From e1ceb050e19c7574bca146a8da7047ee4ff456b5 Mon Sep 17 00:00:00 2001
From: Marius Burkard <m.burkard@pixcept.de>
Date: Sun, 10 Jul 2016 05:02:35 -0400
Subject: [PATCH] Merge branch 'stable-3.1'

---
 interface/web/dns/dns_import.php |  739 ++++++++++++++++++++++++++++----------------------------
 1 files changed, 374 insertions(+), 365 deletions(-)

diff --git a/interface/web/dns/dns_import.php b/interface/web/dns/dns_import.php
index fdac6ac..6bb738e 100644
--- a/interface/web/dns/dns_import.php
+++ b/interface/web/dns/dns_import.php
@@ -28,8 +28,8 @@
 EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
 */
 
-require_once('../../lib/config.inc.php');
-require_once('../../lib/app.inc.php');
+require_once '../../lib/config.inc.php';
+require_once '../../lib/app.inc.php';
 
 //* Check permissions for module
 $app->auth->check_module_permissions('dns');
@@ -38,23 +38,39 @@
 $error = '';
 
 // Loading the template
-$app->uses('tpl,validate_dns');
+$app->uses('tform,tpl,validate_dns');
 $app->tpl->newTemplate("form.tpl.htm");
-$app->tpl->setInclude('content_tpl','templates/dns_import.htm');
+$app->tpl->setInclude('content_tpl', 'templates/dns_import.htm');
 $app->load_language_file('/web/dns/lib/lang/'.$_SESSION['s']['language'].'_dns_wizard.lng');
 
+// Check if dns record limit has been reached. We will check only users, not admins
+if($_SESSION["s"]["user"]["typ"] == 'user') {
+	$app->tform->formDef['db_table_idx'] = 'id';
+	$app->tform->formDef['db_table'] = 'dns_soa';
+	if(!$app->tform->checkClientLimit('limit_dns_zone')) {
+		$app->error($app->lng('limit_dns_zone_txt'));
+	}
+	if(!$app->tform->checkResellerLimit('limit_dns_zone')) {
+		$app->error('Reseller: '.$app->lng('limit_dns_zone_txt'));
+	}
+}
+
 // import variables
-$template_id = (isset($_POST['template_id']))?intval($_POST['template_id']):0;
-$sys_groupid = (isset($_POST['client_group_id']))?intval($_POST['client_group_id']):0;
+$template_id = (isset($_POST['template_id']))?$app->functions->intval($_POST['template_id']):0;
+$sys_groupid = (isset($_POST['client_group_id']))?$app->functions->intval($_POST['client_group_id']):0;
 $domain = (isset($_POST['domain'])&&!empty($_POST['domain']))?$_POST['domain']:NULL;
 
 // get the correct server_id
-if($_SESSION['s']['user']['typ'] == 'admin') {
-	$server_id = (isset($_POST['server_id']))?intval($_POST['server_id']):1;
+if (isset($_POST['server_id'])) {
+	$server_id = $app->functions->intval($_POST['server_id']);
+	$post_server_id = true;
+} elseif (isset($_POST['server_id_value'])) {
+	$server_id = $app->functions->intval($_POST['server_id_value']);
+	$post_server_id = true;
 } else {
-	$client_group_id = $_SESSION["s"]["user"]["default_group"];
-	$client = $app->db->queryOneRecord("SELECT default_dnsserver FROM sys_group, client WHERE sys_group.client_id = client.client_id and sys_group.groupid = $client_group_id");
-	$server_id = $client["default_dnsserver"];
+	$settings = $app->getconf->get_global_config('dns');
+	$server_id = $app->functions->intval($settings['default_dnsserver']);
+	$post_server_id = false;
 }
 
 
@@ -69,11 +85,11 @@
 	$n++;
 }
 unset($n);
-$app->tpl->setVar("template_id_option",$template_id_option);
+$app->tpl->setVar("template_id_option", $template_id_option);
 
 // If the user is administrator
 if($_SESSION['s']['user']['typ'] == 'admin') {
-	
+
 	// Load the list of servers
 	$records = $app->db->queryAllRecords("SELECT server_id, server_name FROM server WHERE mirror_server_id = 0 AND dns_server = 1 ORDER BY server_name");
 	$server_id_option = '';
@@ -81,73 +97,152 @@
 		$checked = ($rec['server_id'] == $server_id)?' SELECTED':'';
 		$server_id_option .= '<option value="'.$rec['server_id'].'"'.$checked.'>'.$rec['server_name'].'</option>';
 	}
-	$app->tpl->setVar("server_id",$server_id_option);
-	
+	$app->tpl->setVar("server_id", $server_id_option);
+
 	// load the list of clients
-	$sql = "SELECT sys_group.groupid, sys_group.name, CONCAT(client.company_name,' :: ',client.contact_name) as contactname FROM sys_group, client WHERE sys_group.client_id = client.client_id AND sys_group.client_id > 0 ORDER BY sys_group.name";
+	$sql = "SELECT sys_group.groupid, sys_group.name, CONCAT(IF(client.company_name != '', CONCAT(client.company_name, ' :: '), ''), client.contact_name, ' (', client.username, IF(client.customer_no != '', CONCAT(', ', client.customer_no), ''), ')') as contactname FROM sys_group, client WHERE sys_group.client_id = client.client_id AND sys_group.client_id > 0 ORDER BY client.company_name, client.contact_name, sys_group.name";
 	$clients = $app->db->queryAllRecords($sql);
 	$client_select = '';
 	if($_SESSION["s"]["user"]["typ"] == 'admin') $client_select .= "<option value='0'></option>";
 	if(is_array($clients)) {
 		foreach( $clients as $client) {
 			$selected = ($client["groupid"] == $sys_groupid)?'SELECTED':'';
-			$client_select .= "<option value='$client[groupid]' $selected>$client[name] :: $client[contactname]</option>\r\n";
+			$client_select .= "<option value='$client[groupid]' $selected>$client[contactname]</option>\r\n";
 		}
 	}
 
