How to wipe specific card in sql

[Ace D Potgas]

Hi guys,

 

I wanted to reset the thanatos card that my player already have in the my ragnarok server. I already delete all the card that i found through the sql inventory, cart inventory,mail,storage. Unfortunately, i cant find a way how to reset the card from the player weapon. Is there anyone can help me on this part? I dont know how to reset the thanatos card that were equip on their weapon.  

[Emistry]

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

try this.

[Brian]

*4399

In addition to running the 4 SQL queries on the `inventory` table, you should also run them on

- auction

- cart_inventory

- guild_storage

- mail

- storage

[Ace D Potgas]

If i wanted to wipe a card on other part of equipment, for example headgear or garment? whats the command line in sql?

[Brian]

Searching the card0, card1, card2, card3 slots will find ALL equipment (weapons, headgear, and garments) with that card.

[Ace D Potgas]

thanks alot Brian.