修改全部在/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 LIM
找到：
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
}