diff options
author | Benny Baumann <BenBE@geshi.org> | 2013-11-19 22:56:04 +0100 |
---|---|---|
committer | Benny Baumann <BenBE@geshi.org> | 2013-11-19 23:24:09 +0100 |
commit | 1d4a0decbddcb0a1c78203720e7a7dcfd702590b (patch) | |
tree | 6c495f5f64783b49d0a5cfc535446966824ab512 | |
parent | 8f72f0692164e88165741ba79fbea77df039e949 (diff) | |
download | cacert-devel-1d4a0decbddcb0a1c78203720e7a7dcfd702590b.tar.gz cacert-devel-1d4a0decbddcb0a1c78203720e7a7dcfd702590b.tar.xz cacert-devel-1d4a0decbddcb0a1c78203720e7a7dcfd702590b.zip |
bug 1221: added `deleted` = 0 to general.php
-rw-r--r-- | includes/general.php | 4 |
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']; |