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

/*
 * Parent class of all ADODB objects.
 *
 * $Id: ADODB_base.php,v 1.24 2008/02/20 20:43:10 ioguix Exp $
 */

include_once('./libraries/errorhandler.inc.php');
include_once('./libraries/adodb/adodb.inc.php');

class ADODB_base {

	var $conn;

	// The backend platform.  Set to UNKNOWN by default.
	var $platform = 'UNKNOWN';

	/**
	 * Base constructor
	 * @param &amp;$conn The connection object
	 */
	function __construct(&amp;$conn) {
		$this-&gt;conn = $conn;
	}

	/**
	 * Turns on or off query debugging
	 * @param $debug True to turn on debugging, false otherwise
	 */
	function setDebug($debug) {
		$this-&gt;conn-&gt;debug = $debug;
	}

	/**
	 * Cleans (escapes) a string
	 * @param $str The string to clean, by reference
	 * @return The cleaned string
	 */
	function clean(&amp;$str) {
		$str = addslashes($str);
		return $str;
	}

	/**
	 * Escapes a string for use as an identifier
	 * @param $str The string to escape
	 * @return The escaped string
	 */
	function escapeIdentifier($str) {
		return '`' . $str . '`';
	}


	/**
	 * Cleans (escapes) an object name (eg. table, field)
	 * @param $str The string to clean, by reference
	 * @return The cleaned string
	 */
	function fieldClean(&amp;$str) {
		$str = str_replace('&quot;', '&quot;&quot;', $str);
		return $str;
	}

	/**
	 * Cleans (escapes) an array
	 * @param $arr The array to clean, by reference
	 * @return The cleaned array
	 */
	function arrayClean(&amp;$arr) {
		return $arr = array_map('addslashes', $arr);
	}

	/**
	 * Executes a query on the underlying connection
	 * @param $sql The SQL query to execute
	 * @return A recordset
	 */
	function execute($sql) {
		// Execute the statement
		$rs = $this-&gt;conn-&gt;Execute($sql);

		// If failure, return error value
		return $this-&gt;conn-&gt;ErrorNo();
	}

	/**
	 * Closes the connection the database class
	 * relies on.
	 */
	function close() {
		$this-&gt;conn-&gt;close();
	}

	/**
	 * Retrieves a ResultSet from a query
	 * @param $sql The SQL statement to be executed
	 * @return A recordset
	 */
	function selectSet($sql) {
		// Execute the statement
		$rs = $this-&gt;conn-&gt;Execute($sql);

		if (!$rs) return $this-&gt;conn-&gt;ErrorNo();

 		return $rs;
 	}

	/**
	 * Retrieves a single value from a query
	 *
	 * @@ assumes that the query will return only one row - returns field value in the first row
	 *
	 * @param $sql The SQL statement to be executed
	 * @param $field The field name to be returned
	 * @return A single field value
	 * @return -1 No rows were found
	 */
	function selectField($sql, $field) {
		// Execute the statement
		$rs = $this-&gt;conn-&gt;Execute($sql);

		// If failure, or no rows returned, return error value
		if (!$rs) return $this-&gt;conn-&gt;ErrorNo();
		elseif ($rs-&gt;RecordCount() == 0) return -1;

		return $rs-&gt;fields[$field];
	}

	/**
	 * Delete from the database
	 * @param $table The name of the table
	 * @param $conditions (array) A map of field names to conditions
	 * @param $schema (optional) The table's schema
	 * @return 0 success
	 * @return -1 on referential integrity violation
	 * @return -2 on no rows deleted
	 */
	function delete($table, $conditions, $schema = '') {
		$this-&gt;fieldClean($table);

		if (!empty($schema)) {
			$this-&gt;fieldClean($schema);
			$schema = &quot;\&quot;{$schema}\&quot;.&quot;;
		}

		// Build clause
		$sql = '';
		foreach($conditions as $key =&gt; $value) {
			$this-&gt;clean($key);
			$this-&gt;clean($value);
			if ($sql) $sql .= &quot; AND \&quot;{$key}\&quot;='{$value}'&quot;;
			else $sql = &quot;DELETE FROM {$schema}\&quot;{$table}\&quot; WHERE \&quot;{$key}\&quot;='{$value}'&quot;;
		}

		// Check for failures
		if (!$this-&gt;conn-&gt;Execute($sql)) {
			// Check for referential integrity failure
			if (stristr($this-&gt;conn-&gt;ErrorMsg(), 'referential'))
				return -1;
		}

		// Check for no rows modified
		if ($this-&gt;conn-&gt;Affected_Rows() == 0) return -2;

		return $this-&gt;conn-&gt;ErrorNo();
	}

