From eda713032ce9bed773b6c927b2f6ac4b445fe577 Mon Sep 17 00:00:00 2001 From: Lukas Fleischer Date: Wed, 6 Oct 2010 04:25:53 +0200 Subject: Add timestamp when a package is flagged out-of-date (FS#20848). Signed-off-by: Loui Chang - resolve conflict and omit i18n changes. --- web/lib/stats.inc | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'web/lib/stats.inc') diff --git a/web/lib/stats.inc b/web/lib/stats.inc index 85c7e28e..6a765581 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,Users WHERE Packages.OutOfDateTS IS NOT NULL AND Packages.MaintainerUID = Users.ID AND Users.Username='" . $escuser . "'"; $flagged_outdated = db_cache_value($q, $dbh, $apc_prefix . 'user_flagged_outdated:' . $escuser); -- cgit v1.2.3-24-g4f1b