mail_user_edit.php 14 KB
Newer Older
tbrehm's avatar
tbrehm committed
1 2
<?php
/*
3
Copyright (c) 2005 - 2009, Till Brehm, projektfarm Gmbh
tbrehm's avatar
tbrehm committed
4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34
All rights reserved.

Redistribution and use in source and binary forms, with or without modification,
are permitted provided that the following conditions are met:

    * Redistributions of source code must retain the above copyright notice,
      this list of conditions and the following disclaimer.
    * Redistributions in binary form must reproduce the above copyright notice,
      this list of conditions and the following disclaimer in the documentation
      and/or other materials provided with the distribution.
    * Neither the name of ISPConfig nor the names of its contributors
      may be used to endorse or promote products derived from this software without
      specific prior written permission.

THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND
ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED.
IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT,
INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING,
BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY
OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING
NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE,
EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
*/


/******************************************
* Begin Form configuration
******************************************/

tbrehm's avatar
tbrehm committed
35
$tform_def_file = "form/mail_user.tform.php";
tbrehm's avatar
tbrehm committed
36 37 38 39 40 41 42 43

/******************************************
* End Form configuration
******************************************/

require_once('../../lib/config.inc.php');
require_once('../../lib/app.inc.php');

44 45
//* Check permissions for module
$app->auth->check_module_permissions('mail');
tbrehm's avatar
tbrehm committed
46 47 48 49 50 51 52

// Loading classes
$app->uses('tpl,tform,tform_actions');
$app->load('tform_actions');

class page_action extends tform_actions {
	
tbrehm's avatar
tbrehm committed
53 54 55 56 57 58
	
	function onShowNew() {
		global $app, $conf;
		
		// we will check only users, not admins
		if($_SESSION["s"]["user"]["typ"] == 'user') {
59 60 61 62 63
			if(!$app->tform->checkClientLimit('limit_mailbox')) {
				$app->error($app->tform->wordbook["limit_mailbox_txt"]);
			}
			if(!$app->tform->checkResellerLimit('limit_mailbox')) {
				$app->error('Reseller: '.$app->tform->wordbook["limit_mailbox_txt"]);
tbrehm's avatar
tbrehm committed
64 65 66 67 68 69
			}
		}
		
		parent::onShowNew();
	}
	
tbrehm's avatar
tbrehm committed
70 71 72 73 74 75 76 77
	function onShowEnd() {
		global $app, $conf;
		
		$email = $this->dataRecord["email"];
		$email_parts = explode("@",$email);
		$app->tpl->setVar("email_local_part",$email_parts[0]);
		
		// Getting Domains of the user
78
		$sql = "SELECT domain FROM mail_domain WHERE ".$app->tform->getAuthSQL('r').' ORDER BY domain';
tbrehm's avatar
tbrehm committed
79 80
		$domains = $app->db->queryAllRecords($sql);
		$domain_select = '';
tbrehm's avatar
tbrehm committed
81 82
		if(is_array($domains)) {
			foreach( $domains as $domain) {
83
				$selected = ($domain["domain"] == @$email_parts[1])?'SELECTED':'';
tbrehm's avatar
tbrehm committed
84 85
				$domain_select .= "<option value='$domain[domain]' $selected>$domain[domain]</option>\r\n";
			}
tbrehm's avatar
tbrehm committed
86 87
		}
		$app->tpl->setVar("email_domain",$domain_select);
tbrehm's avatar
tbrehm committed
88 89 90 91 92 93 94
		unset($domains);
		unset($domain_select);
		
		// Get the spamfilter policys for the user
		$tmp_user = $app->db->queryOneRecord("SELECT policy_id FROM spamfilter_users WHERE email = '".$this->dataRecord["email"]."'");
		$sql = "SELECT id, policy_name FROM spamfilter_policy WHERE ".$app->tform->getAuthSQL('r');
		$policys = $app->db->queryAllRecords($sql);
95
		$policy_select = "<option value='0'>".$app->tform->lng("no_policy")."</option>";
tbrehm's avatar
tbrehm committed
96 97 98 99 100 101 102 103 104 105
		if(is_array($policys)) {
			foreach( $policys as $p) {
				$selected = ($p["id"] == $tmp_user["policy_id"])?'SELECTED':'';
				$policy_select .= "<option value='$p[id]' $selected>$p[policy_name]</option>\r\n";
			}
		}
		$app->tpl->setVar("policy",$policy_select);
		unset($policys);
		unset($policy_select);
		unset($tmp_user);
tbrehm's avatar
tbrehm committed
106
		
tbrehm's avatar
tbrehm committed
107
		// Convert quota from Bytes to MB
tbrehm's avatar
tbrehm committed
108
		if($this->dataRecord["quota"] != -1) $app->tpl->setVar("quota",$this->dataRecord["quota"] / 1024 / 1024);
tbrehm's avatar
tbrehm committed
109
		
110 111 112 113 114 115 116
		// Is autoresponder set?
		if ($this->dataRecord['autoresponder'] == 'y') {
			$app->tpl->setVar("ar_active", 'checked="checked"');
		} else {
			$app->tpl->setVar("ar_active", '');
		}
		
tbrehm's avatar
tbrehm committed
117 118 119 120 121 122
		parent::onShowEnd();
	}
	
