<?
@session_start();
@header("Cache-control: private");


include "includes/config.php";

include "includes/class_mysql.php";
include "includes/xtemplate.class.inc";
include "includes/vietdecode.php";
include "includes/function.php"; 
include "includes/slug.php";
include "detectmobilebrowse.php"; 

$data = new class_mysql();
$data->config();
$data->access();
$config=$data->query("SELECT * FROM $data->table_config ORDER BY config_id ASC");
$rows_config=$data->num_rows($config);
 for($i=0;$i<$rows_config;$i++){
 	$k[$i]=$data->result($config,$i,"config_values");
 	$h[$i]=$data->result($config,$i,"config_name");
 }

$REMOTE_ADDR=$_SERVER['REMOTE_ADDR'];
 # Const
      $timeout 	= 300; // seconds
      $current_time = time();
      $time_exit = $current_time - $timeout;   
      mysql_query("DELETE FROM table_useronline WHERE timestamp < $time_exit");
		$uri=$_SERVER['REQUEST_URI'];
		$sql_in="INSERT INTO table_useronline (timestamp, ip, username,phpsessid,url) VALUES ('$current_time', '$REMOTE_ADDR', '$username', '$PHPSESSID','$uri')";
      @mysql_query($sql_in);  
/*If ($_SESSION["username"]!=""){
	$username=$_SESSION["username"];
     $sql_in="INSERT INTO table_useronline (timestamp, ip, username,phpsessid) VALUES ('$current_time', '$REMOTE_ADDR', '$username', '$PHPSESSID')";
     mysql_query($sql_in) or die (mysql_error());  
}

	$query_exist=$data->query("SELECT * FROM $data->table_useronline WHERE ip='$REMOTE_ADDR' AND phpsessid='$PHPSESSID'");

	$result_exist=$data->num_rows($query_exist);

	if($result_exist > 0){
        $n=$data->fetch_array($query_exist);
	$_SESSION["username"]=$n["username"];	
        
	}*/


If ($h[7]=="2"){
echo $k[7];
exit;
}
$pagesize = $k[1];
$startrow = 0;


function counter(){
 	global $data,$xtpl;

	# Useronline

	$timeout 	= 300;

	$current_time = time();

	$time_exit = $current_time - $timeout;   
	//$REMOTE_ADDR = $_SERVER["REMOTE_ADDR"];

   // $data->query("INSERT INTO $data->table_useronline (timestamp, username, ip, url) VALUES ('$current_time', '$user', '$REMOTE_ADDR','$uri')");  // new edit        
	$data->query("DELETE FROM $data->table_useronline WHERE timestamp < $time_exit");
	$query_total = $data->query("SELECT DISTINCT ip FROM $data->table_useronline");       
	$online = $data->num_rows($query_total);

	$xtpl->assign("online",$online);

	 $sql="SELECT value FROM table_visit WHERE id=2";
	$rs = $data->query($sql);
	while($row = $data->fetch_array($rs)){
		 $xtpl->assign("visited",$row['value']);
	}
	
}



function select_brand($not_in_str){
 	global $data,$xtpl;

    $sql = "SELECT categoryname,categoryid FROM table_category WHERE opt=1 AND parentid=0 ".$not_in_str." ORDER BY orderid";
	$rs = $data->query($sql);
	while($row = $data->fetch_array($rs))
	{
		$row["selected"] = "";
		If ( isset($_GET["brand"]) && $row["categoryid"] == $_GET["brand"])
		$row["selected"] = "selected";
		

		$xtpl->assign("select_brand",$row);
		$xtpl->parse("main.select_brand");
    }

}

function list_group(){
 	global $data,$xtpl;

    $sql = "SELECT categoryname,categoryid FROM table_category WHERE opt=1 AND parentid=82 ".$not_in_str." ORDER BY orderid";
	$rs = $data->query($sql);
	while($row = $data->fetch_array($rs))
	{
			$row["selected"] = "";
			If ($row["categoryid"] == $_GET["group"])
			$row["selected"] = "selected";

           	$xtpl->assign("list_group",$row);
           	$xtpl->parse("main.list_group");
    }

}


 function ym(){
 	global $data,$xtpl;



    $sql2 = "SELECT * FROM table_support WHERE categoryid=1 ORDER BY id";
	$rs_name2 = $data->query($sql2) or die("Error: ".$sql2);
	while($row_name2 = $data->fetch_array($rs_name2))
	{
           	$xtpl->assign("ym",$row_name2);
           	$xtpl->parse("main.ym");
    }

    $sql2 = "SELECT * FROM table_support WHERE categoryid=1 ORDER BY id";
	$rs_name2 = $data->query($sql2) or die("Error: ".$sql2);
	while($row_name2 = $data->fetch_array($rs_name2))
	{
           	$xtpl->assign("ym2",$row_name2);
           	$xtpl->parse("main.ym2");
    }
	
    $sql2 = "SELECT * FROM table_support WHERE categoryid=2 ORDER BY id";
	$rs_name2 = $data->query($sql2) or die("Error: ".$sql2);
	while($row_name2 = $data->fetch_array($rs_name2))
	{
           	$xtpl->assign("skype",$row_name2);
           	$xtpl->parse("main.skype");
    }
	
	$sql2 = "SELECT * FROM table_support WHERE categoryid=3 ORDER BY id";
	$rs_name2 = $data->query($sql2) or die("Error: ".$sql2);
	while($row_name2 = $data->fetch_array($rs_name2))
	{
           	$xtpl->assign("zalo",$row_name2);
           	$xtpl->parse("main.zalo");
    }

}

 function vote(){
 	global $data,$xtpl;
        $sql2 = "SELECT categoryid,categoryname FROM $data->table_vote WHERE indexid=1";
	$rs_name2 = $data->query($sql2) or die("Error: ".$sql2);
	while($row_name2 = $data->fetch_array($rs_name2))
	{
	$parentid=$row_name2["categoryid"];
	$question=$row_name2["categoryname"];
	    $sql3 = "SELECT categoryid,categoryname FROM $data->table_vote WHERE parentid=$parentid";
		$rs_name3 = $data->query($sql3) or die("Error: ".$sql3);
		while($row_name3 = $data->fetch_array($rs_name3))
		{
	           	$xtpl->assign("listvote",$row_name3);
        	   	$xtpl->parse("main.vote.listvote");
 		}
        }

           	$xtpl->assign("question",$question);
           	$xtpl->parse("main.vote");
}

