<?
include_once('inc/config.php');
checklanguage();
$datatab=array("ov"=>"Overview","sp"=>"Specifications","do"=>"Download","ga"=>"Gallery");
require_once("xajax6/xajax_core/xajax.inc.php");
$xajax = new xajax();
$xajax->configure('javascript URI', 'xajax6/');
$xajax->register(XAJAX_FUNCTION, "changessdcomparison");
$xajax->register(XAJAX_FUNCTION, "ssdcomparisonshow");
$xajax->register(XAJAX_FUNCTION, "clearssdcomparison");
	
$xajax->processRequest();
function changessdcomparison($ssdpro_spec_id){
	$objResponse = new xajaxResponse();
	if($_SESSION['ssdcomparison'][$ssdpro_spec_id])
	{
		unset($_SESSION['ssdcomparison'][$ssdpro_spec_id]);
	}else
	{
		$_SESSION['ssdcomparison'][$ssdpro_spec_id]=$ssdpro_spec_id;
	}
	//$objResponse->script('alert("this ssdpro_spec_id is '.$ssdpro_spec_id.'")');
	$objResponse->script('xajax_ssdcomparisonshow()');
	return $objResponse;
}

function ssdcomparisonshow(){
	$objResponse = new xajaxResponse();
	if($_SESSION['ssdcomparison'])
	{
		$objResponse->assign("ssdcomparisontd","innerHTML", '<span class="circle">'.count($_SESSION['ssdcomparison']).'</span>');
		$objResponse->script('$("#rightmediaicon").css("display","block");');
	}else
	{
		$objResponse->script('$("#rightmediaicon").css("display","none");');
	}
	
	return $objResponse;
}

function clearssdcomparison(){
	$objResponse = new xajaxResponse();
	unset($_SESSION['ssdcomparison']);
	$objResponse->script('$("#rightmediaicon").css("display","none");');
	$objResponse->script('$("input[type=\"checkbox\"]").prop("checked", false);');
	return $objResponse;
}

function Retrieve_ssdpro(){
    global $getpost;
	$ssdspecitemdata=get_ssdspecitem();
	$record=array();
	$pro_spec=array();
	$pro_icon=array();
	if($getpost[id])
	{
		$langshowid="and (langshow='all' or langshow LIKE '%:".$_SESSION['languageid'].":%')";
		$timelimit=" and enable=1 and publish <= SYSDATE() and (unpublish ='0000-00-00 00:00:00' or unpublish > SYSDATE())";
		if($getpost[preview])
		{
			$timelimit='';
		}
		$sql = "SELECT * FROM ssdpro WHERE id=$getpost[id]$timelimit $langshowid ORDER BY od asc";
		// 傳回查詢結果
		if($result = mysql_query($sql))
		{
			if($record = mysql_fetch_assoc($result))
			{
				if($record[upid]>0)
				{
					$language=Retrieve_language($record[language]);
					$record[changetourl]='ssdpro.php?id='.$record[upid].'&lang='.$language['abbreviator'];
				}else
				{
					$prospecdata=get_pro_specitemdata($ssdspecitemdata,$record);
					$record['spec']=$prospecdata['spec'];
					$record['icon']=$prospecdata['icon'];
					if($_SESSION['languageid']!=$record[language])
					{
						$sql = "SELECT * FROM ssdpro WHERE upid=$getpost[id] and language=".$_SESSION['languageid'];
						if($result = mysql_query($sql))
						{
							if($recordother = mysql_fetch_assoc($result))
							{
								if($recordother[description]) $record[description]=$recordother[description];
							}
						}
					}
				}
				//$record[title]=changekeyword($record[title]);
				//$record[description]=changekeyword($record[description]);
				if($pro_pic=Retrieve_ssdpro_pic($record[id]))
				{
				   $record['bigimage']=$pro_pic;
				}
			}
			
		}
	}
    if($record)
	{
		return $record;	 
	}else
	{
		return false;
	}
}

