}

//普通情况先从arctiny表查出ID，然后按ID查询（速度非常快）

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>//编译附加表里的数据

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’)

{

//传递整个数组，在runphp模式中有特殊作用

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

}

else

{