summaryrefslogtreecommitdiff
path: root/scripts/assurer.php
diff options
context:
space:
mode:
authorBernhard Fröhlich <bernhard@cacert.org>2011-09-14 16:05:15 +0200
committerBernhard Fröhlich <bernhard@cacert.org>2011-09-14 16:05:15 +0200
commitb14806a5215a9fc1e95383c7f543d7e17f24a1f5 (patch)
treef84885788fdc62cb8dcd9d50d2be21d854c03ed9 /scripts/assurer.php
parenta2c2ddd7b5ef0c04d52fe9f22439e30a6de27a87 (diff)
parenteb4d4d1ca50d08211ec230a60cee11f65b74c2bd (diff)
downloadcacert-devel-b14806a5215a9fc1e95383c7f543d7e17f24a1f5.tar.gz
cacert-devel-b14806a5215a9fc1e95383c7f543d7e17f24a1f5.tar.xz
cacert-devel-b14806a5215a9fc1e95383c7f543d7e17f24a1f5.zip
Merge branch 'release' of ssh://git-dev.cacert/var/cache/git/cacert-devel into bug-975
Diffstat (limited to 'scripts/assurer.php')
-rw-r--r--scripts/assurer.php2
1 files changed, 1 insertions, 1 deletions
diff --git a/scripts/assurer.php b/scripts/assurer.php
index c649fbf..d85a2a6 100644
--- a/scripts/assurer.php
+++ b/scripts/assurer.php
@@ -30,7 +30,7 @@
$query = "
select u.email, fname, lname, sum(n.points) from users u, notary n
where n.to=u.id
- and not exists(select 1 from cats_passed cp where cp.user_id=u.id)
+ and not EXISTS(SELECT 1 FROM `cats_passed` AS `tp`, `cats_variant` AS `cv` WHERE `tp`.`variant_id` = `cv`.`id` AND `cv`.`type_id` = 1 AND `tp`.`user_id` = `u`.`id`)
and exists(select 1 from notary n2 where n2.from=u.id and year(n2.`when`)>2007)
and (select count(*) from notary n3 where n3.from=u.id) > 1
group by email, fname, lname