".htmlentities($msg["nettoyage_suppr_collections"], ENT_QUOTES, $charset)."
";
$query = pmb_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 = pmb_mysql_num_rows($query)){
while ($ligne = pmb_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 = pmb_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 .= "
![](".get_url_icon()
".htmlentities($msg["nettoyage_suppr_collections"], ENT_QUOTES, $charset)." :";
$v_state .= $affected." ".htmlentities($msg["nettoyage_res_suppr_collections"], ENT_QUOTES, $charset);
$opt = pmb_mysql_query('OPTIMIZE TABLE collections');
// mise à jour de l'affichage de la jauge
print netbase::get_display_final_progress();
print netbase::get_process_state_form($v_state, $spec);