*/

function user_get_id_name(&$user_id_ary, &$username_ary, $user_type = false)

{

// Are both arrays already filled? Yep, return else

// are neither array filled?

if ($user_id_ary && $username_ary)

$sql_where = ($which_ary == 'user_id_ary') ? 'user_id' : 'username_clean';

$sql = 'SELECT user_id, username

FROM ' . USERS_TABLE . '

if ($user_type !== false && !empty($user_type))

{

}

{

return 'NO_USERS';

}

$username_ary[$row['user_id']] = $row['username'];

$user_id_ary[] = $row['user_id'];

}

return false;

}

*/

function update_last_username()

{

// Get latest username

$sql = 'SELECT user_id, username, user_colour

FROM ' . USERS_TABLE . '

WHERE user_type IN (' . phpbb::USER_NORMAL . ', ' . phpbb::USER_FOUNDER . ')

ORDER BY user_id DESC';

if ($row)

{

*/

function user_update_name($old_name, $new_name)

{

$update_ary = array(

FORUMS_TABLE => array('forum_last_poster_name'),

MODERATOR_CACHE_TABLE => array('username'),

foreach ($field_ary as $field)

{

$sql = "UPDATE $table

}

}

*/

function user_add($user_row, $cp_data = false)

{

if (empty($user_row['username']) || !isset($user_row['group_id']) || !isset($user_row['user_email']) || !isset($user_row['user_type']))

{

return false;

'user_sig_bbcode_uid' => '',

'user_sig_bbcode_bitfield' => '',

);

// Now fill the sql array with not required variables

}

}

// Insert Custom Profile Fields

if ($cp_data !== false && sizeof($cp_data))

if (!class_exists('custom_profile'))

{

}

$sql = 'INSERT INTO ' . PROFILE_FIELDS_DATA_TABLE . ' ' .

}

// Place into appropriate group...

'user_id' => (int) $user_id,

'group_id' => (int) $user_row['group_id'],

'user_pending' => 0)

);

// Now make it the users default group...

group_set_user_default($user_row['group_id'], array($user_id), false);

$sql = 'SELECT group_colour

FROM ' . GROUPS_TABLE . '

WHERE group_id = ' . (int) $user_row['group_id'];

set_config('newest_user_colour', $row['group_colour'], true);

}

*/

function user_delete($mode, $user_id, $post_username = false)

