<?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");

?>