Query to put everyone on the server vip

Results 1 to 8 of 8
  1. #1

    Query to put everyone on the server vip

    There is a query or program to everyone on the server by vip?

    those who are already playing.


  2. #2
    Account Upgraded | Title Enabled! Alphakilo23 is offline
    MemberRank
    Jun 2010 Join Date
    Ze German ländLocation
    428Posts

    Re: Query to put everyone on the server vip

    What do you mean by "vip"? Premium?

  3. #3

    Re: Query to put everyone on the server vip

    That's right. =)

  4. #4
    ANTI emi is offline
    MemberRank
    Mar 2009 Join Date
    ZHLocation
    1,378Posts

    Re: Query to put everyone on the server vip


  5. #5

    Re: Query to put everyone on the server vip

    The players that I already put new start

    but I would put those who already play

  6. #6
    Account Upgraded | Title Enabled! MisterMinister is offline
    MemberRank
    May 2009 Join Date
    Pontus FerrumLocation
    250Posts

    Re: Query to put everyone on the server vip

    Just get a GM-Tool (from Chumpy or balQ)..search for the Players/accounts they have,and Change the Account settings to Premium.

    As far as i know there isnt Any Script to make the Players who already playing to Premium..
    but if you are good on SQL,you could script it by yourself.

    Regards..

  7. #7
    Account Upgraded | Title Enabled! Alphakilo23 is offline
    MemberRank
    Jun 2010 Join Date
    Ze German ländLocation
    428Posts

    Re: Query to put everyone on the server vip

    You could use this query:
    Code:
    Update [account].[dbo].[cabal_charge_auth]
    SET [Type] = 1, 
    [ExpireDate] = '2012-01-01 00:00:00.000',
    [ServiceKind] = 1
    GO
    It gives every account that exists in your cabal_charge_auth table platinum premium ([ServiceKind] = 1).
    If you want new players, who registers after you executed the query, to have premium, too, you should carefully read what emi told you.

    Cheers.
    Last edited by Alphakilo23; 28-07-10 at 12:52 AM.

  8. #8

    Re: Query to put everyone on the server vip

    Thank Youuuuuuuuuuuuuuu!!!!!



Advertisement