diff options
| author | Lukas Fleischer <archlinux@cryptocrack.de> | 2014-12-28 17:44:25 +0100 |
|---|---|---|
| committer | Lukas Fleischer <archlinux@cryptocrack.de> | 2014-12-28 17:44:25 +0100 |
| commit | d1df490370f420bbf653cd1968d0178fa0a7b42c (patch) | |
| tree | 3d8be33266b5a54d656cdb24093ee6b590c15b30 /web | |
| parent | 9bb93fad7506696a7bc089b4153784dec6214c73 (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')
| -rw-r--r-- | web/lib/pkgfuncs.inc.php | 2 | ||||
| -rw-r--r-- | web/lib/stats.inc.php | 1 |
2 files changed, 2 insertions, 1 deletions
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); |