mail_user_edit.php 15.8 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) {
153
				$tmp = $app->db->queryOneRecord("SELECT sum(quota) as mailquota FROM mail_user WHERE mailuser_id != ".intval($this->id)." AND ".$app->tform->getAuthSQL('u'));
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
//		mail($this->dataRecord["email"],$app->tform->wordbook["welcome_mail_subject"],$app->tform->wordbook["welcome_mail_message"]);
		
217 218 219
		/*
		// the conversion to iso-8859-1 causes compatibility problems, therefore the transition to utf-8

220
		// tries to detect current charset, and encode subject-header and body from it to ISO-8859-1.
221
		$fromCharset      = mb_detect_encoding($app->tform->lng("welcome_mail_subject"));
222 223 224
		$iconvPreferences = array("input-charset" => $fromCharset,
					"output-charset" => "ISO-8859-1",
					"line-length" => 76,
225
					"line-break-chars" => "\n",
226 227
					"scheme" => "Q");

228 229
		$welcomeFromName  = $app->tform->lng("welcome_mail_fromname_txt");
		$welcomeFromEmail = $app->tform->lng("welcome_mail_fromemail_txt");
230 231 232 233
		$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";
234
		$mailTarget       = $this->dataRecord["email"];
235
		$mailSubject      = iconv_mime_encode("trimoff", $app->tform->lng("welcome_mail_subject"), $iconvPreferences);
236
		$mailSubject      = str_replace("trimoff: ", "", $mailSubject);
237
		$mailBody         = iconv ($fromCharset, "ISO-8859-1", $app->tform->lng("welcome_mail_message"));
238 239

		mail($mailTarget, $mailSubject, $mailBody, $mailHeaders);
tbrehm's avatar
tbrehm committed
240
		
241 242 243 244
		*/

		$welcomeFromName  = $app->tform->lng("welcome_mail_fromname_txt");
		$welcomeFromEmail = $app->tform->lng("welcome_mail_fromemail_txt");
245 246 247 248 249 250
		
		$app->uses('getconf');
		$global_config = $app->getconf->get_global_config('mail');
		if(!empty($global_config['admin_mail']))$welcomeFromEmail = $global_config['admin_mail'];
		if(!empty($global_config['admin_name']))$welcomeFromName = $global_config['admin_name'];

251 252 253 254 255 256 257 258 259 260 261 262
		$mailHeaders      = "MIME-Version: 1.0" . "\n";
		$mailHeaders     .= "Content-type: text/plain; charset=utf-8" . "\n";
		$mailHeaders     .= "Content-Transfer-Encoding: 8bit" . "\n";
		$mailHeaders     .= "From: $welcomeFromName  <$welcomeFromEmail>" . "\n";
		$mailHeaders     .= "Reply-To: <$welcomeFromEmail>" . "\n";
		$mailTarget       = $this->dataRecord["email"];

		$mailSubject = "=?utf-8?Q?" . imap_8bit($app->tform->lng("welcome_mail_subject")) . "?=";
		$mailBody = $app->tform->lng("welcome_mail_message");

		mail($mailTarget, $mailSubject, $mailBody, $mailHeaders);
		
tbrehm's avatar
tbrehm committed
263 264 265
		// Spamfilter policy
		$policy_id = intval($this->dataRecord["policy"]);
		if($policy_id > 0) {
266
			$tmp_user = $app->db->queryOneRecord("SELECT id FROM spamfilter_users WHERE email = '".mysql_real_escape_string($this->dataRecord["email"])."'");
tbrehm's avatar
tbrehm committed
267 268
			if($tmp_user["id"] > 0) {
				// There is already a record that we will update
tbrehm's avatar
tbrehm committed
269
				$app->db->datalogUpdate('spamfilter_users', "policy_id = $ploicy_id", 'id', $tmp_user["id"]);
tbrehm's avatar
tbrehm committed
270 271
			} else {
				// We create a new record
272
				$insert_data = "(`sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`, `server_id`, `priority`, `policy_id`, `email`, `fullname`, `local`) 
273
				        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')";
274
				$app->db->datalogInsert('spamfilter_users', $insert_data, 'id');
tbrehm's avatar
tbrehm committed
275 276 277
			}
		}  // endif spamfilter policy
		
278 279 280 281 282 283 284 285 286 287 288
		
		// 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
289 290 291 292 293 294
	}
	
	function onAfterUpdate() {
		global $app, $conf;
		
		// Set the domain owner as mailbox owner
295 296 297
		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
298
		
299 300
			// Spamfilter policy
			$policy_id = intval($this->dataRecord["policy"]);
301
			$tmp_user = $app->db->queryOneRecord("SELECT id FROM spamfilter_users WHERE email = '".mysql_real_escape_string($this->dataRecord["email"])."'");
302 303 304
			if($policy_id > 0) {
				if($tmp_user["id"] > 0) {
					// There is already a record that we will update
305
					$app->db->datalogUpdate('spamfilter_users', "policy_id = $policy_id", 'id', $tmp_user["id"]);
306 307
				} else {
					// We create a new record
308
					$insert_data = "(`sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`, `server_id`, `priority`, `policy_id`, `email`, `fullname`, `local`) 
309
				        	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')";
310
					$app->db->datalogInsert('spamfilter_users', $insert_data, 'id');
311 312 313 314
				}
			}else {
				if($tmp_user["id"] > 0) {
					// There is already a record but the user shall have no policy, so we delete it
315
					$app->db->datalogDelete('spamfilter_users', 'id', $tmp_user["id"]);
316 317 318
				}
			} // endif spamfilter policy
		}
tbrehm's avatar
tbrehm committed
319
		
320 321 322 323 324 325 326 327 328 329 330
		// 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
331
		//** If the email address has been changed, change it in all aliases too
332 333
		if(isset($this->dataRecord['email']) && $this->oldDataRecord['email'] != $this->dataRecord['email']) {
		//if($this->oldDataRecord['email'] != $this->dataRecord['email']) {
tbrehm's avatar
tbrehm committed
334 335 336 337 338 339 340 341 342 343 344 345
			
			//* Update the aliases
			$forwardings = $app->db->queryAllRecords("SELECT * FROM mail_forwarding WHERE destination = '".$app->db->quote($this->oldDataRecord['email'])."'");
			if(is_array($forwardings)) {
				foreach($forwardings as $rec) {
					$destination = $app->db->quote($this->dataRecord['email']);
					$app->db->datalogUpdate('mail_forwarding', "destination = '$destination'", 'forwarding_id', $rec['forwarding_id']);
				}
			}
			
		} // end if email addess changed
		
tbrehm's avatar
tbrehm committed
346 347
	}
	
tbrehm's avatar
tbrehm committed
348 349 350 351 352
}

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

353
?>