+ $max_filesize = get_formatted_filesize($ext_group_row['max_filesize'], false, array('mb', 'kb', 'b'));

+ $size_format = $max_filesize['si_identifier'];

+ $ext_group_row['max_filesize'] = $max_filesize['value'];

+ if (!empty($imglist['']))

+ 'REAL_FILENAME' => utf8_basename($row['real_filename']),

+ 'PHYSICAL_FILENAME' => utf8_basename($row['physical_filename']),

+ $filesize = get_formatted_filesize($value, false, array('mb', 'kb', 'b'));

+ $size_var = $filesize['si_identifier'];

+ $value = $filesize['value'];

+ AND ban_ip <> ''

+ ORDER BY ban_ip";

+ AND ban_email <> ''

+ ORDER BY ban_email";

+

+ if ($time_length == 0)

+ {

+ // Banned permanently

+ $ban_length[$row['ban_id']] = $user->lang['PERMANENT'];

+ }

+ else if (isset($ban_end_text[$time_length]))

+ {

+ // Banned for a given duration

+ $ban_length[$row['ban_id']] = sprintf($user->lang['BANNED_UNTIL_DURATION'], $ban_end_text[$time_length], $user->format_date($row['ban_end'], false, true));

+ }

+ else

+ {

+ // Banned until given date

+ $ban_length[$row['ban_id']] = sprintf($user->lang['BANNED_UNTIL_DATE'], $user->format_date($row['ban_end'], false, true));

+ }

+

+ 'legend3' => 'ACP_SUBMIT_CHANGES',

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

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

+

+ 'legend3' => 'ACP_SUBMIT_CHANGES',

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

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

+ 'enable_pm_icons' => array('lang' => 'ENABLE_PM_ICONS', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => false),

+

+ 'legend3' => 'ACP_SUBMIT_CHANGES',

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

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

+ 'smilies_per_page' => array('lang' => 'SMILIES_PER_PAGE', 'validate' => 'int:1', 'type' => 'text:3:4', 'explain' => false),

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

+

+ 'legend3' => 'ACP_SUBMIT_CHANGES',

+

+ 'legend3' => 'ACP_SUBMIT_CHANGES',

+ 'new_member_post_limit' => array('lang' => 'NEW_MEMBER_POST_LIMIT', 'validate' => 'int:0:255', 'type' => 'text:4:4', 'explain' => true, 'append' => ' ' . $user->lang['POSTS']),

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

+

+ 'legend4' => 'ACP_SUBMIT_CHANGES',

+ )

+ );

+ break;

+

+ case 'feed':

