[aur-dev] [PATCH 2/2] Hide fresh package bases from stats and results

[Lukas Fleischer]

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 at 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