+<IfModule mod_rewrite.c>

+RewriteEngine on

+

+

+#

+# The following 3 lines will rewrite URLs passed through the front controller

+# to not require app.php in the actual URL. In other words, a controller is

+# by default accessed at /app.php/my/controller, but can also be accessed at

+# /my/controller

+#

+RewriteCond %{REQUEST_FILENAME} !-f

+RewriteCond %{REQUEST_FILENAME} !-d

+RewriteRule ^(.*)$ app.php [QSA,L]

+

+#

+# If symbolic links are not already being followed,

+# uncomment the line below.

+# http://anothersysadmin.wordpress.com/2008/06/10/mod_rewrite-forbidden-403-with-apache-228/

+#

+#Options +FollowSymLinks

+</IfModule>

+$template->set_custom_style('adm', $phpbb_admin_path . 'style');

+$template->set_custom_style('adm', $phpbb_admin_path . 'style');

+// Create a Symfony Request object from our phpbb_request object

+$symfony_request = phpbb_create_symfony_request($request);

+

+ "symfony/config": "2.3.*",

+ "symfony/dependency-injection": "2.3.*",

+ "symfony/event-dispatcher": "2.3.*",

+ "symfony/http-kernel": "2.3.*",

+ "symfony/routing": "2.3.*",

+ "symfony/yaml": "2.3.*",

+ "hash": "fcad562b3b6768f0e355d93edc0db405",

+ "name": "psr/log",

+ "version": "1.0.0",

+ "source": {

+ "type": "git",

+ "url": "https://github.com/php-fig/log.git",

+ "reference": "fe0936ee26643249e916849d48e3a51d5f5e278b"

+ },

+ "dist": {

+ "type": "zip",

+ "url": "https://api.github.com/repos/php-fig/log/zipball/fe0936ee26643249e916849d48e3a51d5f5e278b",

+ "reference": "fe0936ee26643249e916849d48e3a51d5f5e278b",

+ "shasum": ""

+ },

+ "type": "library",

+ "autoload": {

+ "psr-0": {

+ "Psr\\Log\\": ""

+ }

+ },

+ "notification-url": "https://packagist.org/downloads/",

+ "license": [

+ "MIT"

+ ],

+ "authors": [

+ {

+ "name": "PHP-FIG",

+ "homepage": "http://www.php-fig.org/"

+ }

+ ],

+ "description": "Common interface for logging libraries",

+ "keywords": [

+ "log",

+ "psr",

+ "psr-3"

+ ],

+ "time": "2012-12-21 11:40:51"

+ },

+ {

+ "version": "v2.3.4",

+ "reference": "65a927c15ca5a911ba2fa277a5457fa8129505b0"

+ "url": "https://api.github.com/repos/symfony/Config/zipball/65a927c15ca5a911ba2fa277a5457fa8129505b0",

+ "reference": "65a927c15ca5a911ba2fa277a5457fa8129505b0",

+ "php": ">=5.3.3",

+ "symfony/filesystem": "~2.3"

+ "extra": {

+ "branch-alias": {

+ "dev-master": "2.3-dev"

+ }

+ },

+ "Symfony\\Component\\Config\\": ""

+ "time": "2013-08-06 05:49:23"

+ },

+ {

+ "name": "symfony/debug",

+ "version": "v2.3.4",

+ "target-dir": "Symfony/Component/Debug",

+ "source": {

+ "type": "git",

+ "url": "https://github.com/symfony/Debug.git",

+ "reference": "729f6d19cfc401c4942e43fcc1059103bd6df130"

+ },

+ "dist": {

+ "type": "zip",

+ "url": "https://api.github.com/repos/symfony/Debug/zipball/729f6d19cfc401c4942e43fcc1059103bd6df130",

+ "reference": "729f6d19cfc401c4942e43fcc1059103bd6df130",

+ "shasum": ""

+ },

+ "require": {

+ "php": ">=5.3.3"

+ },

+ "require-dev": {

+ "symfony/http-foundation": "~2.1",

+ "symfony/http-kernel": "~2.1"

+ },

+ "suggest": {

+ "symfony/class-loader": "",

+ "symfony/http-foundation": "",

+ "symfony/http-kernel": ""

+ },

+ "type": "library",

+ "extra": {

+ "branch-alias": {

+ "dev-master": "2.3-dev"

+ }

+ },

+ "autoload": {

+ "psr-0": {

+ "Symfony\\Component\\Debug\\": ""

+ }

+ },

+ "notification-url": "https://packagist.org/downloads/",

+ "license": [

+ "MIT"

+ ],

+ "authors": [

+ {

+ "name": "Fabien Potencier",

+ "email": "fabien@symfony.com"

+ },

+ {

+ "name": "Symfony Community",

+ "homepage": "http://symfony.com/contributors"

+ }

+ ],

+ "description": "Symfony Debug Component",

+ "homepage": "http://symfony.com",

+ "time": "2013-08-08 14:16:10"

+ "version": "v2.3.4",

+ "reference": "3678aa969e5bfeb8515a1f3047c63e8104723f5c"

+ "url": "https://api.github.com/repos/symfony/DependencyInjection/zipball/3678aa969e5bfeb8515a1f3047c63e8104723f5c",

+ "reference": "3678aa969e5bfeb8515a1f3047c63e8104723f5c",

+ "symfony/config": "~2.2",

+ "symfony/yaml": "~2.0"

+ "symfony/config": "",

+ "symfony/proxy-manager-bridge": "Generate service proxies to lazy load them",

+ "symfony/yaml": ""

+ "extra": {

+ "branch-alias": {

+ "dev-master": "2.3-dev"

+ }

+ },

+ "Symfony\\Component\\DependencyInjection\\": ""

+ "time": "2013-07-25 17:13:25"

+ "version": "v2.3.4",

+ "reference": "41c9826457c65fa3cf746f214985b7ca9cba42f8"

+ "url": "https://api.github.com/repos/symfony/EventDispatcher/zipball/41c9826457c65fa3cf746f214985b7ca9cba42f8",

+ "reference": "41c9826457c65fa3cf746f214985b7ca9cba42f8",

+ "symfony/dependency-injection": "~2.0"

+ "symfony/dependency-injection": "",

+ "symfony/http-kernel": ""

+ "extra": {

+ "branch-alias": {

+ "dev-master": "2.3-dev"

+ }

+ },

+ "Symfony\\Component\\EventDispatcher\\": ""

+ "time": "2013-07-21 12:12:18"

+ },

+ {

+ "name": "symfony/filesystem",

+ "version": "v2.3.4",

+ "target-dir": "Symfony/Component/Filesystem",

+ "source": {

+ "type": "git",

+ "url": "https://github.com/symfony/Filesystem.git",

+ "reference": "87acbbef6d35ba649f96f09cc572c45119b360c3"

+ },

+ "dist": {

+ "type": "zip",

+ "url": "https://api.github.com/repos/symfony/Filesystem/zipball/87acbbef6d35ba649f96f09cc572c45119b360c3",

+ "reference": "87acbbef6d35ba649f96f09cc572c45119b360c3",

+ "shasum": ""

+ },

+ "require": {

+ "php": ">=5.3.3"

+ },

+ "type": "library",

+ "extra": {

+ "branch-alias": {

+ "dev-master": "2.3-dev"

+ }

+ },

+ "autoload": {

+ "psr-0": {

+ "Symfony\\Component\\Filesystem\\": ""

+ }

+ },

+ "notification-url": "https://packagist.org/downloads/",

+ "license": [

+ "MIT"

+ ],

+ "authors": [

+ {

+ "name": "Fabien Potencier",

+ "email": "fabien@symfony.com"

+ },

+ {

+ "name": "Symfony Community",

+ "homepage": "http://symfony.com/contributors"

+ }

+ ],

+ "description": "Symfony Filesystem Component",

+ "homepage": "http://symfony.com",

+ "time": "2013-07-21 12:12:18"

+ "version": "v2.3.4",

+ "reference": "fdf130fe65457aedbc4639a22f4ef9d3be5c002c"

+ "url": "https://api.github.com/repos/symfony/HttpFoundation/zipball/fdf130fe65457aedbc4639a22f4ef9d3be5c002c",

+ "reference": "fdf130fe65457aedbc4639a22f4ef9d3be5c002c",

+ "extra": {

+ "branch-alias": {

+ "dev-master": "2.3-dev"

+ }

+ },

+ "Symfony\\Component\\HttpFoundation\\": ""

+ },

+ "classmap": [

+ "Symfony/Component/HttpFoundation/Resources/stubs"

+ ]

+ "time": "2013-08-26 05:49:51"

+ "version": "v2.3.4",

+ "reference": "9d35da40f07bbe7a4f8dfbc41555d2b69de674bf"

+ "url": "https://api.github.com/repos/symfony/HttpKernel/zipball/9d35da40f07bbe7a4f8dfbc41555d2b69de674bf",

+ "reference": "9d35da40f07bbe7a4f8dfbc41555d2b69de674bf",

+ "psr/log": "~1.0",

+ "symfony/debug": "~2.3",

+ "symfony/event-dispatcher": "~2.1",

+ "symfony/http-foundation": "~2.2"

+ "symfony/browser-kit": "~2.2",

+ "symfony/class-loader": "~2.1",

+ "symfony/config": "~2.0",

+ "symfony/console": "~2.2",

+ "symfony/dependency-injection": "~2.0",

+ "symfony/finder": "~2.0",

+ "symfony/process": "~2.0",

+ "symfony/routing": "~2.2",

+ "symfony/stopwatch": "~2.2",

+ "symfony/templating": "~2.2"

+ "symfony/browser-kit": "",

+ "symfony/class-loader": "",

+ "symfony/config": "",

+ "symfony/console": "",

+ "symfony/dependency-injection": "",

+ "symfony/finder": ""

+ "extra": {

+ "branch-alias": {

+ "dev-master": "2.3-dev"

+ }

+ },

+ "Symfony\\Component\\HttpKernel\\": ""

+ "time": "2013-08-27 08:58:24"

+ "version": "v2.3.4",

+ "reference": "69af3f07dbf3ae93dd513dbc373f561cb2e7f143"

+ "url": "https://api.github.com/repos/symfony/Routing/zipball/69af3f07dbf3ae93dd513dbc373f561cb2e7f143",

+ "reference": "69af3f07dbf3ae93dd513dbc373f561cb2e7f143",

+ "doctrine/common": "~2.2",

+ "psr/log": "~1.0",

+ "symfony/config": "~2.2",

+ "symfony/yaml": "~2.0"

+ "doctrine/common": "",

+ "symfony/config": "",

+ "symfony/yaml": ""

+ "extra": {

+ "branch-alias": {

+ "dev-master": "2.3-dev"

+ }

+ },

+ "Symfony\\Component\\Routing\\": ""

+ "time": "2013-08-23 15:14:07"

+ "version": "v2.3.4",

+ "reference": "5a279f1b5f5e1045a6c432354d9ea727ff3a9847"

+ "url": "https://api.github.com/repos/symfony/Yaml/zipball/5a279f1b5f5e1045a6c432354d9ea727ff3a9847",

+ "reference": "5a279f1b5f5e1045a6c432354d9ea727ff3a9847",

+ "extra": {

+ "branch-alias": {

+ "dev-master": "2.3-dev"

+ }

+ },

+ "Symfony\\Component\\Yaml\\": ""

+ "time": "2013-08-24 15:26:22"

+ "version": "v1.13.2",

+ "reference": "6d6a1009427d1f398c9d40904147bf9f723d5755"

+ "url": "https://api.github.com/repos/fabpot/Twig/zipball/6d6a1009427d1f398c9d40904147bf9f723d5755",

+ "reference": "6d6a1009427d1f398c9d40904147bf9f723d5755",

+ "BSD-3-Clause"

+ "time": "2013-08-03 15:35:31"

+ "url": "https://github.com/fabpot/Goutte.git",

+ "reference": "dcfba09b0f3781b2629693ab627bfa61ad4753bb"

+ "url": "https://api.github.com/repos/fabpot/Goutte/zipball/dcfba09b0f3781b2629693ab627bfa61ad4753bb",