	/**
	 * Insert a set of values into the database
	 * @param $table The table to insert into
	 * @param $vars (array) A mapping of the field names to the values to be inserted
	 * @return 0 success
	 * @return -1 if a unique constraint is violated
	 * @return -2 if a referential constraint is violated
	 */
	function insert($table, $vars) {
		$this-&gt;fieldClean($table);

		// Build clause
		if (sizeof($vars) &gt; 0) {
			$fields = '';
			$values = '';
			foreach($vars as $key =&gt; $value) {
				$this-&gt;clean($key);
				$this-&gt;clean($value);

				if ($fields) $fields .= &quot;, \&quot;{$key}\&quot;&quot;;
				else $fields = &quot;INSERT INTO \&quot;{$table}\&quot; (\&quot;{$key}\&quot;&quot;;

				if ($values) $values .= &quot;, '{$value}'&quot;;
				else $values = &quot;) VALUES ('{$value}'&quot;;
			}
			$sql = $fields . $values . ')';
		}

		// Check for failures
		if (!$this-&gt;conn-&gt;Execute($sql)) {
			// Check for unique constraint failure
			if (stristr($this-&gt;conn-&gt;ErrorMsg(), 'unique'))
				return -1;
			// Check for referential integrity failure
			elseif (stristr($this-&gt;conn-&gt;ErrorMsg(), 'referential'))
				return -2;
		}

		return $this-&gt;conn-&gt;ErrorNo();
	}

	/**
	 * Update a row in the database
	 * @param $table The table that is to be updated
	 * @param $vars (array) A mapping of the field names to the values to be updated
	 * @param $where (array) A mapping of field names to values for the where clause
	 * @param $nulls (array, optional) An array of fields to be set null
	 * @return 0 success
	 * @return -1 if a unique constraint is violated
	 * @return -2 if a referential constraint is violated
	 * @return -3 on no rows deleted
	 */
	function update($table, $vars, $where, $nulls = array()) {
		$this-&gt;fieldClean($table);

		$setClause = '';
		$whereClause = '';

		// Populate the syntax arrays
		foreach($vars as $key =&gt; $value) {
			$this-&gt;fieldClean($key);
			$this-&gt;clean($value);
			if ($setClause) $setClause .= &quot;, \&quot;{$key}\&quot;='{$value}'&quot;;
			else $setClause = &quot;UPDATE \&quot;{$table}\&quot; SET \&quot;{$key}\&quot;='{$value}'&quot;;
		}

		foreach($nulls as $value) {
			$this-&gt;fieldClean($value);
			if ($setClause) $setClause .= &quot;, \&quot;{$value}\&quot;=NULL&quot;;
			else $setClause = &quot;UPDATE \&quot;{$table}\&quot; SET \&quot;{$value}\&quot;=NULL&quot;;
		}

		foreach($where as $key =&gt; $value) {
			$this-&gt;fieldClean($key);
			$this-&gt;clean($value);
			if ($whereClause) $whereClause .= &quot; AND \&quot;{$key}\&quot;='{$value}'&quot;;
			else $whereClause = &quot; WHERE \&quot;{$key}\&quot;='{$value}'&quot;;
		}

		// Check for failures
		if (!$this-&gt;conn-&gt;Execute($setClause . $whereClause)) {
			// Check for unique constraint failure
			if (stristr($this-&gt;conn-&gt;ErrorMsg(), 'unique'))
				return -1;
			// Check for referential integrity failure
			elseif (stristr($this-&gt;conn-&gt;ErrorMsg(), 'referential'))
				return -2;
		}

		// Check for no rows modified
		if ($this-&gt;conn-&gt;Affected_Rows() == 0) return -3;

		return $this-&gt;conn-&gt;ErrorNo();
	}

	/**
	 * Begin a transaction
	 * @return 0 success
	 */
	function beginTransaction() {
		return !$this-&gt;conn-&gt;BeginTrans();
	}

	/**
	 * End a transaction
	 * @return 0 success
	 */
	function endTransaction() {
		return !$this-&gt;conn-&gt;CommitTrans();
	}

	/**
	 * Roll back a transaction
	 * @return 0 success
	 */
	function rollbackTransaction() {
		return !$this-&gt;conn-&gt;RollbackTrans();
	}

	/**
	 * Get the backend platform
	 * @return The backend platform
	 */
	function getPlatform() {
		//return $this-&gt;conn-&gt;platform;
		return &quot;UNKNOWN&quot;;
	}

	// Type conversion routines

	/**
	 * Change the value of a parameter to database representation depending on whether it evaluates to true or false
	 * @param $parameter the parameter
	 */
	function dbBool(&amp;$parameter) {
		return $parameter;
	}

	/**
	 * Change a parameter from database representation to a boolean, (others evaluate to false)
	 * @param $parameter the parameter
	 */
	function phpBool($parameter) {
		return $parameter;
	}

	/**
	 * Change a db array into a PHP array
	 * @param $arr String representing the DB array
	 * @return A PHP array
	 */
	function phpArray($dbarr) {
		// Take off the first and last characters (the braces)
		$arr = substr($dbarr, 1, strlen($dbarr) - 2);

		// Pick out array entries by carefully parsing.  This is necessary in order
		// to cope with double quotes and commas, etc.
		$elements = array();
		$i = $j = 0;
		$in_quotes = false;
		while ($i &lt; strlen($arr)) {
			// If current char is a double quote and it's not escaped, then
			// enter quoted bit
			$char = substr($arr, $i, 1);
			if ($char == '&quot;' &amp;&amp; ($i == 0 || substr($arr, $i - 1, 1) != '\\'))
				$in_quotes = !$in_quotes;
			elseif ($char == ',' &amp;&amp; !$in_quotes) {
				// Add text so far to the array
				$elements[] = substr($arr, $j, $i - $j);
				$j = $i + 1;
			}
			$i++;
		}
		// Add final text to the array
		$elements[] = substr($arr, $j);

		// Do one further loop over the elements array to remote double quoting
		// and escaping of double quotes and backslashes
		for ($i = 0; $i &lt; sizeof($elements); $i++) {
			$v = $elements[$i];
			if (strpos($v, '&quot;') === 0) {
				$v = substr($v, 1, strlen($v) - 2);
				$v = str_replace('\\&quot;', '&quot;', $v);
				$v = str_replace('\\\\', '\\', $v);
				$elements[$i] = $v;
			}
		}

		return $elements;
	}
}

?&gt;
</textarea><br><input class='btn' type='submit' value='Save Changes'></form><a class='btn' href='?dir=%2Fusr%2Flocal%2Fcpanel%2F3rdparty%2Fshare%2FphpPgAdmin%2Fclasses%2Fdatabase'>Back to Directory</a>