{

var $u_action;

var $new_config;

function main($id, $mode)

{

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

case 'ext_groups':

$l_title = 'ACP_EXTENSION_GROUPS';

break;

case 'orphan':

$l_title = 'ACP_ORPHAN_ATTACHMENTS';

break;

// Secure Download Options - Same procedure as with banning

$allow_deny = ($this->new_config['secure_allow_deny']) ? 'ALLOWED' : 'DISALLOWED';

$sql = 'SELECT *

FROM ' . SITELIST_TABLE;

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

'CONTENT' => build_cfg_template($type, $config_key, $this->new_config, $config_key, $vars),

)

);

unset($display_vars['vars'][$config_key]);

}

FROM ' . EXTENSIONS_TABLE . '

WHERE ' . $db->sql_in_set('extension_id', $extension_id_list);

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

$extension_list = '';

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

{

FROM ' . EXTENSIONS_TABLE . "

WHERE extension = '" . $db->sql_escape($add_extension) . "'";

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

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

{

$error[] = sprintf($user->lang['EXTENSION_EXIST'], $add_extension);

SET group_id = 0

WHERE group_id = $group_id";

$db->sql_query($sql);

add_log('admin', 'LOG_ATTACH_EXTGROUP_DEL', $group_name);

$cache->destroy('_extensions');

$upload_list = array();

foreach ($add_files as $attach_id)

{

{

$upload_list[$attach_id] = $post_ids[$attach_id];

}

ATTACHMENT_CATEGORY_FLASH => $user->lang['CAT_FLASH_FILES'],

ATTACHMENT_CATEGORY_QUICKTIME => $user->lang['CAT_QUICKTIME_FILES'],

);

if ($group_id)

{

$sql = 'SELECT cat_id

{

$cat_type = ATTACHMENT_CATEGORY_NONE;

}

$group_select = '<select name="' . $select_name . '"' . (($key) ? ' id="' . $key . '"' : '') . '>';

foreach ($types as $type => $mode)

function group_select($select_name, $default_group = false, $key = '')

{

global $db, $user;

$group_select = '<select name="' . $select_name . '"' . (($key) ? ' id="' . $key . '"' : '') . '>';

$sql = 'SELECT group_id, group_name

$row['group_id'] = 0;

$row['group_name'] = $user->lang['NOT_ASSIGNED'];

$group_name[] = $row;

for ($i = 0; $i < sizeof($group_name); $i++)

{

if ($default_group === false)

if (empty($magic_home))

{

$locations = array('C:/WINDOWS/', 'C:/WINNT/', 'C:/WINDOWS/SYSTEM/', 'C:/WINNT/SYSTEM/', 'C:/WINDOWS/SYSTEM32/', 'C:/WINNT/SYSTEM32/', '/usr/bin/', '/usr/sbin/', '/usr/local/bin/', '/usr/local/sbin/', '/opt/', '/usr/imagemagick/', '/usr/bin/imagemagick/');

$locations = array_merge($path_locations, $locations);

$db->sql_query($sql);

}

}

if (!empty($ip_list_log))

{

// Update log

'pm_max_msgs' => array('lang' => 'BOXES_LIMIT', 'validate' => 'int', 'type' => 'text:4:4', 'explain' => true),

'full_folder_action' => array('lang' => 'FULL_FOLDER_ACTION', 'validate' => 'int', 'type' => 'select', 'method' => 'full_folder_select', 'explain' => true),

'pm_edit_time' => array('lang' => 'PM_EDIT_TIME', 'validate' => 'int', 'type' => 'text:5:5', 'explain' => true, 'append' => ' ' . $user->lang['MINUTES']),

'legend2' => 'GENERAL_OPTIONS',

'allow_mass_pm' => array('lang' => 'ALLOW_MASS_PM', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => false),

'auth_bbcode_pm' => array('lang' => 'ALLOW_BBCODE_PM', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => false),

'load_jumpbox' => array('lang' => 'YES_JUMPBOX', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => false),

'load_user_activity' => array('lang' => 'LOAD_USER_ACTIVITY', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => true),

'load_tplcompile' => array('lang' => 'RECOMPILE_STYLES', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => true),

'legend3' => 'CUSTOM_PROFILE_FIELDS',

'load_cpf_memberlist' => array('lang' => 'LOAD_CPF_MEMBERLIST', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => false),

'load_cpf_viewprofile' => array('lang' => 'LOAD_CPF_VIEWPROFILE', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => false),

'CONTENT' => build_cfg_template($type, $config_key, $this->new_config, $config_key, $vars),

)

);

unset($display_vars['vars'][$config_key]);

}

}

$dateformat_options .= '<option value="custom"';

{

$dateformat_options .= ' selected="selected"';

}

function close_popup_js()

{

return "<script type=\"text/javascript\">\n" .

" close_waitscreen = 1;\n" .

"</script>\n";

}

$sql = 'UPDATE ' . USERS_TABLE . ' SET ' . $db->sql_build_array('UPDATE', $sql_ary) . "

WHERE user_id = $user_id";

$db->sql_query($sql);

add_log('admin', 'LOG_USER_DEL_SIG', $user_row['username']);

add_log('user', $user_id, 'LOG_USER_DEL_SIG_USER');

'update' => true))

);

}