+ "reference": "dcfba09b0f3781b2629693ab627bfa61ad4753bb",

+ "url": "https://github.com/guzzle/guzzle.git",

+ "reference": "f31f35d1669382936861533bd0217fcf830dc9a9"

+ "url": "https://api.github.com/repos/guzzle/guzzle/zipball/f31f35d1669382936861533bd0217fcf830dc9a9",

+ "reference": "f31f35d1669382936861533bd0217fcf830dc9a9",

+ "url": "https://github.com/phingofficial/phing.git",

+ "reference": "41075d93ca254f1c90c79ec7ce81be2b2629e138"

+ "url": "https://api.github.com/repos/phingofficial/phing/zipball/41075d93ca254f1c90c79ec7ce81be2b2629e138",

+ "reference": "41075d93ca254f1c90c79ec7ce81be2b2629e138",

+ "reference": "8386782a2d55153e44a06eb1a9d13d6ed35d9c2d"

+ "url": "https://api.github.com/repos/sebastianbergmann/dbunit/zipball/8386782a2d55153e44a06eb1a9d13d6ed35d9c2d",

+ "reference": "8386782a2d55153e44a06eb1a9d13d6ed35d9c2d",

+ "reference": "0e9958c459d675fb497d8dc5001c91d335734e48"

+ "url": "https://api.github.com/repos/sebastianbergmann/php-code-coverage/zipball/0e9958c459d675fb497d8dc5001c91d335734e48",

+ "reference": "0e9958c459d675fb497d8dc5001c91d335734e48",

+ "url": "https://github.com/sebastianbergmann/php-file-iterator.git",

+ "reference": "16a78140ed2fc01b945cfa539665fadc6a038029"

+ "url": "https://api.github.com/repos/sebastianbergmann/php-file-iterator/zipball/16a78140ed2fc01b945cfa539665fadc6a038029",

+ "reference": "16a78140ed2fc01b945cfa539665fadc6a038029",

+ "time": "2012-10-11 11:44:38"

+ "url": "https://github.com/sebastianbergmann/php-text-template.git",

+ "reference": "5180896f51c5b3648ac946b05f9ec02be78a0b23"

+ "url": "https://api.github.com/repos/sebastianbergmann/php-text-template/zipball/5180896f51c5b3648ac946b05f9ec02be78a0b23",

+ "reference": "5180896f51c5b3648ac946b05f9ec02be78a0b23",

+ "time": "2012-10-31 18:15:28"

+ "version": "1.0.5",

+ "url": "https://github.com/sebastianbergmann/php-timer.git",

+ "reference": "19689d4354b295ee3d8c54b4f42c3efb69cbc17c"

+ "url": "https://api.github.com/repos/sebastianbergmann/php-timer/zipball/19689d4354b295ee3d8c54b4f42c3efb69cbc17c",

+ "reference": "19689d4354b295ee3d8c54b4f42c3efb69cbc17c",

+ "homepage": "https://github.com/sebastianbergmann/php-timer/",

+ "time": "2013-08-02 07:42:54"

+ "version": "1.2.0",

+ "url": "https://github.com/sebastianbergmann/php-token-stream.git",

+ "reference": "31babf400e5b5868573bf49a000a3519d3978233"

+ "url": "https://api.github.com/repos/sebastianbergmann/php-token-stream/zipball/31babf400e5b5868573bf49a000a3519d3978233",

+ "reference": "31babf400e5b5868573bf49a000a3519d3978233",

+ "extra": {

+ "branch-alias": {

+ "dev-master": "1.2-dev"

+ }

+ },

+ "homepage": "https://github.com/sebastianbergmann/php-token-stream/",

+ "time": "2013-08-04 05:57:48"

+ "version": "3.7.24",

+ "reference": "af7b77ccb5c64458bdfca95665d29558d1df7d08"

+ "url": "https://api.github.com/repos/sebastianbergmann/phpunit/zipball/af7b77ccb5c64458bdfca95665d29558d1df7d08",

+ "reference": "af7b77ccb5c64458bdfca95665d29558d1df7d08",

+ "phpunit/php-timer": ">=1.0.4",

+ "time": "2013-08-09 06:58:24"

+ "url": "https://github.com/sebastianbergmann/phpunit-mock-objects.git",

+ "reference": "5794e3c5c5ba0fb037b11d8151add2a07fa82875"

+ "url": "https://api.github.com/repos/sebastianbergmann/phpunit-mock-objects/zipball/5794e3c5c5ba0fb037b11d8151add2a07fa82875",

+ "reference": "5794e3c5c5ba0fb037b11d8151add2a07fa82875",

+ "version": "v2.1.12",

+ "reference": "0bb8f07107a2911db0fe49c39f96b5018e5ab678"

+ "url": "https://api.github.com/repos/symfony/BrowserKit/zipball/0bb8f07107a2911db0fe49c39f96b5018e5ab678",

+ "reference": "0bb8f07107a2911db0fe49c39f96b5018e5ab678",

+ "version": "v2.1.12",

+ "reference": "bf7bb82a099dfb26b018daf70ad1985fea4d2997"

+ "url": "https://api.github.com/repos/symfony/CssSelector/zipball/bf7bb82a099dfb26b018daf70ad1985fea4d2997",

+ "reference": "bf7bb82a099dfb26b018daf70ad1985fea4d2997",

+ "version": "v2.1.12",

+ "reference": "bedfd7eb44e3b1224d1e18335d2e36bbbed26cbe"

+ "url": "https://api.github.com/repos/symfony/DomCrawler/zipball/bedfd7eb44e3b1224d1e18335d2e36bbbed26cbe",

+ "reference": "bedfd7eb44e3b1224d1e18335d2e36bbbed26cbe",

+ "version": "v2.1.12",

+ "reference": "0dbc61194b58bc513e003789853ddfe0aea8cf33"

+ "url": "https://api.github.com/repos/symfony/Finder/zipball/0dbc61194b58bc513e003789853ddfe0aea8cf33",

+ "reference": "0dbc61194b58bc513e003789853ddfe0aea8cf33",

+ "version": "v2.1.12",

+ "reference": "be3cac4d0575bc547a0f2e85ceb4f19a5a8b3025"

+ "url": "https://api.github.com/repos/symfony/Process/zipball/be3cac4d0575bc547a0f2e85ceb4f19a5a8b3025",

+ "reference": "be3cac4d0575bc547a0f2e85ceb4f19a5a8b3025",

+ - @request

+define('IN_PHPBB', true);

+

+require(dirname(__FILE__) . '/../includes/db/schema_data.php');

+require(dirname(__FILE__) . '/../phpbb/db/tools.php');

+

+$dbms_type_map = phpbb_db_tools::get_dbms_type_map();

+require($phpbb_root_path . 'includes/db/schema_data.' . $phpEx);

+require($phpbb_root_path . 'phpbb/db/tools.' . $phpEx);

+$dbms_type_map = phpbb_db_tools::get_dbms_type_map();

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11769">PHPBB3-11769</a>] - Wrong poster in subscription email when poster is using the Quote button</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11775">PHPBB3-11775</a>] - Error while moving posts to a new topic</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11802">PHPBB3-11802</a>] - Undefined variable $browser in /download/file.php</li>

+<?php

+/**

+*

+* @package dbal

+* @copyright (c) 2013 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+$schema_data = array();

+

+/**

+* Define the basic structure

+* The format:

+* array('{TABLE_NAME}' => {TABLE_DATA})

+* {TABLE_DATA}:

+* COLUMNS = array({column_name} = array({column_type}, {default}, {auto_increment}))

+* PRIMARY_KEY = {column_name(s)}

+* KEYS = array({key_name} = array({key_type}, {column_name(s)})),

+*

+* Column Types:

+* INT:x => SIGNED int(x)

+* BINT => BIGINT

+* UINT => mediumint(8) UNSIGNED

+* UINT:x => int(x) UNSIGNED

+* TINT:x => tinyint(x)

+* USINT => smallint(4) UNSIGNED (for _order columns)

+* BOOL => tinyint(1) UNSIGNED

+* VCHAR => varchar(255)

+* CHAR:x => char(x)

+* XSTEXT_UNI => text for storing 100 characters (topic_title for example)

+* STEXT_UNI => text for storing 255 characters (normal input field with a max of 255 single-byte chars) - same as VCHAR_UNI

+* TEXT_UNI => text for storing 3000 characters (short text, descriptions, comments, etc.)

+* MTEXT_UNI => mediumtext (post text, large text)

+* VCHAR:x => varchar(x)

+* TIMESTAMP => int(11) UNSIGNED

+* DECIMAL => decimal number (5,2)

+* DECIMAL: => decimal number (x,2)

+* PDECIMAL => precision decimal number (6,3)

+* PDECIMAL: => precision decimal number (x,3)

+* VCHAR_UNI => varchar(255) BINARY

+* VCHAR_CI => varchar_ci for postgresql, others VCHAR

+*/

+$schema_data['phpbb_attachments'] = array(

+ 'COLUMNS' => array(

+ 'attach_id' => array('UINT', NULL, 'auto_increment'),

+ 'post_msg_id' => array('UINT', 0),

+ 'topic_id' => array('UINT', 0),

+ 'in_message' => array('BOOL', 0),

+ 'poster_id' => array('UINT', 0),

+ 'is_orphan' => array('BOOL', 1),

+ 'physical_filename' => array('VCHAR', ''),

+ 'real_filename' => array('VCHAR', ''),

+ 'download_count' => array('UINT', 0),

+ 'attach_comment' => array('TEXT_UNI', ''),

+ 'extension' => array('VCHAR:100', ''),

+ 'mimetype' => array('VCHAR:100', ''),

+ 'filesize' => array('UINT:20', 0),

+ 'filetime' => array('TIMESTAMP', 0),

+ 'thumbnail' => array('BOOL', 0),

+ ),

+ 'PRIMARY_KEY' => 'attach_id',

+ 'KEYS' => array(

+ 'filetime' => array('INDEX', 'filetime'),

+ 'post_msg_id' => array('INDEX', 'post_msg_id'),

+ 'topic_id' => array('INDEX', 'topic_id'),

+ 'poster_id' => array('INDEX', 'poster_id'),

+ 'is_orphan' => array('INDEX', 'is_orphan'),

+ ),

+);

+

+$schema_data['phpbb_acl_groups'] = array(

+ 'COLUMNS' => array(

+ 'group_id' => array('UINT', 0),

+ 'forum_id' => array('UINT', 0),

+ 'auth_option_id' => array('UINT', 0),

+ 'auth_role_id' => array('UINT', 0),

+ 'auth_setting' => array('TINT:2', 0),

+ ),

+ 'KEYS' => array(

+ 'group_id' => array('INDEX', 'group_id'),

+ 'auth_opt_id' => array('INDEX', 'auth_option_id'),

+ 'auth_role_id' => array('INDEX', 'auth_role_id'),

+ ),

+);

+

+$schema_data['phpbb_acl_options'] = array(

+ 'COLUMNS' => array(

+ 'auth_option_id' => array('UINT', NULL, 'auto_increment'),

+ 'auth_option' => array('VCHAR:50', ''),

+ 'is_global' => array('BOOL', 0),

+ 'is_local' => array('BOOL', 0),

+ 'founder_only' => array('BOOL', 0),

+ ),

+ 'PRIMARY_KEY' => 'auth_option_id',

+ 'KEYS' => array(

+ 'auth_option' => array('UNIQUE', 'auth_option'),

+ ),

+);

+

+$schema_data['phpbb_acl_roles'] = array(

+ 'COLUMNS' => array(

+ 'role_id' => array('UINT', NULL, 'auto_increment'),

+ 'role_name' => array('VCHAR_UNI', ''),

+ 'role_description' => array('TEXT_UNI', ''),

+ 'role_type' => array('VCHAR:10', ''),

+ 'role_order' => array('USINT', 0),

+ ),

+ 'PRIMARY_KEY' => 'role_id',

+ 'KEYS' => array(

+ 'role_type' => array('INDEX', 'role_type'),

+ 'role_order' => array('INDEX', 'role_order'),

+ ),

+);

+

