L2J Server

Posted: **Sat Jun 12, 2010 4:51 pm**

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.

Posted: **Sat Jun 12, 2010 4:55 pm**

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.

Posted: **Sat Jun 12, 2010 5:22 pm**

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

Posted: **Sat Jun 12, 2010 5:31 pm**

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.

L2J Server

How to delete item for all characters/accounts

How to delete item for all characters/accounts

Re: How to delete item for all characters/accounts

Re: How to delete item for all characters/accounts

Re: How to delete item for all characters/accounts