summaryrefslogtreecommitdiff
path: root/scripts
diff options
context:
space:
mode:
authorINOPIAE <inopiae@cacert.org>2015-01-13 07:24:10 +0100
committerINOPIAE <inopiae@cacert.org>2015-01-13 07:24:10 +0100
commit7033e0d203d85e5a284654b9324985a8b3a989f1 (patch)
treea46b85b264cea59e3a77b0ad713fba7fe2c19a31 /scripts
parenta72c7896a6e887efbd9fd91873301e8856d2a36b (diff)
downloadcacert-devel-7033e0d203d85e5a284654b9324985a8b3a989f1.tar.gz
cacert-devel-7033e0d203d85e5a284654b9324985a8b3a989f1.tar.xz
cacert-devel-7033e0d203d85e5a284654b9324985a8b3a989f1.zip
bug 1357: replaced calculation assurer count with new function
Diffstat (limited to 'scripts')
-rwxr-xr-xscripts/cron/refresh_stats.php10
1 files changed, 2 insertions, 8 deletions
diff --git a/scripts/cron/refresh_stats.php b/scripts/cron/refresh_stats.php
index ae25182..6890024 100755
--- a/scripts/cron/refresh_stats.php
+++ b/scripts/cron/refresh_stats.php
@@ -168,14 +168,8 @@ function getDataFromLive() {
and `deleted` = 0
and `locked` = 0");
- $totassurers += $assurers = tc(
- "select count(*) as `count` from (
- select 1 from `notary`
- where `when` >= '$first' and `when` < '$next_month'
- and `method`!='Administrative Increase'
- and `deleted` = 0
- group by `to` having sum(`points`) >= 100
- ) as `assurer_candidates`");
+ $totalcandidates += $candidates = assurer_count($first, $next_month, 0);
+ $totalassurers += $assurers = assurer_count($first, $next_month, 1);
$certs = tc(
"select count(*) as `count` from `domaincerts`