index.php

城市分类信息,门户网站,我做为地方信息网

<?php



define('CURSCRIPT', 'index');

require_once '../include/common.php';



if( (!@include_once '../webdata/cache/cache_indexdianp.php') || ($timestamp - $expiration > $webindexdianp) )
{

$contents = "\r\n\n\$indexDianpCache = array\r\n(\r\n";

$query = $DB->query("SELECT c.*, t.*, b.biz_name,u.username, u.face FROM {$tablepre}comment as c LEFT JOIN {$tablepre}users as u ON u.uid=c.uid LEFT JOIN {$tablepre}bizpoint as t ON  t.bizid=c.bizid AND t.uid=u.uid LEFT JOIN {$tablepre}bizinfo as b ON b.bizid=c.bizid   ORDER BY cmtid DESC LIMIT 0, 10");

while($rs = $DB->fetch_array($query)) {
	$rs['dateline'] = date('Y-m-d H:i:s', $rs['dateline']);
	$rs['point'] = round(($rs['a']+$rs['b']+$rs['c']) / 30 * 5);
	$rs['a'] = $rs['a'] / 2;
	$rs['b'] = $rs['b'] / 2;
	$rs['c'] = $rs['c'] / 2;
	$rs['content'] = addslashes(cutstr($rs['content'], 108));
	$rs['face'] = $rs['face'] ? "../webdata/userface/" . $rs['face'] : '../images/common/head_no.gif';
	$contents .= " array('cmtid'=>'$rs[cmtid]', 'biz_name'=>'".addslashes($rs[biz_name])."', 'username'=>'".addslashes($rs[username])."', 'uid'=>'$rs[uid]', 'a'=>'$rs[a]', 
										'b'=>'$rs[b]', 'c'=>'$rs[c]', 'point'=>'$rs[point]', 'face'=>'$rs[face]', 'bizid'=>'$rs[bizid]',
										'content'=>'$rs[content]', 'good'=>'$rs[good]', 'bad'=>'$rs[bad]'), \r\n";
	
}

	$contents .= ");";
	$contents = preg_replace('/(.+?),/Us', '\\1\\2', $contents);

	$cachefile = FLY_ROOT . "/webdata/cache/cache_indexdianp.php";
	if($fp = @fopen($cachefile, 'wb')) {
		@fwrite($fp, "<?php\r\nif(!defined('IN_FLY')) exit('Access Denied');\r\n\n\$expiration='".(time())."';\r\n".$contents."\r\n?>");
		@fclose($fp);
		@chmod($cachefile, 0777);
	} else {
		echo 'Can not write to cache files, please check directory ./cache/ .';
		exit;
	}
}


include_once FLY_ROOT . '/webdata/cache/cache_bizcate.php';

foreach($_FCACHE['bizsort']  as $key => $var) {
	$var[2] = $key;
	$bizsort_list[$var[0]][] = $var;
}



//淇℃伅鍒嗙被
$query = $DB->query("SELECT * FROM {$tablepre}fleicate ORDER BY cid ASC");
while($rs = $DB->fetch_array($query)) {
	$fleicate_all_list[] = $rs;	
}

foreach($fleicate_all_list as $var) {
	if($var['fup'] == '0') {
		$fleicate_list[] = $var;
	} else {
		$fleisort_list[$var[fup]][] = $var;
	}
}

//鏈