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