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 | |
| 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>
| -rw-r--r-- | includes/account.php | 2 | ||||
| -rwxr-xr-x | scripts/cron/warning.php | 2 |
2 files changed, 2 insertions, 2 deletions
diff --git a/includes/account.php b/includes/account.php index 5e87605..4f8ed03 100644 --- a/includes/account.php +++ b/includes/account.php @@ -622,7 +622,7 @@ echo $row['domain']."<br>\n"; $dres = mysql_query( - "select `domaincerts`.`id` + "select distinct `domaincerts`.`id` from `domaincerts`, `domlink` where `domaincerts`.`domid` = '$id' or ( 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`, |