<?
require_once "./global.php";

if(empty($_GET[id]) && empty($_GET[itemid])) {
	redirect("catelist.php");
	exit;
}

$highrate = count_rate();
if($highrate==0) {
	if(isset($_GET[id])) { 
		$db->query("UPDATE product SET view=view+1 WHERE id='".intval($_GET[id])."'");
	} else if(isset($_GET[itemid])) {
		$db->query("UPDATE product SET view=view+1 WHERE goodsid='".addslashes($_GET[itemid])."'");
	}
}

#####Module: Cache Product
if($is_cache_product) {
	if(isset($_GET[id]) || isset($_GET[itemid])) {
		$qry = $_GET[id]?"id='".intval($_GET[id])."'":"goodsid='".addslashes($_GET[itemid])."'";
		$qry = "SELECT id,cateid,addtime FROM product WHERE ".$qry;
		$id = $db->get_var($qry,0,0);
		$cateid = $db->get_var(null,1,0);
		$addtime = $db->get_var(null,2,0);

		$cachefile = './items/'.$cateid.'/'.$id.','.$addtime.'.htm';
		if(file_exists($cachefile)) {
			header("Location: $cachefile");
			@chmod($dir,0777);
			exit;
		}
	}
}
#####

if(isset($_GET[id])) $qry="SELECT * FROM product WHERE id='".intval($_GET[id])."'";
if(isset($_GET[itemid])) $qry="SELECT * FROM product WHERE goodsid='".addslashes($_GET[itemid])."'";

$product=$db->get_results($qry,ARRAY_A);
$product=$product[0];

if(empty($product)) err_exit("Sorry,this product does not exist!");

$catesnav=catenav($product[cateid]);
$product[addtime0]=$product[addtime];
$product[addtime]=date("m/d/Y",$product[addtime]);
$product[istop]=$product[istop]=="y"?"<font color=red>recommended</font>":"";
//if($product[image]) resizeimg($product_img_dir.$product[image],$thumb_dir.$product[image],100,100);
$saveprice=number_format(($product[retailcost]-$product[tradeprice]), 2, '.', '');;
if(empty($product[image])) $product[image]="noimage.jpg";

$tpl->assign("p",$product);
$tpl->assign("catesnav",$catesnav);
$tpl->assign("saveprice",$saveprice);
unset($catesnav,$saveprice);


###############
//Newest Products List Data
$qry="SELECT id,name,addtime,image,tradeprice FROM product  ORDER BY addtime DESC LIMIT 0,10";
$id=$db->get_col($qry,0);
$name=$db->get_col(null,1);
$addtime=$db->get_col(null,2);
$image=$db->get_col(null,3);
$tradeprice=$db->get_col(null,4);

if(is_array($comments)) foreach($comments as $key=>$result) $comments[$key]=substr($result,0,30);
if(is_array($addtime)) foreach($addtime as $key=>$result) $addtime[$key]=date("m/d/Y",$result);
if(is_array($image)) foreach($image as $key=>$result) {
	if($result) resizeimg($product_img_dir.$result,$thumb_dir.$result,75,75);
}

$tpl->assign("N_product_id",$id);
$tpl->assign("N_product_name",$name);
$tpl->assign("N_addtime",$addtime);
$tpl->assign("N_product_image",$image);
$tpl->assign("N_tradeprice",$tradeprice);

unset($id,$cateid,$name,$comments,$addtime,$image,$tradeprice,$result);

##############

//Other
//Right Column Data :specials & Adcolumn
//0:index page;(1:All pages);2:Category Page;3:Product Page;4:Other Pages
right_col(3);

/*
$tpl_vars = $tpl->get_template_vars();
print_rr($tpl_vars);
*/
$output=$tpl->fetch("show_product_,ahp2004.htm");
$output=str_replace($tpl_imgdir_name, $tpl->template_dir.$tpl_imgdir_name,$output);

####Module: If output cache product
if($is_cache_product) {
	$dir = "./items/$product[cateid]";
	if(!is_dir($dir)) {
		@mkdir($dir,0777);
		@chmod($dir,0777);
	}

	$cachefile = $dir.'/'.$product[id].','.$product[addtime0].'.htm';
	$handle = @fopen($cachefile,'w');
	@fwrite($handle,$output);
	@chmod($cachefile,0755);
}
####

echo $output;
echo $cachefile;
?>