Welcome!

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!

Service Premium

Joined
Oct 14, 2008
Messages
1,277
Reaction score
248
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]    [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


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]   ( [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




1800 = DAYS = 5 YEARS
 
Upvote 0
Elite Diviner
Joined
Jun 23, 2012
Messages
465
Reaction score
39
error code ???????? how fix

errorcode - Service Premium - RaGEZONE Forums
 

Attachments

You must be registered for see attachments list
Upvote 0
RaGEZONE VIP
[VIP] Member
Joined
Oct 10, 2019
Messages
198
Reaction score
426
error code ???????? how fix

View 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
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
 
Last edited:
Upvote 0
Joined
Oct 14, 2008
Messages
1,277
Reaction score
248
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

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...
 
Upvote 0
Initiate Mage
Joined
Oct 30, 2020
Messages
18
Reaction score
2
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:
Upvote 0
Back
Top