Service Premium

[sasuke]

does anyone have the query to set premium service to all users?

[MentaL_BOT]

[samus]

view cabal register account

[Onplay]

have any scrip qb give auto to all user ??????

[Onplay]

up .....

- - - Updated - - -

view cabal register account

how set ??????

[S37uP!Update]

cabal_tool_registerAccount

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

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

[Onplay]

error code ???????? how fix

[HariSeldon]

error code ???????? how fix

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

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

cabal_tool_registerAccount_web

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

[S37uP!Update]

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

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

cabal_tool_registerAccount_web

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

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...

[HariSeldon]

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.

[S37uP!Update]

You gave them a working code, but the crooked forum handler destroyed some characters and punctuation marks. Let's be honest.

Yeah that's why i said the code isn't working :)

[kingkc]

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