Tutorial Guide add premium

[manyy]

I need a tutorial on how to remove and add a premium account

[MentaL]

[Stricted]

here my procedure for that

CREATE PROCEDURE [dbo].[cabal_tool_SetPremium]
			( @userNum int, @days int )
AS
BEGIN
	BEGIN TRAN
		SELECT * FROM cabal_charge_auth WHERE usernum = @userNum

		IF @@ROWCOUNT = 0
			BEGIN
				insert into cabal_charge_auth(usernum, type, expiredate, payminutes) values @userNum, 5, DATEADD(day, @days, getdate()), 0)
			END
		ELSE
			BEGIN
				update cabal_charge_auth set expiredate = DATEADD(day, @days, getdate()) where usernum = @userNum
			END
	COMMIT
END

[manyy]

how do I configure it?
I add days to date?

account 123123, type: 0

I click OK but nothing happens


account suck, type: 2

connect normal...

[manyy]

when the deadline is over, the game does not connect