+ $display_vars = array(

+ 'title' => 'ACP_FEED_MANAGEMENT',

+ 'vars' => array(

+ 'legend1' => 'ACP_FEED_GENERAL',

+ 'feed_enable' => array('lang' => 'ACP_FEED_ENABLE', 'validate' => 'bool', 'type' => 'radio:enabled_disabled', 'explain' => true ),

+ 'feed_item_statistics' => array('lang' => 'ACP_FEED_ITEM_STATISTICS', 'validate' => 'bool', 'type' => 'radio:enabled_disabled', 'explain' => true),

+ 'feed_limit' => array('lang' => 'ACP_FEED_LIMIT', 'validate' => 'int:5', 'type' => 'text:3:4', 'explain' => true),

+ 'feed_overall_forums' => array('lang' => 'ACP_FEED_OVERALL_FORUMS', 'validate' => 'bool', 'type' => 'radio:enabled_disabled', 'explain' => true ),

+ 'feed_overall_forums_limit' => array('lang' => 'ACP_FEED_OVERALL_FORUMS_LIMIT', 'validate' => 'int:5', 'type' => 'text:3:4', 'explain' => false),

+ 'feed_overall_topics' => array('lang' => 'ACP_FEED_OVERALL_TOPIC', 'validate' => 'bool', 'type' => 'radio:enabled_disabled', 'explain' => true ),

+ 'feed_overall_topics_limit' => array('lang' => 'ACP_FEED_OVERALL_TOPIC_LIMIT', 'validate' => 'int:5', 'type' => 'text:3:4', 'explain' => false),

+ 'feed_forum' => array('lang' => 'ACP_FEED_FORUM', 'validate' => 'bool', 'type' => 'radio:enabled_disabled', 'explain' => true ),

+ 'feed_topic' => array('lang' => 'ACP_FEED_TOPIC', 'validate' => 'bool', 'type' => 'radio:enabled_disabled', 'explain' => true ),

+ 'feed_news_id' => array('lang' => 'ACP_FEED_NEWS', 'validate' => 'string', 'type' => 'custom', 'method' => 'select_news_forums', 'explain' => true),

+ 'feed_exclude_id' => array('lang' => 'ACP_FEED_EXCLUDE_ID', 'validate' => 'string', 'type' => 'custom', 'method' => 'select_exclude_forums', 'explain' => true),

+

+ 'legend4' => 'ACP_SUBMIT_CHANGES',

+

+ 'legend4' => 'ACP_SUBMIT_CHANGES',

+ 'smtp_password' => array('lang' => 'SMTP_PASSWORD', 'validate' => 'string', 'type' => 'password:25:255', 'explain' => true),

+

+ 'legend3' => 'ACP_SUBMIT_CHANGES',

+ if ($config_name == 'auth_method' || $config_name == 'feed_news_id' || $config_name == 'feed_exclude_id')

+ // Store news and exclude ids

+ if ($mode == 'feed' && $submit)

+ {

+ $this->store_feed_forums(FORUM_OPTION_FEED_NEWS, 'feed_news_id');

+ $this->store_feed_forums(FORUM_OPTION_FEED_EXCLUDE, 'feed_exclude_id');

+ }

+

+

+ /**

+ * Select multiple forums

+ */

+ function select_news_forums($value, $key)

+ {

+ global $user, $config;

+

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

+

+ // Build forum options

+ $s_forum_options = '<select id="' . $key . '" name="' . $key . '[]" multiple="multiple">';

+ foreach ($forum_list as $f_id => $f_row)

+ {

+ $f_row['selected'] = phpbb_optionget(FORUM_OPTION_FEED_NEWS, $f_row['forum_options']);

+

+ $s_forum_options .= '<option value="' . $f_id . '"' . (($f_row['selected']) ? ' selected="selected"' : '') . (($f_row['disabled']) ? ' disabled="disabled" class="disabled-option"' : '') . '>' . $f_row['padding'] . $f_row['forum_name'] . '</option>';

+ }

+ $s_forum_options .= '</select>';

+

+ return $s_forum_options;

+ }

+

+ function select_exclude_forums($value, $key)

+ {

+ global $user, $config;

+

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

+

+ // Build forum options

+ $s_forum_options = '<select id="' . $key . '" name="' . $key . '[]" multiple="multiple">';

+ foreach ($forum_list as $f_id => $f_row)

+ {

+ $f_row['selected'] = phpbb_optionget(FORUM_OPTION_FEED_EXCLUDE, $f_row['forum_options']);

+

+ $s_forum_options .= '<option value="' . $f_id . '"' . (($f_row['selected']) ? ' selected="selected"' : '') . (($f_row['disabled']) ? ' disabled="disabled" class="disabled-option"' : '') . '>' . $f_row['padding'] . $f_row['forum_name'] . '</option>';

+ }

+ $s_forum_options .= '</select>';

+

+ return $s_forum_options;

+ }

+

+ function store_feed_forums($option, $key)

+ {

+ global $db, $cache;

+

+ // Get key

+ $values = request_var($key, array(0 => 0));

+

+ // Empty option bit for all forums

+ $sql = 'UPDATE ' . FORUMS_TABLE . '

+ SET forum_options = forum_options - ' . (1 << $option) . '

+ WHERE ' . $db->sql_bit_and('forum_options', $option, '<> 0');

+ $db->sql_query($sql);

+

+ // Already emptied for all...

+ if (sizeof($values))

+ {

+ // Set for selected forums

+ $sql = 'UPDATE ' . FORUMS_TABLE . '

+ SET forum_options = forum_options + ' . (1 << $option) . '

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

+ $db->sql_query($sql);

+ }

+

+ // Empty sql cache for forums table because options changed

+ $cache->destroy('sql', FORUMS_TABLE);

+ }

+

+ include($phpbb_root_path . 'includes/captcha/captcha_factory.' . $phpEx);

+ $selected = request_var('select_captcha', $config['captcha_plugin']);

+ $configure = request_var('configure', false);

+ // Oh, they are just here for the view

+ if (isset($_GET['captcha_demo']))

+ {

+ $this->deliver_demo($selected);

+ // Delegate

+ if ($configure)

+ {

+ $config_captcha =& phpbb_captcha_factory::get_instance($selected);

+ $config_captcha->acp_page($id, $this);

+ add_log('admin', 'LOG_CONFIG_VISUAL');

+ }

+ else

+ {

+ $captchas = phpbb_captcha_factory::get_captcha_types();

+ $config_vars = array(

+ 'enable_confirm' => array('tpl' => 'REG_ENABLE', 'default' => false),

+ 'enable_post_confirm' => array('tpl' => 'POST_ENABLE', 'default' => false),

+ 'confirm_refresh' => array('tpl' => 'CONFIRM_REFRESH', 'default' => false),

+ 'max_reg_attempts' => array('tpl' => 'REG_LIMIT', 'default' => 0),

+ );

+ $this->tpl_name = 'acp_captcha';

+ $this->page_title = 'ACP_VC_SETTINGS';

+ $form_key = 'acp_captcha';

+ add_form_key($form_key);

+ $submit = request_var('main_submit', false);

+ if ($submit && check_form_key($form_key))

+ foreach ($config_vars as $config_var => $options)

+ {

+ set_config($config_var, request_var($config_var, $options['default']));

+ }

+ if ($selected !== $config['captcha_plugin'])

+ // sanity check

+ if (isset($captchas['available'][$selected]))

+ {

+ $old_captcha =& phpbb_captcha_factory::get_instance($config['captcha_plugin']);

+ $old_captcha->uninstall();

+

+ set_config('captcha_plugin', $selected);

+ $new_captcha =& phpbb_captcha_factory::get_instance($config['captcha_plugin']);

+ $new_captcha->install();

+

+ add_log('admin', 'LOG_CONFIG_VISUAL');

+ }

+ else

+ {

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

+ }

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

+ else if ($submit)

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

+ else

+ $captcha_select = '';

+ foreach ($captchas['available'] as $value => $title)

+ {

+ $current = ($selected !== false && $value == $selected) ? ' selected="selected"' : '';

+ $captcha_select .= '<option value="' . $value . '"' . $current . '>' . $user->lang[$title] . '</option>';

+ }

+ foreach ($captchas['unavailable'] as $value => $title)

+ {

+ $current = ($selected !== false && $value == $selected) ? ' selected="selected"' : '';

+ $captcha_select .= '<option value="' . $value . '"' . $current . ' class="disabled-option">' . $user->lang[$title] . '</option>';

+ }

+

+ $demo_captcha =& phpbb_captcha_factory::get_instance($selected);

+

+ foreach ($config_vars as $config_var => $options)

+ {

+ $template->assign_var($options['tpl'], (isset($_POST[$config_var])) ? request_var($config_var, $options['default']) : $config[$config_var]) ;

+ }

+ $template->assign_vars(array(

+ 'CAPTCHA_PREVIEW_TPL' => $demo_captcha->get_demo_template($id),

+ 'S_CAPTCHA_HAS_CONFIG' => $demo_captcha->has_config(),

+ 'CAPTCHA_SELECT' => $captcha_select,

+ ));

+ }

+

+ /**

+ * Entry point for delivering image CAPTCHAs in the ACP.

+ */

+ function deliver_demo($selected)

+ {

+ global $db, $user, $config;

+

+ $captcha =& phpbb_captcha_factory::get_instance($selected);

+ $captcha->init(CONFIRM_REG);

+ $captcha->execute_demo();

+

+ garbage_collection();

+ exit_handler();

+ }

+ trigger_error('FILE_WRITE_FAIL', E_USER_ERROR);

+ $def_row = $db->sql_fetchrow($def_res);

+ $db->sql_freeresult($def_res);

+ if (empty($def_row))

+ $row['rowdefault'] = $def_row['rowdefault'];

+ // Oracle uses uppercase - we use lowercase

+ $str_val = $row[strtolower($ary_name[$i])];

+ $schema_fields[$i] = '"' . $ary_name[$i] . '"';

+ case 'copy_perm':

+

+ if (!(($auth->acl_get('a_fauth') && $auth->acl_get('a_authusers') && $auth->acl_get('a_authgroups') && $auth->acl_get('a_mauth'))))

+ {

+ trigger_error($user->lang['NO_PERMISSION_COPY'] . adm_back_link($this->u_action . '&amp;parent_id=' . $this->parent_id), E_USER_WARNING);

+ }

+

+ 'forum_options' => 0,

+ 'enable_quick_reply' => request_var('enable_quick_reply', false),

+ $cache->destroy('sql', FORUMS_TABLE);

+ copy_forum_permissions($forum_perm_from, $forum_data['forum_id'], ($action == 'edit') ? true : false);

+ else if (($action != 'edit') && $auth->acl_get('a_fauth') && $auth->acl_get('a_authusers') && $auth->acl_get('a_authgroups') && $auth->acl_get('a_mauth'))

+ {

+ $this->copy_permission_page($forum_data);

+ return;

+ }

+ $forum_data['forum_flags'] += (request_var('enable_quick_reply', false)) ? FORUM_FLAG_QUICK_REPLY : 0;

+ 'forum_options' => 0,

+ 'S_ENABLE_QUICK_REPLY' => ($forum_data['forum_flags'] & FORUM_FLAG_QUICK_REPLY) ? true : false,

+

+ case 'copy_perm':

+ $forum_perm_from = request_var('forum_perm_from', 0);

+

+ // Copy permissions?

+ if (!empty($forum_perm_from) && $forum_perm_from != $forum_id)

+ {

+ copy_forum_permissions($forum_perm_from, $forum_id, true);

+ cache_moderators();

+ $auth->acl_clear_prefetch();

+ $cache->destroy('sql', FORUMS_TABLE);

+

+ $acl_url = '&amp;mode=setting_forum_local&amp;forum_id[]=' . $forum_id;

+

+ $message = $user->lang['FORUM_UPDATED'];

+

+ // Redirect to permissions

+ if ($auth->acl_get('a_fauth'))

+ {

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

+ }

+

+ trigger_error($message . adm_back_link($this->u_action . '&amp;parent_id=' . $this->parent_id));

+ }

+

+ break;

+ $forum_data['forum_flags'] += ($forum_data['enable_quick_reply']) ? FORUM_FLAG_QUICK_REPLY : 0;

+ unset($forum_data_sql['enable_quick_reply']);

+

+ /**

+ * Display copy permission page

+ */

+ function copy_permission_page($forum_data)

+ {

+ global $phpEx, $phpbb_admin_path, $template, $user;

+

+ $acl_url = '&amp;mode=setting_forum_local&amp;forum_id[]=' . $forum_data['forum_id'];

+ $action = append_sid($this->u_action . "&amp;parent_id={$this->parent_id}&amp;f={$forum_data['forum_id']}&amp;action=copy_perm");

+

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

+

+ $this->tpl_name = 'acp_forums_copy_perm';

+

+ $template->assign_vars(array(

+ 'U_ACL' => append_sid("{$phpbb_admin_path}index.$phpEx", 'i=permissions' . $acl_url),

+ 'L_ACL_LINK' => $l_acl,

+ 'L_BACK_LINK' => adm_back_link($this->u_action . '&amp;parent_id=' . $this->parent_id),

+ 'S_COPY_ACTION' => $action,

+ 'S_FORUM_OPTIONS' => make_forum_select($forum_data['parent_id'], $forum_data['forum_id'], false, false, false),

+ ));

+ }

+

+ 'skip_auth' => request_var('group_skip_auth', 0),

+ $test_variables = array(

+ 'rank' => 'int',

+ 'colour' => 'string',

+ 'avatar' => 'string',

+ 'avatar_type' => 'int',

+ 'avatar_width' => 'int',

+ 'avatar_height' => 'int',

+ 'receive_pm' => 'int',

+ 'legend' => 'int',

+ 'message_limit' => 'int',

+ 'max_recipients'=> 'int',

+ 'founder_manage'=> 'int',

+ 'skip_auth' => 'int',

+ );

+

+ foreach ($test_variables as $test => $type)

+ settype($submit_ary[$test], $type);

+ 'GROUP_SKIP_AUTH' => (!empty($group_row['group_skip_auth'])) ? ' checked="checked"' : '',

+ ));

+ $sql = 'SELECT u.user_id, u.username, u.username_clean, u.user_regdate, u.user_colour, u.user_posts, u.group_id, ug.group_leader, ug.user_pending

+ 'USERNAME_COLOUR' => $row['user_colour'],

+ 'USER_ID' => $row['user_id'],

+ ));

