summaryrefslogtreecommitdiff
path: root/stamp/common.php
diff options
context:
space:
mode:
authorBenny Baumann <BenBE@geshi.org>2013-11-19 23:02:00 +0100
committerBenny Baumann <BenBE@geshi.org>2013-11-19 23:24:09 +0100
commitb8b0d0044fcac7402bba19bfd601339bf61f1a69 (patch)
tree3f3a822ec0d60e2ed3119fa65244aee19528e6f1 /stamp/common.php
parent1d4a0decbddcb0a1c78203720e7a7dcfd702590b (diff)
downloadcacert-devel-b8b0d0044fcac7402bba19bfd601339bf61f1a69.tar.gz
cacert-devel-b8b0d0044fcac7402bba19bfd601339bf61f1a69.tar.xz
cacert-devel-b8b0d0044fcac7402bba19bfd601339bf61f1a69.zip
bug 1221: added `deleted` = 0
Diffstat (limited to 'stamp/common.php')
-rw-r--r--stamp/common.php2
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]'";