case 'SELECT':

case 'SELECT_DISTINCT';

$table_array = array();

foreach ($array['FROM'] as $table_name => $alias)

break;

}

return $sql;

}

{

$this->sql_transaction('rollback');

}

if (strlen($message) > 1024)

{

// We need to define $msg_long_text here to circumvent text stripping.

$this->_sql_report($mode, $query);

break;

case 'record_fromcache':

case 'begin':

$result = true;

$this->transaction = true;

case 'commit':

$result = @ibase_commit();

{

@ibase_rollback();

}

case 'rollback':

$result = @ibase_rollback();

$this->transaction = false;

default:

$result = true;

{

global $cache;

$this->last_query_text = $query;

$this->query_result = ($cache_ttl && method_exists($cache, 'sql_load')) ? $cache->sql_load($query) : false;

$this->sql_add_num_queries($this->query_result);

$this->sql_error($query);

}

if (!$this->transaction)

{

@ibase_commit_ret();

* Build LIMIT query

*/

function sql_query_limit($query, $total, $offset = 0, $cache_ttl = 0)

{

$query = 'SELECT FIRST ' . $total . ((!empty($offset)) ? ' SKIP ' . $offset : '') . substr($query, 6);

return $this->sql_query($query, $cache_ttl);

}

/**

{

$this->sql_rowseek($rownum, $query_id);

}

$row = $this->sql_fetchrow($query_id);

return isset($row[$field]) ? $row[$field] : false;

}

$query_id = $this->query_result;

}

// We do not fetch the row for rownum == 0 because then the next resultset would be the second row

for ($i = 0; $i < $rownum; $i++)

{

{

if ($this->query_result && preg_match('#^INSERT[\t\n ]+INTO[\t\n ]+([a-z0-9\_\-]+)#is', $this->last_query_text, $tablename))

{

{

return false;

}

return ($temp_result) ? $temp_result->NEW_ID : false;

}

}

return false;

}

case 'begin':

$result = @mssql_query('BEGIN TRANSACTION', $this->db_connect_id);

$this->transaction = true;

case 'commit':

$result = @mssql_query('commit', $this->db_connect_id);

{

@mssql_query('ROLLBACK', $this->db_connect_id);

}

case 'rollback':

$result = @mssql_query('ROLLBACK', $this->db_connect_id);

$this->transaction = false;

default:

$result = true;

* Build LIMIT query

*/

function sql_query_limit($query, $total, $offset = 0, $cache_ttl = 0)

{

// if $total is set to 0 we do not want to limit the number of rows

if ($total == 0)

}

return $this->sql_query($query, $cache_ttl);

}

/**

}

$row = @mssql_fetch_assoc($query_id);

// I hope i am able to remove this later... hopefully only a PHP or MSSQL bug

if ($row)

{

{

$this->sql_rowseek($rownum, $query_id);

}

$row = $this->sql_fetchrow($query_id);

return isset($row[$field]) ? $row[$field] : false;

}

return false;

}

case 'begin':

$result = @odbc_autocommit($this->db_connect_id, false);

$this->transaction = true;

case 'commit':

$result = @odbc_commit($this->db_connect_id);

@odbc_rollback($this->db_connect_id);

@odbc_autocommit($this->db_connect_id, true);

}

case 'rollback':

$result = @odbc_rollback($this->db_connect_id);

@odbc_autocommit($this->db_connect_id, true);

$this->transaction = false;

default:

$result = true;

{

$this->sql_report('start', $query);

}

$this->last_query_text = $query;

$this->query_result = ($cache_ttl && method_exists($cache, 'sql_load')) ? $cache->sql_load($query) : false;

* Build LIMIT query

*/

function sql_query_limit($query, $total, $offset = 0, $cache_ttl = 0)

{

// if $total is set to 0 we do not want to limit the number of rows

if ($total == 0)

$query = 'SELECT TOP ' . ($row_offset + $num_rows) . ' ' . substr($query, 6);

}

}

/**

{

return $cache->sql_fetchrow($query_id);

}

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

}

{

$this->sql_rowseek($rownum, $query_id);

}

$row = $this->sql_fetchrow($query_id);

return isset($row[$field]) ? $row[$field] : false;

}

case 'begin':

$result = @mysql_query('BEGIN', $this->db_connect_id);

$this->transaction = true;

case 'commit':

$result = @mysql_query('COMMIT', $this->db_connect_id);

{

@mysql_query('ROLLBACK', $this->db_connect_id);

}

case 'rollback':

$result = @mysql_query('ROLLBACK', $this->db_connect_id);

$this->transaction = false;

default:

$result = true;

* Build LIMIT query

*/

function sql_query_limit($query, $total, $offset = 0, $cache_ttl = 0)

{

// if $total is set to 0 we do not want to limit the number of rows

if ($total == 0)

$query .= "\n LIMIT " . ((!empty($offset)) ? $offset . ', ' . $total : $total);

}

/**

$data = '(' . $data . ')';

break;

}

return $data;

}

/**

* return sql error array

* @private

'code' => @mysql_errno()

);

}

return array(

'message' => @mysql_error($this->db_connect_id),

'code' => @mysql_errno($this->db_connect_id)

case 'begin':

$result = @mysql_query('BEGIN', $this->db_connect_id);

$this->transaction = true;

case 'commit':

$result = @mysql_query('COMMIT', $this->db_connect_id);

$this->transaction = false;

if (!$result)

{

@mysql_query('ROLLBACK', $this->db_connect_id);

}

case 'rollback':

$result = @mysql_query('ROLLBACK', $this->db_connect_id);

$this->transaction = false;

default:

$result = true;

* Build LIMIT query

*/

