summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--web/lib/acctfuncs.inc.php5
1 files changed, 4 insertions, 1 deletions
diff --git a/web/lib/acctfuncs.inc.php b/web/lib/acctfuncs.inc.php
index f52dfc32..d8a44f8c 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();