Do not show users that took part in past TU votes but no longer have TU powers. Also, fix the sorting column while we're touching these lines. Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de> --- web/lib/acctfuncs.inc.php | 7 ++++--- 1 file changed, 4 insertions(+), 3 deletions(-) diff --git a/web/lib/acctfuncs.inc.php b/web/lib/acctfuncs.inc.php index d8a44f8..fe748a2 100644 --- a/web/lib/acctfuncs.inc.php +++ b/web/lib/acctfuncs.inc.php @@ -1004,9 +1004,10 @@ function last_votes_list() { $dbh = DB::connect(); $q = "SELECT UserID, MAX(VoteID) AS LastVote FROM TU_Votes, "; - $q .= "TU_VoteInfo WHERE TU_VoteInfo.ID = TU_Votes.VoteID AND "; - $q .= "TU_VoteInfo.End < UNIX_TIMESTAMP() GROUP BY UserID "; - $q .= "ORDER BY VoteID DESC"; + $q .= "TU_VoteInfo, Users WHERE TU_VoteInfo.ID = TU_Votes.VoteID AND "; + $q .= "TU_VoteInfo.End < UNIX_TIMESTAMP() AND "; + $q .= "Users.ID = TU_Votes.UserID AND Users.AccountTypeID = 2 "; + $q .= "GROUP BY UserID ORDER BY LastVote DESC"; $result = $dbh->query($q); $details = array(); -- 1.8.4.rc3.500.gc3113b0