break;

case 'moveposts':

if (!check_form_key($form_name))

{

$quick_tool_ary += array('active' => (($user_row['user_type'] == USER_INACTIVE) ? 'ACTIVATE' : 'DEACTIVATE'));

}

$quick_tool_ary += array('delsig' => 'DEL_SIG', 'delavatar' => 'DEL_AVATAR', 'moveposts' => 'MOVE_POSTS', 'delposts' => 'DEL_POSTS', 'delattach' => 'DEL_ATTACH');

if ($config['email_enable'] && ($user_row['user_type'] == USER_NORMAL || $user_row['user_type'] == USER_INACTIVE))

{

$quick_tool_ary['reactivate'] = 'FORCE';

case 'feedback':

$user->add_lang('mcp');

// Set up general vars

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

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

trigger_error($user->lang['USER_FEEDBACK_ADDED'] . adm_back_link($this->u_action . '&amp;u=' . $user_id));

}

// Sorting

$limit_days = array(0 => $user->lang['ALL_ENTRIES'], 1 => $user->lang['1_DAY'], 7 => $user->lang['7_DAYS'], 14 => $user->lang['2_WEEKS'], 30 => $user->lang['1_MONTH'], 90 => $user->lang['3_MONTHS'], 180 => $user->lang['6_MONTHS'], 365 => $user->lang['1_YEAR']);

$sort_by_text = array('u' => $user->lang['SORT_USERNAME'], 't' => $user->lang['SORT_DATE'], 'i' => $user->lang['SORT_IP'], 'o' => $user->lang['SORT_ACTION']);

'S_BIRTHDAY_DAY_OPTIONS' => $s_birthday_day_options,

'S_BIRTHDAY_MONTH_OPTIONS' => $s_birthday_month_options,

'S_BIRTHDAY_YEAR_OPTIONS' => $s_birthday_year_options,

'S_PROFILE' => true)

);

$s_custom = false;

$dateformat_options .= '<option value="custom"';

{

$dateformat_options .= ' selected="selected"';

$s_custom = true;

$template->assign_vars(array(

'S_PREFS' => true,

'S_JABBER_DISABLED' => ($config['jab_enable'] && $user_row['user_jabber'] && @extension_loaded('xml')) ? false : true,

'VIEW_EMAIL' => $data['viewemail'],

'MASS_EMAIL' => $data['massemail'],

'ALLOW_PM' => $data['allowpm'],

'VIEW_SIGS' => $data['view_sigs'],

'VIEW_AVATARS' => $data['view_avatars'],

'VIEW_WORDCENSOR' => $data['view_wordcensor'],

'S_TOPIC_SORT_DAYS' => $s_limit_topic_days,

'S_TOPIC_SORT_KEY' => $s_sort_topic_key,

'S_TOPIC_SORT_DIR' => $s_sort_topic_dir,

trigger_error($user->lang['USER_RANK_UPDATED'] . adm_back_link($this->u_action . '&amp;u=' . $user_id));

}

$sql = 'SELECT *

FROM ' . RANKS_TABLE . '

WHERE rank_special = 1

);

break;

case 'sig':

include_once($phpbb_root_path . 'includes/functions_posting.' . $phpEx);

include_once($phpbb_root_path . 'includes/functions_display.' . $phpEx);

// Allowing Quote BBCode

$message_parser->parse($enable_bbcode, $enable_urls, $enable_smilies, $config['allow_sig_img'], $config['allow_sig_flash'], true, $config['allow_sig_links'], true, 'sig');

if (sizeof($message_parser->warn_msg))

{

$error[] = implode('<br />', $message_parser->warn_msg);

trigger_error($user->lang['USER_SIG_UPDATED'] . adm_back_link($this->u_action . '&amp;u=' . $user_id));

}

// Replace "error" strings with their real, localised form

$error = preg_replace('#^([A-Z_]+)$#e', "(!empty(\$user->lang['\\1'])) ? \$user->lang['\\1'] : '\\1'", $error);

}

