Wiping a specific item

[Mad Walker]

Does anyone know how to wipe a specific item to all players without disabling the item?

For example I want to wipe gtb from all players but I don't have to disable it from item_db

[RCharles]

Do it in sql by querying.

 SELECT <column_name> FROM inventory WHERE <cloumn_name> = '<item_id_number>;

this will display all that has eg. item no. 7777 in the inventory

to delete:

 DELETE FROM inventory WHERE <column_name> = <item_ID>;

Edited August 26, 2012 by RCharles

[Emistry]

run this in your SQL ...

make sure you do backup before use this ...

shutdown the server and run the query ....

DELETE FROM `cart_inventory` WHERE `nameid`=4128
DELETE FROM `inventory` WHERE `nameid`=4128
DELETE FROM `mail` WHERE `nameid`=4128
DELETE FROM `storage` WHERE `nameid`=4128

[Mad Walker]

Thanks for the reply!

[EvilPuncker]

UPDATE `inventory` SET card0=0 WHERE card0 = 4430;

UPDATE `inventory` SET card1=0 WHERE card1 = 4430;

UPDATE `inventory` SET card2=0 WHERE card2 = 4430;

UPDATE `inventory` SET card3=0 WHERE card3 = 4430;