foreach ($sql_subary as $sql)

{

$sql = "INSERT INTO $table ($id_field, forum_id, auth_option_id, auth_setting) VALUES ($sql)";

$sql = '';

}

}

if ($sql != '')

{

$sql = "INSERT INTO $table ($id_field, forum_id, auth_option_id, auth_setting) $sql";

}

break;

case 'delete':

foreach ($sql_subary as $sql)

{

$sql = '';

}

break;

{

case 'user':

$sql = 'SELECT b.*, u.user_id, u.username, u.username_clean

FROM ' . BANLIST_TABLE . ' b, ' . USERS_TABLE . ' u

case 'ip':

$field = 'ban_ip';

$sql = 'SELECT *

FROM ' . BANLIST_TABLE . '

case 'email':

$field = 'ban_email';

$sql = 'SELECT *

FROM ' . BANLIST_TABLE . '

*/

function deliver_demo($selected)

{

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

$captcha->init(CONFIRM_REG);

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

}

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

{

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

$data = array();

$after = false;

$order_lists = array('', '');

$add_order_lists = array('', '');

$display_count = 0;

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

{

$after = true;

$data[$row[$fields . '_url']] = $row;

}

else

*/

function prune_users($id, $mode)

{

/** @var \phpbb\group\helper $group_helper */

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

function index($id, $mode)

{

$action = $request->variable('action', '');

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

$messages = array();

$installed_names = array();

$installed_dirs = array();

foreach ($dirs as $dir)

{

if (in_array($dir, $this->reserved_style_names))

$style['style_id'] = $this->install_style($style);

$style['_installed'] = true;

$found = true;

$installed_names[] = $style['style_name'];

$installed_dirs[] = $style['style_path'];

$messages[] = sprintf($this->user->lang['STYLE_INSTALLED'], htmlspecialchars($style['style_name']));

case 'banuser':

$ban[] = $user_row['username'];

$reason = 'USER_ADMIN_BAN_NAME_REASON';

break;

case 'banemail':

$ban[] = $user_row['user_email'];

$reason = 'USER_ADMIN_BAN_EMAIL_REASON';

break;

case 'banip':

$db->sql_freeresult($result);

$reason = 'USER_ADMIN_BAN_IP_REASON';

break;

}

*/

function display_mask($mode, $permission_type, &$hold_ary, $user_mode = 'user', $local = false, $group_display = true)

{

/* @var $phpbb_permissions \phpbb\permissions */

$phpbb_permissions = $phpbb_container->get('acl.permissions');

break;

case 'number':

$min = ( isset($tpl_type[1]) ) ? (int) $tpl_type[1] : false;

if ( isset($tpl_type[2]) )

{

break;

case 'dimension':

$min = (int) $tpl_type[1];

case 'select':

case 'custom':

if (isset($vars['method']))

{

$call = array($module->module, $vars['method']);

function import_avatar_gallery($gallery_name = '', $subdirs_as_galleries = false)

{

$relative_path = empty($convert->convertor['source_path_absolute']);

*/

function template($template_file, $template_lang = '', $template_path = '')

{

$this->setup_template();

*/

function error($type, $msg)

{

// Session doesn't exist, create it

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

$calling_page = htmlspecialchars_decode($request->server('PHP_SELF'));

switch ($type)

{

case 'EMAIL':

*/

static function module_auth($module_auth, $forum_id)

{

$module_auth = trim($module_auth);

*/

function posting_gen_topic_types($forum_id, $cur_topic_type = POST_NORMAL)

{

$toggle = false;

*/

function clean_sentbox($num_sentbox_messages)

{

// Check Message Limit

if ($user->data['message_limit'] && $num_sentbox_messages > $user->data['message_limit'])

*/

function check_rule(&$rules, &$rule_row, &$message_row, $user_id)

{

if (!isset($rules[$rule_row['rule_check']][$rule_row['rule_connection']]))

{

return false;

break;

case ACTION_DELETE_MESSAGE:

// Check for admins/mods - users are not allowed to remove those messages...

// We do the check here to make sure the data we use is consistent

*/

function _put($from_file, $to_file)

{

// We only use the BINARY file mode to cicumvent rewrite actions from ftp server (mostly linefeeds being replaced)

$mode = FTP_BINARY;

foreach ($topic_list as $topic_id)

{

$row_ary = &$topic_rows[$topic_id];

$replies = $phpbb_content_visibility->get_count('topic_posts', $row_ary, $forum_id) - 1;

*/

function mcp_resync_topics($topic_ids)

{

if (!sizeof($topic_ids))

{

*/

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

{

if (!sizeof($topic_ids))

{

*/

function lock_unlock($action, $ids)

{

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

{

'action' => $action,

'redirect' => $redirect)

);

if (confirm_box(true))

{

*/

function change_topic_type($action, $topic_ids)

{

switch ($action)

{

'action' => $action,

'redirect' => $redirect,

);

if (confirm_box(true))

{

));

}

// Get topic tracking info

if ($config['load_db_lastread'])

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

{

$sql = 'SELECT *

FROM ' . ATTACHMENTS_TABLE . '

WHERE post_msg_id = ' . $post_id . '

$sort_by_sql = $sort_order_sql = array();

phpbb_mcp_sorting($mode, $sort_days, $sort_key, $sort_dir, $sort_by_sql, $sort_order_sql, $total, $forum_id, $topic_id);

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

$forum_names = array();

));

}

// Get topic tracking info

if ($config['load_db_lastread'])

{

trigger_error('NOT_MODERATOR');

}

$sql = 'SELECT SUM(forum_topics_approved) as sum_forum_topics

FROM ' . FORUMS_TABLE . '

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

$sort_by_sql = $sort_order_sql = array();

phpbb_mcp_sorting($mode, $sort_days, $sort_key, $sort_dir, $sort_by_sql, $sort_order_sql, $total, $forum_id, $topic_id);

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

if ($mode == 'reports')

$has_unapproved_posts = $has_deleted_posts = false;

// Grab extensions

if ($topic_info['topic_attachment'] && sizeof($post_id_list))

{

// Get attachments...

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

{

'U_MCP_REPORT' => ($auth->acl_get('m_report', $topic_info['forum_id'])) ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=reports&mode=report_details&f=' . $topic_info['forum_id'] . '&p=' . $row['post_id']) : '',

);

/**

* Event to modify the template data block for topic reviews in the MCP

*

function mcp_warn_post_view($action)

{

global $phpEx, $phpbb_root_path, $config, $request;

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

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

*/

function mcp_warn_user_view($action)

{

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

$username = $request->variable('username', '', true);

*/

function get_data()

{

extract($phpbb_config_php_file->get_all());

unset($dbhost, $dbport, $dbname, $dbuser, $dbpasswd); // Just a precaution

*/

protected function process_login_result($result)

{

$login_error = null;

{

$forums = array_keys($request->variable('f', array(0 => 0)));

$topics = array_keys($request->variable('t', array(0 => 0)));

if (sizeof($forums) || sizeof($topics))

{

trigger_error('NO_AUTH_READ_HOLD_MESSAGE');

}

// Load the custom profile fields

if ($config['load_cpf_pm'])

{

*/

function get_user_information($user_id, $user_row)

{

global $phpbb_root_path, $phpEx, $config;

if (!$user_id)

$selected = ($i == $data['bday_month']) ? ' selected="selected"' : '';

$s_birthday_month_options .= "<option value=\"$i\"$selected>$i</option>";

}

$now = getdate();

$s_birthday_year_options = '<option value="0"' . ((!$data['bday_year']) ? ' selected="selected"' : '') . '>--</option>';

$db->sql_query($sql);

$cats_added[$unknown_cat_id] = $max_forum_id;

}

// Now insert the forums

}

}

return utf8_recode($text, $lang_enc_array[$get_lang]);

}

function validate()

{

if (!$user->is_setup())

{

$ary_name[$i] = ocicolumnname($result, $i + 1);

}

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

{

$schema_vals = $schema_fields = array();

$this->entry_count = 0;

$this->last_page_offset = $offset;

$profile_url = ($this->get_is_admin() && $this->phpbb_admin_path) ? append_sid("{$this->phpbb_admin_path}index.{$this->php_ext}", 'i=users&amp;mode=overview') : append_sid("{$this->phpbb_root_path}memberlist.{$this->php_ext}", 'mode=viewprofile');

$this->must_not_contain_ids = array();

$this->must_exclude_one_ids = array();

foreach ($query as $word)

{

if (empty($word))

$variable = $section->get_variable_by_name($key);

if (!$variable)

{

}

else

{

}

else

{

}

}

}

$match = array('#\sand\s#i', '#\sor\s#i', '#\snot\s#i', '#\+#', '#-#', '#\|#', '#@#');

$replace = array(' & ', ' | ', ' - ', ' +', ' -', ' |', '');

$keywords = preg_replace($match, $replace, $keywords);

$this->sphinx->SetMatchMode(SPH_MATCH_EXTENDED);

}

{

$xml = $this->quote_helper->inject_metadata($xml);

}

/**

* Modify a parsed text before it is rendered

throw new \OutOfBoundsException($this->message_prefix . 'INVALID_PARENT');

}

$sql_exclude_moved_items = $this->db->sql_in_set($this->column_item_id, $move_items, true);

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

// User has wrong style

if (!$this->style && $style_id == $this->data['user_style'])

{

$sql = 'UPDATE ' . USERS_TABLE . "

SET user_style = $style_id