diff options
Diffstat (limited to 'includes/lib')
| -rw-r--r-- | includes/lib/account.php | 4 | ||||
| -rw-r--r-- | includes/lib/general.php | 2 |
2 files changed, 3 insertions, 3 deletions
diff --git a/includes/lib/account.php b/includes/lib/account.php index e311668..46bbcee 100644 --- a/includes/lib/account.php +++ b/includes/lib/account.php @@ -51,7 +51,7 @@ function fix_assurer_flag($userID = NULL) SELECT SUM(`points`) FROM `notary` AS `n` WHERE `n`.`to` = `u`.`id` AND (`n`.`expire` > now() - OR `n`.`expire` IS NULL) + OR `n`.`expire` IS NULL) and `n`.`deleted` = 0 ) >= 100'; $query = mysql_query($sql); @@ -85,7 +85,7 @@ function fix_assurer_flag($userID = NULL) AND ( `n`.`expire` > now() OR `n`.`expire` IS NULL - ) + ) and `n`.`deleted` = 0 ) < 100 )'; diff --git a/includes/lib/general.php b/includes/lib/general.php index 85b132d..cb73c51 100644 --- a/includes/lib/general.php +++ b/includes/lib/general.php @@ -146,7 +146,7 @@ function runCommand($command, $input = "", &$output = null, &$errors = true) { $Result |= 5; } - $query = mysql_query('SELECT SUM(`points`) AS `points` FROM `notary` AS `n` WHERE `n`.`to` = \''.(int)intval($userID).'\' AND `n`.`expire` < now()'); + $query = mysql_query('SELECT SUM(`points`) AS `points` FROM `notary` AS `n` WHERE `n`.`to` = \''.(int)intval($userID).'\' AND `n`.`expire` < now() and `deleted` = 0'); $row = mysql_fetch_assoc($query); if ($row['points'] < 100) { $Result |= 3; |