[HELP] [CN] Underage message

[marschlu]

Hi,

i need your help with this:
I get following message when i log-in.



How can i change the account that the message doesnt appear?

Thanks

[MentaL]

[aqua512]

You have to add an entry into tMinorsPlaytime. True = adult on row bIsAdult in Account database. This function cannot be removed. Add a script into your account creation page to auto add it. That is what I did.


EDIT: I added this to my signup page, INSERT INTO Account..tMinorsPlaytime (nUserNo, bIsAdult) VALUES ('" . $row["nUserNo"] . "', 'True');");

[hannesa]

You also could change the stored procedure "usp_China_getMinorsPlaytime" to

BEGIN
	SET NOCOUNT ON
/*	
	DECLARE @isAdult    bit
	DECLARE @Playtime   bigint
	DECLARE @logoutDate datetime
	
	SET @nRet = 0
	
	SELECT @isAdult = bIsAdult, @Playtime = nPlaytime, @logoutDate = dLogoutDate 
	  FROM tMinorsPlaytime WITH(UPDLOCK, HOLDLOCK)
	 WHERE nUserNo = @NuserNo
	IF @logoutDate IS NULL OR DATEADD(hour, 5, @logoutDate) <= GETDATE() BEGIN
		BEGIN TRAN
		
		SET @Playtime = 0
		
		UPDATE tMinorsPlaytime 
		   SET nPlaytime = @Playtime
		 WHERE nUserNo = @NuserNo
		IF @@ERROR <> 0 OR @@ROWCOUNT <> 1 BEGIN
			ROLLBACK TRAN
			SET @nRet = -1111
			RETURN
		END
		
		COMMIT TRAN
	END

	SELECT @isAdult AS bIsAdult, @Playtime AS nPlaytime
*/
	SELECT 1, 0  -- returns that the player is not underage and playtime is 0
END

This where already discussed. ;)