- 5.3

- 5.4

- 5.5

- hhvm

env:

install:

- sh -c "if [ '$DB' = 'mariadb' ]; then travis/setup-mariadb.sh; fi"

- sh -c "if [ `php -r "echo (int) version_compare(PHP_VERSION, '5.3.19', '>=');"` = "1" ]; then travis/setup-webserver.sh; fi"

- cd phpBB

- php ../composer.phar install --dev --no-interaction --prefer-source

- cd ..

- sh -c "if [ '$TRAVIS_PHP_VERSION' = '5.5' -a '$DB' = 'mysql' ]; then ../phpBB/vendor/bin/phing sniff; fi"

- cd ..

- phpBB/vendor/bin/phpunit --configuration travis/phpunit-$DB-travis.xml

matrix:

allow_failures:

<project name="phpBB" description="The phpBB forum software" default="all" basedir="../">

<!-- a few settings for the build -->

<!-- no configuration should be needed beyond this point -->

<property name="oldversions" value="${olderversions}, ${prevversion}" />

<property name="dir" value="build/old_versions/release-${version}" />

</phingcall>

../new_version/patches/phpBB-${version}_to_${newversion}.patch" escape="false" />

</target>

<exec dir="build" command="php -f package.php '${versions}' > logs/package.log" escape="false" />

<exec dir="build" escape="false"

command="diff -crNEBwd old_versions/release-${prevversion}/language new_version/phpBB3/language >

<exec dir="build" escape="false"

command="diff -crNEBwd old_versions/release-${prevversion}/styles/prosilver new_version/phpBB3/styles/prosilver >

<exec dir="build" escape="false"

command="diff -crNEBwd old_versions/release-${prevversion}/styles/subsilver2 new_version/phpBB3/styles/subsilver2 >

<exec dir="build" escape="false"

command="git shortlog --summary --numbered release-${prevversion}...HEAD >

<exec dir="build" escape="false"

command="git diff --stat release-${prevversion}...HEAD >

<phingcall target="checksum-dir">

<property name="dir" value="build/new_version/release_files" />

<!-- Method arguments with default values MUST go at the end of the argument list. -->

<rule ref="PEAR.Functions.ValidDefaultValue" />

<!-- In the argument list, there MUST NOT be a space before each comma,

and there MUST be one space after each comma. -->

<rule ref="Squiz.Functions.FunctionDeclarationArgumentSpacing">

<dd><input type="checkbox" class="radio" id="field_show_on_vt" name="field_show_on_vt" value="1"<!-- IF S_SHOW_ON_VT --> checked="checked"<!-- ENDIF --> /></dd>

</dl>

<dl>

<dt><label for="field_required">{L_REQUIRED_FIELD}{L_COLON}</label><br /><span>{L_REQUIRED_FIELD_EXPLAIN}</span></dt>

<dd><input type="checkbox" class="radio" id="field_required" name="field_required" value="1"<!-- IF S_FIELD_REQUIRED --> checked="checked"<!-- ENDIF --> /></dd>

</dl>

<dd><input type="url" id="website" name="website" value="{WEBSITE}" /></dd>

</dl>

<dl>

<dt><label for="birthday">{L_BIRTHDAY}{L_COLON}</label><br /><span>{L_BIRTHDAY_EXPLAIN}</span></dt>

<dd>{L_DAY}{L_COLON} <select id="birthday" name="bday_day">{S_BIRTHDAY_DAY_OPTIONS}</select> {L_MONTH}{L_COLON} <select name="bday_month">{S_BIRTHDAY_MONTH_OPTIONS}</select> {L_YEAR}{L_COLON} <select name="bday_year">{S_BIRTHDAY_YEAR_OPTIONS}</select></dd>

</dl>

}*/

.clearfix, .row, #content, fieldset dl, #page-body {

overflow: hidden;

}

