".htmlentities($msg["nettoyage_suppr_editeurs"], ENT_QUOTES, $charset)."
";
// creation table tempo contenant les id des publishers utilisés
$query = mysql_query("create temporary table tmppub as select distinct ed1_id as edid from notices where ed1_id!=0 union select distinct ed2_id as edid from notices where ed2_id!=0");
$query = mysql_query("alter table tmppub add index (edid)");
// supp des pub non utilisés dans les collections, sous-collections et notices !
$query = mysql_query("delete publishers from publishers left join tmppub on ed_id=edid left join collections on ed_id=collection_parent left join sub_collections on collection_id=sub_coll_parent where sub_coll_parent is null and collection_parent is null and edid is null ");
$affected = mysql_affected_rows();
$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 "
";
