- '%core.root_path%'

- '@request'

- '@dbal.conn.driver'

$sql = 'VALUES ' . implode(', ', preg_replace('#^(.*?)$#', '(\1)', $sql_subary));

break;

case 'sqlite3':

$sql = implode(' UNION ALL ', preg_replace('#^(.*?)$#', 'SELECT \1', $sql_subary));

break;

->directory('/db/migration/data')

->get_classes();

$factory = new \phpbb\db\tools\factory();

$db_tools = $factory->get($db, true);

<li>MySQL 3.23 or above (MySQLi supported)</li>

<li>MariaDB 5.1 or above</li>

<li>PostgreSQL 8.3+</li>

<li>SQLite 3.6.15+</li>

<li>MS SQL Server 2000 or above (via ODBC or the native adapter)</li>

<li>Oracle</li>

<p>Please remember that running any application on a development (unstable, e.g. a beta release) version of PHP can lead to strange/unexpected results which may appear to be bugs in the application. Therefore, we recommend you upgrade to the newest stable version of PHP before running phpBB. If you are running a development version of PHP please check any bugs you find on a system running a stable release before submitting.</p>

<a name="phpsec"></a><h3>7.i. Notice on PHP security issues</h3>

// We might wanna empty out all that junk :D

switch ($db->get_sql_layer())

