+ "AVATAR_GALLERY_PATH" => $new['avatar_gallery_path'],

+include($phpbb_root_path . 'includes/bbcode.'.$phpEx);

+include($phpbb_root_path . 'includes/post.'.$phpEx);

+ $this_userdata = get_userdata_from_id($HTTP_GET_VARS[POST_USERS_URL]);

+ $user_id = $this_userdata['user_id'];

+ $username = $this_userdata['username'];

+ $email = $this_userdata['user_email'];

+ $icq = $this_userdata['user_icq'];

+ $aim = $this_userdata['user_aim'];

+ $msn = $this_userdata['user_msnm'];

+ $yim = $this_userdata['user_yim'];

+

+ $website = $this_userdata['user_website'];

+ $location = $this_userdata['user_from'];

+ $occupation = $this_userdata['user_occ'];

+ $interests = $this_userdata['user_interests'];

+ $signature = $this_userdata['user_sig'];

+

+ $viewemail = $this_userdata['user_viewemail'];

+ $notifypm = $this_userdata['user_notify_pm'];

+ $attachsig = $this_userdata['user_attachsig'];

+ $allowhtml = $this_userdata['user_allowhtml'];

+ $allowbbcode = $this_userdata['user_allowbbcode'];

+ $allowsmilies = $this_userdata['user_allowsmile'];

+ $allowviewonline = $this_userdata['user_allow_viewonline'];

+

+ $user_avatar = $this_userdata['user_avatar'];

+ $user_avatar_type = $this_userdata['user_avatar_type'];

+ $user_style = $this_userdata['user_style'];

+ $user_lang = $this_userdata['user_lang'];

+ $user_timezone = $this_userdata['user_timezone'];

+ $user_dateformat = $this_userdata['user_dateformat'];

+ $user_status = $this_userdata['user_active'];

+ $user_allowavatar = $this_userdata['user_allowavatar'];

+ $user_allowpm = $this_userdata['user_allow_pm'];

+ $s_hidden_fields .= '<input type="hidden" name="user_id" value="' . $this_userdata['user_id'] . '" />';

+ if( $user_avatar_type )

+ switch( $user_avatar_type )

+ {

+ case USER_AVATAR_UPLOAD:

+ $avatar = "<img src=\"" . $board_config['avatar_path'] . "/" . $user_avatar . "\" alt=\"\" />";

+ break;

+ case USER_AVATAR_REMOTE:

+ $avatar = "<img src=\"$user_avatar\" alt=\"\" />";

+ break;

+ case USER_AVATAR_GALLERY:

+ $avatar = "<img src=\"" . $board_config['avatar_gallery_path'] . "/" . $user_avatar . "\" alt=\"\" />";

+ break;

+ }

+ $signature = preg_replace("/\:[0-9a-z\:]*?\]/si", "]", $signature);

+

+ $viewemail = (isset($HTTP_POST_VARS['viewemail'])) ? intval($HTTP_POST_VARS['viewemail']) : 0;

+ $notifypm = (isset($HTTP_POST_VARS['notifypm'])) ? intval($HTTP_POST_VARS['notifypm']) : 1;

+ $attachsig = (isset($HTTP_POST_VARS['attachsig'])) ? intval($HTTP_POST_VARS['attachsig']) : 0;

+ $allowhtml = (isset($HTTP_POST_VARS['allowhtml'])) ? intval($HTTP_POST_VARS['allowhtml']) : $board_config['allow_html'];

+ $allowbbcode = (isset($HTTP_POST_VARS['allowbbcode'])) ? intval($HTTP_POST_VARS['allowbbcode']) : $board_config['allow_bbcode'];

+ $allowsmilies = (isset($HTTP_POST_VARS['allowsmilies'])) ? intval($HTTP_POST_VARS['allowsmilies']) : $board_config['allow_smilies'];

+ $user_style = ($HTTP_POST_VARS['style']) ? intval($HTTP_POST_VARS['style']) : $board_config['default_style'];

+ $user_timezone = (isset($HTTP_POST_VARS['timezone'])) ? doubleval($HTTP_POST_VARS['timezone']) : $board_config['board_timezone'];

+ $user_status = (!empty($HTTP_POST_VARS['user_status'])) ? intval($HTTP_POST_VARS['user_status']) : 0;

+ $user_allowpm = (!empty($HTTP_POST_VARS['user_allowpm'])) ? intval($HTTP_POST_VARS['user_allowpm']) : 0;

+ $user_allowavatar = (!empty($HTTP_POST_VARS['usr_allowavatar'])) ? intval($HTTP_POST_VARS['user_allowavatar']) : 0;

+ else if(!$password && $password_confirm)

+ {

+ $error = TRUE;

+ $error_msg = $lang['Password_mismatch'];

+ }

+

+ if( $signature != "" )

+ {

+ if( strlen($signature) > $board_config['max_sig_chars'] )

+ {

+ $error = TRUE;

+ if(isset($error_msg))

+ {

+ $error_msg .= "<br />";

+ }

+ $error_msg .= $lang['Signature_too_long'];

+ }

+ else

+ {

+ $signature_bbcode_uid = ( $allowbbcode ) ? make_bbcode_uid() : "";

+ $signature = prepare_message($signature, $allowhtml, $allowbbcode, $allowsmilies, $signature_bbcode_uid);

+ }

+ }