function sql_query_limit($query, $total, $offset = 0, $cache_ttl = 0)

{

// if $total is set to 0 we do not want to limit the number of rows

if ($total == 0)

$query .= "\n LIMIT " . ((!empty($offset)) ? $offset . ', ' . $total : $total);

}

/**

{

return @mysql_real_escape_string($msg);

}

return @mysql_real_escape_string($msg, $this->db_connect_id);

}

$data = '(' . $data . ')';

break;

}

return $data;

}

'code' => @mysql_errno()

);

}

return array(

'message' => @mysql_error($this->db_connect_id),

'code' => @mysql_errno($this->db_connect_id)

case 'begin':

$result = @mysqli_autocommit($this->db_connect_id, false);

$this->transaction = true;

case 'commit':

$result = @mysqli_commit($this->db_connect_id);

@mysqli_rollback($this->db_connect_id);

@mysqli_autocommit($this->db_connect_id, true);

}

case 'rollback':

$result = @mysqli_rollback($this->db_connect_id);

@mysqli_autocommit($this->db_connect_id, true);

$this->transaction = false;

default:

$result = true;

* Build LIMIT query

*/

function sql_query_limit($query, $total, $offset = 0, $cache_ttl = 0)

{

// if $total is set to 0 we do not want to limit the number of rows

if ($total == 0)

$query .= "\n LIMIT " . ((!empty($offset)) ? $offset . ', ' . $total : $total);

}

/**

{

$this->sql_rowseek($rownum, $query_id);

}

$row = $this->sql_fetchrow($query_id);

return isset($row[$field]) ? $row[$field] : false;

}

$data = '(' . $data . ')';

break;

}

return $data;

}

/**

* return sql error array

* @private

case 'begin':

$result = true;

$this->transaction = true;

case 'commit':

$result = @ocicommit($this->db_connect_id);

{

@ocirollback($this->db_connect_id);

}

case 'rollback':

$result = @ocirollback($this->db_connect_id);

$this->transaction = false;

default:

$result = true;

{

global $cache;

// EXPLAIN only in extra debug mode

if (defined('DEBUG_EXTRA'))

{

$this->sql_report('start', $query);

}

$this->last_query_text = $query;

$this->query_result = ($cache_ttl && method_exists($cache, 'sql_load')) ? $cache->sql_load($query) : false;

$this->sql_add_num_queries($this->query_result);

$this->sql_transaction('commit');

}

}

if (defined('DEBUG_EXTRA'))

{

$this->sql_report('stop', $query);

* Build LIMIT query

*/

function sql_query_limit($query, $total, $offset = 0, $cache_ttl = 0)

{

$this->query_result = false;

$query = 'SELECT * FROM (SELECT /*+ FIRST_ROWS */ rownum AS xrownum, a.* FROM (' . $query . ') a WHERE rownum <= ' . ($offset + $total) . ') WHERE xrownum >= ' . $offset;

return $this->sql_query($query, $cache_ttl);

return false;

}

/**

{

return $cache->sql_fetchrow($query_id);

}

$row = array();

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

{

$this->sql_rowseek($rownum, $query_id);

}

$row = $this->sql_fetchrow($query_id);

return isset($row[$field]) ? $row[$field] : false;

}

return false;

}

case 'begin':

$result = @pg_query($this->db_connect_id, 'BEGIN');

$this->transaction = true;

case 'commit':

$result = @pg_query($this->db_connect_id, 'COMMIT');

{

@pg_query($this->db_connect_id, 'ROLLBACK');

}

case 'rollback':

$result = @pg_query($this->db_connect_id, 'ROLLBACK');

$this->transaction = false;

default:

$result = true;

{

global $cache;

// EXPLAIN only in extra debug mode

if (defined('DEBUG_EXTRA'))

{

*/

function sql_query_limit($query, $total, $offset = 0, $cache_ttl = 0)

{

{

$this->query_result = false;

$query .= "\n LIMIT $total OFFSET $offset";

return $this->sql_query($query, $cache_ttl);

return false;

}

/**

{

$this->sql_rowseek($rownum, $query_id);

}

$row = $this->sql_fetchrow($query_id);

return isset($row[$field]) ? $row[$field] : false;

}

{

$query = "SELECT currval('" . $tablename[1] . "_seq') AS last_value";

$temp_q_id = @pg_query($this->db_connect_id, $query);

if (!$temp_q_id)

{

return false;

{

$query_id = $this->query_result;

}

if (isset($this->open_queries[(int) $query_id]))

{

unset($this->open_queries[(int) $query_id]);

/**

* Escape string used in sql query

*/

function sql_escape($msg)

{

return @pg_escape_string($msg);

}

case 'begin':

$result = @sqlite_query('BEGIN', $this->db_connect_id);

$this->transaction = true;

case 'commit':

$result = @sqlite_query('COMMIT', $this->db_connect_id);

{

@sqlite_query('ROLLBACK', $this->db_connect_id);

}

case 'rollback':

$result = @sqlite_query('ROLLBACK', $this->db_connect_id);

$this->transaction = false;

default:

$result = true;

{

global $cache;

// EXPLAIN only in extra debug mode

if (defined('DEBUG_EXTRA'))

{

* Build LIMIT query

*/

function sql_query_limit($query, $total, $offset = 0, $cache_ttl = 0)

{

$this->query_result = false;

$query .= "\n LIMIT " . ((!empty($offset)) ? $offset . ', ' . $total : $total);

return $this->sql_query($query, $cache_ttl);

}

/**

}

else

{

return @sqlite_column($query_id, $field);

}

}

$topic_id_list[$post_data['topic_id']] = 1;

// Topic or Post. ;)

{

if ($post_data['forum_id'])

{