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

	$script = ''; // init global value script

	/**
	 * Show confirmation of cluster and perform cluster
	 */
	function doCluster($type, $confirm=false) {
		global $script, $data, $misc, $lang;

		if (($type == 'table') &amp;&amp; empty($_REQUEST['table']) &amp;&amp; empty($_REQUEST['ma'])) {
			doDefault($lang['strspecifytabletocluster']);
			return;
		}

		if ($confirm) {
			if (isset($_REQUEST['ma'])) {
				$misc-&gt;printTrail('schema');
				$misc-&gt;printTitle($lang['strclusterindex'], 'pg.index.cluster');

				echo &quot;&lt;form action=\&quot;{$script}\&quot; method=\&quot;post\&quot;&gt;\n&quot;;
				foreach($_REQUEST['ma'] as $v) {
					$a = safeUnserialize(htmlspecialchars_decode($v, ENT_QUOTES));
					echo &quot;&lt;p&gt;&quot;, sprintf($lang['strconfclustertable'], $misc-&gt;printVal($a['table'])), &quot;&lt;/p&gt;\n&quot;;
					echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;table[]\&quot; value=\&quot;&quot;, htmlspecialchars($a['table']), &quot;\&quot; /&gt;\n&quot;;
				}
			} // END if multi cluster
			else {
				$misc-&gt;printTrail($type);
				$misc-&gt;printTitle($lang['strclusterindex'], 'pg.index.cluster');

				echo &quot;&lt;form action=\&quot;{$script}\&quot; method=\&quot;post\&quot;&gt;\n&quot;;

				if ($type == 'table') {
					echo &quot;&lt;p&gt;&quot;, sprintf($lang['strconfclustertable'], $misc-&gt;printVal($_REQUEST['object'])), &quot;&lt;/p&gt;\n&quot;;
					echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;table\&quot; value=\&quot;&quot;, htmlspecialchars($_REQUEST['object']), &quot;\&quot; /&gt;\n&quot;;
				}
				else {
					echo &quot;&lt;p&gt;&quot;, sprintf($lang['strconfclusterdatabase'], $misc-&gt;printVal($_REQUEST['object'])), &quot;&lt;/p&gt;\n&quot;;
					echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;table\&quot; value=\&quot;\&quot; /&gt;\n&quot;;
				}
			}
			echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;action\&quot; value=\&quot;cluster\&quot; /&gt;\n&quot;;

			echo $misc-&gt;form;

			echo &quot;&lt;input type=\&quot;submit\&quot; name=\&quot;cluster\&quot; value=\&quot;{$lang['strcluster']}\&quot; /&gt;\n&quot;; //TODO
			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;;
		} // END single cluster
		else {
			//If multi table cluster
			if ($type == 'table') { // cluster one or more table
				if (is_array($_REQUEST['table'])) {
					$msg='';
					foreach($_REQUEST['table'] as $o) {
						$status = $data-&gt;clusterIndex($o);
						if ($status == 0)
							$msg.= sprintf('%s: %s&lt;br /&gt;', htmlentities($o, ENT_QUOTES, 'UTF-8'), $lang['strclusteredgood']);
						else {
							doDefault($type, sprintf('%s%s: %s&lt;br /&gt;', $msg, htmlentities($o, ENT_QUOTES, 'UTF-8'), $lang['strclusteredbad']));
							return;
						}
					}
					 // Everything went fine, back to the Default page....
					 doDefault($msg);
				}
				else {
					$status = $data-&gt;clusterIndex($_REQUEST['object']);
					if ($status == 0) {
						doAdmin($type, $lang['strclusteredgood']);
					}
					else
						doAdmin($type, $lang['strclusteredbad']);
				}
			}
			else { // Cluster all tables in database
				$status = $data-&gt;clusterIndex();
				if ($status == 0) {
					doAdmin($type, $lang['strclusteredgood']);
				}
				else
					doAdmin($type, $lang['strclusteredbad']);
			}
		}
	}

	/**
	 * Show confirmation of reindex and perform reindex
	 */
	function doReindex($type, $confirm=false) {
		global $script, $data, $misc, $lang, $_reload_browser;

		if (($type == 'table') &amp;&amp; empty($_REQUEST['table']) &amp;&amp; empty($_REQUEST['ma'])) {
			doDefault($lang['strspecifytabletoreindex']);
			return;
		}

		if ($confirm) {
			if (isset($_REQUEST['ma'])) {
				$misc-&gt;printTrail('schema');
				$misc-&gt;printTitle($lang['strreindex'], 'pg.reindex');

				echo &quot;&lt;form action=\&quot;{$script}\&quot; method=\&quot;post\&quot;&gt;\n&quot;;
				foreach($_REQUEST['ma'] as $v) {
					$a = safeUnserialize(htmlspecialchars_decode($v, ENT_QUOTES));
					echo &quot;&lt;p&gt;&quot;, sprintf($lang['strconfreindextable'], $misc-&gt;printVal($a['table'])), &quot;&lt;/p&gt;\n&quot;;
					echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;table[]\&quot; value=\&quot;&quot;, htmlspecialchars($a['table']), &quot;\&quot; /&gt;\n&quot;;
				}
			} // END if multi reindex
			else {
				$misc-&gt;printTrail($type);
				$misc-&gt;printTitle($lang['strreindex'], 'pg.reindex');

				echo &quot;&lt;form action=\&quot;{$script}\&quot; method=\&quot;post\&quot;&gt;\n&quot;;

				if ($type == 'table') {
					echo &quot;&lt;p&gt;&quot;, sprintf($lang['strconfreindextable'], $misc-&gt;printVal($_REQUEST['object'])), &quot;&lt;/p&gt;\n&quot;;
					echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;table\&quot; value=\&quot;&quot;, htmlspecialchars($_REQUEST['object']), &quot;\&quot; /&gt;\n&quot;;
				}
				else {
					echo &quot;&lt;p&gt;&quot;, sprintf($lang['strconfreindexdatabase'], $misc-&gt;printVal($_REQUEST['object'])), &quot;&lt;/p&gt;\n&quot;;
					echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;table\&quot; value=\&quot;\&quot; /&gt;\n&quot;;
				}
			}
			echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;action\&quot; value=\&quot;reindex\&quot; /&gt;\n&quot;;

			if ($data-&gt;hasForceReindex())
				echo &quot;&lt;p&gt;&lt;input type=\&quot;checkbox\&quot; id=\&quot;reindex_force\&quot; name=\&quot;reindex_force\&quot; /&gt;&lt;label for=\&quot;reindex_force\&quot;&gt;{$lang['strforce']}&lt;/label&gt;&lt;/p&gt;\n&quot;;

			echo $misc-&gt;form;

			echo &quot;&lt;input type=\&quot;submit\&quot; name=\&quot;reindex\&quot; value=\&quot;{$lang['strreindex']}\&quot; /&gt;\n&quot;; //TODO
			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;;
		} // END single reindex
		else {
			//If multi table reindex
			if (($type == 'table') &amp;&amp; is_array($_REQUEST['table'])) {
				$msg='';
				foreach($_REQUEST['table'] as $o) {
					$status = $data-&gt;reindex(strtoupper($type), $o, isset($_REQUEST['reindex_force']));
					if ($status == 0)
						$msg.= sprintf('%s: %s&lt;br /&gt;', htmlentities($o, ENT_QUOTES, 'UTF-8'), $lang['strreindexgood']);
					else {
						doDefault($type, sprintf('%s%s: %s&lt;br /&gt;', $msg, htmlentities($o, ENT_QUOTES, 'UTF-8'), $lang['strreindexbad']));
						return;
					}
				}
				 // Everything went fine, back to the Default page....
				 $_reload_browser = true;
				 doDefault($msg);
			}
			else {
				$status = $data-&gt;reindex(strtoupper($type), $_REQUEST['object'], isset($_REQUEST['reindex_force']));
				if ($status == 0) {
					$_reload_browser = true;
					doAdmin($type, $lang['strreindexgood']);
				}
				else
					doAdmin($type, $lang['strreindexbad']);
			}
		}
	}

	/**
	 * Show confirmation of analyze and perform analyze
	 */
	function doAnalyze($type, $confirm=false) {
		global $script, $data, $misc, $lang, $_reload_browser;

		if (($type == 'table') &amp;&amp; empty($_REQUEST['table']) &amp;&amp; empty($_REQUEST['ma'])) {
			doDefault($lang['strspecifytabletoanalyze']);
			return;
		}

		if ($confirm) {
			if (isset($_REQUEST['ma'])) {
				$misc-&gt;printTrail('schema');
				$misc-&gt;printTitle($lang['stranalyze'], 'pg.analyze');

				echo &quot;&lt;form action=\&quot;{$script}\&quot; method=\&quot;post\&quot;&gt;\n&quot;;
				foreach($_REQUEST['ma'] as $v) {
					$a = safeUnserialize(htmlspecialchars_decode($v, ENT_QUOTES));
					echo &quot;&lt;p&gt;&quot;, sprintf($lang['strconfanalyzetable'], $misc-&gt;printVal($a['table'])), &quot;&lt;/p&gt;\n&quot;;
					echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;table[]\&quot; value=\&quot;&quot;, htmlspecialchars($a['table']), &quot;\&quot; /&gt;\n&quot;;
				}
			} // END if multi analyze
			else {
				$misc-&gt;printTrail($type);
				$misc-&gt;printTitle($lang['stranalyze'], 'pg.analyze');

				echo &quot;&lt;form action=\&quot;{$script}\&quot; method=\&quot;post\&quot;&gt;\n&quot;;

				if ($type == 'table') {
					echo &quot;&lt;p&gt;&quot;, sprintf($lang['strconfanalyzetable'], $misc-&gt;printVal($_REQUEST['object'])), &quot;&lt;/p&gt;\n&quot;;
					echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;table\&quot; value=\&quot;&quot;, htmlspecialchars($_REQUEST['object']), &quot;\&quot; /&gt;\n&quot;;
				}
				else {
					echo &quot;&lt;p&gt;&quot;, sprintf($lang['strconfanalyzedatabase'], $misc-&gt;printVal($_REQUEST['object'])), &quot;&lt;/p&gt;\n&quot;;
					echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;table\&quot; value=\&quot;\&quot; /&gt;\n&quot;;
				}
			}
			echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;action\&quot; value=\&quot;analyze\&quot; /&gt;\n&quot;;
			echo $misc-&gt;form;

			echo &quot;&lt;input type=\&quot;submit\&quot; name=\&quot;analyze\&quot; value=\&quot;{$lang['stranalyze']}\&quot; /&gt;\n&quot;; //TODO
			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;;
		} // END single analyze
		else {
			//If multi table analyze
			if (($type == 'table') &amp;&amp; is_array($_REQUEST['table'])) {
				$msg='';
				foreach($_REQUEST['table'] as $o) {
					$status = $data-&gt;analyzeDB($o);
					if ($status == 0)
						$msg.= sprintf('%s: %s&lt;br /&gt;', htmlentities($o, ENT_QUOTES, 'UTF-8'), $lang['stranalyzegood']);
					else {
						doDefault($type, sprintf('%s%s: %s&lt;br /&gt;', $msg, htmlentities($o, ENT_QUOTES, 'UTF-8'), $lang['stranalyzebad']));
						return;
					}
				}
				 // Everything went fine, back to the Default page....
				 $_reload_browser = true;
				 doDefault($msg);
			}
			else {
				//we must pass table here. When empty, analyze the whole db
				$status = $data-&gt;analyzeDB($_REQUEST['table']);
				if ($status == 0) {
					$_reload_browser = true;
					doAdmin($type, $lang['stranalyzegood']);
				}
				else
					doAdmin($type, $lang['stranalyzebad']);
			}
		}
	}

	/**
	 * Show confirmation of vacuum and perform actual vacuum
	 */
	function doVacuum($type, $confirm = false) {
		global $script, $data, $misc, $lang, $_reload_browser;

		if (($type == 'table') &amp;&amp; empty($_REQUEST['table']) &amp;&amp; empty($_REQUEST['ma'])) {
			doDefault($lang['strspecifytabletovacuum']);
			return;
		}

		if ($confirm) {
			if (isset($_REQUEST['ma'])) {
				$misc-&gt;printTrail('schema');
				$misc-&gt;printTitle($lang['strvacuum'], 'pg.vacuum');

				echo &quot;&lt;form action=\&quot;{$script}\&quot; method=\&quot;post\&quot;&gt;\n&quot;;
				foreach($_REQUEST['ma'] as $v) {
					$a = safeUnserialize(htmlspecialchars_decode($v, ENT_QUOTES));
					echo &quot;&lt;p&gt;&quot;, sprintf($lang['strconfvacuumtable'], $misc-&gt;printVal($a['table'])), &quot;&lt;/p&gt;\n&quot;;
					echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;table[]\&quot; value=\&quot;&quot;, htmlspecialchars($a['table']), &quot;\&quot; /&gt;\n&quot;;
				}
			} // END if multi vacuum
			else {
				$misc-&gt;printTrail($type);
				$misc-&gt;printTitle($lang['strvacuum'], 'pg.vacuum');

				echo &quot;&lt;form action=\&quot;{$script}\&quot; method=\&quot;post\&quot;&gt;\n&quot;;

				if ($type == 'table') {
					echo &quot;&lt;p&gt;&quot;, sprintf($lang['strconfvacuumtable'], $misc-&gt;printVal($_REQUEST['object'])), &quot;&lt;/p&gt;\n&quot;;
					echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;table\&quot; value=\&quot;&quot;, htmlspecialchars($_REQUEST['object']), &quot;\&quot; /&gt;\n&quot;;
				}
				else {
					echo &quot;&lt;p&gt;&quot;, sprintf($lang['strconfvacuumdatabase'], $misc-&gt;printVal($_REQUEST['object'])), &quot;&lt;/p&gt;\n&quot;;
					echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;table\&quot; value=\&quot;\&quot; /&gt;\n&quot;;
				}
			}
			echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;action\&quot; value=\&quot;vacuum\&quot; /&gt;\n&quot;;
			echo $misc-&gt;form;
			echo &quot;&lt;p&gt;&lt;input type=\&quot;checkbox\&quot; id=\&quot;vacuum_full\&quot; name=\&quot;vacuum_full\&quot; /&gt; &lt;label for=\&quot;vacuum_full\&quot;&gt;{$lang['strfull']}&lt;/label&gt;&lt;/p&gt;\n&quot;;
			echo &quot;&lt;p&gt;&lt;input type=\&quot;checkbox\&quot; id=\&quot;vacuum_analyze\&quot; name=\&quot;vacuum_analyze\&quot; /&gt; &lt;label for=\&quot;vacuum_analyze\&quot;&gt;{$lang['stranalyze']}&lt;/label&gt;&lt;/p&gt;\n&quot;;
			echo &quot;&lt;p&gt;&lt;input type=\&quot;checkbox\&quot; id=\&quot;vacuum_freeze\&quot; name=\&quot;vacuum_freeze\&quot; /&gt; &lt;label for=\&quot;vacuum_freeze\&quot;&gt;{$lang['strfreeze']}&lt;/label&gt;&lt;/p&gt;\n&quot;;
			echo &quot;&lt;input type=\&quot;submit\&quot; name=\&quot;vacuum\&quot; value=\&quot;{$lang['strvacuum']}\&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;;
		} // END single vacuum
		else {
			//If multi drop
			if (is_array($_REQUEST['table'])) {
				$msg='';
				foreach($_REQUEST['table'] as $t) {
					$status = $data-&gt;vacuumDB($t, isset($_REQUEST['vacuum_analyze']), isset($_REQUEST['vacuum_full']), isset($_REQUEST['vacuum_freeze']));
					if ($status == 0)
						$msg.= sprintf('%s: %s&lt;br /&gt;', htmlentities($t, ENT_QUOTES, 'UTF-8'), $lang['strvacuumgood']);
					else {
						doDefault($type, sprintf('%s%s: %s&lt;br /&gt;', $msg, htmlentities($t, ENT_QUOTES, 'UTF-8'), $lang['strvacuumbad']));
						return;
					}
				}
				 // Everything went fine, back to the Default page....
				 $_reload_browser = true;
				 doDefault($msg);
			}
			else {
				//we must pass table here. When empty, vacuum the whole db
				$status = $data-&gt;vacuumDB($_REQUEST['table'], isset($_REQUEST['vacuum_analyze']), isset($_REQUEST['vacuum_full']), isset($_REQUEST['vacuum_freeze']));
				if ($status == 0) {
					$_reload_browser = true;
					doAdmin($type, $lang['strvacuumgood']);
				}
				else
					doAdmin($type, $lang['strvacuumbad']);
			}
		}
	}

	/**
	 * Add or Edit autovacuum params and save them
	 */
	function doEditAutovacuum($type, $confirm, $msg='') {
		global $script, $data, $misc, $lang;

		if (empty($_REQUEST['table'])) {
			doAdmin($type, '', $lang['strspecifyeditvacuumtable']);
			return;
		}

		$script = ($type == 'database')? 'database.php' : 'tables.php';

		if ($confirm) {
			$misc-&gt;printTrail($type);
			$misc-&gt;printTitle(sprintf($lang['streditvacuumtable'], $misc-&gt;printVal($_REQUEST['table'])));
			$misc-&gt;printMsg(sprintf($msg, $misc-&gt;printVal($_REQUEST['table'])));

			if (empty($_REQUEST['table'])) {
				doAdmin($type, '', $lang['strspecifyeditvacuumtable']);
				return;
			}

			$old_val = $data-&gt;getTableAutovacuum($_REQUEST['table']);
			$defaults = $data-&gt;getAutovacuum();
			$old_val = $old_val-&gt;fields;

			if (isset($old_val['autovacuum_enabled']) and ($old_val['autovacuum_enabled'] == 'off')) {
				$enabled = '';
				$disabled = 'checked=&quot;checked&quot;';
			}
			else {
				$enabled = 'checked=&quot;checked&quot;';
				$disabled = '';
			}

			if (!isset($old_val['autovacuum_vacuum_threshold'])) $old_val['autovacuum_vacuum_threshold'] = '';
			if (!isset($old_val['autovacuum_vacuum_scale_factor'])) $old_val['autovacuum_vacuum_scale_factor'] = '';
			if (!isset($old_val['autovacuum_analyze_threshold'])) $old_val['autovacuum_analyze_threshold'] = '';
			if (!isset($old_val['autovacuum_analyze_scale_factor'])) $old_val['autovacuum_analyze_scale_factor'] = '';
			if (!isset($old_val['autovacuum_vacuum_cost_delay'])) $old_val['autovacuum_vacuum_cost_delay'] = '';
			if (!isset($old_val['autovacuum_vacuum_cost_limit'])) $old_val['autovacuum_vacuum_cost_limit'] = '';

			echo &quot;&lt;form action=\&quot;{$script}\&quot; method=\&quot;post\&quot;&gt;\n&quot;;
			echo $misc-&gt;form;
			echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;action\&quot; value=\&quot;editautovac\&quot; /&gt;\n&quot;;
			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;br /&gt;\n&lt;br /&gt;\n&lt;table&gt;\n&quot;;
			echo &quot;\t&lt;tr&gt;&lt;td&gt;&amp;nbsp;&lt;/td&gt;\n&quot;;
			echo &quot;&lt;th class=\&quot;data\&quot;&gt;{$lang['strnewvalues']}&lt;/th&gt;&lt;th class=\&quot;data\&quot;&gt;{$lang['strdefaultvalues']}&lt;/th&gt;&lt;/tr&gt;\n&quot;;
			echo &quot;\t&lt;tr&gt;&lt;th class=\&quot;data left\&quot;&gt;{$lang['strenable']}&lt;/th&gt;\n&quot;;
			echo &quot;&lt;td class=\&quot;data1\&quot;&gt;\n&quot;;
			echo &quot;&lt;label for=\&quot;on\&quot;&gt;on&lt;/label&gt;&lt;input type=\&quot;radio\&quot; name=\&quot;autovacuum_enabled\&quot; id=\&quot;on\&quot; value=\&quot;on\&quot; {$enabled} /&gt;\n&quot;;
			echo &quot;&lt;label for=\&quot;off\&quot;&gt;off&lt;/label&gt;&lt;input type=\&quot;radio\&quot; name=\&quot;autovacuum_enabled\&quot; id=\&quot;off\&quot; value=\&quot;off\&quot; {$disabled} /&gt;&lt;/td&gt;\n&quot;;
			echo &quot;&lt;th class=\&quot;data left\&quot;&gt;{$defaults['autovacuum']}&lt;/th&gt;&lt;/tr&gt;\n&quot;;
			echo &quot;\t&lt;tr&gt;&lt;th class=\&quot;data left\&quot;&gt;{$lang['strvacuumbasethreshold']}&lt;/th&gt;\n&quot;;
			echo &quot;&lt;td class=\&quot;data1\&quot;&gt;&lt;input type=\&quot;text\&quot; name=\&quot;autovacuum_vacuum_threshold\&quot; value=\&quot;{$old_val['autovacuum_vacuum_threshold']}\&quot; /&gt;&lt;/td&gt;\n&quot;;
			echo &quot;&lt;th class=\&quot;data left\&quot;&gt;{$defaults['autovacuum_vacuum_threshold']}&lt;/th&gt;&lt;/tr&gt;\n&quot;;
			echo &quot;\t&lt;tr&gt;&lt;th class=\&quot;data left\&quot;&gt;{$lang['strvacuumscalefactor']}&lt;/th&gt;\n&quot;;
			echo &quot;&lt;td class=\&quot;data1\&quot;&gt;&lt;input type=\&quot;text\&quot; name=\&quot;autovacuum_vacuum_scale_factor\&quot; value=\&quot;{$old_val['autovacuum_vacuum_scale_factor']}\&quot; /&gt;&lt;/td&gt;\n&quot;;
			echo &quot;&lt;th class=\&quot;data left\&quot;&gt;{$defaults['autovacuum_vacuum_scale_factor']}&lt;/th&gt;&lt;/tr&gt;\n&quot;;
			echo &quot;\t&lt;tr&gt;&lt;th class=\&quot;data left\&quot;&gt;{$lang['stranalybasethreshold']}&lt;/th&gt;\n&quot;;
			echo &quot;&lt;td class=\&quot;data1\&quot;&gt;&lt;input type=\&quot;text\&quot; name=\&quot;autovacuum_analyze_threshold\&quot; value=\&quot;{$old_val['autovacuum_analyze_threshold']}\&quot; /&gt;&lt;/td&gt;\n&quot;;
			echo &quot;&lt;th class=\&quot;data left\&quot;&gt;{$defaults['autovacuum_analyze_threshold']}&lt;/th&gt;&lt;/tr&gt;\n&quot;;
			echo &quot;\t&lt;tr&gt;&lt;th class=\&quot;data left\&quot;&gt;{$lang['stranalyzescalefactor']}&lt;/th&gt;\n&quot;;
			echo &quot;&lt;td class=\&quot;data1\&quot;&gt;&lt;input type=\&quot;text\&quot; name=\&quot;autovacuum_analyze_scale_factor\&quot; value=\&quot;{$old_val['autovacuum_analyze_scale_factor']}\&quot; /&gt;&lt;/td&gt;\n&quot;;
			echo &quot;&lt;th class=\&quot;data left\&quot;&gt;{$defaults['autovacuum_analyze_scale_factor']}&lt;/th&gt;&lt;/tr&gt;\n&quot;;
			echo &quot;\t&lt;tr&gt;&lt;th class=\&quot;data left\&quot;&gt;{$lang['strvacuumcostdelay']}&lt;/th&gt;\n&quot;;
			echo &quot;&lt;td class=\&quot;data1\&quot;&gt;&lt;input type=\&quot;text\&quot; name=\&quot;autovacuum_vacuum_cost_delay\&quot; value=\&quot;{$old_val['autovacuum_vacuum_cost_delay']}\&quot; /&gt;&lt;/td&gt;\n&quot;;
			echo &quot;&lt;th class=\&quot;data left\&quot;&gt;{$defaults['autovacuum_vacuum_cost_delay']}&lt;/th&gt;&lt;/tr&gt;\n&quot;;
			echo &quot;\t&lt;tr&gt;&lt;th class=\&quot;data left\&quot;&gt;{$lang['strvacuumcostlimit']}&lt;/th&gt;\n&quot;;
			echo &quot;&lt;td class=\&quot;datat1\&quot;&gt;&lt;input type=\&quot;text\&quot; name=\&quot;autovacuum_vacuum_cost_limit\&quot; value=\&quot;{$old_val['autovacuum_vacuum_cost_limit']}\&quot; /&gt;&lt;/td&gt;\n&quot;;
			echo &quot;&lt;th class=\&quot;data left\&quot;&gt;{$defaults['autovacuum_vacuum_cost_limit']}&lt;/th&gt;&lt;/tr&gt;\n&quot;;
			echo &quot;&lt;/table&gt;\n&quot;;
			echo &quot;&lt;br /&gt;&quot;;
			echo &quot;&lt;br /&gt;&quot;;
			echo &quot;&lt;input type=\&quot;submit\&quot; name=\&quot;save\&quot; value=\&quot;{$lang['strsave']}\&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;saveAutovacuum($_REQUEST['table'], $_POST['autovacuum_enabled'], $_POST['autovacuum_vacuum_threshold'], 
				$_POST['autovacuum_vacuum_scale_factor'], $_POST['autovacuum_analyze_threshold'], $_POST['autovacuum_analyze_scale_factor'],
				$_POST['autovacuum_vacuum_cost_delay'], $_POST['autovacuum_vacuum_cost_limit']);

			if ($status == 0)
				doAdmin($type, '', sprintf($lang['strsetvacuumtablesaved'], $_REQUEST['table']));
			else
				doEditAutovacuum($type, true, $lang['strsetvacuumtablefail']);
		}
	}

	/**
	 * confirm drop autovacuum params for a table and drop it
	 */
	function doDropAutovacuum($type, $confirm) {
		global $script, $data, $misc, $lang;

		if (empty($_REQUEST['table'])) {
			doAdmin($type, '', $lang['strspecifydelvacuumtable']);
			return;
		}

		if ($confirm) {
			$misc-&gt;printTrail($type);
			$misc-&gt;printTabs($type,'admin');

			$script = ($type == 'database')? 'database.php' : 'tables.php';

			printf(&quot;&lt;p&gt;{$lang['strdelvacuumtable']}&lt;/p&gt;\n&quot;, 
				$misc-&gt;printVal(&quot;\&quot;{$_GET['schema']}\&quot;.\&quot;{$_GET['table']}\&quot;&quot;));

			echo &quot;&lt;form style=\&quot;float: left\&quot; action=\&quot;{$script}\&quot; method=\&quot;post\&quot;&gt;\n&quot;;
			echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;action\&quot; value=\&quot;delautovac\&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;rel\&quot; value=\&quot;&quot;, htmlspecialchars(serialize(array($_REQUEST['schema'], $_REQUEST['table']))), &quot;\&quot; /&gt;\n&quot;;
			echo &quot;&lt;input type=\&quot;submit\&quot; name=\&quot;yes\&quot; value=\&quot;{$lang['stryes']}\&quot; /&gt;\n&quot;;
			echo &quot;&lt;/form&gt;\n&quot;;

			echo &quot;&lt;form action=\&quot;{$script}\&quot; method=\&quot;post\&quot;&gt;\n&quot;;
			echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;action\&quot; value=\&quot;admin\&quot; /&gt;\n&quot;;
			echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;table\&quot; value=\&quot;&quot;, htmlspecialchars($_REQUEST['table']), &quot;\&quot; /&gt;\n&quot;;
			echo $misc-&gt;form;
			echo &quot;&lt;input type=\&quot;submit\&quot; name=\&quot;no\&quot; value=\&quot;{$lang['strno']}\&quot; /&gt;\n&quot;;
			echo &quot;&lt;/form&gt;\n&quot;;
		}
		else {

			$status = $data-&gt;dropAutovacuum($_POST['table']);

			if ($status == 0) {
				doAdmin($type, '', sprintf($lang['strvacuumtablereset'], $misc-&gt;printVal($_POST['table'])));
			}
			else
				doAdmin($type, '', sprintf($lang['strdelvacuumtablefail'], $misc-&gt;printVal($_POST['table'])));
		}
	}

	/**
	 * database/table administration and tuning tasks
	 *
	 * $Id: admin.php
	 */

	function doAdmin($type, $msg = '') {
		global $script, $data, $misc, $lang;

		$misc-&gt;printTrail($type);
		$misc-&gt;printTabs($type,'admin');
		$misc-&gt;printMsg($msg);

		if ($type == 'database')
			printf(&quot;&lt;p&gt;{$lang['stradminondatabase']}&lt;/p&gt;\n&quot;, $misc-&gt;printVal($_REQUEST['object']));
		else
			printf(&quot;&lt;p&gt;{$lang['stradminontable']}&lt;/p&gt;\n&quot;, $misc-&gt;printVal($_REQUEST['object']));

		echo &quot;&lt;table style=\&quot;width: 50%\&quot;&gt;\n&quot;;
		echo &quot;&lt;tr&gt;\n&quot;;
		echo &quot;&lt;th class=\&quot;data\&quot;&gt;&quot;;
		$misc-&gt;printHelp($lang['strvacuum'],'pg.admin.vacuum').&quot;&lt;/th&gt;\n&quot;;
		echo &quot;&lt;/th&gt;&quot;;
		echo &quot;&lt;th class=\&quot;data\&quot;&gt;&quot;;
		$misc-&gt;printHelp($lang['stranalyze'],'pg.admin.analyze');
		echo &quot;&lt;/th&gt;&quot;;
		if ($data-&gt;hasRecluster()){
			echo &quot;&lt;th class=\&quot;data\&quot;&gt;&quot;;
			$misc-&gt;printHelp($lang['strclusterindex'],'pg.index.cluster');
			echo &quot;&lt;/th&gt;&quot;;
		}
		echo &quot;&lt;th class=\&quot;data\&quot;&gt;&quot;;
		$misc-&gt;printHelp($lang['strreindex'],'pg.index.reindex');
		echo &quot;&lt;/th&gt;&quot;;
		echo &quot;&lt;/tr&gt;&quot;;

		// Vacuum
		echo &quot;&lt;tr class=\&quot;row1\&quot;&gt;\n&quot;;
		echo &quot;&lt;td style=\&quot;text-align: center; vertical-align: bottom\&quot;&gt;\n&quot;;
		echo &quot;&lt;form action=\&quot;{$script}\&quot; method=\&quot;post\&quot;&gt;\n&quot;;

		echo &quot;&lt;p&gt;&lt;input type=\&quot;hidden\&quot; name=\&quot;action\&quot; value=\&quot;confirm_vacuum\&quot; /&gt;\n&quot;;
		echo $misc-&gt;form;
		if ($type == 'table') {
			echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;table\&quot; value=\&quot;&quot;, htmlspecialchars($_REQUEST['object']), &quot;\&quot; /&gt;\n&quot;;
			echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;subject\&quot; value=\&quot;table\&quot; /&gt;\n&quot;;
		}
		echo &quot;&lt;input type=\&quot;submit\&quot; value=\&quot;{$lang['strvacuum']}\&quot; /&gt;&lt;/p&gt;\n&quot;;
		echo &quot;&lt;/form&gt;\n&quot;;
		echo &quot;&lt;/td&gt;\n&quot;;

		// Analyze
		echo &quot;&lt;td style=\&quot;text-align: center; vertical-align: bottom\&quot;&gt;\n&quot;;
		echo &quot;&lt;form action=\&quot;{$script}\&quot; method=\&quot;post\&quot;&gt;\n&quot;;
		echo &quot;&lt;p&gt;&lt;input type=\&quot;hidden\&quot; name=\&quot;action\&quot; value=\&quot;confirm_analyze\&quot; /&gt;\n&quot;;
		echo $misc-&gt;form;
		if ($type == 'table') {
			echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;table\&quot; value=\&quot;&quot;, htmlspecialchars($_REQUEST['object']), &quot;\&quot; /&gt;\n&quot;;
			echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;subject\&quot; value=\&quot;table\&quot; /&gt;\n&quot;;
		}
		echo &quot;&lt;input type=\&quot;submit\&quot; value=\&quot;{$lang['stranalyze']}\&quot; /&gt;&lt;/p&gt;\n&quot;;
		echo &quot;&lt;/form&gt;\n&quot;;
		echo &quot;&lt;/td&gt;\n&quot;;

		// Cluster
		if ($data-&gt;hasRecluster()){
			$disabled = '';
			echo &quot;&lt;td style=\&quot;text-align: center; vertical-align: bottom\&quot;&gt;\n&quot;;
			echo &quot;&lt;form action=\&quot;{$script}\&quot; method=\&quot;post\&quot;&gt;\n&quot;;
			echo $misc-&gt;form;
			if ($type == 'table') {
				echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;table\&quot; value=\&quot;&quot;, htmlspecialchars($_REQUEST['object']), &quot;\&quot; /&gt;\n&quot;;
				echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;subject\&quot; value=\&quot;table\&quot; /&gt;\n&quot;;
				if (!$data-&gt;alreadyClustered($_REQUEST['object'])) {
					$disabled = 'disabled=&quot;disabled&quot; ';
					echo &quot;{$lang['strnoclusteravailable']}&lt;br /&gt;&quot;;
				}
			}
			echo &quot;&lt;p&gt;&lt;input type=\&quot;hidden\&quot; name=\&quot;action\&quot; value=\&quot;confirm_cluster\&quot; /&gt;\n&quot;;
			echo &quot;&lt;input type=\&quot;submit\&quot; value=\&quot;{$lang['strclusterindex']}\&quot; $disabled/&gt;&lt;/p&gt;\n&quot;;
			echo &quot;&lt;/form&gt;\n&quot;;
			echo &quot;&lt;/td&gt;\n&quot;;
		}

		// Reindex
		echo &quot;&lt;td style=\&quot;text-align: center; vertical-align: bottom\&quot;&gt;\n&quot;;
		echo &quot;&lt;form action=\&quot;{$script}\&quot; method=\&quot;post\&quot;&gt;\n&quot;;
		echo &quot;&lt;p&gt;&lt;input type=\&quot;hidden\&quot; name=\&quot;action\&quot; value=\&quot;confirm_reindex\&quot; /&gt;\n&quot;;
		echo $misc-&gt;form;
		if ($type == 'table') {
			echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;table\&quot; value=\&quot;&quot;, htmlspecialchars($_REQUEST['object']), &quot;\&quot; /&gt;\n&quot;;
			echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;subject\&quot; value=\&quot;table\&quot; /&gt;\n&quot;;
		}
		echo &quot;&lt;input type=\&quot;submit\&quot; value=\&quot;{$lang['strreindex']}\&quot; /&gt;&lt;/p&gt;\n&quot;;
		echo &quot;&lt;/form&gt;\n&quot;;
		echo &quot;&lt;/td&gt;\n&quot;;
		echo &quot;&lt;/tr&gt;\n&quot;;
		echo &quot;&lt;/table&gt;\n&quot;;

		// Autovacuum
		if($data-&gt;hasAutovacuum()) {
			// get defaults values for autovacuum
			$defaults = $data-&gt;getAutovacuum();
			// Fetch the autovacuum properties from the database or table if != ''
			if ($type == 'table') $autovac = $data-&gt;getTableAutovacuum($_REQUEST['table']);
			else $autovac = $data-&gt;getTableAutovacuum();

			echo &quot;&lt;br /&gt;&lt;br /&gt;&lt;h2&gt;{$lang['strvacuumpertable']}&lt;/h2&gt;&quot;;
			echo '&lt;p&gt;' . (($defaults['autovacuum'] == 'on') ? $lang['strturnedon'] : $lang['strturnedoff'] ) . '&lt;/p&gt;';
			echo &quot;&lt;p class=\&quot;message\&quot;&gt;{$lang['strnotdefaultinred']}&lt;/p&gt;&quot;;

			function enlight($f, $p) {
				if ( isset($f[$p[0]]) and ($f[$p[0]] != $p[1]))
					return &quot;&lt;span style=\&quot;color:#F33;font-weight:bold\&quot;&gt;&quot;. htmlspecialchars($f[$p[0]]) .&quot;&lt;/span&gt;&quot;;
				return htmlspecialchars($p[1]);
			}

			$columns = array(
				'namespace' =&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'),
				),
				'relname' =&gt; array(
					'title' =&gt; $lang['strtable'],
					'field' =&gt; field('relname'),
					'url'	=&gt; &quot;redirect.php?subject=table&amp;amp;{$misc-&gt;href}&amp;amp;&quot;,
					'vars'  =&gt; array('table' =&gt; 'relname', 'schema' =&gt; 'nspname'),
				),
				'autovacuum_enabled' =&gt; array(
					'title' =&gt; $lang['strenabled'],
					'field' =&gt; callback('enlight', array('autovacuum_enabled', $defaults['autovacuum'])),
					'type' =&gt; 'verbatim'
				),
				'autovacuum_vacuum_threshold' =&gt; array(
					'title' =&gt; $lang['strvacuumbasethreshold'],
					'field' =&gt; callback('enlight', array('autovacuum_vacuum_threshold', $defaults['autovacuum_vacuum_threshold'])),
					'type' =&gt; 'verbatim'
				),
				'autovacuum_vacuum_scale_factor' =&gt; array(
					'title' =&gt; $lang['strvacuumscalefactor'],
					'field' =&gt; callback('enlight', array('autovacuum_vacuum_scale_factor', $defaults['autovacuum_vacuum_scale_factor'])),
					'type' =&gt; 'verbatim'
				),
				'autovacuum_analyze_threshold' =&gt; array(
					'title' =&gt; $lang['stranalybasethreshold'],
					'field' =&gt; callback('enlight', array('autovacuum_analyze_threshold', $defaults['autovacuum_analyze_threshold'])),
					'type' =&gt; 'verbatim'
				),
				'autovacuum_analyze_scale_factor' =&gt; array(
					'title' =&gt; $lang['stranalyzescalefactor'],
					'field' =&gt; callback('enlight', array('autovacuum_analyze_scale_factor', $defaults['autovacuum_analyze_scale_factor'])),
					'type' =&gt; 'verbatim'
				),
				'autovacuum_vacuum_cost_delay' =&gt; array(
					'title' =&gt; $lang['strvacuumcostdelay'],
					'field' =&gt; concat(callback('enlight', array('autovacuum_vacuum_cost_delay', $defaults['autovacuum_vacuum_cost_delay'])), 'ms'),
					'type' =&gt; 'verbatim'
				),
				'autovacuum_vacuum_cost_limit' =&gt; array(
					'title' =&gt; $lang['strvacuumcostlimit'],
					'field' =&gt; callback('enlight', array('autovacuum_vacuum_cost_limit', $defaults['autovacuum_vacuum_cost_limit'])),
					'type' =&gt; 'verbatim'
				),
			);

			// Maybe we need to check permissions here?
			$columns['actions'] = array('title' =&gt; $lang['stractions']);

			$actions = array(
				'edit' =&gt; array(
					'content' =&gt; $lang['stredit'],
					'attr'=&gt; array (
						'href' =&gt; array (
							'url' =&gt; $script,
							'urlvars' =&gt; array (
								'subject' =&gt; $type,
								'action' =&gt; 'confeditautovac',
								'schema' =&gt; field('nspname'),
								'table' =&gt; field('relname')
							)
						)
					)
				),
				'delete' =&gt; array(
					'content' =&gt; $lang['strdelete'],
					'attr'=&gt; array (
						'href' =&gt; array (
							'url' =&gt; $script,
							'urlvars' =&gt; array (
								'subject' =&gt; $type,
								'action' =&gt; 'confdelautovac',
								'schema' =&gt; field('nspname'),
								'table' =&gt; field('relname')
							)
						)
					)
				)
			);

			if ($type == 'table') {
				unset($actions['edit']['vars']['schema'], 
					$actions['delete']['vars']['schema'],
					$columns['namespace'],
					$columns['relname']
				);
			}

			$misc-&gt;printTable($autovac, $columns, $actions, 'admin-admin', $lang['strnovacuumconf']);

			if (($type == 'table') and ($autovac-&gt;recordCount() == 0)) {
				echo &quot;&lt;br /&gt;&quot;;
				echo &quot;&lt;a href=\&quot;tables.php?action=confeditautovac&amp;amp;{$misc-&gt;href}&amp;amp;table=&quot;, htmlspecialchars($_REQUEST['table'])
					,&quot;\&quot;&gt;{$lang['straddvacuumtable']}&lt;/a&gt;&quot;;
			}
		}
	}

	function adminActions($action, $type) {
		global $script;

		if ($type == 'database') {
			$_REQUEST['object'] = $_REQUEST['database'];
			$script = 'database.php';
		}
		else {
			// $_REQUEST['table'] is no set if we are in the schema page
			$_REQUEST['object'] = (isset($_REQUEST['table']) ? $_REQUEST['table']:'');
			$script = 'tables.php';
		}

		switch ($action) {
			case 'confirm_cluster':
				doCluster($type, true);
				break;
			case 'confirm_reindex':
				doReindex($type, true);
				break;
			case 'confirm_analyze':
				doAnalyze($type, true);
				break;
			case 'confirm_vacuum':
				doVacuum($type, true);
				break;
			case 'cluster':
				if (isset($_POST['cluster'])) doCluster($type);
				// if multi-action from table canceled: back to the schema default page
				else if (($type == 'table') &amp;&amp; is_array($_REQUEST['object']) ) doDefault();
				else doAdmin($type);
				break;
			case 'reindex':
				if (isset($_POST['reindex'])) doReindex($type);
				// if multi-action from table canceled: back to the schema default page
				else if (($type == 'table') &amp;&amp; is_array($_REQUEST['object']) ) doDefault();
				else doAdmin($type);
				break;
			case 'analyze':
				if (isset($_POST['analyze'])) doAnalyze($type);
				// if multi-action from table canceled: back to the schema default page
				else if (($type == 'table') &amp;&amp; is_array($_REQUEST['object']) ) doDefault();
				else doAdmin($type);
				break;
			case 'vacuum':
				if (isset($_POST['vacuum'])) doVacuum($type);
				// if multi-action from table canceled: back to the schema default page
				else if (($type == 'table') &amp;&amp; is_array($_REQUEST['object']) ) doDefault();
				else doAdmin($type);
				break;
			case 'admin':
				doAdmin($type);
				break;
			case 'confeditautovac':
				doEditAutovacuum($type, true);
				break;
			case 'confdelautovac':
				doDropAutovacuum($type, true);
				break;
			case 'confaddautovac':
				doAddAutovacuum(true);
				break;
			case 'editautovac':
				if (isset($_POST['save'])) doEditAutovacuum($type, false);
				else doAdmin($type);
				break;
			case 'delautovac':
				doDropAutovacuum($type, false);
				break;
			default:
				return false;
		}
		return true;
	}
</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>