phpbb.plupload.deleteFile = function(row, attachId) {

// If there's no attach id, then the file hasn't been uploaded. Simply delete the row.

if (typeof attachId === 'undefined') {

row.slideUp(100, function() {

row.remove();

phpbb.plupload.hideEmptyList();

- %core.php_ext%

- %core.table_prefix%

- @migrator.tool_collection

migrator.tool_collection:

class: phpbb\di\service_collection

$email = "nobody@localhost";

$icq = "12345678";

$website = "http://www.phpbb.com";

$signature = "$username: phpBB tester.";

$signature_bbcode_uid = "";

$avatar_filename = "";

}

$sql .= "1, '')";

<ol>

<li><a href="#changelog">Changelog</a>

<ol style="list-style-type: lower-roman;">

<li><a href="#v310a1">Changes since 3.1.0-a1</a></li>

<li><a href="#v30x">Changes since 3.0.x</a></li>

<li><a href="#v3011">Changes since 3.0.11</a></li>

<div class="content">

<h4>Bug</h4>

<ul>

<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11998">PHPBB3-11998</a>] - Add console / command line client environment </li>

</ul>

<h4>Bug</h4>

<ul>

<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11913">PHPBB3-11913</a>] - Apply reorganisation of download.phpbb.com to build_announcement.php</li>

</ul>

<h4>Bug</h4>

<ul>

<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11753">PHPBB3-11753</a>] - Upgrade mysql_upgrader.php schema data.</li>

</ul>

<h4>Bug</h4>

<ul>

<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10909">PHPBB3-10909</a>] - Update Travis Test Configuration: Travis no longer supports PHP 5.3.2</li>

</ul>

<h4>Bug</h4>

<ul>

<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10480">PHPBB3-10480</a>] - Automate changelog building</li>

</ul>

<h4> Bug

</h4>

</ul>

<h4> Security

</h4>

<ul>

</ul>

<ul>

<li>[Sec] Do not expose forum content of forums with ACL entries but no actual permission in ATOM Feeds. (Bug #58595)</li>

</ul>

<ul>

<li>[Fix] Allow ban reason and length to be selected and copied in ACP and subsilver2 MCP. (Bug #51095)</li>

</ul>

<ul>

<li>[Fix] Allow whitespaces in avatar gallery names. (Bug #44955)</li>

<li>[Feature] Send anonymous statistical information to phpBB on installation and update (optional).</li>

</ul>

<ul>

<li>[Fix] Delete user entry from ban list table upon user deletion (Bug #40015 - Patch by TerraFrost)</li>

<li>[Sec] Only use forum id supplied for posting if global announcement detected. (Reported by nickvergessen)</li>

</ul>

<ul>

<li>[Fix] Allow mixed-case template directories to be inherited (Bug #36725)</li>

<li>[Sec] Ask for forum password if post within passworded forum quoted in private message. (Reported by nickvergessen)</li>

</ul>

<ul>

<li>[Fix] Correctly set topic starter if first post in topic removed (Bug #30575 - Patch by blueray2048)</li>

<li>[Sec Precaution] Stricter validation of the HTTP_HOST header (Thanks to Techie-Micheal et al for pointing out possible issues in derived code)</li>

</ul>

<ul>

<li>[Fix] Ability to set permissions on non-mysql dbms (Bug #24955)</li>

<li>[Sec] Only allow urls gone through redirect() being used within login_box(). (thanks nookieman)</li>

</ul>

<ul>

<li>[Change] Validate birthdays (Bug #15004)</li>

<li>[Fix] Find and display colliding usernames correctly when converting from one database to another (Bug #23925)</li>

</ul>

<ul>

<li>[Fix] Cleaned usernames contain only single spaces, so &quot;a_name&quot; and &quot;a__name&quot; are treated as the same name (Bug #15634)</li>

<li>[Fix] Call garbage_collection() within database updater to correctly close connections (affects Oracle for example)</li>

</ul>

<ul>

<li>[Fix] Fixed MSSQL related bug in the update system</li>

<li>[Fix] No duplication of active topics (Bug #15474)</li>

</ul>

<ul>

<li>[Fix] Submitting language changes using acp_language (Bug #14736)</li>

<li>[Fix] Able to request new password (Bug #14743)</li>

</ul>

<ul>

<li>[Feature] Removing constant PHPBB_EMBEDDED in favor of using an exit_handler(); the constant was meant to achive this more or less.</li>

<li>[Sec] New password hashing mechanism for storing passwords (#i42)</li>

</ul>

<ul>

<li>[Fix] MySQL, PostgreSQL and SQLite related database fixes (Bug #13862)</li>

<li>[Fix] odbc_autocommit causing existing result sets to be dropped (Bug #14182)</li>

</ul>

<ul>

<li>[Fix] Fixing some subsilver2 and prosilver style issues</li>

</ul>

<ul>

<li>[Fix] Re-allow searching within the memberlist</li>

</ul>

<ul>

<li>[Fix] (X)HTML issues within the templates (Bug #11255, #11255)</li>

* Since: 3.1.0-a2

* Purpose: Add field (e.g. textbox) to the posting screen before the subject

simple_footer_after

===

* Locations:

===

* Locations:

+ styles/prosilver/template/ucp_pm_viewmessage_print.html

* Since: 3.1.0-a1

* Purpose: Add asset calls directly before the `</head>` tag of the Print PM screen

* Purpose: Add options to the bottom of the drop-down lists block of the Edit

Display Options screen

viewtopic_print_head_append

===

* Locations:

+ styles/prosilver/template/viewtopic_print.html

* Since: 3.1.0-a1

* Purpose: Add asset calls directly before the `</head>` tag of the Print Topic screen

'field_show_on_reg' => 0,

'field_show_on_pm' => 0,

'field_show_on_vt' => 0,

'lang_name' => utf8_normalize_nfc(request_var('field_ident', '', true)),

'lang_explain' => '',

'lang_default_value'=> '')

// $exclude contains the data we gather in each step

$exclude = array(

2 => array('field_length', 'field_maxlen', 'field_minlen', 'field_validation', 'field_novalue', 'field_default_value'),

3 => array('l_lang_name', 'l_lang_explain', 'l_lang_default_value', 'l_lang_options')

);

'field_show_on_reg',

'field_show_on_pm',

'field_show_on_vt',

'field_show_profile',

'field_hide',

);

'S_SHOW_ON_REG' => ($cp->vars['field_show_on_reg']) ? true : false,

'S_SHOW_ON_PM' => ($cp->vars['field_show_on_pm']) ? true : false,

'S_SHOW_ON_VT' => ($cp->vars['field_show_on_vt']) ? true : false,

'S_FIELD_HIDE' => ($cp->vars['field_hide']) ? true : false,

'S_SHOW_PROFILE' => ($cp->vars['field_show_profile']) ? true : false,

'S_FIELD_NO_VIEW' => ($cp->vars['field_no_view']) ? true : false,

'field_show_on_reg' => $cp->vars['field_show_on_reg'],

'field_show_on_pm' => $cp->vars['field_show_on_pm'],

'field_show_on_vt' => $cp->vars['field_show_on_vt'],

'field_hide' => $cp->vars['field_hide'],

'field_show_profile' => $cp->vars['field_show_profile'],

'field_no_view' => $cp->vars['field_no_view']

'yim' => request_var('yim', $user_row['user_yim']),

'jabber' => utf8_normalize_nfc(request_var('jabber', $user_row['user_jabber'], true)),

'website' => request_var('website', $user_row['user_website']),

'bday_day' => 0,

'bday_month' => 0,

'bday_year' => 0,

'website' => array(

array('string', true, 12, 255),

array('match', true, '#^http[s]?://(.*?\.)*?[a-z0-9\-]+\.[a-z]{2,4}#i')),

'bday_day' => array('num', true, 1, 31),

'bday_month' => array('num', true, 1, 12),

'bday_year' => array('num', true, 1901, gmdate('Y', time())),

'user_yim' => $data['yim'],

'user_jabber' => $data['jabber'],

'user_website' => $data['website'],

'user_birthday' => $data['user_birthday'],

);

'MSN' => $data['msn'],

'JABBER' => $data['jabber'],

'WEBSITE' => $data['website'],

'S_BIRTHDAY_DAY_OPTIONS' => $s_birthday_day_options,

'S_BIRTHDAY_MONTH_OPTIONS' => $s_birthday_month_options,

*/

// phpBB Version

// QA-related

// define('PHPBB_QA', 1);

define('ZEBRA_TABLE', $table_prefix . 'zebra');

// Additional tables

'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),

$schema_data['phpbb_profile_fields_data'] = array(

'COLUMNS' => array(

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

),

'PRIMARY_KEY' => 'user_id',

);

'user_sig' => array('MTEXT_UNI', ''),

'user_sig_bbcode_uid' => array('VCHAR:8', ''),

'user_sig_bbcode_bitfield' => array('VCHAR:255', ''),

'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_actkey' => array('VCHAR:32', ''),

'user_newpasswd' => array('VCHAR_UNI:40', ''),

'user_form_salt' => array('VCHAR_UNI:32', ''),

function generate_smilies($mode, $forum_id)

{

global $db, $user, $config, $template, $phpbb_dispatcher;

$start = request_var('start', 0);

if ($mode == 'window')

'body' => 'posting_smilies.html')

);

}

$display_link = false;

{

$template->assign_vars(array(

'S_SHOW_SMILEY_LINK' => true,

}

if ($mode == 'window')

'user_lastpage' => '',

'user_posts' => 0,

'user_colour' => '',

'user_avatar' => '',

'user_avatar_type' => '',

'user_avatar_width' => 0,

'POSTS_DAY' => $user->lang('POST_DAY', $posts_per_day),

'POSTS_PCT' => $user->lang('POST_PCT', $percentage),

// 'S_GROUP_OPTIONS' => $group_options,

'U_SEARCH_USER' => ($auth->acl_get('u_search')) ? append_sid("{$phpbb_root_path}search.$phpEx", 'author_id=' . $user->data['user_id'] . '&amp;sr=posts') : '',

'AUTHOR_AVATAR' => (isset($user_info['avatar'])) ? $user_info['avatar'] : '',

'AUTHOR_JOINED' => $user->format_date($user_info['user_regdate']),

'AUTHOR_POSTS' => (int) $user_info['user_posts'],

'ONLINE_IMG' => (!$config['load_onlinetrack']) ? '' : ((isset($user_info['online']) && $user_info['online']) ? $user->img('icon_user_online', $user->lang['ONLINE']) : $user->img('icon_user_offline', $user->lang['OFFLINE'])),

'S_ONLINE' => (!$config['load_onlinetrack']) ? false : ((isset($user_info['online']) && $user_info['online']) ? true : false),

'yim' => request_var('yim', $user->data['user_yim']),

'jabber' => utf8_normalize_nfc(request_var('jabber', $user->data['user_jabber'], true)),

'website' => request_var('website', $user->data['user_website']),

);

if ($config['allow_birthdays'])

'website' => array(

array('string', true, 12, 255),

array('match', true, '#^http[s]?://(.*?\.)*?[a-z0-9\-]+\.[a-z]{2,4}#i')),

);

if ($config['allow_birthdays'])

'user_yim' => $data['yim'],

'user_jabber' => $data['jabber'],

'user_website' => $data['website'],

'user_notify_type' => $data['notify'],

);

'MSN' => $data['msn'],

'JABBER' => $data['jabber'],

'WEBSITE' => $data['website'],

));

// Get additional profile fields and assign them to the template block var 'profile_fields'

$convertor_data = array(

'forum_name' => 'phpBB 2.0.x',

'version' => '1.0.3',

'author' => '<a href="https://www.phpbb.com/">phpBB Group</a>',

'dbms' => $dbms,

'dbhost' => $dbhost,

array('user_inactive_reason', '', 'phpbb_inactive_reason'),

array('user_inactive_time', '', 'phpbb_inactive_time'),

array('user_website', 'users.user_website', 'validate_website'),

array('user_jabber', '', ''),

array('user_msnm', 'users.user_msnm', array('function1' => 'phpbb_set_encoding')),

array('user_yim', 'users.user_yim', array('function1' => 'phpbb_set_encoding')),

array('user_aim', 'users.user_aim', array('function1' => 'phpbb_set_encoding')),

array('user_icq', 'users.user_icq', array('function1' => 'phpbb_set_encoding')),

array('user_rank', 'users.user_rank', 'intval'),

array('user_permissions', '', ''),

'where' => 'users.user_id <> -1',

),

),

);

}

$this->error('Unable to access the language directory', __LINE__, __FILE__);

}

while (($file = readdir($dir)) !== false)

{

$path = $phpbb_root_path . 'language/' . $file;

$db->sql_query('INSERT INTO ' . LANG_TABLE . ' ' . $db->sql_build_array('INSERT', $lang_pack));

if ($db->sql_error_triggered)

{

$error = $db->sql_error($db->sql_error_sql);

}

}

closedir($dir);

}

/**

field_show_on_reg INTEGER DEFAULT 0 NOT NULL,

field_show_on_pm INTEGER DEFAULT 0 NOT NULL,

field_show_on_vt INTEGER DEFAULT 0 NOT NULL,

field_show_profile INTEGER DEFAULT 0 NOT NULL,

field_hide INTEGER DEFAULT 0 NOT NULL,

field_no_view INTEGER DEFAULT 0 NOT NULL,

# Table: 'phpbb_profile_fields_data'

CREATE TABLE phpbb_profile_fields_data (

);;

ALTER TABLE phpbb_profile_fields_data ADD PRIMARY KEY (user_id);;

user_sig BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL,

user_sig_bbcode_uid VARCHAR(8) CHARACTER SET NONE DEFAULT '' NOT NULL,

user_sig_bbcode_bitfield VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL,

user_icq VARCHAR(15) CHARACTER SET NONE DEFAULT '' NOT NULL,

user_aim VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,

user_yim VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,

user_msnm VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,

user_jabber VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,

user_website VARCHAR(200) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,

user_actkey VARCHAR(32) CHARACTER SET NONE DEFAULT '' NOT NULL,

user_newpasswd VARCHAR(40) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,

user_form_salt VARCHAR(32) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,

[field_show_on_reg] [int] DEFAULT (0) NOT NULL ,

[field_show_on_pm] [int] DEFAULT (0) NOT NULL ,

[field_show_on_vt] [int] DEFAULT (0) NOT NULL ,

[field_show_profile] [int] DEFAULT (0) NOT NULL ,

[field_hide] [int] DEFAULT (0) NOT NULL ,

[field_no_view] [int] DEFAULT (0) NOT NULL ,

Table: 'phpbb_profile_fields_data'

*/

CREATE TABLE [phpbb_profile_fields_data] (

) ON [PRIMARY]

GO

[user_sig] [text] DEFAULT ('') NOT NULL ,

[user_sig_bbcode_uid] [varchar] (8) DEFAULT ('') NOT NULL ,

[user_sig_bbcode_bitfield] [varchar] (255) DEFAULT ('') NOT NULL ,

[user_icq] [varchar] (15) DEFAULT ('') NOT NULL ,

[user_aim] [varchar] (255) DEFAULT ('') NOT NULL ,

[user_yim] [varchar] (255) DEFAULT ('') NOT NULL ,

[user_msnm] [varchar] (255) DEFAULT ('') NOT NULL ,

[user_jabber] [varchar] (255) DEFAULT ('') NOT NULL ,

[user_website] [varchar] (200) DEFAULT ('') NOT NULL ,

[user_actkey] [varchar] (32) DEFAULT ('') NOT NULL ,

[user_newpasswd] [varchar] (40) DEFAULT ('') NOT NULL ,

[user_form_salt] [varchar] (32) DEFAULT ('') NOT NULL ,

field_show_on_reg tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

field_show_on_pm tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

field_show_on_vt tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

field_show_profile tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

field_hide tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

field_no_view tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

# Table: 'phpbb_profile_fields_data'

CREATE TABLE phpbb_profile_fields_data (

user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

PRIMARY KEY (user_id)

);

user_sig mediumblob NOT NULL,

user_sig_bbcode_uid varbinary(8) DEFAULT '' NOT NULL,

user_sig_bbcode_bitfield varbinary(255) DEFAULT '' NOT NULL,

user_icq varbinary(15) DEFAULT '' NOT NULL,

user_aim blob NOT NULL,

user_yim blob NOT NULL,

user_msnm blob NOT NULL,

user_jabber blob NOT NULL,

user_website blob NOT NULL,

user_actkey varbinary(32) DEFAULT '' NOT NULL,

user_newpasswd varbinary(120) DEFAULT '' NOT NULL,

user_form_salt varbinary(96) DEFAULT '' NOT NULL,

field_show_on_reg tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

field_show_on_pm tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

field_show_on_vt tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

field_show_profile tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

field_hide tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

field_no_view tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

# Table: 'phpbb_profile_fields_data'

CREATE TABLE phpbb_profile_fields_data (

user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

PRIMARY KEY (user_id)

) CHARACTER SET `utf8` COLLATE `utf8_bin`;

user_sig mediumtext NOT NULL,

user_sig_bbcode_uid varchar(8) DEFAULT '' NOT NULL,

user_sig_bbcode_bitfield varchar(255) DEFAULT '' NOT NULL,

user_icq varchar(15) DEFAULT '' NOT NULL,

user_aim varchar(255) DEFAULT '' NOT NULL,

user_yim varchar(255) DEFAULT '' NOT NULL,

user_msnm varchar(255) DEFAULT '' NOT NULL,

user_jabber varchar(255) DEFAULT '' NOT NULL,

user_website varchar(200) DEFAULT '' NOT NULL,

user_actkey varchar(32) DEFAULT '' NOT NULL,

user_newpasswd varchar(40) DEFAULT '' NOT NULL,

user_form_salt varchar(32) DEFAULT '' NOT NULL,

field_show_on_reg number(1) DEFAULT '0' NOT NULL,

field_show_on_pm number(1) DEFAULT '0' NOT NULL,

field_show_on_vt number(1) DEFAULT '0' NOT NULL,

field_show_profile number(1) DEFAULT '0' NOT NULL,

field_hide number(1) DEFAULT '0' NOT NULL,

field_no_view number(1) DEFAULT '0' NOT NULL,

*/

CREATE TABLE phpbb_profile_fields_data (

user_id number(8) DEFAULT '0' NOT NULL,

CONSTRAINT pk_phpbb_profile_fields_data PRIMARY KEY (user_id)

)

/

user_sig clob DEFAULT '' ,

user_sig_bbcode_uid varchar2(8) DEFAULT '' ,

user_sig_bbcode_bitfield varchar2(255) DEFAULT '' ,

user_icq varchar2(15) DEFAULT '' ,

user_aim varchar2(765) DEFAULT '' ,

user_yim varchar2(765) DEFAULT '' ,

user_msnm varchar2(765) DEFAULT '' ,

user_jabber varchar2(765) DEFAULT '' ,

user_website varchar2(600) DEFAULT '' ,

user_actkey varchar2(32) DEFAULT '' ,

user_newpasswd varchar2(120) DEFAULT '' ,

user_form_salt varchar2(96) DEFAULT '' ,

field_show_on_reg INT2 DEFAULT '0' NOT NULL CHECK (field_show_on_reg >= 0),

field_show_on_pm INT2 DEFAULT '0' NOT NULL CHECK (field_show_on_pm >= 0),

field_show_on_vt INT2 DEFAULT '0' NOT NULL CHECK (field_show_on_vt >= 0),

field_show_profile INT2 DEFAULT '0' NOT NULL CHECK (field_show_profile >= 0),

field_hide INT2 DEFAULT '0' NOT NULL CHECK (field_hide >= 0),

field_no_view INT2 DEFAULT '0' NOT NULL CHECK (field_no_view >= 0),

*/

CREATE TABLE phpbb_profile_fields_data (

user_id INT4 DEFAULT '0' NOT NULL CHECK (user_id >= 0),

PRIMARY KEY (user_id)

);

user_sig TEXT DEFAULT '' NOT NULL,

user_sig_bbcode_uid varchar(8) DEFAULT '' NOT NULL,

user_sig_bbcode_bitfield varchar(255) DEFAULT '' NOT NULL,

user_icq varchar(15) DEFAULT '' NOT NULL,

user_aim varchar(255) DEFAULT '' NOT NULL,

user_yim varchar(255) DEFAULT '' NOT NULL,

user_msnm varchar(255) DEFAULT '' NOT NULL,

user_jabber varchar(255) DEFAULT '' NOT NULL,

user_website varchar(200) DEFAULT '' NOT NULL,

user_actkey varchar(32) DEFAULT '' NOT NULL,

user_newpasswd varchar(40) DEFAULT '' NOT NULL,

user_form_salt varchar(32) DEFAULT '' NOT NULL,

INSERT INTO phpbb_config (config_name, config_value) VALUES ('upload_icons_path', 'images/upload_icons');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('upload_path', 'files');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('use_system_cron', '0');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('warnings_expire_days', '90');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('warnings_gc', '14400');

INSERT INTO phpbb_forums (forum_name, forum_desc, left_id, right_id, parent_id, forum_type, forum_posts_approved, forum_posts_unapproved, forum_posts_softdeleted, forum_topics_approved, forum_topics_unapproved, forum_topics_softdeleted, forum_last_post_id, forum_last_poster_id, forum_last_poster_name, forum_last_poster_colour, forum_last_post_subject, forum_last_post_time, forum_link, forum_password, forum_image, forum_rules, forum_rules_link, forum_rules_uid, forum_desc_uid, prune_days, prune_viewed, forum_parents, forum_flags) VALUES ('{L_FORUMS_TEST_FORUM_TITLE}', '{L_FORUMS_TEST_FORUM_DESC}', 2, 3, 1, 1, 1, 0, 0, 1, 0, 0, 1, 2, 'Admin', 'AA0000', '{L_TOPICS_TOPIC_TITLE}', 972086460, '', '', '', '', '', '', '', 0, 0, '', 48);

# -- Users / Anonymous user

# -- username: Admin password: admin (change this or remove it once everything is working!)

# -- Groups

INSERT INTO phpbb_groups (group_name, group_type, group_founder_manage, group_colour, group_legend, group_avatar, group_desc, group_desc_uid, group_max_recipients) VALUES ('GUESTS', 3, 0, '', 0, '', '', '', 5);

INSERT INTO phpbb_extensions (group_id, extension) VALUES (9, 'ogg');

INSERT INTO phpbb_extensions (group_id, extension) VALUES (9, 'ogm');

# User Notification Options (for first user)

INSERT INTO phpbb_user_notifications (item_type, item_id, user_id, method) VALUES('post', 0, 2, '');

INSERT INTO phpbb_user_notifications (item_type, item_id, user_id, method) VALUES('post', 0, 2, 'email');

field_show_on_reg INTEGER UNSIGNED NOT NULL DEFAULT '0',

field_show_on_pm INTEGER UNSIGNED NOT NULL DEFAULT '0',

field_show_on_vt INTEGER UNSIGNED NOT NULL DEFAULT '0',

field_show_profile INTEGER UNSIGNED NOT NULL DEFAULT '0',

field_hide INTEGER UNSIGNED NOT NULL DEFAULT '0',

field_no_view INTEGER UNSIGNED NOT NULL DEFAULT '0',

# Table: 'phpbb_profile_fields_data'

CREATE TABLE phpbb_profile_fields_data (

user_id INTEGER UNSIGNED NOT NULL DEFAULT '0',

PRIMARY KEY (user_id)

);

user_sig mediumtext(16777215) NOT NULL DEFAULT '',

user_sig_bbcode_uid varchar(8) NOT NULL DEFAULT '',

user_sig_bbcode_bitfield varchar(255) NOT NULL DEFAULT '',

user_icq varchar(15) NOT NULL DEFAULT '',

user_aim varchar(255) NOT NULL DEFAULT '',

user_yim varchar(255) NOT NULL DEFAULT '',

user_msnm varchar(255) NOT NULL DEFAULT '',

user_jabber varchar(255) NOT NULL DEFAULT '',

user_website varchar(200) NOT NULL DEFAULT '',

user_actkey varchar(32) NOT NULL DEFAULT '',

user_newpasswd varchar(40) NOT NULL DEFAULT '',

user_form_salt varchar(32) NOT NULL DEFAULT '',

'DISPLAY_AT_PROFILE_EXPLAIN' => 'The user is able to change this profile field within the user control panel.',

'DISPLAY_AT_REGISTER' => 'Display on registration screen',

'DISPLAY_AT_REGISTER_EXPLAIN' => 'If this option is enabled, the field will be displayed on registration.',

'DISPLAY_ON_PM' => 'Display on view pm screen',

'DISPLAY_ON_PM_EXPLAIN' => 'If this option is enabled, the field will be displayed in the mini-profile on the pm screen.',

'DISPLAY_ON_VT' => 'Display on viewtopic screen',

'TOO_LONG_CONFIRM_CODE' => 'The confirm code you entered is too long.',

'TOO_LONG_DATEFORMAT' => 'The date format you entered is too long.',

'TOO_LONG_ICQ' => 'The ICQ number you entered is too long.',

'TOO_LONG_JABBER' => 'The Jabber account name you entered is too long.',

'TOO_LONG_MSN' => 'The WLM name you entered is too long.',

'TOO_LONG_NEW_PASSWORD' => 'The password you entered is too long.',

'TOO_LONG_PASSWORD_CONFIRM' => 'The password confirmation you entered is too long.',

'TOO_LONG_USER_PASSWORD' => 'The password you entered is too long.',

'TOO_LONG_USERNAME' => 'The username you entered is too long.',

'TOO_SHORT_CONFIRM_CODE' => 'The confirm code you entered is too short.',

'TOO_SHORT_DATEFORMAT' => 'The date format you entered is too short.',

'TOO_SHORT_ICQ' => 'The ICQ number you entered is too short.',

'TOO_SHORT_JABBER' => 'The Jabber account name you entered is too short.',

'TOO_SHORT_MSN' => 'The WLM name you entered is too short.',

'TOO_SHORT_NEW_PASSWORD' => 'The password you entered is too short.',

'TOO_SHORT_PASSWORD_CONFIRM' => 'The password confirmation you entered is too short.',

'TOO_SHORT_USER_PASSWORD' => 'The password you entered is too short.',

'TOO_SHORT_USERNAME' => 'The username you entered is too short.',

'PLUPLOAD_ERR_INPUT' => 'Failed to open input stream.',

'PLUPLOAD_ERR_MOVE_UPLOADED' => 'Failed to move uploaded file.',

'PLUPLOAD_ERR_OUTPUT' => 'Failed to open output stream.',

'PLUPLOAD_ERR_FILE_COUNT' => 'File count error.',

'PLUPLOAD_ERR_RUNTIME_MEMORY' => 'Runtime ran out of available memory.',

'PLUPLOAD_ERR_UPLOAD_URL' => 'Upload URL might be wrong or does not exist.',

'PLUPLOAD_EXTENSION_ERROR' => 'File extension error.',

'POSTS_DAY' => $user->lang('POST_DAY', $posts_per_day),

'POSTS_PCT' => $user->lang('POST_PCT', $percentage),

'SIGNATURE' => $member['user_sig'],

'POSTS_IN_QUEUE'=> $member['posts_in_queue'],

$pagination = $phpbb_container->get('pagination');

// Sorting

if ($auth->acl_get('a_user'))

{

$user_list[] = (int) $row['user_id'];

}

$db->sql_freeresult($result);

$leaders_set = false;

// So, did we get any users?

if (sizeof($user_list))

// Load custom profile fields

if ($config['load_cpf_memberlist'])

{

// Grab all profile fields from users in id cache for later use - similar to the poster cache

$profile_fields_cache = $cp->generate_profile_fields_template('grab', $user_list);

}

// If we sort by last active date we need to adjust the id cache due to user_lastvisit not being the last active date...

'U_FIND_MEMBER' => ($config['load_search'] || $auth->acl_get('a_')) ? append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=searchuser' . (($start) ? "&amp;start=$start" : '') . (!empty($params) ? '&amp;' . implode('&amp;', $params) : '')) : '',

'U_HIDE_FIND_MEMBER' => ($mode == 'searchuser' || ($mode == '' && $submit)) ? $u_hide_find_member : '',

'U_SORT_USERNAME' => $sort_url . '&amp;sk=a&amp;sd=' . (($sort_key == 'a' && $sort_dir == 'a') ? 'd' : 'a'),

'U_SORT_JOINED' => $sort_url . '&amp;sk=c&amp;sd=' . (($sort_key == 'c' && $sort_dir == 'a') ? 'd' : 'a'),

'U_SORT_POSTS' => $sort_url . '&amp;sk=d&amp;sd=' . (($sort_key == 'd' && $sort_dir == 'a') ? 'd' : 'a'),

'U_SORT_EMAIL' => $sort_url . '&amp;sk=e&amp;sd=' . (($sort_key == 'e' && $sort_dir == 'a') ? 'd' : 'a'),

'U_SORT_WEBSITE' => $sort_url . '&amp;sk=f&amp;sd=' . (($sort_key == 'f' && $sort_dir == 'a') ? 'd' : 'a'),

'U_SORT_ICQ' => $sort_url . '&amp;sk=g&amp;sd=' . (($sort_key == 'g' && $sort_dir == 'a') ? 'd' : 'a'),

'U_SORT_AIM' => $sort_url . '&amp;sk=h&amp;sd=' . (($sort_key == 'h' && $sort_dir == 'a') ? 'd' : 'a'),

'U_SORT_MSN' => $sort_url . '&amp;sk=i&amp;sd=' . (($sort_key == 'i' && $sort_dir == 'a') ? 'd' : 'a'),

'U_YIM' => ($data['user_yim']) ? 'http://edit.yahoo.com/config/send_webmesg?.target=' . urlencode($data['user_yim']) . '&amp;.src=pg' : '',

'U_MSN' => ($data['user_msnm'] && $auth->acl_get('u_sendim')) ? append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=contact&amp;action=msnm&amp;u=' . $user_id) : '',

'U_JABBER' => ($data['user_jabber'] && $auth->acl_get('u_sendim')) ? append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=contact&amp;action=jabber&amp;u=' . $user_id) : '',

'USER_ICQ' => $data['user_icq'],

'USER_AIM' => $data['user_aim'],

return false;

}

}

/** @var \phpbb\db\tools */

protected $db_tools;

/** @var string */

protected $table_prefix;

/**

* Constructor of the database migrator

*/

{

$this->config = $config;

$this->db = $db;

$this->db_tools = $db_tools;

$this->migrations_table = $migrations_table;

$this->tools[$tool->get_name()] = $tool;

}

$this->load_migration_state();

}

if (!$state['migration_schema_done'])

{

}

else if (!$state['migration_data_done'])

{

$this->set_migration_state($name, $state);

}

{

}

return true;

}

/**

* Process the data step of the migration

*

* @param array $steps The steps to run

return $this->get_callable_from_step($step);

break;

case 'custom':

if (!is_callable($parameters[0]))

{

// here lies an array, filled with information compiled on the column's data

$prepared_column = $this->sql_prepare_column_data($table_name, $column_name, $column_data);

{

trigger_error("Index name '${column_name}_gen' on table '$table_name' is too long. The maximum auto increment column length is 26 characters.", E_USER_ERROR);

}

{

return $this->getMessage();

}

*/

public function get_avatar()

{

}

/**

}

/**

* Assign fields to template, used for viewprofile, viewtopic and memberlist (if load setting is enabled)

* This is directly connected to the user -> mode == grab is to grab the user specific fields, mode == show is for assigning the row to the template

*/

/**

* {@inheritDoc}

*/

public function get_language_options_input($field_data)

{

$field_data['l_lang_name'] = $this->request->variable('l_lang_name', array(0 => ''), true);

if (!$field_value && $field_data['field_required'])

{

}

return false;

if ((!$day || !$month || !$year) && $field_data['field_required'])

{

}

if ($day < 0 || $day > 31 || $month < 0 || $month > 12 || ($year < 1901 && $year > 0) || $year > gmdate('Y', time()) + 50)

{

}

if (checkdate($month, $day, $year) === false)

{

}

return false;

if (!$this->lang_helper->is_set($field_data['field_id'], $field_data['lang_id'], $field_value))

{

}

if ($field_value == $field_data['field_novalue'] && $field_data['field_required'])

{

}

return false;

if ($field_value < $field_data['field_minlen'])

{

}

else if ($field_value > $field_data['field_maxlen'])

{

}

return false;

public function get_service_name();

/**

* Get dropdown options for second step in ACP

*

* @param string $default_lang_id ID of the default language

* @return null

*/

public function display_options(&$template_vars, &$field_data);

}

$options = array(

0 => array('TITLE' => $this->user->lang['FIELD_LENGTH'], 'FIELD' => '<input type="number" min="0" name="field_length" size="5" value="' . $field_data['field_length'] . '" />'),

1 => array('TITLE' => $this->user->lang['MIN_FIELD_CHARS'], 'FIELD' => '<input type="number" min="0" name="field_minlen" size="5" value="' . $field_data['field_minlen'] . '" />'),

3 => array('TITLE' => $this->user->lang['FIELD_VALIDATION'], 'FIELD' => '<select name="field_validation">' . $this->validate_options($field_data) . '</select>'),

);

}

else if (trim($field_value) === '' && $field_data['field_required'])

{

}

if ($field_data['field_minlen'] && utf8_strlen($field_value) < $field_data['field_minlen'])

{

}

else if ($field_data['field_maxlen'] && utf8_strlen($field_value) > $field_data['field_maxlen'])

{

}

if (!empty($field_data['field_validation']) && $field_data['field_validation'] != '.*')

switch ($row['field_validation'])

{

case '[0-9]+':

case '[\w]+':

case '[\w_\+\. \-\[\]]+':

}

}

}

