".htmlentities($msg["nettoyage_clean_relations_pan3"], ENT_QUOTES, $charset)."
";
$query = mysql_query("delete caddie_content from caddie join caddie_content on (idcaddie=caddie_id and type='BULL') left join bulletins on object_id=bulletin_id where bulletin_id is null");
$affected = mysql_affected_rows();
$query = mysql_query("delete notices_langues from notices_langues left join notices on num_notice=notice_id where notice_id is null");
$affected += mysql_affected_rows();
$query = mysql_query("delete abo_liste_lecture from abo_liste_lecture left join empr on num_empr=id_empr where id_empr is null");
$affected_ll += mysql_affected_rows();
$query = mysql_query("delete abo_liste_lecture from abo_liste_lecture left join opac_liste_lecture on num_liste=id_liste where id_liste is null");
$affected_ll += mysql_affected_rows();
$query = mysql_query("delete opac_liste_lecture from opac_liste_lecture left join empr on num_empr=id_empr where id_empr is null");
$affected_ll += mysql_affected_rows();
$spec = $spec - CLEAN_RELATIONS;
$v_state .= "
".htmlentities($msg["nettoyage_suppr_relations"], ENT_QUOTES, $charset)." : ";
$v_state .= $affected." ".htmlentities($msg["nettoyage_res_suppr_relations_pan3"], ENT_QUOTES, $charset);
$opt = mysql_query('OPTIMIZE TABLE caddie_content');
// mise à jour de l'affichage de la jauge
print "
100%
";
print "
";
