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