dede:memberlist按照空间点击数homecount排序并加上序号的办法

2024-07-12 08:29:39

字体：大中小

来源：转载

供稿：网友

修改全部在/include/taglib/memberlist.lib.php 这个文件中：

找到：

1 $sql = "SELECT mb.*,ms.spacename,ms.sign FROM `dede_member` mb 2 LEFT JOIN `dede_member_space` ms ON ms.mid = mb.mid 3 $wheresql order by mb.{$orderby} DESC LIMIT 0,$row ";
修改为：

01 if($orderby=='homecount') 02 { 03 $sql = "SELECT mb.*,ms.spacename,ms.sign,ht.homecount FROM `dede_member` mb 04 LEFT JOIN `dede_member_space` ms ON ms.mid = mb.mid left join `dede_member_tj` ht ON ht.mid = mb.mid 05 $wheresql order by ht.homecount DESC LIMIT 0,$row "; 06 } 07 else 08 { 09 $sql = "SELECT mb.*,ms.spacename,ms.sign,ht.homecount FROM `dede_member` mb 10 LEFT JOIN `dede_member_space` ms ON ms.mid = mb.mid left join `dede_member_tj` ht ON ht.mid = mb.mid 11 $wheresql order by mb.{$orderby} DESC LIMIT 0,$row "; 12 }

上一篇：织梦dedecms评论添加字段方法，如何添加评论字段？

下一篇：DEDE织梦CMS模板在runphp=yes的标签中调用其他field值的方法