+ $sql = 'SELECT u.user_id, u.username, u.username_clean, u.user_colour, u.user_regdate, u.user_posts, u.group_id, ug.group_leader, ug.user_pending

+ 'USERNAME_COLOUR' => $row['user_colour'],

+ ));

+ // adjust the width and height to be lower than 128px while perserving the aspect ratio

+ if ($img_size[0] > 127 && $img_size[0] > $img_size[1])

+ {

+ $img_size[1] = (int) ($img_size[1] * (127 / $img_size[0]));

+ $img_size[0] = 127;

+ }

+ else if ($img_size[1] > 127)

+ {

+ $img_size[0] = (int) ($img_size[0] * (127 / $img_size[1]));

+ $img_size[1] = 127;

+ }

+

+

+

+

+ $colspan = (($mode == 'smilies') ? 7 : 5);

+

+

+

+

+

+

+ if ($mode == 'smilies' && $action == 'create')

+ {

+ $smiley_count = $this->item_count($table);

+

+ $addable_smileys_count = sizeof($images);

+ foreach ($images as $image)

+ {

+ if (!isset($image_add[$image]))

+ {

+ --$addable_smileys_count;

+ }

+ }

+

+ if ($smiley_count + $addable_smileys_count > SMILEY_LIMIT)

+ {

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

+ }

+ }

+

+ if ($image_width[$image] > 127 && $image_width[$image] > $image_height[$image])

+ {

+ $image_height[$image] = (int) ($image_height[$image] * (127 / $image_width[$image]));

+ $image_width[$image] = 127;

+ }

+ else if ($image_height[$image] > 127)

+ {

+ $image_width[$image] = (int) ($image_width[$image] * (127 / $image_height[$image]));

+ $image_height[$image] = 127;

+ }

+

+

+

+

+

+

+ if ($mode == 'smilies')

+ {

+ $smiley_count = $this->item_count($table);

+ if ($smiley_count + sizeof($pak_ary) > SMILEY_LIMIT)

+ {

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

+ }

+ }

+

+ $pagination_start = request_var('start', 0);

+

+ $item_count = $this->item_count($table);

+ $result = $db->sql_query_limit($sql, $config['smilies_per_page'], $pagination_start);

+ 'U_MOVE_UP' => $this->u_action . '&amp;action=move_up&amp;id=' . $row[$fields . '_id'] . '&amp;start=' . $pagination_start,

+ 'U_MOVE_DOWN' => $this->u_action . '&amp;action=move_down&amp;id=' . $row[$fields . '_id'] . '&amp;start=' . $pagination_start,

+ ));

+

+ $template->assign_var('PAGINATION',

+ generate_pagination($this->u_action, $item_count, $config['smilies_per_page'], $pagination_start, true)

+ );

+ }

+

+ /**

+ * Returns the count of smilies or icons in the database

+ *

+ * @param string $table The table of items to count.

+ * @return int number of items

+ */

+ /* private */ function item_count($table)

