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

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

'legend2' => $l_legend_cat_images,

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

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

'ATTACHMENT_POSTER' => get_username_string('full', (int) $row['poster_id'], (string) $row['username'], (string) $row['user_colour'], (string) $row['username']),

'FILESIZE' => get_formatted_filesize((int) $row['filesize']),

'FILETIME' => $user->format_date((int) $row['filetime']),

'PHYSICAL_FILENAME' => utf8_basename((string) $row['physical_filename']),

'EXT_GROUP_NAME' => (!empty($extensions[$row['extension']]['group_name'])) ? $user->lang['EXT_GROUP_' . $extensions[$row['extension']]['group_name']] : '',

'COMMENT' => $comment,

/**

* Set config attachment stat values

*

* @return null

*/

public function set_attachment_stats($stats)

/**

* Check accuracy of attachment statistics.

*

* @return bool|string Returns false if stats are correct or error message

* otherwise.

*/

// Get current files stats

$num_files = (int) $this->config['num_files'];

if (($num_files != $stats['num_files']) || ($total_size != $stats['upload_dir_size']))

{

'L_NO_BAN_CELL' => $l_no_ban_cell,

'S_USERNAME_BAN' => ($mode == 'user') ? true : false,

'U_ACTION' => $this->u_action,

'U_FIND_USERNAME' => append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=searchuser&form=acp_ban&field=ban'),

));

case 'create':

$sql_ary = $hidden_fields = array();

/**

* Modify custom bbcode data before the modify/create action

*

* submitting form when $warn_text is true

* @since 3.1.0-a3

*/

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

$warn_text = preg_match('%<[^>]*\{text[\d]*\}[^>]*>%i', $bbcode_tpl);

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

}

if (strlen($bbcode_helpline) > 255)

{

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

$db->sql_query('DELETE FROM ' . BBCODES_TABLE . " WHERE bbcode_id = $bbcode_id");

$cache->destroy('sql', BBCODES_TABLE);

add_log('admin', 'LOG_BBCODE_DELETE', $row['bbcode_tag']);

if ($request->is_ajax())

{

$json_response = new \phpbb\json_response;

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

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

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

'legend3' => 'CUSTOM_PROFILE_FIELDS',

'load_cpf_memberlist' => array('lang' => 'LOAD_CPF_MEMBERLIST', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => false),

'email_function_name' => array('lang' => 'EMAIL_FUNCTION_NAME', 'validate' => 'string', 'type' => 'text:20:50', 'explain' => true),

'email_package_size' => array('lang' => 'EMAIL_PACKAGE_SIZE', 'validate' => 'int:0', 'type' => 'number:0:99999', 'explain' => true),

'board_contact' => array('lang' => 'CONTACT_EMAIL', 'validate' => 'email', 'type' => 'email:25:100', 'explain' => true),

'board_email' => array('lang' => 'ADMIN_EMAIL', 'validate' => 'email', 'type' => 'email:25:100', 'explain' => true),

'board_email_sig' => array('lang' => 'EMAIL_SIG', 'validate' => 'string', 'type' => 'textarea:5:30', 'explain' => true),

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

{

$error[] = $user->lang['ERR_BOT_NO_MATCHES'];

}

if ($bot_row['bot_ip'] && !preg_match('#^[\d\.,:]+$#', $bot_row['bot_ip']))

{

if (!$ip_list = gethostbynamel($bot_row['bot_ip']))

{

$error[] = $user->lang['ERR_BOT_AGENT_MATCHES_UA'];

}

$bot_name = false;

if ($bot_id)

{

{

$error[] = $user->lang['BOT_NAME_TAKEN'];

}

if (!sizeof($error))

{

// New bot? Create a new user and group entry

{

trigger_error($user->lang['NO_BOT_GROUP'] . adm_back_link($this->u_action . "&amp;id=$bot_id&amp;action=$action"), E_USER_WARNING);

}

$user_id = user_add(array(

'user_type' => (int) USER_IGNORE,

'user_style' => (int) $bot_row['bot_style'],

'user_allow_massemail' => 0,

));

$sql = 'INSERT INTO ' . BOTS_TABLE . ' ' . $db->sql_build_array('INSERT', array(

'user_id' => (int) $user_id,

'bot_name' => (string) $bot_row['bot_name'],

'bot_ip' => (string) $bot_row['bot_ip'])

);

$db->sql_query($sql);

$log = 'ADDED';

}

else if ($bot_id)

$log = 'UPDATED';

}

$cache->destroy('_bots');

add_log('admin', 'LOG_BOT_' . $log, $bot_row['bot_name']);

trigger_error($user->lang['BOT_' . $log] . adm_back_link($this->u_action));

}

}

else if ($bot_id)

'U_ACTION' => $this->u_action . "&amp;id=$bot_id&amp;action=$action",

'U_BACK' => $this->u_action,

'ERROR_MSG' => (sizeof($error)) ? implode('<br />', $error) : '',

'BOT_NAME' => $bot_row['bot_name'],

'BOT_IP' => $bot_row['bot_ip'],

'BOT_AGENT' => $bot_row['bot_agent'],

'S_EDIT_BOT' => true,

'S_ACTIVE_OPTIONS' => $s_active_options,

'S_STYLE_OPTIONS' => $style_select,

break;

}

if ($request->is_ajax() && ($action == 'activate' || $action == 'deactivate'))

{

$json_response = new \phpbb\json_response;

}

$db->sql_freeresult($result);

}

/**

* Validate bot name against username table

*/

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

$row = $db->sql_fetchrow($result);

$db->sql_freeresult($result);

return ($row) ? false : true;

}

}

$selected = (isset($captchas['available'][$selected]) || isset($captchas['unavailable'][$selected])) ? $selected : $config['captcha_plugin'];

$configure = request_var('configure', false);

// Oh, they are just here for the view

if (isset($_GET['captcha_demo']))

