</rule>

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

<!-- The ?> closing tag MUST be omitted from files containing only PHP. -->

<rule ref="Zend.Files.ClosingTag" />

<!-- PHP keywords MUST be in lower case. -->

<rule ref="Generic.PHP.LowerCaseKeyword" />

<!-- Classes etc. MUST be namespaced -->

<rule ref="PSR1.Classes.ClassDeclaration.MissingNamespace" />

if (!loadingIndicator.is(':visible')) {

loadingIndicator.fadeIn(phpbb.alertTime);

// Wait fifteen seconds and display an error if nothing has been returned by then.

phpbbAlertTimer = setTimeout(function() {

if (loadingIndicator.is(':visible')) {

phpbb.alert($('#phpbb_alert').attr('data-l-err'), $('#phpbb_alert').attr('data-l-timeout-processing-req'));

refresh = false;

}

if (refresh) {

window.location = res.REFRESH_DATA.url;

}

}

$auth->acl($user->data);

// Initial var setup

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

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

/**

* 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&amp;form=acp_ban&amp;field=ban'),

));

case 'create':

$sql_ary = $hidden_fields = array();

/**

* Modify custom bbcode data before the modify/create action

*

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;

{

$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']))

{

}

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

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

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

{

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]) . '">';

}

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

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

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

);

return;

break;

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

}

}

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

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

}

/**

* Options to pick a timezone and date/time

*

* @param \phpbb\user $user Object of the current user

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;

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

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

}

/**

* View log

*

* @param string $mode The mode defines which log_type is used and from which log the entry is retrieved

}

/**

* Lists inactive users

*/

function view_inactive_users(&$users, &$user_count, $limit = 0, $offset = 0, $limit_days = 0, $sort_by = 'user_inactive_time DESC')

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

}

}

return $phpbb_path_helper->clean_path($path);

}

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

if ($censor_text)

$text = censor_text($text);

}

* 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

{

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

*

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

$ids = array($ids);

}

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

if ($type != 'topic')

break;

}

if (!$result)

{

return false;

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

{

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

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

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

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

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

}

$db->sql_query($sql);

if (sizeof($close_report_posts))

{

if ($pm)

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;

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

{

{

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

}

foreach ($attachments as $attachment)

{

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

}

}

}

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:

$prune_enabled = (int) $src_db->sql_fetchfield('config_value');

$src_db->sql_freeresult($result);

// Insert categories

$sql = 'SELECT cat_id, cat_title

FROM ' . $convert->src_table_prefix . 'categories

// What we will do is handling all 2.0.x admins as founder to replicate what is common in 2.0.x.

// After conversion the main admin need to make sure he is removing permissions and the founder status if wanted.

// Grab user ids of users with user_level of ADMIN

$sql = "SELECT user_id

FROM {$convert->src_table_prefix}users

'S_LEGEND' => false,

));

// Check for getimagesize

if (@function_exists('getimagesize'))