$this->error();

}

}

unset($lang_set_ext);

$style_request = request_var('style', 0);

{

global $SID, $_EXTRA_URL;

# General Information about this style

name = prosilver

copyright = &copy; phpBB Group, 2007

# Defining a different template bitfield

# template_bitfield = lNg=

<tr>

<th class="name" data-dfn="{L_RANK}{L_COMMA_SEPARATOR}<!-- IF S_SHOW_GROUP and .memberrow -->{L_GROUP_LEADER}<!-- ELSE -->{L_USERNAME}<!-- ENDIF -->"><span class="rank-img"><a href="{U_SORT_RANK}">{L_RANK}</a></span><a href="{U_SORT_USERNAME}"><!-- IF S_SHOW_GROUP and .memberrow -->{L_GROUP_LEADER}<!-- ELSE -->{L_USERNAME}<!-- ENDIF --></a></th>

<th class="posts"><a href="{U_SORT_POSTS}#memberlist">{L_POSTS}</a></th>

<th class="joined"><a href="{U_SORT_JOINED}#memberlist">{L_JOINED}</a></th>

<!-- IF U_SORT_ACTIVE --><th class="active"><a href="{U_SORT_ACTIVE}#memberlist">{L_LAST_ACTIVE}</a></th><!-- ENDIF -->

</tr>

<!-- IF not S_LEADERS_SET -->

<th class="name" data-dfn="{L_RANK}{L_COMMA_SEPARATOR}{L_USERNAME}"><span class="rank-img"><a href="{U_SORT_RANK}">{L_RANK}</a></span><a href="{U_SORT_USERNAME}"><!-- IF S_SHOW_GROUP -->{L_GROUP_MEMBERS}<!-- ELSE -->{L_USERNAME}<!-- ENDIF --></a></th>

<th class="posts"><a href="{U_SORT_POSTS}#memberlist">{L_POSTS}</a></th>

<th class="joined"><a href="{U_SORT_JOINED}#memberlist">{L_JOINED}</a></th>

<!-- IF U_SORT_ACTIVE --><th class="active"><a href="{U_SORT_ACTIVE}#memberlist">{L_LAST_ACTIVE}</a></th><!-- ENDIF -->

<!-- ELSEIF S_SHOW_GROUP -->

<tr class="<!-- IF memberrow.S_ROW_COUNT is even -->bg1<!-- ELSE -->bg2<!-- ENDIF -->">

<td><!-- IF memberrow.RANK_IMG --><span class="rank-img">{memberrow.RANK_IMG}</span><!-- ELSE --><span class="rank-img">{memberrow.RANK_TITLE}</span><!-- ENDIF --><!-- IF S_IN_SEARCH_POPUP and not S_SELECT_SINGLE --><input type="checkbox" name="user" value="{memberrow.USERNAME}" /> <!-- ENDIF --><!-- EVENT memberlist_body_username_prepend -->{memberrow.USERNAME_FULL}<!-- EVENT memberlist_body_username_append --><!-- IF S_IN_SEARCH_POPUP --><br />[&nbsp;<a href="#" onclick="insert_single_user('#results', '{memberrow.A_USERNAME}'); return false;">{L_SELECT}</a>&nbsp;]<!-- ENDIF --></td>

<td class="posts"><!-- IF memberrow.POSTS and S_DISPLAY_SEARCH --><a href="{memberrow.U_SEARCH_USER}" title="{L_SEARCH_USER_POSTS}">{memberrow.POSTS}</a><!-- ELSE -->{memberrow.POSTS}<!-- ENDIF --></td>

<td>{memberrow.JOINED}</td>

<!-- IF S_VIEWONLINE --><td>{memberrow.VISITED}&nbsp;</td><!-- ENDIF -->

</tr>

<!-- IF RANK_IMG --><dt><!-- IF RANK_TITLE -->&nbsp;<!-- ELSE -->{L_RANK}{L_COLON}<!-- ENDIF --></dt> <dd>{RANK_IMG}</dd><!-- ENDIF -->

<!-- ENDIF -->

<!-- IF S_USER_INACTIVE --><dt>{L_USER_IS_INACTIVE}{L_COLON}</dt> <dd>{USER_INACTIVE_REASON}</dd><!-- ENDIF -->

<!-- IF AGE !== '' --><dt>{L_AGE}{L_COLON}</dt> <dd>{AGE}</dd><!-- ENDIF -->

<!-- IF S_GROUP_OPTIONS --><dt>{L_USERGROUPS}{L_COLON}</dt> <dd><select name="g">{S_GROUP_OPTIONS}</select> <input type="submit" name="submit" value="{L_GO}" class="button2" /></dd><!-- ENDIF -->

<!-- BEGIN custom_fields --><dt>{custom_fields.PROFILE_FIELD_NAME}{L_COLON}</dt> <dd>{custom_fields.PROFILE_FIELD_VALUE}</dd><!-- END custom_fields -->

<!-- IF S_USER_LOGGED_IN and S_ZEBRA -->

'Close': '{LA_PLUPLOAD_CLOSE}',

'Drag files here.': '{LA_PLUPLOAD_DRAG}',

'Duplicate file error.': '{LA_PLUPLOAD_DUPLICATE_ERROR}',

'File: %s': '{LA_PLUPLOAD_FILE}',

'File: %s, size: %d, max file size: %d': '{LA_PLUPLOAD_FILE_DETAILS}',

'File count error.': '{LA_PLUPLOAD_ERR_FILE_COUNT}',

'File extension error.': '{LA_PLUPLOAD_EXTENSION_ERROR}',

'File size error.': '{LA_PLUPLOAD_SIZE_ERROR}',

'Filename': '{LA_PLUPLOAD_FILENAME}',

'Generic error.': '{LA_PLUPLOAD_GENERIC_ERROR}',

'HTTP Error.': '{LA_PLUPLOAD_HTTP_ERROR}',

'Image format either wrong or not supported.': '{LA_PLUPLOAD_IMAGE_FORMAT}',

'Init error.': '{LA_PLUPLOAD_INIT_ERROR}',

'IO error.': '{LA_PLUPLOAD_IO_ERROR}',

'N/A': '{LA_PLUPLOAD_NOT_APPLICABLE}',

'Runtime ran out of available memory.': '{LA_PLUPLOAD_ERR_RUNTIME_MEMORY}',

'Security error.': '{LA_PLUPLOAD_SECURITY_ERROR}',

<dt><label for="subject">{L_SUBJECT}{L_COLON}</label></dt>

<dd><input type="text" name="subject" id="subject" size="45" maxlength="124" tabindex="2" value="{SUBJECT}" class="inputbox autowidth" /></dd>

</dl>

<div id="message-box">

<textarea style="height: 9em;" name="message" rows="7" cols="76" tabindex="3" class="inputbox"></textarea>

</div>

</fieldset>

<fieldset class="submit-buttons">

{S_FORM_TOKEN}

<dd><strong>{L_POSTS}{L_COLON}</strong> {AUTHOR_POSTS}</dd>

<!-- IF AUTHOR_JOINED --><dd><strong>{L_JOINED}{L_COLON}</strong> {AUTHOR_JOINED}</dd><!-- ENDIF -->

<!-- EVENT ucp_pm_viewmessage_custom_fields_before -->

<!-- BEGIN custom_fields -->

<dt><label for="website">{L_WEBSITE}{L_COLON}</label></dt>

<dd><input type="url" name="website" id="website" maxlength="255" value="{WEBSITE}" class="inputbox" /></dd>

</dl>

<!-- IF S_BIRTHDAYS_ENABLED -->

<dl>

<dt><label for="bday_day">{L_BIRTHDAY}{L_COLON}</label><br /><span>{L_BIRTHDAY_EXPLAIN}</span></dt>

<fieldset class="fields2">

<!-- IF ERROR --><p class="error">{ERROR}</p><!-- ENDIF -->

<dl>

<dt><label <!-- IF S_USERNAME_OPTIONS -->for="usernames"<!-- ENDIF -->>{L_YOUR_FRIENDS}{L_COLON}</label><br /><span>{L_YOUR_FRIENDS_EXPLAIN}</span></dt>

<dd>

<!-- ENDIF -->

</dd>

</dl>

<dl>

<dt><label for="add">{L_ADD_FRIENDS}{L_COLON}</label><br /><span>{L_ADD_FRIENDS_EXPLAIN}</span></dt>

<dd><textarea name="add" id="add" rows="3" cols="30" class="inputbox">{USERNAMES}</textarea></dd>

<!-- IF postrow.POSTER_POSTS != '' --><dd><strong>{L_POSTS}{L_COLON}</strong> {postrow.POSTER_POSTS}</dd><!-- ENDIF -->

<!-- IF postrow.POSTER_JOINED --><dd><strong>{L_JOINED}{L_COLON}</strong> {postrow.POSTER_JOINED}</dd><!-- ENDIF -->

<!-- IF postrow.S_PROFILE_FIELD1 -->

<!-- Use a construct like this to include admin defined profile fields. Replace FIELD1 with the name of your field. -->

}