+ if( $user_avatar_type == USER_AVATAR_UPLOAD )

+ if( file_exists("./../" . $board_config['avatar_path'] . "/" . $user_avatar) )

+ $avatar_sql = ", user_avatar = '', user_avatar_type = " . USER_AVATAR_NONE;

+ echo $sql = "UPDATE " . USERS_TABLE . "

+ SET " . $username_sql . $passwd_sql . "user_email = '$email', user_icq = '$icq', user_website = '$website', user_occ = '$occupation', user_from = '$location', user_interests = '$interests', user_sig = '$signature', user_viewemail = $viewemail, user_aim = '$aim', user_yim = '$yim', user_msnm = '$msn', user_attachsig = $attachsig, user_allowsmile = $allowsmilies, user_allowhtml = $allowhtml, user_allowavatar = $user_allowavatar, user_allowbbcode = $allowbbcode, user_allow_viewonline = $allowviewonline, user_allow_pm = $user_allowpm, user_notify_pm = $notifypm, user_lang = '$user_lang', user_style = $user_style, user_timezone = $user_timezone, user_dateformat = '$user_dateformat', user_active = $user_status, user_actkey = '$user_actkey'" . $avatar_sql . "

+ [user_avatar] [varchar] (100) NULL ,

+ [user_avatar_type] [smallint] NOT NULL,

+ CONSTRAINT [DF_phpbb_users_user_notify_pm] DEFAULT (1) FOR [user_notify_pm],

+ CONSTRAINT [DF_phpbb_users_user_avatar_type] DEFAULT (0) FOR [user_avatar_type]

+ user_avatar_type tinyint(4) DEFAULT '0' NOT NULL,

+ user_avatar varchar(100),

+ user_avatar_type int2 DEFAULT '0' NOT NULL,

+<?php

+

+$phpbb_root_path = "../";

+

+include($phpbb_root_path . 'extension.inc');

+include($phpbb_root_path . 'config.'.$phpEx);

+include($phpbb_root_path . 'includes/constants.'.$phpEx);

+include($phpbb_root_path . 'includes/db.'.$phpEx);

+

+

+$sql = "ALTER TABLE " . USERS_TABLE . "

+ ADD user_avatar_type TINYINT(4) DEFAULT '0' NOT NULL";

+if( !$result = $db->sql_query($sql) )

+{

+ die("Couldn't alter users table");

+}

+

+$sql = "SELECT user_id, user_avatar

+ FROM " . USERS_TABLE;

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

+{

+ $rowset = $db->sql_fetchrowset($result);

+

+ for($i = 0; $i < count($rowset); $i++)

+ {

+ if( ereg("^http", $rowset[$i]['user_avatar']))

+ {

+ $sql_type = USER_AVATAR_REMOTE;

+ }

+ else if( $rowset[$i]['user_avatar'] != "" )

+ {

+ $sql_type = USER_AVATAR_UPLOAD;

+ }

+ else

+ {

+ $sql_type = USER_AVATAR_NONE;

+ }

+

+ $sql = "UPDATE " . USERS_TABLE . "

+ SET user_avatar_type = $sql_type

+ WHERE user_id = " . $rowset[$i]['user_id'];

+ if( !$result = $db->sql_query($sql) )

+ {

+ die("Couldn't update users table- " . $i);

+ }

+ }

+}

+

+echo "<BR><BR>COMPLETE<BR>";

+

+?>

+// User related

+define(USER_AVATAR_NONE, 0);

+define(USER_AVATAR_UPLOAD, 1);

+define(USER_AVATAR_REMOTE, 2);

+define(USER_AVATAR_GALLERY, 3);

+

+$lang['Avatar_gallery'] = "Avatar gallery";

+$lang['View_avatar_gallery'] = "Show gallery";

+

+$lang['Select_avatar'] = "Select avatar";

+$lang['Return_profile'] = "Cancel avatar";

+$lang['Select_category'] = "Select category";

+ if( $profiledata['user_avatar_type'] )

+ switch( $profiledata['user_avatar_type'] )

+ {

+ case USER_AVATAR_UPLOAD:

+ $avatar_img = "<img src=\"" . $board_config['avatar_path'] . "/" . $profiledata['user_avatar'] . "\" alt=\"\" />";

+ break;

+ case USER_AVATAR_REMOTE:

+ $avatar_img = "<img src=\"" . $profiledata['user_avatar'] . "\" alt=\"\" />";

+ break;

+ case USER_AVATAR_GALLERY:

+ $avatar_img = "<img src=\"" . $board_config['avatar_gallery_path'] . "/" . $profiledata['user_avatar'] . "\" alt=\"\" />";

+ break;

+ }

+ $avatar_img = "";

+ header(append_sid("Location: login.$phpEx?forward_page=profile.$phpEx&mode=editprofile"));

+ else if( isset($HTTP_POST_VARS['submit']) || isset($HTTP_POST_VARS['avatargallery']) || isset($HTTP_POST_VARS['submitavatar']) || isset($HTTP_POST_VARS['cancelavatar']) || $mode == "register" )

+ $user_timezone = (isset($HTTP_POST_VARS['timezone'])) ? doubleval($HTTP_POST_VARS['timezone']) : $board_config['board_timezone'];

