From b316652307b171588e813b7586efa028f38b6e92 Mon Sep 17 00:00:00 2001 From: =?UTF-8?q?Michael=20T=C3=A4nzer?= Date: Wed, 15 Aug 2012 00:14:31 +0200 Subject: bug 922: only select distinct server serts to avoid processing the same cert multiple times MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Signed-off-by: Michael Tänzer --- scripts/cron/warning.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'scripts/cron') diff --git a/scripts/cron/warning.php b/scripts/cron/warning.php index afa9996..ef570fd 100755 --- a/scripts/cron/warning.php +++ b/scripts/cron/warning.php @@ -69,7 +69,7 @@ echo $row['fname']." ".$row['lname']." <".$row['email']."> (memid: ".$row['memid foreach($days as $day => $warning) { $query = - "SELECT `domaincerts`.`id`, + "SELECT DISTINCT `domaincerts`.`id`, `users`.`fname`, `users`.`lname`, `users`.`email`, `domains`.`memid`, `domaincerts`.`subject`, `domaincerts`.`crt_name`, -- cgit v1.2.1