</dl>

<dl>

<dt><label for="allowed_forums">{L_ALLOWED_FORUMS}{L_COLON}</label><br /><span>{L_ALLOWED_FORUMS_EXPLAIN}</span></dt>

<dd><select name="allowed_forums[]" multiple="multiple" size="8">{S_FORUM_ID_OPTIONS}</select></dd>

</dl>

<dl>

<dt><label>{L_AVATAR_TYPE}{L_COLON}</label></dt>

<dd><select name="avatar_driver" id="avatar_driver" data-togglable-settings="true">

<!-- BEGIN avatar_drivers -->

<option value="{avatar_drivers.DRIVER}"<!-- IF avatar_drivers.SELECTED --> selected="selected"<!-- ENDIF --> data-toggle-setting="#avatar_option_{avatar_drivers.DRIVER}">{avatar_drivers.L_TITLE}</option>

<!-- END avatar_drivers -->

<dl>

<dt><label>{L_AVATAR_TYPE}</label></dt>

<dd><select name="avatar_driver" id="avatar_driver" data-togglable-settings="true">

<!-- BEGIN avatar_drivers -->

<option value="{avatar_drivers.DRIVER}"<!-- IF avatar_drivers.SELECTED --> selected="selected"<!-- ENDIF --> data-toggle-setting="#avatar_option_{avatar_drivers.DRIVER}">{avatar_drivers.L_TITLE}</option>

<!-- END avatar_drivers -->

