+ $banned_options = $excluded_options = array();

+ $option = '<option value="' . $row['ban_id'] . '">' . $row[$field] . '</option>';

+

+ if ($row['ban_exclude'])

+ {

+ $excluded_options[] = $option;

+ }

+ else

+ {

+ $banned_options[] = $option;

+ }

+ $options = '';

+ if ($excluded_options)

+ {

+ $options .= '<optgroup label="' . $user->lang['OPTIONS_EXCLUDED'] . '">';

+ $options .= implode('', $excluded_options);

+ $options .= '</optgroup>';

+ }

+

+ if ($banned_options)

+ {

+ $options .= '<optgroup label="' . $user->lang['OPTIONS_BANNED'] . '">';

+ $options .= implode('', $banned_options);

+ $options .= '</optgroup>';

+ }

+

+ 'S_BANNED_OPTIONS' => ($banned_options || $excluded_options) ? true : false,

+ 'BANNED_OPTIONS' => $options,

+ ));

+ if ($bbcode_id > BBCODE_LIMIT)

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

+ 'require_activation' => array('lang' => 'ACC_ACTIVATION', 'validate' => 'int', 'type' => 'select', 'method' => 'select_acc_activation', 'explain' => true),

+ 'max_pass_chars' => array('lang' => 'PASSWORD_LENGTH', 'validate' => 'int:8:255', 'type' => false, 'method' => false, 'explain' => false,),

+ 'min_pass_chars' => array('lang' => 'PASSWORD_LENGTH', 'validate' => 'int:1', 'type' => 'custom', 'method' => 'password_length', 'explain' => true),

+ 'ip_login_limit_max' => array('lang' => 'IP_LOGIN_LIMIT_MAX', 'validate' => 'int:0', 'type' => 'text:3:3', 'explain' => true),

+ 'ip_login_limit_time' => array('lang' => 'IP_LOGIN_LIMIT_TIME', 'validate' => 'int:0', 'type' => 'text:5:5', 'explain' => true, 'append' => ' ' . $user->lang['SECONDS']),

+ 'ip_login_limit_use_forwarded' => array('lang' => 'IP_LOGIN_LIMIT_USE_FORWARDED', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => true),

+ function select_acc_activation($selected_value, $value)

+ $act_ary = array(

+ 'ACC_DISABLE' => USER_ACTIVATION_DISABLE,

+ 'ACC_NONE' => USER_ACTIVATION_NONE,

+ );

+ $act_ary['ACC_USER'] = USER_ACTIVATION_SELF;

+ $act_ary['ACC_ADMIN'] = USER_ACTIVATION_ADMIN;

+ }

+ $act_options = '';

+

+ foreach ($act_ary as $key => $value)

+ {

+ $selected = ($selected_value == $value) ? ' selected="selected"' : '';

+ $act_options .= '<option value="' . $value . '"' . $selected . '>' . $user->lang[$key] . '</option>';

+ return $act_options;

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

+ var $db_tools;

+ if (!class_exists('phpbb_db_tools'))

+ {

+ require($phpbb_root_path . 'includes/db/db_tools.' . $phpEx);

+ }

+ $this->db_tools = new phpbb_db_tools($db);

+

+ $table = array_intersect($this->db_tools->sql_list_tables(), request_var('table', array('')));

+ $tables = $this->db_tools->sql_list_tables();

+ $download = request_var('download', '');

+ else if ($download || confirm_box(true))

+ else if (!$download)

+ {

+ confirm_box(false, $user->lang['RESTORE_SELECTED_BACKUP'], build_hidden_fields(array('file' => $file)));

+ }

+ $sql = 'SELECT disallow_id

+ FROM ' . DISALLOW_TABLE . "

+ WHERE disallow_username = '" . $db->sql_escape($disallowed_user) . "'";

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

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

+ $db->sql_freeresult($result);

+

+ if ($row)

+ {

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

+ }

+

+ $sql_ary = array(

+ 'SELECT' => 'u.user_email, u.username, u.username_clean, u.user_lang, u.user_jabber, u.user_notify_type',

+ 'FROM' => array(

+ USERS_TABLE => 'u',

+ USER_GROUP_TABLE => 'ug',

+ ),

+ 'WHERE' => 'ug.group_id = ' . $group_id . '

+ AND u.user_type IN (' . USER_NORMAL . ', ' . USER_FOUNDER . ')',

+ 'ORDER_BY' => 'u.user_lang, u.user_notify_type',

+ );

+ $sql_ary = array(

+ 'SELECT' => 'u.username, u.username_clean, u.user_email, u.user_jabber, u.user_lang, u.user_notify_type',

+ 'FROM' => array(

+ USERS_TABLE => 'u',

+ ),

+ 'WHERE' => 'u.user_allow_massemail = 1

+ AND u.user_type IN (' . USER_NORMAL . ', ' . USER_FOUNDER . ')',

+ 'ORDER_BY' => 'u.user_lang, u.user_notify_type',

+ );

+

+ // Mail banned or not

+ if (!isset($_REQUEST['mail_banned_flag']))

+ {

+ $sql_ary['WHERE'] .= ' AND (b.ban_id IS NULL

+ OR b.ban_exclude = 1)';

+ $sql_ary['LEFT_JOIN'] = array(

+ array(

+ 'FROM' => array(

+ BANLIST_TABLE => 'b',

+ ),

+ 'ON' => 'u.user_id = b.ban_userid',

+ ),

+ );

+ }

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