.clearfix, fieldset dl, ul.topiclist dl, dl.polls {

overflow: hidden;

}

/* Pagination

---------------------------------------- */

.pagination {

width: auto;

text-align: right;

margin-top: 5px;

# General Information about this style

name = subsilver2

copyright = &copy; 2005 phpBB Group

# Defining a different template bitfield

# template_bitfield = lNg=

<td class="gen" align="{S_CONTENT_FLOW_END}" nowrap="nowrap">{L_USERGROUPS}{L_COLON} </td>

<td><select name="g">{S_GROUP_OPTIONS}</select> <input class="btnlite" type="submit" name="submit" value="{L_GO}" /></td>

</tr>

<!-- IF AGE !== '' -->

<tr>

<td class="gen" align="{S_CONTENT_FLOW_END}" nowrap="nowrap">{L_AGE}{L_COLON} </td>

</tr>

<!-- ENDIF -->

<tr>

<td class="gen" align="{S_CONTENT_FLOW_END}" nowrap="nowrap">{L_WEBSITE}{L_COLON} </td>

<td><!-- IF U_WWW --><b><a class="genmed" href="{U_WWW}">{U_WWW}</a></b><!-- ENDIF --></td>

</tr>

<td class="row1" width="22%"><b class="genmed">{L_SUBJECT}{L_COLON}</b></td>

<td class="row2" width="78%"><input class="post" style="width:450px" type="text" name="subject" size="45" maxlength="124" tabindex="2" value="{SUBJECT}" /></td>

</tr>

<tr>

<td class="row1" width="22%"><b class="genmed">{L_MESSAGE}{L_COLON}</b></td>

<td class="row2" valign="top" align="left" width="78%"><textarea name="message" rows="7" cols="76" tabindex="3" style="width: 700px; height: 130px; min-width: 98%; max-width: 98%;"></textarea> </td>

</tr>

<tr>

<td class="cat" colspan="2" align="center">

<input class="btnlite" type="submit" accesskey="f" tabindex="6" name="preview" value="{L_FULL_EDITOR}" />&nbsp;

}

