<?php
class Main{
	
	public function selectProduct_I($value){
		if($value==null){ $m="WHERE shows=1";}
		if($value!=null){$m="WHERE id='".$value."' AND shows=1";}
		$sql = mysql_query("SELECT * FROM product_i $m ORDER BY sort ASC") or die ("ERROR");
		$Level1Array = array();
		while($rs = mysql_fetch_array($sql)){
			array_push($Level1Array,$rs);
		}
		return $Level1Array;
	}

	public function selectProduct_II($value,$value2){
		if($value==null && $value2==null){ $m="WHERE shows=1";}
		elseif($value!=null){$m="WHERE Lid='".$value."' AND shows=1";}
		elseif($value==null && $value2!=null){ $m="WHERE id='".$value2."' AND shows=1";}
		$sql = mysql_query("SELECT * FROM product_ii $m ORDER BY sort ASC") or die ("ERROR");
		$Level2Array = array();
		while($rs = mysql_fetch_array($sql)){
			array_push($Level2Array,$rs);
		}
		return $Level2Array;
	}

	public function selectProducts_II($value,$value2){
		if($value==null && $value2==null){ $m="WHERE product_ii.shows=1";}
		elseif($value!=null){$m="WHERE product_ii.Lid='".$value."' AND product_ii.shows=1 AND product_iii.shows=1";}
		elseif($value==null && $value2!=null){ $m="WHERE product_ii.id='".$value2."' AND product_ii.shows=1";}
		$sql = mysql_query("SELECT Gid,product_iii.id ID3,product_ii.nameth AS name2th,product_ii.nameen AS name2en,product_ii.detailth,product_ii.detailen FROM product_iv INNER JOIN product_iii ON product_iv.Lid=product_iii.id INNER JOIN product_ii ON product_ii.id=product_iii.Lid $m GROUP BY ID3 ORDER BY product_ii.sort ASC,product_iii.sort ASC") or die ("ERROR");
		$Level2sArray = array();
		while($rs = mysql_fetch_array($sql)){
			array_push($Level2sArray,$rs);
		}
		return $Level2sArray;
	}

	public function selectProduct_III($value,$value2){
		if($value==null && $value2==null){ $m="WHERE shows=1";}
		elseif($value!=null){$m="WHERE Lid='".$value."' AND shows=1";}
		elseif($value==null && $value2!=null){ $m="WHERE id='".$value2."' AND shows=1";}
		$sql = mysql_query("SELECT * FROM product_iii $m ORDER BY sort ASC") or die ("ERROR");
		$Level3Array = array();
		while($rs = mysql_fetch_array($sql)){
			array_push($Level3Array,$rs);
		}
		return $Level3Array;
	}

	public function selectProduct_IV($value,$value2){
		if($value==null && $value2==null){ $m="WHERE shows=1";}
		elseif($value!=null){$m="WHERE Lid='".$value."' AND shows=1";}
		elseif($value==null && $value2!=null){ $m="WHERE id='".$value2."' AND shows=1";}
		$sql = mysql_query("SELECT * FROM product_iv $m ORDER BY sort ASC") or die ("ERROR");
		$Level4Array = array();
		while($rs = mysql_fetch_array($sql)){
			array_push($Level4Array,$rs);
		}
		return $Level4Array;
	}

	public function selectProduct_V($value,$value2){
		if($value==null && $value2==null){ $m="WHERE shows=1";}
		elseif($value!=null){$m="WHERE Lid='".$value."' AND shows=1";}
		elseif($value==null && $value2!=null){ $m="WHERE id='".$value2."' AND shows=1";}
		$sql = mysql_query("SELECT * FROM product_v $m ORDER BY sort ASC") or die ("ERROR");
		$Level5Array = array();
		while($rs = mysql_fetch_array($sql)){
			array_push($Level5Array,$rs);
		}
		return $Level5Array;
	}
		
	public function selectSlide(){
		$sql = mysql_query("SELECT * FROM slide WHERE shows=1 ORDER BY sort ASC");
		$Result = array();
		while($rs = mysql_fetch_array($sql)){
			array_push($Result,$rs);	
		}
		return $Result;
	}
	
	public function selectNews($value,$query){
		if($value==null){ $m=$query;}
		if($value!=null){$m="WHERE id='".$value."' AND shows=1";}
		$sql = mysql_query("SELECT * FROM news_event $m ORDER BY date DESC") or die ("ERROR");
		$NewsArray = array();
		while($rs = mysql_fetch_array($sql)){
			array_push($NewsArray,$rs);
		}
		return $NewsArray;
	}

	public function selectDownload($value,$limit){
		$sql = mysql_query("SELECT * FROM download WHERE type='".$value."' AND shows=1 ORDER BY sort ASC ,id ASC $limit") or die ("ERROR");
		$DLArray = array();
		while($rs = mysql_fetch_array($sql)){
			array_push($DLArray,$rs);
		}
		return $DLArray;
	}

	public function selectReference($value,$query=''){
		if($value==null){ $m=$query;}
		if($value!=null){$m="WHERE id='".$value."' AND shows=1";}
		$sql = mysql_query("SELECT * FROM reference $m ORDER BY sort ASC ,id DESC") or die ("ERROR");
		$RFArray = array();
		while($rs = mysql_fetch_array($sql)){
			array_push($RFArray,$rs);
		}
		return $RFArray;
	}

	public function selectPartners($condition){
		$sql = mysql_query("SELECT * FROM partners $condition") or die ("ERROR");
		$PTArray = array();
		while($rs = mysql_fetch_array($sql)){
			array_push($PTArray,$rs);
		}
		return $PTArray;
	}

	public function selectPartnerslist($condition){
		$sql = mysql_query("SELECT * FROM partner_news $condition") or die ("ERROR");
		$PTNArray = array();
		while($rs = mysql_fetch_array($sql)){
			array_push($PTNArray,$rs);
		}
		return $PTNArray;
	}

	public function selectBrand($value=''){
		if($value!=null){$m="WHERE id='".$value."' AND shows=1";}else{$m="WHERE shows=1";}
		$sql = mysql_query("SELECT * FROM brand $m ORDER BY sort ASC ,id ASC") or die ("ERROR");
		$BrandArray = array();
		while($rs = mysql_fetch_array($sql)){
			array_push($BrandArray,$rs);
		}
		return $BrandArray;
	}
	
	public function selectServerNews($condition){
		$sql = mysql_query("SELECT * FROM server_news $condition") or die ("ERROR");
		$ServerNews = array();
		while($rs = mysql_fetch_array($sql)){
			array_push($ServerNews,$rs);
		}
		return $ServerNews;
	}

	public function selectGeneral(){
		$sql = mysql_query("SELECT * FROM general WHERE id=1");
		$rs = mysql_fetch_array($sql);
		return $rs;
	}
		
}

$Class = new Main();
?>