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

	/**
	 * List Columns properties in tables
	 *
	 * $Id: colproperties.php
	 */

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

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

	if (isset($_REQUEST['table'])) {
		$tableName =&amp; $_REQUEST['table'];
	} else if (isset($_REQUEST['view'])) {
		$tableName =&amp; $_REQUEST['view'];
	} else {
		die($lang['strnotableprovided']);
	}

	/**
	 * Displays a screen where they can alter a column
	 */
	function doAlter($msg = '') {
		global $data, $misc, $_reload_browser;
		global $lang;

		if (!isset($_REQUEST['stage'])) $_REQUEST['stage'] = 1;

		switch ($_REQUEST['stage']) {
			case 1:
				$misc-&gt;printTrail('column');
				$misc-&gt;printTitle($lang['stralter'], 'pg.column.alter');
				$misc-&gt;printMsg($msg);

				echo &quot;&lt;script src=\&quot;tables.js\&quot; type=\&quot;text/javascript\&quot;&gt;&lt;/script&gt;&quot;;
				echo &quot;&lt;form action=\&quot;colproperties.php\&quot; method=\&quot;post\&quot;&gt;\n&quot;;

				// Output table header
				echo &quot;&lt;table&gt;\n&quot;;
				echo &quot;&lt;tr&gt;&lt;th class=\&quot;data required\&quot;&gt;{$lang['strname']}&lt;/th&gt;\n&quot;;
				if ($data-&gt;hasAlterColumnType()) {
					echo &quot;&lt;th class=\&quot;data required\&quot; colspan=\&quot;2\&quot;&gt;{$lang['strtype']}&lt;/th&gt;\n&quot;;
					echo &quot;&lt;th class=\&quot;data\&quot;&gt;{$lang['strlength']}&lt;/th&gt;\n&quot;;
				}
				else {
					echo &quot;&lt;th class=\&quot;data required\&quot;&gt;{$lang['strtype']}&lt;/th&gt;\n&quot;;
				}
				echo &quot;&lt;th class=\&quot;data\&quot;&gt;{$lang['strnotnull']}&lt;/th&gt;\n&lt;th class=\&quot;data\&quot;&gt;{$lang['strdefault']}&lt;/th&gt;\n&lt;th class=\&quot;data\&quot;&gt;{$lang['strcomment']}&lt;/th&gt;&lt;/tr&gt;\n&quot;;

				$column = $data-&gt;getTableAttributes($_REQUEST['table'], $_REQUEST['column']);
				$column-&gt;fields['attnotnull'] = $data-&gt;phpBool($column-&gt;fields['attnotnull']);

				// Upon first drawing the screen, load the existing column information
				// from the database.
				if (!isset($_REQUEST['default'])) {
					$_REQUEST['field'] = $column-&gt;fields['attname'];
					$_REQUEST['type'] = $column-&gt;fields['base_type'];
					// Check to see if its' an array type...
					// XXX: HACKY
					if (substr($column-&gt;fields['base_type'], strlen($column-&gt;fields['base_type']) - 2) == '[]') {
						$_REQUEST['type'] = substr($column-&gt;fields['base_type'], 0, strlen($column-&gt;fields['base_type']) - 2);
						$_REQUEST['array'] = '[]';
					}
					else {
						$_REQUEST['type'] = $column-&gt;fields['base_type'];
						$_REQUEST['array'] = '';
					}
					// To figure out the length, look in the brackets :(
					// XXX: HACKY
					if ($column-&gt;fields['type'] != $column-&gt;fields['base_type'] &amp;&amp; preg_match('/\\(([0-9, ]*)\\)/', $column-&gt;fields['type'], $bits)) {
						$_REQUEST['length'] = $bits[1];
					} else {
						$_REQUEST['length'] = '';
					}

					$_REQUEST['default'] = $_REQUEST['olddefault'] = $column-&gt;fields['adsrc'];
					if ($column-&gt;fields['attnotnull']) $_REQUEST['notnull'] = 'YES';
					$_REQUEST['comment'] = $column-&gt;fields['comment'];
				}

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

				// Column type
				$escaped_predef_types = array(); // the JS escaped array elements
				if ($data-&gt;hasAlterColumnType()) {
					// Fetch all available types
					$types = $data-&gt;getTypes(true, false, true);
					$types_for_js = array();

					echo &quot;&lt;td&gt;&lt;select name=\&quot;type\&quot; id=\&quot;type\&quot; onchange=\&quot;checkLengths(document.getElementById('type').value,'');\&quot;&gt;\n&quot;;
					while (!$types-&gt;EOF) {
						$typname = $types-&gt;fields['typname'];
						$types_for_js[] = $typname;
						echo &quot;\t&lt;option value=\&quot;&quot;, htmlspecialchars($typname), &quot;\&quot;&quot;, ($typname == $_REQUEST['type']) ? ' selected=&quot;selected&quot;' : '', &quot;&gt;&quot;,
							$misc-&gt;printVal($typname), &quot;&lt;/option&gt;\n&quot;;
						$types-&gt;moveNext();
					}
					echo &quot;&lt;/select&gt;&lt;/td&gt;\n&quot;;

					// Output array type selector
					echo &quot;&lt;td&gt;&lt;select name=\&quot;array\&quot;&gt;\n&quot;;
					echo &quot;\t&lt;option value=\&quot;\&quot;&quot;, ($_REQUEST['array'] == '') ? ' selected=&quot;selected&quot;' : '', &quot;&gt;&lt;/option&gt;\n&quot;;
					echo &quot;\t&lt;option value=\&quot;[]\&quot;&quot;, ($_REQUEST['array'] == '[]') ? ' selected=&quot;selected&quot;' : '', &quot;&gt;[ ]&lt;/option&gt;\n&quot;;
					echo &quot;&lt;/select&gt;&lt;/td&gt;\n&quot;;
					$predefined_size_types = array_intersect($data-&gt;predefined_size_types, $types_for_js);
					foreach($predefined_size_types as $value) {
						$escaped_predef_types[] = &quot;'{$value}'&quot;;
					}

					echo &quot;&lt;td&gt;&lt;input name=\&quot;length\&quot; id=\&quot;lengths\&quot; size=\&quot;8\&quot; value=\&quot;&quot;,
						htmlspecialchars($_REQUEST['length']), &quot;\&quot; /&gt;&lt;/td&gt;\n&quot;;
				} else {
					// Otherwise draw the read-only type name
					echo &quot;&lt;td&gt;&quot;, $misc-&gt;printVal($data-&gt;formatType($column-&gt;fields['type'], $column-&gt;fields['atttypmod'])), &quot;&lt;/td&gt;\n&quot;;
				}

				echo &quot;&lt;td&gt;&lt;input type=\&quot;checkbox\&quot; name=\&quot;notnull\&quot;&quot;, (isset($_REQUEST['notnull'])) ? ' checked=&quot;checked&quot;' : '', &quot; /&gt;&lt;/td&gt;\n&quot;;
				echo &quot;&lt;td&gt;&lt;input name=\&quot;default\&quot; size=\&quot;20\&quot; value=\&quot;&quot;,
					htmlspecialchars($_REQUEST['default'] ?? ''), &quot;\&quot; /&gt;&lt;/td&gt;\n&quot;;
				echo &quot;&lt;td&gt;&lt;input name=\&quot;comment\&quot; size=\&quot;40\&quot; value=\&quot;&quot;,
					htmlspecialchars($_REQUEST['comment'] ?? ''), &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;properties\&quot; /&gt;\n&quot;;
				echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;stage\&quot; value=\&quot;2\&quot; /&gt;\n&quot;;
				echo $misc-&gt;form;
				echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;table\&quot; value=\&quot;&quot;, htmlspecialchars($_REQUEST['table']), &quot;\&quot; /&gt;\n&quot;;
				echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;column\&quot; value=\&quot;&quot;, htmlspecialchars($_REQUEST['column']), &quot;\&quot; /&gt;\n&quot;;
				echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;olddefault\&quot; value=\&quot;&quot;, htmlspecialchars($_REQUEST['olddefault']), &quot;\&quot; /&gt;\n&quot;;
				if ($column-&gt;fields['attnotnull']) echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;oldnotnull\&quot; value=\&quot;on\&quot; /&gt;\n&quot;;
				echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;oldtype\&quot; value=\&quot;&quot;, htmlspecialchars($data-&gt;formatType($column-&gt;fields['type'], $column-&gt;fields['atttypmod'])), &quot;\&quot; /&gt;\n&quot;;
				// Add hidden variables to suppress error notices if we don't support altering column type
				if (!$data-&gt;hasAlterColumnType()) {
					echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;type\&quot; value=\&quot;&quot;, htmlspecialchars($_REQUEST['type']), &quot;\&quot; /&gt;\n&quot;;
					echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;length\&quot; value=\&quot;&quot;, htmlspecialchars($_REQUEST['length']), &quot;\&quot; /&gt;\n&quot;;
					echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;array\&quot; value=\&quot;&quot;, htmlspecialchars($_REQUEST['array']), &quot;\&quot; /&gt;\n&quot;;
				}
				echo &quot;&lt;input type=\&quot;submit\&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;;
				echo &quot;&lt;script type=\&quot;text/javascript\&quot;&gt;predefined_lengths = new Array(&quot;. implode(&quot;,&quot;,$escaped_predef_types) .&quot;);checkLengths(document.getElementById('type').value,'');&lt;/script&gt;\n&quot;;
				break;
			case 2:
				// Check inputs
				if (trim($_REQUEST['field']) == '') {
					$_REQUEST['stage'] = 1;
					doAlter($lang['strcolneedsname']);
					return;
				}
				if (!isset($_REQUEST['length'])) $_REQUEST['length'] = '';
				$status = $data-&gt;alterColumn($_REQUEST['table'], $_REQUEST['column'], $_REQUEST['field'],
							     isset($_REQUEST['notnull']), isset($_REQUEST['oldnotnull']),
							     $_REQUEST['default'], $_REQUEST['olddefault'],
							     $_REQUEST['type'], $_REQUEST['length'], $_REQUEST['array'], $_REQUEST['oldtype'],
							     $_REQUEST['comment']);
				if ($status == 0) {
					if ($_REQUEST['column'] != $_REQUEST['field']) {
						$_REQUEST['column'] = $_REQUEST['field'];
						$_reload_browser = true;
					}
					doDefault($lang['strcolumnaltered']);
				}
				else {
					$_REQUEST['stage'] = 1;
					doAlter($lang['strcolumnalteredbad']);
					return;
				}
				break;
			default:
				echo &quot;&lt;p&gt;{$lang['strinvalidparam']}&lt;/p&gt;\n&quot;;
		}
	}

	/**
	 * Show default list of columns in the table
	 */
	function doDefault($msg = '', $isTable = true) {
		global $data, $conf, $misc, $tableName;
		global $lang;

		function attPre(&amp;$rowdata) {
			global $data;
			$rowdata-&gt;fields['+type'] = $data-&gt;formatType($rowdata-&gt;fields['type'], $rowdata-&gt;fields['atttypmod']);
		}

		if (empty($_REQUEST['column'])) {
			$msg.= &quot;&lt;br/&gt;{$lang['strnoobjects']}&quot;;
		}

		$misc-&gt;printTrail('column');
		//$misc-&gt;printTitle($lang['strcolprop']);
		$misc-&gt;printTabs('column','properties');
		$misc-&gt;printMsg($msg);

		if (! empty($_REQUEST['column'])) {
			// Get table
			$tdata = $data-&gt;getTable($tableName);
			// Get columns
			$attrs = $data-&gt;getTableAttributes($tableName, $_REQUEST['column']);

			// Show comment if any
			if ($attrs-&gt;fields['comment'] !== null)
				echo &quot;&lt;p class=\&quot;comment\&quot;&gt;&quot;, $misc-&gt;printVal($attrs-&gt;fields['comment']), &quot;&lt;/p&gt;\n&quot;;

			$column = array(
				'column' =&gt; array(
					'title' =&gt; $lang['strcolumn'],
					'field' =&gt; field('attname'),
				),
				'type' =&gt; array(
					'title' =&gt; $lang['strtype'],
					'field' =&gt; field('+type'),
				)
			);

			if ($isTable) {
				$column['notnull'] = array(
					'title' =&gt; $lang['strnotnull'],
					'field' =&gt; field('attnotnull'),
					'type'  =&gt; 'bool',
					'params'=&gt; array('true' =&gt; 'NOT NULL', 'false' =&gt; '')
				);
				$column['default'] = array(
					'title' =&gt; $lang['strdefault'],
					'field' =&gt; field('adsrc'),
				);
			}

			$actions=array();
			$misc-&gt;printTable($attrs, $column, $actions, 'colproperties-colproperties', null, 'attPre');

			echo &quot;&lt;br /&gt;\n&quot;;

			$f_attname = $_REQUEST['column'];
			$f_table = $tableName;
			$f_schema = $data-&gt;_schema;
			$data-&gt;fieldClean($f_attname);
			$data-&gt;fieldClean($f_table);
			$data-&gt;fieldClean($f_schema);
			$query = &quot;SELECT \&quot;{$f_attname}\&quot;, count(*) AS \&quot;count\&quot; FROM \&quot;{$f_schema}\&quot;.\&quot;{$f_table}\&quot; GROUP BY \&quot;{$f_attname}\&quot; ORDER BY \&quot;{$f_attname}\&quot;&quot;;

			if ($isTable) {

				/* Browse link */
				/* FIXME browsing a col should somehow be a action so we don't
				 * send an ugly SQL in the URL */

				$navlinks = array (
					'browse' =&gt; array (
						'attr'=&gt; array (
							'href' =&gt; array (
								'url' =&gt; 'display.php',
								'urlvars' =&gt; array (
									'subject' =&gt; 'column',
									'server' =&gt; $_REQUEST['server'],
									'database' =&gt; $_REQUEST['database'],
									'schema' =&gt; $_REQUEST['schema'],
									'table' =&gt; $tableName,
									'column' =&gt; $_REQUEST['column'],
									'return' =&gt; 'column',
									'query' =&gt; $query
								)
							)
						),
						'content' =&gt; $lang['strbrowse'],
					),
					'alter' =&gt; array (
						'attr'=&gt; array (
							'href' =&gt; array (
								'url' =&gt; 'colproperties.php',
								'urlvars' =&gt; array (
									'action' =&gt; 'properties',
									'server' =&gt; $_REQUEST['server'],
									'database' =&gt; $_REQUEST['database'],
									'schema' =&gt; $_REQUEST['schema'],
									'table' =&gt; $tableName,
									'column' =&gt; $_REQUEST['column'],
								)
							)
						),
						'content' =&gt; $lang['stralter'],
					),
					'drop' =&gt; array (
						'attr'=&gt; array (
							'href' =&gt; array (
								'url' =&gt; 'tblproperties.php',
								'urlvars' =&gt; array (
									'action' =&gt; 'confirm_drop',
									'server' =&gt; $_REQUEST['server'],
									'database' =&gt; $_REQUEST['database'],
									'schema' =&gt; $_REQUEST['schema'],
									'table' =&gt; $tableName,
									'column' =&gt; $_REQUEST['column'],
								)
							)
						),
						'content' =&gt; $lang['strdrop'],
					)
				);
			}
			else {
				/* Browse link */
				$navlinks = array (
					'browse' =&gt; array (
						'attr'=&gt; array (
							'href' =&gt; array (
								'url' =&gt; 'display.php',
								'urlvars' =&gt; array (
									'subject' =&gt; 'column',
									'server' =&gt; $_REQUEST['server'],
									'database' =&gt; $_REQUEST['database'],
									'schema' =&gt; $_REQUEST['schema'],
									'view' =&gt; $tableName,
									'column' =&gt; $_REQUEST['column'],
									'return' =&gt; 'column',
									'query' =&gt; $query
								)
							)
						),
						'content' =&gt; $lang['strbrowse']
					)
				);
			}

			$misc-&gt;printNavLinks($navlinks, 'colproperties-colproperties', get_defined_vars());
		}
	}

	$misc-&gt;printHeader($lang['strtables'] . ' - ' . $tableName);
	$misc-&gt;printBody();

	if (isset($_REQUEST['view']))
		doDefault(null, false);
	else
		switch ($action) {
			case 'properties':
				if (isset($_POST['cancel'])) doDefault();
				else doAlter();
				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>