How to delete item for all characters/accounts

[Anakin666]

Can someone tell me how can i delete same items for everyone ? in the DB or something.

What i'm saying is that i want to remove vesper items from my players cause it was custom aquired (with vesper shop exchanger ) and it unbalanced the server . Any help please? thx in advance.


LE: or replace them.

[janiii]

in database

Code: Select all

DELETE FROM items WHERE item_id IN (1,2,3,4);

where 1,2,3,4 are your item ids of vesper. the list of the item ids can be variable long.

[Anakin666]

thx ,but doesnt that delete vespers for good?

LE: nvm i saw that there is "ownerid" so i guess it deletes just from owners not server ,reply if im wrong,tyvm

[janiii]

the table items holds the information about items that are in possesion of players and clans, their warehouses.
there could be a leak if an item is as attachment in mail, but im am not sure how these are stored.