Query to put everyone on the server vip

[David Vampiro]

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

those who are already playing.

[MentaL]

[Alphakilo23]

What do you mean by "vip"? Premium?

[David Vampiro]

That's right. =)

[emi]

read this http://forum.ragezone.com/f460/how-t...es-etc-452000/

[David Vampiro]

The players that I already put new start

but I would put those who already play

[MisterMinister]

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

[Alphakilo23]

You could use this query:

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.

[David Vampiro]

Thank Youuuuuuuuuuuuuuu!!!!!