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

}

add_log('admin', 'LOG_INACTIVE_' . strtoupper($action), implode(', ', $user_affected));

if (confirm_box(true))

{

$user_ids = $usernames = array();

if (sizeof($user_ids))

{

if ($action == 'deactivate')

{

if ($deleteposts)

{

$l_log = 'LOG_PRUNE_USER_DEL_DEL';

}

else

{

$l_log = 'LOG_PRUNE_USER_DEL_ANON';

}

{

$template->assign_block_vars('users', array(

'USERNAME' => $usernames[$user_id],

'U_PROFILE' => append_sid($phpbb_root_path . 'memberlist.' . $phpEx, 'mode=viewprofile&u=' . $user_id),

'U_USER_ADMIN' => ($auth->acl_get('a_user')) ? append_sid("{$phpbb_admin_path}index.$phpEx", 'i=users&mode=overview&u=' . $user_id, true, $user->session_id) : '',

));

'mode' => $mode,

'prune' => 1,

'deleteposts' => request_var('deleteposts', 0),

'action' => request_var('action', ''),

)), 'confirm_body_prune.html');

}

}

$find_time = array('lt' => $user->lang['BEFORE'], 'gt' => $user->lang['AFTER']);

$s_find_active_time = '';

foreach ($find_time as $key => $value)

{

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

}

$template->assign_vars(array(

'U_ACTION' => $this->u_action,

'S_ACTIVE_OPTIONS' => $s_find_active_time,

'S_COUNT_OPTIONS' => $s_find_count,

'U_FIND_USERNAME' => append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=searchuser&amp;form=acp_prune&amp;field=users'),

));

{

global $user, $db;

{

$where_sql = ' AND ' . $db->sql_in_set('username_clean', array_map('utf8_clean_string', $users));

}

else

{

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

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

$count_select = request_var('count_select', 'eq');

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

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

{

}

$key_match = array('lt' => '<', 'gt' => '>', 'eq' => '=');

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

$where_sql = '';

$where_sql .= ($username) ? ' AND username_clean ' . $db->sql_like_expression(str_replace('*', $db->any_char, utf8_clean_string($username))) : '';

$where_sql .= ($email) ? ' AND user_email ' . $db->sql_like_expression(str_replace('*', $db->any_char, $email)) . ' ' : '';

// 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";

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

$user_ids = $usernames = array();

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

}

}

$db->sql_freeresult($result);

}

}

case RULE_IS_LIKE:

$result = preg_match("/" . preg_quote($rule_row['rule_string'], '/') . '/i', $check0);

break;

case RULE_IS_NOT_LIKE:

$result = !preg_match("/" . preg_quote($rule_row['rule_string'], '/') . '/i', $check0);

break;

case RULE_IS:

$result = ($check0 == $rule_row['rule_string']);

break;

case RULE_IS_NOT:

$result = ($check0 != $rule_row['rule_string']);

break;

case RULE_BEGINS_WITH:

$result = preg_match("/^" . preg_quote($rule_row['rule_string'], '/') . '/i', $check0);

break;

case RULE_ENDS_WITH:

$result = preg_match("/" . preg_quote($rule_row['rule_string'], '/') . '$/i', $check0);

break;

case RULE_IS_FRIEND:

case RULE_IS_FOE:

case RULE_ANSWERED:

case RULE_FORWARDED:

$result = ($check0 == 1);

break;

case RULE_IS_USER:

$result = ($check0 == $rule_row['rule_user_id']);

break;

case RULE_IS_GROUP:

$result = in_array($rule_row['rule_group_id'], $check0);

break;

case RULE_TO_GROUP:

$result = (in_array('g_' . $message_row[$check_ary['check2']], $check0) || in_array('g_' . $message_row[$check_ary['check2']], $message_row[$check_ary['check1']]));

break;

case RULE_TO_ME:

$result = (in_array('u_' . $user_id, $check0) || in_array('u_' . $user_id, $message_row[$check_ary['check1']]));

break;

return false;

}

// Get PM Information for later deleting

// The two queries where split, so we can use our indexes

$undelivered_msg = $delete_ids = array();

// Part 1: get PMs the user received

