- Joined
- Oct 10, 2007
- Messages
- 1,772
- Reaction score
- 187
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] [USER=19862]id[/USER] varchar(32), @password varchar(256))
AS
begin tran
declare [USER=1335]user[/USER]Num as int
insert into cabal_auth_table( ID, Password, Login, AuthType, IdentityNo )
values [USER=19862]id[/USER], pwdencrypt(@password), '0', 1, '7700000000000' )
set [USER=1335]user[/USER]Num = [USER=19862]id[/USER]entity
insert into cabal_charge_auth(usernum, type, expiredate, payminutes, servicekind)
values [USER=1335]user[/USER]Num, 0, DATEADD(day,[COLOR="#FF0000"] 1800[/COLOR], getdate()), 0, 1)
insert into CabalCash..cashaccount (id,UserNum,Cash,CashBonus,UpdateDateTime) values [USER=19862]id[/USER] [USER=1335]user[/USER]Num,0,1000,GETDATE())
select [USER=1335]user[/USER]Num as usernum
commit
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] ( [USER=19862]id[/USER] varchar(32),
@password varchar(256), [USER=213273]email[/USER] varchar(100), [USER=528823]question[/USER] varchar(200),
@answer varchar(200),
@ip varchar(32)
)
AS
begin tran
declare [USER=1335]user[/USER]Num as int
insert into cabal_auth_table( ID, Password, Login, AuthType, IdentityNo,email,question,answer,ip )
values [USER=19862]id[/USER], pwdencrypt(@password), '0', 1, '7700000000000' [USER=213273]email[/USER] [USER=528823]question[/USER],@answer,@ip )
set [USER=1335]user[/USER]Num = [USER=19862]id[/USER]entity
insert into cabal_charge_auth(usernum, type, expiredate, payminutes, servicekind)
values [USER=1335]user[/USER]Num, 0, DATEADD(day, [COLOR="#FF0000"]1800[/COLOR], getdate()), 0, 1)
insert into CabalCash..cashaccount (id,UserNum,Cash,CashBonus,UpdateDateTime) values [USER=19862]id[/USER] [USER=1335]user[/USER]Num,0,0,GETDATE())
select [USER=1335]user[/USER]Num as usernum
commit
Remove the extra bracket in the specified line.
USE [Account]
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[cabal_tool_registerAccount] ( @[I][B][URL="http://forum.ragezone.com/members/19862.html"]id[/URL][/B][/I] varchar(32), @password varchar(256))
AS
begin tran
declare @[I][B][URL="http://forum.ragezone.com/members/1335.html"]user[/URL][/B][/I]Num as int
insert into cabal_auth_table (ID, Password, Login, AuthType, IdentityNo)
values ( @[I][B][URL="http://forum.ragezone.com/members/19862.html"]id[/URL][/B][/I], pwdencrypt(@password), '0', 1, '7700000000000' )
set @[I][B][URL="http://forum.ragezone.com/members/1335.html"]user[/URL][/B][/I]Num = @@[I][B][URL="http://forum.ragezone.com/members/19862.html"]id[/URL][/B][/I]entity
insert into cabal_charge_auth (usernum, type, expiredate, payminutes, servicekind)
values ( @[I][B][URL="http://forum.ragezone.com/members/1335.html"]user[/URL][/B][/I]Num, 0, DATEADD(day, 1800, getdate()), 0, 1)
insert into CabalCash..cashaccount (id,UserNum,Cash,CashBonus,UpdateDateTime)
values ( @[I][B][URL="http://forum.ragezone.com/members/19862.html"]id[/URL],[/B][/I] @[I][B][URL="http://forum.ragezone.com/members/1335.html"]user[/URL][/B][/I]Num,0,0,GETDATE())
select @[I][B][URL="http://forum.ragezone.com/members/1335.html"]user[/URL][/B][/I]Num as usernum
commit
USE [Account]
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[cabal_tool_registerAccount_web] ( @[I][B][URL="http://forum.ragezone.com/members/19862.html"]id[/URL][/B][/I] varchar(32), @password varchar(256), @[I][B][URL="http://forum.ragezone.com/members/213273.html"]email[/URL][/B][/I] varchar(100), @[I][B][URL="http://forum.ragezone.com/members/528823.html"]question[/URL][/B][/I] varchar(200),@answer varchar(200),@ip varchar(32))
AS
begin tran
declare @[I][B][URL="http://forum.ragezone.com/members/1335.html"]user[/URL][/B][/I]Num as int
insert into cabal_auth_table (ID, Password, Login, AuthType, IdentityNo, email, question, answer, ip )
values ( @[I][B][URL="http://forum.ragezone.com/members/19862.html"]id[/URL][/B][/I], pwdencrypt(@password), '0', 1, '7700000000000', @[I][B][URL="http://forum.ragezone.com/members/213273.html"]email[/URL][/B][/I], @[I][B][URL="http://forum.ragezone.com/members/528823.html"]question[/URL][/B][/I], @answer, @ip )
set @[I][B][URL="http://forum.ragezone.com/members/1335.html"]user[/URL][/B][/I]Num = @@[I][B][URL="http://forum.ragezone.com/members/19862.html"]id[/URL][/B][/I]entity
insert into cabal_charge_auth (usernum, type, expiredate, payminutes, servicekind)
values ( @[I][B][URL="http://forum.ragezone.com/members/1335.html"]user[/URL][/B][/I]Num, 0, DATEADD(day, 1800, getdate()), 0, 1)
insert into CabalCash..cashaccount (id,UserNum,Cash,CashBonus,UpdateDateTime)
values ( @[I][B][URL="http://forum.ragezone.com/members/19862.html"]id[/URL],[/B][/I] @[I][B][URL="http://forum.ragezone.com/members/1335.html"]user[/URL][/B][/I]Num,0,0,GETDATE())
select @[I][B][URL="http://forum.ragezone.com/members/1335.html"]user[/URL][/B][/I]Num as usernum
commit
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
Code:USE [Account] GO SET ANSI_NULLS OFF GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[cabal_tool_registerAccount] ( @[I][B][URL="http://forum.ragezone.com/members/19862.html"]id[/URL][/B][/I] varchar(32), @password varchar(256)) AS begin tran declare @[I][B][URL="http://forum.ragezone.com/members/1335.html"]user[/URL][/B][/I]Num as int insert into cabal_auth_table (ID, Password, Login, AuthType, IdentityNo) values ( @[I][B][URL="http://forum.ragezone.com/members/19862.html"]id[/URL][/B][/I], pwdencrypt(@password), '0', 1, '7700000000000' ) set @[I][B][URL="http://forum.ragezone.com/members/1335.html"]user[/URL][/B][/I]Num = @@[I][B][URL="http://forum.ragezone.com/members/19862.html"]id[/URL][/B][/I]entity insert into cabal_charge_auth (usernum, type, expiredate, payminutes, servicekind) values ( @[I][B][URL="http://forum.ragezone.com/members/1335.html"]user[/URL][/B][/I]Num, 0, DATEADD(day, 1800, getdate()), 0, 1) insert into CabalCash..cashaccount (id,UserNum,Cash,CashBonus,UpdateDateTime) values ( @[I][B][URL="http://forum.ragezone.com/members/19862.html"]id[/URL],[/B][/I] @[I][B][URL="http://forum.ragezone.com/members/1335.html"]user[/URL][/B][/I]Num,0,0,GETDATE()) select @[I][B][URL="http://forum.ragezone.com/members/1335.html"]user[/URL][/B][/I]Num as usernum commit
cabal_tool_registerAccount_web
Code:USE [Account] GO SET ANSI_NULLS OFF GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[cabal_tool_registerAccount_web] ( @[I][B][URL="http://forum.ragezone.com/members/19862.html"]id[/URL][/B][/I] varchar(32), @password varchar(256), @[I][B][URL="http://forum.ragezone.com/members/213273.html"]email[/URL][/B][/I] varchar(100), @[I][B][URL="http://forum.ragezone.com/members/528823.html"]question[/URL][/B][/I] varchar(200),@answer varchar(200),@ip varchar(32)) AS begin tran declare @[I][B][URL="http://forum.ragezone.com/members/1335.html"]user[/URL][/B][/I]Num as int insert into cabal_auth_table (ID, Password, Login, AuthType, IdentityNo, email, question, answer, ip ) values ( @[I][B][URL="http://forum.ragezone.com/members/19862.html"]id[/URL][/B][/I], pwdencrypt(@password), '0', 1, '7700000000000', @[I][B][URL="http://forum.ragezone.com/members/213273.html"]email[/URL][/B][/I], @[I][B][URL="http://forum.ragezone.com/members/528823.html"]question[/URL][/B][/I], @answer, @ip ) set @[I][B][URL="http://forum.ragezone.com/members/1335.html"]user[/URL][/B][/I]Num = @@[I][B][URL="http://forum.ragezone.com/members/19862.html"]id[/URL][/B][/I]entity insert into cabal_charge_auth (usernum, type, expiredate, payminutes, servicekind) values ( @[I][B][URL="http://forum.ragezone.com/members/1335.html"]user[/URL][/B][/I]Num, 0, DATEADD(day, 1800, getdate()), 0, 1) insert into CabalCash..cashaccount (id,UserNum,Cash,CashBonus,UpdateDateTime) values ( @[I][B][URL="http://forum.ragezone.com/members/19862.html"]id[/URL],[/B][/I] @[I][B][URL="http://forum.ragezone.com/members/1335.html"]user[/URL][/B][/I]Num,0,0,GETDATE()) select @[I][B][URL="http://forum.ragezone.com/members/1335.html"]user[/URL][/B][/I]Num as usernum commit
You gave them a working code, but the crooked forum handler destroyed some characters and punctuation marks. Let's be honest.The code will not work, i just gave them example so they can look into they're table and just adjust how i did. Is so simple...
You gave them a working code, but the crooked forum handler destroyed some characters and punctuation marks. Let's be honest.