".htmlentities($msg["nettoyage_suppr_editeurs"], ENT_QUOTES, $charset)."

"; $requete="SELECT DISTINCT ed_id FROM publishers LEFT JOIN notices n1 ON n1.ed1_id=ed_id LEFT JOIN notices n2 ON n2.ed2_id=ed_id LEFT JOIN collections ON ed_id=collection_parent WHERE n1.notice_id IS NULL AND n2.notice_id IS NULL AND collection_id IS NULL"; $res=mysql_query($requete); $affected=0; if($affected = mysql_num_rows($res)){ while ($ligne = mysql_fetch_object($res)) { $editeur = new editeur($ligne->ed_id); $editeur->delete(); } } $spec = $spec - CLEAN_PUBLISHERS; $v_state .= "
".htmlentities($msg["nettoyage_suppr_editeurs"], ENT_QUOTES, $charset)." : "; $v_state .= $affected." ".htmlentities($msg["nettoyage_res_suppr_editeurs"], ENT_QUOTES, $charset); $opt = mysql_query('OPTIMIZE TABLE publishers'); // mise à jour de l'affichage de la jauge print "
100%
"; print "
";