{

$sql = 'SELECT *

FROM ' . USERS_TABLE . '

WHERE user_id = ' . $user_id;

if (!$user_row)

{

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

WHERE r.user_id = ' . $user_id . '

AND p.post_id = r.post_id';

$report_posts = $report_topics = array();

{

$report_posts[] = $row['post_id'];

$report_topics[] = $row['topic_id'];

}

if (sizeof($report_posts))

{

// Get a list of topics that still contain reported posts

$sql = 'SELECT DISTINCT topic_id

FROM ' . POSTS_TABLE . '

AND post_reported = 1

$keep_report_topics = array();

{

$keep_report_topics[] = $row['topic_id'];

}

if (sizeof($keep_report_topics))

{

// Now set the flags back

$sql = 'UPDATE ' . POSTS_TABLE . '

SET post_reported = 0

if (sizeof($report_topics))

{

$sql = 'UPDATE ' . TOPICS_TABLE . '

SET topic_reported = 0

}

}

// Remove reports

if ($user_row['user_avatar'] && $user_row['user_avatar_type'] == AVATAR_UPLOAD)

{

{

case 'retain':

if ($post_username === false)

{

else

{

$sql = 'UPDATE ' . FORUMS_TABLE . '

WHERE forum_last_poster_id = $user_id";

$sql = 'UPDATE ' . POSTS_TABLE . '

WHERE poster_id = $user_id";

$sql = 'UPDATE ' . POSTS_TABLE . '

SET post_edit_user = ' . ANONYMOUS . "

WHERE post_edit_user = $user_id";

$sql = 'UPDATE ' . TOPICS_TABLE . '

WHERE topic_poster = $user_id";

$sql = 'UPDATE ' . TOPICS_TABLE . '

WHERE topic_last_poster_id = $user_id";

// Since we change every post by this author, we need to count this amount towards the anonymous user

$sql = 'UPDATE ' . USERS_TABLE . '

SET user_posts = user_posts + ' . $user_row['user_posts'] . '

WHERE user_id = ' . ANONYMOUS;

}

}

break;

FROM ' . POSTS_TABLE . "

WHERE poster_id = $user_id

GROUP BY topic_id";

$topic_id_ary = array();

{

$topic_id_ary[$row['topic_id']] = $row['total_posts'];

}

if (sizeof($topic_id_ary))

{

$sql = 'SELECT topic_id, topic_replies, topic_replies_real

FROM ' . TOPICS_TABLE . '

$del_topic_ary = array();

{

if (max($row['topic_replies'], $row['topic_replies_real']) + 1 == $topic_id_ary[$row['topic_id']])

{

$del_topic_ary[] = $row['topic_id'];

}

}

if (sizeof($del_topic_ary))

{

$sql = 'DELETE FROM ' . TOPICS_TABLE . '

}

}

break;

}

$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);

{

$sql = "DELETE FROM $table

WHERE user_id = $user_id";

}

phpbb::$acm->destroy_sql(MODERATOR_CACHE_TABLE);

FROM ' . PRIVMSGS_TO_TABLE . '

WHERE author_id = ' . $user_id . '

AND folder_id = ' . PRIVMSGS_NO_BOX;

$undelivered_msg = $undelivered_user = array();

{

$undelivered_msg[] = $row['msg_id'];

$undelivered_user[$row['user_id']][] = true;

}

if (sizeof($undelivered_msg))

{

$sql = 'DELETE FROM ' . PRIVMSGS_TABLE . '

}

$sql = 'DELETE FROM ' . PRIVMSGS_TO_TABLE . '

WHERE author_id = ' . $user_id . '

AND folder_id = ' . PRIVMSGS_NO_BOX;

// Delete all to-information

$sql = 'DELETE FROM ' . PRIVMSGS_TO_TABLE . '

WHERE user_id = ' . $user_id;

// Set the remaining author id to anonymous - this way users are still able to read messages from users being removed

$sql = 'UPDATE ' . PRIVMSGS_TO_TABLE . '

SET author_id = ' . ANONYMOUS . '

WHERE author_id = ' . $user_id;

$sql = 'UPDATE ' . PRIVMSGS_TABLE . '

SET author_id = ' . ANONYMOUS . '

WHERE author_id = ' . $user_id;

foreach ($undelivered_user as $_user_id => $ary)

{

SET user_new_privmsg = user_new_privmsg - ' . sizeof($ary) . ',

user_unread_privmsg = user_unread_privmsg - ' . sizeof($ary) . '

WHERE user_id = ' . $_user_id;

}

// Reset newest user info if appropriate

if (phpbb::$config['newest_user_id'] == $user_id)

*/

function user_active_flip($mode, $user_id_ary, $reason = INACTIVE_MANUAL)

{

$deactivated = $activated = 0;

$sql_statements = array();

$sql = 'SELECT user_id, group_id, user_type, user_inactive_reason

FROM ' . USERS_TABLE . '

{

$sql_ary = array();

$sql_statements[$row['user_id']] = $sql_ary;

}

if (sizeof($sql_statements))

{

foreach ($sql_statements as $user_id => $sql_ary)

{

$sql = 'UPDATE ' . USERS_TABLE . '

WHERE user_id = ' . $user_id;

}

$auth->acl_clear_prefetch(array_keys($sql_statements));

*/

function user_ban($mode, $ban, $ban_len, $ban_len_other, $ban_exclude, $ban_reason, $ban_give_reason = '')

{

// Delete stale bans

$sql = 'DELETE FROM ' . BANLIST_TABLE . '

WHERE ban_end < ' . time() . '

AND ban_end <> 0';

$ban_list = (!is_array($ban)) ? array_unique(explode("\n", $ban)) : $ban;

$ban_list_log = implode(', ', $ban_list);

$sql = 'SELECT user_id, user_email, username_clean

FROM ' . USERS_TABLE . '

WHERE user_type = ' . phpbb::USER_FOUNDER;

{

$founder[$row['user_id']] = $row['user_email'];

$founder_names[$row['user_id']] = $row['username_clean'];

}

}

$banlist_ary = array();

$sql = 'SELECT user_id

FROM ' . USERS_TABLE . '

// Do not allow banning yourself

if (sizeof($founder))

{

}

else

{

$sql .= ' AND user_id <> ' . $user->data['user_id'];

}

{

do

{

$banlist_ary[] = (int) $row['user_id'];

}

}

else

{

trigger_error('NO_USERS');

}

break;

case 'ip':

FROM " . BANLIST_TABLE . "

WHERE $sql_where

AND ban_exclude = " . (int) $ban_exclude;

// Reset $sql_where, because we use it later...

$sql_where = '';

{

$banlist_ary_tmp = array();

do

break;

}

}

$banlist_ary = array_unique(array_diff($banlist_ary, $banlist_ary_tmp));

unset($banlist_ary_tmp);

}

// We have some entities to ban

if (sizeof($banlist_ary))

);

}

// If we are banning we want to logout anyone matching the ban

if (!$ban_exclude)

switch ($mode)

{

case 'user':

break;

case 'ip':

break;

case 'email':

$sql = 'SELECT user_id

FROM ' . USERS_TABLE . '

$sql_in = array();

{

do

{

$sql_in[] = $row['user_id'];

}

}

break;

}

{

$sql = 'DELETE FROM ' . SESSIONS_TABLE . "

$sql_where";

if ($mode == 'user')

{

}

}

}