+ {

+ global $db;

+

+ $sql = "SELECT COUNT(*) AS count

+ FROM $table";

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

+ $item_count = (int) $db->sql_fetchfield('count');

+ $db->sql_freeresult($result);

+ return $item_count;

+ // We build the sort key and per page settings here, because they may be needed later

+

+ // Number of entries to display

+ $per_page = request_var('users_per_page', (int) $config['topics_per_page']);

+

+ // Sorting

+ $limit_days = array(0 => $user->lang['ALL_ENTRIES'], 1 => $user->lang['1_DAY'], 7 => $user->lang['7_DAYS'], 14 => $user->lang['2_WEEKS'], 30 => $user->lang['1_MONTH'], 90 => $user->lang['3_MONTHS'], 180 => $user->lang['6_MONTHS'], 365 => $user->lang['1_YEAR']);

+ $sort_by_text = array('i' => $user->lang['SORT_INACTIVE'], 'j' => $user->lang['SORT_REG_DATE'], 'l' => $user->lang['SORT_LAST_VISIT'], 'd' => $user->lang['SORT_LAST_REMINDER'], 'r' => $user->lang['SORT_REASON'], 'u' => $user->lang['SORT_USERNAME'], 'p' => $user->lang['SORT_POSTS'], 'e' => $user->lang['SORT_REMINDER']);

+ $sort_by_sql = array('i' => 'user_inactive_time', 'j' => 'user_regdate', 'l' => 'user_lastvisit', 'd' => 'user_reminded_time', 'r' => 'user_inactive_reason', 'u' => 'username_clean', 'p' => 'user_posts', 'e' => 'user_reminded');

+

+ $s_limit_days = $s_sort_key = $s_sort_dir = $u_sort_param = '';

+ gen_sort_selects($limit_days, $sort_by_text, $sort_days, $sort_key, $sort_dir, $s_limit_days, $s_sort_key, $s_sort_dir, $u_sort_param);

+

+

+ $messenger = new messenger(false);

+

+ // For activate we really need to redirect, else a refresh can result in users being deactivated again

+ $u_action = $this->u_action . "&amp;$u_sort_param&amp;start=$start";

+ $u_action .= ($per_page != $config['topics_per_page']) ? "&amp;users_per_page=$per_page" : '';

+

+ redirect($u_action);

+ $usernames = $user_ids = array();

+ $user_ids[] = (int) $row['user_id'];

+ // Add the remind state to the database

+ $sql = 'UPDATE ' . USERS_TABLE . '

+ SET user_reminded = user_reminded + 1,

+ user_reminded_time = ' . time() . '

+ WHERE ' . $db->sql_in_set('user_id', $user_ids);

+ $db->sql_query($sql);

+

+

+ // For remind we really need to redirect, else a refresh can result in more than one reminder

+ $u_action = $this->u_action . "&amp;$u_sort_param&amp;start=$start";

+ $u_action .= ($per_page != $config['topics_per_page']) ? "&amp;users_per_page=$per_page" : '';

+

+ redirect($u_action);

+

+ $start = view_inactive_users($inactive, $inactive_count, $per_page, $start, $sql_where, $sql_sort);

+ 'REMINDED_DATE' => $user->format_date($row['user_reminded_time']),

+

+ 'POSTS' => ($row['user_posts']) ? $row['user_posts'] : 0,

+ 'REMINDED' => $row['user_reminded'],

+

+ 'REMINDED_EXPLAIN' => $user->lang('USER_LAST_REMINDED', (int) $row['user_reminded'], $user->format_date($row['user_reminded_time'])),

+

+ 'USERNAME_FULL' => get_username_string('full', $row['user_id'], $row['username'], $row['user_colour'], false, append_sid("{$phpbb_admin_path}index.$phpEx", 'i=users&amp;mode=overview')),

+ 'USERNAME' => get_username_string('username', $row['user_id'], $row['username'], $row['user_colour']),

+ 'USER_COLOR' => get_username_string('colour', $row['user_id'], $row['username'], $row['user_colour']),

+

+ 'U_USER_ADMIN' => append_sid("{$phpbb_admin_path}index.$phpEx", "i=users&amp;mode=overview&amp;u={$row['user_id']}"),

+ 'U_SEARCH_USER' => ($auth->acl_get('u_search')) ? append_sid("{$phpbb_root_path}search.$phpEx", "author_id={$row['user_id']}&amp;sr=posts") : '',

+ ));

+ 'S_ON_PAGE' => on_page($inactive_count, $per_page, $start),

+ 'PAGINATION' => generate_pagination($this->u_action . "&amp;$u_sort_param&amp;users_per_page=$per_page", $inactive_count, $per_page, $start, true),

+ 'USERS_PER_PAGE' => $per_page,

+

+ if (confirm_box(true))

+ {

+ $db->sql_query('DELETE FROM ' . LANG_TABLE . ' WHERE lang_id = ' . $lang_id);

+ $sql = 'UPDATE ' . USERS_TABLE . "

+ SET user_lang = '" . $db->sql_escape($config['default_lang']) . "'

+ WHERE user_lang = '" . $db->sql_escape($row['lang_iso']) . "'";

+ $db->sql_query($sql);

+ // We also need to remove the translated entries for custom profile fields - we want clean tables, don't we?

+ $sql = 'DELETE FROM ' . PROFILE_LANG_TABLE . ' WHERE lang_id = ' . $lang_id;

+ $db->sql_query($sql);

+ $sql = 'DELETE FROM ' . PROFILE_FIELDS_LANG_TABLE . ' WHERE lang_id = ' . $lang_id;

+ $db->sql_query($sql);

+ $sql = 'DELETE FROM ' . STYLES_IMAGESET_DATA_TABLE . " WHERE image_lang = '" . $db->sql_escape($row['lang_iso']) . "'";

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

+ $cache->destroy('sql', STYLES_IMAGESET_DATA_TABLE);

+ add_log('admin', 'LOG_LANGUAGE_PACK_DELETED', $row['lang_english_name']);

+ trigger_error(sprintf($user->lang['LANGUAGE_PACK_DELETED'], $row['lang_english_name']) . adm_back_link($this->u_action));

+ }

+ else

+ {

+ $s_hidden_fields = array(

+ 'i' => $id,

+ 'mode' => $mode,

+ 'action' => $action,

+ 'id' => $lang_id,

+ );

+ confirm_box(false, $user->lang['CONFIRM_OPERATION'], build_hidden_fields($s_hidden_fields));

+ }

+ $value = utf8_normalize_nfc(array_shift($keys));

+ $topic_id = request_var('t', 0);

+ $keywords = utf8_normalize_nfc(request_var('keywords', '', true));

+ $keywords_param = !empty($keywords) ? '&amp;keywords=' . urlencode(htmlspecialchars_decode($keywords)) : '';

+

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

+ 'PAGINATION' => generate_pagination($this->u_action . "&amp;$u_sort_param$keywords_param", $log_count, $config['topics_per_page'], $start, true),

+ 'S_KEYWORDS' => $keywords,

+ case 'purge_sessions':

+ $confirm = true;

+ $confirm_lang = 'PURGE_SESSIONS_CONFIRM';

+ break;

+

+ case 'purge_sessions':

+ if ((int) $user->data['user_type'] !== USER_FOUNDER)

+ {

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

+ }

+

+ $tables = array(CONFIRM_TABLE, SESSIONS_TABLE);

+

+ foreach ($tables as $table)

+ {

+ switch ($db->sql_layer)

+ {

+ case 'sqlite':

+ case 'firebird':

+ $db->sql_query("DELETE FROM $table");

+ break;

+

+ default:

+ $db->sql_query("TRUNCATE TABLE $table");

+ break;

+ }

+ }