//-->

</style>

</head>

<body>

<td class="row1" width="35%"><b class="genmed">{L_WEBSITE}{L_COLON} </b></td>

<td class="row2"><input class="post" type="url" name="website" size="30" maxlength="255" value="{WEBSITE}" /></td>

</tr>

<!-- IF S_BIRTHDAYS_ENABLED -->

<tr>

<td class="row1" width="35%"><b class="genmed">{L_BIRTHDAY}{L_COLON} </b><br /><span class="gensmall">{L_BIRTHDAY_EXPLAIN}</span></td>

<tr>

<th colspan="2" valign="middle">{L_TITLE}</th>

</tr>

<tr>

<td class="row3" colspan="2"><span class="gensmall">{L_FRIENDS_EXPLAIN}</span></td>

</tr>

<td class="row1" width="40%"><b class="genmed">{L_YOUR_FRIENDS}{L_COLON}</b><br /><span class="gensmall">{L_YOUR_FRIENDS_EXPLAIN}</span></td>

<td class="row2" align="center"><!-- IF S_USERNAME_OPTIONS --><select name="usernames[]" multiple="multiple" size="5">{S_USERNAME_OPTIONS}</select><!-- ELSE --><b class="genmed">{L_NO_FRIENDS}</b><!-- ENDIF --></td>

