<?php
include 'config.php';

// Check if the user is logged in

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


$pdid 	= $_GET["pdid"];

$sql3 = "SELECT * FROM project_det_cat WHERE pdid = '".$pdid."' ORDER BY psort ASC ";
$result3 = mysql_query($sql3);			
while ($row3 = mysql_fetch_array($result3,MYSQL_ASSOC)) {
	
	// Delete Product Detail Category
	$sql4 = "DELETE FROM project_det_cat WHERE pdid='". $row3{'pdid'} ."' AND pjcatid='". $row3{'pjcatid'} ."' ";
	mysql_query($sql4);
	if( mysql_errno() > 0 ){
		echo 'Delete Product Detail Category Error:<br />'. mysql_error() .'<br />SQL: '. $sql4;
		exit;
	}	
	// Update Category Sort
	$sql5 = "UPDATE project_det_cat SET psort = psort-1 WHERE psort >=".$row3{'psort'}." AND pjcatid= ". $row3{'pjcatid'} ." ";
	mysql_query($sql5);
	if( mysql_errno() > 0 ){
		echo 'Delete Product Detail Category Sort Error:<br />'. mysql_error() .'<br />SQL: '. $sql5;
		exit;
	}
}

//Delete Project Image
$sql2 = "SELECT * FROM project_img WHERE pdid=". $pdid ." ";
$result2=mysql_query($sql2);
while ($row2 = mysql_fetch_array($result2,MYSQL_ASSOC))
{
unlink("../project/".$row2{'pimgfile'});
unlink("../project/large/".$row2{'gdetphoto'});
unlink("../project/thumb/".$row2{'gdetphoto'});
}

//Delete Product Detail
//$sql = "update project_det set prodadmindelete='1', modifyday='$nowdate', cmsloginid='".$_SESSION['cmsloginid']."' ";
//$sql .= " where pdid = '".$pdid."' ";
$sql = "DELETE FROM project_det WHERE pdid='".$pdid."' ";
mysql_query($sql);
if( mysql_errno() > 0 ){
	echo 'Delete Product Detail Error:<br />'. mysql_error() .'<br />SQL: '. $sql;
	exit;
}


mysql_close($dbh);

header("Location: project_detail_index.php?msg=Delete Successful");

?>