Active Member Exygo 1091 Posted September 10, 2016 Active Member Share Posted September 10, 2016 Problem: Solution: Step 1: Open navicat -> player -> item_proto and Press CTRL + Q Step 2: Execute these queries: UPDATE item_proto SET shop_buy_price = gold; UPDATE item_proto SET shop_buy_price = (shop_buy_price * 1.40)-gold where gold > '0'; UPDATE item_proto SET shop_buy_price = gold-shop_buy_price where gold > '0'; Step 3: Update item_proto client side too, so you can see the sell price in client window Result: Let me know if that solved your problem 1 https://www.youtube.com/channel/UCQ8mAeda9TWq6SsTzB53emw/videos Link to comment Share on other sites More sharing options...
alondark 59 Posted September 10, 2016 Share Posted September 10, 2016 for txt ? Link to comment Share on other sites More sharing options...
Active Member Exygo 1091 Posted September 10, 2016 Author Active Member Share Posted September 10, 2016 No solution for that https://www.youtube.com/channel/UCQ8mAeda9TWq6SsTzB53emw/videos Link to comment Share on other sites More sharing options...
Premium tierrilopes 452 Posted September 10, 2016 Premium Share Posted September 10, 2016 48 minutes ago, alondark said: for txt ? Import txt into excell and then do a formula that does the same as query provided above. Link to comment Share on other sites More sharing options...
Denis 1474 Posted September 10, 2016 Share Posted September 10, 2016 1 hour ago, alondark said: for txt ? You can edit ProtoReader at db for that Link to comment Share on other sites More sharing options...
Active Member Exygo 1091 Posted October 26, 2016 Author Active Member Share Posted October 26, 2016 BUMP https://www.youtube.com/channel/UCQ8mAeda9TWq6SsTzB53emw/videos Link to comment Share on other sites More sharing options...
Garzard 2 Posted December 4, 2016 Share Posted December 4, 2016 Rly? Link to comment Share on other sites More sharing options...
Active Member Exygo 1091 Posted December 6, 2016 Author Active Member Share Posted December 6, 2016 UP https://www.youtube.com/channel/UCQ8mAeda9TWq6SsTzB53emw/videos Link to comment Share on other sites More sharing options...
Werwolf94 2 Posted May 14 Share Posted May 14 I allways use your command but what about Silver/Gold bars? It can cause problems when you mess with their selling price, so I allways run after your code this SQL command: UPDATE item_proto SET shop_buy_price = gold where vnum>=80003 and vnum<=80007; Link to comment Share on other sites More sharing options...
Recommended Posts