</tr>

<tr>

<td class="row1"><b class="genmed">{L_ADD_FRIENDS}{L_COLON}</b><br /><span class="gensmall">{L_ADD_FRIENDS_EXPLAIN} [ <a href="{U_FIND_USERNAME}" onclick="find_username(this.href); return false;">{L_FIND_USERNAME}</a> ]</span></td>

<td class="row2" align="center"><textarea name="add" rows="5" cols="30">{USERNAMES}</textarea><br /></td>

<span class="postdetails">

<!-- IF postrow.POSTER_JOINED --><br /><b>{L_JOINED}{L_COLON}</b> {postrow.POSTER_JOINED}<!-- ENDIF -->

<!-- IF postrow.POSTER_POSTS != '' --><br /><b>{L_POSTS}{L_COLON}</b> {postrow.POSTER_POSTS}<!-- ENDIF -->

<!-- IF postrow.S_PROFILE_FIELD1 -->

<!-- Use a construct like this to include admin defined profile fields. Replace FIELD1 with the name of your field. -->

}

//-->

</style>

</head>

<body>

$user_cache_data = array(

'joined' => '',

'posts' => '',

'sig' => '',

'sig_bbcode_uid' => '',

'joined' => $user->format_date($row['user_regdate']),

'posts' => $row['user_posts'],

'warnings' => (isset($row['user_warnings'])) ? $row['user_warnings'] : 0,

'sig' => $user_sig,

'sig_bbcode_uid' => (!empty($row['user_sig_bbcode_uid'])) ? $row['user_sig_bbcode_uid'] : '',

'RANK_IMG_SRC' => $user_cache[$poster_id]['rank_image_src'],

'POSTER_JOINED' => $user_cache[$poster_id]['joined'],

'POSTER_POSTS' => $user_cache[$poster_id]['posts'],

'POSTER_AVATAR' => $user_cache[$poster_id]['avatar'],

'POSTER_WARNINGS' => $user_cache[$poster_id]['warnings'],

'POSTER_AGE' => $user_cache[$poster_id]['age'],

$request->overwrite('t', $topic_id);

}

