| .. | |||||
| 1functions.php | |||||
| common.php | |||||
| functions.php | |||||
| thumbnail.class.php |
| Server IP : 104.21.87.198 / Your IP : 172.70.92.205 Web Server : Apache/2.2.15 (CentOS) System : Linux GA 2.6.32-431.1.2.0.1.el6.x86_64 #1 SMP Fri Dec 13 13:06:13 UTC 2013 x86_64 User : apache ( 48) PHP Version : 5.6.38 Disable Function : NONE MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : OFF Directory : /var/www/html/carmax/backup/includes/ |
Upload File : |
<?php
function contact($tplx){
global $lang,$cf,$tpl;
if (@$_POST['c']!=1){
$_SESSION['codez']=rand(120,987);
$inp=array('{name}','{addr}','{email}','{phone}','{comment}','<!-- FORM CONTACT -->','{codez}');
$oup=array('','','','','','',$_SESSION['codez']);
$nd=str_replace($inp,$oup,$tplx);
} else{
$name=htmlspecialchars(trim($_POST["name"]));
$address=htmlspecialchars(trim($_POST["addr"]));
$email=htmlspecialchars(trim($_POST["email"]));
$phone=htmlspecialchars(trim($_POST["phone"]));
$comment=htmlspecialchars($_POST["comment"]);
$codez=htmlspecialchars($_POST["codez"]);
$inp=array('{name}','{addr}','{email}','{phone}','{comment}','<!-- FORM CONTACT -->','{codez}');
if ($codez!=$_SESSION['codez']){
$_SESSION['codez']=rand(120,987);
$inp=array('{name}','{addr}','{email}','{phone}','{comment}','<!-- FORM CONTACT -->','{codez}');
$oup=array('','','','','','',$_SESSION['codez']);
$nd=str_replace($inp,$oup,$tplx);
// $nd=$codez."----".$_SESSION['codez'];
} else{
if ($name!='' && $email!='' && $phone!='' && $comment!=''){
$baseemail=$cf['admin_email'];
$message='<b>Người gửi:</b> '.$name.'<br>'.
'<b>Địa chỉ:</b> '.$address.'<br>'.
'<b>Email:</b> '.$email.'<br>'.
'<b>Điện thoại:</b> '.$phone.'<br>'.
'<b>Nội dung:</b><p> '.$comment.'</p>'
;
$headers = 'MIME-Version: 1.0' . "\n";
$headers .= 'Content-type: text/html; charset=utf-8' . "\n";
$headers .= 'From: '.$name.' <'.$email.'>' . "\n" . 'Reply-To: '.$email. "\n" . 'X-Mailer: PHP/' . phpversion();
//$rm=mail($baseemail,'Liên hệ khách hàng '.date("i:H d/m/Y",time()),$message,$headers);
// $title='Liên hệ khách hàng '.date("i:H d/m/Y",time());
// $rm=remote_email($message,$name,$email,$baseemail,$title);
// if ($rm=='ok'){
$rm=1;
if ($rm){
$text='<h1 style="color:#227722;font-size:14px;">Bạn đã gửi thông tin thành công, chúng tôi sẽ liên hệ với bạn sớm nhất có thể.</h1>';
$nd=str_replace(array('{headtitle}','{text}'),array('LIÊN HỆ',$text),$tpl['box']);
$_SESSION['codez']=-100;
} else{
$oup=array($name,$address,$email,$phone,$comment,'<h1 style="color:#ff0000;font-size:14px;">Có lỗi khi gửi thông tin, bạn hãy thử lại. </h1>',$_SESSION['codez']);
$nd=str_replace($inp,$oup,$tplx);
}
} else{
$oup=array($name,$address,$email,$phone,$comment,'<h2 style="color:#ff0000;font-size:14px;">Bạn điềnn thiếu thông tin.</h2>',$_SESSION['codez']);
$nd=str_replace($inp,$oup,$tplx);
}
}
}
if ($lang=='vi'){
$sql="SELECT * FROM dg_common WHERE name='contact'";
} else{
$sql="SELECT * FROM dg_common WHERE name='contact2'";
}
$result=mysql_query($sql) or die('Error: '.mysql_error());
$r = mysql_fetch_array($result);
$nd=str_replace('{text}',strshow($r['body']),$nd);
return $nd;
}
function about(){
global $lang,$cf,$tpl;
if ($lang=='vi'){
$sql="SELECT * FROM dg_common WHERE name='about'";
} else{
$sql="SELECT * FROM dg_common WHERE name='about2'";
}
$result=mysql_query($sql) or die('Error: '.mysql_error());
$r = mysql_fetch_array($result);
$nd=str_replace('{text}',strshow($r['body']),$tpl['gioithieu']);
return $nd;
}
function _whoonline(){
global $lang,$cf;
cf($cf['sitedir']."whoonline/guest-".session_id().".txt","o","w");
$ol=glob($cf['sitedir']."whoonline/*.txt");
// print_r($ol);
$g=array();
$k=0;
$j=0;
for ($i=0;$i<count($ol);$i++){
if (file_exists($ol[$i])){
//echo time()- filemtime($ol[$i])."--";
if (time()-filemtime($ol[$i])>300){
unlink($ol[$i]);
} else{
$k++;
}
}
}
return $k;
}
function _dailyhit(){
global $lang,$cf;
cf($cf['sitedir']."dailyhit/".date("Y-m-d",time()+$cf['timeoffset']).".txt","K","a");
$k=@filesize($cf['sitedir']."dailyhit/".date("Y-m-d",time()+$cf['timeoffset']).".txt");
$m=@filesize($cf['sitedir']."dailyhit/max.txt");
if ($m<$k){
cf($cf['sitedir']."dailyhit/max.txt",file_get_contents($cf['sitedir']."dailyhit/".date("Y-m-d",time()+$cf['timeoffset']).".txt"),"w");
}
if ($k<1){$k=1;}
return $k;
}
function _yesterdayhit(){
global $lang,$cf;
$k=@filesize($cf['sitedir']."dailyhit/".date("Y-m-d",(time()+$cf['timeoffset'])-86400).".txt");
if ($k<1){$k=0;}
return $k;
}
function _maxhit(){
global $lang,$cf;
$k=@filesize($cf['sitedir']."dailyhit/max.txt");
if ($k<1){$k=0;}
return $k;
}
function _visitcount(){
global $lang,$db,$tpl,$cf;
createfile("{$cf['sitedir']}visit_count.txt","K","a+");
$nd=number_format(filesize("{$cf['sitedir']}visit_count.txt"),0, ',', '.');
return $nd;
}
function home(){
global $lang,$db,$tpl,$cf;
$t=$tpl['home'];
$newimt=cuttemplate($t,'newim');
$oldimt=cuttemplate($t,'oldim');
$oldt=cuttemplate($t,'old');
$accesst=cuttemplate($t,'access');
$newim='';
$oldim='';
$old='';
$t=str_replace(array($newimt,$oldimt,$oldt,$accesst),'',$t);
// $sql="SELECT * FROM dg_car WHERE nhapkhau=0 ORDER BY id DESC LIMIT {$cf['home']}";
$sql="SELECT * FROM dg_car WHERE nhapkhau=0 AND lang='{$lang}' ORDER BY id DESC LIMIT {$cf['home']}";
$result=mysql_query($sql) or die('Error: '.mysql_error());
while ($r = mysql_fetch_array($result)){
if ($r['img1']==''){
$img=$cf['siteurl'].'images/noimg.jpg';
} else{
$img=$cf['siteurl'].str_replace('carimg/','carimg/thumb_',$r['img1']);
}
if ($lang=='vi'){
if ($r['gia']==0){
$gia=$cf['gia0'];
} elseif ($r['gia']==1){
$gia=$cf['gia1'];
}else{
$gia=number_format($r['gia'],0,',','.');
}
$gia.='<br>LH: '.$r['sodt'];
} else{
if ($r['gia']==0){
$gia=$cf['gia1'];
} elseif ($r['gia']==1){
$gia=$cf['gia1'];
}else{
$gia=number_format($r['gia'],0,',','.');
}
$gia.='<br>CALL: '.$r['sodt'];
}
$newim.=str_replace(array('{id}','{img}','{ten}','{gia}'),array($r['id'],$img,_hangsanxuat($r['hangsx'])." ".$r['ten'],$gia),$newimt);
}
// $sql="SELECT * FROM dg_car WHERE nhapkhau=1 ORDER BY id DESC LIMIT {$cf['home']}";
$sql="SELECT * FROM dg_car WHERE nhapkhau=1 AND lang='{$lang}' ORDER BY id DESC LIMIT {$cf['home']}";
$result=mysql_query($sql) or die('Error: '.mysql_error());
while ($r = mysql_fetch_array($result)){
if ($r['img1']==''){
$img=$cf['siteurl'].'images/noimg.jpg';
} else{
$img=$cf['siteurl'].str_replace('carimg/','carimg/thumb_',$r['img1']);
}
if ($lang=='vi'){
if ($r['gia']==0){
$gia=$cf['gia0'];
} elseif ($r['gia']==1){
$gia=$cf['gia1'];
}else{
$gia=number_format($r['gia'],0,',','.');
}
$gia.='<br>LH: '.$r['sodt'];
} else{
if ($r['gia']==0){
$gia=$cf['gia1'];
} elseif ($r['gia']==1){
$gia=$cf['gia1'];
}else{
$gia=number_format($r['gia'],0,',','.');
}
$gia.='<br>CALL: '.$r['sodt'];
}
$oldim.=str_replace(array('{id}','{img}','{ten}','{gia}'),array($r['id'],$img,_hangsanxuat($r['hangsx'])." ".$r['ten'],$gia),$oldimt);
}
// $sql="SELECT * FROM dg_car WHERE nhapkhau=2 ORDER BY id DESC LIMIT {$cf['home']}";
/*
$sql="SELECT * FROM dg_car WHERE nhapkhau=2 AND lang='{$lang}' ORDER BY id DESC LIMIT {$cf['home']}";
$result=mysql_query($sql) or die('Error: '.mysql_error());
while ($r = mysql_fetch_array($result)){
if ($r['img1']==''){
$img=$cf['siteurl'].'images/noimg.jpg';
} else{
$img=$cf['siteurl'].str_replace('carimg/','carimg/thumb_',$r['img1']);
}
if ($lang=='vi'){
if ($r['gia']==0){
$gia=$cf['gia0'];
} elseif ($r['gia']==1){
$gia=$cf['gia1'];
}else{
$gia=number_format($r['gia'],0,',','.');
}
$gia.='<br>LH: '.$r['sodt'];
} else{
if ($r['gia']==0){
$gia=$cf['gia1'];
} elseif ($r['gia']==1){
$gia=$cf['gia1'];
}else{
$gia=number_format($r['gia'],0,',','.');
}
$gia.='<br>CALL: '.$r['sodt'];
}
$old.=str_replace(array('{id}','{img}','{ten}','{gia}'),array($r['id'],$img,_hangsanxuat($r['hangsx'])." ".$r['ten'],$gia),$oldt);
}
*/
$access='';
$sql="SELECT * FROM dg_accessories WHERE lang='{$lang}' ORDER BY id DESC LIMIT {$cf['home']}";
$result=mysql_query($sql) or die('Error: '.mysql_error());
while ($r = mysql_fetch_array($result)){
if ($r['img']==''){
$img=$cf['siteurl'].'images/noimg.jpg';
} else{
$img=$cf['siteurl'].str_replace('carimg/','carimg/thumb_',$r['img']);
}
if ($lang=='vi'){
if ($r['price']==0){
$gia=$cf['gia0'];
} elseif ($r['price']==1){
$gia=$cf['gia1'];
}else{
$gia=number_format($r['price'],0,',','.');
}
$gia.='<br>LH: '.$r['sodt'];
} else{
if ($r['price']==0){
$gia=$cf['gia1'];
} elseif ($r['price']==1){
$gia=$cf['gia1'];
}else{
$gia=number_format($r['price'],0,',','.');
}
$gia.='<br>CALL: '.$r['sodt'];
}
$access.=str_replace(array('{id}','{img}','{ten}','{gia}'),array($r['id'],$img,$r['title'],$gia),$accesst);
}
$nd=str_replace(array('<!--newim-->','<!--oldim-->','<!--old-->','<!--access-->'),array($newim,$oldim,$old,$access),$t);
return $nd;
}
function product(){
global $lang,$db,$tpl,$cf;
$nd='';
$nd1='';
$sub=@$_GET['sub'];
$page=@$_GET['page'];
$tt=$cf['list'];
switch ($sub){
case 'newim':
$t=$tpl['list2'];
$item=cuttemplate($t,'item');
$t=str_replace($item,'',$t);
$t=str_replace('{sub}','newim',$t);
if ($lang=='en'){
$t=str_replace('{headtitle}','Passenger Car',$t);
} else{
$t=str_replace('{headtitle}','Xe du lịch',$t);
}
if ($page<1){$page=1;}
$sql="SELECT count(id) as total FROM dg_car WHERE nhapkhau=0 AND lang='{$lang}'";
$result=mysql_query($sql) or die('Error: '.mysql_error());
$rw=mysql_fetch_array($result);
$totalPages = (int)(($rw['total']-1)/$tt)+1;
if ($page>$totalPages){$page=$totalPages;}
$numrow=($page-1)*$tt;
if ($numrow<1){$numrow=0;}
$sql="SELECT * FROM dg_car WHERE nhapkhau=0 AND lang='{$lang}' ORDER BY id DESC LIMIT {$numrow},{$tt}";
$result=mysql_query($sql) or die('Error: '.mysql_error());
while ($r = mysql_fetch_array($result)){
if ($r['img1']==''){
$img=$cf['siteurl'].'images/noimg.jpg';
$img1=$cf['siteurl'].'images/noimg.jpg';
} else{
$img=$cf['siteurl'].str_replace('carimg/','carimg/thumb_',$r['img1']);
$img1=$cf['siteurl'].$r['img1'];
}
if ($r['img2']==''){
$img2=$cf['siteurl'].'images/noimg.jpg';
} else{
$img2=$cf['siteurl'].$r['img2'];
}
if ($r['img3']==''){
$img3=$cf['siteurl'].'images/noimg.jpg';
} else{
$img3=$cf['siteurl'].$r['img3'];
}
if ($r['img4']==''){
$img4=$cf['siteurl'].'images/noimg.jpg';
} else{
$img4=$cf['siteurl'].$r['img4'];
}
if ($r['img5']==''){
$img5=$cf['siteurl'].'images/noimg.jpg';
} else{
$img5=$cf['siteurl'].$r['img5'];
}
if ($r['img6']==''){
$img6=$cf['siteurl'].'images/noimg.jpg';
} else{
$img6=$cf['siteurl'].$r['img6'];
}
if ($lang=='vi'){
if ($r['gia']==0){
$gia=$cf['gia0'];
} elseif ($r['gia']==1){
$gia=$cf['gia1'];
}else{
$gia=number_format($r['gia'],0,',','.');
}
} else{
if ($r['gia']==0){
$gia=$cf['gia1'];
} elseif ($r['gia']==1){
$gia=$cf['gia1'];
}else{
$gia=number_format($r['gia'],0,',','.');
}
}
$nd1.=str_replace(array('{id}','{img}','{name}','{hopso}','{xuatxu}','{noiban}','{mausac}','{class}','{gia}','{img1}','{img2}','{img3}','{img4}','{img5}','{img6}'),
array($r['id'],$img,$r['ten'],$r['hopso'],$r['xuatxu'],$r['noiban'],$r['mausac'],$r['xclass'],$gia
,$img1,$img2,$img3,$img4,$img5,$img6),$item);
}
if ($totalPages==1){
$wp='';
} else {
$wp=paging($page,$totalPages,"?act=product&sub=newim&page={page}&lang={$lang}");
}
$nd=str_replace('<!--item-->',$nd1,$t);
$nd=str_replace('<!--page-->',$wp,$nd);
break;
case 'oldim':
$t=$tpl['list2'];
$item=cuttemplate($t,'item');
$t=str_replace($item,'',$t);
$t=str_replace('{sub}','oldim',$t);
if ($lang=='en'){
$t=str_replace('{headtitle}','Commercial Car',$t);
} else{
$t=str_replace('{headtitle}','Xe thương mại',$t);
}
if ($page<1){$page=1;}
$sql="SELECT count(id) as total FROM dg_car WHERE nhapkhau=1 AND lang='{$lang}'";
$result=mysql_query($sql) or die('Error: '.mysql_error());
$rw=mysql_fetch_array($result);
$totalPages = (int)(($rw['total']-1)/$tt)+1;
if ($page>$totalPages){$page=$totalPages;}
$numrow=($page-1)*$tt;
if ($numrow<1){$numrow=0;}
$sql="SELECT * FROM dg_car WHERE nhapkhau=1 AND lang='{$lang}' ORDER BY id DESC LIMIT {$numrow},{$tt}";
$result=mysql_query($sql) or die('Error: '.mysql_error());
while ($r = mysql_fetch_array($result)){
if ($r['img1']==''){
$img=$cf['siteurl'].'images/noimg.jpg';
$img1=$cf['siteurl'].'images/noimg.jpg';
} else{
$img=$cf['siteurl'].str_replace('carimg/','carimg/thumb_',$r['img1']);
$img1=$cf['siteurl'].$r['img1'];
}
if ($r['img2']==''){
$img2=$cf['siteurl'].'images/noimg.jpg';
} else{
$img2=$cf['siteurl'].$r['img2'];
}
if ($r['img3']==''){
$img3=$cf['siteurl'].'images/noimg.jpg';
} else{
$img3=$cf['siteurl'].$r['img3'];
}
if ($r['img4']==''){
$img4=$cf['siteurl'].'images/noimg.jpg';
} else{
$img4=$cf['siteurl'].$r['img4'];
}
if ($r['img5']==''){
$img5=$cf['siteurl'].'images/noimg.jpg';
} else{
$img5=$cf['siteurl'].$r['img5'];
}
if ($r['img6']==''){
$img6=$cf['siteurl'].'images/noimg.jpg';
} else{
$img6=$cf['siteurl'].$r['img6'];
}
if ($lang=='vi'){
if ($r['gia']==0){
$gia=$cf['gia0'];
} elseif ($r['gia']==1){
$gia=$cf['gia1'];
}else{
$gia=number_format($r['gia'],0,',','.');
}
} else{
if ($r['gia']==0){
$gia=$cf['gia1'];
} elseif ($r['gia']==1){
$gia=$cf['gia1'];
}else{
$gia=number_format($r['gia'],0,',','.');
}
}
$nd1.=str_replace(array('{id}','{img}','{name}','{hopso}','{xuatxu}','{noiban}','{mausac}','{class}','{gia}','{img1}','{img2}','{img3}','{img4}','{img5}','{img6}'),
array($r['id'],$img,$r['ten'],$r['hopso'],$r['xuatxu'],$r['noiban'],$r['mausac'],$r['xclass'],$gia
,$img1,$img2,$img3,$img4,$img5,$img6),$item);
}
if ($totalPages==1){
$wp='';
} else {
$wp=paging($page,$totalPages,"?act=product&sub=oldim&page={page}&lang={$lang}");
}
$nd=str_replace('<!--item-->',$nd1,$t);
$nd=str_replace('<!--page-->',$wp,$nd);
break;
case 'old':
$t=$tpl['list2'];
$item=cuttemplate($t,'item');
$t=str_replace($item,'',$t);
$t=str_replace('{sub}','old',$t);
if ($lang=='en'){
$t=str_replace('{headtitle}','Used Car',$t);
} else{
$t=str_replace('{headtitle}','Xe cũ có biển số',$t);
}
if ($page<1){$page=1;}
$sql="SELECT count(id) as total FROM dg_car WHERE nhapkhau=2 AND lang='{$lang}'";
$result=mysql_query($sql) or die('Error: '.mysql_error());
$rw=mysql_fetch_array($result);
$totalPages = (int)(($rw['total']-1)/$tt)+1;
if ($page>$totalPages){$page=$totalPages;}
$numrow=($page-1)*$tt;
if ($numrow<1){$numrow=0;}
$sql="SELECT * FROM dg_car WHERE nhapkhau=2 AND lang='{$lang}' ORDER BY id DESC LIMIT {$numrow},{$tt}";
$result=mysql_query($sql) or die('Error: '.mysql_error());
while ($r = mysql_fetch_array($result)){
if ($r['img1']==''){
$img=$cf['siteurl'].'images/noimg.jpg';
$img1=$cf['siteurl'].'images/noimg.jpg';
} else{
$img=$cf['siteurl'].str_replace('carimg/','carimg/thumb_',$r['img1']);
$img1=$cf['siteurl'].$r['img1'];
}
if ($r['img2']==''){
$img2=$cf['siteurl'].'images/noimg.jpg';
} else{
$img2=$cf['siteurl'].$r['img2'];
}
if ($r['img3']==''){
$img3=$cf['siteurl'].'images/noimg.jpg';
} else{
$img3=$cf['siteurl'].$r['img3'];
}
if ($r['img4']==''){
$img4=$cf['siteurl'].'images/noimg.jpg';
} else{
$img4=$cf['siteurl'].$r['img4'];
}
if ($r['img5']==''){
$img5=$cf['siteurl'].'images/noimg.jpg';
} else{
$img5=$cf['siteurl'].$r['img5'];
}
if ($r['img6']==''){
$img6=$cf['siteurl'].'images/noimg.jpg';
} else{
$img6=$cf['siteurl'].$r['img6'];
}
if ($lang=='vi'){
if ($r['gia']==0){
$gia=$cf['gia0'];
} elseif ($r['gia']==1){
$gia=$cf['gia1'];
}else{
$gia=number_format($r['gia'],0,',','.');
}
} else{
if ($r['gia']==0){
$gia=$cf['gia1'];
} elseif ($r['gia']==1){
$gia=$cf['gia1'];
}else{
$gia=number_format($r['gia'],0,',','.');
}
}
$nd1.=str_replace(array('{id}','{img}','{name}','{hopso}','{xuatxu}','{noiban}','{mausac}','{class}','{gia}','{img1}','{img2}','{img3}','{img4}','{img5}','{img6}'),
array($r['id'],$img,$r['ten'],$r['hopso'],$r['xuatxu'],$r['noiban'],$r['mausac'],$r['xclass'],$gia
,$img1,$img2,$img3,$img4,$img5,$img6),$item);
}
if ($totalPages==1){
$wp='';
} else {
$wp=paging($page,$totalPages,"?act=product&sub=old&page={page}&lang={$lang}");
}
$nd=str_replace('<!--item-->',$nd1,$t);
$nd=str_replace('<!--page-->',$wp,$nd);
break;
case '':
$t=$tpl['list1'];
$item=cuttemplate($t,'item');
$t=str_replace($item,'',$t);
if ($page<1){$page=1;}
$sql="SELECT count(id) as total FROM dg_car WHERE lang='{$lang}'";
$result=mysql_query($sql) or die('Error: '.mysql_error());
$rw=mysql_fetch_array($result);
$totalPages = (int)(($rw['total']-1)/$tt)+1;
if ($page>$totalPages){$page=$totalPages;}
$numrow=($page-1)*$tt;
$sql="SELECT * FROM dg_car WHERE lang='{$lang}' ORDER BY id DESC LIMIT {$numrow},{$tt}";
$result=mysql_query($sql) or die('Error: '.mysql_error());
while ($r = mysql_fetch_array($result)){
if ($r['img1']==''){
$img=$cf['siteurl'].'images/noimg.jpg';
} else{
$img=$cf['siteurl'].str_replace('carimg/','carimg/thumb_',$r['img1']);
}
if ($lang=='vi'){
if ($r['gia']==0){
$gia=$cf['gia0'];
} elseif ($r['gia']==1){
$gia=$cf['gia1'];
}else{
$gia=number_format($r['gia'],0,',','.');
}
} else{
if ($r['gia']==0){
$gia=$cf['gia1'];
} elseif ($r['gia']==1){
$gia=$cf['gia1'];
}else{
$gia=number_format($r['gia'],0,',','.');
}
}
$nd1.=str_replace(array('{id}','{img}','{nhasx}','{loaixe}','{hopso}','{ngaysx}','{mausac}','{km}','{gia}'),
array($r['id'],$img,_hangsanxuat($r['hangsx']),_loaixe($r['mauxe']),$r['hopso'],$r['ngaysx'],$r['mausac'],number_format($r['km'],0,',','.'),$gia),$item);
}
if ($totalPages==1){
$wp='';
} else {
$wp=paging($page,$totalPages,"?act=product&page={page}&lang={$lang}");
}
$nd=str_replace('<!--item-->',$nd1,$t);
$nd=str_replace('<!--page-->',$wp,$nd);
break;
}
return $nd;
}
function _hangsanxuat($id){
global $lang,$db,$tpl,$cf;
$sql="SELECT * FROM dg_corp WHERE id={$id}";
$result=mysql_query($sql) or die('Error: '.mysql_error());
$r = mysql_fetch_array($result);
return $r['name'];
}
function _loaixe($id){
global $lang,$db,$tpl,$cf;
$sql="SELECT * FROM dg_car_name WHERE id={$id}";
$result=mysql_query($sql) or die('Error: '.mysql_error());
$r = mysql_fetch_array($result);
return $r['name'];
}
function view(){
global $lang,$db,$tpl,$cf;
$t=$tpl['chitiet'];
$nd='';
$nd1='';
$id=(int) @ $_GET['id'];
if ($id>0){
$t=$tpl['chitiet'];
$sql="SELECT * FROM dg_car WHERE id={$id}";
$result=mysql_query($sql) or die('Error: '.mysql_error());
$r = mysql_fetch_array($result);
if ($r['id']>0){
if ($r['img1']==''){
$img=$cf['siteurl'].'images/noimg.jpg';
} else{
$img=$cf['siteurl'].$r['img1'];
}
if ($r['img2']==''){
$img2=urlencode($cf['siteurl'].'images/noimg.jpg');
} else{
$img2=$cf['siteurl'].$r['img2'];
}
if ($r['img3']==''){
$img3=$cf['siteurl'].'images/noimg.jpg';
} else{
$img3=$cf['siteurl'].$r['img3'];
}
if ($r['img4']==''){
$img4=$cf['siteurl'].'images/noimg.jpg';
} else{
$img4=$cf['siteurl'].$r['img4'];
}
if ($r['img5']==''){
$img5=$cf['siteurl'].'images/noimg.jpg';
} else{
$img5=$cf['siteurl'].$r['img5'];
}
if ($r['img6']==''){
$img6=$cf['siteurl'].'images/noimg.jpg';
} else{
$img6=$cf['siteurl'].$r['img6'];
}
if ($r['gia']==0){
$gia=$cf['gia0'];
if ($lang=='en'){
$gia=$cf['gia1'];
}
} elseif ($r['gia']==1){
$gia=$cf['gia1'];
}else{
$gia=number_format($r['gia'],0,',','.');
}
$nd=str_replace(array('{id}','{img}','{corp}','{name}','{hopso}','{xuatxu}','{noiban}','{mausac}','{km}','{gia}','{img1}','{img2}','{img3}','{img4}','{img5}','{img6}',
'{vin}','{ngaysx}','{hedandong}','{dungtich}','{nhienlieu}','{congsuat}','{tiennghi}','{kieudandong}','{tieuhaonhienlieu}','{tieuhaonhienlieu2}','{class}'),
array($r['id'],$img,_hangsanxuat($r['hangsx']),$r['ten'],$r['hopso'],$r['xuatxu'],$r['noiban'],$r['mausac'],number_format($r['km'],0,',','.'),$gia
,$img,$img2,$img3,$img4,$img5,$img6,$r['vin'],$r['ngaysx'],$r['hedandong'],$r['dungtich'],
$r['nhienlieu'],$r['congsuat'],strshow($r['tiennghi']),$r['kieudandong'],$r['tieuhaonhienlieu'],$r['tieuhaonhienlieu2'],$r['xclass']
),$t);
$item=cuttemplate($tpl['list1'],'item');
$sql="SELECT * FROM dg_car WHERE id>{$r['id']} AND nhapkhau={$r['nhapkhau']} AND lang='{$lang}' ORDER BY id DESC LIMIT 10";
$result=mysql_query($sql) or die('Error: '.mysql_error());
while ($r1 = mysql_fetch_array($result)){
if ($r1['img1']==''){
$img=$cf['siteurl'].'images/noimg.jpg';
} else{
$img=$cf['siteurl'].str_replace('carimg/','carimg/thumb_',$r1['img1']);
}
if ($r1['gia']==0){
$gia=$cf['gia0'];
if ($lang=='en'){
$gia=$cf['gia1'];
}
} elseif ($r1['gia']==1){
$gia=$cf['gia1'];
}else{
$gia=number_format($r1['gia'],0,',','.');
}
$nd1.=str_replace(array('{id}','{img}','{nhasx}','{loaixe}','{hopso}','{ngaysx}','{mausac}','{km}','{gia}'),
array($r1['id'],$img,_hangsanxuat($r1['hangsx']),_loaixe($r1['mauxe']),$r1['hopso'],$r1['ngaysx'],$r1['mausac'],number_format($r1['km'],0,',','.'),$gia),$item);
}
$sql="SELECT * FROM dg_car WHERE id<{$r['id']} AND nhapkhau={$r['nhapkhau']} AND lang='{$lang}' ORDER BY id DESC LIMIT 10";
$result=mysql_query($sql) or die('Error: '.mysql_error());
while ($r1 = mysql_fetch_array($result)){
if ($r1['img1']==''){
$img=$cf['siteurl'].'images/noimg.jpg';
} else{
$img=$cf['siteurl'].str_replace('carimg/','carimg/thumb_',$r1['img1']);
}
if ($r1['gia']==0){
$gia=$cf['gia0'];
} elseif ($r1['gia']==1){
$gia=$cf['gia1'];
}else{
$gia=number_format($r1['gia'],0,',','.');
}
$nd1.=str_replace(array('{id}','{img}','{nhasx}','{loaixe}','{hopso}','{ngaysx}','{mausac}','{km}','{gia}'),
array($r1['id'],$img,_hangsanxuat($r1['hangsx']),_loaixe($r1['mauxe']),$r1['hopso'],$r1['ngaysx'],$r1['mausac'],number_format($r1['km'],0,',','.'),$gia),$item);
}
$nd=str_replace('<!--item-->',$nd1,$nd);
} else{
$nd=str_replace(array('{headtitle}','{text}'),array('Lỗi','Sản phẩm không tồn tại'),$tpl['box']);
}
} else{
$nd=str_replace(array('{headtitle}','{text}'),array('Lỗi','Sản phẩm không tồn tại'),$tpl['box']);
}
return $nd;
}
function news(){
global $lang,$db,$tpl,$cf;
$sub=@$_GET['sub'];
$cat=(int)@$_GET['cat'];
$page=(int)@$_GET['page'];
if ($sub==''){
if ($cat>0){
$tt=$cf['news'];
$t=$tpl['tintuc'];
$item=cuttemplate($t,'item');
$t=str_replace($item,'',$t);
if ($page<1){$page=1;}
$sql="SELECT count(id) as total FROM dg_news WHERE cat={$cat} AND lang='{$lang}'";
$result=mysql_query($sql) or die('Error: '.mysql_error());
$rw=mysql_fetch_array($result);
$totalPages = (int)(($rw['total']-1)/$tt)+1;
if ($page>$totalPages){$page=$totalPages;}
$numrow=($page-1)*$tt;
$sql="SELECT * FROM dg_news WHERE cat={$cat} AND lang='{$lang}' ORDER BY id DESC LIMIT {$numrow},{$tt}";
$result=mysql_query($sql) or die('Error: '.mysql_error());
while ($r = mysql_fetch_array($result)){
if ($r['thumb']==''){
$img=$cf['siteurl'].'images/noimg.jpg';
} else{
$img=$cf['siteurl'].$r['thumb'];
}
$nd1.=str_replace(array('{id}','{img}','{title}','{date}','{des}'),
array($r['id'],$img,ubfix($r['title']),date("d-m-Y",$r['ndate']),strshow(ubfix($r['des']))),$item);
}
if ($totalPages==1){
$wp='';
} else {
$wp=paging($page,$totalPages,"?act=news&page={page}&lang={$lang}");
if ($cat>0){
$wp=paging($page,$totalPages,"?act=news&cat={$cat}&page={page}&lang={$lang}");
}
}
$nd=str_replace('<!--item-->',$nd1,$t);
$nd=str_replace('<!--page-->',$wp,$nd);
} else{
$t=$tpl['tintuc1'];
$item=cuttemplate($t,'item');
$t=str_replace($item,'',$t);
$sql="SELECT * FROM dg_news_cat WHERE lang='{$lang}' ORDER BY nc_pos";
$result=mysql_query($sql) or die('Error: '.mysql_error());
while ($r = mysql_fetch_array($result)){
$sql2="SELECT * FROM dg_news WHERE cat={$r['ncid']} AND lang='{$lang}' ORDER BY id DESC LIMIT 3";
$result2=mysql_query($sql2) or die('Error: '.mysql_error());
$nd1='';
while ($r2 = mysql_fetch_array($result2)){
if ($r2['thumb']==''){
$img=$cf['siteurl'].'images/noimg.jpg';
} else{
$img=$cf['siteurl'].$r2['thumb'];
}
$nd1.=str_replace(array('{id}','{img}','{title}','{date}','{des}'),
array($r2['id'],$img,$r2['title'],date("d-m-Y",$r2['ndate']),strshow(ubfix($r2['des']))),$item);
}
$nd.=str_replace(array('<!--item-->','{cattitle}','{catlink}'),array($nd1,$r['nc_title'],'?act=news&cat='.$r['ncid']),$t);
}
}
$nd='<div id="table_right">'.$nd.'</div>';
}
if ($sub=='view'){
$id=(int)@$_GET['id'];
$t=$tpl['tinchitiet'];
$sql="SELECT * FROM dg_news WHERE id={$id} AND lang='{$lang}'";
$result=mysql_query($sql) or die('Error: '.mysql_error());
$r = mysql_fetch_array($result);
$nd=str_replace(array('{id}','{img}','{title}','{date}','{body}'),
array($r['id'],'',ubfix($r['title']),date("d-m-Y",$r['ndate']),strshow(ubfix($r['body']))),$t);
$nd=str_replace('<!--morenews-->',morenews($r['id'],$r['cat']),$nd);
}
return $nd;
}
function accessories(){
global $lang,$db,$tpl,$cf;
$nd='';
$nd1='';
$sub=@$_GET['sub'];
$cat=(int)@$_GET['cat'];
$page=(int)@$_GET['page'];
if ($sub==''){
if ($cat>0){
$tt=$cf['list'];
$t=$tpl['aclist'];
$item=cuttemplate($t,'item');
$t=str_replace($item,'',$t);
if ($page<1){$page=1;}
$sql="SELECT count(id) as total FROM dg_accessories WHERE cat={$cat} AND lang='{$lang}'";
$result=mysql_query($sql) or die('Error: '.mysql_error());
$rw=mysql_fetch_array($result);
$totalPages = (int)(($rw['total']-1)/$tt)+1;
if ($page>$totalPages){$page=$totalPages;}
$numrow=($page-1)*$tt;
$sql="SELECT * FROM dg_accessories WHERE cat={$cat} AND lang='{$lang}' ORDER BY id DESC LIMIT {$numrow},{$tt}";
$result=mysql_query($sql) or die('Error: '.mysql_error());
while ($r = mysql_fetch_array($result)){
if ($r['img']==''){
$img=$cf['siteurl'].'images/noimg.jpg';
} else{
$img=$cf['siteurl'].str_replace("carimg/","carimg/thumb_",$r['img']);
}
if ($r['price']==0){
$gia=$cf['gia0'];
if ($lang=='en'){
$gia=$cf['gia1'];
}
} elseif ($r['price']==1){
$gia=$cf['gia1'];
}else{
$gia=number_format($r['price'],0,',','.');
}
$catz=$r['cat'];
$nd1.=str_replace(array('{id}','{img}','{title}','{manufact}','{price}'),
array($r['id'],$img,$r['title'],$r['manufact'],$gia),$item);
}
if ($totalPages==1){
$wp='';
} else {
$wp=paging($page,$totalPages,"?act=accessories&page={page}&lang={$lang}");
if ($cat>0){
$wp=paging($page,$totalPages,"?act=accessories&cat={$cat}&page={page}&lang={$lang}");
}
}
$nd=str_replace(array('<!--page-->','<!--item-->','{cattitle}','{catlink}'),array($wp,$nd1,acccat($catz),'?act=accessories&cat='.$r['id'].'&lang='.$lang),$t);
} else{
$t=$tpl['aclist'];
$item=cuttemplate($t,'item');
$t=str_replace($item,'',$t);
$sql="SELECT * FROM dg_accessories_cat WHERE lang='{$lang}' ORDER BY pos";
$result=mysql_query($sql) or die('Error: '.mysql_error());
while ($r = mysql_fetch_array($result)){
$sql2="SELECT * FROM dg_accessories WHERE cat={$r['id']} AND lang='{$lang}' ORDER BY id DESC LIMIT 3";
$result2=mysql_query($sql2) or die('Error: '.mysql_error());
$nd1='';
while ($r2 = mysql_fetch_array($result2)){
if ($r2['price']==0){
$gia=$cf['gia0'];
if ($lang=='en'){
$gia=$cf['gia1'];
}
} elseif ($r2['price']==1){
$gia=$cf['gia1'];
}else{
$gia=number_format($r2['price'],0,',','.');
}
if ($r2['img']==''){
$img=$cf['siteurl'].'images/noimg.jpg';
} else{
$img=$cf['siteurl'].str_replace("carimg/","carimg/thumb_",$r2['img']);
}
$nd1.=str_replace(array('{id}','{img}','{title}','{manufact}','{price}'),
array($r2['id'],$img,$r2['title'],$r2['manufact'],$gia),$item);
}
$nd.=str_replace(array('<!--item-->','{cattitle}','{catlink}'),array($nd1,$r['title'],'?act=accessories&cat='.$r['id'].'&lang='.$lang),$t);
}
}
$nd='<div id="table_right">'.$nd.'</div>';
}
if ($sub=='view'){
$id=(int)@$_GET['id'];
$t=$tpl['accessories'];
$sql="SELECT * FROM dg_accessories WHERE id={$id} AND lang='{$lang}'";
$result=mysql_query($sql) or die('Error: '.mysql_error());
$r = mysql_fetch_array($result);
if ($lang=='vi'){
$st='Còn hàng';
if ($r['status']==0){
$st='Hết hàng';
}
} else{
$st='In Stock';
if ($r['status']==0){
$st='Sold Out';
}
}
if ($r['price']==0){
$gia=$cf['gia0'];
if ($lang=='en'){
$gia=$cf['gia1'];
}
} elseif ($r['price']==1){
$gia=$cf['gia1'];
}else{
$gia=number_format($r['price'],0,',','.');
}
$nd=str_replace(array('{id}','{img}','{title}','{acode}','{ayear}','{info}','{manufact}','{seller}','{cat}','{status}','{price}'),
array($r['id'],$r['img'],ubfix($r['title']),strshow($r['acode']),strshow($r['ayear']),strshow(ubfix($r['info']))
,strshow($r['manufact']),strshow($r['seller']),acccat($r['cat']),$st,$gia
),$t);
}
return $nd;
}
function morenews($id,$cat){
global $lang,$db,$tpl,$cf;
$nd='<ul>';
$sql="SELECT * FROM dg_news WHERE id>{$id} AND cat={$cat} ORDER BY id DESC LIMIT 5";
$result=mysql_query($sql) or die('Error: '.mysql_error());
while ($r = mysql_fetch_array($result)){
$nd.="<li>• <a href='?act=news&sub=view&id={$r['id']}&lang={$lang}'>{$r['title']}</a></li>";
}
$sql="SELECT * FROM dg_news WHERE id<{$id} AND cat={$cat} ORDER BY id DESC LIMIT 5";
$result=mysql_query($sql) or die('Error: '.mysql_error());
while ($r = mysql_fetch_array($result)){
$nd.="<li>• <a href='?act=news&sub=view&id={$r['id']}&lang={$lang}'>{$r['title']}</a></li>";
}
$nd.='</ul>';
return $nd;
}
function acccat($id){
global $lang,$db,$tpl,$cf;
$sql="SELECT * FROM dg_accessories_cat WHERE id={$id} LIMIT 1";
$result=mysql_query($sql) or die('Error: '.mysql_error());
$r = mysql_fetch_array($result);
return $r['title'];
}
function search(){
global $lang,$db,$tpl,$cf;
$q=safeinput(@$_GET['q']);
$corp=(int)@$_GET['corp'];
$page=(int)@$_GET['page'];
$car_name=(int)@$_GET['car_name'];
$nhapkhau=$_GET['nhapkhau'];
$nhapkhau=$nhapkhau-1;
$namsx=@$_GET['namsx'];
if ($nhapkhau==0){
$nk1='selected';
}
if ($nhapkhau==1){
$nk2='selected';
}
if ($nhapkhau==2){
$nk3='selected';
}
$inp=array('<!--list_corp-->','{q}','{nk1}','{nk2}','{nk3}','{namsx}','<!--mauxe-->');
$outp=array(_listcat($corp),$q,$nk1,$nk2,$nk3,$namsx,_car_name($car_name,$corp));
$t=str_replace($inp,$outp,$tpl['timkiem']);
$item=cuttemplate($t,'item');
$t=str_replace($item,'',$t);
$add='WHERE 1=1 ';
if ($q!=''){
$add.="AND ten LIKE '%{$q}%' ";
}
if ($corp>0){
$add.="AND hangsx ={$corp} ";
}
if ($car_name>0){
$add.="AND mauxe ={$car_name} ";
}
if ($nhapkhau >=0){
$add.="AND nhapkhau ={$nhapkhau} ";
}
if ($namsx){
$add.="AND ngaysx ={$namsx} ";
}
if ($add!='WHERE 1=1 '){
$tt=$cf['list'];
if ($page<1){$page=1;}
$sql="SELECT count(id) as total FROM dg_car {$add}";
$result=mysql_query($sql) or die('Errorq: '.mysql_error());
$rw=mysql_fetch_array($result);
$totalPages = (int)(($rw['total']-1)/$tt)+1;
if ($page>$totalPages){$page=$totalPages;}
$numrow=($page-1)*$tt;
if ($numrow<0){$numrow=0;}
$sql="SELECT * FROM dg_car {$add} ORDER BY id DESC LIMIT {$numrow},{$tt}";
$result=mysql_query($sql) or die('Error: '.mysql_error());
while ($r = mysql_fetch_array($result)){
if ($r['img1']==''){
$img=$cf['siteurl'].'images/noimg.jpg';
} else{
$img=$cf['siteurl'].str_replace('carimg/','carimg/thumb_',$r['img1']);
}
if ($lang=='vi'){
if ($r['gia']==0){
$gia=$cf['gia0'];
} elseif ($r['gia']==1){
$gia=$cf['gia1'];
}else{
$gia=number_format($r['gia'],0,',','.');
}
} else{
if ($r['gia']==0){
$gia=$cf['gia1'];
} elseif ($r['gia']==1){
$gia=$cf['gia1'];
}else{
$gia=number_format($r['gia'],0,',','.');
}
}
$nd1.=str_replace(array('{id}','{img}','{nhasx}','{loaixe}','{hopso}','{ngaysx}','{mausac}','{km}','{gia}'),
array($r['id'],$img,_hangsanxuat($r['hangsx']),_loaixe($r['mauxe']),$r['hopso'],$r['ngaysx'],$r['mausac'],number_format($r['km'],0,',','.'),$gia),$item);
}
if ($totalPages==1){
$wp='';
} else {
$nhapkhau=$nhapkhau+1;
$wp=paging($page,$totalPages,"?act=search&q={$q}&corp={$corp}&nhapkhau={$nhapkhau}&namsx={$namsx}&page={page}&lang={$lang}");
}
}
$nd=str_replace('<!--item-->',$nd1,$t);
$nd=str_replace('<!--page-->',$wp,$nd);
return $nd;
}
function _listcat($id){
global $lang,$cf;
$nd1='';
$sql="Select * from dg_corp ORDER BY pos";
$result=mysql_query($sql) or die('Error: '.mysql_error());
while ($row = mysql_fetch_array($result)){
if ($id==$row['id']){
$nd1.='<option value="'.$row['id'].'" selected>'.$row['name'].'</option>';
} else{
$nd1.='<option value="'.$row['id'].'">'.$row['name'].'</option>';
}
}
return $nd1;
}
function _car_name($id,$corp,$num){
global $lang;
$sql="Select * from dg_car_name WHERE corp={$corp} ORDER BY name";
$result=mysql_query($sql) or die('Error: '.mysql_error());
while ($row = mysql_fetch_array($result)){
$sl='';
if ($id==$row['id']) {$sl=' selected';}
$nd1.='<option value="'.$row['id'].'" '.$sl.'>'.$row['name'].'</option>';
}
if ($lang=='vi'){
$text='Chọn mẫu xe';
} else{
$text='All';
}
if ($nd1!=''){
$nd='<select name="car_name'.$num.'" size="1" style="width:100%; background:#cccccc; text-transform:none;" onchange="loadcar'.$num.'(this[this.selectedIndex].value);">
<option value="">'.$text.'</option>
'.$nd1.'
</select>';
}
return $nd;
}
function _name($idx,$id,$num){
global $lang;
$sql="Select * from dg_car WHERE mauxe={$idx} ORDER BY ten";
$result=mysql_query($sql) or die('Error: '.mysql_error());
while ($row = mysql_fetch_array($result)){
$sl='';
if ($id==$row['id']) {$sl=' selected';}
$nd1.='<option value="'.$row['id'].'" '.$sl.'>'.$row['ten'].'</option>';
}
if ($lang=='vi'){
$text='Chọn xe';
} else{
$text='All';
}
if ($nd1!=''){
$nd='<select name="id'.$num.'" size="1" style="width:100%; background:#cccccc; text-transform:none;">
<option value="">'.$text.'</option>
'.$nd1.'
</select>';
}
return $nd;
}
function _des($id,$t){
if ($id>0){
$sql="Select * from dg_car WHERE id={$id}";
$result=mysql_query($sql) or die('Error: '.mysql_error());
$r = mysql_fetch_array($result);
if ($r['img1']==''){
$img=$cf['siteurl'].'images/noimg.jpg';
} else{
$img=$cf['siteurl'].str_replace('carimg/','carimg/thumb_',$r['img1']);
}
if ($r['gia']==0){
$gia=$cf['gia0'];
} elseif ($r['gia']==1){
$gia=$cf['gia1'];
}else{
$gia=number_format($r['gia'],0,',','.');
}
$inp=array('{id}','{img}','{ten}','{km}','{mausac}','{xuatxu}','{noiban}','{gia}');
$oup=array($r['id'],$img,$r['ten'],$r['km'],$r['mausac'],$r['xuatxu'],$r['noiban'],$gia);
$nd=str_replace($inp,$oup,$t);
}
return $nd;
}
function _spec($id,$t){
if ($id>0){
$sql="Select * from dg_car WHERE id={$id}";
$result=mysql_query($sql) or die('Error: '.mysql_error());
$r = mysql_fetch_array($result);
$inp=array('{dungtich}','{momen}','{congsuat}','{tieuhaonhienlieu}','{tieuhaonhienlieu2}','{tocdotoida}','{tangtoc}');
$oup=array($r['dungtich'],$r['momen'],$r['congsuat'],$r['tieuhaonhienlieu'],$r['tieuhaonhienlieu2'],$r['tocdotoida'],$r['tangtoc']);
$nd=str_replace($inp,$oup,$t);
}
return $nd;
}
function compare(){
global $lang,$db,$tpl,$cf;
$sub=@$_GET['sub'];
$t=$tpl['sosanh'];
$des=cuttemplate($t,'des');
$spec=cuttemplate($t,'spec');
$t=str_replace($des,'',$t);
$t=str_replace($spec,'',$t);
$inp=array('<!--corp1-->','<!--corp2-->','<!--corp3-->','<!--carname1-->','<!--carname2-->','<!--carname3-->',
'<!--name1-->','<!--name2-->','<!--name3-->','<!--des1-->','<!--des2-->','<!--des3-->','<!--spec1-->','<!--spec2-->','<!--spec3-->');
if ($sub!='doit'){
$outp=array(_listcat(0),_listcat(0),_listcat(0),'','','','','','');
} else {
// print_r($_POST);
$corp1=(int)@$_POST['corp1'];
$corp2=(int)@$_POST['corp2'];
$corp3=(int)@$_POST['corp3'];
$car_name1=(int)@$_POST['car_name1'];
$car_name2=(int)@$_POST['car_name2'];
$car_name3=(int)@$_POST['car_name3'];
$id1=(int)@$_POST['id1'];
$id2=(int)@$_POST['id2'];
$id3=(int)@$_POST['id3'];
if ($id1>0){
}
$outp=array(_listcat($corp1),_listcat($corp2),_listcat($corp3),_car_name($car_name1,$corp1,1),_car_name($car_name2,$corp2,2),_car_name($car_name3,$corp3,3),
_name($car_name1,$id1,1),_name($car_name2,$id2,2),_name($car_name3,$id3,3),_des($id1,$des),_des($id2,$des),_des($id3,$des),_spec($id1,$spec),_spec($id2,$spec),_spec($id3,$spec));
}
$nd=str_replace($inp,$outp,$t);
return $nd;
}
function _ym(){
global $lang,$db,$tpl,$cf;
$nd='';
$sql="SELECT * FROM dg_common WHERE name='ym'";
$result=mysql_query($sql) or die('editspec Error: '.mysql_error()."<br>".$sql);
$r = mysql_fetch_array($result);
$ymlist=$r['body'];
$ym=explode("]|[",$ymlist);
for ($i=0;$i<count($ym);$i++){
if ($ym[$i]!=''){
$row=explode("|",$ym[$i]);
$nd.=str_replace(array('{nick}','{skype}','{ten}','{status}','{sodt}'),array($row[0],$row[1],$row[2],checkym($row[0]),$row[3]),$tpl['ym']);
}
}
return $nd;
}
function _skype(){
global $lang,$db,$tpl,$cf;
$nd='';
$sql="SELECT * FROM dg_common WHERE name='skype'";
$result=mysql_query($sql) or die('editspec Error: '.mysql_error()."<br>".$sql);
$r = mysql_fetch_array($result);
$ymlist=$r['body'];
$ym=explode("]|[",$ymlist);
for ($i=0;$i<count($ym);$i++){
if ($ym[$i]!=''){
$row=explode("|",$ym[$i]);
$nd.=str_replace(array('{nick}','{ten}'),array($row[0],$row[1]),$tpl['skype']);
}
}
return $nd;
}
function _newsmenu(){
global $lang,$db,$tpl,$cf;
$nd='';
$sql="SELECT * FROM dg_news_cat WHERE lang='{$lang}' ORDER BY nc_pos";
$result=mysql_query($sql) or die('editspec Error: '.mysql_error()."<br>".$sql);
while ($r = mysql_fetch_array($result)){
$nd.="<li><a href='?act=news&cat={$r['ncid']}&lang={$lang}'>{$r['nc_title']}</a></li>";
}
return $nd;
}
function _lastestnews(){
global $lang,$db,$tpl,$cf;
$nd='';
$sql="SELECT * FROM dg_news WHERE lang='{$lang}' ORDER BY id DESC LIMIT 5";
$result=mysql_query($sql) or die('editspec Error: '.mysql_error()."<br>".$sql);
while ($r = mysql_fetch_array($result)){
$nd.="<li><a href='?act=news&sub=view&id={$r['id']}&lang={$lang}'>{$r['title']}</a></li>";
}
return $nd;
}
function checkym($nick){
global $lang,$db,$tpl,$cf;
/*
$url="http://opi.yahoo.com/online?u={$nick}&t=0&m=a";
$dt=getp($url);
$nd='';
$pos = strpos(' '.$dt.' ', 'NOT ONLINE');
if ($pos === false) {
$nd=$cf['siteurl'].'images/ym_icon.jpg';
} else{
$nd=$cf['siteurl'].'images/ym_icon_off.jpg';
}
*/
$nd=$cf['siteurl'].'images/ym_icon.jpg';
return $nd;
}
function getp($baseurl){
$thiscurl = curl_init();
// Set options
curl_setopt ( $thiscurl, CURLOPT_URL, $baseurl);
curl_setopt ( $thiscurl, CURLOPT_REFERER, 'http://www.carmax.com.vn');
curl_setopt ( $thiscurl, CURLOPT_RETURNTRANSFER, true );
curl_setopt ( $thiscurl, CURLOPT_HEADER, false );
curl_setopt ( $thiscurl, CURLOPT_USERAGENT, $_SERVER['HTTP_USER_AGENT'] );
// Execute request
$result = curl_exec ( $thiscurl );
return $result;
}
function finance(){
global $lang,$db,$tpl,$cf;
$t=$tpl['finance'];
$nd='';
// $nd=$t;
//print_r($_POST);
$tong = (int) @$_POST['tong'];
$tt = (int) @$_POST['tt'];
$vay = @$_POST['vay'];
$vay = str_replace('.','',$vay);
$vay = (int) str_replace(',','',$vay);
$vay1 = $vay;
$thoigian = (int) @$_POST['thoigian'];
$lainam = (int) @$_POST['lainam'];
if ($vay >0 && $thoigian>0 && $lainam>0){
$lai=round(($lainam/12)/100,4);
$tiengoc=(int)round($vay/$thoigian,2);
$nd="
<style>
#abc table, #abc th, #abc td
{
border: 1px solid black;
}
</style>
<table width='100%' celspacing='0' celpadding='0' border='0' bordercolor='#333300' id='abc'>
<tr bgcolor='#a7c942'>
<td width='50' align='center'><b>Tháng</b></td>
<td width='200' align='center'><b>Tiền gốc còn lại</b></td>
<td width='200' align='center'><b>Tiền gốc hàng tháng</b></td>
<td width='200' align='center'><b>Tiền lãi hàng tháng</b></td>
</tr>
";
$tonglai=0;
$laithang=(int)round(($vay)*$lai,2);
for ($i=0;$i<$thoigian;$i++){
$j=$i+1;
$nd.="<tr height='20'>";
$nd.="<td align='center'>{$j}</td>";
$nd.="<td align='center'>".number_format($vay,0,"",".")."</td>";
$nd.="<td align='center'>".number_format($tiengoc,0,"",".")."</td>";
$nd.="<td align='center'>".number_format($laithang,0,"",".")."</td>";
$nd.="</tr>";
$vay=$vay-$tiengoc;
$tonglai+=$laithang;
$laithang=(int)round(($vay)*$lai,2);
}
$nd.="
<tr bgcolor='#a7c942'>
<td width='50' align='center'><b>Tổng cộng</b></td>
<td width='200' align='center'></td>
<td width='200' align='center'><b>".number_format($vay1,0,"",".")."</b></td>
<td width='200' align='center'><b>".number_format($tonglai,0,"",".")."</b></td>
</tr>
</table>";
} else{
$nd="
<style>
#abc table, #abc th, #abc td
{
border: 1px solid black;
}
</style>
<table width='100%' celspacing='0' celpadding='0' border='0' bordercolor='#333300' id='abc'>
<tr bgcolor='#a7c942'>
<td width='50' align='center'><b>Tháng</b></td>
<td width='200' align='center'><b>Tiền gốc còn lại</b></td>
<td width='200' align='center'><b>Tiền gốc hàng tháng</b></td>
<td width='200' align='center'><b>Tiền lãi hàng tháng</b></td>
</tr>
";
$nd.="
<tr bgcolor='#a7c942'>
<td width='50' align='center'><b>Tổng cộng</b></td>
<td width='200' align='center'></td>
<td width='200' align='center'></td>
<td width='200' align='center'></td>
</tr>
</table>";
}
$nd=str_replace('{text}',$nd,$t);
return $nd;
}
function _userpanel(){
global $lang,$db,$tpl,$cf;
if (@$_SESSION['userin']==1){
} else{
$nd=$tpl['userlogout'];
}
return $nd;
}
/**
* Mobile funtions
*/
function m_home(){
global $lang,$db,$tpl,$cf;
$nd='';
$newim='';
$newim2='';
$newim3='';
$t=$tpl['home'];
$p=cuttemplate($t,'p');
$t=str_replace($p,'',$t);
$it=cuttemplate($p,'it');
$p=str_replace($it,'',$p);
$sql="SELECT * FROM dg_car WHERE nhapkhau=0 AND lang='{$lang}' ORDER BY id DESC LIMIT 2";
$result=mysql_query($sql) or die('Error: '.mysql_error());
while ($r = mysql_fetch_array($result)){
if ($r['img1']==''){
$img=$cf['siteurl'].'images/noimg.jpg';
} else{
$img=$cf['siteurl'].str_replace('carimg/','carimg/thumb_',$r['img1']);
}
if ($lang=='vi'){
if ($r['gia']==0){
$gia=$cf['gia0'];
} elseif ($r['gia']==1){
$gia=$cf['gia1'];
}else{
$gia=number_format($r['gia'],0,',','.');
}
} else{
if ($r['gia']==0){
$gia=$cf['gia1'];
} elseif ($r['gia']==1){
$gia=$cf['gia1'];
}else{
$gia=number_format($r['gia'],0,',','.');
}
}
$newim.=str_replace(array('{id}','{img}','{name}','{price}'),array($r['id'],$img,_hangsanxuat($r['hangsx'])." ".$r['ten'],$gia),$it);
}
$p1=str_replace('<!--it-->',$newim,$p);
$p1=str_replace('{suba}','ni',$p1);
if ($lang=='vi'){
$p1=str_replace('{ctitle}','Xe du lịch',$p1);
} else{
$p1=str_replace('{ctitle}','Passenger Car',$p1);
}
$sql="SELECT * FROM dg_car WHERE nhapkhau=1 AND lang='{$lang}' ORDER BY id DESC LIMIT 2";
$result=mysql_query($sql) or die('Error: '.mysql_error());
while ($r = mysql_fetch_array($result)){
if ($r['img1']==''){
$img=$cf['siteurl'].'images/noimg.jpg';
} else{
$img=$cf['siteurl'].str_replace('carimg/','carimg/thumb_',$r['img1']);
}
if ($lang=='vi'){
if ($r['gia']==0){
$gia=$cf['gia0'];
} elseif ($r['gia']==1){
$gia=$cf['gia1'];
}else{
$gia=number_format($r['gia'],0,',','.');
}
} else{
if ($r['gia']==0){
$gia=$cf['gia1'];
} elseif ($r['gia']==1){
$gia=$cf['gia1'];
}else{
$gia=number_format($r['gia'],0,',','.');
}
}
$newim2.=str_replace(array('{id}','{img}','{name}','{price}'),array($r['id'],$img,_hangsanxuat($r['hangsx'])." ".$r['ten'],$gia),$it);
}
$p2=str_replace('<!--it-->',$newim2,$p);
$p2=str_replace('{suba}','oi',$p2);
if ($lang=='vi'){
$p2=str_replace('{ctitle}','Xe thương mại',$p2);
} else{
$p2=str_replace('{ctitle}','Commercial Car',$p2);
}
$sql="SELECT * FROM dg_car WHERE nhapkhau=0 AND lang='{$lang}' ORDER BY id DESC LIMIT 2";
$result=mysql_query($sql) or die('Error: '.mysql_error());
while ($r = mysql_fetch_array($result)){
if ($r['img1']==''){
$img=$cf['siteurl'].'images/noimg.jpg';
} else{
$img=$cf['siteurl'].str_replace('carimg/','carimg/thumb_',$r['img1']);
}
if ($lang=='vi'){
if ($r['gia']==0){
$gia=$cf['gia0'];
} elseif ($r['gia']==1){
$gia=$cf['gia1'];
}else{
$gia=number_format($r['gia'],0,',','.');
}
} else{
if ($r['gia']==0){
$gia=$cf['gia1'];
} elseif ($r['gia']==1){
$gia=$cf['gia1'];
}else{
$gia=number_format($r['gia'],0,',','.');
}
}
$newim3.=str_replace(array('{id}','{img}','{name}','{price}'),array($r['id'],$img,_hangsanxuat($r['hangsx'])." ".$r['ten'],$gia),$it);
}
$p3=str_replace('<!--it-->',$newim3,$p);
$p3=str_replace('{suba}','o',$p3);
if ($lang=='vi'){
$p3=str_replace('{ctitle}','Xe cũ có biển số',$p3);
} else{
$p3=str_replace('{ctitle}','Used Car',$p3);
}
$nd=str_replace('<!--p-->',$p1.$p2.$p3,$t);
return $nd;
}
function m_view(){
global $lang,$db,$tpl,$cf;
$t=$tpl['view'];
$id=(int) @ $_GET['id'];
if ($id>0){
$t=$tpl['view'];
$sql="SELECT * FROM dg_car WHERE id={$id}";
$result=mysql_query($sql) or die('Error: '.mysql_error());
$r = mysql_fetch_array($result);
if ($r['img1']==''){
$img=$cf['siteurl'].'images/noimg.jpg';
} else{
$img=$cf['siteurl'].$r['img1'];
}
if ($r['gia']==0){
$gia=$cf['gia0'];
if ($lang=='en'){
$gia=$cf['gia1'];
}
} elseif ($r['gia']==1){
$gia=$cf['gia1'];
}else{
$gia=number_format($r['gia'],0,',','.');
}
$nd=str_replace(array('{id}','{img}','{corp}','{name}','{hopso}','{xuatxu}','{noiban}','{mausac}','{km}','{gia}',
'{vin}','{ngaysx}','{hedandong}','{dungtich}','{nhienlieu}','{congsuat}','{tiennghi}','{kieudandong}','{tieuhaonhienlieu}','{tieuhaonhienlieu2}','{class}'),
array($r['id'],$img,_hangsanxuat($r['hangsx']),$r['ten'],$r['hopso'],$r['xuatxu'],$r['noiban'],$r['mausac'],number_format($r['km'],0,',','.'),$gia
,$r['vin'],$r['ngaysx'],$r['hedandong'],$r['dungtich'],
$r['nhienlieu'],$r['congsuat'],strshow($r['tiennghi']),$r['kieudandong'],$r['tieuhaonhienlieu'],$r['tieuhaonhienlieu2'],$r['xclass']
),$t);
} else{
if ($lang=='vi'){
$nd='Sản phẩm không tồn tại.';
} else {
$nd='Product not found.';
}
}
return $nd;
}
function strshow($String)
{
return str_replace('<','<',
str_replace('>','>',
str_replace('\'\'','\'',
str_replace('\'\'','\\\'',
str_replace('"','\"',trim($String))))));
}
?>| .. | |||||
| 1functions.php | |||||
| common.php | |||||
| functions.php | |||||
| thumbnail.class.php |