+ // Send with BCC

+ // Maximum number of bcc recipients

+ $max_chunk_size = (int) $config['email_max_chunk_size'];

+ $messenger->anti_abuse_headers($config, $user);

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

+ else if (!file_exists($phpbb_root_path . $img_path . '/' . $image))

+ {

+ $errors[$image] = 'SMILIE_NO_FILE';

+ }

+ $messenger->anti_abuse_headers($config, $user);

+ $messenger->anti_abuse_headers($config, $user);

+ 'U_ACTION' => $this->u_action . "&amp;$u_sort_param&amp;users_per_page=$per_page&amp;start=$start",

+ // We want to notify the admin that custom profile fields need to be updated for the new language.

+ $notify_cpf_update = false;

+

+ $notify_cpf_update = true;

+ $notify_cpf_update = true;

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

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

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

+ // index.htm files

+ $compress->add_data('', 'language/' . $row['lang_iso'] . '/index.htm');

+ $compress->add_data('', 'language/' . $row['lang_iso'] . '/email/index.htm');

+ $compress->add_data('', 'language/' . $row['lang_iso'] . '/acp/index.htm');

+ $compress->add_data('', 'language/' . $row['lang_iso'] . '/mods/index.htm');

+ $this->main_files = array("captcha_qa.$phpEx", "captcha_recaptcha.$phpEx", "common.$phpEx", "groups.$phpEx", "install.$phpEx", "mcp.$phpEx", "memberlist.$phpEx", "posting.$phpEx", "search.$phpEx", "ucp.$phpEx", "viewforum.$phpEx", "viewtopic.$phpEx", "help_bbcode.$phpEx", "help_faq.$phpEx");

+ $start = view_log($mode, $log_data, $log_count, $config['topics_per_page'], $start, $forum_id, 0, 0, $sql_where, $sql_sort, $keywords);

+ 'U_ACTION' => $this->u_action . "&amp;$u_sort_param$keywords_param&amp;start=$start",

+ $sql = 'SELECT MAX(post_id) as max_post_id

+ if ($auth->acl_get('a_server') && version_compare(PHP_VERSION, '5.3.2', '<'))

+ 'L_PHP_VERSION_OLD' => sprintf($user->lang['PHP_VERSION_OLD'], '<a href="http://www.phpbb.com/community/viewtopic.php?f=14&amp;t=2152375">', '</a>'),

+ 'S_VERSION_UP_TO_DATE' => phpbb_version_compare(trim($latest_version_info[0]), $config['version'], '<='),

+ 'U_VERSIONCHECK_FORCE' => append_sid("{$phpbb_admin_path}index.$phpEx", 'versioncheck_force=1'),

+ $log_count = false;

+ if (extension_loaded('mbstring'))

+ {

+ $template->assign_vars(array(

+ 'S_MBSTRING_LOADED' => true,

+ 'S_MBSTRING_FUNC_OVERLOAD_FAIL' => (intval(@ini_get('mbstring.func_overload')) & (MB_OVERLOAD_MAIL | MB_OVERLOAD_STRING)),

+ 'S_MBSTRING_ENCODING_TRANSLATION_FAIL' => (@ini_get('mbstring.encoding_translation') != 0),

+ 'S_MBSTRING_HTTP_INPUT_FAIL' => (@ini_get('mbstring.http_input') != 'pass'),

+ 'S_MBSTRING_HTTP_OUTPUT_FAIL' => (@ini_get('mbstring.http_output') != 'pass'),

+ ));

+ }

