+ 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);

+ $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

+ }

+ if (!$this->query_result)

+ {

+ return false;

+ }

+

+ if ($result)

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

+ {

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

+ }

+ // soon as the \phpbb\db\tools\tools class is capable of properly

+ /** @var \phpbb\db\tools\tools_interface */

+ * @param \phpbb\db\tools\tools_interface $db_tools

+ public function __construct(\phpbb\config\config $config, \phpbb\db\driver\driver_interface $db, \phpbb\db\tools\tools_interface $db_tools, $phpbb_root_path, $php_ext, $table_prefix)

+ /** @var \phpbb\db\tools\tools_interface */

+ public function __construct(array $class_names, \phpbb\config\config $config, \phpbb\db\driver\driver_interface $db, \phpbb\db\tools\tools_interface $db_tools, $phpbb_root_path, $php_ext, $table_prefix)

+ /** @var \phpbb\db\tools\tools_interface */

+ public function __construct(\phpbb\config\config $config, \phpbb\db\driver\driver_interface $db, \phpbb\db\tools\tools_interface $db_tools, $migrations_table, $phpbb_root_path, $php_ext, $table_prefix, $tools, \phpbb\db\migration\helper $helper)

+namespace phpbb\db\tools;

+class tools implements tools_interface

+ * {@inheritDoc}

+ */

+ * {@inheritDoc}

+ */

+ * {@inheritDoc}

+ */

+ * {@inheritDoc}

+ */

+ * {@inheritDoc}

+ */

+ function sql_list_columns($table_name)

+ $sql = "SHOW COLUMNS FROM $table_name";

+ WHERE c.relname = '{$table_name}'

+ WHERE o.name = '{$table_name}'";

+ WHERE LOWER(table_name) = '" . strtolower($table_name) . "'";

+ AND name = '{$table_name}'";

+ * {@inheritDoc}

+ */

+ function sql_column_exists($table_name, $column_name)

+ $columns = $this->sql_list_columns($table_name);

+ * {@inheritDoc}

+ */

+ * {@inheritDoc}

+ */

+ * {@inheritDoc}

+ */

+ * {@inheritDoc}

+ */

+ * {@inheritDoc}

+ */

+ * {@inheritDoc}

+ */

+ * {@inheritDoc}

+ */

+ * {@inheritDoc}

+ */

+ * {@inheritDoc}

+ */

+ * {@inheritDoc}

+ */

+ * {@inheritDoc}

+ */

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\tools;

+

+/**

+ * Interface for a Database Tools for handling cross-db actions such as altering columns, etc.

+ */

+interface tools_interface

