".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=pmb_mysql_query($requete); $affected=0; if($affected = pmb_mysql_num_rows($res)){ while ($ligne = pmb_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 = pmb_mysql_query('OPTIMIZE TABLE publishers'); // mise à jour de l'affichage de la jauge print netbase::get_display_final_progress(); print netbase::get_process_state_form($v_state, $spec);