+ $user_avatar_local = ( isset($HTTP_POST_VARS['avatarselect']) && !empty($HTTP_POST_VARS['submitavatar']) && $board_config['allow_avatar_local'] ) ? $HTTP_POST_VARS['avatarselect'] : ( ( isset($HTTP_POST_VARS['avatarlocal']) ) ? $HTTP_POST_VARS['avatarlocal'] : "" );

+

+ $user_avatar_filetype = (!empty($HTTP_POST_FILES['avatar']['type'])) ? $HTTP_POST_FILES['avatar']['type'] : "";

+

+ $user_avatar_type = (empty($user_avatar_loc) && $mode == "editprofile") ? $userdata['user_avatar_type'] : "";

+ if( isset($HTTP_POST_VARS['submit']) )

+ if( $board_config['allow_avatar_upload'] && !$error )

+ if( !empty($user_avatar_loc) && !empty($user_avatar_url) )

+ if( @file_exists("./" . $board_config['avatar_path'] . "/" . $userdata['user_avatar']) )

+ @unlink("./" . $board_config['avatar_path'] . "/" . $userdata['user_avatar']);

+ $avatar_sql = ", user_avatar = '', user_avatar_type = " . USER_AVATAR_NONE;

+ else if( $user_avatar_loc != "" && $board_config['allow_avatar_upload'] )

+ if(file_exists($user_avatar_loc) && ereg(".jpg$|.gif$|.png$", $user_avatar_name))

+ if($user_avatar_size <= $board_config['avatar_filesize'] && $avatar_size > 0)

+ $error_type = false;

+

+ //

+ // Opera appends the image name after the type, not big, not clever!

+ //

+ preg_match("'image\/[x\-]*([a-z]+)'", $user_avatar_filetype, $user_avatar_filetype);

+ $user_avatar_filetype = $user_avatar_filetype[1];

+

+ switch($user_avatar_filetype)

+ case "jpeg":

+ case "pjpeg":

+ $imgtype = '.jpg';

+ break;

+ case "gif":

+ $imgtype = '.gif';

+ break;

+ case "png":

+ $imgtype = '.png';

+ break;

+ default:

+ $error = true;

+ $error_msg = (!empty($error_msg)) ? $error_msg . "<br />" . $lang['Avatar_filetype'] : $lang['Avatar_filetype'];

+ break;

+ }

+ if(!$error)

+ {

+ list($width, $height) = @getimagesize($user_avatar_loc);

+ if( $width <= $board_config['avatar_max_width'] &&

+ $height <= $board_config['avatar_max_height'] )

+ $user_id = ($mode == "register") ? $new_user_id : $userdata['user_id'];

+ $avatar_filename = $user_id . $imgtype;

+ if($mode == "editprofile")

+ if(file_exists("./" . $board_config['avatar_path'] . "/" . $user_id))

+ @unlink("./" . $board_config['avatar_path'] . "/" . $user_id);

+ @copy($user_avatar_loc, "./" . $board_config['avatar_path'] . "/$avatar_filename");

+

+ $avatar_sql = ", user_avatar = '$avatar_filename', user_avatar_type = " . USER_AVATAR_UPLOAD;

+ }

+ else

+ {

+ $error = true;

+ $error_msg = (!empty($error_msg)) ? $error_msg . "<br />" . $lang['Avatar_imagesize'] : $lang['Avatar_imagesize'];

+ $error_filesize = $lang['Avatar_filesize'] . " " . round($board_config['avatar_filesize'] / 1024) . " " . $lang['kB'];

+ $error_msg = (!empty($error_msg)) ? $error_msg . "<br />" . $error_filesize : $error_filesize;

+ }

+ else

+ {

+ $error = true;

+ $error_msg = (!empty($error_msg)) ? $error_msg . "<br />" . $lang['Avatar_filetype'] : $lang['Avatar_filetype'];

+ }

+ else if( !empty($user_avatar_url) && $board_config['allow_avatar_upload'] )

+ //

+ // First check what port we should connect

+ // to, look for a :[xxxx]/ or, if that doesn't

+ // exist assume port 80 (http)

+ //

+ preg_match("/^(http:\/\/)?([a-z0-9\.]+)\:?([0-9]*)\/(.*)$/", $user_avatar_url, $url_ary);

+

+ if( !empty($url_ary[4]) )

+ $port = (!empty($url_ary[3])) ? $url_ary[3] : 80;

+ $fsock = @fsockopen($url_ary[2], $port, $errno, $errstr);

+ if($fsock)

+ $base_get = "/" . $url_ary[4];

+ //

+ // Uses HTTP 1.1, could use HTTP 1.0 ...

+ //

+ @fputs($fsock, "GET $base_get HTTP/1.1\r\n");

+ @fputs($fsock, "HOST: " . $url_ary[2] . "\r\n");

+ @fputs($fsock, "Connection: close\r\n\r\n");

+

+ unset($avatar_data);

+ while(!@feof($fsock))

+ $avatar_data .= @fread($fsock, $board_config['avatar_filesize']);

+ }

+ @fclose($fsock);

+ if(preg_match("/Content-Length\: ([0-9]+)[^\/]+Content-Type\: image\/[x\-]*([a-z]+)[\s]+/i", $avatar_data, $file_data))

