-
家政服务保姆月嫂类网站...
-
装修设计类网站织梦模板...
-
鲜花商城购物类网站织梦...
-
QQ个性空间日志资讯类网...
-
防腐木材工程类网站织梦...
-
中英双语窗帘门窗设计类...
-
物流快运速递类网站织梦...
-
仪器仪表科技公司类网站...
-
智能电子玩具类网站织梦...
-
财富管理培训咨询类网站...
-
新闻博客资讯类网站织梦...
-
茶几茶盘类网站织梦模板...
-
产品展示柜台类网站织梦...
-
汽车用品配件类网站织梦...
-
精工机械轴承加工类网站...
-
仪器分析仪类网站织梦模...
-
网络品牌广告设计类网站...
-
搬家搬迁公司类网站织梦...
-
网站建设万词霸屏SEO优化...
-
财经新闻资讯网类织梦模...
我们需要操作的就是修改织梦内核的文件
教程如下
打开include/arc.listview.class.php,找到:
//假如不消默认的sortrank或id排序,利用连系查询(数据量大时很是迟钝)if(preg_match('/hot|click|lastpost|title/', $orderby)){$query = "SELECT arc.*,tp.typedir,tp.typename,tp.isdefault,tp.defaultname,tp.namerule,tp.namerule2,tp.ispart,tp.moresite,tp.siteurl,tp.sitepath$addFieldFROM `js_archives` arcLEFT JOIN `js_arctype` tp ON arc.typeid=tp.id$addJoinWHERE {$this->addSql} $ordersql LIMIT $limitstart,$row";}//普通环境先从arctiny表查出ID,然后按ID查询(速度很是快)else{$t1 = ExecTime();$ids = array();$query = "SELECT id FROM `js_arctiny` arc WHERE {$this->addSql} $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$addFieldFROM `js_archives` arc LEFT JOIN `js_arctype` tp ON arc.typeid=tp.id$addJoinWHERE arc.id in($idstr) $ordersql ";}$t2 = ExecTime();//echo $t2-$t1;}
改成
if($orderby=="default"){$t1 = ExecTime();$ids = array();$query = "SELECT id FROM `js_arctiny` arc WHERE {$this->addSql} $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$addFieldFROM `js_archives` arc LEFT JOIN `js_arctype` tp ON arc.typeid=tp.id$addJoinWHERE arc.id in($idstr) $ordersql ";}$t2 = ExecTime();//echo $t2-$t1;}else{$query = "SELECT arc.*,tp.typedir,tp.typename,tp.isdefault,tp.defaultname,tp.namerule,tp.namerule2,tp.ispart,tp.moresite,tp.siteurl,tp.sitepath$addFieldFROM `js_archives` arcLEFT JOIN `js_arctype` tp ON arc.typeid=tp.id$addJoinWHERE {$this->addSql} $ordersql LIMIT $limitstart,$row";}
再找到
else {$ordersql=" ORDER BY arc.sortrank $orderWay";}
改成
else if($orderby=="default"){$ordersql=" ORDER BY arc.sortrank $orderWay";}else{$ordersql=" ORDER BY ".$orderby.",arc.sortrank $orderWay";}
前端模板代码如下
{dede:list pagesize='10' orderby='arc.title desc,arc.id'}


