".$msg['admin_nomap_ref_name']." "; // affichage du tableau $requete = "SELECT map_ref_id, map_ref_name FROM map_refs ORDER BY map_ref_name "; $res = pmb_mysql_query($requete, $dbh); $nbr = pmb_mysql_num_rows($res); $parity=1; for($i=0;$i<$nbr;$i++) { $row=pmb_mysql_fetch_object($res); if ($parity % 2) $pair_impair = "even";else $pair_impair = "odd"; $parity += 1; $tr_javascript=" onmouseover=\"this.className='surbrillance'\" onmouseout=\"this.className='$pair_impair'\" onmousedown=\"document.location='./admin.php?categ=notices&sub=map_ref&action=modif&id=$row->map_ref_id';\" "; print "".htmlentities($row->map_ref_name,ENT_QUOTES, $charset).""; print ""; } print " "; } function map_ref_form($nom="", $id=0) { global $msg; global $admin_map_ref_form; global $charset; $admin_map_ref_form = str_replace('!!id!!', $id, $admin_map_ref_form); if(!$id) $admin_map_ref_form = str_replace('!!form_title!!', $msg[admin_noti_map_ref_ajout], $admin_map_ref_form); else $admin_map_ref_form = str_replace('!!form_title!!', $msg[admin_noti_map_ref_modification], $admin_map_ref_form); $admin_map_ref_form = str_replace('!!nom!!', htmlentities($nom,ENT_QUOTES, $charset), $admin_map_ref_form); $admin_map_ref_form = str_replace('!!nom_suppr!!', addslashes($nom), $admin_map_ref_form); print confirmation_delete("./admin.php?categ=notices&sub=map_ref&action=del&id="); print $admin_map_ref_form; } switch($action) { case 'update': if(!empty($form_nom)) { if($id) { $requete = "UPDATE map_refs SET map_ref_name='$form_nom' WHERE map_ref_id='$id' "; $res = pmb_mysql_query($requete, $dbh); } else { $requete = "SELECT count(1) FROM map_refs WHERE map_ref_name='$form_nom' LIMIT 1 "; $res = pmb_mysql_query($requete, $dbh); $nbr = pmb_mysql_result($res, 0, 0); if($nbr == 0){ $requete = "INSERT INTO map_refs (map_ref_name) VALUES ('$form_nom') "; $res = pmb_mysql_query($requete, $dbh); } } } show_map_ref(); break; case 'add': if(empty($form_nom)) map_ref_form(); else show_map_ref(); break; case 'modif': if($id){ $requete = "SELECT map_ref_name FROM map_refs WHERE map_ref_id='$id' "; $res = pmb_mysql_query($requete, $dbh); if(pmb_mysql_num_rows($res)) { $row=pmb_mysql_fetch_object($res); map_ref_form($row->map_ref_name, $id); } else { show_map_ref(); } } else { show_map_ref(); } break; case 'del': if ($id) { $requete = "DELETE FROM map_refs WHERE map_ref_id='$id' "; $res = pmb_mysql_query($requete, $dbh); $requete = "OPTIMIZE TABLE map_refs "; $res = pmb_mysql_query($requete, $dbh); show_map_ref(); } break; default: show_map_ref(); break; }