	function onSubmit() {
		global $app, $conf;
		
123
		//* Check if Domain belongs to user
124 125
		if(isset($_POST["email_domain"])) {
			$domain = $app->db->queryOneRecord("SELECT server_id, domain FROM mail_domain WHERE domain = '".$app->db->quote($_POST["email_domain"])."' AND ".$app->tform->getAuthSQL('r'));
126
			if($domain["domain"] != $_POST["email_domain"]) $app->tform->errorMessage .= $app->tform->lng("no_domain_perm");
127
		}
tbrehm's avatar
tbrehm committed
128
		
tbrehm's avatar
tbrehm committed
129
		
130
		//* if its an insert, check that the password is not empty
tbrehm's avatar
tbrehm committed
131
		if($this->id == 0 && $_POST["password"] == '') {
132
			$app->tform->errorMessage .= $app->tform->lng("error_no_pwd")."<br>";
tbrehm's avatar
tbrehm committed
133 134
		}
		
135
		//* Check the client limits, if user is not the admin
tbrehm's avatar
tbrehm committed
136 137 138 139
		if($_SESSION["s"]["user"]["typ"] != 'admin') { // if user is not admin
			// Get the limits of the client
			$client_group_id = $_SESSION["s"]["user"]["default_group"];
			$client = $app->db->queryOneRecord("SELECT limit_mailbox, limit_mailquota FROM sys_group, client WHERE sys_group.client_id = client.client_id and sys_group.groupid = $client_group_id");
tbrehm's avatar
tbrehm committed
140
			
tbrehm's avatar
tbrehm committed
141

tbrehm's avatar
tbrehm committed
142
			// Check if the user may add another mailbox.
tbrehm's avatar
tbrehm committed
143
			if($this->id == 0 && $client["limit_mailbox"] >= 0) {
tbrehm's avatar
tbrehm committed
144 145
				$tmp = $app->db->queryOneRecord("SELECT count(mailuser_id) as number FROM mail_user WHERE sys_groupid = $client_group_id");
				if($tmp["number"] >= $client["limit_mailbox"]) {
146
					$app->tform->errorMessage .= $app->tform->lng("limit_mailbox_txt")."<br>";
tbrehm's avatar
tbrehm committed
147 148 149
				}
				unset($tmp);
			}
tbrehm's avatar
tbrehm committed
150 151
			
			// Check the quota and adjust
152
			if(isset($_POST["quota"]) && $client["limit_mailquota"] >= 0) {
tbrehm's avatar
tbrehm committed
153
				$tmp = $app->db->queryOneRecord("SELECT sum(quota) as mailquota FROM mail_user WHERE mailuser_id != ".intval($this->id)." AND sys_groupid = $client_group_id");
154
				$mailquota = $tmp["mailquota"] / 1024 / 1024;
tbrehm's avatar
tbrehm committed
155
				$new_mailbox_quota = intval($this->dataRecord["quota"]);
156
				if(($mailquota + $new_mailbox_quota > $client["limit_mailquota"]) || ($new_mailbox_quota == 0 && $client["limit_mailquota"] != -1)) {
tbrehm's avatar
tbrehm committed
157
					$max_free_quota = $client["limit_mailquota"] - $mailquota;
158
					$app->tform->errorMessage .= $app->tform->lng("limit_mailquota_txt").": ".$max_free_quota."<br>";
tbrehm's avatar
tbrehm committed
159 160 161 162 163
					// Set the quota field to the max free space
					$this->dataRecord["quota"] = $max_free_quota;
				}
				unset($tmp);
				unset($tmp_quota);
tbrehm's avatar
tbrehm committed
164
			}
tbrehm's avatar
tbrehm committed
165
		} // end if user is not admin
tbrehm's avatar
tbrehm committed
166
		
tbrehm's avatar
tbrehm committed
167

168
		//* compose the email field
169
		if(isset($_POST["email_local_part"]) && isset($_POST["email_domain"])) {
170
			$this->dataRecord["email"] = strtolower($_POST["email_local_part"]."@".$_POST["email_domain"]);
171 172 173
		
			// Set the server id of the mailbox = server ID of mail domain.
			$this->dataRecord["server_id"] = $domain["server_id"];
tbrehm's avatar
tbrehm committed
174
		
175 176
			unset($this->dataRecord["email_local_part"]);
			unset($this->dataRecord["email_domain"]);
tbrehm's avatar
tbrehm committed
177
		
178
			// Convert quota from MB to Bytes
tbrehm's avatar
tbrehm committed
179
			if($this->dataRecord["quota"] != -1) $this->dataRecord["quota"] = $this->dataRecord["quota"] * 1024 * 1024;
tbrehm's avatar
tbrehm committed
180
		
181 182 183 184
			// setting Maildir, Homedir, UID and GID
			$app->uses('getconf');
			$mail_config = $app->getconf->get_server_config($domain["server_id"],'mail');
			$maildir = str_replace("[domain]",$domain["domain"],$mail_config["maildir_path"]);
185
			$maildir = str_replace("[localpart]",strtolower($_POST["email_local_part"]),$maildir);
186 187 188 189
			$this->dataRecord["maildir"] = $maildir;
			$this->dataRecord["homedir"] = $mail_config["homedir_path"];
			$this->dataRecord["uid"] = $mail_config["mailuser_uid"];
			$this->dataRecord["gid"] = $mail_config["mailuser_gid"];
190 191
			
			//* Check if there is no alias or forward with this address
192
			$tmp = $app->db->queryOneRecord("SELECT count(forwarding_id) as number FROM mail_forwarding WHERE active = 'y' AND source = '".$app->db->quote($this->dataRecord["email"])."'");
193 194 195
			if($tmp['number'] > 0) $app->tform->errorMessage .= $app->tform->lng("duplicate_alias_or_forward_txt")."<br>";
			unset($tmp);
			
196
		}
tbrehm's avatar
tbrehm committed
197
		
198 199 200 201 202 203
		//* if autoresponder checkbox not selected, do not save dates
		if (!isset($_POST['autoresponder']) && array_key_exists('autoresponder_start_date', $_POST)) {
			$this->dataRecord['autoresponder_start_date'] = array_map(create_function('$item','return 0;'), $this->dataRecord['autoresponder_start_date']);
			$this->dataRecord['autoresponder_end_date'] = array_map(create_function('$item','return 0;'), $this->dataRecord['autoresponder_end_date']);
		}
		
tbrehm's avatar
tbrehm committed
204 205 206
		parent::onSubmit();
	}
	
tbrehm's avatar
tbrehm committed
207 208 209 210
	function onAfterInsert() {
		global $app, $conf;
		
		// Set the domain owner as mailbox owner
tbrehm's avatar
tbrehm committed
211
		$domain = $app->db->queryOneRecord("SELECT sys_groupid, server_id FROM mail_domain WHERE domain = '".$app->db->quote($_POST["email_domain"])."' AND ".$app->tform->getAuthSQL('r'));
tbrehm's avatar
tbrehm committed
212
		$app->db->query("UPDATE mail_user SET sys_groupid = ".$domain["sys_groupid"]." WHERE mailuser_id = ".$this->id);
tbrehm's avatar
tbrehm committed
213 214
		
		// send a welcome email to create the mailbox
215 216 217
//		mail($this->dataRecord["email"],$app->tform->wordbook["welcome_mail_subject"],$app->tform->wordbook["welcome_mail_message"]);
		
		// tries to detect current charset, and encode subject-header and body from it to ISO-8859-1.
218
		$fromCharset      = mb_detect_encoding($app->tform->lng("welcome_mail_subject"));
219 220 221
		$iconvPreferences = array("input-charset" => $fromCharset,
					"output-charset" => "ISO-8859-1",
					"line-length" => 76,
222
					"line-break-chars" => "\n",
223 224
					"scheme" => "Q");

225 226
		$welcomeFromName  = $app->tform->lng("welcome_mail_fromname_txt");
		$welcomeFromEmail = $app->tform->lng("welcome_mail_fromemail_txt");
227 228 229 230
		$mailHeaders      = "MIME-Version: 1.0" . "\n";
		$mailHeaders     .= "Content-type: text/plain; charset=iso-8859-1" . "\n";
		$mailHeaders     .= "From: $welcomeFromName  <$welcomeFromEmail>" . "\n";
		$mailHeaders     .= "Reply-To: <$welcomeFromEmail>" . "\n";
231
		$mailTarget       = $this->dataRecord["email"];
232
		$mailSubject      = iconv_mime_encode("trimoff", $app->tform->lng("welcome_mail_subject"), $iconvPreferences);
233
		$mailSubject      = str_replace("trimoff: ", "", $mailSubject);
234
		$mailBody         = iconv ($fromCharset, "ISO-8859-1", $app->tform->lng("welcome_mail_message"));
235 236

		mail($mailTarget, $mailSubject, $mailBody, $mailHeaders);
tbrehm's avatar
tbrehm committed
237 238 239 240
		
		// Spamfilter policy
		$policy_id = intval($this->dataRecord["policy"]);
		if($policy_id > 0) {
241
			$tmp_user = $app->db->queryOneRecord("SELECT id FROM spamfilter_users WHERE email = '".mysql_real_escape_string($this->dataRecord["email"])."'");
tbrehm's avatar
tbrehm committed
242 243
			if($tmp_user["id"] > 0) {
				// There is already a record that we will update
tbrehm's avatar
tbrehm committed
244
				$app->db->datalogUpdate('spamfilter_users', "policy_id = $ploicy_id", 'id', $tmp_user["id"]);
tbrehm's avatar
tbrehm committed
245 246
			} else {
				// We create a new record
247
				$insert_data = "(`sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`, `server_id`, `priority`, `policy_id`, `email`, `fullname`, `local`) 
248
				        VALUES (".$_SESSION["s"]["user"]["userid"].", ".$domain["sys_groupid"].", 'riud', 'riud', '', ".$domain["server_id"].", 10, ".$policy_id.", '".mysql_real_escape_string($this->dataRecord["email"])."', '".mysql_real_escape_string($this->dataRecord["email"])."', 'Y')";
249
				$app->db->datalogInsert('spamfilter_users', $insert_data, 'id');
tbrehm's avatar
tbrehm committed
250 251 252
			}
		}  // endif spamfilter policy
		
253 254 255 256 257 258 259 260 261 262 263
		
		// Set the fields for dovecot
		if(isset($this->dataRecord["email"])) {
			$disableimap = ($this->dataRecord["disableimap"])?'y':'n';
			$disablepop3 = ($this->dataRecord["disablepop3"])?'y':'n';
			$disabledeliver = ($this->dataRecord["postfix"] == 'y')?'n':'y';
			$disablesmtp = ($this->dataRecord["postfix"] == 'y')?'n':'y';
		
			$sql = "UPDATE mail_user SET disableimap = '$disableimap', disablepop3 = '$disablepop3', disablesmtp = '$disablesmtp', disabledeliver = '$disabledeliver' WHERE mailuser_id = ".$this->id;
			$app->db->query($sql);
		}
tbrehm's avatar
tbrehm committed
264 265 266 267 268 269
	}
	