function Retrieve_ssdpc($id)
{
	global $getpost;
    $langshowid="and (langshow='all' or langshow LIKE '%:".$_SESSION['languageid'].":%')";
	$timelimit=" and enable=1";
	if($getpost[preview])
	{
		$timelimit='';
	}
	$sql = "SELECT * FROM ssdpc WHERE id=$id $timelimit $langshowid ORDER BY od asc";
	
	// 傳回查詢結果
    if($result = mysql_query($sql))
	{
		if($record = mysql_fetch_assoc($result))
		{
			if($_SESSION['languageid']!=$record[language])
			{
				$sql = "SELECT * FROM ssdpc WHERE mainid=$record[id] and language=".$_SESSION['languageid'];
				if($result = mysql_query($sql))
				{
					if($recordother = mysql_fetch_assoc($result))
					{
						$record[title]=$recordother[title];
						$record[pic]=$recordother[pic];
						$record[downid]=$recordother[id];
					}
				}
			}
			//$record[title]=changekeyword($record[title]);
		}
     	return $record;
	}else
	{
		header('refresh:0 ; url= index.php?lang='.$_SESSION["lang"]);
		exit;
	}
}

function get_other_ssdprofeature($upid){
     // 定義 SQL 命令的字串變數
     $sql = "SELECT * FROM ssdprofeature WHERE upid=$upid and language=".$_SESSION['languageid'];
     // 傳回查詢結果
     $result = mysql_query($sql);
     if(!$result) die ('Can not select table: '.$sql);
     $record = mysql_fetch_assoc($result);
     return $record;
}


function Retrieve_ssdpro_feature($id)
{
	$recordset = array();
    // 定義 SQL 命令的字串變數
    $sql = "SELECT ssdprofeature.* FROM  ssdpro_product_feature left join ssdprofeature on ssdpro_product_feature.ssdprofeature_id=ssdprofeature.id WHERE ssdpro_product_feature.ssdpro_id=$id and enable=1 and (langshow='all' or langshow LIKE '%:".$_SESSION['languageid'].":%') ORDER BY od asc";
    // 傳回查詢結果
	$result = mysql_query($sql);
    if(!$result) die ('Can not select table: '.$sql);
    while($record = mysql_fetch_assoc($result)){
         if($record[icon])
		 {
			 $record[icon]="i".sprintf("%05d",$record[id])."/".$record[icon];
		 }
		 if($otherdata=get_other_ssdprofeature($record[id]))
		 {
			 if($otherdata[content])
			 {
				 $record[content]=$otherdata[content];
			 }
			 if($otherdata[url])
			 {
				 $record[url]=$otherdata[url];
			 }
			 if($otherdata[icon])
			 {
				 $record[icon]="i".sprintf("%05d",$otherdata[id])."/".$otherdata[icon];
			 }
		 }
		 $recordset[]=$record;
    }
    return $recordset;
}

function Retrieve_ssdpro_pic($id)
{
	$recordset = array();
    // 定義 SQL 命令的字串變數
    $sql = "SELECT * FROM ssdpro_pic WHERE p_id=$id ORDER BY od asc";
    // 傳回查詢結果
	$result = mysql_query($sql);
    if(!$result) die ('Can not select table: '.$sql);
    while($record = mysql_fetch_assoc($result)){
         array_push($recordset, $record);
    }
    return $recordset;
}

function get_pro_award($id)
{
	$data=array();
	if($id&&(!preg_match("/[^0-9]/",$id)))
	{
		$sql = "select * FROM award_review WHERE proid=$id and pcate='ssd' ORDER BY dateyear desc, datemonth desc, id desc";
		$result = mysql_query($sql);
		if(!$result) die ('Error: '.$sql);
		while($record = mysql_fetch_assoc($result))
		{
			$data[]=$record;
		}	
	}
	return $data;
}


function get_dcate(){
	// 宣告一個陣列變數 $recordset, 存放查詢所得的紀錄集
    $recordset = array();
    // 定義 SQL 命令的字串變數
    $sql = "SELECT * FROM dcate ORDER BY od asc";
	// 傳回查詢結果
    $result = mysql_query($sql);
    if(!$result) die ('Can not select table: '.$sql);
	while($record = mysql_fetch_assoc($result)){
    	array_push($recordset, $record);
    }
    return $recordset;
}

