summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorFelix Dörre <felix@dogcraft.de>2015-04-07 22:04:55 +0200
committerBenny Baumann <BenBE@geshi.org>2015-04-30 00:16:30 +0200
commit9429f6bf21943069d6a577b64f5fa3bce45563c1 (patch)
tree4596e30ff5b4b30d3f1bf63c48d75a2b661a6e94
parent16cb7044fa31e618f969d6104d976a7bc087e1be (diff)
downloadcacert-devel-9429f6bf21943069d6a577b64f5fa3bce45563c1.tar.gz
cacert-devel-9429f6bf21943069d6a577b64f5fa3bce45563c1.tar.xz
cacert-devel-9429f6bf21943069d6a577b64f5fa3bce45563c1.zip
bug-1054: new points calculation for includes/general.php
-rw-r--r--includes/general.php9
1 files changed, 2 insertions, 7 deletions
diff --git a/includes/general.php b/includes/general.php
index 17b449b..45162c0 100644
--- a/includes/general.php
+++ b/includes/general.php
@@ -82,10 +82,7 @@
$locked = mysql_fetch_assoc(mysql_query("select `locked` from `users` where `id`='".intval($_SESSION['profile']['id'])."'"));
if($locked['locked'] == 0)
{
- $query = "select sum(`points`) as `total` from `notary` where `to`='".intval($_SESSION['profile']['id'])."' and `deleted` = 0 group by `to`";
- $res = mysql_query($query);
- $row = mysql_fetch_assoc($res);
- $_SESSION['profile']['points'] = $row['total'];
+ update_points_in_profile();
} else {
$_SESSION['profile'] = "";
unset($_SESSION['profile']);
@@ -477,9 +474,7 @@
if($id <= 0)
$id = $_SESSION['profile']['id'];
- $query = "select sum(`points`) as `points` from `notary` where `to`='$id' and `deleted` = 0 group by `to`";
- $row = mysql_fetch_assoc(mysql_query($query));
- $points = $row['points'];
+ $points = get_received_total_points($id);
$dob = date("Y-m-d", mktime(0,0,0,date("m"),date("d"),date("Y")-18));
$query = "select * from `users` where `id`='".intval($_SESSION['profile']['id'])."' and `dob` < '$dob'";