- Joined
- Apr 9, 2014
- Messages
- 143
- Reaction score
- 19
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
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