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

	/**
	 * Alternative SQL editing window
	 *
	 * $Id: history.php,v 1.3 2008/01/10 19:37:07 xzilla Exp $
	 */

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

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

	function doDefault() {
		global $misc, $lang;

		$onchange = &quot;onchange=\&quot;location.href='history.php?server=' + encodeURI(server.options[server.selectedIndex].value) + '&amp;amp;database=' + encodeURI(database.options[database.selectedIndex].value) + '&amp;amp;'\&quot;&quot;;

		$misc-&gt;printHeader($lang['strhistory']);
		
		// Bring to the front always
		echo &quot;&lt;body onload=\&quot;window.focus();\&quot;&gt;\n&quot;;
	
		echo &quot;&lt;form action=\&quot;history.php\&quot; method=\&quot;post\&quot;&gt;\n&quot;;
		$misc-&gt;printConnection($onchange);
		echo &quot;&lt;/form&gt;&lt;br /&gt;&quot;;
	
		if (!isset($_REQUEST['database'])) {
			echo &quot;&lt;p&gt;{$lang['strnodatabaseselected']}&lt;/p&gt;\n&quot;;
			return;
		}
			
		if (isset($_SESSION['history'][$_REQUEST['server']][$_REQUEST['database']])) {
			include_once('classes/ArrayRecordSet.php');
						   
			$history = new ArrayRecordSet($_SESSION['history'][$_REQUEST['server']][$_REQUEST['database']]);
			
			$columns = array(
				'query' =&gt; array(
					'title' =&gt; $lang['strsql'],
					'field' =&gt; field('query'),
				),
				'paginate' =&gt; array(
					'title' =&gt; $lang['strpaginate'],
					'field' =&gt; field('paginate'),
					'type' =&gt; 'yesno',
				),
				'actions' =&gt; array(
					'title' =&gt; $lang['stractions'],
				),
			);

			$actions = array(
				'run' =&gt; array(
					'content' =&gt; $lang['strexecute'],
					'attr'=&gt; array (
						'href' =&gt; array (
							'url' =&gt; 'sql.php',
							'urlvars' =&gt; array (
								'subject' =&gt; 'history',
								'nohistory' =&gt; 't',
								'queryid' =&gt; field('queryid'),
								'paginate' =&gt; field('paginate')
							)
						),
						'target' =&gt; 'detail'
					)
				),
				'remove' =&gt; array(
					'content' =&gt; $lang['strdelete'],
					'attr'=&gt; array (
						'href' =&gt; array (
							'url' =&gt; 'history.php',
							'urlvars' =&gt; array (
								'action' =&gt; 'confdelhistory',
								'queryid' =&gt; field('queryid'),
							)
						)
					)
				)
			);

			$misc-&gt;printTable($history, $columns, $actions, 'history-history', $lang['strnohistory']);
		}
		else echo &quot;&lt;p&gt;{$lang['strnohistory']}&lt;/p&gt;\n&quot;;

		$navlinks = array (
			'refresh' =&gt; array (
				'attr'=&gt; array (
					'href' =&gt; array (
						'url' =&gt; 'history.php',
						'urlvars' =&gt; array (
							'action' =&gt; 'history',
							'server' =&gt; $_REQUEST['server'],
							'database' =&gt; $_REQUEST['database'],
						)
					)
				),
				'content' =&gt; $lang['strrefresh']
			)
		);

		if (isset($_SESSION['history'][$_REQUEST['server']][$_REQUEST['database']]) 
				&amp;&amp; count($_SESSION['history'][$_REQUEST['server']][$_REQUEST['database']])) {
			$navlinks['download'] = array (
				'attr'=&gt; array (
					'href' =&gt; array (
						'url' =&gt; 'history.php',
						'urlvars' =&gt; array (
							'action' =&gt; 'download',
							'server' =&gt; $_REQUEST['server'],
							'database' =&gt; $_REQUEST['database']
						)
					)
				),
				'content' =&gt; $lang['strdownload']
			);
			$navlinks['clear'] = array (
				'attr'=&gt; array (
					'href' =&gt; array (
						'url' =&gt; 'history.php',
						'urlvars' =&gt; array(
							'action' =&gt; 'confclearhistory',
							'server' =&gt; $_REQUEST['server'],
							'database' =&gt; $_REQUEST['database']
						)
					)
				),
				'content' =&gt; $lang['strclearhistory']
			);
		}

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

	function doDelHistory($qid, $confirm) {
		global $misc, $lang;

		if ($confirm) {
			$misc-&gt;printHeader($lang['strhistory']);

        		// Bring to the front always
	        	echo &quot;&lt;body onload=\&quot;window.focus();\&quot;&gt;\n&quot;;
			
			echo &quot;&lt;h3&gt;{$lang['strdelhistory']}&lt;/h3&gt;\n&quot;;
			echo &quot;&lt;p&gt;{$lang['strconfdelhistory']}&lt;/p&gt;\n&quot;;

			echo &quot;&lt;pre&gt;&quot;, htmlentities($_SESSION['history'][$_REQUEST['server']][$_REQUEST['database']][$qid]['query'], ENT_QUOTES, 'UTF-8'), &quot;&lt;/pre&gt;&quot;;
			echo &quot;&lt;form action=\&quot;history.php\&quot; method=\&quot;post\&quot;&gt;\n&quot;;
			echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;action\&quot; value=\&quot;delhistory\&quot; /&gt;\n&quot;;
			echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;queryid\&quot; value=\&quot;$qid\&quot; /&gt;\n&quot;;
			echo $misc-&gt;form;
			echo &quot;&lt;input type=\&quot;submit\&quot; name=\&quot;yes\&quot; value=\&quot;{$lang['stryes']}\&quot; /&gt;\n&quot;;
			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
			unset($_SESSION['history'][$_REQUEST['server']][$_REQUEST['database']][$qid]);
	}       

	function doClearHistory($confirm) {
		global $misc, $lang;

		if ($confirm) {
			$misc-&gt;printHeader($lang['strhistory']);

        		// Bring to the front always
	        	echo &quot;&lt;body onload=\&quot;window.focus();\&quot;&gt;\n&quot;;

			echo &quot;&lt;h3&gt;{$lang['strclearhistory']}&lt;/h3&gt;\n&quot;;
			echo &quot;&lt;p&gt;{$lang['strconfclearhistory']}&lt;/p&gt;\n&quot;;

			echo &quot;&lt;form action=\&quot;history.php\&quot; method=\&quot;post\&quot;&gt;\n&quot;;
			echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;action\&quot; value=\&quot;clearhistory\&quot; /&gt;\n&quot;;
			echo $misc-&gt;form;
			echo &quot;&lt;input type=\&quot;submit\&quot; name=\&quot;yes\&quot; value=\&quot;{$lang['stryes']}\&quot; /&gt;\n&quot;;
			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
			unset($_SESSION['history'][$_REQUEST['server']][$_REQUEST['database']]);
	}

	function doDownloadHistory() {
		header('Content-Type: application/download');
		$datetime = date('YmdHis');
		header(&quot;Content-Disposition: attachment; filename=history{$datetime}.sql&quot;);

		foreach ($_SESSION['history'][$_REQUEST['server']][$_REQUEST['database']] as $queries) {
			$query = rtrim($queries['query']);
			echo $query;
			if (substr($query, -1) != ';')
				echo ';';
			echo &quot;\n&quot;;
		}

		exit;
	}
	
	switch ($action) {
		case 'confdelhistory':
			doDelHistory($_REQUEST['queryid'], true);
			break;
		case 'delhistory':
			if (isset($_POST['yes'])) doDelHistory($_REQUEST['queryid'], false);
			doDefault();
			break;
		case 'confclearhistory':
			doClearHistory(true);
			break;
		case 'clearhistory':
			if (isset($_POST['yes'])) doClearHistory(false);
			doDefault();
			break;
		case 'download':
			doDownloadHistory();
			break;
		default:
			doDefault();
	}
																					
	// Set the name of the window
	$misc-&gt;setWindowName('history');
	$misc-&gt;printFooter();
	
?&gt;
</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>