diff options
| author | Benny Baumann <BenBE@geshi.org> | 2013-11-19 23:02:00 +0100 |
|---|---|---|
| committer | Benny Baumann <BenBE@geshi.org> | 2013-11-19 23:24:09 +0100 |
| commit | b8b0d0044fcac7402bba19bfd601339bf61f1a69 (patch) | |
| tree | 3f3a822ec0d60e2ed3119fa65244aee19528e6f1 /pages/account/55.php | |
| parent | 1d4a0decbddcb0a1c78203720e7a7dcfd702590b (diff) | |
| download | cacert-devel-b8b0d0044fcac7402bba19bfd601339bf61f1a69.tar.gz cacert-devel-b8b0d0044fcac7402bba19bfd601339bf61f1a69.tar.xz cacert-devel-b8b0d0044fcac7402bba19bfd601339bf61f1a69.zip | |
bug 1221: added `deleted` = 0
Diffstat (limited to 'pages/account/55.php')
| -rw-r--r-- | pages/account/55.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/pages/account/55.php b/pages/account/55.php index ec401a0..402b7a8 100644 --- a/pages/account/55.php +++ b/pages/account/55.php @@ -87,7 +87,7 @@ <tr><td colspan="3" class="DataTD"><a href="account.php?id=43&userid=<?=$user_id ?>">back</a></td></tr>
<? } else {
$query = 'SELECT `u`.id, `u`.`assurer`, SUM(`points`) FROM `users` AS `u`, `notary` AS `n` '.
- ' WHERE `u`.`id` = \''.(int)intval($_SESSION['profile']['id']).'\' AND `n`.`to` = `u`.`id` AND `expire` < now() '.
+ ' WHERE `u`.`id` = \''.(int)intval($_SESSION['profile']['id']).'\' AND `n`.`to` = `u`.`id` AND `expire` < now() and and `n`.`deleted` = 0'. ' GROUP BY `u`.id, `u`.`assurer`';
$res = mysql_query($query);
if (!$res) {
|