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> --- 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 0c7f2d9..c71358a 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 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); -- 2.2.1