	function onAfterUpdate() {
		global $app, $conf;
		
		// Set the domain owner as mailbox owner
270 271 272
		if(isset($_POST["email_domain"])) {
			$domain = $app->db->queryOneRecord("SELECT sys_groupid, server_id FROM mail_domain WHERE domain = '".$app->db->quote($_POST["email_domain"])."' AND ".$app->tform->getAuthSQL('r'));
			$app->db->query("UPDATE mail_user SET sys_groupid = ".$domain["sys_groupid"]." WHERE mailuser_id = ".$this->id);
tbrehm's avatar
tbrehm committed
273
		
274 275
			// Spamfilter policy
			$policy_id = intval($this->dataRecord["policy"]);
276
			$tmp_user = $app->db->queryOneRecord("SELECT id FROM spamfilter_users WHERE email = '".mysql_real_escape_string($this->dataRecord["email"])."'");
277 278 279
			if($policy_id > 0) {
				if($tmp_user["id"] > 0) {
					// There is already a record that we will update
280
					$app->db->datalogUpdate('spamfilter_users', "policy_id = $policy_id", 'id', $tmp_user["id"]);
281 282
				} else {
					// We create a new record
283
					$insert_data = "(`sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`, `server_id`, `priority`, `policy_id`, `email`, `fullname`, `local`) 
284
				        	VALUES (".$_SESSION["s"]["user"]["userid"].", ".$domain["sys_groupid"].", 'riud', 'riud', '', ".$domain["server_id"].", 10, ".$policy_id.", '".mysql_real_escape_string($this->dataRecord["email"])."', '".mysql_real_escape_string($this->dataRecord["email"])."', 'Y')";
285
					$app->db->datalogInsert('spamfilter_users', $insert_data, 'id');
286 287 288 289
				}
			}else {
				if($tmp_user["id"] > 0) {
					// There is already a record but the user shall have no policy, so we delete it
290
					$app->db->datalogDelete('spamfilter_users', 'id', $tmp_user["id"]);
291 292 293
				}
			} // endif spamfilter policy
		}
tbrehm's avatar
tbrehm committed
294
		
295 296 297 298 299 300 301 302 303 304 305
		// Set the fields for dovecot
		if(isset($this->dataRecord["email"])) {
			$disableimap = ($this->dataRecord["disableimap"])?'y':'n';
			$disablepop3 = ($this->dataRecord["disablepop3"])?'y':'n';
			$disabledeliver = ($this->dataRecord["postfix"] == 'y')?'n':'y';
			$disablesmtp = ($this->dataRecord["postfix"] == 'y')?'n':'y';
		
			$sql = "UPDATE mail_user SET disableimap = '$disableimap', disablepop3 = '$disablepop3', disablesmtp = '$disablesmtp', disabledeliver = '$disabledeliver' WHERE mailuser_id = ".$this->id;
			$app->db->query($sql);
		}
		
tbrehm's avatar
tbrehm committed
306 307
	}
	
tbrehm's avatar
tbrehm committed
308 309 310 311 312
}

$app->tform_actions = new page_action;
$app->tform_actions->onLoad();

313
?>