From 3fc28c0142bf8ab4e2cfae44931e2a51aadc4d51 Mon Sep 17 00:00:00 2001
From: mcramer <m.cramer@pixcept.de>
Date: Mon, 25 Feb 2013 13:51:37 -0500
Subject: [PATCH] - Added: remoting queries with a lot of results (e.g. email addresses or alias domains or dns rr) lead to non-functioning soap requests - added '#OFFSET#' AND '#LIMIT#' handling to the query - added automatic 'WHERE 1' if an empty array was given as query example: $result = $api->sites_web_domain_get('type' => 'vhost', '#OFFSET#' => 25, '#LIMIT#' => 50); to get the websites 26 to 75
---
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