From f4038a2160d55a7f519a3b42be1aa96e29e9a908 Mon Sep 17 00:00:00 2001
From: ftimme <ft@falkotimme.com>
Date: Wed, 27 Feb 2013 09:01:40 -0500
Subject: [PATCH] - Fixed "FUNCTION databasename.CONCAT does not exist" error for older MySQL versions.
---
server/plugins-available/maildeliver_plugin.inc.php | 38 ++++++++++++++++++++++++++++++++------
1 files changed, 32 insertions(+), 6 deletions(-)
diff --git a/server/plugins-available/maildeliver_plugin.inc.php b/server/plugins-available/maildeliver_plugin.inc.php
index 9df9fd6..ffbb6ed 100644
--- a/server/plugins-available/maildeliver_plugin.inc.php
+++ b/server/plugins-available/maildeliver_plugin.inc.php
@@ -158,16 +158,42 @@
//* Set alias addresses for autoresponder
$sql = "SELECT * FROM mail_forwarding WHERE type = 'alias' AND destination = '".$app->db->quote($data["new"]["email"])."'";
$records = $app->db->queryAllRecords($sql);
- $addresses = '';
+
+ $addresses = array();
+ $addresses[] = $data["new"]["email"];
if(is_array($records) && count($records) > 0) {
- $addresses .= ':addresses ["'.$data["new"]["email"].'",';
foreach($records as $rec) {
- $addresses .= '"'.$rec['source'].'",';
+ $addresses[] = $rec['source'];
}
- $addresses = substr($addresses,0,-1);
- $addresses .= ']';
}
- $tpl->setVar('addresses',$addresses);
+
+ $email_parts = explode('@',$data["new"]["email"]);
+ $sql = "SELECT * FROM mail_forwarding WHERE type = 'aliasdomain' AND destination = '@".$app->db->quote($email_parts[1])."'";
+ $records = $app->db->queryAllRecords($sql);
+ if(is_array($records) && count($records) > 0) {
+ foreach($records as $rec) {
+ $aliasdomain = substr($rec['source'],1);
+ foreach($addresses as $email) {
+ $email_parts = explode('@',$email);
+ $addresses[] = $email_parts[0].'@'.$aliasdomain;
+ }
+ }
+ }
+
+ $addresses = array_unique($addresses);
+
+ $address_str = '';
+ if(is_array($addresses) && count($addresses) > 0) {
+ $address_str .= ':addresses [';
+ foreach($addresses as $rec) {
+ $address_str .= '"'.$rec.'",';
+ }
+ $address_str = substr($address_str,0,-1);
+ $address_str .= ']';
+ }
+
+
+ $tpl->setVar('addresses',$address_str);
file_put_contents($sieve_file,$tpl->grab());
--
Gitblit v1.9.1