+ global $request;

+ $ip_exclude = (int) $request->variable('ipexclude', false, false, phpbb_request_interface::POST);

+ $utf8_pcre_properties = pcre_utf8_support();

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

+ // We validate the complete config if wished

+ $col_types = sqlite_fetch_column_types($db->db_connect_id, $table_name);

+ global $request;

+ if ($request->variable('add_additional_code', false, false, phpbb_request_interface::POST))

+ if ($request->variable('add_display_on_posting', false, false, phpbb_request_interface::POST))

+ user_delete('retain', $mark, true);

+ global $request;

+ $request->overwrite('language_file', array_shift(array_keys($missing_file)));

+ // detect language file type

+ if ($this->language_directory == 'email')

+ {

+ $language_file_type = 'email';

+ $request_default = '';

+ }

+ else if (strpos($this->language_file, 'help_') === 0)

+ {

+ $language_file_type = 'help';

+ $request_default = array(0 => array(0 => ''));

+ }

+ else

+ {

+ $language_file_type = 'normal';

+ $request_default = array('' => '');

+ }

+

+ 'DEFAULT' => $request->variable($data, (string) $default),

+ $hidden_data .= build_hidden_fields(array('entry' => $request->variable('entry', $request_default, true, phpbb_request_interface::POST)));

+ $entry_value = $request->variable('entry', $request_default, true, phpbb_request_interface::POST);

+ if (!$lang_id || !$entry_value)

+ if ($language_file_type == 'email')

+ $entry = $this->prepare_lang_entry(htmlspecialchars_decode($entry_value), false);

+ if ($language_file_type == 'help')

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

+ $entry .= "\t\t" . (int) $_key . "\t=> '" . $this->prepare_lang_entry(htmlspecialchars_decode($_value)) . "',\n";

+ else if ($language_file_type == 'normal')

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

+ $entry = $this->format_lang_array(htmlspecialchars_decode($key), htmlspecialchars_decode($value));

+ global $request;

+ $deletemark = $request->variable('delmarked', false, false, phpbb_request_interface::POST);

+ $deleteall = $request->variable('delall', false, false, phpbb_request_interface::POST);

+ global $request;

+ $settings = $request->variable('setting', array(0 => array(0 => array('' => 0))), false, phpbb_request_interface::POST);

+ if (empty($settings) || empty($settings[$ug_id]) || empty($settings[$ug_id][$forum_id]))

+ $auth_settings = $settings[$ug_id][$forum_id];

+ $roles = $request->variable('role', array(0 => array(0 => 0)), false, phpbb_request_interface::POST);

+ $assigned_role = (isset($roles[$ug_id][$forum_id])) ? (int) $roles[$ug_id][$forum_id] : 0;

+ global $request;

+ $auth_settings = $request->variable('setting', array(0 => array(0 => array('' => 0))), false, phpbb_request_interface::POST);

+ $auth_roles = $request->variable('role', array(0 => array(0 => 0)), false, phpbb_request_interface::POST);

+ global $request;

+ $var = 'now';

+ $request->overwrite('field_default_value', $var, phpbb_request_interface::POST);

+ $var = sprintf('%2d-%2d-%4d', $cp->vars['field_default_value_day'], $cp->vars['field_default_value_month'], $cp->vars['field_default_value_year']);

+ $request->overwrite('field_default_value', $var, phpbb_request_interface::POST);

+ $_new_key_ary[$key] = ($field_type == FIELD_BOOL && $key == 'lang_options') ? utf8_normalize_nfc(request_var($key, array(''), true)) : utf8_normalize_nfc(request_var($key, '', true));

+

+ user_delete('remove', $user_ids);

+ user_delete('retain', $user_ids, true);

+ 'USER_ID' => $user_id,

+ 'users' => request_var('users', '', true),

+ 'username' => request_var('username', '', true),

+ $s_group_list = '<option value="0" selected="selected">' . $user->lang['SELECT_OPTION'] . '</option>';

+ $sql = 'SELECT group_id, group_name FROM ' . GROUPS_TABLE . '

+ WHERE group_type <> ' . GROUP_SPECIAL . '

+ ORDER BY group_name ASC';

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

+

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

+ {

+ $s_group_list .= '<option value="' . $row['group_id'] . '">' . $row['group_name'] . '</select>';

+ }

+

+ 'S_GROUP_LIST' => $s_group_list,

