PageRenderTime 57ms CodeModel.GetById 18ms RepoModel.GetById 1ms app.codeStats 0ms

/domains.php

https://github.com/Cha0sgr/DNS-Registry
PHP | 1282 lines | 903 code | 219 blank | 160 comment | 225 complexity | 6b51b41e8fbab9409df8c704debee4f1 MD5 | raw file
Possible License(s): GPL-3.0

Large files files are truncated, but you can click here to view the full file

    

  1. <?php
    2. 

  2. /*-----------------------------------------------------------------------------
    3. 

  3. * Domain Registry Control Panel                                               *
    4. 

  4. *                                                                             *
    5. 

  5. * Main Author: Vaggelis Koutroumpas vaggelis@koutroumpas.gr (c)2014 for AWMN  *
    6. 

  6. * Credits: see CREDITS file                                                   *
    7. 

  7. *                                                                             *
    8. 

  8. * This program is free software: you can redistribute it and/or modify        *
    9. 

  9. * it under the terms of the GNU General Public License as published by        * 
    10. 

  10. * the Free Software Foundation, either version 3 of the License, or           *
    11. 

  11. * (at your option) any later version.                                         *
    12. 

  12. *                                                                             *
    13. 

  13. * This program is distributed in the hope that it will be useful,             *
    14. 

  14. * but WITHOUT ANY WARRANTY; without even the implied warranty of              *
    15. 

  15. * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the                *
    16. 

  16. * GNU General Public License for more details.                                *
    17. 

  17. *                                                                             *
    18. 

  18. * You should have received a copy of the GNU General Public License           *
    19. 

  19. * along with this program. If not, see <http://www.gnu.org/licenses/>.        *
    20. 

  20. *                                                                             *
    21. 

  21. *-----------------------------------------------------------------------------*/
    22. 

  22. 

  23. // Protect page from anonymous users
    24. 

  24. admin_auth();
    25. 

  25. 

  26. // include dns validation functions
    27. 

  27. require ("./includes/dns.php");
    28. 

  28. 

  29. 

  30. //Define current page data
    31. 

  31. $mysql_table = 'records';
    32. 

  32. $sorting_array = array("id", "name", "content", "change_date", "created");
    33. 

  33. 

  34. // ----------------------------------------------------------------------
    35. 

  35. 

  36. $action_title = "All My Domain Names"; 
    37. 

  37.     
    38. 

  38. $search_vars = "";
    39. 

  39.     
    40. 

  40. $q = mysql_real_escape_string($_GET['q'], $db);
    41. 

  41. if ($q) { 
    42. 

  42.     $search_vars .= "&q=".$q; 
    43. 

  43.     $action_title = "Search: " . $q;
    44. 

  44. }
    45. 

  45. 

  46. if ($_SESSION['admin_default_ttl_domains']){
    47. 

  47. 	$CONF['RECORDS_TTL'] = $_SESSION['admin_default_ttl_domains'];
    48. 

  48. }
    49. 

  49. 

  50. if ($_SESSION['admin_level'] == 'user'){
    51. 

  51. 	$user_id = " AND user_id = '".$_SESSION['admin_id']."' ";
    52. 

  52. }else{
    53. 

  53. 

  54. 	$qu = mysql_real_escape_string($_GET['search_user_id'], $db);
    55. 

  55.     if ($qu) { 
    56. 

  56.         $search_vars .= "&search_user_id=".$qu;
    57. 

  57.     
    58. 

  58.         $user_id = " AND user_id = '".$qu."' ";
    59. 

  59.      
    60. 

  60.     }else{
    61. 

  61. 

  62. 		if ($_GET['show_system_domains'] == '1'){
    63. 

  63. 			$user_id = " ";
    64. 

  64. 		}elseif ($_GET['show_system_domains'] == '2'){
    65. 

  65. 			$user_id = " AND user_id = '0' AND domain_id ";
    66. 

  66. 		}else{
    67. 

  67. 			$user_id = " AND user_id > '0' ";
    68. 

  68. 		}								
    69. 

  69. 		
    70. 

  70. 		$search_vars .= "&show_system_domains=".mysql_real_escape_string($_GET['show_system_domains'], $db);;		
    71. 

  71. 				
    72. 

  72.     }
    73. 

  73. 

  74. }
    75. 

  75. 

  76. $search_query = "WHERE (".$mysql_table.".name LIKE '%".$q."%' OR ".$mysql_table.".content LIKE '%".$q."%' ) AND type = 'NS' ". $user_id . " GROUP BY `name` ";
    77. 

  77. 

  78.   
    79. 

  79. // Sorting
    80. 

  80. if (isset($_GET['sort'])){
    81. 

  81.     if (in_array($_GET['sort'], $sorting_array)) {
    82. 

  82.         if ($_GET['by'] !== "desc" && $_GET['by'] !== "asc") {
    83. 

  83.             $_GET['by'] = "desc";
    84. 

  84.         }
    85. 

  85.         $order = "ORDER BY `". mysql_escape_string($_GET['sort']) ."` ". mysql_escape_string($_GET['by']) . " ";
    86. 

  86.     }
    87. 

  87. } else {
    88. 

  88.     $order = "ORDER BY `created` DESC ";
    89. 

  89.     $_GET['sort'] = "created";
    90. 

  90.     $_GET['by'] = "desc";
    91. 

  91. }
    92. 

  92. $sort_vars = "&sort=".$_GET['sort']."&by=".$_GET['by'];
    93. 

  93. 

  94. 

  95. // Paging
    96. 

  96. $count = mysql_query("SELECT id FROM ".$mysql_table." ".$search_query,$db);
    97. 

  97. $items_number  = mysql_num_rows($count);
    98. 

  98. if ($_GET['items_per_page'] && is_numeric($_GET['items_per_page'])){
    99. 

  99.     $_SESSION['items_per_page'] = $_GET['items_per_page'];
    100. 

  100. }
    101. 

  101. if ($_POST['items_per_page'] && is_numeric($_POST['items_per_page'])){
    102. 

  102.     $_SESSION['items_per_page'] = $_POST['items_per_page'];
    103. 

  103. }
    104. 

  104. if (isset($_SESSION['items_per_page']) && is_numeric($_SESSION['items_per_page'])){
    105. 

  105.     $num = $_SESSION['items_per_page'];
    106. 

  106. } else { 
    107. 

  107.     $_SESSION['items_per_page'] = $CONF['ADMIN_ITEMS_PER_PAGE'];
    108. 

  108.     $num = $CONF['ADMIN_ITEMS_PER_PAGE'];     
    109. 

  109. }
    110. 

  110. $e = $num;
    111. 

  111. $pages = $items_number/$num;
    112. 

  112. if (!$_GET['pageno']){
    113. 

  113.     $pageno = 0; 
    114. 

  114. }else{
    115. 

  115.     $pageno = $_GET['pageno'];
    116. 

  116. }
    117. 

  117. if (isset($_POST['goto'])) {
    118. 

  118.     if ($_POST['goto'] <= $pages + 1) {
    119. 

  119.         $pageno = $num * ($_POST['goto'] - 1);
    120. 

  120.     } else {
    121. 

  121.         $pageno = 0;
    122. 

  122.     }
    123. 

  123. }
    124. 

  124. $current_page = 0;
    125. 

  125. for($i=0;$i<$pages;$i++){
    126. 

  126.     $y=$i+1;
    127. 

  127.     $page=$i*$num;
    128. 

  128.     if ($page == $pageno){
    129. 

  129.         $current_page = $y;
    130. 

  130.     }
    131. 

  131. } 
    132. 

  132. $total_pages=$i; // sinolo selidon
    133. 

  133. 

  134. //Final Query for records listing
    135. 

  135. $SELECT_RESULTS  = mysql_query("SELECT `".$mysql_table."`.* FROM `".$mysql_table."` ".$search_query." ".$order . " LIMIT ".$pageno.", ".$e ,$db);
    136. 

  136. 

  137. $url_vars = "action=".$_GET['action'] . $sort_vars . $search_vars;
    138. 

  138. 

  139. 

  140. //ADD NEW RECORD
    141. 

  141. if ($_POST['action'] == "add" ) {
    142. 

  142.     
    143. 

  143.     $errors = array();
    144. 

  144.     
    145. 

  145.     //Check if user has reached daily limit of new domain registrations
    146. 

  146.     if ($_SESSION['admin_level'] == "user"){
    147. 

  147. 	    $SELECT_DOMAINS_TODAY = mysql_query("SELECT created FROM records WHERE type = 'NS' ". $user_id . " AND created >= '".(time() - 86400 )."'  GROUP BY `name` ORDER BY created DESC", $db);
    148. 

  148. 	    $TOTAL_DOMAINS_TODAY = mysql_num_rows($SELECT_DOMAINS_TODAY);
    149. 

  149. 	    $DOMAINS_TODAY = mysql_fetch_array($SELECT_DOMAINS_TODAY);
    150. 

  150. 	    
    151. 

  151. 	    if ($TOTAL_DOMAINS_TODAY >= $CONF['NEW_DOMAINS_PER_DAY'] && $DOMAINS_TODAY['created'] > (time() - 86400 )){
    152. 

  152. 			$errors['domains_per_day'] = "You have reached the daily limit (".$CONF['NEW_DOMAINS_PER_DAY'].") of new domain registrations. Please try again tomorrow.";
    153. 

  153. 	    }    
    154. 

  154. 	} 
    155. 

  155.     
    156. 

  156.     if ($_POST['tld'] < 1) {
    157. 

  157.         $errors['tld'] = "Please choose a TLD.";
    158. 

  158.         $tld = "";
    159. 

  159.     } else {
    160. 

  160.         
    161. 

  161.         $SELECT_TLD = mysql_query("SELECT name, id FROM `tlds` WHERE `id` = '".mysql_escape_string($_POST['tld'])."' ",$db);
    162. 

  162.         $TLD = mysql_fetch_array($SELECT_TLD);
    163. 

  163.         
    164. 

  164.         $SELECT_TLD_ID = mysql_query("SELECT domain_id, name FROM `".$mysql_table."` WHERE name = '".$TLD['name']."' AND type = 'SOA' ",$db);
    165. 

  165.         $TLDID = mysql_fetch_array($SELECT_TLD_ID);
    166. 

  166.         
    167. 

  167.         if (!$TLDID['name'] && !$TLDID['domain_id']){
    168. 

  168.         	$errors['tld'] = "Please choose a TLD.";	
    169. 

  169. 		}else{
    170. 

  170. 			$tld = ".".$TLD['name'];
    171. 

  171.         }
    172. 

  172.         
    173. 

  173.     }
    174. 

  174.     
    175. 

  175.     $_POST['name'] = trim($_POST['name']);
    176. 

  176.     
    177. 

  177.     $hostname_labels = explode('.', $_POST['name'] . "." . $TLD['name']);
    178. 

  178.     $label_count = count($hostname_labels);    
    179. 

  179.     
    180. 

  180.     //If reverse domain validate differently
    181. 

  181.     if ($hostname_labels[$label_count - 1] == "arpa" ) {
    182. 

  182.     	$lookup_domain = $_POST['name'] . "." . $TLD['name'];
    183. 

  183.     	if ($validate = is_valid_hostname_fqdn($lookup_domain, 0) ){
    184. 

  184. 			$errors['name'] = $validate;
    185. 

  185. 		}
    186. 

  186. 	//If forward domain do our validation
    187. 

  187. 	}elseif (!preg_match("/^(?!-)[a-z0-9-]{1,63}(?<!-)$/", $_POST['name'])) {
    188. 

  188.         $errors['name'] = "Please choose a valid domain name. Only lowercase alphanumeric characters are allowed and a dash (-). Domain cannot start or end with a dash.";
    189. 

  189. 	}else{
    190. 

  190.     	if (strlen($_POST['name']) > 62){
    191. 

  191. 			$errors['name'] = "Please choose a shorter domain name.";	
    192. 

  192.     	}elseif (strlen($_POST['name']) < 2){
    193. 

  193. 			$errors['name'] = "Please choose a bigger domain name.";	
    194. 

  194.     	}else{
    195. 

  195. 	        if (mysql_num_rows(mysql_query("SELECT 1 FROM `".$mysql_table."` WHERE `name` = '".mysql_escape_string($_POST['name'].$tld)."' ",$db))){
    196. 

  196. 	            $errors['name'] = "This domain name is already registered." ;
    197. 

  197. 	        } 
    198. 

  198.     	}
    199. 

  199.     }
    200. 

  200.     
    201. 

  201.     if ($_POST['hosted'] == "nohosted"){ 
    202. 

  202.     
    203. 

  203. 	    //CHECK NAMESERVERS
    204. 

  204. 	    for ($i = 0; $i <= count($_POST['nameserver'])-1; $i++) {
    205. 

  205.     		$ns = trim($_POST['nameserver'][$i]);	
    206. 

  206.     		$glue = trim($_POST['glue'][$i]);	
    207. 

  207.     		$n = $i+1;
    208. 

  208. 			if (!$ns){
    209. 

  209.     			$errors['namesever'.$i] = "Please enter a valid Nameserver ".$n.".";						
    210. 

  210.     		}else{
    211. 

  211.     			//check nameserver name
    212. 

  212. 			    if (mysql_num_rows(mysql_query("SELECT 1 FROM `".$mysql_table."` WHERE `name` = '".mysql_escape_string($ns)."' AND type = 'A' AND user_id > 0 ",$db)) || !getTLD(mysql_escape_string($ns)) ){
    213. 

  213. 				    //NS exists! We use this one!			    
    214. 

  214. 				    $nameserver[$i]['name'] = trim($ns);	
    215. 

  215. 				}else{
    216. 

  216. 

  217. 					//Check if the nameserver to be created is under a domain the user owns or under the newly created domain
    218. 

  218. 					$new_domain = ".".$_POST['name'] . $tld;
    219. 

  219. 					//echo $new_domain;
    220. 

  220. 					$ns_domain_parts = explode(".", $ns);
    221. 

  221. 					//print_r($ns_domain_parts);
    222. 

  222. 					$ns_domain_parts[0] = false;
    223. 

  223. 					$ns_domain = implode(".", $ns_domain_parts);
    224. 

  224. 					$ns_domain = substr($ns_domain, 1);												
    225. 

  225. 					//$ns_domain_parts = array_reverse($ns_domain_parts);
    226. 

  226. 					//$ns_domain = $ns_domain_parts[1] . "." . $ns_domain_parts[0] . $tld;
    227. 

  227. 					//echo $ns_domain;				
    228. 

  228. 					if ( stristr($ns. $tld, $new_domain ) || 
    229. 

  229. 						mysql_num_rows(mysql_query("SELECT 1 FROM `".$mysql_table."` WHERE `name` = '".mysql_escape_string($ns_domain)."' AND type = 'NS' " . $user_id ,$db))
    230. 

  230. 					) {
    231. 

  231. 						//NS does not exist - so we check the A record to add them later on
    232. 

  232. 						if ($glue){
    233. 

  233.     						//check nameserver ip/glue
    234. 

  234. 						    if(filter_var($glue, FILTER_VALIDATE_IP)){
    235. 

  235. 								if ($CONF['NAMESERVERS_IP_RANGE'] == 'any' || netMatch($CONF['NAMESERVERS_IP_RANGE'], $glue)){
    236. 

  236. 									//IP VALIDATED! We prepare arrays for the new nameserver/glue record insert
    237. 

  237. 									$nameserver[$i]['name'] = trim($ns);	
    238. 

  238. 									$nameserver[$i]['glue'] = trim($glue);
    239. 

  239. 																						
    240. 

  240. 								}else{
    241. 

  241. 									$errors['glue'.$i] = "The Nameserver ".$n." IP you entered is not within permitted range: ".$CONF['NAMESERVERS_IP_RANGE'].".";	
    242. 

  242. 								}	
    243. 

  243. 							}else{
    244. 

  244. 								$errors['glue'.$i] = "The Nameserver ".$n." IP you entered is not valid.";	
    245. 

  245. 							}        
    246. 

  246.     					}else{
    247. 

  247. 							$n = $i+1;
    248. 

  248. 							$errors['glue'.$i] = "Please enter a valid Nameserver ".$n." IP.";						
    249. 

  249. 						}				
    250. 

  250. 					}else{
    251. 

  251. 						$n = $i+1;
    252. 

  252. 						$errors['namesever'.$i] = "Nameserver ".$n." parent domain is not owned by you. Cannot create Glue Record";						
    253. 

  253.     				}
    254. 

  254. 				}    	    		
    255. 

  255.     		}
    256. 

  256. 

  257. 		}
    258. 

  258. 		
    259. 

  259. 		//echo "<pre>";	
    260. 

  260. 		//print_r($nameserver);	    
    261. 

  261. 		//echo "</pre>";	    
    262. 

  262. 	    
    263. 

  263. 	}elseif ($_POST['hosted'] != 'hosted'){
    264. 

  264. 		
    265. 

  265. 		$errors['hosted'] = "Please select a Domain Hosting Method";		
    266. 

  266. 		
    267. 

  267. 	}
    268. 

  268.     
    269. 

  269.     
    270. 

  270.     if (!$_POST['user_id']) {
    271. 

  271.         if ($_SESSION['admin_level'] != 'admin'){
    272. 

  272.         	$_POST['user_id'] = $_SESSION['admin_id'];
    273. 

  273. 		}else{
    274. 

  274. 			$errors['user_id'] = "Please choose an owner for the domain.";			
    275. 

  275. 		}
    276. 

  276.     }elseif ($_POST['user_id'] == 'system'){
    277. 

  277. 		$_POST['user_id'] = '0';
    278. 

  278.     }
    279. 

  279.     
    280. 

  280.     if (count($errors) == 0) {
    281. 

  281.         
    282. 

  282.         $insert_errors = array();
    283. 

  283.         $new_domain_time = time();
    284. 

  284. 		
    285. 

  285.         //INSERT DOMAIN FOR SELF HOSTING
    286. 

  286. 		if ($_POST['hosted'] == 'nohosted'){
    287. 

  287.         	
    288. 

  288. 	        for ($i = 0; $i <= count($nameserver)-1; $i++) {
    289. 

  289. 	        
    290. 

  290. 		        $INSERT = mysql_query("INSERT INTO `".$mysql_table."` (name, user_id, domain_id, type, content, ttl, prio, change_date, disabled, auth, created) VALUES (      
    291. 

  291. 		            '" . mysql_escape_string($_POST['name'].$tld) . "',
    292. 

  292. 		            '" . mysql_escape_string($_POST['user_id']) . "',
    293. 

  293. 		            '".$TLDID['domain_id']."',
    294. 

  294. 		            'NS',
    295. 

  295. 		            '".mysql_escape_string($nameserver[$i]['name'])."',
    296. 

  296. 		            '".$CONF['RECORDS_TTL']."',
    297. 

  297. 		            '0',
    298. 

  298. 		            '".$new_domain_time."',
    299. 

  299. 		            '1',
    300. 

  300. 		            NULL,
    301. 

  301. 		            '".$new_domain_time."'
    302. 

  302. 		        )", $db);
    303. 

  303. 		        
    304. 

  304. 		        if (!$INSERT){
    305. 

  305. 					$insert_errors[] = true;
    306. 

  306. 		        }
    307. 

  307. 		        
    308. 

  308. 		        if ($nameserver[$i]['glue']){
    309. 

  309. 

  310. 			        $INSERT = mysql_query("INSERT INTO `".$mysql_table."` (name, content, type, domain_id, ttl, prio, change_date, created, user_id, auth, disabled ) VALUES (      
    311. 

  311. 			            '" . mysql_escape_string($nameserver[$i]['name']) . "',
    312. 

  312. 			            '" . mysql_escape_string($nameserver[$i]['glue']) . "',
    313. 

  313. 			            'A',
    314. 

  314. 			            '".$TLDID['domain_id']."',
    315. 

  315. 			            '".$CONF['RECORDS_TTL']."',
    316. 

  316. 			            '0',
    317. 

  317. 			            '".$new_domain_time."',
    318. 

  318. 			            '".$new_domain_time."',
    319. 

  319. 			            '".mysql_escape_string($_POST['user_id'])."',
    320. 

  320. 			            NULL,
    321. 

  321. 			            '0'
    322. 

  322. 			        )", $db);
    323. 

  323. 					
    324. 

  324. 					if (!$INSERT){
    325. 

  325. 						$insert_errors[] = true;
    326. 

  326. 	        		}		
    327. 

  327. 		        }
    328. 

  328.     			
    329. 

  329.     			//$soa_update = update_soa_serial($tld);
    330. 

  330.     		
    331. 

  331. 			}
    332. 

  332.     		
    333. 

  333. 		}elseif ($_POST['hosted'] == 'hosted'){
    334. 

  334. 		//INSERT DOMAIN FOR MANAGED HOSTING
    335. 

  335. 			
    336. 

  336. 			//Insert Domain record
    337. 

  337. 			$INSERT_DOMAIN = mysql_query("INSERT INTO domains (name, type, notified_serial) VALUES ('". mysql_escape_string($_POST['name'].$tld)."', 'MASTER', '".get_soa_serial($CONF['DEFAULT_SOA'])."' ) ", $db);
    338. 

  338. 			
    339. 

  339. 			$new_domain_id = mysql_insert_id($db);			
    340. 

  340. 			
    341. 

  341. 			if (!$INSERT_DOMAIN || !$new_domain_id){
    342. 

  342. 				$insert_errors[] = true;
    343. 

  343. 		    }			
    344. 

  344. 			
    345. 

  345. 			
    346. 

  346. 			//Insert SOA record
    347. 

  347. 			$INSERT_SOA = mysql_query("INSERT INTO `records` (`domain_id`, `name`, `type`, `content`, `ttl`, `prio`, `change_date`, `ordername`, `auth`, `disabled`, `created`, `user_id`) VALUES (
    348. 

  348. 						'".$new_domain_id."', 
    349. 

  349. 						'".mysql_escape_string($_POST['name'].$tld)."', 
    350. 

  350. 						'SOA',
    351. 

  351. 						'".$CONF['DEFAULT_SOA']."',
    352. 

  352. 						'".$CONF['RECORDS_TTL']."',
    353. 

  353. 						'0',
    354. 

  354. 						'".$new_domain_time."',
    355. 

  355. 						NULL,
    356. 

  356. 						NULL,
    357. 

  357. 						'1',
    358. 

  358. 						'".$new_domain_time."',
    359. 

  359. 						'".mysql_escape_string($_POST['user_id'])."'
    360. 

  360. 			)", $db);
    361. 

  361. 			
    362. 

  362. 			if (!$INSERT_SOA){
    363. 

  363. 				$insert_errors[] = true;
    364. 

  364. 		    }			
    365. 

  365. 			
    366. 

  366. 			//Insert Nameservers for new Domain
    367. 

  367. 			$SELECT_ROOT_NS = mysql_query("SELECT `name`, `ip`, `id` FROM `root_ns` WHERE `active` = '1' ORDER BY `name` ASC ", $db);
    368. 

  368. 			while($ROOT_NS = mysql_fetch_array($SELECT_ROOT_NS)){
    369. 

  369. 				
    370. 

  370. 				$INSERT_NS = mysql_query("INSERT INTO `records` (`domain_id`, `name`, `type`, `content`, `ttl`, `prio`, `change_date`, `ordername`, `auth`, `disabled`, `created`, `user_id`) VALUES (
    371. 

  371. 							'".$new_domain_id."', 
    372. 

  372. 							'".mysql_escape_string($_POST['name'].$tld)."', 
    373. 

  373. 							'NS',
    374. 

  374. 							'".$ROOT_NS['name']."',
    375. 

  375. 							'".$CONF['RECORDS_TTL']."',
    376. 

  376. 							'0',
    377. 

  377. 							'".$new_domain_time."',
    378. 

  378. 							NULL,
    379. 

  379. 							NULL,
    380. 

  380. 							'1',
    381. 

  381. 							'".$new_domain_time."',
    382. 

  382. 							'".mysql_escape_string($_POST['user_id'])."'
    383. 

  383. 				)", $db);
    384. 

    385. 

  385. 				if (!$INSERT_NS){
    386. 

  386. 					$insert_errors[] = true;
    387. 

  387. 		        }
    388. 

  388. 		        
    389. 

  389. 		    	//Insert the NS TSIG records for AXFR to slaves				
    390. 

  390. 				$INSERT_TSIG = mysql_query("INSERT INTO `domainmetadata` (`domain_id`, `kind`, `content` ) VALUES (
    391. 

  391. 							'".$new_domain_id."', 
    392. 

  392. 							'TSIG-ALLOW-AXFR',
    393. 

  393. 							'".$ROOT_NS['name']."'
    394. 

  394. 							
    395. 

  395. 				)", $db);
    396. 

  396. 				
    397. 

  397.    				//Insert the ALSO-NOTIFY records with Unicast IPs to notify meta-slaves for automatic provision of the new zone on the slaves. 				
    398. 

  398. 				$SELECT_UNICAST_NS = mysql_query("SELECT `ip` FROM root_ns_unicast WHERE parent_id = '".$ROOT_NS['id']."' ", $db);
    399. 

  399. 				while ($UNICAST_NS = mysql_fetch_array($SELECT_UNICAST_NS)){
    400. 

  400. 					mysql_query("INSERT INTO `domainmetadata` (`domain_id`, `kind`, `content` ) VALUES (
    401. 

  401. 								'".$new_domain_id."', 
    402. 

  402. 								'ALSO-NOTIFY',
    403. 

  403. 								'".addslashes($UNICAST_NS['ip'])."'
    404. 

  404. 								
    405. 

  405. 					)", $db);
    406. 

  406. 					mysql_query("INSERT INTO `domainmetadata` (`domain_id`, `kind`, `content` ) VALUES (
    407. 

  407. 								'".$new_domain_id."', 
    408. 

  408. 								'ALSO-NOTIFY',
    409. 

  409. 								'".addslashes($UNICAST_NS['ip']).":".$CONF['META_SLAVE_PORT']."'
    410. 

  410. 								
    411. 

  411. 					)", $db);
    412. 

  412. 				}				
    413. 

  413. 				
    414. 

  414. 				
    415. 

  415. 				if (!$INSERT_TSIG){
    416. 

  416. 					$insert_errors[] = true;
    417. 

  417. 		        }
    418. 

  418. 		        
    419. 

  419. 		    			
    420. 

  420. 			
    421. 

  421. 			}
    422. 

  422. 			
    423. 

  423. 			$soa_update = update_soa_serial($tld);
    424. 

  424. 			$soa_update = update_soa_serial(mysql_escape_string($_POST['name'].$tld));
    425. 

  425. 			
    426. 

  426. 			
    427. 

  427. 		}
    428. 

  428. 		
    429. 

  429. 		
    430. 

  430.         if (count($insert_errors) == 0){
    431. 

  431.             header("Location: index.php?section=".$SECTION."&saved_success=1");
    432. 

  432.             exit();
    433. 

  433.         }else{
    434. 

  434.             $error_occured = TRUE;
    435. 

  435.         }
    436. 

  436.         
    437. 

  437.     }
    438. 

  438.         
    439. 

  439. }
    440. 

  440. 

  441. 

  442. // DELETE RECORD
    443. 

  443. if ($_GET['action'] == "delete" && $_POST['id']){
    444. 

  444.     $id = mysql_real_escape_string(str_replace ("tr-", "", $_POST['id']), $db);
    445. 

  445. 

  446. 	if ($_SESSION['admin_level'] == 'user'){
    447. 

  447. 		$user_id = " AND user_id = '".$_SESSION['admin_id'] . "' ";  	
    448. 

  448. 	}else{
    449. 

  449. 		$user_id = '';
    450. 

  450. 	}
    451. 

  451.     
    452. 

  452.     $SELECT_DOMAIN = mysql_query("SELECT name FROM `".$mysql_table."` WHERE id = '".$id."' ". $user_id, $db);
    453. 

  453.     $DOMAIN = mysql_fetch_array($SELECT_DOMAIN);
    454. 

  454.     
    455. 

  455. 	$SELECT_ISHOSTED = mysql_query("SELECT id FROM domains WHERE name = '".$DOMAIN['name']."' ", $db);
    456. 

  456. 	$HOSTEDID = mysql_fetch_array($SELECT_ISHOSTED);
    457. 

  457. 	$ISHOSTED = mysql_num_rows($SELECT_ISHOSTED);
    458. 

  458. 					      
    459. 

  459. 

  460.     if (mysql_num_rows($SELECT_DOMAIN)){
    461. 

  461. 		$DELETE = mysql_query("DELETE FROM `".$mysql_table."` WHERE `name`= '".$DOMAIN['name']."' AND type = 'NS' ". $user_id ,$db);
    462. 

  462. 		$DELETE = mysql_query("DELETE FROM `".$mysql_table."` WHERE `name` LIKE '%.".$DOMAIN['name']."' AND type = 'A' ". $user_id ,$db);
    463. 

  463. 		$DELETE = mysql_query("DELETE FROM `users_notifications` WHERE `name`= '".$DOMAIN['name']."' ". $user_id ,$db);
    464. 

  464. 		
    465. 

  465. 		if ($ISHOSTED){
    466. 

  466. 			$DELETE = mysql_query("DELETE FROM `domains` WHERE `id`= '".$HOSTEDID['id']."' ",$db);
    467. 

  467. 			$DELETE = mysql_query("DELETE FROM `domainmetadata` WHERE `domain_id`= '".$HOSTEDID['id']."' ",$db);
    468. 

  468. 			$DELETE = mysql_query("DELETE FROM `".$mysql_table."` WHERE `domain_id`= '".$HOSTEDID['id']."' ". $user_id ,$db);
    469. 

  469. 			$soa_update = true;
    470. 

  470. 		}
    471. 

  471. 	    
    472. 

  472. 	    $soa_update = update_soa_serial($DOMAIN['name'], true);
    473. 

  473. 	    
    474. 

  474. 	    if ($DELETE && $soa_update){
    475. 

  475. 	        ob_end_clean();
    476. 

  476. 	        echo "ok";
    477. 

  477. 	    } else {
    478. 

  478. 	        ob_end_clean();
    479. 

  479. 	        echo "An error has occured.";
    480. 

  480. 	    }
    481. 

  481. 	}
    482. 

  482. 	
    483. 

  483.     exit();
    484. 

  484. } 
    485. 

  485. 

  486. // NOTIFY ROOT NAMESERVERS
    487. 

  487. if ($_GET['action'] == "notify" && $_POST['id'] && $_SESSION['admin_level'] == 'admin'){
    488. 

  488.     $id = mysql_real_escape_string(str_replace ("tr-", "", $_POST['id']), $db);
    489. 

  489. 

  490. 	$SELECT_DOMAINS = mysql_query("SELECT domain_id, name FROM `".$mysql_table."` WHERE id = '".$id."' ", $db);
    491. 

  491. 	$DOMAIN = mysql_fetch_array($SELECT_DOMAINS);
    492. 

  492. 	
    493. 

  493. 	if ($DOMAIN['domain_id'] != '1' && $DOMAIN['name']){
    494. 

  494. 		$soa_update = update_soa_serial_byid($DOMAIN['domain_id']);
    495. 

  495. 		
    496. 

  496. 		// Run pdns_control notify to push the new SOA update to our slaves immediately. Fire and forget.
    497. 

  497. 		exec ($CONF['PDNS_CONTROL_PATH'] . " --remote-address=".$CONF['PDNS_CONTROL_IP']." --remote-port=".$CONF['PDNS_CONTROL_PORT']." --secret=".$CONF['PDNS_CONTROL_KEY']." notify " . $DOMAIN['name'] . " > /dev/null 2>/dev/null &" );
    498. 

  498.         
    499. 

  499. 	}
    500. 

  500. 	    
    501. 

  501. 	if ($DOMAIN['name'] && $soa_update){
    502. 

  502. 	    ob_end_clean();
    503. 

  503. 	    echo "ok";
    504. 

  504. 	} else {
    505. 

  505. 	    ob_end_clean();
    506. 

  506. 	    echo "An error has occured.";
    507. 

  507. 	}
    508. 

  508. 	
    509. 

  509.     exit();
    510. 

  510. } 
    511. 

  511. 

  512. 

  513. /*
    514. 

  514. // ENABLE/DISABLE RECORD
    515. 

  515. if ($_GET['action'] == "toggle_active" && $_POST['id'] && isset($_POST['option'])){
    516. 

  516.     $id = mysql_real_escape_string($_POST['id'], $db);
    517. 

  517.     $option = mysql_real_escape_string($_POST['option'], $db);
    518. 

  518.     
    519. 

  519.     if ($_SESSION['admin_level'] == 'user'){
    520. 

  520. 		$user_id = " AND user_id = '".$_SESSION['admin_id'] . "' ";  	
    521. 

  521. 	}else{
    522. 

  522. 		$user_id = '';
    523. 

  523. 	}
    524. 

  524.     
    525. 

  525.     $SELECT_DOMAIN = mysql_query("SELECT name, domain_id FROM `".$mysql_table."` WHERE id = '".$id."' ". $user_id, $db);
    526. 

    527. 

  527.     if (mysql_num_rows($SELECT_DOMAIN)){
    528. 

    529. 

  529.         $DOMAIN = mysql_fetch_array($SELECT_DOMAIN);
    530. 

    531. 

  531. 	    $UPDATE = mysql_query("UPDATE `".$mysql_table."` SET `disabled` = '".$option."' WHERE `name` = '".$DOMAIN['name']."' ".$user_id,$db);
    532. 

  532. 	    $UPDATE = mysql_query("UPDATE `".$mysql_table."` SET `disabled` = '".$option."' WHERE `name` LIKE '%.".$DOMAIN['name']."' ".$user_id,$db);
    533. 

  533. 		
    534. 

  534. 		$soa_update = update_soa_serial_byid($DOMAIN['domain_id']);
    535. 

  535. 		
    536. 

  536. 		if ($UPDATE && $soa_update) {
    537. 

  537. 	        //print_r($_GET);
    538. 

  538. 	        ob_clean();
    539. 

  539. 	        echo "ok";
    540. 

  540. 	    } else {
    541. 

  541. 	        ob_clean();
    542. 

  542. 	        echo "An error has occured.";
    543. 

  543. 	    }
    544. 

  544.     
    545. 

  545. 	}
    546. 

  546.     exit();
    547. 

  547. }
    548. 

  548. */
    549. 

  549. 

  550. // FIND NAMESERVER GLUE
    551. 

  551. if ($_GET['action'] == "fetch_glue" && $_POST['nameserver']){
    552. 

  552.     $nameserver = addslashes($_POST['nameserver']);
    553. 

  553. 

  554.     //Check if nameserver TLD belongs to us or a 3rd Party DNS Service
    555. 

  555.     if (!getTLD($nameserver)){
    556. 

  556. 		ob_clean();
    557. 

  557. 	    echo "3rd Party TLD";
    558. 

  558. 	    exit();
    559. 

  559. 	}
    560. 

  560. 	    
    561. 

  561.     $SELECT_GLUE = mysql_query("SELECT content FROM `".$mysql_table."` WHERE name = '".$nameserver."' AND type = 'A' AND user_id > 0", $db);
    562. 

  562.     $GLUE = mysql_fetch_array($SELECT_GLUE);
    563. 

  563. 

  564.     if ($GLUE['content']){
    565. 

  565.     	ob_clean();
    566. 

  566. 	    echo $GLUE['content'];
    567. 

  567. 	} else {
    568. 

  568. 		ob_clean();
    569. 

  569. 	    echo "Enter IP";
    570. 

  570. 	}
    571. 

  571.     exit();
    572. 

  572. }
    573. 

  573. 

  574. ?>
    575. 

  575. 

  576.                 <script>
    577. 

  577.                 
    578. 

  578.                 $(document).bind('cbox_closed', function(){
    579. 

  579.     				location.reload();
    580. 

  580. 				});
    581. 

  581.                 
    582. 

  582.                 $(function() {
    583. 

  583.                 	
    584. 

  584.                 	
    585. 

  585.                 	$(".validate_domain").colorbox({iframe:true, width:"85%", height:"90%", fastIframe:false, current: "Domain {current} of {total}" });
    586. 

  586.                 
    587. 

  587.                 	
    588. 

  588.                 	// most effect types need no options passed by default
    589. 

  589.                     var options = {};    
    590. 

  590.                     
    591. 

  591.                     // Hide/Show the ADD Form
    592. 

  592.                     $( "#button" ).click(function() {
    593. 

  593.                         $( "#toggler" ).toggle( "blind", options, 500, function (){
    594. 

  594.                         	$('#name').focus();
    595. 

  595.     				    } );
    596. 

  596.                         return false;
    597. 

  597.                     });
    598. 

  598. 

  599.                     // Hide/Show the RESULTS Table
    600. 

  600.                     $( "#button2" ).click(function() {
    601. 

  601.                         $( "#toggler2" ).toggle( "blind", options, 500, function (){
    602. 

  602.                             
    603. 

  603.                             //if ( $('#toggle_state').val('1') )
    604. 

  604.                             $('#toggle_state').val('1');
    605. 

  605. 

  606.                             
    607. 

  607.                             
    608. 

  608.                         } );
    609. 

  609.                         return false;
    610. 

  610.                     });
    611. 

  611.                     
    612. 

  612.                     //Init
    613. 

  613.                     <?if ($_POST['action'] || $_GET['action'] == 'add'){?>
    614. 

  614.                         $( "#toggler" ).show();
    615. 

  615.                     <?}else{?>
    616. 

  616.                         $( "#toggler" ).hide();
    617. 

  617.                     <?}?>
    618. 

  618.                     $( "#toggler2" ).show();
    619. 

  619.                     
    620. 

  620.                     
    621. 

  621.                     <?if (staff_help()){?>
    622. 

  622.                     //TIPSY for the ADD Form
    623. 

  623.                     $('#name').tipsy({trigger: 'focus', gravity: 'n', fade: true});
    624. 

  624.                     $('#tld').tipsy({trigger: 'focus', gravity: 'w', fade: true});
    625. 

  625.                     $('#hosted').tipsy({trigger: 'focus', gravity: 'w', fade: true});
    626. 

  626.                     $('#user_id').tipsy({trigger: 'focus', gravity: 'w', fade: true});
    627. 

  627.                     $('#nameserver').tipsy({ gravity: 'e', fade: true, live: true, html: true });
    628. 

  628.                     $('#glue').tipsy({ gravity: 'w', fade: true, live: true, html: true });
    629. 

  629.                     <?}?>
    630. 

  630.                     
    631. 

  631. 

  632.                     //DELETE RECORD
    633. 

  633.                     $('a.delete').click(function () {
    634. 

  634.                         var record_id = $(this).attr('rel');
    635. 

  635.                         if(confirm('Are you sure you want to delete this domain?\n\rThis action cannot be undone!')){
    636. 

  636.                             $.post("index.php?section=<?=$SECTION;?>&action=delete", {
    637. 

  637.                                     id: record_id
    638. 

  638.                                 }, function(response){
    639. 

  639.                                     if (response == "ok"){
    640. 

  640.                                         $('#'+record_id).hide();
    641. 

  641.                                         $("#notification_success_response").html('Record deleted successfully.');
    642. 

  642.                                         $('.notification_success').show();
    643. 

  643.                                         var total_records = $('span#total_records').html();
    644. 

  644.                                          total_records--;
    645. 

  645.                                          $('span#total_records').html(total_records);
    646. 

  646.                                     } else {
    647. 

  647.                                         $("#notification_fail_response").html('An error occured.' );
    648. 

  648.                                         $('.notification_fail').show();
    649. 

  649.                                         //alert(response);
    650. 

  650.                                     }
    651. 

  651.                                 });
    652. 

  652.                             return false;
    653. 

  653.                         }
    654. 

  654.                     });
    655. 

  655. 

  656.                     //NOTIFY ROOT NS
    657. 

  657.                     $('a.notify').click(function () {
    658. 

  658.                         var record_id = $(this).attr('rel');
    659. 

  659.                         if(confirm('Are you sure you want to notify all root nameservers for this domain?')){
    660. 

  660.                             $.post("index.php?section=<?=$SECTION;?>&action=notify", {
    661. 

  661.                                     id: record_id
    662. 

  662.                                 }, function(response){
    663. 

  663.                                     if (response == "ok"){
    664. 

  664.                                         $("#notification_success_response").html('Root nameservers notified!');
    665. 

  665.                                         $('.notification_success').show();
    666. 

  666.                                     } else {
    667. 

  667.                                         $("#notification_fail_response").html('An error occured.' );
    668. 

  668.                                         $('.notification_fail').show();
    669. 

  669.                                         //alert(response);
    670. 

  670.                                     }
    671. 

  671.                                 });
    672. 

  672.                             return false;
    673. 

  673.                         }
    674. 

  674.                     });
    675. 

  675. 

  676.                     <?/*
    677. 

  677.                     //ENABLE/DISABLE
    678. 

  678.                     $('a.toggle_active').click(function () {
    679. 

  679.                     	var dochange = '0';
    680. 

  680. 	                    if ($(this).hasClass('activated')){
    681. 

  681. 	                        if(confirm('Are you sure you want disable this domain?')){    
    682. 

  682. 	                            var option = '1';
    683. 

  683. 	                            var dochange = '1';
    684. 

  684. 							}
    685. 

  685. 	                    } else if ($(this).hasClass('deactivated')){
    686. 

  686. 	                        var option = '0';
    687. 

  687. 	                        var dochange = '1';
    688. 

  688. 	                    }
    689. 

  689. 	                    if (dochange == '1'){
    690. 

  690. 		                    var myItem = $(this);
    691. 

  691. 		                    var record_id = $(this).attr('rel');
    692. 

  692. 		                    $.post("index.php?section=<?=$SECTION;?>&action=toggle_active", {
    693. 

  693.                           		id: record_id,
    694. 

  694. 		                        option: option
    695. 

  695. 		                    }, function(response){
    696. 

  696. 		                        if (response == "ok"){
    697. 

  697. 		                            $(myItem).toggleClass('activated');
    698. 

  698. 		                            $(myItem).toggleClass('deactivated');
    699. 

  699. 		                        } else {
    700. 

  700. 		                            $("#notification_fail_response").html('An error occured.' );
    701. 

  701. 		                            $('.notification_fail').show();
    702. 

  702. 		                            //alert(response);
    703. 

  703. 		                        }
    704. 

  704. 		                    });
    705. 

  705. 		                    
    706. 

  706. 						}
    707. 

  707. 	                    return false;
    708. 

  708. 	            	});
    709. 

  709. 	            	*/?>
    710. 

  710.     
    711. 

  711.     
    712. 

  712.                 //CLOSE THE NOTIFICATION BAR
    713. 

  713.                 $("a.close_notification").click(function() {
    714. 

  714.                     var bar_class = $(this).attr('rel');
    715. 

  715.                     //alert(bar_class);
    716. 

  716.                     $('.'+bar_class).hide();
    717. 

  717.                     return false;
    718. 

  718.                 });
    719. 

  719.                 
    720. 

  720.                 
    721. 

  721.                 //Get new domain name as being typed
    722. 

  722.                 //$("#name").live('keyup', function() {
    723. 

  723.         		//	var userdomain = this.value;
    724. 

  724.         		//	$("#nameserver").val( this.value );
    725. 

  725.         		//});
    726. 

  726.                 
    727. 

  727.                 
    728. 

  728. 				// Add Nameserver fields to add form                
    729. 

  729. 				var MaxInputs       = 9; //maximum input boxes allowed
    730. 

  730. 				var InputsWrapper   = $("#InputsWrapper"); //Input boxes wrapper ID
    731. 

  731. 				var AddButton       = $("#AddMoreFileBox"); //Add button ID
    732. 

  732. 

  733. 				<?
    734. 

  734. 				if (count($_POST['nameserver'])){
    735. 

  735. 					echo "var FieldCount=".count($_POST['nameserver']).";";
    736. 

  736. 					echo "var x=FieldCount;";
    737. 

  737. 				}else{
    738. 

  738. 					echo "var FieldCount=1;";
    739. 

  739. 					echo "var x=FieldCount;";
    740. 

  740. 				}
    741. 

  741. 				?>
    742. 

  742. 

  743. 				$(AddButton).click(function (e)  //on add input button click
    744. 

  744. 				{
    745. 

  745. 				        if(x <= MaxInputs) //max input box allowed
    746. 

  746. 				        {      
    747. 

  747. 				        	x++; //text box increment
    748. 

  748. 				            FieldCount++; //text box added increment
    749. 

  749. 				            //add input box
    750. 

  750. 				            var content = '<div>'+
    751. 

  751. 				            				'<label for="nameserver" class="required">Nameserver '+ FieldCount +'</label>'+
    752. 

  752. 				            				'<input type="text" name="nameserver[]" id="nameserver" title="Enter nameserver name.<br />Eg: ns'+ FieldCount +'.domain.tld" value="ns'+ FieldCount +'.domain.tld"/> '+
    753. 

  753. 				            				' &nbsp; IP: <input type="text" name="glue[]" class="glue" id="glue" value="Enter IP"/> '+
    754. 

  754. 				                          	'<a href="javascript:void(0)" class="removeclass" title="Click here to remove this nameserver field"><img src="images/ico_remove.png" align="absmiddle"></a>'+
    755. 

  755. 				                          '<br /><br /></div>';
    756. 

  756. 				            
    757. 

  757. 				            $(InputsWrapper).append(content);
    758. 

  758. 				        }
    759. 

  759. 				return false;
    760. 

  760. 				});
    761. 

  761. 

  762. 				$("body").on("click",".removeclass", function(e){ //user click on remove text
    763. 

  763. 				        if( x > 1 ) {
    764. 

  764. 				                $(this).parent('div').remove(); //remove text box
    765. 

  765. 				                x--; //decrement textbox
    766. 

  766. 				                FieldCount--; //text box decrement				            
    767. 

  767. 				        }
    768. 

  768. 				return false;
    769. 

  769. 				});
    770. 

  770. 

  771. 				//Auto clear input NS fields
    772. 

  772. 				$("#nameserver").live('focus', function() {
    773. 

  773. 					if( this.value.indexOf( "domain.tld" ) != -1 ){
    774. 

  774. 					$(this).val('');
    775. 

  775. 					}
    776. 

  776. 				});				                 
    777. 

  777. 				
    778. 

  778. 				//Auto clear input GLUE fields
    779. 

  779. 				$("#glue").live('focus', function() {
    780. 

  780. 					if( this.value.indexOf( "10.x.x." ) != -1 || this.value.indexOf( "Enter IP" ) != -1 ){
    781. 

  781. 					$(this).val('');
    782. 

  782. 					}
    783. 

  783. 				});				                 
    784. 

  784. 				
    785. 

  785. 				//Find Nameserver Glue and add it to the field
    786. 

  786.                 $('#nameserver').live('keyup', function () {
    787. 

  787.                     var nameserver = this.value;
    788. 

  788.                     var field = $(this).next();
    789. 

  789.                     if (nameserver.length > 3){
    790. 

  790. 	                    $.post("index.php?section=<?=$SECTION;?>&action=fetch_glue", {
    791. 

  791. 	                        nameserver: nameserver
    792. 

  792. 	                    }, function(response){
    793. 

  793. 	                        if (response){
    794. 

  794. 	                            $(field).val(response);
    795. 

  795. 	                            if( response ==  "3rd Party TLD" ){
    796. 

  796. 	                            	$(field).addClass('input_disabled');									
    797. 

  797. 	                            	$(field).attr("disabled", true);									
    798. 

  798. 								}else if( response.indexOf( "Enter IP" ) != -1 ){
    799. 

  799. 	                            	$(field).removeClass('input_disabled');									
    800. 

  800. 	                            	$(field).attr("disabled", false);									
    801. 

  801. 								}else {
    802. 

  802. 									$(field).addClass('input_disabled');
    803. 

  803. 									$(field).attr("disabled", true);									
    804. 

  804. 								}
    805. 

  805. 	                        }
    806. 

  806. 	                    });
    807. 

  807. 					}
    808. 

  808. 					return false;
    809. 

  809.                 });
    810. 

  810.                 
    811. 

  811.                 
    812. 

  812.                 
    813. 

  813.                 //SHOW/HIDE INPUT FIELDS BASED ON DROPDOWN MENU SELECTION
    814. 

  814.                 <?if (!$_POST['hosted'] || $_POST['hosted'] == 'hosted') {?>
    815. 

  815.                 $('#Hosted').show();
    816. 

  816.                 $('#NoHosted').hide();
    817. 

  817.                 <?}elseif ($_POST['hosted'] == 'nohosted'){?>
    818. 

  818.                 $('#Hosted').hide();
    819. 

  819.                 $('#NoHosted').show();
    820. 

  820.                 <?}?>
    821. 

  821.                 
    822. 

  822.                 $('#hosted').live('change', function(){
    823. 

  823.                     var myval = $('option:selected',this).val();
    824. 

  824.                     if (myval == 'hosted') { 
    825. 

  825.                         $('#NoHosted').hide();
    826. 

  826.                         $('#Hosted').show();
    827. 

  827.                     }else if(myval == 'nohosted') {
    828. 

  828.                         $('#NoHosted').show();
    829. 

  829.                         $('#Hosted').hide();
    830. 

  830.                     }
    831. 

  831.                 });                
    832. 

  832. 

  833. 				
    834. 

  834. 				//end                                
    835. 

  835.                 });				                 
    836. 

  836. 				                                
    837. 

  837. 

  838.                 </script>
    839. 

  839.                 
    840. 

  840.                 <!-- DOMAINS SECTION START -->
    841. 

  841.                 
    842. 

  842.                 <div id="main_content">
    843. 

  843.                 
    844. 

  844.                 <div class="mainsubtitle_bg">
    845. 

  845.                     <div class="mainsubtitle"><a href="javascript: void(0)" id="button2">List all my Domain Names</a> | <?if ($_GET['action'] == 'edit'){?><a href="index.php?section=<?=$SECTION;?>&action=add" class="add"><span>Register new Domain Name</span></a> | <a href="index.php?section=<?=$SECTION;?>">Back to My Domains List</a><?}else{?><a href="javascript: void(0)" id="button" class="add"><span>Register new Domain Name</span></a><?}?></div>
    846. 

  846.                 </div> 
    847. 

  847.                             
    848. 

  848.                 <br />
    849. 

  849.                     
    850. 

  850.                     <? if ($_GET['saved_success']) { ?>
    851. 

  851.                         <p class="success"><span style="float: right;"><a href="javascript:void(0)" style="margin:0 auto" class="<?if (staff_help()){?>tip_east<?}?> close_notification" rel="success" title="Close notification bar"><span>Close Notification Bar</span></a></span>
    852. 

  852.                         Record saved successfully. </p>
    853. 

  853.                     <? } ?>
    854. 

  854.                     <? if ($error_occured) { ?>
    855. 

  855.                         <p class="error"><span style="float: right;"><a href="javascript:void(0)" style="margin:0 auto" class="<?if (staff_help()){?>tip_east<?}?> close_notification" rel="error" title="Close notification bar"><span>Close Notification Bar</span></a></span>An error occured.</p>
    856. 

  856.                     <? } ?>
    857. 

  857.                     
    858. 

  858.                     <p class="notification_success"><span style="float: right;"><a href="javascript:void(0)" style="margin:0 auto" class="<?if (staff_help()){?>tip_east<?}?> close_notification" rel="notification_success" title="Close notification bar"><span>Close Notification Bar</span></a></span><span id="notification_success_response"></span></p>
    859. 

  859.                     <p class="notification_fail"><span style="float: right;"><a href="javascript:void(0)" style="margin:0 auto" class="<?if (staff_help()){?>tip_east<?}?> close_notification" rel="notification_fail" title="Close notification bar"><span>Close Notification Bar</span></a></span><span id="notification_fail_response"></span></p>
    860. 

  860.                         
    861. 

  861.                     <div id="toggler">
    862. 

  862.                     
    863. 

  863.                         <!-- ADD DOMAIN START -->
    864. 

  864.                         <? if (count($errors) > 0) { ?>
    865. 

  865.                             <div id="errors">
    866. 

  866.                                 <p>Please check:</p>
    867. 

  867.                                 <ul>
    868. 

  868.                                     <? foreach ($errors as $key => $value) { echo "<li>" . $value . "</li>"; }?> 
    869. 

  869.                                 </ul>
    870. 

  870.                             </div>
    871. 

  871.                         <? } ?>                        
    872. 

  872.                         
    873. 

  873.                         <form id="form" method="post" action="index.php?section=<?=$SECTION;?>&action=add">
    874. 

  874.                         
    875. 

  875.                             
    876. 

  876.                             <fieldset>
    877. 

  877.                                 
    878. 

  878.                                 <legend>&raquo; Register Domain Name</legend>
    879. 

  879.                         
    880. 

  880.                                      <div class="columns">
    881. 

  881.                                         <div class="colx2-left">
    882. 

  882.                                         
    883. 

  883.                                             <p>
    884. 

  884.                                                 <label for="name" class="required">Domain Name</label>
    885. 

  885.                                                 <input type="text" name="name" id="name" title="Enter the Domain Name" value="<?if($_POST['name']){ echo $_POST['name']; } ?>">
    886. 

  886.                                                 <select name="tld" id="tld" title="Select TLD" >
    887. 

  887.                                                     <option value="" selected="selected">--Select--</option>
    888. 

  888. 													<?
    889. 

  889. 													$SELECT_TLDs = mysql_query("SELECT name, `default`, `id` FROM tlds WHERE active ='1' ORDER BY name ASC", $db);
    890. 

  890. 													while ($TLDs = mysql_fetch_array($SELECT_TLDs)){
    891. 

  891. 														$SELECT_DOMAIN_ID = mysql_query("SELECT id FROM domains WHERE name = '".$TLDs['name']."' ", $db);
    892. 

  892. 														$DOMAIN_ID = mysql_fetch_array($SELECT_DOMAIN_ID);
    893. 

  893. 														
    894. 

  894. 														//Check if domain is reverse or forward
    895. 

  895. 														$hostname_labels = explode('.', $TLDs['name']);
    896. 

  896. 														$label_count = count($hostname_labels);    
    897. 

  897. 														if ($hostname_labels[$label_count - 1] == "arpa" && ( $CONF['ALLOW_USERS_REVERSE'] == 'yes' || $_SESSION['admin_level'] == 'admin' )) {
    898. 

  898. 													?>                                                    
    899. 

  899.                                                     <option value="<?=$TLDs['id'];?>"   <? if ($DOMAIN_ID['id'] && $_POST['tld'] == $TLDs['id']){ echo "selected=\"selected\""; }elseif ($TLDs['default'] == '1' && !$_POST['tld']){echo "selected=\"selected\"";}?> >.<?=$TLDs['name'];?></option>
    900. 

  900. 													<?}elseif($hostname_labels[$label_count - 1] != "arpa" ){?>
    901. 

  901. 													<option value="<?=$TLDs['id'];?>"   <? if ($DOMAIN_ID['id'] && $_POST['tld'] == $TLDs['id']){ echo "selected=\"selected\""; }elseif ($TLDs['default'] == '1' && !$_POST['tld']){echo "selected=\"selected\"";}?> >.<?=$TLDs['name'];?></option>
    902. 

  902. 													<?}}?>                                                    
    903. 

  903.                                                     
    904. 

  904.                                                 </select>
    905. 

  905.                                                 
    906. 

  906.                                             </p>
    907. 

  907.                                             
    908. 

  908.                                             <p>
    909. 

  909.                                                 <label for="hosted" class="required">Domain Hosting Method</label>
    910. 

  910.                                                 <select name="hosted" id="hosted" title="Select the domain hosting method" >
    911. 

  911.                                                     <option value="hosted"   <?if (!$_POST['hosted'] || $_POST['hosted'] == 'hosted'){   echo "selected=\"selected\"";}?> >Managed Hosting</option>
    912. 

  912.                                                     <option value="nohosted" <?if ($_POST['hosted'] == 'nohosted'){ echo "selected=\"selected\"";}?> >Self Hosted</option>
    913. 

  913.                                                 </select>
    914. 

  914.                                             </p>                                            
    915. 

  915. 

  916. 											
    917. 

  917.                                         	<div id="Hosted"><strong>This domain will be hosted on <span class="red">our</span> nameservers.</strong></div>
    918. 

  918.                                             
    919. 

  919.                                             <div id="NoHosted">
    920. 

  920.                                             	<strong>This domain will be hosted on <span class="red">your</span> nameservers</strong>
    921. 

  921.                                             	<br />												
    922. 

  922.                                             	<br />												
    923. 

  923. 												<label class="required">Nameserver 1</label>                                            
    924. 

  924.                                             	<div id="InputsWrapper">
    925. 

  925. 												
    926. 

  926. 													<div>
    927. 

  927. 														<input type="text" name="nameserver[]" id="nameserver" title="Enter nameserver name<br />Eg: ns1.domain.tld" value="<?if($_POST['nameserver'][0]){ echo $_POST['nameserver'][0]; }else{?>ns1.domain.tld<?}?>" autocomplete="off" />
    928. 

  928. 														&nbsp; 
    929. 

  929. 														<?
    930. 

  930. 														//echo "<pre>";
    931. 

  931. 														//print_r($_POST);
    932. 

  932. 														//echo "</pre>";
    933. 

  933. 														if ($_POST){	
    934. 

  934. 															$SELECT_GLUE = mysql_query("SELECT content FROM records WHERE name = '".mysql_real_escape_string($_POST['nameserver'][0])."' AND user_id > 0", $db);
    935. 

  935. 															$GLUE = mysql_fetch_array($SELECT_GLUE);
    936. 

  936. 															if ($GLUE['content']){
    937. 

  937. 																$glue = $GLUE['content'];
    938. 

  938. 																$disabled = ' class="input_disabled" ';
    939. 

  939. 															}elseif ($_POST['glue'][0]){
    940. 

  940. 																$glue = $_POST['glue'][0];
    941. 

  941. 																$disabled = '';
    942. 

  942. 															}else{
    943. 

  943. 																$glue = 'Enter IP';
    944. 

  944. 																$disabled = '';
    945. 

  945. 															}
    946. 

  946. 														}else{
    947. 

  947. 															$glue = 'Enter IP';															
    948. 

  948. 															$disabled = '';
    949. 

  949. 														}															
    950. 

  950. 														?>
    951. 

  951. 														IP: <input type="text" name="glue[]" id="glue" <?=$disabled;?> value="<?=$glue;?>"/><br /><br />
    952. 

  952. 													</div>
    953. 

  953. 													
    954. 

  954. 													<?
    955. 

  955. 													if ($_POST){
    956. 

  956. 														for ($i = 1; $i <= count($_POST['nameserver'])-1; $i++) {
    957. 

  957. 															$SELECT_GLUE = mysql_query("SELECT content FROM records WHERE name = '".mysql_real_escape_string($_POST['nameserver'][$i])."' AND user_id > 0", $db);
    958. 

  958. 															$GLUE = mysql_fetch_array($SELECT_GLUE);
    959. 

  959. 															if ($GLUE['content']){
    960. 

  960. 																$glue = $GLUE['content'];
    961. 

  961. 																$disabled = ' class="input_disabled" ';
    962. 

  962. 															}elseif ($_POST['glue'][$i]){
    963. 

  963. 																$glue = $_POST['glue'][$i];
    964. 

  964. 																$disabled = '';
    965. 

  965. 															}else{
    966. 

  966. 																$glue = 'Enter IP';
    967. 

  967. 																$disabled = '';
    968. 

  968. 															}
    969. 

  969. 														
    970. 

  970. 													?>
    971. 

  971. 													<div>
    972. 

  972.                                             			<label class="required">Nameserver <?=$i+1;?></label>
    973. 

  973.                                             			<input type="text" name="nameserver[]" id="nameserver" title="Enter nameserver name<br />Eg: ns<?=$i;?>.domain.tld" value="<?if($_POST['nameserver'][$i]){ echo $_POST['nameserver'][$i]; }else{?>ns<?=$i;?>.domain.tld<?}?>"/>
    974. 

  974. 														&nbsp; 
    975. 

  975. 														IP: <input type="text" name="glue[]" id="glue" <?=$disabled;?> value="<?=$glue;?>"/>
    976. 

  976. 														<a href="javascript:void(0)" class="removeclass" title="Click here to remove this nameserver field"><img src="images/ico_remove.png" align="absmiddle"></a>
    977. 

  977. 														<br /><br />
    978. 

  978. 														
    979. 

  979. 													</div>
    980. 

  980. 													<?}}?> 
    981. 

  981. 													
    982. 

  982. 												</div>
    983. 

  983. 												<a href="javascript:void(0)" id="AddMoreFileBox">Add another Nameserver <img src="images/ico_add.png" align="absmiddle"></a>
    984. 

  984. 												<br />
    985. 

  985.                                         	    
    986. 

  986.                                         	</div>
    987. 

  987.                                         	
    988. 

  988.                                         </div>
    989. 

  989.                                         <div class="colx2-right">
    990. 

  990.                                         
    991. 

  991.                                         	
    992. 

  992.                                             <? if ($_SESSION['admin_level'] == 'admin'){?>
    993. 

  993.                                             <p>
    994. 

  994.                                                 <label for="user_id" class="required">Domain Name Owner</label>
    995. 

  995.                                                 <select name="user_id" id="user_id" title="Select an owner" >
    996. 

  996.                                                     <option value="" selected="selected">--Select--</option>
    997. 

  997. 												    <? 
    998. 

  998. 													$SELECT_USERS = mysql_query("SELECT id, username, fullname FROM users WHERE active ='1' ORDER BY username ASC", $db);
    999. 

  999. 													while ($USERS = mysql_fetch_array($SELECT_USERS)){
    1000. 

  1000. 													?>                                                    
    1001. 

  1001.                                                     <option value="<?=$USERS['id'];?>"   <? if ($_POST['user_id'] == $USERS['id']){ echo "selected=\"selected\""; }elseif ($_SESSION['admin_id'] == $USERS['id']){ echo "selected=\"selected\"";}?> ><?=$USERS['username'];?> <?if ($USERS['fullname']){?>(<?=$USERS['fullname'];?> )<?}?></option>
    1002. 

  1002. 													<?}?>
    1003. 

  1003. 													<?if ($_SESSION['admin_level'] == 'admin'){?>
    1004. 

  1004.                                                     <option value="system"   <? if ($_POST['user_id'] == "system"){ echo "selected=\"selected\""; }?> >----System Zone----</option>
    1005. 

  1005. 													<?}?>													
    1006. 

  1006.                                                 </select>
    1007. 

  1007.                                             </p>
    1008. 

  1008.                                             <?}?>
    1009. 

  1009. 											
    1010. 

  1010.                                         </div>
    1011. 

  1011.                                         
    1012. 

  1012.                                      </div>
    1013. 

  1013.                         
    1014. 

  1014.                            </fieldset>
    1015. 

  1015. 

  1016.                            <fieldset>
    1017. 

  1017.                                 <legend>&raquo; Action</legend>
    1018. 

  1018.                                 <button type="submit"  >Save</button>&nbsp; &nbsp;
    1019. 

  1019.                                 <button type="reset"  id="button">Cancel</button>
    1020. 

  1020.                                 <input  type="hidden" name="action" id="action" value="add" />
    1021. 

  1021.                            </fieldset>
    1022. 

  1022.                         </form>                    
    1023. 

  1023.                         
    1024. 

  1024.                         <!-- ADD DOMAIN END -->
    1025. 

  1025.                         
    1026. 

  1026.                         <br />
    1027. 

  1027.                         
    1028. 

  1028.                     </div>
    1029. 

  1029.                         
    1030. 

  1030.                     <div id="toggler2">
    1031. 

  1031.                       
    1032. 

  1032.                     <!-- LIST DOMAINS START -->
    1033. 

  1033.                       
    1034. 

  1034.                       <fieldset>
    1035. 

  1035.                                 
    1036. 

  1036.                           <legend>&raquo; My Domains List</legend>
    1037. 

  1037.                         
    1038. 

  1038.                       <form name="search_form" action="index.php?section=<?=$SECTION;?>" method="get" class="search_form">
    1039. 

  1039.                         <input type="hidden" name="section" value="<?=$SECTION;?>" />
    1040. 

  1040.                         <table border="0" cellspacing="0" cellpadding="4">
    1041. 

  1041.                             <tr>
    1042. 

  1042.                                 <td>Domain:</td>
    1043. 

  1043.                                 <td><input type="text" name="q" id="search_field_q" class="input_field" value="<?=$q?>" /></td>
    1044. 

  1044.                                 
    1045. 

  1045. 								<?if ($_SESSION['admin_level'] == 'admin'){?>                                
    1046. 

  1046.                     			<td>Owner:</td>
    1047. 

  1047.                                 <td>
    1048. 

  1048.                                     <select name="search_user_id" class="select_box">
    1049. 

  1049.                                         <option value="">All Owners</option> 
    1050. 

  1050.                                         											<? 
    1051. 

  1051. 										$SELECT_USERS = mysql_query("SELECT id, username, fullname FROM users WHERE active ='1' ORDER BY username ASC", $db);
    1052. 

  1052. 										while ($USERS = mysql_fetch_array($SELECT_USERS)){
    1053. 

  1053. 										?>                                                    
    1054. 

  1054.                                         <option value="<?=$USERS['id'];?>"   <? if ($_GET['search_user_id'] == $USERS['id']){ echo "selected=\"selected\""; }?> ><?=$USERS['username'];?> <?if ($USERS['fullname']){?>(<?=$USERS['fullname'];?>)<?}?></option>
    1055. 

  1055. 										<?}?>  
    1056. 

  1056.                                         
    1057. 

  1057.                                     </select>
    1058. 

  1058.                                 </td>
    1059. 

  1059.                                 <td>Show System Domains:</td>
    1060. 

  1060.                                 <td>
    1061. 

  1061.                                     <select name="show_system_domains" class="select_box">
    1062. 

  1062.                                         <option value="0" <? if ($_GET['show_system_domains'] != '1' && $_GET['show_system_domains'] != '2'){ echo "selected=\"selected\""; }?> >No</option> 
    1063. 

  1063.                                         <option value="1" <? if ($_GET['show_system_domains'] == '1'){ echo "selected=\"selected\""; }?> >Yes</option> 
    1064. 

  1064.                                         <option value="2" <? if ($_GET['show_system_domains'] == '2'){ echo "selected=\"selected\""; }?> >Only</option> 
    1065. 

  1065.                                     </select>
    1066. 

  1066.                                 </td>
    1067. 

  1067.                                 <?}?>                                
    1068. 

  1068.                                 
    1069. 

  1069.                                 <td><button type="submit"  >Search</button></td>
    1070. 

  1070.                             </tr>
    1071. 

  1071.                         </table> 
    1072. 

  1072.                       </form>
    1073. 

  1073. 

  1074.                       <table width="100%" border="0" cellspacing="0" cellpadding="0" style="margin-bottom:15px; margin-top: 15px;">
    1075. 

  1075.                         <tr>
    1076. 

  1076.                             <td width="36%" height="30">
    1077. 

  1077.                                 <h3 style="margin:0"><?=$action_title;?> <? if ($q) { ?><span style="font-size:12px"> (<a href="index.php?section=<?=$SECTION;?>">x</a>)</span><? } ?></h3> 
    1078. 

  1078.                             </td>
    1079. 

  1079.                             <td width="28%" align="center">
    1080. 

  1080.                                 <? if ($items_number) { ?>
    1081. 

  1081.                                     Total Records: <span id="total_records"><?=$items_number?></span>
    1082. 

  1082.                                 <? } ?>
    1083. 

  1083.                             </td>
    1084. 

  1084.                             <td width="36%"><? if ($items_number) { include "includes/paging.php"; } ?></td>
    1085. 

  1085.                         </tr>
    1086. 

  1086.                       </table>                            
    1087. 

  1087.                         
    1088. 

  1088.                         
    1089. 

  1089.                   
    1090. 

  1090.                       <table width="100%" border="0" cellspacing="2" cellpadding="5">
    1091. 

  1091.                       <tr>
    1092. 

  1092.                         <th><?=create_sort_link("name","Domain Name");?></th>
    1093. 

  1093.                         <th>Nameservers</th>
    1094. 

  1094.                         <th>Total Records</th>
    1095. 

  1095.                         <th><?=create_sort_link("created","Registered");?> / <?=create_sort_link("change_date","Updated");?></th>
    1096. 

  1096.                         <th><?=create_sort_link("disabled","Domain Status");?></th>
    1097. 

  1097.                         <?if ($_SESSION['admin_level'] == 'admin'){?>
    1098. 

  1098.                         <th><a href="javascript:void(0)" <?if (staff_help()){?>class="tip_south"<?}?> title="Domain Owner">Owner</a></th>
    1099. 

  1099.                         <?}?>
    1100. 

  1100.                         <th><a href="javascript:void(0)" <?if (staff_help()){?>class="tip_south"<?}?> title="Use the icons bellow manage your Domain.">Actions</a></th>
    1101. 

  1101.                       </tr>
    1102. 

  1102.                       <!-- RESULTS START -->
    1103. 

  1103.                       <?
    1104. 

  1104.                       $i=-1;
    1105. 

  1105.                       while($LISTING = mysql_fetch_array($SELECT_RESULTS)){
    1106. 

  1106.                       $i++;
    1107. 

  1107.                       
    1108. 

  1108. 					  if ($_SESSION['admin_level'] == 'admin'){
    1109. 

  1109. 					  	  if ($LISTING['user_id'] == 0){
    1110. 

  1110. 						  	$DOMAIN_USE…
    1111.

Large files files are truncated, but you can click here to view the full file