{

$url = (!in_array(false, $passed)) ? $this->p_master->module_url . "?mode=$mode&amp;sub=database&amp;language=$language" : $this->p_master->module_url . "?mode=$mode&amp;sub=requirements&amp;language=$language ";

$submit = (!in_array(false, $passed)) ? $lang['INSTALL_START'] : $lang['INSTALL_TEST'];

$template->assign_vars(array(

'L_SUBMIT' => $submit,

'S_HIDDEN' => $s_hidden_fields,

$_module->move_module_by($row, 'move_up', 5);

}

if ($module_class == 'ucp')

{

// Move attachment module 4 down...

WHERE module_basename = 'ucp_notifications'

AND module_class = 'ucp'

AND module_mode = 'notification_options'";

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

$db->sql_freeresult($result);

$_module->move_module_by($row, 'move_down', 4);

$sql = 'SELECT *

FROM ' . MODULES_TABLE . "

WHERE module_basename = 'ucp_auth_link'

'ACP_EXTENSION_MANAGEMENT' => 'Extension management',

'ACP_EXTENSIONS' => 'Manage extensions',

'ACP_FORUM_BASED_PERMISSIONS' => 'Forum based permissions',

'ACP_FORUM_LOGS' => 'Forum logs',

'ACP_FORUM_MANAGEMENT' => 'Forum management',

'LOG_PM_REPORT_CLOSED' => '<strong>Closed PM report</strong><br />» %s',

'LOG_PM_REPORT_DELETED' => '<strong>Deleted PM report</strong><br />» %s',

'LOG_POST_APPROVED' => '<strong>Approved post</strong><br />» %s',

'LOG_POST_EDITED' => '<strong>Edited post “%1$s” written by</strong><br />» %2$s',

'LOG_POST_RESTORED' => '<strong>Restored post</strong><br />» %s',

'LOG_REPORT_CLOSED' => '<strong>Closed report</strong><br />» %s',

'LOG_TOPIC_APPROVED' => '<strong>Approved topic</strong><br />» %s',

'LOG_TOPIC_RESTORED' => '<strong>Restored topic</strong><br />» %s',

'LOG_TOPIC_RESYNC' => '<strong>Resynchronised topic counters</strong><br />» %s',

'LOG_TOPIC_TYPE_CHANGED' => '<strong>Changed topic type</strong><br />» %s',

'LOG_UNLOCK' => '<strong>Unlocked topic</strong><br />» %s',

'LOG_PURGE_CACHE' => '<strong>Purged cache</strong>',

'LOG_PURGE_SESSIONS' => '<strong>Purged sessions</strong>',

'LOG_RANK_ADDED' => '<strong>Added new rank</strong><br />» %s',

'LOG_RANK_REMOVED' => '<strong>Removed rank</strong><br />» %s',

'LOG_RANK_UPDATED' => '<strong>Updated rank</strong><br />» %s',

// equally where a string contains only two placeholders which are used to wrap text

// in a url you again do not need to specify an order e.g., 'Click %sHERE%s' is fine

$lang = array_merge($lang, array(

'EXTENSION' => 'Extension',

'EXTENSIONS' => 'Extensions',

'ROLE_USER_STANDARD' => 'Standard Features',

'ROLE_USER_NEW_MEMBER' => 'Newly Registered User Features',

'ROLE_DESCRIPTION_ADMIN_FORUM' => 'Can access the forum management and forum permission settings.',

'ROLE_DESCRIPTION_ADMIN_FULL' => 'Has access to all administrative functions of this board.<br />Not recommended.',

'ROLE_DESCRIPTION_ADMIN_STANDARD' => 'Has access to most administrative features but is not allowed to use server or system related tools.',

'URL' => 'A valid URL using any protocol (http, ftp, etc… cannot be used for javascript exploits). If none is given, “http://” is prefixed to the string.',

'LOCAL_URL' => 'A local URL. The URL must be relative to the topic page and cannot contain a server name or protocol, as links are prefixed with “%s”',

'RELATIVE_URL' => 'A relative URL. You can use this to match parts of a URL, but be careful: a full URL is a valid relative URL. When you want to use relative URLs of your board, use the LOCAL_URL token.',

));

// Smilies and topic icons

'DISPLAY_POSTING' => 'On posting page',

'DISPLAY_POSTING_NO' => 'Not on posting page',

'EDIT_ICONS' => 'Edit icons',

'EDIT_SMILIES' => 'Edit smilies',

'EMOTION' => 'Emotion',

'D M d, Y g:i a' => 'Mon Jan 01, 2007 1:37 pm',

'F jS, Y, g:i a' => 'January 1st, 2007, 1:37 pm',

'|d M Y|, H:i' => 'Today, 13:37 / 01 Jan 2007, 13:37',

),

// The default dateformat which will be used on new installs in this language

Use this link to activate the account:

{U_ACTIVATE}

{MESSAGE}

{EMAIL_SIG}

Your password has been securely stored in our database and cannot be retrieved. In the event that it is forgotten, you will be able to reset it using the email address associated with your account.

Thank you for registering.

----------

In order to keep your board safe and secure, we highly recommended keeping current with software releases. For your convenience, a mailing list is available at the page referenced above.

You are receiving this notification because the report you filed regarding the private message "{PM_SUBJECT}" at "{SITENAME}" has been tended to by a moderator or administrator. The report is now closed. If you have further questions, please contact {CLOSER_NAME} by private message.

You are receiving this notification because the report you filed regarding the private message "{PM_SUBJECT}" at "{SITENAME}" was deleted by a moderator or administrator.

If you want to view the topic, click the following link:

{U_VIEW_TOPIC}

If you want to view the topic, click the following link:

{U_VIEW_TOPIC}

{U_ACTIVATE}

Your account on "{SITENAME}" has been deactivated, most likely due to changes made to your profile. The administrator of the board will need to activate it before you can log in. You will receive another notification when this has occurred.

You can of course change this password yourself via the profile page. If you have any difficulties please contact the board administrator.

{U_ACTIVATE}

Thank you for registering at "{SITENAME}", we look forward to your participation.

Thank you for registering.

Thank you for registering.

Thank you for registering.

'NOT_LEADER_OF_GROUP' => 'The requested operation cannot be taken because you are not a leader of the selected group.',

'NOT_MEMBER_OF_GROUP' => 'The requested operation cannot be taken because you are not a member of the selected group or your membership has not been approved yet.',

'NOT_RESIGN_FROM_DEFAULT_GROUP' => 'You are not allowed to resign from your default group.',

'PRIMARY_GROUP' => 'Primary group',

'REMOVE_SELECTED' => 'Remove selected',

array(

0 => 'Can I add my own tags?',

1 => 'If you are an administrator on this board and have the proper permissions, you can add further BBCodes through the Custom BBCodes section.'

);

array(

0 => 'Who do I contact about abusive and/or legal matters related to this board?',

1 => 'Any of the administrators listed on the “The team” page should be an appropriate point of contact for your complaints. If this still gets no response then you should contact the owner of the domain (do a <a href="http://www.google.com/search?q=whois">whois lookup</a>) or, if this is running on a free service (e.g. Yahoo!, free.fr, f2s.com, etc.), the management or abuse department of that service. Please note that the phpBB Group has <strong>absolutely no jurisdiction</strong> and cannot in any way be held liable over how, where or by whom this board is used. Do not contact the phpBB Group in relation to any legal (cease and desist, liable, defamatory comment, etc.) matter <strong>not directly related</strong> to the phpBB.com website or the discrete software of phpBB itself. If you do email phpBB Group <strong>about any third party</strong> use of this software then you should expect a terse response or no response at all.'

);

'SPAM' => 'The reported message has the only purpose to advertise for a website or another product.',

'OFF_TOPIC' => 'The reported message is off topic.',

'OTHER' => 'The reported message does not fit into any other category, please use the further information field.',

),

));