+

+ // let's restore the admin session

+ $reinsert_ary = array(

+ 'session_id' => (string) $user->session_id,

+ 'session_page' => (string) substr($user->page['page'], 0, 199),

+ 'session_forum_id' => $user->page['forum'],

+ 'session_user_id' => (int) $user->data['user_id'],

+ 'session_start' => (int) $user->data['session_start'],

+ 'session_last_visit' => (int) $user->data['session_last_visit'],

+ 'session_time' => (int) $user->time_now,

+ 'session_browser' => (string) trim(substr($user->browser, 0, 149)),

+ 'session_forwarded_for' => (string) $user->forwarded_for,

+ 'session_ip' => (string) $user->ip,

+ 'session_autologin' => (int) $user->data['session_autologin'],

+ 'session_admin' => 1,

+ 'session_viewonline' => (int) $user->data['session_viewonline'],

+ );

+

+ $sql = 'INSERT INTO ' . SESSIONS_TABLE . ' ' . $db->sql_build_array('INSERT', $reinsert_ary);

+ $db->sql_query($sql);

+

+ add_log('admin', 'LOG_PURGE_SESSIONS');

+ break;

+ // Version check

+ $user->add_lang('install');

+

+ $latest_version_info = false;

+ if (($latest_version_info = obtain_latest_version_info(request_var('versioncheck_force', false))) === false)

+ {

+ $template->assign_var('S_VERSIONCHECK_FAIL', true);

+ }

+ else

+ {

+ $latest_version_info = explode("\n", $latest_version_info);

+

+ $latest_version = str_replace('rc', 'RC', strtolower(trim($latest_version_info[0])));

+ $current_version = str_replace('rc', 'RC', strtolower($config['version']));

+

+ $template->assign_vars(array(

+ 'S_VERSION_UP_TO_DATE' => version_compare($current_version, $latest_version, '<') ? false : true,

+ ));

+ }

+

+ 'GZIP_COMPRESSION' => ($config['gzip_compress'] && @extension_loaded('zlib')) ? $user->lang['ON'] : $user->lang['OFF'],

+ 'U_VERSIONCHECK' => append_sid("{$phpbb_admin_path}index.$phpEx", 'i=update&amp;mode=version_check'),

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

+ $user->add_lang('memberlist');

+

+ 'REMINDED_DATE' => $user->format_date($row['user_reminded_time']),

+

+ 'POSTS' => ($row['user_posts']) ? $row['user_posts'] : 0,

+ 'REMINDED' => $row['user_reminded'],

+

+ 'REMINDED_EXPLAIN' => $user->lang('USER_LAST_REMINDED', (int) $row['user_reminded'], $user->format_date($row['user_reminded_time'])),

+

+ 'USERNAME_FULL' => get_username_string('full', $row['user_id'], $row['username'], $row['user_colour'], false, append_sid("{$phpbb_admin_path}index.$phpEx", 'i=users&amp;mode=overview')),

+ 'USERNAME' => get_username_string('username', $row['user_id'], $row['username'], $row['user_colour']),

+ 'USER_COLOR' => get_username_string('colour', $row['user_id'], $row['username'], $row['user_colour']),

+

+ 'U_USER_ADMIN' => append_sid("{$phpbb_admin_path}index.$phpEx", "i=users&amp;mode=overview&amp;u={$row['user_id']}"),

+ 'U_SEARCH_USER' => ($auth->acl_get('u_search')) ? append_sid("{$phpbb_root_path}search.$phpEx", "author_id={$row['user_id']}&amp;sr=posts") : '',

+ ));

+ if (file_exists($phpbb_root_path . 'install') && !is_file($phpbb_root_path . 'install'))

+ if (!defined('PHPBB_DISABLE_CONFIG_CHECK') && file_exists($phpbb_root_path . 'config.' . $phpEx) && phpbb_is_writable($phpbb_root_path . 'config.' . $phpEx))

+ // Copy forum permissions

+ if ($mode == 'setting_forum_copy')

+ {

+ $this->tpl_name = 'permission_forum_copy';

+

+ if ($auth->acl_get('a_fauth') && $auth->acl_get('a_authusers') && $auth->acl_get('a_authgroups') && $auth->acl_get('a_mauth'))

+ {

+ $this->page_title = 'ACP_FORUM_PERMISSIONS_COPY';

+ $this->copy_forum_permissions();

+ return;

+ }

+

+ trigger_error('NO_MODE', E_USER_ERROR);

+ }

+

+ if (confirm_box(true))

+ // All users/groups selected?

+ $all_users = (isset($_POST['all_users'])) ? true : false;

+ $all_groups = (isset($_POST['all_groups'])) ? true : false;

+ if ($all_users || $all_groups)

+ {

+ $items = $this->retrieve_defined_user_groups($permission_scope, $forum_id, $permission_type);

+

+ if ($all_users && sizeof($items['user_ids']))

+ {

+ $user_id = $items['user_ids'];

+ }

+ else if ($all_groups && sizeof($items['group_ids']))

+ {

+ $group_id = $items['group_ids'];

+ }

+ }

+ if (sizeof($user_id) || sizeof($group_id))

+ $this->remove_permissions($mode, $permission_type, $auth_admin, $user_id, $group_id, $forum_id);

+ else

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

+ if (isset($_POST['cancel']))

+ {

+ $u_redirect = $this->u_action . '&amp;type=' . $permission_type;

+ foreach ($forum_id as $fid)

+ {

+ $u_redirect .= '&amp;forum_id[]=' . $fid;

+ }

+ redirect($u_redirect);

+ }

+

+ $s_hidden_fields = array(

+ 'i' => $id,

+ 'mode' => $mode,

+ 'action' => array($action => 1),

+ 'user_id' => $user_id,

+ 'group_id' => $group_id,

+ 'forum_id' => $forum_id,

+ 'type' => $permission_type,

+ );

+ if (isset($_POST['all_users']))

+ {

+ $s_hidden_fields['all_users'] = 1;

+ }

+ if (isset($_POST['all_groups']))

+ {

+ $s_hidden_fields['all_groups'] = 1;

+ }

+ confirm_box(false, $user->lang['CONFIRM_OPERATION'], build_hidden_fields($s_hidden_fields));

+ AND NOT (ug.group_leader = 1 AND g.group_skip_auth = 1)

+ * Handles copying permissions from one forum to others

+ */

+ function copy_forum_permissions()

