How can i do this in phpmyadmin

[Dvrstle]

I want to wipe out TAO GUNKA CARD in my server. . . as well as those tao gunka cards that were already compounded in their armors. . thank you in advance =)

[Linkin Park]

tao gunka card item id: 4302

Execute the following query in your database

card0 is the first slot of the item

DELETE FROM `inventory` WHERE nameid=4302
UPDATE `inventory` SET card0=0 WHERE card0=4302
DELETE FROM `storage` WHERE nameid=4302
UPDATE `storage` SET card0=0 WHERE card0=4302
DELETE FROM `cart_inventory` WHERE nameid=4302
UPDATE `cart_inventory` SET card0=0 WHERE card0=4302

Edited June 25, 2012 by RaGERO

[Dvrstle]

and how about wiping thanatos card too . . . and replacing them with 12 pods per thanatos card =)

[Linkin Park]

just edit the update query and set the amount to whatever value you want.

[Dvrstle]

but how about the compounded one?

[Wolfeh]

Removing it completely, you remove the item from your item_db and mob_db. This way they cannot be obtained and does not exist in the game.

DELETE FROM `ragnarok`.`item_db` WHERE `id`='4302';
DELETE FROM `ragnarok`.`item_db` WHERE `id`='4399';
UPDATE `ragnarok`.`mob_db` SET `DropCardid`=0, `DropCardper`=0 WHERE `ID`='1583';
UPDATE `ragnarok`.`mob_db` SET `DropCardid`=0, `DropCardper`=0 WHERE `ID`='1708';

I'm afraid I don't know how to remove compounds or replace cards with an item. Another option would be to turn the cards into "vouchers" or "dummies" and have players exchange them for the "pods". With doing that, you can make it so the monster does not drop the card, and then just edit the card script so it has no effect, like so:

UPDATE `ragnarok`.`item_db` SET `name_english`='Tao_Gunka_Card_Voucher', `name_japanese`='Tao Gunka Card Voucher', `script`='' WHERE `id`='4302';
UPDATE `ragnarok`.`item_db` SET `name_english`='Thanatos_Card_Voucher', `name_japanese`='Thanatos Card Voucher', `script`='' WHERE `id`='4399';

Then make sure to edit idnum2itemdesctable.txt, num2itemdesctable.txt, num2itemdisplaynametable.txt, and idnum2itemdisplaynametable.txt so players are aware that the card does not have any effect.

#
4302#
This card no longer has any effect. Exchange it at the voucher NPC for items.
Class :^777777 Card^000000
Compound on :^777777 Armor^000000
Weight :^777777 1^000000

#
4399#
This card no longer has any effect. Exchange it at the voucher NPC for items.
Class :^777777 Card^000000
Compound on :^777777 Weapon^000000
Weight :^777777 1^000000

4302#Tao_Gunka_Card_Voucher#

4399#Thanatos_Card_Voucher#

[Asura]

Hi vlatag12,

You could do it with an in-game script... just make it run during login of character; this way you can provide the 12 pods to people with compounded cards, otherwise, I don't think there's a way you could really provide 12 pods for a compounded thanatos card via MySQL Query.