 	end
 	else begin
 		update yaf_User set
-			Location = @Location,
-			HomePage = @HomePage,
 			TimeZone = @TimeZone,
-			Avatar = @Avatar,
 			LanguageFile = @LanguageFile,
 			ThemeFile = @ThemeFile,
 			OverrideDefaultThemes = @OverrideDefaultTheme,
-			MSN = @MSN,
-			YIM = @YIM,
-			AIM = @AIM,
-			ICQ = @ICQ,
-			RealName = @RealName,
-			Occupation = @Occupation,
-			Interests = @Interests,
-			Gender = @Gender,
-			Weblog = @Weblog,
-			PMNotification = @PMNotification,
-			WeblogUrl = @WeblogUrl,
-			WeblogID = @WeblogID,
-			WeblogUsername = @WeblogUsername
+			PMNotification = @PMNotification
 		where UserID = @UserID
 		
 		if @Email is not null

		
		select @RankID = RankID from yaf_Rank where (Flags & 1)<>0 and BoardID=@BoardID

		insert into yaf_User(BoardID,RankID,Name,Password,Email,Joined,LastVisit,NumPosts,Location,HomePage,TimeZone,Avatar,Gender,Flags,PMNotification,ProviderUserKey,WeblogUrl,WeblogUsername,WeblogID) 
		values(@BoardID,@RankID,@UserName,'-',@Email,getdate(),getdate(),0,@Location,@HomePage,@TimeZone,@Avatar,@Gender,@Flags,@PMNotification,@ProviderUserKey,@WeblogUrl,@WeblogUsername,@WeblogID)		
	
		set @UserID = SCOPE_IDENTITY()


	set @GroupIDMember = SCOPE_IDENTITY()	
	
	-- yaf_User
	insert into yaf_User(BoardID,RankID,Name,Password,Joined,LastVisit,NumPosts,TimeZone,Email,Flags)
	values(@BoardID,@RankIDGuest,'Guest','na',getdate(),getdate(),0,@TimeZone,@ForumEmail,6)
	set @UserIDGuest = SCOPE_IDENTITY()	
	
	SET @UserFlags = 2
	if @IsHostAdmin<>0 SET @UserFlags = 3
	
	insert into yaf_User(BoardID,RankID,Name,Password,Joined,LastVisit,NumPosts,TimeZone,Email,Flags)
	values(@BoardID,@RankIDAdmin,@UserName,@UserPass,getdate(),getdate(),0,@TimeZone,@UserEmail,@UserFlags)
	set @UserIDAdmin = SCOPE_IDENTITY()

	-- yaf_UserGroup
