diff options
| -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`, |