<?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 product_cat_item 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 product_cat_item WHERE pdid='". $row3{'pdid'} ."' AND pdcatid='". $row3{'pdcatid'} ."' ";
	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 product_cat_item SET psort = psort-1 WHERE psort >=".$row3{'psort'}." AND pdcatid= ". $row3{'pdcatid'} ." ";
	mysql_query($sql5);
	if( mysql_errno() > 0 ){
		echo 'Delete Product Detail Category Sort Error:<br />'. mysql_error() .'<br />SQL: '. $sql5;
		exit;
	}
}

//Delete Product Image
$sql2 = "SELECT * FROM product_image WHERE pdid=". $pdid ." ";
$result2=mysql_query($sql2);
while ($row2 = mysql_fetch_array($result2,MYSQL_ASSOC))
{
unlink("../images/product/large/".$row2{'pimgfile'});
unlink("../images/product/mid/".$row2{'pimgfile'});
unlink("../images/product/thumb/".$row2{'pimgfile'});
}
$sql6 = "DELETE FROM product_image WHERE pdid='". $pdid ."' ";
mysql_query($sql6);


//Delete Product Detail
$sql4 = "SELECT * FROM product_detail WHERE pdid=". $pdid ." ";
$result4=mysql_query($sql4);
while ($row4 = mysql_fetch_array($result4,MYSQL_ASSOC))
{
unlink("../product/catalogue/".$row4{'pdcatalogueen'});
}

	//delete material logo
	$sql5 = "SELECT * FROM product_material_logo WHERE pdid = '".$pdid."' ";
	$result5 = mysql_query($sql5);
	while ($row5 = mysql_fetch_array($result5,MYSQL_ASSOC)) {

		// Delete Product Detail Category
		$sql4 = "DELETE FROM product_material_logo WHERE pdid='". $row5{'pdid'} ."' ";
		mysql_query($sql5);

		if( mysql_errno() > 0 ){
			echo 'Delete Product Materail Logo Error:<br />'. mysql_error() .'<br />SQL: '. $sql5;
			exit;
		}
	}


$sql = "DELETE FROM product_detail 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: product_detail_index.php?msg=Delete Successful");

?>