{

case 'sqlite3':

$extractor->flush('DELETE FROM ' . $table_name . ";\n");

break;

case 'mysql':

case 'mysql4':

case 'mysqli':

case 'sqlite3':

while (($sql = $fgetd($fp, ";\n", $read, $seek, $eof)) !== false)

{

{

switch ($db->get_sql_layer())

{

case 'sqlite3':

$db->sql_query('DELETE FROM ' . $table);

break;

case 'db_track':

switch ($db->get_sql_layer())

{

case 'sqlite3':

$db->sql_query('DELETE FROM ' . TOPICS_POSTED_TABLE);

break;

{

switch ($db->get_sql_layer())

{

case 'sqlite3':

$db->sql_query("DELETE FROM $table");

break;

// Teh standard

case 'postgres':

case 'oracle':

case 'sqlite3':

// Change the reports using this reason to 'other'

$sql = 'UPDATE ' . REPORTS_TABLE . '

// Get number of online guests

{

$sql = 'SELECT COUNT(session_ip) as num_guests

FROM (

// Clear table

switch ($db->get_sql_layer())

{

case 'sqlite3':

$db->sql_query('DELETE FROM ' . MODERATOR_CACHE_TABLE);

break;

}

break;

case 'sqlite3':

global $dbhost;

$sql = 'VALUES ' . implode(', ', preg_replace('#^(.*?)$#', '(\1)', $sql_subary));

break;

case 'sqlite3':

case 'mssqlnative':

$sql = implode(' UNION ALL ', preg_replace('#^(.*?)$#', 'SELECT \1', $sql_subary));

switch ($db->get_sql_layer())

{

case 'sqlite3':

$db->sql_query('DELETE FROM ' . TOPICS_POSTED_TABLE);

break;

switch ($this->db->get_sql_layer())

{

case 'sqlite3':

$this->db->sql_query('DELETE FROM ' . $this->session_keys_table);

$this->db->sql_query('DELETE FROM ' . $this->session_table);

$convert->mysql_convert = false;

switch ($src_db->sql_layer)

{

case 'sqlite3':

$convert->src_truncate_statement = 'DELETE FROM ';

break;

switch ($db->get_sql_layer())

{

case 'sqlite3':

$convert->truncate_statement = 'DELETE FROM ';

break;

)';

break;

case 'sqlite3':

$create_sql = 'CREATE TABLE ' . USERCONV_TABLE . ' (

user_id INTEGER NOT NULL DEFAULT \'0\',

<ul>

<li>MySQL 3.23 or above (MySQLi supported)</li>

<li>PostgreSQL 8.3+</li>

<li>SQLite 3.6.15+</li>

<li>MS SQL Server 2000 or above (directly or via ODBC)</li>

<li>MS SQL Server 2005 or above (native)</li>

'DB_OPTION_MYSQLI' => 'MySQL with MySQLi Extension',

'DB_OPTION_ORACLE' => 'Oracle',

'DB_OPTION_POSTGRES' => 'PostgreSQL',

'DB_OPTION_SQLITE3' => 'SQLite 3',

// Errors

'INST_ERR_DB_NO_ERROR' => 'No error message given.',

'INST_ERR_PREFIX' => 'Tables with the specified prefix already exist, please choose an alternative.',

'INST_ERR_DB_NO_MYSQLI' => 'The version of MySQL installed on this machine is incompatible with the “MySQL with MySQLi Extension” option you have selected. Please try the “MySQL” option instead.',

'INST_ERR_DB_NO_SQLITE3' => 'The version of the SQLite extension you have installed is too old, it must be upgraded to at least 3.6.15.',

'INST_ERR_DB_NO_ORACLE' => 'The version of Oracle installed on this machine requires you to set the <var>NLS_CHARACTERSET</var> parameter to <var>UTF8</var>. Either upgrade your installation to 9.2+ or change the parameter.',

'INST_ERR_DB_NO_POSTGRES' => 'The database you have selected was not created in <var>UNICODE</var> or <var>UTF8</var> encoding. Try installing with a database in <var>UNICODE</var> or <var>UTF8</var> encoding.',

{

return $this->container->get('dbal.extractor.extractors.postgres_extractor');

}

else if ($this->db instanceof \phpbb\db\driver\sqlite3)

{

return $this->container->get('dbal.extractor.extractors.sqlite3_extractor');

'VARBINARY' => 'raw(255)',

),

'sqlite3' => array(

'INT:' => 'INT(%d)',

'BINT' => 'BIGINT(20)',

$sql = 'SHOW TABLES';

break;

case 'sqlite3':

$sql = 'SELECT name

FROM sqlite_master

{

case 'mysql_40':

case 'mysql_41':

case 'sqlite3':

$table_sql .= ",\n\t PRIMARY KEY (" . implode(', ', $table_data['PRIMARY_KEY']) . ')';

break;

break;

case 'mysql_40':

case 'sqlite3':

$table_sql .= "\n);";

$statements[] = $table_sql;

$sqlite = false;

// For SQLite we need to perform the schema changes in a much more different way

{

$sqlite_data = array();

$sqlite = true;

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

break;

case 'sqlite3':

$sql = "SELECT sql

FROM sqlite_master

$col = 'index_name';

break;

case 'sqlite3':

$sql = "PRAGMA index_list('" . $table_name . "');";

$col = 'name';

switch ($this->sql_layer)

{

case 'oracle':

case 'sqlite3':

$row[$col] = substr($row[$col], strlen($table_name) + 1);

break;

$col = 'index_name';

break;

case 'sqlite3':

$sql = "PRAGMA index_list('" . $table_name . "');";

$col = 'name';

continue;

}

{

continue;

}

}

break;

case 'sqlite3':

$row[$col] = substr($row[$col], strlen($table_name) + 1);

break;

break;

case 'sqlite3':

$return_array['primary_key_set'] = false;

if (isset($column_data[2]) && $column_data[2] == 'auto_increment')

{

$return_array['primary_key_set'] = true;

}

else

{

$statements[] = 'ALTER TABLE ' . $table_name . ' ADD ' . $column_name . ' ' . $column_data['column_type_sql'];

break;

case 'sqlite3':

if ($inline && $this->return_statements)

{

$statements[] = 'ALTER TABLE ' . $table_name . ' DROP COLUMN ' . $column_name;

break;

case 'sqlite3':

if ($inline && $this->return_statements)

break;

case 'oracle':

case 'sqlite3':

$statements[] = 'DROP INDEX ' . $table_name . '_' . $index_name;

break;

$statements[] = 'ALTER TABLE ' . $table_name . ' add CONSTRAINT pk_' . $table_name . ' PRIMARY KEY (' . implode(', ', $column) . ')';

break;

case 'sqlite3':

if ($inline && $this->return_statements)

switch ($this->sql_layer)

{

case 'oracle':

case 'sqlite3':

$statements[] = 'CREATE UNIQUE INDEX ' . $table_name . '_' . $index_name . ' ON ' . $table_name . '(' . implode(', ', $column) . ')';

break;

switch ($this->sql_layer)

{

case 'oracle':

case 'sqlite3':

$statements[] = 'CREATE INDEX ' . $table_name . '_' . $index_name . ' ON ' . $table_name . '(' . implode(', ', $column) . ')';

break;

$col = 'index_name';

break;

case 'sqlite3':

$sql = "PRAGMA index_info('" . $table_name . "');";

$col = 'name';

switch ($this->sql_layer)

{

case 'oracle':

case 'sqlite3':

$row[$col] = substr($row[$col], strlen($table_name) + 1);

break;

$this->return_statements = $old_return_statements;

break;

case 'sqlite3':

if ($inline && $this->return_statements)

{

case 'mysql_40':

case 'mysql_41':

case 'sqlite3':

// Not supported

throw new \Exception('DBMS is not supported');

'AVAILABLE' => true,

'2.0.x' => true,

),

'sqlite3' => array(

'LABEL' => 'SQLite3',

'SCHEMA' => 'sqlite',

);

}

break;

case 'sqlite3':

if (version_compare($db->sql_server_info(true), '3.6.15', '<'))

{

break;

case 'sqlite3':

$sql_array_count['SELECT'] = ($type == 'posts') ? 'DISTINCT p.post_id' : 'DISTINCT p.topic_id';

$sql = 'SELECT COUNT(' . (($type == 'posts') ? 'post_id' : 'topic_id') . ') as total_results

}

else

{

{

$sql = 'SELECT COUNT(topic_id) as total_results

FROM (SELECT DISTINCT t.topic_id';

$post_visibility

$sql_fora

AND t.topic_id = p.topic_id

}

$result = $this->db->sql_query($sql);

{

switch ($this->db->get_sql_layer())

{

case 'sqlite3':

$this->db->sql_query('DELETE FROM ' . SEARCH_WORDLIST_TABLE);

$this->db->sql_query('DELETE FROM ' . SEARCH_WORDMATCH_TABLE);

{

switch ($db->get_sql_layer())

{

case 'sqlite3':

$sql = 'SELECT COUNT(session_ip) as num_guests

FROM (

array('mysqli'),

array('oracle'),

array('postgres'),

);

}

parent::setUp();

$this->config = new \phpbb\config\config(array());

$factory = new \phpbb\db\tools\factory();

$this->db_tools = $factory->get($this->db);

$this->table_prefix = 'phpbb_';

global $table_prefix;

$factory = new \phpbb\db\tools\factory();

$db_tools = $factory->get($db, true);

switch ($this->dbms['PDO'])

{

case 'sqlite': // SQLite3 driver

$dsn .= $this->config['dbhost'];

break;

{

switch ($this->config['dbms'])

{

case 'phpbb\db\driver\sqlite3':

$this->connect();

// Drop all of the tables

$sql = 'SHOW TABLES';

break;

case 'phpbb\db\driver\sqlite3':

$sql = 'SELECT name

FROM sqlite_master

$classes = $finder->core_path('phpbb/db/migration/data/')

->get_classes();

$factory = new \phpbb\db\tools\factory();

$db_tools = $factory->get($db, true);

'DELIM' => ';',

'PDO' => 'pgsql',

),

'phpbb\db\driver\sqlite3' => array(

'SCHEMA' => 'sqlite',

'DELIM' => ';',

'dbpasswd' => '',

));

}

if (isset($_SERVER['PHPBB_TEST_CONFIG']))

{