+ 'user_email_hash' => phpbb_email_hash($user_row['user_email']),

+ 'user_options' => 230271,

+ // We do not set the new flag here - registration scripts need to specify it

+ 'user_new' => 0,

+ // Add to newly registered users group if user_new is 1

+ if ($config['new_member_post_limit'] && $sql_ary['user_new'])

+ {

+ $sql = 'SELECT group_id

+ FROM ' . GROUPS_TABLE . "

+ WHERE group_name = 'NEWLY_REGISTERED'

+ AND group_type = " . GROUP_SPECIAL;

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

+ $add_group_id = (int) $db->sql_fetchfield('group_id');

+ $db->sql_freeresult($result);

+

+ if ($add_group_id)

+ {

+ // Because these actions only fill the log unneccessarily we skip the add_log() entry with a little hack. :/

+ $GLOBALS['skip_add_log'] = true;

+

+ // Add user to "newly registered users" group and set to default group if admin specified so.

+ if ($config['new_member_group_default'])

+ {

+ group_user_add($add_group_id, $user_id, false, false, true);

+ }

+ else

+ {

+ group_user_add($add_group_id, $user_id);

+ }

+

+ unset($GLOBALS['skip_add_log']);

+ }

+ }

+

+ if ($user_row['user_type'] == USER_NORMAL || $user_row['user_type'] == USER_FOUNDER)

+ $sql = 'UPDATE ' . ATTACHMENTS_TABLE . '

+ SET poster_id = ' . ANONYMOUS . "

+ WHERE poster_id = $user_id";

+ $db->sql_query($sql);

+

+ // Delete user log entries about this user

+ $sql = 'DELETE FROM ' . LOG_TABLE . '

+ WHERE reportee_id = ' . $user_id;

+ $db->sql_query($sql);

+

+ // Change user_id to anonymous for this users triggered events

+ $sql = 'UPDATE ' . LOG_TABLE . '

+ SET user_id = ' . ANONYMOUS . '

+ WHERE user_id = ' . $user_id;

+ $db->sql_query($sql);

+

+ // Delete the user_id from the zebra table

+ $sql = 'DELETE FROM ' . ZEBRA_TABLE . '

+ WHERE user_id = ' . $user_id . '

+ OR zebra_id = ' . $user_id;

+ $db->sql_query($sql);

+

+

+ if (empty($banlist_ary))

+ $banlist_ary_tmp = array_intersect($banlist_ary, $banlist_ary_tmp);

+

+ if (sizeof($banlist_ary_tmp))

+ {

+ // One or more entities are already banned/excluded, delete the existing bans, so they can be re-inserted with the given new length

+ $sql = 'DELETE FROM ' . BANLIST_TABLE . '

+ WHERE ' . $db->sql_in_set($type, $banlist_ary_tmp) . '

+ AND ban_exclude = ' . (int) $ban_exclude;

+ $db->sql_query($sql);

+ }

+

+ // Add to moderator log, admin log and user notes

+ if ($mode == 'user')

+ {

+ foreach ($banlist_ary as $user_id)

+ {

+ add_log('user', $user_id, $log_entry . strtoupper($mode), $ban_reason, $ban_list_log);

+ }

+ }

+ $sql = 'SELECT u.username AS unban_info, u.user_id

+ $user_ids_ary = array();

+ if ($mode == 'user')

+ {

+ $user_ids_ary[] = $row['user_id'];

+ }

+ // Add to moderator log, admin log and user notes

+ if ($mode == 'user')

+ {

+ foreach ($user_ids_ary as $user_id)

+ {

+ add_log('user', $user_id, 'LOG_UNBAN_' . strtoupper($mode), $l_unban_list);

+ }

+ }

+ WHERE user_email_hash = " . $db->sql_escape(phpbb_email_hash($email));

+ 'file' => rawurlencode($file) . '/' . rawurlencode($sub_file),

+ 'filename' => rawurlencode($sub_file),

+ // Attributes which also affect the users table

+ $user_attribute_ary = array('group_colour', 'group_rank', 'group_avatar', 'group_avatar_type', 'group_avatar_width', 'group_avatar_height');

+ // Merge them with $sql_ary to properly update the group

+ $sql_ary = array_merge($sql_ary, $group_attributes);

+

+

+ // One special case is the group skip auth setting. If this was changed we need to purge permissions for this group

