".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 "
";