+ {

+ global $auth, $cache, $template, $user;

+

+ $user->add_lang('acp/forums');

+

+ $submit = isset($_POST['submit']) ? true : false;

+

+ if ($submit)

+ {

+ $src = request_var('src_forum_id', 0);

+ $dest = request_var('dest_forum_ids', array(0));

+

+ if (confirm_box(true))

+ {

+ if (copy_forum_permissions($src, $dest))

+ {

+ cache_moderators();

+

+ $auth->acl_clear_prefetch();

+ $cache->destroy('sql', FORUMS_TABLE);

+

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

+ }

+ else

+ {

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

+ }

+ }

+ else

+ {

+ $s_hidden_fields = array(

+ 'submit' => $submit,

+ 'src_forum_id' => $src,

+ 'dest_forum_ids' => $dest,

+ );

+

+ $s_hidden_fields = build_hidden_fields($s_hidden_fields);

+

+ confirm_box(false, $user->lang['COPY_PERMISSIONS_CONFIRM'], $s_hidden_fields);

+ }

+ }

+

+ $template->assign_vars(array(

+ 'S_FORUM_OPTIONS' => make_forum_select(false, false, false, false, false),

+ ));

+ }

+

+ /**

+ 'field_show_on_vt' => 0,

+ 1 => array('field_ident', 'lang_name', 'lang_explain', 'field_option_none', 'field_show_on_reg', 'field_show_on_vt', 'field_required', 'field_hide', 'field_show_profile', 'field_no_view'),

+ 'field_show_on_vt',

+ 'S_SHOW_ON_VT' => ($cp->vars['field_show_on_vt']) ? true : false,

+ 'field_show_on_vt' => $cp->vars['field_show_on_vt'],

+ // First handle pruning of users who never logged in, last active date is 0000-00-00

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

+ $form_name = 'acp_ranks';

+ if ($ranks && $img == $ranks['rank_image'])

+ $selected = ' selected="selected"';

+ $edit_img = $img;

+ else

+ {

+ $selected = '';

+ }

+

+ if (strlen($img) > 255)

+ {

+ continue;

+ }

+

+ $filename_list .= '<option value="' . htmlspecialchars($img) . '"' . $selected . '>' . $img . ((in_array($img, $existing_imgs)) ? ' ' . $user->lang['RANK_IMAGE_IN_USE'] : '') . '</option>';

+<?php

+/**

+*

+* @package acp

+* @version $Id$

+* @copyright (c) 2005 phpBB Group

+* @license http://opensource.org/licenses/gpl-license.php GNU Public License

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+include($phpbb_root_path . 'includes/questionnaire/questionnaire.' . $phpEx);

+

+/**

+* @package acp

+*/

+class acp_send_statistics

+{

+ var $u_action;

+

+ function main($id, $mode)

+ {

+ global $config, $template, $phpbb_admin_path, $phpEx;

+

+ $collect_url = "http://www.phpbb.com/stats/receive_stats.php";

+

+ $this->tpl_name = 'acp_send_statistics';

+ $this->page_title = 'ACP_SEND_STATISTICS';

+

+ // generate a unique id if necessary

+ if (!isset($config['questionnaire_unique_id']))

+ {

+ $install_id = unique_id();

+ set_config('questionnaire_unique_id', $install_id);

+ }

+ else

+ {

+ $install_id = $config['questionnaire_unique_id'];

+ }

+

+ $collector = new phpbb_questionnaire_data_collector($install_id);

+

+ // Add data provider

+ $collector->add_data_provider(new phpbb_questionnaire_php_data_provider());

+ $collector->add_data_provider(new phpbb_questionnaire_system_data_provider());

+ $collector->add_data_provider(new phpbb_questionnaire_phpbb_data_provider($config));

+

+ $template->assign_vars(array(

+ 'U_COLLECT_STATS' => $collect_url,

+ 'RAW_DATA' => $collector->get_data_for_form(),

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

+ ));

+

+ $raw = $collector->get_data_raw();

+

+ foreach ($raw as $provider => $data)

+ {

+ if ($provider == 'install_id')

+ {

+ $data = array($provider => $data);

+ }

+

+ $template->assign_block_vars('providers', array(

+ 'NAME' => htmlspecialchars($provider),

+ ));

+

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

+ {

+ if (is_array($value))

+ {

+ $value = utf8_wordwrap(serialize($value), 75, "\n", true);

+ }

+

+ $template->assign_block_vars('providers.values', array(

+ 'KEY' => utf8_htmlspecialchars($key),

+ 'VALUE' => utf8_htmlspecialchars($value),

+ ));

+ }

+ }

+ }

+}

+

+?> \ No newline at end of file

+ if (($action == 'deactivate' && confirm_box(true)) || $action == 'activate')

+ $sql = 'UPDATE ' . STYLES_TABLE . '

+ SET style_active = ' . (($action == 'activate') ? 1 : 0) . '

+ WHERE style_id = ' . $style_id;

+ // Set style to default for any member using deactivated style

+ if ($action == 'deactivate')

+ {

+ $sql = 'UPDATE ' . USERS_TABLE . '

+ SET user_style = ' . $config['default_style'] . "

+ WHERE user_style = $style_id";

+ $db->sql_query($sql);

+

+ $sql = 'UPDATE ' . FORUMS_TABLE . '

+ SET forum_style = 0

+ WHERE forum_style = ' . $style_id;

+ $db->sql_query($sql);

+ }

+ }

+ else if ($action == 'deactivate')

