showts.php

采用模块化设计,自由组合文章,软件,论坛等模块,安装方便快捷 模板支持Dreamweaver可视化编辑,创建风格更为容易,专业

<?php

if (!defined('ROOT'))
    exit('Access Denied');
$db = db::getinstance();
$ts = array();
$fid = intval($_GET['fid']);
$cid=intval($_GET['cid']);
($cid<1 || $cid>5) && $cid=0;


$fdata = read_table('forum_lists', 'order by zu,xu');
call_func('forum_pv');
$pv = forum_pv($fid);
empty($pv['p2']) && e('鏃犳潈杩涘叆');
$fpage = ($_t = abs(intval($_GET['fpage']))) ? $_t : 1;
$top_ts = array();
if ($fpage < 2 && $cid<1)
{
    $i = 1000;
    if (false == ($top_ts = read_cache(MOD.'_showts_top_' . $fid, 10)))
    {
        $top_ts = array();
        $result = $db->query("select a.*,b.* from " . PF .
            "forum_titles as a LEFT JOIN " . PF .
            "center_titles as b on a.tid=b.tid where a.fid='$fid' && a.f_top>0 && b.lid<1 order by a.etime desc");
        while ($row = $db->fetch_array($result))
        {
            $top_ts[$row['tid']] = $row;
            $top_ts[$row['tid']]['s'] = 1000;
        }
        write_cache(MOD.'_showts_top_' . $fid, $top_ts);
    }
}

$dpage = intval($conf['forum'][3]);
//$dpage =2;
if($cid<1){
$mpage = $fdata[$fid]['titles'] - count($top_ts);
$spage = ($fpage - 1) * $dpage;
$result = $db->query("select a.*,b.* from " . PF .
    "forum_titles as a LEFT JOIN " . PF .
    "center_titles as b on a.tid=b.tid where a.fid='$fid' && a.f_top<1 && b.lid<1 order by a.etime desc LIMIT $spage,$dpage");
	
	}else{

$spage = ($fpage - 1) * $dpage;
$cl_sql='cl_'.$cid.'=1';
$result = $db->query("select a.*,b.* from " . PF .
    "forum_titles as a LEFT JOIN " . PF .
    "center_titles as b on a.tid=b.tid where a.fid='$fid' && $cl_sql && b.lid<1 order by a.etime desc LIMIT $spage," .
    ($dpage + 1));

$mpage = $fpage * $dpage + ($db->num_rows($result) > $dpage ? 1 : 0);
$i = 1;
}
	
while (($row = array_shift($top_ts)) || ($row = $db->fetch_array($result)))
{
	if ($cid>0 && $i++ > $dpage)  break;
    $ts[$row['tid']] = $row;
	$ts[$row['tid']]['author'] = html($row['author']);
    $ts[$row['tid']]['lastauthor'] = html($row['lastauthor']);
    $ts[$row['tid']]['authorid'] = html($row['authorid']);
    $ts[$row['tid']]['tid'] = html($row['tid']);    
    $ts[$row['tid']]['lastptime'] = dtime($row['lastptime']);
    $ts[$row['tid']]['ptime'] = dtime($row['ptime']);
    $ts[$row['tid']]['title'] = html($row['title']);
    $ts[$row['tid']]['reply'] = html($row['reply']);    
}
call_class('page');
$subpages = new page($dpage, $mpage, $fpage, 10, '?mod=forum&file=showts&fid=' .
    $fid . '&cid='.$cid.'&fpage=', $cid>0?false:true);
$pages = $subpages->pages;

$head_title = $fdata[$fid]['name'] . ' - ' . modname('forum');
$head_description = @strip_tags($fdata[$fid]['c']);

$cla=array(0=>$tpl['鏄剧ず鍏ㄩ儴']);
	for($i=1;$i<6;$i++){
	!empty($fdata[$fid]['cl_'.$i]) && $cla[$i]=$fdata[$fid]['cl_'.$i];	
	}

?>