summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorINOPIAE <inopiae@cacert.org>2015-07-22 21:40:31 +0200
committerINOPIAE <inopiae@cacert.org>2015-07-22 21:40:31 +0200
commit1c5bceeae7f572a975ed7c2c17fa4cffce4718a6 (patch)
treedd79a8c2bffe282257c0a7dae51ee8c5e4215a4b
parent5a03b6f6f2eb7ad3e2438035f9e70f1ab4277016 (diff)
downloadcacert-mgr-1c5bceeae7f572a975ed7c2c17fa4cffce4718a6.tar.gz
cacert-mgr-1c5bceeae7f572a975ed7c2c17fa4cffce4718a6.tar.xz
cacert-mgr-1c5bceeae7f572a975ed7c2c17fa4cffce4718a6.zip
bug 1391: adjusted query so that only the non administrative increase assurance are taken for the point calculation
-rw-r--r--manager/application/models/User.php4
1 files changed, 2 insertions, 2 deletions
diff --git a/manager/application/models/User.php b/manager/application/models/User.php
index 3085123..443dac5 100644
--- a/manager/application/models/User.php
+++ b/manager/application/models/User.php
@@ -108,8 +108,8 @@ class Default_Model_User {
* user's points
*/
public function refreshPoints() {
- $query = 'select sum(`points`) as `total` from `notary` '.
- 'where `to` = :user';
+ $query = "select sum(`points`) as `total` from `notary` " .
+ "where `to` = :user and method != 'Administrative Increase' and from != to";
$query_params['user'] = $this->id;
$row = $this->db->query($query, $query_params)->fetch();
if ($row['total'] === null) $row['total'] = 0;