diff options
author | Lukas Fleischer <archlinux@cryptocrack.de> | 2013-08-26 17:29:24 +0200 |
---|---|---|
committer | Lukas Fleischer <archlinux@cryptocrack.de> | 2013-08-26 17:34:31 +0200 |
commit | 2dd3d04f45f8a0e57f0c8686a12d7b95fe5bdb59 (patch) | |
tree | c2899efec29286a45b09942e03dd02bdadae1c4e /web/lib/acctfuncs.inc.php | |
parent | fb76aab8cffbc3d251fb635ae8e986c7138d8d68 (diff) |
Add "Last Votes by TU" list
This shows a list of all Trusted Users and the vote ID of the last
proposal each of the TUs voted on. This list is sorted by vote ID.
Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>
Diffstat (limited to 'web/lib/acctfuncs.inc.php')
-rw-r--r-- | web/lib/acctfuncs.inc.php | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/web/lib/acctfuncs.inc.php b/web/lib/acctfuncs.inc.php index 31cdd79..f52dfc3 100644 --- a/web/lib/acctfuncs.inc.php +++ b/web/lib/acctfuncs.inc.php @@ -996,6 +996,25 @@ function past_proposal_list($order, $lim) { } /** + * Get the vote ID of the last vote of all Trusted Users + * + * @return array The vote ID of the last vote of each Trusted User + */ +function last_votes_list() { + $dbh = DB::connect(); + + $q = "SELECT UserID, MAX(VoteID) AS LastVote FROM TU_Votes GROUP BY UserID ORDER BY VoteID DESC"; + $result = $dbh->query($q); + + $details = array(); + while ($row = $result->fetch(PDO::FETCH_ASSOC)) { + $details[] = $row; + } + + return $details; +} + +/** * Determine the total number of Trusted User proposals * * @return string The total number of Trusted User proposals |