function list_filter(){
 	global $data,$xtpl;
	
    $sql = "SELECT * FROM $data->table_menu where parentid=$categoryid and opt=1 ORDER BY orderid $str";
	$rs = $data->query($sql) or die("Error: ".$sql);
	$recordcount=$data->num_rows($rs);
	$i=0;
	$gqs = $_SERVER[REQUEST_URI];
	
	$qs = explode('index.php', $gqs);
	$qs = explode('/', $qs[1]);
	$mdl 	= $qs[1];
	$id 	= $qs[2]; 
	
	while($row = $data->fetch_array($rs))
	{	
			$categoryid1=$row["categoryid"];
			$sql1 = "SELECT * FROM $data->table_menu where parentid=$categoryid1 and opt=1 ORDER BY orderid";
			$rs1 = $data->query($sql1) or die("Error: ".$sql1);
			$record = $data->num_rows($rs1);
				if ($record >0) {
					while($row1 = $data->fetch_array($rs1))
						{
							
							$xtpl->assign("smenu",$row1);
							$xtpl->parse("main.$block.exist.smenu");
						}	
					$xtpl->parse("main.$block.exist");
				}	
		$i++;
		//echo $id."---------";
		
		$url = explode('index.php', $row['url']);
		$url = explode('/', $url[1]);
		if ($url[1]==$mdl && $url[2]==$id)  {		
			$xtpl->assign("image",$row["img1"]);
		} else $xtpl->assign("image",$row["img0"]);
		
		//echo $row["categoryid"]."--".$id."  ";
		
		if(!isset($id) && !isset($mdl) && $i==1){
			$xtpl->assign("image",$row["img1"]);
		}
		$row[abc]='<li>|</li>';
		if ($i==$recordcount) $row[abc]='';
		if ($row[url]=="javascript:void(0)"){
			$row["img1"]='';
			$xtpl->assign("image",$row["img0"]);
		}
		
		
		$xtpl->assign("$block",$row);
		$xtpl->parse("main.$block");
    }
}





 function adv(){
 	global $data,$xtpl,$site_url;
	$i=0;
	
	$xtpl->assign("site_url",$site_url);

	# TOP BANNER
	$sql = "SELECT * FROM $data->table_banner WHERE categoryid=1 AND opt=1  ORDER BY orderid limit 0,5";
	$rs = $data->query($sql) or die("Error: ".$sql);
	while($row = $data->fetch_array($rs))
	{	
		$xtpl->assign("top_banner",$row);
		$xtpl->parse("main.top_banner");
    }
	
	# SLIDE
    	$sql = "SELECT * FROM $data->table_banner WHERE categoryid=2 AND opt=1 ORDER BY orderid";
		$rs = $data->query($sql) or die("Error: ".$sql);
		while($row = $data->fetch_array($rs))
		{
		$xtpl->assign("slide",$row);
		$xtpl->parse("main.slide");
		}

	# CENTER BANNER
	$sql = "SELECT * FROM $data->table_banner WHERE categoryid=4 AND opt=1  ORDER BY orderid";
	$rs = $data->query($sql) or die("Error: ".$sql);
	while($row = $data->fetch_array($rs))
	{	
		If ($row["title"] != "{hidden}") {
		$xtpl->assign("title",$row["title"]);
		$xtpl->assign("url",$row["url"]);
		$xtpl->parse("main.center_banner.show_title");		
		}
		$xtpl->assign("center_banner",$row);
		$xtpl->parse("main.center_banner");
		
    }
	
	$sql = "SELECT * FROM $data->table_banner WHERE categoryid=8 AND opt=1 ORDER BY orderid";
	$rs = $data->query($sql) or die("Error: ".$sql);
	while($row = $data->fetch_array($rs))
	{	
		If ($row["title"] != "{hidden}") {
		$xtpl->assign("title",$row["title"]);
		$xtpl->assign("url",$row["url"]);
		$xtpl->parse("main.center_banner_2.show_title");		
		}
		$xtpl->assign("center_banner_2",$row);
		$xtpl->parse("main.center_banner_2");
		
    }

	$sql = "SELECT * FROM $data->table_banner WHERE categoryid=9 AND opt=1 ORDER BY orderid";
	$rs = $data->query($sql) or die("Error: ".$sql);
	while($row = $data->fetch_array($rs))
	{	
		If ($row["title"] != "{hidden}") {
		$xtpl->assign("title",$row["title"]);
		$xtpl->assign("url",$row["url"]);
		$xtpl->parse("main.center_banner_3.show_title");		
		}
		$xtpl->assign("center_banner_3",$row);
		$xtpl->parse("main.center_banner_3");
		
    }
	
	
    $sql = "SELECT * FROM $data->table_banner WHERE categoryid=3 AND opt=1 ORDER BY orderid desc ";
	$rs = $data->query($sql) or die("Error: ".$sql);
	while($row = $data->fetch_array($rs))
	{

           	$xtpl->assign("adv_left",$row);
           	$xtpl->parse("main.adv_left");

    }
    

	


    $sql = "SELECT * FROM $data->table_banner WHERE categoryid=5 ORDER BY id desc limit 0,1";
	$rs = $data->query($sql) or die("Error: ".$sql);
	while($row = $data->fetch_array($rs))
	{

           	$xtpl->assign("banner_chay_trai",$row);
           	$xtpl->parse("main.banner_chay_trai");
    }

    $sql = "SELECT * FROM $data->table_banner WHERE categoryid=6 ORDER BY id desc limit 0,1";
	$rs = $data->query($sql) or die("Error: ".$sql);
	while($row = $data->fetch_array($rs))
	{

           	$xtpl->assign("banner_chay_phai",$row);
           	$xtpl->parse("main.banner_chay_phai");
    }
	
	If ($_SESSION["show_popup"] == "") {
	$_SESSION["show_popup"] = "0";
    $sql = "SELECT * FROM $data->table_banner WHERE categoryid=7 ORDER BY id desc limit 0,1";
	$rs = $data->query($sql) or die("Error: ".$sql);
	while($row = $data->fetch_array($rs))
	{
           	$xtpl->assign("banner_popup",$row);
           	$xtpl->parse("main.banner_popup");
    }
	}		

	
}


 function left_news(){
 	global $data,$xtpl;
		$sql="SELECT title,description,id,categoryid FROM $data->table_news WHERE m_categoryid like '%,3,%' AND active=1  ORDER BY orderid DESC LIMIT 0,5";
		$rs1 = $data->query($sql) or die("Error: ".$sql);
		while($row1 = $data->fetch_array($rs1))
		{
			$row1[vd_categoryname] = vd_categoryname($row1[categoryid]);
			$row1[vd_title] = vd_title($row1[title]);
			$xtpl->assign("left_news_1",$row1);
			$xtpl->parse("main.left_news_1");	
		}

		$sql="SELECT title,description,id,categoryid FROM $data->table_news WHERE m_categoryid like '%,4,%' AND active=1  ORDER BY orderid DESC LIMIT 0,5";
		$rs1 = $data->query($sql) or die("Error: ".$sql);
		while($row1 = $data->fetch_array($rs1))
		{
			$row1[vd_categoryname] = vd_categoryname($row1[categoryid]);
			$row1[vd_title] = vd_title($row1[title]);
			$xtpl->assign("left_news_4",$row1);
			$xtpl->parse("main.left_news_4");	
		}		

}

 function footer_news(){
 	global $data,$xtpl;
		$sql="SELECT title,description,id FROM $data->table_news WHERE m_categoryid like '%,161,%' AND active=1  ORDER BY orderid DESC LIMIT 0,5";
		$rs1 = $data->query($sql) or die("Error: ".$sql);
		while($row1 = $data->fetch_array($rs1))
		{
			$row1[vd_title] = vd_title($row1[title]);
			$xtpl->assign("footer_news",$row1);
			$xtpl->parse("main.footer_news");	
		}

}

 function right_news(){
 	global $data,$xtpl;

		$sql="SELECT id,title,description,categoryid FROM $data->table_news WHERE m_categoryid like '%,15,%' AND active=1  ORDER BY orderid DESC LIMIT 0,1";
		$rs1 = $data->query($sql) or die("Error: ".$sql);
		while($row1 = $data->fetch_array($rs1))
		{
			$row1[vd_categoryname] = vd_categoryname($row1[categoryid]);
			$row1[vd_title] = vd_title($row1[title]);
			If ($row["image"]!=""){
				$xtpl->assign("vd_categoryname",$row["vd_categoryname"]);
				$xtpl->assign("image",$row["image"]);
				$xtpl->assign("id",$row["id"]);
				$xtpl->assign("title",$row["title"]);
				$xtpl->assign("vd_title",$row["vd_title"]);
				$xtpl->parse("main.right_news_top.image");
			}
		
			$xtpl->assign("right_news_top",$row1);
			$xtpl->parse("main.right_news_top");	
		}
		
		$sql="SELECT id,title,description,categoryid FROM $data->table_news WHERE m_categoryid like '%,15,%' AND active=1  ORDER BY orderid DESC LIMIT 1,5";
		$rs1 = $data->query($sql) or die("Error: ".$sql);
		while($row1 = $data->fetch_array($rs1))
		{
			$row1[vd_categoryname] = vd_categoryname($row1[categoryid]);
			$row1[vd_title] = vd_title($row1[title]);
			$xtpl->assign("right_news",$row1);
			$xtpl->parse("main.right_news");	
		}
		
		
}

