diff options
Diffstat (limited to 'pages')
| -rw-r--r-- | pages/account/55.php | 3 | ||||
| -rw-r--r-- | pages/wot/9.php | 3 |
2 files changed, 3 insertions, 3 deletions
diff --git a/pages/account/55.php b/pages/account/55.php index 24cc86d..1f01771 100644 --- a/pages/account/55.php +++ b/pages/account/55.php @@ -90,10 +90,11 @@ $query = ' SELECT `u`.`id`, `u`.`assurer`, - SUM(`points`) + SUM(`awarded`) FROM `users` AS `u`, `notary` AS `n` WHERE `u`.`id` = \''.intval($_SESSION['profile']['id']).'\' + AND `n`.`method` != 'Administrative Increase' AND `n`.`from` != `n`.`to` AND `n`.`to` = `u`.`id` AND `expire` < NOW() AND `n`.`deleted` = 0 diff --git a/pages/wot/9.php b/pages/wot/9.php index 20f2c6d..f68cc16 100644 --- a/pages/wot/9.php +++ b/pages/wot/9.php @@ -27,8 +27,7 @@ $user = mysql_fetch_array($res); $userlang = L10n::normalise_translation($user['language']); - $points = mysql_num_rows(mysql_query("select sum(`points`) as `total` from `notary` - where `to`='".intval($user['id'])."' and `deleted`=0 group by `to` HAVING SUM(`points`) > 0")); + $points = get_received_total_points(intval($user['id'])); if($points <= 0) { echo _("Sorry, I was unable to locate that user."); } else { |