-	$app->tpl->setVar("client_group_id",$client_select);
+	$app->tpl->setVar("client_group_id", $client_select);
 }
 
 if ($_SESSION["s"]["user"]["typ"] != 'admin' && $app->auth->has_clients($_SESSION['s']['user']['userid'])) {
-	
-	// Get the limits of the client
-	$client_group_id = $_SESSION["s"]["user"]["default_group"];
-	$client = $app->db->queryOneRecord("SELECT client.client_id, client.contact_name, CONCAT(client.company_name,' :: ',client.contact_name) as contactname, sys_group.name FROM sys_group, client WHERE sys_group.client_id = client.client_id and sys_group.groupid = $client_group_id");
 
-	
+	// Get the limits of the client
+	$client_group_id = intval($_SESSION["s"]["user"]["default_group"]);
+	$client = $app->db->queryOneRecord("SELECT client.client_id, client.contact_name, CONCAT(IF(client.company_name != '', CONCAT(client.company_name, ' :: '), ''), client.contact_name, ' (', client.username, IF(client.customer_no != '', CONCAT(', ', client.customer_no), ''), ')') as contactname, sys_group.name FROM sys_group, client WHERE sys_group.client_id = client.client_id and sys_group.groupid = ?", $client_group_id);
+
+
 	// load the list of clients
-	$sql = "SELECT sys_group.groupid, sys_group.name, CONCAT(client.company_name,' :: ',client.contact_name) as contactname FROM sys_group, client WHERE sys_group.client_id = client.client_id AND client.parent_client_id = ".$client['client_id'];
-	$clients = $app->db->queryAllRecords($sql);
-	$tmp = $app->db->queryOneRecord("SELECT groupid FROM sys_group WHERE client_id = ".$client['client_id']);
-	$client_select = '<option value="'.$tmp['groupid'].'">'.$client['name'].' :: '.$client['contactname'].'</option>';
+	$sql = "SELECT sys_group.groupid, sys_group.name, CONCAT(IF(client.company_name != '', CONCAT(client.company_name, ' :: '), ''), client.contact_name, ' (', client.username, IF(client.customer_no != '', CONCAT(', ', client.customer_no), ''), ')') as contactname FROM sys_group, client WHERE sys_group.client_id = client.client_id AND client.parent_client_id = ? ORDER BY client.company_name, client.contact_name, sys_group.name";
+	$clients = $app->db->queryAllRecords($sql, $client['client_id']);
+	$tmp = $app->db->queryOneRecord("SELECT groupid FROM sys_group WHERE client_id = ?", $client['client_id']);
+	$client_select = '<option value="'.$tmp['groupid'].'">'.$client['contactname'].'</option>';
 	if(is_array($clients)) {
 		foreach( $clients as $client) {
 			$selected = ($client["groupid"] == $sys_groupid)?'SELECTED':'';
-			$client_select .= "<option value='$client[groupid]' $selected>$client[name] :: $client[contactname]</option>\r\n";
+			$client_select .= "<option value='$client[groupid]' $selected>$client[contactname]</option>\r\n";
 		}
 	}
 
-	$app->tpl->setVar("client_group_id",$client_select);
+	$app->tpl->setVar("client_group_id", $client_select);
+}
+
+if($_SESSION["s"]["user"]["typ"] != 'admin')
+{
+	$client_group_id = $_SESSION["s"]["user"]["default_group"];
+	$client_dns = $app->db->queryOneRecord("SELECT dns_servers FROM sys_group, client WHERE sys_group.client_id = client.client_id and sys_group.groupid = ?", $client_group_id);
+
+	$client_dns['dns_servers_ids'] = explode(',', $client_dns['dns_servers']);
+
+	$only_one_server = count($client_dns['dns_servers_ids']) === 1;
+	$app->tpl->setVar('only_one_server', $only_one_server);
+
+	if ($only_one_server) {
+		$app->tpl->setVar('server_id_value', $client_dns['dns_servers_ids'][0]);
+	}
+
+	$sql = "SELECT server_id, server_name FROM server WHERE server_id IN ?";
+	$dns_servers = $app->db->queryAllRecords($sql, $client_dns['dns_servers_ids']);
+
+	$options_dns_servers = "";
+
+	foreach ($dns_servers as $dns_server) {
+		$options_dns_servers .= "<option value='$dns_server[server_id]'>$dns_server[server_name]</option>";
+	}
+
+	$app->tpl->setVar("server_id", $options_dns_servers);
+	unset($options_dns_servers);
+
+}
+
+/*
+ * Now we have to check, if we should use the domain-module to select the domain
+ * or not
+ */
+$app->uses('ini_parser,getconf');
+$settings = $app->getconf->get_global_config('domains');
+if ($settings['use_domain_module'] == 'y') {
+	/*
+	 * The domain-module is in use.
+	*/
+	$domains = $app->tools_sites->getDomainModuleDomains("dns_soa");
+	/*
+	 * We can leave domain empty if domain is filename
+	*/
+	$domain_select = "<option value=''></option>\r\n";
+	if(is_array($domains) && sizeof($domains) > 0) {
+		/* We have domains in the list, so create the drop-down-list */
+		foreach( $domains as $domain) {
+			$domain_select .= "<option value=" . $domain['domain_id'] ;
+			if ($domain['domain'] == $_POST['domain']) {
+				$domain_select .= " selected";
+			}
+			$domain_select .= ">" . $app->functions->idn_decode($domain['domain']) . ".</option>\r\n";
+		}
+	}
+	$app->tpl->setVar("domain_option", $domain_select);
+	/* check if the selected domain can be used! */
+	if ($domain) {
+		$domain_check = $app->tools_sites->checkDomainModuleDomain($domain);
+		if(!$domain_check) {
+			// invalid domain selected
+			$domain = NULL;
+		} else {
+			$domain = $domain_check;
+		}
+	}
 }
 
 $lng_file = 'lib/lang/'.$_SESSION['s']['language'].'_dns_import.lng';
