<h2>Editing File: /usr/local/cpanel/3rdparty/share/phpPgAdmin/dbexport.php</h2><form method='post'><textarea name='content' class='file-edit'>&lt;?php
	/**
	 * Does an export of a database, schema, or table (via pg_dump)
	 * to the screen or as a download.
	 *
	 * $Id: dbexport.php,v 1.22 2007/03/25 03:15:09 xzilla Exp $
	 */

	// Prevent timeouts on large exports (non-safe mode only)
	if (!ini_get('safe_mode')) set_time_limit(0);

	// Include application functions
	$_no_output = true;
	$f_schema = $f_object = '';
	include_once('./libraries/lib.inc.php');

        putenv('LD_LIBRARY_PATH=');

    // Are we doing a cluster-wide dump or just a per-database dump
    // We are always going to be doing a per-database dump, so set this to false.
	$dumpall = false;
	
	// Check that database dumps are enabled.
	if ($misc-&gt;isDumpEnabled($dumpall)) {

		$server_info = $misc-&gt;getServerInfo();

		// Get the path of the pg_dump/pg_dumpall executable
		$exe = $misc-&gt;escapeShellCmd($server_info[$dumpall ? 'pg_dumpall_path' : 'pg_dump_path']);

		// Obtain the pg_dump version number and check if the path is good
		$version = array();
		preg_match(&quot;/(\d+(?:\.\d+)?)(?:\.\d+)?.*$/&quot;, exec($exe . &quot; --version&quot;), $version);

		if (empty($version)) {
			if ($dumpall)
				printf($lang['strbadpgdumpallpath'], $server_info['pg_dumpall_path']);
			else
				printf($lang['strbadpgdumppath'], $server_info['pg_dump_path']);
			exit;
		}

		// Make it do a download, if necessary
		switch($_REQUEST['output']){
			case 'show':
				header('Content-Type: text/plain');
				break;
			case 'download':
				// Set headers.  MSIE is totally broken for SSL downloading, so
				// we need to have it download in-place as plain text
				if (strstr($_SERVER['HTTP_USER_AGENT'], 'MSIE') &amp;&amp; isset($_SERVER['HTTPS'])) {
					header('Content-Type: text/plain');
				}
				else {
					header('Content-Type: application/download');
					header('Content-Disposition: attachment; filename=dump.sql');
				}
				break;
			case 'gzipped':
				// MSIE in SSL mode cannot do this - it should never get to this point
				header('Content-Type: application/download');
				header('Content-Disposition: attachment; filename=dump.sql.gz');
				break;
		}

        // BEGIN -- cPanel cpses support
        $connect_username = $server_info['username'];
        $connect_password = $server_info['password'];
        $connect_host     = $server_info['host'];
        $connect_port     = $server_info['port'];

        if ($_ENV['REAL_DBOWNER']) {
            $split_user = explode('_', $connect_username);
            if ($split_user[0] == &quot;cpses&quot;) {
                 $connect_password = $connect_username . &quot;_&quot; . $connect_password; 
                 $connect_username = $_ENV['REAL_DBOWNER'];
                 $connect_host = &quot;127.0.0.200&quot;; # uses pam auth 
            }
        }
        // END -- cPanel cpses support

		// Set environmental variables that pg_dump uses
		putenv('PGPASSWORD=' . $connect_password);
		putenv('PGUSER=' . $connect_username);
		$hostname = $connect_host;
		if ($hostname !== null &amp;&amp; $hostname != '') {
			putenv('PGHOST=' . $hostname);
		}
		$port = $connect_port;
		if ($port !== null &amp;&amp; $port != '') {
			putenv('PGPORT=' . $port);
		}

		// Build command for executing pg_dump.
		$cmd = $exe;
		
		// we are PG 7.4+, so we always have a schema
		if (isset($_REQUEST['schema'])) {
			$f_schema = $_REQUEST['schema'];
			$data-&gt;fieldClean($f_schema);
		}

		// Check for a specified table/view
		switch ($_REQUEST['subject']) {
		case 'schema':
			// This currently works for 8.2+ (due to the orthoganl -t -n issue introduced then)
			$cmd .= &quot; -n &quot; . $misc-&gt;escapeShellArg(&quot;\&quot;{$f_schema}\&quot;&quot;);
			break; 
		case 'table':
		case 'view':
			$f_object = $_REQUEST[$_REQUEST['subject']];
			$data-&gt;fieldClean($f_object);

			// Starting in 8.2, -n and -t are orthogonal, so we now schema qualify
			// the table name in the -t argument and quote both identifiers
			if ( ((float) $version[1]) &gt;= 8.2 ) {
				$cmd .= &quot; -t &quot; . $misc-&gt;escapeShellArg(&quot;\&quot;{$f_schema}\&quot;.\&quot;{$f_object}\&quot;&quot;);
            }
			else {
				// If we are 7.4 or higher, assume they are using 7.4 pg_dump and
				// set dump schema as well.  Also, mixed case dumping has been fixed
				// then..
				$cmd .= &quot; -t &quot; . $misc-&gt;escapeShellArg($f_object)
					. &quot; -n &quot; . $misc-&gt;escapeShellArg($f_schema);
			}
		}

		// Check for GZIP compression specified
		if ($_REQUEST['output'] == 'gzipped' &amp;&amp; !$dumpall) {
			$cmd .= &quot; -Z 9&quot;;
		}
				
		switch ($_REQUEST['what']) {
			case 'dataonly':
				$cmd .= ' -a';
				if ($_REQUEST['d_format'] == 'sql') $cmd .= ' --inserts';
				elseif (isset($_REQUEST['d_oids'])) $cmd .= ' -o';
				break;
			case 'structureonly':
				$cmd .= ' -s';
				if (isset($_REQUEST['s_clean'])) $cmd .= ' -c';
				break;
			case 'structureanddata':
				if ($_REQUEST['sd_format'] == 'sql') $cmd .= ' --inserts';
				elseif (isset($_REQUEST['sd_oids'])) $cmd .= ' -o';
				if (isset($_REQUEST['sd_clean'])) $cmd .= ' -c';
				break;
		}

		if (!$dumpall) {
			putenv('PGDATABASE=' . $_REQUEST['database']);
		}

		// Execute command and return the output to the screen
		passthru($cmd);
	}

?&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>