summaryrefslogtreecommitdiff
path: root/web/lib/stats.inc.php
diff options
context:
space:
mode:
authorLukas Fleischer <archlinux@cryptocrack.de>2014-12-28 17:44:25 +0100
committerLukas Fleischer <archlinux@cryptocrack.de>2014-12-28 17:44:25 +0100
commitd1df490370f420bbf653cd1968d0178fa0a7b42c (patch)
tree3d8be33266b5a54d656cdb24093ee6b590c15b30 /web/lib/stats.inc.php
parent9bb93fad7506696a7bc089b4153784dec6214c73 (diff)
Hide fresh package bases from stats and results
Do not show package bases that have just been created in the package update statistics or in the search results. Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>
Diffstat (limited to 'web/lib/stats.inc.php')
-rw-r--r--web/lib/stats.inc.php1
1 files changed, 1 insertions, 0 deletions
diff --git a/web/lib/stats.inc.php b/web/lib/stats.inc.php
index d63767c..1dcb9b9 100644
--- a/web/lib/stats.inc.php
+++ b/web/lib/stats.inc.php
@@ -14,6 +14,7 @@ function updates_table() {
$q = 'SELECT Packages.Name, Version, ModifiedTS, SubmittedTS ';
$q.= 'FROM Packages INNER JOIN PackageBases ON ';
$q.= 'Packages.PackageBaseID = PackageBases.ID ';
+ $q.= 'WHERE PackageBases.PackagerUID IS NOT NULL ';
$q.= 'ORDER BY ModifiedTS DESC LIMIT 10';
$result = $dbh->query($q);