Search for item and delete it.

[enriel]

Is it possible to search for example item ID : 1111 then delete it from every player in database?

 

[SpiderOT]

DELETE FROM player_depotitems, player_items, tile_items WHERE itemtype = [COLOR="Red"]ID[/COLOR];

change id to the id of any item you want

 

[Icy]

Thanks for this, repped up

This'll help me make a smooth transfer over from normal items into donator items incase anyone has any xD

EDIT: Hmm, it's not working; does the server have to be offline?
EDIT2: ah okay nvm, I had to run each query seperately instead of altogether for some reason..