/* Tabbed menu

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

#tabs {

line-height: normal;

margin: 0 7px;

position: relative;

z-index: 2;

}

list-style: none;

margin: 0;

padding: 0;

}

content: '';

display: block;

clear: both;

}

float: left;

}

float: right;

}

color: #767676;

font-weight: bold;

}

color: #BC2A4D;

}

color: #23649F;

}

color: #115098;

}

.responsive-tab {

position: relative;

}

font-size: 16px;

position: relative;

width: 16px;

line-height: 14px;

text-decoration: none;

}

content: '';

position: absolute;

height: .125em;

width: 14px;

border-bottom: 0.125em solid #767676;

border-top: 0.375em double #767676;

}

border-color: #BC2A4D;

}

border-color: #23649F;

}

border-color: #115098;

}

}

#tabs .dropdown-right .dropdown {

margin-left: -2px;

}

}

}

}

}

/* Main Panel

ul = $this.children(),

tabs = ul.children().not('[data-skip-responsive]'),

links = tabs.children('a'),

menu = item.find('.dropdown-contents'),

maxHeight = 0,

lastWidth = false,

for (i = total - 1; i >= 0; i --) {

tab = availableTabs.eq(i);

tab.hide();

if ($this.height() <= maxHeight) {

menu.find('a').click(function() { check(true); });

</div>

<div id="page-footer">

</div>

</div>

<div id="tabs">

<ul>

<!-- BEGIN t_block1 -->

<!-- END t_block1 -->

</ul>

</div>

<!-- ENDIF -->

<br />

<fieldset class="quick">

<div id="tabs">

<ul>

<!-- BEGIN t_block1 -->

<!-- END t_block1 -->

</ul>

</div>

"twig/twig": "1.13.*"

},

"require-dev": {

"fabpot/goutte": "1.0.*",

"phpunit/dbunit": "1.3.*",

"phpunit/phpunit": "4.1.*",

"This file locks the dependencies of your project to a known state",

"Read more about it at http://getcomposer.org/doc/01-basic-usage.md#composer-lock-the-lock-file"

],

"packages": [

{

"name": "lusitanian/oauth",

],

"packages-dev": [

{

"name": "fabpot/goutte",

"version": "v1.0.3",

"source": {

tags:

- { name: profilefield.type }

profilefields.type.int:

class: phpbb\profilefields\type\type_int

arguments:

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

$supported_dbms = array(

'mssql',

'mysql_40',

'mysql_41',

fwrite($fp, json_encode($schema_data, JSON_PRETTY_PRINT));

fclose($fp);

echo 'done';

<ol>

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

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

<li><a href="#v310b3">Changes since 3.1.0-b3</a></li>

<li><a href="#v310b2">Changes since 3.1.0-b2</a></li>

<li><a href="#v310b1">Changes since 3.1.0-b1</a></li>

<div class="content">

<h4>Bug</h4>

<ul>

</ul>

<h4>Bug</h4>

<ul>

</ul>

<h4>Bug</h4>

<ul>

<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-12302">PHPBB3-12302</a>] - Upgrade composer.phar to 1.0.0-alpha8</li>

</ul>

<h4>Bug</h4>

<ul>

</ul>

<h4>Bug</h4>

<ul>

<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-12147">PHPBB3-12147</a>] - Remove Travis CI notification configuration</li>

</ul>

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

<li>PostgreSQL 8.3+</li>

<li>SQLite 2.8.2+</li>

<li>SQLite 3.6.15+</li>

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

<li>Oracle</li>

</ul>

<p>Please remember that running any application on a development (unstable, e.g. a beta release) version of PHP can lead to strange/unexpected results which may appear to be bugs in the application. Therefore, we recommend you upgrade to the newest stable version of PHP before running phpBB3. If you are running a development version of PHP please check any bugs you find on a system running a stable release before submitting.</p>

<a name="phpsec"></a><h3>7.i. Notice on PHP security issues</h3>

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

<h4>Common SQL Guidelines: </h4>

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

<h4>SQL code layout:</h4>

* Since: 3.1.0-a1

* Purpose: Add entries before the user statistics part of any user profile

overall_footer_after

===

* Locations:

+ styles/prosilver/template/ucp_prefs_view.html

+ styles/subsilver2/template/ucp_prefs_view.html

* Since: 3.1.0-a1

Display Options screen

ucp_prefs_view_radio_buttons_append

+ styles/prosilver/template/ucp_prefs_view.html

+ styles/subsilver2/template/ucp_prefs_view.html

* Since: 3.1.0-a1

Display Options screen

ucp_prefs_view_select_menu_prepend

+ styles/prosilver/template/ucp_prefs_view.html

+ styles/subsilver2/template/ucp_prefs_view.html

* Since: 3.1.0-a1

Display Options screen

ucp_prefs_view_select_menu_append

+ styles/prosilver/template/ucp_prefs_view.html

+ styles/subsilver2/template/ucp_prefs_view.html

* Since: 3.1.0-a1

Display Options screen

ucp_friend_list_before

===

* Locations:

'ip_check' => array('lang' => 'IP_VALID', 'validate' => 'int', 'type' => 'custom', 'method' => 'select_ip_check', 'explain' => true),

'browser_check' => array('lang' => 'BROWSER_VALID', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => true),

'forwarded_for_check' => array('lang' => 'FORWARDED_FOR_VALID', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => true),

'check_dnsbl' => array('lang' => 'CHECK_DNSBL', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => true),

'email_check_mx' => array('lang' => 'EMAIL_CHECK_MX', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => true),

'max_pass_chars' => array('lang' => 'PASSWORD_LENGTH', 'validate' => 'int:8:255', 'type' => false, 'method' => false, 'explain' => false,),

case 'mssqlnative':

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

break;

}

$extractor->write_start($table_prefix);

{

case 'sqlite':

case 'sqlite3':

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

break;

}

break;

case 'postgres':

$delim = ";\n";

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

}

}

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

function get_usable_memory()

{

{

case 'sqlite':

case 'sqlite3':

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

break;

{

case 'sqlite':

case 'sqlite3':

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

break;

{

case 'sqlite':

case 'sqlite3':

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

break;

break;

case 'oracle':

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

// Teh standard

case 'postgres':

case 'oracle':

case 'sqlite':

case 'sqlite3':

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

trigger_error($this->user->lang['NO_MATCHING_STYLES_FOUND'] . adm_back_link($this->u_action), E_USER_WARNING);

}

$message = implode('<br />', $messages);

trigger_error($message, E_USER_NOTICE);

}

*/

// phpBB Version

// QA-related

// define('PHPBB_QA', 1);

if (isset($GLOBALS['starttime']))

{

$totaltime = microtime(true) - $GLOBALS['starttime'];

}

$memory_usage = memory_get_peak_usage();

if ($memory_usage)

{

case 'sqlite':

case 'sqlite3':

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

break;

}

break;

case 'sqlite':

case 'sqlite3':

global $dbhost;

{

case 'sqlite':

case 'sqlite3':

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

break;

'L_SUBFORUM' => ($visible_forums == 1) ? $user->lang['SUBFORUM'] : $user->lang['SUBFORUMS'],

'LAST_POST_IMG' => $user->img('icon_topic_latest', 'VIEW_LATEST_POST'),

'UNAPPROVED_IMG' => $user->img('icon_topic_unapproved', 'TOPICS_UNAPPROVED'),

));

