index.php

这个版本只是修正了一些BUG

<?php
/**********************************************
   	index.php  -  首页程序

	Version  : 1.2
	Author   : Tracemouse ([e-mail])
	Copyright: http://www.vitci.com
	Writed   : 2003/08/08
	Modified : 2004/04/17
***********************************************/
 
require "./include/base.php";
require "./include/catalog.php";
require "./include/vote.php";

//======== 取友情连接和合作站点信息 ==================================
/*
$linklist='';
$linknum=0;
$query = $db->query("SELECT * FROM $table_weblinks WHERE type = 'link'");
$flink = array();
while($dbq_rec = $db->fetch_array($query))
{
	$linklist=$linklist.'<a href='.$dbq_rec['url'].' target=_blanket>';
	$linklist=$linklist.'<img border=0 src='.$dbq_rec['logo'].'></a>&nbsp;';
  	$flink[] = $dbq_rec;
  	$linknum = $linknum + 1;
}
unset($dbq_rec);unset($query);

$allynum=0;
$allylist = array();
$query = $db->query("SELECT * FROM $table_weblinks WHERE type = 'ally'");
while($dbq_rec = $db->fetch_array($query))
{
    $allylist[] = $dbq_rec;
    $allynum ++;
}
unset($query);unset($dbq_rec);
*/

//======== 取公告信息 ================================================
$query = $db->query("SELECT COUNT(*) FROM $table_bulletins");
$bulletinnum = $db->result($query, 0);
$bulletinlist = array();
$query = $db->query("SELECT * FROM $table_bulletins");
while($dbq_rec = $db->fetch_array($query))
{
    $bulletinlist[] = $dbq_rec;
}
unset($query);unset($dbq_rec);

//======= 取商品类别列表 ==================================================
if (empty($sortlist)){ 
        $sortlist=array(); 
        $sortlist=getsortlist(); 
}

//======= 取推荐商品信息 =================================================
$query = $db->query("SELECT * FROM $table_recommend");
$recomlist=array();
$recomnum=0;
while($dbq_rec = $db->fetch_array($query))
{
	$recomnum++;
	$dbq_rec[words]=nl2br($dbq_rec['words']);
	$dbq_rec[img]=empty($dbq_rec['img'])?IMGDIR.'/noimg.gif':$dbq_rec['img'];
	$recomlist[]=$dbq_rec;
}
unset($query);unset($dbq_rec);

$query = $db->query("SELECT * FROM $table_recommend where sid > 0 limit 0,5");
$plinelist=array();
while($dbq_rec = $db->fetch_array($query))
{
  	$ispline = 1;
  	$dbq_rec['img']=empty($dbq_rec['img'])?IMGDIR.'/noimg.gif':$dbq_rec['img'];
  	$plinelist[]=$dbq_rec;
}
unset($query);unset($dbq_rec);

//======== 取最新上架商品 ======================================================
$query = $db->query("SELECT * FROM $table_products ORDER BY posttime DESC LIMIT 0,10");
$newproductlist = array();
$bgcolor=ALTBG1;
$newproductnum=0;
while($dbq_rec = $db->fetch_array($query))
{
	if ($bgcolor==ALTBG1)
  		$bgcolor=ALTBG2;
  	elseif($bgcolor==ALTBG2)
  		$bgcolor=ALTBG1;
  	$dbq_rec['bgcolor']=$bgcolor;
  	$dbq_rec['img']=empty($dbq_rec['smallimg'])?IMGDIR.'/noimg.gif':$dbq_rec['smallimg'];
  	$dbq_rec['notes']=substr($dbq_rec['notes'] , 0, 35) . " ...";
  	$dbq_rec['save']=$dbq_rec['marketprice'] - $dbq_rec['ourprice'];
  	$dbq_rec['save']=number_format($dbq_rec['save'], 2);
  	$dbq_rec['postdate']=gmdate($dateformat,$dbq_rec['posttime']);
  	$newproductlist[]=$dbq_rec;
    	$newproductnum=$newproductnum+1;
}
unset($query);unset($dbq_rec);

//======= 取热门商品 ============================================================
$query = $db->query("SELECT * FROM $table_products ORDER BY viewtimes DESC LIMIT 0,10");
$hotproductlist = array();
$bgcolor=ALTBG1;
while($dbq_rec = $db->fetch_array($query))
{
	if ($bgcolor==ALTBG1) $bgcolor=ALTBG2;
	elseif($bgcolor==ALTBG2) $bgcolor=ALTBG1;
  	$dbq_rec['bgcolor']=$bgcolor;
  	$dbq_rec['img']=empty($dbq_rec['smallimg'])?IMGDIR.'/noimg.gif':$dbq_rec['smallimg'];
  	$dbq_rec['notes']=substr($dbq_rec['notes'] , 0, 35) . " ...";
  	$dbq_rec['save']=$dbq_rec['marketprice'] - $dbq_rec['ourprice'];
  	$dbq_rec['save']=number_format($dbq_rec['save'], 2);
  	$dbq_rec['postdate']=gmdate($dateformat,$dbq_rec['posttime']);
  	$hotproductlist[]=$dbq_rec;
}
unset($query);unset($dbq_rec);

//========== 取当月日历信息 ======================================

$tr_calendar=getdatewin($today[mon],$today[mday],$today[year]);


//========= 取会员数据  ============================================
if($islogin)
{
 	$query = $db->query("SELECT count(*) from $table_favorite where username='$_login_user'");
 	$favnum=$db->result($query,0);
 	$query = $db->query("SELECT count(*) from $table_basket where username='$_login_user' and oid='picking'");
 	$basketnum=$db->result($query,0);
 	$query = $db->query("SELECT count(*) from $table_orders where username='$_login_user'");
 	$ordernum=$db->result($query,0);
 	$query=$db->query("SELECT count(*) from $table_pm WHERE msgto='$_login_user'");
 	$pmnum=$db->result($query,0);
}

// changed by tracemosue in 2004.3.17.
//======== 取底部帮助信息 ===========================================
/*
$query = $db->query("SELECT * FROM $table_guide WHERE id = supid ORDER BY sid");
$guidelist=array();
while($dbq_rec = $db->fetch_array($query))
{
    $dbq_rec['issort'] = 1;
    $guidelist[]=$dbq_rec;
    $sql="SELECT * FROM ".$table_guide." WHERE id<>supid AND supid=".$dbq_rec['id']." ORDER BY sid LIMIT 0,4";
    $query1=$db->query($sql);
    while($dbq_rec1 = $db->fetch_array($query1))
    {
     $dbq_rec1['issort'] = 0;
     $guidelist[]=$dbq_rec1;
    }

}
unset($dbq_rec);unset($dbq_rec1);unset($query1);unset($query);
*/

$sort_select=getsortselect();

if  ($isiclbbs)
{
	$bbs_hotthreads_list=$bbs->get_hotthreads($db,10);
	$bbs_newthreads_list=$bbs->get_newthreads($db,10);
}

$nav .=SEPARATER.$language['nav_homepage'];
include template('index');
?>