 	set @Flags = 0
 	if @Approved<>0 set @Flags = @Flags | 2
 	
-	if @Location is not null and @Location = '' set @Location = null
-	if @HomePage is not null and @HomePage = '' set @HomePage = null
-	if @Avatar is not null and @Avatar = '' set @Avatar = null
-	if @MSN is not null and @MSN = '' set @MSN = null
-	if @YIM is not null and @YIM = '' set @YIM = null
-	if @AIM is not null and @AIM = '' set @AIM = null
-	if @ICQ is not null and @ICQ = 0 set @ICQ = null
-	if @RealName is not null and @RealName = '' set @RealName = null
-	if @Occupation is not null and @Occupation = '' set @Occupation = null
-	if @Interests is not null and @Interests = '' set @Interests = null
-	if @Weblog is not null and @Weblog = '' set @Weblog = null
-	if @WeblogUsername is not null and @WeblogUsername = '' set @WeblogUsername = null
-	if @WeblogID is not null and @WeblogID = '' set @WeblogID = null	
 	if @PMNotification is null SET @PMNotification = 1
 	if @OverrideDefaultTheme is null SET @OverrideDefaultTheme=0
 

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

		insert into dbo.yaf_User(BoardID,RankID,[Name],Password,Email,Joined,LastVisit,NumPosts,TimeZone,Gender,Flags,ProviderUserKey) 
		values(@BoardID,@RankID,@UserName,'-',@Email,getdate(),getdate(),0,0,0,@approvedFlag,@ProviderUserKey)
	
		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
