<h2>Editing File: /var/softaculous/leto/inc.DBAccess.php</h2><form method='post'><textarea name='content' class='file-edit'>&lt;?php
/**
 * Implementation of database access
 *
 * @category   DMS
 * @package    LetoDMS_Core
 * @license    GPL 2
 * @version    @version@
 * @author     Uwe Steinmann &lt;uwe@steinmann.cx&gt;
 * @copyright  Copyright (C) 2002-2005 Markus Westphal, 2006-2008 Malcolm Cowe,
 *             2010 Matteo Lucarelli, 2010 Uwe Steinmann
 * @version    Release: @package_version@
 */

/**
 * Include the adodb database abstraction
 */
require_once &quot;[[softpath]]/adodb/adodb.inc.php&quot;;
/** @noinspection PhpUndefinedClassInspection */

/**
 * Class to represent the database access for the document management
 *
 * @category   DMS
 * @package    LetoDMS_Core
 * @author     Markus Westphal, Malcolm Cowe, Matteo Lucarelli, Uwe Steinmann &lt;uwe@steinmann.cx&gt;
 * @copyright  Copyright (C) 2002-2005 Markus Westphal, 2006-2008 Malcolm Cowe, 2010 Matteo Lucarelli, 2010 Uwe Steinmann
 * @version    Release: @package_version@
 */
class LetoDMS_Core_DatabaseAccess {
	var $_debug;
	var $_driver;
	var $_hostname;
	var $_database;
	var $_user;
	var $_passw;
	var $_conn;
	var $_connected;
	var $_ttreviewid;
	var $_ttapproveid;
	var $_ttstatid;
	var $_ttcontentid;
	var $_intransaction;
	
	/*
	Backup functions
	*/

	/**
	 * Return list of all database tables
	 *
	 * This function is used to retrieve a list of database tables for backup
	 *
	 * @return array list of table names
	 */
	function TableList() {
		return $this-&gt;_conn-&gt;MetaTables(&quot;TABLES&quot;);
	}

    /**
     * Constructor of LetoDMS_Core_DatabaseAccess
     *
     * Sets all database parameters but does not connect.
     *
     * @param string $driver the database type e.g. mysql, sqlite
     * @param string $hostname host of database server
     * @param string $user name of user having access to database
     * @param string $passw password of user
     * @param bool|string $database name of database
     */
	function __construct($driver, $hostname, $user, $passw, $database = false) {
		$this-&gt;_driver = $driver;
		$this-&gt;_hostname = $hostname;
		$this-&gt;_database = $database;
		$this-&gt;_user = $user;
		$this-&gt;_passw = $passw;
		$this-&gt;_connected = false;
		$this-&gt;_intransaction = 0;
		// $tt*****id is a hack to ensure that we do not try to create the
		// temporary table twice during a single connection. Can be fixed by
		// using Views (MySQL 5.0 onward) instead of temporary tables.
		// CREATE ... IF NOT EXISTS cannot be used because it has the
		// unpleasant side-effect of performing the insert again even if the
		// table already exists.
		//
		// See createTemporaryTable() method for implementation.
		$this-&gt;_ttreviewid = false;
		$this-&gt;_ttapproveid = false;
		$this-&gt;_ttstatid = false;
		$this-&gt;_ttcontentid = false;
		$this-&gt;_debug = false;
	}

	/**
	 * Connect to database
	 *
	 * @return boolean true if connection could be established, otherwise false
	 */
	function connect() { /* {{{ */
		$this-&gt;_conn = ADONewConnection($this-&gt;_driver);
		if ($this-&gt;_database)
			$this-&gt;_conn-&gt;Connect($this-&gt;_hostname, $this-&gt;_user, $this-&gt;_passw, $this-&gt;_database);
		else
			$this-&gt;_conn-&gt;Connect($this-&gt;_hostname, $this-&gt;_user, $this-&gt;_passw);

		if (!$this-&gt;_conn)
			return false;

		$this-&gt;_conn-&gt;SetFetchMode(ADODB_FETCH_ASSOC);
		$this-&gt;_conn-&gt;Execute('SET NAMES utf8');
		$this-&gt;_connected = true;
		return true;
	} /* }}} */

