bug 922: only select distinct server serts to avoid processing the same cert
authorMichael Tänzer <neo@nhng.de>
Tue, 14 Aug 2012 22:14:31 +0000 (00:14 +0200)
committerMichael Tänzer <neo@nhng.de>
Tue, 14 Aug 2012 22:14:31 +0000 (00:14 +0200)
multiple times

Signed-off-by: Michael Tänzer <neo@nhng.de>
includes/account.php
scripts/cron/warning.php

index 5e87605..4f8ed03 100644 (file)
                                        echo $row['domain']."<br>\n";
                                        
                                        $dres = mysql_query(
-                                               "select `domaincerts`.`id`
+                                               "select distinct `domaincerts`.`id`
                                                        from `domaincerts`, `domlink`
                                                        where `domaincerts`.`domid` = '$id'
                                                        or (
index afa9996..ef570fd 100755 (executable)
@@ -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`,