Admin NPC To Delete Item from everyone inventory/Storage either player is Online or Offline

[Dolphin86]

Welp as title, anyone can help me? i would like to remove some bugged item that most my player have been using on my server,

example, i talk to NPC and enter the item ID i want to delete, and everyone either his/her online or offline the item will be deleted 

not matter where they put it, in inventory, equipped or in storage 

[Emistry]

DELETE FROM `auction` WHERE `nameid` = 512;
DELETE FROM `cart_inventory` WHERE `nameid` = 512;
DELETE FROM `guild_storage` WHERE `nameid` = 512;
DELETE FROM `inventory` WHERE `nameid` = 512;
DELETE FROM `mail_attachments` WHERE `nameid` = 512;
DELETE FROM `market` WHERE `nameid` = 512;
DELETE FROM `sales` WHERE `nameid` = 512;
DELETE FROM `storage` WHERE `nameid` = 512;

1. shutdown server
2. edit the item ID
3. run the queries above in your database
4. restart server

[Dolphin86]

17 minutes ago, Emistry said:

DELETE FROM `auction` WHERE `nameid` = 512;
DELETE FROM `cart_inventory` WHERE `nameid` = 512;
DELETE FROM `guild_storage` WHERE `nameid` = 512;
DELETE FROM `inventory` WHERE `nameid` = 512;
DELETE FROM `mail_attachments` WHERE `nameid` = 512;
DELETE FROM `market` WHERE `nameid` = 512;
DELETE FROM `sales` WHERE `nameid` = 512;
DELETE FROM `storage` WHERE `nameid` = 512;

1. shutdown server
2. edit the item ID
3. run the queries above in your database
4. restart server

512 is the item ID? what if i want to add multiple item to delete?

[Emistry]

change the itemID after every execution ...

or use this

DELETE FROM `auction` WHERE `nameid` IN (501,502,503);
DELETE FROM `cart_inventory` WHERE `nameid` IN (501,502,503);
DELETE FROM `guild_storage` WHERE `nameid` IN (501,502,503);
DELETE FROM `inventory` WHERE `nameid` IN (501,502,503);
DELETE FROM `mail_attachments` WHERE `nameid` IN (501,502,503);
DELETE FROM `market` WHERE `nameid` IN (501,502,503);
DELETE FROM `sales` WHERE `nameid` IN (501,502,503);
DELETE FROM `storage` WHERE `nameid` IN (501,502,503);

 

[Dolphin86]

@Emistry just run on sql date base of my ragnarok correct?