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
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
Last edited by HariSeldon; 10-06-20 at 02:31 PM.
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
Last edited by kingkc; 15-01-21 at 03:25 AM.