function menu_left(){
	global $data,$xtpl,$module_term_lpro;
	$gqs = $_SERVER['REQUEST_URI'];
	$qs = explode('index.php', $gqs);
	$qs = explode('/', $qs[1]);
	$categoryid=$qs[2];
	$sql1 = "SELECT * FROM $data->table_category WHERE parentid=0 AND opt=1 ORDER BY orderid";
	$i=0;
	$rs_name1 = $data->query($sql1);
	while($row = $data->fetch_array($rs_name1)){
		$id=$row["categoryid"];
		if ($id==$categoryid){
			$abc=$i;
			$xtpl->assign("menudong",$abc);
		}
		$row["li_act"] = '';
		$sql2 = "SELECT * FROM $data->table_category WHERE parentid=$id AND opt=1 ORDER BY orderid ";
		$rs_name2 = $data->query($sql2);
		if ($data->num_rows($rs_name2) >0)
		{
			$row["li_act"] = 'id="li1_act"';	
	   		 while($row1 = $data->fetch_array($rs_name2))
			{	
				$row1['vd_categoryname'] = vd_title($row1['categoryname']);
				$svd_title = $row1["vd_categoryname"]."-p";
				$row1["url"] = get_url_slug($module_term_lpro,$row1["categoryid"],$svd_title);
					$xtpl->assign("smenu_left",$row1);	
				
					$xtpl->parse("main.menu_left.exist.smenu_left");
			}
			$xtpl->parse("main.menu_left.exist");
		}
		$i++;
		$row['vd_categoryname'] = vd_title($row['categoryname']);
		$svd_title = $row["vd_categoryname"]."-p";
		$row["url"] = get_url_slug($module_term_lpro,$row["categoryid"],$svd_title);
           	$xtpl->assign("menu_left",$row);	
           	$xtpl->parse("main.menu_left");
   }
}


