summaryrefslogtreecommitdiff
path: root/includes/lib
diff options
context:
space:
mode:
Diffstat (limited to 'includes/lib')
-rw-r--r--includes/lib/account.php4
-rw-r--r--includes/lib/general.php2
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;