[aur-dev] [PATCH 2/2] voters.php: Show time stamps if available

[archlinux at cryptocrack.de]

From: Lukas Fleischer <archlinux at cryptocrack.de>

Signed-off-by: Lukas Fleischer <archlinux at cryptocrack.de>
---
 web/html/voters.php          | 7 ++++++-
 web/lib/pkgbasefuncs.inc.php | 2 +-
 2 files changed, 7 insertions(+), 2 deletions(-)

diff --git a/web/html/voters.php b/web/html/voters.php
index b0753b9..a40a9a1 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 df59a80..e1e4c1a 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 ";
-- 
2.1.2