From 2276171b2987c42ce9658e9cac469f2714939a33 Mon Sep 17 00:00:00 2001 From: Lukas Fleischer Date: Wed, 28 Aug 2013 01:52:40 +0200 Subject: Only include current TUs in the last votes list 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 --- web/lib/acctfuncs.inc.php | 7 ++++--- 1 file changed, 4 insertions(+), 3 deletions(-) (limited to 'web/lib/acctfuncs.inc.php') 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(); -- cgit v1.2.3-54-g00ecf