本文介紹了dedecms實(shí)現(xiàn)讓列表標(biāo)簽不調(diào)用有推薦屬性文章的方法，大家參考使用吧

修改include/arc.listview.class.php，以下是修改后的文件

代碼如下:

<?php if(!defined('DEDEINC')) exit('Request Error!');</p> <p>require_once(DEDEINC.'/arc.partview.class.php');

require_once(DEDEINC.'/ftp.class.php');</p> <p>helper('cache');

@set_time_limit(0);</p> <p>

class ListView

{

var $dsql;

var $dtp;

var $dtp2;

var $TypeID;

var $TypeLink;

var $PageNo;

var $TotalPage;

var $TotalResult;

var $PageSize;

var $ChannelUnit;

var $ListType;

var $Fields;

var $PartView;

var $upPageType;

var $addSql;

var $IsError;

var $CrossID;

var $IsReplace;

var $ftp;

var $remoteDir;

var $Noflag; 

function __construct($typeid, $uppage=1)

{

global $dsql,$ftp;

$this->TypeID = $typeid;

$this->dsql = &$dsql;

$this->CrossID = '';

$this->IsReplace = false;

$this->IsError = false;

$this->dtp = new DedeTagParse();

$this->dtp->SetRefObj($this);

$this->dtp->SetNameSpace("dede", "{", "}");

$this->dtp2 = new DedeTagParse();

$this->dtp2->SetNameSpace("field","[","]");

$this->TypeLink = new TypeLink($typeid);

$this->upPageType = $uppage;

$this->ftp = &$ftp;

$this->remoteDir = '';

$this->TotalResult = is_numeric($this->TotalResult)? $this->TotalResult : "";

if(!is_array($this->TypeLink->TypeInfos))

{

$this->IsError = true;

}

if(!$this->IsError)

{

$this->ChannelUnit = new ChannelUnit($this->TypeLink->TypeInfos['channeltype']);

$this->Fields = $this->TypeLink->TypeInfos;

$this->Fields['id'] = $typeid;

$this->Fields['position'] = $this->TypeLink->GetPositionLink(true);

$this->Fields['title'] = preg_replace("/[<>]/", " / ", $this->TypeLink->GetPositionLink(false));

//設(shè)置一些全局參數(shù)的值

foreach($GLOBALS['PubFields'] as $k=>$v) $this->Fields[$k] = $v;

$this->Fields['rsslink'] = $GLOBALS['cfg_cmsurl']."/data/rss/".$this->TypeID.".xml";</p> <p>//設(shè)置環(huán)境變量

SetSysEnv($this->TypeID,$this->Fields['typename'],0,'','list');

$this->Fields['typeid'] = $this->TypeID;</p> <p>//獲得交叉欄目ID

if($this->TypeLink->TypeInfos['cross']>0 && $this->TypeLink->TypeInfos['ispart']==0)

{

$selquery = '';

if($this->TypeLink->TypeInfos['cross']==1)

{

$selquery = "SELECT id,topid FROM `dede_arctype` WHERE typename LIKE '{$this->Fields['typename']}' AND id<>'{$this->TypeID}' AND topid<>'{$this->TypeID}' ";

}

else

{

$this->Fields['crossid'] = preg_replace('/[^0-9,]/', '', trim($this->Fields['crossid']));

if($this->Fields['crossid']!='')

{

$selquery = "SELECT id,topid FROM `dede_arctype` WHERE id in({$this->Fields['crossid']}) AND id<>{$this->TypeID} AND topid<>{$this->TypeID} ";

}

}

if($selquery!='')

{

$this->dsql->SetQuery($selquery);

$this->dsql->Execute();

while($arr = $this->dsql->GetArray())

{

$this->CrossID .= ($this->CrossID=='' ? $arr['id'] : ','.$arr['id']);

}

}

}

}//!error

}</p> <p>//php4構(gòu)造函數(shù)

function ListView($typeid,$uppage=0){

$this->__construct($typeid,$uppage);

}

//關(guān)閉相關(guān)資源

function Close()

{ }

function CountRecord()

{

global $cfg_list_son,$cfg_need_typeid2,$cfg_cross_sectypeid;

if(empty($cfg_need_typeid2)) $cfg_need_typeid2 = 'N';

//統(tǒng)計(jì)數(shù)據(jù)庫記錄

$this->TotalResult = -1;

if(isset($GLOBALS['TotalResult'])) $this->TotalResult = $GLOBALS['TotalResult'];

if(isset($GLOBALS['PageNo'])) $this->PageNo = $GLOBALS['PageNo'];

else $this->PageNo = 1;

$this->addSql = " arc.arcrank > -1 ";

$typeid2like = " '%,{$this->TypeID},%' ";

if($cfg_list_son=='N')

{

if($cfg_need_typeid2=='N')

{

if($this->CrossID=='') $this->addSql .= " AND (arc.typeid='".$this->TypeID."') ";

else $this->addSql .= " AND (arc.typeid in({$this->CrossID},{$this->TypeID})) ";

}

else

{

if($this->CrossID=='')

{

$this->addSql .= " AND ( (arc.typeid='".$this->TypeID."') OR CONCAT(',', arc.typeid2, ',') LIKE $typeid2like) ";

} else {

if($cfg_cross_sectypeid == 'Y')

{

$typeid2Clike = " '%,{$this->CrossID},%' ";

$this->addSql .= " AND ( arc.typeid IN({$this->CrossID},{$this->TypeID}) OR CONCAT(',', arc.typeid2, ',') LIKE $typeid2like OR CONCAT(',', arc.typeid2, ',') LIKE $typeid2Clike)";

} else {

$this->addSql .= " AND ( arc.typeid IN({$this->CrossID},{$this->TypeID}) OR CONCAT(',', arc.typeid2, ',') LIKE $typeid2like)";

}

}

}

}

else

{

$sonids = GetSonIds($this->TypeID,$this->Fields['channeltype']);

if(!preg_match("/,/", $sonids)) {

$sonidsCon = " arc.typeid = '$sonids' ";

}

else {

$sonidsCon = " arc.typeid IN($sonids) ";

}

if($cfg_need_typeid2=='N')

{

if($this->CrossID=='') $this->addSql .= " AND ( $sonidsCon ) ";

else $this->addSql .= " AND ( arc.typeid IN ({$sonids},{$this->CrossID}) ) ";

}

else

{

if($this->CrossID=='')

{

$this->addSql .= " AND ( $sonidsCon OR CONCAT(',', arc.typeid2, ',') like $typeid2like ) ";

} else {

if($cfg_cross_sectypeid == 'Y')

{

$typeid2Clike = " '%,{$this->CrossID},%' ";

$this->addSql .= " AND ( arc.typeid IN ({$sonids},{$this->CrossID}) OR CONCAT(',', arc.typeid2, ',') LIKE $typeid2like OR CONCAT(',', arc.typeid2, ',') LIKE $typeid2Clike) ";

} else {

$this->addSql .= " AND ( arc.typeid IN ({$sonids},{$this->CrossID}) OR CONCAT(',', arc.typeid2, ',') LIKE $typeid2like) ";

}

}

}

}

if($this->TotalResult==-1)

{

$cquery = "SELECT COUNT(*) AS dd FROM `dede_arctiny` arc WHERE ".$this->addSql;

$row = $this->dsql->GetOne($cquery);

if(is_array($row))

{

$this->TotalResult = $row['dd'];

}

else

{

$this->TotalResult = 0;

}

}</p> <p>//初始化列表模板，并統(tǒng)計(jì)頁面總數(shù)

$tempfile = $GLOBALS['cfg_basedir'].$GLOBALS['cfg_templets_dir']."/".$this->TypeLink->TypeInfos['templist'];

$tempfile = str_replace("{tid}", $this->TypeID, $tempfile);

$tempfile = str_replace("{cid}", $this->ChannelUnit->ChannelInfos['nid'], $tempfile);

if(!file_exists($tempfile))

{

$tempfile = $GLOBALS['cfg_basedir'].$GLOBALS['cfg_templets_dir']."/".$GLOBALS['cfg_df_style']."/list_default.htm";

}

if(!file_exists($tempfile)||!is_file($tempfile))

{

echo "模板文件不存在，無法解析文檔！";

exit();

}

$this->dtp->LoadTemplate($tempfile);

$ctag = $this->dtp->GetTag("page");

if(!is_object($ctag))

{

$ctag = $this->dtp->GetTag("list");

}

if(!is_object($ctag))

{

$this->PageSize = 20;

}

else

{

if($ctag->GetAtt("pagesize")!="")

{

$this->PageSize = $ctag->GetAtt("pagesize");

}

else

{

$this->PageSize = 20;

}

}

$this->TotalPage = ceil($this->TotalResult/$this->PageSize);

}

function MakeHtml($startpage=1, $makepagesize=0, $isremote=0)

{

global $cfg_remote_site;

if(empty($startpage))

{

$startpage = 1;

}</p> <p>//創(chuàng)建封面模板文件

if($this->TypeLink->TypeInfos['isdefault']==-1)

{

echo '這個類目是動態(tài)類目！';

return '../plus/list.php?tid='.$this->TypeLink->TypeInfos['id'];

}</p> <p>//單獨(dú)頁面

else if($this->TypeLink->TypeInfos['ispart']>0)

{

$reurl = $this->MakePartTemplets();

return $reurl;

}</p> <p>$this->CountRecord();

//初步給固定值的標(biāo)記賦值

$this->ParseTempletsFirst();

$totalpage = ceil($this->TotalResult/$this->PageSize);

if($totalpage==0)

{

$totalpage = 1;

}

CreateDir(MfTypedir($this->Fields['typedir']));

$murl = '';

if($makepagesize > 0)

{

$endpage = $startpage+$makepagesize;

}

else

{

$endpage = ($totalpage+1);

}

if( $endpage >= $totalpage+1 )

{

$endpage = $totalpage+1;

}

if($endpage==1)

{

$endpage = 2;

}

for($this->PageNo=$startpage; $this->PageNo < $endpage; $this->PageNo++)

{

$this->ParseDMFields($this->PageNo,1);

$makeFile = $this->GetMakeFileRule($this->Fields['id'],'list',$this->Fields['typedir'],'',$this->Fields['namerule2']);

$makeFile = str_replace("{page}", $this->PageNo, $makeFile);

$murl = $makeFile;

if(!preg_match("/^\//", $makeFile))

{

$makeFile = "/".$makeFile;

}

$makeFile = $this->GetTruePath().$makeFile;

$makeFile = preg_replace("/\/{1,}/", "/", $makeFile);

$murl = $this->GetTrueUrl($murl);

$this->dtp->SaveTo($makeFile);

//如果啟用遠(yuǎn)程發(fā)布則需要進(jìn)行判斷

if($cfg_remote_site=='Y'&& $isremote == 1)

{

//分析遠(yuǎn)程文件路徑

$remotefile = str_replace(DEDEROOT, '',$makeFile);

$localfile = '..'.$remotefile;

$remotedir = preg_replace('/[^\/]*\.html/', '',$remotefile);

//不相等則說明已經(jīng)切換目錄則可以創(chuàng)建鏡像

$this->ftp->rmkdir($remotedir);

$this->ftp->upload($localfile, $remotefile, 'acii');

}

}

if($startpage==1)

{

//如果列表啟用封面文件，復(fù)制這個文件第一頁

if($this->TypeLink->TypeInfos['isdefault']==1

&& $this->TypeLink->TypeInfos['ispart']==0)

{

$onlyrule = $this->GetMakeFileRule($this->Fields['id'],"list",$this->Fields['typedir'],'',$this->Fields['namerule2']);

$onlyrule = str_replace("{page}","1",$onlyrule);

$list_1 = $this->GetTruePath().$onlyrule;

$murl = MfTypedir($this->Fields['typedir']).'/'.$this->Fields['defaultname'];

//如果啟用遠(yuǎn)程發(fā)布則需要進(jìn)行判斷

if($cfg_remote_site=='Y'&& $isremote == 1)

{

//分析遠(yuǎn)程文件路徑

$remotefile = $murl;

$localfile = '..'.$remotefile;

$remotedir = preg_replace('/[^\/]*\.html/', '',$remotefile);

//不相等則說明已經(jīng)切換目錄則可以創(chuàng)建鏡像

$this->ftp->rmkdir($remotedir);

$this->ftp->upload($localfile, $remotefile, 'acii');

}

$indexname = $this->GetTruePath().$murl;

copy($list_1,$indexname);

}

}

return $murl;

}</p> <p>function Display()

{

if($this->TypeLink->TypeInfos['ispart']>0)

{

$this->DisplayPartTemplets();

return ;

}

$this->CountRecord();

if((empty($this->PageNo) || $this->PageNo==1)

&& $this->TypeLink->TypeInfos['ispart']==1)

{

$tmpdir = $GLOBALS['cfg_basedir'].$GLOBALS['cfg_templets_dir'];

$tempfile = str_replace("{tid}",$this->TypeID,$this->Fields['tempindex']);

$tempfile = str_replace("{cid}",$this->ChannelUnit->ChannelInfos['nid'],$tempfile);

$tempfile = $tmpdir."/".$tempfile;

if(!file_exists($tempfile))

{

$tempfile = $tmpdir."/".$GLOBALS['cfg_df_style']."/index_default.htm";

}

$this->dtp->LoadTemplate($tempfile);

}

$this->ParseTempletsFirst();

$this->ParseDMFields($this->PageNo,0);

$this->dtp->Display();

} 

function MakePartTemplets()

{

$this->PartView = new PartView($this->TypeID,false);

$this->PartView->SetTypeLink($this->TypeLink);

$nmfa = 0;

$tmpdir = $GLOBALS['cfg_basedir'].$GLOBALS['cfg_templets_dir'];

if($this->Fields['ispart']==1)

{

$tempfile = str_replace("{tid}",$this->TypeID,$this->Fields['tempindex']);

$tempfile = str_replace("{cid}",$this->ChannelUnit->ChannelInfos['nid'],$tempfile);

$tempfile = $tmpdir."/".$tempfile;

if(!file_exists($tempfile))

{

$tempfile = $tmpdir."/".$GLOBALS['cfg_df_style']."/index_default.htm";

}

$this->PartView->SetTemplet($tempfile);

}

else if($this->Fields['ispart']==2)

{

//跳轉(zhuǎn)網(wǎng)址

return $this->Fields['typedir'];

}

CreateDir(MfTypedir($this->Fields['typedir']));

$makeUrl = $this->GetMakeFileRule($this->Fields['id'],"index",MfTypedir($this->Fields['typedir']),$this->Fields['defaultname'],$this->Fields['namerule2']);

$makeUrl = preg_replace("/\/{1,}/", "/", $makeUrl);

$makeFile = $this->GetTruePath().$makeUrl;

if($nmfa==0)

{

$this->PartView->SaveToHtml($makeFile);

//如果啟用遠(yuǎn)程發(fā)布則需要進(jìn)行判斷

if($GLOBALS['cfg_remote_site']=='Y'&& $isremote == 1)

{

//分析遠(yuǎn)程文件路徑

$remotefile = str_replace(DEDEROOT, '',$makeFile);

$localfile = '..'.$remotefile;

$remotedir = preg_replace('/[^\/]*\.html/', '',$remotefile);

//不相等則說明已經(jīng)切換目錄則可以創(chuàng)建鏡像

$this->ftp->rmkdir($remotedir);

$this->ftp->upload($localfile, $remotefile, 'acii');

}

}

else

{

if(!file_exists($makeFile))

{

$this->PartView->SaveToHtml($makeFile);

//如果啟用遠(yuǎn)程發(fā)布則需要進(jìn)行判斷

if($cfg_remote_site=='Y'&& $isremote == 1)

{

//分析遠(yuǎn)程文件路徑

$remotefile = str_replace(DEDEROOT, '',$makeFile);

$localfile = '..'.$remotefile;

$remotedir = preg_replace('/[^\/]*\.html/', '',$remotefile);

//不相等則說明已經(jīng)切換目錄則可以創(chuàng)建鏡像

$this->ftp->rmkdir($remotedir);

$this->ftp->upload($localfile, $remotefile, 'acii');

}

}

}

return $this->GetTrueUrl($makeUrl);

}</p> <p> 

function DisplayPartTemplets()

{

$this->PartView = new PartView($this->TypeID,false);

$this->PartView->SetTypeLink($this->TypeLink);

$nmfa = 0;

$tmpdir = $GLOBALS['cfg_basedir'].$GLOBALS['cfg_templets_dir'];

if($this->Fields['ispart']==1)

{

//封面模板

$tempfile = str_replace("{tid}",$this->TypeID,$this->Fields['tempindex']);

$tempfile = str_replace("{cid}",$this->ChannelUnit->ChannelInfos['nid'],$tempfile);

$tempfile = $tmpdir."/".$tempfile;

if(!file_exists($tempfile))

{

$tempfile = $tmpdir."/".$GLOBALS['cfg_df_style']."/index_default.htm";

}

$this->PartView->SetTemplet($tempfile);

}

else if($this->Fields['ispart']==2)

{

//跳轉(zhuǎn)網(wǎng)址

$gotourl = $this->Fields['typedir'];

header("Location:$gotourl");

exit();

}

CreateDir(MfTypedir($this->Fields['typedir']));

$makeUrl = $this->GetMakeFileRule($this->Fields['id'],"index",MfTypedir($this->Fields['typedir']),$this->Fields['defaultname'],$this->Fields['namerule2']);

$makeFile = $this->GetTruePath().$makeUrl;

if($nmfa==0)

{

$this->PartView->Display();

}

else

{

if(!file_exists($makeFile))

{

$this->PartView->Display();

}

else

{

include($makeFile);

}

}

}</p> <p> 

function GetTruePath()

{

$truepath = $GLOBALS["cfg_basedir"];

return $truepath;

}</p> <p> 

function GetTrueUrl($nurl)

{

if($this->Fields['moresite']==1)

{

if($this->Fields['sitepath']!='')

{

$nurl = preg_replace("/^".$this->Fields['sitepath']."/", '', $nurl);

}

$nurl = $this->Fields['siteurl'].$nurl;

}

return $nurl;

}</p> <p> 

function ParseTempletsFirst()

{

if(isset($this->TypeLink->TypeInfos['reid']))

{

$GLOBALS['envs']['reid'] = $this->TypeLink->TypeInfos['reid'];

}

$GLOBALS['envs']['typeid'] = $this->TypeID;

$GLOBALS['envs']['topid'] = GetTopid($this->Fields['typeid']);

$GLOBALS['envs']['cross'] = 1;

MakeOneTag($this->dtp,$this);

}</p> <p> 

function ParseDMFields($PageNo,$ismake=1)

{

//替換第二頁后的內(nèi)容

if(($PageNo>1 || strlen($this->Fields['content'])<10 ) && !$this->IsReplace)

{

$this->dtp->SourceString = str_replace('[cmsreplace]','display:none',$this->dtp->SourceString);

$this->IsReplace = true;

}

foreach($this->dtp->CTags as $tagid=>$ctag)

{

if($ctag->GetName()=="list")

{

$limitstart = ($this->PageNo-1) * $this->PageSize;

$row = $this->PageSize;

if(trim($ctag->GetInnerText())=="")

{

$InnerText = GetSysTemplets("list_fulllist.htm");

}

else

{

$InnerText = trim($ctag->GetInnerText());

}

$this->dtp->Assign($tagid,

$this->GetArcList(

$limitstart,

$row,

$ctag->GetAtt("col"),

$ctag->GetAtt("titlelen"),

$ctag->GetAtt("infolen"),

$ctag->GetAtt("imgwidth"),

$ctag->GetAtt("imgheight"),

$ctag->GetAtt("listtype"),

$ctag->GetAtt("orderby"),

$InnerText,

$ctag->GetAtt("tablewidth"),

$ismake,

$ctag->GetAtt("orderway"),

$ctag->GetAtt("noflag")

)

);

}

else if($ctag->GetName()=="pagelist")

{

$list_len = trim($ctag->GetAtt("listsize"));

$ctag->GetAtt("listitem")=="" ? $listitem="index,pre,pageno,next,end,option" : $listitem=$ctag->GetAtt("listitem");

if($list_len=="")

{

$list_len = 3;

}

if($ismake==0)

{

$this->dtp->Assign($tagid,$this->GetPageListDM($list_len,$listitem));

}

else

{

$this->dtp->Assign($tagid,$this->GetPageListST($list_len,$listitem));

}

}

else if($PageNo!=1 && $ctag->GetName()=='field' && $ctag->GetAtt('display')!='')

{

$this->dtp->Assign($tagid,'');

}

}

}</p> <p> 

function GetMakeFileRule($typeid,$wname,$typedir,$defaultname,$namerule2)

{

$typedir = MfTypedir($typedir);

if($wname=='index')

{

return $typedir.'/'.$defaultname;

}

else

{

$namerule2 = str_replace('{tid}',$typeid,$namerule2);

$namerule2 = str_replace('{typedir}',$typedir,$namerule2);

return $namerule2;

}

}</p> <p> 

function GetArcList($limitstart=0,$row=10,$col=1,$titlelen=30,$infolen=250,

$imgwidth=120,$imgheight=90,$listtype="all",$orderby="default",$innertext="",$tablewidth="100",$ismake=1,$orderWay='desc',$noflag='')

{

global $cfg_list_son,$cfg_digg_update;

$noflags = explode(',', $noflag);

$noflagsql = '';

for($i=0;$i<count($noflags);$i++)

{

$noflagsql .= "And arc.flag not like '%{$noflags[$i]}%' ";

} 

$typeid=$this->TypeID;

if($row=='') $row = 10;

if($limitstart=='') $limitstart = 0;

if($titlelen=='') $titlelen = 100;

if($infolen=='') $infolen = 250;

if($imgwidth=='') $imgwidth = 120;

if($imgheight=='') $imgheight = 120;

if($listtype=='') $listtype = 'all';

if($orderWay=='') $orderWay = 'desc';

if($orderby=='') {

$orderby='default';

}

else {

$orderby=strtolower($orderby);

}

$tablewidth = str_replace('%','',$tablewidth);

if($tablewidth=='') $tablewidth=100;

if($col=='') $col=1;

$colWidth = ceil(100/$col);

$tablewidth = $tablewidth.'%';

$colWidth = $colWidth.'%';

$innertext = trim($innertext);

if($innertext=='') {

$innertext = GetSysTemplets('list_fulllist.htm');

}</p> <p>//排序方式

$ordersql = '';

if($orderby=="senddate" || $orderby=="id") {

$ordersql=" ORDER BY arc.id $orderWay";

}

else if($orderby=="hot" || $orderby=="click") {

$ordersql = " ORDER BY arc.click $orderWay";

}

else if($orderby=="lastpost") {

$ordersql = " ORDER BY arc.lastpost $orderWay";

}

else {

$ordersql=" ORDER BY arc.sortrank $orderWay";

}</p> <p>//獲得附加表的相關(guān)信息

$addtable = $this->ChannelUnit->ChannelInfos['addtable'];

if($addtable!="")

{

$addJoin = " LEFT JOIN `$addtable` ON arc.id = ".$addtable.'.aid ';

$addField = '';

$fields = explode(',',$this->ChannelUnit->ChannelInfos['listfields']);

foreach($fields as $k=>$v)

{

$nfields[$v] = $k;

}

if(is_array($this->ChannelUnit->ChannelFields) && !empty($this->ChannelUnit->ChannelFields))

{

foreach($this->ChannelUnit->ChannelFields as $k=>$arr)

{

if(isset($nfields[$k]))

{

if(!empty($arr['rename'])) {

$addField .= ','.$addtable.'.'.$k.' as '.$arr['rename'];

}

else {

$addField .= ','.$addtable.'.'.$k;

}

}

}

}

}

else

{

$addField = '';

$addJoin = '';

}</p> <p>//如果不用默認(rèn)的sortrank或id排序，使用聯(lián)合查詢（數(shù)據(jù)量大時非常緩慢）

if(preg_match('/hot|click|lastpost/', $orderby))

{

$query = "Select arc.*,tp.typedir,tp.typename,tp.isdefault,tp.defaultname,

tp.namerule,tp.namerule2,tp.ispart,tp.moresite,tp.siteurl,tp.sitepath

$addField

from `dede_archives` arc

left join `dede_arctype` tp on arc.typeid=tp.id

$addJoin

where {$this->addSql} $noflagsql $ordersql limit $limitstart,$row";

}

//普通情況先從arctiny表查出ID，然后按ID查詢（速度非?？欤?/P>

else

{

$numquery = "Select id From `dede_archives` arc where {$this->addSql} $noflagsql $ordersql";

$this->dsql->SetQuery($numquery);

$this->dsql->Execute();

while($arr=$this->dsql->GetArray())

{

$fuck[] = $arr['id'];

}

$this->TotalResult = count($fuck);

$t1 = ExecTime();

$ids = array();

$query = "Select id From `dede_archives` arc where {$this->addSql} $noflagsql $ordersql limit $limitstart,$row ";

$this->dsql->SetQuery($query);

$this->dsql->Execute();

while($arr=$this->dsql->GetArray())

{

$ids[] = $arr['id'];

}

$idstr = join(',',$ids);

if($idstr=='')

{

return '';

}

else

{

$query = "Select arc.*,tp.typedir,tp.typename,tp.corank,tp.isdefault,tp.defaultname,

tp.namerule,tp.namerule2,tp.ispart,tp.moresite,tp.siteurl,tp.sitepath

$addField

from `dede_archives` arc left join `dede_arctype` tp on arc.typeid=tp.id

$addJoin

where arc.id in($idstr) $noflagsql $ordersql ";

}

$t2 = ExecTime();

//echo $t2-$t1;</p> <p>}

$this->dsql->SetQuery($query);

$this->dsql->Execute('al');

$t2 = ExecTime();</p> <p>//echo $t2-$t1;

$artlist = '';

$this->dtp2->LoadSource($innertext);

$GLOBALS['autoindex'] = 0;

for($i=0;$i<$row;$i++)

{

if($col>1)

{

$artlist .= "<div>\r\n";

}

for($j=0;$j<$col;$j++)

{

if($row = $this->dsql->GetArray("al"))

{

$GLOBALS['autoindex']++;

$ids[$row['id']] = $row['id'];</p> <p>//處理一些特殊字段

$row['infos'] = cn_substr($row['description'],$infolen);

$row['id'] = $row['id'];

if($cfg_digg_update > 0)

{

$prefix = 'diggCache';

$key = 'aid-'.$row['id'];

$cacherow = GetCache($prefix, $key);

$row['goodpost'] = $cacherow['goodpost'];

$row['badpost'] = $cacherow['badpost'];

$row['scores'] = $cacherow['scores'];

}</p> <p>if($row['corank'] > 0 && $row['arcrank']==0)

{

$row['arcrank'] = $row['corank'];

}</p> <p>$row['filename'] = $row['arcurl'] = GetFileUrl($row['id'],$row['typeid'],$row['senddate'],$row['title'],$row['ismake'],

$row['arcrank'],$row['namerule'],$row['typedir'],$row['money'],$row['filename'],$row['moresite'],$row['siteurl'],$row['sitepath']);

$row['typeurl'] = GetTypeUrl($row['typeid'],MfTypedir($row['typedir']),$row['isdefault'],$row['defaultname'],

$row['ispart'],$row['namerule2'],$row['moresite'],$row['siteurl'],$row['sitepath']);

if($row['litpic'] == '-' || $row['litpic'] == '')

{

$row['litpic'] = $GLOBALS['cfg_cmspath'].'/images/defaultpic.gif';

}

if(!preg_match("/^http:\/\//i", $row['litpic']) && $GLOBALS['cfg_multi_site'] == 'Y')

{

$row['litpic'] = $GLOBALS['cfg_mainsite'].$row['litpic'];

}

$row['picname'] = $row['litpic'];

$row['stime'] = GetDateMK($row['pubdate']);

$row['typelink'] = "<a href='".$row['typeurl']."'>".$row['typename']."</a>";

$row['image'] = "<img src='".$row['picname']."' border='0' width='$imgwidth' height='$imgheight' alt='".preg_replace("/['><]/", "", $row['title'])."'>";

$row['imglink'] = "<a href='".$row['filename']."'>".$row['image']."</a>";

$row['fulltitle'] = $row['title'];

$row['title'] = cn_substr($row['title'],$titlelen);

if($row['color']!='')

{

$row['title'] = "<font color='".$row['color']."'>".$row['title']."</font>";

}

if(preg_match('/c/', $row['flag']))

{

$row['title'] = "<b>".$row['title']."</b>";

}

$row['textlink'] = "<a href='".$row['filename']."'>".$row['title']."</a>";

$row['plusurl'] = $row['phpurl'] = $GLOBALS['cfg_phpurl'];

$row['memberurl'] = $GLOBALS['cfg_memberurl'];

$row['templeturl'] = $GLOBALS['cfg_templeturl'];</p> <p>//編譯附加表里的數(shù)據(jù)

foreach($row as $k=>$v)

{

$row[strtolower($k)] = $v;

}

foreach($this->ChannelUnit->ChannelFields as $k=>$arr)

{

if(isset($row[$k]))

{

$row[$k] = $this->ChannelUnit->MakeField($k,$row[$k]);

}

}

if(is_array($this->dtp2->CTags))

{

foreach($this->dtp2->CTags as $k=>$ctag)

{

if($ctag->GetName()=='array')

{

//傳遞整個數(shù)組，在runphp模式中有特殊作用

$this->dtp2->Assign($k,$row);

}

else

{

if(isset($row[$ctag->GetName()]))

{

$this->dtp2->Assign($k,$row[$ctag->GetName()]);

}

else

{

$this->dtp2->Assign($k,'');

}

}

}

}

$artlist .= $this->dtp2->GetResult();

}//if hasRow</p> <p>}//Loop Col</p> <p>if($col>1)

{

$i += $col - 1;

$artlist .= "</div>\r\n";

}

}//Loop Line</p> <p>$t3 = ExecTime();</p> <p>//echo ($t3-$t2);

$this->dsql->FreeResult('al');

return $artlist;

}

function GetPageListST($list_len,$listitem="index,end,pre,next,pageno")

{

$prepage = $nextpage = '';

$prepagenum = $this->PageNo-1;

$nextpagenum = $this->PageNo+1;

if($list_len=='' || preg_match("/[^0-9]/", $list_len))

{

$list_len=3;

}

$totalpage = ceil($this->TotalResult/$this->PageSize);

if($totalpage<=1 && $this->TotalResult>0)

{</p> <p>return "<li><span class=\"pageinfo\">共 <strong>1</strong>頁<strong>".$this->TotalResult."</strong>條記錄</span></li>\r\n";

}

if($this->TotalResult == 0)

{

return "<li><span class=\"pageinfo\">共 <strong>0</strong>頁<strong>".$this->TotalResult."</strong>條記錄</span></li>\r\n";

}

$purl = $this->GetCurUrl();

$maininfo = "<li><span class=\"pageinfo\">共 <strong>{$totalpage}</strong>頁<strong>".$this->TotalResult."</strong>條</span></li>\r\n";

$tnamerule = $this->GetMakeFileRule($this->Fields['id'],"list",$this->Fields['typedir'],$this->Fields['defaultname'],$this->Fields['namerule2']);

$tnamerule = preg_replace("/^(.*)\//", '', $tnamerule);</p> <p>//獲得上一頁和主頁的鏈接

if($this->PageNo != 1)

{

$prepage.="<li><a href='".str_replace("{page}",$prepagenum,$tnamerule)."'>上一頁</a></li>\r\n";

$indexpage="<li><a href='".str_replace("{page}",1,$tnamerule)."'>首頁</a></li>\r\n";

}

else

{

$indexpage="<li>首頁</li>\r\n";

}</p> <p>//下一頁,未頁的鏈接

if($this->PageNo!=$totalpage && $totalpage>1)

{

$nextpage.="<li><a href='".str_replace("{page}",$nextpagenum,$tnamerule)."'>下一頁</a></li>\r\n";

$endpage="<li><a href='".str_replace("{page}",$totalpage,$tnamerule)."'>末頁</a></li>\r\n";

}

else

{

$endpage="<li>末頁</li>\r\n";

}</p> <p>//option鏈接

$optionlist = '';</p> <p>$optionlen = strlen($totalpage);

$optionlen = $optionlen*12 + 18;

if($optionlen < 36) $optionlen = 36;

if($optionlen > 100) $optionlen = 100;

$optionlist = "<li><select name='sldd' style='width:{$optionlen}px' onchange='location.href=this.options[this.selectedIndex].value;'>\r\n";

for($mjj=1;$mjj<=$totalpage;$mjj++)

{

if($mjj==$this->PageNo)

{

$optionlist .= "<option value='".str_replace("{page}",$mjj,$tnamerule)."' selected>$mjj</option>\r\n";

}

else

{

$optionlist .= "<option value='".str_replace("{page}",$mjj,$tnamerule)."'>$mjj</option>\r\n";

}

}

$optionlist .= "</select></li>\r\n";</p> <p>//獲得數(shù)字鏈接

$listdd="";

$total_list = $list_len * 2 + 1;

if($this->PageNo >= $total_list)

{

$j = $this->PageNo-$list_len;

$total_list = $this->PageNo+$list_len;

if($total_list>$totalpage)

{

$total_list=$totalpage;

}

}

else

{

$j=1;

if($total_list>$totalpage)

{

$total_list=$totalpage;

}

}

for($j;$j<=$total_list;$j++)

{

if($j==$this->PageNo)

{

$listdd.= "<li class=\"thisclass\">$j</li>\r\n";

}

else

{

$listdd.="<li><a href='".str_replace("{page}",$j,$tnamerule)."'>".$j."</a></li>\r\n";

}

}

$plist = '';

if(preg_match('/index/i', $listitem)) $plist .= $indexpage;

if(preg_match('/pre/i', $listitem)) $plist .= $prepage;

if(preg_match('/pageno/i', $listitem)) $plist .= $listdd;

if(preg_match('/next/i', $listitem)) $plist .= $nextpage;

if(preg_match('/end/i', $listitem)) $plist .= $endpage;

if(preg_match('/option/i', $listitem)) $plist .= $optionlist;

if(preg_match('/info/i', $listitem)) $plist .= $maininfo;

return $plist;

}

function GetPageListDM($list_len,$listitem="index,end,pre,next,pageno")

{

global $cfg_rewrite;

$prepage = $nextpage = '';

$prepagenum = $this->PageNo-1;

$nextpagenum = $this->PageNo+1;

if($list_len=='' || preg_match("/[^0-9]/", $list_len))

{

$list_len=3;

}

$totalpage = ceil($this->TotalResult/$this->PageSize);

if($totalpage<=1 && $this->TotalResult>0)

{

return "<li><span class=\"pageinfo\">共 1 頁/".$this->TotalResult." 條記錄</span></li>\r\n";

}

if($this->TotalResult == 0)

{

return "<li><span class=\"pageinfo\">共 0 頁/".$this->TotalResult." 條記錄</span></li>\r\n";

}

$maininfo = "<li><span class=\"pageinfo\">共 <strong>{$totalpage}</strong>頁<strong>".$this->TotalResult."</strong>條</span></li>\r\n";

$purl = $this->GetCurUrl();

// 如果開啟為靜態(tài),則對規(guī)則進(jìn)行替換

if($cfg_rewrite == 'Y')

{

$nowurls = preg_replace("/\-/", ".php?", $purl);

$nowurls = explode("?", $nowurls);

$purl = $nowurls[0];

}</p> <p>$geturl = "tid=".$this->TypeID."&TotalResult=".$this->TotalResult."&";

$purl .= '?'.$geturl;

$optionlist = '';

//$hidenform = "<input type='hidden' name='tid' value='".$this->TypeID."'>\r\n";

//$hidenform .= "<input type='hidden' name='TotalResult' value='".$this->TotalResult."'>\r\n";</p> <p>//獲得上一頁和下一頁的鏈接

if($this->PageNo != 1)

{

$prepage.="<li><a href='".$purl."PageNo=$prepagenum'>上一頁</a></li>\r\n";

$indexpage="<li><a href='".$purl."PageNo=1'>首頁</a></li>\r\n";

}

else

{

$indexpage="<li><a>首頁</a></li>\r\n";

}

if($this->PageNo!=$totalpage && $totalpage>1)

{

$nextpage.="<li><a href='".$purl."PageNo=$nextpagenum'>下一頁</a></li>\r\n";

$endpage="<li><a href='".$purl."PageNo=$totalpage'>末頁</a></li>\r\n";

}

else

{

$endpage="<li><a>末頁</a></li>\r\n";

}

//獲得數(shù)字鏈接

$listdd="";

$total_list = $list_len * 2 + 1;

if($this->PageNo >= $total_list)

{

$j = $this->PageNo-$list_len;

$total_list = $this->PageNo+$list_len;

if($total_list>$totalpage)

{

$total_list=$totalpage;

}

}

else

{

$j=1;

if($total_list>$totalpage)

{

$total_list=$totalpage;

}

}

for($j;$j<=$total_list;$j++)

{

if($j==$this->PageNo)

{

$listdd.= "<li class=\"thisclass\"><a>$j</a></li>\r\n";

}

else

{

$listdd.="<li><a href='".$purl."PageNo=$j'>".$j."</a></li>\r\n";

}

}

$plist = '';

if(preg_match('/index/i', $listitem)) $plist .= $indexpage;

if(preg_match('/pre/i', $listitem)) $plist .= $prepage;

if(preg_match('/pageno/i', $listitem)) $plist .= $listdd;

if(preg_match('/next/i', $listitem)) $plist .= $nextpage;

if(preg_match('/end/i', $listitem)) $plist .= $endpage;

if(preg_match('/option/i', $listitem)) $plist .= $optionlist;

if(preg_match('/info/i', $listitem)) $plist .= $maininfo;

if($cfg_rewrite == 'Y')

{

$plist = str_replace('.php?tid=', '-', $plist);

$plist = str_replace('&TotalResult=', '-', $plist);

$plist = preg_replace("/&PageNo=(\d+)/i",'-\\1.html',$plist);

}

return $plist;

}

function GetCurUrl()

{

if(!empty($_SERVER['REQUEST_URI']))

{

$nowurl = $_SERVER['REQUEST_URI'];

$nowurls = explode('?', $nowurl);

$nowurl = $nowurls[0];

}

else

{

$nowurl = $_SERVER['PHP_SELF'];

}

return $nowurl;

}

}//End Class