summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorINOPIAE <inopiae@cacert.org>2015-01-13 23:01:54 +0100
committerINOPIAE <inopiae@cacert.org>2015-01-13 23:01:54 +0100
commit0ee9c78f30399241b18f7fa3db52ffa91e7a7c2b (patch)
treeae72d3ce2aa847e162aaf1504f3f6c67a4a3e064
parent9ac1acf3d085c4ac4ef0e3d40fad21565d678419 (diff)
downloadcacert-devel-0ee9c78f30399241b18f7fa3db52ffa91e7a7c2b.tar.gz
cacert-devel-0ee9c78f30399241b18f7fa3db52ffa91e7a7c2b.tar.xz
cacert-devel-0ee9c78f30399241b18f7fa3db52ffa91e7a7c2b.zip
bug 1357: fixed query as the calcualtion was inconsitent
-rwxr-xr-xscripts/cron/refresh_stats.php4
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`