DATABASE COMAND* REPP U ++ [help] easy

[Discovery]

The command used to delete certain items from the database. Example I want to delete the money from the server. Thanks rep + up +
:w00t:

 

[Summ]

DELETE FROM player_items WHERE itemtype = 2160 or itemtype = 2152 or itemtype = 2148;
UPDATE players SET balance = 0;

First line deletes all gold, platinum and crystal coins, second line resets players' balance (if you use bank system)

 

[Zoom Iker]

DELETE FROM player_items WHERE itemtype = 2160 or itemtype = 2152 or itemtype = 2148;
UPDATE player SET balance = 0;

First line deletes all gold, platinum and crystal coins, second line resets players' balance (if you use bank system)

thanks, I needed

 

[Zonet]

DELETE FROM player_items WHERE itemtype = 2160 or itemtype = 2152 or itemtype = 2148;
UPDATE player SET balance = 0;

First line deletes all gold, platinum and crystal coins, second line resets players' balance (if you use bank system)

Second line should be:

UPDATE `players` SET `balance` = 0;

s

 

[Summ]

edited thx