summaryrefslogtreecommitdiff
path: root/scripts
diff options
context:
space:
mode:
authorMichael Tänzer <neo@nhng.de>2012-08-25 01:53:43 +0200
committerMichael Tänzer <neo@nhng.de>2012-08-25 01:53:43 +0200
commitbd96263d04fc0ea18fab51b149bbddae79244ae4 (patch)
tree10f947c5b7a0dad9b2884a366295431777cd0a1d /scripts
parentd4dfe2b9628e2591cc5534c5ac1bf866763228a2 (diff)
downloadcacert-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>
Diffstat (limited to 'scripts')
-rwxr-xr-xscripts/cron/refresh_stats.php4
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;