コード例 #1
0
ファイル: index.php プロジェクト: jcmwc/fleet
<?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";
コード例 #2
0
ファイル: function_arbre.php プロジェクト: jcmwc/fleet
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);
}