possible to delete enchantment stones items using SQL commands?

[Kakaroto]

Hello everybody!

Well, I'm with a doubt one boring either, and I wonder if someone could help me, I was wondering if it is possible to delete enchantment stones items using SQL commands, but without deleting the item from the player, only the spells, you can ? if so, can give me the code?

I appreciate very much the same who can help

Edited November 5, 2016 by Akkarin
Topic title edited. Be more informative in the future, please.

[Cydh]

UPDATE `inventory` SET `card0` = 0 WHERE `card0` BETWEEN 4700 AND 4900;

repeat it for cart_inventory, storage, guild_storage, mail, auction

repeat it for card1, card2, and card3

[Jey]

1. Get all Enchantment Stone IDs:

(May be wrong or overlap with Card IDs. You need to check it)

egrep "^([^,]*,){3}6(,[^,]*){10},," db/re/item_db.txt | grep -o "^[^,]*" | tr '\n' ,

2. Stop your server.

 

3. Apply the update command:

UPDATE `inventory` SET `card0` = 0 WHERE `card0` IN (4700,4701,4702);
UPDATE `inventory` SET `card1` = 0 WHERE `card1` IN (4700,4701,4702);
UPDATE `inventory` SET `card2` = 0 WHERE `card2` IN (4700,4701,4702);
UPDATE `inventory` SET `card3` = 0 WHERE `card3` IN (4700,4701,4702);

This is just an example. You need to add all item ids you like to remove. And do the same for all other item tables like storage, mail, cart, etc.

[Kakaroto]

1. Get all Enchantment Stone IDs:

(May be wrong or overlap with Card IDs. You need to check it)

egrep "^([^,]*,){3}6(,[^,]*){10},," db/re/item_db.txt | grep -o "^[^,]*" | tr '\n' ,

2. Stop your server.

 

3. Apply the update command:

UPDATE `inventory` SET `card0` = 0 WHERE `card0` IN (4700,4701,4702);
UPDATE `inventory` SET `card1` = 0 WHERE `card1` IN (4700,4701,4702);
UPDATE `inventory` SET `card2` = 0 WHERE `card2` IN (4700,4701,4702);
UPDATE `inventory` SET `card3` = 0 WHERE `card3` IN (4700,4701,4702);

This is just an example. You need to add all item ids you like to remove. And do the same for all other item tables like storage, mail, cart, etc.

 

 

UPDATE `inventory` SET `card0` = 0 WHERE `card0` BETWEEN 4700 AND 4900;

repeat it for cart_inventory, storage, guild_storage, mail, auction

repeat it for card1, card2, and card3

 

 

Thank you so much !!!