 	set @GroupIDMember = SCOPE_IDENTITY()	
 	
 	-- yaf_User
-	insert into yaf_User(BoardID,RankID,Name,Password,Joined,LastVisit,NumPosts,TimeZone,Email,Gender,Flags)
-	values(@BoardID,@RankIDGuest,'Guest','na',getdate(),getdate(),0,@TimeZone,@ForumEmail,0,6)
+	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,Gender,Flags)
-	values(@BoardID,@RankIDAdmin,@UserName,@UserPass,getdate(),getdate(),0,@TimeZone,@UserEmail,0,@UserFlags)
+	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

	@BoardID			int,
	@UserName			nvarchar(50) = null,
	@Email				nvarchar(50) = null,
	@Location			nvarchar(50) = null,
	@HomePage			nvarchar(50) = null,
	@TimeZone			int,
	@Avatar				nvarchar(255) = null,
	@LanguageFile		nvarchar(50) = null,
	@ThemeFile			nvarchar(50) = null,
	@OverrideDefaultTheme	bit = null,
	@Approved			bit = null,
	@MSN				nvarchar(50) = null,
	@YIM				nvarchar(30) = null,
	@AIM				nvarchar(30) = null,
	@ICQ				int = null,
	@RealName			nvarchar(50) = null,
	@Occupation			nvarchar(50) = null,
	@Interests			nvarchar(100) = null,
	@Gender				tinyint = 0,
	@Weblog				nvarchar(100) = null,
	@PMNotification		bit = null,
	@ProviderUserKey	uniqueidentifier = null,
    @WeblogUrl			nvarchar(256) = null,
    @WeblogUsername		nvarchar (256) = null,
    @WeblogID			nvarchar (50) = null) as
begin
	declare @RankID int
	declare @Flags int

	set @Flags = 0
	if @Approved<>0 set @Flags = @Flags | 2
	
	if @PMNotification is null SET @PMNotification = 1
	if @OverrideDefaultTheme is null SET @OverrideDefaultTheme=0

