Disable premium account

[skronix]

How to disable premium account?


USE [Account]
GO
/****** Object: StoredProcedure [dbo].[cabal_tool_registerAccount_web] Script Date: 01/19/2018 00:42:40 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[cabal_tool_registerAccount_web] ( @id varchar(32), @password varchar(32), @email varchar(100), @question varchar(200),
@answer varchar(200),
@ip varchar(32)
)
AS
begin tran
declare @userNum as int

insert into cabal_auth_table( ID, Password, Login, AuthType, IdentityNo,email,question,answer,ip )
values @id, pwdencrypt @password), '0', 1, '7700000000000' @email @question,@answer,@ip )

set @userNum = @identity


insert into cabal_charge_auth(usernum, type, expiredate, payminutes)
values @userNum, 5, DATEADD(day, 1000, getdate()), 0)

insert into CabalCash..cashaccount (id,UserNum,Cash,CashBonus,UpdateDateTime) values @id @userNum,0,0,GETDATE())

select @userNum as usernum
commit

 

[walkernight88]

Change the highlighted parameter to the type of premium/free you want:

insert into cabal_charge_auth(usernum, type, expiredate, payminutes)
values userNum, 5, DATEADD(day, 1000, getdate()), 0)

 

[skronix]

Change the highlighted parameter to the type of premium/free you want:

Changed to 0, still nothing has changed

 

[walkernight88]

I hope you registered a new account. If you want to change the premium type on yours, you need to alter the table " cabal_charge_auth "...