if ($return_moderators)

// Get forum parents

$forum_parents = get_forum_parents($forum_data);

// Build navigation links

if (!empty($forum_parents))

{

'S_IS_POST' => ($parent_type == FORUM_POST) ? true : false,

'FORUM_NAME' => $parent_name,

'FORUM_ID' => $parent_forum_id,

'U_VIEW_FORUM' => append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $parent_forum_id))

);

}

'S_IS_POST' => ($forum_data['forum_type'] == FORUM_POST) ? true : false,

'FORUM_NAME' => $forum_data['forum_name'],

'FORUM_ID' => $forum_data['forum_id'],

'U_VIEW_FORUM' => append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $forum_data['forum_id']))

);

return $links;

}

{

global $lang;

$available_dbms = array(

// Note: php 5.5 alpha 2 deprecated mysql.

// Keep mysqli before mysql in this list.

'mysqli' => array(

$prefix_length = 200;

break;

case 'phpbb\db\driver\oracle':

$prefix_length = 6;

break;

}

break;

case 'phpbb\db\driver\oracle':

if ($unicode_check)

{

// Function for building 'url_extra'

$short_name = $this->get_short_name($row['module_basename']);

// Function for building the language name

// Custom function for calling parameters on module init (for example assigning template variables)

$names[$row['module_basename'] . '_' . $row['module_mode']][] = true;

return $url;

}

*/

function delete_pm($user_id, $msg_ids, $folder_id)

{

$user_id = (int) $user_id;

$folder_id = (int) $folder_id;

return false;

}

// Get PM Information for later deleting

$sql = 'SELECT msg_id, pm_unread, pm_new

FROM ' . PRIVMSGS_TO_TABLE . '

$phpbb_notifications->add_notifications('pm', $pm_data);

}

return $data['msg_id'];

}

var $max_height = 0;

var $error_prefix = '';

/**

* Init file upload class.

*

fputs($fsock, "HOST: " . $host . "\r\n");

fputs($fsock, "Connection: close\r\n\r\n");

$get_info = false;

$data = '';

{

if ($get_info)

{

$filesize += strlen($block);

if ($remote_max_filesize && $filesize > $remote_max_filesize)

}

}

}

}

@fclose($fsock);

* Use this event to modify the values to be inserted when a user is added

*

* @event core.user_add_modify_data

* @var array sql_ary Array of data to be inserted when a user is added

* @since 3.1.0-a1

*/

extract($phpbb_dispatcher->trigger_event('core.user_add_modify_data', compact($vars)));

$sql = 'INSERT INTO ' . USERS_TABLE . ' ' . $db->sql_build_array('INSERT', $sql_ary);

set_config('newest_user_colour', $row['group_colour'], true);

}

return $user_id;

}

return $banned_ids_list;

}

}

else if ($post_id)