{

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

break;

case 'postgres':

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

break;

switch ($db->sql_layer)

{

case 'sqlite':

case 'firebird':

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

break;

case 'mysql4':

case 'mysqli':

case 'sqlite':

while (($sql = $fgetd($fp, ";\n", $read, $seek, $eof)) !== false)

{

$db->sql_query($sql);

/**

* @package acp

*/

class postgres_extractor extends base_extractor

{

function write_start($prefix)

}

$db->sql_freeresult($result);

// Get the listing of primary keys.

$sql_pri_keys = "SELECT ic.relname as index_name, bc.relname as tab_name, ta.attname as column_name, i.indisunique as unique_key, i.indisprimary as primary_key

FROM pg_class bc, pg_class ic, pg_index i, pg_attribute ta, pg_attribute ia

$ary_type[] = pg_field_type($result, $i);

$ary_name[] = pg_field_name($result, $i);

$sql = "SELECT pg_get_expr(d.adbin, d.adrelid) as rowdefault

FROM pg_attrdef d, pg_class c

WHERE (c.relname = '{$table_name}')

public function list_enabled_exts(\phpbb\extension\manager $phpbb_extension_manager)

{

$enabled_extension_meta_data = array();

foreach ($phpbb_extension_manager->all_enabled() as $name => $location)

{

$md_manager = $phpbb_extension_manager->create_extension_metadata_manager($name, $this->template);

public function list_disabled_exts(\phpbb\extension\manager $phpbb_extension_manager)

{

$disabled_extension_meta_data = array();

foreach ($phpbb_extension_manager->all_disabled() as $name => $location)

{

$md_manager = $phpbb_extension_manager->create_extension_metadata_manager($name, $this->template);

$uninstalled = array_diff_key($phpbb_extension_manager->all_available(), $phpbb_extension_manager->all_configured());

$available_extension_meta_data = array();

foreach ($uninstalled as $name => $location)

{

$md_manager = $phpbb_extension_manager->create_extension_metadata_manager($name, $this->template);

* @event core.acp_manage_forums_request_data

* @var string action Type of the action: add|edit

* @var array forum_data Array with new forum data

*/

$vars = array('action', 'forum_data');

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

* empty when creating new forum

* @var array forum_data Array with new forum data

* @var string parents_list List of parent options

*/

$vars = array('action', 'update', 'forum_id', 'row', 'forum_data', 'parents_list');

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

* ensure to update the template variables

* S_ERROR and ERROR_MSG to display it

* @var array template_data Array with new forum data

*/

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

$template->assign_vars($template_data);

* @var array forum_data Array with new forum data

* @var array errors Array of errors, should be strings and not

* language key.

*/

$vars = array('forum_data', 'errors');

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

* @var array forum_data_sql Array with data we are going to update

* If forum_data_sql[forum_id] is set, we update

* that forum, otherwise a new one is created.

*/

$vars = array('forum_data', 'forum_data_sql');

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

* ensure to set forum_data_sql[forum_id]

* @var array errors Array of errors, should be strings and not

* language key.

*/

$vars = array('forum_data', 'forum_data_sql', 'is_new_forum', 'errors');

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

* @var int to_id If of the new parent forum

* @var array errors Array of errors, should be strings and not

* language key.

*/

$vars = array('from_id', 'to_id', 'errors');

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

* @var array errors Array of errors, should be strings and not

* language key. If this array is not empty,

* The content will not be moved.

*/

$vars = array('from_id', 'to_id', 'sync', 'errors');

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

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

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

// Clear some vars

$group_row = array();

if (confirm_box(true))

{

$group_name = ($group_row['group_type'] == GROUP_SPECIAL) ? $user->lang['G_' . $group_row['group_name']] : $group_row['group_name'];

trigger_error($user->lang['GROUP_DEFS_UPDATED'] . adm_back_link($this->u_action . '&amp;action=list&amp;g=' . $group_id));

}

else

}

}

// Did we submit?

if ($update)

{

unset($_images[$row[$fields . '_url']]);

}

if ($row[$fields . '_id'] == $icon_id)

{

$after = true;

switch ($db->sql_layer)

{

case 'sqlite':

case 'firebird':

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

break;

$cache->destroy('_icons');

$cache->destroy('sql', $table);

if ($request->is_ajax())

{

$json_response = new \phpbb\json_response;

if ($mode == 'mod')

{

$forum_box = '<option value="0">' . $user->lang['ALL_FORUMS'] . '</option>' . make_forum_select($forum_id);

$template->assign_vars(array(

'S_SHOW_FORUMS' => true,

'S_FORUM_BOX' => $forum_box)

foreach ($log_data as $row)

{

$data = array();

$checks = array('viewtopic', 'viewlogs', 'viewforum');

foreach ($checks as $check)

{

switch ($db->sql_layer)

{

case 'sqlite':

case 'firebird':

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

break;

switch ($db->sql_layer)

{

case 'sqlite':

case 'firebird':

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

break;

case 'edit':

if ($action == 'edit')

$sql = 'SELECT *

FROM ' . ACL_ROLES_TABLE . '

WHERE role_id = ' . $role_id;

}

}

// Setting permissions screen

$s_hidden_fields = build_hidden_fields(array(

'user_id' => $user_id,

$template->assign_var('PHPINFO', $output);

}

function remove_spaces($matches)

{

return '<a name="' . str_replace(' ', '_', $matches[1]) . '">';

switch ($db->sql_layer)

{

case 'sqlite':

$sql = "SELECT sql

FROM sqlite_master

WHERE type = 'table'

}

$db->sql_freeresult($result);

$sql = 'SELECT lang_id, lang_name, lang_explain, lang_default_value

FROM ' . PROFILE_LANG_TABLE . '

WHERE lang_id <> ' . $this->edit_lang_id . "

}

}

$db->sql_transaction('begin');

if ($action == 'create')

break;

case 'sqlite':

{

$sql = "SELECT sql

FROM sqlite_master

$prune_posted = request_var('prune_days', 0);

$prune_viewed = request_var('prune_vieweddays', 0);

$prune_all = (!$prune_posted && !$prune_viewed) ? true : false;

$prune_flags = 0;

$prune_flags += (request_var('prune_old_polls', 0)) ? 2 : 0;

$prune_flags += (request_var('prune_announce', 0)) ? 4 : 0;

$p_result['topics'] = 0;

$p_result['posts'] = 0;

$log_data = '';

do

{

if (!$auth->acl_get('f_list', $row['forum_id']))

$p_result['topics'] += $return['topics'];

$p_result['posts'] += $return['posts'];

}

if ($prune_viewed)

{

$return = prune($row['forum_id'], 'viewed', $prunedate_viewed, $prune_flags, false);

'NUM_TOPICS' => $p_result['topics'],

'NUM_POSTS' => $p_result['posts'])

);

$log_data .= (($log_data != '') ? ', ' : '') . $row['forum_name'];

}

while ($row = $db->sql_fetchrow($result));

// Sync all pruned forums at once

sync('forum', 'forum_id', $prune_ids, true, true);

add_log('admin', 'LOG_PRUNE', $log_data);

if ($deleteposts)

{

user_delete('remove', $user_ids);

$l_log = 'LOG_PRUNE_USER_DEL_DEL';

}

else

if (sizeof($active) && (int) $active[0] == 0 && (int) $active[1] == 0 && (int) $active[2] == 0)

{

$where_sql .= ' AND user_lastvisit = 0';

else if (sizeof($active) && $active_select != 'lt')

{

$where_sql .= ' AND user_lastvisit ' . $key_match[$active_select] . ' ' . gmmktime(0, 0, 0, (int) $active[1], (int) $active[2], (int) $active[0]);

WHERE u.user_id <> ' . ANONYMOUS . '

AND u.user_type <> ' . USER_FOUNDER .

((!empty($user_ids)) ? 'AND ' . $db->sql_in_set('p.poster_id', $user_ids) : '') . '

AND u.user_id = p.poster_id

GROUP BY p.poster_id

HAVING queue_posts ' . $key_match[$queue_select] . ' ' . $posts_on_queue;

'MIN_POSTS' => (isset($ranks['rank_min']) && !$ranks['rank_special']) ? $ranks['rank_min'] : 0)

);

return;

break;

case 'oracle':

case 'firebird':

case 'sqlite':

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

$sql = 'UPDATE ' . REPORTS_TABLE . '

SET reason_id = ' . $other_reason_id . ", report_text = '" . $db->sql_escape($reason_row['reason_description']) . "\n\n' || report_text

{

if ($topic_id_ary[$row['topic_id']][ITEM_APPROVED] == $row['topic_posts_approved']

&& $topic_id_ary[$row['topic_id']][ITEM_UNAPPROVED] == $row['topic_posts_unapproved']

&& $topic_id_ary[$row['topic_id']][ITEM_DELETED] == $row['topic_posts_softdeleted'])

{

$move_topic_ary[] = $row['topic_id'];

sync('forum', 'forum_id', $forum_id_ary, false, true);

}

add_log('admin', 'LOG_USER_MOVE_POSTS', $user_row['username'], $forum_info['forum_name']);

add_log('user', $user_id, 'LOG_USER_MOVE_POSTS_USER', $forum_info['forum_name']);

* @event core.acp_users_overview_run_quicktool

* @var array user_row Current user data

* @var string action Quick tool that should be run

*/

$vars = array('action', 'user_row');

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

* @var array user_row Current user data

* @var array data Submitted user data

* @var array sql_ary User data we udpate

*/

$vars = array('user_row', 'data', 'sql_ary');

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

* @event core.acp_users_display_overview

* @var array user_row Array with user data

* @var array quick_tool_ary Ouick tool options

*/

$vars = array('user_row', 'quick_tool_ary');

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

$sql = 'SELECT COUNT(post_id) as posts_in_queue

FROM ' . POSTS_TABLE . '

WHERE poster_id = ' . $user_id . '

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

$user_row['posts_in_queue'] = (int) $db->sql_fetchfield('posts_in_queue');

$db->sql_freeresult($result);

}

}

$template->assign_block_vars('warn', array(

'ID' => $row['warning_id'],

'USERNAME' => ($row['log_operation']) ? get_username_string('full', $row['mod_user_id'], $row['mod_username'], $row['mod_user_colour']) : '-',

$data['bday_year'] = request_var('bday_year', $data['bday_year']);

$data['user_birthday'] = sprintf('%2d-%2d-%4d', $data['bday_day'], $data['bday_month'], $data['bday_year']);

if ($submit)

{

$error = validate_data($data, array(

'notify' => request_var('notify', $user_row['user_notify']),

);

if ($submit)

{

$error = validate_data($data, array(

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

);

{

{

}

}

// Replace "error" strings with their real, localised form

}

$timezone_selects = phpbb_timezone_select($user, $data['tz'], true);

'S_PREFS' => true,

'S_JABBER_DISABLED' => ($config['jab_enable'] && $user_row['user_jabber'] && @extension_loaded('xml')) ? false : true,

'S_STYLE_OPTIONS' => style_select($data['style']),

'S_TZ_OPTIONS' => $timezone_selects['tz_select'],

'S_TZ_DATE_OPTIONS' => $timezone_selects['tz_dates'],

);

break;

case 'avatar':

$error = array();

}

$sql = 'SELECT ug.*, g.*

FROM ' . GROUPS_TABLE . ' g, ' . USER_GROUP_TABLE . " ug

WHERE ug.user_id = $user_id

'word' => $word,

'replacement' => $replacement

);

if ($word_id)

{

$db->sql_query('UPDATE ' . WORDS_TABLE . ' SET ' . $db->sql_build_array('UPDATE', $sql_ary) . ' WHERE word_id = ' . $word_id);

break;

}

$template->assign_vars(array(

'U_ACTION' => $this->u_action,

'S_HIDDEN_FIELDS' => $s_hidden_fields)

$auth2 = &$auth;

}

$hold_ary[$userdata['user_id']] = array();

foreach ($forum_ids as $f_id)

{

function execute($code, $seed)

{

global $config;

mt_srand($seed);

// Create image

function wave($img)

{

global $config;

$period_x = mt_rand(12,18);

$period_y = mt_rand(7,14);

$amp_x = mt_rand(5,10);

$socket = mt_rand(0,100);

$dampen_x = mt_rand($this->width/5, $this->width/2);

$dampen_y = mt_rand($this->height/5, $this->height/2);

$direction_x = (mt_rand (0, 1));

}

return $img;

}

/**

* Noise line

*/

}

function captcha_noise_bg_bitmaps()

return array(

'width' => 15,

'height' => 5,

function captcha_bitmaps()

{

global $config;

$chars = array(

'A' => array(

array(

'J' => $chars['J'][mt_rand(0, min(sizeof($chars['J']), $config['captcha_gd_fonts']) -1)],

'K' => $chars['K'][mt_rand(0, min(sizeof($chars['K']), $config['captcha_gd_fonts']) -1)],

'L' => $chars['L'][mt_rand(0, min(sizeof($chars['L']), $config['captcha_gd_fonts']) -1)],

'N' => $chars['N'][mt_rand(0, min(sizeof($chars['N']), $config['captcha_gd_fonts']) -1)],

'O' => $chars['O'][mt_rand(0, min(sizeof($chars['O']), $config['captcha_gd_fonts']) -1)],

'P' => $chars['P'][mt_rand(0, min(sizeof($chars['P']), $config['captcha_gd_fonts']) -1)],

{

$mode = $this->mode;

}

if (!is_array($colour))

{

if (isset($this->named_rgb[$colour]))

$colour3[0] += 180;

$colour4[0] += 210;

$results[] = $this->allocate($colour2, $mode);

$results[] = $this->allocate($colour3, $mode);

$results[] = $this->allocate($colour4, $mode);

}

// This is a hard problem. I chicken out and try to maintain readability at the cost of less randomness.

while ($count > 0)

{

$colour[1] = ($colour[1] + mt_rand(40,60)) % 99;

*/

// phpBB Version

// QA-related

// define('PHPBB_QA', 1);

define('USER_IGNORE', 2);

define('USER_FOUNDER', 3);

// ACL

define('ACL_NEVER', 0);

define('ITEM_UNAPPROVED', 0); // => has not yet been approved

define('ITEM_APPROVED', 1); // => has been approved, and has not been soft deleted

define('ITEM_DELETED', 2); // => has been soft deleted

// Forum Flags

define('FORUM_FLAG_LINK_TRACK', 1);

* the global one (false)

* @var bool|string append_sid_overwrite Overwrite function (string

* URL) or not (false)

*/

$vars = array('url', 'params', 'is_amp', 'session_id', 'append_sid_overwrite');

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

*/

function build_url($strip_vars = false)

{

$page = $user->page['page'];

// We need to be cautious here.

if ($url_parts === false || empty($url_parts['scheme']) || empty($url_parts['host']))

{

// Remove 'app.php/' from the page, when rewrite is enabled

{

}

}

// Append SID

$redirect = append_sid($page, false, false);

{

}

{

}

}

/**

WHERE user_id = " . $user->data['user_id'];

$db->sql_query($sql);

if ($request->is_ajax())

{

$u_action .= '&confirm_uid=' . $user->data['user_id'] . '&sess=' . $user->session_id . '&sid=' . $user->session_id;

// Get number of online guests

{

$sql = 'SELECT COUNT(session_ip) as num_guests

FROM (

* @var int item_id Restrict online users to item id

* @var bool page_header_override Shall we return instead of running

* the rest of page_header()

*/

$vars = array('page_title', 'display_online_list', 'item_id', 'item', 'page_header_override');

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

}

}

$notification_mark_hash = generate_link_hash('mark_all_notifications_read');

// The following assigns all _common_ variables that may be used at any point in a template.

$template->assign_vars(array(

'SITENAME' => $config['sitename'],

'SITE_DESCRIPTION' => $config['site_desc'],

'PAGE_TITLE' => $page_title,

'TOTAL_USERS_ONLINE' => $l_online_users,

'LOGGED_IN_USER_LIST' => $online_userlist,

'RECORD_USERS' => $l_online_record,

'UNREAD_NOTIFICATIONS_COUNT' => ($notifications !== false) ? $notifications['unread_count'] : '',

'NOTIFICATIONS_COUNT' => ($notifications !== false) ? $notifications['unread_count'] : '',

'U_VIEW_ALL_NOTIFICATIONS' => append_sid("{$phpbb_root_path}ucp.$phpEx", 'i=ucp_notifications'),

'SESSION_ID' => $user->session_id,

'ROOT_PATH' => $web_path,

'BOARD_URL' => $board_url,

'L_LOGIN_LOGOUT' => $l_login_logout,

'L_INDEX' => ($config['board_index_text'] !== '') ? $config['board_index_text'] : $user->lang['FORUM_INDEX'],

* @var bool run_cron Shall we run cron tasks

* @var bool page_footer_override Shall we return instead of running

* the rest of page_footer()

*/

$vars = array('run_cron', 'page_footer_override');

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

* Unload some objects, to free some memory, before we finish our task

*

* @event core.garbage_collection

*/

$phpbb_dispatcher->dispatch('core.garbage_collection');

}

* @var string page_title Page title

* @var bool adm_page_header_override Shall we return instead of

* running the rest of adm_page_header()

*/

$vars = array('page_title', 'adm_page_header_override');

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

* @var bool copyright_html Shall we display the copyright?

* @var bool adm_page_footer_override Shall we return instead of

* running the rest of adm_page_footer()

*/

$vars = array('copyright_html', 'adm_page_footer_override');

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

* @var string name Should be used for the name attribute

* @var array vars Array with the options for the config

* @var string tpl The resulting html code we display

*/

$vars = array('tpl_type', 'key', 'new', 'name', 'vars', 'tpl');

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

* @var array error Array of errors, the errors should

* be strings only, language keys are

* not replaced afterwards

*/

$vars = array('cfg_array', 'config_name', 'config_definition', 'error');

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

// Notifications types to delete

$delete_notifications_types = array(

'quote',

'approve_post',

'post_in_queue',

);

* Perform additional actions before post(s) deletion

*

* @event core.delete_posts_before

* @var mixed where_ids Array or comma separated list of posts ids to delete

* @var bool auto_sync Flag indicating if topics/forums should be synchronized

* @var bool posted_sync Flag indicating if topics_posted table should be resynchronized

* @var array delete_notifications_types Array with notifications types to delete

* @since 3.1.0-a4

*/

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

if ($where_type === 'range')

* @var array poster_ids Array with deleted posts' author ids

* @var array topic_ids Array with deleted posts' topic ids

* @var array forum_ids Array with deleted posts' forum ids

* @var mixed where_ids Array or comma separated list of posts ids to delete

* @var array delete_notifications_types Array with notifications types to delete

* @since 3.1.0-a4

*/

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

$db->sql_transaction('commit');

* @var array poster_ids Array with deleted posts' author ids

* @var array topic_ids Array with deleted posts' topic ids

* @var array forum_ids Array with deleted posts' forum ids

* @var mixed where_ids Array or comma separated list of posts ids to delete

* @var array delete_notifications_types Array with notifications types to delete

* @since 3.1.0-a4

*/

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

// Resync topics_posted table

ITEM_DELETED => (!empty($topics_softdeleted)) ? ' WHERE ' . $db->sql_in_set('topic_id', $topics_softdeleted) : '',

);

{

if ($sql_where)

{

{

$forum_data[$forum_id]['topics_approved'] = $row['total_topics'];

}

{

$forum_data[$forum_id]['topics_unapproved'] = $row['total_topics'];

}

{

$topic_data[$topic_id]['posts_approved'] = $row['total_posts'];

}

{

$topic_data[$topic_id]['posts_unapproved'] = $row['total_posts'];

}

$topic_data[$topic_id]['first_post_id'] = (!empty($topic_data[$topic_id]['first_post_id'])) ? min($topic_data[$topic_id]['first_post_id'], $row['first_post_id']) : $row['first_post_id'];

$topic_data[$topic_id]['last_post_id'] = max($topic_data[$topic_id]['last_post_id'], $row['last_post_id']);

{

// Soft delete status is stronger than unapproved.

$topic_data[$topic_id]['visibility'] = $row['post_visibility'];

switch ($db->sql_layer)

{

case 'sqlite':

case 'firebird':

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

break;

break;

case 'sqlite':

global $dbhost;

if (file_exists($dbhost))

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

$row = $db->sql_fetchrow($result);

$db->sql_freeresult($result);

$sql = 'SELECT ((SUM(size) * 8.0) * 1024.0) as dbsize

FROM sysfiles';

// Azure stats are stored elsewhere

if (strpos($row['mssql_version'], 'SQL Azure') !== false)

{

FROM sys.dm_db_partition_stats';

}

}

*/

function make_jumpbox($action, $forum_id = false, $select_all = false, $acl_list = false, $force_display = false)

{

// We only return if the jumpbox is not forced to be displayed (in case it is needed for functionality)

if (!$config['load_jumpbox'] && $force_display === false)

$db->sql_freeresult($result);

unset($padding_store);

$template->assign_vars(array(

return;

}

* @var string bitfield The BBCode Bitfield

* @var int flags The BBCode Flags

* @var bool censor_text Whether or not to apply word censors

*/

$vars = array('text', 'uid', 'bitfield', 'flags', 'censor_text');

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

if ($censor_text)

$text = censor_text($text);

}

* @var string uid The BBCode UID

* @var string bitfield The BBCode Bitfield

* @var int flags The BBCode Flags

*/

$vars = array('text', 'uid', 'bitfield', 'flags');

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

* For parsing custom parsed text to be stored within the database.

* This function additionally returns the uid and bitfield that needs to be stored.

* Expects $text to be the value directly from request_var() and in it's non-parsed form

* @param string $text The text to be replaced with the parsed one

* @param string $uid The BBCode uid for this parse

* @param string $bitfield The BBCode bitfield for this parse

* @var bool allow_bbcode Whether or not to parse BBCode

* @var bool allow_urls Whether or not to parse URLs

* @var bool allow_smilies Whether or not to parse Smilies

*/

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

$uid = $bitfield = '';

* @var string uid The BBCode UID

* @var string bitfield The BBCode Bitfield

* @var int flags The BBCode Flags

*/

$vars = array('text', 'uid', 'bitfield', 'flags');

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

* @var string text The text to parse

* @var string uid The BBCode UID

* @var int flags The BBCode Flags

*/

$vars = array('text', 'uid', 'flags');

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

* @event core.modify_text_for_edit_after

* @var string text The text to parse

* @var int flags The BBCode Flags

*/

$vars = array('text', 'flags');

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

{

$username_string = str_replace(array('{PROFILE_URL}', '{USERNAME_COLOUR}', '{USERNAME}'), array($profile_url, $username_colour, $username), (!$username_colour) ? $_profile_cache['tpl_profile'] : $_profile_cache['tpl_profile_colour']);

}

/**

* Use this event to change the output of get_username_string()

*

* profile url.

* @var string username_string The string that has been generated

* @var array _profile_cache Array of original return templates

*/

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

return $username_string;

case 'mssql':

case 'sqlite':

case 'mssqlnative':

$sql = implode(' UNION ALL ', preg_replace('#^(.*?)$#', 'SELECT \1', $sql_subary));

break;

switch ($db->sql_layer)

{

case 'sqlite':

case 'firebird':

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

break;

*

* @event core.display_forums_modify_sql

* @var array sql_ary The SQL array to get the data of the forums

*/

$vars = array('sql_ary');

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

* @event core.display_forums_modify_row

* @var int branch_root_id Last top-level forum

* @var array row The data of the forum

*/

$vars = array('branch_root_id', 'row');

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

* @var int branch_root_id Current top-level forum

* @var int parent_id Current parent forum

* @var array row The data of the forum

*/

$vars = array('forum_rows', 'subforums', 'branch_root_id', 'parent_id', 'row');

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

* @event core.display_forums_modify_template_vars

* @var array forum_row Template data of the forum

* @var array row The data of the forum

*/

$vars = array('forum_row', 'row');

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

$folder_new .= '_locked';

}

$folder_img = ($unread_topic) ? $folder_new : $folder;

$folder_alt = ($unread_topic) ? 'UNREAD_POSTS' : (($topic_row['topic_status'] == ITEM_LOCKED) ? 'TOPIC_LOCKED' : 'NO_UNREAD_POSTS');

* @event core.display_custom_bbcodes_modify_row

* @var array custom_tags Template data of the bbcode

* @var array row The data of the bbcode

*/

$vars = array('custom_tags', 'row');

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

* Display custom bbcodes

*

* @event core.display_custom_bbcodes

*/

$phpbb_dispatcher->dispatch('core.display_custom_bbcodes');

}

'AVAILABLE' => true,

'2.0.x' => false,

),

);

if ($dbms)

$db->sql_return_on_error(true);

// Check that we actually have a database name before going any further.....

{

$error[] = $lang['INST_ERR_DB_NO_NAME'];

return false;

}

// Make sure we don't have a daft user who thinks having the SQLite database in the forum directory is a good idea

{

$error[] = $lang['INST_ERR_DB_FORUM_PATH'];

return false;

break;

case 'phpbb\db\driver\sqlite':

$prefix_length = 200;

break;

}

break;

case 'phpbb\db\driver\firebird':

// check the version of FB, use some hackery if we can't get access to the server info

if ($db->service_handle !== false && function_exists('ibase_server_info'))

$use_queue = true;

}

if (empty($this->replyto))

{

}

if (empty($this->from))

{

}

$encode_eol = ($config['smtp_delivery']) ? "\r\n" : $this->eol;

* @var string module_auth The module_auth of the current

* module

* @var int forum_id The current forum_id

*/

$vars = array('valid_tokens', 'module_auth', 'forum_id');

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

function generate_smilies($mode, $forum_id)

{

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

$base_url = append_sid("{$phpbb_root_path}posting.$phpEx", 'mode=smilies&amp;f=' . $forum_id);

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

if (sizeof($smilies))

{

foreach ($smilies as $row)

{

* @var string mode Mode of the smilies: window|inline

* @var int forum_id The forum ID we are currently in

* @var bool display_link Shall we display the "more smilies" link?

*/

$vars = array('mode', 'forum_id', 'display_link');

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

$ids = array($ids);

}

$update_sql = $empty_forums = $not_empty_forums = array();

if ($type != 'topic')

{

$sql_data[FORUMS_TABLE] .= 'forum_posts_approved = forum_posts_approved - 1, forum_topics_approved = forum_topics_approved - 1';

}

{

$sql_data[FORUMS_TABLE] .= 'forum_posts_unapproved = forum_posts_unapproved - 1, forum_topics_unapproved = forum_topics_unapproved - 1';

}

{

$phpbb_content_visibility->remove_post_from_statistic($data, $sql_data);

}

{

$sql_data[FORUMS_TABLE] = (($sql_data[FORUMS_TABLE]) ? $sql_data[FORUMS_TABLE] . ', ' : '') . 'forum_posts_unapproved = forum_posts_unapproved - 1';

$sql_data[TOPICS_TABLE] = (($sql_data[TOPICS_TABLE]) ? $sql_data[TOPICS_TABLE] . ', ' : '') . 'topic_posts_unapproved = topic_posts_unapproved - 1';

* @var bool update_search_index Flag indicating if the search index will be updated

* @since 3.1.0-a4

*/

// We do not handle erasing posts here

if ($mode == 'delete')

{

// Post not approved, but in queue

$post_visibility = ITEM_UNAPPROVED;

}

// MODs/Extensions are able to force any visibility on posts

if (isset($data['force_approved_state']))

{

}

if (isset($data['force_visibility']))

{

}

// Start the transaction here

$first_post_has_topic_info = ($post_mode == 'edit_first_post' &&

(($post_visibility == ITEM_DELETED && $data['topic_posts_softdeleted'] == 1) ||

($post_visibility == ITEM_UNAPPROVED && $data['topic_posts_unapproved'] == 1) ||

($post_visibility == ITEM_APPROVED && $data['topic_posts_approved'] == 1)));

// Fix the post's and topic's visibility and first/last post information, when the post is edited

if (($post_mode != 'post' && $post_mode != 'reply') && $data['post_visibility'] != $post_visibility)

// If the post was not approved, it could also be the starter,

// so we sync the starter after approving/restoring, to ensure that the stats are correct

// Same applies for the last post

$is_latest = ($post_mode == 'edit_last_post' || $post_mode == 'edit_topic' || $data['post_visibility'] != ITEM_APPROVED);

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

case 'edit_first_post':

case 'edit':

case 'edit_last_post':

break;

}

}

{

switch ($mode)

{

case 'post':

case 'reply':

case 'quote':

// Nothing to do here

break;

case 'edit_topic':

case 'edit_first_post':

case 'edit':

case 'edit_last_post':

break;

}

}

* @var string url The "Return to topic" URL

* @var array data Array of post data about the

* submitted post

*/

$vars = array('url', 'data');

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

break;

}

if (!$result)

{

return false;

/**

* Get all parts of the PM that are to be submited to the DB.

*

* @var string mode PM Post mode - post|reply|quote|quotepost|forward|edit

* @var string subject Subject of the private message

* @var array data The whole row data of the PM.

$decoded_message = bbcode_nl2br($decoded_message);

}

$parse_flags = ($row['bbcode_bitfield'] ? OPTION_FLAG_BBCODE : 0);

$parse_flags |= ($row['enable_smilies'] ? OPTION_FLAG_SMILIES : 0);

$message = generate_text_for_display($message, $row['bbcode_uid'], $row['bbcode_bitfield'], $parse_flags, false);

$subject = censor_text($subject);

class fileupload

{

var $allowed_extensions = array();

var $max_filesize = 0;

var $min_width = 0;

var $min_height = 0;

/**

* Create a new UrlMatcher class and dump it into the cache file

*

* @param RequestContext $context Symfony RequestContext object

* @param string $root_path Root path

* @param string $php_ext PHP extension

* @return null

*/

{

if (defined('DEBUG'))

{

}

if (!phpbb_url_matcher_dumped($root_path, $php_ext))

{

}

return phpbb_load_url_matcher($context, $root_path, $php_ext);

/**

* Create a new UrlMatcher class and dump it into the cache file

*

* @param string $root_path Root path

* @param string $php_ext PHP extension

* @return null

*/

{

$routes = $provider->find($root_path)->get_routes();

$dumper = new PhpMatcherDumper($routes);

$cached_url_matcher_dump = $dumper->dump(array(

/**

* Create a non-cached UrlMatcher

*

* @param RequestContext $context Symfony RequestContext object

* @return UrlMatcher

*/

{

$routes = $provider->find($root_path)->get_routes();

return new UrlMatcher($routes, $context);

}

* @event core.update_username

* @var string old_name The old username that is replaced

* @var string new_name The new username

*/

$vars = array('old_name', 'new_name');

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

*

* @event core.user_add_modify_data

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

*/

$vars = array('sql_ary');

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

* @var array user_ids IDs of the deleted user

* @var mixed retain_username True if username should be retained

* or false if not

*/

$vars = array('mode', 'user_ids', 'retain_username');

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

* @var array user_ids IDs of the deleted user

* @var mixed retain_username True if username should be retained

* or false if not

*/

$vars = array('mode', 'user_ids', 'retain_username');

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

{

$function = array_shift($validate);

array_unshift($validate, $data[$var]);

{

// Since errors are checked later for their language file existence, we need to make sure custom errors are not adjusted.

$error[] = (empty($user->lang[$result . '_' . strtoupper($var)])) ? $result : $result . '_' . strtoupper($var);

{

global $config;

if ($avatar_entry[0] === 'g')

{

$avatar_group = true;

* @event core.delete_group_after

* @var int group_id ID of the deleted group

* @var string group_name Name of the deleted group

*/

$vars = array('group_id', 'group_name');

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

* @var string group_name Name of the group

* @var array user_id_ary IDs of the users which are removed

* @var array username_ary names of the users which are removed

*/

$vars = array('group_id', 'group_name', 'user_id_ary', 'username_ary');

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

* @var array group_attributes Group attributes which were changed

* @var array update_listing Update the list of moderators and foes

* @var array sql_ary User attributes which were changed

*/

$vars = array('group_id', 'user_id_ary', 'group_attributes', 'update_listing', 'sql_ary');

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

*

* @param array $user_ids Array of users' ids to check for banning,

* leave empty to get complete list of banned ids

* @return array Array of banned users' ids if any, empty array otherwise

*/

{

global $db;

$sql = 'SELECT ban_userid

FROM ' . BANLIST_TABLE . "

WHERE $sql_user_ids

OR ban_end = 0)';

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

while ($row = $db->sql_fetchrow($result))

{

'title' => 'MCP_PM_REPORTS',

'version' => '1.0.0',

'modes' => array(

'pm_reports_closed' => array('title' => 'MCP_PM_REPORTS_CLOSED', 'auth' => 'aclf_m_report', 'cat' => array('MCP_REPORTS')),

'pm_report_details' => array('title' => 'MCP_PM_REPORT_DETAILS', 'auth' => 'aclf_m_report', 'cat' => array('MCP_REPORTS')),

),

case 'user':

$pre_fill = (string) $db->sql_fetchfield('username');

break;

case 'ip':

$pre_fill = (string) $db->sql_fetchfield('user_ip');

break;

$topic_title = censor_text($row['topic_title']);

$posts_unapproved = ($row['topic_visibility'] == ITEM_APPROVED && $row['topic_posts_unapproved'] && $auth->acl_get('m_approve', $row['forum_id'])) ? true : false;

$topic_deleted = $row['topic_visibility'] == ITEM_DELETED;

$u_mcp_queue = ($topic_unapproved || $posts_unapproved) ? $url . '&amp;i=queue&amp;mode=' . (($topic_unapproved) ? 'approve_details' : 'unapproved_posts') . '&amp;t=' . $row['topic_id'] : '';

* @event core.mcp_view_forum_modify_topicrow

* @var array row Array with topic data

* @var array topic_row Template array with topic data

*/

$vars = array('row', 'topic_row');

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

$sql = 'SELECT COUNT(post_id) AS total

FROM ' . POSTS_TABLE . '

WHERE ' . $db->sql_in_set('forum_id', $forum_list) . '

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

$total = (int) $db->sql_fetchfield('total');

$db->sql_freeresult($result);

$sql = 'SELECT post_id

FROM ' . POSTS_TABLE . '

WHERE ' . $db->sql_in_set('forum_id', $forum_list) . '

ORDER BY post_time DESC';

$result = $db->sql_query_limit($sql, 5);

{

$topics_moved++;

}

{

$topics_moved_unapproved++;

}

$total_topics++;

break;

case ITEM_UNAPPROVED:

$total_topics_unapproved++;

break;

case ITEM_DELETED:

$total_posts++;

break;

case ITEM_UNAPPROVED:

$total_posts_unapproved++;

break;

case ITEM_DELETED:

'U_MCP_USER_NOTES' => append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=notes&amp;mode=user_notes&amp;u=' . $pm_info['author_id']),

'U_MCP_WARN_REPORTER' => ($auth->acl_get('m_warn')) ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=warn&amp;mode=warn_user&amp;u=' . $report['user_id']) : '',

'U_MCP_WARN_USER' => ($auth->acl_get('m_warn')) ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=warn&amp;mode=warn_user&amp;u=' . $pm_info['author_id']) : '',

'EDIT_IMG' => $user->img('icon_post_edit', $user->lang['EDIT_POST']),

'MINI_POST_IMG' => $user->img('icon_post_target', 'POST'),

$template->assign_vars(array(

'L_EXPLAIN' => ($mode == 'pm_reports') ? $user->lang['MCP_PM_REPORTS_OPEN_EXPLAIN'] : $user->lang['MCP_PM_REPORTS_CLOSED_EXPLAIN'],

'L_TITLE' => ($mode == 'pm_reports') ? $user->lang['MCP_PM_REPORTS_OPEN'] : $user->lang['MCP_PM_REPORTS_CLOSED'],

'S_PM' => true,

'S_MCP_ACTION' => $this->u_action,

'S_CLOSED' => ($mode == 'pm_reports_closed') ? true : false,

'S_CAN_DELETE_POST' => $auth->acl_get('m_delete', $post_info['forum_id']),

'S_POST_REPORTED' => ($post_info['post_reported']) ? true : false,

'S_POST_DELETED' => ($post_info['post_visibility'] == ITEM_DELETED) ? true : false,

'S_POST_LOCKED' => ($post_info['post_edit_locked']) ? true : false,

'S_USER_NOTES' => true,

if (!empty($topic_id_list))

{

$sql = 'SELECT post_id

FROM ' . POSTS_TABLE . '

AND ' . $db->sql_in_set('topic_id', $topic_id_list);

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

'U_APPROVE_ACTION' => append_sid("{$phpbb_root_path}mcp.$phpEx", "i=queue&amp;p=$post_id&amp;f=$forum_id"),

'S_CAN_VIEWIP' => $auth->acl_get('m_info', $post_info['forum_id']),

'S_POST_REPORTED' => $post_info['post_reported'],

'S_POST_LOCKED' => $post_info['post_edit_locked'],

'S_USER_NOTES' => true,

'S_POST_DELETED' => ($post_info['post_visibility'] == ITEM_DELETED),

'MINI_POST_IMG' => ($post_unread) ? $user->img('icon_post_target_unread', 'UNREAD_POST') : $user->img('icon_post_target', 'POST'),

'RETURN_QUEUE' => sprintf($user->lang['RETURN_QUEUE'], '<a href="' . append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=queue' . (($topic_id) ? '&amp;mode=unapproved_topics' : '&amp;mode=unapproved_posts')) . '&amp;start=' . $start . '">', '</a>'),

'RETURN_POST' => sprintf($user->lang['RETURN_POST'], '<a href="' . $post_url . '">', '</a>'),

'RETURN_TOPIC_SIMPLE' => sprintf($user->lang['RETURN_TOPIC_SIMPLE'], '<a href="' . $topic_url . '">', '</a>'),

$m_perm = 'm_approve';

$is_topics = ($mode == 'unapproved_topics' || $mode == 'deleted_topics') ? true : false;

$is_restore = ($mode == 'deleted_posts' || $mode == 'deleted_topics') ? true : false;

$user->add_lang(array('viewtopic', 'viewforum'));

$sql = 'SELECT p.post_id

FROM ' . POSTS_TABLE . ' p, ' . TOPICS_TABLE . ' t' . (($sort_order_sql[0] == 'u') ? ', ' . USERS_TABLE . ' u' : '') . '

WHERE ' . $db->sql_in_set('p.forum_id', $forum_list) . '

' . (($sort_order_sql[0] == 'u') ? 'AND u.user_id = p.poster_id' : '') . '

' . (($topic_id) ? 'AND p.topic_id = ' . $topic_id : '') . "

AND t.topic_id = p.topic_id

$sql = 'SELECT t.forum_id, t.topic_id, t.topic_title, t.topic_title AS post_subject, t.topic_time AS post_time, t.topic_poster AS poster_id, t.topic_first_post_id AS post_id, t.topic_attachment AS post_attachment, t.topic_first_poster_name AS username, t.topic_first_poster_colour AS user_colour

FROM ' . TOPICS_TABLE . ' t

WHERE ' . $db->sql_in_set('forum_id', $forum_list) . '

AND topic_delete_user <> 0

$limit_time_sql

ORDER BY $sort_order_sql";

}

$phpbb_notifications->delete_notifications('post_in_queue', $post_id);

$phpbb_notifications->mark_notifications_read(array(

'quote',

));

$phpbb_notifications->delete_notifications('topic_in_queue', $topic_id);

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

$phpbb_notifications->mark_notifications_read('topic', $topic_id, $user->data['user_id']);

if ($is_disapproving)

{

$l_log_message = ($log_data['type'] == 'topic') ? 'LOG_TOPIC_DISAPPROVED' : 'LOG_POST_DISAPPROVED';

}

else

{

$post_data['disapprove_reason'] .= ($reason) ? "\n\n" . $reason : '';

}

if ($disapprove_all_posts_in_topic && $topic_information[$topic_id]['topic_posts_unapproved'] == 1)

{

// If there is only 1 post when disapproving the topic,

unset($lang_reasons, $post_info, $disapprove_reason, $disapprove_reason_lang);

if ($num_disapproved_topics)

{

$success_msg = ($num_disapproved_topics == 1) ? 'TOPIC' : 'TOPICS';

$post_id = $report['post_id'];

$report_id = $report['report_id'];

$parse_post_flags = $report['reported_post_enable_bbcode'] ? OPTION_FLAG_BBCODE : 0;

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

$post_info = get_post_data(array($post_id), 'm_report', true);

$post_unread = (isset($topic_tracking_info[$post_info['topic_id']]) && $post_info['post_time'] > $topic_tracking_info[$post_info['topic_id']]) ? true : false;

$report['report_text'] = make_clickable(bbcode_nl2br($report['report_text']));

if ($post_info['post_attachment'] && $auth->acl_get('u_download') && $auth->acl_get('f_download', $post_info['forum_id']))

'S_CLOSE_ACTION' => append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=reports&amp;mode=report_details&amp;f=' . $post_info['forum_id'] . '&amp;p=' . $post_id),

'S_CAN_VIEWIP' => $auth->acl_get('m_info', $post_info['forum_id']),

'S_POST_REPORTED' => $post_info['post_reported'],

'S_POST_LOCKED' => $post_info['post_edit_locked'],

'S_REPORT_CLOSED' => $report['report_closed'],

'S_USER_NOTES' => true,

}

$db->sql_query($sql);

if (sizeof($close_report_posts))

{

if ($pm)

parse_attachments($topic_info['forum_id'], $message, $attachments[$row['post_id']], $update_count);

}

{

$has_unapproved_posts = true;

}

'MINI_POST_IMG' => ($post_unread) ? $user->img('icon_post_target_unread', 'UNREAD_POST') : $user->img('icon_post_target', 'POST'),

'S_POST_REPORTED' => ($row['post_reported'] && $auth->acl_get('m_report', $topic_info['forum_id'])),

'S_POST_DELETED' => ($row['post_visibility'] == ITEM_DELETED && $auth->acl_get('m_approve', $topic_info['forum_id'])),

'S_CHECKED' => (($submitted_id_list && !in_array(intval($row['post_id']), $submitted_id_list)) || in_array(intval($row['post_id']), $checked_ids)) ? true : false,

'S_HAS_ATTACHMENTS' => (!empty($attachments[$row['post_id']])) ? true : false,

while ($row = $db->sql_fetchrow($result))

{

// If split from selected post (split_beyond), we split the unapproved items too.

{

// continue;

}

function bbcode_init($allow_custom_bbcode = true)

{

global $phpbb_dispatcher;

static $rowset;

// This array holds all bbcode data. BBCodes will be processed in this

break;

}

$template->assign_vars(array(

'L_TITLE' => $user->lang['UCP_MAIN_' . strtoupper($mode)],

AND t.topic_id = tw.topic_id

AND ' . $db->sql_in_set('t.forum_id', $forbidden_forum_ary, true, true),

'ORDER_BY' => 't.topic_last_post_time DESC'

);

meta_refresh(3, $this->u_action);

$message = $user->lang['NOTIFICATIONS_MARK_ALL_READ_SUCCESS'];

if ($request->is_ajax())

{

$json_response = new \phpbb\json_response();

trigger_error('NO_AUTH_READ_HOLD_MESSAGE');

}

// First Handle Mark actions and moving messages

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

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

);

$s_hidden_fields .= build_address_field($address_list);

confirm_box(false, 'SAVE_DRAFT', $s_hidden_fields);

}

}

$return_box_url = ($action === 'post' || $action === 'edit') ? $outbox_folder_url : $inbox_folder_url;

$return_box_lang = ($action === 'post' || $action === 'edit') ? 'PM_OUTBOX' : 'PM_INBOX';

$save_message = ($action === 'edit') ? $user->lang['MESSAGE_EDITED'] : $user->lang['MESSAGE_STORED'];

$message = $save_message . '<br /><br />' . $user->lang('VIEW_PRIVATE_MESSAGE', '<a href="' . $return_message_url . '">', '</a>');

// Build hidden address list

$s_hidden_address_field = build_address_field($address_list);

$bbcode_checked = (isset($enable_bbcode)) ? !$enable_bbcode : (($config['allow_bbcode'] && $auth->acl_get('u_pm_bbcode')) ? !$user->optionget('bbcode') : 1);

$smilies_checked = (isset($enable_smilies)) ? !$enable_smilies : (($config['allow_smilies'] && $auth->acl_get('u_pm_smilies')) ? !$user->optionget('smilies') : 1);

$urls_checked = (isset($enable_urls)) ? !$enable_urls : 0;

// Check for disallowed recipients

if (!empty($address_list['u']))

{

{

{

}

{

}

}

}

}

trigger_error($message);

}

}

// Add Folder

if (isset($_POST['addfolder']))

{

// Move Messages

case 1:

$num_moved = move_pm($user->data['user_id'], $user->data['message_limit'], $msg_ids, $move_to, $remove_folder_id);

// Something went wrong, only partially moved?

if ($num_moved != $folder_row['pm_count'])

{

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

$num_messages = (int) $db->sql_fetchfield('num_messages');

$db->sql_freeresult($result);

$folder[PRIVMSGS_INBOX] = array(

'folder_name' => $user->lang['PM_INBOX'],

'message_status' => $user->lang('FOLDER_MESSAGE_STATUS', $user->lang('MESSAGES_COUNT', (int) $user->data['message_limit']), $num_messages),

function define_cond_option($hardcoded, $cond_option, $rule_option, $global_rule_conditions)

{

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

$template->assign_vars(array(

'S_COND_DEFINED' => true,

'S_COND_SELECT' => (!$hardcoded && isset($global_rule_conditions[$rule_option])) ? true : false)

{

case 'text':

$rule_string = utf8_normalize_nfc(request_var('rule_string', '', true));

$template->assign_vars(array(

'S_TEXT_CONDITION' => true,

'CURRENT_STRING' => $rule_string,

case 'user':

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

$rule_string = utf8_normalize_nfc(request_var('rule_string', '', true));

if ($rule_string && !$rule_user_id)

{

$sql = 'SELECT user_id

{

$sql .= 'WHERE';

}

ORDER BY g.group_type DESC, g.group_name ASC';

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

$s_group_options = '';

$s_class = ($row['group_type'] == GROUP_SPECIAL) ? ' class="sep"' : '';

$s_selected = ($row['group_id'] == $rule_group_id) ? ' selected="selected"' : '';

$s_group_options .= '<option value="' . $row['group_id'] . '"' . $s_class . $s_selected . '>' . (($row['group_type'] == GROUP_SPECIAL) ? $user->lang['G_' . $row['group_name']] : $row['group_name']) . '</option>';

}

$db->sql_freeresult($result);

WHERE user_id = ' . $user_id . '

ORDER BY rule_id ASC';

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

$count = 0;

while ($row = $db->sql_fetchrow($result))

{

}

}

$msg_data = array(

'MESSAGE_AUTHOR_FULL' => get_username_string('full', $author_id, $user_info['username'], $user_info['user_colour'], $user_info['username']),

'MESSAGE_AUTHOR_COLOUR' => get_username_string('colour', $author_id, $user_info['username'], $user_info['user_colour'], $user_info['username']),

'EDITED_MESSAGE' => $l_edited_by,

'MESSAGE_ID' => $message_row['msg_id'],

'U_DELETE' => ($auth->acl_get('u_pm_delete')) ? "$url&amp;mode=compose&amp;action=delete&amp;f=$folder_id&amp;p=" . $message_row['msg_id'] : '',

'U_EMAIL' => $user_info['email'],

* @var array message_row Array with message data

* @var array cp_row Array with senders custom profile field data

* @var array msg_data Template array with message data

*/

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

$template->assign_vars($msg_data);

// Display the custom profile fields

if (!empty($cp_row['row']))

{

foreach ($cp_row['blockrow'] as $cp_block_row)

{

$template->assign_block_vars('custom_fields', $cp_block_row);

}

}

{

$template->assign_block_vars('dl_method', $method);

}

foreach ($attachments as $attachment)

{

$template->assign_block_vars('attachment', array(

* @var bool submit Do we display the form only

* or did the user press submit

* @var array data Array with current ucp options data

*/

$vars = array('submit', 'data');

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

* @event core.ucp_prefs_personal_update_data

* @var array data Submitted display options data

* @var array sql_ary Display options data we udpate

*/

$vars = array('data', 'sql_ary');

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

* @var bool submit Do we display the form only

* or did the user press submit

* @var array data Array with current ucp options data

*/

$vars = array('submit', 'data');

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

* @event core.ucp_prefs_view_update_data

* @var array data Submitted display options data

* @var array sql_ary Display options data we udpate

*/

$vars = array('data', 'sql_ary');

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

* @var bool submit Do we display the form only

* or did the user press submit

* @var array data Array with current ucp options data

*/

$vars = array('submit', 'data');

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

* @event core.ucp_prefs_post_update_data

* @var array data Submitted display options data

* @var array sql_ary Display options data we udpate

*/

$vars = array('data', 'sql_ary');

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

$agreed = false;

}

}

else

{

if (!$agreed || ($coppa === false && $config['coppa_enable']) || ($coppa && !$config['coppa_enable']))

{

$add_coppa = ($coppa !== false) ? '&amp;coppa=' . $coppa : '';

$s_hidden_fields = array_merge($s_hidden_fields, array(

'L_COPPA_NO' => sprintf($user->lang['UCP_COPPA_BEFORE'], $coppa_birthday),

'L_COPPA_YES' => sprintf($user->lang['UCP_COPPA_ON_AFTER'], $coppa_birthday),

'S_SHOW_COPPA' => true,

'S_HIDDEN_FIELDS' => build_hidden_fields($s_hidden_fields),

));

}

else

'S_SHOW_COPPA' => false,

'S_REGISTRATION' => true,

'S_HIDDEN_FIELDS' => build_hidden_fields($s_hidden_fields),

)

);

}

'S_COPPA' => $coppa,

'S_HIDDEN_FIELDS' => $s_hidden_fields,

'S_UCP_ACTION' => append_sid("{$phpbb_root_path}ucp.$phpEx", 'mode=register'),

));

//

* @event core.ucp_remove_zebra

* @var string mode Zebra type: friends|foes

* @var array user_ids User ids we remove

*/

$vars = array('mode', 'user_ids');

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

* friends|foes

* @var array sql_ary Array of

* entries we add

*/

$vars = array('mode', 'sql_ary');

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

}

}

}

if ($request->is_ajax())

{

$message = ($updated) ? $user->lang[$l_mode . '_UPDATED'] : implode('<br />', $error);

$json_response = new \phpbb\json_response;

$json_response->send(array(

'success' => $updated,

'MESSAGE_TITLE' => $user->lang['INFORMATION'],

'MESSAGE_TEXT' => $message,

'REFRESH_DATA' => array(

continue;

}

// STEP 1: Decompose current char

// We have found a character that is either:

$utf_seq = array($utf_char);

}

// STEP 2: Capture the starter

// Check out the combining class of the first character of the UTF sequence

}

}

// STEP 3: Capture following combining modifiers

while ($pos < $len)

}

}

// STEP 4: Sort and combine

// Here we sort...

$tmp_pos = $last_cc = $sort = $dump = 0;

$utf_sort = array();

// Main loop

do

{

continue;

}

// STEP 1: Decide what to do with current char

// Now, in that order: