修改全部在/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') |
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 "; |
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 "; |
|
