diff options
| author | Lukas Fleischer <archlinux@cryptocrack.de> | 2014-10-15 16:59:15 +0200 |
|---|---|---|
| committer | Lukas Fleischer <archlinux@cryptocrack.de> | 2014-10-16 18:15:45 +0200 |
| commit | e9ebcc4479a09ebcf057664c55124caa00cf1946 (patch) | |
| tree | d7a1218758fd99f2e3eb4a8c00bec28a2e622639 /web/lib/pkgbasefuncs.inc.php | |
| parent | c986ba0c52a771daf3593e3e262d3345997311ad (diff) | |
| download | aurweb-e9ebcc4479a09ebcf057664c55124caa00cf1946.tar.xz | |
Add a time stamp to package base votes
This can potentially be used to identify trending packages.
Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>
Diffstat (limited to 'web/lib/pkgbasefuncs.inc.php')
| -rw-r--r-- | web/lib/pkgbasefuncs.inc.php | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/web/lib/pkgbasefuncs.inc.php b/web/lib/pkgbasefuncs.inc.php index 1ac0b47..df59a80 100644 --- a/web/lib/pkgbasefuncs.inc.php +++ b/web/lib/pkgbasefuncs.inc.php @@ -667,12 +667,12 @@ function pkgbase_vote ($base_ids, $action=true) { $first = 0; $vote_ids = $pid; if ($action) { - $vote_clauses = "($uid, $pid)"; + $vote_clauses = "($uid, $pid, UNIX_TIMESTAMP())"; } } else { $vote_ids .= ", $pid"; if ($action) { - $vote_clauses .= ", ($uid, $pid)"; + $vote_clauses .= ", ($uid, $pid, UNIX_TIMESTAMP())"; } } } @@ -686,7 +686,7 @@ function pkgbase_vote ($base_ids, $action=true) { $dbh->exec($q); if ($action) { - $q = "INSERT INTO PackageVotes (UsersID, PackageBaseID) VALUES "; + $q = "INSERT INTO PackageVotes (UsersID, PackageBaseID, VoteTS) VALUES "; $q.= $vote_clauses; } else { $q = "DELETE FROM PackageVotes WHERE UsersID = $uid "; |