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

#page-footer {

clear: both;

font-size: 0.75em;

text-align: center;

}

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

margin-bottom: 1px;

}

table.responsive td.empty {

display: none !important;

}

box-sizing: border-box;

}

table.responsive.two-columns td:nth-child(2n+1) {

clear: left;

}

z-index: 50;

padding: 25px;

padding: 0 25px 20px 25px;

}

.phpbb_alert .alert_close {

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>

<div id="page-footer">

<div id="darkenwrapper" data-ajax-error-title="{L_AJAX_ERROR_TITLE}" data-ajax-error-text="{L_AJAX_ERROR_TEXT}" data-ajax-error-text-abort="{L_AJAX_ERROR_TEXT_ABORT}" data-ajax-error-text-timeout="{L_AJAX_ERROR_TEXT_TIMEOUT}" data-ajax-error-text-parsererror="{L_AJAX_ERROR_TEXT_PARSERERROR}">

<div id="darken">&nbsp;</div>

<div id="tabs">

<ul>

<!-- BEGIN t_block1 -->

<!-- END t_block1 -->

</ul>

</div>

<ul>

<!-- BEGIN pagination -->

<!-- IF pagination.S_IS_PREV --><li><a href="{pagination.PAGE_URL}">{L_PREVIOUS}</a></li>

// define a couple constants for keydown functions.

var keymap = {

ENTER: 13,

ESC: 27

};

}

};

phpbb.ajaxCallbacks = {};

/**

var key = event.keyCode || event.which;

// intercept tabs

!event.metaKey) {

if (inTag()) {

appendText("\t");

}

// intercept new line characters

if (inTag()) {

var lastLine = getLastLine(true),

code = '' + /^\s*/g.exec(lastLine);

};

/**

*/

});

// Hide active dropdowns when click event happens outside

$(phpbb.dropdownHandles).each(phpbb.toggleDropdown);

}

});

$('#color_palette_placeholder').each(function() {

phpbb.registerPalette($(this));

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

arguments:

- @auth

- @config

- @dbal.conn

- @user

- %core.root_path%

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

<?php

/**

*

*/

/**

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

{

$version_helper = new \phpbb\version_helper($this->cache, $this->config, $this->user);

$version_helper->set_current_version($meta['version']);

$version_helper->force_stability($this->config['extension_force_unstable'] ? 'unstable' : null);

return $updates = $version_helper->get_suggested_updates($force_update, $force_cache);

{

case 'sqlite':

case 'sqlite3':

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

break;

$this->tpl_name = 'acp_jabber';

$this->page_title = 'ACP_JABBER_SETTINGS';

$form_name = 'acp_jabber';

add_form_key($form_name);

{

case 'sqlite':

case 'sqlite3':

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

break;

{

case 'sqlite':

case 'sqlite3':

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

break;

}

}

// Go through the screens/options needed and present them in correct order

foreach ($permission_victim as $victim)

{

// If there are more than 5 forums selected the admin is not able to select all users/groups too.

// We need to see if the number of forums can be increased or need to be decreased.

$template->assign_vars(array(

'U_ACTION' => $this->u_action,

'ANONYMOUS_USER_ID' => ANONYMOUS,

return;

}

// Do not allow forum_ids being set and no other setting defined (will bog down the server too much)

if (sizeof($forum_id) && !sizeof($user_id) && !sizeof($group_id))

{

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

}

}

// Remove current auth options...

foreach ($auth as $auth_option => $auth_setting)

{

$auth_option_ids[] = (int) $this->acl_options['id'][$auth_option];

<?php

/**

*

*

*/

*/

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

static $static_class;

static $magic_url_match_args;

{

$static_class = $class;

$class = ($static_class) ? ' class="' . $static_class . '"' : '';

$local_class = ($static_class) ? ' class="' . $static_class . '-local"' : '';

// relative urls for this board

'#(^|[\n\t (>.])(' . preg_quote($server_url, '#') . ')/(' . get_preg_expression('relative_url_inline') . ')#i',

MAGIC_URL_LOCAL,

$local_class,

);

// matches a xxxx://aaaaa.bbb.cccc. ...

'#(^|[\n\t (>.])(' . get_preg_expression('url_inline') . ')#i',

MAGIC_URL_FULL,

$class,

);

// matches a "www.xxxx.yyyy[/zzzz]" kinda lazy URL thing

'#(^|[\n\t (>])(' . get_preg_expression('www_url_inline') . ')#i',

MAGIC_URL_WWW,

$class,

);

