diff options
-rw-r--r-- | includes/lib/account.php | 6 |
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 |