trader issues Epoch Panthera

[1LT]

anyone know how to auto update the traders so they either never run out or they update everything on server restart,

 

 

If you guys could help that would be great as its annoying as hell having to retype this on every post I do due to CTRL C & CTRL V being disabled..grrrr

 

 

Thanks in advance

[calamity]

DROP EVENT IF EXISTS updateStockDaily; CREATE EVENT updateStockDaily ON SCHEDULE EVERY 1 DAY COMMENT 'Updates out of stock vendors' DO UPDATE `traders_data` SET qty=100 WHERE qty=0 AND afile<>'trade_any_vehicle' AND afile<>'trade_any_boat'; ;

 

 

or 

 

UPDATE `Traders_DATA` SET qty = 10 WHERE qty < 10

 

or

 

UPDATE `Traders_DATA` SET qty=10 WHERE qty=0 AND afile<>'trade_any_vehicle' AND afile<>'trade_any_boat';

 

 

You may have to rename Traders_DATA to traders_data

mine is CAPS

[1LT]

Thanks for replying but where and what do you add all this too? sorry we are new to the dayz side of things so a little more of a help in hand would be great if possible...

 

 

Regards and thanks in advance

[calamity]

you add it too the database. its different process for different database programs.

in heidi I add it to the query tab window and press execute or f9