+

+ // Fix invalid anchor names (eg "module_Zend Optimizer")

+ $output = preg_replace_callback('#<a name="([^"]+)">#', array($this, 'remove_spaces'), $output);

+

+

+ function remove_spaces($matches)

+ {

+ return '<a name="' . str_replace(' ', '_', $matches[1]) . '">';

+ }

+ else if ($field_type == FIELD_BOOL && $key == 'field_default_value')

+ // 'field_length' == 1 defines radio buttons. Possible values are 1 or 2 only.

+ // 'field_length' == 2 defines checkbox. Possible values are 0 or 1 only.

+ // If we switch the type on step 2, we have to adjust field value.

+ // 1 is a common value for the checkbox and radio buttons.

+

+ // Adjust unchecked checkbox value.

+ // If we return or save settings from 2nd/3rd page

+ // and the checkbox is unchecked, set the value to 0.

+ if (isset($_REQUEST['step']) && !isset($_REQUEST[$key]))

+ {

+ $var = 0;

+ }

+

+ // If we switch to the checkbox type but former radio buttons value was 2,

+ // which is not the case for the checkbox, set it to 0 (unchecked).

+ if ($cp->vars['field_length'] == 2 && $var == 2)

+ {

+ $var = 0;

+ }

+ // If we switch to the radio buttons but the former checkbox value was 0,

+ // which is not the case for the radio buttons, set it to 0.

+ else if ($cp->vars['field_length'] == 1 && $var == 0)

+ {

+ $var = 2;

+ }

+ }

+ if ($action == 'create' && request_var('field_default_value', '') === '')

+ else if ($field_type == FIELD_BOOL && $key == 'field_default_value')

+ {

+ $_new_key_ary[$key] = request_var($key, $cp->vars[$key]);

+ }

+ $min_posts = ($special_rank) ? 0 : max(0, request_var('min_posts', 0));

+ 'S_SPECIAL_RANK' => (isset($ranks['rank_special']) && $ranks['rank_special']) ? true : false,

+ $buffer = $db->sql_buffer_nested_transactions();

+

+ if ($buffer)

+ {

+ $rows = $db->sql_fetchrowset($result);

+ $rows[] = false; // indicate end of array for while loop below

+

+ $db->sql_freeresult($result);

+ }

+

+ $i = 0;

+ while ($row = ($buffer ? $rows[$i++] : $db->sql_fetchrow($result)))

+ if (!$buffer)

+ {

+ $db->sql_freeresult($result);

+ }

+# Template inheritance

+# See http://blog.phpbb.com/2008/07/31/templating-just-got-easier/

+# Set value to empty or this template name to ignore template inheritance.

+inherit_from = {INHERIT_FROM}

+';

+ $cache->destroy('imageset_site_logo_md5');

+ $sql_sort = 'LOWER(' . $mode . '_name)';

+ $sql_sort = 'style_active DESC, ' . $sql_sort;

+

+ default:

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

+ FROM $sql_from

+ ORDER BY $sql_sort ASC";

+

+ 'S_INACTIVE' => ($mode == 'style' && !$row['style_active']) ? true : false,

+ // The array key is used for sorting later on.

+ // $file is appended because $name doesn't have to be unique.

+ $new_ary[$name . $file] = array(

+ ksort($new_ary);

+

+ $template_file = preg_replace('#\.{2,}#', '.', $template_file);

+ $sql_select = 'style_id, style_name, template_id, theme_id, imageset_id';

+ $sql_select = 'template_id, template_name, template_path, template_storedb';

+ $sql_select = 'theme_id, theme_name, theme_path, theme_storedb';

+ $sql_select = 'imageset_id, imageset_name, imageset_path';

+ $s_only_component = $this->display_component_options($mode, $style_row[$mode . '_id'], $style_row);

+ if ($s_only_component)

+ $sql = "DELETE FROM $sql_from

+ WHERE {$mode}_id = $style_id";

+ $db->sql_query($sql);

+

+

+ // Remove the components

+ $components = array('template', 'theme', 'imageset');

+ foreach ($components as $component)

+ {

+ $new_id = request_var('new_' . $component . '_id', 0);

+ $component_id = $style_row[$component . '_id'];

+ $this->remove_component($component, $component_id, $new_id, $style_id);

+ }

+ $this->remove_component($mode, $style_id, $new_id);

+

+ if ($mode == 'style')

+ {

+ $template->assign_vars(array(

+ 'S_DELETE_STYLE' => true,

+ ));

+ }

+ }

