summaryrefslogtreecommitdiff
path: root/www/api/cemails.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/cemails.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/cemails.php')
-rw-r--r--www/api/cemails.php2
1 files changed, 1 insertions, 1 deletions
diff --git a/www/api/cemails.php b/www/api/cemails.php
index 0d067ea..260ca4f 100644
--- a/www/api/cemails.php
+++ b/www/api/cemails.php
@@ -25,7 +25,7 @@
echo "200,Authentication Ok\n";
$user = mysql_fetch_assoc($res);
$memid = $user['id'];
- $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'];
echo "CS=".intval($user['codesign'])."\n";