[aur-dev] [PATCH] Only include current TUs in the last votes list

[Lukas Fleischer]

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 at 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