+/tests/phpbb_unit_tests.sqlite*

+ - php: 5.4

+ env: DB=sqlite3

+ fast_finish: true

+ var windowWidth = $(window).width();

+

+ var $this = $(this);

+ var freeSpace = parent.offset().left - 4;

+

+ if (direction == 'left') {

+ options.dropdown.css('margin-left', '-' + freeSpace + 'px');

+ } else {

+ options.dropdown.css('margin-right', '-' + (windowWidth + freeSpace) + 'px');

+ }

+ case 'sqlite3':

+ case 'sqlite3':

+ marc1706 (Marc Alexander)

+ <li>SQLite 2.8.2+</li>

+ <li>SQLite 3.6.15+</li>

+ case 'sqlite3':

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

+ break;

+

+ case 'sqlite3':

+ case 'sqlite3':

+class sqlite3_extractor extends base_extractor

+{

+ function write_start($prefix)

+ {

+ $sql_data = "--\n";

+ $sql_data .= "-- phpBB Backup Script\n";

+ $sql_data .= "-- Dump of tables for $prefix\n";

+ $sql_data .= "-- DATE : " . gmdate("d-m-Y H:i:s", $this->time) . " GMT\n";

+ $sql_data .= "--\n";

+ $sql_data .= "BEGIN TRANSACTION;\n";

+ $this->flush($sql_data);

+ }

+

+ function write_table($table_name)

+ {

+ global $db;

+ $sql_data = '-- Table: ' . $table_name . "\n";

+ $sql_data .= "DROP TABLE $table_name;\n";

+

+ $sql = "SELECT sql

+ FROM sqlite_master

+ WHERE type = 'table'

+ AND name = '" . $db->sql_escape($table_name) . "'

+ ORDER BY name ASC;";

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

+ $row = $db->sql_fetchrow($result);

+ $db->sql_freeresult($result);

+

+ // Create Table

+ $sql_data .= $row['sql'] . ";\n";

+

+ $result = $db->sql_query("PRAGMA index_list('" . $db->sql_escape($table_name) . "');");

+

+ while ($row = $db->sql_fetchrow($result))

+ {

+ if (strpos($row['name'], 'autoindex') !== false)

+ {

+ continue;

+ }

+

+ $result2 = $db->sql_query("PRAGMA index_info('" . $db->sql_escape($row['name']) . "');");

+

+ $fields = array();

+ while ($row2 = $db->sql_fetchrow($result2))

+ {

+ $fields[] = $row2['name'];

+ }

+ $db->sql_freeresult($result2);

+

+ $sql_data .= 'CREATE ' . ($row['unique'] ? 'UNIQUE ' : '') . 'INDEX ' . $row['name'] . ' ON ' . $table_name . ' (' . implode(', ', $fields) . ");\n";

+ }

+ $db->sql_freeresult($result);

+

+ $this->flush($sql_data . "\n");

+ }

+

+ function write_data($table_name)

+ {

+ global $db;

+

+ $result = $db->sql_query("PRAGMA table_info('" . $db->sql_escape($table_name) . "');");

+

+ $col_types = array();

+ while ($row = $db->sql_fetchrow($result))

+ {

+ $col_types[$row['name']] = $row['type'];

+ }

+ $db->sql_freeresult($result);

+

+ $sql_insert = 'INSERT INTO ' . $table_name . ' (' . implode(', ', array_keys($col_types)) . ') VALUES (';

+

+ $sql = "SELECT *

+ FROM $table_name";

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

+

+ while ($row = $db->sql_fetchrow($result))

+ {

+ foreach ($row as $column_name => $column_data)

+ {

+ if (is_null($column_data))

+ {

+ $row[$column_name] = 'NULL';

+ }

+ else if ($column_data === '')

+ {

+ $row[$column_name] = "''";

+ }

+ else if (stripos($col_types[$column_name], 'text') !== false || stripos($col_types[$column_name], 'char') !== false || stripos($col_types[$column_name], 'blob') !== false)

+ {

+ $row[$column_name] = sanitize_data_generic(str_replace("'", "''", $column_data));

+ }

+ }

+ $this->flush($sql_insert . implode(', ', $row) . ");\n");

+ }

+ }

+

+ function write_end()

+ {

+ $this->flush("COMMIT;\n");

+ parent::write_end();

+ }

+}

+

+/**

+* @package acp

+*/

+ case 'sqlite3':

+ case 'sqlite3':

+ case 'sqlite3':

+ case 'sqlite3':

+ case 'sqlite3':

+ if (version_compare($db->sql_server_info(true), '3.0') == -1)

+ case 'sqlite3':

+ global $config, $user, $phpbb_path_helper;

+ $php_ext = $phpbb_path_helper->get_php_ext();

+ if ($config['enable_mod_rewrite'] && strpos($page, 'app.' . $php_ext . '/') === 0)

+ $page = substr($page, strlen('app.' . $php_ext . '/'));

+ $page = $phpbb_path_helper->get_phpbb_root_path() . $page;

+ if ($strip_vars !== false)

+ $redirect = $phpbb_path_helper->strip_url_params($redirect, $strip_vars, false);

+ return $redirect . ((strpos($redirect, '?') === false) ? '?' : '');

+ if ($db->sql_layer === 'sqlite' || $db->sql_layer === 'sqlite3')

+ case 'sqlite3':

+ case 'sqlite3':

+ global $config, $auth, $template, $user, $db, $phpbb_path_helper;

+ $url_parts = $phpbb_path_helper->get_url_parts($action);

+

+ 'S_DISPLAY_JUMPBOX' => $display_jumpbox,

+ 'S_JUMPBOX_ACTION' => $action,

+ 'HIDDEN_FIELDS_FOR_JUMPBOX' => build_hidden_fields($url_parts['params']),

+ ));

+ case 'sqlite3':

+ case 'sqlite3':

+ 'sqlite3' => array(

+ 'LABEL' => 'SQLite3',

+ 'SCHEMA' => 'sqlite',

+ 'MODULE' => 'sqlite3',

+ 'DELIM' => ';',

+ 'DRIVER' => 'phpbb\db\driver\sqlite3',

+ 'AVAILABLE' => true,

+ '2.0.x' => false,

+ ),