// matches an email@domain type address at the start of a line, or after a space or after what might be a BBCode.

'/(^|[\n\t (>])(' . get_preg_expression('email') . ')/i',

MAGIC_URL_EMAIL,

'',

);

}

{

if (preg_match($magic_args[0], $text, $matches))

{

{

$bigger = ($remote_avatar_cache[$src][0] > $remote_avatar_cache[$src][1]) ? 0 : 1;

$ratio = $default[$bigger] / $remote_avatar_cache[$src][$bigger];

}

}

{

$var = (empty($m[2]) || empty($convert_config[$m[2]])) ? "''" : "'" . addslashes($convert_config[$m[2]]) . "'";

$exec = '$config_value = ' . $m[1] . '(' . $var . ');';

eval($exec);

}

else

{

{

case 'sqlite':

case 'sqlite3':

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

break;

$message = preg_replace('#\[size=([0-9]+)\](.*?)\[/size\]#i', '[size=\1]\2[/size]', $message);

$message = preg_replace('#\[size=[0-9]{2,}\](.*?)\[/size\]#i', '[size=29]\1[/size]', $message);

{

$i--;

$message = str_replace('[size=' . $i . ']', '[size=' . $size[$i] . ']', $message);

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

);

$is_auth = false;

eval('$is_auth = (int) (' . $module_auth . ');');

return $is_auth;

}

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;

}

else

{

$ban_other = explode('-', $ban_len_other);

(strlen($ban_other[0]) == 4) && (strlen($ban_other[1]) == 2) && (strlen($ban_other[2]) == 2))

{

$ban_end = max($current_time, $user->create_datetime()

// Check if the users avatar is actually *not* a group avatar

if ($mode == 'user')

{

{

return false;

}

{

global $config, $db, $phpbb_root_path;

$ext = substr(strrchr($old_entry, '.'), 1);

$old_filename = get_avatar_filename($old_entry);

$new_filename = $config['avatar_salt'] . "_g$group_id.$ext";

$sql = 'SELECT *

FROM ' . GROUPS_TABLE . '

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

if (!$row = $db->sql_fetchrow($result))

{

$sql = 'SELECT *

FROM ' . GROUPS_TABLE . '

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

if (!$row = $db->sql_fetchrow($result))

{

$sql = 'UPDATE ' . USERS_TABLE . '

SET user_rank = 0

AND user_rank <> 0

AND ' . $db->sql_in_set('user_id', $user_ids);

$db->sql_query($sql);

}

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();

{

$topics_moved++;

}

{

$topics_moved_unapproved++;

}

{

$topics_moved_softdeleted++;

}

'topic_last_poster_id' => (int) $row['topic_last_poster_id'],

'topic_last_poster_colour'=>(string) $row['topic_last_poster_colour'],

'topic_last_poster_name'=> (string) $row['topic_last_poster_name'],

'topic_last_post_time' => (int) $row['topic_last_post_time'],

'topic_last_view_time' => (int) $row['topic_last_view_time'],

'topic_moved_id' => (int) $row['topic_id'],

{

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

}

{

$redirect = request_var('redirect', build_url(array('mode', 'r', 'quickmod')) . '&amp;mode=reports');

}

{

$redirect = request_var('redirect', build_url(array('mode', 'r', 'quickmod')) . '&amp;mode=pm_reports');

}