if (!$count) { $notices = pmb_mysql_query("SELECT count(1) FROM notices", $dbh); $count = pmb_mysql_result($notices, 0, 0); } print "<br /><br /><h2 align='center'>" . htmlentities($msg["nettoyage_clean_tags"], ENT_QUOTES, $charset) . "</h2>"; $query = pmb_mysql_query("SELECT notice_id FROM notices LIMIT {$start}, {$lot}"); if (pmb_mysql_num_rows($query)) { // définition de l'état de la jauge $state = floor($start / ($count / $jauge_size)); // mise à jour de l'affichage de la jauge print "<table border='0' align='center' width='{$jauge_size}' cellpadding='0' border='0'><tr><td class='jauge'>"; print "<img src='../../images/jauge.png' width='{$state}' height='16'></td></tr></table>"; // calcul pourcentage avancement $percent = floor($start / $count * 100); // affichage du % d'avancement et de l'état print "<div align='center'>{$percent}%</div>"; while ($row = pmb_mysql_fetch_row($query)) { notice::majNotices_clean_tags($row[0]); } pmb_mysql_free_result($query); $next = $start + $lot; print "\n\t<form class='form-{$current_module}' name='current_state' action='./clean.php' method='post'>\n\t\t<input type='hidden' name='v_state' value=\"" . urlencode($v_state) . "\">\n\t\t<input type='hidden' name='spec' value=\"{$spec}\">\n\t\t<input type='hidden' name='start' value=\"{$next}\">\n\t\t<input type='hidden' name='count' value=\"{$count}\">\n\t</form>\n\t<script type=\"text/javascript\">\n\t<!--\n\t\tdocument.forms['current_state'].submit();\n\t-->\n\t</script>"; } else { $spec = $spec - NETTOYAGE_CLEAN_TAGS; $v_state .= "<br /><img src=../../images/d.gif hspace=3>" . htmlentities($msg["nettoyage_clean_tags_status"], ENT_QUOTES, $charset); $v_state .= $count . " " . htmlentities($msg["nettoyage_clean_tags_status_end"], ENT_QUOTES, $charset); $opt = pmb_mysql_query('OPTIMIZE TABLE notices'); // mise à jour de l'affichage de la jauge print "\n\t<table border='0' align='center' width='{$table_size}' cellpadding='0'><tr><td class='jauge'>\n\t<img src='../../images/jauge.png' width='{$jauge_size}' height='16'></td></tr></table>\n\t<div align='center'>100%</div>"; print "\n\t<form class='form-{$current_module}' name='process_state' action='./clean.php' method='post'>\n\t\t<input type='hidden' name='v_state' value=\"" . urlencode($v_state) . "\">\n\t\t<input type='hidden' name='spec' value=\"{$spec}\">\n\t</form>\n\t<script type=\"text/javascript\">\n\t<!--\n\t\tdocument.forms['process_state'].submit();\n\t-->\n\t</script>"; }
function nettoyageCleanTags() { global $msg, $dbh, $charset, $PMBusername; if (SESSrights & ADMINISTRATION_AUTH) { $result .= "<h3>" . htmlentities($msg["nettoyage_clean_tags"], ENT_QUOTES, $charset) . "</h3>"; $query = mysql_query("SELECT notice_id FROM notices"); if (mysql_num_rows($query)) { while ($row = mysql_fetch_row($query)) { notice::majNotices_clean_tags($row[0]); } mysql_free_result($query); } $notices = mysql_query("SELECT count(1) FROM notices", $dbh); $count = mysql_result($notices, 0, 0); $result .= $count . " " . htmlentities($msg["nettoyage_clean_tags_status_end"], ENT_QUOTES, $charset); $opt = mysql_query('OPTIMIZE TABLE notices'); } else { $result .= sprintf($msg["planificateur_rights_bad_user_rights"], $PMBusername); } return $result; }
static function majNotices($notice) { global $pmb_keyword_sep; if ($notice) { $query = pmb_mysql_query("SELECT notice_id,tparent_id,tit1,tit2,tit3,tit4,index_l, n_gen, n_contenu, n_resume, tnvol, indexation_lang FROM notices WHERE notice_id='" . $notice . "'"); if (pmb_mysql_num_rows($query)) { //Nettoyage des mots clès notice::majNotices_clean_tags($notice, false); $row = pmb_mysql_fetch_object($query); // titre de série if ($row->tparent_id) { $tserie = new serie($row->tparent_id); $ind_serie = ' ' . strip_empty_words($tserie->name) . ' '; } else { $ind_serie = ''; } $ind_wew = $ind_serie . " " . $row->tnvol . " " . $row->tit1 . " " . $row->tit2 . " " . $row->tit3 . " " . $row->tit4; $ind_sew = strip_empty_words($ind_wew); $row->index_l ? $ind_matieres = ' ' . strip_empty_words(str_replace($pmb_keyword_sep, " ", $row->index_l)) . ' ' : ($ind_matieres = ''); $row->n_gen ? $ind_n_gen = ' ' . strip_empty_words($row->n_gen) . ' ' : ($ind_n_gen = ''); $row->n_contenu ? $ind_n_contenu = ' ' . strip_empty_words($row->n_contenu) . ' ' : ($ind_n_contenu = ''); $row->n_resume ? $ind_n_resume = ' ' . strip_empty_words($row->n_resume) . ' ' : ($ind_n_resume = ''); $req_update = "UPDATE notices"; $req_update .= " SET index_wew='" . addslashes($ind_wew) . "'"; $req_update .= ", index_sew=' " . addslashes($ind_sew) . " '"; $req_update .= ", index_serie='" . addslashes($ind_serie) . "'"; $req_update .= ", index_n_gen='" . addslashes($ind_n_gen) . "'"; $req_update .= ", index_n_contenu='" . addslashes($ind_n_contenu) . "'"; $req_update .= ", index_n_resume='" . addslashes($ind_n_resume) . "'"; $req_update .= ", index_matieres='" . addslashes($ind_matieres) . "'"; $req_update .= " WHERE notice_id={$row->notice_id} "; $update = pmb_mysql_query($req_update); pmb_mysql_free_result($query); } } }