- $banned_options = '';

- $banned_options .= '<option' . (($row['ban_exclude']) ? ' class="sep"' : '') . ' value="' . $row['ban_id'] . '">' . $row[$field] . '</option>';

- 'S_BANNED_OPTIONS' => ($banned_options) ? true : false,

- 'BANNED_OPTIONS' => $banned_options)

- );

- 'min_post_chars' => array('lang' => 'MIN_CHAR_LIMIT', 'validate' => 'int:0', 'type' => 'text:4:6', 'explain' => true),

- // Send with BCC, no more than 50 recipients for one mail (to not exceed the limit)

- $max_chunk_size = 50;

- // Redirect to permissions

- if ($auth->acl_get('a_fauth') && !$copied_permissions)

- {

- $message .= '<br /><br />' . sprintf($user->lang['REDIRECT_ACL'], '<a href="' . append_sid("{$phpbb_admin_path}index.$phpEx", 'i=permissions' . $acl_url) . '">', '</a>');

- }

-

- if (!$forum_data['forum_name'])

- if (isset($submit_ary[$test]) && ($action == 'add' || $group_row['group_' . $test] != $submit_ary[$test]))

- set_config('teampage_multiple', request_var('teampage_multiple', 0));

- 'S_GROUP_SELECT_LEGEND' => $s_group_select_legend,

- 'S_GROUP_SELECT_TEAMPAGE' => $s_group_select_teampage,

- 'DISPLAY_FORUMS' => ($config['teampage_forums']) ? true : false,

- 'DISPLAY_MULTIPLE' => ($config['teampage_multiple']) ? true : false,

- 'LEGEND_SORT_GROUPNAME' => ($config['legend_sort_groupname']) ? true : false,

- trigger_error(sprintf($user->lang['LANGUAGE_PACK_INSTALLED'], $lang_pack['name']) . adm_back_link($this->u_action));

- 'S_SPECIAL_RANK' => (!isset($ranks['rank_special']) || $ranks['rank_special']) ? true : false,

- $info = obtain_latest_version_info(request_var('versioncheck_force', false), true);

- $update_password = ($data['new_password'] && !phpbb_check_hash($user_row['user_password'], $data['new_password'])) ? true : false;

- * Check if a specified column exist

- * @param string $table Table to check the column at

- * @param string $column_name The column to check

- * @return bool True if column exists, else false

- function sql_column_exists($table, $column_name)

-

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

-

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

- {

- // lower case just in case

- if (strtolower($row['Field']) == $column_name)

- {

- $this->db->sql_freeresult($result);

- return true;

- }

- }

- $this->db->sql_freeresult($result);

- return false;

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

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

- {

- // lower case just in case

- if (strtolower($row['attname']) == $column_name)

- {

- $this->db->sql_freeresult($result);

- return true;

- }

- }

- $this->db->sql_freeresult($result);

-

- return false;

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

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

- {

- // lower case just in case

- if (strtolower($row['name']) == $column_name)

- {

- $this->db->sql_freeresult($result);

- return true;

- }

- }

- $this->db->sql_freeresult($result);

- return false;

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

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

- {

- // lower case just in case

- if (strtolower($row['column_name']) == $column_name)

- {

- $this->db->sql_freeresult($result);

- return true;

- }

- }

- $this->db->sql_freeresult($result);

- return false;

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

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

- {

- // lower case just in case

- if (strtolower($row['fname']) == $column_name)

- {

- $this->db->sql_freeresult($result);

- return true;

- }

- }

- $this->db->sql_freeresult($result);

- return false;

- // ugh, SQLite

- if (strtolower($entities[0]) == $column_name)

- {

- return true;

- }

- return false;

- $statements[] = 'CREATE UNIQUE INDEX ' . $index_name . ' ON ' . $table_name . '(' . implode(', ', $column) . ')';

- $statements[] = 'CREATE INDEX ' . $index_name . ' ON ' . $table_name . '(' . implode(', ', $column) . ')';

- return ($query_id !== false) ? @mysqli_fetch_assoc($query_id) : false;

- global $db, $tracking_topics, $user, $config, $request;

- AND t.topic_moved_id = 0

- AND topic_moved_id = 0';

- $page_string .= ($start_cnt > 1) ? ' ... ' : $separator;

- $page_string .= ($end_cnt < $total_pages) ? ' ... ' : $separator;

- if (function_exists('memory_get_usage'))

- if ($memory_usage = memory_get_usage())

- global $base_memory_usage;

- $memory_usage -= $base_memory_usage;

- $debug_output .= ' | Memory Usage: ' . $memory_usage;

- if (function_exists('memory_get_usage'))

- if ($memory_usage = memory_get_usage())

