diff options
Diffstat (limited to 'includes/lib/account.php')
| -rw-r--r-- | includes/lib/account.php | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/includes/lib/account.php b/includes/lib/account.php index 6e17dda..f9c1399 100644 --- a/includes/lib/account.php +++ b/includes/lib/account.php @@ -49,7 +49,7 @@ function fix_assurer_flag($userID = NULL) ) AND ( SELECT SUM(`awarded`) FROM `notary` AS `n` - WHERE `n`.`to` = `u`.`id` AND `n`.`method` != 'Administrative Increase' AND `n`.`from` != `n`.`to` + 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 @@ -82,7 +82,7 @@ function fix_assurer_flag($userID = NULL) ) OR ( SELECT SUM(`awarded`) FROM `notary` AS `n` - WHERE `n`.`to` = `u`.`id` AND `n`.`method` != 'Administrative Increase' AND `n`.`from` != `n`.`to` + WHERE `n`.`to` = `u`.`id` AND `n`.`method` != \'Administrative Increase\' AND `n`.`from` != `n`.`to` AND ( `n`.`expire` > now() OR `n`.`expire` IS NULL |