'BBCODE_IS_OFF' => '%sBBCode%s is <em>OFF</em>',

'BBCODE_IS_ON' => '%sBBCode%s is <em>ON</em>',

'BBCODE_I_HELP' => 'Italic text: [i]text[/i]',

'BBCODE_LISTITEM_HELP' => 'List item: [*]text',

'BBCODE_O_HELP' => 'Ordered list: e.g. [list=1][*]First point[/list] or [list=a][*]Point a[/list]',

'BBCODE_P_HELP' => 'Insert image: [img]http://image_url[/img]',

'PM_SENTBOX' => 'Sent messages',

'PM_SUBJECT' => 'Message subject',

'PM_TO' => 'Send to',

'PM_USERS_REMOVED_NO_PM' => 'Some users couldn’t be added as they have disabled private message receipt.',

'POST_EDIT_PM' => 'Edit message',

'POST_FORWARD_PM' => 'Forward message',

'PLACE_INTO_FOLDER' => 'Place into folder',

'MARK_AS_READ' => 'Mark as read',

'MARK_AS_IMPORTANT' => 'Mark message',

),

'PM_CHECK' => array(

'SUBJECT' => 'Subject',

'SENDER' => 'Sender',

'MESSAGE' => 'Message',

'STATUS' => 'Message status',

),

'PM_RULE' => array(

'IS_LIKE' => 'is like',

'ANSWERED' => 'answered',

'FORWARDED' => 'forwarded',

'TO_GROUP' => 'to my default usergroup',

),