function menu_footer(){
	global $data,$xtpl;
	
	$rs_org = $data->query( "SELECT * FROM $data->table_menu WHERE parentid=0 AND opt=1 and orderid=12 ORDER BY orderid limit 0,1" );
	$row_org = $data->fetch_array($rs_org);
	
	$sql1 = "SELECT * FROM $data->table_menu WHERE opt=1 and parentid=".$row_org['categoryid']." ORDER BY orderid limit 0,2";
	$i=0;
	$rs_name1 = $data->query($sql1);
	while($row = $data->fetch_array($rs_name1)){
		
		$sql2 = "SELECT * FROM $data->table_menu WHERE parentid=".$row['categoryid']." AND opt=1 ORDER BY orderid ";
		$rs2 = $data->query($sql2);
		if ($data->num_rows($rs2) >0){
	   		 while($row1 = $data->fetch_array($rs2)){
					$xtpl->assign("list",$row1);				
					$xtpl->parse("main.menu_footer.exist.list");
			}
			$xtpl->parse("main.menu_footer.exist");
		}
		$i++;
		
		$xtpl->assign("menu_footer",$row);	
		$xtpl->parse("main.menu_footer");
   }
}


 function art_footer(){
 	global $data,$xtpl;
		$sql="SELECT categoryid,categoryname FROM $data->table_category_news WHERE opt=1 LIMIT 0,2";
		$rs = $data->query($sql);
		while($row = $data->fetch_array($rs))
		{	
			$vd_categoryname = vd_title($row["categoryname"]);
			$sql1="SELECT * FROM $data->table_news WHERE m_categoryid like '%,".$row["categoryid"].",%' ORDER BY orderid DESC LIMIT 0,4";
			$rs1 = $data->query($sql1);
			while($row1 = $data->fetch_array($rs1))
			{
				$row1["vd_title"] = vd_title($row1["title"]);
				$row1["vd_categoryname"] = $vd_categoryname;
				$xtpl->assign("list_fnews",$row1);
				$xtpl->parse("main.catenews.list_fnews");	
			}
		$xtpl->assign("catenews",$row);
		$xtpl->parse("main.catenews");				
		}

}

 function menu_header(){
 	global $data,$xtpl,$mdl,$id;
	$i=0;
	$d=0;
	
	$gqs = $_SERVER['REQUEST_URI'];
	$gqs = str_replace('/projects/phutungapt/','', $gqs);	
	
	$str2 = $gqs;
	
	If ($str2 == "")
	$str2 = "index.php";
	
    $sql = "SELECT * FROM $data->table_menu WHERE parentid=55 AND opt=1 ORDER BY orderid";
	$rs = $data->query($sql) or die("Error: ".$sql);
	$count = $data->num_rows($rs);
	while($row = $data->fetch_array($rs)){
		$d++;
						
		$row['cs_end'] = "";
		If ($d == $count)
		$row['cs_end'] = 'class="li-cuoi"';
		$row['d']=$d;
		$row['css_id']="";
		$row['css_cls']="";
		$row['rel']="";

			$row["active"]='';

			
			if ($row["url"]==$str2)  {		
				$row["active"]=' id="act"';
			}

		$row["rel"]= "";
		$categoryid=$row["categoryid"];
		$sql1 = "SELECT * FROM $data->table_menu where parentid=$categoryid and opt=1 ORDER BY orderid";
		$rs1 = $data->query($sql1);
		$record = $data->num_rows($rs1);
		if ($record >0) {
			$i++;	
			$row["css_id"]='id="ddsubmenu'.$i.'"';
			$row["rel"]='rel="ddsubmenu'.$i.'"';
			while($row1 = $data->fetch_array($rs1)){
				
					$categoryid2=$row1["categoryid"];
					
					$sql2 = "SELECT * FROM $data->table_menu where parentid=$categoryid2 and opt=1 ORDER BY orderid";
					$rs2 = $data->query($sql2) or die("Error: ".$sql2);
					$record2 = $data->num_rows($rs2);
						if ($record2 >0) {
							
							while($row2 = $data->fetch_array($rs2))
								{
									
									$xtpl->assign("ssmenuhead",$row2);
									$xtpl->parse("main.pmenuhead.smenuhead.ssmenuhead");
								}	
						}
					
					$row1['record']=$record2;
					$xtpl->assign("smenuhead",$row1);
					$xtpl->parse("main.menuhead.pmenuhead.smenuhead");
				}
						
			//$xtpl->assign("pmenuhead",$row);
			$xtpl->parse("main.menuhead.pmenuhead");
		}	
		
		$row['record']=$record;
		$row["last_css"]   	=  	"";
		If ($d == $count)
		$row["last_css"]  	=	'style="border:none;"';	

		$xtpl->assign("menuhead",$row);
		$xtpl->parse("main.menuhead");

		
	
    }
	
	

}

 function menufooter(){
 	global $data,$xtpl,$mdl,$id;
	$i=0;
	$d=0;
    $sql = "SELECT * FROM $data->table_menu WHERE parentid=56 AND opt=1 ORDER BY orderid";
	$rs = $data->query($sql) or die("Error: ".$sql);
	$count = $data->num_rows($rs);
	while($row = $data->fetch_array($rs))
	{
	$row['ss'] = "<span>|</span>";
	$d++;
	If ($count == $d)
	$row['ss'] = "";
	
	$xtpl->assign("menufooter",$row);
	$xtpl->parse("main.menufooter");
    }
	
	#Sitemap footer
		$sql="SELECT categoryid,categoryname,url FROM $data->table_menu WHERE parentid=66 AND opt=1 LIMIT 0,2";
		$rs = $data->query($sql);
		while($row = $data->fetch_array($rs))
		{	
			$sql1="SELECT categoryid,categoryname,url FROM $data->table_menu WHERE parentid=".$row["categoryid"]." ORDER BY orderid";
			$rs1 = $data->query($sql1);
			while($row1 = $data->fetch_array($rs1))
			{
				$xtpl->assign("child",$row1);
				$xtpl->parse("main.sitemap_footer.child");	
			}
		$xtpl->assign("sitemap_footer",$row);
		$xtpl->parse("main.sitemap_footer");				
		}
		
}


 function header_news(){
 	global $data,$xtpl,$mdl,$id;

############## INDEX_CATEGORY_1 ######################
    $sql1 = "SELECT * FROM $data->table_category_news WHERE location=1 ORDER BY orderid LIMIT 0,1";
	$d = 0;
	$rs1 = $data->query($sql1) or die("Error: ".$sql1);
	while($row1 = $data->fetch_array($rs1)){
				## ART ####
				$sql2 = "SELECT * FROM $data->table_news WHERE m_categoryid like '%,".$row1[categoryid].",%' AND active=1 ORDER BY orderid DESC LIMIT 0,1";
				//echo $sql2;
				$rs2 = $data->query($sql2) or die("Error: ".$sql2);
				while($row2 = $data->fetch_array($rs2)){
					$row2[vd_title] = vd_title($row2[title]);
					$row2[vd_categoryname] = vd_categoryname($row2[categoryid]);
					$xtpl->assign("index_news_1",$row2);
					$xtpl->parse("main.index_category_1.index_news_1");
				}
	
	$xtpl->assign("index_category_1",$row1);
	$xtpl->parse("main.index_category_1");
	}
############################################################

############## INDEX_CATEGORY_2 ######################
    $sql1 = "SELECT * FROM $data->table_category_news WHERE location=1 ORDER BY orderid LIMIT 1,1";
	$d = 0;
	$rs1 = $data->query($sql1) or die("Error: ".$sql1);
	while($row1 = $data->fetch_array($rs1)){
				## ART ####
				$sql2 = "SELECT * FROM $data->table_news WHERE m_categoryid like '%,".$row1[categoryid].",%' AND active=1 ORDER BY orderid DESC LIMIT 0,1";
				$rs2 = $data->query($sql2) or die("Error: ".$sql2);
				while($row2 = $data->fetch_array($rs2)){
					$row2[vd_title] = vd_title($row2[title]);
					$row2[vd_categoryname] = vd_categoryname($row2[categoryid]);
					$xtpl->assign("index_news_2",$row2);
					$xtpl->parse("main.index_category_2.index_news_2");
				}
	
	$xtpl->assign("index_category_2",$row1);
	$xtpl->parse("main.index_category_2");
	}
############################################################

############## INDEX_CATEGORY_3 ######################
    $sql1 = "SELECT * FROM $data->table_category_news WHERE location=1 ORDER BY orderid LIMIT 2,1";
	$d = 0;
	$rs1 = $data->query($sql1) or die("Error: ".$sql1);
	while($row1 = $data->fetch_array($rs1)){
				## ART ####
				$sql2 = "SELECT * FROM $data->table_news WHERE m_categoryid like '%,".$row1[categoryid].",%' AND active=1 ORDER BY orderid DESC LIMIT 0,1";
				$rs2 = $data->query($sql2) or die("Error: ".$sql2);
				while($row2 = $data->fetch_array($rs2)){
					$row2[vd_title] = vd_title($row2[title]);
					$row2[vd_categoryname] = vd_categoryname($row2[categoryid]);
					$xtpl->assign("index_news_3",$row2);
					$xtpl->parse("main.index_category_3.index_news_3");
				}
	
	$xtpl->assign("index_category_3",$row1);
	$xtpl->parse("main.index_category_3");
	}
############################################################

############## INDEX_CATEGORY_4 ######################
    $sql1 = "SELECT * FROM $data->table_category_news WHERE location=1 ORDER BY orderid LIMIT 3,1";
	$d = 0;
	$rs1 = $data->query($sql1) or die("Error: ".$sql1);
	while($row1 = $data->fetch_array($rs1)){
				## ART ####
				$sql2 = "SELECT * FROM $data->table_news WHERE m_categoryid like '%,".$row1[categoryid].",%' AND active=1 ORDER BY orderid DESC LIMIT 0,1";
				$rs2 = $data->query($sql2) or die("Error: ".$sql2);
				while($row2 = $data->fetch_array($rs2)){
					$row2[vd_title] = vd_title($row2[title]);
					$row2[vd_categoryname] = vd_categoryname($row2[categoryid]);
					$xtpl->assign("index_news_4",$row2);
					$xtpl->parse("main.index_category_4.index_news_4");
				}
	
	$xtpl->assign("index_category_4",$row1);
	$xtpl->parse("main.index_category_4");
	}
############################################################

############## INDEX_CATEGORY_5 ######################
    $sql1 = "SELECT * FROM $data->table_category_news WHERE location=1 ORDER BY orderid LIMIT 4,1";
	$d = 0;
	$rs1 = $data->query($sql1) or die("Error: ".$sql1);
	while($row1 = $data->fetch_array($rs1)){
				## ART ####
				$sql2 = "SELECT * FROM $data->table_news WHERE m_categoryid like '%,".$row1[categoryid].",%' AND active=1 ORDER BY orderid DESC LIMIT 0,1";
				$rs2 = $data->query($sql2) or die("Error: ".$sql2);
				while($row2 = $data->fetch_array($rs2)){
					$row2[vd_title] = vd_title($row2[title]);
					$row2[vd_categoryname] = vd_categoryname($row2[categoryid]);
					$xtpl->assign("index_news_5",$row2);
					$xtpl->parse("main.index_category_5.index_news_5");
				}
	
	$xtpl->assign("index_category_5",$row1);
	$xtpl->parse("main.index_category_5");
	}
############################################################

}



 function category(){
 	global $data,$xtpl;
	$cateid  = $_GET[cateid];
	If ($cateid == "")
	$cateid = 0;
	
    $sql = "SELECT * from table_category WHERE parentid=0  AND opt=1 order by categoryid";
	$rs = $data->query($sql) or die("Error: ".$sql);
	while($row = $data->fetch_array($rs))
	{

	$categoryid=$row["categoryid"];
	$row["vd_categoryname"] = vd_title($row["categoryname"]);
	$sql = "SELECT * from table_category where parentid=$categoryid  AND opt=1 order by orderid ";
	$rs1 = $data->query($sql) or die("Error: ".$sql);
	 $recordcount1 = $data->num_rows($rs1);
	if ($recordcount1 > 0)
	 {
		$row["opt1"] = "<optgroup label='$row[categoryname]'>";
		$row["opt2"] = "</optgroup>";
		while($row1 = $data->fetch_array($rs1))

		{	
				$select="";
				If ($row1["categoryid"]==$cateid)
				$select="selected";	
			
			$row1["vd_categoryname"] = vd_title($row1["categoryname"]);	
			$row1["option1"] = "<option value='".$row1[categoryid]."' style='margin-left:10px;' ".$select." >";
			$row1["option2"] = "</option>";
			
           		$xtpl->assign("scate",$row1);
           		$xtpl->parse("main.cate.scate");
        }
	}
	else 
	{
		$select="";
		If ($row1["categoryid"]==$cateid)
		$select="selected";	
		$row["opt1"] = "<option value='$row[categoryid]' $select> $row[categoryname]";
		$row["opt2"] = "</option>";
     }

	$xtpl->assign("cate",$row);
    $xtpl->parse("main.cate");	


}
}


