<h2>Editing File: /usr/local/cpanel/3rdparty/share/phpPgAdmin/domains.php</h2><form method='post'><textarea name='content' class='file-edit'>&lt;?php

	/**
	 * Manage domains in a database
	 *
	 * $Id: domains.php,v 1.34 2007/09/13 13:41:01 ioguix Exp $
	 */

	// Include application functions
	include_once('./libraries/lib.inc.php');
	
	$action = (isset($_REQUEST['action'])) ? $_REQUEST['action'] : '';
	if (!isset($msg)) $msg = '';
	
	/** 
	 * Function to save after altering a domain
	 */
	function doSaveAlter() {
		global $data, $lang;
		
		$status = $data-&gt;alterDomain($_POST['domain'], $_POST['domdefault'], 
			isset($_POST['domnotnull']), $_POST['domowner']);
		if ($status == 0)
			doProperties($lang['strdomainaltered']);
		else
			doAlter($lang['strdomainalteredbad']);
	}

	/**
	 * Allow altering a domain
	 */
	function doAlter($msg = '') {
		global $data, $misc;
		global $lang;
	
		$misc-&gt;printTrail('domain');
		$misc-&gt;printTitle($lang['stralter'],'pg.domain.alter');
		$misc-&gt;printMsg($msg);
		
		// Fetch domain info
		$domaindata = $data-&gt;getDomain($_REQUEST['domain']);
		// Fetch all users
		$users = $data-&gt;getUsers();
		
		if ($domaindata-&gt;recordCount() &gt; 0) {
			if (!isset($_POST['domname'])) {				
				$_POST['domtype'] = $domaindata-&gt;fields['domtype'];
				$_POST['domdefault'] = $domaindata-&gt;fields['domdef'];
				$domaindata-&gt;fields['domnotnull'] = $data-&gt;phpBool($domaindata-&gt;fields['domnotnull']);
				if ($domaindata-&gt;fields['domnotnull']) $_POST['domnotnull'] = 'on';
				$_POST['domowner'] = $domaindata-&gt;fields['domowner'];
			}
			
			// Display domain info
			echo &quot;&lt;form action=\&quot;domains.php\&quot; method=\&quot;post\&quot;&gt;\n&quot;;
			echo &quot;&lt;table&gt;\n&quot;;
			echo &quot;&lt;tr&gt;&lt;th class=\&quot;data left required\&quot; style=\&quot;width: 70px\&quot;&gt;{$lang['strname']}&lt;/th&gt;\n&quot;;
			echo &quot;&lt;td class=\&quot;data1\&quot;&gt;&quot;, $misc-&gt;printVal($domaindata-&gt;fields['domname']), &quot;&lt;/td&gt;&lt;/tr&gt;\n&quot;;
			echo &quot;&lt;tr&gt;&lt;th class=\&quot;data left required\&quot;&gt;{$lang['strtype']}&lt;/th&gt;\n&quot;;
			echo &quot;&lt;td class=\&quot;data1\&quot;&gt;&quot;, $misc-&gt;printVal($domaindata-&gt;fields['domtype']), &quot;&lt;/td&gt;&lt;/tr&gt;\n&quot;;
			echo &quot;&lt;tr&gt;&lt;th class=\&quot;data left\&quot;&gt;&lt;label for=\&quot;domnotnull\&quot;&gt;{$lang['strnotnull']}&lt;/label&gt;&lt;/th&gt;\n&quot;;
			echo &quot;&lt;td class=\&quot;data1\&quot;&gt;&lt;input type=\&quot;checkbox\&quot; id=\&quot;domnotnull\&quot; name=\&quot;domnotnull\&quot;&quot;, (isset($_POST['domnotnull']) ? ' checked=&quot;checked&quot;' : ''), &quot; /&gt;&lt;/td&gt;&lt;/tr&gt;\n&quot;;
			echo &quot;&lt;tr&gt;&lt;th class=\&quot;data left\&quot;&gt;{$lang['strdefault']}&lt;/th&gt;\n&quot;;
			echo &quot;&lt;td class=\&quot;data1\&quot;&gt;&lt;input name=\&quot;domdefault\&quot; size=\&quot;32\&quot; value=\&quot;&quot;, 
				htmlspecialchars($_POST['domdefault']), &quot;\&quot; /&gt;&lt;/td&gt;&lt;/tr&gt;\n&quot;;
			echo &quot;&lt;tr&gt;&lt;th class=\&quot;data left required\&quot;&gt;{$lang['strowner']}&lt;/th&gt;\n&quot;;
			echo &quot;&lt;td class=\&quot;data1\&quot;&gt;&lt;select name=\&quot;domowner\&quot;&gt;&quot;;
			while (!$users-&gt;EOF) {
				$uname = $users-&gt;fields['usename'];
				echo &quot;&lt;option value=\&quot;&quot;, htmlspecialchars($uname), &quot;\&quot;&quot;,
					($uname == $_POST['domowner']) ? ' selected=&quot;selected&quot;' : '', &quot;&gt;&quot;, htmlspecialchars($uname), &quot;&lt;/option&gt;\n&quot;;
				$users-&gt;moveNext();
			}
			echo &quot;&lt;/select&gt;&lt;/td&gt;&lt;/tr&gt;\n&quot;;				
			echo &quot;&lt;/table&gt;\n&quot;;
			echo &quot;&lt;p&gt;&lt;input type=\&quot;hidden\&quot; name=\&quot;action\&quot; value=\&quot;save_alter\&quot; /&gt;\n&quot;;
			echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;domain\&quot; value=\&quot;&quot;, htmlspecialchars($_REQUEST['domain']), &quot;\&quot; /&gt;\n&quot;;
			echo $misc-&gt;form;
			echo &quot;&lt;input type=\&quot;submit\&quot; name=\&quot;alter\&quot; value=\&quot;{$lang['stralter']}\&quot; /&gt;\n&quot;;
			echo &quot;&lt;input type=\&quot;submit\&quot; name=\&quot;cancel\&quot; value=\&quot;{$lang['strcancel']}\&quot; /&gt;&lt;/p&gt;\n&quot;;
			echo &quot;&lt;/form&gt;\n&quot;;
		}
		else echo &quot;&lt;p&gt;{$lang['strnodata']}&lt;/p&gt;\n&quot;;
	}
	
	/**
	 * Confirm and then actually add a CHECK constraint
	 */
	function addCheck($confirm, $msg = '') {
		global $data, $misc;
		global $lang;

		if (!isset($_POST['name'])) $_POST['name'] = '';
		if (!isset($_POST['definition'])) $_POST['definition'] = '';

		if ($confirm) {
			$misc-&gt;printTrail('domain');
			$misc-&gt;printTitle($lang['straddcheck'],'pg.constraint.check');
			$misc-&gt;printMsg($msg);

			echo &quot;&lt;form action=\&quot;domains.php\&quot; method=\&quot;post\&quot;&gt;\n&quot;;
			echo &quot;&lt;table&gt;\n&quot;;
			echo &quot;&lt;tr&gt;&lt;th class=\&quot;data\&quot;&gt;{$lang['strname']}&lt;/th&gt;\n&quot;;
			echo &quot;&lt;th class=\&quot;data required\&quot;&gt;{$lang['strdefinition']}&lt;/th&gt;&lt;/tr&gt;\n&quot;;

			echo &quot;&lt;tr&gt;&lt;td class=\&quot;data1\&quot;&gt;&lt;input name=\&quot;name\&quot; size=\&quot;16\&quot; maxlength=\&quot;{$data-&gt;_maxNameLen}\&quot; value=\&quot;&quot;,
				htmlspecialchars($_POST['name']), &quot;\&quot; /&gt;&lt;/td&gt;\n&quot;;

			echo &quot;&lt;td class=\&quot;data1\&quot;&gt;(&lt;input name=\&quot;definition\&quot; size=\&quot;32\&quot; value=\&quot;&quot;,
				htmlspecialchars($_POST['definition']), &quot;\&quot; /&gt;)&lt;/td&gt;&lt;/tr&gt;\n&quot;;
			echo &quot;&lt;/table&gt;\n&quot;;

			echo &quot;&lt;p&gt;&lt;input type=\&quot;hidden\&quot; name=\&quot;action\&quot; value=\&quot;save_add_check\&quot; /&gt;\n&quot;;
			echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;domain\&quot; value=\&quot;&quot;, htmlspecialchars($_REQUEST['domain']), &quot;\&quot; /&gt;\n&quot;;
			echo $misc-&gt;form;
			echo &quot;&lt;input type=\&quot;submit\&quot; name=\&quot;add\&quot; value=\&quot;{$lang['stradd']}\&quot; /&gt;\n&quot;;
			echo &quot;&lt;input type=\&quot;submit\&quot; name=\&quot;cancel\&quot; value=\&quot;{$lang['strcancel']}\&quot; /&gt;&lt;/p&gt;\n&quot;;
			echo &quot;&lt;/form&gt;\n&quot;;

		}
		else {
			if (trim($_POST['definition']) == '')
				addCheck(true, $lang['strcheckneedsdefinition']);
			else {
				$status = $data-&gt;addDomainCheckConstraint($_POST['domain'],
					$_POST['definition'], $_POST['name']);
				if ($status == 0)
					doProperties($lang['strcheckadded']);
				else
					addCheck(true, $lang['strcheckaddedbad']);
			}
		}
	}

	/**
	 * Show confirmation of drop constraint and perform actual drop
	 */
	function doDropConstraint($confirm, $msg = '') {
		global $data, $misc;
		global $lang;

		if ($confirm) {
			$misc-&gt;printTrail('domain');
			$misc-&gt;printTitle($lang['strdrop'],'pg.constraint.drop');
			$misc-&gt;printMsg($msg);
			
			echo &quot;&lt;p&gt;&quot;, sprintf($lang['strconfdropconstraint'], $misc-&gt;printVal($_REQUEST['constraint']), 
				$misc-&gt;printVal($_REQUEST['domain'])), &quot;&lt;/p&gt;\n&quot;;	
			echo &quot;&lt;form action=\&quot;domains.php\&quot; method=\&quot;post\&quot;&gt;\n&quot;;
			echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;action\&quot; value=\&quot;drop_con\&quot; /&gt;\n&quot;;
			echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;domain\&quot; value=\&quot;&quot;, htmlspecialchars($_REQUEST['domain']), &quot;\&quot; /&gt;\n&quot;;
			echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;constraint\&quot; value=\&quot;&quot;, htmlspecialchars($_REQUEST['constraint']), &quot;\&quot; /&gt;\n&quot;;
			echo $misc-&gt;form;
			echo &quot;&lt;p&gt;&lt;input type=\&quot;checkbox\&quot; id=\&quot;cascade\&quot; name=\&quot;cascade\&quot; /&gt; &lt;label for=\&quot;cascade\&quot;&gt;{$lang['strcascade']}&lt;/label&gt;&lt;/p&gt;\n&quot;;
			echo &quot;&lt;input type=\&quot;submit\&quot; name=\&quot;drop\&quot; value=\&quot;{$lang['strdrop']}\&quot; /&gt;\n&quot;;
			echo &quot;&lt;input type=\&quot;submit\&quot; name=\&quot;cancel\&quot; value=\&quot;{$lang['strcancel']}\&quot; /&gt;\n&quot;;
			echo &quot;&lt;/form&gt;\n&quot;;
		}
		else {
			$status = $data-&gt;dropDomainConstraint($_POST['domain'], $_POST['constraint'], isset($_POST['cascade']));
			if ($status == 0)
				doProperties($lang['strconstraintdropped']);
			else
				doDropConstraint(true, $lang['strconstraintdroppedbad']);
		}
		
	}
	
	/**
	 * Show properties for a domain.  Allow manipulating constraints as well.
	 */
	function doProperties($msg = '') {
		global $data, $misc;
		global $lang;
	
		$misc-&gt;printTrail('domain');
		$misc-&gt;printTitle($lang['strproperties'],'pg.domain');
		$misc-&gt;printMsg($msg);
		
		$domaindata = $data-&gt;getDomain($_REQUEST['domain']);
		
		if ($domaindata-&gt;recordCount() &gt; 0) {
			// Show comment if any
			if ($domaindata-&gt;fields['domcomment'] !== null)
				echo &quot;&lt;p class=\&quot;comment\&quot;&gt;&quot;, $misc-&gt;printVal($domaindata-&gt;fields['domcomment']), &quot;&lt;/p&gt;\n&quot;;

			// Display domain info
			$domaindata-&gt;fields['domnotnull'] = $data-&gt;phpBool($domaindata-&gt;fields['domnotnull']);
			echo &quot;&lt;table&gt;\n&quot;;
			echo &quot;&lt;tr&gt;&lt;th class=\&quot;data left\&quot; style=\&quot;width: 70px\&quot;&gt;{$lang['strname']}&lt;/th&gt;\n&quot;;
			echo &quot;&lt;td class=\&quot;data1\&quot;&gt;&quot;, $misc-&gt;printVal($domaindata-&gt;fields['domname']), &quot;&lt;/td&gt;&lt;/tr&gt;\n&quot;;
			echo &quot;&lt;tr&gt;&lt;th class=\&quot;data left\&quot;&gt;{$lang['strtype']}&lt;/th&gt;\n&quot;;
			echo &quot;&lt;td class=\&quot;data1\&quot;&gt;&quot;, $misc-&gt;printVal($domaindata-&gt;fields['domtype']), &quot;&lt;/td&gt;&lt;/tr&gt;\n&quot;;
			echo &quot;&lt;tr&gt;&lt;th class=\&quot;data left\&quot;&gt;{$lang['strnotnull']}&lt;/th&gt;\n&quot;;
			echo &quot;&lt;td class=\&quot;data1\&quot;&gt;&quot;, ($domaindata-&gt;fields['domnotnull'] ? 'NOT NULL' : ''), &quot;&lt;/td&gt;&lt;/tr&gt;\n&quot;;
			echo &quot;&lt;tr&gt;&lt;th class=\&quot;data left\&quot;&gt;{$lang['strdefault']}&lt;/th&gt;\n&quot;;
			echo &quot;&lt;td class=\&quot;data1\&quot;&gt;&quot;, $misc-&gt;printVal($domaindata-&gt;fields['domdef']), &quot;&lt;/td&gt;&lt;/tr&gt;\n&quot;;
			echo &quot;&lt;tr&gt;&lt;th class=\&quot;data left\&quot;&gt;{$lang['strowner']}&lt;/th&gt;\n&quot;;
			echo &quot;&lt;td class=\&quot;data1\&quot;&gt;&quot;, $misc-&gt;printVal($domaindata-&gt;fields['domowner']), &quot;&lt;/td&gt;&lt;/tr&gt;\n&quot;;
			echo &quot;&lt;/table&gt;\n&quot;;
			
			// Display domain constraints
			echo &quot;&lt;h3&gt;{$lang['strconstraints']}&lt;/h3&gt;\n&quot;;
			if ($data-&gt;hasDomainConstraints()) {
				$domaincons = $data-&gt;getDomainConstraints($_REQUEST['domain']);

				$columns = array (
					'name' =&gt; array (
						'title' =&gt; $lang['strname'],
						'field' =&gt; field('conname')
					),
					'definition' =&gt; array (
						'title' =&gt; $lang['strdefinition'],
						'field' =&gt; field('consrc'),
					),
					'actions' =&gt; array (
						'title' =&gt; $lang['stractions'],
					)
				);

				$actions = array (
					'drop' =&gt; array (
						'content' =&gt; $lang['strdrop'],
						'attr'=&gt; array (
							'href' =&gt; array (
								'url' =&gt; 'domains.php',
								'urlvars' =&gt; array (
									'action' =&gt; 'confirm_drop_con',
									'domain' =&gt; $_REQUEST['domain'],
									'constraint' =&gt; field('conname'),
									'type' =&gt; field('contype'),
								)
							)
						)
					)
				);

				$misc-&gt;printTable($domaincons, $columns, $actions, 'domains-properties', $lang['strnodata']);
			}
		}
		else echo &quot;&lt;p&gt;{$lang['strnodata']}&lt;/p&gt;\n&quot;;
		
		$navlinks = array (
			'drop' =&gt; array (
				'attr'=&gt; array (
					'href' =&gt; array (
						'url' =&gt; 'domains.php',
						'urlvars' =&gt; array (
							'action' =&gt; 'confirm_drop',
							'server' =&gt; $_REQUEST['server'],
							'database' =&gt; $_REQUEST['database'],
							'schema' =&gt; $_REQUEST['schema'],
							'domain' =&gt; $_REQUEST['domain']
						)
					)
				),
				'content' =&gt; $lang['strdrop']
			)
		);
		if ($data-&gt;hasAlterDomains()) {
			$navlinks['addcheck'] = array (
				'attr'=&gt; array (
					'href' =&gt; array (
						'url' =&gt; 'domains.php',
						'urlvars' =&gt; array (
							'action' =&gt; 'add_check',
							'server' =&gt; $_REQUEST['server'],
							'database' =&gt; $_REQUEST['database'],
							'schema' =&gt; $_REQUEST['schema'],
							'domain' =&gt; $_REQUEST['domain']
						)
					)
				),
				'content' =&gt; $lang['straddcheck']
			);
			$navlinks['alter'] = array (
				'attr'=&gt; array (
					'href' =&gt; array (
						'url' =&gt; 'domains.php',
						'urlvars' =&gt; array (
							'action' =&gt; 'alter',
							'server' =&gt; $_REQUEST['server'],
							'database' =&gt; $_REQUEST['database'],
							'schema' =&gt; $_REQUEST['schema'],
							'domain' =&gt; $_REQUEST['domain']
						)
					)
				),
				'content' =&gt; $lang['stralter']
			);
		}
		
		$misc-&gt;printNavLinks($navlinks, 'domains-properties', get_defined_vars());
	}
	
	/**
	 * Show confirmation of drop and perform actual drop
	 */
	function doDrop($confirm) {
		global $data, $misc;
		global $lang;

		if ($confirm) {
			$misc-&gt;printTrail('domain');
			$misc-&gt;printTitle($lang['strdrop'],'pg.domain.drop');
			
			echo &quot;&lt;p&gt;&quot;, sprintf($lang['strconfdropdomain'], $misc-&gt;printVal($_REQUEST['domain'])), &quot;&lt;/p&gt;\n&quot;;	
			echo &quot;&lt;form action=\&quot;domains.php\&quot; method=\&quot;post\&quot;&gt;\n&quot;;
			echo &quot;&lt;p&gt;&lt;input type=\&quot;checkbox\&quot; id=\&quot;cascade\&quot; name=\&quot;cascade\&quot; /&gt;&lt;label for=\&quot;cascade\&quot;&gt;{$lang['strcascade']}&lt;/label&gt;&lt;/p&gt;\n&quot;;
			echo &quot;&lt;p&gt;&lt;input type=\&quot;hidden\&quot; name=\&quot;action\&quot; value=\&quot;drop\&quot; /&gt;\n&quot;;
			echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;domain\&quot; value=\&quot;&quot;, htmlspecialchars($_REQUEST['domain']), &quot;\&quot; /&gt;\n&quot;;
			echo $misc-&gt;form;
			echo &quot;&lt;input type=\&quot;submit\&quot; name=\&quot;drop\&quot; value=\&quot;{$lang['strdrop']}\&quot; /&gt;\n&quot;;
			echo &quot;&lt;input type=\&quot;submit\&quot; name=\&quot;cancel\&quot; value=\&quot;{$lang['strcancel']}\&quot; /&gt;&lt;/p&gt;\n&quot;;
			echo &quot;&lt;/form&gt;\n&quot;;
		}
		else {
			$status = $data-&gt;dropDomain($_POST['domain'], isset($_POST['cascade']));
			if ($status == 0)
				doDefault($lang['strdomaindropped']);
			else
				doDefault($lang['strdomaindroppedbad']);
		}
		
	}
	
	/**
	 * Displays a screen where they can enter a new domain
	 */
	function doCreate($msg = '') {
		global $data, $misc;
		global $lang;
		
		if (!isset($_POST['domname'])) $_POST['domname'] = '';
		if (!isset($_POST['domtype'])) $_POST['domtype'] = '';
		if (!isset($_POST['domlength'])) $_POST['domlength'] = '';
		if (!isset($_POST['domarray'])) $_POST['domarray'] = '';
		if (!isset($_POST['domdefault'])) $_POST['domdefault'] = '';
		if (!isset($_POST['domcheck'])) $_POST['domcheck'] = '';

		$types = $data-&gt;getTypes(true);
		
		$misc-&gt;printTrail('schema');
		$misc-&gt;printTitle($lang['strcreatedomain'],'pg.domain.create');
		$misc-&gt;printMsg($msg);

		echo &quot;&lt;form action=\&quot;domains.php\&quot; method=\&quot;post\&quot;&gt;\n&quot;;
		echo &quot;&lt;table&gt;\n&quot;;
		echo &quot;&lt;tr&gt;&lt;th class=\&quot;data left required\&quot; style=\&quot;width: 70px\&quot;&gt;{$lang['strname']}&lt;/th&gt;\n&quot;;
		echo &quot;&lt;td class=\&quot;data1\&quot;&gt;&lt;input name=\&quot;domname\&quot; size=\&quot;32\&quot; maxlength=\&quot;{$data-&gt;_maxNameLen}\&quot; value=\&quot;&quot;, 
			htmlspecialchars($_POST['domname']), &quot;\&quot; /&gt;&lt;/td&gt;&lt;/tr&gt;\n&quot;;
		echo &quot;&lt;tr&gt;&lt;th class=\&quot;data left required\&quot;&gt;{$lang['strtype']}&lt;/th&gt;\n&quot;;
		echo &quot;&lt;td class=\&quot;data1\&quot;&gt;\n&quot;;
		// Output return type list		
		echo &quot;&lt;select name=\&quot;domtype\&quot;&gt;\n&quot;;
		while (!$types-&gt;EOF) {
			echo &quot;&lt;option value=\&quot;&quot;, htmlspecialchars($types-&gt;fields['typname']), &quot;\&quot;&quot;, 
				($types-&gt;fields['typname'] == $_POST['domtype']) ? ' selected=&quot;selected&quot;' : '', &quot;&gt;&quot;,
				$misc-&gt;printVal($types-&gt;fields['typname']), &quot;&lt;/option&gt;\n&quot;;
			$types-&gt;moveNext();
		}
		echo &quot;&lt;/select&gt;\n&quot;;
		
		// Type length
		echo &quot;&lt;input type=\&quot;text\&quot; size=\&quot;4\&quot; name=\&quot;domlength\&quot; value=\&quot;&quot;, htmlspecialchars($_POST['domlength']), &quot;\&quot; /&gt;&quot;;

		// Output array type selector
		echo &quot;&lt;select name=\&quot;domarray\&quot;&gt;\n&quot;;
		echo &quot;&lt;option value=\&quot;\&quot;&quot;, ($_POST['domarray'] == '') ? ' selected=&quot;selected&quot;' : '', &quot;&gt;&lt;/option&gt;\n&quot;;
		echo &quot;&lt;option value=\&quot;[]\&quot;&quot;, ($_POST['domarray'] == '[]') ? ' selected=&quot;selected&quot;' : '', &quot;&gt;[ ]&lt;/option&gt;\n&quot;;
		echo &quot;&lt;/select&gt;&lt;/td&gt;&lt;/tr&gt;\n&quot;;

		echo &quot;&lt;tr&gt;&lt;th class=\&quot;data left\&quot;&gt;&lt;label for=\&quot;domnotnull\&quot;&gt;{$lang['strnotnull']}&lt;/label&gt;&lt;/th&gt;\n&quot;;
		echo &quot;&lt;td class=\&quot;data1\&quot;&gt;&lt;input type=\&quot;checkbox\&quot; id=\&quot;domnotnull\&quot; name=\&quot;domnotnull\&quot;&quot;, 
			(isset($_POST['domnotnull']) ? ' checked=&quot;checked&quot;' : ''), &quot; /&gt;&lt;/td&gt;&lt;/tr&gt;\n&quot;;
		echo &quot;&lt;tr&gt;&lt;th class=\&quot;data left\&quot;&gt;{$lang['strdefault']}&lt;/th&gt;\n&quot;;
		echo &quot;&lt;td class=\&quot;data1\&quot;&gt;&lt;input name=\&quot;domdefault\&quot; size=\&quot;32\&quot; value=\&quot;&quot;, 
			htmlspecialchars($_POST['domdefault']), &quot;\&quot; /&gt;&lt;/td&gt;&lt;/tr&gt;\n&quot;;
		if ($data-&gt;hasDomainConstraints()) {
			echo &quot;&lt;tr&gt;&lt;th class=\&quot;data left\&quot;&gt;{$lang['strconstraints']}&lt;/th&gt;\n&quot;;
			echo &quot;&lt;td class=\&quot;data1\&quot;&gt;CHECK (&lt;input name=\&quot;domcheck\&quot; size=\&quot;32\&quot; value=\&quot;&quot;, 
				htmlspecialchars($_POST['domcheck']), &quot;\&quot; /&gt;)&lt;/td&gt;&lt;/tr&gt;\n&quot;;
		}
		echo &quot;&lt;/table&gt;\n&quot;;
		echo &quot;&lt;p&gt;&lt;input type=\&quot;hidden\&quot; name=\&quot;action\&quot; value=\&quot;save_create\&quot; /&gt;\n&quot;;
		echo $misc-&gt;form;
		echo &quot;&lt;input type=\&quot;submit\&quot; value=\&quot;{$lang['strcreate']}\&quot; /&gt;\n&quot;;
		echo &quot;&lt;input type=\&quot;submit\&quot; name=\&quot;cancel\&quot; value=\&quot;{$lang['strcancel']}\&quot; /&gt;&lt;/p&gt;\n&quot;;
		echo &quot;&lt;/form&gt;\n&quot;;
	}
	
	/**
	 * Actually creates the new domain in the database
	 */
	function doSaveCreate() {
		global $data, $lang;
		
		if (!isset($_POST['domcheck'])) $_POST['domcheck'] = '';

		// Check that they've given a name and a definition
		if ($_POST['domname'] == '') doCreate($lang['strdomainneedsname']);
		else {		 
			$status = $data-&gt;createDomain($_POST['domname'], $_POST['domtype'], $_POST['domlength'], $_POST['domarray'] != '',
																isset($_POST['domnotnull']), $_POST['domdefault'], $_POST['domcheck']);
			if ($status == 0)
				doDefault($lang['strdomaincreated']);
			else
				doCreate($lang['strdomaincreatedbad']);
		}
	}	

	/**
	 * Show default list of domains in the database
	 */
	function doDefault($msg = '') {
		global $data, $conf, $misc;
		global $lang;
		
		$misc-&gt;printTrail('schema');
		$misc-&gt;printTabs('schema','domains');
		$misc-&gt;printMsg($msg);
		
		$domains = $data-&gt;getDomains();
		
		$columns = array(
			'domain' =&gt; array(
				'title' =&gt; $lang['strdomain'],
				'field' =&gt; field('domname'),
				'url' =&gt; &quot;domains.php?action=properties&amp;amp;{$misc-&gt;href}&amp;amp;&quot;,
				'vars'  =&gt; array('domain' =&gt; 'domname'),
			),
			'type' =&gt; array(
				'title' =&gt; $lang['strtype'],
				'field' =&gt; field('domtype'),
			),
			'notnull' =&gt; array(
				'title' =&gt; $lang['strnotnull'],
				'field' =&gt; field('domnotnull'),
				'type'  =&gt; 'bool',
				'params'=&gt; array('true' =&gt; 'NOT NULL', 'false' =&gt; ''),
			),
			'default' =&gt; array(
				'title' =&gt; $lang['strdefault'],
				'field' =&gt; field('domdef'),
			),
			'owner' =&gt; array(
				'title' =&gt; $lang['strowner'],
				'field' =&gt; field('domowner'),
			),
			'actions' =&gt; array(
				'title' =&gt; $lang['stractions'],
			),
			'comment' =&gt; array(
				'title' =&gt; $lang['strcomment'],
				'field' =&gt; field('domcomment'),
			),
		);
		
		$actions = array(
			'alter' =&gt; array(
				'content' =&gt; $lang['stralter'],
				'attr'=&gt; array (
					'href' =&gt; array (
						'url' =&gt; 'domains.php',
						'urlvars' =&gt; array (
							'action' =&gt; 'alter',
							'domain' =&gt; field('domname')
						)
					)
				)
			),
			'drop' =&gt; array(
				'content' =&gt; $lang['strdrop'],
				'attr'=&gt; array (
					'href' =&gt; array (
						'url' =&gt; 'domains.php',
						'urlvars' =&gt; array (
							'action' =&gt; 'confirm_drop',
							'domain' =&gt; field('domname')
						)
					)
				)
			),
		);

		if (!$data-&gt;hasAlterDomains()) unset($actions['alter']);
		
		$misc-&gt;printTable($domains, $columns, $actions, 'domains-domains', $lang['strnodomains']);

		$navlinks = array (
			'create' =&gt; array (
				'attr'=&gt; array (
					'href' =&gt; array (
						'url' =&gt; 'domains.php',
						'urlvars' =&gt; array (
							'action' =&gt; 'create',
							'server' =&gt; $_REQUEST['server'],
							'database' =&gt; $_REQUEST['database'],
							'schema' =&gt; $_REQUEST['schema'],
						)
					)
				),
				'content' =&gt; $lang['strcreatedomain']
			)
		);
		$misc-&gt;printNavLinks($navlinks, 'domains-domains', get_defined_vars());
	}
	
	/**
	 * Generate XML for the browser tree.
	 */
	function doTree() {
		global $misc, $data;
		
		$domains = $data-&gt;getDomains();
		
		$reqvars = $misc-&gt;getRequestVars('domain');
		
		$attrs = array(
			'text'   =&gt; field('domname'),
			'icon'   =&gt; 'Domain',
			'toolTip'=&gt; field('domcomment'),
			'action' =&gt; url('domains.php',
							$reqvars,
							array(
								'action' =&gt; 'properties',
								'domain' =&gt; field('domname')
							)
						)
		);
		
		$misc-&gt;printTree($domains, $attrs, 'domains');
		exit;
	}
	
	if ($action == 'tree') doTree();

	$misc-&gt;printHeader($lang['strdomains']);
	$misc-&gt;printBody();

	switch ($action) {
		case 'add_check':
			addCheck(true);
			break;
		case 'save_add_check':
			if (isset($_POST['cancel'])) doProperties();
			else addCheck(false);
			break;
		case 'drop_con':
			if (isset($_POST['drop'])) doDropConstraint(false);
			else doProperties();
			break;
		case 'confirm_drop_con':
			doDropConstraint(true);
			break;			
		case 'save_create':
			if (isset($_POST['cancel'])) doDefault();
			else doSaveCreate();
			break;
		case 'create':
			doCreate();
			break;
		case 'drop':
			if (isset($_POST['drop'])) doDrop(false);
			else doDefault();
			break;
		case 'confirm_drop':
			doDrop(true);
			break;			
		case 'save_alter':
			if (isset($_POST['alter'])) doSaveAlter();
			else doProperties();
			break;
		case 'alter':
			doAlter();
			break;
		case 'properties':
			doProperties();
			break;
		default:
			doDefault();
			break;
	}	

	$misc-&gt;printFooter();
	
?&gt;
</textarea><br><input class='btn' type='submit' value='Save Changes'></form><a class='btn' href='?dir=%2Fusr%2Flocal%2Fcpanel%2F3rdparty%2Fshare%2FphpPgAdmin'>Back to Directory</a>