dede栏目用idlist='自定义字段' 调用指定id文章
发表时间：2018-09-05 17:29 责任编辑：莫都晨晓 浏览：
次
我们都知道dede可以利用idlist='1'调用文章id为1的文章，但是很多朋友知道dede默认的 idlist='' 只能手动填写，不能后台调用。我们利用{dede:arclist idlist='自定义字段'}这种形式的调用方法是不可以实现的。
今天我就整理了一下如何利用 {dede:arclist idlist='自定义字段'} 随机调用自定义文章。实现了这个功能后，栏目可以随意调用任意文章，只需要在后台栏目相应位置填写一下你要调用的文章id号即可。
言归正传
首先我们需要在栏目里创建一个类似于相关文章的字段（这里方便你以后填写想要调用的文章id）
这个很简单：我们可以参考https://blog.csdn.net/langyu1021/article/details/52460660
下面是关键：
下面要实现的是让{dede:arclist idlist='自定义字段'}生效，我们需要修改include\taglib下的arclist.lib.php文件
修改后的代码为（或直接联系QQ286601999，索要arclist.lib.php文件，替换即可）
<?php if(!defined('DEDEINC')) exit('Request Error!');
/**
* 文章列表调用标记
*
* 9:19 2010年7月13日:修正对isweight属性的支持
*
* @version $Id: arclist.lib.php 3 9:19 2010年7月13日Z tianya $
* @package DedeCMS.Taglib
* @copyright Copyright (c) 2007 - 2010, DesDev, Inc.
* @license http://help.dedecms.com/usersguide/license.html
* @link http://www.dedecms.com
*/
/**
* arclist解析标签
*
* @access public
* @param object $ctag 解析标签
* @param object $refObj 引用对象
* @return string 成功后返回解析后的标签内容
*/
/*>>dede>>
<name>文档列表</name>
<type>全局标记</type>
<for>V55,V56,V57</for>
<description>获取指定文档列表</description>
<demo>
{dede:arclist flag='h' typeid='' row='' col='' titlelen='' infolen='' imgwidth='' imgheight='' listtype='' orderby='' keyword='' limit='0,1'}
<a href='[field:arcurl/]'>[field:title/]</a>
{/dede:arclist}
</demo>
<attributes>
<iterm>col:分多少列显示（默认为单列），5.3版中本属性可以通过多种方式进行多行显示</iterm>
<iterm>row:返回文档列表总数</iterm>
<iterm>typeid:栏目ID,在列表模板和档案模板中一般不需要指定，在首页模板中允许用","分开表示多个栏目</iterm>
<iterm>getall:在没有指定这属性的情况下,在栏目页、文章页模板,不会获取以","分开的多个栏目的下级子类</iterm>
<iterm>titlelen:标题长度 等同于titlelength</iterm>
<iterm>infolen:表示内容简介长度 等同于infolength</iterm>
<iterm>imgwidth:缩略图宽度</iterm>
<iterm>imgheight:缩略图高度</iterm>
<iterm>listtype: 栏目类型 image含有缩略图 commend推荐</iterm>
<iterm>orderby:文档排序方式</iterm>
<iterm>keyword:含有指定关键字的文档列表，多个关键字用","分</iterm>
<iterm>innertext:单条记录样式</iterm>
<iterm>aid:指定文档ID</iterm>
<iterm>idlist:提取特定文档（文档ID</iterm>
<iterm>channelid:频道ID</iterm>
<iterm>limit:（起始ID从0开始）表示限定的记录范围（如：limit='1,2' 表示从ID为1的记录开始，取2条记录</iterm>
<iterm>flag:自定义属性值：头条[h]推荐[c]图片[p]幻灯[f]滚动[s]跳转[j]图文[a]加粗[b]</iterm>
<iterm>noflag:同flag，但这里是表示不包含这些属性</iterm>
<iterm>orderway:值为 desc 或 asc ，指定排序方式是降序还是顺向排序，默认为降序</iterm>
<iterm>subday:表示在多少天以内的文档</iterm>
</attributes>
>>dede>>*/
function lib_arclist( &$ctag, &$refObj )
{
global $envs;
$autopartid = 0;
$tagid = '';
$tagname = $ctag->GetTagName();
$channelid = $ctag->GetAtt('channelid');
//增加对分页内容的处理
$pagesize = $ctag->GetAtt('pagesize');
if($pagesize == '')
{
$multi = 0;
} else {
$tagid = $ctag->GetAtt('tagid');
}
// arclist是否需要weight排序,默认为"N",如果需要排序则设置为"Y"
$isweight = $ctag->GetAtt('isweight');
if($tagname=='imglist' || $tagname=='imginfolist') {
$listtype = 'image';
}
else if($tagname=='specart') {
$channelid = -1;
$listtype='';
}
else if($tagname=='coolart') {
$listtype = 'commend';
}
else if($tagname=='autolist') {
$autopartid = $ctag->GetAtt('partsort');
}
else {
$listtype = $ctag->GetAtt('type');
}
//排序
if($ctag->GetAtt('sort')!='') $orderby = $ctag->GetAtt('sort');
else if($tagname=='hotart') $orderby = 'click';
else $orderby = $ctag->GetAtt('orderby');
//对相应的标记使用不同的默认innertext
if(trim($ctag->GetInnerText()) != '') $innertext = $ctag->GetInnerText();
else if($tagname=='imglist') $innertext = GetSysTemplets('part_imglist.htm');
else if($tagname=='imginfolist') $innertext = GetSysTemplets('part_imginfolist.htm');
else $innertext = GetSysTemplets("part_arclist.htm");
//兼容titlelength
if($ctag->GetAtt('titlelength')!='') $titlelen = $ctag->GetAtt('titlelength');
else $titlelen = $ctag->GetAtt('titlelen');
//兼容infolength
if($ctag->GetAtt('infolength')!='') $infolen = $ctag->GetAtt('infolength');
else $infolen = $ctag->GetAtt('infolen');
$typeid = trim($ctag->GetAtt('typeid'));
if(empty($typeid)) {
$typeid = ( isset($refObj->Fields['typeid']) ? $refObj->Fields['typeid'] : $envs['typeid'] );
}
$idlist = $ctag->GetAtt('idlist');
if(!empty($idlist)){
if($idlist == 'typesnews'){
$idlist = isset($refObj->Fields['typesnews']) ? $refObj->Fields['typesnews'] : '';
if(empty($idlist)){
$idlist = '0';
}
}
}
if($listtype=='autolist') {
$typeid = lib_GetAutoChannelID($ctag->GetAtt('partsort'),$typeid);
}
if($ctag->GetAtt('att')=='') {
$flag = $ctag->GetAtt('flag');
}
else {
$flag = $ctag->GetAtt('att');
}
return lib_arclistDone
(
$refObj, $ctag, $typeid, $ctag->GetAtt('row'), $ctag->GetAtt('col'), $titlelen, $infolen,
$ctag->GetAtt('imgwidth'), $ctag->GetAtt('imgheight'), $listtype, $orderby,
$ctag->GetAtt('keyword'), $innertext, $envs['aid'], $idlist, $channelid,
$ctag->GetAtt('limit'), $flag,$ctag->GetAtt('orderway'), $ctag->GetAtt('subday'), $ctag->GetAtt('noflag'),
$tagid,$pagesize,$isweight
);
}
/**
* arclist解析函数
*
* @access public
* @param object $refObj 引用对象
* @param object $ctag 标签
* @param int $typeid 栏目ID
* @param int $row 调用行数
* @param int $titlelen 字符串长度
* @param int $infolen 描述信息长度
* @param int $imgwidth 图片宽度
* @param int $imgheight 图片高度
* @param string $listtype 列表类型
* @param string $orderby 排列顺序
* @param string $keyword 关键词
* @param string $innertext 底层模板
* @param int $arcid 文档ID
* @param string $idlist ID列表
* @param int $channelid 频道ID
* @param string $limit 限制
* @param string $att 属性
* @param string $order 排序类型
* @param int $subday 天内
* @param string $noflag 属性标记
* @param string $tagid 标签id
* @param string $pagesize 显示条数
* @param string $isweight 是否需要对检索出来的内容按照weight排序
* @return string
*/
function lib_arclistDone(&$refObj, &$ctag, $typeid=0, $row=10, $col=1, $titlelen=30, $infolen=160,
$imgwidth=120, $imgheight=90, $listtype='all', $orderby='default', $keyword='',
$innertext='', $arcid=0, $idlist='', $channelid=0, $limit='', $att='', $order='desc', $subday=0, $noflag='',$tagid='', $pagesize=0, $isweight='N')
{
global $dsql,$PubFields,$cfg_keyword_like,$cfg_index_cache,$_arclistEnv,$envs,$cfg_cache_type,$cfg_digg_update;
$row = AttDef($row,10);
$titlelen = AttDef($titlelen,30);
$infolen = AttDef($infolen,160);
$imgwidth = AttDef($imgwidth,120);
$imgheight = AttDef($imgheight,120);
$listtype = AttDef($listtype,'all');
$arcid = AttDef($arcid,0);
$channelid = AttDef($channelid,0);
$orderby = AttDef($orderby,'default');
$orderWay = AttDef($order,'desc');
$subday = AttDef($subday,0);
$pagesize = AttDef($pagesize,0);
$line = $row;
$orderby = strtolower($orderby);
$keyword = trim($keyword);
$innertext = trim($innertext);
$tablewidth = $ctag->GetAtt('tablewidth');
$writer = $ctag->GetAtt('writer');
if($tablewidth == "") $tablewidth = 100;
if(empty($col)) $col = 1;
$colWidth = ceil(100/$col);
$tablewidth = $tablewidth."%";
$colWidth = $colWidth."%";
//记录属性,以便分页样式统一调用
$attarray = compact("row", "titlelen", 'infolen', 'imgwidth', 'imgheight', 'listtype',
'arcid', 'channelid', 'orderby', 'orderWay', 'subday','pagesize',
'orderby', 'keyword', 'tablewidth', 'col', 'colWidth');
if($innertext=='') $innertext = GetSysTemplets('part_arclist.htm');
if( @$ctag->GetAtt('getall') == 1 ) $getall = 1;
else $getall = 0;
if($att=='0') $att='';
if($att=='3') $att='f';
if($att=='1') $att='h';
$orwheres = array();
$maintable = 'dede_archives';
//按不同情况设定SQL条件 排序方式
if($idlist=='')
{
if($orderby=='near' && $cfg_keyword_like=='N') { $keyword=''; }
if($writer=='this') {
$wmid = isset($refObj->Fields['mid']) ? $refObj->Fields['mid'] : 0;
$orwheres[] = " arc.mid = '$wmid' ";
}
//时间限制(用于调用最近热门文章、热门评论之类)，这里的时间只能计算到天，否则缓存功能将无效
if($subday > 0)
{
$ntime = gmmktime(0, 0, 0, gmdate('m'), gmdate('d'), gmdate('Y'));
$limitday = $ntime - ($subday * 24 * 3600);
$orwheres[] = " arc.senddate > $limitday ";
}
//关键字条件
if($keyword!='')
{
$keyword = str_replace(',', '|', $keyword);
$orwheres[] = " CONCAT(arc.title,arc.keywords) REGEXP '$keyword' ";
}
//文档属性
if(preg_match('/commend/i', $listtype)) $orwheres[] = " FIND_IN_SET('c', arc.flag)>0 ";
if(preg_match('/image/i', $listtype)) $orwheres[] = " FIND_IN_SET('p', arc.flag)>0 ";
if($att != '') {
$flags = explode(',', $att);
for($i=0; isset($flags[$i]); $i++) $orwheres[] = " FIND_IN_SET('{$flags[$i]}', arc.flag)>0 ";
}
if(!empty($typeid) && $typeid != 'top')
{
//指定了多个栏目时，不再获取子类的id
if( preg_match('#,#', $typeid) )
{
//指定了getall属性或主页模板例外
if($getall==1 || empty($refObj->Fields['typeid']))
{
$typeids = explode(',', $typeid);
foreach($typeids as $ttid) {
$typeidss[] = GetSonIds($ttid);
}
$typeidStr = join(',', $typeidss);
$typeidss = explode(',', $typeidStr);
$typeidssok = array_unique($typeidss);
$typeid = join(',', $typeidssok);
}
$orwheres[] = " arc.typeid IN ($typeid) ";
}
else
{
//处理交叉栏目
$CrossID = '';
if($ctag->GetAtt('cross')=='1')
{
$arr = $dsql->GetOne("SELECT `id`,`topid`,`cross`,`crossid`,`ispart`,`typename` FROM `dede_arctype` WHERE id='$typeid' ");
if( $arr['cross']==0 || ( $arr['cross']==2 && trim($arr['crossid']=='') ) )
{
$orwheres[] = ' arc.typeid IN ('.GetSonIds($typeid).')';
}
else
{
$selquery = '';
if($arr['cross']==1) {
$selquery = "SELECT id,topid FROM `dede_arctype` WHERE typename LIKE '{$arr['typename']}' AND id<>'{$typeid}' AND topid<>'{$typeid}' ";
}
else {
$arr['crossid'] = preg_replace('#[^0-9,]#', '', trim($arr['crossid']));
if($arr['crossid']!='') $selquery = "SELECT id,topid FROM `dede_arctype` WHERE id IN('{$arr['crossid']}') AND id<>'{$typeid}' AND topid<>'{$typeid}' ";
}
if($selquery!='')
{
$dsql->SetQuery($selquery);
$dsql->Execute();
while($arr = $dsql->GetArray())
{
$CrossID .= ($CrossID=='' ? $arr['id'] : ','.$arr['id']);
}
}
}
}
if($CrossID=='') $orwheres[] = ' arc.typeid IN ('.GetSonIds($typeid).')';
else $orwheres[] = ' arc.typeid IN ('.GetSonIds($typeid).','.$CrossID.')';
}
}
//频道ID
if(preg_match('#spec#i', $listtype)) $channelid==-1;
if(!empty($channelid)) $orwheres[] = " And arc.channel = '$channelid' ";
if(!empty($noflag))
{
if(!preg_match('#,#', $noflag))
{
$orwheres[] = " FIND_IN_SET('$noflag', arc.flag)<1 ";
}
else
{
$noflags = explode(',', $noflag);
foreach($noflags as $noflag) {
if(trim($noflag)=='') continue;
$orwheres[] = " FIND_IN_SET('$noflag', arc.flag)<1 ";
}
}
}
$orwheres[] = ' arc.arcrank > -1 ';
//由于这个条件会导致缓存功能失去意义，因此取消
//if($arcid!=0) $orwheres[] = " arc.id<>'$arcid' ";
}
//文档排序的方式
$ordersql = '';
if($orderby=='hot' || $orderby=='click') $ordersql = " ORDER BY arc.click $orderWay";
else if($orderby == 'sortrank' || $orderby=='pubdate') $ordersql = " ORDER BY arc.sortrank $orderWay";
else if($orderby == 'id') $ordersql = " ORDER BY arc.id $orderWay";
else if($orderby == 'near') $ordersql = " ORDER BY ABS(arc.id - ".$arcid.")";
else if($orderby == 'lastpost') $ordersql = " ORDER BY arc.lastpost $orderWay";
else if($orderby == 'scores') $ordersql = " ORDER BY arc.scores $orderWay";
//功能：增加按好评数和差评数调用
else if($orderby == 'goodpost') $ordersql = " order by arc.goodpost $orderWay";
else if($orderby == 'badpost') $ordersql = " order by arc.badpost $orderWay";
else if($orderby == 'rand') $ordersql = " ORDER BY rand()";
else $ordersql = " ORDER BY arc.sortrank $orderWay";
if($orderby == 'idlist' && $idlist!=''){
$ordersql = "ORDER BY FIELD(arc.id,$idlist) ";
}
//limit条件
$limit = trim(preg_replace('#limit#is', '', $limit));
if($limit!='')
{
$limitsql = " LIMIT $limit ";
$limitarr = explode(',', $limit);
$line = isset($limitarr[1])? $limitarr[1] : $line;
}
else $limitsql = " LIMIT 0,$line ";
$orwhere = '';
if(isset($orwheres[0])) {
$orwhere = join(' And ',$orwheres);
$orwhere = preg_replace("#^ And#is", '', $orwhere);
$orwhere = preg_replace("#And[ ]{1,}And#is", 'And ', $orwhere);
}
if($orwhere!='') $orwhere = " WHERE $orwhere ";
//获取附加表信息
$addfield = trim($ctag->GetAtt('addfields'));
$addfieldsSql = '';
$addfieldsSqlJoin = '';
if($addfield != '' && !empty($channelid))
{
$row = $dsql->GetOne("SELECT addtable FROM `dede_channeltype` WHERE id='$channelid' ");
if(isset($row['addtable']) && trim($row['addtable']) != '')
{
$addtable = trim($row['addtable']);
$addfields = explode(',', $addfield);
$row['addtable'] = trim($row['addtable']);
$addfieldsSql = ",addf.".join(',addf.', $addfields);
$addfieldsSqlJoin = " LEFT JOIN `$addtable` addf ON addf.aid = arc.id ";
}
}
$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
$addfieldsSql
FROM `$maintable` arc LEFT JOIN `dede_arctype` tp on arc.typeid=tp.id
$addfieldsSqlJoin
$orwhere $ordersql $limitsql";
//统一hash
$taghash = md5(serialize($ctag).$typeid);
$needSaveCache = true;
//进行tagid的默认处理
if($pagesize > 0) $tagid = AttDef($tagid,'tag'.$taghash );
if($idlist!='' || $GLOBALS['_arclistEnv']=='index' || $cfg_index_cache==0)
{
$needSaveCache = false;
}
else
{
$idlist = GetArclistCache($taghash);
if($idlist != '') {
$needSaveCache = false;
}
//如果使用的是内容缓存，直接返回结果
if($cfg_cache_type=='content' && $idlist != '')
{
$idlist = ($idlist==0 ? '' : $idlist);
return $idlist;
}
}
//指定了id或使用缓存中的id
if($idlist != '')
{
$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
$addfieldsSql
FROM `$maintable` arc left join `dede_arctype` tp on arc.typeid=tp.id
$addfieldsSqlJoin
WHERE arc.id in($idlist) $ordersql ";
}
// 好评差评缓存更新
if($cfg_digg_update > 0)
{
if($orderby == 'goodpost' || $orderby == 'badpost')
{
$t1 = ExecTime();
$postsql = "SELECT arc.id,arc.goodpost,arc.badpost,arc.scores
FROM `$maintable` arc
$orwhere $ordersql $limitsql";
if($idlist != '')
{
$postsql = "SELECT arc.id,arc.goodpost,arc.badpost,arc.scores
FROM `$maintable` arc
WHERE arc.id in($idlist) $ordersql ";
}
$dsql->SetQuery($query);
$dsql->Execute('lit');
while ($row = $dsql->GetArray('lit')) {
$prefix = 'diggCache';
$key = 'aid-'.$row['id'];
$cacherow = GetCache($prefix, $key);
$setsql = array();
if(!empty($cacherow['scores']) && $cacherow['scores'] != $row['scores'])
{
$setsql[] = "scores = {$cacherow['scores']}";
}
if(!empty($cacherow['goodpost']) && $cacherow['goodpost'] != $row['goodpost'])
{
$setsql[] = "goodpost = {$cacherow['goodpost']}";
}
if(!empty($cacherow['badpost']) && $cacherow['badpost'] != $row['badpost'])
{
$setsql[] = "badpost = {$cacherow['badpost']}";
}
$setsql = implode(',', $setsql);
$sql = "UPDATE `$maintable` SET {$setsql} WHERE id='{$row['id']}'";
if(!empty($setsql))
{
$dsql->ExecuteNoneQuery($sql);
}
}
//echo ExecTime()-$t1;
}
}
$dsql->SetQuery($query);
$dsql->Execute('al');
//$row = $dsql->GetArray("al");
$artlist = '';
if($pagesize > 0) $artlist .= " <div id='{$tagid}'>\r\n";
if($col > 1) $artlist = "<table width='$tablewidth' border='0' cellspacing='0' cellpadding='0'>\r\n";
$dtp2 = new DedeTagParse();
$dtp2->SetNameSpace('field', '[', ']');
$dtp2->LoadString($innertext);
$GLOBALS['autoindex'] = 0;
$ids = array();
$orderWeight = array();
for($i=0; $i<$line; $i++)
{
if($col>1) $artlist .= "<tr>\r\n";
for($j=0; $j<$col; $j++)
{
if($col>1) $artlist .= " <td width='$colWidth'>\r\n";
if($row = $dsql->GetArray("al"))
{
$ids[] = $row['id'];
//处理一些特殊字段
$row['info'] = $row['infos'] = cn_substr($row['description'],$infolen);
$row['id'] = $row['id'];
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']);
$row['typeurl'] = GetTypeUrl($row['typeid'],$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('#b#', $row['flag'])) $row['title'] = "<strong>".$row['title']."</strong>";
//$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'];
if(is_array($dtp2->CTags))
{
foreach($dtp2->CTags as $k=>$ctag)
{
if($ctag->GetName()=='array')
{
//传递整个数组，在runphp模式中有特殊作用
$dtp2->Assign($k, $row);
} else {
if(isset($row[$ctag->GetName()])) $dtp2->Assign($k,$row[$ctag->GetName()]);
else $dtp2->Assign($k, '');
}
}
$GLOBALS['autoindex']++;
}
if($pagesize > 0)
{
if($GLOBALS['autoindex'] <= $pagesize)
{
$liststr = $dtp2->GetResult();
$artlist .= $liststr."\r\n";
} else {
$artlist .= "";
$orderWeight[] = array(
'weight' => $row['weight'],
'arclist' => ''
);
}
} else {
$liststr = $dtp2->GetResult();
$artlist .= $liststr."\r\n";
}
$orderWeight[] = array(
'weight' => $row['weight'],
'arclist' => $liststr
);
}//if hasRow
else{
$artlist .= '';
}
// 进行判断,如果启用排序则内容输出为重新排序后的内容
// var_dump($isweight=='y' && count($orderWeight) == $line);
$isweight = strtolower($isweight);
if ( $isweight=='y' )
{
$artlist = '';
$orderWeight = list_sort_by($orderWeight, 'weight', 'asc');
foreach ($orderWeight as $vv) {
$artlist .= $vv['arclist'];
}
}
if($col>1) $artlist .= " </td>\r\n";
}//Loop Col
if($col>1) $i += $col - 1;
if($col>1) $artlist .= " </tr>\r\n";
}//loop line
if($col>1) $artlist .= " </table>\r\n";
$dsql->FreeResult("al");
$idsstr = join(',', $ids);
//分页特殊处理
if($pagesize > 0)
{
$artlist .= " </div>\r\n";
$row = $dsql->GetOne("SELECT tagid FROM dede_arcmulti WHERE tagid='$tagid'");
$uptime = time();
$attstr = addslashes(serialize($attarray));
$innertext = addslashes($innertext);
if(!is_array($row))
{
$query = "
INSERT INTO dede_arcmulti(tagid,uptime,innertext,pagesize,arcids,ordersql,addfieldsSql,addfieldsSqlJoin,attstr)
VALUES('$tagid','$uptime','$innertext','$pagesize','$idsstr','$ordersql','$addfieldsSql','$addfieldsSqlJoin','$attstr');
";
$dsql->ExecuteNoneQuery($query);
} else {
$query = "UPDATE `dede_arcmulti`
SET
uptime='$uptime',
innertext='$innertext',
pagesize='$pagesize',
arcids='$idsstr',
ordersql='$ordersql',
addfieldsSql='$addfieldsSql',
addfieldsSqlJoin='$addfieldsSqlJoin',
attstr='$attstr'
WHERE tagid='$tagid'
";
$dsql->ExecuteNoneQuery($query);
}
}
//保存ID缓存
if($needSaveCache)
{
if($idsstr=='') $idsstr = '0';
if($cfg_cache_type=='content' && $idsstr!='0') {
$idsstr = addslashes($artlist);
}
$inquery = "INSERT INTO `dede_arccache`(`md5hash`,`uptime`,`cachedata`) VALUES ('".$taghash."','".time()."', '$idsstr'); ";
$dsql->ExecuteNoneQuery("DELETE FROM `dede_arccache` WHERE md5hash='".$taghash."' ");
$dsql->ExecuteNoneQuery($inquery);
}
return $artlist;
}
/**
* 查询缓存
*
* @access public
* @param string $md5hash 唯一识别hash
* @return string
*/
function GetArclistCache($md5hash)
{
global $dsql,$envs,$cfg_makesign_cache,$cfg_index_cache,$cfg_cache_type;
if($cfg_index_cache <= 0) return '';
if(isset($envs['makesign']) && $cfg_makesign_cache=='N') return '';
$mintime = time() - $cfg_index_cache;
$arr = $dsql->GetOne("SELECT cachedata,uptime FROM `dede_arccache` WHERE md5hash = '$md5hash' ");
if(!is_array($arr)) {
return '';
}
else if($arr['uptime'] < $mintime) {
return '';
}
else {
return $arr['cachedata'];
}
}
/**
* 获取自动频道ID
*
* @access public
* @param string $sortid
* @param string $topid
* @return string
*/
function lib_GetAutoChannelID($sortid, $topid)
{
global $dsql;
if(empty($sortid)) $sortid = 1;
$getstart = $sortid - 1;
$row = $dsql->GetOne("SELECT id,typename FROM dede_arctype WHERE reid='{$topid}' And ispart<2 And ishidden<>'1' ORDER BY sortrank asc limit $getstart,1");
if(!is_array($row)) return 0;
else return $row['id'];
}
/**
* 对查询结果集进行排序
*
* @access public
* @param array $list 查询结果
* @param string $field 排序的字段名
* @param array $sortby 排序类型
* asc正向排序 desc逆向排序 nat自然排序
* @return array
*/
function list_sort_by($list, $field, $sortby='asc') {
if(is_array($list)){
$refer = $resultSet = array();
foreach ($list as $i => $data)
$refer[$i] = &$data[$field];
switch ($sortby) {
case 'asc': // 正向排序
asort($refer);
break;
case 'desc':// 逆向排序
arsort($refer);
break;
case 'nat': // 自然排序
natcasesort($refer);
break;
}
foreach ( $refer as $key=> $val)
$resultSet[] = &$list[$key];
return $resultSet;
}
return false;
}<?php if(!defined('DEDEINC')) exit('Request Error!');
/**
* 文章列表调用标记
*
* 9:19 2010年7月13日:修正对isweight属性的支持
*
* @version $Id: arclist.lib.php 3 9:19 2010年7月13日Z tianya $
* @package DedeCMS.Taglib
* @copyright Copyright (c) 2007 - 2010, DesDev, Inc.
* @license http://help.dedecms.com/usersguide/license.html
* @link http://www.dedecms.com
*/
/**
* arclist解析标签
*
* @access public
* @param object $ctag 解析标签
* @param object $refObj 引用对象
* @return string 成功后返回解析后的标签内容
*/
/*>>dede>>
<name>文档列表</name>
<type>全局标记</type>
<for>V55,V56,V57</for>
<description>获取指定文档列表</description>
<demo>
{dede:arclist flag='h' typeid='' row='' col='' titlelen='' infolen='' imgwidth='' imgheight='' listtype='' orderby='' keyword='' limit='0,1'}
<a href='[field:arcurl/]'>[field:title/]</a>
{/dede:arclist}
</demo>
<attributes>
<iterm>col:分多少列显示（默认为单列），5.3版中本属性可以通过多种方式进行多行显示</iterm>
<iterm>row:返回文档列表总数</iterm>
<iterm>typeid:栏目ID,在列表模板和档案模板中一般不需要指定，在首页模板中允许用","分开表示多个栏目</iterm>
<iterm>getall:在没有指定这属性的情况下,在栏目页、文章页模板,不会获取以","分开的多个栏目的下级子类</iterm>
<iterm>titlelen:标题长度 等同于titlelength</iterm>
<iterm>infolen:表示内容简介长度 等同于infolength</iterm>
<iterm>imgwidth:缩略图宽度</iterm>
<iterm>imgheight:缩略图高度</iterm>
<iterm>listtype: 栏目类型 image含有缩略图 commend推荐</iterm>
<iterm>orderby:文档排序方式</iterm>
<iterm>keyword:含有指定关键字的文档列表，多个关键字用","分</iterm>
<iterm>innertext:单条记录样式</iterm>
<iterm>aid:指定文档ID</iterm>
<iterm>idlist:提取特定文档（文档ID</iterm>
<iterm>channelid:频道ID</iterm>
<iterm>limit:（起始ID从0开始）表示限定的记录范围（如：limit='1,2' 表示从ID为1的记录开始，取2条记录</iterm>
<iterm>flag:自定义属性值：头条[h]推荐[c]图片[p]幻灯[f]滚动[s]跳转[j]图文[a]加粗[b]</iterm>
<iterm>noflag:同flag，但这里是表示不包含这些属性</iterm>
<iterm>orderway:值为 desc 或 asc ，指定排序方式是降序还是顺向排序，默认为降序</iterm>
<iterm>subday:表示在多少天以内的文档</iterm>
</attributes>
>>dede>>*/
function lib_arclist( &$ctag, &$refObj )
{
global $envs;
$autopartid = 0;
$tagid = '';
$tagname = $ctag->GetTagName();
$channelid = $ctag->GetAtt('channelid');
//增加对分页内容的处理
$pagesize = $ctag->GetAtt('pagesize');
if($pagesize == '')
{
$multi = 0;
} else {
$tagid = $ctag->GetAtt('tagid');
}
// arclist是否需要weight排序,默认为"N",如果需要排序则设置为"Y"
$isweight = $ctag->GetAtt('isweight');
if($tagname=='imglist' || $tagname=='imginfolist') {
$listtype = 'image';
}
else if($tagname=='specart') {
$channelid = -1;
$listtype='';
}
else if($tagname=='coolart') {
$listtype = 'commend';
}
else if($tagname=='autolist') {
$autopartid = $ctag->GetAtt('partsort');
}
else {
$listtype = $ctag->GetAtt('type');
}
//排序
if($ctag->GetAtt('sort')!='') $orderby = $ctag->GetAtt('sort');
else if($tagname=='hotart') $orderby = 'click';
else $orderby = $ctag->GetAtt('orderby');
//对相应的标记使用不同的默认innertext
if(trim($ctag->GetInnerText()) != '') $innertext = $ctag->GetInnerText();
else if($tagname=='imglist') $innertext = GetSysTemplets('part_imglist.htm');
else if($tagname=='imginfolist') $innertext = GetSysTemplets('part_imginfolist.htm');
else $innertext = GetSysTemplets("part_arclist.htm");
//兼容titlelength
if($ctag->GetAtt('titlelength')!='') $titlelen = $ctag->GetAtt('titlelength');
else $titlelen = $ctag->GetAtt('titlelen');
//兼容infolength
if($ctag->GetAtt('infolength')!='') $infolen = $ctag->GetAtt('infolength');
else $infolen = $ctag->GetAtt('infolen');
$typeid = trim($ctag->GetAtt('typeid'));
if(empty($typeid)) {
$typeid = ( isset($refObj->Fields['typeid']) ? $refObj->Fields['typeid'] : $envs['typeid'] );
}
$idlist = $ctag->GetAtt('idlist');
if(!empty($idlist)){
if($idlist == 'typesnews'){
$idlist = isset($refObj->Fields['typesnews']) ? $refObj->Fields['typesnews'] : '';
if(empty($idlist)){
$idlist = '0';
}
}
}
if($listtype=='autolist') {
$typeid = lib_GetAutoChannelID($ctag->GetAtt('partsort'),$typeid);
}
if($ctag->GetAtt('att')=='') {
$flag = $ctag->GetAtt('flag');
}
else {
$flag = $ctag->GetAtt('att');
}
return lib_arclistDone
(
$refObj, $ctag, $typeid, $ctag->GetAtt('row'), $ctag->GetAtt('col'), $titlelen, $infolen,
$ctag->GetAtt('imgwidth'), $ctag->GetAtt('imgheight'), $listtype, $orderby,
$ctag->GetAtt('keyword'), $innertext, $envs['aid'], $idlist, $channelid,
$ctag->GetAtt('limit'), $flag,$ctag->GetAtt('orderway'), $ctag->GetAtt('subday'), $ctag->GetAtt('noflag'),
$tagid,$pagesize,$isweight
);
}
/**
* arclist解析函数
*
* @access public
* @param object $refObj 引用对象
* @param object $ctag 标签
* @param int $typeid 栏目ID
* @param int $row 调用行数
* @param int $titlelen 字符串长度
* @param int $infolen 描述信息长度
* @param int $imgwidth 图片宽度
* @param int $imgheight 图片高度
* @param string $listtype 列表类型
* @param string $orderby 排列顺序
* @param string $keyword 关键词
* @param string $innertext 底层模板
* @param int $arcid 文档ID
* @param string $idlist ID列表
* @param int $channelid 频道ID
* @param string $limit 限制
* @param string $att 属性
* @param string $order 排序类型
* @param int $subday 天内
* @param string $noflag 属性标记
* @param string $tagid 标签id
* @param string $pagesize 显示条数
* @param string $isweight 是否需要对检索出来的内容按照weight排序
* @return string
*/
function lib_arclistDone(&$refObj, &$ctag, $typeid=0, $row=10, $col=1, $titlelen=30, $infolen=160,
$imgwidth=120, $imgheight=90, $listtype='all', $orderby='default', $keyword='',
$innertext='', $arcid=0, $idlist='', $channelid=0, $limit='', $att='', $order='desc', $subday=0, $noflag='',$tagid='', $pagesize=0, $isweight='N')
{
global $dsql,$PubFields,$cfg_keyword_like,$cfg_index_cache,$_arclistEnv,$envs,$cfg_cache_type,$cfg_digg_update;
$row = AttDef($row,10);
$titlelen = AttDef($titlelen,30);
$infolen = AttDef($infolen,160);
$imgwidth = AttDef($imgwidth,120);
$imgheight = AttDef($imgheight,120);
$listtype = AttDef($listtype,'all');
$arcid = AttDef($arcid,0);
$channelid = AttDef($channelid,0);
$orderby = AttDef($orderby,'default');
$orderWay = AttDef($order,'desc');
$subday = AttDef($subday,0);
$pagesize = AttDef($pagesize,0);
$line = $row;
$orderby = strtolower($orderby);
$keyword = trim($keyword);
$innertext = trim($innertext);
$tablewidth = $ctag->GetAtt('tablewidth');
$writer = $ctag->GetAtt('writer');
if($tablewidth == "") $tablewidth = 100;
if(empty($col)) $col = 1;
$colWidth = ceil(100/$col);
$tablewidth = $tablewidth."%";
$colWidth = $colWidth."%";
//记录属性,以便分页样式统一调用
$attarray = compact("row", "titlelen", 'infolen', 'imgwidth', 'imgheight', 'listtype',
'arcid', 'channelid', 'orderby', 'orderWay', 'subday','pagesize',
'orderby', 'keyword', 'tablewidth', 'col', 'colWidth');
if($innertext=='') $innertext = GetSysTemplets('part_arclist.htm');
if( @$ctag->GetAtt('getall') == 1 ) $getall = 1;
else $getall = 0;
if($att=='0') $att='';
if($att=='3') $att='f';
if($att=='1') $att='h';
$orwheres = array();
$maintable = 'dede_archives';
//按不同情况设定SQL条件 排序方式
if($idlist=='')
{
if($orderby=='near' && $cfg_keyword_like=='N') { $keyword=''; }
if($writer=='this') {
$wmid = isset($refObj->Fields['mid']) ? $refObj->Fields['mid'] : 0;
$orwheres[] = " arc.mid = '$wmid' ";
}
//时间限制(用于调用最近热门文章、热门评论之类)，这里的时间只能计算到天，否则缓存功能将无效
if($subday > 0)
{
$ntime = gmmktime(0, 0, 0, gmdate('m'), gmdate('d'), gmdate('Y'));
$limitday = $ntime - ($subday * 24 * 3600);
$orwheres[] = " arc.senddate > $limitday ";
}
//关键字条件
if($keyword!='')
{
$keyword = str_replace(',', '|', $keyword);
$orwheres[] = " CONCAT(arc.title,arc.keywords) REGEXP '$keyword' ";
}
//文档属性
if(preg_match('/commend/i', $listtype)) $orwheres[] = " FIND_IN_SET('c', arc.flag)>0 ";
if(preg_match('/image/i', $listtype)) $orwheres[] = " FIND_IN_SET('p', arc.flag)>0 ";
if($att != '') {
$flags = explode(',', $att);
for($i=0; isset($flags[$i]); $i++) $orwheres[] = " FIND_IN_SET('{$flags[$i]}', arc.flag)>0 ";
}
if(!empty($typeid) && $typeid != 'top')
{
//指定了多个栏目时，不再获取子类的id
if( preg_match('#,#', $typeid) )
{
//指定了getall属性或主页模板例外
if($getall==1 || empty($refObj->Fields['typeid']))
{
$typeids = explode(',', $typeid);
foreach($typeids as $ttid) {
$typeidss[] = GetSonIds($ttid);
}
$typeidStr = join(',', $typeidss);
$typeidss = explode(',', $typeidStr);
$typeidssok = array_unique($typeidss);
$typeid = join(',', $typeidssok);
}
$orwheres[] = " arc.typeid IN ($typeid) ";
}
else
{
//处理交叉栏目
$CrossID = '';
if($ctag->GetAtt('cross')=='1')
{
$arr = $dsql->GetOne("SELECT `id`,`topid`,`cross`,`crossid`,`ispart`,`typename` FROM `dede_arctype` WHERE id='$typeid' ");
if( $arr['cross']==0 || ( $arr['cross']==2 && trim($arr['crossid']=='') ) )
{
$orwheres[] = ' arc.typeid IN ('.GetSonIds($typeid).')';
}
else
{
$selquery = '';
if($arr['cross']==1) {
$selquery = "SELECT id,topid FROM `dede_arctype` WHERE typename LIKE '{$arr['typename']}' AND id<>'{$typeid}' AND topid<>'{$typeid}' ";
}
else {
$arr['crossid'] = preg_replace('#[^0-9,]#', '', trim($arr['crossid']));
if($arr['crossid']!='') $selquery = "SELECT id,topid FROM `dede_arctype` WHERE id IN('{$arr['crossid']}') AND id<>'{$typeid}' AND topid<>'{$typeid}' ";
}
if($selquery!='')
{
$dsql->SetQuery($selquery);
$dsql->Execute();
while($arr = $dsql->GetArray())
{
$CrossID .= ($CrossID=='' ? $arr['id'] : ','.$arr['id']);
}
}
}
}
if($CrossID=='') $orwheres[] = ' arc.typeid IN ('.GetSonIds($typeid).')';
else $orwheres[] = ' arc.typeid IN ('.GetSonIds($typeid).','.$CrossID.')';
}
}
//频道ID
if(preg_match('#spec#i', $listtype)) $channelid==-1;
if(!empty($channelid)) $orwheres[] = " And arc.channel = '$channelid' ";
if(!empty($noflag))
{
if(!preg_match('#,#', $noflag))
{
$orwheres[] = " FIND_IN_SET('$noflag', arc.flag)<1 ";
}
else
{
$noflags = explode(',', $noflag);
foreach($noflags as $noflag) {
if(trim($noflag)=='') continue;
$orwheres[] = " FIND_IN_SET('$noflag', arc.flag)<1 ";
}
}
}
$orwheres[] = ' arc.arcrank > -1 ';
//由于这个条件会导致缓存功能失去意义，因此取消
//if($arcid!=0) $orwheres[] = " arc.id<>'$arcid' ";
}
//文档排序的方式
$ordersql = '';
if($orderby=='hot' || $orderby=='click') $ordersql = " ORDER BY arc.click $orderWay";
else if($orderby == 'sortrank' || $orderby=='pubdate') $ordersql = " ORDER BY arc.sortrank $orderWay";
else if($orderby == 'id') $ordersql = " ORDER BY arc.id $orderWay";
else if($orderby == 'near') $ordersql = " ORDER BY ABS(arc.id - ".$arcid.")";
else if($orderby == 'lastpost') $ordersql = " ORDER BY arc.lastpost $orderWay";
else if($orderby == 'scores') $ordersql = " ORDER BY arc.scores $orderWay";
//功能：增加按好评数和差评数调用
else if($orderby == 'goodpost') $ordersql = " order by arc.goodpost $orderWay";
else if($orderby == 'badpost') $ordersql = " order by arc.badpost $orderWay";
else if($orderby == 'rand') $ordersql = " ORDER BY rand()";
else $ordersql = " ORDER BY arc.sortrank $orderWay";
if($orderby == 'idlist' && $idlist!=''){
$ordersql = "ORDER BY FIELD(arc.id,$idlist) ";
}
//limit条件
$limit = trim(preg_replace('#limit#is', '', $limit));
if($limit!='')
{
$limitsql = " LIMIT $limit ";
$limitarr = explode(',', $limit);
$line = isset($limitarr[1])? $limitarr[1] : $line;
}
else $limitsql = " LIMIT 0,$line ";
$orwhere = '';
if(isset($orwheres[0])) {
$orwhere = join(' And ',$orwheres);
$orwhere = preg_replace("#^ And#is", '', $orwhere);
$orwhere = preg_replace("#And[ ]{1,}And#is", 'And ', $orwhere);
}
if($orwhere!='') $orwhere = " WHERE $orwhere ";
//获取附加表信息
$addfield = trim($ctag->GetAtt('addfields'));
$addfieldsSql = '';
$addfieldsSqlJoin = '';
if($addfield != '' && !empty($channelid))
{
$row = $dsql->GetOne("SELECT addtable FROM `dede_channeltype` WHERE id='$channelid' ");
if(isset($row['addtable']) && trim($row['addtable']) != '')
{
$addtable = trim($row['addtable']);
$addfields = explode(',', $addfield);
$row['addtable'] = trim($row['addtable']);
$addfieldsSql = ",addf.".join(',addf.', $addfields);
$addfieldsSqlJoin = " LEFT JOIN `$addtable` addf ON addf.aid = arc.id ";
}
}
$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
$addfieldsSql
FROM `$maintable` arc LEFT JOIN `dede_arctype` tp on arc.typeid=tp.id
$addfieldsSqlJoin
$orwhere $ordersql $limitsql";
//统一hash
$taghash = md5(serialize($ctag).$typeid);
$needSaveCache = true;
//进行tagid的默认处理
if($pagesize > 0) $tagid = AttDef($tagid,'tag'.$taghash );
if($idlist!='' || $GLOBALS['_arclistEnv']=='index' || $cfg_index_cache==0)
{
$needSaveCache = false;
}
else
{
$idlist = GetArclistCache($taghash);
if($idlist != '') {
$needSaveCache = false;
}
//如果使用的是内容缓存，直接返回结果
if($cfg_cache_type=='content' && $idlist != '')
{
$idlist = ($idlist==0 ? '' : $idlist);
return $idlist;
}
}
//指定了id或使用缓存中的id
if($idlist != '')
{
$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
$addfieldsSql
FROM `$maintable` arc left join `dede_arctype` tp on arc.typeid=tp.id
$addfieldsSqlJoin
WHERE arc.id in($idlist) $ordersql ";
}
// 好评差评缓存更新
if($cfg_digg_update > 0)
{
if($orderby == 'goodpost' || $orderby == 'badpost')
{
$t1 = ExecTime();
$postsql = "SELECT arc.id,arc.goodpost,arc.badpost,arc.scores
FROM `$maintable` arc
$orwhere $ordersql $limitsql";
if($idlist != '')
{
$postsql = "SELECT arc.id,arc.goodpost,arc.badpost,arc.scores
FROM `$maintable` arc
WHERE arc.id in($idlist) $ordersql ";
}
$dsql->SetQuery($query);
$dsql->Execute('lit');
while ($row = $dsql->GetArray('lit')) {
$prefix = 'diggCache';
$key = 'aid-'.$row['id'];
$cacherow = GetCache($prefix, $key);
$setsql = array();
if(!empty($cacherow['scores']) && $cacherow['scores'] != $row['scores'])
{
$setsql[] = "scores = {$cacherow['scores']}";
}
if(!empty($cacherow['goodpost']) && $cacherow['goodpost'] != $row['goodpost'])
{
$setsql[] = "goodpost = {$cacherow['goodpost']}";
}
if(!empty($cacherow['badpost']) && $cacherow['badpost'] != $row['badpost'])
{
$setsql[] = "badpost = {$cacherow['badpost']}";
}
$setsql = implode(',', $setsql);
$sql = "UPDATE `$maintable` SET {$setsql} WHERE id='{$row['id']}'";
if(!empty($setsql))
{
$dsql->ExecuteNoneQuery($sql);
}
}
//echo ExecTime()-$t1;
}
}
$dsql->SetQuery($query);
$dsql->Execute('al');
//$row = $dsql->GetArray("al");
$artlist = '';
if($pagesize > 0) $artlist .= " <div id='{$tagid}'>\r\n";
if($col > 1) $artlist = "<table width='$tablewidth' border='0' cellspacing='0' cellpadding='0'>\r\n";
$dtp2 = new DedeTagParse();
$dtp2->SetNameSpace('field', '[', ']');
$dtp2->LoadString($innertext);
$GLOBALS['autoindex'] = 0;
$ids = array();
$orderWeight = array();
for($i=0; $i<$line; $i++)
{
if($col>1) $artlist .= "<tr>\r\n";
for($j=0; $j<$col; $j++)
{
if($col>1) $artlist .= " <td width='$colWidth'>\r\n";
if($row = $dsql->GetArray("al"))
{
$ids[] = $row['id'];
//处理一些特殊字段
$row['info'] = $row['infos'] = cn_substr($row['description'],$infolen);
$row['id'] = $row['id'];
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']);
$row['typeurl'] = GetTypeUrl($row['typeid'],$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('#b#', $row['flag'])) $row['title'] = "<strong>".$row['title']."</strong>";
//$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'];
if(is_array($dtp2->CTags))
{
foreach($dtp2->CTags as $k=>$ctag)
{
if($ctag->GetName()=='array')
{
//传递整个数组，在runphp模式中有特殊作用
$dtp2->Assign($k, $row);
} else {
if(isset($row[$ctag->GetName()])) $dtp2->Assign($k,$row[$ctag->GetName()]);
else $dtp2->Assign($k, '');
}
}
$GLOBALS['autoindex']++;
}
if($pagesize > 0)
{
if($GLOBALS['autoindex'] <= $pagesize)
{
$liststr = $dtp2->GetResult();
$artlist .= $liststr."\r\n";
} else {
$artlist .= "";
$orderWeight[] = array(
'weight' => $row['weight'],
'arclist' => ''
);
}
} else {
$liststr = $dtp2->GetResult();
$artlist .= $liststr."\r\n";
}
$orderWeight[] = array(
'weight' => $row['weight'],
'arclist' => $liststr
);
}//if hasRow
else{
$artlist .= '';
}
// 进行判断,如果启用排序则内容输出为重新排序后的内容
// var_dump($isweight=='y' && count($orderWeight) == $line);
$isweight = strtolower($isweight);
if ( $isweight=='y' )
{
$artlist = '';
$orderWeight = list_sort_by($orderWeight, 'weight', 'asc');
foreach ($orderWeight as $vv) {
$artlist .= $vv['arclist'];
}
}
if($col>1) $artlist .= " </td>\r\n";
}//Loop Col
if($col>1) $i += $col - 1;
if($col>1) $artlist .= " </tr>\r\n";
}//loop line
if($col>1) $artlist .= " </table>\r\n";
$dsql->FreeResult("al");
$idsstr = join(',', $ids);
//分页特殊处理
if($pagesize > 0)
{
$artlist .= " </div>\r\n";
$row = $dsql->GetOne("SELECT tagid FROM dede_arcmulti WHERE tagid='$tagid'");
$uptime = time();
$attstr = addslashes(serialize($attarray));
$innertext = addslashes($innertext);
if(!is_array($row))
{
$query = "
INSERT INTO dede_arcmulti(tagid,uptime,innertext,pagesize,arcids,ordersql,addfieldsSql,addfieldsSqlJoin,attstr)
VALUES('$tagid','$uptime','$innertext','$pagesize','$idsstr','$ordersql','$addfieldsSql','$addfieldsSqlJoin','$attstr');
";
$dsql->ExecuteNoneQuery($query);
} else {
$query = "UPDATE `dede_arcmulti`
SET
uptime='$uptime',
innertext='$innertext',
pagesize='$pagesize',
arcids='$idsstr',
ordersql='$ordersql',
addfieldsSql='$addfieldsSql',
addfieldsSqlJoin='$addfieldsSqlJoin',
attstr='$attstr'
WHERE tagid='$tagid'
";
$dsql->ExecuteNoneQuery($query);
}
}
//保存ID缓存
if($needSaveCache)
{
if($idsstr=='') $idsstr = '0';
if($cfg_cache_type=='content' && $idsstr!='0') {
$idsstr = addslashes($artlist);
}
$inquery = "INSERT INTO `dede_arccache`(`md5hash`,`uptime`,`cachedata`) VALUES ('".$taghash."','".time()."', '$idsstr'); ";
$dsql->ExecuteNoneQuery("DELETE FROM `dede_arccache` WHERE md5hash='".$taghash."' ");
$dsql->ExecuteNoneQuery($inquery);
}
return $artlist;
}
/**
* 查询缓存
*
* @access public
* @param string $md5hash 唯一识别hash
* @return string
*/
function GetArclistCache($md5hash)
{
global $dsql,$envs,$cfg_makesign_cache,$cfg_index_cache,$cfg_cache_type;
if($cfg_index_cache <= 0) return '';
if(isset($envs['makesign']) && $cfg_makesign_cache=='N') return '';
$mintime = time() - $cfg_index_cache;
$arr = $dsql->GetOne("SELECT cachedata,uptime FROM `dede_arccache` WHERE md5hash = '$md5hash' ");
if(!is_array($arr)) {
return '';
}
else if($arr['uptime'] < $mintime) {
return '';
}
else {
return $arr['cachedata'];
}
}
/**
* 获取自动频道ID
*
* @access public
* @param string $sortid
* @param string $topid
* @return string
*/
function lib_GetAutoChannelID($sortid, $topid)
{
global $dsql;
if(empty($sortid)) $sortid = 1;
$getstart = $sortid - 1;
$row = $dsql->GetOne("SELECT id,typename FROM dede_arctype WHERE reid='{$topid}' And ispart<2 And ishidden<>'1' ORDER BY sortrank asc limit $getstart,1");
if(!is_array($row)) return 0;
else return $row['id'];
}
/**
* 对查询结果集进行排序
*
* @access public
* @param array $list 查询结果
* @param string $field 排序的字段名
* @param array $sortby 排序类型
* asc正向排序 desc逆向排序 nat自然排序
* @return array
*/
function list_sort_by($list, $field, $sortby='asc') {
if(is_array($list)){
$refer = $resultSet = array();
foreach ($list as $i => $data)
$refer[$i] = &$data[$field];
switch ($sortby) {
case 'asc': // 正向排序
asort($refer);
break;
case 'desc':// 逆向排序
arsort($refer);
break;
case 'nat': // 自然排序
natcasesort($refer);
break;
}
foreach ( $refer as $key=> $val)
$resultSet[] = &$list[$key];
return $resultSet;
}
return false;
}
修改完成后前台就可以使用
{dede:arclist idlist='typesnews' orderby='idlist' }进行调用
typesnews是你的自定义字段名
orderby='idlist' 是按照你填写的文章id顺序显示到前台，你可在后台自定义字段的地方填写1,3,2按填写顺序调用多个文章
厉害吧，如果觉得有用千万别忘了收藏。如有不明白处咨询QQ：286601999，免费为您解答。
今天我就整理了一下如何利用 {dede:arclist idlist='自定义字段'} 随机调用自定义文章。实现了这个功能后，栏目可以随意调用任意文章，只需要在后台栏目相应位置填写一下你要调用的文章id号即可。
言归正传
首先我们需要在栏目里创建一个类似于相关文章的字段（这里方便你以后填写想要调用的文章id）
这个很简单：我们可以参考https://blog.csdn.net/langyu1021/article/details/52460660
下面是关键：
下面要实现的是让{dede:arclist idlist='自定义字段'}生效，我们需要修改include\taglib下的arclist.lib.php文件
修改后的代码为（或直接联系QQ286601999，索要arclist.lib.php文件，替换即可）
<?php if(!defined('DEDEINC')) exit('Request Error!');
/**
* 文章列表调用标记
*
* 9:19 2010年7月13日:修正对isweight属性的支持
*
* @version $Id: arclist.lib.php 3 9:19 2010年7月13日Z tianya $
* @package DedeCMS.Taglib
* @copyright Copyright (c) 2007 - 2010, DesDev, Inc.
* @license http://help.dedecms.com/usersguide/license.html
* @link http://www.dedecms.com
*/
/**
* arclist解析标签
*
* @access public
* @param object $ctag 解析标签
* @param object $refObj 引用对象
* @return string 成功后返回解析后的标签内容
*/
/*>>dede>>
<name>文档列表</name>
<type>全局标记</type>
<for>V55,V56,V57</for>
<description>获取指定文档列表</description>
<demo>
{dede:arclist flag='h' typeid='' row='' col='' titlelen='' infolen='' imgwidth='' imgheight='' listtype='' orderby='' keyword='' limit='0,1'}
<a href='[field:arcurl/]'>[field:title/]</a>
{/dede:arclist}
</demo>
<attributes>
<iterm>col:分多少列显示（默认为单列），5.3版中本属性可以通过多种方式进行多行显示</iterm>
<iterm>row:返回文档列表总数</iterm>
<iterm>typeid:栏目ID,在列表模板和档案模板中一般不需要指定，在首页模板中允许用","分开表示多个栏目</iterm>
<iterm>getall:在没有指定这属性的情况下,在栏目页、文章页模板,不会获取以","分开的多个栏目的下级子类</iterm>
<iterm>titlelen:标题长度 等同于titlelength</iterm>
<iterm>infolen:表示内容简介长度 等同于infolength</iterm>
<iterm>imgwidth:缩略图宽度</iterm>
<iterm>imgheight:缩略图高度</iterm>
<iterm>listtype: 栏目类型 image含有缩略图 commend推荐</iterm>
<iterm>orderby:文档排序方式</iterm>
<iterm>keyword:含有指定关键字的文档列表，多个关键字用","分</iterm>
<iterm>innertext:单条记录样式</iterm>
<iterm>aid:指定文档ID</iterm>
<iterm>idlist:提取特定文档（文档ID</iterm>
<iterm>channelid:频道ID</iterm>
<iterm>limit:（起始ID从0开始）表示限定的记录范围（如：limit='1,2' 表示从ID为1的记录开始，取2条记录</iterm>
<iterm>flag:自定义属性值：头条[h]推荐[c]图片[p]幻灯[f]滚动[s]跳转[j]图文[a]加粗[b]</iterm>
<iterm>noflag:同flag，但这里是表示不包含这些属性</iterm>
<iterm>orderway:值为 desc 或 asc ，指定排序方式是降序还是顺向排序，默认为降序</iterm>
<iterm>subday:表示在多少天以内的文档</iterm>
</attributes>
>>dede>>*/
function lib_arclist( &$ctag, &$refObj )
{
global $envs;
$autopartid = 0;
$tagid = '';
$tagname = $ctag->GetTagName();
$channelid = $ctag->GetAtt('channelid');
//增加对分页内容的处理
$pagesize = $ctag->GetAtt('pagesize');
if($pagesize == '')
{
$multi = 0;
} else {
$tagid = $ctag->GetAtt('tagid');
}
// arclist是否需要weight排序,默认为"N",如果需要排序则设置为"Y"
$isweight = $ctag->GetAtt('isweight');
if($tagname=='imglist' || $tagname=='imginfolist') {
$listtype = 'image';
}
else if($tagname=='specart') {
$channelid = -1;
$listtype='';
}
else if($tagname=='coolart') {
$listtype = 'commend';
}
else if($tagname=='autolist') {
$autopartid = $ctag->GetAtt('partsort');
}
else {
$listtype = $ctag->GetAtt('type');
}
//排序
if($ctag->GetAtt('sort')!='') $orderby = $ctag->GetAtt('sort');
else if($tagname=='hotart') $orderby = 'click';
else $orderby = $ctag->GetAtt('orderby');
//对相应的标记使用不同的默认innertext
if(trim($ctag->GetInnerText()) != '') $innertext = $ctag->GetInnerText();
else if($tagname=='imglist') $innertext = GetSysTemplets('part_imglist.htm');
else if($tagname=='imginfolist') $innertext = GetSysTemplets('part_imginfolist.htm');
else $innertext = GetSysTemplets("part_arclist.htm");
//兼容titlelength
if($ctag->GetAtt('titlelength')!='') $titlelen = $ctag->GetAtt('titlelength');
else $titlelen = $ctag->GetAtt('titlelen');
//兼容infolength
if($ctag->GetAtt('infolength')!='') $infolen = $ctag->GetAtt('infolength');
else $infolen = $ctag->GetAtt('infolen');
$typeid = trim($ctag->GetAtt('typeid'));
if(empty($typeid)) {
$typeid = ( isset($refObj->Fields['typeid']) ? $refObj->Fields['typeid'] : $envs['typeid'] );
}
$idlist = $ctag->GetAtt('idlist');
if(!empty($idlist)){
if($idlist == 'typesnews'){
$idlist = isset($refObj->Fields['typesnews']) ? $refObj->Fields['typesnews'] : '';
if(empty($idlist)){
$idlist = '0';
}
}
}
if($listtype=='autolist') {
$typeid = lib_GetAutoChannelID($ctag->GetAtt('partsort'),$typeid);
}
if($ctag->GetAtt('att')=='') {
$flag = $ctag->GetAtt('flag');
}
else {
$flag = $ctag->GetAtt('att');
}
return lib_arclistDone
(
$refObj, $ctag, $typeid, $ctag->GetAtt('row'), $ctag->GetAtt('col'), $titlelen, $infolen,
$ctag->GetAtt('imgwidth'), $ctag->GetAtt('imgheight'), $listtype, $orderby,
$ctag->GetAtt('keyword'), $innertext, $envs['aid'], $idlist, $channelid,
$ctag->GetAtt('limit'), $flag,$ctag->GetAtt('orderway'), $ctag->GetAtt('subday'), $ctag->GetAtt('noflag'),
$tagid,$pagesize,$isweight
);
}
/**
* arclist解析函数
*
* @access public
* @param object $refObj 引用对象
* @param object $ctag 标签
* @param int $typeid 栏目ID
* @param int $row 调用行数
* @param int $titlelen 字符串长度
* @param int $infolen 描述信息长度
* @param int $imgwidth 图片宽度
* @param int $imgheight 图片高度
* @param string $listtype 列表类型
* @param string $orderby 排列顺序
* @param string $keyword 关键词
* @param string $innertext 底层模板
* @param int $arcid 文档ID
* @param string $idlist ID列表
* @param int $channelid 频道ID
* @param string $limit 限制
* @param string $att 属性
* @param string $order 排序类型
* @param int $subday 天内
* @param string $noflag 属性标记
* @param string $tagid 标签id
* @param string $pagesize 显示条数
* @param string $isweight 是否需要对检索出来的内容按照weight排序
* @return string
*/
function lib_arclistDone(&$refObj, &$ctag, $typeid=0, $row=10, $col=1, $titlelen=30, $infolen=160,
$imgwidth=120, $imgheight=90, $listtype='all', $orderby='default', $keyword='',
$innertext='', $arcid=0, $idlist='', $channelid=0, $limit='', $att='', $order='desc', $subday=0, $noflag='',$tagid='', $pagesize=0, $isweight='N')
{
global $dsql,$PubFields,$cfg_keyword_like,$cfg_index_cache,$_arclistEnv,$envs,$cfg_cache_type,$cfg_digg_update;
$row = AttDef($row,10);
$titlelen = AttDef($titlelen,30);
$infolen = AttDef($infolen,160);
$imgwidth = AttDef($imgwidth,120);
$imgheight = AttDef($imgheight,120);
$listtype = AttDef($listtype,'all');
$arcid = AttDef($arcid,0);
$channelid = AttDef($channelid,0);
$orderby = AttDef($orderby,'default');
$orderWay = AttDef($order,'desc');
$subday = AttDef($subday,0);
$pagesize = AttDef($pagesize,0);
$line = $row;
$orderby = strtolower($orderby);
$keyword = trim($keyword);
$innertext = trim($innertext);
$tablewidth = $ctag->GetAtt('tablewidth');
$writer = $ctag->GetAtt('writer');
if($tablewidth == "") $tablewidth = 100;
if(empty($col)) $col = 1;
$colWidth = ceil(100/$col);
$tablewidth = $tablewidth."%";
$colWidth = $colWidth."%";
//记录属性,以便分页样式统一调用
$attarray = compact("row", "titlelen", 'infolen', 'imgwidth', 'imgheight', 'listtype',
'arcid', 'channelid', 'orderby', 'orderWay', 'subday','pagesize',
'orderby', 'keyword', 'tablewidth', 'col', 'colWidth');
if($innertext=='') $innertext = GetSysTemplets('part_arclist.htm');
if( @$ctag->GetAtt('getall') == 1 ) $getall = 1;
else $getall = 0;
if($att=='0') $att='';
if($att=='3') $att='f';
if($att=='1') $att='h';
$orwheres = array();
$maintable = 'dede_archives';
//按不同情况设定SQL条件 排序方式
if($idlist=='')
{
if($orderby=='near' && $cfg_keyword_like=='N') { $keyword=''; }
if($writer=='this') {
$wmid = isset($refObj->Fields['mid']) ? $refObj->Fields['mid'] : 0;
$orwheres[] = " arc.mid = '$wmid' ";
}
//时间限制(用于调用最近热门文章、热门评论之类)，这里的时间只能计算到天，否则缓存功能将无效
if($subday > 0)
{
$ntime = gmmktime(0, 0, 0, gmdate('m'), gmdate('d'), gmdate('Y'));
$limitday = $ntime - ($subday * 24 * 3600);
$orwheres[] = " arc.senddate > $limitday ";
}
//关键字条件
if($keyword!='')
{
$keyword = str_replace(',', '|', $keyword);
$orwheres[] = " CONCAT(arc.title,arc.keywords) REGEXP '$keyword' ";
}
//文档属性
if(preg_match('/commend/i', $listtype)) $orwheres[] = " FIND_IN_SET('c', arc.flag)>0 ";
if(preg_match('/image/i', $listtype)) $orwheres[] = " FIND_IN_SET('p', arc.flag)>0 ";
if($att != '') {
$flags = explode(',', $att);
for($i=0; isset($flags[$i]); $i++) $orwheres[] = " FIND_IN_SET('{$flags[$i]}', arc.flag)>0 ";
}
if(!empty($typeid) && $typeid != 'top')
{
//指定了多个栏目时，不再获取子类的id
if( preg_match('#,#', $typeid) )
{
//指定了getall属性或主页模板例外
if($getall==1 || empty($refObj->Fields['typeid']))
{
$typeids = explode(',', $typeid);
foreach($typeids as $ttid) {
$typeidss[] = GetSonIds($ttid);
}
$typeidStr = join(',', $typeidss);
$typeidss = explode(',', $typeidStr);
$typeidssok = array_unique($typeidss);
$typeid = join(',', $typeidssok);
}
$orwheres[] = " arc.typeid IN ($typeid) ";
}
else
{
//处理交叉栏目
$CrossID = '';
if($ctag->GetAtt('cross')=='1')
{
$arr = $dsql->GetOne("SELECT `id`,`topid`,`cross`,`crossid`,`ispart`,`typename` FROM `dede_arctype` WHERE id='$typeid' ");
if( $arr['cross']==0 || ( $arr['cross']==2 && trim($arr['crossid']=='') ) )
{
$orwheres[] = ' arc.typeid IN ('.GetSonIds($typeid).')';
}
else
{
$selquery = '';
if($arr['cross']==1) {
$selquery = "SELECT id,topid FROM `dede_arctype` WHERE typename LIKE '{$arr['typename']}' AND id<>'{$typeid}' AND topid<>'{$typeid}' ";
}
else {
$arr['crossid'] = preg_replace('#[^0-9,]#', '', trim($arr['crossid']));
if($arr['crossid']!='') $selquery = "SELECT id,topid FROM `dede_arctype` WHERE id IN('{$arr['crossid']}') AND id<>'{$typeid}' AND topid<>'{$typeid}' ";
}
if($selquery!='')
{
$dsql->SetQuery($selquery);
$dsql->Execute();
while($arr = $dsql->GetArray())
{
$CrossID .= ($CrossID=='' ? $arr['id'] : ','.$arr['id']);
}
}
}
}
if($CrossID=='') $orwheres[] = ' arc.typeid IN ('.GetSonIds($typeid).')';
else $orwheres[] = ' arc.typeid IN ('.GetSonIds($typeid).','.$CrossID.')';
}
}
//频道ID
if(preg_match('#spec#i', $listtype)) $channelid==-1;
if(!empty($channelid)) $orwheres[] = " And arc.channel = '$channelid' ";
if(!empty($noflag))
{
if(!preg_match('#,#', $noflag))
{
$orwheres[] = " FIND_IN_SET('$noflag', arc.flag)<1 ";
}
else
{
$noflags = explode(',', $noflag);
foreach($noflags as $noflag) {
if(trim($noflag)=='') continue;
$orwheres[] = " FIND_IN_SET('$noflag', arc.flag)<1 ";
}
}
}
$orwheres[] = ' arc.arcrank > -1 ';
//由于这个条件会导致缓存功能失去意义，因此取消
//if($arcid!=0) $orwheres[] = " arc.id<>'$arcid' ";
}
//文档排序的方式
$ordersql = '';
if($orderby=='hot' || $orderby=='click') $ordersql = " ORDER BY arc.click $orderWay";
else if($orderby == 'sortrank' || $orderby=='pubdate') $ordersql = " ORDER BY arc.sortrank $orderWay";
else if($orderby == 'id') $ordersql = " ORDER BY arc.id $orderWay";
else if($orderby == 'near') $ordersql = " ORDER BY ABS(arc.id - ".$arcid.")";
else if($orderby == 'lastpost') $ordersql = " ORDER BY arc.lastpost $orderWay";
else if($orderby == 'scores') $ordersql = " ORDER BY arc.scores $orderWay";
//功能：增加按好评数和差评数调用
else if($orderby == 'goodpost') $ordersql = " order by arc.goodpost $orderWay";
else if($orderby == 'badpost') $ordersql = " order by arc.badpost $orderWay";
else if($orderby == 'rand') $ordersql = " ORDER BY rand()";
else $ordersql = " ORDER BY arc.sortrank $orderWay";
if($orderby == 'idlist' && $idlist!=''){
$ordersql = "ORDER BY FIELD(arc.id,$idlist) ";
}
//limit条件
$limit = trim(preg_replace('#limit#is', '', $limit));
if($limit!='')
{
$limitsql = " LIMIT $limit ";
$limitarr = explode(',', $limit);
$line = isset($limitarr[1])? $limitarr[1] : $line;
}
else $limitsql = " LIMIT 0,$line ";
$orwhere = '';
if(isset($orwheres[0])) {
$orwhere = join(' And ',$orwheres);
$orwhere = preg_replace("#^ And#is", '', $orwhere);
$orwhere = preg_replace("#And[ ]{1,}And#is", 'And ', $orwhere);
}
if($orwhere!='') $orwhere = " WHERE $orwhere ";
//获取附加表信息
$addfield = trim($ctag->GetAtt('addfields'));
$addfieldsSql = '';
$addfieldsSqlJoin = '';
if($addfield != '' && !empty($channelid))
{
$row = $dsql->GetOne("SELECT addtable FROM `dede_channeltype` WHERE id='$channelid' ");
if(isset($row['addtable']) && trim($row['addtable']) != '')
{
$addtable = trim($row['addtable']);
$addfields = explode(',', $addfield);
$row['addtable'] = trim($row['addtable']);
$addfieldsSql = ",addf.".join(',addf.', $addfields);
$addfieldsSqlJoin = " LEFT JOIN `$addtable` addf ON addf.aid = arc.id ";
}
}
$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
$addfieldsSql
FROM `$maintable` arc LEFT JOIN `dede_arctype` tp on arc.typeid=tp.id
$addfieldsSqlJoin
$orwhere $ordersql $limitsql";
//统一hash
$taghash = md5(serialize($ctag).$typeid);
$needSaveCache = true;
//进行tagid的默认处理
if($pagesize > 0) $tagid = AttDef($tagid,'tag'.$taghash );
if($idlist!='' || $GLOBALS['_arclistEnv']=='index' || $cfg_index_cache==0)
{
$needSaveCache = false;
}
else
{
$idlist = GetArclistCache($taghash);
if($idlist != '') {
$needSaveCache = false;
}
//如果使用的是内容缓存，直接返回结果
if($cfg_cache_type=='content' && $idlist != '')
{
$idlist = ($idlist==0 ? '' : $idlist);
return $idlist;
}
}
//指定了id或使用缓存中的id
if($idlist != '')
{
$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
$addfieldsSql
FROM `$maintable` arc left join `dede_arctype` tp on arc.typeid=tp.id
$addfieldsSqlJoin
WHERE arc.id in($idlist) $ordersql ";
}
// 好评差评缓存更新
if($cfg_digg_update > 0)
{
if($orderby == 'goodpost' || $orderby == 'badpost')
{
$t1 = ExecTime();
$postsql = "SELECT arc.id,arc.goodpost,arc.badpost,arc.scores
FROM `$maintable` arc
$orwhere $ordersql $limitsql";
if($idlist != '')
{
$postsql = "SELECT arc.id,arc.goodpost,arc.badpost,arc.scores
FROM `$maintable` arc
WHERE arc.id in($idlist) $ordersql ";
}
$dsql->SetQuery($query);
$dsql->Execute('lit');
while ($row = $dsql->GetArray('lit')) {
$prefix = 'diggCache';
$key = 'aid-'.$row['id'];
$cacherow = GetCache($prefix, $key);
$setsql = array();
if(!empty($cacherow['scores']) && $cacherow['scores'] != $row['scores'])
{
$setsql[] = "scores = {$cacherow['scores']}";
}
if(!empty($cacherow['goodpost']) && $cacherow['goodpost'] != $row['goodpost'])
{
$setsql[] = "goodpost = {$cacherow['goodpost']}";
}
if(!empty($cacherow['badpost']) && $cacherow['badpost'] != $row['badpost'])
{
$setsql[] = "badpost = {$cacherow['badpost']}";
}
$setsql = implode(',', $setsql);
$sql = "UPDATE `$maintable` SET {$setsql} WHERE id='{$row['id']}'";
if(!empty($setsql))
{
$dsql->ExecuteNoneQuery($sql);
}
}
//echo ExecTime()-$t1;
}
}
$dsql->SetQuery($query);
$dsql->Execute('al');
//$row = $dsql->GetArray("al");
$artlist = '';
if($pagesize > 0) $artlist .= " <div id='{$tagid}'>\r\n";
if($col > 1) $artlist = "<table width='$tablewidth' border='0' cellspacing='0' cellpadding='0'>\r\n";
$dtp2 = new DedeTagParse();
$dtp2->SetNameSpace('field', '[', ']');
$dtp2->LoadString($innertext);
$GLOBALS['autoindex'] = 0;
$ids = array();
$orderWeight = array();
for($i=0; $i<$line; $i++)
{
if($col>1) $artlist .= "<tr>\r\n";
for($j=0; $j<$col; $j++)
{
if($col>1) $artlist .= " <td width='$colWidth'>\r\n";
if($row = $dsql->GetArray("al"))
{
$ids[] = $row['id'];
//处理一些特殊字段
$row['info'] = $row['infos'] = cn_substr($row['description'],$infolen);
$row['id'] = $row['id'];
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']);
$row['typeurl'] = GetTypeUrl($row['typeid'],$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('#b#', $row['flag'])) $row['title'] = "<strong>".$row['title']."</strong>";
//$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'];
if(is_array($dtp2->CTags))
{
foreach($dtp2->CTags as $k=>$ctag)
{
if($ctag->GetName()=='array')
{
//传递整个数组，在runphp模式中有特殊作用
$dtp2->Assign($k, $row);
} else {
if(isset($row[$ctag->GetName()])) $dtp2->Assign($k,$row[$ctag->GetName()]);
else $dtp2->Assign($k, '');
}
}
$GLOBALS['autoindex']++;
}
if($pagesize > 0)
{
if($GLOBALS['autoindex'] <= $pagesize)
{
$liststr = $dtp2->GetResult();
$artlist .= $liststr."\r\n";
} else {
$artlist .= "";
$orderWeight[] = array(
'weight' => $row['weight'],
'arclist' => ''
);
}
} else {
$liststr = $dtp2->GetResult();
$artlist .= $liststr."\r\n";
}
$orderWeight[] = array(
'weight' => $row['weight'],
'arclist' => $liststr
);
}//if hasRow
else{
$artlist .= '';
}
// 进行判断,如果启用排序则内容输出为重新排序后的内容
// var_dump($isweight=='y' && count($orderWeight) == $line);
$isweight = strtolower($isweight);
if ( $isweight=='y' )
{
$artlist = '';
$orderWeight = list_sort_by($orderWeight, 'weight', 'asc');
foreach ($orderWeight as $vv) {
$artlist .= $vv['arclist'];
}
}
if($col>1) $artlist .= " </td>\r\n";
}//Loop Col
if($col>1) $i += $col - 1;
if($col>1) $artlist .= " </tr>\r\n";
}//loop line
if($col>1) $artlist .= " </table>\r\n";
$dsql->FreeResult("al");
$idsstr = join(',', $ids);
//分页特殊处理
if($pagesize > 0)
{
$artlist .= " </div>\r\n";
$row = $dsql->GetOne("SELECT tagid FROM dede_arcmulti WHERE tagid='$tagid'");
$uptime = time();
$attstr = addslashes(serialize($attarray));
$innertext = addslashes($innertext);
if(!is_array($row))
{
$query = "
INSERT INTO dede_arcmulti(tagid,uptime,innertext,pagesize,arcids,ordersql,addfieldsSql,addfieldsSqlJoin,attstr)
VALUES('$tagid','$uptime','$innertext','$pagesize','$idsstr','$ordersql','$addfieldsSql','$addfieldsSqlJoin','$attstr');
";
$dsql->ExecuteNoneQuery($query);
} else {
$query = "UPDATE `dede_arcmulti`
SET
uptime='$uptime',
innertext='$innertext',
pagesize='$pagesize',
arcids='$idsstr',
ordersql='$ordersql',
addfieldsSql='$addfieldsSql',
addfieldsSqlJoin='$addfieldsSqlJoin',
attstr='$attstr'
WHERE tagid='$tagid'
";
$dsql->ExecuteNoneQuery($query);
}
}
//保存ID缓存
if($needSaveCache)
{
if($idsstr=='') $idsstr = '0';
if($cfg_cache_type=='content' && $idsstr!='0') {
$idsstr = addslashes($artlist);
}
$inquery = "INSERT INTO `dede_arccache`(`md5hash`,`uptime`,`cachedata`) VALUES ('".$taghash."','".time()."', '$idsstr'); ";
$dsql->ExecuteNoneQuery("DELETE FROM `dede_arccache` WHERE md5hash='".$taghash."' ");
$dsql->ExecuteNoneQuery($inquery);
}
return $artlist;
}
/**
* 查询缓存
*
* @access public
* @param string $md5hash 唯一识别hash
* @return string
*/
function GetArclistCache($md5hash)
{
global $dsql,$envs,$cfg_makesign_cache,$cfg_index_cache,$cfg_cache_type;
if($cfg_index_cache <= 0) return '';
if(isset($envs['makesign']) && $cfg_makesign_cache=='N') return '';
$mintime = time() - $cfg_index_cache;
$arr = $dsql->GetOne("SELECT cachedata,uptime FROM `dede_arccache` WHERE md5hash = '$md5hash' ");
if(!is_array($arr)) {
return '';
}
else if($arr['uptime'] < $mintime) {
return '';
}
else {
return $arr['cachedata'];
}
}
/**
* 获取自动频道ID
*
* @access public
* @param string $sortid
* @param string $topid
* @return string
*/
function lib_GetAutoChannelID($sortid, $topid)
{
global $dsql;
if(empty($sortid)) $sortid = 1;
$getstart = $sortid - 1;
$row = $dsql->GetOne("SELECT id,typename FROM dede_arctype WHERE reid='{$topid}' And ispart<2 And ishidden<>'1' ORDER BY sortrank asc limit $getstart,1");
if(!is_array($row)) return 0;
else return $row['id'];
}
/**
* 对查询结果集进行排序
*
* @access public
* @param array $list 查询结果
* @param string $field 排序的字段名
* @param array $sortby 排序类型
* asc正向排序 desc逆向排序 nat自然排序
* @return array
*/
function list_sort_by($list, $field, $sortby='asc') {
if(is_array($list)){
$refer = $resultSet = array();
foreach ($list as $i => $data)
$refer[$i] = &$data[$field];
switch ($sortby) {
case 'asc': // 正向排序
asort($refer);
break;
case 'desc':// 逆向排序
arsort($refer);
break;
case 'nat': // 自然排序
natcasesort($refer);
break;
}
foreach ( $refer as $key=> $val)
$resultSet[] = &$list[$key];
return $resultSet;
}
return false;
}<?php if(!defined('DEDEINC')) exit('Request Error!');
/**
* 文章列表调用标记
*
* 9:19 2010年7月13日:修正对isweight属性的支持
*
* @version $Id: arclist.lib.php 3 9:19 2010年7月13日Z tianya $
* @package DedeCMS.Taglib
* @copyright Copyright (c) 2007 - 2010, DesDev, Inc.
* @license http://help.dedecms.com/usersguide/license.html
* @link http://www.dedecms.com
*/
/**
* arclist解析标签
*
* @access public
* @param object $ctag 解析标签
* @param object $refObj 引用对象
* @return string 成功后返回解析后的标签内容
*/
/*>>dede>>
<name>文档列表</name>
<type>全局标记</type>
<for>V55,V56,V57</for>
<description>获取指定文档列表</description>
<demo>
{dede:arclist flag='h' typeid='' row='' col='' titlelen='' infolen='' imgwidth='' imgheight='' listtype='' orderby='' keyword='' limit='0,1'}
<a href='[field:arcurl/]'>[field:title/]</a>
{/dede:arclist}
</demo>
<attributes>
<iterm>col:分多少列显示（默认为单列），5.3版中本属性可以通过多种方式进行多行显示</iterm>
<iterm>row:返回文档列表总数</iterm>
<iterm>typeid:栏目ID,在列表模板和档案模板中一般不需要指定，在首页模板中允许用","分开表示多个栏目</iterm>
<iterm>getall:在没有指定这属性的情况下,在栏目页、文章页模板,不会获取以","分开的多个栏目的下级子类</iterm>
<iterm>titlelen:标题长度 等同于titlelength</iterm>
<iterm>infolen:表示内容简介长度 等同于infolength</iterm>
<iterm>imgwidth:缩略图宽度</iterm>
<iterm>imgheight:缩略图高度</iterm>
<iterm>listtype: 栏目类型 image含有缩略图 commend推荐</iterm>
<iterm>orderby:文档排序方式</iterm>
<iterm>keyword:含有指定关键字的文档列表，多个关键字用","分</iterm>
<iterm>innertext:单条记录样式</iterm>
<iterm>aid:指定文档ID</iterm>
<iterm>idlist:提取特定文档（文档ID</iterm>
<iterm>channelid:频道ID</iterm>
<iterm>limit:（起始ID从0开始）表示限定的记录范围（如：limit='1,2' 表示从ID为1的记录开始，取2条记录</iterm>
<iterm>flag:自定义属性值：头条[h]推荐[c]图片[p]幻灯[f]滚动[s]跳转[j]图文[a]加粗[b]</iterm>
<iterm>noflag:同flag，但这里是表示不包含这些属性</iterm>
<iterm>orderway:值为 desc 或 asc ，指定排序方式是降序还是顺向排序，默认为降序</iterm>
<iterm>subday:表示在多少天以内的文档</iterm>
</attributes>
>>dede>>*/
function lib_arclist( &$ctag, &$refObj )
{
global $envs;
$autopartid = 0;
$tagid = '';
$tagname = $ctag->GetTagName();
$channelid = $ctag->GetAtt('channelid');
//增加对分页内容的处理
$pagesize = $ctag->GetAtt('pagesize');
if($pagesize == '')
{
$multi = 0;
} else {
$tagid = $ctag->GetAtt('tagid');
}
// arclist是否需要weight排序,默认为"N",如果需要排序则设置为"Y"
$isweight = $ctag->GetAtt('isweight');
if($tagname=='imglist' || $tagname=='imginfolist') {
$listtype = 'image';
}
else if($tagname=='specart') {
$channelid = -1;
$listtype='';
}
else if($tagname=='coolart') {
$listtype = 'commend';
}
else if($tagname=='autolist') {
$autopartid = $ctag->GetAtt('partsort');
}
else {
$listtype = $ctag->GetAtt('type');
}
//排序
if($ctag->GetAtt('sort')!='') $orderby = $ctag->GetAtt('sort');
else if($tagname=='hotart') $orderby = 'click';
else $orderby = $ctag->GetAtt('orderby');
//对相应的标记使用不同的默认innertext
if(trim($ctag->GetInnerText()) != '') $innertext = $ctag->GetInnerText();
else if($tagname=='imglist') $innertext = GetSysTemplets('part_imglist.htm');
else if($tagname=='imginfolist') $innertext = GetSysTemplets('part_imginfolist.htm');
else $innertext = GetSysTemplets("part_arclist.htm");
//兼容titlelength
if($ctag->GetAtt('titlelength')!='') $titlelen = $ctag->GetAtt('titlelength');
else $titlelen = $ctag->GetAtt('titlelen');
//兼容infolength
if($ctag->GetAtt('infolength')!='') $infolen = $ctag->GetAtt('infolength');
else $infolen = $ctag->GetAtt('infolen');
$typeid = trim($ctag->GetAtt('typeid'));
if(empty($typeid)) {
$typeid = ( isset($refObj->Fields['typeid']) ? $refObj->Fields['typeid'] : $envs['typeid'] );
}
$idlist = $ctag->GetAtt('idlist');
if(!empty($idlist)){
if($idlist == 'typesnews'){
$idlist = isset($refObj->Fields['typesnews']) ? $refObj->Fields['typesnews'] : '';
if(empty($idlist)){
$idlist = '0';
}
}
}
if($listtype=='autolist') {
$typeid = lib_GetAutoChannelID($ctag->GetAtt('partsort'),$typeid);
}
if($ctag->GetAtt('att')=='') {
$flag = $ctag->GetAtt('flag');
}
else {
$flag = $ctag->GetAtt('att');
}
return lib_arclistDone
(
$refObj, $ctag, $typeid, $ctag->GetAtt('row'), $ctag->GetAtt('col'), $titlelen, $infolen,
$ctag->GetAtt('imgwidth'), $ctag->GetAtt('imgheight'), $listtype, $orderby,
$ctag->GetAtt('keyword'), $innertext, $envs['aid'], $idlist, $channelid,
$ctag->GetAtt('limit'), $flag,$ctag->GetAtt('orderway'), $ctag->GetAtt('subday'), $ctag->GetAtt('noflag'),
$tagid,$pagesize,$isweight
);
}
/**
* arclist解析函数
*
* @access public
* @param object $refObj 引用对象
* @param object $ctag 标签
* @param int $typeid 栏目ID
* @param int $row 调用行数
* @param int $titlelen 字符串长度
* @param int $infolen 描述信息长度
* @param int $imgwidth 图片宽度
* @param int $imgheight 图片高度
* @param string $listtype 列表类型
* @param string $orderby 排列顺序
* @param string $keyword 关键词
* @param string $innertext 底层模板
* @param int $arcid 文档ID
* @param string $idlist ID列表
* @param int $channelid 频道ID
* @param string $limit 限制
* @param string $att 属性
* @param string $order 排序类型
* @param int $subday 天内
* @param string $noflag 属性标记
* @param string $tagid 标签id
* @param string $pagesize 显示条数
* @param string $isweight 是否需要对检索出来的内容按照weight排序
* @return string
*/
function lib_arclistDone(&$refObj, &$ctag, $typeid=0, $row=10, $col=1, $titlelen=30, $infolen=160,
$imgwidth=120, $imgheight=90, $listtype='all', $orderby='default', $keyword='',
$innertext='', $arcid=0, $idlist='', $channelid=0, $limit='', $att='', $order='desc', $subday=0, $noflag='',$tagid='', $pagesize=0, $isweight='N')
{
global $dsql,$PubFields,$cfg_keyword_like,$cfg_index_cache,$_arclistEnv,$envs,$cfg_cache_type,$cfg_digg_update;
$row = AttDef($row,10);
$titlelen = AttDef($titlelen,30);
$infolen = AttDef($infolen,160);
$imgwidth = AttDef($imgwidth,120);
$imgheight = AttDef($imgheight,120);
$listtype = AttDef($listtype,'all');
$arcid = AttDef($arcid,0);
$channelid = AttDef($channelid,0);
$orderby = AttDef($orderby,'default');
$orderWay = AttDef($order,'desc');
$subday = AttDef($subday,0);
$pagesize = AttDef($pagesize,0);
$line = $row;
$orderby = strtolower($orderby);
$keyword = trim($keyword);
$innertext = trim($innertext);
$tablewidth = $ctag->GetAtt('tablewidth');
$writer = $ctag->GetAtt('writer');
if($tablewidth == "") $tablewidth = 100;
if(empty($col)) $col = 1;
$colWidth = ceil(100/$col);
$tablewidth = $tablewidth."%";
$colWidth = $colWidth."%";
//记录属性,以便分页样式统一调用
$attarray = compact("row", "titlelen", 'infolen', 'imgwidth', 'imgheight', 'listtype',
'arcid', 'channelid', 'orderby', 'orderWay', 'subday','pagesize',
'orderby', 'keyword', 'tablewidth', 'col', 'colWidth');
if($innertext=='') $innertext = GetSysTemplets('part_arclist.htm');
if( @$ctag->GetAtt('getall') == 1 ) $getall = 1;
else $getall = 0;
if($att=='0') $att='';
if($att=='3') $att='f';
if($att=='1') $att='h';
$orwheres = array();
$maintable = 'dede_archives';
//按不同情况设定SQL条件 排序方式
if($idlist=='')
{
if($orderby=='near' && $cfg_keyword_like=='N') { $keyword=''; }
if($writer=='this') {
$wmid = isset($refObj->Fields['mid']) ? $refObj->Fields['mid'] : 0;
$orwheres[] = " arc.mid = '$wmid' ";
}
//时间限制(用于调用最近热门文章、热门评论之类)，这里的时间只能计算到天，否则缓存功能将无效
if($subday > 0)
{
$ntime = gmmktime(0, 0, 0, gmdate('m'), gmdate('d'), gmdate('Y'));
$limitday = $ntime - ($subday * 24 * 3600);
$orwheres[] = " arc.senddate > $limitday ";
}
//关键字条件
if($keyword!='')
{
$keyword = str_replace(',', '|', $keyword);
$orwheres[] = " CONCAT(arc.title,arc.keywords) REGEXP '$keyword' ";
}
//文档属性
if(preg_match('/commend/i', $listtype)) $orwheres[] = " FIND_IN_SET('c', arc.flag)>0 ";
if(preg_match('/image/i', $listtype)) $orwheres[] = " FIND_IN_SET('p', arc.flag)>0 ";
if($att != '') {
$flags = explode(',', $att);
for($i=0; isset($flags[$i]); $i++) $orwheres[] = " FIND_IN_SET('{$flags[$i]}', arc.flag)>0 ";
}
if(!empty($typeid) && $typeid != 'top')
{
//指定了多个栏目时，不再获取子类的id
if( preg_match('#,#', $typeid) )
{
//指定了getall属性或主页模板例外
if($getall==1 || empty($refObj->Fields['typeid']))
{
$typeids = explode(',', $typeid);
foreach($typeids as $ttid) {
$typeidss[] = GetSonIds($ttid);
}
$typeidStr = join(',', $typeidss);
$typeidss = explode(',', $typeidStr);
$typeidssok = array_unique($typeidss);
$typeid = join(',', $typeidssok);
}
$orwheres[] = " arc.typeid IN ($typeid) ";
}
else
{
//处理交叉栏目
$CrossID = '';
if($ctag->GetAtt('cross')=='1')
{
$arr = $dsql->GetOne("SELECT `id`,`topid`,`cross`,`crossid`,`ispart`,`typename` FROM `dede_arctype` WHERE id='$typeid' ");
if( $arr['cross']==0 || ( $arr['cross']==2 && trim($arr['crossid']=='') ) )
{
$orwheres[] = ' arc.typeid IN ('.GetSonIds($typeid).')';
}
else
{
$selquery = '';
if($arr['cross']==1) {
$selquery = "SELECT id,topid FROM `dede_arctype` WHERE typename LIKE '{$arr['typename']}' AND id<>'{$typeid}' AND topid<>'{$typeid}' ";
}
else {
$arr['crossid'] = preg_replace('#[^0-9,]#', '', trim($arr['crossid']));
if($arr['crossid']!='') $selquery = "SELECT id,topid FROM `dede_arctype` WHERE id IN('{$arr['crossid']}') AND id<>'{$typeid}' AND topid<>'{$typeid}' ";
}
if($selquery!='')
{
$dsql->SetQuery($selquery);
$dsql->Execute();
while($arr = $dsql->GetArray())
{
$CrossID .= ($CrossID=='' ? $arr['id'] : ','.$arr['id']);
}
}
}
}
if($CrossID=='') $orwheres[] = ' arc.typeid IN ('.GetSonIds($typeid).')';
else $orwheres[] = ' arc.typeid IN ('.GetSonIds($typeid).','.$CrossID.')';
}
}
//频道ID
if(preg_match('#spec#i', $listtype)) $channelid==-1;
if(!empty($channelid)) $orwheres[] = " And arc.channel = '$channelid' ";
if(!empty($noflag))
{
if(!preg_match('#,#', $noflag))
{
$orwheres[] = " FIND_IN_SET('$noflag', arc.flag)<1 ";
}
else
{
$noflags = explode(',', $noflag);
foreach($noflags as $noflag) {
if(trim($noflag)=='') continue;
$orwheres[] = " FIND_IN_SET('$noflag', arc.flag)<1 ";
}
}
}
$orwheres[] = ' arc.arcrank > -1 ';
//由于这个条件会导致缓存功能失去意义，因此取消
//if($arcid!=0) $orwheres[] = " arc.id<>'$arcid' ";
}
//文档排序的方式
$ordersql = '';
if($orderby=='hot' || $orderby=='click') $ordersql = " ORDER BY arc.click $orderWay";
else if($orderby == 'sortrank' || $orderby=='pubdate') $ordersql = " ORDER BY arc.sortrank $orderWay";
else if($orderby == 'id') $ordersql = " ORDER BY arc.id $orderWay";
else if($orderby == 'near') $ordersql = " ORDER BY ABS(arc.id - ".$arcid.")";
else if($orderby == 'lastpost') $ordersql = " ORDER BY arc.lastpost $orderWay";
else if($orderby == 'scores') $ordersql = " ORDER BY arc.scores $orderWay";
//功能：增加按好评数和差评数调用
else if($orderby == 'goodpost') $ordersql = " order by arc.goodpost $orderWay";
else if($orderby == 'badpost') $ordersql = " order by arc.badpost $orderWay";
else if($orderby == 'rand') $ordersql = " ORDER BY rand()";
else $ordersql = " ORDER BY arc.sortrank $orderWay";
if($orderby == 'idlist' && $idlist!=''){
$ordersql = "ORDER BY FIELD(arc.id,$idlist) ";
}
//limit条件
$limit = trim(preg_replace('#limit#is', '', $limit));
if($limit!='')
{
$limitsql = " LIMIT $limit ";
$limitarr = explode(',', $limit);
$line = isset($limitarr[1])? $limitarr[1] : $line;
}
else $limitsql = " LIMIT 0,$line ";
$orwhere = '';
if(isset($orwheres[0])) {
$orwhere = join(' And ',$orwheres);
$orwhere = preg_replace("#^ And#is", '', $orwhere);
$orwhere = preg_replace("#And[ ]{1,}And#is", 'And ', $orwhere);
}
if($orwhere!='') $orwhere = " WHERE $orwhere ";
//获取附加表信息
$addfield = trim($ctag->GetAtt('addfields'));
$addfieldsSql = '';
$addfieldsSqlJoin = '';
if($addfield != '' && !empty($channelid))
{
$row = $dsql->GetOne("SELECT addtable FROM `dede_channeltype` WHERE id='$channelid' ");
if(isset($row['addtable']) && trim($row['addtable']) != '')
{
$addtable = trim($row['addtable']);
$addfields = explode(',', $addfield);
$row['addtable'] = trim($row['addtable']);
$addfieldsSql = ",addf.".join(',addf.', $addfields);
$addfieldsSqlJoin = " LEFT JOIN `$addtable` addf ON addf.aid = arc.id ";
}
}
$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
$addfieldsSql
FROM `$maintable` arc LEFT JOIN `dede_arctype` tp on arc.typeid=tp.id
$addfieldsSqlJoin
$orwhere $ordersql $limitsql";
//统一hash
$taghash = md5(serialize($ctag).$typeid);
$needSaveCache = true;
//进行tagid的默认处理
if($pagesize > 0) $tagid = AttDef($tagid,'tag'.$taghash );
if($idlist!='' || $GLOBALS['_arclistEnv']=='index' || $cfg_index_cache==0)
{
$needSaveCache = false;
}
else
{
$idlist = GetArclistCache($taghash);
if($idlist != '') {
$needSaveCache = false;
}
//如果使用的是内容缓存，直接返回结果
if($cfg_cache_type=='content' && $idlist != '')
{
$idlist = ($idlist==0 ? '' : $idlist);
return $idlist;
}
}
//指定了id或使用缓存中的id
if($idlist != '')
{
$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
$addfieldsSql
FROM `$maintable` arc left join `dede_arctype` tp on arc.typeid=tp.id
$addfieldsSqlJoin
WHERE arc.id in($idlist) $ordersql ";
}
// 好评差评缓存更新
if($cfg_digg_update > 0)
{
if($orderby == 'goodpost' || $orderby == 'badpost')
{
$t1 = ExecTime();
$postsql = "SELECT arc.id,arc.goodpost,arc.badpost,arc.scores
FROM `$maintable` arc
$orwhere $ordersql $limitsql";
if($idlist != '')
{
$postsql = "SELECT arc.id,arc.goodpost,arc.badpost,arc.scores
FROM `$maintable` arc
WHERE arc.id in($idlist) $ordersql ";
}
$dsql->SetQuery($query);
$dsql->Execute('lit');
while ($row = $dsql->GetArray('lit')) {
$prefix = 'diggCache';
$key = 'aid-'.$row['id'];
$cacherow = GetCache($prefix, $key);
$setsql = array();
if(!empty($cacherow['scores']) && $cacherow['scores'] != $row['scores'])
{
$setsql[] = "scores = {$cacherow['scores']}";
}
if(!empty($cacherow['goodpost']) && $cacherow['goodpost'] != $row['goodpost'])
{
$setsql[] = "goodpost = {$cacherow['goodpost']}";
}
if(!empty($cacherow['badpost']) && $cacherow['badpost'] != $row['badpost'])
{
$setsql[] = "badpost = {$cacherow['badpost']}";
}
$setsql = implode(',', $setsql);
$sql = "UPDATE `$maintable` SET {$setsql} WHERE id='{$row['id']}'";
if(!empty($setsql))
{
$dsql->ExecuteNoneQuery($sql);
}
}
//echo ExecTime()-$t1;
}
}
$dsql->SetQuery($query);
$dsql->Execute('al');
//$row = $dsql->GetArray("al");
$artlist = '';
if($pagesize > 0) $artlist .= " <div id='{$tagid}'>\r\n";
if($col > 1) $artlist = "<table width='$tablewidth' border='0' cellspacing='0' cellpadding='0'>\r\n";
$dtp2 = new DedeTagParse();
$dtp2->SetNameSpace('field', '[', ']');
$dtp2->LoadString($innertext);
$GLOBALS['autoindex'] = 0;
$ids = array();
$orderWeight = array();
for($i=0; $i<$line; $i++)
{
if($col>1) $artlist .= "<tr>\r\n";
for($j=0; $j<$col; $j++)
{
if($col>1) $artlist .= " <td width='$colWidth'>\r\n";
if($row = $dsql->GetArray("al"))
{
$ids[] = $row['id'];
//处理一些特殊字段
$row['info'] = $row['infos'] = cn_substr($row['description'],$infolen);
$row['id'] = $row['id'];
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']);
$row['typeurl'] = GetTypeUrl($row['typeid'],$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('#b#', $row['flag'])) $row['title'] = "<strong>".$row['title']."</strong>";
//$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'];
if(is_array($dtp2->CTags))
{
foreach($dtp2->CTags as $k=>$ctag)
{
if($ctag->GetName()=='array')
{
//传递整个数组，在runphp模式中有特殊作用
$dtp2->Assign($k, $row);
} else {
if(isset($row[$ctag->GetName()])) $dtp2->Assign($k,$row[$ctag->GetName()]);
else $dtp2->Assign($k, '');
}
}
$GLOBALS['autoindex']++;
}
if($pagesize > 0)
{
if($GLOBALS['autoindex'] <= $pagesize)
{
$liststr = $dtp2->GetResult();
$artlist .= $liststr."\r\n";
} else {
$artlist .= "";
$orderWeight[] = array(
'weight' => $row['weight'],
'arclist' => ''
);
}
} else {
$liststr = $dtp2->GetResult();
$artlist .= $liststr."\r\n";
}
$orderWeight[] = array(
'weight' => $row['weight'],
'arclist' => $liststr
);
}//if hasRow
else{
$artlist .= '';
}
// 进行判断,如果启用排序则内容输出为重新排序后的内容
// var_dump($isweight=='y' && count($orderWeight) == $line);
$isweight = strtolower($isweight);
if ( $isweight=='y' )
{
$artlist = '';
$orderWeight = list_sort_by($orderWeight, 'weight', 'asc');
foreach ($orderWeight as $vv) {
$artlist .= $vv['arclist'];
}
}
if($col>1) $artlist .= " </td>\r\n";
}//Loop Col
if($col>1) $i += $col - 1;
if($col>1) $artlist .= " </tr>\r\n";
}//loop line
if($col>1) $artlist .= " </table>\r\n";
$dsql->FreeResult("al");
$idsstr = join(',', $ids);
//分页特殊处理
if($pagesize > 0)
{
$artlist .= " </div>\r\n";
$row = $dsql->GetOne("SELECT tagid FROM dede_arcmulti WHERE tagid='$tagid'");
$uptime = time();
$attstr = addslashes(serialize($attarray));
$innertext = addslashes($innertext);
if(!is_array($row))
{
$query = "
INSERT INTO dede_arcmulti(tagid,uptime,innertext,pagesize,arcids,ordersql,addfieldsSql,addfieldsSqlJoin,attstr)
VALUES('$tagid','$uptime','$innertext','$pagesize','$idsstr','$ordersql','$addfieldsSql','$addfieldsSqlJoin','$attstr');
";
$dsql->ExecuteNoneQuery($query);
} else {
$query = "UPDATE `dede_arcmulti`
SET
uptime='$uptime',
innertext='$innertext',
pagesize='$pagesize',
arcids='$idsstr',
ordersql='$ordersql',
addfieldsSql='$addfieldsSql',
addfieldsSqlJoin='$addfieldsSqlJoin',
attstr='$attstr'
WHERE tagid='$tagid'
";
$dsql->ExecuteNoneQuery($query);
}
}
//保存ID缓存
if($needSaveCache)
{
if($idsstr=='') $idsstr = '0';
if($cfg_cache_type=='content' && $idsstr!='0') {
$idsstr = addslashes($artlist);
}
$inquery = "INSERT INTO `dede_arccache`(`md5hash`,`uptime`,`cachedata`) VALUES ('".$taghash."','".time()."', '$idsstr'); ";
$dsql->ExecuteNoneQuery("DELETE FROM `dede_arccache` WHERE md5hash='".$taghash."' ");
$dsql->ExecuteNoneQuery($inquery);
}
return $artlist;
}
/**
* 查询缓存
*
* @access public
* @param string $md5hash 唯一识别hash
* @return string
*/
function GetArclistCache($md5hash)
{
global $dsql,$envs,$cfg_makesign_cache,$cfg_index_cache,$cfg_cache_type;
if($cfg_index_cache <= 0) return '';
if(isset($envs['makesign']) && $cfg_makesign_cache=='N') return '';
$mintime = time() - $cfg_index_cache;
$arr = $dsql->GetOne("SELECT cachedata,uptime FROM `dede_arccache` WHERE md5hash = '$md5hash' ");
if(!is_array($arr)) {
return '';
}
else if($arr['uptime'] < $mintime) {
return '';
}
else {
return $arr['cachedata'];
}
}
/**
* 获取自动频道ID
*
* @access public
* @param string $sortid
* @param string $topid
* @return string
*/
function lib_GetAutoChannelID($sortid, $topid)
{
global $dsql;
if(empty($sortid)) $sortid = 1;
$getstart = $sortid - 1;
$row = $dsql->GetOne("SELECT id,typename FROM dede_arctype WHERE reid='{$topid}' And ispart<2 And ishidden<>'1' ORDER BY sortrank asc limit $getstart,1");
if(!is_array($row)) return 0;
else return $row['id'];
}
/**
* 对查询结果集进行排序
*
* @access public
* @param array $list 查询结果
* @param string $field 排序的字段名
* @param array $sortby 排序类型
* asc正向排序 desc逆向排序 nat自然排序
* @return array
*/
function list_sort_by($list, $field, $sortby='asc') {
if(is_array($list)){
$refer = $resultSet = array();
foreach ($list as $i => $data)
$refer[$i] = &$data[$field];
switch ($sortby) {
case 'asc': // 正向排序
asort($refer);
break;
case 'desc':// 逆向排序
arsort($refer);
break;
case 'nat': // 自然排序
natcasesort($refer);
break;
}
foreach ( $refer as $key=> $val)
$resultSet[] = &$list[$key];
return $resultSet;
}
return false;
}
修改完成后前台就可以使用
{dede:arclist idlist='typesnews' orderby='idlist' }进行调用
typesnews是你的自定义字段名
orderby='idlist' 是按照你填写的文章id顺序显示到前台，你可在后台自定义字段的地方填写1,3,2按填写顺序调用多个文章
厉害吧，如果觉得有用千万别忘了收藏。如有不明白处咨询QQ：286601999，免费为您解答。
技术支持
相关阅读
- 1将文本垂直居中08-06
- 2dede:arclist按照自定义字段的条件调05-07
- 3js把英文逗号换成中文逗号04-01
- 4dede编辑器添加MP4视频上传功能01-08
- 5ssl证书12-22
- 6dede简单把分页页码改成英文10-30
- 7IIS7 环境中http重定向到https的设置04-01
- 8dedecms安全漏洞之/include/common.inc06-04
- 9织梦DEDE include/dedesql.class.php变量覆06-04
- 10dede自定义表单发送邮件提醒（非05-17
- 11dede列表页异步加载，点击加载更04-30
- 12正则表达式应用——实例应用04-25
- 13dede自定义表单防止恶意提交，增04-11
- 14goole地图API代码生成制作01-24
- 15CSS:text-fill-color 给文字增加图片蒙01-22