	/**
	 * Make sure a database connection exisits
	 *
	 * This function checks for a database connection. If it does not exists
	 * it will reconnect.
	 *
	 * @return boolean true if connection is established, otherwise false
	 */
	function ensureConnected() { /* {{{ */
		if (!$this-&gt;_connected) return $this-&gt;connect();
		else return true;
	} /* }}} */

	/**
	 * Sanitize String used in database operations
	 *
	 * @param string $text
	 * @return string sanitized string
	 */
	function qstr($text) { /* {{{ */
		return $this-&gt;_conn-&gt;qstr($text);
	} /* }}} */


	/**
	 * Execute SQL query and return result
	 *
	 * Call this function only with sql query which return data records.
	 *
	 * @param string $queryStr sql query
	 * @return array|boolean data if query could be executed otherwise false
	 */
	function getResultArray($queryStr) { /* {{{ */
        /** @noinspection PhpUnusedLocalVariableInspection */
        $resArr = array();
		
		$res = $this-&gt;_conn-&gt;Execute($queryStr);
		if (!$res) {
			if($this-&gt;_debug)
				echo &quot;error: &quot;.$queryStr.&quot;&lt;br /&gt;&quot;;
			return false;
		}
		$resArr = $res-&gt;GetArray();
		$res-&gt;Close();
		return $resArr;
	} /* }}} */

    /**
     * Execute SQL query
     *
     * Call this function only with sql query which do not return data records.
     *
     * @param string $queryStr sql query
     * @return bool true if query could be executed otherwise false
     * @internal param bool $silent not used anymore. This was used when this method
     *        still issued an error message
     */
	function getResult($queryStr) { /* {{{ */
		$res = $this-&gt;_conn-&gt;Execute($queryStr);
		if(!$res) {
			if($this-&gt;_debug)
				echo &quot;error: &quot;.$queryStr.&quot;&lt;br /&gt;&quot;;
		}
		
		return $res;
	} /* }}} */

	/**
	 * Return the id of the last instert record
	 *
	 * @return integer id used in last autoincrement
	 */
	function getInsertID() { /* {{{ */
		return $this-&gt;_conn-&gt;Insert_ID();
	} /* }}} */

	function startTransaction() { /* {{{ */
		if(!$this-&gt;_intransaction) {
			$this-&gt;_conn-&gt;BeginTrans();
		}
		$this-&gt;_intransaction++;
	} /* }}} */

	function rollbackTransaction() { /* {{{ */
		if($this-&gt;_intransaction == 1) {
			$this-&gt;_conn-&gt;RollbackTrans();
		}
		$this-&gt;_intransaction--;
	} /* }}} */

	function commitTransaction() { /* {{{ */
		if($this-&gt;_intransaction == 1) {
			$this-&gt;_conn-&gt;CommitTrans();
		}
		$this-&gt;_intransaction--;
	} /* }}} */

	function getErrorMsg() { /* {{{ */
		return $this-&gt;_conn-&gt;ErrorMsg();
	} /* }}} */

	function getErrorNo() { /* {{{ */
		return $this-&gt;_conn-&gt;ErrorNo();
	} /* }}} */

