<?php require "../../require/function.php"; testGenRulesDie("EMPT"); set_time_limit(3600); $sql = "delete from " . __racinebd__ . "log where DATEDIFF(now(),date_evt)> 360"; query($sql); //suppression des vieux noeud $sql = "select * from " . __racinebd__ . "arbre where supprimer=2"; //$sql="select * from arbre where arbre_id>137"; $link = query($sql); while ($tbl_result = fetch($link)) { finaldelete($tbl_result["arbre_id"]); } require "../../include/template_haut.php"; ?> <center><?php echo $trad["Suppression définitive"]; ?> OK</center> <?php require "../../include/template_bas.php";
function finaldelete($arbre_id) { //recherche des fils $sql = "select * from " . __racinebd__ . "arbre where pere=" . $arbre_id; $link = query($sql); while ($tbl_result = fetch($link)) { finaldelete($tbl_result["arbre_id"]); } $sql = "delete from " . __racinebd__ . "groupe_arbre where arbre_id=" . $arbre_id; query($sql); $sql = "delete from " . __racinebd__ . "log where arbre_id=" . $arbre_id; query($sql); $sql = "select * from " . __racinebd__ . "contenu c inner join " . __racinebd__ . "content c1 on c1.contenu_id=c.contenu_id where arbre_id=" . $arbre_id; $link2 = query($sql); while ($tbl_result2 = fetch($link2)) { $sql = "delete from " . __racinebd__ . "fichiers where content_id=" . $tbl_result2["content_id"]; query($sql); $sql = "delete from " . __racinebd__ . "tag_content where content_id=" . $tbl_result2["content_id"]; query($sql); $sql = "delete from " . __racinebd__ . "tag_search_content where content_id=" . $tbl_result2["content_id"]; query($sql); $sql = "delete from " . __racinebd__ . "content where content_id=" . $tbl_result2["content_id"]; query($sql); } $sql = "delete from " . __racinebd__ . "contenu where arbre_id=" . $arbre_id; query($sql); $sql = "delete from " . __racinebd__ . "arbre where arbre_id=" . $arbre_id; query($sql); $sql = "select max(arbre_id)as max from " . __racinebd__ . "arbre"; $link = query($sql); $tbl_result = fetch($link); $sql = "ALTER TABLE " . __racinebd__ . "arbre AUTO_INCREMENT = " . ($tbl_result["max"] + 1); query($sql); $sql = "select max(log_id)as max from " . __racinebd__ . "log"; $link = query($sql); $tbl_result = fetch($link); $sql = "ALTER TABLE " . __racinebd__ . "log AUTO_INCREMENT = " . ($tbl_result["max"] + 1); query($sql); $sql = "select max(contenu_id)as max from " . __racinebd__ . "contenu"; $link = query($sql); $tbl_result = fetch($link); $sql = "ALTER TABLE " . __racinebd__ . "contenu AUTO_INCREMENT = " . ($tbl_result["max"] + 1); query($sql); $sql = "select max(content_id)as max from " . __racinebd__ . "content"; $link = query($sql); $tbl_result = fetch($link); $sql = "ALTER TABLE " . __racinebd__ . "content AUTO_INCREMENT = " . ($tbl_result["max"] + 1); query($sql); $sql = "select max(fichiers_id)as max from " . __racinebd__ . "fichiers"; $link = query($sql); $tbl_result = fetch($link); $sql = "ALTER TABLE " . __racinebd__ . "fichiers AUTO_INCREMENT = " . ($tbl_result["max"] + 1); query($sql); }