patch attached -- Andrea `bash` Scarpino Arch Linux Developer
From 1f02036934257f8f0cb25839ba8687a1e63b318d Mon Sep 17 00:00:00 2001 From: Andrea Scarpino <[email protected]> Date: Mon, 26 Oct 2009 21:13:45 +0100 Subject: [PATCH] out-of-date counts only packages in unsupported
--- web/lib/stats.inc | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/web/lib/stats.inc b/web/lib/stats.inc index 85c7e28..f01c3fc 100644 --- a/web/lib/stats.inc +++ b/web/lib/stats.inc @@ -59,7 +59,7 @@ function user_table($user, $dbh) $maintainer_unsupported_count = db_cache_value(sprintf($base_q, 'unsupported'), $dbh, $apc_prefix . 'user_unsupported_count:' . $escuser); - $q = "SELECT count(*) FROM Packages,Users WHERE Packages.OutOfDate = 1 AND Packages.MaintainerUID = Users.ID AND Users.Username='" . $escuser . "'"; + $q = "SELECT count(*) FROM Packages,PackageLocations,Users WHERE Packages.OutOfDate = 1 AND Packages.MaintainerUID = Users.ID AND Packages.LocationID = PackageLocations.ID AND PackageLocations.Location = 'unsupported' AND Users.Username='" . $escuser . "'"; $flagged_outdated = db_cache_value($q, $dbh, $apc_prefix . 'user_flagged_outdated:' . $escuser); -- 1.6.5.1
