+ const LOGICAL_OP = 0;

+ const STATEMENTS = 1;

+ const LEFT_STMT = 0;

+ const COMPARE_OP = 1;

+ const RIGHT_STMT = 2;

+ const SUBQUERY_OP = 3;

+ const SUBQUERY_SELECT_TYPE = 4;

+ const SUBQUERY_BUILD = 5;

+

+ if ($query_id)

+ if (!$query_id)

+ if (!$query_id)

+ if ($query_id)

+ $expression = str_replace(array('_', '%'), array("\_", "\%"), $expression);

+ $expression = str_replace(array(chr(0) . "\_", chr(0) . "\%"), array('_', '%'), $expression);

+ $expression = str_replace(array('_', '%'), array("\_", "\%"), $expression);

+ $expression = str_replace(array(chr(0) . "\_", chr(0) . "\%"), array('_', '%'), $expression);

+ $sql .= ' WHERE ';

+

+ if (is_array($array['WHERE']))

+ {

+ $sql_where = $this->_process_boolean_tree_first($array['WHERE']);

+ }

+ else

+ {

+ $sql_where = $array['WHERE'];

+ }

+

+ $sql .= $this->_sql_custom_build('WHERE', $sql_where);

+

+ protected function _process_boolean_tree_first($operations_ary)

+ {

+ // In cases where an array exists but there is no head condition,

+ // it should be because there's only 1 WHERE clause. This seems the best way to deal with it.

+ if ($operations_ary[self::LOGICAL_OP] !== 'AND' &&

+ $operations_ary[self::LOGICAL_OP] !== 'OR')

+ {

+ $operations_ary = array('AND', array($operations_ary));

+ }

+ return $this->_process_boolean_tree($operations_ary) . "\n";

+ }

+

+ protected function _process_boolean_tree($operations_ary)

+ {

+ $operation = $operations_ary[self::LOGICAL_OP];

+

+ foreach ($operations_ary[self::STATEMENTS] as &$condition)

+ {

+ switch ($condition[self::LOGICAL_OP])

+ {

+ case 'AND':

+ case 'OR':

+

+ $condition = ' ( ' . $this->_process_boolean_tree($condition) . ') ';

+

+ break;

+ case 'NOT':

+

+ $condition = ' NOT (' . $this->_process_boolean_tree($condition) . ') ';

+

+ break;

+

+ default:

+

+ switch (sizeof($condition))

+ {

+ case 3:

+

+ // Typical 3 element clause with {left hand} {operator} {right hand}

+ switch ($condition[self::COMPARE_OP])

+ {

+ case 'IN':

+ case 'NOT_IN':

+

+ // As this is used with an IN, assume it is a set of elements for sql_in_set()

+ $condition = $this->sql_in_set($condition[self::LEFT_STMT], $condition[self::RIGHT_STMT], $condition[self::COMPARE_OP] === 'NOT_IN', true);

+

+ break;

+

+ case 'LIKE':

+

+ $condition = $condition[self::LEFT_STMT] . ' ' . $this->sql_like_expression($condition[self::RIGHT_STMT]) . ' ';

+

+ break;

+

+ case 'NOT_LIKE':

+

+ $condition = $condition[self::LEFT_STMT] . ' ' . $this->sql_not_like_expression($condition[self::RIGHT_STMT]) . ' ';

+

+ break;

+

+ case 'IS_NOT':

+

+ $condition[self::COMPARE_OP] = 'IS NOT';

+

+ // no break

+ case 'IS':

+

+ // If the value is NULL, the string of it is the empty string ('') which is not the intended result.

+ // this should solve that

+ if ($condition[self::RIGHT_STMT] === null)

+ {

+ $condition[self::RIGHT_STMT] = 'NULL';

+ }

+

+ $condition = implode(' ', $condition);

+

+ break;

+

+ default:

+

+ $condition = implode(' ', $condition);

+

+ break;

+ }

+

+ break;

+

+ case 5:

+

+ // Subquery with {left hand} {operator} {compare kind} {SELECT Kind } {Sub Query}

+

+ $condition = $condition[self::LEFT_STMT] . ' ' . $condition[self::COMPARE_OP] . ' ' . $condition[self::SUBQUERY_OP] . ' ( ';

+ $condition .= $this->sql_build_query($condition[self::SUBQUERY_SELECT_TYPE], $condition[self::SUBQUERY_BUILD]);

+ $condition .= ' )';

+

+ break;

+

+ default:

+ // This is an unpredicted clause setup. Just join all elements.

+ $condition = implode(' ', $condition);

+

+ break;

+ }

+

+ break;

+ }

+

+ }

+

+ if ($operation === 'NOT')

+ {

+ $operations_ary = implode("", $operations_ary[self::STATEMENTS]);

+ }

+ else

+ {

+ $operations_ary = implode(" \n $operation ", $operations_ary[self::STATEMENTS]);

+ }

+

+ return $operations_ary;

+ }