+

+ /**

+ * Remove template/theme/imageset entry from the database

+ */

+ function remove_component($component, $component_id, $new_id, $style_id = false)

+ {

+ global $db;

+

+ if (($new_id == 0) || ($component === 'template' && ($conflicts = $this->check_inheritance($component, $component_id))))

+ {

+ // We can not delete the template, as the user wants to keep the component or an other template is inheriting from this one.

+ return;

+ }

+

+ $component_in_use = array();

+ if ($component != 'style')

+ {

+ $component_in_use = $this->component_in_use($component, $component_id, $style_id);

+ }

+

+ if (($new_id == -1) && !empty($component_in_use))

+ {

+ // We can not delete the component, as it is still in use

+ return;

+ }

+

+ if ($component == 'imageset')

+ {

+ $sql = 'DELETE FROM ' . STYLES_IMAGESET_DATA_TABLE . "

+ WHERE imageset_id = $component_id";

+ $db->sql_query($sql);

+ }

+

+ switch ($component)

+ {

+ case 'template':

+ $sql_from = STYLES_TEMPLATE_TABLE;

+ break;

+

+ case 'theme':

+ $sql_from = STYLES_THEME_TABLE;

+ break;

+

+ case 'imageset':

+ $sql_from = STYLES_IMAGESET_TABLE;;

+ break;

+ }

+

+ $sql = "DELETE FROM $sql_from

+ WHERE {$component}_id = $component_id";

+ $db->sql_query($sql);

+

+ $sql = 'UPDATE ' . STYLES_TABLE . "

+ SET {$component}_id = $new_id

+ WHERE {$component}_id = $component_id";

+ $db->sql_query($sql);

+ }

+

+ /**

+ * Display the options which can be used to replace a style/template/theme/imageset

+ *

+ * @return boolean Returns true if the component is the only component and can not be deleted.

+ */

+ function display_component_options($component, $component_id, $style_row = false, $style_id = false)

+ {

+ global $db, $template, $user;

+

+ $is_only_component = true;

+ $component_in_use = array();

+ if ($component != 'style')

+ {

+ $component_in_use = $this->component_in_use($component, $component_id, $style_id);

+ }

+

+ $sql_where = '';

+ switch ($component)

+ {

+ case 'style':

+ $sql_from = STYLES_TABLE;

+ $sql_where = 'WHERE style_active = 1';

+ break;

+

+ case 'template':

+ $sql_from = STYLES_TEMPLATE_TABLE;

+ $sql_where = 'WHERE template_inherits_id <> ' . $component_id;

+ break;

+

+ case 'theme':

+ $sql_from = STYLES_THEME_TABLE;

+ break;

+

+ case 'imageset':

+ $sql_from = STYLES_IMAGESET_TABLE;

+ break;

+ }

+

+ $s_options = '';

+ if (($component != 'style') && empty($component_in_use))

+ {

+ // If it is not in use, there must be another component

+ $is_only_component = false;

+

+ $sql = "SELECT {$component}_id, {$component}_name

+ FROM $sql_from

+ WHERE {$component}_id = {$component_id}";

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

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

+ $db->sql_freeresult($result);

+

+ $s_options .= '<option value="-1" selected="selected">' . $user->lang['DELETE_' . strtoupper($component)] . '</option>';

+ $s_options .= '<option value="0">' . sprintf($user->lang['KEEP_' . strtoupper($component)], $row[$component . '_name']) . '</option>';

+ }

+ else

+ {

+ $sql = "SELECT {$component}_id, {$component}_name

+ FROM $sql_from

+ $sql_where

+ ORDER BY {$component}_name ASC";

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

+

+ $s_keep_option = $s_options = '';

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

+ {

+ if ($row[$component . '_id'] != $component_id)

+ {

+ $is_only_component = false;

+ $s_options .= '<option value="' . $row[$component . '_id'] . '">' . sprintf($user->lang['REPLACE_WITH_OPTION'], $row[$component . '_name']) . '</option>';

+ }

+ else if ($component != 'style')

+ {

+ $s_keep_option = '<option value="0" selected="selected">' . sprintf($user->lang['KEEP_' . strtoupper($component)], $row[$component . '_name']) . '</option>';

+ }

+ }

+ $db->sql_freeresult($result);

+ $s_options = $s_keep_option . $s_options;

+ }

+

+ if (!$style_row)

+ {

+ $template->assign_var('S_REPLACE_' . strtoupper($component) . '_OPTIONS', $s_options);

+ }

+ else

+ {

+ $template->assign_var('S_REPLACE_OPTIONS', $s_options);

+ if ($component == 'style')

+ {

+ $components = array('template', 'theme', 'imageset');

+ foreach ($components as $component)

+ {

+ $this->display_component_options($component, $style_row[$component . '_id'], false, $component_id, true);

+ }

+ }

+ }

+

+ return $is_only_component;

+ }