- global $base_memory_usage;

- $memory_usage -= $base_memory_usage;

- $debug_output .= ' | Memory Usage: ' . $memory_usage;

-function get_remote_file($host, $directory, $filename, &$errstr, &$errno, $port = 80, $timeout = 10)

- $pagination .= ' ... ';

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

- if (($uid != $user_id) || ($request->variable('unwatch', '', false, phpbb_request_interface::GET) != $mode))

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

- $confirm_box_message = (($item_title == '') ? 'UNWATCH_' . strtoupper($mode) : $user->lang('UNWATCH_' . strtoupper($mode) . '_DETAILED', $item_title));

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

- if (($uid != $user_id) || ($request->variable('watch', '', false, phpbb_request_interface::GET) != $mode))

- ),

-function get_tables($db)

- switch ($db->sql_layer)

- case 'mysql':

- case 'mysql4':

- case 'mysqli':

- $sql = 'SHOW TABLES';

- break;

-

- case 'sqlite':

- $sql = 'SELECT name

- FROM sqlite_master

- WHERE type = "table"';

- break;

-

- case 'mssql':

- case 'mssql_odbc':

- case 'mssqlnative':

- $sql = "SELECT name

- FROM sysobjects

- WHERE type='U'";

- break;

-

- case 'postgres':

- $sql = 'SELECT relname

- FROM pg_stat_user_tables';

- break;

-

- case 'firebird':

- $sql = 'SELECT rdb$relation_name

- FROM rdb$relations

- WHERE rdb$view_source is null

- AND rdb$system_flag = 0';

- break;

-

- case 'oracle':

- $sql = 'SELECT table_name

- FROM USER_TABLES';

- break;

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

- $tables = array();

-

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

- {

- $tables[] = current($row);

- }

-

- $db->sql_freeresult($result);

-

- return $tables;

- 3) Add a new language variable to ucp.php

- RULE_IS_LIKE => array('check0' => 'message_subject', 'function' => 'preg_match("/" . preg_quote({STRING}, "/") . "/i", {CHECK0})'),

- RULE_IS_NOT_LIKE => array('check0' => 'message_subject', 'function' => '!(preg_match("/" . preg_quote({STRING}, "/") . "/i", {CHECK0}))'),

- RULE_IS => array('check0' => 'message_subject', 'function' => '{CHECK0} == {STRING}'),

- RULE_IS_NOT => array('check0' => 'message_subject', 'function' => '{CHECK0} != {STRING}'),

- RULE_BEGINS_WITH => array('check0' => 'message_subject', 'function' => 'preg_match("/^" . preg_quote({STRING}, "/") . "/i", {CHECK0})'),

- RULE_ENDS_WITH => array('check0' => 'message_subject', 'function' => 'preg_match("/" . preg_quote({STRING}, "/") . "$/i", {CHECK0})'),

- RULE_IS_LIKE => array('check0' => 'username', 'function' => 'preg_match("/" . preg_quote({STRING}, "/") . "/i", {CHECK0})'),

- RULE_IS_NOT_LIKE => array('check0' => 'username', 'function' => '!(preg_match("/" . preg_quote({STRING}, "/") . "/i", {CHECK0}))'),

- RULE_IS => array('check0' => 'username', 'function' => '{CHECK0} == {STRING}'),

- RULE_IS_NOT => array('check0' => 'username', 'function' => '{CHECK0} != {STRING}'),

- RULE_BEGINS_WITH => array('check0' => 'username', 'function' => 'preg_match("/^" . preg_quote({STRING}, "/") . "/i", {CHECK0})'),

- RULE_ENDS_WITH => array('check0' => 'username', 'function' => 'preg_match("/" . preg_quote({STRING}, "/") . "$/i", {CHECK0})'),

- RULE_IS_FRIEND => array('check0' => 'friend', 'function' => '{CHECK0} == 1'),

- RULE_IS_FOE => array('check0' => 'foe', 'function' => '{CHECK0} == 1'),

- RULE_IS_USER => array('check0' => 'author_id', 'function' => '{CHECK0} == {USER_ID}'),

- RULE_IS_GROUP => array('check0' => 'author_in_group', 'function' => 'in_array({GROUP_ID}, {CHECK0})'),

- RULE_IS_LIKE => array('check0' => 'message_text', 'function' => 'preg_match("/" . preg_quote({STRING}, "/") . "/i", {CHECK0})'),

- RULE_IS_NOT_LIKE => array('check0' => 'message_text', 'function' => '!(preg_match("/" . preg_quote({STRING}, "/") . "/i", {CHECK0}))'),

- RULE_IS => array('check0' => 'message_text', 'function' => '{CHECK0} == {STRING}'),

