Account Freeze

[berkayata]

Can you give me Account Freeze codes ?

Not Quest.

[Benhero]

You mean the state to ban an account? If yes.. then change the value of the field "Status" to "block" without "".. If you just wan´t to freeze the account so change the field "availDt" to a date you want.

Greatz Benhero

[berkayata]

Originally Posted by Benhero

You mean the state to ban an account? If yes.. then change the value of the field "Status" to "block" without "".. If you just wan´t to freeze the account so change the field "availDt" to a date you want.

Greatz Benhero

I don't understand. Can you give the codes ?

[Benhero]

you must run it in mysql..

UPDATE account.account SET status = 'BLOCK' WHERE login = '>>>ACCOUNTNAME<<<';

This will block an account. You just have to change '>>>ACCOUNTNAME<<<' to the Account name of the Player (YOU´LL NEED THE ' ' <---!!!). If you want to Ban it with Player name use this here.

UPDATE account.account SET status = 'BLOCK' WHERE id = (SELECT account_id FROM player.player WHERE name = '>>>PLAYER_NAME<<<');

In this one you have to change '>>>PLAYER_NAME<<<' To the name you want to ban... You need the ' ' to..

Greatz Benhero
(Sry for my bad English )