+

+ /**

+ * Check whether the component is still used by another style or component

+ */

+ function component_in_use($component, $component_id, $style_id = false)

+ {

+ global $db;

+

+ $component_in_use = array();

+

+ if ($style_id)

+ {

+ $sql = 'SELECT style_id, style_name

+ FROM ' . STYLES_TABLE . "

+ WHERE {$component}_id = {$component_id}

+ AND style_id <> {$style_id}

+ ORDER BY style_name ASC";

+ }

+ else

+ {

+ $sql = 'SELECT style_id, style_name

+ FROM ' . STYLES_TABLE . "

+ WHERE {$component}_id = {$component_id}

+ ORDER BY style_name ASC";

+ }

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

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

+ {

+ $component_in_use[] = $row['style_name'];

+ }

+ $db->sql_freeresult($result);

+

+ if ($component === 'template' && ($conflicts = $this->check_inheritance($component, $component_id)))

+ {

+ foreach ($conflicts as $temp_id => $conflict_data)

+ {

+ $component_in_use[] = $conflict_data['template_name'];

+ }

+ }

+

+ return $component_in_use;

+ $use_template_name = $style_row['template_name'];

+ $template_cfg = str_replace(array('{MODE}', '{NAME}', '{COPYRIGHT}', '{VERSION}', '{INHERIT_FROM}'), array($mode, $style_row['template_name'], $style_row['template_copyright'], $config['version'], $use_template_name), $this->template_cfg);

+

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

+ 'S_UP_TO_DATE' => phpbb_version_compare($latest_version, $config['version'], '<='),

+ 'S_UP_TO_DATE_AUTO' => phpbb_version_compare($latest_version, $current_version, '<='),

+ $messenger->anti_abuse_headers($config, $user);

+ $messenger->anti_abuse_headers($config, $user);

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

+ $sql = 'SELECT post_id

+ FROM ' . POSTS_TABLE . '

+ WHERE poster_id = '. $user_id;

+ $result = $db->sql_query_limit($sql, 1);

+ $user_row['user_has_posts'] = (bool) $db->sql_fetchfield('post_id');

+ $db->sql_freeresult($result);

+

+ 'USER_HAS_POSTS' => $user_row['user_has_posts'],

+ $start = view_log('user', $log_data, $log_count, $config['topics_per_page'], $start, 0, 0, $user_id, $sql_where, $sql_sort);

+ * Set option bit field for user options in a user row array.

+ *

+ * Optionset replacement for this module based on $user->optionset.

+ *

+ * @param array $user_row Row from the users table.

+ * @param int $key Option key, as defined in $user->keyoptions property.

+ * @param bool $value True to set the option, false to clear the option.

+ * @param int $data Current bit field value, or false to use $user_row['user_options']

+ * @return int|bool If $data is false, the bit field is modified and

+ * written back to $user_row['user_options'], and

+ * return value is true if the bit field changed and

+ * false otherwise. If $data is not false, the new

+ * bitfield value is returned.

+ $var = ($data !== false) ? $data : $user_row['user_options'];

+ $new_var = phpbb_optionset($user->keyoptions[$key], $value, $var);

+ if ($data === false)

+ if ($new_var != $var)

+ {

+ $user_row['user_options'] = $new_var;

+ return true;

+ }

+ else

+ {

+ return false;

+ }

+ return $new_var;

+ * Get option bit field from user options in a user row array.

+ *

+ * Optionget replacement for this module based on $user->optionget.

+ *

+ * @param array $user_row Row from the users table.

+ * @param int $key option key, as defined in $user->keyoptions property.

+ * @param int $data bit field value to use, or false to use $user_row['user_options']

+ * @return bool true if the option is set in the bit field, false otherwise

+ $var = ($data !== false) ? $data : $user_row['user_options'];

+ return phpbb_optionget($user->keyoptions[$key], $var);

+ // Replace multiple consecutive asterisks with single one as those are not needed

+ $word = preg_replace('#\*{2,}#', '*', $word);

+