diff options
| author | Michael Tänzer <neo@nhng.de> | 2011-08-21 02:07:40 +0200 |
|---|---|---|
| committer | Michael Tänzer <neo@nhng.de> | 2011-08-21 02:07:40 +0200 |
| commit | ce4bfbaf0c2babb5bba2568d3b8712e1615aa651 (patch) | |
| tree | bcdd82ada2066eff6fc21f6dfc2fe01844f1550f /scripts | |
| parent | 983a7dced2bc15cfb5760b81659bc72fb39b2567 (diff) | |
| download | cacert-devel-ce4bfbaf0c2babb5bba2568d3b8712e1615aa651.tar.gz cacert-devel-ce4bfbaf0c2babb5bba2568d3b8712e1615aa651.tar.xz cacert-devel-ce4bfbaf0c2babb5bba2568d3b8712e1615aa651.zip | |
Source code taken from cacert-20110820.tar.bz2
Diffstat (limited to 'scripts')
| -rw-r--r-- | scripts/assurer.php | 2 |
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 |