+ {

+ $s_hidden_fields = array(

+ 'i' => $id,

+ 'mode' => $mode,

+ 'action' => $action,

+ 'style_id' => $style_id,

+ );

+ confirm_box(false, $user->lang['CONFIRM_OPERATION'], build_hidden_fields($s_hidden_fields));

+ // File exists and is writeable, but still not able to be written to

+ trigger_error(sprintf($user->lang['TEMPLATE_FILE_NOT_WRITABLE'], htmlspecialchars($template_file)) . adm_back_link($this->u_action), E_USER_WARNING);

+ if (empty($filelist['']))

+ {

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

+ }

+

+ $file = str_replace('/', '.', $file);

+ $tpl_file = str_replace('.', '/', $file);

+ $tpl_file = str_replace('///', '../', $tpl_file);

+ // Correct the filename if it is stored in database and the file is in a subfolder.

+ if ($template_row['template_storedb'])

+ {

+ $file = str_replace('.', '/', $file);

+ }

+ 'FILESIZE' => get_formatted_filesize(filesize("{$phpbb_root_path}cache/$filename")),

+

+ $filesize = filesize("{$phpbb_root_path}styles/$template_path$pathfile$file");

+

+ if ($filesize)

+ {

+ $template_data = fread($fp, $filesize);

+ }

+

+ if (!$filesize)

+ {

+ // File is empty

+ continue;

+ }

+

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

+ 'U_VERSIONCHECK_FORCE' => append_sid($this->u_action . '&amp;versioncheck_force=1'),

+ if ($user_row['user_type'] == USER_INACTIVE)

+ {

+ if ($config['require_activation'] == USER_ACTIVATION_ADMIN)

+ {

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

+

+ $messenger = new messenger(false);

+

+ $messenger->template('admin_welcome_activated', $user_row['user_lang']);

+

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

+

+ $messenger->headers('X-AntiAbuse: Board servername - ' . $config['server_name']);

+ $messenger->headers('X-AntiAbuse: User_id - ' . $user->data['user_id']);

+ $messenger->headers('X-AntiAbuse: Username - ' . $user->data['username']);

+ $messenger->headers('X-AntiAbuse: User IP - ' . $user->ip);

+

+ $messenger->assign_vars(array(

+ 'USERNAME' => htmlspecialchars_decode($user_row['username']))

+ );

+

+ $messenger->send(NOTIFY_EMAIL);

+ }

+ }

+

+ case 'deloutbox':

+

+ if (confirm_box(true))

+ {

+ $msg_ids = array();

+ $lang = 'EMPTY';

+

+ $sql = 'SELECT msg_id

+ FROM ' . PRIVMSGS_TO_TABLE . "

+ WHERE author_id = $user_id

+ AND folder_id = " . PRIVMSGS_OUTBOX;

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

+

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

+ {

+ if (!function_exists('delete_pm'))

+ {

+ include($phpbb_root_path . 'includes/functions_privmsgs.' . $phpEx);

+ }

+

+ do

+ {

+ $msg_ids[] = (int) $row['msg_id'];

+ }

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

+

+ $db->sql_freeresult($result);

+

+ delete_pm($user_id, $msg_ids, PRIVMSGS_OUTBOX);

+

+ add_log('admin', 'LOG_USER_DEL_OUTBOX', $user_row['username']);

+

+ $lang = 'EMPTIED';

+ }

+ $db->sql_freeresult($result);

+

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

+ }

+ else

+ {

+ confirm_box(false, $user->lang['CONFIRM_OPERATION'], build_hidden_fields(array(

+ 'u' => $user_id,

+ 'i' => $id,

+ 'mode' => $mode,

+ 'action' => $action,

+ 'update' => true))

+ );

+ }

+ break;

+

+

+ case 'leave_nr':

+

+ if (confirm_box(true))

+ {

+ remove_newly_registered($user_id, $user_row);

+

+ add_log('admin', 'LOG_USER_REMOVED_NR', $user_row['username']);

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

+ }

+ else

+ {

+ confirm_box(false, $user->lang['CONFIRM_OPERATION'], build_hidden_fields(array(

+ 'u' => $user_id,

+ 'i' => $id,

+ 'mode' => $mode,

+ 'action' => $action,

+ 'update' => true))

+ );

+ }

+

+ break;

+ 'user_email_hash' => phpbb_email_hash($update_email),

+ $quick_tool_ary = array('delsig' => 'DEL_SIG', 'delavatar' => 'DEL_AVATAR', 'moveposts' => 'MOVE_POSTS', 'delposts' => 'DEL_POSTS', 'delattach' => 'DEL_ATTACH', 'deloutbox' => 'DEL_OUTBOX');

+ if ($user_row['user_new'])

+ {

+ $quick_tool_ary['leave_nr'] = 'LEAVE_NR';

+ }

+ $quick_tool_ary += array('delsig' => 'DEL_SIG', 'delavatar' => 'DEL_AVATAR', 'moveposts' => 'MOVE_POSTS', 'delposts' => 'DEL_POSTS', 'delattach' => 'DEL_ATTACH', 'deloutbox' => 'DEL_OUTBOX');

+

+ if ($user_row['user_new'])

+ {

+ $quick_tool_ary['leave_nr'] = 'LEAVE_NR';

+ }

+ case 'warnings':

+ $user->add_lang('mcp');

+

+ // Set up general vars

+ $start = request_var('start', 0);

+ $deletemark = (isset($_POST['delmarked'])) ? true : false;

+ $deleteall = (isset($_POST['delall'])) ? true : false;

+ $confirm = (isset($_POST['confirm'])) ? true : false;

+ $marked = request_var('mark', array(0));

+ $message = utf8_normalize_nfc(request_var('message', '', true));

+

+ // Sort keys

+ $sort_days = request_var('st', 0);

+ $sort_key = request_var('sk', 't');

+ $sort_dir = request_var('sd', 'd');

+

+ // Delete entries if requested and able

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

+ {

+ if (confirm_box(true))

+ {

+ $where_sql = '';

+ $deletemark = request_var('delmarked', 0);

+ $deleteall = request_var('delall', 0);

+ if ($deletemark && $marked)

+ {

+ $sql_in = array();

+ foreach ($marked as $mark)

+ {

+ $sql_in[] = $mark;

+ }

+ $where_sql = ' AND ' . $db->sql_in_set('warning_id', $sql_in);

+ unset($sql_in);

+ }

+

+ if ($where_sql || $deleteall)

+ {

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

+ WHERE user_id = $user_id

+ $where_sql";

+ $db->sql_query($sql);

+

+ if ($deleteall)

+ {

+ $log_warnings = $deleted_warnings = 0;

+ }

+ else

+ {

+ $num_warnings = (int) $db->sql_affectedrows();

+ $deleted_warnings = ' user_warnings - ' . $num_warnings;

+ $log_warnings = ($num_warnings > 2) ? 2 : $num_warnings;

+ }

+

+ $sql = 'UPDATE ' . USERS_TABLE . "

+ SET user_warnings = $deleted_warnings

+ WHERE user_id = $user_id";

+ $db->sql_query($sql);

+

+ switch ($log_warnings)

+ {

+ case 2:

+ add_log('admin', 'LOG_WARNINGS_DELETED', $user_row['username'], $num_warnings);

+ break;

+ case 1:

+ add_log('admin', 'LOG_WARNING_DELETED', $user_row['username']);

+ break;

+ default:

+ add_log('admin', 'LOG_WARNINGS_DELETED_ALL', $user_row['username']);

+ break;

+ }

+ }

+ }

+ else

+ {

+ $s_hidden_fields = array(

+ 'i' => $id,

+ 'mode' => $mode,

+ 'u' => $user_id,

+ 'mark' => $marked,

+ );

+ if (isset($_POST['delmarked']))

+ {

+ $s_hidden_fields['delmarked'] = 1;

+ }

+ if (isset($_POST['delall']))

+ {

+ $s_hidden_fields['delall'] = 1;

+ }

+ if (isset($_POST['delall']) || (isset($_POST['delmarked']) && sizeof($marked)))

+ {

+ confirm_box(false, $user->lang['CONFIRM_OPERATION'], build_hidden_fields($s_hidden_fields));

+ }

+ }

+ }

+

+ $sql = 'SELECT w.warning_id, w.warning_time, w.post_id, l.log_operation, l.log_data, l.user_id AS mod_user_id, m.username AS mod_username, m.user_colour AS mod_user_colour

+ FROM ' . WARNINGS_TABLE . ' w

+ LEFT JOIN ' . LOG_TABLE . ' l

+ ON (w.log_id = l.log_id)

+ LEFT JOIN ' . USERS_TABLE . ' m

+ ON (l.user_id = m.user_id)

+ WHERE w.user_id = ' . $user_id . '

+ ORDER BY w.warning_time DESC';

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

+

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

+ {

+ if (!$row['log_operation'])

+ {

+ // We do not have a log-entry anymore, so there is no data available

+ $row['action'] = $user->lang['USER_WARNING_LOG_DELETED'];

+ }

+ else

+ {

+ $row['action'] = (isset($user->lang[$row['log_operation']])) ? $user->lang[$row['log_operation']] : '{' . ucfirst(str_replace('_', ' ', $row['log_operation'])) . '}';

+ if (!empty($row['log_data']))

+ {

+ $log_data_ary = @unserialize($row['log_data']);

+ $log_data_ary = ($log_data_ary === false) ? array() : $log_data_ary;

+

+ if (isset($user->lang[$row['log_operation']]))

+ {

+ // Check if there are more occurrences of % than arguments, if there are we fill out the arguments array

+ // It doesn't matter if we add more arguments than placeholders

+ if ((substr_count($row['action'], '%') - sizeof($log_data_ary)) > 0)

+ {

+ $log_data_ary = array_merge($log_data_ary, array_fill(0, substr_count($row['action'], '%') - sizeof($log_data_ary), ''));

+ }

+ $row['action'] = vsprintf($row['action'], $log_data_ary);

+ $row['action'] = bbcode_nl2br(censor_text($row['action']));

+ }

+ else if (!empty($log_data_ary))

+ {

+ $row['action'] .= '<br />' . implode('', $log_data_ary);

+ }

+ }

+ }

+

+

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

+ 'ACTION' => make_clickable($row['action']),

+ 'DATE' => $user->format_date($row['warning_time']),

+ ));

