ISPConfig3 devel
view | history | commit | commitdiff
Marius Cramer
2015-08-06 37b29231e47a0c4458dc1c15d98588f16f07e1e2
commit | author | age
ac3b1f 1 <?php
T 2 /*
89623d 3 Copyright (c) 2005 - 2009, Till Brehm, projektfarm Gmbh
ac3b1f 4 All rights reserved.
T 5
6 Redistribution and use in source and binary forms, with or without modification,
7 are permitted provided that the following conditions are met:
8
9     * Redistributions of source code must retain the above copyright notice,
10       this list of conditions and the following disclaimer.
11     * Redistributions in binary form must reproduce the above copyright notice,
12       this list of conditions and the following disclaimer in the documentation
13       and/or other materials provided with the distribution.
14     * Neither the name of ISPConfig nor the names of its contributors
15       may be used to endorse or promote products derived from this software without
16       specific prior written permission.
17
18 THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND
19 ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
20 WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED.
21 IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT,
22 INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING,
23 BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
24 DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY
25 OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING
26 NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE,
27 EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
28 */
29
30
31 /******************************************
32 * Begin Form configuration
33 ******************************************/
34
35 $tform_def_file = "form/mail_alias.tform.php";
36
37 /******************************************
38 * End Form configuration
39 ******************************************/
40
7fe908 41 require_once '../../lib/config.inc.php';
MC 42 require_once '../../lib/app.inc.php';
ac3b1f 43
910093 44 //* Check permissions for module
T 45 $app->auth->check_module_permissions('mail');
ac3b1f 46
T 47 // Loading classes
48 $app->uses('tpl,tform,tform_actions');
49 $app->load('tform_actions');
50
51 class page_action extends tform_actions {
7fe908 52
965795 53     function onShowNew() {
T 54         global $app, $conf;
7fe908 55
965795 56         // we will check only users, not admins
T 57         if($_SESSION["s"]["user"]["typ"] == 'user') {
7fe908 58             if(!$app->tform->checkClientLimit('limit_mailalias', "type = 'alias'")) {
3cebc3 59                 $app->error($app->tform->wordbook["limit_mailalias_txt"]);
T 60             }
7fe908 61             if(!$app->tform->checkResellerLimit('limit_mailalias', "type = 'alias'")) {
3cebc3 62                 $app->error('Reseller: '.$app->tform->wordbook["limit_mailalias_txt"]);
965795 63             }
T 64         }
7fe908 65
965795 66         parent::onShowNew();
T 67     }
7fe908 68
ac3b1f 69     function onShowEnd() {
T 70         global $app, $conf;
7fe908 71
ac3b1f 72         $email = $this->dataRecord["source"];
7fe908 73         $email_parts = explode("@", $email);
MC 74         $app->tpl->setVar("email_local_part", $email_parts[0]);
75         $email_parts[1] = $app->functions->idn_decode($email_parts[1]);
76
ac3b1f 77         // Getting Domains of the user
dec0df 78         // $sql = "SELECT domain FROM mail_domain WHERE ".$app->tform->getAuthSQL('r').' ORDER BY domain';
T 79         $sql = "SELECT domain FROM mail_domain WHERE domain NOT IN (SELECT SUBSTR(source,2) FROM mail_forwarding WHERE type = 'aliasdomain') AND ".$app->tform->getAuthSQL('r')." ORDER BY domain";
ac3b1f 80         $domains = $app->db->queryAllRecords($sql);
T 81         $domain_select = '';
82         if(is_array($domains)) {
83             foreach( $domains as $domain) {
7fe908 84                 $domain['domain'] = $app->functions->idn_decode($domain['domain']);
94a020 85                 $selected = ($domain["domain"] == @$email_parts[1])?'SELECTED':'';
ac3b1f 86                 $domain_select .= "<option value='$domain[domain]' $selected>$domain[domain]</option>\r\n";
T 87             }
88         }
7fe908 89         $app->tpl->setVar("email_domain", $domain_select);
MC 90
ac3b1f 91         parent::onShowEnd();
T 92     }
7fe908 93
ac3b1f 94     function onSubmit() {
T 95         global $app, $conf;
7fe908 96
ac3b1f 97         // Check if Domain belongs to user
2af58c 98         $domain = $app->db->queryOneRecord("SELECT server_id, domain FROM mail_domain WHERE domain = ? AND ".$app->tform->getAuthSQL('r'), $app->functions->idn_encode($_POST["email_domain"]));
d6363b 99         if($domain["domain"] != $app->functions->idn_encode($_POST["email_domain"])) $app->tform->errorMessage .= $app->tform->wordbook["no_domain_perm"];
7fe908 100
7b47c0 101         //* Check if destination email belongs to user
T 102         if(isset($_POST["destination"])) {
2af58c 103             $email = $app->db->queryOneRecord("SELECT email FROM mail_user WHERE email = ? AND ".$app->tform->getAuthSQL('r'), $app->functions->idn_encode($_POST["destination"]));
7b47c0 104             if($email["email"] != $app->functions->idn_encode($_POST["destination"])) $app->tform->errorMessage .= $app->tform->lng("no_destination_perm");
T 105         }
7fe908 106
965795 107         // Check the client limits, if user is not the admin
T 108         if($_SESSION["s"]["user"]["typ"] != 'admin') { // if user is not admin
109             // Get the limits of the client
604c0c 110             $client_group_id = $app->functions->intval($_SESSION["s"]["user"]["default_group"]);
cc7a82 111             $client = $app->db->queryOneRecord("SELECT limit_mailalias FROM sys_group, client WHERE sys_group.client_id = client.client_id and sys_group.groupid = ?", $client_group_id);
965795 112
T 113             // Check if the user may add another mailbox.
114             if($this->id == 0 && $client["limit_mailalias"] >= 0) {
2af58c 115                 $tmp = $app->db->queryOneRecord("SELECT count(forwarding_id) as number FROM mail_forwarding WHERE sys_groupid = ? AND type = 'alias'", $client_group_id);
965795 116                 if($tmp["number"] >= $client["limit_mailalias"]) {
T 117                     $app->tform->errorMessage .= $app->tform->wordbook["limit_mailalias_txt"]."<br>";
118                 }
119                 unset($tmp);
120             }
121         } // end if user is not admin
7fe908 122
MC 123
ac3b1f 124         // compose the email field
d6363b 125         $this->dataRecord["source"] = $_POST["email_local_part"]."@".$app->functions->idn_encode($_POST["email_domain"]);
ac3b1f 126         // Set the server id of the mailbox = server ID of mail domain.
604c0c 127         $this->dataRecord["server_id"] = $app->functions->intval($domain["server_id"]);
7fe908 128
ac3b1f 129         unset($this->dataRecord["email_local_part"]);
T 130         unset($this->dataRecord["email_domain"]);
7fe908 131
7acef0 132         //* Check if there is no active mailbox with this address
2af58c 133         $tmp = $app->db->queryOneRecord("SELECT count(mailuser_id) as number FROM mail_user WHERE postfix = 'y' AND email = ?", $this->dataRecord["source"]);
89623d 134         if($tmp['number'] > 0) $app->tform->errorMessage .= $app->tform->lng("duplicate_mailbox_txt")."<br>";
T 135         unset($tmp);
7fe908 136
02bf99 137         //* Check if email alias exists
T 138         if($this->id > 0) {
2af58c 139             $tmp = $app->db->queryOneRecord("SELECT count(forwarding_id) as number FROM mail_forwarding WHERE source = ? AND destination = ? AND forwarding_id != ?", $this->dataRecord["source"], $this->dataRecord["destination"], $this->id);
02bf99 140         } else {
2af58c 141             $tmp = $app->db->queryOneRecord("SELECT count(forwarding_id) as number FROM mail_forwarding WHERE source = ? AND destination = ?", $this->dataRecord["source"], $this->dataRecord["destination"]);
02bf99 142         }
T 143         if($tmp['number'] > 0) $app->tform->errorMessage .= $app->tform->lng("duplicate_email_alias_txt")."<br>";
144         unset($tmp);
7fe908 145
ac3b1f 146         parent::onSubmit();
T 147     }
7fe908 148
d4d985 149     function onAfterInsert() {
T 150         global $app;
7fe908 151
a6e3ae 152         $domain = $app->db->queryOneRecord("SELECT sys_groupid FROM mail_domain WHERE domain = ? AND ".$app->tform->getAuthSQL('r'), $app->functions->idn_encode($_POST["email_domain"]));
2af58c 153         $app->db->query("update mail_forwarding SET sys_groupid = ? WHERE forwarding_id = ?", $domain['sys_groupid'], $this->id);
7fe908 154
d4d985 155     }
7fe908 156
MC 157
ac3b1f 158 }
T 159
160 $page = new page_action;
161 $page->onLoad();
162
7fe908 163 ?>