+ if ($dbms_details['DRIVER'] != 'phpbb\db\driver\sqlite' && $dbms_details['DRIVER'] != 'phpbb\db\driver\sqlite3' && $dbms_details['DRIVER'] != 'phpbb\db\driver\oracle' && $dbname === '')

+ if (($dbms_details['DRIVER'] == 'phpbb\db\driver\sqlite' || $dbms_details['DRIVER'] == 'phpbb\db\driver\sqlite3') && stripos(phpbb_realpath($dbhost), phpbb_realpath('../')) === 0)

+ case 'phpbb\db\driver\sqlite3':

+ case 'phpbb\db\driver\sqlite3':

+ $version = \SQLite3::version();

+ if (version_compare($version['versionString'], '3.6.15', '<'))

+ {

+ $error[] = $lang['INST_ERR_DB_NO_SQLITE3'];

+ }

+ break;

+

+ $u_pm = $u_jabber = '';

+

+ if ($config['allow_privmsg'] && $auth->acl_get('u_sendpm') && ($user_info['user_allow_pm'] || $auth->acl_gets('a_', 'm_') || $auth->acl_getf_global('m_')))

+ {

+ $u_pm = append_sid("{$phpbb_root_path}ucp.$phpEx", 'i=pm&amp;mode=compose&amp;u=' . $author_id);

+ }

+

+ if ($user_info['user_jabber'] && $auth->acl_get('u_sendim'))

+ {

+ $u_jabber = append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=contact&amp;action=jabber&amp;u=' . $author_id);

+ }

+

+ 'U_PM' => $u_pm,

+ 'U_JABBER' => $u_jabber,

+ $contact_fields = array(

+ array(

+ 'ID' => 'pm',

+ 'NAME' => $user->lang['PRIVATE_MESSAGE'],

+ 'U_CONTACT' => $u_pm,

+ ),

+ array(

+ 'ID' => 'email',

+ 'NAME' => $user->lang['SEND_EMAIL'],

+ 'U_CONTACT' => $user_info['email'],

+ ),

+ array(

+ 'ID' => 'jabber',

+ 'NAME' => $user->lang['JABBER'],

+ 'U_CONTACT' => $u_jabber,

+ ),

+ );

+

+ foreach ($contact_fields as $field)

+ {

+ if ($field['U_CONTACT'])

+ {

+ $template->assign_block_vars('contact', $field);

+ }

+ }

+

+

+ if ($cp_block_row['S_PROFILE_CONTACT'])

+ {

+ $template->assign_block_vars('contact', array(

+ 'ID' => $cp_block_row['PROFILE_FIELD_IDENT'],

+ 'NAME' => $cp_block_row['PROFILE_FIELD_NAME'],

+ 'U_CONTACT' => $cp_block_row['PROFILE_FIELD_CONTACT'],

+ ));

+ }

+ case 'sqlite3':

+ case 'sqlite3':

+ case 'sqlite3':

+ case 'sqlite3':

+ 'CONTACT_USER' => 'Contact',

+ 'DLL_SQLITE' => 'SQLite 2',

+ 'DLL_SQLITE3' => 'SQLite 3',

+ <li>SQLite 3.6.15+</li>

+ '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.',

+<?php

+/**

+*

+* @package dbal

+* @copyright (c) 2014 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+namespace phpbb\db\driver;

+

+/**

+* SQLite3 Database Abstraction Layer

+* Minimum Requirement: 3.6.15+

+* @package dbal

+*/

+class sqlite3 extends \phpbb\db\driver\driver