+ }

+ $db->sql_freeresult($result);

+

+ $template->assign_vars(array(

+ 'S_WARNINGS' => true,

+ 'S_CLEARLOGS' => $auth->acl_get('a_clearlogs'),

+ ));

+

+ break;

+

+ $cp->update_profile_field_data($user_id, $cp_data);

+ if (!$config['allow_avatar'] && $user_row['user_avatar_type'])

+ {

+ $error[] = $user->lang['USER_AVATAR_NOT_ALLOWED'];

+ }

+ else if ((($user_row['user_avatar_type'] == AVATAR_UPLOAD) && !$config['allow_avatar_upload']) ||

+ (($user_row['user_avatar_type'] == AVATAR_REMOTE) && !$config['allow_avatar_remote']) ||

+ (($user_row['user_avatar_type'] == AVATAR_GALLERY) && !$config['allow_avatar_local']))

+ {

+ $error[] = $user->lang['USER_AVATAR_TYPE_NOT_ALLOWED'];

+ }

+

+ $avatar_img = ($user_row['user_avatar']) ? get_user_avatar($user_row['user_avatar'], $user_row['user_avatar_type'], $user_row['user_avatar_width'], $user_row['user_avatar_height'], 'USER_AVATAR', true) : '<img src="' . $phpbb_admin_path . 'images/no_avatar.gif" alt="" />';

+ 'S_UPLOAD_FILE' => ($config['allow_avatar'] && $can_upload && $config['allow_avatar_upload']) ? true : false,

+ 'S_REMOTE_UPLOAD' => ($config['allow_avatar'] && $can_upload && $config['allow_avatar_remote_upload']) ? true : false,

+ 'S_ALLOW_REMOTE' => ($config['allow_avatar'] && $config['allow_avatar_remote']) ? true : false,

+ 'S_DISPLAY_GALLERY' => ($config['allow_avatar'] && $config['allow_avatar_local'] && !$display_gallery) ? true : false,

+ 'S_IN_GALLERY' => ($config['allow_avatar'] && $config['allow_avatar_local'] && $display_gallery) ? true : false,

+ $enable_bbcode = ($config['allow_sig_bbcode']) ? (bool) $this->optionget($user_row, 'sig_bbcode') : false;

+ $enable_smilies = ($config['allow_sig_smilies']) ? (bool) $this->optionget($user_row, 'sig_smilies') : false;

+ $enable_urls = ($config['allow_sig_links']) ? (bool) $this->optionget($user_row, 'sig_links') : false;

+ $enable_bbcode = ($config['allow_sig_bbcode']) ? ((request_var('disable_bbcode', false)) ? false : true) : false;

+ $enable_smilies = ($config['allow_sig_smilies']) ? ((request_var('disable_smilies', false)) ? false : true) : false;

+ $enable_urls = ($config['allow_sig_links']) ? ((request_var('disable_magic_url', false)) ? false : true) : false;

+

+ $this->optionset($user_row, 'sig_bbcode', $enable_bbcode);

+ $this->optionset($user_row, 'sig_smilies', $enable_smilies);

+ $this->optionset($user_row, 'sig_links', $enable_urls);

+

+ 'user_options' => $user_row['user_options'],

+

+ case 'approve':

+

+ if (confirm_box(true))

+ {

+ if (!$group_id)

+ {

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

+ }

+ group_user_attributes($action, $group_id, $user_id);

+ }

+ else

+ {

+ confirm_box(false, $user->lang['CONFIRM_OPERATION'], build_hidden_fields(array(

+ 'u' => $user_id,

+ 'i' => $id,

+ 'mode' => $mode,

+ 'action' => $action,

+ 'g' => $group_id))

+ );

+ }

+

+ break;

+ 'U_APPROVE' => ($group_type == 'pending') ? $this->u_action . "&amp;action=approve&amp;u=$user_id&amp;g=" . $data['group_id'] : '',

+ 'S_IS_MEMBER' => ($group_type != 'pending') ? true : false,

+

+

+

+

+

+

+ if ($word === '' || $replacement === '')

+ 'feed' => array('title' => 'ACP_FEED_SETTINGS', 'auth' => 'acl_a_board', 'cat' => array('ACP_BOARD_CONFIGURATION')),

+ 'setting_forum_copy' => array('title' => 'ACP_FORUM_PERMISSIONS_COPY', 'auth' => 'acl_a_fauth && acl_a_authusers && acl_a_authgroups && acl_a_mauth', 'cat' => array('ACP_FORUM_BASED_PERMISSIONS')),

+<?php

+/**

+*

+* @package acp

+* @version $Id$

+* @copyright (c) 2005 phpBB Group

+* @license http://opensource.org/licenses/gpl-license.php GNU Public License

+*

+*/

+

+/**

+* @package module_install

+*/

+class acp_send_statistics_info

+{

+ function module()

+ {

+ return array(

+ 'filename' => 'acp_send_statistics',

+ 'title' => 'ACP_SEND_STATISTICS',

+ 'version' => '1.0.0',

+ 'modes' => array(

+ 'send_statistics' => array('title' => 'ACP_SEND_STATISTICS', 'auth' => 'acl_a_server', 'cat' => array('ACP_SERVER_CONFIGURATION')),

+ ),

+ );

+ }

+

+ function install()

+ {

+ }

+

+ function uninstall()

+ {

+ }

+}

+

+?> \ No newline at end of file

+ 'warnings' => array('title' => 'ACP_USER_WARNINGS', 'auth' => 'acl_a_user', 'display' => false, 'cat' => array('ACP_CAT_USERS')),