'user_sig' => '',

'user_sig_bbcode_uid' => '',

'user_sig_bbcode_bitfield' => '',

'user_form_salt' => unique_id(),

);

{

avatar_delete('user', $user_row);

}

switch ($mode)

{

case 'retain':

'ban_give_reason' => (string) $ban_give_reason,

);

}

$db->sql_multi_insert(BANLIST_TABLE, $sql_ary);

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

$date[2] = 1980;

}

}

if (sizeof($date) != 3 || !checkdate($date[1], $date[0], $date[2]))

{

return 'INVALID';

return false;

}

}

if ($clean_db)

{

avatar_remove_db($row[$mode . '_avatar']);

{

$file = $upload->remote_upload($data['uploadurl']);

}

$prefix = $config['avatar_salt'] . '_';

$file->clean_filename('avatar', $prefix, $data['user_id']);

{

global $config;

if ($avatar_entry[0] === 'g')

{

$avatar_group = true;

if ($file[0] != '.' && preg_match('#^[^&"\'<>]+$#i', $file) && is_dir("$path/$file"))

{

$avatar_row_count = $avatar_col_count = 0;

if ($dp2 = @opendir("$path/$file"))

{

while (($sub_file = readdir($dp2)) !== false)

function avatar_get_dimensions($avatar, $avatar_type, &$error, $current_x = 0, $current_y = 0)

{

global $config, $phpbb_root_path, $user;

switch ($avatar_type)

{

case AVATAR_REMOTE :

case AVATAR_UPLOAD :

$avatar = $phpbb_root_path . $config['avatar_path'] . '/' . get_avatar_filename($avatar);

break;

case AVATAR_GALLERY :

$avatar = $phpbb_root_path . $config['avatar_gallery_path'] . '/' . $avatar ;

break;

$error[] = $user->lang['AVATAR_NO_SIZE'];

return false;

}

// try to maintain ratio

if (!(empty($current_x) && empty($current_y)))

{

else if (!empty($userdata['user_avatar']))

{

// Only update the dimensions

if (empty($data['width']) || empty($data['height']))

{

if ($dims = avatar_get_dimensions($userdata['user_avatar'], $userdata['user_avatar_type'], $error, $data['width'], $data['height']))

{

$error[] = (!utf8_strlen($name)) ? $user->lang['GROUP_ERR_USERNAME'] : $user->lang['GROUP_ERR_USER_LONG'];

}

$err = group_validate_groupname($group_id, $name);

if (!empty($err))

{

$error[] = $user->lang[$err];

}

if (!in_array($type, array(GROUP_OPEN, GROUP_CLOSED, GROUP_HIDDEN, GROUP_SPECIAL, GROUP_FREE)))

{

$error[] = $user->lang['GROUP_ERR_TYPE'];

$old_filename = get_avatar_filename($old_entry);

$new_filename = $config['avatar_salt'] . "_g$group_id.$ext";

$new_entry = 'g' . $group_id . '_' . substr(time(), -5) . ".$ext";

$avatar_path = $phpbb_root_path . $config['avatar_path'];

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

{

function avatar_remove_db($avatar_name)

{

global $config, $db;

$sql = 'UPDATE ' . USERS_TABLE . "

SET user_avatar = '',

user_avatar_type = 0

return false;

}

$db->sql_freeresult($result);

$sql = 'UPDATE ' . USERS_TABLE . "

SET user_avatar = '',

user_avatar_type = 0,

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

AND user_avatar = '" . $db->sql_escape($row['group_avatar']) . "'

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

$db->sql_query($sql);

}

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

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

$db->sql_freeresult($result);

if ($row)

{

return 'GROUP_NAME_TAKEN';

}

// Before we update the user attributes, we will make a list of those having now the group avatar assigned

{

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

WHERE ' . $db->sql_in_set('user_id', $user_id_ary);

$db->sql_query($sql);

{

// Update any cached colour information for these users

$sql = 'UPDATE ' . FORUMS_TABLE . " SET forum_last_poster_colour = '" . $db->sql_escape($sql_ary['user_colour']) . "'