summaryrefslogtreecommitdiff
path: root/pages/wot
diff options
context:
space:
mode:
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.");