- RULE_IS_NOT => array('check0' => 'message_text', 'function' => '{CHECK0} != {STRING}'),

- RULE_ANSWERED => array('check0' => 'pm_replied', 'function' => '{CHECK0} == 1'),

- RULE_FORWARDED => array('check0' => 'pm_forwarded', 'function' => '{CHECK0} == 1'),

- RULE_TO_GROUP => array('check0' => 'to', 'check1' => 'bcc', 'check2' => 'user_in_group', 'function' => 'in_array("g_" . {CHECK2}, {CHECK0}) || in_array("g_" . {CHECK2}, {CHECK1})'),

- RULE_TO_ME => array('check0' => 'to', 'check1' => 'bcc', 'function' => 'in_array("u_" . $user_id, {CHECK0}) || in_array("u_" . $user_id, {CHECK1})'),

- // Replace Check Literals

- $evaluate = $check_ary['function'];

- $evaluate = preg_replace('/{(CHECK[0-9])}/', '$message_row[$check_ary[strtolower("\1")]]', $evaluate);

- // Replace Rule Literals

- $evaluate = preg_replace('/{(STRING|USER_ID|GROUP_ID)}/', '$rule_row["rule_" . strtolower("\1")]', $evaluate);

- // Evil Statement

- $result = false;

- eval('$result = (' . $evaluate . ') ? true : false;');

- pm_notification($mode, $data['from_username'], $recipients, $subject, $data['message']);

-function pm_notification($mode, $author, $recipients, $subject, $message)

- 'U_INBOX' => generate_board_url() . "/ucp.$phpEx?i=pm&folder=inbox")

- );

- // For changing topic types, we only allow operations in one forum.

- $forum_id = check_ids($topic_ids, TOPICS_TABLE, 'topic_id', array('f_announce', 'f_sticky', 'm_'), true);

-

- if ($forum_id === false)

- {

- return;

- }

-

- $check_acl = '';

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

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

- 'S_POST_UNAPPROVED' => ($row['post_approved']) ? false : true,

-// If we are on PHP >= 6.0.0 we do not need some code

-if (version_compare(PHP_VERSION, '6.0.0-dev', '>='))

-

- $email_template = 'group_added';

- $email_template = 'group_request';

- }

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

- $messenger = new messenger();

- $sql = 'SELECT u.username, u.username_clean, u.user_email, u.user_notify_type, u.user_jabber, u.user_lang

- FROM ' . USER_GROUP_TABLE . ' ug, ' . USERS_TABLE . ' u

- WHERE ug.user_id = u.user_id

- AND ' . (($group_row[$group_id]['group_type'] == GROUP_FREE) ? "ug.user_id = {$user->data['user_id']}" : 'ug.group_leader = 1') . "

- AND ug.group_id = $group_id";

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

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

- {

- $messenger->template($email_template, $row['user_lang']);

- $messenger->to($row['user_email'], $row['username']);

- $messenger->im($row['user_jabber'], $row['username']);

- $messenger->assign_vars(array(

- 'USERNAME' => htmlspecialchars_decode($row['username']),

- 'GROUP_NAME' => htmlspecialchars_decode($group_row[$group_id]['group_name']),

- 'REQUEST_USERNAME' => $user->data['username'],

- 'U_PENDING' => generate_board_url() . "/ucp.$phpEx?i=groups&mode=manage&action=list&g=$group_id",

- 'U_GROUP' => generate_board_url() . "/memberlist.$phpEx?mode=group&g=$group_id")

- );

- $messenger->send($row['user_notify_type']);

- $db->sql_freeresult($result);

-

- $messenger->save_queue();

- if ($user->data['user_new_privmsg'] && $action == 'view_folder')

- global $phpbb_root_path, $phpEx, $config;

- 'U_ICQ' => ($user_info['user_icq']) ? 'http://www.icq.com/people' . urlencode($user_info['user_icq']) . '/' : '',

- if ($auth->acl_get('u_chgpasswd') && $data['new_password'] && $data['password_confirm'] != $data['new_password'])

- $error[] = 'NEW_PASSWORD_ERROR';

- if (($data['new_password'] || ($auth->acl_get('u_chgemail') && $data['email'] != $user->data['user_email']) || ($data['username'] != $user->data['username'] && $auth->acl_get('u_chgname') && $config['allow_namechange'])) && !phpbb_check_hash($data['cur_password'], $user->data['user_password']))

- $error[] = 'CUR_PASSWORD_ERROR';

- if ($auth->acl_get('u_chgemail') && $data['email'] != $user->data['user_email'] && $data['email_confirm'] != $data['email'])

- $error[] = 'NEW_EMAIL_ERROR';