+ $users_by_name = request_var('users', '', true);

+ $users_by_id = request_var('user_ids', array(0));

+

+ if ($users_by_name)

+ $users = explode("\n", $users_by_name);

+ else if (!empty($users_by_id))

+ {

+ $user_ids = $users_by_id;

+ user_get_id_name($user_ids, $usernames);

+

+ $where_sql = ' AND ' . $db->sql_in_set('user_id', $user_ids);

+ }

+ $username = request_var('username', '', true);

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

+ $queue_select = request_var('queue_select', 'gt');

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

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

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

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

+

+ $joined_before = ($joined_before) ? explode('-', $joined_before) : array();

+ $joined_after = ($joined_after) ? explode('-', $joined_after) : array();

+ // calculate the conditions required by the join time criteria

+ $joined_sql = '';

+ if (!empty($joined_before) && !empty($joined_after))

+ // if the two entered dates are equal, we need to adjust

+ // so that our time range is a full day instead of 1 second

+ if ($joined_after == $joined_before)

+ {

+ $joined_after[2] += 1; //$joined_after[2]++;

+ }

+

+ $joined_sql = ' AND user_regdate BETWEEN ' . gmmktime(0, 0, 0, (int) $joined_after[1], (int) $joined_after[2], (int) $joined_after[0]) . ' AND ' . gmmktime(0, 0, 0, (int) $joined_before[1], (int) $joined_before[2], (int) $joined_before[0]);

+ else if (empty($joined_before) && !empty($joined_after))

+ {

+ $joined_sql = ' AND user_regdate > ' . gmmktime(0, 0, 0, (int) $joined_after[1], (int) $joined_after[2], (int) $joined_after[0]);

+ }

+ else if (empty($joined_after) && !empty($joined_before))

+ {

+ $joined_sql = ' AND user_regdate < ' . gmmktime(0, 0, 0, (int) $joined_before[1], (int) $joined_before[2], (int) $joined_before[3]);

+ }

+ // implicit else when both arrays are empty do nothing

+ if ((sizeof($active) && sizeof($active) != 3) || (sizeof($joined_before) && sizeof($joined_before) != 3) || (sizeof($joined_after) && sizeof($joined_after) != 3))

+ {

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

+ }

+ $where_sql .= ($website) ? ' AND user_website ' . $db->sql_like_expression(str_replace('*', $db->any_char, $website)) . ' ' : '';

+ $where_sql .= $joined_sql;

+ $where_sql .= ($count) ? " AND user_posts " . $key_match[$count_select] . ' ' . (int) $count . ' ' : '';

+

+ if ($group_id)

+ {

+ $sql = 'SELECT user_id FROM ' . USER_GROUP_TABLE . '

+ WHERE group_id = ' . (int) $group_id . '

+ AND user_pending = 0

+ AND ' . $db->sql_in_set('user_id', $user_ids, false, true);

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

+

+ // we're performing an intersection operation, so all the relevant users

+ // come from this most recent query (which was limited to the results of the

+ // previous query)

+ $user_ids = $usernames = array();

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

+ {

+ $user_ids[] = $row['poster_id'];

+ }

+

+ // only get usernames if they are needed (not part of some later query)

+ if (!$posts_on_queue)

+ {

+ // this is an additional query aginst the users table

+ user_get_id_name($user_ids, $usernames);

+ }

+ }

+

+ if ($posts_on_queue)

+ {

+ $sql = 'SELECT poster_id, COUNT(post_id) AS queue_posts FROM ' . POSTS_TABLE . '

+ WHERE ' . $db->sql_in_set('poster_id', $user_ids, false, true) .

+ ' GROUP BY poster_id

+ HAVING queue_posts ' . $key_match[$queue_select] . ' ' . $posts_on_queue;

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

+

+ // same intersection logic as the above group ID portion

+ $user_ids = $usernames = array();

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

+ {

+ $user_ids[] = $row['poster_id'];

+ }

+

+ // do an additional query to get the correct set of usernames

+ user_get_id_name($user_ids, $usernames);

+ }

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

+ $user_ip = phpbb_ip_normalise(request_var('user_ip', ''));

+ $error = array_map(array($user, 'lang'), $error);

+ $error = array_map(array($user, 'lang'), $error);

+ $error = array_map(array($user, 'lang'), $error);

+ $error = array_map(array($user, 'lang'), $error);

+ $error = array_map(array($user, 'lang'), $error);