summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorFelix Dörre <felix@dogcraft.de>2015-04-14 22:28:02 +0200
committerFelix Dörre <felix@dogcraft.de>2015-04-14 22:28:02 +0200
commit305c23ce3d42f1302f9d12f4b97758871f351539 (patch)
tree083db081b65d9dae777c478ac5448389510d041c
parent345eb2e771f6475e243f406fe37c41933a520c11 (diff)
downloadcacert-devel-305c23ce3d42f1302f9d12f4b97758871f351539.tar.gz
cacert-devel-305c23ce3d42f1302f9d12f4b97758871f351539.tar.xz
cacert-devel-305c23ce3d42f1302f9d12f4b97758871f351539.zip
bug-1046: new points calculation in updatesort.php (code moved to includes/lib/account.php)
-rw-r--r--includes/lib/account.php4
1 files changed, 2 insertions, 2 deletions
diff --git a/includes/lib/account.php b/includes/lib/account.php
index dd8afd3..aab98a4 100644
--- a/includes/lib/account.php
+++ b/includes/lib/account.php
@@ -48,7 +48,7 @@ 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`.`expire` > now()
OR `n`.`expire` IS NULL)
@@ -81,7 +81,7 @@ 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`.`expire` > now()