summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorLukas Fleischer <archlinux@cryptocrack.de>2014-10-17 09:53:02 +0200
committerLukas Fleischer <archlinux@cryptocrack.de>2014-10-17 09:53:02 +0200
commitc64b51f2eeedca319c5160777f74266bc3886b43 (patch)
tree18a2cfda88569ed27368d6d452bf4653ffbbb62e
parente9ebcc4479a09ebcf057664c55124caa00cf1946 (diff)
downloadaur-c64b51f2eeedca319c5160777f74266bc3886b43.tar.gz
aur-c64b51f2eeedca319c5160777f74266bc3886b43.tar.xz
voters.php: Show time stamps if available
Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>
-rw-r--r--web/html/voters.php7
-rw-r--r--web/lib/pkgbasefuncs.inc.php2
2 files changed, 7 insertions, 2 deletions
diff --git a/web/html/voters.php b/web/html/voters.php
index b0753b96..a40a9a13 100644
--- a/web/html/voters.php
+++ b/web/html/voters.php
@@ -17,7 +17,12 @@ if (has_credential(CRED_PKGBASE_LIST_VOTERS)):
<div class="boxbody">
<ul>
<?php while (list($indx, $row) = each($votes)): ?>
- <li><a href="<?= get_user_uri($row['Username']); ?>"><?= htmlspecialchars($row['Username']) ?></a></li>
+ <li>
+ <a href="<?= get_user_uri($row['Username']); ?>"><?= htmlspecialchars($row['Username']) ?></a>
+ <?php if ($row["VoteTS"] > 0): ?>
+ (<?= gmdate("Y-m-d H:i", intval($row["VoteTS"])) ?>)
+ <?php endif; ?>
+ </li>
<?php endwhile; ?>
</ul>
</div>
diff --git a/web/lib/pkgbasefuncs.inc.php b/web/lib/pkgbasefuncs.inc.php
index df59a80c..e1e4c1a6 100644
--- a/web/lib/pkgbasefuncs.inc.php
+++ b/web/lib/pkgbasefuncs.inc.php
@@ -712,7 +712,7 @@ function pkgbase_vote ($base_ids, $action=true) {
function pkgbase_votes_from_name($pkgbase_name) {
$dbh = DB::connect();
- $q = "SELECT UsersID, Username, Name FROM PackageVotes ";
+ $q = "SELECT UsersID, Username, Name, VoteTS FROM PackageVotes ";
$q.= "LEFT JOIN Users ON UsersID = Users.ID ";
$q.= "LEFT JOIN PackageBases ";
$q.= "ON PackageVotes.PackageBaseID = PackageBases.ID ";