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

$error = array();

$group_id = request_var('g', 0);

$subject = request_var('subject', '', true);

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

{

$sql = 'SELECT username, user_email, user_jabber, user_notify_type, user_lang

FROM ' . USERS_TABLE . '

AND user_allow_massemail = 1

ORDER BY user_lang, user_notify_type'; // , SUBSTRING(user_email FROM INSTR(user_email, '@'))

}

$action = (isset($_POST['add'])) ? 'add' : ((isset($_POST['addusers'])) ? 'addusers' : request_var('action', ''));

$group_id = request_var('g', 0);

$mark_ary = request_var('mark', array(0));

$leader = request_var('leader', 0);

$default = request_var('default', 0);

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

$subforum_id = request_var('subforum_id', 0);

$forum_id = request_var('forum_id', array(0));

$user_id = request_var('user_id', array(0));

$group_id = request_var('group_id', array(0));

{

if (confirm_box(true))

{

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

$deleteposts = request_var('deleteposts', 0);

if ($users)

{

}

else

{

$email = request_var('email', '');

$joined_select = request_var('joined_select', 'lt');

$sort_by_types = array('username', 'user_email', 'user_posts', 'user_regdate', 'user_lastvisit');

$where_sql = '';

$where_sql .= ($email) ? " AND user_email LIKE '" . $db->sql_escape(str_replace('*', '%', $email)) . "' " : '';

$where_sql .= (sizeof($joined)) ? " AND user_regdate " . $key_match[$joined_select] . ' ' . gmmktime(0, 0, 0, (int) $joined[1], (int) $joined[2], (int) $joined[0]) : '';

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

$db->sql_freeresult($result);

// Do not prune founder members

WHERE user_id <> ' . ANONYMOUS . '

AND user_type <> ' . USER_FOUNDER . "

$where_sql";

'prune' => 1,

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

'email' => request_var('email', ''),

'joined_select' => request_var('joined_select', ''),

'joined' => request_var('joined', ''),

include($phpbb_root_path . 'includes/functions_profile_fields.' . $phpEx);

$error = array();

$user_id = request_var('u', 0);

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

{

$sql = 'SELECT user_id

FROM ' . USERS_TABLE . "

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

$user_id = (int) $db->sql_fetchfield('user_id');

$db->sql_freeresult($result);

if ($update_username !== false)

{

$sql_ary['username'] = $update_username;

add_log('user', $user_id, 'LOG_USER_UPDATE_NAME', $user_row['username'], $update_username);

}

SET topic_last_poster_id = ' . ANONYMOUS . ", topic_last_poster_name = '" . $db->sql_escape($post_username) . "', topic_last_poster_colour = ''

WHERE topic_last_poster_id = $user_id";

$db->sql_query($sql);

break;

case 'remove':

global $template, $db, $user, $auth;

$user_id = request_var('u', 0);

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

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

$sk = request_var('sk', 'b');

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

$sql = 'SELECT *

FROM ' . USERS_TABLE . "

if ($action == 'chgposter')

{

}

else

{

global $template, $db, $user, $auth;

$user_id = request_var('u', 0);

$notify = (isset($_REQUEST['notify_user'])) ? true : false;

$warning = request_var('warning', '', true);

$sql = 'SELECT *

FROM ' . USERS_TABLE . '

$user->add_lang(array('acp/groups', 'acp/common'));

if (!$group_id)

{

$user_id_ary = array();

// Build usernames to add

if ($username_list)

{

$usernames = array_merge($usernames, explode("\n", $username_list));

{

$sql_ary = array(

'username' => ($auth->acl_get('u_chgname') && $config['allow_namechange']) ? $username : $user->data['username'],

'user_email' => ($auth->acl_get('u_chgemail')) ? $email : $user->data['user_email'],

'user_email_hash' => ($auth->acl_get('u_chgemail')) ? crc32(strtolower($email)) . strlen($email) : $user->data['user_email_hash'],

'user_password' => ($auth->acl_get('u_chgpasswd') && $new_password) ? md5($new_password) : $user->data['user_password'],

global $config, $phpbb_root_path, $phpEx;

global $db, $user, $auth, $template;

$email = request_var('email', '');

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

global $config, $phpbb_root_path, $phpEx;

global $db, $user, $auth, $template;

$email = request_var('email', '');

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

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

$forum_id = request_var('f', 0);

$user_id = request_var('u', 0);

if ($post_id)

{

$mode = request_var('mode', '');

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

$user_id = request_var('u', ANONYMOUS);

$group_id = request_var('g', 0);

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

if ($mode == 'searchuser' && ($config['load_search'] || $auth->acl_get('a_')))

{

$email = request_var('email', '');

$icq = request_var('icq', '');

$aim = request_var('aim', '');

$s_find_active_time .= '<option value="' . $key . '"' . $selected . '>' . $value . '</option>';

}

$sql_where .= ($email) ? " AND u.user_email LIKE '" . str_replace('*', '%', $db->sql_escape($email)) . "' " : '';

$sql_where .= ($icq) ? " AND u.user_icq LIKE '" . str_replace('*', '%', $db->sql_escape($icq)) . "' " : '';

$sql_where .= ($aim) ? " AND u.user_aim LIKE '" . str_replace('*', '%', $db->sql_escape($aim)) . "' " : '';

$post_data['post_subject'] = request_var('subject', '', true);

$message_parser->message = request_var('message', '', true);

$post_data['post_edit_reason'] = (!empty($_POST['edit_reason']) && $mode == 'edit' && $auth->acl_get('m_edit', $forum_id)) ? request_var('edit_reason', '', true) : '';

$post_data['topic_type'] = request_var('topic_type', (($mode != 'post') ? (int) $post_data['topic_type'] : POST_NORMAL));

if ($poll_delete && $mode == 'edit' && sizeof($post_data['poll_options']) &&

((!$post_data['poll_last_vote'] && $post_data['poster_id'] == $user->data['user_id'] && $auth->acl_get('f_delete', $forum_id)) || $auth->acl_get('m_delete', $forum_id)))

{

$post_data['poll_title'] = $post_data['poll_option_text'] = '';

$post_data['poll_vote_change'] = $post_data['poll_max_options'] = $post_data['poll_length'] = 0;

$preview_subject = censor_text($post_data['post_subject']);

// Poll Preview

&& $auth->acl_get('f_poll', $forum_id))

{

$parse_poll = new parse_message($post_data['poll_title']);

'S_SHOW_POLL_BOX' => true,

'S_POLL_VOTE_CHANGE' => ($auth->acl_get('f_votechg', $forum_id)),

'S_POLL_DELETE' => ($mode == 'edit' && sizeof($post_data['poll_options']) && ((!$post_data['poll_last_vote'] && $post_data['poster_id'] == $user->data['user_id'] && $auth->acl_get('f_delete', $forum_id)) || $auth->acl_get('m_delete', $forum_id))),

'L_POLL_OPTIONS_EXPLAIN' => sprintf($user->lang['POLL_OPTIONS_EXPLAIN'], $config['max_poll_options']),

<td class="row2"><input class="post" type="text" name="poll_max_options" size="3" maxlength="3" value="{POLL_MAX_OPTIONS}" /></td>

</tr>

<tr>

<td class="row2"><input class="post" type="text" name="poll_length" size="3" maxlength="3" value="{POLL_LENGTH}" />&nbsp;<b class="gen">{L_DAYS}</b> <span class="gensmall">{L_POLL_FOR_EXPLAIN}</span></td>

</tr>

<!-- IF S_POLL_VOTE_CHANGE -->

<!-- IF S_POLL_DELETE -->

<tr>

</tr>

<!-- ENDIF -->

$topic_last_read = (isset($topic_tracking_info[$topic_id])) ? $topic_tracking_info[$topic_id] : 0;

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

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

$db->sql_freeresult($result);

if (!$row)

{

// Setup user environment so we can process lang string

$user->setup('viewtopic');

}

$post_id = $row['post_id'];