".htmlentities($msg["nettoyage_suppr_subcollections"], ENT_QUOTES, $charset)."
";
$query = pmb_mysql_query("SELECT sub_coll_id from sub_collections left join notices on sub_coll_id=subcoll_id where subcoll_id is null ");
$affected=0;
if($affected = pmb_mysql_num_rows($query)){
while ($ligne = pmb_mysql_fetch_object($query)) {
$subcoll = new subcollection($ligne->sub_coll_id);
$subcoll->delete();
}
}
//Nettoyage des informations d'autorités pour les sous collections
subcollection::delete_autority_sources();
$query = pmb_mysql_query("update notices left join sub_collections ON sub_coll_id=subcoll_id SET subcoll_id=0 WHERE sub_coll_id is null");
$spec = $spec - CLEAN_SUBCOLLECTIONS;
$v_state .= "
![](".get_url_icon()
".htmlentities($msg["nettoyage_suppr_subcollections"], ENT_QUOTES, $charset)." : ";
$v_state .= $affected." ".htmlentities($msg["nettoyage_res_suppr_subcollections"], ENT_QUOTES, $charset);
$opt = pmb_mysql_query('OPTIMIZE TABLE sub_collections');
// mise à jour de l'affichage de la jauge
print netbase::get_display_final_progress();
print "
";