Service Premium

Results 1 to 11 of 11
  1. #1
    Account Upgraded | Title Enabled! sasuke is offline
    True MemberRank
    Oct 2007 Join Date
    In your houseLocation
    1,265Posts

    Service Premium

    Service Premium
    does anyone have the query to set premium service to all users?
    Attached Thumbnails Attached Thumbnails Immagine.png  
    CentoS 7

    if I was helpful you can give me a like


  2. #2
    Hardcore Member samus is offline
    MemberRank
    Aug 2014 Join Date
    Managua, NicaraLocation
    103Posts

    Re: Service Premium

    view cabal register account

  3. #3
    Account Upgraded | Title Enabled! Onplay is offline
    True MemberRank
    Jun 2012 Join Date
    403Posts

    Re: Service Premium

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

  4. #4
    Account Upgraded | Title Enabled! Onplay is offline
    True MemberRank
    Jun 2012 Join Date
    403Posts

    Re: Service Premium

    up .....

    - - - Updated - - -

    Quote Originally Posted by samus View Post
    view cabal register account
    how set ??????

  5. #5
    wWw.F403.OrG S37uP!Update is offline
    True MemberRank
    Oct 2008 Join Date
    F403.ORGLocation
    1,180Posts

    Re: Service Premium

    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

  6. #6
    Account Upgraded | Title Enabled! Onplay is offline
    True MemberRank
    Jun 2012 Join Date
    403Posts

    Re: Service Premium

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

    Click image for larger version. 

Name:	errorcode.jpg 
Views:	26 
Size:	149.1 KB 
ID:	167607

  7. #7
    Hardcore Member HariSeldon is offline
    MemberRank
    Oct 2019 Join Date
    149Posts

    Re: Service Premium

    Quote Originally Posted by Onplay View Post
    error code ???????? how fix

    Click image for larger version. 

Name:	errorcode.jpg 
Views:	26 
Size:	149.1 KB 
ID:	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]     ( @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
    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.

  8. #8
    wWw.F403.OrG S37uP!Update is offline
    True MemberRank
    Oct 2008 Join Date
    F403.ORGLocation
    1,180Posts

    Re: Service Premium

    Quote Originally Posted by HariSeldon View Post
    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]     ( @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
    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
    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...

  9. #9
    Hardcore Member HariSeldon is offline
    MemberRank
    Oct 2019 Join Date
    149Posts

    Re: Service Premium

    Quote Originally Posted by S37uP!Update View Post
    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.

  10. #10
    wWw.F403.OrG S37uP!Update is offline
    True MemberRank
    Oct 2008 Join Date
    F403.ORGLocation
    1,180Posts

    Re: Service Premium

    Quote Originally Posted by HariSeldon View Post
    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 :)

  11. #11
    Registered kingkc is offline
    MemberRank
    Oct 2020 Join Date
    11Posts

    Re: Service Premium

    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.



Advertisement