1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75

<?php
include 'config.php';

// Check if the user is logged in

if ((!isSet($_SESSION['loginname'])) || ($loggin <> '1'))
{
header("Location: login.php");
exit;
}
?>
<?php
require("configure.php");

$projectscaseid     = $_GET["projectscaseid"];
$parentid             = $_GET["parentid"];
$projectscasesort     = $_GET["projectscasesort"];

//Delete Category image & Detail image
$result2= mysql_query("SELECT * FROM projects_case WHERE projectscaseid=".$projectscaseid." ");
$row2= mysql_fetch_array($result2,MYSQL_ASSOC);
if ( $row2['projectscaseimage'] <> '') {
    unlink("../images/project/".$row2['projectscaseimage']);
}
$result3= mysql_query("SELECT * FROM projects_detail WHERE parentid=".$row2['projectscaseid']." ");
while ($row3= mysql_fetch_array($result3,MYSQL_ASSOC)){
    if($row3['projectsdetimage'] <> ''){
        unlink("../images/project/large/".$row3['projectsdetimage']);
        unlink("../images/project/thumb/".$row3['projectsdetimage']);
    }
}


//Get Category function
function getAllCategoryID($pid){                
    $rtnString = "";
    $sqlCmd = " SELECT projectscaseid FROM projects_case WHERE parentid=".$pid." ";
    $result = mysql_query($sqlCmd);
    if (mysql_num_rows( $result)>0 && mysql_num_rows($result) >0)
    {                   
       while($row = mysql_fetch_array($result, MYSQL_ASSOC))
       {
                 $rtnString .= $row{'projectscaseid'} .",".  getAllCategoryID($row{'projectscaseid'});                 
                 
       }
    }
    return $rtnString;                                     
}
// Delete Category Detail
$sql2 = "DELETE FROM projects_detail ";
$sql2 .= "where parentid in (".substr($projectscaseid.','.getAllCategoryID($projectscaseid),0, -1).")";
mysql_query($sql2);
if( mysql_errno() > 0 ){
    echo 'Delete projects_ Detail Error:<br />'. mysql_error() .'<br />SQL: '. $sql2;
    exit;
}


//Delete Category
$sql1 = "DELETE FROM projects_case ";
$sql1 .= "where projectscaseid in (".substr($projectscaseid.','.getAllCategoryID($projectscaseid),0, -1).")";
mysql_query($sql1);
if( mysql_errno() > 0 ){
    echo 'Delete projects Category Error:<br />'. mysql_error() .'<br />SQL: '. $sql1;
    exit;
}

// Update Category Sort
mysql_query("UPDATE projects_case SET projectscasesort = projectscasesort-1 WHERE parentid=". $parentid ." AND projectscasesort >= $projectscasesort");

mysql_close($dbh);

header("Location: projects_case_index.php?pid=$parentid&msg=Delete Successful");

?>