Delete items from EVERYWHERE

[hxzr]

Is it possible to delete items of one kind from every player? To make sure I can edit it without someone secretly abusing it..

thru MYSQL? (tfs 036)

 

[Cykotitan]

DELETE FROM player_depotitems, player_items, tile_items WHERE itemtype = 2500;

 

[hxzr]

Am I missing out something obvious or what's up? (i assumed 2500 is the itemID

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE itemtype = 2500' at line 1

 

[Cykotitan]

ok try 3 queries then:

DELETE FROM `player_depotitems` WHERE `itemtype` = 2500;
DELETE FROM `player_items` WHERE `itemtype` = 2500;
DELETE FROM `tile_items` WHERE `itemtype` = 2500;

 

[hxzr]

god you're helpful o.o works perfectly!