//

if( $mode == "register" && !isset($HTTP_POST_VARS['agreed']) && !isset($HTTP_GET_VARS['agreed']) )

{

{

//

// Load agreement template since user has not yet

$passwd_sql = "";

if($mode == "editprofile")

{

{

$error = TRUE;

$error_msg = $lang['Wrong_Profile'];

$sql = "SELECT user_password

FROM " . USERS_TABLE . "

WHERE user_id = $user_id";

{

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

//

// Do a ban check on this email address

//

{

if( !validate_email($email) )

{

}

$username_sql = "";

{

{

{

$error = TRUE;

{

$error_msg .= "<br />";

}

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

{

$error = TRUE;

{

$error_msg .= "<br />";

}

}

}

{

//

// The AUTO_INCREMENT field in MySQL v3.23 doesn't work

//

$sql = "SELECT MAX(user_id) AS total

FROM " . USERS_TABLE;

{

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

$new_user_id = $row['total'] + 1;

$sql = "SELECT MAX(group_id) AS total

FROM " . GROUPS_TABLE;

{

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

$new_group_id = $row['total'] + 1;

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

{

$error = TRUE;

{

$error_msg .= "<br />";

}

if( isset($HTTP_POST_VARS['avatardel']) && $mode == "editprofile" )

{

{

}

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

}

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

{

{

{

$error_type = false;

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

$user_avatar_filetype = $user_avatar_filetype[1];

{

case "jpeg":

case "pjpeg":

break;

}

{

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

{

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

$avatar_filename = $user_id . $imgtype;

{

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

{

else

{

$error = true;

}

}

}

{

$error = true;

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

}

}

else

{

$error = true;

}

}

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

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

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

{

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

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

unset($avatar_data);

{

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

}

@fclose($fsock);

{

$file_size = $file_data[1];

$file_type = $file_data[2];

{

case "jpeg":

case "pjpeg":

break;

}

{

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

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

@fclose($fptr);

{

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

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

{

$avatar_filename = $user_id . $imgtype;

{

{

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

}

//

@unlink($tmp_filename);

$error = true;

}

}

else

// No data

//

$error = true;

}

}

else

// No connection

//

$error = true;

}

}

else

{

$error = true;

}

}

else if( !empty($user_avatar_name) )

{

$error = true;

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

}

}

else

{

$error = true;

}

}

}

}

}

{

{

{

$user_active = 0;

$user_actkey = generate_activation_key();

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_sig_bbcode_uid = '$signature_bbcode_uid', user_viewemail = $viewemail, user_aim = '$aim', user_yim = '$yim', user_msnm = '$msn', user_attachsig = $attachsig, user_allowsmile = $allowsmilies, user_allowhtml = $allowhtml, user_allowbbcode = $allowbbcode, user_allow_viewonline = $allowviewonline, user_notify = $notifyreply, user_notify_pm = $notifypm, user_timezone = $user_timezone, user_dateformat = '$user_dateformat', user_lang = '$user_lang', user_style = $user_style, user_active = $user_active, user_actkey = '$user_actkey'" . $avatar_sql . "

WHERE user_id = $user_id";

{

if( $user_active == 0 )

{

$sql .= "1, '')";

}

{

$sql = "INSERT INTO " . GROUPS_TABLE . " (group_id, group_name, group_description, group_single_user, group_moderator)

VALUES ($new_group_id, '', 'Personal User', 1, 0)";

$emailer->set_subject($lang['Welcome_subject']);

$emailer->extra_headers($email_headers);

{

$emailer->assign_vars(array(

"WELCOME_MSG" => $lang['Welcome_subject'],