if( empty($arcid) || $byabs==0 ) {
$orderquery = " order by arc.id desc ";
}
else {
$orderquery = " order by ABS(arc.id - ".$arcid.") ";
}
likearticle标签默认的排序方式。赋予标签orderby属性那么这段代码就没意义了，先在源码中注释掉这段代码
直接延用默认的order by 子句变量$orderquery,这样sql语句就不用做更改了。
创建新变量 orderquery='';//mysql 查询语句中的order by子句 初始为空
然后根据传递的值做相应的判断，在这里只做一些最常用的值的判断
根据$orderby的值做不同的orderby 查询
if($orderby=='hot' || $orderby=='click') $orderquery = " order by arc.click $orderWay";
else if($orderby == 'sortrank' || $orderby=='pubdate') $orderquery = " order by arc.sortrank $orderWay";
else if($orderby == 'id') $orderquery = " order by arc.id $orderWay";
else if($orderby == 'near') $orderquery = " order by ABS(arc.id - ".$arcid.")";
else if($orderby == 'lastpost') $orderquery = " order by arc.lastpost $orderWay";
else if($orderby == 'scores') $orderquery = " order by arc.scores $orderWay";
else if($orderby == 'rand') $orderquery = " order by rand()";
else if($orderby == 'weight') $orderquery = " order by arc.weight asc";//如果没有特定设置排序则按照权重先排序
else $orderquery = " order by arc.sortrank $orderWay";
ok这样就为likearticle标签增加了完整的order by 属性
2.subday属性（标签获取subday指定的最近几天的数据）
同样先获得subday 的属性值
$subday=$ctag->GetAtt('subday');
然后做时间差计算
if($subday > 0)
{
$ntime = gmmktime(0,gmdate('m'),gmdate('d'),gmdate('Y'));
$limitday = $ntime - ($subday * 24 * 3600);
$subdaysql = " and arc.senddate > $limitday ";
}
然后在标签源码的两处sql查询语句中 增加$subdaysql子句判断
第一处为：
$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
from `dede_archives` arc left join `dede_arctype` tp on arc.typeid=tp.id
where arc.arcrank>-1 and ($keyword) $typeid $orderquery limit 0,$row";
修改为:
$query = "Select arc.*,tp.sitepath
from `dede_archives` arc left join `dede_arctype` tp on arc.typeid=tp.id
where arc.arcrank>-1 and ($keyword) $typeid $subdaysql $orderquery limit 0,$row";
第二处为：
$query = "Select arc.*,tp.sitepath
from `dede_archives` arc left join `dede_arctype` tp on arc.typeid=tp.id
where arc.arcrank>-1 and $typeid $orderquery limit 0,$row";
修改为：
$query = "Select arc.*,tp.sitepath
from `dede_archives` arc left join `dede_arctype` tp on arc.typeid=tp.id
where arc.arcrank>-1 and $typeid $subdaysql $orderquery limit 0,$row";
做完以上更改就为likearticle标签增加了subday属性
以下为修改完之后的likearticle.lib.php的完整代码（增加了 orderby 和 subday 属性）
修改之后完整文件：
查看源码打印代码帮助
|
