".htmlentities($msg["nettoyage_suppr_collections"], ENT_QUOTES, $charset)."
";
$query = mysql_query("SELECT collection_id from collections left join notices on collection_id=coll_id left join sub_collections on sub_coll_parent=collection_id where coll_id is null and sub_coll_parent is null ");
$affected=0;
if($affected = mysql_num_rows($query)){
while ($ligne = mysql_fetch_object($query)) {
$coll = new collection($ligne->collection_id);
$coll->delete();
}
}
//Nettoyage des informations d'autorités pour les collections
collection::delete_autority_sources();
$query = mysql_query("update notices left join collections ON collection_id=coll_id SET coll_id=0, subcoll_id=0 WHERE collection_id is null");
$spec = $spec - CLEAN_COLLECTIONS;
$v_state .= "
".htmlentities($msg["nettoyage_suppr_collections"], ENT_QUOTES, $charset)." :";
$v_state .= $affected." ".htmlentities($msg["nettoyage_res_suppr_collections"], ENT_QUOTES, $charset);
$opt = mysql_query('OPTIMIZE TABLE collections');
// mise à jour de l'affichage de la jauge
print "
100%
";
print "
";