注册 | 登录 |
地方论坛门户及新闻和人才网址大全

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

时间:2021-07-21人气:-


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

找到:

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

01if($orderby=='homecount')02{03$sql = "SELECT mb.*,ms.spacename,ms.sign,ht.homecount FROM `dede_member` mb04LEFT JOIN `dede_member_space` ms ON ms.mid = mb.mid leftjoin`dede_member_tj` ht ON ht.mid = mb.mid05$wheresql order by ht.homecount DESC LIMIT 0,$row ";06}07else08{09$sql = "SELECT mb.*,ms.spacename,ms.sign,ht.homecount FROM `dede_member` mb10LEFT JOIN `dede_member_space` ms ON ms.mid = mb.mid leftjoin`dede_member_tj` ht ON ht.mid = mb.mid11$wheresql order by mb.{$orderby} DESC LIMIT 0,$row ";12}

上篇:dede删除自定义字段变量的方法

下篇:织梦DEDECMS 首页列表页内容也时间日期调用标签