diff options
| author | Michael Tänzer <neo@nhng.de> | 2012-08-15 00:14:31 +0200 |
|---|---|---|
| committer | Michael Tänzer <neo@nhng.de> | 2012-08-15 00:14:31 +0200 |
| commit | b316652307b171588e813b7586efa028f38b6e92 (patch) | |
| tree | 4cffdfc5fa3b4a2ba71d512aa5eb89be668c5917 /scripts/cron/warning.php | |
| parent | ded64e3bc978fa332777cf4fffa84c756dd65cb3 (diff) | |
| download | cacert-devel-b316652307b171588e813b7586efa028f38b6e92.tar.gz cacert-devel-b316652307b171588e813b7586efa028f38b6e92.tar.xz cacert-devel-b316652307b171588e813b7586efa028f38b6e92.zip | |
bug 922: only select distinct server serts to avoid processing the same cert
multiple times
Signed-off-by: Michael Tänzer <neo@nhng.de>
Diffstat (limited to 'scripts/cron/warning.php')
| -rwxr-xr-x | scripts/cron/warning.php | 2 |
1 files changed, 1 insertions, 1 deletions
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`, |