From d1df490370f420bbf653cd1968d0178fa0a7b42c Mon Sep 17 00:00:00 2001 From: Lukas Fleischer Date: Sun, 28 Dec 2014 17:44:25 +0100 Subject: 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 --- web/lib/pkgfuncs.inc.php | 2 +- web/lib/stats.inc.php | 1 + 2 files changed, 2 insertions(+), 1 deletion(-) diff --git a/web/lib/pkgfuncs.inc.php b/web/lib/pkgfuncs.inc.php index 0c7f2d9e..c71358a7 100644 --- a/web/lib/pkgfuncs.inc.php +++ b/web/lib/pkgfuncs.inc.php @@ -563,7 +563,7 @@ function pkg_search_page($SID="") { $q_from_extra = ""; } - $q_where = "WHERE 1 = 1 "; + $q_where = 'WHERE PackageBases.PackagerUID IS NOT NULL '; /* * TODO: Possibly do string matching on category to make request * variable values more sensible. diff --git a/web/lib/stats.inc.php b/web/lib/stats.inc.php index d63767c9..1dcb9b96 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); -- cgit v1.2.3-24-g4f1b