diff options
author | Benny Baumann <BenBE@geshi.org> | 2013-11-19 23:02:00 +0100 |
---|---|---|
committer | Benny Baumann <BenBE@geshi.org> | 2013-11-19 23:24:09 +0100 |
commit | b8b0d0044fcac7402bba19bfd601339bf61f1a69 (patch) | |
tree | 3f3a822ec0d60e2ed3119fa65244aee19528e6f1 /stamp | |
parent | 1d4a0decbddcb0a1c78203720e7a7dcfd702590b (diff) | |
download | cacert-devel-b8b0d0044fcac7402bba19bfd601339bf61f1a69.tar.gz cacert-devel-b8b0d0044fcac7402bba19bfd601339bf61f1a69.tar.xz cacert-devel-b8b0d0044fcac7402bba19bfd601339bf61f1a69.zip |
bug 1221: added `deleted` = 0
Diffstat (limited to 'stamp')
-rw-r--r-- | stamp/common.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/stamp/common.php b/stamp/common.php index ff814dd..d0a71f4 100644 --- a/stamp/common.php +++ b/stamp/common.php @@ -117,7 +117,7 @@ if($org == 0) { $query = "SELECT *, sum(`points`) AS `total` FROM `users`, `notary` WHERE `users`.`id` = '$cert[memid]' AND - `notary`.`to` = `users`.`id` and `notary`.`when` <= '$cert[issued]' GROUP BY `notary`.`to`"; + `notary`.`to` = `users`.`id` and `notary`.`when` <= '$cert[issued]' and `notary`.`deleted`=0 GROUP BY `notary`.`to`"; $user = mysql_fetch_assoc(mysql_query($query)); } else { $query = "select * from `orginfo` where `id`='$cert[orgid]'"; |