From d4dfe2b9628e2591cc5534c5ac1bf866763228a2 Mon Sep 17 00:00:00 2001 From: =?UTF-8?q?Michael=20T=C3=A4nzer?= Date: Sat, 25 Aug 2012 01:19:30 +0200 Subject: bug 1004: Count awarded points, not only rounded down ones MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Signed-off-by: Michael Tänzer --- scripts/cron/refresh_stats.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/scripts/cron/refresh_stats.php b/scripts/cron/refresh_stats.php index 6ad5e64..5cfa720 100755 --- a/scripts/cron/refresh_stats.php +++ b/scripts/cron/refresh_stats.php @@ -149,7 +149,7 @@ function getDataFromLive() { )); $stats['points_issued'] = number_format(tc( - "select sum(`points`) as `count` from `notary`")); + "select sum(greatest(`points`, `awarded`)) as `count` from `notary`")); $totalusers=0; $totassurers=0; -- cgit v1.2.1