Yoona Posted July 9, 2014 Group: Members Topic Count: 153 Topics Per Day: 0.04 Content Count: 567 Reputation: 18 Joined: 04/15/13 Last Seen: April 21, 2016 Share Posted July 9, 2014 Is there a chance that i can re-refine all the items in my server from +10 to +0 ? Quote Link to comment Share on other sites More sharing options...
Moriarty Posted July 9, 2014 Group: Members Topic Count: 27 Topics Per Day: 0.01 Content Count: 135 Reputation: 13 Joined: 06/20/12 Last Seen: April 14, 2018 Share Posted July 9, 2014 Yeah, with a simple sql query you can do that. Google about UPDATE.It would be something likeUPDATE `inventory` SET `refine` = 0 WHERE `refine` = 10;Don't forgot the other tables, like storage, cart_inventory.. Quote Link to comment Share on other sites More sharing options...
Yoona Posted July 10, 2014 Group: Members Topic Count: 153 Topics Per Day: 0.04 Content Count: 567 Reputation: 18 Joined: 04/15/13 Last Seen: April 21, 2016 Author Share Posted July 10, 2014 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? Quote Link to comment Share on other sites More sharing options...
Moriarty Posted July 10, 2014 Group: Members Topic Count: 27 Topics Per Day: 0.01 Content Count: 135 Reputation: 13 Joined: 06/20/12 Last Seen: April 14, 2018 Share Posted July 10, 2014 Yeah, execute it on your phpmyadmin.Backup your database first, if you're not sure.It seens fine to me Quote Link to comment Share on other sites More sharing options...
Question
Yoona
Is there a chance that i can re-refine all the items in my server from +10 to +0 ?
Link to comment
Share on other sites
3 answers 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.