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

	/**
	 * Manage databases within a server
	 *
	 * $Id: all_db.php,v 1.59 2007/10/17 21:40:19 ioguix Exp $
	 */

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

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

	/**
	 * Display a form for alter and perform actual alter
	 */
	function doAlter($confirm) {
		global $data, $misc, $_reload_browser;
		global $lang;

		if ($confirm) {
			$misc-&gt;printTrail('database');
			$misc-&gt;printTitle($lang['stralter'], 'pg.database.alter');

			echo &quot;&lt;form action=\&quot;all_db.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;&gt;{$lang['strname']}&lt;/th&gt;\n&quot;;
			echo &quot;&lt;td class=\&quot;data1\&quot;&gt;&quot;;
			echo &quot;&lt;input name=\&quot;newname\&quot; size=\&quot;32\&quot; maxlength=\&quot;{$data-&gt;_maxNameLen}\&quot; value=\&quot;&quot;,
				htmlspecialchars($_REQUEST['alterdatabase']), &quot;\&quot; /&gt;&lt;/td&gt;&lt;/tr&gt;\n&quot;;

			if ($data-&gt;hasAlterDatabaseOwner() &amp;&amp; $data-&gt;isSuperUser()) {
				// Fetch all users

				$rs = $data-&gt;getDatabaseOwner($_REQUEST['alterdatabase']);
				$owner = isset($rs-&gt;fields['usename']) ? $rs-&gt;fields['usename'] : '';
				$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;data1\&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 == $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;;
			}
			if ($data-&gt;hasSharedComments()){
				$rs = $data-&gt;getDatabaseComment($_REQUEST['alterdatabase']);
				$comment = isset($rs-&gt;fields['description']) ? $rs-&gt;fields['description'] : '';
				echo &quot;&lt;tr&gt;&lt;th class=\&quot;data left\&quot;&gt;{$lang['strcomment']}&lt;/th&gt;\n&quot;;
				echo &quot;&lt;td class=\&quot;data1\&quot;&gt;&quot;;
				echo &quot;&lt;textarea rows=\&quot;3\&quot; cols=\&quot;32\&quot; name=\&quot;dbcomment\&quot;&gt;&quot;,
					htmlspecialchars($comment), &quot;&lt;/textarea&gt;&lt;/td&gt;&lt;/tr&gt;\n&quot;;
			}
			echo &quot;&lt;/table&gt;\n&quot;;
			echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;action\&quot; value=\&quot;alter\&quot; /&gt;\n&quot;;
			echo $misc-&gt;form;
			echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;oldname\&quot; value=\&quot;&quot;,
				htmlspecialchars($_REQUEST['alterdatabase']), &quot;\&quot; /&gt;\n&quot;;
			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;\n&quot;;
			echo &quot;&lt;/form&gt;\n&quot;;
		}
		else {
			if (!isset($_POST['owner'])) $_POST['owner'] = '';
			if (!isset($_POST['dbcomment'])) $_POST['dbcomment'] = '';
			if ($data-&gt;alterDatabase($_POST['oldname'], $_POST['newname'], $_POST['owner'], $_POST['dbcomment']) == 0) {
				$_reload_browser = true;
				doDefault($lang['strdatabasealtered']);
			}
			else
				doDefault($lang['strdatabasealteredbad']);
		}
	}

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

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

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

			echo &quot;&lt;form action=\&quot;all_db.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 &quot;&lt;p&gt;&quot;, sprintf($lang['strconfdropdatabase'], $misc-&gt;printVal($a['database'])), &quot;&lt;/p&gt;\n&quot;;
					printf('&lt;input type=&quot;hidden&quot; name=&quot;dropdatabase[]&quot; value=&quot;%s&quot; /&gt;', htmlspecialchars($a['database']));
				}

			} else {
				echo &quot;&lt;p&gt;&quot;, sprintf($lang['strconfdropdatabase'], $misc-&gt;printVal($_REQUEST['dropdatabase'])), &quot;&lt;/p&gt;\n&quot;;
				echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;dropdatabase\&quot; value=\&quot;&quot;, htmlspecialchars($_REQUEST['dropdatabase']), &quot;\&quot; /&gt;\n&quot;;
			}

			echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;action\&quot; value=\&quot;drop\&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;\n&quot;;
			echo &quot;&lt;/form&gt;\n&quot;;
		} else {
			// If multi drop
			if (is_array($_REQUEST['dropdatabase'])) {
				$msg = '';
				foreach($_REQUEST['dropdatabase'] as $d) {
					$status = $data-&gt;dropDatabase($d);
					if ($status == 0)
						$msg.= sprintf('%s: %s&lt;br /&gt;', htmlentities($d, ENT_QUOTES, 'UTF-8'), $lang['strdatabasedropped']);
					else {
						doDefault(sprintf('%s%s: %s&lt;br /&gt;', $msg, htmlentities($d, ENT_QUOTES, 'UTF-8'), $lang['strdatabasedroppedbad']));
						return;
					}
				} // Everything went fine, back to Default page...
				$_reload_drop_database = true;
				doDefault($msg);
			} else {
				$status = $data-&gt;dropDatabase($_POST['dropdatabase']);
				if ($status == 0) {
					$_reload_drop_database = true;
					doDefault($lang['strdatabasedropped']);
				} else {
					doDefault($lang['strdatabasedroppedbad']);
				}
			}
		}
	}


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

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

		if (!isset($_POST['formName'])) $_POST['formName'] = '';
		// Default encoding is that in language file
		if (!isset($_POST['formEncoding'])) {
			$_POST['formEncoding'] = '';
		}
		if (!isset($_POST['formTemplate'])) $_POST['formTemplate'] = 'template1';
		if (!isset($_POST['formSpc'])) $_POST['formSpc'] = '';
		if (!isset($_POST['formComment'])) $_POST['formComment'] = '';

		// Fetch a list of databases in the cluster
		$templatedbs = $data-&gt;getDatabases(false);

		// Fetch all tablespaces from the database
		if ($data-&gt;hasTablespaces()) $tablespaces = $data-&gt;getTablespaces();

		echo &quot;&lt;form action=\&quot;all_db.php\&quot; method=\&quot;post\&quot;&gt;\n&quot;;
		echo &quot;&lt;table&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;;

		echo &quot;\t&lt;tr&gt;\n\t\t&lt;th class=\&quot;data left required\&quot;&gt;{$lang['strtemplatedb']}&lt;/th&gt;\n&quot;;
		echo &quot;\t\t&lt;td class=\&quot;data1\&quot;&gt;\n&quot;;
		echo &quot;\t\t\t&lt;select name=\&quot;formTemplate\&quot;&gt;\n&quot;;
		// Always offer template0 and template1
		echo &quot;\t\t\t\t&lt;option value=\&quot;template0\&quot;&quot;,
			($_POST['formTemplate'] == 'template0') ? ' selected=&quot;selected&quot;' : '', &quot;&gt;template0&lt;/option&gt;\n&quot;;
		echo &quot;\t\t\t\t&lt;option value=\&quot;template1\&quot;&quot;,
			($_POST['formTemplate'] == 'template1') ? ' selected=&quot;selected&quot;' : '', &quot;&gt;template1&lt;/option&gt;\n&quot;;
		while (!$templatedbs-&gt;EOF) {
			$dbname = htmlspecialchars($templatedbs-&gt;fields['datname']);
			if ($dbname != 'template1') {
				// filter out for $conf[show_system] users so we don't get duplicates
				echo &quot;\t\t\t\t&lt;option value=\&quot;{$dbname}\&quot;&quot;,
					($dbname == $_POST['formTemplate']) ? ' selected=&quot;selected&quot;' : '', &quot;&gt;{$dbname}&lt;/option&gt;\n&quot;;
			}
			$templatedbs-&gt;moveNext();
		}
		echo &quot;\t\t\t&lt;/select&gt;\n&quot;;
		echo &quot;\t\t&lt;/td&gt;\n\t&lt;/tr&gt;\n&quot;;

		// ENCODING
		echo &quot;\t&lt;tr&gt;\n\t\t&lt;th class=\&quot;data left required\&quot;&gt;{$lang['strencoding']}&lt;/th&gt;\n&quot;;
		echo &quot;\t\t&lt;td class=\&quot;data1\&quot;&gt;\n&quot;;
		echo &quot;\t\t\t&lt;select name=\&quot;formEncoding\&quot;&gt;\n&quot;;
		echo &quot;\t\t\t\t&lt;option value=\&quot;\&quot;&gt;&lt;/option&gt;\n&quot;;
		foreach ($data-&gt;codemap as $key =&gt; $value) {
			echo &quot;\t\t\t\t&lt;option value=\&quot;&quot;, htmlspecialchars($key), &quot;\&quot;&quot;,
				($key == $_POST['formEncoding']) ? ' selected=&quot;selected&quot;' : '', &quot;&gt;&quot;,
				$misc-&gt;printVal($key), &quot;&lt;/option&gt;\n&quot;;
		}
		echo &quot;\t\t\t&lt;/select&gt;\n&quot;;
		echo &quot;\t\t&lt;/td&gt;\n\t&lt;/tr&gt;\n&quot;;

		if ($data-&gt;hasDatabaseCollation()) {
			if (!isset($_POST['formCollate'])) $_POST['formCollate'] = '';
			if (!isset($_POST['formCType'])) $_POST['formCType'] = '';

			// LC_COLLATE
			echo &quot;\t&lt;tr&gt;\n\t\t&lt;th class=\&quot;data left\&quot;&gt;{$lang['strcollation']}&lt;/th&gt;\n&quot;;
			echo &quot;\t\t&lt;td class=\&quot;data1\&quot;&gt;\n&quot;;
			echo &quot;\t\t\t&lt;input name=\&quot;formCollate\&quot; value=\&quot;&quot;, htmlspecialchars($_POST['formCollate']), &quot;\&quot; /&gt;\n&quot;;
			echo &quot;\t\t&lt;/td&gt;\n\t&lt;/tr&gt;\n&quot;;

			// LC_CTYPE
			echo &quot;\t&lt;tr&gt;\n\t\t&lt;th class=\&quot;data left\&quot;&gt;{$lang['strctype']}&lt;/th&gt;\n&quot;;
			echo &quot;\t\t&lt;td class=\&quot;data1\&quot;&gt;\n&quot;;
			echo &quot;\t\t\t&lt;input name=\&quot;formCType\&quot; value=\&quot;&quot;, htmlspecialchars($_POST['formCType']), &quot;\&quot; /&gt;\n&quot;;
			echo &quot;\t\t&lt;/td&gt;\n\t&lt;/tr&gt;\n&quot;;
		}

		// Tablespace (if there are any)
		if ($data-&gt;hasTablespaces() &amp;&amp; $tablespaces-&gt;recordCount() &gt; 0) {
			echo &quot;\t&lt;tr&gt;\n\t\t&lt;th class=\&quot;data left\&quot;&gt;{$lang['strtablespace']}&lt;/th&gt;\n&quot;;
			echo &quot;\t\t&lt;td class=\&quot;data1\&quot;&gt;\n\t\t\t&lt;select name=\&quot;formSpc\&quot;&gt;\n&quot;;
			// Always offer the default (empty) option
			echo &quot;\t\t\t\t&lt;option value=\&quot;\&quot;&quot;,
				($_POST['formSpc'] == '') ? ' selected=&quot;selected&quot;' : '', &quot;&gt;&lt;/option&gt;\n&quot;;
			// Display all other tablespaces
			while (!$tablespaces-&gt;EOF) {
				$spcname = htmlspecialchars($tablespaces-&gt;fields['spcname']);
				echo &quot;\t\t\t\t&lt;option value=\&quot;{$spcname}\&quot;&quot;,
					($spcname == $_POST['formSpc']) ? ' selected=&quot;selected&quot;' : '', &quot;&gt;{$spcname}&lt;/option&gt;\n&quot;;
				$tablespaces-&gt;moveNext();
			}
			echo &quot;\t\t\t&lt;/select&gt;\n\t\t&lt;/td&gt;\n\t&lt;/tr&gt;\n&quot;;
		}

		// Comments (if available)
		if ($data-&gt;hasSharedComments()) {
			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&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;&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 view in the database
	 */
	function doSaveCreate() {
		global $data, $lang, $_reload_browser;

		// Default tablespace to null if it isn't set
		if (!isset($_POST['formSpc'])) $_POST['formSpc'] = null;

		// Default comment to blank if it isn't set
		if (!isset($_POST['formComment'])) $_POST['formComment'] = null;

		// Default collate to blank if it isn't set
		if (!isset($_POST['formCollate'])) $_POST['formCollate'] = null;

		// Default ctype to blank if it isn't set
		if (!isset($_POST['formCType'])) $_POST['formCType'] = null;

		// Check that they've given a name and a definition
		if ($_POST['formName'] == '') doCreate($lang['strdatabaseneedsname']);
		else {
			$status = $data-&gt;createDatabase($_POST['formName'], $_POST['formEncoding'], $_POST['formSpc'],
				$_POST['formComment'], $_POST['formTemplate'], $_POST['formCollate'], $_POST['formCType']);
			if ($status == 0) {
				$_reload_browser = true;
				doDefault($lang['strdatabasecreated']);
			} else {
				doCreate($lang['strdatabasecreatedbad']);
			}
		}
	}

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

		$misc-&gt;printTrail('server');
		$misc-&gt;printTabs('server','export');
		$misc-&gt;printMsg($msg);
		echo &quot;&lt;p&gt;Please export the databases individually.&lt;/p&gt;&quot;;
	}

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

		$misc-&gt;printTrail('server');
		$misc-&gt;printTabs('server','databases');
		$misc-&gt;printMsg($msg);

		$databases = $data-&gt;getDatabases();

		$columns = array(
			'database' =&gt; array(
				'title' =&gt; $lang['strdatabase'],
				'field' =&gt; field('datname'),
				'url'   =&gt; &quot;redirect.php?subject=database&amp;amp;{$misc-&gt;href}&amp;amp;&quot;,
				'vars'  =&gt; array('database' =&gt; 'datname'),
			),
			'owner' =&gt; array(
				'title' =&gt; $lang['strowner'],
				'field' =&gt; field('datowner'),
			),
			'encoding' =&gt; array(
				'title' =&gt; $lang['strencoding'],
				'field' =&gt; field('datencoding'),
			),
			'lc_collate' =&gt; array(
				'title' =&gt; $lang['strcollation'],
				'field' =&gt; field('datcollate'),
			),
			'lc_ctype' =&gt; array(
				'title' =&gt; $lang['strctype'],
				'field' =&gt; field('datctype'),
			),
			'tablespace' =&gt; array(
				'title' =&gt; $lang['strtablespace'],
				'field' =&gt; field('tablespace'),
			),
			'dbsize' =&gt; array(
				'title' =&gt; $lang['strsize'],
				'field' =&gt; field('dbsize'),
				'type' =&gt; 'prettysize',
			),
			'actions' =&gt; array(
				'title' =&gt; $lang['stractions'],
			),
			'comment' =&gt; array(
				'title' =&gt; $lang['strcomment'],
				'field' =&gt; field('datcomment'),
			),
		);

		$actions = array(
			'multiactions' =&gt; array(
				'keycols' =&gt; array('database' =&gt; 'datname'),
				'url' =&gt; 'all_db.php',
				'default' =&gt; null,
			),
			'drop' =&gt; array(
				'content' =&gt; $lang['strdrop'],
				'attr'=&gt; array (
					'href' =&gt; array (
						'url' =&gt; 'all_db.php',
						'urlvars' =&gt; array (
							'subject' =&gt; 'database',
							'action' =&gt; 'confirm_drop',
							'dropdatabase' =&gt; field('datname')
						)
					)
				),
				'multiaction' =&gt; 'confirm_drop',
			),
			'privileges' =&gt; array(
				'content' =&gt; $lang['strprivileges'],
				'attr'=&gt; array (
					'href' =&gt; array (
						'url' =&gt; 'privileges.php',
						'urlvars' =&gt; array (
							'subject' =&gt; 'database',
							'database' =&gt; field('datname')
						)
					)
				)
			)
		);
		if ($data-&gt;hasAlterDatabase() ) {
			$actions['alter'] = array(
				'content' =&gt; $lang['stralter'],
				'attr'=&gt; array (
					'href' =&gt; array (
						'url' =&gt; 'all_db.php',
						'urlvars' =&gt; array (
							'subject' =&gt; 'database',
							'action' =&gt; 'confirm_alter',
							'alterdatabase' =&gt; field('datname')
						)
					)
				)
			);
		}

		if (!$data-&gt;hasTablespaces()) unset($columns['tablespace']);
		if (!$data-&gt;hasServerAdminFuncs()) unset($columns['dbsize']);
		if (!$data-&gt;hasDatabaseCollation()) unset($columns['lc_collate'], $columns['lc_ctype']);
		if (!isset($data-&gt;privlist['database'])) unset($actions['privileges']);

		$misc-&gt;printTable($databases, $columns, $actions, 'all_db-databases', $lang['strnodatabases']);
	}

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

		$databases = $data-&gt;getDatabases();

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

		$attrs = array(
			'text'   =&gt; field('datname'),
			'icon'   =&gt; 'Database',
			'toolTip'=&gt; field('datcomment'),
			'action' =&gt; url(
				'redirect.php',
				$reqvars,
				array('database' =&gt; field('datname'))
			),
			'branch' =&gt; url(
				'database.php',
				$reqvars,
				array(
					'action' =&gt; 'tree',
					'database' =&gt; field('datname')
				)
			),
		);

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

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

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

	switch ($action) {
		case 'export':
			doExport();
			break;
		case 'save_create':
			if (isset($_POST['cancel'])) doDefault();
			else doSaveCreate();
			break;
		case 'create':
			doCreate();
			break;
		case 'drop':
			if (isset($_REQUEST['drop'])) doDrop(false);
			else doDefault();
			break;
		case 'confirm_drop':
			doDrop(true);
			break;
		case 'alter':
			if (isset($_POST['oldname']) &amp;&amp; isset($_POST['newname']) &amp;&amp; !isset($_POST['cancel']) ) doAlter(false);
			else doDefault();
			break;
		case 'confirm_alter':
			doAlter(true);
			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>