So I'm trying to modify the price of an item across all vendors (specifically fly wings, which as far as I'm aware is item id 601). I've modified the "price_buy" column for that entry in item_db_re using MySQL Workbench (and I've made other modifications to other tables unrelated to shop npcs that I know have worked, so it isn't a tool issue). I've also modified the same value in item_db, though I assume that table isn't used as my server is renewal, figured I'd try it just to be sure anyway. From looking through merchant .txt files, every merchant that sells item 601 lists it as using the price -1 (unless I'm terribly misreading the merchant .txt files, which is entirely possible I suppose), which if I'm not mistaken should mean they reference the database for the price. Yet, with my price_buy set at, say 10, all vendors continue to sell them at the price of 250, the original price.
Do shop prices get cached somewhere that I need to modify or make it re-cache that data, am I misreading the txt files for merchants, or is there another database table I need to modify or what?
Question
Denthorn_
So I'm trying to modify the price of an item across all vendors (specifically fly wings, which as far as I'm aware is item id 601). I've modified the "price_buy" column for that entry in item_db_re using MySQL Workbench (and I've made other modifications to other tables unrelated to shop npcs that I know have worked, so it isn't a tool issue). I've also modified the same value in item_db, though I assume that table isn't used as my server is renewal, figured I'd try it just to be sure anyway. From looking through merchant .txt files, every merchant that sells item 601 lists it as using the price -1 (unless I'm terribly misreading the merchant .txt files, which is entirely possible I suppose), which if I'm not mistaken should mean they reference the database for the price. Yet, with my price_buy set at, say 10, all vendors continue to sell them at the price of 250, the original price.
Do shop prices get cached somewhere that I need to modify or make it re-cache that data, am I misreading the txt files for merchants, or is there another database table I need to modify or what?
Link to comment
Share on other sites
2 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.