function menu()
{
global $data,$xtpl;
$gqs = $_SERVER['REQUEST_URI'];
$qs = explode('index.php', $gqs);
$qs = explode('/', $qs[1]);
$categoryid=$qs[2];
 $sql1 = "SELECT * FROM $data->table_category where parentid=0 AND opt=1 ORDER BY orderid";
$qstr = "$_SERVER[REQUEST_URI]";
$qs = explode('/', $qstr);
//echo $qs[3];
//exit;
$x=0;
$i=1;
	$rs_name1 = $data->query($sql1);
	while($row = $data->fetch_array($rs_name1))
	{
				
		$id=$row["categoryid"];
		if ($id==$categoryid){
			$abc=$x;
			$xtpl->assign("menudong",$abc);
		}
		if ($i%2 ==0){
			$row['css_class']="li_menu1";
		}
		else {
			$row['css_class']="li_menu1";
		}
		$i++;
		  $row['open']="b";
			$id=$row["categoryid"];
		 $sql2 = "SELECT * FROM $data->table_category WHERE parentid=$id AND opt=1 ORDER BY orderid ";
		$rs_name2 = $data->query($sql2);
		if ($data->num_rows($rs_name2) >0)
		{
	   		 while($row1 = $data->fetch_array($rs_name2))
			{	
				$row1['css_class']="li_tree";
				if ($row1['categoryid']==$qs[3]) 
				{
					$activeid = $i-1;		
					$row['css_class']="li_menu_act";
					$row['open']="b";
					$row1['css_class']="li_tree_act";  
				} 
				if ($categoryid==$row1["categoryid"]){
					$abc=$x;
					$xtpl->assign("menudong",$abc);
				}
				$row1['vd_categoryname'] = vd_title($row1['categoryname']);
				$xtpl->assign("smenu_cate",$row1);	
				
					$xtpl->parse("main.menu_cate.smenu_cate");
				}
		}
		else
		{ 
			$xtpl->parse("main.menu_cate.no_record");
		}
              
		
		if ($row['categoryid']==$qs[3]) 
			{
					
				$row['open']="b";
				$row['css_class']="li_menu_act";
			}

		$x++;
		$row['vd_categoryname'] = vd_title($row['categoryname']);
           	$xtpl->assign("menu_cate",$row);	

           	$xtpl->parse("main.menu_cate");
        }
	$activeid--; 
	$xtpl->assign("activeid",$activeid);
}