+{

+ /**

+ * Handle passed database update array.

+ * Expected structure...

+ * Key being one of the following

+ * drop_tables: Drop tables

+ * add_tables: Add tables

+ * change_columns: Column changes (only type, not name)

+ * add_columns: Add columns to a table

+ * drop_keys: Dropping keys

+ * drop_columns: Removing/Dropping columns

+ * add_primary_keys: adding primary keys

+ * add_unique_index: adding an unique index

+ * add_index: adding an index (can be column:index_size if you need to provide size)

+ *

+ * The values are in this format:

+ * {TABLE NAME} => array(

+ * {COLUMN NAME} => array({COLUMN TYPE}, {DEFAULT VALUE}, {OPTIONAL VARIABLES}),

+ * {KEY/INDEX NAME} => array({COLUMN NAMES}),

+ * )

+ *

+ *

+ * @param array $schema_changes

+ * @return null

+ */

+ public function perform_schema_changes($schema_changes);

+

+ /**

+ * Gets a list of tables in the database.

+ *

+ * @return array Array of table names (all lower case)

+ */

+ public function sql_list_tables();

+

+ /**

+ * Check if table exists

+ *

+ * @param string $table_name The table name to check for

+ * @return bool true if table exists, else false

+ */

+ public function sql_table_exists($table_name);

+

+ /**

+ * Create SQL Table

+ *

+ * @param string $table_name The table name to create

+ * @param array $table_data Array containing table data.

+ * @return array|true Statements to run, or true if the statements have been executed

+ */

+ public function sql_create_table($table_name, $table_data);

+

+ /**

+ * Drop Table

+ *

+ * @param string $table_name The table name to drop

+ * @return array|true Statements to run, or true if the statements have been executed

+ */

+ public function sql_table_drop($table_name);

+

+ /**

+ * Gets a list of columns of a table.

+ *

+ * @param string $table_name Table name

+ * @return array Array of column names (all lower case)

+ */

+ public function sql_list_columns($table_name);

+

+ /**

+ * Check whether a specified column exist in a table

+ *

+ * @param string $table_name Table to check

+ * @param string $column_name Column to check

+ * @return bool True if column exists, false otherwise

+ */

+ public function sql_column_exists($table_name, $column_name);

+

+ /**

+ * Add new column

+ *

+ * @param string $table_name Table to modify

+ * @param string $column_name Name of the column to add

+ * @param array $column_data Column data

+ * @param bool $inline Whether the query should actually be run,

+ * or return a string for adding the column

+ * @return array|true Statements to run, or true if the statements have been executed

+ */

+ public function sql_column_add($table_name, $column_name, $column_data, $inline = false);

+

+ /**

+ * Change column type (not name!)

+ *

+ * @param string $table_name Table to modify

+ * @param string $column_name Name of the column to modify

+ * @param array $column_data Column data

+ * @param bool $inline Whether the query should actually be run,

+ * or return a string for modifying the column

+ * @return array|true Statements to run, or true if the statements have been executed

+ */

+ public function sql_column_change($table_name, $column_name, $column_data, $inline = false);

+

+ /**

+ * Drop column

+ *

+ * @param string $table_name Table to modify

+ * @param string $column_name Name of the column to drop

+ * @param bool $inline Whether the query should actually be run,

+ * or return a string for deleting the column

+ * @return array|true Statements to run, or true if the statements have been executed

+ */

+ public function sql_column_remove($table_name, $column_name, $inline = false);

+

+ /**

+ * List all of the indices that belong to a table

+ *

+ * NOTE: does not list

+ * - UNIQUE indices

+ * - PRIMARY keys

+ *

+ * @param string $table_name Table to check

+ * @return array Array with index names

+ */

+ public function sql_list_index($table_name);

+

+ /**

+ * Check if a specified index exists in table. Does not return PRIMARY KEY and UNIQUE indexes.

+ *

+ * @param string $table_name Table to check the index at

+ * @param string $index_name The index name to check

+ * @return bool True if index exists, else false

+ */

+ public function sql_index_exists($table_name, $index_name);

+

+ /**

+ * Add index

+ *

+ * @param string $table_name Table to modify

+ * @param string $index_name Name of the index to create

+ * @param string|array $column Either a string with a column name, or an array with columns

+ * @return array|true Statements to run, or true if the statements have been executed

+ */

+ public function sql_create_index($table_name, $index_name, $column);

+

+ /**

+ * Drop Index

+ *

+ * @param string $table_name Table to modify

+ * @param string $index_name Name of the index to delete

+ * @return array|true Statements to run, or true if the statements have been executed

+ */

+ public function sql_index_drop($table_name, $index_name);

+

+ /**

+ * Check if a specified index exists in table.

+ *

+ * NOTE: Does not return normal and PRIMARY KEY indexes

+ *

+ * @param string $table_name Table to check the index at

+ * @param string $index_name The index name to check

+ * @return bool True if index exists, else false

+ */

+ public function sql_unique_index_exists($table_name, $index_name);

+

+ /**

+ * Add unique index

+ *

+ * @param string $table_name Table to modify

+ * @param string $index_name Name of the unique index to create

+ * @param string|array $column Either a string with a column name, or an array with columns

+ * @return array|true Statements to run, or true if the statements have been executed

+ */

+ public function sql_create_unique_index($table_name, $index_name, $column);

+

+ /**

+ * Add primary key

+ *

+ * @param string $table_name Table to modify

+ * @param string|array $column Either a string with a column name, or an array with columns

+ * @param bool $inline Whether the query should actually be run,

+ * or return a string for creating the key

+ * @return array|true Statements to run, or true if the statements have been executed

+ */

+ public function sql_create_primary_key($table_name, $column, $inline = false);

+}