summaryrefslogtreecommitdiff
path: root/includes/general.php
diff options
context:
space:
mode:
authorBenny Baumann <BenBE@geshi.org>2013-11-19 22:56:04 +0100
committerBenny Baumann <BenBE@geshi.org>2013-11-19 23:24:09 +0100
commit1d4a0decbddcb0a1c78203720e7a7dcfd702590b (patch)
tree6c495f5f64783b49d0a5cfc535446966824ab512 /includes/general.php
parent8f72f0692164e88165741ba79fbea77df039e949 (diff)
downloadcacert-devel-1d4a0decbddcb0a1c78203720e7a7dcfd702590b.tar.gz
cacert-devel-1d4a0decbddcb0a1c78203720e7a7dcfd702590b.tar.xz
cacert-devel-1d4a0decbddcb0a1c78203720e7a7dcfd702590b.zip
bug 1221: added `deleted` = 0 to general.php
Diffstat (limited to 'includes/general.php')
-rw-r--r--includes/general.php4
1 files changed, 2 insertions, 2 deletions
diff --git a/includes/general.php b/includes/general.php
index d89c0e6..af5b63e 100644
--- a/includes/general.php
+++ b/includes/general.php
@@ -82,7 +82,7 @@
$locked = mysql_fetch_assoc(mysql_query("select `locked` from `users` where `id`='".$_SESSION['profile']['id']."'"));
if($locked['locked'] == 0)
{
- $query = "select sum(`points`) as `total` from `notary` where `to`='".$_SESSION['profile']['id']."' group by `to`";
+ $query = "select sum(`points`) as `total` from `notary` where `to`='".$_SESSION['profile']['id']."' and `deleted` = 0 group by `to`";
$res = mysql_query($query);
$row = mysql_fetch_assoc($res);
$_SESSION['profile']['points'] = $row['total'];
@@ -477,7 +477,7 @@
if($id <= 0)
$id = $_SESSION['profile']['id'];
- $query = "select sum(`points`) as `points` from `notary` where `to`='$id' group by `to`";
+ $query = "select sum(`points`) as `points` from `notary` where `to`='$id' and `deleted` = 0 group by `to`";
$row = mysql_fetch_assoc(mysql_query($query));
$points = $row['points'];