function hot_pro()
{
 	global $data,$xtpl,$module_term_dpro;
	$i = 0;
    $sql1 = "SELECT * FROM $data->table_post WHERE m_categoryid like '%,428,%' AND active=1 ORDER BY orderid DESC LIMIT 0,5";
	$rs_name1 = $data->query($sql1);
	$count = $data->num_rows($rs_name1);
	If ($count > 0) {
	while($row = $data->fetch_array($rs_name1))
	{	
			$i++;
			$row["css_class"]="new-left1";
			if ($i%2==0) $row["css_class"]="new-left2";
			If ($row[price] == 0) {
			$row[price] = "Liên hệ";
			} else {
			$row[price]	   = number_format($row[price])." VNĐ";
			}
			$row[vd_categoryname] 	= vd_categoryname($row["categoryid"]);
			$row[vd_title] 			= vd_title($row["title"]);
			
			$svd_title = $row["vd_categoryname"]."/".$row["vd_title"]."-d";
			$row["url"] = get_url_slug($module_term_dpro,$row["id"],$svd_title);		
		
			If ($row["warranty"] != "")
			$row["warranty"] = 'Bảo hành: '.$row["warranty"];
		
           	$xtpl->assign("hot_pro",$row);	
           	$xtpl->parse("main.show_hot_pro.hot_pro");
   	}
		$xtpl->parse("main.show_hot_pro");
	}
}

