Help with Replenish stock and cleanup damaged vehicles!

[Evention]

Hello

 

I have finally got my server setup and i thank you guys for taking your time in helping me. But there is one thing i need help with which is with the replenish stock and cleanup damaged vehicles. Where do i find this My.ini file i have found one in XAMPP which takes me to a word document is this the correct file.? And if it is how do i go about installing this because i'm new to doing epoch servers and i have only done normal dayz servers.

 

Cheers :)  

Replenish stock and cleanup damaged vehicles

http://dayzepoch.com/wiki/index.php?title=Server_Installation_Instructions_Extended

[Joerivang]

You will going to have to add the events in your database.

 

For example execute this query to set up vehicle clean up once a day:

CREATE EVENT removeDamagedVehicles
    ON SCHEDULE EVERY 1 DAY
    COMMENT 'Removes damaged vehicles'
    DO
      DELETE FROM `object_data` WHERE Damage = 1; 

When you execute the following SQL you'll set up a event to restock the traders once a day when the stock of an item is zero.

CREATE EVENT updateStockDaily
    ON SCHEDULE EVERY 1 DAY
    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'; 

Ofcourse you could make this code to run more than once a day.

[Evention]

Hello

 

Is their a manual way of doing this because my server is not 24 hours at the moment or will this is the best option.?