insufficient stock

[Booguy]

Hello to everyone,few days ago i had the problem withc traders.

When my players wanted to buy any vehicles,clothes,food they get the message "insufficient stock".

I tried to decide this problem in my database Trades_data and set more values in QTY. But it didn't help me.

 

Players still get the message "insufficient stock" when then tryed to buy for example "Skin_GUE_Soldier_Crew_DZ"

Also there isn't "Skin_GUE_Soldier_Crew_DZ" in my Trades_data

 

Sorry for my bad grammar,i hope somenody will help!

 

 

[wokkelwakker]

Server needs to be restarted to get the changes in the MySQL database to take effect on the server.

[Booguy]

don't work this

 

Server needs to be restarted to get the changes in the MySQL database to take effect on the server.

 

doesn't work it

and still have not "Skin_GUE_Soldier_Crew_DZ"  in traders_data and many items like a crowbar

(((

[Booguy]

Server needs to be restarted to get the changes in the MySQL database to take effect on the server.

i'm so sorry,i decide the problem thank you

[Black_Sheep]

Though you may have solved it, it sounded like you needed to run the SQL import again from https://raw.github.com/vbawol/DayZ-Epoch/master/Server%20Files/mysql/epoch.sql. It would be a good idea to also setup the scheduled SQL task that runs every day to restock the traders. This code is UPDATE `traders_data` SET qty= 10 WHERE qty=0 AND afile<>'trade_any_vehicle' AND afile<>'trade_any_boat'

[BetterDeadThanZed]

I have a daily event that sets stock to 1000 for everything. A bit excessive, sure, but I always have everything in stock.

[Booguy]

Though you may have solved it, it sounded like you needed to run the SQL import again from https://raw.github.com/vbawol/DayZ-Epoch/master/Server%20Files/mysql/epoch.sql. It would be a good idea to also setup the scheduled SQL task that runs every day to restock the traders. This code is UPDATE `traders_data` SET qty= 10 WHERE qty=0 AND afile<>'trade_any_vehicle' AND afile<>'trade_any_boat'

 

where i can find place in (navicat or heidi sql)  to update this code UPDATE `traders_data` SET qty= 10 WHERE qty=0 AND afile<>'trade_any_vehicle' AND afile<>'trade_any_boat

Thank you