function hot_news(){
 	global $data,$xtpl,$module_term_dnews;
	$i=0;
    $sql=" SELECT * FROM $data->table_news WHERE  m_categoryid like '%,86,%' AND active=1 ORDER BY id desc  limit 0,8";
	$rs = $data->query($sql);
	while($row = $data->fetch_array($rs))
	{
		$i++;
		$row[vd_categoryname] = vd_categoryname_news($row[categoryid]);
		$row[vd_title] = vd_title($row[title]);
		$row["css_class"]="new-left1";
		if ($i%2==0) $row["css_class"]="new-left2";
		//$row[description]=cut_string($row[description],90,0);
		If ($row["image"]!=""){
           	$xtpl->assign("image",$row["image"]);
           	$xtpl->assign("id",$row["id"]);
           	$xtpl->assign("vd_title",$row["vd_title"]);
           	$xtpl->parse("main.hot_news.image");
		}
			$svd_title = $row["vd_categoryname"]."/".$row["vd_title"]."-a";
			$row["url"] = get_url_slug($module_term_dnews,$row["id"],$svd_title);
			
           	$xtpl->assign("hot_news",$row);
           	$xtpl->parse("main.hot_news");

     }

    $sql=" SELECT $data->table_news.* FROM $data->table_news,$data->table_category_news  WHERE  $data->table_news.categoryid =$data->table_category_news.categoryid AND $data->table_category_news.categoryid=93 AND  $data->table_news.active=1 ORDER BY id desc  limit 0,7";
	$rs = $data->query($sql) or die("Error: ".$sql);
	while($row = $data->fetch_array($rs))
	{
	    $row[vd_categoryname] = vd_categoryname_news($row[categoryid]);
		$row[vd_title] = vd_title($row[title]);
        $xtpl->assign("right_news1",$row);
        $xtpl->parse("main.right_news1");
    }

    $sql=" SELECT $data->table_news.* FROM $data->table_news,$data->table_category_news  WHERE  $data->table_news.categoryid =$data->table_category_news.categoryid AND $data->table_category_news.categoryid=91 AND  $data->table_news.active=1 ORDER BY id desc  limit 0,7";
	$rs = $data->query($sql) or die("Error: ".$sql);
	while($row = $data->fetch_array($rs))
	{
		$row[vd_categoryname] = vd_categoryname_news($row[categoryid]);
		$row[vd_title] = vd_title($row[title]);
        $xtpl->assign("right_news2",$row);
        $xtpl->parse("main.right_news2");
    }

    $sql=" SELECT $data->table_news.* FROM $data->table_news,$data->table_category_news  WHERE  $data->table_news.categoryid =$data->table_category_news.categoryid AND $data->table_category_news.categoryid=92 AND  $data->table_news.active=1 ORDER BY id desc  limit 0,7";
	$rs = $data->query($sql) or die("Error: ".$sql);
	while($row = $data->fetch_array($rs))
	{
		$row[vd_categoryname] = vd_categoryname_news($row[categoryid]);
		$row[vd_title] = vd_title($row[title]);
        $xtpl->assign("right_news3",$row);
        $xtpl->parse("main.right_news3");
    }


}


