From fe9a23f542bc56c1c0b6dc30257418e38ff7bd3a Mon Sep 17 00:00:00 2001
From: ftimme <ft@falkotimme.com>
Date: Sat, 08 Jun 2013 18:57:40 -0400
Subject: [PATCH] - Fixed FS#2936 - Please check and limit username input length.

---
 interface/web/tools/import_ispconfig.php |   19 ++++++++++++++++---
 1 files changed, 16 insertions(+), 3 deletions(-)

diff --git a/interface/web/tools/import_ispconfig.php b/interface/web/tools/import_ispconfig.php
index eb0a2f3..432bb31 100644
--- a/interface/web/tools/import_ispconfig.php
+++ b/interface/web/tools/import_ispconfig.php
@@ -49,7 +49,7 @@
 $app->tpl->setVar($wb);
 
 if(isset($_POST['connected'])) {
-	$connected = intval($_POST['connected']);
+	$connected = $app->functions->intval($_POST['connected']);
 	if($connected == 0) {
 
 		//* Try to connect to remote server
@@ -142,12 +142,18 @@
 	global $app, $conf, $client, $msg, $error, $remote_session_id;
 	
 	//* Get the user and groupid for the new records
-	$sys_groupid = intval($_POST['client_group_id']);
+	$sys_groupid = $app->functions->intval($_POST['client_group_id']);
 	$tmp = $app->db->queryOneRecord("SELECT userid FROM sys_user WHERE default_group = $sys_groupid");
-	$sys_userid = intval($tmp['userid']);
+	$sys_userid = $app->functions->intval($tmp['userid']);
 	unset($tmp);
 	if($sys_groupid == 0) $error .= 'Inavlid groupid<br />';
 	if($sys_userid == 0) $error .= 'Inavlid Userid<br />';
+	
+	//* Get the mail server ID
+	$tmp = $app->db->queryOneRecord("SELECT server_id FROM server WHERE mail_server = 1 LIMIT 0,1");
+	$server_id = intval($tmp['server_id']);
+	unset($tmp);
+	if($server_id == 0) $server_id = 1;
 	
 	//* get the mail domain record
 	$mail_domain_rec = $client->mail_domain_get($remote_session_id, array('domain' => $mail_domain));
@@ -160,6 +166,7 @@
 		//* Change the record owner and remove the index field
 		$mail_domain_rec['sys_userid'] = $sys_userid;
 		$mail_domain_rec['sys_groupid'] = $sys_groupid;
+		$mail_domain_rec['server_id'] = $server_id;
 		unset($mail_domain_rec['domain_id']);
 		
 		//* Insert domain if no error occurred
@@ -181,6 +188,7 @@
 						//* Prepare record
 						$mail_user['sys_userid'] = $sys_userid;
 						$mail_user['sys_groupid'] = $sys_groupid;
+						$mail_user['server_id'] = $server_id;
 						$remote_mailuser_id = $mail_user['mailuser_id'];
 						unset($mail_user['mailuser_id']);
 						if(!isset($_POST['import_user_filter'])) $mail_user['custom_mailfilter'] = '';
@@ -199,6 +207,7 @@
 									$mail_user_filter['sys_userid'] = $sys_userid;
 									$mail_user_filter['sys_groupid'] = $sys_groupid;
 									$mail_user_filter['mailuser_id'] = $local_mailuser_id;
+									$mail_user_filter['server_id'] = $server_id;
 									unset($mail_user_filter['filter_id']);
 									
 									//* Insert record in DB
@@ -224,6 +233,7 @@
 					if($tmp['number'] == 0) {
 						$mail_alias['sys_userid'] = $sys_userid;
 						$mail_alias['sys_groupid'] = $sys_groupid;
+						$mail_alias['server_id'] = $server_id;
 						unset($mail_alias['forwarding_id']);
 						$app->db->datalogInsert('mail_forwarding', $mail_alias, 'forwarding_id');
 						$msg .= "Imported email alias ".$mail_alias['source']."<br />";
@@ -244,6 +254,7 @@
 					if($tmp['number'] == 0) {
 						$mail_alias['sys_userid'] = $sys_userid;
 						$mail_alias['sys_groupid'] = $sys_groupid;
+						$mail_alias['server_id'] = $server_id;
 						unset($mail_alias['forwarding_id']);
 						$app->db->datalogInsert('mail_forwarding', $mail_alias, 'forwarding_id');
 						$msg .= "Imported email aliasdomain ".$mail_alias['source']."<br />";
@@ -264,6 +275,7 @@
 					if($tmp['number'] == 0) {
 						$mail_forward['sys_userid'] = $sys_userid;
 						$mail_forward['sys_groupid'] = $sys_groupid;
+						$mail_forward['server_id'] = $server_id;
 						unset($mail_forward['forwarding_id']);
 						$app->db->datalogInsert('mail_forwarding', $mail_forward, 'forwarding_id');
 						$msg .= "Imported email forward ".$mail_forward['source']."<br />";
@@ -284,6 +296,7 @@
 					if($tmp['number'] == 0) {
 						$mail_spamfilter['sys_userid'] = $sys_userid;
 						$mail_spamfilter['sys_groupid'] = $sys_groupid;
+						$mail_spamfilter['server_id'] = $server_id;
 						unset($mail_spamfilter['id']);
 						$app->db->datalogInsert('spamfilter_users', $mail_spamfilter, 'id');
 						$msg .= "Imported spamfilter user ".$mail_spamfilter['email']."<br />";

--
Gitblit v1.9.1