+ {

+ $file_size = $file_data[1];

+ $file_type = $file_data[2];

+ switch($file_type)

+ case "jpeg":

+ case "pjpeg":

+ $imgtype = '.jpg';

+ break;

+ case "gif":

+ $imgtype = '.gif';

+ break;

+ case "png":

+ $imgtype = '.png';

+ break;

+ default:

+ $error = true;

+ $error_msg = (!empty($error_msg)) ? $error_msg . "<br />" . $lang['Avatar_filetype'] : $lang['Avatar_filetype'];

+ break;

+ if(!$error && $file_size > 0 && $file_size < $board_config['avatar_filesize'])

+ $avatar_data = substr($avatar_data, strlen($avatar_data) - $file_size, $file_size);

+ $tmp_filename = tempnam ("/tmp", $userdata['user_id'] . "-");

+ $fptr = @fopen($tmp_filename, "wb");

+ $bytes_written = @fwrite($fptr, $avatar_data, $file_size);

+ @fclose($fptr);

+ if($bytes_written == $file_size)

+ list($width, $height) = @getimagesize($tmp_filename);

+ if( $width <= $board_config['avatar_max_width'] && $height <= $board_config['avatar_max_height'] )

+ $user_id = ($mode == "register") ? $new_user_id : $userdata['user_id'];

+ $avatar_filename = $user_id . $imgtype;

+ if($mode == "editprofile")

+ {

+ if(file_exists("./" . $board_config['avatar_path'] . "/" . $user_id))

+ @unlink("./" . $board_config['avatar_path'] . "/" . $user_id);

+ @copy($tmp_filename, "./" . $board_config['avatar_path'] . "/$avatar_filename");

+ @unlink($tmp_filename);

+

+ $avatar_sql = ", user_avatar = '$avatar_filename', user_avatar_type = " . USER_AVATAR_UPLOAD;

+ // Image too large

+ $error = true;

+ $error_msg = (!empty($error_msg)) ? $error_msg . "<br />" . $lang['Avatar_imagesize'] : $lang['Avatar_imagesize'];

+ else

+ {

+ //

+ // Error writing file

+ //

+ @unlink($tmp_filename);

+ message_die(GENERAL_ERROR, "Could not write avatar file to local storage. Please contact the board administrator with this message", "", __LINE__, __FILE__);

+ }

+ // No data

+ $error_msg = (!empty($error_msg)) ? $error_msg . "<br />" . $lang['File_no_data'] : $lang['File_no_data'];

+ //

+ // No connection

+ //

+ $error_msg = (!empty($error_msg)) ? $error_msg . "<br />" . $lang['No_connection_URL'] : $lang['No_connection_URL'];

+ }

+ else

+ {

+ $error = true;

+ $error_msg = (!empty($error_msg)) ? $error_msg . "<br />" . $lang['Incomplete_URL'] : $lang['Incomplete_URL'];

+ }

+ if( $board_config['allow_avatar_remote'] && !$error )

+ $avatar_sql = ", user_avatar = '$user_avatar_remoteurl', user_avatar_type = " . USER_AVATAR_REMOTE;

+ }

+ }

+

+ if( $board_config['allow_avatar_local'] && !$error )

