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

	/**
	 * Manage sequences in a database
	 *
	 * $Id: sequences.php,v 1.49 2007/12/15 22:21:54 ioguix Exp $
	 */

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

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

	/**
	 * Display list of all sequences in the database/schema
	 */
	function doDefault($msg = '')	{
		global $data, $conf, $misc;
		global $lang;

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

		// Get all sequences
		$sequences = $data-&gt;getSequences();

		$columns = array(
			'sequence' =&gt; array(
				'title' =&gt; $lang['strsequence'],
				'field' =&gt; field('seqname'),
				'url'   =&gt; &quot;sequences.php?action=properties&amp;amp;{$misc-&gt;href}&amp;amp;&quot;,
				'vars'  =&gt; array('sequence' =&gt; 'seqname'),
			),
			'owner' =&gt; array(
				'title' =&gt; $lang['strowner'],
				'field' =&gt; field('seqowner'),
			),
			'actions' =&gt; array(
				'title' =&gt; $lang['stractions'],
			),
			'comment' =&gt; array(
				'title' =&gt; $lang['strcomment'],
				'field' =&gt; field('seqcomment'),
			),
		);

		$actions = array(
			'multiactions' =&gt; array(
				'keycols' =&gt; array('sequence' =&gt; 'seqname'),
				'url' =&gt; 'sequences.php',
			),
			'alter' =&gt; array(
				'content' =&gt; $lang['stralter'],
				'attr'=&gt; array (
					'href' =&gt; array (
						'url' =&gt; 'sequences.php',
						'urlvars' =&gt; array (
							'action' =&gt; 'confirm_alter',
							'subject' =&gt; 'sequence',
							'sequence' =&gt; field('seqname')
						)
					)
				)
			),
			'drop' =&gt; array(
				'content' =&gt; $lang['strdrop'],
				'attr'=&gt; array (
					'href' =&gt; array (
						'url' =&gt; 'sequences.php',
						'urlvars' =&gt; array (
							'action' =&gt; 'confirm_drop',
							'sequence' =&gt; field('seqname')
						)
					)
				),
				'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; 'sequence',
							'sequence' =&gt; field('seqname')
						)
					)
				)
			),
		);

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

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

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

		$sequences = $data-&gt;getSequences();

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

		$attrs = array(
			'text'   =&gt; field('seqname'),
			'icon'   =&gt; 'Sequence',
			'toolTip'=&gt; field('seqcomment'),
			'action' =&gt; url('sequences.php',
							$reqvars,
							array (
								'action' =&gt; 'properties',
								'sequence' =&gt; field('seqname')
							)
						)
		);

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

	/**
	 * Display the properties of a sequence
	 */
	function doProperties($msg = '') {
		global $data, $misc;
		global $lang;

		$misc-&gt;printTrail('sequence');
		$misc-&gt;printTitle($lang['strproperties'],'pg.sequence');
		$misc-&gt;printMsg($msg);

		// Fetch the sequence information
		$sequence = $data-&gt;getSequence($_REQUEST['sequence']);

		if (is_object($sequence) &amp;&amp; $sequence-&gt;recordCount() &gt; 0) {
			$sequence-&gt;fields['is_cycled'] = $data-&gt;phpBool($sequence-&gt;fields['is_cycled']);
			$sequence-&gt;fields['is_called'] = $data-&gt;phpBool($sequence-&gt;fields['is_called']);

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

			echo &quot;&lt;table border=\&quot;0\&quot;&gt;&quot;;
			echo &quot;&lt;tr&gt;&lt;th class=\&quot;data\&quot;&gt;{$lang['strname']}&lt;/th&gt;&quot;;
			if ($data-&gt;hasAlterSequenceStart()) {
				echo &quot;&lt;th class=\&quot;data\&quot;&gt;{$lang['strstartvalue']}&lt;/th&gt;&quot;;
			}
			echo &quot;&lt;th class=\&quot;data\&quot;&gt;{$lang['strlastvalue']}&lt;/th&gt;&quot;;
			echo &quot;&lt;th class=\&quot;data\&quot;&gt;{$lang['strincrementby']}&lt;/th&gt;&quot;;
			echo &quot;&lt;th class=\&quot;data\&quot;&gt;{$lang['strmaxvalue']}&lt;/th&gt;&quot;;
			echo &quot;&lt;th class=\&quot;data\&quot;&gt;{$lang['strminvalue']}&lt;/th&gt;&quot;;
			echo &quot;&lt;th class=\&quot;data\&quot;&gt;{$lang['strcachevalue']}&lt;/th&gt;&quot;;
			echo &quot;&lt;th class=\&quot;data\&quot;&gt;{$lang['strlogcount']}&lt;/th&gt;&quot;;
			echo &quot;&lt;th class=\&quot;data\&quot;&gt;{$lang['strcancycle']}&lt;/th&gt;&quot;;
			echo &quot;&lt;th class=\&quot;data\&quot;&gt;{$lang['striscalled']}&lt;/th&gt;&lt;/tr&gt;&quot;;
			echo &quot;&lt;tr&gt;&quot;;
			echo &quot;&lt;td class=\&quot;data1\&quot;&gt;&quot;, $misc-&gt;printVal($sequence-&gt;fields['seqname']), &quot;&lt;/td&gt;&quot;;
			if ($data-&gt;hasAlterSequenceStart()) {
				echo &quot;&lt;td class=\&quot;data1\&quot;&gt;&quot;, $misc-&gt;printVal($sequence-&gt;fields['start_value']), &quot;&lt;/td&gt;&quot;;
			}
			echo &quot;&lt;td class=\&quot;data1\&quot;&gt;&quot;, $misc-&gt;printVal($sequence-&gt;fields['last_value']), &quot;&lt;/td&gt;&quot;;
			echo &quot;&lt;td class=\&quot;data1\&quot;&gt;&quot;, $misc-&gt;printVal($sequence-&gt;fields['increment_by']), &quot;&lt;/td&gt;&quot;;
			echo &quot;&lt;td class=\&quot;data1\&quot;&gt;&quot;, $misc-&gt;printVal($sequence-&gt;fields['max_value']), &quot;&lt;/td&gt;&quot;;
			echo &quot;&lt;td class=\&quot;data1\&quot;&gt;&quot;, $misc-&gt;printVal($sequence-&gt;fields['min_value']), &quot;&lt;/td&gt;&quot;;
			echo &quot;&lt;td class=\&quot;data1\&quot;&gt;&quot;, $misc-&gt;printVal($sequence-&gt;fields['cache_value']), &quot;&lt;/td&gt;&quot;;
			echo &quot;&lt;td class=\&quot;data1\&quot;&gt;&quot;, $misc-&gt;printVal($sequence-&gt;fields['log_cnt']), &quot;&lt;/td&gt;&quot;;
			echo &quot;&lt;td class=\&quot;data1\&quot;&gt;&quot;, ($sequence-&gt;fields['is_cycled'] ? $lang['stryes'] : $lang['strno']), &quot;&lt;/td&gt;&quot;;
			echo &quot;&lt;td class=\&quot;data1\&quot;&gt;&quot;, ($sequence-&gt;fields['is_called'] ? $lang['stryes'] : $lang['strno']), &quot;&lt;/td&gt;&quot;;
			echo &quot;&lt;/tr&gt;&quot;;
			echo &quot;&lt;/table&gt;&quot;;

			$navlinks = array (
				'alter' =&gt; array (
					'attr'=&gt; array (
						'href' =&gt; array (
							'url' =&gt; 'sequences.php',
							'urlvars' =&gt; array (
								'action' =&gt; 'confirm_alter',
								'server' =&gt; $_REQUEST['server'],
								'database' =&gt; $_REQUEST['database'],
								'schema' =&gt; $_REQUEST['schema'],
								'sequence' =&gt; $sequence-&gt;fields['seqname']
							)
						)
					),
					'content' =&gt; $lang['stralter']
				),
				'setval' =&gt; array (
					'attr'=&gt; array (
						'href' =&gt; array (
							'url' =&gt; 'sequences.php',
							'urlvars' =&gt; array (
								'action' =&gt; 'confirm_setval',
								'server' =&gt; $_REQUEST['server'],
								'database' =&gt; $_REQUEST['database'],
								'schema' =&gt; $_REQUEST['schema'],
								'sequence' =&gt; $sequence-&gt;fields['seqname']
							)
						)
					),
					'content' =&gt; $lang['strsetval']
				),
				'nextval' =&gt; array (
					'attr'=&gt; array (
						'href' =&gt; array (
							'url' =&gt; 'sequences.php',
							'urlvars' =&gt; array (
								'action' =&gt; 'nextval',
								'server' =&gt; $_REQUEST['server'],
								'database' =&gt; $_REQUEST['database'],
								'schema' =&gt; $_REQUEST['schema'],
								'sequence' =&gt; $sequence-&gt;fields['seqname']
							)
						)
					),
					'content' =&gt; $lang['strnextval']
				),
				'restart' =&gt; array (
					'attr'=&gt; array (
						'href' =&gt; array (
							'url' =&gt; 'sequences.php',
							'urlvars' =&gt; array (
								'action' =&gt; 'restart',
								'server' =&gt; $_REQUEST['server'],
								'database' =&gt; $_REQUEST['database'],
								'schema' =&gt; $_REQUEST['schema'],
								'sequence' =&gt; $sequence-&gt;fields['seqname']
							)
						)
					),
					'content' =&gt; $lang['strrestart']
				),
				'reset' =&gt; array (
					'attr'=&gt; array (
						'href' =&gt; array (
							'url' =&gt; 'sequences.php',
							'urlvars' =&gt; array (
								'action' =&gt; 'reset',
								'server' =&gt; $_REQUEST['server'],
								'database' =&gt; $_REQUEST['database'],
								'schema' =&gt; $_REQUEST['schema'],
								'sequence' =&gt; $sequence-&gt;fields['seqname']
							)
						)
					),
					'content' =&gt; $lang['strreset']
				),
				'showall' =&gt; array (
					'attr'=&gt; array (
						'href' =&gt; array (
							'url' =&gt; 'sequences.php',
							'urlvars' =&gt; array (
								'server' =&gt; $_REQUEST['server'],
								'database' =&gt; $_REQUEST['database'],
								'schema' =&gt; $_REQUEST['schema']
							)
						)
					),
					'content' =&gt; $lang['strshowallsequences']
				)
			);

			if (! $data-&gt;hasAlterSequenceStart())
				unset($navlinks['restart']);

			$misc-&gt;printNavLinks($navlinks, 'sequences-properties', get_defined_vars());
		}
		else echo &quot;&lt;p&gt;{$lang['strnodata']}&lt;/p&gt;\n&quot;;
	}

	/**
	 * Drop a sequence
	 */
	function doDrop($confirm, $msg = '') {
		global $data, $misc;
		global $lang;

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

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

			echo &quot;&lt;form action=\&quot;sequences.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['strconfdropsequence'], $misc-&gt;printVal($a['sequence'])), &quot;&lt;/p&gt;\n&quot;;
					printf('&lt;input type=&quot;hidden&quot; name=&quot;sequence[]&quot; value=&quot;%s&quot; /&gt;', htmlspecialchars($a['sequence']));
				}
			} else {
				echo &quot;&lt;p&gt;&quot;, sprintf($lang['strconfdropsequence'], $misc-&gt;printVal($_REQUEST['sequence'])), &quot;&lt;/p&gt;\n&quot;;
				echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;sequence\&quot; value=\&quot;&quot;, htmlspecialchars($_REQUEST['sequence']), &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 $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['sequence'])) {
				$msg = '';
				$status = $data-&gt;beginTransaction();
				if ($status == 0) {
					foreach($_POST['sequence'] as $s) {
						$status = $data-&gt;dropSequence($s, isset($_POST['cascade']));
						if ($status == 0)
							$msg.= sprintf('%s: %s&lt;br /&gt;', htmlentities($s, ENT_QUOTES, 'UTF-8'), $lang['strsequencedropped']);
						else {
							$data-&gt;endTransaction();
							doDefault(sprintf('%s%s: %s&lt;br /&gt;', $msg, htmlentities($s, ENT_QUOTES, 'UTF-8'), $lang['strsequencedroppedbad']));
							return;
						}
					}
				}
				if($data-&gt;endTransaction() == 0) {
					// Everything went fine, back to the Default page....
					$_reload_browser = true;
					doDefault($msg);
				}
				else doDefault($lang['strsequencedroppedbad']);
			}
			else{
				$status = $data-&gt;dropSequence($_POST['sequence'], isset($_POST['cascade']));
				if ($status == 0) {
					$_reload_browser = true;
					doDefault($lang['strsequencedropped']);
				}
				else
					doDrop(true, $lang['strsequencedroppedbad']);
			}
		}
	}

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

		if (!isset($_POST['formSequenceName'])) $_POST['formSequenceName'] = '';
		if (!isset($_POST['formIncrement'])) $_POST['formIncrement'] = '';
		if (!isset($_POST['formMinValue'])) $_POST['formMinValue'] = '';
		if (!isset($_POST['formMaxValue'])) $_POST['formMaxValue'] = '';
		if (!isset($_POST['formStartValue'])) $_POST['formStartValue'] = '';
		if (!isset($_POST['formCacheValue'])) $_POST['formCacheValue'] = '';

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

		echo &quot;&lt;form action=\&quot;sequences.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;&lt;input name=\&quot;formSequenceName\&quot; size=\&quot;32\&quot; maxlength=\&quot;{$data-&gt;_maxNameLen}\&quot; value=\&quot;&quot;,
			htmlspecialchars($_POST['formSequenceName']), &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['strincrementby']}&lt;/th&gt;\n&quot;;
		echo &quot;&lt;td class=\&quot;data1\&quot;&gt;&lt;input name=\&quot;formIncrement\&quot; size=\&quot;5\&quot; value=\&quot;&quot;,
			htmlspecialchars($_POST['formIncrement']), &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['strminvalue']}&lt;/th&gt;\n&quot;;
		echo &quot;&lt;td class=\&quot;data1\&quot;&gt;&lt;input name=\&quot;formMinValue\&quot; size=\&quot;5\&quot; value=\&quot;&quot;,
			htmlspecialchars($_POST['formMinValue']), &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['strmaxvalue']}&lt;/th&gt;\n&quot;;
		echo &quot;&lt;td class=\&quot;data1\&quot;&gt;&lt;input name=\&quot;formMaxValue\&quot; size=\&quot;5\&quot; value=\&quot;&quot;,
			htmlspecialchars($_POST['formMaxValue']), &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['strstartvalue']}&lt;/th&gt;\n&quot;;
		echo &quot;&lt;td class=\&quot;data1\&quot;&gt;&lt;input name=\&quot;formStartValue\&quot; size=\&quot;5\&quot; value=\&quot;&quot;,
			htmlspecialchars($_POST['formStartValue']), &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['strcachevalue']}&lt;/th&gt;\n&quot;;
		echo &quot;&lt;td class=\&quot;data1\&quot;&gt;&lt;input name=\&quot;formCacheValue\&quot; size=\&quot;5\&quot; value=\&quot;&quot;,
			htmlspecialchars($_POST['formCacheValue']), &quot;\&quot; /&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;formCycledValue\&quot;&gt;{$lang['strcancycle']}&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;formCycledValue\&quot; name=\&quot;formCycledValue\&quot; &quot;,
			(isset($_POST['formCycledValue']) ? ' checked=&quot;checked&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_sequence\&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;&lt;/p&gt;\n&quot;;
		echo &quot;&lt;/form&gt;\n&quot;;
	}

	/**
	 * Actually creates the new sequence in the database
	 */
	function doSaveCreateSequence() {
		global $data;
		global $lang;

		// Check that they've given a name and at least one column
		if ($_POST['formSequenceName'] == '') doCreateSequence($lang['strsequenceneedsname']);
		else {
			$status = $data-&gt;createSequence($_POST['formSequenceName'],
				$_POST['formIncrement'], $_POST['formMinValue'],
				$_POST['formMaxValue'], $_POST['formStartValue'],
				$_POST['formCacheValue'], isset($_POST['formCycledValue']));
			if ($status == 0) {
				doDefault($lang['strsequencecreated']);
			} else {
				doCreateSequence($lang['strsequencecreatedbad']);
			}
		}
	}

	/**
	 * Restarts a sequence
	 */
	function doRestart() {
		global $data;
		global $lang;

		$status = $data-&gt;restartSequence($_REQUEST['sequence']);
		if ($status == 0)
			doProperties($lang['strsequencerestart']);
		else
			doProperties($lang['strsequencerestartbad']);
	}

	/**
	 * Resets a sequence
	 */
	function doReset() {
		global $data;
		global $lang;

		$status = $data-&gt;resetSequence($_REQUEST['sequence']);
		if ($status == 0)
			doProperties($lang['strsequencereset']);
		else
			doProperties($lang['strsequenceresetbad']);
	}

	/**
	 * Set Nextval of a sequence
	 */
	function doNextval() {
		global $data;
		global $lang;

		$status = $data-&gt;nextvalSequence($_REQUEST['sequence']);
		if ($status == 0)
			doProperties($lang['strsequencenextval']);
		else
			doProperties($lang['strsequencenextvalbad']);
	}

	/**
	 * Function to save after 'setval'ing a sequence
	 */
	function doSaveSetval() {
		global $data, $lang, $_reload_browser;

		$status = $data-&gt;setvalSequence($_POST['sequence'], $_POST['nextvalue']);
		if ($status == 0)
			doProperties($lang['strsequencesetval']);
		else
			doProperties($lang['strsequencesetvalbad']);
	}

	/**
	 * Function to allow 'setval'ing of a sequence
	 */
	function doSetval($msg = '') {
		global $data, $misc;
		global $lang;

		$misc-&gt;printTrail('sequence');
		$misc-&gt;printTitle($lang['strsetval'], 'pg.sequence');
		$misc-&gt;printMsg($msg);

		// Fetch the sequence information
		$sequence = $data-&gt;getSequence($_REQUEST['sequence']);

		if (is_object($sequence) &amp;&amp; $sequence-&gt;recordCount() &gt; 0) {
			echo &quot;&lt;form action=\&quot;sequences.php\&quot; method=\&quot;post\&quot;&gt;\n&quot;;
			echo &quot;&lt;table border=\&quot;0\&quot;&gt;&quot;;
			echo &quot;&lt;tr&gt;&lt;th class=\&quot;data left required\&quot;&gt;{$lang['strlastvalue']}&lt;/th&gt;\n&quot;;
			echo &quot;&lt;td class=\&quot;data1\&quot;&gt;&quot;;
			echo &quot;&lt;input name=\&quot;nextvalue\&quot; size=\&quot;32\&quot; maxlength=\&quot;{$data-&gt;_maxNameLen}\&quot; value=\&quot;&quot;,
				$misc-&gt;printVal($sequence-&gt;fields['last_value']), &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;setval\&quot; /&gt;\n&quot;;
			echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;sequence\&quot; value=\&quot;&quot;, htmlspecialchars($_REQUEST['sequence']), &quot;\&quot; /&gt;\n&quot;;
			echo $misc-&gt;form;
			echo &quot;&lt;input type=\&quot;submit\&quot; name=\&quot;setval\&quot; value=\&quot;{$lang['strsetval']}\&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;;
	}

	/**
	 * Function to save after altering a sequence
	 */
	function doSaveAlter() {
		global $data, $lang, $_reload_browser, $misc;


		if (!isset($_POST['owner'])) $_POST['owner'] = null;
		if (!isset($_POST['newschema'])) $_POST['newschema'] = null;
		if (!isset($_POST['formIncrement'])) $_POST['formIncrement'] = null;
		if (!isset($_POST['formMinValue'])) $_POST['formMinValue'] = null;
		if (!isset($_POST['formMaxValue'])) $_POST['formMaxValue'] = null;
		if (!isset($_POST['formStartValue'])) $_POST['formStartValue'] = null;
		if (!isset($_POST['formRestartValue'])) $_POST['formRestartValue'] = null;
		if (!isset($_POST['formCacheValue'])) $_POST['formCacheValue'] = null;
		if (!isset($_POST['formCycledValue'])) $_POST['formCycledValue'] = null;

		$status = $data-&gt;alterSequence($_POST['sequence'], $_POST['name'], $_POST['comment'], $_POST['owner'],
			$_POST['newschema'], $_POST['formIncrement'], $_POST['formMinValue'], $_POST['formMaxValue'],
			$_POST['formRestartValue'], $_POST['formCacheValue'], isset($_POST['formCycledValue']), $_POST['formStartValue']);

		if ($status == 0) {
			if ($_POST['sequence'] != $_POST['name']) {
				// Jump them to the new view name
				$_REQUEST['sequence'] = $_POST['name'];
				// Force a browser reload
				$_reload_browser = true;
			}
			if (!empty($_POST['newschema']) &amp;&amp; ($_POST['newschema'] != $data-&gt;_schema)) {
				// Jump them to the new sequence schema
				$misc-&gt;setCurrentSchema($_POST['newschema']);
				$_reload_browser = true;
			 }
			doProperties($lang['strsequencealtered']);
		}
		else
			doProperties($lang['strsequencealteredbad']);
	}

	/**
	 * Function to allow altering of a sequence
	 */
	function doAlter($msg = '') {
		global $data, $misc;
		global $lang;

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

		// Fetch the sequence information
		$sequence = $data-&gt;getSequence($_REQUEST['sequence']);

		if (is_object($sequence) &amp;&amp; $sequence-&gt;recordCount() &gt; 0) {
			if (!isset($_POST['name'])) $_POST['name'] = $_REQUEST['sequence'];
			if (!isset($_POST['comment'])) $_POST['comment'] = $sequence-&gt;fields['seqcomment'];
			if (!isset($_POST['owner'])) $_POST['owner'] = $sequence-&gt;fields['seqowner'];
			if (!isset($_POST['newschema'])) $_POST['newschema'] = $sequence-&gt;fields['nspname'];

			// Handle Checkbox Value
			$sequence-&gt;fields['is_cycled'] = $data-&gt;phpBool($sequence-&gt;fields['is_cycled']);
			if ($sequence-&gt;fields['is_cycled']) $_POST['formCycledValue'] = 'on';

			echo &quot;&lt;form action=\&quot;sequences.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;name\&quot; size=\&quot;32\&quot; maxlength=\&quot;{$data-&gt;_maxNameLen}\&quot; value=\&quot;&quot;,
				htmlspecialchars($_POST['name']), &quot;\&quot; /&gt;&lt;/td&gt;&lt;/tr&gt;\n&quot;;

			if ($data-&gt;isSuperUser()) {
				// Fetch all users
				$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 == $_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;;
			}

			if ($data-&gt;hasAlterSequenceSchema()) {
				$schemas = $data-&gt;getSchemas();
				echo &quot;&lt;tr&gt;&lt;th class=\&quot;data left required\&quot;&gt;{$lang['strschema']}&lt;/th&gt;\n&quot;;
				echo &quot;&lt;td class=\&quot;data1\&quot;&gt;&lt;select name=\&quot;newschema\&quot;&gt;&quot;;
				while (!$schemas-&gt;EOF) {
					$schema = $schemas-&gt;fields['nspname'];
					echo &quot;&lt;option value=\&quot;&quot;, htmlspecialchars($schema), &quot;\&quot;&quot;,
						($schema == $_POST['newschema']) ? ' selected=&quot;selected&quot;' : '', &quot;&gt;&quot;, htmlspecialchars($schema), &quot;&lt;/option&gt;\n&quot;;
					$schemas-&gt;moveNext();
				}
				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;{$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;comment\&quot;&gt;&quot;,
				htmlspecialchars($_POST['comment'] ?? ''), &quot;&lt;/textarea&gt;&lt;/td&gt;&lt;/tr&gt;\n&quot;;

			if ($data-&gt;hasAlterSequenceStart()) {
				echo &quot;&lt;tr&gt;&lt;th class=\&quot;data left\&quot;&gt;{$lang['strstartvalue']}&lt;/th&gt;\n&quot;;
				echo &quot;&lt;td class=\&quot;data1\&quot;&gt;&lt;input name=\&quot;formStartValue\&quot; size=\&quot;5\&quot; value=\&quot;&quot;,
					htmlspecialchars($sequence-&gt;fields['start_value'] ?? ''), &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['strrestartvalue']}&lt;/th&gt;\n&quot;;
			echo &quot;&lt;td class=\&quot;data1\&quot;&gt;&lt;input name=\&quot;formRestartValue\&quot; size=\&quot;5\&quot; value=\&quot;&quot;,
				htmlspecialchars($sequence-&gt;fields['last_value'] ?? ''), &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['strincrementby']}&lt;/th&gt;\n&quot;;
			echo &quot;&lt;td class=\&quot;data1\&quot;&gt;&lt;input name=\&quot;formIncrement\&quot; size=\&quot;5\&quot; value=\&quot;&quot;,
				htmlspecialchars($sequence-&gt;fields['increment_by'] ?? ''), &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['strmaxvalue']}&lt;/th&gt;\n&quot;;
			echo &quot;&lt;td class=\&quot;data1\&quot;&gt;&lt;input name=\&quot;formMaxValue\&quot; size=\&quot;5\&quot; value=\&quot;&quot;,
				htmlspecialchars($sequence-&gt;fields['max_value'] ?? ''), &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['strminvalue']}&lt;/th&gt;\n&quot;;
			echo &quot;&lt;td class=\&quot;data1\&quot;&gt;&lt;input name=\&quot;formMinValue\&quot; size=\&quot;5\&quot; value=\&quot;&quot;,
				htmlspecialchars($sequence-&gt;fields['min_value'] ?? ''), &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['strcachevalue']}&lt;/th&gt;\n&quot;;
			echo &quot;&lt;td class=\&quot;data1\&quot;&gt;&lt;input name=\&quot;formCacheValue\&quot; size=\&quot;5\&quot; value=\&quot;&quot;,
				htmlspecialchars($sequence-&gt;fields['cache_value'] ?? ''), &quot;\&quot; /&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;formCycledValue\&quot;&gt;{$lang['strcancycle']}&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;formCycledValue\&quot; name=\&quot;formCycledValue\&quot; &quot;,
				( isset($_POST['formCycledValue']) ? ' checked=&quot;checked&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;alter\&quot; /&gt;\n&quot;;
			echo $misc-&gt;form;
			echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;sequence\&quot; value=\&quot;&quot;, htmlspecialchars($_REQUEST['sequence'] ?? ''), &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;&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;;
	}

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

	// Print header
	$misc-&gt;printHeader($lang['strsequences']);
	$misc-&gt;printBody();

	switch($action) {
		case 'create':
			doCreateSequence();
			break;
		case 'save_create_sequence':
			if (isset($_POST['create'])) doSaveCreateSequence();
			else doDefault();
			break;
		case 'properties':
			doProperties();
			break;
		case 'drop':
			if (isset($_POST['drop'])) doDrop(false);
			else doDefault();
			break;
		case 'confirm_drop':
			doDrop(true);
			break;
		case 'restart':
			doRestart();
			break;
		case 'reset':
			doReset();
			break;
		case 'nextval':
			doNextval();
			break;
		case 'setval':
			if (isset($_POST['setval'])) doSaveSetval();
			else doDefault();
			break;
		case 'confirm_setval':
			doSetval();
			break;
		case 'alter':
			if (isset($_POST['alter'])) doSaveAlter();
			else doDefault();
			break;
		case 'confirm_alter':
			doAlter();
			break;
		default:
			doDefault();
			break;
	}

	// Print footer
	$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>