{

if (sizeof($post_info) && !empty($post_info[$post_id]))

{

$sort_days = $total = 0;

$sort_key = $sort_dir = '';

$sort_by_sql = $sort_order_sql = array();

$forum_topics = ($total == -1) ? $forum_info['forum_topics_approved'] : $total;

$limit_time_sql = ($sort_days) ? 'AND t.topic_last_post_time >= ' . (time() - ($sort_days * 86400)) : '';

trigger_error('NO_TOPIC_SELECTED');

}

{

return;

}

$sync_topics = array_merge($topic_ids, array($to_topic_id));

if (!sizeof($topic_data) || empty($topic_data[$to_topic_id]))

{

return;

}

{

return;

}

$forum_id = request_var('f', 0);

if (!sizeof($forum_info))

{

$orig_ids = $ids;

{

// Make sure that for f_user_lock only the lock action is triggered.

if ($action != 'lock')

$ids = $orig_ids;

{

return;

}

WHERE ' . $db->sql_in_set($sql_id, $ids);

$db->sql_query($sql);

foreach ($data as $id => $row)

{

break;

}

if ($forum_id === false)

{

if (sizeof($topic_ids))

{

foreach ($data as $topic_id => $row)

{

global $phpEx, $phpbb_root_path;

// Here we limit the operation to one forum only

if ($forum_id === false)

{

if ($to_forum_id)

{

if (!sizeof($forum_data))

{

if (confirm_box(true))

{

$leave_shadow = (isset($_POST['move_leave_shadow'])) ? true : false;

$forum_sync_data = array();

{

global $auth, $user, $db, $phpEx, $phpbb_root_path, $request, $phpbb_container;

{

return;

}

{

$success_msg = (sizeof($topic_ids) == 1) ? 'TOPIC_RESTORED_SUCCESS' : 'TOPICS_RESTORED_SUCCESS';

$phpbb_content_visibility = $phpbb_container->get('content.visibility');

foreach ($data as $topic_id => $row)

{

global $auth, $user, $db, $phpEx, $phpbb_root_path, $request, $phpbb_container;

{

return;

}

{

$success_msg = (sizeof($topic_ids) == 1) ? 'TOPIC_DELETED_SUCCESS' : 'TOPICS_DELETED_SUCCESS';

foreach ($data as $topic_id => $row)

{

{

global $auth, $user, $db, $phpEx, $phpbb_root_path, $request, $phpbb_container;

{

return;

}

if (confirm_box(true) && $is_soft)

{

$topic_info = $approve_log = array();

$affected_topics = sizeof($topic_id_list);

$db->sql_freeresult($result);

foreach ($post_data as $id => $row)

{

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

global $phpEx, $phpbb_root_path;

{

return;

}

if ($to_forum_id)

{

if (!sizeof($topic_ids))

{

if (confirm_box(true))

{

$total_topics = $total_topics_unapproved = $total_topics_softdeleted = 0;

$total_posts = $total_posts_unapproved = $total_posts_softdeleted = 0;

$pm_id = $report['pm_id'];

$report_id = $report['report_id'];

if (!sizeof($pm_info))

{

$sort_days = $total = 0;

$sort_key = $sort_dir = '';

$sort_by_sql = $sort_order_sql = array();

$limit_time_sql = ($sort_days) ? 'AND r.report_time >= ' . (time() - ($sort_days * 86400)) : '';

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

// Get post data

add_form_key('mcp_post_details');

}

$post_info = $post_info[$post_id];

switch ($action)

{

$to_username = $userdata['username'];

// Renew post info

if (!sizeof($post_info))

{

if ($topic_id)

{

if (isset($topic_info[$topic_id]['topic_first_post_id']))

{

$post_id = (int) $topic_info[$topic_id]['topic_first_post_id'];

$phpbb_notifications->mark_notifications_read('post_in_queue', $post_id, $user->data['user_id']);

if (!sizeof($post_info))

{

if ($topic_id)

{

if (!sizeof($topic_info))

{

}

else

{

if (!sizeof($forum_info))

{

$sort_days = $total = 0;

$sort_key = $sort_dir = '';

$sort_by_sql = $sort_order_sql = array();

$forum_topics = ($total == -1) ? $forum_info['forum_topics_approved'] : $total;

$limit_time_sql = ($sort_days) ? 'AND t.topic_last_post_time >= ' . (time() - ($sort_days * 86400)) : '';

global $db, $template, $user, $config, $request, $phpbb_container;

global $phpEx, $phpbb_root_path;

{

trigger_error('NOT_AUTHORISED');

}

'redirect' => $redirect,

));

if (confirm_box(true))

{

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

global $phpEx, $phpbb_root_path, $request, $phpbb_container;

{

trigger_error('NOT_AUTHORISED');

}

'redirect' => $redirect,

));

if (confirm_box(true))

{

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

global $phpEx, $phpbb_root_path, $request;

{

trigger_error('NOT_AUTHORISED');

}

}

}

$is_disapproving = false;

foreach ($post_info as $post_id => $post_data)

$parse_post_flags += $report['reported_post_enable_smilies'] ? OPTION_FLAG_SMILIES : 0;

$parse_post_flags += $report['reported_post_enable_magic_url'] ? OPTION_FLAG_LINKS : 0;

if (!sizeof($post_info))

{

if ($topic_id)

{

if (!sizeof($topic_info))

{

}

else

{

if (!sizeof($forum_info))

{

$sort_days = $total = 0;

$sort_key = $sort_dir = '';

$sort_by_sql = $sort_order_sql = array();

$forum_topics = ($total == -1) ? $forum_info['forum_topics_approved'] : $total;

$limit_time_sql = ($sort_days) ? 'AND r.report_time >= ' . (time() - ($sort_days * 86400)) : '';

}

else

{

{

trigger_error('NOT_AUTHORISED');

}

if (confirm_box(true))

{

$sql = "SELECT r.report_id, r.$id_column, r.report_closed, r.user_id, r.user_notify, u.username, u.username_clean, u.user_email, u.user_jabber, u.user_lang, u.user_notify_type

FROM " . REPORTS_TABLE . ' r, ' . USERS_TABLE . ' u

global $phpEx, $phpbb_root_path, $config;

global $template, $db, $user, $auth, $cache, $phpbb_container;

$user->add_lang('viewtopic');

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

$topic_id = request_var('t', 0);

if (!sizeof($topic_info))

{

$sort_days = $total = 0;

$sort_key = $sort_dir = '';

$sort_by_sql = $sort_order_sql = array();

$limit_time_sql = ($sort_days) ? 'AND p.post_time >= ' . (time() - ($sort_days * 86400)) : '';

$phpbb_content_visibility = $phpbb_container->get('content.visibility');

// Has the user selected a topic for merge?

if ($to_topic_id)

{

if (!sizeof($to_topic_info))

{

return;

}

{

return;

}

$post_id = $post_id_list[0];

if (!sizeof($post_info))

{

return;

}

if (!sizeof($forum_info))

{

$sort_days = $total = 0;

$sort_key = $sort_dir = '';

$sort_by_sql = $sort_order_sql = array();

$limit_time_sql = ($sort_days) ? 'AND t.topic_last_post_time >= ' . (time() - ($sort_days * 86400)) : '';

$to_topic_id = $db->sql_nextid();

move_posts($post_id_list, $to_topic_id);

$topic_info = $topic_info[$topic_id];

add_log('mod', $to_forum_id, $to_topic_id, 'LOG_SPLIT_DESTINATION', $subject);

$sync_topics = array($topic_id, $to_topic_id);

if (!sizeof($topic_data) || empty($topic_data[$to_topic_id]))

{

return;

}

{

return;

}

ORDER BY LEN(code) DESC';

break;

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

default:

$sql = 'SELECT *

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

$convertor_data = array(

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

'version' => '1.0.3',

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

'dbms' => $dbms,

'dbhost' => $dbhost,

$drop_sql = 'DROP TABLE ' . USERCONV_TABLE;

switch ($map_dbms)

{

case 'mssql':

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

[user_id] [int] NOT NULL ,

</div>

<div id="page-footer">

</div>

</div>

</body>

define('IN_DB_UPDATE', true);

/**

*/

// End startup code

{

case 'sqlite':

case 'sqlite3':

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

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

break;

{

case 'sqlite':

case 'sqlite3':

$convert->src_truncate_statement = 'DELETE FROM ';

break;

{

case 'sqlite':

case 'sqlite3':

$convert->truncate_statement = 'DELETE FROM ';

break;

// How should we treat this schema?

$delimiter = $available_dbms[$data['dbms']]['DELIM'];

{

{

}

}

// Ok we have the db info go ahead and work on building the table

$db_table_schema = @file_get_contents('schemas/schema.json');

'S_COLLECTED' => (int) $update_list['status'],

'S_TO_COLLECT' => sizeof($this->update_info['files']),

'L_IN_PROGRESS' => $user->lang['COLLECTING_FILE_DIFFS'],

));

return;

// Now assign the list to the template

foreach ($update_list as $status => $filelist)

{

{

continue;

}

$all_up_to_date = true;

foreach ($update_list as $status => $filelist)

{

{

$all_up_to_date = false;

break;

foreach ($update_list as $status => $files)

{

{

continue;

}

$this->page_title = 'VIEWING_FILE_CONTENTS';

break;

}

$diff_mode_options = '';

'new_conflict' => array(),

'conflict' => array(),

'no_update' => array(),

'status' => 0,

);

}

$update_list['status']++;

}

$update_list['status'] = -1;

/* if (!sizeof($this->update_info['files']))

{

return $update_list;

/*

This first section is optional, however its probably the best method

of running phpBB on Oracle. If you already have a tablespace and user created

for phpBB you can leave this section commented out!

BEGIN;

"VCHAR",

""

],

"pf_phpbb_interests": [

"MTEXT",

""

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_profile_fields (field_name, field_type, field_ident, field_length, field_minlen, field_maxlen, field_novalue, field_default_value, field_validation, field_required, field_show_novalue, field_show_on_reg, field_show_on_pm, field_show_on_vt, field_show_on_ml, field_show_profile, field_hide, field_no_view, field_active, field_order, field_is_contact, field_contact_desc, field_contact_url) VALUES ('phpbb_twitter', 'profilefields.type.string', 'phpbb_twitter', '20', '1', '15', '', '', '[\w_]+', 0, 0, 0, 1, 1, 1, 1, 0, 0, 1, 10, 1, 'VIEW_TWITTER_PROFILE', 'http://twitter.com/%s');

INSERT INTO phpbb_profile_fields (field_name, field_type, field_ident, field_length, field_minlen, field_maxlen, field_novalue, field_default_value, field_validation, field_required, field_show_novalue, field_show_on_reg, field_show_on_pm, field_show_on_vt, field_show_on_ml, field_show_profile, field_hide, field_no_view, field_active, field_order, field_is_contact, field_contact_desc, field_contact_url) VALUES ('phpbb_skype', 'profilefields.type.string', 'phpbb_skype', '20', '6', '32', '', '', '[a-zA-Z][\w\.,\-_]+', 0, 0, 0, 1, 1, 1, 1, 0, 0, 1, 11, 1, 'VIEW_SKYPE_PROFILE', 'skype:%s?userinfo');

INSERT INTO phpbb_profile_fields (field_name, field_type, field_ident, field_length, field_minlen, field_maxlen, field_novalue, field_default_value, field_validation, field_required, field_show_novalue, field_show_on_reg, field_show_on_pm, field_show_on_vt, field_show_on_ml, field_show_profile, field_hide, field_no_view, field_active, field_order, field_is_contact, field_contact_desc, field_contact_url) VALUES ('phpbb_youtube', 'profilefields.type.string', 'phpbb_youtube', '20', '3', '60', '', '', '[a-zA-Z][\w\.,\-_]+', 0, 0, 0, 1, 1, 1, 1, 0, 0, 1, 12, 1, 'VIEW_YOUTUBE_CHANNEL', 'http://youtube.com/user/%s');

# User Notification Options (for first user)

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

'PASS_TYPE_SYMBOL' => 'Must contain symbols',

'REF_HOST' => 'Only validate host',

'REF_PATH' => 'Also validate path',

'TPL_ALLOW_PHP' => 'Allow php in templates',

'TPL_ALLOW_PHP_EXPLAIN' => 'If this option is enabled, <code>PHP</code> and <code>INCLUDEPHP</code> statements will be recognised and parsed in templates.',

));

'LOG_REASON_REMOVED' => '<strong>Removed report/denial reason</strong><br />» %s',

'LOG_REASON_UPDATED' => '<strong>Updated report/denial reason</strong><br />» %s',

'LOG_RESET_DATE' => '<strong>Board start date reset</strong>',

'LOG_RESET_ONLINE' => '<strong>Most users online reset</strong>',

'LOG_RESYNC_FILES_STATS' => '<strong>File statistics resynchronised</strong>',

'FIELD_DESCRIPTION' => 'Field description',

'FIELD_DESCRIPTION_EXPLAIN' => 'The explanation for this field presented to the user.',

'FIELD_DROPDOWN' => 'Dropdown box',

'FIELD_IDENT' => 'Field identification',

'FIELD_IDENT_ALREADY_EXIST' => 'The chosen field identification already exist. Please choose another name.',

'FIELD_IDENT_EXPLAIN' => 'The field identification is a name to identify the profile field within the database and the templates.',

'STYLE_ERR_NAME_EXIST' => 'A style with that name already exists.',

'STYLE_ERR_STYLE_NAME' => 'You must supply a name for this style.',

'STYLE_INSTALLED' => 'Style "%s" has been installed.',

'STYLE_NAME' => 'Style name',

'STYLE_NOT_INSTALLED' => 'Style "%s" was not installed.',

'STYLE_PATH' => 'Style path',

'AVATAR_PARTIAL_UPLOAD' => 'The specified file was only partially uploaded.',

'AVATAR_PHP_SIZE_NA' => 'The avatar’s filesize is too large.<br />The maximum allowed filesize set in php.ini could not be determined.',

'AVATAR_PHP_SIZE_OVERRUN' => 'The avatar’s filesize is too large. The maximum allowed upload size is %1$d %2$s.<br />Please note this is set in php.ini and cannot be overridden.',

'AVATAR_URL_INVALID' => 'The URL you specified is invalid.',

'AVATAR_URL_NOT_FOUND' => 'The file specified could not be found.',

'AVATAR_WRONG_FILESIZE' => 'The avatar’s filesize must be between 0 and %1$d %2$s.',

'GB' => 'GB',

'GIB' => 'GiB',

'GO' => 'Go',

'GOTO_FIRST_POST' => 'Go to first post',

'GOTO_LAST_POST' => 'Go to last post',

'GOTO_PAGE' => 'Go to page',

// A, B, C and 2 others replied...

// A, B, C and others replied...

'NOTIFICATION_BOOKMARK' => array(

),

'NOTIFICATION_POST' => array(

),

'NOTIFICATION_QUOTE' => array(

),

'NOTIFICATION_TYPE_NOT_EXIST' => 'The notification type "%s" is missing from the file system.',

// Used in conjuction with NOTIFICATION_BOOKMARK and NOTIFICATION_POST.

'NOTIFICATION_MANY_OTHERS' => 'others',

'NOTIFICATION_X_OTHERS' => array(

'POSTED_ON_DATE' => 'on',

'POSTS' => 'Posts',

'POSTS_UNAPPROVED' => 'At least one post in this topic has not been approved.',

'POST_BY_AUTHOR' => 'by',

'POST_BY_FOE' => '<strong>%1$s</strong>, who is currently on your ignore list, made this post.',

'POST_DISPLAY' => '%1$sDisplay this post%2$s.',

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

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

'DISABLE_KEYS' => 'Disabling keys',

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

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

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

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

'FILLING_TABLES' => 'Filling tables',

'FINAL_STEP' => 'Process final step',

'FORUM_ADDRESS' => 'Board address',

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

<li>PostgreSQL 8.3+</li>

<li>SQLite 2.8.2+</li>

<li>SQLite 3.6.15+</li>

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

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

<li>Oracle</li>

'INST_ERR_DB_NO_SQLITE' => 'The version of the SQLite extension you have installed is too old, it must be upgraded to at least 2.8.2.',

'INST_ERR_DB_NO_SQLITE3' => 'The version of the SQLite extension you have installed is too old, it must be upgraded to at least 3.6.15.',

'INST_ERR_DB_NO_ORACLE' => 'The version of Oracle installed on this machine requires you to set the <var>NLS_CHARACTERSET</var> parameter to <var>UTF8</var>. Either upgrade your installation to 9.2+ or change the parameter.',

'INST_ERR_DB_NO_POSTGRES' => 'The database you have selected was not created in <var>UNICODE</var> or <var>UTF8</var> encoding. Try installing with a database in <var>UNICODE</var> or <var>UTF8</var> encoding.',

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

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

'FILE_USED' => 'Information used from', // Single file

'FILES_CONFLICT' => 'Conflict files',

'FILES_CONFLICT_EXPLAIN' => 'The following files are modified and do not represent the original files from the old version. phpBB determined that these files create conflicts if they are tried to be merged. Please investigate the conflicts and try to manually resolve them or continue the update choosing the preferred merging method. If you resolve the conflicts manually check the files again after you modified them. You are also able to choose between the preferred merge method for every file. The first one will result in a file where the conflicting lines from your old file will be lost, the other one will result in losing the changes from the newer file.',

'FILES_MODIFIED' => 'Modified files',

'FILES_MODIFIED_EXPLAIN' => 'The following files are modified and do not represent the original files from the old version. The updated file will be a merge between your modifications and the new file.',

'FILES_NEW' => 'New files',

'SELECT_DOWNLOAD_FORMAT' => 'Select download archive format',

'SELECT_FTP_SETTINGS' => 'Select FTP settings',

'SHOW_DIFF_CONFLICT' => 'Show differences/conflicts',

'SHOW_DIFF_FINAL' => 'Show resulting file',

'SHOW_DIFF_MODIFIED' => 'Show merged differences',

'SHOW_DIFF_NEW' => 'Show file contents',

'STAGE_UPDATE_FILES' => 'Update files',

'STAGE_VERSION_CHECK' => 'Version check',

'STATUS_CONFLICT' => 'Modified file producing conflicts',

'STATUS_MODIFIED' => 'Modified file',

'STATUS_NEW' => 'New file',

'STATUS_NEW_CONFLICT' => 'Conflicting new file',

'BEFORE' => 'Before',

'CC_EMAIL' => 'Send a copy of this email to yourself.',

'CONTACT_ADMIN' => 'Contact a Board Administrator',

'DEST_LANG' => 'Language',

'VIEW_SKYPE_PROFILE' => 'View Skype Profile',

'VIEW_TWITTER_PROFILE' => 'View Twitter Profile',

'VIEW_YOUTUBE_CHANNEL' => 'View YouTube Channel',

));

),

'QUOTE_NO_NESTING' => 'You may not embed quotes within each other.',

'SAVE' => 'Save',

'SAVE_DATE' => 'Saved at',

'SAVE_DRAFT' => 'Save draft',

'FIELD_TOO_LARGE' => 'The value of “%2$s” is too large, a maximum value of %1$d is allowed.',

'FIELD_INVALID_CHARS_INVALID' => 'The field “%s” has invalid characters.',

'FIELD_INVALID_CHARS_NUMBERS_ONLY' => 'The field “%s” has invalid characters, only numbers are allowed.',

'FIELD_INVALID_CHARS_ALPHA_ONLY' => 'The field “%s” has invalid characters, only alphanumeric characters are allowed.',

'FIELD_INVALID_CHARS_ALPHA_SPACERS' => 'The field “%s” has invalid characters, only alphanumeric, space or -+_[] characters are allowed.',

'FIELD_INVALID_CHARS_ALPHA_UNDERSCORE' => 'The field “%s” has invalid characters, only alphanumeric or _ characters are allowed.',

'FIELD_INVALID_DATE' => 'The field “%s” has an invalid date.',

),

'NO_ACTION_MODE' => 'No message action specified.',

'NO_AUTHOR' => 'No author defined for this message',

'NO_AVATAR_CATEGORY' => 'None',

'NO_AUTH_DELETE_MESSAGE' => 'You are not authorised to delete private messages.',

$phpEx = substr(strrchr(__FILE__, '.'), 1);

include($phpbb_root_path . 'common.' . $phpEx);

include($phpbb_root_path . 'includes/functions_admin.' . $phpEx);

require($phpbb_root_path . 'includes/functions_module.' . $phpEx);

// Start session management

$allow_user = false;

if ($quickmod && isset($user_quickmod_actions[$action]) && $user->data['is_registered'] && $auth->acl_gets($user_quickmod_actions[$action], $forum_id))

{

if ($topic_info[$topic_id]['topic_poster'] == $user->data['user_id'])

{

$allow_user = true;

// Generate the page, do not display/query online list

$module->display($module->get_page_title());

);

extract($phpbb_dispatcher->trigger_event('core.memberlist_view_profile', compact($vars)));

// If the user has m_approve permission or a_user permission, then list then display unapproved posts

if ($auth->acl_getf_global('m_approve') || $auth->acl_get('a_user'))

if ($sort_key == 'l')

{

// uasort($id_cache, create_function('$first, $second', "return (\$first['last_visit'] == \$second['last_visit']) ? 0 : ((\$first['last_visit'] < \$second['last_visit']) ? $lesser_than : ($lesser_than * -1));"));

}

for ($i = 0, $end = sizeof($user_list); $i < $end; ++$i)

$cp_row = (isset($profile_fields_cache[$user_id])) ? $cp->generate_profile_fields_template_data($profile_fields_cache[$user_id], false) : array();

}

'ROW_NUMBER' => $i + ($start + 1),

'S_CUSTOM_PROFILE' => (isset($cp_row['row']) && sizeof($cp_row['row'])) ? true : false,

make_jumpbox(append_sid("{$phpbb_root_path}viewforum.$phpEx"));

page_footer();

* @param ContainerInterface $container Container object

* @param \phpbb\config\config $config phpBB config

*/

{

$this->container = $container;

$this->config = $config;

ORDER BY LEN(bot_agent) DESC';

break;

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

default:

$sql = 'SELECT user_id, bot_agent, bot_ip

if ($this->manager->enabled($name))

{

$output->writeln("<info>Successfully enabled extension $name</info>");

return 0;

}

{

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

}

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

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

{

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

}

if ($cache && $cache_ttl)

{

{

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

}

$this->last_query_text = $query;

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

{

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

}

if ($cache && $cache_ttl)

{

{

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

}

$this->last_query_text = $query;

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

{

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

}

if ($cache && $cache_ttl)

{

{

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

}

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

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

{

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

}

if ($cache && $cache_ttl)

{

{

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

}

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

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

{

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

}

if ($cache && $cache_ttl)

{

{

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

}

$this->last_query_text = $query;

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

{

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

}

if ($cache && $cache_ttl)

{

{

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

}

$this->last_query_text = $query;

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

{

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

}

if ($cache && $cache_ttl)

{

{

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

}

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

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

{

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

}

if ($cache && $cache_ttl)

{

{

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

}

$this->last_query_text = $query;

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

{

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

}