diff options
| author | Benny Baumann <BenBE@geshi.org> | 2013-11-19 23:02:00 +0100 |
|---|---|---|
| committer | Benny Baumann <BenBE@geshi.org> | 2013-11-19 23:24:09 +0100 |
| commit | b8b0d0044fcac7402bba19bfd601339bf61f1a69 (patch) | |
| tree | 3f3a822ec0d60e2ed3119fa65244aee19528e6f1 /pages/wot | |
| parent | 1d4a0decbddcb0a1c78203720e7a7dcfd702590b (diff) | |
| download | cacert-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.php | 2 | ||||
| -rw-r--r-- | pages/wot/9.php | 2 |
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."); |