'GROUPS_EXPLAIN' => 'Usergroups enable board admins to better administer users. By default you will be placed in a specific group, this is your default group. This group defines how you may appear to other users, for example your username colouration, avatar, rank, etc. Depending on whether the administrator allows it you may be allowed to change your default group. You may also be placed in or allowed to join other groups. Some groups may give you additional permissions to view content or increase your capabilities in other areas.',

'GROUP_LEADER' => 'Leaderships',

'GROUP_MEMBER' => 'Memberships',

1 => 'Last edited by %2$s on %3$s, edited %1$d time in total.',

2 => 'Last edited by %2$s on %3$s, edited %1$d times in total.',

),

'ERROR_NO_ATTACHMENT' => 'The selected attachment does not exist anymore.',

'FILE_NOT_FOUND_404' => 'The file <strong>%s</strong> does not exist.',

var $dbms_type_map = array();

/**

* Get the column types for every database we support

*

* @return array

case 'mssql':

case 'mssqlnative':

{

}

}

$statements[] = 'ALTER TABLE [' . $table_name . '] DROP COLUMN [' . $column_name . ']';

break;

case 'mysql_40':

case 'mssql':

case 'mssqlnative':

$statements[] = 'ALTER TABLE [' . $table_name . '] ALTER COLUMN [' . $column_name . '] ' . $column_data['column_type_sql'];

if (!empty($column_data['default']))

{

{

}

}

break;

case 'mysql_40':

return $this->_sql_run_sql($statements);

}

}

$num_args = 0;

if (!is_array($this->user->lang[$row['log_operation']]))

{

}

else

{

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

trigger_error($message);

}

$reported_post_text = $report_data['message_text'];

$reported_post_bitfield = $report_data['bbcode_bitfield'];

$reported_post_uid = $report_data['bbcode_uid'];

* @param int Delay in ms until darkenwrapper's click event is triggered

*/

phpbb.closeDarkenWrapper = function(delay) {

$('#darkenwrapper').trigger('click');

}, delay);

};

</div>

</div>

<!-- BEGIN faq_block -->

<div class="panel <!-- IF faq_block.S_ROW_COUNT is odd -->bg1<!-- ELSE -->bg2<!-- ENDIF -->">

<div class="inner">

</div>

</div>

</div>

<!-- INCLUDE overall_footer.html -->

<!-- ENDIF -->

</dl>

</div>

<!-- EVENT memberlist_view_contact_before -->

<div class="panel bg2">

<div class="inner">

<h3>{L_CONTACT_USER} {USERNAME}</h3>

<dl class="details">

<!-- EVENT memberlist_view_user_statistics_after -->

</dl>

</div>

</div>

<!-- EVENT memberlist_view_contact_after -->

<div class="postbody"><div class="signature standalone">{SIGNATURE}</div></div>

</div>

<!-- ENDIF -->

</li>

<!-- IF S_REGISTERED_USER --><li id="username_logged_in" class="rightside"><!-- IF CURRENT_USER_AVATAR --><a href="{U_USER_PROFILE}" class="header-avatar">{CURRENT_USER_AVATAR}</a> <!-- ENDIF -->{USERNAME_FULL}</li><!-- ENDIF -->

<!-- IF S_DISPLAY_SEARCH and not S_IN_SEARCH --><li class="responsive-search rightside" style="display: none;"><a href="{U_SEARCH}" title="{L_SEARCH_ADV_EXPLAIN}">{L_SEARCH}</a></li><!-- ENDIF -->

</ul>

</dl>

</div>

<!-- ENDIF -->

<!-- ENDIF -->

</fieldset>

</div>

</div>

</div>

<!-- IF S_COMPOSE_PM -->

<div>{S_FORM_TOKEN}</div>

</div>

<!-- ENDIF -->

<!-- IF TOTAL_MESSAGES or S_VIEW_MESSAGE -->

<ul class="linklist">

<li class="rightside pagination">

<div class="dropdown-container dropdown-button-control topic-tools">

