Removed all refined items

[chrono01]

Title typo: 

Remove* all refined items

 

Hello. Is there anyway to remove ALL refined items around my server? We just released earlier then we disabled the refine so no one can + their weapons/armors first. But I didn't thought of whitesmiths/blacksmiths. I just removed the refiners not thinking blacksmiths can also refine. ~_~ 

 

Also how can I edit the item id required for the skill refine on blacksmiths?

Edited December 14, 2013 by chrono01

[Shio Devs]

So what your asking is how to de-refine everything that's currently refined in your server? And as for skill what are you asking? to add and item requirement to use the skill?

[chrono01]

Yes.

As for the skill, I want to change the item ID for the weapon refine to a custom one.

[Shio Devs]

i'm not 100% sure on this, but i believe you can refine something equipped to a character, that might be your best method, via sql.

[chrono01]

How about this one? http://rathena.org/board/topic/90578-editing-item-required-for-weapon-refine-skill-on-blacksmiths/

[Emistry]

DELETE FROM `inventory` WHERE `refine` > 0;
DELETE FROM `storage` WHERE `refine` > 0;
DELETE FROM `cart_inventory` WHERE `refine` > 0;
DELETE FROM `mail` WHERE `refine` > 0;
DELETE FROM `guild_storage` WHERE `refine` > 0; 

shutdown server and run these query.

[chrono01]

Thanks emistry. How about changing the item requirements for Weapon Refine skill?