+

+

+ global $cache, $starttime, $phpbb_root_path, $phpbb_path_helper;

+ $row = mssql_fetch_assoc($result_id);

+ mssql_free_result($result_id);

+ if (!$this->query_result)

+ {

+ return false;

+ }

+

+ else if (strpos($query, 'SELECT') === 0 && $this->query_result !== true)

+ if (!$query_id || $query_id === true)

+ $row = mssql_fetch_assoc($query_id);

+ if ($query_id === true)

+ {

+ return false;

+ }

+

+ return ($query_id) ? @mssql_data_seek($query_id, $rownum) : false;

+ if ($row = mssql_fetch_assoc($result_id))

+ mssql_free_result($result_id);

+ mssql_free_result($result_id);

+ if ($query_id === true)

+ {

+ return false;

+ }

+

+ return mssql_free_result($query_id);

+ $row = mssql_fetch_assoc($result_id);

+ mssql_free_result($result_id);

+ $row = mssql_fetch_assoc($result_id);

+ mssql_free_result($result_id);

+ while ($row = mssql_fetch_row($result))

+ mssql_free_result($result);

+ if ($result)

+ while ($void = mssql_fetch_assoc($result))

+ {

+ // Take the time spent on parsing rows into account

+ }

+ mssql_free_result($result);

+ $row = odbc_fetch_array($result_id);

+ odbc_free_result($result_id);

+ if (!$this->query_result)

+ {

+ return false;

+ }

+

+ else if (strpos($query, 'SELECT') === 0)

+ return ($query_id) ? odbc_fetch_array($query_id) : false;

+ if (odbc_fetch_array($result_id))

+ $id = odbc_result($result_id, 1);

+ odbc_free_result($result_id);

+ odbc_free_result($result_id);

+ return odbc_free_result($query_id);

+ if ($result)

+ while ($void = odbc_fetch_array($result))

+ {

+ // Take the time spent on parsing rows into account

+ }

+ odbc_free_result($result);

+ if (!$this->query_result)

+ {

+ return false;

+ }

+

+ else if (strpos($query, 'SELECT') === 0)

+ if (!$query_id)

+ $row = sqlsrv_fetch_array($query_id, SQLSRV_FETCH_ASSOC);

+ if ($result_id)

+ $row = sqlsrv_fetch_array($result_id);

+ sqlsrv_free_stmt($result_id);

+ return sqlsrv_free_stmt($query_id);

+ sqlsrv_next_result($result);

+ while ($row = sqlsrv_fetch_array($result))

+ sqlsrv_free_stmt($result);

+ if ($result)

+ while ($void = sqlsrv_fetch_array($result))

+ {

+ // Take the time spent on parsing rows into account

+ }

+ sqlsrv_free_stmt($result);

+ if ($result)

+ {

+ $row = mysql_fetch_assoc($result);

+ mysql_free_result($result);

+ $modes = array_map('trim', explode(',', $row['sql_mode']));

+ }

+ else

+ {

+ $modes = array();

+ }

+ if ($result)