function menuleftcate(){
 	global $data,$xtpl,$module_term_lpro;
	$i=0;
    $sql="SELECT * FROM $data->table_category WHERE  opt=1 and parentid=0 and menuleft=1 ORDER BY orderid ASC";
	$rs = $data->query($sql);
	while($row = $data->fetch_array($rs)){
		$i++;
		
		$rs2 = $data->query("SELECT * FROM $data->table_category WHERE opt=1 and parentid=".$row['categoryid']." and menuleft=1 ORDER BY orderid ASC");
		while($row2 = $data->fetch_array($rs2)){
			$svd_categoryname2 = vd_title($row2["categoryname"])."-p";
			$row2["url"] = get_url_slug($module_term_lpro,$row2["categoryid"],$svd_categoryname2);
		
			$xtpl->assign("list",$row2);
			$xtpl->parse("main.menuleftcate.list");
		}
				
		$svd_categoryname = vd_title($row["categoryname"])."-p";
		$row["url"] = get_url_slug($module_term_lpro,$row["categoryid"],$svd_categoryname);
			
		$xtpl->assign("list",$row);
		$xtpl->parse("main.menuleftcate");

     }
}

 function left_cart(){
 	global $data,$xtpl,$PHPSESSID;
	$rs = $data->query("SELECT count(table_cart.id_pro) as count_cart FROM table_cart WHERE table_cart.sess = '$PHPSESSID' AND id_customer= '0' ");
	while($n = $data->fetch_array($rs))
	{
		$count_cart = $n["count_cart"];
	}	
		
	If ($count_cart > 0) {
		$xtpl->assign("count_cart",$count_cart);
		$xtpl->parse("main.left_cart");	
	}

}
# General Functions
function general(){
 	global $data,$xtpl,$k,$site_url;
	menu_header();	
	ym();
	adv();
	counter();	
	menufooter();
	menu();
	menu_left();
	left_cart();
	hot_news();
	select_brand("AND categoryid NOT IN ('82')");
	list_group();
	menuleftcate();
	menu_footer();
	
	$xtpl->assign("site_url",site_url);
	$xtpl->assign("footer",$k[6]);
	$xtpl->assign("usd",$k[17]);
	$xtpl->assign("meta_keyword",$k[14]);
	$xtpl->assign("meta_description",$k[15]);
	$memberid=$_SESSION["memberid"];
	
}

 function redirect_url($gqs){
 	global $data;
	If ($gqs["0"] == "/")
	$gqs["0"] = "";
	$gqs = trim($gqs);
	$rs = $data->query("SELECT t_url FROM table_redirect_url WHERE f_url = '$gqs'");
	$count = $data->num_rows($rs);
	If ($count > 0) {
	while($n = $data->fetch_array($rs))
	{
		echo "<script>location='".$n["t_url"]."'</script>";
		exit;
	}	
	
	}
}

//include "includes/traffic.php";
$gqs = $_SERVER['REQUEST_URI'];
//echo $gqs;
//exit;
redirect_url($gqs);
//echo $_SERVER['REQUEST_URI'];
//exit;
$sss = explode('?', $gqs);
$gqs = $sss["0"];
$gqs = str_replace('/autoparts/','', $gqs);
$gqs = str_replace('/index.php/','', $gqs);
$pos = strpos($gqs,"index.php");
if ($pos === false){
	$gqs = 		str_replace('/projects/phutungapt/','', $gqs);	
	$slug 	= 	str_replace('/','', $gqs);
	$asl	=	explode("?",$slug);
	$slug	= 	$asl["0"];
	$qs 	= 	explode('-trang-', $slug);
	$slug 	= 	$qs[0];

	If (is_numeric($qs[1])){
	$page = $qs["1"];
	}
	
	
	$rs = $data->query("SELECT module,value FROM table_term WHERE slug = '$slug'");
	$check_e_url = $data->num_rows($rs);
	If ($check_e_url > 0) {
			while($row= $data->fetch_array($rs))
			{
				$mdl = $row[module];
				$id  = $row[value];
			}
	} else {
	$slug 	= 	str_replace('/','', $gqs);
	$asl	=	explode("?",$slug);		
	$slug	= 	$asl["0"];
	$o_slug	= 	$asl["0"];
	$qs 	= 	explode('-trang-', $slug);
	$slug 	= 	$qs[0];

	If ((is_numeric($qs[1])) && ($qs["2"] == "")){
	$page = $qs["1"];
	} else {
	$slug = $o_slug;
	}
	
	$qs = explode('-', $slug);
	$q_count = count($qs);
	$ttt = $qs[$q_count-1];
	$kkk = explode('?', $ttt);

	$ttt = $kkk[0];
	$mdl = $ttt[0];

	$ttt  	= str_replace(".html",'', $ttt);
	$id  	= str_replace($mdl,'', $ttt);
	$id  	= str_replace(".html",'', $id);

//echo $slug."<br>";
//echo $id;
	}


	include "includes/url.php";
	
} else {
		$qs = explode('index.php', $gqs);
		$qs = explode('/', $qs[1]);
		$mdl 	= $qs[1];
		$id 	= $qs[2]; 
		$page 	= $qs[3]; 
		$vd_title=$qs[4];
}

//echo $mdl."<br>";
//echo $id;
//exit;


If ($mdl=="") 
	 $mdl="index";

$id = str_replace("'","",$id);

$module = $mdl;
 $tplfile= $module.$extension_tpl;

If ($module=="") 
{
 $module="index";
 include "modules/".$module.".php";
 exit;
}


if(!file_exists("modules/$module.php")) 
{
 include "modules/404.php";
}
else{
include "modules/".$module.".php";
}
?>