/phpBB/images/avatars/upload/*

/phpBB/store/*

/phpBB/vendor

/tests/test_config*.php

/tests/tmp/*

env: DB=mariadb

- php: 5.4

env: DB=postgres

allow_failures:

- php: hhvm

case 'mssql':

case 'sqlite':

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

break;

case 'mysql_41':

case 'firebird':

case 'sqlite':

fwrite($fp, "# DO NOT EDIT THIS FILE, IT IS GENERATED\n");

fwrite($fp, "#\n");

fwrite($fp, "# To change the contents of this file, edit\n");

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

<li>MariaDB 5.1 or above</li>

<li>PostgreSQL 8.3+</li>

<li>Firebird 2.1+</li>

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

<li>Oracle</li>

$extractor = new sqlite_extractor($format, $filename, $time, $download, $store);

break;

case 'postgres':

$extractor = new postgres_extractor($format, $filename, $time, $download, $store);

break;

switch ($db->sql_layer)

{

case 'sqlite':

case 'firebird':

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

break;

case 'mysql4':

case 'mysqli':

case 'sqlite':

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

{

$db->sql_query($sql);

/**

* @package acp

*/

class postgres_extractor extends base_extractor

{

function write_start($prefix)

switch ($db->sql_layer)

{

case 'sqlite':

case 'firebird':

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

break;

switch ($db->sql_layer)

{

case 'sqlite':

case 'firebird':

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

break;

switch ($db->sql_layer)

{

case 'sqlite':

case 'firebird':

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

break;

switch ($db->sql_layer)

{

case 'sqlite':

$sql = "SELECT sql

FROM sqlite_master

WHERE type = 'table'

break;

case 'sqlite':

{

$sql = "SELECT sql

FROM sqlite_master

case 'oracle':

case 'firebird':

case 'sqlite':

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

$sql = 'UPDATE ' . REPORTS_TABLE . '

SET reason_id = ' . $other_reason_id . ", report_text = '" . $db->sql_escape($reason_row['reason_description']) . "\n\n' || report_text

// Get number of online guests

{

$sql = 'SELECT COUNT(session_ip) as num_guests

FROM (

switch ($db->sql_layer)

{

case 'sqlite':

case 'firebird':

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

break;

break;

case 'sqlite':

global $dbhost;

if (file_exists($dbhost))

case 'mssql':

case 'sqlite':

case 'mssqlnative':

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

break;

switch ($db->sql_layer)

{

case 'sqlite':

case 'firebird':

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

break;

'AVAILABLE' => true,

'2.0.x' => false,

),

);

if ($dbms)

$db->sql_return_on_error(true);

// Check that we actually have a database name before going any further.....

{

$error[] = $lang['INST_ERR_DB_NO_NAME'];

return false;

}

// Make sure we don't have a daft user who thinks having the SQLite database in the forum directory is a good idea

{

$error[] = $lang['INST_ERR_DB_FORUM_PATH'];

return false;

break;

case 'phpbb\db\driver\sqlite':

$prefix_length = 200;

break;

}

break;

case 'phpbb\db\driver\firebird':

// check the version of FB, use some hackery if we can't get access to the server info

if ($db->service_handle !== false && function_exists('ibase_server_info'))

break;

case 'sqlite':

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

user_id INTEGER NOT NULL DEFAULT \'0\',

username_clean varchar(255) NOT NULL DEFAULT \'\'

switch ($db->sql_layer)

{

case 'sqlite':

case 'firebird':

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

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

switch ($src_db->sql_layer)

{

case 'sqlite':

case 'firebird':

$convert->src_truncate_statement = 'DELETE FROM ';

break;

switch ($db->sql_layer)

{

case 'sqlite':

case 'firebird':

$convert->truncate_statement = 'DELETE FROM ';

break;

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

'DLL_ORACLE' => 'Oracle',

'DLL_POSTGRES' => 'PostgreSQL',

'DLL_XML' => 'XML support [ Jabber ]',

'DLL_ZLIB' => 'zlib compression support [ gz, .tar.gz, .zip ]',

'DL_CONFIG' => 'Download config',

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

<li>PostgreSQL 8.3+</li>

<li>SQLite 2.8.2+</li>

<li>Firebird 2.1+</li>

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

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

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

'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_SQLITE' => 'The version of the SQLite extension you have installed is too old, it must be upgraded to at least 2.8.2.',

'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_FIREBIRD' => 'The version of Firebird installed on this machine is older than 2.1, please upgrade to a newer version.',

'INST_ERR_DB_NO_FIREBIRD_PS'=> 'The database you selected for Firebird has a page size less than 8192, it must be at least 8192.',

'VARBINARY' => 'blob',

),

'postgres' => array(

'INT:' => 'INT4',

'BINT' => 'INT8',

* A list of supported DBMS. We change this class to support more DBMS, the DBMS itself only need to follow some rules.

* @var array

*/

/**

* This is set to true if user only wants to return the 'to-be-executed' SQL statement(s) (as an array).

WHERE type = "table"';

break;

case 'mssql':

case 'mssql_odbc':

case 'mssqlnative':

case 'mysql_41':

case 'postgres':

case 'sqlite':

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

break;

case 'mysql_40':

case 'sqlite':

$table_sql .= "\n);";

$statements[] = $table_sql;

break;

$sqlite = false;

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

{

$sqlite_data = array();

$sqlite = true;

break;

case 'sqlite':

$sql = "SELECT sql

FROM sqlite_master

WHERE type = 'table'

break;

case 'sqlite':

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

$col = 'name';

break;

case 'oracle':

case 'postgres':

case 'sqlite':

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

break;

}

break;

case 'sqlite':

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

$col = 'name';

break;

continue;

}

{

continue;

}

case 'firebird':

case 'postgres':

case 'sqlite':

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

break;

}

break;

case 'sqlite':

$return_array['primary_key_set'] = false;

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

{

$sql .= ' INTEGER PRIMARY KEY';

$return_array['primary_key_set'] = true;

}

else

{

break;

case 'sqlite':

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

{

return $column_name . ' ' . $column_data['column_type_sql'];

}

{

{

}

{

}

break;

}

break;

case 'sqlite':

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

{

return $column_name;

}

{

{

}

{

}

break;

}

case 'oracle':

case 'postgres':

case 'sqlite':

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

break;

}

break;

case 'sqlite':

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

{

return $column;

}

{

break;

}

$statements[] = 'begin';

// Create a backup table and populate it, destroy the existing one

$statements[] = 'INSERT INTO ' . $table_name . '_temp SELECT * FROM ' . $table_name;

$statements[] = 'DROP TABLE ' . $table_name;

$new_table_cols = trim($matches[1]);

$old_table_cols = preg_split('/,(?![\s\w]+\))/m', $new_table_cols);

// create a new table and fill it up. destroy the temp one

$statements[] = 'CREATE TABLE ' . $table_name . ' (' . $new_table_cols . ', PRIMARY KEY (' . implode(', ', $column) . '));';

$statements[] = 'INSERT INTO ' . $table_name . ' (' . $columns . ') SELECT ' . $columns . ' FROM ' . $table_name . '_temp;';

$statements[] = 'DROP TABLE ' . $table_name . '_temp';

case 'postgres':

case 'oracle':

case 'sqlite':

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

break;

case 'postgres':

case 'oracle':

case 'sqlite':

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

break;

break;

case 'sqlite':

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

$col = 'name';

break;

case 'oracle':

case 'postgres':

case 'sqlite':

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

break;

}

break;

case 'sqlite':

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

{

return $column_name . ' ' . $column_data['column_type_sql'];

}

{

break;

}

$statements[] = 'begin';

// Create a temp table and populate it, destroy the existing one

$statements[] = 'INSERT INTO ' . $table_name . '_temp SELECT * FROM ' . $table_name;

$statements[] = 'DROP TABLE ' . $table_name;

$new_table_cols = trim($matches[1]);

$old_table_cols = preg_split('/,(?![\s\w]+\))/m', $new_table_cols);

$columns = implode(',', $column_list);

$statements[] = 'CREATE TABLE ' . $table_name . ' (' . implode(',', $old_table_cols) . ');';

$statements[] = 'INSERT INTO ' . $table_name . ' (' . $columns . ') SELECT ' . $columns . ' FROM ' . $table_name . '_temp;';

$statements[] = 'DROP TABLE ' . $table_name . '_temp';

return $this->is_sql_server_2000;

}

}

break;

case 'sqlite':

$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

FROM (' . $this->db->sql_build_query('SELECT', $sql_array_count) . ')';

}

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->sql_layer)

{

case 'sqlite':

case 'firebird':

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

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

switch ($db->sql_layer)

{

case 'sqlite':

$sql = 'SELECT COUNT(session_ip) as num_guests

FROM (

SELECT DISTINCT session_ip

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

{

case 'sqlite2':

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

break;

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

{

case 'phpbb\db\driver\sqlite':

case 'phpbb\db\driver\firebird':

$this->connect();

// Drop all of the tables

WHERE type = "table"';

break;

case 'phpbb\db\driver\mssql':

case 'phpbb\db\driver\mssql_odbc':

case 'phpbb\db\driver\mssqlnative':

'DELIM' => ';',

'PDO' => 'sqlite2',

),

);

if (isset($available_dbms[$dbms]))

$queries[] = 'SELECT ' . implode(', ', $setval_queries);

}

break;

}

foreach ($queries as $query)

{

$config = array();

{

$config = array_merge($config, array(

'dbms' => 'phpbb\db\driver\sqlite',

</groups>

<php>

<server name="PHPBB_TEST_DBMS" value="phpbb\db\driver\postgres"/>

<server name="PHPBB_TEST_DBHOST" value="localhost" />

<server name="PHPBB_TEST_DBPORT" value="5432" />