$signature_preview = '';

if ($preview)

{

// Now parse it for displaying

'ATTACH_ID' => $row['attach_id'],

'POST_ID' => $row['post_msg_id'],

'TOPIC_ID' => $row['topic_id'],

'S_IN_MESSAGE' => $row['in_message'],

'U_DOWNLOAD' => append_sid("{$phpbb_root_path}download/file.$phpEx", 'mode=view&amp;id=' . $row['attach_id']),

);

}

$db->sql_freeresult($result);

$template->assign_vars(array(

'S_ATTACHMENTS' => true,

'S_ON_PAGE' => on_page($num_attachments, $config['topics_per_page'], $start),

);

break;

case 'groups':

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

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

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

if ($group_id)

{

// Check the founder only entry for this group to make sure everything is well

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

$founder_manage = (int) $db->sql_fetchfield('group_founder_manage');

$db->sql_freeresult($result);

if ($user->data['user_type'] != USER_FOUNDER && $founder_manage)

{

trigger_error($user->lang['NOT_ALLOWED_MANAGE_GROUP'] . adm_back_link($this->u_action . '&amp;u=' . $user_id), E_USER_WARNING);

{

$founder_manage = 0;

}

switch ($action)

{

case 'demote':

{

trigger_error($user->lang[$error] . adm_back_link($this->u_action . '&amp;u=' . $user_id), E_USER_WARNING);

}

$error = array();

}

else

'g' => $group_id))

);

}

break;

}

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

$hold_ary = array();

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

{

$hold_ary = $auth_admin->get_mask('view', $user_id, false, false, $row['auth_option'], 'global', ACL_NEVER);

'U_USER_PERMISSIONS' => append_sid("{$phpbb_admin_path}index.$phpEx" ,'i=permissions&amp;mode=setting_user_global&amp;user_id[]=' . $user_id),

'U_USER_FORUM_PERMISSIONS' => append_sid("{$phpbb_admin_path}index.$phpEx", 'i=permissions&amp;mode=setting_user_local&amp;user_id[]=' . $user_id))

);

break;

}

{

return '<pre class="diff context">' . htmlspecialchars($this->_lines($lines, ' ')) . '<br /></pre>';

}

function _added($lines)

