diff options
| -rw-r--r-- | pages/wot/1.php | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/pages/wot/1.php b/pages/wot/1.php index 9047f27..df6b3c3 100644 --- a/pages/wot/1.php +++ b/pages/wot/1.php @@ -92,7 +92,8 @@ $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` and `notary`.`deleted`=0 - group by `notary`.`to` HAVING SUM(`points`) >= 100 order by `points` desc"; + AND `notary`.`method` != 'Administrative Increase' AND `notary`.`from` != `notary`.`to` + group by `notary`.`to` HAVING SUM(`awarded`) >= 100 order by `points` desc"; $list = mysql_query($query); if(mysql_num_rows($list) > 0) { |