Change +10 Items in to +0

[Yoona]

Is there a chance that i can re-refine all the items in my server from +10 to +0 ?

[Moriarty]

Yeah, with a simple sql query you can do that.

Google about UPDATE.

It would be something like

UPDATE `inventory` SET `refine` = 0 WHERE `refine` = 10;

Don't forgot the other tables, like storage, cart_inventory..

[Yoona]

Yeah, with a simple sql query you can do that.

Google about UPDATE.

It would be something like

UPDATE `inventory` SET `refine` = 0 WHERE `refine` = 10;

Don't forgot the other tables, like storage, cart_inventory..

 

Im not that familiar with this.. but to make sure im gonna ask if this is correct..

 

UPDATE `inventory` SET `refine` = 0 WHERE `refine` = 10; // Check for Inventory

UPDATE `storage` SET `refine` = 0 WHERE `refine` = 10; // for storage

UPDATE `cart_inventory` SET `refine` = 0 WHERE `refine` = 10; // cart inventory

UPDATE `guild_storage` SET `refine` = 0 WHERE `refine` = 10; // cart guild storage

 

this will re-refine all the +10 items into +0 right?

[Moriarty]

Yeah, execute it on your phpmyadmin.

Backup your database first, if you're not sure.

It seens fine to me