diff options
| author | INOPIAE <inopiae@cacert.org> | 2015-01-13 23:01:54 +0100 |
|---|---|---|
| committer | INOPIAE <inopiae@cacert.org> | 2015-01-13 23:01:54 +0100 |
| commit | 0ee9c78f30399241b18f7fa3db52ffa91e7a7c2b (patch) | |
| tree | ae72d3ce2aa847e162aaf1504f3f6c67a4a3e064 /scripts/cron/refresh_stats.php | |
| parent | 9ac1acf3d085c4ac4ef0e3d40fad21565d678419 (diff) | |
| download | cacert-devel-0ee9c78f30399241b18f7fa3db52ffa91e7a7c2b.tar.gz cacert-devel-0ee9c78f30399241b18f7fa3db52ffa91e7a7c2b.tar.xz cacert-devel-0ee9c78f30399241b18f7fa3db52ffa91e7a7c2b.zip | |
bug 1357: fixed query as the calcualtion was inconsitent
Diffstat (limited to 'scripts/cron/refresh_stats.php')
| -rwxr-xr-x | scripts/cron/refresh_stats.php | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/scripts/cron/refresh_stats.php b/scripts/cron/refresh_stats.php index 44c5611..006ac6d 100755 --- a/scripts/cron/refresh_stats.php +++ b/scripts/cron/refresh_stats.php @@ -299,7 +299,7 @@ function assurer_count($from, $to, $type = 1){ FROM cacert.notary as n WHERE 1 AND n.`from` != n.`to` - AND (n.`deleted` = '0000-00-00 00:00:00' OR n.`deleted` >= @a) + AND (n.`deleted` = '0000-00-00 00:00:00') AND n.`when` < @a $atype GROUP by n.`to` @@ -312,7 +312,7 @@ function assurer_count($from, $to, $type = 1){ FROM cacert.notary as n WHERE 1 AND n.`from` != n.`to` - AND (n.`deleted` = '0000-00-00 00:00:00' OR n.`deleted` >= @b) + AND (n.`deleted` = '0000-00-00 00:00:00') AND n.`when` < @b $btype GROUP by n.`to` |