-
潮流資訊信息類網(wǎng)站織夢(mèng)...
-
中藥藥材百科資訊類網(wǎng)站...
-
APP應(yīng)用程序官網(wǎng)類網(wǎng)站織...
-
環(huán)保設(shè)備研發(fā)制造類網(wǎng)站...
-
車輛機(jī)油工業(yè)潤(rùn)滑油類網(wǎng)...
-
園林景觀設(shè)計(jì)類網(wǎng)站織夢(mèng)...
-
水上樂園設(shè)備類網(wǎng)站織夢(mèng)...
-
汽車配件類網(wǎng)站織夢(mèng)模板...
-
網(wǎng)站建設(shè)營(yíng)銷類網(wǎng)站織夢(mèng)...
-
LED顯示屏中英雙外貿(mào)類網(wǎng)...
-
環(huán)保電動(dòng)掃地車類網(wǎng)站織...
-
水性工業(yè)漆類企業(yè)網(wǎng)站織...
-
辦公學(xué)習(xí)教程資訊類網(wǎng)站...
-
灶具電器設(shè)備類網(wǎng)站織夢(mèng)...
-
企業(yè)公司行業(yè)通用類網(wǎng)站...
-
園林綠化景觀建設(shè)類網(wǎng)站...
-
農(nóng)業(yè)機(jī)械設(shè)備類網(wǎng)站織夢(mèng)...
-
道路護(hù)欄交通設(shè)施類網(wǎng)站...
-
攝影拍攝短視頻類網(wǎng)站織...
-
新媒體自媒體運(yùn)營(yíng)資訊類...
我們需要操作的就是修改織夢(mèng)內(nèi)核的文件
教程如下
打開include/arc.listview.class.php,找到:
//假如不消默認(rèn)的sortrank或id排序,利用連系查詢(數(shù)據(jù)量大時(shí)很是遲鈍)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";}//普通環(huán)境先從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'}