<span title="{L_TOPIC_TOOLS}" class="dropdown-trigger dropdown-select dropdown-select-icon tools-icon"><span></span></span>

<div class="dropdown hidden">

</li>

<!-- ENDIF -->

<!-- IF U_BUMP_TOPIC --><li class="small-icon icon-bump"><a href="{U_BUMP_TOPIC}" title="{L_BUMP_TOPIC}" data-ajax="true">{L_BUMP_TOPIC}</a></li><!-- ENDIF -->

<!-- IF S_HAS_ATTACHMENTS -->

<li class="small-icon icon-download">

<a class="dropdown-toggle-submenu" href="{U_DOWNLOAD_ALL_ATTACHMENTS}" title="{L_DOWNLOAD_ALL_ATTACHMENTS}">{L_DOWNLOAD_ALL_ATTACHMENTS}</a>

margin: 0 1px 0 5px;

}

/* Icon images

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

.rtl .small-icon {

.dropdown-visible .dropdown-select.tools-icon:before,

.nojs .dropdown-container:hover .dropdown-select.tools-icon:before { background-position: -80px -20px; }

/* Icon images

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

.small-icon {

Colours and backgrounds for buttons.css

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

.buttons div a, .dropdown-select {

border-color: #C7C3BF;

background-color: #FFFFFF;

.icon-pm { background-image: url("./images/icon_pm.gif"); }

.icon-download { background-image: url("./images/icon_download.gif"); }

.icon-mark { background-image: url("./images/icon_mark.gif"); }

/* Profile & navigation icons */

.email-icon, .email-icon a { background-image: url("./images/icon_contact_email.gif"); }

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

*

* @event core.viewtopic_modify_page_title

* @var array topic_data Array with topic data

* @var int forum_id Forum ID of the topic

* @var int start Start offset used to calculate the page

class phpbb_dbal_db_tools_test extends phpbb_database_test_case

{

protected $db;

protected $tools;

protected $table_exists;

protected $table_data;

$this->assertFalse($this->tools->sql_column_exists('prefix_table_name', 'column_does_not_exist'));

}

public function test_column_remove()

{

$this->assertTrue($this->tools->sql_column_exists('prefix_table_name', 'c_int_size'));

$this->assertFalse($this->tools->sql_column_exists('prefix_table_name', 'c_int_size'));

}

public function test_column_remove_primary()

{

$this->assertTrue($this->tools->sql_column_exists('prefix_table_name', 'c_id'));

$this->assertFalse($this->tools->sql_table_exists('prefix_test_table'));

}

{

$db_tools = $this->getMock('\phpbb\db\tools', array(

'sql_table_exists',

));

}

{

$db_tools = $this->getMock('\phpbb\db\tools', array(

'sql_column_exists',

<value>LOG_SINGULAR_PLURAL</value>

<value>a:1:{i:0;i:2;}</value>

</row>

</table>

<table name="phpbb_users">

<column>user_id</column>

'viewforum' => '',

'action' => 'LOG_SINGULAR_PLURAL 2',

),

);

$test_cases = array(

'expected_returned' => 0,

'user', false, 5, 0, 0, 0, 0, 0, 'l.log_id ASC', 'plural',

),

);

foreach ($test_cases as $case => $case_data)

'LOG_INSTALL_INSTALLED' => 'installed: %s',

'LOG_USER' => 'User<br /> %s',

'LOG_MOD2' => 'Mod2',

'LOG_SINGULAR_PLURAL' => array(

1 => 'singular',

2 => 'plural (%d)',

array(),

'event_loop0|event_loop1|event_loop2',

),

);

}

/**

* @dataProvider template_data

*/

{

// Reset the engine state

$this->setup_engine_for_events($dataset, $style_names);

array(),

"barbarbar1bar1",

),

/* Does not pass with the current implementation.

array(

'loop_reuse.html',

/**

* @dataProvider template_data

*/

{

$this->run_template($file, $vars, $block_vars, $destroy, $expected, $lang_vars);

}

class phpbb_database_test_connection_manager

{

private $config;

private $dbms;

private $pdo;

/**

$table_name,

$table_data

);

foreach ($queries as $query)

{

}

}

}