}

}

}

else

{

$addField = ”;

$addJoin = ”;

}
//如果不用默认的sortrank或id排序，使用联合查询（数据量大时非常缓慢）

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查询（速度非常快）

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;
}

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

$this->dsql->Execute(‘al’);

$t2 = ExecTime();
//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’];
//处理一些特殊字段

$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’];

}
if($row[‘corank’] > 0 && $row[‘arcrank’]==0)

{

$row[‘arcrank’] = $row[‘corank’];

}
$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’]);