function get_download($dcate_id){
	if($dcate_id&&(!preg_match("/[^0-9]/",$dcate_id)))
	{
		$recordset = array();
		$sql = "SELECT * FROM download WHERE dcate_id=$dcate_id ORDER BY description asc, lastupdate desc, id desc";
		$result = mysql_query($sql);
		if(!$result) die ('Error: '.$sql);
		while($record = mysql_fetch_assoc($result)){
			 array_push($recordset, $record);
		}	
	}
	
    return $recordset;
}

function is_in_package($p_id,$d_id){
    // 定義 SQL 命令的字串變數
    $sql = "SELECT count(*) as nt FROM packageofdownload WHERE p_id=$p_id AND d_id=$d_id";
    // 執行查詢
    $result = mysql_query($sql);
    if(!$result) die('Error');
	$data=mysql_fetch_assoc($result);
	if($data[nt]>0)
	{
		return true;
	}else
	{
	 	return false;
	}
}

function get_package_list($pro)
{
	$data=array();
	if($package_id=$pro[package_id])
	{
		if($dcatedata=get_dcate())
		{
			foreach($dcatedata as $dcate)
			{
				if($downloaddata=get_download($dcate[id]))
				{
					$download=array();
					foreach($downloaddata as $filelink)
					{
						if(is_in_package($package_id,$filelink[id])||(($filelink[procate]=='ssd')&&($filelink[filemode]=='mdf')&&preg_match('/:'.$id.':/',$filelink[mdfpro])))
						{
							if($description=Retrieve_download_language($filelink[id]))
							{
								$filelink[description]=$description[title];
							}else
							{
								$filelink[description]=show_interface("Text",$filelink[description]);
							}
							$download[]=$filelink;
						}
					}
					if($download)
					{
						if($d_name=Retrieve_dcate_language($dcate[id]))
						{
							$dcate[d_name]=$d_name[title];
						}
						$data[$dcate[d_name]]=$download;
					}
				}
			}
		}		
	}
	return $data;
}

function Retrieve_dcate_language($id){
	if($id&&(!preg_match("/[^0-9]/",$id)))
	{
		// 定義 SQL 命令的字串變數
		 $sql = "SELECT * FROM dcate_language WHERE id=$id and language=".$_SESSION['languageid'];
		 // 執行查詢
		 $result = mysql_query($sql);
		 if(!$result) die('Error: '.$sql);
		 return mysql_fetch_assoc($result);	
	}
}

function Retrieve_download_language($id){
    if($id&&(!preg_match("/[^0-9]/",$id)))
	{
		 // 定義 SQL 命令的字串變數
		 $sql = "SELECT * FROM download_language WHERE id=$id and language=".$_SESSION['languageid'];
		 // 執行查詢
		 $result = mysql_query($sql);
		 if(!$result) die('Error: '.$sql);
		 return mysql_fetch_assoc($result);	
	}
}

if(empty($getpost[tab])||empty($datatab[$getpost[tab]]))
{
	$getpost[tab]="ov";
}

if($prodata=Retrieve_ssdpro())
{
	if($prodata[changetourl])
	{
		header('Location:'.$prodata[changetourl]);
		exit;
	}
	
	$sub=Retrieve_ssdpc($prodata[ssdpc_id]);
	$main=Retrieve_ssdpc($sub[upid]);
	$downloaddata=get_package_list($prodata);
}else
{
	header('refresh:0 ; url= index.php?lang='.$_SESSION["lang"]);
	exit;
}

$webtitl="::Palit Products - ".strip_tags($prodata[title])." ::";
$webdescription=strip_tags($prodata[description]);
$webfbimage="http://www.palit.com/product/ssd/picture/s".sprintf("%05d",$prodata[id])."/".$prodata[propng];
?>
<!DOCTYPE html>
<html>
<head>
<? include_once('inc/meta.php'); ?>