-include($lng_file);
+include $lng_file;
 $app->tpl->setVar($wb);
 
 // Import the zone-file
 //if(1=="1")
 if(isset($_FILES['file']['name']) && is_uploaded_file($_FILES['file']['tmp_name'])){
 	$valid_zone_file = FALSE;
-	
-	$sql = "SELECT server_name FROM `server` WHERE server_id=".intval($server_id)." OR mirror_server_id=".intval($server_id)." ORDER BY server_name ASC";
-	$servers = $app->db->queryAllRecords($sql);
+
+	$sql = "SELECT server_name FROM `server` WHERE server_id=? OR mirror_server_id=? ORDER BY server_name ASC";
+	$servers = $app->db->queryAllRecords($sql, $server_id, $server_id);
 	for ($i=0;$i<count($servers);$i++)
 	{
-		if (substr($servers[$i]['server_name'],strlen($servers[$i]['server_name'])-1) != ".")
+		if (substr($servers[$i]['server_name'], strlen($servers[$i]['server_name'])-1) != ".")
 		{
 			$servers[$i]['server_name'] .= ".";
 		}
 	}
 	$lines = file($_FILES['file']['tmp_name']);
-	
+
 	// Remove empty lines, comments, whitespace, tabs, etc.
 	$new_lines = array();
 	foreach($lines as $line){
 		$line = trim($line);
-		if ($line != '' && substr($line,0,1) != ';'){
-			if(strpos($line,";") !== FALSE) $line = substr($line,0,strpos($line,";"));
-			if(strpos($line,"(") !== FALSE) $line = substr($line,0,strpos($line,"("));
-			if(strpos($line,")") !== FALSE) $line = substr($line,0,strpos($line,")"));
+		if ($line != '' && substr($line, 0, 1) != ';'){
+			if(strpos($line, ";") !== FALSE) {
+				if(!preg_match("/\"[^\"]+;[^\"]*\"/", $line)) {
+					$line = substr($line, 0, strpos($line, ";"));
+				}
+			}
+			if(strpos($line, "(") !== FALSE ) {
+				if (!preg_match("/v=DKIM/",$line)) {
+					$line = substr($line, 0, strpos($line, "("));
+				}
+			}
+			if(strpos($line, ")") !== FALSE ) {
+				if (!preg_match("/v=DKIM/",$line)) {
+					$line = substr($line, 0, strpos($line, ")"));
+				}
+			}
+			
 			$line = trim($line);
 			if ($line != ''){
 				$sPattern = '/\s+/m';
@@ -159,19 +254,19 @@
 	unset($lines);
 	$lines = $new_lines;
 	unset($new_lines);
-	
+
 	//$lines = file("apriqot.se.txt");
-	$name = str_replace("txt","",$_FILES['file']['name']);
-	$name = str_replace("zone","",$name);
+	$name = str_replace("txt", "", $_FILES['file']['name']);
+	$name = str_replace("zone", "", $name);
 
 	if ($domain !== NULL){
 		$name = $domain;
 	}
-	
-	if (substr($name,-1) != "."){
+
+	if (substr($name, -1) != "."){
 		$name .= ".";
 	}
-	
+
 	$i = 0;
 	$origin_exists = FALSE;
 	$soa_array_key = -1;
@@ -180,18 +275,26 @@
 	$r = 0;
 	$dns_rr = array();
 	foreach($lines as $line){
-	
+
 		$parts = explode(' ', $line);
-		
-		// make all elements lowercase
+
+		// make elements lowercase
 		$new_parts = array();
 		foreach($parts as $part){
-			$new_parts[] = strtolower($part);
+		if(
+			(strpos($part, ';') === false) &&
+			(!preg_match("/^\"/", $part)) &&
+			(!preg_match("/\"$/", $part))
+		) {
+				$new_parts[] = strtolower($part);
+			} else {
+				$new_parts[] = $part;
+			}
 		}
 		unset($parts);
 		$parts = $new_parts;
 		unset($new_parts);
-		
+
 		// if ORIGIN exists, overwrite $soa['name']
 		if($parts[0] == '$origin'){
 			$soa['name'] = $parts[1];
@@ -199,25 +302,25 @@
 		}
 		// TTL
 		if($parts[0] == '$ttl'){
-			$time_format = strtolower(substr($parts[1],-1));
+			$time_format = strtolower(substr($parts[1], -1));
 			switch ($time_format) {
-				case 's':
-					$soa['ttl'] = intval(substr($parts[1],0,-1));
-					break;
-				case 'm':
-					$soa['ttl'] = intval(substr($parts[1],0,-1)) * 60;
-					break;
-				case 'h':
-					$soa['ttl'] = intval(substr($parts[1],0,-1)) * 3600;
-					break;
-				case 'd':
-					$soa['ttl'] = intval(substr($parts[1],0,-1)) * 86400;
-					break;
-				case 'w':
-					$soa['ttl'] = intval(substr($parts[1],0,-1)) * 604800;
-					break;
-				default:
-					$soa['ttl'] = intval($parts[1]);
+			case 's':
+				$soa['ttl'] = $app->functions->intval(substr($parts[1], 0, -1));
+				break;
+			case 'm':
+				$soa['ttl'] = $app->functions->intval(substr($parts[1], 0, -1)) * 60;
+				break;
+			case 'h':
+				$soa['ttl'] = $app->functions->intval(substr($parts[1], 0, -1)) * 3600;
+				break;
+			case 'd':
+				$soa['ttl'] = $app->functions->intval(substr($parts[1], 0, -1)) * 86400;
+				break;
+			case 'w':
+				$soa['ttl'] = $app->functions->intval(substr($parts[1], 0, -1)) * 604800;
+				break;
+			default:
+				$soa['ttl'] = $app->functions->intval($parts[1]);
 			}
 			unset($time_format);
 		}
@@ -234,106 +337,106 @@
 			$valid_zone_file = TRUE;
 		}
 		// SERIAL
-		if($i == ($soa_array_key + 1)) $soa['serial'] = intval($parts[0]);
+		if($i == ($soa_array_key + 1)) $soa['serial'] = $app->functions->intval($parts[0]);
 		// REFRESH
 		if($i == ($soa_array_key + 2)){
-			$time_format = strtolower(substr($parts[0],-1));
+			$time_format = strtolower(substr($parts[0], -1));
 			switch ($time_format) {
-				case 's':
-					$soa['refresh'] = intval(substr($parts[0],0,-1));
-					break;
-				case 'm':
-					$soa['refresh'] = intval(substr($parts[0],0,-1)) * 60;
-					break;
-				case 'h':
-					$soa['refresh'] = intval(substr($parts[0],0,-1)) * 3600;
-					break;
-				case 'd':
-					$soa['refresh'] = intval(substr($parts[0],0,-1)) * 86400;
-					break;
-				case 'w':
-					$soa['refresh'] = intval(substr($parts[0],0,-1)) * 604800;
-					break;
-				default:
-					$soa['refresh'] = intval($parts[0]);
+			case 's':
+				$soa['refresh'] = $app->functions->intval(substr($parts[0], 0, -1));
+				break;
+			case 'm':
+				$soa['refresh'] = $app->functions->intval(substr($parts[0], 0, -1)) * 60;
+				break;
+			case 'h':
+				$soa['refresh'] = $app->functions->intval(substr($parts[0], 0, -1)) * 3600;
+				break;
+			case 'd':
+				$soa['refresh'] = $app->functions->intval(substr($parts[0], 0, -1)) * 86400;
+				break;
+			case 'w':
+				$soa['refresh'] = $app->functions->intval(substr($parts[0], 0, -1)) * 604800;
+				break;
+			default:
+				$soa['refresh'] = $app->functions->intval($parts[0]);
 			}
 			unset($time_format);
 		}
 		// RETRY
 		if($i == ($soa_array_key + 3)){
-			$time_format = strtolower(substr($parts[0],-1));
+			$time_format = strtolower(substr($parts[0], -1));
 			switch ($time_format) {
-				case 's':
-					$soa['retry'] = intval(substr($parts[0],0,-1));
-					break;
-				case 'm':
-					$soa['retry'] = intval(substr($parts[0],0,-1)) * 60;
-					break;
-				case 'h':
-					$soa['retry'] = intval(substr($parts[0],0,-1)) * 3600;
-					break;
-				case 'd':
-					$soa['retry'] = intval(substr($parts[0],0,-1)) * 86400;
-					break;
-				case 'w':
-					$soa['retry'] = intval(substr($parts[0],0,-1)) * 604800;
-					break;
-				default:
-					$soa['retry'] = intval($parts[0]);
+			case 's':
+				$soa['retry'] = $app->functions->intval(substr($parts[0], 0, -1));
+				break;
+			case 'm':
+				$soa['retry'] = $app->functions->intval(substr($parts[0], 0, -1)) * 60;
+				break;
+			case 'h':
+				$soa['retry'] = $app->functions->intval(substr($parts[0], 0, -1)) * 3600;
+				break;
+			case 'd':
+				$soa['retry'] = $app->functions->intval(substr($parts[0], 0, -1)) * 86400;
+				break;
+			case 'w':
+				$soa['retry'] = $app->functions->intval(substr($parts[0], 0, -1)) * 604800;
+				break;
+			default:
+				$soa['retry'] = $app->functions->intval($parts[0]);
 			}
 			unset($time_format);
 		}
 		// EXPIRE
 		if($i == ($soa_array_key + 4)){
-			$time_format = strtolower(substr($parts[0],-1));
+			$time_format = strtolower(substr($parts[0], -1));
 			switch ($time_format) {
-				case 's':
-					$soa['expire'] = intval(substr($parts[0],0,-1));
-					break;
-				case 'm':
-					$soa['expire'] = intval(substr($parts[0],0,-1)) * 60;
-					break;
-				case 'h':
-					$soa['expire'] = intval(substr($parts[0],0,-1)) * 3600;
-					break;
-				case 'd':
-					$soa['expire'] = intval(substr($parts[0],0,-1)) * 86400;
-					break;
-				case 'w':
-					$soa['expire'] = intval(substr($parts[0],0,-1)) * 604800;
-					break;
-				default:
-					$soa['expire'] = intval($parts[0]);
+			case 's':
+				$soa['expire'] = $app->functions->intval(substr($parts[0], 0, -1));
+				break;
+			case 'm':
+				$soa['expire'] = $app->functions->intval(substr($parts[0], 0, -1)) * 60;
+				break;
+			case 'h':
+				$soa['expire'] = $app->functions->intval(substr($parts[0], 0, -1)) * 3600;
+				break;
+			case 'd':
+				$soa['expire'] = $app->functions->intval(substr($parts[0], 0, -1)) * 86400;
+				break;
+			case 'w':
+				$soa['expire'] = $app->functions->intval(substr($parts[0], 0, -1)) * 604800;
+				break;
+			default:
+				$soa['expire'] = $app->functions->intval($parts[0]);
 			}
 			unset($time_format);
 		}
 		// MINIMUM
 		if($i == ($soa_array_key + 5)){
-			$time_format = strtolower(substr($parts[0],-1));
+			$time_format = strtolower(substr($parts[0], -1));
 			switch ($time_format) {
-				case 's':
-					$soa['minimum'] = intval(substr($parts[0],0,-1));
-					break;
-				case 'm':
-					$soa['minimum'] = intval(substr($parts[0],0,-1)) * 60;
-					break;
-				case 'h':
-					$soa['minimum'] = intval(substr($parts[0],0,-1)) * 3600;
-					break;
-				case 'd':
-					$soa['minimum'] = intval(substr($parts[0],0,-1)) * 86400;
-					break;
-				case 'w':
-					$soa['minimum'] = intval(substr($parts[0],0,-1)) * 604800;
-					break;
-				default:
-					$soa['minimum'] = intval($parts[0]);
+			case 's':
+				$soa['minimum'] = $app->functions->intval(substr($parts[0], 0, -1));
+				break;
+			case 'm':
+				$soa['minimum'] = $app->functions->intval(substr($parts[0], 0, -1)) * 60;
+				break;
+			case 'h':
+				$soa['minimum'] = $app->functions->intval(substr($parts[0], 0, -1)) * 3600;
+				break;
+			case 'd':
+				$soa['minimum'] = $app->functions->intval(substr($parts[0], 0, -1)) * 86400;
+				break;
+			case 'w':
+				$soa['minimum'] = $app->functions->intval(substr($parts[0], 0, -1)) * 604800;
+				break;
+			default:
+				$soa['minimum'] = $app->functions->intval($parts[0]);
 			}
 			unset($time_format);
 		}
 		// RESOURCE RECORDS
 		if($i > ($soa_array_key + 5)){
-			if(substr($parts[0],-1) == '.' || $parts[0] == '@' || ($parts[0] != 'a' && $parts[0] != 'aaaa' && $parts[0] != 'ns' && $parts[0] != 'cname' && $parts[0] != 'hinfo' && $parts[0] != 'mx' && $parts[0] != 'naptr' && $parts[0] != 'ptr' && $parts[0] != 'rp' && $parts[0] != 'srv' && $parts[0] != 'txt')){
+			if(substr($parts[0], -1) == '.' || $parts[0] == '@' || ($parts[0] != 'a' && $parts[0] != 'aaaa' && $parts[0] != 'ns' && $parts[0] != 'cname' && $parts[0] != 'hinfo' && $parts[0] != 'mx' && $parts[0] != 'naptr' && $parts[0] != 'ptr' && $parts[0] != 'rp' && $parts[0] != 'srv' && $parts[0] != 'txt')){
 				if(is_numeric($parts[1])){
 					if($parts[2] == 'in'){
 						$resource_type = $parts[3];
@@ -358,25 +461,25 @@
 					$dns_rr[$r]['name'] = $parts[0];
 				}
 				if(is_numeric($parts[1])){
-					$dns_rr[$r]['ttl'] = intval($parts[1]);
+					$dns_rr[$r]['ttl'] = $app->functions->intval($parts[1]);
 				} else {
 					$dns_rr[$r]['ttl'] = $soa['ttl'];
 				}
 				switch ($resource_type) {
-					case 'mx':
-					case 'srv':
-						$dns_rr[$r]['aux'] = intval($parts[$pkey+1]);
-						$dns_rr[$r]['data'] = implode(' ',array_slice($parts, $pkey+2));
-						break;
-					case 'txt':
-						$dns_rr[$r]['aux'] = 0;
-						$dns_rr[$r]['data'] = implode(' ',array_slice($parts, $pkey+1));
-						if(substr($dns_rr[$r]['data'],0,1) == '"') $dns_rr[$r]['data'] = substr($dns_rr[$r]['data'],1);
-						if(substr($dns_rr[$r]['data'],-1) == '"') $dns_rr[$r]['data'] = substr($dns_rr[$r]['data'],0,-1);
-						break;
-					default:
-						$dns_rr[$r]['aux'] = 0;
-						$dns_rr[$r]['data'] = implode(' ',array_slice($parts, $pkey+1));
+				case 'mx':
+				case 'srv':
+					$dns_rr[$r]['aux'] = $app->functions->intval($parts[$pkey+1]);
+					$dns_rr[$r]['data'] = implode(' ', array_slice($parts, $pkey+2));
+					break;
+				case 'txt':
+					$dns_rr[$r]['aux'] = 0;
+					$dns_rr[$r]['data'] = implode(' ', array_slice($parts, $pkey+1));
+					if(substr($dns_rr[$r]['data'], 0, 1) == '"') $dns_rr[$r]['data'] = substr($dns_rr[$r]['data'], 1);
+					if(substr($dns_rr[$r]['data'], -1) == '"') $dns_rr[$r]['data'] = substr($dns_rr[$r]['data'], 0, -1);
+					break;
+				default:
+					$dns_rr[$r]['aux'] = 0;
+					$dns_rr[$r]['data'] = implode(' ', array_slice($parts, $pkey+1));
 				}
 			} else {
 				// a 3600 IN A 1.2.3.4
@@ -385,24 +488,24 @@
 					$pkey = 3;
 					$dns_rr[$r]['type'] = $resource_type;
 					$dns_rr[$r]['name'] = $parts[0];
-					$dns_rr[$r]['ttl'] = intval($parts[1]);
+					$dns_rr[$r]['ttl'] = $app->functions->intval($parts[1]);
 					switch ($resource_type) {
-						case 'mx':
-						case 'srv':
-							$dns_rr[$r]['aux'] = intval($parts[$pkey+1]);
-							$dns_rr[$r]['data'] = implode(' ',array_slice($parts, $pkey+2));
-							break;
-						case 'txt':
-							$dns_rr[$r]['aux'] = 0;
-							$dns_rr[$r]['data'] = implode(' ',array_slice($parts, $pkey+1));
-							if(substr($dns_rr[$r]['data'],0,1) == '"') $dns_rr[$r]['data'] = substr($dns_rr[$r]['data'],1);
-							if(substr($dns_rr[$r]['data'],-1) == '"') $dns_rr[$r]['data'] = substr($dns_rr[$r]['data'],0,-1);
-							break;
-						default:
-							$dns_rr[$r]['aux'] = 0;
-							$dns_rr[$r]['data'] = implode(' ',array_slice($parts, $pkey+1));
+					case 'mx':
+					case 'srv':
+						$dns_rr[$r]['aux'] = $app->functions->intval($parts[$pkey+1]);
+						$dns_rr[$r]['data'] = implode(' ', array_slice($parts, $pkey+2));
+						break;
+					case 'txt':
+						$dns_rr[$r]['aux'] = 0;
+						$dns_rr[$r]['data'] = implode(' ', array_slice($parts, $pkey+1));
+						if(substr($dns_rr[$r]['data'], 0, 1) == '"') $dns_rr[$r]['data'] = substr($dns_rr[$r]['data'], 1);
+						if(substr($dns_rr[$r]['data'], -1) == '"') $dns_rr[$r]['data'] = substr($dns_rr[$r]['data'], 0, -1);
+						break;
+					default:
+						$dns_rr[$r]['aux'] = 0;
+						$dns_rr[$r]['data'] = implode(' ', array_slice($parts, $pkey+1));
 					}
-				} 
+				}
 				// a IN A 1.2.3.4
 				elseif($parts[1] == 'in' && ($parts[2] == 'a' || $parts[2] == 'aaaa' || $parts[2] == 'ns'|| $parts[2] == 'cname' || $parts[2] == 'hinfo' || $parts[2] == 'mx' || $parts[2] == 'naptr' || $parts[2] == 'ptr' || $parts[2] == 'rp' || $parts[2] == 'srv' || $parts[2] == 'txt')){
 					$resource_type = $parts[2];
@@ -411,46 +514,46 @@
 					$dns_rr[$r]['name'] = $parts[0];
 					$dns_rr[$r]['ttl'] = $soa['ttl'];
 					switch ($resource_type) {
-						case 'mx':
-						case 'srv':
-							$dns_rr[$r]['aux'] = intval($parts[$pkey+1]);
-							$dns_rr[$r]['data'] = implode(' ',array_slice($parts, $pkey+2));
-							break;
-						case 'txt':
-							$dns_rr[$r]['aux'] = 0;
-							$dns_rr[$r]['data'] = implode(' ',array_slice($parts, $pkey+1));
-							if(substr($dns_rr[$r]['data'],0,1) == '"') $dns_rr[$r]['data'] = substr($dns_rr[$r]['data'],1);
-							if(substr($dns_rr[$r]['data'],-1) == '"') $dns_rr[$r]['data'] = substr($dns_rr[$r]['data'],0,-1);
-							break;
-						default:
-							$dns_rr[$r]['aux'] = 0;
-							$dns_rr[$r]['data'] = implode(' ',array_slice($parts, $pkey+1));
+					case 'mx':
+					case 'srv':
+						$dns_rr[$r]['aux'] = $app->functions->intval($parts[$pkey+1]);
+						$dns_rr[$r]['data'] = implode(' ', array_slice($parts, $pkey+2));
+						break;
+					case 'txt':
+						$dns_rr[$r]['aux'] = 0;
+						$dns_rr[$r]['data'] = implode(' ', array_slice($parts, $pkey+1));
+						if(substr($dns_rr[$r]['data'], 0, 1) == '"') $dns_rr[$r]['data'] = substr($dns_rr[$r]['data'], 1);
+						if(substr($dns_rr[$r]['data'], -1) == '"') $dns_rr[$r]['data'] = substr($dns_rr[$r]['data'], 0, -1);
+						break;
+					default:
+						$dns_rr[$r]['aux'] = 0;
+						$dns_rr[$r]['data'] = implode(' ', array_slice($parts, $pkey+1));
 					}
-				} 
+				}
 				// a 3600 A 1.2.3.4
 				elseif(is_numeric($parts[1]) && ($parts[2] == 'a' || $parts[2] == 'aaaa' || $parts[2] == 'ns'|| $parts[2] == 'cname' || $parts[2] == 'hinfo' || $parts[2] == 'mx' || $parts[2] == 'naptr' || $parts[2] == 'ptr' || $parts[2] == 'rp' || $parts[2] == 'srv' || $parts[2] == 'txt')){
 					$resource_type = $parts[2];
 					$pkey = 2;
 					$dns_rr[$r]['type'] = $resource_type;
 					$dns_rr[$r]['name'] = $parts[0];
-					$dns_rr[$r]['ttl'] = intval($parts[1]);
+					$dns_rr[$r]['ttl'] = $app->functions->intval($parts[1]);
 					switch ($resource_type) {
-						case 'mx':
-						case 'srv':
-							$dns_rr[$r]['aux'] = intval($parts[$pkey+1]);
-							$dns_rr[$r]['data'] = implode(' ',array_slice($parts, $pkey+2));
-							break;
-						case 'txt':
-							$dns_rr[$r]['aux'] = 0;
-							$dns_rr[$r]['data'] = implode(' ',array_slice($parts, $pkey+1));
-							if(substr($dns_rr[$r]['data'],0,1) == '"') $dns_rr[$r]['data'] = substr($dns_rr[$r]['data'],1);
-							if(substr($dns_rr[$r]['data'],-1) == '"') $dns_rr[$r]['data'] = substr($dns_rr[$r]['data'],0,-1);
-							break;
-						default:
-							$dns_rr[$r]['aux'] = 0;
-							$dns_rr[$r]['data'] = implode(' ',array_slice($parts, $pkey+1));
+					case 'mx':
+					case 'srv':
+						$dns_rr[$r]['aux'] = $app->functions->intval($parts[$pkey+1]);
+						$dns_rr[$r]['data'] = implode(' ', array_slice($parts, $pkey+2));
+						break;
+					case 'txt':
+						$dns_rr[$r]['aux'] = 0;
+						$dns_rr[$r]['data'] = implode(' ', array_slice($parts, $pkey+1));
+						if(substr($dns_rr[$r]['data'], 0, 1) == '"') $dns_rr[$r]['data'] = substr($dns_rr[$r]['data'], 1);
+						if(substr($dns_rr[$r]['data'], -1) == '"') $dns_rr[$r]['data'] = substr($dns_rr[$r]['data'], 0, -1);
+						break;
+					default:
+						$dns_rr[$r]['aux'] = 0;
+						$dns_rr[$r]['data'] = implode(' ', array_slice($parts, $pkey+1));
 					}
-				} 
+				}
 				// A 1.2.3.4
 				// MX 10 mail
 				// TXT "v=spf1 a mx ptr -all"
@@ -461,20 +564,20 @@
 					$dns_rr[$r]['name'] = $soa['name'];
 					$dns_rr[$r]['ttl'] = $soa['ttl'];
 					switch ($resource_type) {
-						case 'mx':
-						case 'srv':
-							$dns_rr[$r]['aux'] = intval($parts[$pkey+1]);
-							$dns_rr[$r]['data'] = implode(' ',array_slice($parts, $pkey+2));
-							break;
-						case 'txt':
-							$dns_rr[$r]['aux'] = 0;
-							$dns_rr[$r]['data'] = implode(' ',array_slice($parts, $pkey+1));
-							if(substr($dns_rr[$r]['data'],0,1) == '"') $dns_rr[$r]['data'] = substr($dns_rr[$r]['data'],1);
-							if(substr($dns_rr[$r]['data'],-1) == '"') $dns_rr[$r]['data'] = substr($dns_rr[$r]['data'],0,-1);
-							break;
-						default:
-							$dns_rr[$r]['aux'] = 0;
-							$dns_rr[$r]['data'] = implode(' ',array_slice($parts, $pkey+1));
+					case 'mx':
+					case 'srv':
+						$dns_rr[$r]['aux'] = $app->functions->intval($parts[$pkey+1]);
+						$dns_rr[$r]['data'] = implode(' ', array_slice($parts, $pkey+2));
+						break;
+					case 'txt':
+						$dns_rr[$r]['aux'] = 0;
+						$dns_rr[$r]['data'] = implode(' ', array_slice($parts, $pkey+1));
+						if(substr($dns_rr[$r]['data'], 0, 1) == '"') $dns_rr[$r]['data'] = substr($dns_rr[$r]['data'], 1);
+						if(substr($dns_rr[$r]['data'], -1) == '"') $dns_rr[$r]['data'] = substr($dns_rr[$r]['data'], 0, -1);
+						break;
+					default:
+						$dns_rr[$r]['aux'] = 0;
+						$dns_rr[$r]['data'] = implode(' ', array_slice($parts, $pkey+1));
 					}
 				}
 			}
@@ -486,130 +589,6 @@
 		}
 		$i++;
 	}
-	
-	/*
-	$i = 0;
-	$r = 0;
-	$s = 0;
-	$dns_rr = array();
-	foreach ($lines as $line)
-	{
-		$line = trim($line);
-		if ($line != '' && substr($line,0,1) != ';' && substr($line,0,1) != '$')
-		{
-			$line = str_replace("\n",NULL,$line);
-			$i++;
-
-			// TODO - Find a better way to parse the SOA record. Lazy checking.
-			if ($i <= 7)
-			{
-				if ($i > 1)
-				{
-					$s++;
-					$line = str_replace("\t",NULL,$line);
-					if (!empty($line))
-					{
-						print(strpos(";",$line));
-						$line = substr($line,0,strpos($line,";"));
-						if ($s == 1)
-							$soa['serial'] = $line;
-						else if ($s == 2)
-							$soa['refresh'] = $line;
-						else if ($s == 3)
-							$soa['retry'] = $line;
-						else if ($s == 4)
-							$soa['expire'] = $line;
-						else if ($s == 5)
-							$soa['minimum'] = $line;
-
-					}
-				}
-				else
-				{
-					$line = str_replace("\t",",",$line);
-					$line = str_replace(" ",",",$line);
-					$recs = explode(",",$line);
-
-					foreach ($recs as $key => $rec)
-					{
-						$rec = trim($rec);
-						if($rec == '') continue;
-						//name	type	data	aux	ttl	active
-						if ($key == 0)
-						{
-							if ($rec == '@')
-							{
-								$rec = $name;
-							}
-
-							$soa['name'] = $rec;
-						}
-
-						if ($key != 0 && strtolower($rec) == 'soa')
-						{
-							$typekeys[$s] = $key;
-						}
-						else if ($key > $typekey[$r])
-						{
-							if ($rec != "" && $rec != "(")
-							{
-								$rec = explode(" ",$rec);
-
-								$soa['ns'] = $servers[0]['server_name'];
-								$soa['mbox'] = $rec[1];
-							}
-						}
-					}
-				}
-			}
-			else
-			{
-				$line = str_replace("\n","",trim($line));
-
-				if (!empty($line))
-				{
-
-					preg_match_all('/(.*?)\s*IN\s*(A|CNAME|MX|TXT|NS|AAAA)\s*(.*)/',$line, $recs);
-
-					if ($recs[1][0] == '@' || trim($recs[1][0]) == "")
-					{
-						$recs[1][0] = $name;
-					}
-					$dns_rr[$r]['name'] = $recs[1][0];
-					$dns_rr[$r]['type'] = $recs[2][0];
-					if (strtolower($dns_rr[$r]['type'])=='mx')
-					{
-						$recs[3][0] = str_replace(" ","\t",$recs[3][0]);
-						$mx[$r] = explode("\t",$recs[3][0]);
-						for ($m=1;$m<count($mx[$r]);$m++)
-						{
-							if (!empty($mx[$r][$m]))
-								$dns_rr[$r]['data'] = $mx[$r][$m];
-						}
-						
-						$dns_rr[$r]['aux'] = $mx[$r][0];
-					}
-					else if (strtolower($dns_rr[$r]['type'])=='txt')
-					{
-						$dns_rr[$r]['data'] = substr($recs[3][0],1,(strlen($recs[3][0])-2));
-					}
-					else
-					{
-						$dns_rr[$r]['data'] = $recs[3][0];
-					}
-
-					if (strtolower($dns_rr[$r]['type'])=='ns' && strtolower($dns_rr[$r]['name'])==$name)
-					{
-						unset($dns_rr[$r]);
-					}
-
-					$r++;
-				}
-			}
-
-		}
-	}
-	*/
 
 	foreach ($servers as $server){
 		$dns_rr[$r]['name'] = $soa['name'];
@@ -618,37 +597,67 @@
 		$dns_rr[$r]['aux'] = 0;
 		$r++;
 	}
-					//print('<pre>');
-					//print_r($dns_rr);
-					//print('</pre>');
-					
-					
+	//print('<pre>');
+	//print_r($dns_rr);
+	//print('</pre>');
+
+
 	// Insert the soa record
 	$sys_userid = $_SESSION['s']['user']['userid'];
-	$origin = $app->db->quote($soa['name']);
-	$ns = $app->db->quote($soa['ns']);
-	$mbox = $app->db->quote($soa['mbox']);
-	$refresh = $app->db->quote($soa['refresh']);
-	$retry = $app->db->quote($soa['retry']);
-	$expire = $app->db->quote($soa['expire']);
-	$minimum = $app->db->quote($soa['minimum']);
-	$ttl = $app->db->quote($soa['ttl']);
-	$xfer = $app->db->quote('');
-	$serial = $app->db->quote(intval($soa['serial'])+1);
+	$origin = $soa['name'];
+	$ns = $soa['ns'];
+	$mbox = $soa['mbox'];
+	$refresh = $soa['refresh'];
+	$retry = $soa['retry'];
+	$expire = $soa['expire'];
+	$minimum = $soa['minimum'];
+	$ttl = $soa['ttl'];
+	$xfer = '';
+	$serial = $app->functions->intval($soa['serial']+1);
 	//print_r($soa);
 	//die();
 	if($valid_zone_file){
-		$insert_data = "(`sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`, `server_id`, `origin`, `ns`, `mbox`, `serial`, `refresh`, `retry`, `expire`, `minimum`, `ttl`, `active`, `xfer`) VALUES
-		('$sys_userid', '$sys_groupid', 'riud', 'riud', '', '$server_id', '$origin', '$ns', '$mbox', '$serial', '$refresh', '$retry', '$expire', '$minimum', '$ttl', 'Y', '$xfer')";
+		$insert_data = array(
+			"sys_userid" => $sys_userid,
+			"sys_groupid" => $sys_groupid,
+			"sys_perm_user" => 'riud',
+			"sys_perm_group" => 'riud',
+			"sys_perm_other" => '',
+			"server_id" => $server_id,
+			"origin" => $origin,
+			"ns" => $ns,
+			"mbox" => $mbox,
+			"serial" => $serial,
+			"refresh" => $refresh,
+			"retry" => $retry,
+			"expire" => $expire,
+			"minimum" => $minimum,
+			"ttl" => $ttl,
+			"active" => 'Y',
+			"xfer" => $xfer
+		);
 		$dns_soa_id = $app->db->datalogInsert('dns_soa', $insert_data, 'id');
-	
+
 		// Insert the dns_rr records
 		if(is_array($dns_rr) && $dns_soa_id > 0)
 		{
 			foreach($dns_rr as $rr)
 			{
-				$insert_data = "(`sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`, `server_id`, `zone`, `name`, `type`, `data`, `aux`, `ttl`, `active`) VALUES
-				('$sys_userid', '$sys_groupid', 'riud', 'riud', '', '$server_id', '$dns_soa_id', '$rr[name]', '$rr[type]', '$rr[data]', '$rr[aux]', '$rr[ttl]', 'Y')";
+				$insert_data = array(
+					"sys_userid" => $sys_userid,
+					"sys_groupid" => $sys_groupid,
+					"sys_perm_user" => 'riud',
+					"sys_perm_group" => 'riud',
+					"sys_perm_other" => '',
+					"server_id" => $server_id,
+					"zone" => $dns_soa_id,
+					"name" => $rr['name'],
+					"type" => $rr['type'],
+					"data" => $rr['data'],
+					"aux" => $rr['aux'],
+					"ttl" => $rr['ttl'],
+					"active" => 'Y'
+				);
 				$dns_rr_id = $app->db->datalogInsert('dns_rr', $insert_data, 'id');
 			}
 		}
@@ -664,11 +673,11 @@
 }
 
 
-$app->tpl->setVar('msg',$msg);
-$app->tpl->setVar('error',$error);
+$app->tpl->setVar('msg', $msg);
+$app->tpl->setVar('error', $error);
 
 $app->tpl_defaults();
 $app->tpl->pparse();
 
 
-?>
\ No newline at end of file
+?>

--
Gitblit v1.9.1