*/

function user_unban($mode, $ban)

{

// Delete stale bans

$sql = 'DELETE FROM ' . BANLIST_TABLE . '

WHERE ban_end < ' . time() . '

AND ban_end <> 0';

if (!is_array($ban))

{

case 'user':

$sql = 'SELECT u.username AS unban_info

FROM ' . USERS_TABLE . ' u, ' . BANLIST_TABLE . ' b

AND u.user_id = b.ban_userid';

break;

case 'email':

$sql = 'SELECT ban_email AS unban_info

FROM ' . BANLIST_TABLE . '

break;

case 'ip':

$sql = 'SELECT ban_ip AS unban_info

FROM ' . BANLIST_TABLE . '

break;

}

$l_unban_list = '';

{

$l_unban_list .= (($l_unban_list != '') ? ', ' : '') . $row['unban_info'];

}

$sql = 'DELETE FROM ' . BANLIST_TABLE . '

// Add to moderator and admin log

add_log('admin', 'LOG_UNBAN_' . strtoupper($mode), $l_unban_list);

*/

function validate_username($username, $allowed_username = false)

{

$clean_username = utf8_clean_string($username);

$allowed_username = ($allowed_username === false) ? $user->data['username_clean'] : utf8_clean_string($allowed_username);

$sql = 'SELECT username

FROM ' . USERS_TABLE . "

if ($row)

{

$sql = 'SELECT group_name

FROM ' . GROUPS_TABLE . "

if ($row)

{

*/

function validate_password($password)

{

if (!$password)

{

*/

function validate_email($email, $allowed_email = false)

{

$email = strtolower($email);

$allowed_email = ($allowed_email === false) ? strtolower($user->data['user_email']) : strtolower($allowed_email);

$sql = 'SELECT user_email_hash

FROM ' . USERS_TABLE . "

WHERE user_email_hash = " . hexdec(crc32($email) . strlen($email));

if ($row)

{

*/

function avatar_delete($mode, $row, $clean_db = false)

{

// Check if the users avatar is actually *not* a group avatar

if ($mode == 'user')

*/

function avatar_remote($data, &$error)

{

if (!preg_match('#^(http|https|ftp)://#i', $data['remotelink']))

{

*/

function avatar_upload($data, &$error)

{

// Init upload class

include_once(PHPBB_ROOT_PATH . 'includes/functions_upload.' . PHP_EXT);

*/

function avatar_process_user(&$error, $custom_userdata = false)

{

$data = array(

'uploadurl' => request_var('uploadurl', ''),

}

$sql = 'UPDATE ' . USERS_TABLE . '

WHERE user_id = ' . (($custom_userdata === false) ? $user->data['user_id'] : $custom_userdata['user_id']);

}

}

*/

function group_create(&$group_id, $type, $name, $desc, $group_attributes, $allow_desc_bbcode = false, $allow_desc_urls = false, $allow_desc_smilies = false)

{

$error = array();

$attribute_ary = array(

$sql = 'SELECT user_id

FROM ' . USERS_TABLE . '

WHERE group_id = ' . $group_id;

{

$user_ary[] = $row['user_id'];

}

if (isset($sql_ary['group_avatar']) && !$sql_ary['group_avatar'])

{

}

$sql = 'UPDATE ' . GROUPS_TABLE . '

WHERE group_id = $group_id";

// Since we may update the name too, we need to do this on other tables too...

$sql = 'UPDATE ' . MODERATOR_CACHE_TABLE . "

WHERE group_id = $group_id";

}

else

{

}

if (!$group_id)

{

if (isset($sql_ary['group_avatar_type']) && $sql_ary['group_avatar_type'] == AVATAR_UPLOAD)

{

group_correct_avatar($group_id, $sql_ary['group_avatar']);

*/

function group_correct_avatar($group_id, $old_entry)

{

$group_id = (int)$group_id;

$ext = substr(strrchr($old_entry, '.'), 1);

$old_filename = get_avatar_filename($old_entry);

if (@rename($avatar_path . '/'. $old_filename, $avatar_path . '/' . $new_filename))

{

$sql = 'UPDATE ' . GROUPS_TABLE . '

WHERE group_id = $group_id";

}

}

*/

function avatar_remove_db($avatar_name)

{

$sql = 'UPDATE ' . USERS_TABLE . "

SET user_avatar = '',

user_avatar_type = 0

}

*/

function group_delete($group_id, $group_name = false)

{

if (!$group_name)

{

$group_name = get_group_name($group_id);

FROM ' . USER_GROUP_TABLE . ' ug, ' . USERS_TABLE . " u

WHERE ug.group_id = $group_id

AND u.user_id = ug.user_id";

{

do

{

$start++;

}

group_user_del($group_id, $user_id_ary, $username_ary, $group_name);

}

{

$start = 0;

}

}

while ($start);

// Delete group

$sql = 'DELETE FROM ' . GROUPS_TABLE . "

WHERE group_id = $group_id";

// Delete auth entries from the groups table

$sql = 'DELETE FROM ' . ACL_GROUPS_TABLE . "

WHERE group_id = $group_id";

// Re-cache moderators

if (!function_exists('cache_moderators'))

*/

function group_user_add($group_id, $user_id_ary = false, $username_ary = false, $group_name = false, $default = false, $leader = 0, $pending = 0, $group_attributes = false)

{

// We need both username and user_id info

$result = user_get_id_name($user_id_ary, $username_ary);

// Remove users who are already members of this group

$sql = 'SELECT user_id, group_leader

FROM ' . USER_GROUP_TABLE . '

AND group_id = $group_id";

$add_id_ary = $update_id_ary = array();

{

$add_id_ary[] = (int) $row['user_id'];

$update_id_ary[] = (int) $row['user_id'];

}

}

// Do all the users exist in this group?

$add_id_ary = array_diff($user_id_ary, $add_id_ary);

return 'GROUP_USERS_EXIST';

}

// Insert the new users

if (sizeof($add_id_ary))

);

}

}

if (sizeof($update_id_ary))

{

$sql = 'UPDATE ' . USER_GROUP_TABLE . '

SET group_leader = 1

AND group_id = $group_id";

}

if ($default)

group_set_user_default($group_id, $user_id_ary, $group_attributes);

}

// Clear permissions cache of relevant users

$auth->acl_clear_prefetch($user_id_ary);

*/

function group_user_del($group_id, $user_id_ary = false, $username_ary = false, $group_name = false)

{

$group_order = array('ADMINISTRATORS', 'GLOBAL_MODERATORS', 'REGISTERED_COPPA', 'REGISTERED', 'BOTS', 'GUESTS');

$sql = 'SELECT *

FROM ' . GROUPS_TABLE . '

$group_order_id = $special_group_data = array();

{

$group_order_id[$row['group_name']] = $row['group_id'];

);

}

}

// Get users default groups - we only need to reset default group membership if the group from which the user gets removed is set as default

$sql = 'SELECT user_id, group_id

FROM ' . USERS_TABLE . '

$default_groups = array();

{

$default_groups[$row['user_id']] = $row['group_id'];

}

// What special group memberships exist for these users?

$sql = 'SELECT g.group_id, g.group_name_clean, ug.user_id

FROM ' . USER_GROUP_TABLE . ' ug, ' . GROUPS_TABLE . ' g

AND g.group_id = ug.group_id

AND g.group_id <> $group_id

AND g.group_type = " . GROUP_SPECIAL . '

ORDER BY ug.user_id, g.group_id';

$temp_ary = array();

{

if ($default_groups[$row['user_id']] == $group_id && (!isset($temp_ary[$row['user_id']]) || array_search($row['group_name_clean'], $clean_group_order) < $temp_ary[$row['user_id']]))

{

$temp_ary[$row['user_id']] = $row['group_id'];

}

}

$sql_where_ary = array();

foreach ($temp_ary as $uid => $gid)

$sql = 'DELETE FROM ' . USER_GROUP_TABLE . "

WHERE group_id = $group_id

// Clear permissions cache of relevant users

$auth->acl_clear_prefetch($user_id_ary);

*/

function remove_default_avatar($group_id, $user_ids)

{

if (!is_array($user_ids))

{

$user_ids = array($user_ids);

$sql = 'SELECT *

FROM ' . GROUPS_TABLE . '

WHERE group_id = ' . (int)$group_id;

{

return false;

}

$sql = 'UPDATE ' . USERS_TABLE . "

SET user_avatar = '',

user_avatar_width = 0,

user_avatar_height = 0

WHERE group_id = " . (int) $group_id . "

}

/**

*/

function remove_default_rank($group_id, $user_ids)

{

if (!is_array($user_ids))

{

$user_ids = array($user_ids);

$sql = 'SELECT *

FROM ' . GROUPS_TABLE . '

WHERE group_id = ' . (int)$group_id;

{

return false;

}

$sql = 'UPDATE ' . USERS_TABLE . '

SET user_rank = 0

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

AND user_rank <> 0

AND user_rank = ' . (int)$row['group_rank'] . '

}

/**

*/

function group_user_attributes($action, $group_id, $user_id_ary = false, $username_ary = false, $group_name = false, $group_attributes = false)

{

// We need both username and user_id info

$result = user_get_id_name($user_id_ary, $username_ary);

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

WHERE group_id = $group_id

AND user_pending = 1

if ($not_empty)

{

return 'NO_VALID_USERS';

SET group_leader = ' . (($action == 'promote') ? 1 : 0) . "

WHERE group_id = $group_id

AND user_pending = 0

$log = ($action == 'promote') ? 'LOG_GROUP_PROMOTED' : 'LOG_GROUP_DEMOTED';

break;

WHERE ug.group_id = ' . $group_id . '

AND ug.user_pending = 1

AND ug.user_id = u.user_id

$user_id_ary = $email_users = array();

{

$user_id_ary[] = $row['user_id'];

$email_users[] = $row;

}

if (!sizeof($user_id_ary))

{

$sql = 'UPDATE ' . USER_GROUP_TABLE . "

SET user_pending = 0

WHERE group_id = $group_id

// Send approved email to users...

include_once(PHPBB_ROOT_PATH . 'includes/functions_messenger.' . PHP_EXT);

case 'default':

$sql = 'SELECT user_id, group_id FROM ' . USERS_TABLE . '

$groups = array();

{

if (!isset($groups[$row['group_id']]))

{

}

$groups[$row['group_id']][] = $row['user_id'];

}

foreach ($groups as $gid => $uids)

{

*/

function group_validate_groupname($group_id, $group_name)

{

$group_name = utf8_clean_string($group_name);

if (!empty($group_id))

$sql = 'SELECT group_name_clean

FROM ' . GROUPS_TABLE . '

WHERE group_id = ' . (int) $group_id;

if (!$row)

{

$sql = 'SELECT group_name

FROM ' . GROUPS_TABLE . "

if ($row)

{

*/

function group_set_user_default($group_id, $user_id_ary, $group_attributes = false, $update_listing = false)

{

if (empty($user_id_ary))

{

return;

$sql = 'SELECT ' . implode(', ', array_keys($attribute_ary)) . '

FROM ' . GROUPS_TABLE . "

WHERE group_id = $group_id";

}

foreach ($attribute_ary as $attribute => $type)

// Ok, get the original avatar data from users having an uploaded one (we need to remove these from the filesystem)

$sql = 'SELECT user_id, group_id, user_avatar

FROM ' . USERS_TABLE . '

AND user_avatar_type = ' . AVATAR_UPLOAD;

{

avatar_delete('user', $row);

}

}

else

{

unset($sql_ary['user_avatar_width']);

}

if (isset($sql_ary['user_colour']))

{

// Update any cached colour information for these users

if (in_array(phpbb::$config['newest_user_id'], $user_id_ary))

{

*/

function get_group_name($group_id)

{

$sql = 'SELECT group_name, group_type

FROM ' . GROUPS_TABLE . '

WHERE group_id = ' . (int) $group_id;

if (!$row)

{

*/

function group_memberships($group_id_ary = false, $user_id_ary = false, $return_bool = false)

{

if (!$group_id_ary && !$user_id_ary)

{

return true;

if ($group_id_ary)

{

}

if ($user_id_ary)

{

$sql .= ($group_id_ary) ? ' AND ' : ' ';

}

if ($return_bool)

{

return ($row) ? true : false;

}

{

$return[] = $row;

}

return $return;

}