".$msg['notice_usage_libelle']." "; $requete = "SELECT * FROM notice_usage ORDER BY usage_libelle "; $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=notice_usage&action=modif&id_usage=$row->id_usage';\" "; print pmb_bidi("".htmlentities($row->usage_libelle,ENT_QUOTES, $charset).""); } print " "; } function notice_usage_form($id_usage=0, $usage_libelle='') { global $msg; global $admin_notice_usage_form; global $charset; if(!$id_usage){ $admin_notice_usage_form = str_replace('!!form_title!!', $msg['notice_usage_ajout'], $admin_notice_usage_form); $admin_notice_usage_form = str_replace("!!bouton_supprimer!!","",$admin_notice_usage_form) ; } else { $admin_notice_usage_form = str_replace('!!form_title!!', $msg['notice_usage_modification'], $admin_notice_usage_form); $admin_notice_usage_form = str_replace("!!bouton_supprimer!!","",$admin_notice_usage_form) ; } $admin_notice_usage_form = str_replace('!!id_usage!!', $id_usage, $admin_notice_usage_form); $admin_notice_usage_form = str_replace('!!usage_libelle!!', htmlentities($usage_libelle,ENT_QUOTES, $charset), $admin_notice_usage_form); $admin_notice_usage_form = str_replace('!!usage_libelle_suppr!!', addslashes($usage_libelle), $admin_notice_usage_form); print confirmation_delete("./admin.php?categ=notices&sub=notice_usage&action=del&id_usage="); print $admin_notice_usage_form; } switch($action) { case 'update': if(!empty($usage_libelle)) { if($id_usage) { $requete = "UPDATE notice_usage SET usage_libelle='".$usage_libelle."' WHERE id_usage='".$id_usage."' "; $res = pmb_mysql_query($requete, $dbh); } else { $requete = "SELECT count(1) FROM notice_usage WHERE usage_libelle='".$usage_libelle."' LIMIT 1 "; $res = pmb_mysql_query($requete, $dbh); $nbr = pmb_mysql_result($res, 0, 0); if($nbr == 0){ $requete = "INSERT INTO notice_usage (usage_libelle) VALUES ('".$usage_libelle."') "; $res = pmb_mysql_query($requete, $dbh); } } } show_notice_usage($dbh); break; case 'add': notice_usage_form(); break; case 'modif': if($id_usage){ $requete = "SELECT * FROM notice_usage WHERE id_usage='".$id_usage."' "; $res = pmb_mysql_query($requete, $dbh); if(pmb_mysql_num_rows($res)) { $row = pmb_mysql_fetch_object($res); notice_usage_form($row->id_usage,$row->usage_libelle); } else { show_notice_usage($dbh); } } else { show_notice_usage($dbh); } break; case 'del': if ($id_usage) { $total = 0; $total = pmb_mysql_num_rows(pmb_mysql_query("select num_notice_usage from notices where num_notice_usage ='".$id_usage."' ", $dbh)); if ($total==0) { $requete = "DELETE FROM notice_usage WHERE id_usage='".$id_usage."' "; $res = pmb_mysql_query($requete, $dbh); $requete = "OPTIMIZE TABLE notice_usage "; $res = pmb_mysql_query($requete, $dbh); show_notice_usage($dbh); } else { error_message( "", $msg['notice_usage_used'], 1, 'admin.php?categ=notices&sub=notice_usage&action='); } } else { show_notice_usage($dbh); } break; default: show_notice_usage($dbh); break; }