if ($ip_2_counter == 0 && $ip_2_end == 254)

{

$ip_2_counter = 256;

$iplist[] = "'$ip_1_counter.*'";

}

if ($ip_3_counter == 0 && $ip_3_end == 254)

{

$ip_3_counter = 256;

$iplist[] = "'$ip_1_counter.$ip_2_counter.*'";

}

if ($ip_4_counter == 0 && $ip_4_end == 254)

{

$ip_4_counter = 256;

$iplist[] = "'$ip_1_counter.$ip_2_counter.$ip_3_counter.*'";

}

*/

function board_disable($value, $key)

{

$radio_ary = array(1 => 'YES', 0 => 'NO');

return h_radio('config[board_disable]', $radio_ary, $value) . '<br /><input id="' . $key . '" type="text" name="config[board_disable_msg]" maxlength="255" size="40" value="' . $this->new_config['board_disable_msg'] . '" />';

*/

function select_news_forums($value, $key)

{

$forum_list = make_forum_select(false, false, true, true, true, false, true);

// Build forum options

function select_exclude_forums($value, $key)

{

$forum_list = make_forum_select(false, false, true, true, true, false, true);

// Build forum options

*/

function enable_mod_rewrite($value, $key)

{

// Determine whether mod_rewrite is enabled on the server

// NOTE: This only works on Apache servers on which PHP is NOT

return array($user->lang['NO_FORUM']);

}

$sql = 'SELECT forum_id

FROM ' . FORUMS_TABLE . "

WHERE parent_id = {$row['forum_id']}";

ORDER BY group_legend ASC, group_type DESC, group_name ASC';

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

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

{

$group_name = $group_helper->get_name($row['group_name']);

ORDER BY t.teampage_position ASC';

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

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

{

if ($row['teampage_id'] == $category_id)

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

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

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

{

$group_name = $group_helper->get_name($row['group_name']);

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

}

// We loop through the auth settings defined in our submit

list($ug_id, ) = each($psubmit);

list($forum_id, ) = each($psubmit[$ug_id]);

}

$key_match = array('lt' => '<', 'gt' => '>', 'eq' => '=');

$where_sql = '';

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

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

// Delete entries if requested and able

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

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

}

}

switch ($action)

{

*/

function assign_cat_array(&$category_array, $tpl_cat, $tpl_mask, $ug_id, $forum_id, $s_view, $show_trace = false)

{

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

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

*/

function build_permission_array(&$permission_row, &$content_array, &$categories, $key_sort_array)

{

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

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

*/

function get_topic_tracking($forum_id, $topic_ids, &$rowset, $forum_mark_time, $global_announce_list = false)

{

$last_read = array();

*/

function update_forum_tracking_info($forum_id, $forum_last_post_time, $f_mark_time = false, $mark_time_forum = false)

{

// Determine the users last forum mark time if not given.

if ($mark_time_forum === false)

*/

function redirect($url, $return = false, $disable_cd_check = false)

{

if (!$user->is_setup())

{

*/

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

{

global $request, $phpbb_container, $phpbb_dispatcher, $phpbb_log;

$err = '';

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)

*/

function obtain_users_online($item_id = 0, $item = 'forum')

{

$reading_sql = '';

if ($item_id !== 0)

{

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

$user_online_link = $rowset = array();

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

$item_caps = strtoupper($item);

*/

function phpbb_get_avatar($row, $alt, $ignore_config = false, $lazy = false)

{

global $phpbb_container, $phpbb_dispatcher;

if (!$config['allow_avatar'] && !$ignore_config)

*/

function page_footer($run_cron = true, $display_template = true, $exit_handler = true)

{

global $request, $phpbb_dispatcher, $phpbb_admin_path;

// A listener can set this variable to `true` when it overrides this function

*/

function exit_handler()

{

if (!empty($phpbb_hook) && $phpbb_hook->call_hook(__FUNCTION__))

{

AND u.user_id = p.poster_id';

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

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

{

$topic_id = intval($row['topic_id']);

AND u.user_id = p.poster_id';

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

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

{

$topic_id = (int) $row['topic_id'];

}

// We add moderators who have forum moderator permissions without an explicit ACL_NEVER setting

// Grab all users having moderative options...

$hold_ary = $auth->acl_user_raw_data(false, 'm_%', false);

// Some basics...

$attachment['extension'] = strtolower(trim($attachment['extension']));

$filename = $phpbb_root_path . $config['upload_path'] . '/' . utf8_basename($attachment['physical_filename']);

$upload_icon = '';

if (!$denied)

{

$display_cat = $extensions[$attachment['extension']]['display_cat'];

if ($display_cat == ATTACHMENT_CATEGORY_IMAGE)

return $avatar_cache[$source][$axis];

}

$orig_source = $source;

*/

function add_user_group($group_id, $user_id, $group_leader = false)

{

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

'group_id' => $group_id,

*/

function user_group_auth($group, $select_query, $use_src_db)

{

if (!in_array($group, array('guests', 'registered', 'registered_coppa', 'global_moderators', 'administrators', 'bots')))

{

return $convert_config;

}

global $convert;

if ($convert->config_schema['table_format'] != 'file')

*/

function restore_config($schema)

{

$convert_config = get_config();

*/

function update_topics_posted()

{

switch ($db->get_sql_layer())

{

*/

function remove_invalid_users()

{

// username_clean is UNIQUE

$sql = 'SELECT user_id

function convert_bbcode($message, $convert_size = true, $extended_bbcodes = false)

{

if (empty($orig))

{

function copy_file($src, $trg, $overwrite = false, $die_on_failure = true, $source_relative_path = true)

{

/** @var \phpbb\filesystem\filesystem_interface $filesystem */

$filesystem = $phpbb_filesystem;

function copy_dir($src, $trg, $copy_subdirs = true, $overwrite = false, $die_on_failure = true, $source_relative_path = true)

{

/** @var \phpbb\filesystem\filesystem_interface $filesystem */

$filesystem = $phpbb_filesystem;

function relative_base($path, $is_relative = true, $line = false, $file = false)

{

if (!$is_relative)

{

*/

function get_moderators(&$forum_moderators, $forum_id = false)

{

global $phpbb_container;

$forum_id_ary = array();

{

global $user, $config;

if ($topic_row['topic_status'] == ITEM_MOVED)

{

$topic_type = $user->lang['VIEW_TOPIC_MOVED'];

*/

function msg_email()

{

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

{

{

global $user;

// Here we try to determine the *real* hostname (reverse DNS entry preferrably)

$local_host = $user->host;

*/

function phpbb_mail($to, $subject, $msg, $headers, $eol, &$err_msg)

{

// We use the EOL character for the OS here because the PHP mail function does not correctly transform line endings. On Windows SMTP is used (SMTP is \r\n), on UNIX a command is used...

// Reference: http://bugs.php.net/bug.php?id=15841

$db->sql_freeresult($result);

// Grab extensions

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

{

// Get attachments...

$sql = 'SELECT *

FROM ' . ATTACHMENTS_TABLE . '

*/

function delete_post($forum_id, $topic_id, $post_id, &$data, $is_soft = false, $softdelete_reason = '')

{

global $config, $phpEx, $phpbb_root_path;

// Specify our post mode

if ($is_soft)

{

$phpbb_content_visibility->set_topic_visibility(ITEM_DELETED, $topic_id, $forum_id, $user->data['user_id'], time(), $softdelete_reason);

}

else

break;

}

// And the topic ladies and gentlemen

switch ($post_mode)

$msg_ids = $request->variable('marked_msg_id', array(0));

$cur_folder_id = $request->variable('cur_folder_id', PRIVMSGS_NO_BOX);

if (!sizeof($msg_ids))

{

*/

function delete_pm($user_id, $msg_ids, $folder_id)

{

$user_id = (int) $user_id;

$folder_id = (int) $folder_id;

*/

function phpbb_delete_user_pms($user_id)

{

$user_id = (int) $user_id;

if (!$user_id)

*/

function phpbb_delete_users_pms($user_ids)

{

$user_id_sql = $db->sql_in_set('user_id', $user_ids);

$author_id_sql = $db->sql_in_set('author_id', $user_ids);

*/

function get_folder_status($folder_id, $folder)

{

if (isset($folder[$folder_id]))

{

*/

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

{

// We do not handle erasing pms here

if ($mode == 'delete')

if (sizeof($sql_data))

{

if ($mode == 'post' || $mode == 'reply' || $mode == 'quote' || $mode == 'quotepost' || $mode == 'forward')

{

$db->sql_query('INSERT INTO ' . PRIVMSGS_TABLE . ' ' . $db->sql_build_array('INSERT', $sql_data));

*/

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

*/

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

if ($ip_2_counter == 0 && $ip_2_end == 254)

{

$ip_2_counter = 256;

$banlist_ary[] = "$ip_1_counter.*";

}

if ($ip_3_counter == 0 && $ip_3_end == 254)

{

$ip_3_counter = 256;

$banlist_ary[] = "$ip_1_counter.$ip_2_counter.*";

}

if ($ip_4_counter == 0 && $ip_4_end == 254)

{

$ip_4_counter = 256;

$banlist_ary[] = "$ip_1_counter.$ip_2_counter.$ip_3_counter.*";

}

*/

function avatar_delete($mode, $row, $clean_db = false)

{

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

if ($mode == 'user')

*/

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

{

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

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

// Setting the log message before we set the group id (if group gets added)

$log = ($group_id) ? 'LOG_GROUP_UPDATED' : 'LOG_GROUP_CREATED';

if ($group_id)

{

$sql = 'SELECT user_id

*/

function avatar_remove_db($avatar_name)

{

$sql = 'UPDATE ' . USERS_TABLE . "

SET user_avatar = '',

*/

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

*/

function group_validate_groupname($group_id, $group_name)

{

$group_name = utf8_clean_string($group_name);

*/

function get_group_name($group_id)

{

$sql = 'SELECT group_name, group_type

FROM ' . GROUPS_TABLE . '

if (!$is_soft)

{

}

}

else

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

{

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

global $phpbb_dispatcher;

$user->add_lang('posting');

public function main($id, $mode)

{

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

global $phpbb_dispatcher;

trigger_error('NOT_MODERATOR');

}

$forum_list = $forum_id;

}

*/

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

{

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

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

*/

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

{

global $phpEx, $phpbb_root_path, $request, $phpbb_log;

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

$redirect = reapply_sid($redirect);

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

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

$s_hidden_fields = build_hidden_fields(array(

'i' => $id,

if (confirm_box(true))

{

$topic_posts_unapproved = $post_disapprove_list = $topic_information = array();

// Build a list of posts to be disapproved and get the related topics real replies count

trigger_error('NOT_MODERATOR');

}

$forum_list = array($forum_id);

}

ORDER BY ' . $sort_order_sql;

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

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

{

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

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

{

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

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

*/

function validate_url($var1, $var2)

{

$var1 = str_replace("\r\n", "\n", str_replace('\"', '"', trim($var1)));

$var2 = str_replace("\r\n", "\n", str_replace('\"', '"', trim($var2)));

*/

function parse($allow_bbcode, $allow_magic_url, $allow_smilies, $allow_img_bbcode = true, $allow_flash_bbcode = true, $allow_quote_bbcode = true, $allow_url_bbcode = true, $update_this_message = true, $mode = 'post')

{

$this->mode = $mode;

*/

function get_submitted_attachment_data($check_user_id = false)

{

global $request;

$this->filename_data['filecomment'] = $request->variable('filecomment', '', true);

*/

function parse_poll(&$poll)

{

$poll_max_options = $poll['poll_max_options'];

return false;

}

$p = 0;

list ( $rows, $cols ) = array_values ( unpack ( "N*N*", substr ( $response, $p, 8 ) ) ); $p += 8;

}

// Now Build the address list

foreach ($address_list as $type => $adr_ary)

{

foreach ($adr_ary as $id => $field)

*/

function view_message($id, $mode, $folder_id, $msg_id, $folder, $message_row)

{

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

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

"\xF0\x9D\x9E\xBB" => "\xCF\x83",

"\xF0\x9D\x9F\x8A" => "\xCF\x9D",

);

// do the case fold

$text = utf8_case_fold($text, $option);

"\xE1\xBF\xB7" => "\xE1\xBF\xB6\xCD\x85",

"\xE1\xBF\xBC" => "\xCE\xA9\xCD\x85",

);

// perform a small trick, avoid further normalization on composed points that contain U+0345 in their decomposition

$text = strtr($text, $ypogegrammeni);

*/

function phpbb_prepare_message($message)

{

if (!$message)

{

$message = str_replace('\&quot;', '&quot;', $message);

}

$message = str_replace('<br />', "\n", $message);

$message = str_replace('<', '&lt;', $message);

$message = str_replace('>', '&gt;', $message);

*/

function phpbb_privmsgs_to_userid($to_userid)

{

return 'u_' . phpbb_user_id($to_userid);

}

*/

function phpbb_import_attach_config()

{

if ($convert->mysql_convert && $same_db)

{

*/

function phpbb_create_userconv_table()

{

switch ($db->get_sql_layer())

{

case 'mysql':

function phpbb_check_username_collisions()

{

// now find the clean version of the usernames that collide

$sql = 'SELECT username_clean

);

}

}

function phpbb_convert_password_hash($hash)

*/

function sql_report($mode, $query = '')

{

global $request;

if (is_object($request) && !$request->variable('explain', false))

}

list($default_key, $default_value) = each($default);

$key_type = gettype($default_key);

$_var = $var;

protected function cleanup($text, $allowed_chars = null, $encoding = 'utf-8')

{

static $conv = array(), $conv_loaded = array();

// Convert the text to UTF-8

$encoding = strtolower($encoding);

*/

function session_kill($new_session = true)

{

$sql = 'DELETE FROM ' . SESSIONS_TABLE . "

WHERE session_id = '" . $db->sql_escape($this->session_id) . "'

*/

function session_gc()

{

$batch_size = 10;

if ($banned && !$return)

{

// If the session is empty we need to create a valid one...

if (empty($this->session_id))