+{

+ /**

+ * @var string Stores errors during connection setup in case the driver is not available

+ */

+ protected $connect_error = '';

+

+ /**

+ * @var \SQLite3 The SQLite3 database object to operate against

+ */

+ protected $dbo = null;

+

+ /**

+ * {@inheritDoc}

+ */

+ public function sql_connect($sqlserver, $sqluser, $sqlpassword, $database, $port = false, $persistency = false, $new_link = false)

+ {

+ $this->persistency = false;

+ $this->user = $sqluser;

+ $this->server = $sqlserver . (($port) ? ':' . $port : '');

+ $this->dbname = $database;

+

+ if (!class_exists('SQLite3', false))

+ {

+ $this->connect_error = 'SQLite3 not found, is the extension installed?';

+ return $this->sql_error('');

+ }

+

+ try

+ {

+ $this->dbo = new \SQLite3($this->server, SQLITE3_OPEN_READWRITE | SQLITE3_OPEN_CREATE);

+ $this->db_connect_id = true;

+ }

+ catch (Exception $e)

+ {

+ return array('message' => $e->getMessage());

+ }

+

+ return true;

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function sql_server_info($raw = false, $use_cache = true)

+ {

+ global $cache;

+

+ if (!$use_cache || empty($cache) || ($this->sql_server_version = $cache->get('sqlite_version')) === false)

+ {

+ $version = \SQLite3::version();

+

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

+

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

+ {

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

+ }

+ }

+

+ return ($raw) ? $this->sql_server_version : 'SQLite ' . $this->sql_server_version;

+ }

+

+ /**

+ * SQL Transaction

+ *

+ * @param string $status Should be one of the following strings:

+ * begin, commit, rollback

+ * @return bool Success/failure of the transaction query

+ */

+ protected function _sql_transaction($status = 'begin')

+ {

+ switch ($status)

+ {

+ case 'begin':

+ return $this->dbo->exec('BEGIN IMMEDIATE');

+ break;

+

+ case 'commit':

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

+ break;

+

+ case 'rollback':

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

+ break;

+ }

+

+ return true;

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function sql_query($query = '', $cache_ttl = 0)

+ {

+ if ($query != '')

+ {

+ global $cache;

+

+ // EXPLAIN only in extra debug mode

+ if (defined('DEBUG'))

+ {

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

+ }

+

+ $this->last_query_text = $query;

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

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

+

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

+ {

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

+ {

+ $this->sql_error($query);

+ }

+

+ if (defined('DEBUG'))

+ {

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

+ }

+

+ if ($cache && $cache_ttl)

+ {

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

+ }

+ }

+ else if (defined('DEBUG'))

+ {

+ $this->sql_report('fromcache', $query);

+ }

+ }

+ else

+ {

+ return false;

+ }

+

+ return $this->query_result;

+ }

+

+ /**

+ * Build LIMIT query

+ *

+ * @param string $query The SQL query to execute

+ * @param int $total The number of rows to select

+ * @param int $offset

+ * @param int $cache_ttl Either 0 to avoid caching or

+ * the time in seconds which the result shall be kept in cache

+ * @return mixed Buffered, seekable result handle, false on error

+ */

+ protected function _sql_query_limit($query, $total, $offset = 0, $cache_ttl = 0)

+ {

+ $this->query_result = false;

+

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

+ if ($total == 0)

+ {

+ $total = -1;

+ }

+

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

+

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

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function sql_affectedrows()

+ {

+ return ($this->db_connect_id) ? $this->dbo->changes() : false;

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function sql_fetchrow($query_id = false)

+ {

+ global $cache;

+

+ if ($query_id === false)

+ {

+ $query_id = $this->query_result;

+ }

+

+ if ($cache && !is_object($query_id) && $cache->sql_exists($query_id))

+ {

+ return $cache->sql_fetchrow($query_id);

+ }

+

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

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function sql_nextid()

+ {

+ return ($this->db_connect_id) ? $this->dbo->lastInsertRowID() : false;

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function sql_freeresult($query_id = false)

+ {

+ global $cache;

+

+ if ($query_id === false)

+ {

+ $query_id = $this->query_result;

+ }

+

+ if ($cache && !is_object($query_id) && $cache->sql_exists($query_id))

+ {

+ return $cache->sql_freeresult($query_id);

+ }

+

+ if ($query_id)

+ {

+ return @$query_id->finalize();

+ }

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function sql_escape($msg)

+ {

+ return \SQLite3::escapeString($msg);

+ }

+

+ /**

+ * {@inheritDoc}

+ *

+ * For SQLite an underscore is a not-known character...

+ */

+ public function sql_like_expression($expression)

+ {

+ // Unlike LIKE, GLOB is case sensitive (unfortunatly). SQLite users need to live with it!

+ // We only catch * and ? here, not the character map possible on file globbing.

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

+

+ $expression = str_replace(array('?', '*'), array("\?", "\*"), $expression);

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

+

+ return 'GLOB \'' . $this->sql_escape($expression) . '\'';

+ }

+

+ /**

+ * return sql error array

+ *

+ * @return array

+ */

+ protected function _sql_error()

+ {

+ if (class_exists('SQLite3', false))

+ {

+ $error = array(

+ 'message' => $this->dbo->lastErrorMsg(),

+ 'code' => $this->dbo->lastErrorCode(),

+ );

+ }

+ else

+ {

+ $error = array(

+ 'message' => $this->connect_error,

+ 'code' => '',

+ );

+ }

+

+ return $error;

+ }

+

+ /**

+ * Build db-specific query data

+ *

+ * @param string $stage Available stages: FROM, WHERE

+ * @param mixed $data A string containing the CROSS JOIN query or an array of WHERE clauses

+ *

+ * @return string The db-specific query fragment

+ */

+ protected function _sql_custom_build($stage, $data)

+ {

+ return $data;

+ }

+

+ /**

+ * Close sql connection

+ *

+ * @return bool False if failure

+ */

+ protected function _sql_close()

+ {

+ return $this->dbo->close();

+ }

+

+ /**

+ * Build db-specific report

+ *

+ * @param string $mode Available modes: display, start, stop,

+ * add_select_row, fromcache, record_fromcache

+ * @param string $query The Query that should be explained

+ * @return mixed Either a full HTML page, boolean or null

+ */

+ protected function _sql_report($mode, $query = '')

+ {

+ switch ($mode)

+ {

+ case 'start':

+

+ $explain_query = $query;

+ if (preg_match('/UPDATE ([a-z0-9_]+).*?WHERE(.*)/s', $query, $m))

+ {

+ $explain_query = 'SELECT * FROM ' . $m[1] . ' WHERE ' . $m[2];

+ }

+ else if (preg_match('/DELETE FROM ([a-z0-9_]+).*?WHERE(.*)/s', $query, $m))

+ {

+ $explain_query = 'SELECT * FROM ' . $m[1] . ' WHERE ' . $m[2];

+ }

+

+ if (preg_match('/^SELECT/', $explain_query))

+ {

+ $html_table = false;

+

+ if ($result = $this->dbo->query("EXPLAIN QUERY PLAN $explain_query"))

+ {

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

+ {

+ $html_table = $this->sql_report('add_select_row', $query, $html_table, $row);

+ }

+ }

+

+ if ($html_table)

+ {

+ $this->html_hold .= '</table>';

+ }

+ }

+

+ break;

+

+ case 'fromcache':

+ $endtime = explode(' ', microtime());

+ $endtime = $endtime[0] + $endtime[1];

+

+ $result = $this->dbo->query($query);

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

+ {

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

+ }

+

+ $splittime = explode(' ', microtime());

+ $splittime = $splittime[0] + $splittime[1];

+

+ $this->sql_report('record_fromcache', $query, $endtime, $splittime);

+

+ break;

+ }

+ }

+}

+ 'sqlite3' => array(

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

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

+ 'UINT' => 'INTEGER UNSIGNED',

+ 'UINT:' => 'INTEGER UNSIGNED',

+ 'TINT:' => 'TINYINT(%d)',

+ 'USINT' => 'INTEGER UNSIGNED',

+ 'BOOL' => 'INTEGER UNSIGNED',

+ 'VCHAR' => 'VARCHAR(255)',

+ 'VCHAR:' => 'VARCHAR(%d)',

+ 'CHAR:' => 'CHAR(%d)',

+ 'XSTEXT' => 'TEXT(65535)',

+ 'STEXT' => 'TEXT(65535)',

+ 'TEXT' => 'TEXT(65535)',

+ 'MTEXT' => 'MEDIUMTEXT(16777215)',

+ 'XSTEXT_UNI'=> 'TEXT(65535)',

+ 'STEXT_UNI' => 'TEXT(65535)',

+ 'TEXT_UNI' => 'TEXT(65535)',

+ 'MTEXT_UNI' => 'MEDIUMTEXT(16777215)',

+ 'TIMESTAMP' => 'INTEGER UNSIGNED', //'int(11) UNSIGNED',

+ 'DECIMAL' => 'DECIMAL(5,2)',

+ 'DECIMAL:' => 'DECIMAL(%d,2)',

+ 'PDECIMAL' => 'DECIMAL(6,3)',

+ 'PDECIMAL:' => 'DECIMAL(%d,3)',

+ 'VCHAR_UNI' => 'VARCHAR(255)',

+ 'VCHAR_UNI:'=> 'VARCHAR(%d)',

+ 'VCHAR_CI' => 'VARCHAR(255)',

+ 'VARBINARY' => 'BLOB',

+ ),

+

+ var $supported_dbms = array('firebird', 'mssql', 'mssqlnative', 'mysql_40', 'mysql_41', 'oracle', 'postgres', 'sqlite', 'sqlite3');

+ case 'sqlite3':

+ $sql = 'SELECT name

+ FROM sqlite_master

+ WHERE type = "table"

+ AND name <> "sqlite_sequence"';

+ break;

+

+ case 'sqlite3':

+ case 'sqlite3':

+ if (($this->db->sql_layer == 'sqlite' || $this->db->sql_layer == 'sqlite3') && $this->return_statements)

+ case 'sqlite3':

+ case 'sqlite3':

+ case 'sqlite3':

+ case 'sqlite3':

+ if (($this->sql_layer == 'sqlite' || $this->sql_layer == 'sqlite3') && !$row['unique'])

+ case 'sqlite3':

+ case 'sqlite3':

+

+ if ($this->sql_layer === 'sqlite3')

+ {

+ $sql .= ' AUTOINCREMENT';

+ }

+ $recreate_queries = $this->sqlite_get_recreate_table_queries($table_name);

+ if (empty($recreate_queries))

+ break;

+ }

+ $statements[] = 'begin';

+ $sql_create_table = array_shift($recreate_queries);

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

+ $statements[] = preg_replace('#CREATE\s+TABLE\s+"?' . $table_name . '"?#i', 'CREATE TEMPORARY TABLE ' . $table_name . '_temp', $sql_create_table);

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

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

+ preg_match('#\((.*)\)#s', $sql_create_table, $matches);

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

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

+ $column_list = array();

+ foreach ($old_table_cols as $declaration)

+ {

+ $entities = preg_split('#\s+#', trim($declaration));

+ if ($entities[0] == 'PRIMARY')

+ continue;

+ $column_list[] = $entities[0];

+ }

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

+ $new_table_cols = $column_name . ' ' . $column_data['column_type_sql'] . ',' . $new_table_cols;

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

+ $statements[] = 'CREATE TABLE ' . $table_name . ' (' . $new_table_cols . ');';

+ $statements = array_merge($statements, $recreate_queries);

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

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

+

+ $statements[] = 'commit';

+ break;

+

+ case 'sqlite3':

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

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

+

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

+ case 'sqlite3':

+ $recreate_queries = $this->sqlite_get_recreate_table_queries($table_name, $column_name);

+ if (empty($recreate_queries))

+ break;

+ }

+ $statements[] = 'begin';

+ $sql_create_table = array_shift($recreate_queries);

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

+ $statements[] = preg_replace('#CREATE\s+TABLE\s+"?' . $table_name . '"?#i', 'CREATE TEMPORARY TABLE ' . $table_name . '_temp', $sql_create_table);

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

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

+ preg_match('#\((.*)\)#s', $sql_create_table, $matches);

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

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

+ $column_list = array();

+ foreach ($old_table_cols as $declaration)

+ {

+ $entities = preg_split('#\s+#', trim($declaration));

+ if ($entities[0] == 'PRIMARY' || $entities[0] === $column_name)

+ continue;

+ $column_list[] = $entities[0];

+ }

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

+ $new_table_cols = trim(preg_replace('/' . $column_name . '[^,]+(?:,|$)/m', '', $new_table_cols));

+ if (substr($new_table_cols, -1) === ',')

+ // Remove the comma from the last entry again

+ $new_table_cols = substr($new_table_cols, 0, -1);

+

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

+ $statements[] = 'CREATE TABLE ' . $table_name . ' (' . $new_table_cols . ');';

+ $statements = array_merge($statements, $recreate_queries);

+

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

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

+

+ $statements[] = 'commit';

+ case 'sqlite3':

+ case 'sqlite3':

+ $recreate_queries = $this->sqlite_get_recreate_table_queries($table_name);

+ if (empty($recreate_queries))

+ $sql_create_table = array_shift($recreate_queries);

+

+ $statements[] = preg_replace('#CREATE\s+TABLE\s+"?' . $table_name . '"?#i', 'CREATE TEMPORARY TABLE ' . $table_name . '_temp', $sql_create_table);

+ preg_match('#\((.*)\)#s', $sql_create_table, $matches);

+ $statements = array_merge($statements, $recreate_queries);

+

+ case 'sqlite3':

+ case 'sqlite3':

+ case 'sqlite3':

+ case 'sqlite3':

+ case 'sqlite3':

+ $recreate_queries = $this->sqlite_get_recreate_table_queries($table_name);

+ if (empty($recreate_queries))

+ $sql_create_table = array_shift($recreate_queries);

+

+ $statements[] = preg_replace('#CREATE\s+TABLE\s+"?' . $table_name . '"?#i', 'CREATE TEMPORARY TABLE ' . $table_name . '_temp', $sql_create_table);

+ preg_match('#\((.*)\)#s', $sql_create_table, $matches);

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

+ $statements = array_merge($statements, $recreate_queries);

+

+

+ /**

+ * Returns the Queries which are required to recreate a table including indexes

+ *

+ * @param string $table_name

+ * @param string $remove_column When we drop a column, we remove the column

+ * from all indexes. If the index has no other

+ * column, we drop it completly.

+ * @return array

+ */

+ protected function sqlite_get_recreate_table_queries($table_name, $remove_column = '')

+ {

+ $queries = array();

+

+ $sql = "SELECT sql

+ FROM sqlite_master

+ WHERE type = 'table'

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

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

+ $sql_create_table = $this->db->sql_fetchfield('sql');

+ $this->db->sql_freeresult($result);

+

+ if (!$sql_create_table)

+ {

+ return array();

+ }

+ $queries[] = $sql_create_table;

+

+ $sql = "SELECT sql

+ FROM sqlite_master

+ WHERE type = 'index'

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

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

+ while ($sql_create_index = $this->db->sql_fetchfield('sql'))

+ {

+ if ($remove_column)

+ {

+ $match = array();

+ preg_match('#(?:[\w ]+)\((.*)\)#', $sql_create_index, $match);

+ if (!isset($match[1]))

+ {

+ continue;

+ }

+

+ // Find and remove $remove_column from the index

+ $columns = explode(', ', $match[1]);

+ $found_column = array_search($remove_column, $columns);

+ if ($found_column !== false)

+ {

+ unset($columns[$found_column]);

+

+ // If the column list is not empty add the index to the list

+ if (!empty($columns))

+ {

+ $queries[] = str_replace($match[1], implode(', ', $columns), $sql_create_index);

+ }

+ }

+ else

+ {

+ $queries[] = $sql_create_index;

+ }

+ }

+ else

+ {

+ $queries[] = $sql_create_index;

+ }

+ }

+ $this->db->sql_freeresult($result);

+

+ return $queries;

+ }

+

+ /**

+ * Glue URL parameters together

+ *

+ * @param array $params URL parameters in the form of array(name => value)

+ * @return string Returns the glued string, e.g. name1=value1&amp;name2=value2

+ */

+ public function glue_url_params($params)

+ {

+ $_params = array();

+

+ foreach ($params as $key => $value)

+ {

+ $_params[] = $key . '=' . $value;

+ }

+ return implode('&amp;', $_params);

+ }

+

+ /**

+ * Get the base and parameters of a URL

+ *

+ * @param string $url URL to break apart

+ * @param bool $is_amp Is the parameter separator &amp;. Defaults to true.

+ * @return array Returns the base and parameters in the form of array('base' => string, 'params' => array(name => value))

+ */

+ public function get_url_parts($url, $is_amp = true)

+ {

+ $separator = ($is_amp) ? '&amp;' : '&';

+ $params = array();

+

+ if (strpos($url, '?') !== false)

+ {

+ $base = substr($url, 0, strpos($url, '?'));

+ $args = substr($url, strlen($base) + 1);

+ $args = ($args) ? explode($separator, $args) : array();

+

+ foreach ($args as $argument)

+ {

+ if (empty($argument))

+ {

+ continue;

+ }

+ list($key, $value) = explode('=', $argument, 2);

+

+ if ($key === '')

+ {

+ continue;

+ }

+

+ $params[$key] = $value;

+ }

+ }

+ else

+ {

+ $base = $url;

+ }

+

+ return array(

+ 'base' => $base,

+ 'params' => $params,

+ );

+ }

+

+ /**

+ * Strip parameters from an already built URL.

+ *

+ * @param string $url URL to strip parameters from

+ * @param array|string $strip Parameters to strip.

+ * @param bool $is_amp Is the parameter separator &amp;. Defaults to true.

+ * @return string Returns the new URL.

+ */

+ public function strip_url_params($url, $strip, $is_amp = true)

+ {

+ $url_parts = $this->get_url_parts($url, $is_amp);

+ $params = $url_parts['params'];

+

+ if (!is_array($strip))

+ {

+ $strip = array($strip);

+ }

+

+ if (!empty($params))

+ {

+ // Strip the parameters off

+ foreach ($strip as $param)

+ {

+ unset($params[$param]);

+ }

+ }

+

+ return $url_parts['base'] . (($params) ? '?' . $this->glue_url_params($params) : '');

+ }

+

+ /**

+ * Append parameters to an already built URL.

+ *

+ * @param string $url URL to append parameters to

+ * @param array $new_params Parameters to add in the form of array(name => value)

+ * @param string $is_amp Is the parameter separator &amp;. Defaults to true.

+ * @return string Returns the new URL.

+ */

+ public function append_url_params($url, $new_params, $is_amp = true)

+ {

+ $url_parts = $this->get_url_parts($url, $is_amp);

+ $params = array_merge($url_parts['params'], $new_params);

+

+ // Move the sid to the end if it's set

+ if (isset($params['sid']))

+ {

+ $sid = $params['sid'];

+ unset($params['sid']);

+ $params['sid'] = $sid;

+ }

+

+ return $url_parts['base'] . (($params) ? '?' . $this->glue_url_params($params) : '');

+ }

+ case 'sqlite3':

+ if ($this->db->sql_layer == 'sqlite' || $this->db->sql_layer == 'sqlite3')

+ $sql_time" . (($this->db->sql_layer == 'sqlite' || $this->db->sql_layer == 'sqlite3') ? ')' : '');

+ case 'sqlite3':

+ <!-- IF .contact -->

+ <dd class="profile-contact">

+ <strong>{L_CONTACT_USER}{L_COLON}</strong>

+ <div class="dropdown-container dropdown-left">

+ <a href="#" class="dropdown-trigger"><span class="imageset icon_contact"></span></a>

+ <div class="dropdown hidden">

+ <div class="pointer"><div class="pointer-inner"></div></div>

+ <div class="dropdown-contents contact-icons">

+ <!-- BEGIN contact -->

+ {% set REMAINDER = contact.S_ROW_COUNT % 4 %}

+ <!-- DEFINE $S_LAST_CELL = ((REMAINDER eq 3) or (contact.S_LAST_ROW and contact.S_NUM_ROWS < 4)) -->

+ <!-- IF REMAINDER eq 0 -->

+ <div>

+ <!-- ENDIF -->

+ <a href="<!-- IF contact.U_CONTACT -->{contact.U_CONTACT}<!-- ELSE -->{contact.U_PROFILE_AUTHOR}<!-- ENDIF -->" title="{contact.NAME}"<!-- IF $S_LAST_CELL --> class="last-cell"<!-- ENDIF --><!-- IF contact.ID eq 'jabber' --> onclick="popup(this.href, 550, 320); return false;"<!-- ENDIF -->>

+ <span class="contact-icon {contact.ID}-icon"></span>

+ </a>

+ <!-- IF REMAINDER eq 3 or contact.S_LAST_ROW -->

+ </div>

+ <!-- ENDIF -->

+ <!-- END contact -->

+ </div>

+ </div>

+ </dd>

+ <!-- IF not S_IS_BOT and .postrow.contact -->

+ <strong>{L_CONTACT_USER}{L_COLON}</strong>

+ <div class="dropdown-container dropdown-left">

+ <a href="#" class="dropdown-trigger"><span class="imageset icon_contact"></span></a>

+ <div class="dropdown hidden">

+ <div class="pointer"><div class="pointer-inner"></div></div>

+ <div class="dropdown-contents contact-icons">

+ <!-- BEGIN contact -->

+ {% set REMAINDER = postrow.contact.S_ROW_COUNT % 4 %}

+ <!-- DEFINE $S_LAST_CELL = ((REMAINDER eq 3) or (postrow.contact.S_LAST_ROW and postrow.contact.S_NUM_ROWS < 4)) -->

+ <!-- IF REMAINDER eq 0 -->

+ <div>

+ <!-- ENDIF -->

+ <a href="<!-- IF postrow.contact.U_CONTACT -->{postrow.contact.U_CONTACT}<!-- ELSE -->{postrow.contact.U_PROFILE_AUTHOR}<!-- ENDIF -->" title="{postrow.contact.NAME}"<!-- IF $S_LAST_CELL --> class="last-cell"<!-- ENDIF --><!-- IF postrow.contact.ID eq 'jabber' --> onclick="popup(this.href, 550, 320); return false;"<!-- ENDIF -->>

+ <span class="contact-icon {postrow.contact.ID}-icon"></span>

+ </a>

+ <!-- IF REMAINDER eq 3 or postrow.contact.S_LAST_ROW -->

+ </div>

+ <!-- ENDIF -->

+ <!-- END contact -->

+ </div>

+ </div>

+ </div>

+.contact-icons.dropdown-contents {

+ min-width: 0;

+ padding: 0;

+}

+

+.contact-icon {

+ background-repeat: no-repeat;

+ display: block;

+ height: 16px;

+ width: 16px;

+}

+.contact-icons a {

+ border-bottom: 1px dotted;

+ border-right: 1px dotted;

+ display: block;

+ float: left;

+ padding: 8px;

+}

+

+.contact-icons .last-cell {

+ border-right: none;

+}

+

+.contact-icons div:last-child a {

+ border-bottom: none;

+}

+

+.contact-icons div {

+ clear: left;

+}

+

+

+.pm-icon { background-position: 0 0; }

+.email-icon { background-position: -21px 0; }

+.jabber-icon { background-position: -80px 0; }

+.phpbb_icq-icon { background-position: -61px 0 ; }

+.phpbb_wlm-icon { background-position: -182px 0; }

+.phpbb_aol-icon { background-position: -244px 0; }

+.phpbb_website-icon { background-position: -40px 0; }

+.phpbb_youtube-icon { background-position: -98px 0; }

+.phpbb_facebook-icon { background-position: -119px 0; }

+.phpbb_google_plus-icon { background-position: -140px 0; }

+.phpbb_skype-icon { background-position: -161px 0; }

+.phpbb_twitter-icon { background-position: -203px 0; }

+.phpbb_yahoo-icon { background-position: -224px 0; }

+

+.contact-icons a {

+ border-color: #DCDCDC;

+}

+

+.contact-icons a:hover {

+ background-color: #F2F6F9;

+}

+

+.contact-icon { background-image: url("./images/icons_contact.png"); }

+

+ margin-right: -500px;

+ margin-left: -500px;

+ margin-right: 0;

+dd.profile-contact {

+ overflow: visible;

+}

+

+.profile-contact .dropdown-container {

+ display: inline-block;

+ text-align: left;

+ width: 30px;

+}

+

+.profile-contact .icon_contact {

+ vertical-align: middle;

+}

+

+.imageset.icon_contact {

+ background-image: url("./images/icon_contact.png");

+ padding-left: 16px;

+ padding-top: 12px;

+}

+

+ case 'sqlite3':

+ $u_pm = '';

+

+ if ($config['allow_privmsg'] && $auth->acl_get('u_sendpm') && $can_receive_pm)

+ {

+ $u_pm = append_sid("{$phpbb_root_path}ucp.$phpEx", 'i=pm&amp;mode=compose&amp;action=quotepost&amp;p=' . $row['post_id']);

+ }

+

+ 'U_PM' => $u_pm,

+ $contact_fields = array(

+ array(

+ 'ID' => 'pm',

+ 'NAME' => $user->lang['PRIVATE_MESSAGES'],

+ 'U_CONTACT' => $u_pm,

+ ),

+ array(

+ 'ID' => 'email',

+ 'NAME' => $user->lang['SEND_EMAIL'],

+ 'U_CONTACT' => $user_cache[$poster_id]['email'],

+ ),

+ array(

+ 'ID' => 'jabber',

+ 'NAME' => $user->lang['JABBER'],

+ 'U_CONTACT' => $user_cache[$poster_id]['jabber'],

+ ),

+ );

+

+ foreach ($contact_fields as $field)

+ {

+ if ($field['U_CONTACT'])

+ {

+ $template->assign_block_vars('postrow.contact', $field);

+ }

+ }

+

+

+ if ($field_data['S_PROFILE_CONTACT'])

+ {

+ $template->assign_block_vars('postrow.contact', array(

+ 'ID' => $field_data['PROFILE_FIELD_IDENT'],

+ 'NAME' => $field_data['PROFILE_FIELD_NAME'],

+ 'U_CONTACT' => $field_data['PROFILE_FIELD_CONTACT'],

+ ));

+ }

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2014 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+/**

+* @group functional

+*/

+class phpbb_functional_jumpbox_test extends phpbb_functional_test_case

+{

+ public function test_jumpbox()

+ {

+ $this->login();

+

+ $crawler = self::request('GET', "viewtopic.php?t=1&sid={$this->sid}");

+ $form = $crawler->filter('#quickmodform')->selectButton($this->lang('GO'))->form(array(

+ 'action' => 'merge_topic',

+ ));

+

+ $crawler = self::submit($form);

+ $this->assertContains($this->lang('FORUM') . ': Your first forum', $crawler->filter('#cp-main h2')->text());

+ $form = $crawler->filter('#jumpbox')->selectButton($this->lang('GO'))->form(array(

+ 'f' => 1,

+ ));

+

+ $crawler = self::submit($form);

+ $this->assertContains($this->lang('FORUM') . ': Your first category', $crawler->filter('#cp-main h2')->text());

+ }

+}

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2014 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+require_once dirname(__FILE__) . '/../../phpBB/includes/functions.php';

+

+class phpbb_build_url_test extends phpbb_test_case

+{

+ protected function setUp()

+ {

+ global $user, $phpbb_dispatcher, $phpbb_container, $phpbb_root_path, $phpbb_path_helper;

+

+ parent::setUp();

+

+ $phpbb_container = new phpbb_mock_container_builder();

+ $user = new phpbb_mock_user();

+ $phpbb_dispatcher = new phpbb_mock_event_dispatcher();

+

+ $phpbb_path_helper = new \phpbb\path_helper(

+ new \phpbb\symfony_request(

+ new phpbb_mock_request()

+ ),

+ new \phpbb\filesystem(),

+ $phpbb_root_path,

+ 'php'

+ );

+ $phpbb_container->set('path_helper', $path_helper);

+ }

+ public function build_url_test_data()

+ {

+ return array(

+ array(

+ 'index.php',

+ false,

+ 'phpBB/index.php?',

+ ),

+ array(

+ 'index.php',

+ 't',

+ 'phpBB/index.php?',

+ ),

+ array(

+ 'viewtopic.php?f=2&style=1&t=6',

+ 'f',

+ 'phpBB/viewtopic.php?style=1&amp;t=6',

+ ),

+ array(

+ 'viewtopic.php?f=2&style=1&t=6',

+ array('f', 'style', 't'),

+ 'phpBB/viewtopic.php?',

+ ),

+ array(

+ 'http://test.phpbb.com/viewtopic.php?f=2&style=1&t=6',

+ array('f', 'style', 't'),

+ 'http://test.phpbb.com/viewtopic.php?',

+ ),

+ );

+ }

+

+ /**

+ * @dataProvider build_url_test_data

+ */

+ public function test_build_url($page, $strip_vars, $expected)

+ {

+ global $user, $phpbb_root_path;

+

+ $user->page['page'] = $page;

+ $output = build_url($strip_vars);

+

+ $this->assertEquals($expected, $output);

+ }

+}

+ public static $function_exists = false;

+

+ protected $fileinfo_supported = false;

+ new \phpbb\mimetype\extension_guesser,

+ new \phpbb\mimetype\content_guesser,

+

+ // Check if any guesser except the extension_guesser is available

+ $this->fileinfo_supported = $guessers[0]->isSupported() | $guessers[1]->isSupported() | $guessers[3]->is_supported();

+

+ // Also create a guesser that emulates not having fileinfo available

+ $this->guesser_no_fileinfo = new \phpbb\mimetype\guesser(array($guessers[2]));

+

+ // We will always get application/octet-stream as mimetype if only the

+ // extension guesser is supported

+ if (!$this->fileinfo_supported)

+ {

+ $this->markTestSkipped('Unable to run tests depending on fileinfo if it is not available');

+ }

+ public function data_guess_files_no_fileinfo()

+ {

+ return array(

+ array('application/octet-stream', 'gif'),

+ array('application/octet-stream', 'txt'),

+ array(false, 'foobar'),

+ );

+ }

+

+ /**

+ * @dataProvider data_guess_files_no_fileinfo

+ */

+ public function test_guess_files_no_fileinfo($expected, $file)

+ {

+ $this->assertEquals($expected, $this->guesser_no_fileinfo->guess($this->path . '/../upload/fixture/' . $file));

+ }

+

+ if (!\function_exists('mime_content_type'))

+ {

+ $this->markTestSkipped('Emulating supported mime_content_type() when it is not supported will cause a fatal error');

+ }

+

+class phpbb_path_helper_test extends phpbb_test_case

+

+ public function glue_url_params_data()

+ {

+ return array(

+ array(

+ array(),

+ '',

+ ),

+ array(

+ array('test' => 'xyz'),

+ 'test=xyz',

+ ),

+ array(

+ array('test' => 'xyz', 'var' => 'value'),

+ 'test=xyz&amp;var=value',

+ ),

+ );

+ }

+

+ /**

+ * @dataProvider glue_url_params_data

+ */

+ public function test_glue_url_params($params, $expected)

+ {

+ $this->assertEquals($expected, $this->path_helper->glue_url_params($params));

+ }

+

+ public function get_url_parts_data()

+ {

+ return array(

+ array(

+ 'viewtopic.php',

+ true,

+ array('base' => 'viewtopic.php', 'params' => array()),

+ ),

+ array(

+ './viewtopic.php?t=5&amp;f=6',

+ true,

+ array('base' => './viewtopic.php', 'params' => array('t' => '5', 'f' => '6')),

+ ),

+ array(

+ 'viewtopic.php?t=5&f=6',

+ false,

+ array('base' => 'viewtopic.php', 'params' => array('t' => '5', 'f' => '6')),

+ ),

+ array(

+ 'https://phpbb.com/community/viewtopic.php?t=5&amp;f=6',

+ true,

+ array('base' => 'https://phpbb.com/community/viewtopic.php', 'params' => array('t' => '5', 'f' => '6')),

+ ),

+ array(

+ 'test.php?topic=post=5&amp;f=3',

+ true,

+ array('base' => 'test.php', 'params' => array('topic' => 'post=5', 'f' => '3')),

+ ),

+ array(

+ 'mcp.php?&amp;t=4&amp;f=3',

+ true,

+ array('base' => 'mcp.php', 'params' => array('t' => '4', 'f' => '3')),

+ ),

+ array(

+ 'mcp.php?=4&amp;f=3',

+ true,

+ array('base' => 'mcp.php', 'params' => array('f' => '3')),

+ ),

+ );

+ }

+

+ /**

+ * @dataProvider get_url_parts_data

+ */

+ public function test_get_url_parts($url, $is_amp, $expected)

+ {

+ $this->assertEquals($expected, $this->path_helper->get_url_parts($url, $is_amp));

+ }

+

+ public function strip_url_params_data()

+ {

+ return array(

+ array(

+ 'viewtopic.php',

+ 'sid',

+ false,

+ 'viewtopic.php',

+ ),

+ array(

+ './viewtopic.php?t=5&amp;f=6',

+ 'f',

+ true,

+ './viewtopic.php?t=5',

+ ),

+ array(

+ 'viewtopic.php?t=5&f=6&sid=19adc288814103cbb4625e74e77455aa',

+ array('t'),

+ false,

+ 'viewtopic.php?f=6&amp;sid=19adc288814103cbb4625e74e77455aa',

+ ),

+ array(

+ 'https://phpbb.com/community/viewtopic.php?t=5&amp;f=6',

+ array('t', 'f'),

+ true,

+ 'https://phpbb.com/community/viewtopic.php',

+ ),

+ );

+ }

+

+ /**

+ * @dataProvider strip_url_params_data

+ */

+ public function test_strip_url_params($url, $strip, $is_amp, $expected)

+ {

+ $this->assertEquals($expected, $this->path_helper->strip_url_params($url, $strip, $is_amp));

+ }

+

+ public function append_url_params_data()

+ {

+ return array(

+ array(

+ 'viewtopic.php',

+ array(),

+ false,

+ 'viewtopic.php',

+ ),

+ array(

+ './viewtopic.php?t=5&amp;f=6',

+ array('t' => '7'),

+ true,

+ './viewtopic.php?t=7&amp;f=6',

+ ),

+ array(

+ 'viewtopic.php?t=5&f=6&sid=19adc288814103cbb4625e74e77455aa',

+ array('p' => '5'),

+ false,

+ 'viewtopic.php?t=5&amp;f=6&amp;p=5&amp;sid=19adc288814103cbb4625e74e77455aa',

+ ),

+ array(

+ 'https://phpbb.com/community/viewtopic.php',

+ array('t' => '7', 'f' => '8'),

+ true,

+ 'https://phpbb.com/community/viewtopic.php?t=7&amp;f=8',

+ ),

+ );

+ }

+

+ /**

+ * @dataProvider append_url_params_data

+ */

+ public function test_append_url_params($url, $params, $is_amp, $expected)

+ {

+ $this->assertEquals($expected, $this->path_helper->append_url_params($url, $params, $is_amp));

+ }

+ case 'sqlite': // SQLite3 driver

+ case 'phpbb\db\driver\sqlite3':

+ case 'phpbb\db\driver\sqlite3':

+ $sql = 'SELECT name

+ FROM sqlite_master

+ WHERE type = "table"

+ AND name <> "sqlite_sequence"';

+ break;

+

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

+ 'SCHEMA' => 'sqlite',

+ 'DELIM' => ';',

+ 'PDO' => 'sqlite',

+ ),

+

+ case 'phpbb\db\driver\sqlite3':

+ /**

+ * Just delete all of the sequences. When an insertion occurs, the sequence will be automatically

+ * re-created from the key with the AUTOINCREMENT attribute

+ */

+ $queries[] = 'DELETE FROM sqlite_sequence';

+ break;

+

+ if (extension_loaded('sqlite3'))

+ {

+ $config = array_merge($config, array(

+ 'dbms' => 'phpbb\db\driver\sqlite3',

+ 'dbhost' => dirname(__FILE__) . '/../phpbb_unit_tests.sqlite3', // filename

+ 'dbport' => '',

+ 'dbname' => '',

+ 'dbuser' => '',

+ 'dbpasswd' => '',

+ ));

+ }

+ else if (extension_loaded('sqlite'))

+<?xml version="1.0" encoding="UTF-8"?>

+<phpunit backupGlobals="true"

+ backupStaticAttributes="true"

+ colors="true"

+ convertErrorsToExceptions="true"

+ convertNoticesToExceptions="true"

+ convertWarningsToExceptions="true"

+ processIsolation="false"

+ stopOnFailure="false"

+ syntaxCheck="true"

+ strict="true"

+ verbose="true"

+ bootstrap="../tests/bootstrap.php">

+ <testsuites>

+ <testsuite name="phpBB Test Suite">

+ <directory suffix="_test.php">../tests/</directory>

+ <exclude>tests/functional</exclude>

+ <exclude>tests/lint_test.php</exclude>

+ </testsuite>

+ <testsuite name="phpBB Functional Tests">

+ <directory suffix="_test.php" phpVersion="5.3.19" phpVersionOperator=">=">../tests/functional</directory>

+ </testsuite>

+ </testsuites>

+

+ <groups>

+ <exclude>

+ <group>slow</group>

+ </exclude>

+ </groups>

+

+ <php>

+ <!--server name="PHPBB_TEST_DBMS" value="phpbb\db\driver\sqlite3" /-->

+ <!--server name="PHPBB_TEST_DBHOST" value="../phpbb_unit_tests.sqlite3" /-->

+ <!--server name="PHPBB_TEST_DBPORT" value="" /-->

+ <!--server name="PHPBB_TEST_DBNAME" value="" /-->

+ <!--server name="PHPBB_TEST_DBUSER" value="" /-->

+ <!--server name="PHPBB_TEST_DBPASSWD" value="" /-->

+ <server name="PHPBB_TEST_REDIS_HOST" value="localhost" />

+ <server name="PHPBB_TEST_TABLE_PREFIX" value="phpbb_"/>

+ <server name="PHPBB_FUNCTIONAL_URL" value="http://localhost/" />

+ </php>

+</phpunit>