function main($id, $mode)

{

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

$this->id = $id;

$this->db = $db;

$error = $notify = array();

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

$form_key = 'acp_attach';

add_form_key($form_key);

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

'img_max_thumb_width' => array('lang' => 'MAX_THUMB_WIDTH', 'validate' => 'int:0:999999999999999', 'type' => 'number:0:999999999999999', 'explain' => true, 'append' => ' ' . $user->lang['PIXEL']),

'img_min_thumb_filesize' => array('lang' => 'MIN_THUMB_FILESIZE', 'validate' => 'int:0:999999999999999', 'type' => 'number:0:999999999999999', 'explain' => true, 'append' => ' ' . $user->lang['BYTES']),

'img_max' => array('lang' => 'MAX_IMAGE_SIZE', 'validate' => 'int:0:9999', 'type' => 'dimension:0:9999', 'explain' => true, 'append' => ' ' . $user->lang['PIXEL']),

'img_link' => array('lang' => 'IMAGE_LINK_SIZE', 'validate' => 'int:0:9999', 'type' => 'dimension:0:9999', 'explain' => true, 'append' => ' ' . $user->lang['PIXEL']),

)

);

$this->new_config = $config;

$error = array();

// We validate the complete config if whished

if (in_array($config_name, array('attachment_quota', 'max_filesize', 'max_filesize_pm')))

{

$this->new_config[$config_name] = $config_value = ($size_var == 'kb') ? round($config_value * 1024) : (($size_var == 'mb') ? round($config_value * 1048576) : $config_value);

}

if ($submit)

{

}

}

if ($submit)

{

// Check Settings

$this->test_upload($error, $this->new_config['upload_path'], false);

if ($submit)

{

// Change Extensions ?

// Generate correct Change List

$extensions = array();

WHERE extension_id = ' . $row['extension_id'];

$db->sql_query($sql);

}

}

$db->sql_freeresult($result);

// Delete Extension?

if (sizeof($extension_id_list))

{

WHERE ' . $db->sql_in_set('extension_id', $extension_id_list);

$db->sql_query($sql);

}

}

// Add Extension?

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

if ($add_extension && $add)

);

$db->sql_query('INSERT INTO ' . EXTENSIONS_TABLE . ' ' . $db->sql_build_array('INSERT', $sql_ary));

}

}

}

if ($submit)

{

if ($action != 'add' && $action != 'edit')

{

$ext_row = array();

}

$new_group_name = ($action == 'add') ? $group_name : (($ext_row['group_name'] != $group_name) ? $group_name : '');

if (!$group_name)

if (!sizeof($error))

{

// Ok, build the update/insert array

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

$max_filesize = ($size_select == 'kb') ? round($max_filesize * 1024) : (($size_select == 'mb') ? round($max_filesize * 1048576) : $max_filesize);

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

$group_ary = array(

'group_name' => $group_name,

'allow_group' => ($allow_group) ? 1 : 0,

'upload_icon' => ($upload_icon == 'no_image') ? '' : $upload_icon,

'max_filesize' => $max_filesize,

}

$group_name = (isset($user->lang['EXT_GROUP_' . $group_name])) ? $user->lang['EXT_GROUP_' . $group_name] : $group_name;

}

if ($action == 'edit' && sizeof($extension_list))

{

ATTACHMENT_CATEGORY_QUICKTIME => $user->lang['CAT_QUICKTIME_FILES'],

);

$action = (isset($_POST['add'])) ? 'add' : $action;

switch ($action)

WHERE group_id = $group_id";

$db->sql_query($sql);

$cache->destroy('_extensions');

if ($action == 'add')

{

$ext_group_row = array(

'cat_id' => 0,

'allow_group' => 1,

'allow_in_pm' => 1,

if ($submit)

{

if (sizeof($delete_files))

{

WHERE ' . $db->sql_in_set('attach_id', array_keys($delete_files));

$db->sql_query($sql);

$notify[] = sprintf($user->lang['LOG_ATTACH_ORPHAN_DEL'], implode($user->lang['COMMA_SEPARATOR'], $delete_files));

}

$space_taken += $row['filesize'];

$files_added++;

}

$db->sql_freeresult($result);

if ($files_added)

{

}

}

}

if ($submit)

{

if (sizeof($delete_files))

{

{

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

}

$notify[] = sprintf($user->lang['LOG_ATTACHMENTS_DELETED'], implode($user->lang['COMMA_SEPARATOR'], $deleted_filenames));

}

else

'S_MANAGE' => true,

));

// Sort keys

// Sorting

$limit_days = array(0 => $user->lang['ALL_ENTRIES'], 1 => $user->lang['1_DAY'], 7 => $user->lang['7_DAYS'], 14 => $user->lang['2_WEEKS'], 30 => $user->lang['1_MONTH'], 90 => $user->lang['3_MONTHS'], 180 => $user->lang['6_MONTHS'], 365 => $user->lang['1_YEAR']);

*/

function perform_site_list()

{

if (isset($_REQUEST['securesubmit']))

{

// Grab the list of entries

$ip_list = array_unique(explode("\n", $ips));

$ip_list_log = implode(', ', $ip_list);

{

// Update log

$log_entry = ($ip_exclude) ? 'LOG_DOWNLOAD_EXCLUDE_IP' : 'LOG_DOWNLOAD_IP';

}

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

}

else if (isset($_POST['unsecuresubmit']))

{

if (sizeof($unip_sql))

{

WHERE ' . $db->sql_in_set('site_id', $unip_sql);

$db->sql_query($sql);

}

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

function main($id, $mode)

{

global $db, $user, $auth, $template, $cache, $request, $phpbb_dispatcher;

$user->add_lang('acp/posting');

// Set up general vars

$this->tpl_name = 'acp_bbcodes';

$this->page_title = 'ACP_BBCODES';

// No break here

case 'create':

break;

}

$log_action = 'LOG_BBCODE_EDIT';

}

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

}