+$schema_data['phpbb_acl_roles_data'] = array(

+ 'COLUMNS' => array(

+ 'role_id' => array('UINT', 0),

+ 'auth_option_id' => array('UINT', 0),

+ 'auth_setting' => array('TINT:2', 0),

+ ),

+ 'PRIMARY_KEY' => array('role_id', 'auth_option_id'),

+ 'KEYS' => array(

+ 'ath_op_id' => array('INDEX', 'auth_option_id'),

+ ),

+);

+

+$schema_data['phpbb_acl_users'] = array(

+ 'COLUMNS' => array(

+ 'user_id' => array('UINT', 0),

+ 'forum_id' => array('UINT', 0),

+ 'auth_option_id' => array('UINT', 0),

+ 'auth_role_id' => array('UINT', 0),

+ 'auth_setting' => array('TINT:2', 0),

+ ),

+ 'KEYS' => array(

+ 'user_id' => array('INDEX', 'user_id'),

+ 'auth_option_id' => array('INDEX', 'auth_option_id'),

+ 'auth_role_id' => array('INDEX', 'auth_role_id'),

+ ),

+);

+

+$schema_data['phpbb_banlist'] = array(

+ 'COLUMNS' => array(

+ 'ban_id' => array('UINT', NULL, 'auto_increment'),

+ 'ban_userid' => array('UINT', 0),

+ 'ban_ip' => array('VCHAR:40', ''),

+ 'ban_email' => array('VCHAR_UNI:100', ''),

+ 'ban_start' => array('TIMESTAMP', 0),

+ 'ban_end' => array('TIMESTAMP', 0),

+ 'ban_exclude' => array('BOOL', 0),

+ 'ban_reason' => array('VCHAR_UNI', ''),

+ 'ban_give_reason' => array('VCHAR_UNI', ''),

+ ),

+ 'PRIMARY_KEY' => 'ban_id',

+ 'KEYS' => array(

+ 'ban_end' => array('INDEX', 'ban_end'),

+ 'ban_user' => array('INDEX', array('ban_userid', 'ban_exclude')),

+ 'ban_email' => array('INDEX', array('ban_email', 'ban_exclude')),

+ 'ban_ip' => array('INDEX', array('ban_ip', 'ban_exclude')),

+ ),

+);

+

+$schema_data['phpbb_bbcodes'] = array(

+ 'COLUMNS' => array(

+ 'bbcode_id' => array('USINT', 0),

+ 'bbcode_tag' => array('VCHAR:16', ''),

+ 'bbcode_helpline' => array('VCHAR_UNI', ''),

+ 'display_on_posting' => array('BOOL', 0),

+ 'bbcode_match' => array('TEXT_UNI', ''),

+ 'bbcode_tpl' => array('MTEXT_UNI', ''),

+ 'first_pass_match' => array('MTEXT_UNI', ''),

+ 'first_pass_replace' => array('MTEXT_UNI', ''),

+ 'second_pass_match' => array('MTEXT_UNI', ''),

+ 'second_pass_replace' => array('MTEXT_UNI', ''),

+ ),

+ 'PRIMARY_KEY' => 'bbcode_id',

+ 'KEYS' => array(

+ 'display_on_post' => array('INDEX', 'display_on_posting'),

+ ),

+);

+

+$schema_data['phpbb_bookmarks'] = array(

+ 'COLUMNS' => array(

+ 'topic_id' => array('UINT', 0),

+ 'user_id' => array('UINT', 0),

+ ),

+ 'PRIMARY_KEY' => array('topic_id', 'user_id'),

+);

+

+$schema_data['phpbb_bots'] = array(

+ 'COLUMNS' => array(

+ 'bot_id' => array('UINT', NULL, 'auto_increment'),

+ 'bot_active' => array('BOOL', 1),

+ 'bot_name' => array('STEXT_UNI', ''),

+ 'user_id' => array('UINT', 0),

+ 'bot_agent' => array('VCHAR', ''),

+ 'bot_ip' => array('VCHAR', ''),

+ ),

+ 'PRIMARY_KEY' => 'bot_id',

+ 'KEYS' => array(

+ 'bot_active' => array('INDEX', 'bot_active'),

+ ),

+);

+

+$schema_data['phpbb_config'] = array(

+ 'COLUMNS' => array(

+ 'config_name' => array('VCHAR', ''),

+ 'config_value' => array('VCHAR_UNI', ''),

+ 'is_dynamic' => array('BOOL', 0),

+ ),

+ 'PRIMARY_KEY' => 'config_name',

+ 'KEYS' => array(

+ 'is_dynamic' => array('INDEX', 'is_dynamic'),

+ ),

+);

+

+$schema_data['phpbb_config_text'] = array(

+ 'COLUMNS' => array(

+ 'config_name' => array('VCHAR', ''),

+ 'config_value' => array('MTEXT', ''),

+ ),

+ 'PRIMARY_KEY' => 'config_name',

+);

+

+$schema_data['phpbb_confirm'] = array(

+ 'COLUMNS' => array(

+ 'confirm_id' => array('CHAR:32', ''),

+ 'session_id' => array('CHAR:32', ''),

+ 'confirm_type' => array('TINT:3', 0),

+ 'code' => array('VCHAR:8', ''),

+ 'seed' => array('UINT:10', 0),

+ 'attempts' => array('UINT', 0),

+ ),

+ 'PRIMARY_KEY' => array('session_id', 'confirm_id'),

+ 'KEYS' => array(

+ 'confirm_type' => array('INDEX', 'confirm_type'),

+ ),

+);

+

+$schema_data['phpbb_disallow'] = array(

+ 'COLUMNS' => array(

+ 'disallow_id' => array('UINT', NULL, 'auto_increment'),

+ 'disallow_username' => array('VCHAR_UNI:255', ''),

+ ),

+ 'PRIMARY_KEY' => 'disallow_id',

+);

+

+$schema_data['phpbb_drafts'] = array(

+ 'COLUMNS' => array(

+ 'draft_id' => array('UINT', NULL, 'auto_increment'),

+ 'user_id' => array('UINT', 0),

+ 'topic_id' => array('UINT', 0),

+ 'forum_id' => array('UINT', 0),

+ 'save_time' => array('TIMESTAMP', 0),

+ 'draft_subject' => array('STEXT_UNI', ''),

+ 'draft_message' => array('MTEXT_UNI', ''),

+ ),

+ 'PRIMARY_KEY' => 'draft_id',

+ 'KEYS' => array(

+ 'save_time' => array('INDEX', 'save_time'),

+ ),

+);

+

+$schema_data['phpbb_ext'] = array(

+ 'COLUMNS' => array(

+ 'ext_name' => array('VCHAR', ''),

+ 'ext_active' => array('BOOL', 0),

+ 'ext_state' => array('TEXT', ''),

+ ),

+ 'KEYS' => array(

+ 'ext_name' => array('UNIQUE', 'ext_name'),

+ ),

+);

+

+$schema_data['phpbb_extensions'] = array(

+ 'COLUMNS' => array(

+ 'extension_id' => array('UINT', NULL, 'auto_increment'),

+ 'group_id' => array('UINT', 0),

+ 'extension' => array('VCHAR:100', ''),

+ ),

+ 'PRIMARY_KEY' => 'extension_id',

+);

+

+$schema_data['phpbb_extension_groups'] = array(

+ 'COLUMNS' => array(

+ 'group_id' => array('UINT', NULL, 'auto_increment'),

+ 'group_name' => array('VCHAR_UNI', ''),

+ 'cat_id' => array('TINT:2', 0),

+ 'allow_group' => array('BOOL', 0),

+ 'download_mode' => array('BOOL', 1),

+ 'upload_icon' => array('VCHAR', ''),

+ 'max_filesize' => array('UINT:20', 0),

+ 'allowed_forums' => array('TEXT', ''),

+ 'allow_in_pm' => array('BOOL', 0),

+ ),

+ 'PRIMARY_KEY' => 'group_id',

+);

+

+$schema_data['phpbb_forums'] = array(

+ 'COLUMNS' => array(

+ 'forum_id' => array('UINT', NULL, 'auto_increment'),

+ 'parent_id' => array('UINT', 0),

+ 'left_id' => array('UINT', 0),

+ 'right_id' => array('UINT', 0),

+ 'forum_parents' => array('MTEXT', ''),

+ 'forum_name' => array('STEXT_UNI', ''),

+ 'forum_desc' => array('TEXT_UNI', ''),

+ 'forum_desc_bitfield' => array('VCHAR:255', ''),

+ 'forum_desc_options' => array('UINT:11', 7),

+ 'forum_desc_uid' => array('VCHAR:8', ''),

+ 'forum_link' => array('VCHAR_UNI', ''),

+ 'forum_password' => array('VCHAR_UNI:40', ''),

+ 'forum_style' => array('UINT', 0),

+ 'forum_image' => array('VCHAR', ''),

+ 'forum_rules' => array('TEXT_UNI', ''),

+ 'forum_rules_link' => array('VCHAR_UNI', ''),

+ 'forum_rules_bitfield' => array('VCHAR:255', ''),

+ 'forum_rules_options' => array('UINT:11', 7),

+ 'forum_rules_uid' => array('VCHAR:8', ''),

+ 'forum_topics_per_page' => array('TINT:4', 0),

+ 'forum_type' => array('TINT:4', 0),

+ 'forum_status' => array('TINT:4', 0),

+ 'forum_posts_approved' => array('UINT', 0),

+ 'forum_posts_unapproved' => array('UINT', 0),

+ 'forum_posts_softdeleted' => array('UINT', 0),

+ 'forum_topics_approved' => array('UINT', 0),

+ 'forum_topics_unapproved' => array('UINT', 0),

+ 'forum_topics_softdeleted' => array('UINT', 0),

+ 'forum_last_post_id' => array('UINT', 0),

+ 'forum_last_poster_id' => array('UINT', 0),

+ 'forum_last_post_subject' => array('STEXT_UNI', ''),

+ 'forum_last_post_time' => array('TIMESTAMP', 0),

+ 'forum_last_poster_name'=> array('VCHAR_UNI', ''),

+ 'forum_last_poster_colour'=> array('VCHAR:6', ''),

+ 'forum_flags' => array('TINT:4', 32),

+ 'forum_options' => array('UINT:20', 0),

+ 'display_subforum_list' => array('BOOL', 1),

+ 'display_on_index' => array('BOOL', 1),

+ 'enable_indexing' => array('BOOL', 1),

+ 'enable_icons' => array('BOOL', 1),

+ 'enable_prune' => array('BOOL', 0),

+ 'prune_next' => array('TIMESTAMP', 0),

+ 'prune_days' => array('UINT', 0),

+ 'prune_viewed' => array('UINT', 0),

+ 'prune_freq' => array('UINT', 0),

+ ),

+ 'PRIMARY_KEY' => 'forum_id',

+ 'KEYS' => array(

+ 'left_right_id' => array('INDEX', array('left_id', 'right_id')),

+ 'forum_lastpost_id' => array('INDEX', 'forum_last_post_id'),

+ ),

+);

+

+$schema_data['phpbb_forums_access'] = array(

+ 'COLUMNS' => array(

+ 'forum_id' => array('UINT', 0),

+ 'user_id' => array('UINT', 0),

+ 'session_id' => array('CHAR:32', ''),

+ ),

+ 'PRIMARY_KEY' => array('forum_id', 'user_id', 'session_id'),

+);

+

+$schema_data['phpbb_forums_track'] = array(

+ 'COLUMNS' => array(

+ 'user_id' => array('UINT', 0),

+ 'forum_id' => array('UINT', 0),

+ 'mark_time' => array('TIMESTAMP', 0),

+ ),

+ 'PRIMARY_KEY' => array('user_id', 'forum_id'),

+);

+

+$schema_data['phpbb_forums_watch'] = array(

+ 'COLUMNS' => array(

+ 'forum_id' => array('UINT', 0),

+ 'user_id' => array('UINT', 0),

+ 'notify_status' => array('BOOL', 0),

+ ),

+ 'KEYS' => array(

+ 'forum_id' => array('INDEX', 'forum_id'),

+ 'user_id' => array('INDEX', 'user_id'),

+ 'notify_stat' => array('INDEX', 'notify_status'),

+ ),

+);

+

+$schema_data['phpbb_groups'] = array(

+ 'COLUMNS' => array(

+ 'group_id' => array('UINT', NULL, 'auto_increment'),

+ 'group_type' => array('TINT:4', 1),

+ 'group_founder_manage' => array('BOOL', 0),

+ 'group_skip_auth' => array('BOOL', 0),

+ 'group_name' => array('VCHAR_CI', ''),

+ 'group_desc' => array('TEXT_UNI', ''),

+ 'group_desc_bitfield' => array('VCHAR:255', ''),

+ 'group_desc_options' => array('UINT:11', 7),

+ 'group_desc_uid' => array('VCHAR:8', ''),

+ 'group_display' => array('BOOL', 0),

+ 'group_avatar' => array('VCHAR', ''),

+ 'group_avatar_type' => array('VCHAR:255', ''),

+ 'group_avatar_width' => array('USINT', 0),

+ 'group_avatar_height' => array('USINT', 0),

+ 'group_rank' => array('UINT', 0),

+ 'group_colour' => array('VCHAR:6', ''),

+ 'group_sig_chars' => array('UINT', 0),

+ 'group_receive_pm' => array('BOOL', 0),

+ 'group_message_limit' => array('UINT', 0),

+ 'group_max_recipients' => array('UINT', 0),

+ 'group_legend' => array('UINT', 0),

+ ),

+ 'PRIMARY_KEY' => 'group_id',

+ 'KEYS' => array(

+ 'group_legend_name' => array('INDEX', array('group_legend', 'group_name')),

+ ),

+);

+

+$schema_data['phpbb_icons'] = array(

+ 'COLUMNS' => array(

+ 'icons_id' => array('UINT', NULL, 'auto_increment'),

+ 'icons_url' => array('VCHAR', ''),

+ 'icons_width' => array('TINT:4', 0),

+ 'icons_height' => array('TINT:4', 0),

+ 'icons_order' => array('UINT', 0),

+ 'display_on_posting' => array('BOOL', 1),

+ ),

+ 'PRIMARY_KEY' => 'icons_id',

+ 'KEYS' => array(

+ 'display_on_posting' => array('INDEX', 'display_on_posting'),

+ ),

+);

+

+$schema_data['phpbb_lang'] = array(

+ 'COLUMNS' => array(

+ 'lang_id' => array('TINT:4', NULL, 'auto_increment'),

+ 'lang_iso' => array('VCHAR:30', ''),

+ 'lang_dir' => array('VCHAR:30', ''),

+ 'lang_english_name' => array('VCHAR_UNI:100', ''),

+ 'lang_local_name' => array('VCHAR_UNI:255', ''),

+ 'lang_author' => array('VCHAR_UNI:255', ''),

+ ),

+ 'PRIMARY_KEY' => 'lang_id',

+ 'KEYS' => array(

+ 'lang_iso' => array('INDEX', 'lang_iso'),

+ ),

+);

+

+$schema_data['phpbb_log'] = array(

+ 'COLUMNS' => array(

+ 'log_id' => array('UINT', NULL, 'auto_increment'),

+ 'log_type' => array('TINT:4', 0),

+ 'user_id' => array('UINT', 0),

+ 'forum_id' => array('UINT', 0),

+ 'topic_id' => array('UINT', 0),

+ 'reportee_id' => array('UINT', 0),

+ 'log_ip' => array('VCHAR:40', ''),

+ 'log_time' => array('TIMESTAMP', 0),

+ 'log_operation' => array('TEXT_UNI', ''),

+ 'log_data' => array('MTEXT_UNI', ''),

+ ),

+ 'PRIMARY_KEY' => 'log_id',

+ 'KEYS' => array(

+ 'log_type' => array('INDEX', 'log_type'),

+ 'log_time' => array('INDEX', 'log_time'),

+ 'forum_id' => array('INDEX', 'forum_id'),

+ 'topic_id' => array('INDEX', 'topic_id'),

+ 'reportee_id' => array('INDEX', 'reportee_id'),

+ 'user_id' => array('INDEX', 'user_id'),

+ ),

+);

+

+$schema_data['phpbb_login_attempts'] = array(

+ 'COLUMNS' => array(

+ 'attempt_ip' => array('VCHAR:40', ''),

+ 'attempt_browser' => array('VCHAR:150', ''),

+ 'attempt_forwarded_for' => array('VCHAR:255', ''),

+ 'attempt_time' => array('TIMESTAMP', 0),

+ 'user_id' => array('UINT', 0),

+ 'username' => array('VCHAR_UNI:255', 0),

+ 'username_clean' => array('VCHAR_CI', 0),

+ ),

+ 'KEYS' => array(

+ 'att_ip' => array('INDEX', array('attempt_ip', 'attempt_time')),

+ 'att_for' => array('INDEX', array('attempt_forwarded_for', 'attempt_time')),

+ 'att_time' => array('INDEX', array('attempt_time')),

+ 'user_id' => array('INDEX', 'user_id'),

+ ),

+);

+

+$schema_data['phpbb_moderator_cache'] = array(

+ 'COLUMNS' => array(

+ 'forum_id' => array('UINT', 0),

+ 'user_id' => array('UINT', 0),

+ 'username' => array('VCHAR_UNI:255', ''),

+ 'group_id' => array('UINT', 0),

+ 'group_name' => array('VCHAR_UNI', ''),

+ 'display_on_index' => array('BOOL', 1),

+ ),

+ 'KEYS' => array(

+ 'disp_idx' => array('INDEX', 'display_on_index'),

+ 'forum_id' => array('INDEX', 'forum_id'),

+ ),

+);

+

+$schema_data['phpbb_migrations'] = array(

+ 'COLUMNS' => array(

+ 'migration_name' => array('VCHAR', ''),

+ 'migration_depends_on' => array('TEXT', ''),

+ 'migration_schema_done' => array('BOOL', 0),

+ 'migration_data_done' => array('BOOL', 0),

+ 'migration_data_state' => array('TEXT', ''),

+ 'migration_start_time' => array('TIMESTAMP', 0),

+ 'migration_end_time' => array('TIMESTAMP', 0),

+ ),

+ 'PRIMARY_KEY' => 'migration_name',

+);

+

+$schema_data['phpbb_modules'] = array(

+ 'COLUMNS' => array(

+ 'module_id' => array('UINT', NULL, 'auto_increment'),

+ 'module_enabled' => array('BOOL', 1),

+ 'module_display' => array('BOOL', 1),

+ 'module_basename' => array('VCHAR', ''),

+ 'module_class' => array('VCHAR:10', ''),

+ 'parent_id' => array('UINT', 0),

+ 'left_id' => array('UINT', 0),

+ 'right_id' => array('UINT', 0),

+ 'module_langname' => array('VCHAR', ''),

+ 'module_mode' => array('VCHAR', ''),

+ 'module_auth' => array('VCHAR', ''),

+ ),

+ 'PRIMARY_KEY' => 'module_id',

+ 'KEYS' => array(

+ 'left_right_id' => array('INDEX', array('left_id', 'right_id')),

+ 'module_enabled' => array('INDEX', 'module_enabled'),

+ 'class_left_id' => array('INDEX', array('module_class', 'left_id')),

+ ),

+);

+

+$schema_data['phpbb_notification_types'] = array(

+ 'COLUMNS' => array(

+ 'notification_type_id' => array('USINT', NULL, 'auto_increment'),

+ 'notification_type_name' => array('VCHAR:255', ''),

+ 'notification_type_enabled' => array('BOOL', 1),

+ ),

+ 'PRIMARY_KEY' => array('notification_type_id'),

+ 'KEYS' => array(

+ 'type' => array('UNIQUE', array('notification_type_name')),

+ ),

+);

+

+$schema_data['phpbb_notifications'] = array(

+ 'COLUMNS' => array(

+ 'notification_id' => array('UINT:10', NULL, 'auto_increment'),

+ 'notification_type_id' => array('USINT', 0),

+ 'item_id' => array('UINT', 0),

+ 'item_parent_id' => array('UINT', 0),

+ 'user_id' => array('UINT', 0),

+ 'notification_read' => array('BOOL', 0),

+ 'notification_time' => array('TIMESTAMP', 1),

+ 'notification_data' => array('TEXT_UNI', ''),

+ ),

+ 'PRIMARY_KEY' => 'notification_id',

+ 'KEYS' => array(

+ 'item_ident' => array('INDEX', array('notification_type_id', 'item_id')),

+ 'user' => array('INDEX', array('user_id', 'notification_read')),

+ ),

+);

+

+$schema_data['phpbb_poll_options'] = array(

+ 'COLUMNS' => array(

+ 'poll_option_id' => array('TINT:4', 0),

+ 'topic_id' => array('UINT', 0),

+ 'poll_option_text' => array('TEXT_UNI', ''),

+ 'poll_option_total' => array('UINT', 0),

+ ),

+ 'KEYS' => array(

+ 'poll_opt_id' => array('INDEX', 'poll_option_id'),

+ 'topic_id' => array('INDEX', 'topic_id'),

+ ),

+);

+

+$schema_data['phpbb_poll_votes'] = array(

+ 'COLUMNS' => array(

+ 'topic_id' => array('UINT', 0),

+ 'poll_option_id' => array('TINT:4', 0),

+ 'vote_user_id' => array('UINT', 0),

+ 'vote_user_ip' => array('VCHAR:40', ''),

+ ),

+ 'KEYS' => array(

+ 'topic_id' => array('INDEX', 'topic_id'),

+ 'vote_user_id' => array('INDEX', 'vote_user_id'),

+ 'vote_user_ip' => array('INDEX', 'vote_user_ip'),

+ ),

+);

+

+$schema_data['phpbb_posts'] = array(

+ 'COLUMNS' => array(

+ 'post_id' => array('UINT', NULL, 'auto_increment'),

+ 'topic_id' => array('UINT', 0),

+ 'forum_id' => array('UINT', 0),

+ 'poster_id' => array('UINT', 0),

+ 'icon_id' => array('UINT', 0),

+ 'poster_ip' => array('VCHAR:40', ''),

+ 'post_time' => array('TIMESTAMP', 0),

+ 'post_visibility' => array('TINT:3', 0),

+ 'post_reported' => array('BOOL', 0),

+ 'enable_bbcode' => array('BOOL', 1),

+ 'enable_smilies' => array('BOOL', 1),

+ 'enable_magic_url' => array('BOOL', 1),

+ 'enable_sig' => array('BOOL', 1),

+ 'post_username' => array('VCHAR_UNI:255', ''),

+ 'post_subject' => array('STEXT_UNI', '', 'true_sort'),

+ 'post_text' => array('MTEXT_UNI', ''),

+ 'post_checksum' => array('VCHAR:32', ''),

+ 'post_attachment' => array('BOOL', 0),

+ 'bbcode_bitfield' => array('VCHAR:255', ''),

+ 'bbcode_uid' => array('VCHAR:8', ''),

+ 'post_postcount' => array('BOOL', 1),

+ 'post_edit_time' => array('TIMESTAMP', 0),

+ 'post_edit_reason' => array('STEXT_UNI', ''),

+ 'post_edit_user' => array('UINT', 0),

+ 'post_edit_count' => array('USINT', 0),

+ 'post_edit_locked' => array('BOOL', 0),

+ 'post_delete_time' => array('TIMESTAMP', 0),

+ 'post_delete_reason' => array('STEXT_UNI', ''),

+ 'post_delete_user' => array('UINT', 0),

+ ),

+ 'PRIMARY_KEY' => 'post_id',

+ 'KEYS' => array(

+ 'forum_id' => array('INDEX', 'forum_id'),

+ 'topic_id' => array('INDEX', 'topic_id'),

+ 'poster_ip' => array('INDEX', 'poster_ip'),

+ 'poster_id' => array('INDEX', 'poster_id'),

+ 'post_visibility' => array('INDEX', 'post_visibility'),

+ 'post_username' => array('INDEX', 'post_username'),

+ 'tid_post_time' => array('INDEX', array('topic_id', 'post_time')),

+ ),

+);