$sql = 'SELECT msg_id

FROM ' . PRIVMSGS_TO_TABLE . '

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

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

}

$db->sql_freeresult($result);

// whether another user already received and read the message.

$sql = 'SELECT msg_id

FROM ' . PRIVMSGS_TO_TABLE . '

AND folder_id = ' . PRIVMSGS_NO_BOX;

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

// received them.

$sql = 'SELECT msg_id

FROM ' . PRIVMSGS_TO_TABLE . '

AND folder_id <> ' . PRIVMSGS_NO_BOX . '

AND folder_id <> ' . PRIVMSGS_OUTBOX . '

AND folder_id <> ' . PRIVMSGS_SENTBOX;

// Count the messages we delete, so we can correct the user pm data

$sql = 'SELECT user_id, COUNT(msg_id) as num_undelivered_privmsgs

FROM ' . PRIVMSGS_TO_TABLE . '

AND folder_id = ' . PRIVMSGS_NO_BOX . '

AND ' . $db->sql_in_set('msg_id', array_merge($undelivered_msg, $delivered_msg)) . '

GROUP BY user_id';

$sql = 'UPDATE ' . USERS_TABLE . '

SET user_new_privmsg = 0,

user_unread_privmsg = 0

$db->sql_query($sql);

// Delete private message data of the user

$sql = 'DELETE FROM ' . PRIVMSGS_TO_TABLE . '

$db->sql_query($sql);

if (!empty($delete_ids))

// This way users are still able to read messages from users being removed

$sql = 'UPDATE ' . PRIVMSGS_TO_TABLE . '

SET author_id = ' . ANONYMOUS . '

$db->sql_query($sql);

$sql = 'UPDATE ' . PRIVMSGS_TABLE . '

SET author_id = ' . ANONYMOUS . '

$db->sql_query($sql);

$db->sql_transaction('commit');

/**

* Remove User

*/

{

global $cache, $config, $db, $user, $auth, $phpbb_dispatcher;

global $phpbb_root_path, $phpEx;

$sql = 'SELECT *

FROM ' . USERS_TABLE . '

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

$db->sql_freeresult($result);

{

return false;

}

// Before we begin, we will remove the reports the user issued.

$sql = 'SELECT r.post_id, p.topic_id

FROM ' . REPORTS_TABLE . ' r, ' . POSTS_TABLE . ' p

AND p.post_id = r.post_id';

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

}

// Remove reports

{

}

}

$table_ary = array(USERS_TABLE, USER_GROUP_TABLE, TOPICS_WATCH_TABLE, FORUMS_WATCH_TABLE, ACL_USERS_TABLE, TOPICS_TRACK_TABLE, TOPICS_POSTED_TABLE, FORUMS_TRACK_TABLE, PROFILE_FIELDS_DATA_TABLE, MODERATOR_CACHE_TABLE, DRAFTS_TABLE, BOOKMARKS_TABLE, SESSIONS_KEYS_TABLE, PRIVMSGS_FOLDER_TABLE, PRIVMSGS_RULES_TABLE);

foreach ($table_ary as $table)

{

$sql = "DELETE FROM $table

$db->sql_query($sql);

}

// Delete user log entries about this user

$sql = 'DELETE FROM ' . LOG_TABLE . '

$db->sql_query($sql);

// Change user_id to anonymous for this users triggered events

$sql = 'UPDATE ' . LOG_TABLE . '

SET user_id = ' . ANONYMOUS . '

$db->sql_query($sql);

// Delete the user_id from the zebra table

$sql = 'DELETE FROM ' . ZEBRA_TABLE . '

$db->sql_query($sql);

// Delete the user_id from the banlist

$sql = 'DELETE FROM ' . BANLIST_TABLE . '

$db->sql_query($sql);

// Delete the user_id from the session table

$sql = 'DELETE FROM ' . SESSIONS_TABLE . '

$db->sql_query($sql);

// Clean the private messages tables from the user

{

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

}

$db->sql_transaction('commit');

extract($phpbb_dispatcher->trigger_event('core.delete_user_after', compact($vars)));

// Reset newest user info if appropriate

{

update_last_username();

}

return false;

}