From b8b0d0044fcac7402bba19bfd601339bf61f1a69 Mon Sep 17 00:00:00 2001 From: Benny Baumann Date: Tue, 19 Nov 2013 23:02:00 +0100 Subject: bug 1221: added `deleted` = 0 --- stamp/common.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'stamp') diff --git a/stamp/common.php b/stamp/common.php index ff814dd..d0a71f4 100644 --- a/stamp/common.php +++ b/stamp/common.php @@ -117,7 +117,7 @@ if($org == 0) { $query = "SELECT *, sum(`points`) AS `total` FROM `users`, `notary` WHERE `users`.`id` = '$cert[memid]' AND - `notary`.`to` = `users`.`id` and `notary`.`when` <= '$cert[issued]' GROUP BY `notary`.`to`"; + `notary`.`to` = `users`.`id` and `notary`.`when` <= '$cert[issued]' and `notary`.`deleted`=0 GROUP BY `notary`.`to`"; $user = mysql_fetch_assoc(mysql_query($query)); } else { $query = "select * from `orginfo` where `id`='$cert[orgid]'"; -- cgit v1.2.1