@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]='
|';
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'] = "|";
$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"] = "";
while($row1 = $data->fetch_array($rs1))
{
$select="";
If ($row1["categoryid"]==$cateid)
$select="selected";
$row1["vd_categoryname"] = vd_title($row1["categoryname"]);
$row1["option1"] = "";
$xtpl->assign("scate",$row1);
$xtpl->parse("main.cate.scate");
}
}
else
{
$select="";
If ($row1["categoryid"]==$cateid)
$select="selected";
$row["opt1"] = "";
}
$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 "";
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."
";
//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."
";
//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";
}
?>