summaryrefslogtreecommitdiff
path: root/includes/lib/account.php
diff options
context:
space:
mode:
authorBenny Baumann <BenBE@geshi.org>2013-11-19 22:56:28 +0100
committerBenny Baumann <BenBE@geshi.org>2013-11-19 23:24:09 +0100
commit323e617e2ca22b3ca985844d81f088f52d9824e6 (patch)
treec8180ef0b7b45ecfa72f67da5bf577d0470e41fb /includes/lib/account.php
parentb8b0d0044fcac7402bba19bfd601339bf61f1a69 (diff)
downloadcacert-devel-323e617e2ca22b3ca985844d81f088f52d9824e6.tar.gz
cacert-devel-323e617e2ca22b3ca985844d81f088f52d9824e6.tar.xz
cacert-devel-323e617e2ca22b3ca985844d81f088f52d9824e6.zip
bug 1221: Whitespace
Diffstat (limited to 'includes/lib/account.php')
-rw-r--r--includes/lib/account.php16
1 files changed, 8 insertions, 8 deletions
diff --git a/includes/lib/account.php b/includes/lib/account.php
index 46bbcee..de25b62 100644
--- a/includes/lib/account.php
+++ b/includes/lib/account.php
@@ -19,10 +19,10 @@
/**
* Function to recalculate the cached Assurer status
- *
+ *
* @param int $userID
* if the user ID is not given the flag will be recalculated for all users
- *
+ *
* @return bool
* false if there was an error on fixing the flag. This does NOT return the
* new value of the flag
@@ -30,7 +30,7 @@
function fix_assurer_flag($userID = NULL)
{
// Update Assurer-Flag on users table if 100 points and CATS passed.
- //
+ //
// We may have some performance issues here if no userID is given
// there are ~150k assurances and ~220k users currently
// but the exists-clause on cats_passed should be a good filter
@@ -46,20 +46,20 @@ function fix_assurer_flag($userID = NULL)
WHERE `cp`.`variant_id` = `cv`.`id`
AND `cv`.`type_id` = 1
AND `cp`.`user_id` = `u`.`id`
- )
+ )
AND (
SELECT SUM(`points`) FROM `notary` AS `n`
WHERE `n`.`to` = `u`.`id`
AND (`n`.`expire` > now()
OR `n`.`expire` IS NULL) and `n`.`deleted` = 0
) >= 100';
-
+
$query = mysql_query($sql);
if (!$query) {
return false;
}
// Challenge has been passed and non-expired points >= 100
-
+
// Reset flag if requirements are not met
//
// Also a bit performance critical but assurer flag is only set on
@@ -88,11 +88,11 @@ function fix_assurer_flag($userID = NULL)
) and `n`.`deleted` = 0
) < 100
)';
-
+
$query = mysql_query($sql);
if (!$query) {
return false;
}
-
+
return true;
} \ No newline at end of file