".htmlentities($msg["nettoyage_clean_relations_cat"], ENT_QUOTES, $charset)."

"; $query = mysql_query("delete from notices_custom_values where notices_custom_champ not in (select idchamp from notices_custom)"); $affected = mysql_affected_rows(); $query = mysql_query("delete from expl_custom_values where expl_custom_champ not in (select idchamp from expl_custom)"); $affected = mysql_affected_rows(); $query = mysql_query("DELETE empr_custom_values FROM empr_custom_values LEFT JOIN empr ON id_empr=empr_custom_origine WHERE id_empr IS NULL "); $affected = mysql_affected_rows(); $query = mysql_query("delete from empr_custom_values where empr_custom_champ not in (select idchamp from empr_custom)"); $affected = mysql_affected_rows(); $v_state .= "
".htmlentities($msg["nettoyage_suppr_relations"], ENT_QUOTES, $charset)." : "; $v_state .= $affected." ".htmlentities($msg["nettoyage_res_suppr_relations_cat"], ENT_QUOTES, $charset); $opt = mysql_query('OPTIMIZE TABLE notices_categories'); // mise à jour de l'affichage de la jauge print "
100%
"; print "
";