+ {

+ if( $user_avatar_local != "" && $avatar_sql == "" )

+ {

+ $avatar_sql = ", user_avatar = '$user_avatar_local', user_avatar_type = " . USER_AVATAR_GALLERY;

+ else if( $mode == "editprofile" && !isset($HTTP_POST_VARS['avatargallery']) && !isset($HTTP_POST_VARS['submitavatar']) && !isset($HTTP_POST_VARS['cancelavatar']) )

+ $user_avatar_type = $userdata['user_avatar_type'];

+ if( isset($HTTP_POST_VARS['avatargallery']) )

+ if($mode == "editprofile")

+ {

+ if( $user_id != $userdata['user_id'] )

+ {

+ $error = TRUE;

+ $error_msg = $lang['Wrong_Profile'];

+ }

+ }

+ if( !$error )

+ {

+ include($phpbb_root_path . 'includes/page_header.'.$phpEx);

+ $template->set_filenames(array(

+ "body" => "profile_avatar_gallery.tpl",

+ "jumpbox" => "jumpbox.tpl")

+ );

+ $jumpbox = make_jumpbox();

+ $template->assign_vars(array(

+ "L_GO" => $lang['Go'],

+ "L_JUMP_TO" => $lang['Jump_to'],

+ "L_SELECT_FORUM" => $lang['Select_forum'],

+ "S_JUMPBOX_LIST" => $jumpbox,

+ "S_JUMPBOX_ACTION" => append_sid("viewforum.$phpEx"))

+ );

+ $template->assign_var_from_handle("JUMPBOX", "jumpbox");

+ $dir = @opendir($board_config['avatar_gallery_path']);

+ $avatar_images = array();

+ while( $file = @readdir($dir) )

+ {

+ if( @filetype($file) == "dir" && !preg_match("/\.\.|\./", $file) )

+ {

+ $sub_dir = @opendir($board_config['avatar_gallery_path'] . "/" . $file);

+ $avatar_row_count = 0;

+ $avatar_col_count = 0;

+ while( $sub_file = @readdir($sub_dir) )

+ {

+ if( preg_match("/(\.gif$|\.png$|\.jpg)$/is", $sub_file) )

+ {

+ $avatar_images[$file][$avatar_row_count][$avatar_col_count] = $file . "/" . $sub_file;

+ $avatar_col_count++;

+ if( $avatar_col_count == 5 )

+ {

+ $avatar_row_count++;

+ $avatar_col_count = 0;

+ }

+ }

+ }

+ }

+ else

+ {

+ }

+ }

+

+ @closedir($dir);

+ if( isset($HTTP_POST_VARS['avatarcategory']) )

+ {

+ $category = $HTTP_POST_VARS['avatarcategory'];

+ }

+ else

+ {

+ list($category, ) = each($avatar_images);

+ }

+ @reset($avatar_images);

+ $s_categories = "";

+ while( list($key) = each($avatar_images) )

+ {

+ $selected = ( $key == $category ) ? "selected=\"selected\"" : "";

+ if( count($avatar_images[$key]) )

+ {

+ $s_categories .= '<option value="' . $key . '"' . $selected . '>' . ucfirst($key) . '</option>';

+ }

+ }

+ $s_colspan = 0;

+ for($i = 0; $i < count($avatar_images[$category]); $i++)

+ {

+ $template->assign_block_vars("avatar_row", array());

+ $s_colspan = max($s_colspan, count($avatar_images[$category][$i]));

+ for($j = 0; $j < count($avatar_images[$category][$i]); $j++)

+ {

+ $template->assign_block_vars("avatar_row.avatar_column", array(

+ "AVATAR_IMAGE" => $board_config['avatar_gallery_path'] . "/" . $avatar_images[$category][$i][$j])

+ );

+ $template->assign_block_vars("avatar_row.avatar_option_column", array(

+ "S_OPTIONS_AVATAR" => $avatar_images[$category][$i][$j])

+ );

+ }

+ }

+

+ $s_hidden_fields = '<input type="hidden" name="agreed" value="true" /><input type="hidden" name="coppa" value="' . $coppa . '" /><input type="hidden" name="user_id" value="' . $userdata['user_id'] . '" /><input type="hidden" name="current_email" value="' . $userdata['user_email'] . '" />';

+ $s_hidden_vars = '<input type="hidden" name="user_id" value="' . $user_id . '" />';

+ $s_hidden_vars .= '<input type="hidden" name="username" value="' . addslashes($username) . '" />';

+ $s_hidden_vars .= '<input type="hidden" name="email" value="' . addslashes($email) . '" />';

+ $s_hidden_vars .= '<input type="hidden" name="icq" value="' . addslashes($icq) . '" />';

+ $s_hidden_vars .= '<input type="hidden" name="aim" value="' . addslashes($aim) . '" />';

+ $s_hidden_vars .= '<input type="hidden" name="msn" value="' . addslashes($msn) . '" />';

+ $s_hidden_vars .= '<input type="hidden" name="yim" value="' . addslashes($yim) . '" />';

+ $s_hidden_vars .= '<input type="hidden" name="website" value="' . addslashes($website) . '" />';

+ $s_hidden_vars .= '<input type="hidden" name="location" value="' . addslashes($location) . '" />';

+ $s_hidden_vars .= '<input type="hidden" name="occupation" value="' . addslashes($occupation) . '" />';

+ $s_hidden_vars .= '<input type="hidden" name="interests" value="' . addslashes($interests) . '" />';

+ $s_hidden_vars .= '<input type="hidden" name="signature" value="' . addslashes($signature) . '" />';

+ $s_hidden_vars .= '<input type="hidden" name="viewemail" value="' . $viewemail . '" />';

+ $s_hidden_vars .= '<input type="hidden" name="notifypm" value="' . $notifypm . '" />';

+ $s_hidden_vars .= '<input type="hidden" name="notifyreply" value="' . $notifyreply . '" />';

+ $s_hidden_vars .= '<input type="hidden" name="attachsig" value="' . $attachsig . '" />';

+ $s_hidden_vars .= '<input type="hidden" name="allowhtml" value="' . $allowhtml . '" />';

+ $s_hidden_vars .= '<input type="hidden" name="allowbbcode" value="' . $allowbbcode . '" />';

+ $s_hidden_vars .= '<input type="hidden" name="allowsmilies" value="' . $allowsmilies . '" />';

+ $s_hidden_vars .= '<input type="hidden" name="hideonline" value="' . !$allowviewonline . '" />';

+ $s_hidden_vars .= '<input type="hidden" name="style" value="' . $user_style . '" />';

+ $s_hidden_vars .= '<input type="hidden" name="language" value="' . $user_lang . '" />';

+ $s_hidden_vars .= '<input type="hidden" name="timezone" value="' . $user_timezone . '" />';

+ $s_hidden_vars .= '<input type="hidden" name="dateformat" value="' . addslashes($user_dateformat) . '" />';

+

+ $template->assign_vars(array(

+ "L_AVATAR_GALLERY" => $lang['Avatar_gallery'],

+ "L_SELECT_AVATAR" => $lang['Select_avatar'],

+ "L_RETURN_PROFILE" => $lang['Return_profile'],

+ "L_CATEGORY" => $lang['Select_category'],

+

+ "S_OPTIONS_CATEGORIES" => $s_categories,

+ "S_COLSPAN" => $s_colspan,

+ "S_PROFILE_ACTION" => append_sid("profile.$phpEx?mode=$mode"),

+ "S_HIDDEN_FIELDS" => $s_hidden_vars)

+ );

+

+ }

+ }

+ else

+ if( !isset($coppa) )

+ {

+ $coppa = FALSE;

+ }

+ if( !isset($user_template) )

+ $selected_template = $board_config['system_template'];

+

+ $html_status = ($userdata['user_allowhtml']) ? $lang['ON'] : $lang['OFF'];

+ $bbcode_status = ($userdata['user_allowbbcode']) ? $lang['ON'] : $lang['OFF'];

+ $smilies_status = ($userdata['user_allowsmile']) ? $lang['ON'] : $lang['OFF'];

+

+ $signature = preg_replace("/\:[0-9a-z\:]*?\]/si", "]", $signature);

+

+ if( $user_avatar_type )

+ switch( $user_avatar_type )

+ {

+ case USER_AVATAR_UPLOAD:

+ $avatar_img = "<img src=\"" . $board_config['avatar_path'] . "/" . $user_avatar . "\" alt=\"\" />";

+ break;

+ case USER_AVATAR_REMOTE:

+ $avatar_img = "<img src=\"$user_avatar\" alt=\"\" />";

+ break;

+ case USER_AVATAR_GALLERY:

+ $avatar_img = "<img src=\"" . $board_config['avatar_gallery_path'] . "/" . $user_avatar . "\" alt=\"\" />";

+ break;

+ }

+ else

+ $avatar_img = "";

+ $s_hidden_fields = '<input type="hidden" name="mode" value="' . $mode . '" /><input type="hidden" name="agreed" value="true" /><input type="hidden" name="coppa" value="' . $coppa . '" />';

+ if( $mode == "editprofile" )

+ {

+ $s_hidden_fields .= '<input type="hidden" name="user_id" value="' . $userdata['user_id'] . '" />';

+ //

+ // Send the users current email address. If they change it, and account activation is turned on

+ // the user account will be disabled and the user will have to reactivate their account.

+ //

+ $s_hidden_fields .= '<input type="hidden" name="current_email" value="' . $userdata['user_email'] . '" />';

+ }

+

+ if( !empty($user_avatar_local) )

+ {

+ $s_hidden_fields .= '<input type="hidden" name="avatarlocal" value="' . $user_avatar_local . '" />';

+ }

+

+ include($phpbb_root_path . 'includes/page_header.'.$phpEx);

+

+ if( $error )

+ {

+ $template->set_filenames(array(

+ "reg_header" => "error_body.tpl")

+ );

+ $template->assign_vars(array(

+ "ERROR_MESSAGE" => $error_msg)

+ );

+ $template->pparse("reg_header");

+ }

+

+ $template->set_filenames(array(

+ "body" => "profile_add_body.tpl",

+ "jumpbox" => "jumpbox.tpl")

+ );

+

+ $jumpbox = make_jumpbox();

+ $template->assign_vars(array(

+ "L_GO" => $lang['Go'],

+ "L_JUMP_TO" => $lang['Jump_to'],

+ "L_SELECT_FORUM" => $lang['Select_forum'],

+

+ "S_JUMPBOX_LIST" => $jumpbox,

+ "S_JUMPBOX_ACTION" => append_sid("viewforum.$phpEx"))

+ );

+ $template->assign_var_from_handle("JUMPBOX", "jumpbox");

+

+ if( $mode == "editprofile" )

+ {

+ $template->assign_block_vars("edit_profile", array());

+ }

+

+ $template->assign_vars(array(

+ "USERNAME" => $username,

+ "EMAIL" => $email,

+ "YIM" => $yim,

+ "ICQ" => $icq,

+ "MSN" => $msn,

+ "AIM" => $aim,

+ "OCCUPATION" => $occupation,

+ "INTERESTS" => $interests,

+ "LOCATION" => $location,

+ "WEBSITE" => $website,

+ "SIGNATURE" => str_replace("<br />", "\n", $signature),

+ "VIEW_EMAIL_YES" => ($viewemail) ? "checked=\"checked\"" : "",

+ "VIEW_EMAIL_NO" => (!$viewemail) ? "checked=\"checked\"" : "",

+ "HIDE_USER_YES" => (!$allowviewonline) ? "checked=\"checked\"" : "",

+ "HIDE_USER_NO" => ($allowviewonline) ? "checked=\"checked\"" : "",

+ "NOTIFY_PM_YES" => ($notifypm) ? "checked=\"checked\"" : "",

+ "NOTIFY_PM_NO" => (!$notifypm) ? "checked=\"checked\"" : "",

+ "ALWAYS_ADD_SIGNATURE_YES" => ($attachsig) ? "checked=\"checked\"" : "",

+ "ALWAYS_ADD_SIGNATURE_NO" => (!$attachsig) ? "checked=\"checked\"" : "",

+ "NOTIFY_REPLY_YES" => ($notifyreply) ? "checked=\"checked\"" : "",

+ "NOTIFY_REPLY_NO" => (!$notifyreply) ? "checked=\"checked\"" : "",

+ "ALWAYS_ALLOW_BBCODE_YES" => ($allowbbcode) ? "checked=\"checked\"" : "",

+ "ALWAYS_ALLOW_BBCODE_NO" => (!$allowbbcode) ? "checked=\"checked\"" : "",

+ "ALWAYS_ALLOW_HTML_YES" => ($allowhtml) ? "checked=\"checked\"" : "",

+ "ALWAYS_ALLOW_HTML_NO" => (!$allowhtml) ? "checked=\"checked\"" : "",

+ "ALWAYS_ALLOW_SMILIES_YES" => ($allowsmilies) ? "checked=\"checked\"" : "",

+ "ALWAYS_ALLOW_SMILIES_NO" => (!$allowsmilies) ? "checked=\"checked\"" : "",

+ "ALLOW_AVATAR" => $board_config['allow_avatar_upload'],

+ "AVATAR" => $avatar_img,

+ "AVATAR_SIZE" => $board_config['avatar_filesize'],

+ "LANGUAGE_SELECT" => language_select($user_lang, 'language'),

+ "STYLE_SELECT" => style_select($user_style, 'style'),

+ "TIMEZONE_SELECT" => tz_select($user_timezone, 'timezone'),

+ "DATE_FORMAT" => $user_dateformat,

+ "HTML_STATUS" => $html_status,

+ "BBCODE_STATUS" => $bbcode_status,

+ "SMILIES_STATUS" => $smilies_status,

+

+ "L_CURRENT_PASSWORD" => $lang['Current_password'],

+ "L_NEW_PASSWORD" => ( $mode == "register" ) ? $lang['Password'] : $lang['New_password'],

+ "L_CONFIRM_PASSWORD" => $lang['Confirm_password'],

+ "L_PASSWORD_IF_CHANGED" => ($mode == "editprofile") ? $lang['password_if_changed'] : "",

+ "L_PASSWORD_CONFIRM_IF_CHANGED" => ($mode == "editprofile") ? $lang['password_confirm_if_changed'] : "",

+ "L_SUBMIT" => $lang['Submit'],

+ "L_RESET" => $lang['Reset'],

+ "L_ICQ_NUMBER" => $lang['ICQ'],

+ "L_MESSENGER" => $lang['MSNM'],

+ "L_YAHOO" => $lang['YIM'],

+ "L_WEBSITE" => $lang['Website'],

+ "L_AIM" => $lang['AIM'],

+ "L_LOCATION" => $lang['From'],

+ "L_OCCUPATION" => $lang['Occupation'],

+ "L_BOARD_LANGUAGE" => $lang['Board_lang'],

+ "L_BOARD_STYLE" => $lang['Board_style'],

+ "L_TIMEZONE" => $lang['Timezone'],

+ "L_DATE_FORMAT" => $lang['Date_format'],

+ "L_DATE_FORMAT_EXPLAIN" => $lang['Date_format_explain'],

+ "L_YES" => $lang['Yes'],

+ "L_NO" => $lang['No'],

+ "L_INTERESTS" => $lang['Interests'],

+ "L_ALWAYS_ALLOW_SMILIES" => $lang['Always_smile'],

+ "L_ALWAYS_ALLOW_BBCODE" => $lang['Always_bbcode'],

+ "L_ALWAYS_ALLOW_HTML" => $lang['Always_html'],

+ "L_HIDE_USER" => $lang['Hide_user'],

+ "L_ALWAYS_ADD_SIGNATURE" => $lang['Always_add_sig'],

+

+ "L_AVATAR_PANEL" => $lang['Avatar_panel'],

+ "L_AVATAR_EXPLAIN" => $lang['Avatar_explain'],

+ "L_UPLOAD_AVATAR_FILE" => $lang['Upload_Avatar_file'],

+ "L_UPLOAD_AVATAR_URL" => $lang['Upload_Avatar_URL'],

+ "L_UPLOAD_AVATAR_URL_EXPLAIN" => $lang['Upload_Avatar_URL_explain'],

+ "L_AVATAR_GALLERY" => $lang['Select_from_gallery'],

+ "L_SHOW_GALLERY" => $lang['View_avatar_gallery'],

+ "L_LINK_REMOTE_AVATAR" => $lang['Link_remote_Avatar'],

+ "L_LINK_REMOTE_AVATAR_EXPLAIN" => $lang['Link_remote_Avatar_explain'],

+ "L_DELETE_AVATAR" => $lang['Delete_Image'],

+ "L_CURRENT_IMAGE" => $lang['Current_Image'],

+

+ "L_SIGNATURE" => $lang['Signature'],

+ "L_SIGNATURE_EXPLAIN" => $lang['Signature_explain'],

+ "L_NOTIFY_ON_REPLY" => $lang['Always_notify'],

+ "L_NOTIFY_ON_REPLY_EXPLAIN" => $lang['Always_notify_explain'],

+ "L_NOTIFY_ON_PRIVMSG" => $lang['Notify_on_privmsg'],

+ "L_PREFERENCES" => $lang['Preferences'],

+ "L_PUBLIC_VIEW_EMAIL" => $lang['Public_view_email'],

+ "L_ITEMS_REQUIRED" => $lang['Items_required'],

+ "L_REGISTRATION_INFO" => $lang['Registration_info'],

+ "L_PROFILE_INFO" => $lang['Profile_info'],

+ "L_PROFILE_INFO_NOTICE" => $lang['Profile_info_warn'],

+ "L_EMAIL_ADDRESS" => $lang['Email_address'],

+

+ "L_HTML_IS" => $lang['HTML'] . " " . $lang['is'],

+ "L_BBCODE_IS" => $lang['BBCode'] . " " . $lang['is'],

+ "L_SMILIES_ARE" => $lang['Smilies'] . " " . $lang['are'],

+

+ "S_ALLOW_AVATAR_UPLOAD" => $board_config['allow_avatar_upload'],

+ "S_ALLOW_AVATAR_LOCAL" => $board_config['allow_avatar_local'],

+ "S_ALLOW_AVATAR_REMOTE" => $board_config['allow_avatar_remote'],

+ "S_HIDDEN_FIELDS" => $s_hidden_fields,

+ "S_PROFILE_ACTION" => append_sid("profile.$phpEx"))

+ );

+

+ //

+ // This is another cheat using the block_var capability

+ // of the templates to 'fake' an IF...ELSE...ENDIF solution

+ // it works well :)

+ //

+ if( $board_config['allow_avatar_upload'] || $board_config['allow_avatar_local'] || $board_config['allow_avatar_remote'] )

+ {

+ $template->assign_block_vars("avatarblock", array() );

+

+ if($board_config['allow_avatar_upload'])

+ {

+ $template->assign_block_vars("avatarblock.avatarupload", array() );

+ }

+ if($board_config['allow_avatar_remote'])

+ {

+ $template->assign_block_vars("avatarblock.avatarremote", array() );

+ }

+ if($board_config['allow_avatar_local'])

+ {

+ $template->assign_block_vars("avatarblock.avatargallery", array() );

+ }

+

+ }

+ <td class="row1">Avatar Gallery Path <br /><span class="gensmall">Path under your phpBB root dir for pre-loaded images, e.g. images/avatars/gallery</span></td>

+ <td class="row2"><input type="text" size="20" maxlength="255" name="avatar_gallery_path" value="{AVATAR_GALLERY_PATH}" /></td>

+ </tr>

+ <tr>

+

+<form action="{S_PROFILE_ACTION}" method="post">

+<table width="100%" cellspacing="2" cellpadding="2" border="0" align="center">

+ <tr>

+ <td align="left"><span class="nav"><a href="{U_INDEX}" class="nav">{SITENAME}&nbsp;{L_INDEX}</a></span></td>

+ </tr>

+</table>

+

+<table border="0" cellpadding="3" cellspacing="1" width="100%" class="forumline">

+ <tr>

+ <th class="thHead" colspan="{S_COLSPAN}" height="25" valign="middle">{L_AVATAR_GALLERY}</th>

+ </tr>

+ <tr>

+ <td class="catBottom" align="center" valign="middle" colspan="6" height="28"><span class="genmed">{L_CATEGORY}:&nbsp;<select name="avatarcategory">{S_OPTIONS_CATEGORIES}</select>&nbsp;<input type="submit" class="liteoption" value="{L_GO}" name="avatargallery" /></span></td>

+ </tr>

+ <!-- BEGIN avatar_row -->

+ <tr>

+ <!-- BEGIN avatar_column -->

+ <td class="row1" align="center"><img src="{avatar_row.avatar_column.AVATAR_IMAGE}" /></td>

+ <!-- END avatar_column -->

+ </tr>

+ <tr>

+ <!-- BEGIN avatar_option_column -->

+ <td class="row2" align="center"><input type="radio" name="avatarselect" value="{avatar_row.avatar_option_column.S_OPTIONS_AVATAR}" /></td>

+ <!-- END avatar_option_column -->

+ </tr>

+

+ <!-- END avatar_row -->

+ <tr>

+ <td class="catBottom" colspan="{S_COLSPAN}" align="center" height="28">{S_HIDDEN_FIELDS}

+ <input type="submit" name="submitavatar" value="{L_SELECT_AVATAR}" class="mainoption" />

+ &nbsp;&nbsp;

+ <input type="submit" name="cancelavatar" value="{L_RETURN_PROFILE}" class="liteoption" />

+ </td>

+ </tr>

+ </table>

+</form>

+$sql = "SELECT u.username, u.user_id, u.user_posts, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, p.*, pt.post_text, pt.post_subject

+ if( $postrow[$i]['user_avatar_type'] && $poster_id != ANONYMOUS )

+ switch( $postrow[$i]['user_avatar_type'] )

+ {

+ case USER_AVATAR_UPLOAD:

+ $poster_avatar = "<img src=\"" . $board_config['avatar_path'] . "/" . $postrow[$i]['user_avatar'] . "\" alt=\"\" />";

+ break;

+ case USER_AVATAR_REMOTE:

+ $poster_avatar = "<img src=\"" . $postrow[$i]['user_avatar'] . "\" alt=\"\" />";

+ break;

+ case USER_AVATAR_GALLERY:

+ $poster_avatar = "<img src=\"" . $board_config['avatar_gallery_path'] . "/" . $postrow[$i]['user_avatar'] . "\" alt=\"\" />";

+ break;

+ }