+

+$schema_data['phpbb_privmsgs'] = array(

+ 'COLUMNS' => array(

+ 'msg_id' => array('UINT', NULL, 'auto_increment'),

+ 'root_level' => array('UINT', 0),

+ 'author_id' => array('UINT', 0),

+ 'icon_id' => array('UINT', 0),

+ 'author_ip' => array('VCHAR:40', ''),

+ 'message_time' => array('TIMESTAMP', 0),

+ 'enable_bbcode' => array('BOOL', 1),

+ 'enable_smilies' => array('BOOL', 1),

+ 'enable_magic_url' => array('BOOL', 1),

+ 'enable_sig' => array('BOOL', 1),

+ 'message_subject' => array('STEXT_UNI', ''),

+ 'message_text' => array('MTEXT_UNI', ''),

+ 'message_edit_reason' => array('STEXT_UNI', ''),

+ 'message_edit_user' => array('UINT', 0),

+ 'message_attachment' => array('BOOL', 0),

+ 'bbcode_bitfield' => array('VCHAR:255', ''),

+ 'bbcode_uid' => array('VCHAR:8', ''),

+ 'message_edit_time' => array('TIMESTAMP', 0),

+ 'message_edit_count' => array('USINT', 0),

+ 'to_address' => array('TEXT_UNI', ''),

+ 'bcc_address' => array('TEXT_UNI', ''),

+ 'message_reported' => array('BOOL', 0),

+ ),

+ 'PRIMARY_KEY' => 'msg_id',

+ 'KEYS' => array(

+ 'author_ip' => array('INDEX', 'author_ip'),

+ 'message_time' => array('INDEX', 'message_time'),

+ 'author_id' => array('INDEX', 'author_id'),

+ 'root_level' => array('INDEX', 'root_level'),

+ ),

+);

+

+$schema_data['phpbb_privmsgs_folder'] = array(

+ 'COLUMNS' => array(

+ 'folder_id' => array('UINT', NULL, 'auto_increment'),

+ 'user_id' => array('UINT', 0),

+ 'folder_name' => array('VCHAR_UNI', ''),

+ 'pm_count' => array('UINT', 0),

+ ),

+ 'PRIMARY_KEY' => 'folder_id',

+ 'KEYS' => array(

+ 'user_id' => array('INDEX', 'user_id'),

+ ),

+);

+

+$schema_data['phpbb_privmsgs_rules'] = array(

+ 'COLUMNS' => array(

+ 'rule_id' => array('UINT', NULL, 'auto_increment'),

+ 'user_id' => array('UINT', 0),

+ 'rule_check' => array('UINT', 0),

+ 'rule_connection' => array('UINT', 0),

+ 'rule_string' => array('VCHAR_UNI', ''),

+ 'rule_user_id' => array('UINT', 0),

+ 'rule_group_id' => array('UINT', 0),

+ 'rule_action' => array('UINT', 0),

+ 'rule_folder_id' => array('INT:11', 0),

+ ),

+ 'PRIMARY_KEY' => 'rule_id',

+ 'KEYS' => array(

+ 'user_id' => array('INDEX', 'user_id'),

+ ),

+);

+

+$schema_data['phpbb_privmsgs_to'] = array(

+ 'COLUMNS' => array(

+ 'msg_id' => array('UINT', 0),

+ 'user_id' => array('UINT', 0),

+ 'author_id' => array('UINT', 0),

+ 'pm_deleted' => array('BOOL', 0),

+ 'pm_new' => array('BOOL', 1),

+ 'pm_unread' => array('BOOL', 1),

+ 'pm_replied' => array('BOOL', 0),

+ 'pm_marked' => array('BOOL', 0),

+ 'pm_forwarded' => array('BOOL', 0),

+ 'folder_id' => array('INT:11', 0),

+ ),

+ 'KEYS' => array(

+ 'msg_id' => array('INDEX', 'msg_id'),

+ 'author_id' => array('INDEX', 'author_id'),

+ 'usr_flder_id' => array('INDEX', array('user_id', 'folder_id')),

+ ),

+);

+

+$schema_data['phpbb_profile_fields'] = array(

+ 'COLUMNS' => array(

+ 'field_id' => array('UINT', NULL, 'auto_increment'),

+ 'field_name' => array('VCHAR_UNI', ''),

+ 'field_type' => array('TINT:4', 0),

+ 'field_ident' => array('VCHAR:20', ''),

+ 'field_length' => array('VCHAR:20', ''),

+ 'field_minlen' => array('VCHAR', ''),

+ 'field_maxlen' => array('VCHAR', ''),

+ 'field_novalue' => array('VCHAR_UNI', ''),

+ 'field_default_value' => array('VCHAR_UNI', ''),

+ 'field_validation' => array('VCHAR_UNI:20', ''),

+ 'field_required' => array('BOOL', 0),

+ 'field_show_novalue' => array('BOOL', 0),

+ 'field_show_on_reg' => array('BOOL', 0),

+ 'field_show_on_pm' => array('BOOL', 0),

+ 'field_show_on_vt' => array('BOOL', 0),

+ 'field_show_profile' => array('BOOL', 0),

+ 'field_hide' => array('BOOL', 0),

+ 'field_no_view' => array('BOOL', 0),

+ 'field_active' => array('BOOL', 0),

+ 'field_order' => array('UINT', 0),

+ ),

+ 'PRIMARY_KEY' => 'field_id',

+ 'KEYS' => array(

+ 'fld_type' => array('INDEX', 'field_type'),

+ 'fld_ordr' => array('INDEX', 'field_order'),

+ ),

+);

+

+$schema_data['phpbb_profile_fields_data'] = array(

+ 'COLUMNS' => array(

+ 'user_id' => array('UINT', 0),

+ ),

+ 'PRIMARY_KEY' => 'user_id',

+);

+

+$schema_data['phpbb_profile_fields_lang'] = array(

+ 'COLUMNS' => array(

+ 'field_id' => array('UINT', 0),

+ 'lang_id' => array('UINT', 0),

+ 'option_id' => array('UINT', 0),

+ 'field_type' => array('TINT:4', 0),

+ 'lang_value' => array('VCHAR_UNI', ''),

+ ),

+ 'PRIMARY_KEY' => array('field_id', 'lang_id', 'option_id'),

+);

+

+$schema_data['phpbb_profile_lang'] = array(

+ 'COLUMNS' => array(

+ 'field_id' => array('UINT', 0),

+ 'lang_id' => array('UINT', 0),

+ 'lang_name' => array('VCHAR_UNI', ''),

+ 'lang_explain' => array('TEXT_UNI', ''),

+ 'lang_default_value' => array('VCHAR_UNI', ''),

+ ),

+ 'PRIMARY_KEY' => array('field_id', 'lang_id'),

+);

+

+$schema_data['phpbb_ranks'] = array(

+ 'COLUMNS' => array(

+ 'rank_id' => array('UINT', NULL, 'auto_increment'),

+ 'rank_title' => array('VCHAR_UNI', ''),

+ 'rank_min' => array('UINT', 0),

+ 'rank_special' => array('BOOL', 0),

+ 'rank_image' => array('VCHAR', ''),

+ ),

+ 'PRIMARY_KEY' => 'rank_id',

+);

+

+$schema_data['phpbb_reports'] = array(

+ 'COLUMNS' => array(

+ 'report_id' => array('UINT', NULL, 'auto_increment'),

+ 'reason_id' => array('USINT', 0),

+ 'post_id' => array('UINT', 0),

+ 'pm_id' => array('UINT', 0),

+ 'user_id' => array('UINT', 0),

+ 'user_notify' => array('BOOL', 0),

+ 'report_closed' => array('BOOL', 0),

+ 'report_time' => array('TIMESTAMP', 0),

+ 'report_text' => array('MTEXT_UNI', ''),

+ 'reported_post_text' => array('MTEXT_UNI', ''),

+ 'reported_post_uid' => array('VCHAR:8', ''),

+ 'reported_post_bitfield' => array('VCHAR:255', ''),

+ 'reported_post_enable_magic_url' => array('BOOL', 1),

+ 'reported_post_enable_smilies' => array('BOOL', 1),

+ 'reported_post_enable_bbcode' => array('BOOL', 1)

+ ),

+ 'PRIMARY_KEY' => 'report_id',

+ 'KEYS' => array(

+ 'post_id' => array('INDEX', 'post_id'),

+ 'pm_id' => array('INDEX', 'pm_id'),

+ ),

+);

+

+$schema_data['phpbb_reports_reasons'] = array(

+ 'COLUMNS' => array(

+ 'reason_id' => array('USINT', NULL, 'auto_increment'),

+ 'reason_title' => array('VCHAR_UNI', ''),

+ 'reason_description' => array('MTEXT_UNI', ''),

+ 'reason_order' => array('USINT', 0),

+ ),

+ 'PRIMARY_KEY' => 'reason_id',

+);

+

+$schema_data['phpbb_search_results'] = array(

+ 'COLUMNS' => array(

+ 'search_key' => array('VCHAR:32', ''),

+ 'search_time' => array('TIMESTAMP', 0),

+ 'search_keywords' => array('MTEXT_UNI', ''),

+ 'search_authors' => array('MTEXT', ''),

+ ),

+ 'PRIMARY_KEY' => 'search_key',

+);

+

+$schema_data['phpbb_search_wordlist'] = array(

+ 'COLUMNS' => array(

+ 'word_id' => array('UINT', NULL, 'auto_increment'),

+ 'word_text' => array('VCHAR_UNI', ''),

+ 'word_common' => array('BOOL', 0),

+ 'word_count' => array('UINT', 0),

+ ),

+ 'PRIMARY_KEY' => 'word_id',

+ 'KEYS' => array(

+ 'wrd_txt' => array('UNIQUE', 'word_text'),

+ 'wrd_cnt' => array('INDEX', 'word_count'),

+ ),

+);

+

+$schema_data['phpbb_search_wordmatch'] = array(

+ 'COLUMNS' => array(

+ 'post_id' => array('UINT', 0),

+ 'word_id' => array('UINT', 0),

+ 'title_match' => array('BOOL', 0),

+ ),

+ 'KEYS' => array(

+ 'unq_mtch' => array('UNIQUE', array('word_id', 'post_id', 'title_match')),

+ 'word_id' => array('INDEX', 'word_id'),

+ 'post_id' => array('INDEX', 'post_id'),

+ ),

+);

+

+$schema_data['phpbb_sessions'] = array(

+ 'COLUMNS' => array(

+ 'session_id' => array('CHAR:32', ''),

+ 'session_user_id' => array('UINT', 0),

+ 'session_forum_id' => array('UINT', 0),

+ 'session_last_visit' => array('TIMESTAMP', 0),

+ 'session_start' => array('TIMESTAMP', 0),

+ 'session_time' => array('TIMESTAMP', 0),

+ 'session_ip' => array('VCHAR:40', ''),

+ 'session_browser' => array('VCHAR:150', ''),

+ 'session_forwarded_for' => array('VCHAR:255', ''),

+ 'session_page' => array('VCHAR_UNI', ''),

+ 'session_viewonline' => array('BOOL', 1),

+ 'session_autologin' => array('BOOL', 0),

+ 'session_admin' => array('BOOL', 0),

+ ),

+ 'PRIMARY_KEY' => 'session_id',

+ 'KEYS' => array(

+ 'session_time' => array('INDEX', 'session_time'),

+ 'session_user_id' => array('INDEX', 'session_user_id'),

+ 'session_fid' => array('INDEX', 'session_forum_id'),

+ ),

+);

+

+$schema_data['phpbb_sessions_keys'] = array(

+ 'COLUMNS' => array(

+ 'key_id' => array('CHAR:32', ''),

+ 'user_id' => array('UINT', 0),

+ 'last_ip' => array('VCHAR:40', ''),

+ 'last_login' => array('TIMESTAMP', 0),

+ ),

+ 'PRIMARY_KEY' => array('key_id', 'user_id'),

+ 'KEYS' => array(

+ 'last_login' => array('INDEX', 'last_login'),

+ ),

+);

