Showing running votes potentially allows for tracking votes and associating yes/no/abstain votes with specific TUs. Signed-off-by: Lukas Fleischer --- 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