summaryrefslogtreecommitdiff
path: root/includes/lib/account.php
diff options
context:
space:
mode:
Diffstat (limited to 'includes/lib/account.php')
-rw-r--r--includes/lib/account.php6
1 files changed, 4 insertions, 2 deletions
diff --git a/includes/lib/account.php b/includes/lib/account.php
index dd8afd3..9e795c8 100644
--- a/includes/lib/account.php
+++ b/includes/lib/account.php
@@ -48,8 +48,9 @@ function fix_assurer_flag($userID = NULL)
AND `cp`.`user_id` = `u`.`id`
)
AND (
- SELECT SUM(`points`) FROM `notary` AS `n`
+ SELECT SUM(`awarded`) FROM `notary` AS `n`
WHERE `n`.`to` = `u`.`id`
+ AND `n`.`method` != 'Administrative Increase' AND `n`.`from` != `n`.`to`
AND (`n`.`expire` > now()
OR `n`.`expire` IS NULL)
AND `n`.`deleted` = 0
@@ -81,8 +82,9 @@ function fix_assurer_flag($userID = NULL)
AND `cp`.`user_id` = `u`.`id`
)
OR (
- SELECT SUM(`points`) FROM `notary` AS `n`
+ SELECT SUM(`awarded`) FROM `notary` AS `n`
WHERE `n`.`to` = `u`.`id`
+ AND `n`.`method` != 'Administrative Increase' AND `n`.`from` != `n`.`to`
AND (
`n`.`expire` > now()
OR `n`.`expire` IS NULL