From 7aa13b258f4b47c7ad41c49cd6983c9e4876ff61 Mon Sep 17 00:00:00 2001 From: =?UTF-8?q?Michael=20T=C3=A4nzer?= Date: Fri, 21 Mar 2014 16:30:06 +0100 Subject: bug 1221: Ignore deleted assurances when calculating the cert validity period MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Signed-off-by: Michael Tänzer --- CommModule/client.pl | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'CommModule/client.pl') diff --git a/CommModule/client.pl b/CommModule/client.pl index bf92b27..1d87adb 100755 --- a/CommModule/client.pl +++ b/CommModule/client.pl @@ -441,7 +441,7 @@ sub calculateDays($) { if($_[0]) { - my @sum = $dbh->selectrow_array("select sum(`points`) as `total` from `notary` where `to`='".$_[0]."' group by `to`"); + my @sum = $dbh->selectrow_array("select sum(`points`) as `total` from `notary` where `to`='".$_[0]."' and `deleted`=0 group by `to`"); SysLog("Summe: $sum[0]\n") if($debug); return ($sum[0]>=50)?730:180; -- cgit v1.2.1