summaryrefslogtreecommitdiff
path: root/pages/account
diff options
context:
space:
mode:
authorFelix Dörre <felix@dogcraft.de>2015-04-07 22:32:43 +0200
committerBenny Baumann <BenBE@geshi.org>2015-04-30 00:24:53 +0200
commitf2a909d694c7039d6a405e71674f325e2ddffc3e (patch)
tree3fcccc40fa24635bf611d9202448e310739c9161 /pages/account
parent16cb7044fa31e618f969d6104d976a7bc087e1be (diff)
downloadcacert-devel-f2a909d694c7039d6a405e71674f325e2ddffc3e.tar.gz
cacert-devel-f2a909d694c7039d6a405e71674f325e2ddffc3e.tar.xz
cacert-devel-f2a909d694c7039d6a405e71674f325e2ddffc3e.zip
bug-1058: fix points calculation in pages/account/55.php
Diffstat (limited to 'pages/account')
-rw-r--r--pages/account/55.php3
1 files changed, 2 insertions, 1 deletions
diff --git a/pages/account/55.php b/pages/account/55.php
index 24cc86d..1f01771 100644
--- a/pages/account/55.php
+++ b/pages/account/55.php
@@ -90,10 +90,11 @@
$query = '
SELECT `u`.`id`,
`u`.`assurer`,
- SUM(`points`)
+ SUM(`awarded`)
FROM `users` AS `u`,
`notary` AS `n`
WHERE `u`.`id` = \''.intval($_SESSION['profile']['id']).'\'
+ AND `n`.`method` != 'Administrative Increase' AND `n`.`from` != `n`.`to`
AND `n`.`to` = `u`.`id`
AND `expire` < NOW()
AND `n`.`deleted` = 0