summaryrefslogtreecommitdiff
path: root/www/api/ccsr.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 /www/api/ccsr.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 'www/api/ccsr.php')
-rw-r--r--www/api/ccsr.php2
1 files changed, 1 insertions, 1 deletions
diff --git a/www/api/ccsr.php b/www/api/ccsr.php
index 7efdf8d..a0f36e2 100644
--- a/www/api/ccsr.php
+++ b/www/api/ccsr.php
@@ -42,7 +42,7 @@ require_once '../../includes/lib/check_weak_key.php';
}
if(count($emails) <= 0)
die("404,Wasn't able to match any emails sent against your account");
- $query = "select sum(`points`) as `points` from `notary` where `to`='$memid' group by `to`";
+ $query = "select sum(`points`) as `points` from `notary` where `to`='$memid' and `notary`.`deleted`=0 group by `to`";
$row = mysql_fetch_assoc(mysql_query($query));
$points = $row['points'];