/**

* You can use this event to modify the page title of the viewtopic page

<column>user_login_attempts</column>

<column>user_permissions</column>

<column>user_sig</column>

<row>

<value>1</value>

<value>foobar</value>

<value>0</value>

<value></value>

<value></value>

</row>

<row>

<value>2</value>

<value>0</value>

<value></value>

<value></value>

</row>

</table>

</dataset>

<column>user_login_attempts</column>

<column>user_permissions</column>

<column>user_sig</column>

<row>

<value>1</value>

<value>foobar</value>

<value>0</value>

<value></value>

<value></value>

</row>

<row>

<value>2</value>

<value>0</value>

<value></value>

<value></value>

</row>

</table>

</dataset>

'user_sig' => '',

'user_sig_bbcode_uid' => '',

'user_sig_bbcode_bitfield' => '',

'user_icq' => '',

'user_aim' => '',

'user_yim' => '',

'user_msnm' => '',

'user_jabber' => '',

'user_website' => '',

'user_actkey' => '',

'user_newpasswd' => '',

'user_form_salt' => '',

<column>username_clean</column>

<column>user_permissions</column>

<column>user_sig</column>

<row>

<value>1</value>

<value>4</value>

<value>user 1</value>

<value></value>

<value></value>

</row>

</table>

</dataset>

<column>username_clean</column>

<column>user_permissions</column>

<column>user_sig</column>

<row>

<value>1</value>

<value>1</value>

<value>user 1</value>

<value></value>

<value></value>

</row>

<row>

<value>2</value>

<value>user 2</value>

<value></value>

<value></value>

</row>

<row>

<value>3</value>

<value>user 3</value>

<value></value>

<value></value>

</row>

</table>

</dataset>

<column>username_clean</column>

<column>user_permissions</column>

<column>user_sig</column>

<row>

<value>1</value>

<value>6</value>

<value>user 1</value>

<value></value>

<value></value>

</row>

</table>

</dataset>

<column>username_clean</column>

<column>user_permissions</column>

<column>user_sig</column>

<row>

<value>1</value>

<value>mass email</value>

<value>mass email</value>

<value></value>

<value></value>

</row>

<row>

<value>2</value>

<value>banned</value>

<value></value>

<value></value>

</row>

<row>

<value>3</value>

<value>not in group</value>

<value></value>

<value></value>

</row>

</table>

<table name="phpbb_user_group">

<column>username_clean</column>

<column>user_permissions</column>

<column>user_sig</column>

<row>

<value>1</value>

<value>barfoo</value>

<value></value>

<value></value>

</row>

<row>

<value>2</value>

<value>foobar</value>

<value></value>

<value></value>

</row>

<row>

<value>3</value>

<value>bertie</value>

<value></value>

<value></value>

</row>

</table>

</dataset>

require_once dirname(__FILE__) . '/migration/revert_with_dependency.php';

require_once dirname(__FILE__) . '/migration/fail.php';

require_once dirname(__FILE__) . '/migration/installed.php';

class phpbb_dbal_migrator_test extends phpbb_database_test_case

{

dirname(__FILE__) . '/../../phpBB/',

'php',

'phpbb_',

);

$container = new phpbb_mock_container_builder();

$this->fail('Installed test failed');

}

}

}

'username_clean' => $username,

'user_permissions' => '',

'user_sig' => '',

));

$db->sql_query($sql);

$phpbb_root_path,

$php_ext,

$table_prefix,

);

$container = new phpbb_mock_container_builder();

$container->set('migrator', $migrator);

$this->phpbb_root_path,

'php',

$this->table_prefix,

);

$container = new phpbb_mock_container_builder();

$container->set('migrator', $migrator);

parent::setUp();

$this->path = __DIR__ . '/fixtures/files/';

$this->add_lang('posting');

}

public function tearDown()

public function test_empty_file()

{

$crawler = $this->upload_file('empty.png', 'image/png');

}

public function test_invalid_extension()

{

$crawler = $this->upload_file('illegal-extension.bif', 'application/octet-stream');

$this->assertEquals($this->lang('DISALLOWED_EXTENSION', 'bif'), $crawler->filter('p.error')->text());

}

public function test_too_large()

{

$crawler = $this->upload_file('too-large.png', 'image/png');

$this->assertEquals($this->lang('WRONG_FILESIZE', '256', 'KiB'), $crawler->filter('p.error')->text());

}

public function test_valid_file()

{

$crawler = $this->upload_file('valid.jpg', 'image/jpeg');

$this->assertNotContains('<h2>' . $this->lang('INFORMATION') . '</h2>', $this->get_content());

}

}

<column>user_allow_viewonline</column>

<column>user_permissions</column>

<column>user_sig</column>

<row>

<value>1</value>

<value>anonymous</value>

<value>1</value>

<value></value>

<value></value>

</row>

<row>

<value>2</value>

<value>1</value>

<value></value>

<value></value>

</row>

<row>

<value>3</value>

<value>1</value>

<value></value>

<value></value>

</row>

<row>

<value>4</value>

<value>1</value>

<value></value>

<value></value>

</row>

<row>

<value>5</value>

<value>1</value>

<value></value>

<value></value>

</row>

<row>

<value>6</value>

<value>0</value>

<value></value>

<value></value>

</row>

<row>

<value>7</value>

<value>0</value>

<value></value>

<value></value>

</row>

<row>

<value>8</value>

<value>0</value>

<value></value>

<value></value>

</row>

<row>

<value>9</value>

<value>0</value>

<value></value>

<value></value>

</row>

<row>

<value>10</value>

<value>0</value>

<value></value>

<value></value>

</row>

</table>

</dataset>

<column>username_clean</column>

<column>user_permissions</column>

<column>user_sig</column>

<column>user_email_hash</column>

<row>

<value>1</value>

<value>admin</value>

<value></value>

<value></value>

<value>143317126117</value>

</row>

</table>

<column>username_clean</column>

<column>user_permissions</column>

<column>user_sig</column>

<row>

<value>1</value>

<value>admin</value>

<value>admin</value>

<value></value>

<value></value>

</row>

<row>

<value>2</value>

<value>moderator</value>

<value></value>

<value></value>

</row>

</table>

</dataset>

<column>username_clean</column>

<column>user_permissions</column>

<column>user_sig</column>

<row>

<value>1</value>

<value>1</value>

<value>barfoo</value>

<value></value>

<value></value>

</row>

<row>

<value>2</value>

<value>foobar</value>

<value></value>

<value></value>

</row>

<row>

<value>3</value>

<value>bertie</value>

<value></value>

<value></value>

</row>

</table>

<table name="phpbb_user_group">

<column>username_clean</column>

<column>user_permissions</column>

<column>user_sig</column>

<row>

<value>1</value>

<value>Anonymous</value>

<value>Anonymous</value>

<value></value>

<value></value>

</row>

<row>

<value>2</value>

<value>admin</value>

<value></value>

<value></value>

</row>

</table>

<table name="phpbb_topics">

<column>user_notify_pm</column>

<column>user_permissions</column>

<column>user_sig</column>

<row>

<value>1</value>

<value>1</value>

<value>0</value>

<value></value>

<value></value>

</row>

<row>

<value>2</value>

<value>1</value>

<value></value>

<value></value>

</row>

<row>

<value>3</value>

<value>0</value>

<value></value>

<value></value>

</row>

<row>

<value>4</value>

<value>1</value>

<value></value>

<value></value>

</row>

<row>

<value>5</value>

<value>0</value>

<value></value>

<value></value>

</row>

<row>

<value>6</value>

<value>1</value>

<value></value>

<value></value>

</row>

</table>

</dataset>

<column>username_clean</column>

<column>user_permissions</column>

<column>user_sig</column>

<row>

<value>2</value>

<value>2</value>

<value>2</value>

<value></value>

<value></value>

</row>

<row>

<value>3</value>

<value>3</value>

<value></value>

<value></value>

</row>

</table>

</dataset>

<column>username_clean</column>

<column>user_permissions</column>

<column>user_sig</column>

<row>

<value>2</value>

<value>poster</value>

<value></value>

<value></value>

</row>

<row>

<value>3</value>

<value>test</value>

<value></value>

<value></value>

</row>

<row>

<value>4</value>

<value>unauthorized</value>

<value></value>

<value></value>

</row>

<row>

<value>5</value>

<value>notified</value>

<value></value>

<value></value>

</row>

<row>

<value>6</value>

<value>disabled</value>

<value></value>

<value></value>

</row>

<row>

<value>7</value>

<value>default</value>

<value></value>

<value></value>

</row>

</table>

<table name="phpbb_user_notifications">

<column>username_clean</column>

<column>user_permissions</column>

<column>user_sig</column>

<row>

<value>2</value>

<value>poster</value>

<value></value>

<value></value>

</row>

<row>

<value>3</value>

<value>test</value>

<value></value>

<value></value>

</row>

<row>

<value>4</value>

<value>unauthorized</value>

<value></value>

<value></value>

</row>

<row>

<value>5</value>

<value>notified</value>

<value></value>

<value></value>

</row>

<row>

<value>6</value>

<value>disabled</value>

<value></value>

<value></value>

</row>

<row>

<value>7</value>

<value>default</value>

<value></value>

<value></value>

</row>

</table>

<table name="phpbb_user_notifications">

<column>username_clean</column>

<column>user_permissions</column>

<column>user_sig</column>

<row>

<value>2</value>

<value>poster</value>

<value></value>

<value></value>

</row>

<row>

<value>3</value>

<value>test</value>

<value></value>

<value></value>

</row>

<row>

<value>4</value>

<value>unauthorized-mod</value>

<value></value>

<value></value>

</row>

<row>

<value>5</value>

<value>unauthorized-read</value>

<value></value>

<value></value>

</row>

<row>

<value>6</value>

<value>notified</value>

<value></value>

<value></value>

</row>

<row>

<value>7</value>

<value>disabled</value>

<value></value>

<value></value>

</row>

<row>

<value>8</value>

<value>default</value>

<value></value>

<value></value>

</row>

<row>

<value>9</value>

<value>test glboal-permissions</value>

<value></value>

<value></value>

</row>

</table>

<table name="phpbb_user_notifications">

<column>username_clean</column>

<column>user_permissions</column>

<column>user_sig</column>

<row>

<value>2</value>

<value>poster</value>

<value></value>

<value></value>

</row>

<row>

<value>3</value>

<value>test</value>

<value></value>

<value></value>

</row>

<row>

<value>4</value>

<value>unauthorized</value>

<value></value>

<value></value>

</row>

<row>

<value>5</value>

<value>notified</value>

<value></value>

<value></value>

</row>

<row>

<value>6</value>

<value>disabled</value>

<value></value>

<value></value>

</row>

<row>

<value>7</value>

<value>default</value>

<value></value>

<value></value>

</row>

</table>

<table name="phpbb_user_notifications">

<column>user_unread_privmsg</column>

<column>user_permissions</column>

<column>user_sig</column>

<row>

<value>2</value>

<value>sender</value>

<value>0</value>

<value></value>

<value></value>

</row>

<row>

<value>3</value>

<value>0</value>

<value></value>

<value></value>

</row>

<row>

<value>4</value>

<value>2</value>

<value></value>

<value></value>

</row>

<row>

<value>5</value>

<value>0</value>

<value></value>

<value></value>

</row>

</table>

<table name="phpbb_privmsgs">

<column>username_clean</column>

<column>user_permissions</column>

<column>user_sig</column>

<row>

<value>1</value>

<value>anonymous</value>

<value></value>

<value></value>

</row>

</table>

<table name="phpbb_sessions">

<column>username_clean</column>

<column>user_permissions</column>

<column>user_sig</column>

<row>

<value>1</value>

<value>anonymous</value>

<value></value>

<value></value>

</row>

<row>

<value>3</value>

<value>foo</value>

<value></value>

<value></value>

</row>

<row>

<value>4</value>

<value>bar</value>

<value></value>

<value></value>

</row>

</table>

<table name="phpbb_sessions">

<column>username_clean</column>

<column>user_permissions</column>

<column>user_sig</column>

<row>

<value>1</value>

<value>anonymous</value>

<value></value>

<value></value>

</row>

<row>

<value>3</value>

<value>foo</value>

<value></value>

<value></value>

</row>

<row>

<value>4</value>

<value>bar</value>

<value></value>

<value></value>

</row>

</table>

<table name="phpbb_sessions">

<column>username_clean</column>

<column>user_permissions</column>

<column>user_sig</column>

<row>

<value>4</value>

<value>bar</value>

<value></value>

<value></value>

</row>

</table>

<table name="phpbb_sessions">

<column>username_clean</column>

<column>user_permissions</column>

<column>user_sig</column>

<row>

<value>4</value>

<value>bar</value>

<value></value>

<value></value>

</row>

</table>

</dataset>

$phpbb_root_path,

$php_ext,

self::$config['table_prefix'],

);

$container = new phpbb_mock_container_builder();

$container->set('migrator', $migrator);

<column>username</column>

<column>username_clean</column>

<column>user_sig</column>

<row>

<value>1</value>

<value></value>

<value>Guest</value>

<value>guest</value>

<value></value>

</row>

<row>

<value>2</value>

<value>Admin</value>

<value>admin</value>

<value></value>

</row>

<row>

<value>3</value>

<value>Test</value>

<value>test</value>

<value></value>

</row>

</table>

</dataset>