does anyone have the query to set premium service to all users?
Printable View
does anyone have the query to set premium service to all users?
view cabal register account
have any scrip qb give auto to all user ??????
cabal_tool_registerAccount
Code:USE [Account]
GO
/****** Object: StoredProcedure [dbo].[cabal_tool_registerAccount] Script Date: 6/9/2020 1:59:03 PM ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[cabal_tool_registerAccount] @id varchar(32), @password varchar(256))
AS
begin tran
declare @userNum as int
insert into cabal_auth_table( ID, Password, Login, AuthType, IdentityNo )
values @id, pwdencrypt(@password), '0', 1, '7700000000000' )
set @userNum = @identity
insert into cabal_charge_auth(usernum, type, expiredate, payminutes, servicekind)
values @userNum, 0, DATEADD(day, 1800, getdate()), 0, 1)
insert into CabalCash..cashaccount (id,UserNum,Cash,CashBonus,UpdateDateTime) values @id @userNum,0,1000,GETDATE())
select @userNum as usernum
commit
cabal_tool_registerAccount_web
Code:USE [Account]
GO
/****** Object: StoredProcedure [dbo].[cabal_tool_registerAccount_web] Script Date: 6/9/2020 2:00:14 PM ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[cabal_tool_registerAccount_web] ( @id varchar(32),
@password varchar(256), @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, servicekind)
values @userNum, 0, DATEADD(day, 1800, getdate()), 0, 1)
insert into CabalCash..cashaccount (id,UserNum,Cash,CashBonus,UpdateDateTime) values @id @userNum,0,0,GETDATE())
select @userNum as usernum
commit
1800 = DAYS = 5 YEARS
error code ???????? how fix
Attachment 167607
Remove the extra bracket in the specified line.
Make sure that you use this procedure during registration. Usually they use the ***_ web procedure, and the first script is not needed.
upd: The scripts really contain a lot of mistakes. Made corrections, but did not check. Check it out. If it does not work - write.I note that these scripts give a premium only to newly registered players.
cabal_tool_registerAccount
cabal_tool_registerAccount_webCode:USE [Account]
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[cabal_tool_registerAccount] ( @id varchar(32), @password varchar(256))
AS
begin tran
declare @userNum as int
insert into cabal_auth_table (ID, Password, Login, AuthType, IdentityNo)
values ( @id, pwdencrypt(@password), '0', 1, '7700000000000' )
set @userNum = @@identity
insert into cabal_charge_auth (usernum, type, expiredate, payminutes, servicekind)
values ( @userNum, 0, DATEADD(day, 1800, getdate()), 0, 1)
insert into CabalCash..cashaccount (id,UserNum,Cash,CashBonus,UpdateDateTime)
values ( @id, @userNum,0,0,GETDATE())
select @userNum as usernum
commit
Code:USE [Account]
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[cabal_tool_registerAccount_web] ( @id varchar(32), @password varchar(256), @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, servicekind)
values ( @userNum, 0, DATEADD(day, 1800, getdate()), 0, 1)
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] Script Date: 15/01/2021 11:12:11 am ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[cabal_tool_registerAccount] (@id varchar(32), @password varchar(256))
AS
begin tran
declare @userNum as int
insert into cabal_auth_table( ID, Password, Login, AuthType, IdentityNo )
values (@id, pwdencrypt(@password), '0', 1, '7700000000000' )
set @userNum = @@identity
insert into cabal_charge_auth(usernum, type, expiredate, payminutes, servicekind)
values @userNum, 0, DATEADD(day, 1800, getdate()), 0, 1)
insert into CabalCash..cashaccount (id,UserNum,Cash,CashBonus,UpdateDateTime) values(@id, @userNum, 0, 1000, GETDATE())
select @userNum as usernum
commit
--------------------------------------------------------------------------------------------------------------------------------------------------------
use that
next time use your logic side to overcome those wrongs syntax