$schema_path = dirname(__FILE__) . '/../install/schemas/';

$supported_dbms = array(

'mssql',

'mysql_40',

'mysql_41',

{

case 'mysql_40':

case 'mysql_41':

case 'sqlite':

case 'sqlite3':

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

<li>PostgreSQL 8.3+</li>

<li>SQLite 2.8.2+</li>

<li>SQLite 3.6.15+</li>

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

<li>Oracle</li>

</ul>

<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 phpBB3. 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>

<a name="sql"></a><h3>2.iii. SQL/SQL Layout</h3>

<h4>Common SQL Guidelines: </h4>

<p>All SQL commands should utilise the DataBase Abstraction Layer (DBAL)</p>

<h4>SQL code layout:</h4>

case 'mssqlnative':

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

break;

}

$extractor->write_start($table_prefix);

{

case 'sqlite':

case 'sqlite3':

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

break;

}

break;

case 'postgres':

$delim = ";\n";

while (($sql = $fgetd($fp, $delim, $read, $seek, $eof)) !== false)

}

}

// get how much space we allow for a chunk of data, very similar to phpMyAdmin's way of doing things ;-) (hey, we only do this for MySQL anyway :P)

function get_usable_memory()

{

{

case 'sqlite':

case 'sqlite3':

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

break;

{

case 'sqlite':

case 'sqlite3':

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

break;

{

case 'sqlite':

case 'sqlite3':

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

break;

break;

case 'oracle':

$sql = 'ALTER TABLE ' . PROFILE_FIELDS_DATA_TABLE . " ADD $field_ident " . $sql_type;

// Teh standard

case 'postgres':

case 'oracle':

case 'sqlite':

case 'sqlite3':

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

{

case 'sqlite':

case 'sqlite3':

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

break;

}

break;

case 'sqlite':

case 'sqlite3':

global $dbhost;

{

case 'sqlite':

case 'sqlite3':

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

break;

{

global $lang;

$available_dbms = array(

// Note: php 5.5 alpha 2 deprecated mysql.

// Keep mysqli before mysql in this list.

'mysqli' => array(

$prefix_length = 200;

break;

case 'phpbb\db\driver\oracle':

$prefix_length = 6;

break;

}

break;

case 'phpbb\db\driver\oracle':

if ($unicode_check)

{

ORDER BY LEN(code) DESC';

break;

// LENGTH supported by MySQL, IBM DB2, Oracle and Access for sure...

default:

$sql = 'SELECT *

$drop_sql = 'DROP TABLE ' . USERCONV_TABLE;

switch ($map_dbms)

{

case 'mssql':

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

[user_id] [int] NOT NULL ,

define('IN_DB_UPDATE', true);

/**

*/

// End startup code

{

case 'sqlite':

case 'sqlite3':

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

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

break;

{

case 'sqlite':

case 'sqlite3':

$convert->src_truncate_statement = 'DELETE FROM ';

break;

{

case 'sqlite':

case 'sqlite3':

$convert->truncate_statement = 'DELETE FROM ';

break;

'DEV_NO_TEST_FILE' => 'No value has been specified for the test_file variable in the convertor. If you are a user of this convertor, you should not be seeing this error, please report this message to the convertor author. If you are a convertor author, you must specify the name of a file which exists in the source board to allow the path to it to be verified.',

'DIRECTORIES_AND_FILES' => 'Directory and file setup',

'DISABLE_KEYS' => 'Disabling keys',

'DLL_FTP' => 'Remote FTP support [ Installation ]',

'DLL_GD' => 'GD graphics support [ Visual Confirmation ]',

'DLL_MBSTRING' => 'Multi-byte character support',

'FILLING_TABLE' => 'Filling table <strong>%s</strong>',

'FILLING_TABLES' => 'Filling tables',

'FINAL_STEP' => 'Process final step',

'FORUM_ADDRESS' => 'Board address',

'FORUM_ADDRESS_EXPLAIN' => 'This is the URL of your former board, for example <samp>http://www.example.com/phpBB2/</samp>. If an address is entered here and not left empty every instance of this address will be replaced by your new board address within messages, private messages and signatures.',

<li>PostgreSQL 8.3+</li>

<li>SQLite 2.8.2+</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>

<li>Oracle</li>

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

'INST_ERR_DB_NO_NAME' => 'No database name specified.',

'INST_ERR_EMAIL_INVALID' => 'The email address you entered is invalid.',

ORDER BY LEN(bot_agent) DESC';

break;

// LENGTH supported by MySQL, IBM DB2 and Oracle for sure...

default:

$sql = 'SELECT user_id, bot_agent, bot_ip

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

),

'mssql' => array(

'INT:' => '[int]',

'BINT' => '[float]',

* 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).

FROM pg_stat_user_tables';

break;

case 'oracle':

$sql = 'SELECT table_name

FROM USER_TABLES';

// Close the table for two DBMS and add to the statements

switch ($this->sql_layer)

{

case 'mssql':

case 'mssqlnative':

$table_sql .= "\n);";

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

break;

case 'mssql':

case 'mssqlnative':

// We need the data here

$statements[] = $trigger;

}

break;

}

// Write Keys

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

break;

case 'sqlite':

case 'sqlite3':

$sql = "SELECT sql

switch ($this->sql_layer)

{

case 'postgres':

$sql = "SELECT ic.relname as index_name

FROM pg_class bc, pg_class ic, pg_index i

// These DBMS prefix index name with the table name

switch ($this->sql_layer)

{

case 'oracle':

case 'postgres':

case 'sqlite':

switch ($this->sql_layer)

{

case 'postgres':

$sql = "SELECT ic.relname as index_name, i.indisunique

FROM pg_class bc, pg_class ic, pg_index i

}

break;

case 'postgres':

case 'sqlite':

case 'sqlite3':

switch ($this->sql_layer)

{

case 'mssql':

case 'mssqlnative':

$sql .= " {$column_type} ";

switch ($this->sql_layer)

{

case 'mssql':

case 'mssqlnative':

// Does not support AFTER, only through temporary table

switch ($this->sql_layer)

{

case 'mssql':

case 'mssqlnative':

// We need the data here

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

break;

case 'oracle':

case 'postgres':

case 'sqlite':

switch ($this->sql_layer)

{

case 'oracle':

$sql = 'SELECT A.REFERENCED_NAME

FROM USER_DEPENDENCIES A, USER_TRIGGERS B

switch ($this->sql_layer)

{

case 'postgres':

case 'mysql_40':

case 'mysql_41':

switch ($this->sql_layer)

{

case 'postgres':

case 'oracle':

case 'sqlite':

switch ($this->sql_layer)

{

case 'postgres':

case 'oracle':

case 'sqlite':

{

switch ($this->sql_layer)

{

case 'postgres':

$sql = "SELECT ic.relname as index_name

FROM pg_class bc, pg_class ic, pg_index i

switch ($this->sql_layer)

{

case 'oracle':

case 'postgres':

case 'sqlite':

switch ($this->sql_layer)

{

case 'mssql':

case 'mssqlnative':

// We need the data here

{

case 'sqlite':

case 'sqlite3':

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

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

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

- apc (APC cache driver)

- bz2 (compress tests)

- mysql, pdo_mysql (MySQL database driver)

- mysqli, pdo_mysql (MySQLi database driver)

- pcntl (flock class)

----------------------

In order to run tests on some of the databases that we support, it will be

necessary to provide a custom DSN string in test_config.php. This is only

$custom_dsn = "Driver={SQL Server Native Client 10.0};Server=$dbhost;Database=$dbname";

public function convert_30_dbms_to_31_data()

{

return array(

array('mssql'),

array('mssql_odbc'),

array('mssqlnative'),

*/

class phpbb_database_connection_odbc_pdo_wrapper extends PDO

{

public $driver = '';

// Version number of driver since PDO::getAttribute(PDO::ATTR_CLIENT_VERSION) is pretty useless for this

public function createXMLDataSet($path)

{

$this->fixture_xml_data = parent::createXMLDataSet($path);

return $this->fixture_xml_data;

}

/**

* Converts a match in the middle of a string to uppercase.

*

* @param $matches The array of matches from a regular expression

*

// These require different connection strings on the phpBB side than they do in PDO

// so you must provide a DSN string for ODBC separately

{

$dsn = 'odbc:' . $this->config['custom_dsn'];

}

$this->pdo = new phpbb_database_connection_odbc_pdo_wrapper('mssql', 0, $dsn, $this->config['dbuser'], $this->config['dbpasswd']);

break;

default:

$this->pdo = new PDO($dsn, $this->config['dbuser'], $this->config['dbpasswd']);

break;

{

case 'phpbb\db\driver\sqlite':

case 'phpbb\db\driver\sqlite3':

$this->connect();

// Drop all of the tables

foreach ($this->get_tables() as $table)

FROM pg_stat_user_tables';

break;

case 'phpbb\db\driver\oracle':

$sql = 'SELECT table_name

FROM USER_TABLES';

protected function get_dbms_data($dbms)

{

$available_dbms = array(

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

'SCHEMA' => 'mysql_41',

'DELIM' => ';',

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

{

case 'phpbb\db\driver\oracle':

$sql = 'SELECT sequence_name

FROM USER_SEQUENCES';