I am having an issue with the inventory of some the Traders on my Epoch server. This is on a Vilayer server.
I see in the database there is an updateStockDaily event that runs daily, but for some reason players are still getting insufficient stock notices when trying to buy some items.
CREATE DEFINER=`vilayer`@`%` EVENT `updateStockDaily`
ON SCHEDULE
EVERY 1 DAY STARTS '2014-07-07 12:31:49'
ON COMPLETION NOT PRESERVE
ENABLE
COMMENT 'Updates out of stock vendors'
DO UPDATE `Traders_DATA` SET qty=10 WHERE qty=0 AND afile<>'trade_any_vehicle' AND afile<>'trade_any_boat'
Is there somewhere that I can view their inventory?
Is there an explanation to this? - I don't know much about SQL, so your input would be greatly appreciated.
Question
Molon Labe
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now