+ {

+ $row = mysql_fetch_assoc($result);

+ mysql_free_result($result);

+ $this->sql_server_version = $row['version'];

+ if (!empty($cache) && $use_cache)

+ {

+ $cache->put('mysql_version', $this->sql_server_version);

+ }

+ if (!$this->query_result)

+ {

+ return false;

+ }

+

+ else if (strpos($query, 'SELECT') === 0)

+ return ($query_id) ? mysql_fetch_assoc($query_id) : false;

+ return mysql_free_result($query_id);

+ while ($row = mysql_fetch_assoc($result))

+ mysql_free_result($result);

+ while ($row = mysql_fetch_assoc($result))

+ mysql_free_result($result);

+ if ($result)

+ while ($void = mysql_fetch_assoc($result))

+ {

+ // Take the time spent on parsing rows into account

+ }

+ mysql_free_result($result);

+ if ($result)

+ $row = mysqli_fetch_assoc($result);

+ mysqli_free_result($result);

+ if ($result)

+ $row = mysqli_fetch_assoc($result);

+ mysqli_free_result($result);

+ if (!$this->query_result)

+ {

+ return false;

+ }

+

+ if ($query_id)

+ $result = mysqli_fetch_assoc($query_id);

+ return ($query_id) ? @mysqli_data_seek($query_id, $rownum) : false;

+ if (!$query_id)

+ {

+ return false;

+ }

+

+ if ($query_id === true)

+ {

+ return true;

+ }

+

+ return mysqli_free_result($query_id);

+ while ($row = mysqli_fetch_assoc($result))

+ mysqli_free_result($result);

+ while ($row = mysqli_fetch_assoc($result))

+ mysqli_free_result($result);

+ if ($result)

+ while ($void = mysqli_fetch_assoc($result))

+ mysqli_free_result($result);

+ if (!$this->query_result)

+ {

+ return false;

+ }

+

+ else if (strpos($query, 'SELECT') === 0)

+ if ($query_id)

+ $result = ocifetchinto($query_id, $row, OCI_ASSOC + OCI_RETURN_NULLS);

+ if (!$query_id)

+ if ($stmt)

+ {

+ $success = @ociexecute($stmt, OCI_DEFAULT);

+ if ($success)

+ {

+ $temp_result = ocifetchinto($stmt, $temp_array, OCI_ASSOC + OCI_RETURN_NULLS);

+ ocifreestatement($stmt);

+ if ($temp_result)

+ {

+ return $temp_array['CURRVAL'];

+ }

+ else

+ {

+ return false;

+ }

+ }

+ return ocifreestatement($query_id);

+ if ($result)

+ $success = @ociexecute($result, OCI_DEFAULT);

+ if ($success)

+ {

+ $row = array();

+

+ while (ocifetchinto($result, $row, OCI_ASSOC + OCI_RETURN_NULLS))

+ {

+ // Take the time spent on parsing rows into account

+ }

+ @ocifreestatement($result);

+ }

+ if ($query_id)

+ {

+ $row = pg_fetch_assoc($query_id, null);

+ pg_free_result($query_id);

+ $this->sql_server_version = (!empty($row['version'])) ? trim(substr($row['version'], 10)) : 0;

+ if (!empty($cache) && $use_cache)

+ {

+ $cache->put('pgsql_version', $this->sql_server_version);

+ }

+ if (!$this->query_result)

+ {

+ return false;

+ }

+

+ else if (strpos($query, 'SELECT') === 0)

+ return ($query_id) ? pg_fetch_assoc($query_id, null) : false;

+ return ($query_id) ? @pg_result_seek($query_id, $rownum) : false;

+ $temp_result = pg_fetch_assoc($temp_q_id, null);

+ pg_free_result($query_id);

+ return pg_free_result($query_id);

+ while ($row = pg_fetch_assoc($result, null))

+ pg_free_result($result);

+ if ($result)

+ while ($void = pg_fetch_assoc($result, null))

+ {

+ // Take the time spent on parsing rows into account

+ }

+ pg_free_result($result);

+ if ($result)

+ {

+ $row = sqlite_fetch_array($result, SQLITE_ASSOC);

+ $this->sql_server_version = (!empty($row['version'])) ? $row['version'] : 0;

+ if (!empty($cache) && $use_cache)

+ {

+ $cache->put('sqlite_version', $this->sql_server_version);

+ }

+ if (!$this->query_result)

+ return false;

+

+ if ($cache && $cache_ttl)

+ $this->query_result = $cache->sql_save($this, $query, $this->query_result, $cache_ttl);

+ return ($query_id) ? sqlite_fetch_array($query_id, SQLITE_ASSOC) : false;

+ return ($query_id) ? @sqlite_seek($query_id, $rownum) : false;

+ if ($result)

+ while ($void = sqlite_fetch_array($result, SQLITE_ASSOC))

+ {

+ // Take the time spent on parsing rows into account

+ }

+ return @$this->dbo->exec('ROLLBACK');

+ if ($this->transaction === true && strpos($query, 'INSERT') === 0)

+ {

+ $query = preg_replace('/^INSERT INTO/', 'INSERT OR ROLLBACK INTO', $query);

+ }

+

+ // Try to recover a lost database connection

+ if ($this->dbo && !@$this->dbo->lastErrorMsg())

+ {

+ if ($this->sql_connect($this->server, $this->user, '', $this->dbname))

+ {

+ $this->query_result = @$this->dbo->query($query);

+ }

+ }

+

+ if ($this->query_result === false)

+ {

+ $this->sql_error($query);

+ }

+ if (!$this->query_result)

+ {

+ return false;

+ }

+

+ /** @var \SQLite3Result $query_id */

+ return is_object($query_id) ? @$query_id->fetchArray(SQLITE3_ASSOC) : false;

+ if ($result)

+ while ($void = $result->fetchArray(SQLITE3_ASSOC))

+ {

+ // Take the time spent on parsing rows into account

+ }