Deleting an item in all storages

[Mabuhay]

How do I delete all Existing Memory of Thanatos Card [Weapon]   Item ID# 4399 (Thanatos_Card) in my server? Thanks

[sandbox]

DELETE FROM inventory WHERE nameid=4399 OR card0=4399 OR card1=4399 OR card2=4399 OR card3=4399;
DELETE FROM cart_inventory WHERE nameid=4399 OR card0=4399 OR card1=4399 OR card2=4399 OR card3=4399;
DELETE FROM storage WHERE nameid=4399 OR card0=4399 OR card1=4399 OR card2=4399 OR card3=4399;
DELETE FROM guild_storage WHERE nameid=4399 OR card0=4399 OR card1=4399 OR card2=4399 OR card3=4399;
DELETE FROM mail WHERE nameid=4399 OR card0=4399 OR card1=4399 OR card2=4399 OR card3=4399;

 

Execute this query on your database, make sure to backup first.

[Toshiro]

DELETE FROM inventory WHERE nameid=4399 OR card0=4399 OR card1=4399 OR card2=4399 OR card3=4399;
DELETE FROM cart_inventory WHERE nameid=4399 OR card0=4399 OR card1=4399 OR card2=4399 OR card3=4399;
DELETE FROM storage WHERE nameid=4399 OR card0=4399 OR card1=4399 OR card2=4399 OR card3=4399;
DELETE FROM guild_storage WHERE nameid=4399 OR card0=4399 OR card1=4399 OR card2=4399 OR card3=4399;
DELETE FROM mail WHERE nameid=4399 OR card0=4399 OR card1=4399 OR card2=4399 OR card3=4399;

 

Execute this query on your database, make sure to backup first.

Instead of deleting all weapons that contain a Thanatos Card, you rather just remove the card from the weapon.

 

DELETE FROM `inventory` WHERE `nameid`=4399;
DELETE FROM `cart_inventory` WHERE `nameid`=4399;
DELETE FROM `storage` WHERE `nameid`=4399;
DELETE FROM `guild_storage` WHERE `nameid`=4399;
DELETE FROM `auction` WHERE `nameid`=4399;

UPDATE `inventory` SET `card0`=0 WHERE `card0`=4399;
UPDATE `inventory` SET `card1`=0 WHERE `card1`=4399;
UPDATE `inventory` SET `card2`=0 WHERE `card2`=4399;
UPDATE `inventory` SET `card3`=0 WHERE `card3`=4399;

UPDATE `cart_inventory` SET `card0`=0 WHERE `card0`=4399;
UPDATE `cart_inventory` SET `card1`=0 WHERE `card1`=4399;
UPDATE `cart_inventory` SET `card2`=0 WHERE `card2`=4399;
UPDATE `cart_inventory` SET `card3`=0 WHERE `card3`=4399;

UPDATE `storage` SET `card0`=0 WHERE `card0`=4399;
UPDATE `storage` SET `card1`=0 WHERE `card1`=4399;
UPDATE `storage` SET `card2`=0 WHERE `card2`=4399;
UPDATE `storage` SET `card3`=0 WHERE `card3`=4399;

UPDATE `guild_storage` SET `card0`=0 WHERE `card0`=4399;
UPDATE `guild_storage` SET `card1`=0 WHERE `card1`=4399;
UPDATE `guild_storage` SET `card2`=0 WHERE `card2`=4399;
UPDATE `guild_storage` SET `card3`=0 WHERE `card3`=4399;

UPDATE `mail` SET `nameid`=0, `amount`=0, `refine`=0, `attribute`=0, `identify`=0, `card0`=0, `card1`=0, `card2`=0, `card3`=0 WHERE `nameid`=4399;
UPDATE `mail` SET `card0`=0 WHERE `card0`=4399;
UPDATE `mail` SET `card1`=0 WHERE `card1`=4399;
UPDATE `mail` SET `card2`=0 WHERE `card2`=4399;
UPDATE `mail` SET `card3`=0 WHERE `card3`=4399;

UPDATE `auction` SET `card0`=0 WHERE `card0`=4399;
UPDATE `auction` SET `card1`=0 WHERE `card1`=4399;
UPDATE `auction` SET `card2`=0 WHERE `card2`=4399;
UPDATE `auction` SET `card3`=0 WHERE `card3`=4399;

Edited May 7, 2014 by Toshiro

[Mabuhay]

Thanks!