summaryrefslogtreecommitdiff
path: root/pages/wot
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 /pages/wot
parent1d4a0decbddcb0a1c78203720e7a7dcfd702590b (diff)
downloadcacert-devel-b8b0d0044fcac7402bba19bfd601339bf61f1a69.tar.gz
cacert-devel-b8b0d0044fcac7402bba19bfd601339bf61f1a69.tar.xz
cacert-devel-b8b0d0044fcac7402bba19bfd601339bf61f1a69.zip
bug 1221: added `deleted` = 0
Diffstat (limited to 'pages/wot')
-rw-r--r--pages/wot/1.php2
-rw-r--r--pages/wot/9.php2
2 files changed, 2 insertions, 2 deletions
diff --git a/pages/wot/1.php b/pages/wot/1.php
index a45b5df..9e5d0f5 100644
--- a/pages/wot/1.php
+++ b/pages/wot/1.php
@@ -91,7 +91,7 @@
{
$query = "select *, `users`.`id` as `id` from `users`,`notary` where `listme`='1' and
`ccid`='".$ccid."' and `regid`='".$regid."' and
- `locid`='".$locid."' and `users`.`id`=`notary`.`to`
+ `locid`='".$locid."' and `users`.`id`=`notary`.`to` and `notary`.`deleted`=0
group by `notary`.`to` HAVING SUM(`points`) >= 100 order by `points` desc";
$list = mysql_query($query);
if(mysql_num_rows($list) > 0)
diff --git a/pages/wot/9.php b/pages/wot/9.php
index bfa7a98..0d9b22d 100644
--- a/pages/wot/9.php
+++ b/pages/wot/9.php
@@ -28,7 +28,7 @@
$user = mysql_fetch_array($res);
$userlang = $user['language'];
$points = mysql_num_rows(mysql_query("select sum(`points`) as `total` from `notary`
- where `to`='".$user['id']."' group by `to` HAVING SUM(`points`) > 0"));
+ where `to`='".$user['id']."' and `deleted`=0 group by `to` HAVING SUM(`points`) > 0"));
if($points <= 0)
{
echo _("Sorry, I was unable to locate that user.");