[aur-dev] [PATCH] Exclude running votes from "Last Votes by TU"

[Lukas Fleischer]

Showing running votes potentially allows for tracking votes and
associating yes/no/abstain votes with specific TUs.

Signed-off-by: Lukas Fleischer <archlinux at cryptocrack.de>
---
 web/lib/acctfuncs.inc.php | 5 ++++-
 1 file changed, 4 insertions(+), 1 deletion(-)

diff --git a/web/lib/acctfuncs.inc.php b/web/lib/acctfuncs.inc.php
index f52dfc3..d8a44f8 100644
--- a/web/lib/acctfuncs.inc.php
+++ b/web/lib/acctfuncs.inc.php
@@ -1003,7 +1003,10 @@ function past_proposal_list($order, $lim) {
 function last_votes_list() {
 	$dbh = DB::connect();
 
-	$q = "SELECT UserID, MAX(VoteID) AS LastVote FROM TU_Votes GROUP BY UserID ORDER BY VoteID DESC";
+	$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";
 	$result = $dbh->query($q);
 
 	$details = array();
-- 
1.8.4.rc3.500.gc3113b0