Feistz Posted December 19, 2011 Group: Members Topic Count: 14 Topics Per Day: 0.00 Content Count: 139 Reputation: 10 Joined: 11/10/11 Last Seen: August 22, 2022 Share Posted December 19, 2011 How do I reduce all +20 Equipments to +10 only? SQL based or what? Or i need to reduce it 1 by 1? Thanks help! Quote Link to comment Share on other sites More sharing options...
Emistry Posted December 19, 2011 Group: Forum Moderator Topic Count: 93 Topics Per Day: 0.02 Content Count: 10015 Reputation: 2348 Joined: 10/28/11 Last Seen: Monday at 01:58 PM Share Posted December 19, 2011 erm..if SQL Based... try run this Query...hope it work well for you~ UPDATE `inventory` SET refine = 10 WHERE refine > 10; Quote Link to comment Share on other sites More sharing options...
gfxmrmark Posted December 19, 2011 Group: Members Topic Count: 16 Topics Per Day: 0.00 Content Count: 148 Reputation: 8 Joined: 11/20/11 Last Seen: September 12, 2013 Share Posted December 19, 2011 @refine -0 10? so your item will be +10 only Quote Link to comment Share on other sites More sharing options...
Feistz Posted December 19, 2011 Group: Members Topic Count: 14 Topics Per Day: 0.00 Content Count: 139 Reputation: 10 Joined: 11/10/11 Last Seen: August 22, 2022 Author Share Posted December 19, 2011 (edited) What i mean is, I want it for all players in my server. Like all Equipments and Weapons will be downgraded from +20 to +10 erm..if SQL Based... try run this Query...hope it work well for you~ UPDATE `inventory` SET refine = 10 WHERE refine > 10; Thanks Emistry! Gonna try it Edited December 19, 2011 by Feistz Quote Link to comment Share on other sites More sharing options...
Question
Feistz
How do I reduce all +20 Equipments to +10 only? SQL based or what? Or i need to reduce it 1 by 1?
Thanks help!
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.