R > Global Refine Reset method

[kaeyih]

I would like to do a global reset for everyone's EQ for refinary online and offline.. 
Anyone has way to reset all EQ refines from SQL? 

Edited July 5, 2021 by kaeyih

[Emistry]

shutdown the server, and run the following SQL query in your database.

UPDATE `auction` SET `refine` = 0;
UPDATE `cart_inventory` SET `refine` = 0;
UPDATE `guild_storage` SET `refine` = 0;
UPDATE `guild_storage_log` SET `refine` = 0;
UPDATE `inventory` SET `refine` = 0;
UPDATE `mail_attachments` SET `refine` = 0;
UPDATE `storage` SET `refine` = 0;

do a backup in case any unwanted result occured.