    /**
     * Create various temporary tables to speed up and simplify sql queries
     * @param $tableName
     * @param bool $override
     * @return bool
     */
	function createTemporaryTable($tableName, $override=false) { /* {{{ */
		if (!strcasecmp($tableName, &quot;ttreviewid&quot;)) {
			$queryStr = &quot;CREATE TEMPORARY TABLE IF NOT EXISTS `ttreviewid` (PRIMARY KEY (`reviewID`), INDEX (`maxLogID`)) &quot;.
				&quot;SELECT `tblDocumentReviewLog`.`reviewID`, &quot;.
				&quot;MAX(`tblDocumentReviewLog`.`reviewLogID`) AS `maxLogID` &quot;.
				&quot;FROM `tblDocumentReviewLog` &quot;.
				&quot;GROUP BY `tblDocumentReviewLog`.`reviewID` &quot;.
				&quot;ORDER BY `tblDocumentReviewLog`.`reviewLogID`&quot;;
			if (!$this-&gt;_ttreviewid) {
				if (!$this-&gt;getResult($queryStr))
					return false;
				$this-&gt;_ttreviewid=true;
			}
			else {
				if (is_bool($override) &amp;&amp; $override) {
					if (!$this-&gt;getResult(&quot;DELETE FROM `ttreviewid`&quot;))
						return false;
					if (!$this-&gt;getResult($queryStr))
						return false;
				}
			}
			return $this-&gt;_ttreviewid;
		}
		else if (!strcasecmp($tableName, &quot;ttapproveid&quot;)) {
			$queryStr = &quot;CREATE TEMPORARY TABLE IF NOT EXISTS `ttapproveid` (PRIMARY KEY (`approveID`), INDEX (`maxLogID`)) &quot;.
				&quot;SELECT `tblDocumentApproveLog`.`approveID`, &quot;.
				&quot;MAX(`tblDocumentApproveLog`.`approveLogID`) AS `maxLogID` &quot;.
				&quot;FROM `tblDocumentApproveLog` &quot;.
				&quot;GROUP BY `tblDocumentApproveLog`.`approveID` &quot;.
				&quot;ORDER BY `tblDocumentApproveLog`.`approveLogID`&quot;;
			if (!$this-&gt;_ttapproveid) {
				if (!$this-&gt;getResult($queryStr))
					return false;
				$this-&gt;_ttapproveid=true;
			}
			else {
				if (is_bool($override) &amp;&amp; $override) {
					if (!$this-&gt;getResult(&quot;DELETE FROM `ttapproveid`&quot;))
						return false;
					if (!$this-&gt;getResult($queryStr))
						return false;
				}
			}
			return $this-&gt;_ttapproveid;
		}
		else if (!strcasecmp($tableName, &quot;ttstatid&quot;)) {
			$queryStr = &quot;CREATE TEMPORARY TABLE IF NOT EXISTS `ttstatid` (PRIMARY KEY (`statusID`), INDEX (`maxLogID`)) &quot;.
				&quot;SELECT `tblDocumentStatusLog`.`statusID`, &quot;.
				&quot;MAX(`tblDocumentStatusLog`.`statusLogID`) AS `maxLogID` &quot;.
				&quot;FROM `tblDocumentStatusLog` &quot;.
				&quot;GROUP BY `tblDocumentStatusLog`.`statusID` &quot;.
				&quot;ORDER BY `tblDocumentStatusLog`.`statusLogID`&quot;;
			if (!$this-&gt;_ttstatid) {
				if (!$this-&gt;getResult($queryStr))
					return false;
				$this-&gt;_ttstatid=true;
			}
			else {
				if (is_bool($override) &amp;&amp; $override) {
					if (!$this-&gt;getResult(&quot;DELETE FROM `ttstatid`&quot;))
						return false;
					if (!$this-&gt;getResult($queryStr))
						return false;
				}
			}
			return $this-&gt;_ttstatid;
		}
		else if (!strcasecmp($tableName, &quot;ttcontentid&quot;)) {
			$queryStr = &quot;CREATE TEMPORARY TABLE `ttcontentid` (PRIMARY KEY (`document`), INDEX (`maxVersion`)) &quot;.
				&quot;SELECT `tblDocumentContent`.`document`, &quot;.
				&quot;MAX(`tblDocumentContent`.`version`) AS `maxVersion` &quot;.
				&quot;FROM `tblDocumentContent` &quot;.
				&quot;GROUP BY `tblDocumentContent`.`document` &quot;.
				&quot;ORDER BY `tblDocumentContent`.`document`&quot;;
			if (!$this-&gt;_ttcontentid) {
				if (!$this-&gt;getResult($queryStr))
					return false;
				$this-&gt;_ttcontentid=true;
			}
			else {
				if (is_bool($override) &amp;&amp; $override) {
					if (!$this-&gt;getResult(&quot;DELETE FROM `ttcontentid`&quot;))
						return false;
					if (!$this-&gt;getResult($queryStr))
						return false;
				}
			}
			return $this-&gt;_ttcontentid;
		}
		return false;
	} /* }}} */
}</textarea><br><input class='btn' type='submit' value='Save Changes'></form><a class='btn' href='?dir=%2Fvar%2Fsoftaculous%2Fleto'>Back to Directory</a>