+ if (isset($group_attributes['group_skip_auth']))

+ {

+ // Get users within this group...

+ $sql = 'SELECT user_id

+ FROM ' . USER_GROUP_TABLE . '

+ WHERE group_id = ' . $group_id . '

+ AND user_pending = 0';

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

+

+ $user_id_ary = array();

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

+ {

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

+ }

+ $db->sql_freeresult($result);

+

+ if (!empty($user_id_ary))

+ {

+ global $auth;

+

+ // Clear permissions cache of relevant users

+ $auth->acl_clear_prefetch($user_id_ary);

+ }

+ }

+

+ // Go through the user attributes array, check if a group attribute matches it and then set it. ;)

+ foreach ($user_attribute_ary as $attribute)

+ if (!isset($group_attributes[$attribute]))

+ continue;

+ }

+ // If we are about to set an avatar, we will not overwrite user avatars if no group avatar is set...

+ if (strpos($attribute, 'group_avatar') === 0 && !$group_attributes[$attribute])

+ {

+ continue;

+

+ $sql_ary[$attribute] = $group_attributes[$attribute];

+ group_user_attributes('default', $group_id, $user_id_ary, false, $group_name, $group_attributes);

+ $log = ($leader) ? 'LOG_MODS_ADDED' : (($pending) ? 'LOG_USERS_PENDING' : 'LOG_USERS_ADDED');

+ remove_default_rank($group_id, $sql_where_ary[$gid]);

+ if ($group_name)

+ {

+ add_log('admin', $log, $group_name, implode(', ', $username_ary));

+ }

+ // We only set default group for approved members of the group

+ $sql = 'SELECT user_id

+ FROM ' . USER_GROUP_TABLE . "

+ WHERE group_id = $group_id

+ AND user_pending = 0

+ AND " . $db->sql_in_set('user_id', $user_id_ary);

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

+

+ $user_id_ary = $username_ary = array();

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

+ {

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

+ }

+ $db->sql_freeresult($result);

+

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

+ if (!sizeof($user_id_ary) || $result !== false)

+ {

+ return 'NO_USERS';

+ }

+

+ global $cache, $db;

+

+ // Because some tables/caches use usercolour-specific data we need to purge this here.

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

+ if (!$row || ($row['group_type'] == GROUP_SPECIAL && empty($user->lang)))

+

+

+/**

+* Funtion to make a user leave the NEWLY_REGISTERED system group.

+* @access public

+* @param $user_id The id of the user to remove from the group

+*/

+function remove_newly_registered($user_id, $user_data = false)

+{

+ global $db;

+

+ if ($user_data === false)

+ {

+ $sql = 'SELECT *

+ FROM ' . USERS_TABLE . '

+ WHERE user_id = ' . $user_id;

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

+ $user_row = $db->sql_fetchrow($result);

+ $db->sql_freeresult($result);

+

+ if (!$user_row)

+ {

+ return false;

+ }

+ else

+ {

+ $user_data = $user_row;

+ }

+ }

+

+ if (empty($user_data['user_new']))

+ {

+ return false;

+ }

+

+ $sql = 'SELECT group_id

+ FROM ' . GROUPS_TABLE . "

+ WHERE group_name = 'NEWLY_REGISTERED'

+ AND group_type = " . GROUP_SPECIAL;

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

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

+ $db->sql_freeresult($result);

+

+ if (!$group_id)

+ {

+ return false;

+ }

+

+ // We need to call group_user_del here, because this function makes sure everything is correctly changed.

+ // A downside for a call within the session handler is that the language is not set up yet - so no log entry

+ group_user_del($group_id, $user_id);

+

+ // Set user_new to 0 to let this not be triggered again

+ $sql = 'UPDATE ' . USERS_TABLE . '

+ SET user_new = 0

+ WHERE user_id = ' . $user_id;

+ $db->sql_query($sql);

+

+ // The new users group was the users default group?

+ if ($user_data['group_id'] == $group_id)

+ {

+ // Which group is now the users default one?

+ $sql = 'SELECT group_id

+ FROM ' . USERS_TABLE . '

+ WHERE user_id = ' . $user_id;

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

+ $user_data['group_id'] = $db->sql_fetchfield('group_id');

+ $db->sql_freeresult($result);

+ }

+

+ return $user_data['group_id'];

+}

+