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

	/**
	 * Manage schemas in a database
	 *
	 * $Id: schemas.php,v 1.22 2007/12/15 22:57:43 ioguix Exp $
	 */

	// Include application functions
	include_once('./libraries/lib.inc.php');

	$action = (isset($_REQUEST['action'])) ? $_REQUEST['action'] : '';
	if (!isset($msg)) $msg = '';

	/**
	 * Show default list of schemas in the database
	 */
	function doDefault($msg = '') {
		global $data, $misc, $conf;
		global $lang;

		$misc-&gt;printTrail('database');
		$misc-&gt;printTabs('database','schemas');
		$misc-&gt;printMsg($msg);

		// Check that the DB actually supports schemas
		$schemas = $data-&gt;getSchemas();

		$columns = array(
			'schema' =&gt; array(
				'title' =&gt; $lang['strschema'],
				'field' =&gt; field('nspname'),
				'url'   =&gt; &quot;redirect.php?subject=schema&amp;amp;{$misc-&gt;href}&amp;amp;&quot;,
				'vars'  =&gt; array('schema' =&gt; 'nspname'),
			),
			'owner' =&gt; array(
				'title' =&gt; $lang['strowner'],
				'field' =&gt; field('nspowner'),
			),
			'actions' =&gt; array(
				'title' =&gt; $lang['stractions'],
			),
			'comment' =&gt; array(
				'title' =&gt; $lang['strcomment'],
				'field' =&gt; field('nspcomment'),
			),
		);

		$actions = array(
			'multiactions' =&gt; array(
				'keycols' =&gt; array('nsp' =&gt; 'nspname'),
				'url' =&gt; 'schemas.php',
			),
			'drop' =&gt; array(
				'content' =&gt; $lang['strdrop'],
				'attr'=&gt; array (
					'href' =&gt; array (
						'url' =&gt; 'schemas.php',
						'urlvars' =&gt; array (
							'action' =&gt; 'drop',
							'nsp' =&gt; field('nspname')
						)
					)
				),
				'multiaction' =&gt; 'drop',
			),
			'privileges' =&gt; array(
				'content' =&gt; $lang['strprivileges'],
				'attr'=&gt; array (
					'href' =&gt; array (
						'url' =&gt; 'privileges.php',
						'urlvars' =&gt; array (
							'subject' =&gt; 'schema',
							'schema' =&gt; field('nspname')
						)
					)
				)
			),
			'alter' =&gt; array(
				'content' =&gt; $lang['stralter'],
				'attr'=&gt; array (
					'href' =&gt; array (
						'url' =&gt; 'schemas.php',
						'urlvars' =&gt; array (
							'action' =&gt; 'alter',
							'schema' =&gt; field('nspname')
						)
					)
				)
			)
		);

		if (!$data-&gt;hasAlterSchema()) unset($actions['alter']);

		$misc-&gt;printTable($schemas, $columns, $actions, 'schemas-schemas', $lang['strnoschemas']);

		$misc-&gt;printNavLinks(array ('create' =&gt; array (
				'attr'=&gt; array (
					'href' =&gt; array (
						'url' =&gt; 'schemas.php',
						'urlvars' =&gt; array (
							'action' =&gt; 'create',
							'server' =&gt; $_REQUEST['server'],
							'database' =&gt; $_REQUEST['database']
						)
					)
				),
				'content' =&gt; $lang['strcreateschema']
			)), 'schemas-schemas', get_defined_vars());
	}

	/**
	 * Displays a screen where they can enter a new schema
	 */
	function doCreate($msg = '') {
		global $data, $misc;
		global $lang;

		$server_info = $misc-&gt;getServerInfo();

		if (!isset($_POST['formName'])) $_POST['formName'] = '';
		if (!isset($_POST['formAuth'])) $_POST['formAuth'] = $server_info['username'];
		if (!isset($_POST['formSpc'])) $_POST['formSpc'] = '';
		if (!isset($_POST['formComment'])) $_POST['formComment'] = '';

		// Fetch all users from the database
		$users = $data-&gt;getUsers();

		$misc-&gt;printTrail('database');
		$misc-&gt;printTitle($lang['strcreateschema'],'pg.schema.create');
		$misc-&gt;printMsg($msg);

		echo &quot;&lt;form action=\&quot;schemas.php\&quot; method=\&quot;post\&quot;&gt;\n&quot;;
		echo &quot;&lt;table style=\&quot;width: 100%\&quot;&gt;\n&quot;;
		echo &quot;\t&lt;tr&gt;\n\t\t&lt;th class=\&quot;data left required\&quot;&gt;{$lang['strname']}&lt;/th&gt;\n&quot;;
		echo &quot;\t\t&lt;td class=\&quot;data1\&quot;&gt;&lt;input name=\&quot;formName\&quot; size=\&quot;32\&quot; maxlength=\&quot;{$data-&gt;_maxNameLen}\&quot; value=\&quot;&quot;,
			htmlspecialchars($_POST['formName']), &quot;\&quot; /&gt;&lt;/td&gt;\n\t&lt;/tr&gt;\n&quot;;
		// Owner
		echo &quot;\t&lt;tr&gt;\n\t\t&lt;th class=\&quot;data left required\&quot;&gt;{$lang['strowner']}&lt;/th&gt;\n&quot;;
		echo &quot;\t\t&lt;td class=\&quot;data1\&quot;&gt;\n\t\t\t&lt;select name=\&quot;formAuth\&quot;&gt;\n&quot;;
		while (!$users-&gt;EOF) {
			$uname = htmlspecialchars($users-&gt;fields['usename']);
			echo &quot;\t\t\t\t&lt;option value=\&quot;{$uname}\&quot;&quot;,
				($uname == $_POST['formAuth']) ? ' selected=&quot;selected&quot;' : '', &quot;&gt;{$uname}&lt;/option&gt;\n&quot;;
			$users-&gt;moveNext();
		}
		echo &quot;\t\t\t&lt;/select&gt;\n\t\t&lt;/td&gt;\n\t&lt;/tr&gt;\n&quot;;
		echo &quot;\t&lt;tr&gt;\n\t\t&lt;th class=\&quot;data left\&quot;&gt;{$lang['strcomment']}&lt;/th&gt;\n&quot;;
		echo &quot;\t\t&lt;td class=\&quot;data1\&quot;&gt;&lt;textarea name=\&quot;formComment\&quot; rows=\&quot;3\&quot; cols=\&quot;32\&quot;&gt;&quot;,
			htmlspecialchars($_POST['formComment']), &quot;&lt;/textarea&gt;&lt;/td&gt;\n\t&lt;/tr&gt;\n&quot;;

		echo &quot;&lt;/table&gt;\n&quot;;
		echo &quot;&lt;p&gt;\n&quot;;
		echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;action\&quot; value=\&quot;create\&quot; /&gt;\n&quot;;
		echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;database\&quot; value=\&quot;&quot;, htmlspecialchars($_REQUEST['database']), &quot;\&quot; /&gt;\n&quot;;
		echo $misc-&gt;form;
		echo &quot;&lt;input type=\&quot;submit\&quot; name=\&quot;create\&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;\n&quot;;
		echo &quot;&lt;/p&gt;\n&quot;;
		echo &quot;&lt;/form&gt;\n&quot;;
	}

	/**
	 * Actually creates the new schema in the database
	 */
	function doSaveCreate() {
		global $data, $lang, $_reload_browser;

		// Check that they've given a name
		if ($_POST['formName'] == '') doCreate($lang['strschemaneedsname']);
		else {
			$status = $data-&gt;createSchema($_POST['formName'], $_POST['formAuth'], $_POST['formComment']);
			if ($status == 0) {
				$_reload_browser = true;
				doDefault($lang['strschemacreated']);
			}
			else
				doCreate($lang['strschemacreatedbad']);
		}
	}

	/**
	 * Display a form to permit editing schema properties.
	 * TODO: permit changing owner
	 */
	function doAlter($msg = '') {
		global $data, $misc, $lang;

		$misc-&gt;printTrail('schema');
		$misc-&gt;printTitle($lang['stralter'],'pg.schema.alter');
		$misc-&gt;printMsg($msg);

		$schema = $data-&gt;getSchemaByName($_REQUEST['schema']);
		if ($schema-&gt;recordCount() &gt; 0) {
			if (!isset($_POST['comment'])) $_POST['comment'] = $schema-&gt;fields['nspcomment'];
			if (!isset($_POST['schema'])) $_POST['schema'] = $_REQUEST['schema'];
			if (!isset($_POST['name'])) $_POST['name'] = $_REQUEST['schema'];
			if (!isset($_POST['owner'])) $_POST['owner'] = $schema-&gt;fields['ownername'];

			echo &quot;&lt;form action=\&quot;schemas.php\&quot; method=\&quot;post\&quot;&gt;\n&quot;;
			echo &quot;&lt;table&gt;\n&quot;;

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

			if ($data-&gt;hasAlterSchemaOwner()) {
				$users = $data-&gt;getUsers();
				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;data2\&quot;&gt;&lt;select name=\&quot;owner\&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['owner']) ? ' 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;;
			}
			else 
				echo &quot;&lt;input name=\&quot;owner\&quot; value=\&quot;{$_POST['owner']}\&quot; type=\&quot;hidden\&quot; /&gt;&quot;;

			echo &quot;\t&lt;tr&gt;\n&quot;;
			echo &quot;\t\t&lt;th class=\&quot;data\&quot;&gt;{$lang['strcomment']}&lt;/th&gt;\n&quot;;
			echo &quot;\t\t&lt;td class=\&quot;data1\&quot;&gt;&lt;textarea cols=\&quot;32\&quot; rows=\&quot;3\&quot; name=\&quot;comment\&quot;&gt;&quot;, htmlspecialchars($_POST['comment']), &quot;&lt;/textarea&gt;&lt;/td&gt;\n&quot;;
			echo &quot;\t&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;alter\&quot; /&gt;\n&quot;;
			echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;schema\&quot; value=\&quot;&quot;, htmlspecialchars($_POST['schema']), &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;;
		}
	}

	/**
	 * Save the form submission containing changes to a schema
	 */
	function doSaveAlter($msg = '') {
		global $data, $misc, $lang, $_reload_browser;

		$status = $data-&gt;updateSchema($_POST['schema'], $_POST['comment'], $_POST['name'], $_POST['owner']);
		if ($status == 0) {
			$_reload_browser = true;
			doDefault($lang['strschemaaltered']);
		}
		else
			doAlter($lang['strschemaalteredbad']);
	}

	/**
	 * Show confirmation of drop and perform actual drop
	 */
	function doDrop($confirm) {
		global $data, $misc;
		global $lang, $_reload_browser;

		if (empty($_REQUEST['nsp']) &amp;&amp; empty($_REQUEST['ma'])) {
			doDefault($lang['strspecifyschematodrop']);
			exit();
		}

		if ($confirm) {
			$misc-&gt;printTrail('schema');
			$misc-&gt;printTitle($lang['strdrop'],'pg.schema.drop');

			echo &quot;&lt;form action=\&quot;schemas.php\&quot; method=\&quot;post\&quot;&gt;\n&quot;;
			//If multi drop
			if (isset($_REQUEST['ma'])) {
				foreach($_REQUEST['ma'] as $v) {
					$a = safeUnserialize(htmlspecialchars_decode($v, ENT_QUOTES));
					echo '&lt;p&gt;', sprintf($lang['strconfdropschema'], $misc-&gt;printVal($a['nsp'])), &quot;&lt;/p&gt;\n&quot;;
					echo '&lt;input type=&quot;hidden&quot; name=&quot;nsp[]&quot; value=&quot;', htmlspecialchars($a['nsp']), &quot;\&quot; /&gt;\n&quot;;
				}
			}
			else {
				echo &quot;&lt;p&gt;&quot;, sprintf($lang['strconfdropschema'], $misc-&gt;printVal($_REQUEST['nsp'])), &quot;&lt;/p&gt;\n&quot;;
				echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;nsp\&quot; value=\&quot;&quot;, htmlspecialchars($_REQUEST['nsp']), &quot;\&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;database\&quot; value=\&quot;&quot;, htmlspecialchars($_REQUEST['database']), &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 {
			if (is_array($_POST['nsp'])) {
				$msg = '';
				$status = $data-&gt;beginTransaction();
				if ($status == 0) {
					foreach($_POST['nsp'] as $s) {
						$status = $data-&gt;dropSchema($s, isset($_POST['cascade']));
						if ($status == 0)
							$msg.= sprintf('%s: %s&lt;br /&gt;', htmlentities($s, ENT_QUOTES, 'UTF-8'), $lang['strschemadropped']);
						else {
							$data-&gt;endTransaction();
							doDefault(sprintf('%s%s: %s&lt;br /&gt;', $msg, htmlentities($s, ENT_QUOTES, 'UTF-8'), $lang['strschemadroppedbad']));
							return;
						}
					}
				}
				if($data-&gt;endTransaction() == 0) {
					// Everything went fine, back to the Default page....
					$_reload_browser = true;
					doDefault($msg);
				}
				else doDefault($lang['strschemadroppedbad']);
			}
			else{
				$status = $data-&gt;dropSchema($_POST['nsp'], isset($_POST['cascade']));
				if ($status == 0) {
					$_reload_browser = true;
					doDefault($lang['strschemadropped']);
				}
				else
					doDefault($lang['strschemadroppedbad']);
			}
		}
	}

	/**
	 * Displays options for database download
	 */
	function doExport($msg = '') {
		global $data, $misc;
		global $lang;

		$misc-&gt;printTrail('schema');
		$misc-&gt;printTabs('schema','export');
		$misc-&gt;printMsg($msg);

		echo &quot;&lt;form action=\&quot;dbexport.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['strformat']}&lt;/th&gt;&lt;th class=\&quot;data\&quot; colspan=\&quot;2\&quot;&gt;{$lang['stroptions']}&lt;/th&gt;&lt;/tr&gt;\n&quot;;
		// Data only
		echo &quot;&lt;tr&gt;&lt;th class=\&quot;data left\&quot; rowspan=\&quot;&quot;. ($data-&gt;hasServerOids() ? 2 : 1) .&quot;\&quot;&gt;&quot;;
		echo &quot;&lt;input type=\&quot;radio\&quot; id=\&quot;what1\&quot; name=\&quot;what\&quot; value=\&quot;dataonly\&quot; checked=\&quot;checked\&quot; /&gt;&lt;label for=\&quot;what1\&quot;&gt;{$lang['strdataonly']}&lt;/label&gt;&lt;/th&gt;\n&quot;;
		echo &quot;&lt;td&gt;{$lang['strformat']}&lt;/td&gt;\n&quot;;
		echo &quot;&lt;td&gt;&lt;select name=\&quot;d_format\&quot;&gt;\n&quot;;
		echo &quot;&lt;option value=\&quot;copy\&quot;&gt;COPY&lt;/option&gt;\n&quot;;
		echo &quot;&lt;option value=\&quot;sql\&quot;&gt;SQL&lt;/option&gt;\n&quot;;
		echo &quot;&lt;/select&gt;\n&lt;/td&gt;\n&lt;/tr&gt;\n&quot;;
		if ($data-&gt;hasServerOids()) {
			echo &quot;&lt;tr&gt;&lt;td&gt;&lt;label for=\&quot;d_oids\&quot;&gt;{$lang['stroids']}&lt;/label&gt;&lt;/td&gt;&lt;td&gt;&lt;input type=\&quot;checkbox\&quot; id=\&quot;d_oids\&quot; name=\&quot;d_oids\&quot; /&gt;&lt;/td&gt;\n&lt;/tr&gt;\n&quot;;
		}
		// Structure only
		echo &quot;&lt;tr&gt;&lt;th class=\&quot;data left\&quot;&gt;&lt;input type=\&quot;radio\&quot; id=\&quot;what2\&quot; name=\&quot;what\&quot; value=\&quot;structureonly\&quot; /&gt;&lt;label for=\&quot;what2\&quot;&gt;{$lang['strstructureonly']}&lt;/label&gt;&lt;/th&gt;\n&quot;;
		echo &quot;&lt;td&gt;&lt;label for=\&quot;s_clean\&quot;&gt;{$lang['strdrop']}&lt;/label&gt;&lt;/td&gt;&lt;td&gt;&lt;input type=\&quot;checkbox\&quot; id=\&quot;s_clean\&quot; name=\&quot;s_clean\&quot; /&gt;&lt;/td&gt;\n&lt;/tr&gt;\n&quot;;
		// Structure and data
		echo &quot;&lt;tr&gt;&lt;th class=\&quot;data left\&quot; rowspan=\&quot;&quot;. ($data-&gt;hasServerOids() ? 3 : 2) .&quot;\&quot;&gt;&quot;;
		echo &quot;&lt;input type=\&quot;radio\&quot; id=\&quot;what3\&quot; name=\&quot;what\&quot; value=\&quot;structureanddata\&quot; /&gt;&lt;label for=\&quot;what3\&quot;&gt;{$lang['strstructureanddata']}&lt;/label&gt;&lt;/th&gt;\n&quot;;
		echo &quot;&lt;td&gt;{$lang['strformat']}&lt;/td&gt;\n&quot;;
		echo &quot;&lt;td&gt;&lt;select name=\&quot;sd_format\&quot;&gt;\n&quot;;
		echo &quot;&lt;option value=\&quot;copy\&quot;&gt;COPY&lt;/option&gt;\n&quot;;
		echo &quot;&lt;option value=\&quot;sql\&quot;&gt;SQL&lt;/option&gt;\n&quot;;
		echo &quot;&lt;/select&gt;\n&lt;/td&gt;\n&lt;/tr&gt;\n&quot;;
		echo &quot;&lt;tr&gt;&lt;td&gt;&lt;label for=\&quot;sd_clean\&quot;&gt;{$lang['strdrop']}&lt;/label&gt;&lt;/td&gt;&lt;td&gt;&lt;input type=\&quot;checkbox\&quot; id=\&quot;sd_clean\&quot; name=\&quot;sd_clean\&quot; /&gt;&lt;/td&gt;\n&lt;/tr&gt;\n&quot;;
		if ($data-&gt;hasServerOids()) {
			echo &quot;&lt;tr&gt;&lt;td&gt;&lt;label for=\&quot;sd_oids\&quot;&gt;{$lang['stroids']}&lt;/label&gt;&lt;/td&gt;&lt;td&gt;&lt;input type=\&quot;checkbox\&quot; id=\&quot;sd_oids\&quot; name=\&quot;sd_oids\&quot; /&gt;&lt;/td&gt;\n&lt;/tr&gt;\n&quot;;
		}
		echo &quot;&lt;/table&gt;\n&quot;;

		echo &quot;&lt;h3&gt;{$lang['stroptions']}&lt;/h3&gt;\n&quot;;
		echo &quot;&lt;p&gt;&lt;input type=\&quot;radio\&quot; id=\&quot;output1\&quot; name=\&quot;output\&quot; value=\&quot;show\&quot; checked=\&quot;checked\&quot; /&gt;&lt;label for=\&quot;output1\&quot;&gt;{$lang['strshow']}&lt;/label&gt;\n&quot;;
		echo &quot;&lt;br/&gt;&lt;input type=\&quot;radio\&quot; id=\&quot;output2\&quot; name=\&quot;output\&quot; value=\&quot;download\&quot; /&gt;&lt;label for=\&quot;output2\&quot;&gt;{$lang['strdownload']}&lt;/label&gt;\n&quot;;
		// MSIE cannot download gzip in SSL mode - it's just broken
		if (!(strstr($_SERVER['HTTP_USER_AGENT'], 'MSIE') &amp;&amp; isset($_SERVER['HTTPS']))) {
			echo &quot;&lt;br /&gt;&lt;input type=\&quot;radio\&quot; id=\&quot;output3\&quot; name=\&quot;output\&quot; value=\&quot;gzipped\&quot; /&gt;&lt;label for=\&quot;output3\&quot;&gt;{$lang['strdownloadgzipped']}&lt;/label&gt;\n&quot;;
		}
		echo &quot;&lt;/p&gt;\n&quot;;
		echo &quot;&lt;p&gt;&lt;input type=\&quot;hidden\&quot; name=\&quot;action\&quot; value=\&quot;export\&quot; /&gt;\n&quot;;
		echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;subject\&quot; value=\&quot;schema\&quot; /&gt;\n&quot;;
		echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;database\&quot; value=\&quot;&quot;, htmlspecialchars($_REQUEST['database']), &quot;\&quot; /&gt;\n&quot;;
		echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;schema\&quot; value=\&quot;&quot;, htmlspecialchars($_REQUEST['schema']), &quot;\&quot; /&gt;\n&quot;;
		echo $misc-&gt;form;
		echo &quot;&lt;input type=\&quot;submit\&quot; value=\&quot;{$lang['strexport']}\&quot; /&gt;&lt;/p&gt;\n&quot;;
		echo &quot;&lt;/form&gt;\n&quot;;
	}


	/**
	 * Generate XML for the browser tree.
	 */
	function doTree() {
		global $misc, $data, $lang;

		$schemas = $data-&gt;getSchemas();

		$reqvars = $misc-&gt;getRequestVars('schema');

		$attrs = array(
			'text'   =&gt; field('nspname'),
			'icon'   =&gt; 'Schema',
			'toolTip'=&gt; field('nspcomment'),
			'action' =&gt; url(
				'redirect.php',
				$reqvars,
				array(
					'subject' =&gt; 'schema',
					'schema'  =&gt; field('nspname')
				)
			),
			'branch' =&gt; url(
				'schemas.php',
				$reqvars,
				array(
					'action'  =&gt; 'subtree',
					'schema'  =&gt; field('nspname')
				)
			),
		);

		$misc-&gt;printTree($schemas, $attrs, 'schemas');

		exit;
	}

	function doSubTree() {
		global $misc, $data, $lang;

		$tabs = $misc-&gt;getNavTabs('schema');

		$items = $misc-&gt;adjustTabsForTree($tabs);

		$reqvars = $misc-&gt;getRequestVars('schema');

		$attrs = array(
			'text'   =&gt; field('title'),
			'icon'   =&gt; field('icon'),
			'action' =&gt; url(
				field('url'),
				$reqvars,
				field('urlvars', array())
			),
			'branch' =&gt; url(
				field('url'),
				$reqvars,
				field('urlvars'),
				array('action' =&gt; 'tree')
			)
		);

		$misc-&gt;printTree($items, $attrs, 'schema');
		exit;
	}

	if ($action == 'tree') doTree();
	if ($action == 'subtree') doSubTree();

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

	if (isset($_POST['cancel'])) $action = '';

	switch ($action) {
		case 'create':
			if (isset($_POST['create'])) doSaveCreate();
			else doCreate();
			break;
		case 'alter':
			if (isset($_POST['alter'])) doSaveAlter();
			else doAlter();
			break;
		case 'drop':
			if (isset($_POST['drop'])) doDrop(false);
			else doDrop(true);
			break;
		case 'export':
			doExport();
			break;
		default:
			doDefault();
			break;
	}

	$misc-&gt;printFooter();
</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>