diff options
author | Michael Tänzer <neo@nhng.de> | 2012-08-25 01:53:43 +0200 |
---|---|---|
committer | Michael Tänzer <neo@nhng.de> | 2012-08-25 01:53:43 +0200 |
commit | bd96263d04fc0ea18fab51b149bbddae79244ae4 (patch) | |
tree | 10f947c5b7a0dad9b2884a366295431777cd0a1d | |
parent | d4dfe2b9628e2591cc5534c5ac1bf866763228a2 (diff) | |
download | cacert-devel-bd96263d04fc0ea18fab51b149bbddae79244ae4.tar.gz cacert-devel-bd96263d04fc0ea18fab51b149bbddae79244ae4.tar.xz cacert-devel-bd96263d04fc0ea18fab51b149bbddae79244ae4.zip |
bug 1004: Only count non-revoked and Face-to-Face points
Signed-off-by: Michael Tänzer <neo@nhng.de>
-rwxr-xr-x | scripts/cron/refresh_stats.php | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/scripts/cron/refresh_stats.php b/scripts/cron/refresh_stats.php index 5cfa720..ca02f6b 100755 --- a/scripts/cron/refresh_stats.php +++ b/scripts/cron/refresh_stats.php @@ -149,7 +149,9 @@ function getDataFromLive() { )); $stats['points_issued'] = number_format(tc( - "select sum(greatest(`points`, `awarded`)) as `count` from `notary`")); + "select sum(greatest(`points`, `awarded`)) as `count` from `notary` + where `deleted` = 0 + and `method` = 'Face to Face Meeting'")); $totalusers=0; $totassurers=0; |