How to get events to run in sql database

[Achmed]

I have tried to get events running in my sql database to remove destroyed vehicles, dead players and also set the stock level to 10 every morning at 9am.

 

creating the events is not a problem but they dont appear to be running.

 

Can someone tell me what i need to do to get them running? I am running a VIlayer server not dedicated so cant do bat files etc.

[maca134]

How have you done this?

 

The epoch event system doesn't use the database at all (there is a hive call but its to get the current time from the system). That's not to say the mission file itself couldn't use the database in some way.

[MGT]

I use these to remove broken vehicles and update trader stock in Navicat, called at server restart using .\SQL\bin\mysql.exe --user=******* --password=******--host=127.0.0.1 --port=***** --database=dayz_epoch --execute="call pMain()"

 

Obviously you would have to edit that to suit your database parameters and if you can't access the startup file then this is of no use.

UPDATE `traders_data` SET qty=99 WHERE  qty<99

DELETE
    FROM object_data
    WHERE Damage = '1'

I call these both from a procedure called pMain, contents of which are

BEGIN


    CALL pCleanup();
    CALL refill;


END

[vbawol]

You may need to ask the host to enable the mysql event scheduler, If your using phpmyadmin it should show what the status ON/OFF on the events page.

[Achmed]

i dont have phpmyadmin, i use HeidiSQL to connect.

 

where would i find the status?

 

 

i have asked my host to enable the mysql event scheduler so hopefully its as simple as that

[Achmed]

Have just heard back from vilayer. I have full access to the mysql so can enable it in my.ini..... but they didnt tell me how lol.

Anyone know what i need to put in to enable it? (Prob get a answer faster here)

[Bombi]

Did you find out where to enable it?

[Achmed]

yes but its getting over wrote by another file. vilayer support are looking into it