kaeyih Posted July 5, 2021 Group: Members Topic Count: 12 Topics Per Day: 0.01 Content Count: 27 Reputation: 2 Joined: 10/08/20 Last Seen: July 3, 2024 Share Posted July 5, 2021 (edited) 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 Quote Link to comment Share on other sites More sharing options...
0 Emistry Posted August 25, 2021 Group: Forum Moderator Topic Count: 93 Topics Per Day: 0.02 Content Count: 10018 Reputation: 2369 Joined: 10/28/11 Last Seen: Thursday at 04:49 PM Share Posted August 25, 2021 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. Quote Link to comment Share on other sites More sharing options...
Question
kaeyih
I would like to do a global reset for everyone's EQ for refinary online and offline..
Edited by kaeyihAnyone has way to reset all EQ refines from SQL?
Link to comment
Share on other sites
1 answer to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.