+

+$schema_data['phpbb_sitelist'] = array(

+ 'COLUMNS' => array(

+ 'site_id' => array('UINT', NULL, 'auto_increment'),

+ 'site_ip' => array('VCHAR:40', ''),

+ 'site_hostname' => array('VCHAR', ''),

+ 'ip_exclude' => array('BOOL', 0),

+ ),

+ 'PRIMARY_KEY' => 'site_id',

+);

+

+$schema_data['phpbb_smilies'] = array(

+ 'COLUMNS' => array(

+ 'smiley_id' => array('UINT', NULL, 'auto_increment'),

+ // We may want to set 'code' to VCHAR:50 or check if unicode support is possible... at the moment only ASCII characters are allowed.

+ 'code' => array('VCHAR_UNI:50', ''),

+ 'emotion' => array('VCHAR_UNI:50', ''),

+ 'smiley_url' => array('VCHAR:50', ''),

+ 'smiley_width' => array('USINT', 0),

+ 'smiley_height' => array('USINT', 0),

+ 'smiley_order' => array('UINT', 0),

+ 'display_on_posting'=> array('BOOL', 1),

+ ),

+ 'PRIMARY_KEY' => 'smiley_id',

+ 'KEYS' => array(

+ 'display_on_post' => array('INDEX', 'display_on_posting'),

+ ),

+);

+

+$schema_data['phpbb_styles'] = array(

+ 'COLUMNS' => array(

+ 'style_id' => array('UINT', NULL, 'auto_increment'),

+ 'style_name' => array('VCHAR_UNI:255', ''),

+ 'style_copyright' => array('VCHAR_UNI', ''),

+ 'style_active' => array('BOOL', 1),

+ 'style_path' => array('VCHAR:100', ''),

+ 'bbcode_bitfield' => array('VCHAR:255', 'kNg='),

+ 'style_parent_id' => array('UINT:4', 0),

+ 'style_parent_tree' => array('TEXT', ''),

+ ),

+ 'PRIMARY_KEY' => 'style_id',

+ 'KEYS' => array(

+ 'style_name' => array('UNIQUE', 'style_name'),

+ ),

+);

+

+$schema_data['phpbb_teampage'] = array(

+ 'COLUMNS' => array(

+ 'teampage_id' => array('UINT', NULL, 'auto_increment'),

+ 'group_id' => array('UINT', 0),

+ 'teampage_name' => array('VCHAR_UNI:255', ''),

+ 'teampage_position' => array('UINT', 0),

+ 'teampage_parent' => array('UINT', 0),

+ ),

+ 'PRIMARY_KEY' => 'teampage_id',

+);

+

+$schema_data['phpbb_topics'] = array(

+ 'COLUMNS' => array(

+ 'topic_id' => array('UINT', NULL, 'auto_increment'),

+ 'forum_id' => array('UINT', 0),

+ 'icon_id' => array('UINT', 0),

+ 'topic_attachment' => array('BOOL', 0),

+ 'topic_visibility' => array('TINT:3', 0),

+ 'topic_reported' => array('BOOL', 0),

+ 'topic_title' => array('STEXT_UNI', '', 'true_sort'),

+ 'topic_poster' => array('UINT', 0),

+ 'topic_time' => array('TIMESTAMP', 0),

+ 'topic_time_limit' => array('TIMESTAMP', 0),

+ 'topic_views' => array('UINT', 0),

+ 'topic_posts_approved' => array('UINT', 0),

+ 'topic_posts_unapproved' => array('UINT', 0),

+ 'topic_posts_softdeleted' => array('UINT', 0),

+ 'topic_status' => array('TINT:3', 0),

+ 'topic_type' => array('TINT:3', 0),

+ 'topic_first_post_id' => array('UINT', 0),

+ 'topic_first_poster_name' => array('VCHAR_UNI', ''),

+ 'topic_first_poster_colour' => array('VCHAR:6', ''),

+ 'topic_last_post_id' => array('UINT', 0),

+ 'topic_last_poster_id' => array('UINT', 0),

+ 'topic_last_poster_name' => array('VCHAR_UNI', ''),

+ 'topic_last_poster_colour' => array('VCHAR:6', ''),

+ 'topic_last_post_subject' => array('STEXT_UNI', ''),

+ 'topic_last_post_time' => array('TIMESTAMP', 0),

+ 'topic_last_view_time' => array('TIMESTAMP', 0),

+ 'topic_moved_id' => array('UINT', 0),

+ 'topic_bumped' => array('BOOL', 0),

+ 'topic_bumper' => array('UINT', 0),

+ 'poll_title' => array('STEXT_UNI', ''),

+ 'poll_start' => array('TIMESTAMP', 0),

+ 'poll_length' => array('TIMESTAMP', 0),

+ 'poll_max_options' => array('TINT:4', 1),

+ 'poll_last_vote' => array('TIMESTAMP', 0),

+ 'poll_vote_change' => array('BOOL', 0),

+ 'topic_delete_time' => array('TIMESTAMP', 0),

+ 'topic_delete_reason' => array('STEXT_UNI', ''),

+ 'topic_delete_user' => array('UINT', 0),

+ ),

+ 'PRIMARY_KEY' => 'topic_id',

+ 'KEYS' => array(

+ 'forum_id' => array('INDEX', 'forum_id'),

+ 'forum_id_type' => array('INDEX', array('forum_id', 'topic_type')),

+ 'last_post_time' => array('INDEX', 'topic_last_post_time'),

+ 'topic_visibility' => array('INDEX', 'topic_visibility'),

+ 'forum_appr_last' => array('INDEX', array('forum_id', 'topic_visibility', 'topic_last_post_id')),

+ 'fid_time_moved' => array('INDEX', array('forum_id', 'topic_last_post_time', 'topic_moved_id')),

+ ),

+);

+

+$schema_data['phpbb_topics_track'] = array(

+ 'COLUMNS' => array(

+ 'user_id' => array('UINT', 0),

+ 'topic_id' => array('UINT', 0),

+ 'forum_id' => array('UINT', 0),

+ 'mark_time' => array('TIMESTAMP', 0),

+ ),

+ 'PRIMARY_KEY' => array('user_id', 'topic_id'),

+ 'KEYS' => array(

+ 'topic_id' => array('INDEX', 'topic_id'),

+ 'forum_id' => array('INDEX', 'forum_id'),

+ ),

+);

+

+$schema_data['phpbb_topics_posted'] = array(

+ 'COLUMNS' => array(

+ 'user_id' => array('UINT', 0),

+ 'topic_id' => array('UINT', 0),

+ 'topic_posted' => array('BOOL', 0),

+ ),

+ 'PRIMARY_KEY' => array('user_id', 'topic_id'),

+);

+

+$schema_data['phpbb_topics_watch'] = array(

+ 'COLUMNS' => array(

+ 'topic_id' => array('UINT', 0),

+ 'user_id' => array('UINT', 0),

+ 'notify_status' => array('BOOL', 0),

+ ),

+ 'KEYS' => array(

+ 'topic_id' => array('INDEX', 'topic_id'),

+ 'user_id' => array('INDEX', 'user_id'),

+ 'notify_stat' => array('INDEX', 'notify_status'),

+ ),

+);

+

+$schema_data['phpbb_user_notifications'] = array(

+ 'COLUMNS' => array(

+ 'item_type' => array('VCHAR:255', ''),

+ 'item_id' => array('UINT', 0),

+ 'user_id' => array('UINT', 0),

+ 'method' => array('VCHAR:255', ''),

+ 'notify' => array('BOOL', 1),

+ ),

+);

+

+$schema_data['phpbb_user_group'] = array(

+ 'COLUMNS' => array(

+ 'group_id' => array('UINT', 0),

+ 'user_id' => array('UINT', 0),

+ 'group_leader' => array('BOOL', 0),

+ 'user_pending' => array('BOOL', 1),

+ ),

+ 'KEYS' => array(

+ 'group_id' => array('INDEX', 'group_id'),

+ 'user_id' => array('INDEX', 'user_id'),

+ 'group_leader' => array('INDEX', 'group_leader'),

+ ),

+);

+

+$schema_data['phpbb_users'] = array(

+ 'COLUMNS' => array(

+ 'user_id' => array('UINT', NULL, 'auto_increment'),

+ 'user_type' => array('TINT:2', 0),

+ 'group_id' => array('UINT', 3),

+ 'user_permissions' => array('MTEXT', ''),

+ 'user_perm_from' => array('UINT', 0),

+ 'user_ip' => array('VCHAR:40', ''),

+ 'user_regdate' => array('TIMESTAMP', 0),

+ 'username' => array('VCHAR_CI', ''),

+ 'username_clean' => array('VCHAR_CI', ''),

+ 'user_password' => array('VCHAR_UNI:40', ''),

+ 'user_passchg' => array('TIMESTAMP', 0),

+ 'user_pass_convert' => array('BOOL', 0),

+ 'user_email' => array('VCHAR_UNI:100', ''),

+ 'user_email_hash' => array('BINT', 0),

+ 'user_birthday' => array('VCHAR:10', ''),

+ 'user_lastvisit' => array('TIMESTAMP', 0),

+ 'user_lastmark' => array('TIMESTAMP', 0),

+ 'user_lastpost_time' => array('TIMESTAMP', 0),

+ 'user_lastpage' => array('VCHAR_UNI:200', ''),

+ 'user_last_confirm_key' => array('VCHAR:10', ''),

+ 'user_last_search' => array('TIMESTAMP', 0),

+ 'user_warnings' => array('TINT:4', 0),

+ 'user_last_warning' => array('TIMESTAMP', 0),

+ 'user_login_attempts' => array('TINT:4', 0),

+ 'user_inactive_reason' => array('TINT:2', 0),

+ 'user_inactive_time' => array('TIMESTAMP', 0),

+ 'user_posts' => array('UINT', 0),

+ 'user_lang' => array('VCHAR:30', ''),

+ 'user_timezone' => array('VCHAR:100', 'UTC'),

+ 'user_dateformat' => array('VCHAR_UNI:30', 'd M Y H:i'),

+ 'user_style' => array('UINT', 0),

+ 'user_rank' => array('UINT', 0),

+ 'user_colour' => array('VCHAR:6', ''),

+ 'user_new_privmsg' => array('INT:4', 0),

+ 'user_unread_privmsg' => array('INT:4', 0),

+ 'user_last_privmsg' => array('TIMESTAMP', 0),

+ 'user_message_rules' => array('BOOL', 0),

+ 'user_full_folder' => array('INT:11', -3),

+ 'user_emailtime' => array('TIMESTAMP', 0),

+ 'user_topic_show_days' => array('USINT', 0),

+ 'user_topic_sortby_type' => array('VCHAR:1', 't'),

+ 'user_topic_sortby_dir' => array('VCHAR:1', 'd'),

+ 'user_post_show_days' => array('USINT', 0),

+ 'user_post_sortby_type' => array('VCHAR:1', 't'),

+ 'user_post_sortby_dir' => array('VCHAR:1', 'a'),

+ 'user_notify' => array('BOOL', 0),

+ 'user_notify_pm' => array('BOOL', 1),

+ 'user_notify_type' => array('TINT:4', 0),

+ 'user_allow_pm' => array('BOOL', 1),

+ 'user_allow_viewonline' => array('BOOL', 1),

+ 'user_allow_viewemail' => array('BOOL', 1),

+ 'user_allow_massemail' => array('BOOL', 1),

+ 'user_options' => array('UINT:11', 230271),

+ 'user_avatar' => array('VCHAR', ''),

+ 'user_avatar_type' => array('VCHAR:255', ''),

+ 'user_avatar_width' => array('USINT', 0),

+ 'user_avatar_height' => array('USINT', 0),

+ 'user_sig' => array('MTEXT_UNI', ''),

+ 'user_sig_bbcode_uid' => array('VCHAR:8', ''),

+ 'user_sig_bbcode_bitfield' => array('VCHAR:255', ''),

+ 'user_from' => array('VCHAR_UNI:100', ''),

+ 'user_icq' => array('VCHAR:15', ''),

+ 'user_aim' => array('VCHAR_UNI', ''),

+ 'user_yim' => array('VCHAR_UNI', ''),

+ 'user_msnm' => array('VCHAR_UNI', ''),

+ 'user_jabber' => array('VCHAR_UNI', ''),

+ 'user_website' => array('VCHAR_UNI:200', ''),

+ 'user_occ' => array('TEXT_UNI', ''),

+ 'user_interests' => array('TEXT_UNI', ''),

+ 'user_actkey' => array('VCHAR:32', ''),

+ 'user_newpasswd' => array('VCHAR_UNI:40', ''),

+ 'user_form_salt' => array('VCHAR_UNI:32', ''),

+ 'user_new' => array('BOOL', 1),

+ 'user_reminded' => array('TINT:4', 0),

+ 'user_reminded_time' => array('TIMESTAMP', 0),

+ ),

+ 'PRIMARY_KEY' => 'user_id',

+ 'KEYS' => array(

+ 'user_birthday' => array('INDEX', 'user_birthday'),

+ 'user_email_hash' => array('INDEX', 'user_email_hash'),

+ 'user_type' => array('INDEX', 'user_type'),

+ 'username_clean' => array('UNIQUE', 'username_clean'),

+ ),

+);

