diff options
| author | INOPIAE <inopiae@cacert.org> | 2015-01-13 07:24:10 +0100 |
|---|---|---|
| committer | INOPIAE <inopiae@cacert.org> | 2015-01-13 07:24:10 +0100 |
| commit | 7033e0d203d85e5a284654b9324985a8b3a989f1 (patch) | |
| tree | a46b85b264cea59e3a77b0ad713fba7fe2c19a31 | |
| parent | a72c7896a6e887efbd9fd91873301e8856d2a36b (diff) | |
| download | cacert-devel-7033e0d203d85e5a284654b9324985a8b3a989f1.tar.gz cacert-devel-7033e0d203d85e5a284654b9324985a8b3a989f1.tar.xz cacert-devel-7033e0d203d85e5a284654b9324985a8b3a989f1.zip | |
bug 1357: replaced calculation assurer count with new function
| -rwxr-xr-x | scripts/cron/refresh_stats.php | 10 |
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` |