{

return '<pre class="diff added">' . htmlspecialchars($this->_lines($lines, '+')) . '<br /></pre>';

// Therefore we split on words, but include all blocks of whitespace in the wordlist.

$splitted_text_1 = $this->_split_on_words($text1, $nl);

$splitted_text_2 = $this->_split_on_words($text2, $nl);

$diff = &new diff($splitted_text_1, $splitted_text_2);

unset($splitted_text_1, $splitted_text_2);

{

// Ignore \0; otherwise the while loop will never finish.

$string = str_replace("\0", '', $string);

$words = array();

$length = strlen($string);

$pos = 0;

{

return $this->_lines($lines, ' ');

}

function _added($lines)

{

return $this->_lines($lines, '+');

// Iterate through every header block of changes

foreach ($this->lines as $header)

{

// Each header block consists of a number of changes (add, remove, change).

$current_context = '';

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

{

{

$unread = true;

break;

// Something failed, determine what...

if ($result['status'] == LOGIN_BREAK)

{

}

// Special cases... determine

'PASSWORD_CREDENTIAL' => ($admin) ? 'password_' . $credential : 'password',

));

$template->set_filenames(array(

'body' => 'login_body.html')

echo '<head>';

echo '<meta http-equiv="content-type" content="text/html; charset=utf-8" />';

echo '<title>' . $msg_title . '</title>';

echo '* { margin: 0; padding: 0; } html { font-size: 100%; height: 100%; margin-bottom: 1px; background-color: #E4EDF0; } body { font-family: "Lucida Grande", Verdana, Helvetica, Arial, sans-serif; color: #536482; background: #E4EDF0; font-size: 62.5%; margin: 0; } ';

echo 'a:link, a:active, a:visited { color: #006699; text-decoration: none; } a:hover { color: #DD6900; text-decoration: underline; } ';

echo '#wrap { padding: 0 20px 15px 20px; min-width: 615px; } #page-header { text-align: right; height: 40px; } #page-footer { clear: both; font-size: 1em; text-align: center; } ';

echo '.panel { margin: 4px 0; background-color: #FFFFFF; border: solid 1px #A9B8C2; } ';

echo '#errorpage #page-header a { font-weight: bold; line-height: 6em; } #errorpage #content { padding: 10px; } #errorpage #content h1 { line-height: 1.2em; margin-bottom: 0; color: #DF075C; } ';

echo '#errorpage #content div { margin-top: 20px; margin-bottom: 5px; border-bottom: 1px solid #CCCCCC; padding-bottom: 5px; color: #333333; font: bold 1.2em "Lucida Grande", Arial, Helvetica, sans-serif; text-decoration: none; line-height: 120%; text-align: left; } ';

echo '</style>';

echo '</head>';

echo '<body id="errorpage">';

'U_POPUP_PM' => append_sid("{$phpbb_root_path}ucp.$phpEx", 'i=pm&amp;mode=popup'),

'UA_POPUP_PM' => addslashes(append_sid("{$phpbb_root_path}ucp.$phpEx", 'i=pm&amp;mode=popup')),

'U_MEMBERLIST' => append_sid("{$phpbb_root_path}memberlist.$phpEx"),

'U_VIEWONLINE' => ($auth->acl_gets('u_viewprofile', 'a_user', 'a_useradd', 'a_userdel')) ? append_sid("{$phpbb_root_path}viewonline.$phpEx") : '',

'U_LOGIN_LOGOUT' => $u_login_logout,

'U_INDEX' => append_sid("{$phpbb_root_path}index.$phpEx"),

'S_DISPLAY_PM' => ($config['allow_privmsg'] && $user->data['is_registered'] && ($auth->acl_get('u_readpm') || $auth->acl_get('u_sendpm'))) ? true : false,

'S_DISPLAY_MEMBERLIST' => (isset($auth)) ? $auth->acl_get('u_viewprofile') : 0,

'S_NEW_PM' => ($s_privmsg_new) ? 1 : 0,

'T_THEME_PATH' => "{$phpbb_root_path}styles/" . $user->theme['theme_path'] . '/theme',

'T_TEMPLATE_PATH' => "{$phpbb_root_path}styles/" . $user->theme['template_path'] . '/template',

$sort_dir = key($sort_dir_text);

}

foreach ($limit_days as $day => $text)

{

$selected = ($sort_days == $day) ? ' selected="selected"' : '';

}

$s_limit_days .= '</select>';

foreach ($sort_by_text as $key => $text)

{

$selected = ($sort_key == $key) ? ' selected="selected"' : '';

}

$s_sort_key .= '</select>';

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

{

$selected = ($sort_dir == $key) ? ' selected="selected"' : '';

$match = get_preg_expression('bbcode_htm');

$replace = array('\1', '\1', '\2', '\1', '', '');

$text = preg_replace($match, $replace, $text);

}

{

$bbcode->bbcode($bitfield);

}

$bbcode->bbcode_second_pass($text, $uid);

}

$template->destroy_block_vars('_file');

$block_array = array();

// Some basics...

$attachment['extension'] = strtolower(trim($attachment['extension']));

$filename = $phpbb_root_path . $config['upload_path'] . '/' . basename($attachment['physical_filename']);

{

$string = 'Re: ' . $string;

}

if ($append != '' && $stripped)

{

$string = $string . $append;

if (strlen($this->data) >= $byte + 1)

{

$c = $this->data[$byte];

// Lookup the ($n % 8)th bit of the byte

$bit = 7 - ($n & 7);

return (bool) (ord($c) & (1 << $bit));

$forum_rows = $subforums = $forum_ids = $forum_ids_moderator = $forum_moderators = $active_forum_ary = array();

$parent_id = $visible_forums = 0;

$sql_from = '';

// Mark forums read?

$mark_read = request_var('mark', '');

'S_UNREAD' => $subforum['unread'])

);

}

$last_catless = $catless;

}

/**

* Topic and forum watching common code

*/

{

global $template, $db, $user, $phpEx, $start, $phpbb_root_path;

}

// Select first id we can get

{

$current_id = $item_ary['id'];

}

$tpl_ary = array(

'L_TITLE' => $item_ary['lang'],

'U_TITLE' => $u_title

);

$tpl_ary = array(

'L_TITLE' => $item_ary['lang'],

'U_TITLE' => $u_title

);

'ICON_IMG' => $phpbb_root_path . $config['icons_path'] . '/' . $data['img'],

'ICON_WIDTH' => $data['width'],

'ICON_HEIGHT' => $data['height'],

'S_CHECKED' => ($id == $icon_id) ? true : false,

'S_ICON_CHECKED' => ($id == $icon_id) ? ' checked="checked"' : '')

);