{

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

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

if ($request->is_ajax())

{

{

$bbcode_match = trim($bbcode_match);

$bbcode_tpl = trim($bbcode_tpl);

$utf8_pcre_properties = phpbb_pcre_utf8_support();

function main($id, $mode)

{

global $config, $phpbb_root_path, $phpbb_admin_path, $phpEx;

$user->add_lang('acp/board');

$submit = (isset($_POST['submit']) || isset($_POST['allow_quick_reply_enable'])) ? true : false;

$form_key = 'acp_board';

}

$this->new_config = $config;

$error = array();

// We validate the complete config if wished

if ($submit)

{

if ($config_name == 'allow_quick_reply' && isset($_POST['allow_quick_reply_enable']))

{

{

if (!isset($config[$field]))

{

}

if (!isset($cfg_array[$field]) || strpos($field, 'legend') !== false)

if ($submit)

{

$updated_auth_settings = true;

}

}

}

{

foreach ($old_auth_config as $config_name => $config_value)

{

}

trigger_error($error . adm_back_link($this->u_action), E_USER_WARNING);

}

}

else

{

if ($submit)

{

$message = $user->lang('CONFIG_UPDATED');

$message_type = E_USER_NOTICE;

function store_feed_forums($option, $key)

{

// Get key

// Empty option bit for all forums

$sql = 'UPDATE ' . FORUMS_TABLE . '

function main($id, $mode)

{

global $phpbb_root_path, $phpbb_admin_path, $phpEx, $table_prefix;

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

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

{

$cache->destroy('_bots');

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

}

else

include_once($phpbb_root_path . 'includes/functions_user.' . $phpEx);

$bot_row = array(

);

if ($submit)

$cache->destroy('_bots');

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

}

function main($id, $mode)

{

global $config, $phpbb_root_path, $phpbb_admin_path, $phpEx, $phpbb_container;

$user->add_lang('acp/board');

$factory = $phpbb_container->get('captcha.factory');

$captchas = $factory->get_captcha_types();

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

// Oh, they are just here for the view

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

$form_key = 'acp_captcha';

add_form_key($form_key);

if ($submit && check_form_key($form_key))

{

foreach ($config_vars as $config_var => $options)

{

}

if ($selected !== $config['captcha_plugin'])

$old_captcha = $factory->get_instance($config['captcha_plugin']);

$old_captcha->uninstall();

$new_captcha = $factory->get_instance($config['captcha_plugin']);

$new_captcha->install();

}

else

{

foreach ($config_vars as $config_var => $options)

{

}

$template->assign_vars(array(

function main($id, $mode)

{

$user->add_lang('acp/database');

$this->tpl_name = 'acp_database';

$this->page_title = 'ACP_DATABASE';

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

$template->assign_vars(array(

switch ($action)

{

case 'download':

if (!sizeof($table))

{

$extractor->write_end();

if ($download == true)

{

switch ($action)

{

case 'submit':

if (!preg_match('#^backup_\d{10,}_[a-z\d]{16}\.(sql(?:\.(?:gz|bz2))?)$#', $file, $matches))

{

if (confirm_box(true))

{

unlink($file_name);

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

}

else

// Purge the cache due to updated data

$cache->purge();

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

break;

}

{

function write_table($table_name)

{

$sql_data = '-- Table: ' . $table_name . "\n";

$sql_data .= "DROP TABLE $table_name\n/\n";

$sql_data .= "\nCREATE TABLE $table_name (\n";

AND C.SEQUENCE_NAME = A.REFERENCED_NAME";

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

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

{

function main($id, $mode)

{

global $config, $phpbb_root_path, $phpbb_admin_path, $phpEx;

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

if ($disallow)

{

if (!$disallowed_user)

{

$cache->destroy('_disallowed_usernames');

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

trigger_error($message . adm_back_link($this->u_action));

}

else if ($allow)

{

if (!$disallowed_id)

{

$cache->destroy('_disallowed_usernames');

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

}

function main($id, $mode)

{

global $phpbb_root_path, $phpbb_admin_path, $phpEx, $table_prefix, $phpbb_dispatcher;

$user->add_lang('acp/email');

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

$error = array();

$usernames = (!empty($usernames)) ? explode("\n", $usernames) : array();

// Do the job ...

if ($submit)

// Error checking needs to go here ... if no subject and/or no message then skip

// over the send and return to the form

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

if (!check_form_key($form_key))

{

{

if (!empty($usernames))

{

}

else

{

$group_name = $user->lang['ALL_USERS'];

}

}

}

$s_priority_options .= '<option value="' . MAIL_NORMAL_PRIORITY . '" selected="selected">' . $user->lang['MAIL_NORMAL_PRIORITY'] . '</option>';

$s_priority_options .= '<option value="' . MAIL_HIGH_PRIORITY . '">' . $user->lang['MAIL_HIGH_PRIORITY'] . '</option>';

'S_WARNING' => (sizeof($error)) ? true : false,

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

'U_ACTION' => $this->u_action,

'U_FIND_USERNAME' => append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=searchuser&amp;form=acp_email&amp;field=usernames'),

'SUBJECT' => $subject,

'MESSAGE' => $message,

);

}

}

function main($id, $mode)

{

global $db, $user, $auth, $template, $cache, $request, $phpbb_dispatcher;

$user->add_lang('acp/forums');

$this->tpl_name = 'acp_forums';

$form_key = 'acp_forums';

add_form_key($form_key);

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

$forum_data = $errors = array();

if ($update && !check_form_key($form_key))

{

switch ($action)

{

case 'progress_bar':

$this->display_progress_bar($start, $total);

break;

switch ($action)

{

case 'delete':

$errors = $this->delete_forum($forum_id, $action_posts, $action_subforums, $posts_to_id, $subforums_to_id);

case 'add':

$forum_data += array(

'forum_parents' => '',

'forum_desc_uid' => '',

'forum_desc_options' => 7,

'forum_desc_bitfield' => '',

'forum_rules_uid' => '',

'forum_rules_options' => 7,

'forum_rules_bitfield' => '',

);

/**

// Use link_display_on_index setting if forum type is link

if ($forum_data['forum_type'] == FORUM_LINK)

{

}

// Linked forums and categories are not able to be locked...

$forum_data['forum_status'] = ITEM_UNLOCKED;

}

// Get data for forum rules if specified...

if ($forum_data['forum_rules'])

{

}

// Get data for forum description if specified

if ($forum_data['forum_desc'])

{

}

$errors = $this->update_forum_data($forum_data);

if (!sizeof($errors))

{

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

$copied_permissions = false;

if ($move_forum_name !== false)

{

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

}

$row2['min_topic_id'] = (int) $row2['min_topic_id'];

$row2['max_topic_id'] = (int) $row2['max_topic_id'];

$batch_size = 2000;

$end = $start + $batch_size;

WHERE forum_id = ' . $forum_id . '

AND topic_id BETWEEN ' . $start . ' AND ' . $end;

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

$db->sql_freeresult($result);

$start += $batch_size;

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

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

$template->assign_var('L_FORUM_RESYNCED', sprintf($user->lang['FORUM_RESYNCED'], $row['forum_name']));

if ($update)

{

$forum_data['forum_flags'] = 0;

$forum_data['forum_flags'] += ($forum_data['show_active']) ? FORUM_FLAG_ACTIVE_TOPICS : 0;

}

// Initialise $row, so we always have it in the event

'parent_id' => $this->parent_id,

'forum_type' => FORUM_POST,

'forum_status' => ITEM_UNLOCKED,

'forum_link' => '',

'forum_link_track' => false,

'forum_desc' => '',

{

if (!isset($forum_data['forum_rules_uid']))

{

$forum_data['forum_rules_uid'] = '';

$forum_data['forum_rules_bitfield'] = '';

$forum_data['forum_rules_options'] = 0;

}

// Generate preview content

{

if (!isset($forum_data['forum_desc_uid']))

{

$forum_data['forum_desc_uid'] = '';

$forum_data['forum_desc_bitfield'] = '';

$forum_data['forum_desc_options'] = 0;

}

// decode...

break;

case 'copy_perm':

// Copy permissions?

if (!empty($forum_perm_from) && $forum_perm_from != $forum_id)

*/

function update_forum_data(&$forum_data)

{

$errors = array();

$forum_data['forum_id'] = $db->sql_nextid();

}

else

{

// we're turning a postable forum into a non-postable forum

if ($forum_data_sql['type_action'] == 'move')

{

if ($to_forum_id)

{

if ($row['right_id'] - $row['left_id'] > 1)

{

// We are turning a category into a link - but need to decide what to do with the subforums.

if ($action_subforums == 'delete')

{

// Add it back

$forum_data['forum_id'] = $forum_id;

}

/**

*/

function delete_forum($forum_id, $action_posts = 'delete', $action_subforums = 'delete', $posts_to_id = 0, $subforums_to_id = 0)

{

$forum_data = $this->get_forum_info($forum_id);

switch ($log_action)

{

case 'MOVE_POSTS_MOVE_FORUMS':

break;

case 'MOVE_POSTS_FORUMS':

break;

case 'POSTS_MOVE_FORUMS':

break;

case '_MOVE_FORUMS':

break;

case 'MOVE_POSTS_':

break;

case 'POSTS_FORUMS':

break;

case '_FORUMS':

break;

case 'POSTS_':

break;

default:

break;

}

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

$db->sql_freeresult($result);

$sql = 'SELECT COUNT(topic_id) AS stat

FROM ' . TOPICS_TABLE . '

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

$db->sql_freeresult($result);

$sql = 'SELECT COUNT(attach_id) as stat

FROM ' . ATTACHMENTS_TABLE;

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

$db->sql_freeresult($result);

$sql = 'SELECT SUM(filesize) as stat

FROM ' . ATTACHMENTS_TABLE;

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

$db->sql_freeresult($result);

return array();

}

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

// Check and set some common vars

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

// Clear some vars

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

}

$submit_ary = array(

'receive_pm' => isset($_REQUEST['group_receive_pm']) ? 1 : 0,

'legend' => isset($_REQUEST['group_legend']) ? 1 : 0,

'teampage' => isset($_REQUEST['group_teampage']) ? 1 : 0,

'founder_manage' => 0,

);

if ($user->data['user_type'] == USER_FOUNDER)

if (!($error = group_create($group_id, $group_type, $group_name, $group_desc, $group_attributes, $allow_desc_bbcode, $allow_desc_urls, $allow_desc_smilies)))

{

// Copy permissions?

// If the user has the a_authgroups permission and at least one additional permission ability set the permissions are fully transferred.

}

else if (!$group_id)

{

$group_desc_data = array(

'text' => '',

'allow_bbcode' => true,

$error = array_merge($error, $phpbb_avatar_manager->localize_errors($user, $avatar_error));

}

switch ($back_link)

{

case 'acp_users_groups':

break;

default:

$user->add_lang('acp/posting');

// Set up general vars

$action = (isset($_POST['add'])) ? 'add' : $action;

$action = (isset($_POST['edit'])) ? 'edit' : $action;

$action = (isset($_POST['import'])) ? 'import' : $action;

$mode = ($mode == 'smilies') ? 'smilies' : 'icons';

case 'modify':

// Get items to create/modify

// Now really get the items

// Ok, add the relevant bits if we are adding new codes to existing emoticons...

if ($request->variable('add_additional_code', false, false, \phpbb\request\request_interface::POST))

{

if ($add_image && $add_emotion && $add_code)

{

$image_code[$add_image] = $add_code;

$image_emotion[$add_image] = $add_emotion;

if ($request->variable('add_display_on_posting', false, false, \phpbb\request\request_interface::POST))

{

$image_display_on_posting[$add_image] = 1;

}

}

}

case 'import':

if ($pak != '')

{

/* @var $pagination \phpbb\pagination */

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

$spacer = false;

$item_count = $this->item_count($table);

function main($id, $mode)

{

global $phpbb_root_path, $phpbb_admin_path, $phpEx, $table_prefix;

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

$user->add_lang('memberlist');

$submit = isset($_POST['submit']);

// Sort keys

$form_key = 'acp_inactive';

add_form_key($form_key);

// We build the sort key and per page settings here, because they may be needed later

// Number of entries to display

// Sorting

$limit_days = array(0 => $user->lang['ALL_ENTRIES'], 1 => $user->lang['1_DAY'], 7 => $user->lang['7_DAYS'], 14 => $user->lang['2_WEEKS'], 30 => $user->lang['1_MONTH'], 90 => $user->lang['3_MONTHS'], 180 => $user->lang['6_MONTHS'], 365 => $user->lang['1_YEAR']);

{

foreach ($inactive_users as $row)

{

}

trigger_error(sprintf($user->lang['LOG_INACTIVE_ACTIVATE'], implode($user->lang['COMMA_SEPARATOR'], $user_affected) . ' ' . adm_back_link($this->u_action)));

user_delete('retain', $mark, true);

trigger_error(sprintf($user->lang['LOG_INACTIVE_DELETE'], implode($user->lang['COMMA_SEPARATOR'], $user_affected) . ' ' . adm_back_link($this->u_action)));

}

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

$db->sql_query($sql);

trigger_error(sprintf($user->lang['LOG_INACTIVE_REMIND'], implode($user->lang['COMMA_SEPARATOR'], $usernames) . ' ' . adm_back_link($this->u_action)));

}

function main($id, $mode)

{

global $config, $phpbb_root_path, $phpbb_admin_path, $phpEx;

$user->add_lang('acp/board');

include_once($phpbb_root_path . 'includes/functions_jabber.' . $phpEx);

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

if ($mode != 'settings')

$this->tpl_name = 'acp_jabber';

$this->page_title = 'ACP_JABBER_SETTINGS';

$form_name = 'acp_jabber';

add_form_key($form_name);

$db->sql_query($sql);

}

trigger_error($message . adm_back_link($this->u_action));

}

function main($id, $mode)

{

global $phpbb_root_path, $phpEx, $request;

include_once($phpbb_root_path . 'includes/functions_user.' . $phpEx);

$action = (isset($_POST['remove_store'])) ? 'details' : $action;

$submit = (empty($action) && !isset($_POST['update']) && !isset($_POST['test_connection'])) ? false : true;

$form_name = 'acp_lang';

add_form_key('acp_lang');

list($this->language_directory, $this->language_file) = explode('|', $selected_lang_file);

$db->sql_freeresult($result);

$sql_ary = array(

);

$db->sql_query('UPDATE ' . LANG_TABLE . '

SET ' . $db->sql_build_array('UPDATE', $sql_ary) . '

WHERE lang_id = ' . $lang_id);

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

break;

$sql = 'DELETE FROM ' . PROFILE_FIELDS_LANG_TABLE . ' WHERE lang_id = ' . $lang_id;

$db->sql_query($sql);

trigger_error(sprintf($user->lang['LANGUAGE_PACK_DELETED'], $row['lang_english_name']) . adm_back_link($this->u_action));

}

break;

case 'install':

$lang_iso = basename($lang_iso);

if (!$lang_iso || !file_exists("{$phpbb_root_path}language/$lang_iso/iso.txt"))

}

$db->sql_freeresult($result);

$message = sprintf($user->lang['LANGUAGE_PACK_INSTALLED'], $lang_pack['name']);

$message .= ($notify_cpf_update) ? '<br /><br />' . $user->lang['LANGUAGE_PACK_CPF_UPDATE'] : '';

$user->add_lang('mcp');

// Set up general vars

$deletemark = $request->variable('delmarked', false, false, \phpbb\request\request_interface::POST);

$deleteall = $request->variable('delall', false, false, \phpbb\request\request_interface::POST);

// Sort keys

$this->tpl_name = 'acp_logs';

$this->log_type = constant('LOG_' . strtoupper($mode));

$conditions['log_time'] = array('>=', time() - ($sort_days * 86400));

}

$conditions['keywords'] = $keywords;

}

$sql_where = ($sort_days) ? (time() - ($sort_days * 86400)) : 0;

$sql_sort = $sort_by_sql[$sort_key] . ' ' . (($sort_dir == 'd') ? 'DESC' : 'ASC');

$keywords_param = !empty($keywords) ? '&amp;keywords=' . urlencode(htmlspecialchars_decode($keywords)) : '';

$l_title = $user->lang['ACP_' . strtoupper($mode) . '_LOGS'];

function main($id, $mode)

{

global $phpbb_root_path, $phpbb_admin_path, $phpEx, $phpbb_container, $phpbb_dispatcher;

// Show restore permissions notice

return;

}

if ($action)

{

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

}

if ($request->is_ajax())

{

FROM ' . POSTS_TABLE . '

WHERE post_visibility = ' . ITEM_APPROVED;

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

$db->sql_freeresult($result);

$sql = 'SELECT COUNT(topic_id) AS stat

FROM ' . TOPICS_TABLE . '

WHERE topic_visibility = ' . ITEM_APPROVED;

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

$db->sql_freeresult($result);

$sql = 'SELECT COUNT(user_id) AS stat

FROM ' . USERS_TABLE . '

WHERE user_type IN (' . USER_NORMAL . ',' . USER_FOUNDER . ')';

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

$db->sql_freeresult($result);

$sql = 'SELECT COUNT(attach_id) as stat

FROM ' . ATTACHMENTS_TABLE . '

WHERE is_orphan = 0';

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

$db->sql_freeresult($result);

$sql = 'SELECT SUM(filesize) as stat

FROM ' . ATTACHMENTS_TABLE . '

WHERE is_orphan = 0';

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

$db->sql_freeresult($result);

if (!function_exists('update_last_username'))

}

update_last_username();

if ($request->is_ajax())

{

// Still no maximum post id? Then we are finished

if (!$max_post_id)

{

break;

}

$start += $step;

}

if ($request->is_ajax())

{

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

}

if ($request->is_ajax())

{

}

}

if ($request->is_ajax())

{

$auth->acl_clear_prefetch();

phpbb_cache_moderators($db, $cache, $auth);

if ($request->is_ajax())

{

$sql = 'INSERT INTO ' . SESSIONS_TABLE . ' ' . $db->sql_build_array('INSERT', $reinsert_ary);

$db->sql_query($sql);

if ($request->is_ajax())

{

// Fill dbms version if not yet filled

if (empty($config['dbms_version']))

{

}

$this->tpl_name = 'acp_main';

function main($id, $mode)

{

global $config, $phpbb_admin_path, $phpbb_root_path, $phpEx;

// Set a global define for modules we might include (the author is able to prevent execution of code by checking this constant)

$this->page_title = strtoupper($this->module_class);

$errors = array();

switch ($action)

AND module_id = $module_id";

$db->sql_query($sql);

$this->remove_cache_file();

break;

if ($move_module_name !== false)

{

$this->remove_cache_file();

}

break;

case 'quickadd':

if (confirm_box(true))

{

'module_enabled' => 0,

'module_display' => 1,

'parent_id' => 0,

'module_mode' => '',

'module_auth' => '',

);

$module_data = array();

$module_data['module_class'] = $this->module_class;

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

trigger_error($user->lang['NO_MODULE_LANGNAME'] . adm_back_link($this->u_action . '&amp;parent_id=' . $this->parent_id), E_USER_WARNING);

}

if ($module_type == 'category')

{

*/

function update_module_data(&$module_data, $run_inline = false)

{

if (!isset($module_data['module_id']))

{

if (!$run_inline)

{

}

}

else

if (!$run_inline)

{

}

}

*/

function delete_module($module_id)

{

$row = $this->get_module_row($module_id);

AND left_id > {$row['right_id']}";

$db->sql_query($sql);

return array();

{

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

global $config, $phpbb_root_path, $phpbb_admin_path, $phpEx;

include_once($phpbb_root_path . 'includes/functions_user.' . $phpEx);

include_once($phpbb_root_path . 'includes/acp/auth.' . $phpEx);

$this->tpl_name = 'acp_permission_roles';

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

$action = (isset($_POST['add'])) ? 'add' : $action;

$form_name = 'acp_permissions';

$this->remove_role($role_id, $permission_type);

$role_name = (!empty($user->lang[$role_row['role_name']])) ? $user->lang[$role_row['role_name']] : $role_row['role_name'];

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

}

else

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

}

if (!$role_name)

{

$this->auth_admin->acl_set_role($role_id, $auth_settings);

$role_name = (!empty($user->lang[$role_name])) ? $user->lang[$role_name] : $role_name;

trigger_error($user->lang['ROLE_' . strtoupper($action) . '_SUCCESS'] . adm_back_link($this->u_action));

{

case 'add':

$role_row = array(

'role_type' => $permission_type,

);

$db->sql_freeresult($result);

// Display assigned items?

// Select existing roles

$sql = 'SELECT *

function main($id, $mode)

{

global $config, $phpbb_root_path, $phpbb_admin_path, $phpEx;

include_once($phpbb_root_path . 'includes/functions_user.' . $phpEx);

// Trace has other vars

if ($mode == 'trace')

{

$this->tpl_name = 'permission_trace';

}

// Set some vars

$action = key($action);

$action = (isset($_POST['psubmit'])) ? 'apply_permissions' : $action;

$form_name = 'acp_permissions';

add_form_key($form_name);

);

// Get permission type

if (!in_array($permission_type, $this->permission_dropdown))

{

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

global $request;

// User or group to be set?

$ug_type = (sizeof($user_id)) ? 'user' : 'group';

$assigned_role = (isset($roles[$ug_id][$forum_id])) ? (int) $roles[$ug_id][$forum_id] : 0;

// Do the admin want to set these permissions to other items too?

$ug_id = array($ug_id);

$forum_id = array($forum_id);

*/

function log_action($mode, $action, $permission_type, $ug_type, $ug_id, $forum_id)

{

if (!is_array($ug_id))

{

if ($forum_id[0] == 0)

{

}

else

{

}

$db->sql_freeresult($result);

}

}

*/

function permission_trace($user_id, $forum_id, $permission)

{

if ($user_id != $user->data['user_id'])

{

$db->sql_freeresult($result);

}

$template->assign_vars(array(

'PERMISSION' => $this->permissions->get_permission_lang($permission),

*/

function copy_forum_permissions()

{

$user->add_lang('acp/forums');

if ($submit)

{

if (confirm_box(true))

{

{

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

global $phpbb_root_path, $phpbb_admin_path, $phpEx, $table_prefix;

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

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

$this->page_title = 'ACP_CUSTOM_PROFILE_FIELDS';

$field_id = $request->variable('field_id', 0);

$error = array();

$s_hidden_fields = '';

$db->sql_query('DELETE FROM ' . PROFILE_FIELDS_LANG_TABLE . " WHERE field_id = $field_id");

$db->sql_query('DELETE FROM ' . PROFILE_LANG_TABLE . " WHERE field_id = $field_id");

$db_tools = $phpbb_container->get('dbal.tools');

$db_tools->sql_column_remove(PROFILE_FIELDS_DATA_TABLE, 'pf_' . $field_ident);

$db->sql_transaction('commit');

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

}

else

$field_ident = (string) $db->sql_fetchfield('field_ident');

$db->sql_freeresult($result);

if ($request->is_ajax())

{

));

}

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

case 'create':

case 'edit':

$submit = (isset($_REQUEST['next']) || isset($_REQUEST['prev'])) ? true : false;

$save = (isset($_REQUEST['save'])) ? true : false;

// We are adding a new field, define basic params

$lang_options = $field_row = array();

if (!isset($this->type_collection[$field_type]))

{

$profile_field = $this->type_collection[$field_type];

$field_row = array_merge($profile_field->get_default_option_values(), array(

'field_required' => 0,

'field_show_novalue'=> 0,

'field_hide' => 0,

'field_is_contact' => 0,

'field_contact_desc'=> '',

'field_contact_url' => '',

'lang_explain' => '',

'lang_default_value'=> '')

);

$options = $profile_field->prepare_options_form($exclude, $visibility_ary);

$cp->vars['lang_name'] = $request->variable('lang_name', $field_row['lang_name'], true);

$cp->vars['lang_explain'] = $request->variable('lang_explain', $field_row['lang_explain'], true);

$cp->vars['lang_default_value'] = $request->variable('lang_default_value', $field_row['lang_default_value'], true);

// step 2

foreach ($exclude[2] as $key)

{

$field_data = $cp->vars;

$var = $profile_field->get_excluded_options($key, $action, $var, $field_data, 2);

foreach ($exclude[3] as $key)

{

if (!$cp->vars[$key] && $action == 'edit')

{

}

$field_data = $cp->vars;

*/

function build_language_options(&$cp, $field_type, $action = 'create')

{

$default_lang_id = (!empty($this->edit_lang_id)) ? $this->edit_lang_id : $this->lang_defs['iso'][$config['default_lang']];

$lang_options[$lang_id]['lang_iso'] = $lang_iso;

foreach ($options as $field => $field_type)

{

if ($field == 'lang_options')

{

$var = (!isset($cp->vars['l_lang_options'][$lang_id]) || !is_array($cp->vars['l_lang_options'][$lang_id])) ? $cp->vars['lang_options'] : $cp->vars['l_lang_options'][$lang_id];

*/

function save_profile_field(&$cp, $field_type, $action = 'create')

{

// Collect all information, if something is going wrong, abort the operation

$profile_sql = $profile_lang = $empty_lang = $profile_lang_fields = array();

if ($action == 'create')

{

$field_ident = 'pf_' . $field_ident;

$db_tools = $phpbb_container->get('dbal.tools');

$db_tools->sql_column_add(PROFILE_FIELDS_DATA_TABLE, $field_ident, array($profile_field->get_database_column_type(), null));

}

if ($action == 'edit')

{

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

}

else

{

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

}

}

*/

function prune_forums($id, $mode)

{

global $config, $phpbb_root_path, $phpbb_admin_path, $phpEx;

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

if ($all_forums)

{

if (confirm_box(true))

{

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

$prune_flags = 0;

// Convert days to seconds for timestamp functions...

$prunedate_posted = time() - ($prune_posted * 86400);

// Sync all pruned forums at once

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

}

$db->sql_freeresult($result);

'all_forums' => $all_forums,

'f' => $forum_id,

)));

}

}

*/

function prune_users($id, $mode)

{

global $config, $phpbb_root_path, $phpbb_admin_path, $phpEx;

$user->add_lang('memberlist');

if ($prune)

{

if (confirm_box(true))

{

}

}

$msg = $user->lang['USER_' . strtoupper($action) . '_SUCCESS'];

}

else

'mode' => $mode,

'prune' => 1,

)), 'confirm_body_prune.html');

}

}

{

global $user, $db, $request;

$posts_on_queue = (trim($request->variable('posts_on_queue', '')) === '') ? false : $request->variable('posts_on_queue', 0);

if ($users_by_name)

}

else

{

$active = ($active) ? explode('-', $active) : array();

$joined_before = ($joined_before) ? explode('-', $joined_before) : array();

$where_sql .= ($username) ? ' AND username_clean ' . $db->sql_like_expression(str_replace('*', $db->get_any_char(), utf8_clean_string($username))) : '';

$where_sql .= ($email) ? ' AND user_email ' . $db->sql_like_expression(str_replace('*', $db->get_any_char(), $email)) . ' ' : '';

$where_sql .= $joined_sql;

// First handle pruning of users who never logged in, last active date is 0000-00-00

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

AND ug.user_id <> ' . ANONYMOUS . '

AND u.user_type <> ' . USER_FOUNDER . '

AND ug.user_pending = 0 ' .

AND u.user_id = ug.user_id';

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

FROM ' . POSTS_TABLE . ' p, ' . USERS_TABLE . ' u

WHERE u.user_id <> ' . ANONYMOUS . '

AND u.user_type <> ' . USER_FOUNDER .

AND ' . $db->sql_in_set('p.post_visibility', array(ITEM_UNAPPROVED, ITEM_REAPPROVE)) . '

AND u.user_id = p.poster_id

GROUP BY p.poster_id

function main($id, $mode)

{

global $db, $user, $auth, $template, $cache, $request, $phpbb_dispatcher;

$user->add_lang('acp/posting');

// Set up general vars

$action = (isset($_POST['add'])) ? 'add' : $action;

$action = (isset($_POST['save'])) ? 'save' : $action;

$this->tpl_name = 'acp_ranks';

$this->page_title = 'ACP_MANAGE_RANKS';

{

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

}

// The rank image has to be a jpg, gif or png

if ($rank_image != '' && !preg_match('#(\.gif|\.png|\.jpg|\.jpeg)$#i', $rank_image))

$sql = 'UPDATE ' . RANKS_TABLE . ' SET ' . $db->sql_build_array('UPDATE', $sql_ary) . " WHERE rank_id = $rank_id";

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

}

else

{

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

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

}

$db->sql_query($sql);

$cache->destroy('_ranks');

if ($request->is_ajax())

{

{

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

global $config, $phpbb_root_path, $phpbb_admin_path, $phpEx;

$user->add_lang(array('mcp', 'acp/posting'));

// Set up general vars

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

$this->tpl_name = 'acp_reasons';

$this->page_title = 'ACP_REASONS';

case 'edit':

$reason_row = array(

);

if ($submit)

$log = 'UPDATED';

}

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

}

}

$db->sql_query('DELETE FROM ' . REPORTS_REASONS_TABLE . ' WHERE reason_id = ' . $reason_id);

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

}

else

function settings($id, $mode)

{

global $config, $phpbb_root_path, $phpbb_admin_path, $phpEx;

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

unset($search);

unset($error);

foreach ($settings as $config_name => $var_type)

{

// only change config if anything was actually changed

if ($submit && ($config[$config_name] != $config_value))

{

$updated = true;

}

}

$extra_message = '';

if ($updated)

{

}

if (isset($cfg_array['search_type']) && in_array($cfg_array['search_type'], $search_types, true) && ($cfg_array['search_type'] != $config['search_type']))

{

if (!method_exists($search, 'init') || !($error = $search->init()))

{

if (!$updated)

{

}

$extra_message = '<br />' . $user->lang['SWITCHED_SEARCH_BACKEND'] . '<br /><a href="' . append_sid("{$phpbb_admin_path}index.$phpEx", 'i=search&amp;mode=index') . '">&raquo; ' . $user->lang['GO_TO_SEARCH_INDEX'] . '</a>';

}

function index($id, $mode)

{

global $config, $phpbb_root_path, $phpbb_admin_path, $phpEx;

$this->state = explode(',', $config['search_indexing_state']);

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

switch ($action)

{

case 'progress_bar':

$this->display_progress_bar($type);

break;

if (empty($this->state[0]))

{

}

$this->search = null;

$this->state = array('');

$this->save_state();

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

break;

$this->state = array('');

$this->save_state();

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

break;

}

function save_state($state = false)

{

if ($state)

{

$this->state = $state;

ksort($this->state);

}

/**

if (!isset($config['questionnaire_unique_id']))

{

$install_id = unique_id();

}

else

{

protected $styles_list_cols = 0;

protected $reserved_style_names = array('adm', 'admin', 'all');

/** @var \phpbb\db\driver\driver_interface */

protected $db;

*/

protected function action_uninstall_confirmed($ids, $delete_files)

{

$default = $this->default_style;

$uninstalled = array();

$messages = array();

// Log action

if (count($uninstalled))

{

}

// Clear cache

*/

protected function action_details()

{

$id = $this->request->variable('id', 0);

if (!$id)

{

$this->cache->purge();

}

}

}

// Update default style

{

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

}

$this->cache->purge();

}

*/

protected function install_style($style)

{

// Generate row

$sql_ary = array();

foreach ($style as $key => $value)

$this->db->sql_transaction('commit');

return $id;

}

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

global $phpbb_root_path, $phpbb_admin_path, $phpEx, $table_prefix, $file_uploads;

global $phpbb_dispatcher, $request;

$user->add_lang(array('posting', 'ucp', 'acp/users'));

$this->tpl_name = 'acp_users';

$error = array();

$submit = (isset($_POST['update']) && !isset($_POST['cancel'])) ? true : false;

$this->page_title = 'WHOIS';

$this->tpl_name = 'simple_body';

$domain = gethostbyaddr($user_ip);

$ipwhois = user_ipwhois($user_ip);

$user->add_lang('acp/ban');

/**

* Run code at beginning of ACP users overview

{

user_delete($delete_type, $user_id, $user_row['username']);

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

}

else

break;

}

// Log not used at the moment, we simply utilize the ban function.

$result = user_ban(substr($action, 3), $ban, 0, 0, 0, $ban_reason, $ban_give_reason);

$messenger->send(NOTIFY_EMAIL);

trigger_error($user->lang['FORCE_REACTIVATION_SUCCESS'] . adm_back_link($this->u_action . '&amp;u=' . $user_id));

}

$message = ($user_row['user_type'] == USER_INACTIVE) ? 'USER_ADMIN_ACTIVATED' : 'USER_ADMIN_DEACTIVED';

$log = ($user_row['user_type'] == USER_INACTIVE) ? 'LOG_USER_ACTIVE' : 'LOG_USER_INACTIVE';

trigger_error($user->lang[$message] . adm_back_link($this->u_action . '&amp;u=' . $user_id));

WHERE user_id = $user_id";

$db->sql_query($sql);

trigger_error($user->lang['USER_ADMIN_SIG_REMOVED'] . adm_back_link($this->u_action . '&amp;u=' . $user_id));

$phpbb_avatar_manager = $phpbb_container->get('avatar.manager');

$phpbb_avatar_manager->handle_avatar_delete($db, $user, $phpbb_avatar_manager->clean_row($user_row, 'user'), USERS_TABLE, 'user_');

trigger_error($user->lang['USER_ADMIN_AVATAR_REMOVED'] . adm_back_link($this->u_action . '&amp;u=' . $user_id));

break;

// Delete posts, attachments, etc.

delete_posts('poster_id', $user_id);

trigger_error($user->lang['USER_POSTS_DELETED'] . adm_back_link($this->u_action . '&amp;u=' . $user_id));

}

else

{

delete_attachments('user', $user_id);

trigger_error($user->lang['USER_ATTACHMENTS_REMOVED'] . adm_back_link($this->u_action . '&amp;u=' . $user_id));

}

else

delete_pm($user_id, $msg_ids, PRIVMSGS_OUTBOX);

$lang = 'EMPTIED';

}

$user->add_lang('acp/forums');

if (!$new_forum_id)

{

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

}

trigger_error($user->lang['USER_POSTS_MOVED'] . adm_back_link($this->u_action . '&amp;u=' . $user_id));

{

remove_newly_registered($user_id, $user_row);

trigger_error($user->lang['USER_LIFTED_NR'] . adm_back_link($this->u_action . '&amp;u=' . $user_id));

}

else

// Handle registration info updates

$data = array(

'new_password' => $request->variable('new_password', '', true),

'password_confirm' => $request->variable('password_confirm', '', true),

);

$sql_ary['username'] = $update_username;

$sql_ary['username_clean'] = utf8_clean_string($update_username);

}

if ($update_email !== false)

'user_email_hash' => phpbb_email_hash($update_email),

);

}

if ($update_password)

);

$user->reset_login_keys($user_id);

}

if (sizeof($sql_ary))

// Let the users permissions being updated

$auth->acl_clear_prefetch($user_id);

trigger_error($user->lang['USER_OVERVIEW_UPDATED'] . adm_back_link($this->u_action . '&amp;u=' . $user_id));

}

$user->add_lang('mcp');

// Set up general vars

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

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

/* @var $pagination \phpbb\pagination */

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

// Sort keys

// Delete entries if requested and able

if (($deletemark || $deleteall) && $auth->acl_get('a_clearlogs'))

$where_sql";

$db->sql_query($sql);

}

}

trigger_error($user->lang['FORM_INVALID'] . adm_back_link($this->u_action . '&amp;u=' . $user_id), E_USER_WARNING);

}

trigger_error($user->lang['USER_FEEDBACK_ADDED'] . adm_back_link($this->u_action . '&amp;u=' . $user_id));

}

$user->add_lang('mcp');

// Set up general vars

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

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

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

// Sort keys

// Delete entries if requested and able

if ($deletemark || $deleteall || $confirm)

if (confirm_box(true))

{

$where_sql = '';

if ($deletemark && $marked)

{

$where_sql = ' AND ' . $db->sql_in_set('warning_id', array_values($marked));

if ($log_warnings)

{

}

else

{

}

}

}

$user_row['iso_lang_id'] = $row['lang_id'];

$data = array(

'bday_day' => 0,

'bday_month' => 0,

'bday_year' => 0,

list($data['bday_day'], $data['bday_month'], $data['bday_year']) = explode('-', $user_row['user_birthday']);

}

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

if ($submit)

{

$error = validate_data($data, array(

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

);

$sql = 'UPDATE ' . USERS_TABLE . '

SET ' . $db->sql_build_array('UPDATE', $sql_ary) . "

WHERE user_id = $user_id";

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

$data = array(

);

/**

trigger_error($user->lang['FORM_INVALID'] . adm_back_link($this->u_action . '&amp;u=' . $user_id), E_USER_WARNING);

}

$sql = 'UPDATE ' . USERS_TABLE . "

SET user_rank = $rank_id

/* @var $pagination \phpbb\pagination */

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

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

// Sort keys

if ($deletemark && sizeof($marked))

{

$message = (sizeof($log_attachments) == 1) ? $user->lang['ATTACHMENT_DELETED'] : $user->lang['ATTACHMENTS_DELETED'];

trigger_error($message . adm_back_link($this->u_action . '&amp;u=' . $user_id));

}

else

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

$user->add_lang(array('groups', 'acp/groups'));

if ($group_id)

{

$user->add_lang('acp/permissions');

add_permission_language();

// Global Permissions

if (!$forum_id)

function main($id, $mode)

{

global $config, $phpbb_root_path, $phpbb_admin_path, $phpEx;

$user->add_lang('acp/posting');

// Set up general vars

$action = (isset($_POST['add'])) ? 'add' : ((isset($_POST['save'])) ? 'save' : $action);

$s_hidden_fields = '';

{

case 'edit':

if (!$word_id)

{

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

}

if ($word === '' || $replacement === '')

{

$cache->destroy('_word_censors');

$log_action = ($word_id) ? 'LOG_WORD_EDIT' : 'LOG_WORD_ADD';

$message = ($word_id) ? $user->lang['WORD_UPDATED'] : $user->lang['WORD_ADDED'];

trigger_error($message . adm_back_link($this->u_action));

case 'delete':

if (!$word_id)

{

$cache->destroy('_word_censors');

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

}

/* @var $db \phpbb\db\driver\driver_interface */

$db = $phpbb_container->get('dbal.conn');

// Grab global variables, re-cache if necessary

/* @var $config phpbb\config\db */

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

/* @var $phpbb_log \phpbb\log\log_interface */

$phpbb_log = $phpbb_container->get('log');

}

/**

* Generates an alphanumeric random string of given length

*

* @return string

if ($dss_seeded !== true && ($config['rand_seed_last_update'] < time() - rand(1,10)))

{

$dss_seeded = true;

}

function markread($mode, $forum_id = false, $topic_id = false, $post_time = 0, $user_id = 0)

{

global $db, $user, $config;

$post_time = ($post_time === 0 || $post_time > time()) ? time() : (int) $post_time;

if ($mode == 'all')

{

if ($forum_id === false || !sizeof($forum_id))

*/

function get_unread_topics($user_id = false, $sql_extra = '', $sql_sort = '', $sql_limit = 1001, $sql_limit_offset = 0)

{

$user_id = ($user_id === false) ? (int) $user->data['user_id'] : (int) $user_id;

$sql_sort",

);

$sql = $db->sql_build_query('SELECT', $sql_array);

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

if (empty($tracking_topics))

{

$tracking_topics = ($tracking_topics) ? tracking_unserialize($tracking_topics) : array();

}

{

global $config, $user, $phpbb_path_helper;

// Append SID

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

function confirm_box($check, $title = '', $hidden = '', $html_body = 'confirm_body.html', $u_action = '')

{

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

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

{

if ($check && $confirm)

{

if ($user_id != $user->data['user_id'] || $session_id != $user->session_id || !$confirm_key || !$user->data['user_last_confirm_key'] || $confirm_key != $user->data['user_last_confirm_key'])

{

);

// If activation key already exist, we better do not re-use the key (something very strange is going on...)

{

// This should not occur, therefore we cancel the operation to safe the user

return false;

}

// re-add sid / transform & to &amp; for user->page (user->page is always using &)

$u_action .= ((strpos($u_action, '?') === false) ? '?' : '&amp;') . 'confirm_key=' . $confirm_key;

$template->assign_vars(array(

function login_box($redirect = '', $l_explain = '', $l_success = '', $admin = false, $s_display = true)

{

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

$err = '';

// anonymous/inactive users are never able to go to the ACP even if they have the relevant permissions

if ($user->data['is_registered'])

{

}

trigger_error('NO_AUTH_ADMIN');

}

// Get credential

if ($admin)

{

if (strspn($credential, 'abcdef0123456789') !== strlen($credential) || strlen($credential) != 32)

{

if ($user->data['is_registered'])

{

}

trigger_error('NO_AUTH_ADMIN');

}

$password = $request->untrimmed_variable('password', '', true);

}

$autologin = $request->is_set_post('autologin');

$viewonline = (int) !$request->is_set_post('viewonline');

$admin = ($admin) ? 1 : 0;

if ($admin && utf8_clean_string($username) != utf8_clean_string($user->data['username']))

{

// We log the attempt to use a different username...

trigger_error('NO_AUTH_ADMIN_USER_DIFFER');

}

{

if ($result['status'] == LOGIN_SUCCESS)

{

}

else

{

// anonymous/inactive users are never able to go to the ACP even if they have the relevant permissions

if ($user->data['is_registered'])

{

}

}

}

// The result parameter is always an array, holding the relevant information...

if ($result['status'] == LOGIN_SUCCESS)

{

/**

* This event allows an extension to modify the redirection when a user successfully logs in

}

/**

* Return a nicely formatted backtrace.

*

* Turns the array returned by debug_backtrace() into HTML markup.

case 'email':

// Regex written by James Watts and Francisco Jose Martin Moreno

// http://fightingforalostcause.net/misc/2006/compare-email-regex.php

break;

case 'bbcode_htm':

function msg_handler($errno, $msg_text, $errfile, $errline)

{

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

// Do not display notices if we suppress them via @

if (error_reporting() == 0 && $errno != E_USER_ERROR && $errno != E_USER_WARNING && $errno != E_USER_NOTICE)

// we are writing an image - the user won't see the debug, so let's place it in the log

if (defined('IMAGE_OUTPUT') || defined('IN_CRON'))

{

}

// echo '<br /><br />BACKTRACE<br />' . get_backtrace() . '<br />' . "\n";

}

{

// let's avoid loops

$db->sql_return_on_error(true);

$db->sql_return_on_error(false);

}

*/

function obtain_users_online_string($online_users, $item_id = 0, $item = 'forum')

{

// Need caps version of $item for language-strings

$item_caps = strtoupper($item);

FROM ' . USERS_TABLE . '

WHERE ' . $db->sql_in_set('user_id', $online_users['online_users']) . '

ORDER BY username_clean ASC';

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

{

// User is logged in and therefore not a guest

if ($row['user_id'] != ANONYMOUS)

if (!isset($online_users['hidden_users'][$row['user_id']]) || $auth->acl_get('u_viewonline'))

{

}

}

}

}

if (!$online_userlist)

{

$l_online_users = $user->lang('ONLINE_USERS_TOTAL', (int) $online_users['total_online'], $visible_online, $hidden_online);

}

return array(

'online_userlist' => $online_userlist,

'l_online_users' => $l_online_users,

if ($total_online_users > $config['record_online_users'])

{

}

$l_online_record = $user->lang('RECORD_ONLINE_USERS', (int) $config['record_online_users'], $user->format_date($config['record_online_date'], false, true));

}

}

$s_feed_news = false;

*/

function copy_forum_permissions($src_forum_id, $dest_forum_ids, $clear_dest_perms = true, $add_log = true)

{

// Only one forum id specified

if (!is_array($dest_forum_ids))

if ($add_log)

{

}

$db->sql_transaction('commit');

if ($approved_topics)

{

}

/* @var $phpbb_notifications \phpbb\notification\manager */

if ($approved_posts && $post_count_sync)

{

}

// We actually remove topics now to not be inconsistent (the delete_topics function calls this function too)

if ($space_removed || $files_removed)

{

}

// If we do not resync, we do not need to adjust any message, post, topic or user entries

*/

function auto_prune($forum_id, $prune_mode, $prune_flags, $prune_days, $prune_freq)

{

$sql = 'SELECT forum_name

FROM ' . FORUMS_TABLE . "

WHERE forum_id = $forum_id";

$db->sql_query($sql);

}

return;

$db->sql_transaction('commit');

}

}

/**

*/

function tidy_database()

{

// Here we check permission consistency

WHERE ' . $db->sql_in_set('forum_id', $forum_ids, true);

$db->sql_query($sql);

}

/**

* @param string $path Path to clean

* @return string Cleaned path

*

*/

function phpbb_clean_path($path)

{

*

* @return string Returns the options for timezone selector only

*

*/

function tz_select($default = '', $truncate = false)

{

* via admin_permissions. Changes of usernames and group names

* must be carried through for the moderators table.

*

* @return null

*/

function cache_moderators()

/**

* Removes moderators and administrators from foe lists.

*

* @param array|bool $group_id If an array, remove all members of this group from foe lists, or false to ignore

* @param array|bool $user_id If an array, remove this user from foe lists, or false to ignore

* @return null

return $file_data;

}

foreach ($sorts as $name => $sort_ary)

{

$key = $sort_ary['key'];

// Check if the key is selectable. If not, we reset to the default or first key found.

// This ensures the values are always valid. We also set $sort_dir/sort_key/etc. to the

{

if ($sort_ary['default'] !== false)

{

}

else

{

@reset($sort_ary['options']);

}

}

/**

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

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

*

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

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

$config_value = truncate_string(utf8_htmlspecialchars($config_value), 255, 255, false);

}

}

}

}

if ($row)

{

}

// Also do not reset record online user/date. There will be old data or the fresh data from the schema.

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

$db->sql_freeresult($result);

$sql = 'SELECT COUNT(topic_id) AS stat

FROM ' . TOPICS_TABLE . '

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

$db->sql_freeresult($result);

$sql = 'SELECT COUNT(user_id) AS stat

FROM ' . USERS_TABLE . '

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

$db->sql_freeresult($result);

$sql = 'SELECT COUNT(attach_id) as stat

FROM ' . ATTACHMENTS_TABLE . '

WHERE is_orphan = 0';

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

$db->sql_freeresult($result);

$sql = 'SELECT SUM(filesize) as stat

FROM ' . ATTACHMENTS_TABLE . '

WHERE is_orphan = 0';

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

$db->sql_freeresult($result);

/**

$sql_from = '';

// Mark forums read?

if ($mark_read == 'all')

{

$redirect = build_url(array('mark', 'hash', 'mark_time'));

meta_refresh(3, $redirect);

{

if ($request->is_ajax())

{

if ($mark_read == 'forums')

{

$redirect = build_url(array('mark', 'hash', 'mark_time'));

if (check_link_hash($token, 'global'))

{

$message = sprintf($user->lang['RETURN_FORUM'], '<a href="' . $redirect . '">', '</a>');

meta_refresh(3, $redirect);

{

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

{

if ($token && check_link_hash($token, "{$mode}_$match_id") || confirm_box(true))

{

{

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

{

if ($token && check_link_hash($token, "{$mode}_$match_id") || confirm_box(true))

{

*/

function send_file_to_browser($attachment, $upload_dir, $category)

{

$filename = $phpbb_root_path . $upload_dir . '/' . $attachment['physical_filename'];

header('X-Content-Type-Options: nosniff');

}

{

// We use content-disposition: inline for flash files and view=1 to let it correctly play with flash player 10 - any other disposition will fail to play inline

header('Content-Disposition: inline');

}

}

// Close the db connection before sending the file etc.

file_gc(false);

exit;

}

// Try to deliver in chunks

@set_time_limit(0);

}

/**

* Used to test whether we are able to connect to the database the user has specified

* and identify any problems (eg there are already tables with the names we want to use

* @param array $dbms should be of the format of an element of the array returned by {@link get_available_dbms get_available_dbms()}

$temp_prefix = strtolower($table_prefix);

$table_ary = array($temp_prefix . 'attachments', $temp_prefix . 'config', $temp_prefix . 'sessions', $temp_prefix . 'topics', $temp_prefix . 'users');

$tables = array_map('strtolower', $tables);

$table_intersect = array_intersect($tables, $table_ary);

*/

function phpbb_mcp_sorting($mode, &$sort_days, &$sort_key, &$sort_dir, &$sort_by_sql, &$sort_order_sql, &$total, $forum_id = 0, $topic_id = 0, $where_sql = 'WHERE')

{

$min_time = ($sort_days) ? time() - ($sort_days * 86400) : 0;

switch ($mode)

AND t.topic_id = p.topic_id

AND t.topic_visibility <> p.post_visibility';

if ($min_time)

{

$sql .= ' AND post_time >= ' . $min_time;

break;

}

$sort_dir_text = array('a' => $user->lang['ASCENDING'], 'd' => $user->lang['DESCENDING']);

switch ($type)

*/

function error($type, $msg)

{

// Session doesn't exist, create it

if (!isset($user->session_id) || $user->session_id === '')

}

$message .= '<br /><em>' . htmlspecialchars($calling_page) . '</em><br /><br />' . $msg . '<br />';

}

/**

foreach ($address_ary as $which_ary)

{

}

}

{

if (!$have_cache_file)

{

}

$lock->release();

return;

}

include($this->cache_file);

*/

function set_active($id = false, $mode = false)

{

$icat = false;

$this->active_module = false;

{

$icat = $id;

}

// Restore the backslashes in class names

*/

function load_active($mode = false, $module_url = false, $execute_module = true)

{

$module_path = $this->include_path . $this->p_class;

if ($this->active_module === false)

{

*/

function generate_smilies($mode, $forum_id)

{

global $phpEx, $phpbb_root_path, $phpbb_container, $phpbb_path_helper;

/* @var $pagination \phpbb\pagination */

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

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

if ($mode == 'window')

{

*/

function topic_review($topic_id, $forum_id, $mode = 'topic_review', $cur_post_id = 0, $show_quote_button = true)

{

/* @var $phpbb_content_visibility \phpbb\content_visibility */

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

$sql = $db->sql_build_query('SELECT', $sql_ary);

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

$rowset = array();

$has_attachments = false;

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

{

$rowset[$row['post_id']] = $row;

if ($row['post_attachment'])

{

}

$db->sql_freeresult($result);

// Grab extensions

$extensions = $attachments = array();

if ($has_attachments && $auth->acl_get('u_download') && $auth->acl_get('f_download', $forum_id))

$post_anchor = ($mode == 'post_review') ? 'ppr' . $row['post_id'] : 'pr' . $row['post_id'];

$u_show_post = append_sid($phpbb_root_path . 'viewtopic.' . $phpEx, "f=$forum_id&amp;t=$topic_id&amp;p={$row['post_id']}&amp;view=show#p{$row['post_id']}");

'POST_AUTHOR_FULL' => get_username_string('full', $poster_id, $row['username'], $row['user_colour'], $row['post_username']),

'POST_AUTHOR_COLOUR' => get_username_string('colour', $poster_id, $row['username'], $row['user_colour'], $row['post_username']),

'POST_AUTHOR' => get_username_string('username', $poster_id, $row['username'], $row['user_colour'], $row['post_username']),

'POST_ID' => $row['post_id'],

'U_MINI_POST' => append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'p=' . $row['post_id']) . '#p' . $row['post_id'],

'U_MCP_DETAILS' => ($auth->acl_get('m_info', $forum_id)) ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=main&amp;mode=post_details&amp;f=' . $forum_id . '&amp;p=' . $row['post_id'], true, $user->session_id) : '',

);

// Display not already displayed Attachments for this post, we already parsed them. ;)

if (!empty($attachments[$row['post_id']]))

{

*/

function submit_post($mode, $subject, $username, $topic_type, &$poll, &$data, $update_message = true, $update_search_index = true)

{

/**

* Modify the data for post submitting

if ($user->data['user_id'] != $poster_id)

{

$log_subject = ($subject) ? $subject : $data['topic_title'];

}

if (!isset($sql_data[POSTS_TABLE]['sql']))

{

if ($post_mode == 'post')

{

}

$sql_data[FORUMS_TABLE]['stat'][] = 'forum_last_post_id = ' . $data['post_id'];

$sql_data[FORUMS_TABLE]['stat'][] = "forum_last_post_subject = '" . $db->sql_escape($subject) . "'";

if ($space_taken && $files_added)

{

}

}

$db->sql_transaction('commit');

// Delete draft if post was loaded...

if ($draft_id)

{

$sql = 'DELETE FROM ' . DRAFTS_TABLE . "

*/

function phpbb_bump_topic($forum_id, $topic_id, $post_data, $bump_time = false)

{

if ($bump_time === false)

{

update_forum_tracking_info($forum_id, $forum_last_post_time, $f_mark_time, false);

}

$url = append_sid("{$phpbb_root_path}viewtopic.$phpEx", "f=$forum_id&amp;t=$topic_id&amp;p={$post_data['topic_last_post_id']}") . "#p{$post_data['topic_last_post_id']}";

function phpbb_handle_post_delete($forum_id, $topic_id, $post_id, &$post_data, $is_soft = false, $delete_reason = '')

{

global $user, $auth, $config, $request;

$perm_check = ($is_soft) ? 'softdelete' : 'delete';

if ($next_post_id === false)

{

$meta_info = append_sid("{$phpbb_root_path}viewforum.$phpEx", "f=$forum_id");

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

}

else

{

$meta_info = append_sid("{$phpbb_root_path}viewtopic.$phpEx", "f=$forum_id&amp;t=$topic_id&amp;p=$next_post_id") . "#p$next_post_id";

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

*/

function handle_mark_actions($user_id, $mark_action)

{

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

if (!sizeof($msg_ids))

$_types = array('u', 'g');

foreach ($_types as $type)

{

{

{

$address[$type][$id] = $check_type;

}

*/

function submit_pm($mode, $subject, &$data, $put_in_outbox = true)

{

// We do not handle erasing pms here

if ($mode == 'delete')

if ($space_taken && $files_added)

{

}

}

// Delete draft if post was loaded...

if ($draft_id)

{

$sql = 'DELETE FROM ' . DRAFTS_TABLE . "

*/

function message_history($msg_id, $user_id, $message_row, $folder, $in_post_mode = false)

{

// Select all receipts and the author from the pm we currently view, to only display their pm-history

$sql = 'SELECT author_id, user_id

$title = $row['message_subject'];

$rowset = array();

$folder_url = append_sid("{$phpbb_root_path}ucp.$phpEx", 'i=pm') . '&amp;folder=';

do

else

{

$rowset[$row['msg_id']] = $row;

}

}

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

return false;

}

$title = censor_text($title);

$url = append_sid("{$phpbb_root_path}ucp.$phpEx", 'i=pm');

$which_ary = ($user_id_ary) ? 'user_id_ary' : 'username_ary';

{

}

$user_id_ary = $username_ary = array();

*/

function update_last_username()

{

// Get latest username

$sql = 'SELECT user_id, username, user_colour

if ($row)

{

}

}

if ($config['newest_username'] == $old_name)

{

}

/**

{

global $phpbb_log;

$phpbb_log->disable('admin');

// Add user to "newly registered users" group and set to default group if admin specified so.

// set the newest user and adjust the user count if the user is a normal user and no activation mail is sent

if ($user_row['user_type'] == USER_NORMAL || $user_row['user_type'] == USER_FOUNDER)

{

$sql = 'SELECT group_colour

FROM ' . GROUPS_TABLE . '

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

$db->sql_freeresult($result);

}

// Use default notifications settings if notifications_data is not set

*/

function user_delete($mode, $user_ids, $retain_username = true)

{

global $phpbb_root_path, $phpEx;

$db->sql_transaction('begin');

if ($num_users_delta != 0)

{

}

// Now do the invariant tasks

}

phpbb_delete_users_pms($user_ids);

$db->sql_transaction('commit');

/**

*/

function user_active_flip($mode, $user_id_ary, $reason = INACTIVE_MANUAL)

{

$deactivated = $activated = 0;

$sql_statements = array();

}

$db->sql_freeresult($result);

if (sizeof($sql_statements))

{

foreach ($sql_statements as $user_id => $sql_ary)

$auth->acl_clear_prefetch(array_keys($sql_statements));

}

if ($deactivated)

{

}

if ($activated)

{

}

// Update latest username

*/

function user_ban($mode, $ban, $ban_len, $ban_len_other, $ban_exclude, $ban_reason, $ban_give_reason = '')

{

// Delete stale bans

$sql = 'DELETE FROM ' . BANLIST_TABLE . '

$log_entry = ($ban_exclude) ? 'LOG_BAN_EXCLUDE_' : 'LOG_BAN_';

// Add to admin log, moderator log and user notes

if ($mode == 'user')

{

foreach ($banlist_ary as $user_id)

{

}

}

*/

function user_unban($mode, $ban)

{

// Delete stale bans

$sql = 'DELETE FROM ' . BANLIST_TABLE . '

$db->sql_query($sql);

// Add to moderator log, admin log and user notes

if ($mode == 'user')

{

foreach ($user_ids_ary as $user_id)

{

}

}

}

*/

function group_create(&$group_id, $type, $name, $desc, $group_attributes, $allow_desc_bbcode = false, $allow_desc_urls = false, $allow_desc_smilies = false)

{

$error = array();

}

$name = ($type == GROUP_SPECIAL) ? $user->lang['G_' . $name] : $name;

group_update_listings($group_id);

}

*/

function group_delete($group_id, $group_name = false)

{

if (!$group_name)

{

phpbb_cache_moderators($db, $cache, $auth);

// Return false - no error

return false;

*/

function group_user_add($group_id, $user_id_ary = false, $username_ary = false, $group_name = false, $default = false, $leader = 0, $pending = 0, $group_attributes = false)

{

// We need both username and user_id info

$result = user_get_id_name($user_id_ary, $username_ary);

$log = ($leader) ? 'LOG_MODS_ADDED' : (($pending) ? 'LOG_USERS_PENDING' : 'LOG_USERS_ADDED');

group_update_listings($group_id);

*/

function group_user_del($group_id, $user_id_ary = false, $username_ary = false, $group_name = false)

{

if ($config['coppa_enable'])

{

if ($group_name)

{

}

group_update_listings($group_id);

*/

function group_user_attributes($action, $group_id, $user_id_ary = false, $username_ary = false, $group_name = false, $group_attributes = false)

{

// We need both username and user_id info

$result = user_get_id_name($user_id_ary, $username_ary);

// Clear permissions cache of relevant users

$auth->acl_clear_prefetch($user_id_ary);

group_update_listings($group_id);

*/

function group_set_user_default($group_id, $user_id_ary, $group_attributes = false, $update_listing = false)

{

if (empty($user_id_ary))

{

if (isset($sql_ary[$avatar_option]))

{

$avatar_sql_ary[$avatar_option] = $sql_ary[$avatar_option];

}

$sql = 'UPDATE ' . USERS_TABLE . '

SET ' . $db->sql_build_array('UPDATE', $avatar_sql_ary) . "

WHERE " . $db->sql_in_set('topic_last_poster_id', $user_id_ary);

$db->sql_query($sql);

if (in_array($config['newest_user_id'], $user_id_ary))

{

}

}

}

$forum_id = $forum_info['forum_id'];

$url_extra = '';

$url_extra .= ($forum_id) ? "&amp;f=$forum_id" : '';

switch ($action)

{

case 'resync':

mcp_resync_topics($topic_ids);

break;

*/

function mcp_resync_topics($topic_ids)

{

if (!sizeof($topic_ids))

{

// Log this action

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

{

}

$db->sql_freeresult($result);

$msg = (sizeof($topic_ids) == 1) ? $user->lang['TOPIC_RESYNC_SUCCESS'] : $user->lang['TOPICS_RESYNC_SUCCESS'];

meta_refresh(3, $redirect);

trigger_error($msg . '<br /><br />' . sprintf($user->lang['RETURN_PAGE'], '<a href="' . $redirect . '">', '</a>'));

*/

function merge_topics($forum_id, $topic_ids, $to_topic_id)

{

if (!sizeof($topic_ids))

{

$topic_data = $topic_data[$to_topic_id];

if (!sizeof($post_id_list) && sizeof($topic_ids))

{

return;

}

$s_hidden_fields = build_hidden_fields(array(

'i' => 'main',

$to_forum_id = $topic_data['forum_id'];

move_posts($post_id_list, $to_topic_id, false);

// Message and return links

$success_msg = 'POSTS_MERGED_SUCCESS';

// Link to the new topic

$return_link .= (($return_link) ? '<br /><br />' : '') . sprintf($user->lang['RETURN_NEW_TOPIC'], '<a href="' . append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $to_forum_id . '&amp;t=' . $to_topic_id) . '">', '</a>');

$redirect = reapply_sid($redirect);

meta_refresh(3, $redirect);

{

global $phpEx, $phpbb_root_path, $config;

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

// Latest 5 unapproved

if ($module->loaded('queue'))

$post_list = array();

$forum_names = array();

$template->assign_var('S_SHOW_UNAPPROVED', (!empty($forum_list)) ? true : false);

'ATTACH_ICON_IMG' => ($auth->acl_get('u_download') && $auth->acl_get('f_download', $row['forum_id']) && $row['post_attachment']) ? $user->img('icon_topic_attach', $user->lang['TOTAL_ATTACHMENTS']) : '',

));

}

}

$template->assign_vars(array(

$pm_by_id[(int) $row['msg_id']] = $row;

$pm_list[] = (int) $row['msg_id'];

}

$address_list = get_recipient_strings($pm_by_id);

function main($id, $mode)

{

global $config, $phpbb_root_path, $phpEx, $phpbb_container, $phpbb_log;

$user->add_lang('acp/common');

if (is_array($action))

{

}

else

{

}

// Set up general vars

$deletemark = ($action == 'del_marked') ? true : false;

$deleteall = ($action == 'del_all') ? true : false;

// Sort keys

$this->tpl_name = 'mcp_logs';

$this->page_title = 'MCP_LOGS';

break;

case 'forum_logs':

if (!in_array($forum_id, $forum_list))

{

break;

case 'topic_logs':

$sql = 'SELECT forum_id

FROM ' . TOPICS_TABLE . '

}

else if ($deleteall)

{

$conditions = array(

'forum_id' => array('IN' => $forum_list),

'sd' => $sort_dir,

'i' => $id,

'mode' => $mode,

);

}

}

$sql_where = ($sort_days) ? (time() - ($sort_days * 86400)) : 0;

$sql_sort = $sort_by_sql[$sort_key] . ' ' . (($sort_dir == 'd') ? 'DESC' : 'ASC');

$keywords_param = !empty($keywords) ? '&amp;keywords=' . urlencode(htmlspecialchars_decode($keywords)) : '';

// Grab log data

{

case 'lock':

case 'unlock':

if (!sizeof($topic_ids))

{

case 'lock_post':

case 'unlock_post':

if (!sizeof($post_ids))

{

case 'make_global':

case 'make_normal':

if (!sizeof($topic_ids))

{

case 'move':

$user->add_lang('viewtopic');

if (!sizeof($topic_ids))

{

case 'fork':

$user->add_lang('viewtopic');

if (!sizeof($topic_ids))

{

$user->add_lang('viewforum');

$forum_info = phpbb_get_forum_data($forum_id, 'm_', true);

*/

function lock_unlock($action, $ids)

{

if ($action == 'lock' || $action == 'unlock')

{

}

unset($orig_ids);

$redirect = reapply_sid($redirect);

$s_hidden_fields = build_hidden_fields(array(

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

{

}

$success_msg = $l_prefix . ((sizeof($ids) == 1) ? '' : 'S') . '_' . (($action == 'lock' || $action == 'lock_post') ? 'LOCKED' : 'UNLOCKED') . '_SUCCESS';

*/

function change_topic_type($action, $topic_ids)

{

switch ($action)

{

return;

}

$redirect = reapply_sid($redirect);

$s_hidden_fields = array(

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

{

}

}

return;

}

$additional_msg = $success_msg = '';

$s_hidden_fields = build_hidden_fields(array(

confirm_box(false, 'MOVE_TOPIC' . ((sizeof($topic_ids) == 1) ? '' : 'S'), $s_hidden_fields, 'mcp_move.html');

}

$redirect = reapply_sid($redirect);

if (!$success_msg)

*/

function mcp_restore_topic($topic_ids)

{

if (!phpbb_check_ids($topic_ids, TOPICS_TABLE, 'topic_id', array('m_approve')))

{

$return = $phpbb_content_visibility->set_topic_visibility(ITEM_APPROVED, $topic_id, $row['forum_id'], $user->data['user_id'], time(), '');

if (!empty($return))

{

}

}

}

*/

function mcp_delete_topic($topic_ids, $is_soft = false, $soft_delete_reason = '', $action = 'delete_topic')

{

$check_permission = ($is_soft) ? 'm_softdelete' : 'm_delete';

if (!phpbb_check_ids($topic_ids, TOPICS_TABLE, 'topic_id', array($check_permission)))

{

if ($row['topic_moved_id'])

{

}

else

{

$return = $phpbb_content_visibility->set_topic_visibility(ITEM_DELETED, $topic_id, $row['forum_id'], $user->data['user_id'], time(), $soft_delete_reason);

if (!empty($return))

{

}

}

else

{

}

}

}

*/

function mcp_delete_post($post_ids, $is_soft = false, $soft_delete_reason = '', $action = 'delete_post')

{

$check_permission = ($is_soft) ? 'm_softdelete' : 'm_delete';

if (!phpbb_check_ids($post_ids, POSTS_TABLE, 'post_id', array($check_permission)))

foreach ($approve_log as $row)

{

$post_username = ($row['poster_id'] == ANONYMOUS && !empty($row['post_username'])) ? $row['post_username'] : $row['username'];

}

$topic_id = $request->variable('t', 0);

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

{

$post_username = ($row['poster_id'] == ANONYMOUS && !empty($row['post_username'])) ? $row['post_username'] : $row['username'];

}

// Now delete the posts, topics and forums are automatically resync'ed

function mcp_fork_topic($topic_ids)

{

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

if (!phpbb_check_ids($topic_ids, TOPICS_TABLE, 'topic_id', array('m_')))

{

return;

}

$additional_msg = $success_msg = '';

$counter = array();

$db->sql_query('INSERT INTO ' . POLL_OPTIONS_TABLE . ' ' . $db->sql_build_array('INSERT', $sql_ary));

}

}

$sql = 'SELECT *

sync('topic', 'topic_id', $new_topic_id_list);

sync('forum', 'forum_id', $to_forum_id);

foreach ($new_topic_id_list as $topic_id => $new_topic_id)

{

}

$success_msg = (sizeof($topic_ids) == 1) ? 'TOPIC_FORKED_SUCCESS' : 'TOPICS_FORKED_SUCCESS';

confirm_box(false, 'FORK_TOPIC' . ((sizeof($topic_ids) == 1) ? '' : 'S'), $s_hidden_fields, 'mcp_move.html');

}

$redirect = reapply_sid($redirect);

if (!$success_msg)

function main($id, $mode)

{

global $config, $phpbb_root_path, $phpEx;

if (is_array($action))

{

*/

function mcp_notes_user_view($action)

{

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

/* @var $pagination \phpbb\pagination */

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

$deletemark = ($action == 'del_marked') ? true : false;

$deleteall = ($action == 'del_all') ? true : false;

// Handle any actions

if (($deletemark || $deleteall) && $auth->acl_get('a_clearlogs'))

$where_sql";

$db->sql_query($sql);

$msg = ($deletemark) ? 'MARKED_NOTES_DELETED' : 'ALL_NOTES_DELETED';

}

{

if (check_form_key('mcp_notes'))

{

$msg = $user->lang['USER_FEEDBACK_ADDED'];

}

else

$sql_where = ($st) ? (time() - ($st * 86400)) : 0;

$sql_sort = $sort_by_sql[$sk] . ' ' . (($sd == 'd') ? 'DESC' : 'ASC');

$keywords_param = !empty($keywords) ? '&amp;keywords=' . urlencode(htmlspecialchars_decode($keywords)) : '';

$log_data = array();

function main($id, $mode)

{

global $config, $phpbb_root_path, $phpEx, $action, $phpbb_container;

include_once($phpbb_root_path . 'includes/functions_posting.' . $phpEx);

/* @var $pagination \phpbb\pagination */

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

$this->page_title = 'MCP_PM_REPORTS';

case 'delete':

include_once($phpbb_root_path . 'includes/functions_messenger.' . $phpEx);

if (!sizeof($report_id_list))

{

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

$sql = 'SELECT r.pm_id, r.user_id, r.report_id, r.report_closed, report_time, r.report_text, rr.reason_title, rr.reason_description, u.username, u.username_clean, u.user_colour

FROM ' . REPORTS_TABLE . ' r, ' . REPORTS_REASONS_TABLE . ' rr, ' . USERS_TABLE . ' u

'POST_SUBJECT' => ($pm_info['message_subject']) ? $pm_info['message_subject'] : $user->lang['NO_SUBJECT'],

'POST_DATE' => $user->format_date($pm_info['message_time']),

'POST_IP' => $pm_info['author_ip'],

'POST_ID' => $pm_info['msg_id'],

'U_LOOKUP_IP' => ($auth->acl_getf_global('m_info')) ? $this->u_action . '&amp;r=' . $report_id . '&amp;pm=' . $pm_id . '&amp;lookup=' . $pm_info['author_ip'] . '#ip' : '',

*/

function mcp_post_details($id, $mode, $action)

{

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

$user->add_lang('posting');

// Get post data

$post_info = phpbb_get_post_data(array($post_id), false, true);

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

{

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

$template->assign_vars(array(

if ($action == 'chgposter')

{

$sql_where = "username_clean = '" . $db->sql_escape(utf8_clean_string($username)) . "'";

}

else

{

$sql_where = 'user_id = ' . $new_user_id;

}

'POST_SUBJECT' => $post_info['post_subject'],

'POST_DATE' => $user->format_date($post_info['post_time']),

'POST_IP' => $post_info['poster_ip'],

'POST_ID' => $post_info['post_id'],

'U_LOOKUP_IP' => ($auth->acl_get('m_info', $post_info['forum_id'])) ? "$url&amp;i=$id&amp;mode=$mode&amp;lookup={$post_info['poster_ip']}#ip" : '',

// Get IP

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

{

if ($rdns_ip_num != 'all')

{

*/

function change_poster(&$post_info, $userdata)

{

if (empty($userdata) || $userdata['user_id'] == $post_info['user_id'])

{

$post_info = $post_info[$post_id];

// Now add log entry

}

include_once($phpbb_root_path . 'includes/functions_posting.' . $phpEx);

$this->page_title = 'MCP_QUEUE';

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

/* @var $phpbb_notifications \phpbb\notification\manager */

$phpbb_notifications = $phpbb_container->get('notification_manager');

'POST_SUBJECT' => $post_info['post_subject'],

'POST_DATE' => $user->format_date($post_info['post_time']),

'POST_IP' => $post_info['poster_ip'],

'POST_ID' => $post_info['post_id'],

'S_FIRST_POST' => ($post_info['topic_first_post_id'] == $post_id),

*/

static public function approve_posts($action, $post_id_list, $id, $mode)

{

if (!phpbb_check_ids($post_id_list, POSTS_TABLE, 'post_id', array('m_approve')))

{

foreach ($approve_log as $log_data)

{

}

// Only send out the mails, when the posts are being approved

$success_msg = (sizeof($post_info) == 1) ? 'POST_' . strtoupper($action) . 'D_SUCCESS' : 'POSTS_' . strtoupper($action) . 'D_SUCCESS';

}

meta_refresh(3, $redirect);

$message = $user->lang[$success_msg];

*/

static public function approve_topics($action, $topic_id_list, $id, $mode)

{

if (!phpbb_check_ids($topic_id_list, TOPICS_TABLE, 'topic_id', array('m_approve')))

{

foreach ($approve_log as $log_data)

{

}

// Only send out the mails, when the posts are being approved

}

}

meta_refresh(3, $redirect);

$message = $user->lang[$success_msg];

*/

static public function disapprove_posts($post_id_list, $id, $mode)

{

if (!phpbb_check_ids($post_id_list, POSTS_TABLE, 'post_id', array('m_approve')))

{

if ($is_disapproving)

{

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

}

else

{

$l_log_message = ($log_data['type'] == 'topic') ? 'LOG_DELETE_TOPIC' : 'LOG_DELETE_POST';

}

}

}

}

}

if ($num_disapproved_topics)

{

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

}

}

meta_refresh(3, $redirect);

$message = $user->lang[$success_msg];

function main($id, $mode)

{

global $config, $phpbb_root_path, $phpEx, $action, $phpbb_container, $phpbb_dispatcher;

include_once($phpbb_root_path . 'includes/functions_posting.' . $phpEx);

$this->page_title = 'MCP_REPORTS';

case 'delete':

include_once($phpbb_root_path . 'includes/functions_messenger.' . $phpEx);

if (!sizeof($report_id_list))

{

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

// closed reports are accessed by report id

$sql = 'SELECT r.post_id, r.user_id, r.report_id, r.report_closed, report_time, r.report_text, r.reported_post_text, r.reported_post_uid, r.reported_post_bitfield, r.reported_post_enable_magic_url, r.reported_post_enable_smilies, r.reported_post_enable_bbcode, rr.reason_title, rr.reason_description, u.username, u.username_clean, u.user_colour

FROM ' . REPORTS_TABLE . ' r, ' . REPORTS_REASONS_TABLE . ' rr, ' . USERS_TABLE . ' u

'POST_SUBJECT' => ($post_info['post_subject']) ? $post_info['post_subject'] : $user->lang['NO_SUBJECT'],

'POST_DATE' => $user->format_date($post_info['post_time']),

'POST_IP' => $post_info['poster_ip'],

'POST_ID' => $post_info['post_id'],

'U_LOOKUP_IP' => ($auth->acl_get('m_info', $post_info['forum_id'])) ? $this->u_action . '&amp;r=' . $report_id . '&amp;p=' . $post_id . '&amp;f=' . $forum_id . '&amp;lookup=' . $post_info['poster_ip'] . '#ip' : '',

case 'reports':

case 'reports_closed':

$forum_info = array();

$forum_list_reports = get_forum_list('m_report', false, true);

*/

function close_report($report_id_list, $mode, $action, $pm = false)

{

global $phpEx, $phpbb_root_path, $phpbb_container;

$pm_where = ($pm) ? ' AND r.post_id = 0 ' : ' AND r.pm_id = 0 ';

if ($action == 'delete' && strpos($user->data['session_page'], 'mode=report_details') !== false)

{

}

else if ($action == 'delete' && strpos($user->data['session_page'], 'mode=pm_report_details') !== false)

{

}

{

}

else

{

}

$success_msg = '';

$forum_ids = array();

{

if ($pm)

{

$phpbb_notifications->delete_notifications('notification.type.report_pm', $report['pm_id']);

}

else

{

$phpbb_notifications->delete_notifications('notification.type.report_post', $report['post_id']);

}

}

confirm_box(false, $user->lang[strtoupper($action) . "_{$pm_prefix}REPORT" . ((sizeof($report_id_list) == 1) ? '' : 'S') . '_CONFIRM'], $s_hidden_fields);

}

$redirect = reapply_sid($redirect);

if (!$success_msg)

*/

function mcp_topic_view($id, $mode, $action)

{

$url = append_sid("{$phpbb_root_path}mcp.$phpEx?" . phpbb_extra_url());

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

$user->add_lang('viewtopic');

$topic_info = phpbb_get_topic_data(array($topic_id), false, true);

if (!sizeof($topic_info))

$topic_info = $topic_info[$topic_id];

// Set up some vars

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

// Resync Topic?

if ($action == 'resync')

$total = $phpbb_content_visibility->get_count('topic_posts', $topic_info, $topic_info['forum_id']);

}

if ($posts_per_page == 0)

{

$posts_per_page = $total;

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

$rowset = $post_id_list = array();

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

{

$rowset[] = $row;

$post_id_list[] = $row['post_id'];

}

$db->sql_freeresult($result);

$topic_tracking_info = array();

// Get topic tracking info

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

'POST_AUTHOR_FULL' => get_username_string('full', $row['poster_id'], $row['username'], $row['user_colour'], $row['post_username']),

'POST_AUTHOR_COLOUR' => get_username_string('colour', $row['poster_id'], $row['username'], $row['user_colour'], $row['post_username']),

'POST_AUTHOR' => get_username_string('username', $row['poster_id'], $row['username'], $row['user_colour'], $row['post_username']),

'U_POST_DETAILS' => "$url&amp;i=$id&amp;p={$row['post_id']}&amp;mode=post_details" . (($forum_id) ? "&amp;f=$forum_id" : ''),

'U_MCP_APPROVE' => ($auth->acl_get('m_approve', $topic_info['forum_id'])) ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=queue&amp;mode=approve_details&amp;f=' . $topic_info['forum_id'] . '&amp;p=' . $row['post_id']) : '',

);

// Display not already displayed Attachments for this post, we already parsed them. ;)

if (!empty($attachments[$row['post_id']]))

{

*/

function split_topic($action, $topic_id, $to_forum_id, $subject)

{

if (!sizeof($post_id_list))

{

return;

}

$s_hidden_fields = build_hidden_fields(array(

'i' => 'main',

'redirect' => $redirect,

'subject' => $subject,

'to_forum_id' => $to_forum_id,

);

$success_msg = $return_link = '';

trigger_error('NO_POST_SELECTED');

}

$sql_ary = array(

'forum_id' => $to_forum_id,

$topic_info = phpbb_get_topic_data(array($topic_id));

$topic_info = $topic_info[$topic_id];

// Change topic title of first post

$sql = 'UPDATE ' . POSTS_TABLE . "

$success_msg = 'TOPIC_SPLIT_SUCCESS';

// Update forum statistics

// Link back to both topics

$return_link = sprintf($user->lang['RETURN_TOPIC'], '<a href="' . append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $post_info['forum_id'] . '&amp;t=' . $post_info['topic_id']) . '">', '</a>') . '<br /><br />' . sprintf($user->lang['RETURN_NEW_TOPIC'], '<a href="' . append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $to_forum_id . '&amp;t=' . $to_topic_id) . '">', '</a>');

$redirect = reapply_sid($redirect);

meta_refresh(3, $redirect);

*/

function merge_posts($topic_id, $to_topic_id)

{

if (!$to_topic_id)

{

$topic_data = $topic_data[$to_topic_id];

if (!sizeof($post_id_list))

{

return;

}

$s_hidden_fields = build_hidden_fields(array(

'i' => 'main',

$to_forum_id = $topic_data['forum_id'];

move_posts($post_id_list, $to_topic_id, false);

// Message and return links

$success_msg = 'POSTS_MERGED_SUCCESS';

// Link to the new topic

$return_link .= (($return_link) ? '<br /><br />' : '') . sprintf($user->lang['RETURN_NEW_TOPIC'], '<a href="' . append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $to_forum_id . '&amp;t=' . $to_topic_id) . '">', '</a>');

$redirect = reapply_sid($redirect);

meta_refresh(3, $redirect);

function main($id, $mode)

{

global $config, $phpbb_root_path, $phpEx;

if (is_array($action))

{

function mcp_warn_list_view($action)

{

global $phpEx, $phpbb_root_path, $config, $phpbb_container;

/* @var $pagination \phpbb\pagination */

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

$user->add_lang('memberlist');