+

+$schema_data['phpbb_warnings'] = array(

+ 'COLUMNS' => array(

+ 'warning_id' => array('UINT', NULL, 'auto_increment'),

+ 'user_id' => array('UINT', 0),

+ 'post_id' => array('UINT', 0),

+ 'log_id' => array('UINT', 0),

+ 'warning_time' => array('TIMESTAMP', 0),

+ ),

+ 'PRIMARY_KEY' => 'warning_id',

+);

+

+$schema_data['phpbb_words'] = array(

+ 'COLUMNS' => array(

+ 'word_id' => array('UINT', NULL, 'auto_increment'),

+ 'word' => array('VCHAR_UNI', ''),

+ 'replacement' => array('VCHAR_UNI', ''),

+ ),

+ 'PRIMARY_KEY' => 'word_id',

+);

+

+$schema_data['phpbb_zebra'] = array(

+ 'COLUMNS' => array(

+ 'user_id' => array('UINT', 0),

+ 'zebra_id' => array('UINT', 0),

+ 'friend' => array('BOOL', 0),

+ 'foe' => array('BOOL', 0),

+ ),

+ 'PRIMARY_KEY' => array('user_id', 'zebra_id'),

+);

+ global $symfony_request, $phpbb_root_path;

+ $corrected_path = $symfony_request !== null ? phpbb_get_web_root_path($symfony_request, $phpbb_root_path) : '';

+ if ($corrected_path)

+ {

+ $url = substr($corrected_path . $url, strlen($phpbb_root_path));

+ }

+

+ global $phpbb_dispatcher, $request, $phpbb_container, $symfony_request;

+ // This path is sent with the base template paths in the assign_vars()

+ // call below. We need to correct it in case we are accessing from a

+ // controller because the web paths will be incorrect otherwise.

+ $corrected_path = $symfony_request !== null ? phpbb_get_web_root_path($symfony_request, $phpbb_root_path) : '';

+ $web_path = (defined('PHPBB_USE_BOARD_URL_PATH') && PHPBB_USE_BOARD_URL_PATH) ? $board_url : $corrected_path;

+ // If we have already gotten it, don't go back through all the trouble of

+ // creating it again; instead, just return it. This allows multiple calls

+ // of this method so we don't have to globalize $symfony_request in other

+ // functions.

+ static $symfony_request;

+ if (null !== $symfony_request)

+ {

+ return $symfony_request;

+ }

+

+ $symfony_request = new Request($get_parameters, $post_parameters, array(), $cookie_parameters, $files_parameters, $server_parameters);

+ return $symfony_request;

+}

+/**

+* Get a relative root path from the current URL

+*

+* @param Request $symfony_request Symfony Request object

+*/

+function phpbb_get_web_root_path(Request $symfony_request, $phpbb_root_path = '')

+{

+ static $path;

+ if (null !== $path)

+ {

+ return $path;

+ }

+

+ $path_info = $symfony_request->getPathInfo();

+ if ($path_info === '/')

+ $path = $phpbb_root_path;

+ return $path;

+ $corrections = substr_count($path_info, '/');

+

+ // When URL Rewriting is enabled, app.php is optional. We have to

+ // correct for it not being there

+ if (strpos($symfony_request->getRequestUri(), $symfony_request->getScriptName()) === false)

+ {

+ $corrections -= 1;

+ }

+ $path = $phpbb_root_path . str_repeat('../', $corrections);

+ return $path;

+ $template->set_custom_style('adm', array($module_style_dir, $phpbb_admin_path . 'style'));

+ // If a username was supplied or the poster is a guest, we will use the supplied username.

+ // Doing it this way we can use "...post by guest-username..." in notifications when

+ // "guest-username" is supplied or ommit the username if it is not.

+ $username = ($username !== '' || !$user->data['is_registered']) ? $username : $user->data['username'];

+

+$template->set_custom_style('adm', $paths);

+ $template->set_custom_style('adm', $paths);

+You are receiving this notification because you are watching the forum "{FORUM_NAME}" at "{SITENAME}". This forum has received a new reply to the topic "{TOPIC_TITLE}"<!-- IF AUTHOR_NAME !== '' --> by {AUTHOR_NAME}<!-- ENDIF --> since your last visit. You can use the following link to view the last unread reply, no more notifications will be sent until you visit the topic.

+You are receiving this notification because you are watching the forum "{FORUM_NAME}" at "{SITENAME}". This forum has received a new topic<!-- IF AUTHOR_NAME !== '' --> by {AUTHOR_NAME}<!-- ENDIF --> since your last visit, "{TOPIC_TITLE}". You can use the following link to view the forum, no more notifications will be sent until you visit the forum.

+You are receiving this notification because you are watching the topic "{TOPIC_TITLE}" at "{SITENAME}". This topic has received a reply<!-- IF AUTHOR_NAME !== '' --> by {AUTHOR_NAME}<!-- ENDIF --> since your last visit. You can use the following link to view the replies made, no more notifications will be sent until you visit the topic.

+ * Request object

+ * @var phpbb_request

+ */

+ protected $request;

+

+ /**

+ public function __construct(phpbb_template $template, phpbb_user $user, phpbb_request_interface $request, $phpbb_root_path, $php_ext)

+ $this->request = $request;

+ $request_uri = $this->request->variable('REQUEST_URI', '', false, phpbb_request::SERVER);

+ $script_name = $this->request->variable('SCRIPT_NAME', '', false, phpbb_request::SERVER);

+

+ // If the app.php file is being used (no rewrite) keep it in the URL.

+ // Otherwise, don't include it.

+ $route_prefix = $this->phpbb_root_path;

+ $parts = explode('/', $script_name);

+ $route_prefix .= strpos($request_uri, $script_name) === 0 ? array_pop($parts) . '/' : '';

+ return append_sid($route_prefix . "$route" . $route_params, $params, $is_amp, $session_id);

+ var $dbms_type_map = array();

+

+ /**

+ * Get the column types for every database we support

+ *

+ * @return array

+ */

+ public static function get_dbms_type_map()

+ {

+ return array(

+ 'mysql_41' => array(

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

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

+ 'UINT' => 'mediumint(8) UNSIGNED',

+ 'UINT:' => 'int(%d) UNSIGNED',

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

+ 'USINT' => 'smallint(4) UNSIGNED',

+ 'BOOL' => 'tinyint(1) UNSIGNED',

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

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

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

+ 'XSTEXT' => 'text',

+ 'XSTEXT_UNI'=> 'varchar(100)',

+ 'STEXT' => 'text',

+ 'STEXT_UNI' => 'varchar(255)',

+ 'TEXT' => 'text',

+ 'TEXT_UNI' => 'text',

+ 'MTEXT' => 'mediumtext',

+ 'MTEXT_UNI' => 'mediumtext',

+ 'TIMESTAMP' => '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' => 'varbinary(255)',

+ ),

+

+ 'mysql_40' => array(

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

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

+ 'UINT' => 'mediumint(8) UNSIGNED',

+ 'UINT:' => 'int(%d) UNSIGNED',

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

+ 'USINT' => 'smallint(4) UNSIGNED',

+ 'BOOL' => 'tinyint(1) UNSIGNED',

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

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

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

+ 'XSTEXT' => 'blob',

+ 'XSTEXT_UNI'=> 'blob',

+ 'STEXT' => 'blob',

+ 'STEXT_UNI' => 'blob',

+ 'TEXT' => 'blob',

+ 'TEXT_UNI' => 'blob',

+ 'MTEXT' => 'mediumblob',

+ 'MTEXT_UNI' => 'mediumblob',

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

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

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

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

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

+ 'VCHAR_UNI' => 'blob',

+ 'VCHAR_UNI:'=> array('varbinary(%d)', 'limit' => array('mult', 3, 255, 'blob')),

+ 'VCHAR_CI' => 'blob',

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

+ ),

+

+ 'firebird' => array(

+ 'INT:' => 'INTEGER',

+ 'BINT' => 'DOUBLE PRECISION',

+ 'UINT' => 'INTEGER',

+ 'UINT:' => 'INTEGER',

+ 'TINT:' => 'INTEGER',

+ 'USINT' => 'INTEGER',

+ 'BOOL' => 'INTEGER',

+ 'VCHAR' => 'VARCHAR(255) CHARACTER SET NONE',

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

+ 'CHAR:' => 'CHAR(%d) CHARACTER SET NONE',

+ 'XSTEXT' => 'BLOB SUB_TYPE TEXT CHARACTER SET NONE',

+ 'STEXT' => 'BLOB SUB_TYPE TEXT CHARACTER SET NONE',

+ 'TEXT' => 'BLOB SUB_TYPE TEXT CHARACTER SET NONE',

+ 'MTEXT' => 'BLOB SUB_TYPE TEXT CHARACTER SET NONE',

+ 'XSTEXT_UNI'=> 'VARCHAR(100) CHARACTER SET UTF8',

+ 'STEXT_UNI' => 'VARCHAR(255) CHARACTER SET UTF8',

+ 'TEXT_UNI' => 'BLOB SUB_TYPE TEXT CHARACTER SET UTF8',

+ 'MTEXT_UNI' => 'BLOB SUB_TYPE TEXT CHARACTER SET UTF8',

+ 'TIMESTAMP' => 'INTEGER',

+ 'DECIMAL' => 'DOUBLE PRECISION',

+ 'DECIMAL:' => 'DOUBLE PRECISION',

+ 'PDECIMAL' => 'DOUBLE PRECISION',

+ 'PDECIMAL:' => 'DOUBLE PRECISION',

+ 'VCHAR_UNI' => 'VARCHAR(255) CHARACTER SET UTF8',

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

+ 'VCHAR_CI' => 'VARCHAR(255) CHARACTER SET UTF8',

+ 'VARBINARY' => 'CHAR(255) CHARACTER SET NONE',

+ ),

+

+ 'mssql' => array(

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

+ 'BINT' => '[float]',

+ 'UINT' => '[int]',

+ 'UINT:' => '[int]',

+ 'TINT:' => '[int]',

+ 'USINT' => '[int]',

+ 'BOOL' => '[int]',

+ 'VCHAR' => '[varchar] (255)',

+ 'VCHAR:' => '[varchar] (%d)',

+ 'CHAR:' => '[char] (%d)',

+ 'XSTEXT' => '[varchar] (1000)',

+ 'STEXT' => '[varchar] (3000)',

+ 'TEXT' => '[varchar] (8000)',

+ 'MTEXT' => '[text]',

+ 'XSTEXT_UNI'=> '[varchar] (100)',

+ 'STEXT_UNI' => '[varchar] (255)',

+ 'TEXT_UNI' => '[varchar] (4000)',

+ 'MTEXT_UNI' => '[text]',

+ 'TIMESTAMP' => '[int]',

+ 'DECIMAL' => '[float]',

+ 'DECIMAL:' => '[float]',

+ 'PDECIMAL' => '[float]',

+ 'PDECIMAL:' => '[float]',

+ 'VCHAR_UNI' => '[varchar] (255)',

+ 'VCHAR_UNI:'=> '[varchar] (%d)',

+ 'VCHAR_CI' => '[varchar] (255)',

+ 'VARBINARY' => '[varchar] (255)',

+ ),

+

+ 'mssqlnative' => array(

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

+ 'BINT' => '[float]',

+ 'UINT' => '[int]',

+ 'UINT:' => '[int]',

+ 'TINT:' => '[int]',

+ 'USINT' => '[int]',

+ 'BOOL' => '[int]',

+ 'VCHAR' => '[varchar] (255)',

+ 'VCHAR:' => '[varchar] (%d)',

+ 'CHAR:' => '[char] (%d)',

+ 'XSTEXT' => '[varchar] (1000)',

+ 'STEXT' => '[varchar] (3000)',

+ 'TEXT' => '[varchar] (8000)',

+ 'MTEXT' => '[text]',

+ 'XSTEXT_UNI'=> '[varchar] (100)',

+ 'STEXT_UNI' => '[varchar] (255)',

+ 'TEXT_UNI' => '[varchar] (4000)',

+ 'MTEXT_UNI' => '[text]',

+ 'TIMESTAMP' => '[int]',

+ 'DECIMAL' => '[float]',

+ 'DECIMAL:' => '[float]',

+ 'PDECIMAL' => '[float]',

+ 'PDECIMAL:' => '[float]',

+ 'VCHAR_UNI' => '[varchar] (255)',

+ 'VCHAR_UNI:'=> '[varchar] (%d)',

+ 'VCHAR_CI' => '[varchar] (255)',

+ 'VARBINARY' => '[varchar] (255)',

+ ),

+

+ 'oracle' => array(

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

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

+ 'UINT' => 'number(8)',

+ 'UINT:' => 'number(%d)',

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

+ 'USINT' => 'number(4)',

+ 'BOOL' => 'number(1)',

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

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

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

+ 'XSTEXT' => 'varchar2(1000)',

+ 'STEXT' => 'varchar2(3000)',

+ 'TEXT' => 'clob',

+ 'MTEXT' => 'clob',

+ 'XSTEXT_UNI'=> 'varchar2(300)',

+ 'STEXT_UNI' => 'varchar2(765)',

+ 'TEXT_UNI' => 'clob',

+ 'MTEXT_UNI' => 'clob',

+ 'TIMESTAMP' => 'number(11)',

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

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

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

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

+ 'VCHAR_UNI' => 'varchar2(765)',

+ 'VCHAR_UNI:'=> array('varchar2(%d)', 'limit' => array('mult', 3, 765, 'clob')),

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

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

+ ),

+

+ 'sqlite' => array(

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

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

+ 'UINT' => 'INTEGER UNSIGNED', //'mediumint(8) UNSIGNED',

+ 'UINT:' => 'INTEGER UNSIGNED', // 'int(%d) UNSIGNED',

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

+ 'USINT' => 'INTEGER UNSIGNED', //'mediumint(4) UNSIGNED',

+ 'BOOL' => 'INTEGER UNSIGNED', //'tinyint(1) 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',

+ ),

+

+ 'postgres' => array(

+ 'INT:' => 'INT4',

+ 'BINT' => 'INT8',

+ 'UINT' => 'INT4', // unsigned

+ 'UINT:' => 'INT4', // unsigned

+ 'USINT' => 'INT2', // unsigned

+ 'BOOL' => 'INT2', // unsigned

+ 'TINT:' => 'INT2',

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

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

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

+ 'XSTEXT' => 'varchar(1000)',

+ 'STEXT' => 'varchar(3000)',

+ 'TEXT' => 'varchar(8000)',

+ 'MTEXT' => 'TEXT',

+ 'XSTEXT_UNI'=> 'varchar(100)',

+ 'STEXT_UNI' => 'varchar(255)',

+ 'TEXT_UNI' => 'varchar(4000)',

+ 'MTEXT_UNI' => 'TEXT',

+ 'TIMESTAMP' => 'INT4', // 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_ci',

+ 'VARBINARY' => 'bytea',

+ ),

+ );

+ }

+ $this->dbms_type_map = self::get_dbms_type_map();

+

+ $matches[2] = preg_replace('#^([\'"])?(.*?)\1$#', '$2', $matches[2]);

+ // Replace ELSE IF with ELSEIF

+ $code = preg_replace('#<!-- ELSE IF (.+?) -->#', '<!-- ELSEIF $1 -->', $code);

+

+ // Replace our "div by" with Twig's divisibleby (Twig does not like test names with spaces)

+ $code = preg_replace('# div by ([0-9]+)#', ' divisibleby($1)', $code);

+

+ // Only return the username when it is either a guest posting or we are editing a post and

+ // the username was supplied; otherwise post_data might hold the data of the post that is

+ // being quoted (which could result in the username being returned being that of the quoted

+ // post's poster, not the poster of the current post). See: PHPBB3-11769 for more information.

+ $post_author_name = ((!$user->data['is_registered'] || $mode == 'edit') && $post_data['username'] !== '') ? $post_data['username'] : '';

+

+ $redirect_url = submit_post($mode, $post_data['post_subject'], $post_author_name, $post_data['topic_type'], $poll, $data, $update_message, ($update_message || $update_subject) ? true : false);

+ <p class="post-notice reported">{L_REPORT_CLOSED}</p>

+ <p class="post-notice unapproved">

+ <p class="post-notice deleted">

+ <p class="post-notice reported">

+ <!-- IF postrow.S_POST_UNAPPROVED -->

+ <p class="post-notice unapproved">

+ <a href="{postrow.U_MCP_APPROVE}"><strong>{L_POST_UNAPPROVED}</strong></a>

+ </p>

+ <!-- ENDIF -->

+

+ <!-- IF postrow.S_POST_DELETED -->

+ <p class="post-notice deleted">

+ <a href="{postrow.U_MCP_APPROVE}"><strong>{L_POST_DELETED}</strong></a>

+ </p>

+ <!-- ENDIF -->

+

+ <!-- IF postrow.S_POST_REPORTED -->

+ <p class="post-notice reported">

+ <a href="{postrow.U_MCP_REPORT}"><strong>{L_POST_REPORTED}</strong></a>

+ <div class="post-notice error">{L_DOWNLOAD_NOTICE}</div>

+ <!-- IF postrow.S_POST_UNAPPROVED -->

+ <p class="post-notice unapproved">

+ <strong>{L_POST_UNAPPROVED}</strong>

+ <input class="button2" type="submit" value="{L_DISAPPROVE}" name="action[disapprove]" />

+ <input class="button1" type="submit" value="{L_APPROVE}" name="action[approve]" />

+ <input type="hidden" name="post_id_list[]" value="{postrow.POST_ID}" />

+ {S_FORM_TOKEN}

+ <!-- ELSEIF postrow.S_POST_DELETED -->

+ <form method="post" class="mcp_approve" action="{postrow.U_APPROVE_ACTION}">

+ <p class="post-notice deleted">

+ <strong>{L_POST_DELETED}</strong>

+ <input class="button2" type="submit" value="{L_DELETE}" name="action[disapprove]" />

+ <input class="button1" type="submit" value="{L_RESTORE}" name="action[restore]" />

+ <input type="hidden" name="post_id_list[]" value="{postrow.POST_ID}" />

+ {S_FORM_TOKEN}

+ </p>

+ </form>

+ <!-- ENDIF -->

+

+ <!-- IF postrow.S_POST_REPORTED -->

+ <p class="post-notice reported">

+ <a href="{postrow.U_MCP_REPORT}"><strong>{L_POST_REPORTED}</strong></a>

+ </p>

+.rtl p.post-notice:before {

+ left: auto;

+ right: 0;

+ padding-left: 5px;

+ padding-right: 26px;

+}

+

+p.post-notice {

+p.post-notice.deleted:before {

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

+}

+

+p.post-notice.unapproved:before {

+ background-image: url("./images/icon_topic_unapproved.gif");

+}

+

+p.post-notice.reported:before, p.post-notice.error:before {

+ background-image: url("./images/icon_topic_reported.gif");

+}

+

+

+p.post-notice {

+ position: relative;

+ padding-left: 26px;

+ min-height: 14px;

+ margin-bottom: 1em;

+p.post-notice:before {

+ content: '';

+ display: block;

+ position: absolute;

+ top: 0;

+ bottom: 0;

+ left: 0;

+ width: 28px;

+ background: transparent none 50% 50% no-repeat;

+ pointer-events: none;

+form > p.post-notice strong {

+ line-height: 20px;

+ array('foo/bar?t=1&amp;f=2', false, true, false, 'foo/bar?t=1&amp;f=2', 'parameters in url-argument'),

+ array('foo/bar', 't=1&amp;f=2', true, false, 'foo/bar?t=1&amp;f=2', 'parameters in params-argument using amp'),

+ array('foo/bar', 't=1&f=2', false, false, 'foo/bar?t=1&f=2', 'parameters in params-argument using &'),

+ array('foo/bar', array('t' => 1, 'f' => 2), true, false, 'foo/bar?t=1&amp;f=2', 'parameters in params-argument as array'),

+ array('foo/bar', 't=1&amp;f=2', true, 'custom-sid', 'foo/bar?t=1&amp;f=2&amp;sid=custom-sid', 'using session_id'),

+ array('foo/bar?t=1&amp;f=2#anchor', false, true, false, 'foo/bar?t=1&amp;f=2#anchor', 'anchor in url-argument'),

+ array('foo/bar', 't=1&amp;f=2#anchor', true, false, 'foo/bar?t=1&amp;f=2#anchor', 'anchor in params-argument'),

+ array('foo/bar', array('t' => 1, 'f' => 2, '#' => 'anchor'), true, false, 'foo/bar?t=1&amp;f=2#anchor', 'anchor in params-argument (array)'),

+ array('foo/bar?t=1&amp;f=2#anchor', false, true, 'custom-sid', 'foo/bar?t=1&amp;f=2&amp;sid=custom-sid#anchor', 'anchor in url-argument using session_id'),

+ array('foo/bar', 't=1&amp;f=2#anchor', true, 'custom-sid', 'foo/bar?t=1&amp;f=2&amp;sid=custom-sid#anchor', 'anchor in params-argument using session_id'),

+ array('foo/bar', array('t' => 1, 'f' => 2, '#' => 'anchor'), true, 'custom-sid', 'foo/bar?t=1&amp;f=2&amp;sid=custom-sid#anchor', 'anchor in params-argument (array) using session_id'),

+ array('foo/bar', false, true, false, 'foo/bar', 'no params using bool false'),

+ array('foo/bar', '', true, false, 'foo/bar', 'no params using empty string'),

+ array('foo/bar', array(), true, false, 'foo/bar', 'no params using empty array'),

+

+ $request = new phpbb_mock_request($_GET, $_POST, $_COOKIE, $_SERVER, false, $_FILES);

+ $helper = new phpbb_controller_helper($this->template, $this->user, $request, '', 'php');

+ $crawler = self::request('GET', 'app.php/foo/bar', array(), false);

+ $crawler = self::request('GET', 'app.php/foo/template');

+ $crawler = self::request('GET', 'app.php/foo/baz', array(), false);

+ $crawler = self::request('GET', 'app.php/foo/exception', array(), false);

+ $crawler = self::request('GET', 'app.php/does/not/exist', array(), false);

+class phpbb_mock_auth_provider extends phpbb_auth_provider_base

+ public function login($username, $password)

+ array('S_OTHER_OTHER_VALUE' => true),

+ array(),

+ array(),

+ '|S_OTHER_OTHER_VALUE|!false',

+ ),

+ array(

+ 'if.html',

+ "xyz\nabc\n\$VALUE == 'abc'abc\nbar\nbar\nabc\ntest!@#$%^&*()_-=+{}[]:;\",<.>/?\n[]",

+<!-- DEFINE $VALUE = '' -->

+[{$VALUE}]

+<!-- ELSE IF S_OTHER_OTHER_VALUE -->

+|S_OTHER_OTHER_VALUE|

+ location ~ \.php {