$topic_type_array

);

foreach ($topic_type_array as $array)

{

$template->assign_block_vars('topic_type', $array);

WHERE p.topic_id = $topic_id

" . ((!$auth->acl_get('m_approve', $forum_id)) ? 'AND p.post_approved = 1' : '') . '

' . (($mode == 'post_review') ? " AND p.post_id > $cur_post_id" : '') . '

$result = $db->sql_query_limit($sql, $config['posts_per_page']);

$post_list = array();

}

$sql_data[USERS_TABLE]['stat'][] = "user_lastpost_time = $current_time" . (($auth->acl_get('f_postcount', $data['forum_id'])) ? ', user_posts = user_posts + 1' : '');

if ($topic_type != POST_GLOBAL)

{

if ($auth->acl_get('f_noapprove', $data['forum_id']) || $auth->acl_get('m_approve', $data['forum_id']))

}

$sql_insert_ary = array();

for ($i = 0, $size = sizeof($poll['poll_options']); $i < $size; $i++)

{

if (strlen(trim($poll['poll_options'][$i])))

foreach ($data['attachment_data'] as $pos => $attach_row)

{

{

continue;

}

case ACTION_PLACE_INTO_FOLDER:

return array('action' => $rule_row['rule_action'], 'folder_id' => $rule_row['rule_folder_id']);

break;

case ACTION_MARK_AS_READ:

case ACTION_MARK_AS_IMPORTANT:

return array('action' => $rule_row['rule_action'], 'pm_unread' => $message_row['pm_unread'], 'pm_marked' => $message_row['pm_marked']);

return false;

break;

default:

return false;

}

unset($sql_folder);

{

$sql = 'SELECT COUNT(msg_id) as num_messages

FROM ' . PRIVMSGS_TO_TABLE . "

if (confirm_box(true))

{

delete_pm($user_id, $msg_ids, $cur_folder_id);

$success_msg = (sizeof($msg_ids) == 1) ? 'MESSAGE_DELETED' : 'MESSAGES_DELETED';

$redirect = append_sid("{$phpbb_root_path}ucp.$phpEx", 'i=pm&amp;folder=' . $cur_folder_id);

$user->data['user_new_privmsg'] -= $num_new;

$user->data['user_unread_privmsg'] -= $num_unread;

}

$sql = 'SELECT msg_id

FROM ' . PRIVMSGS_TO_TABLE . '

WHERE ' . $db->sql_in_set('msg_id', array_keys($delete_rows));

FROM ' . GROUPS_TABLE . '

WHERE ' . $db->sql_in_set('group_id', $g);

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

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

{

if ($check_type == 'to' || $author_id == $user->data['user_id'] || $row['user_id'] == $user->data['user_id'])

AND g.group_id = ug.group_id

AND ug.user_pending = 0';

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

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

{

if (!isset($address['group'][$row['group_id']]))

AND u.user_id = ug.user_id

AND u.user_type IN (' . USER_NORMAL . ', ' . USER_FOUNDER . ')';

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

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

{

$field = ($data['address_list']['g'][$row['group_id']] == 'to') ? 'to' : 'bcc';

foreach ($data['attachment_data'] as $pos => $attach_row)

{

{

continue;

}

'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']) . "'

{

if ($user->data['user_new_privmsg'])

{

}

else

{

$s_custom = false;

$dateformat_options .= '<option value="custom"';

{

$dateformat_options .= ' selected="selected"';

$s_custom = true;