- Joined
- Oct 10, 2007
- Messages
- 1,772
- Reaction score
- 187
does anyone have the query to set premium service to all users?
Attachments
You must be registered for see attachments list
Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!
Join Today!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.