Running "Mysql recommended events" using VertHosting

[Mystykall]

Can anyone explain to me how to do this? In the interface there is an "Event Scheduler" but putting the event into it gives an error about failing to create event. 

 

I've been trying to get deletenonkeyvehicle to run once a day at 4am(as well as the other events at different times etc). I have had no luck in doing so.

 

 

 

 

 

 

[Sukkaed]

Run sql query under your epoch database e.g.

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

[Mystykall]

Wow, thanks a ton, I can't believe it was that simple, I have been trying to make them through the dashboard...

[ThatGamer_Bullet]

I'm having a little trouble wrapping my mind around this process as well.

I have a successfully installed and accessible server and now I’m going through and adding some addons that I had hoped to give some people private experience with interacting with. And the

"D:\SteamLibraryD\SteamApps\common\ARMA 2 Operation Arrowhead\SQL\add_recommended_mysql_events.sql"

File appears to have some very useful scripting in it that I had assumed I wasn’t going without. But I haven’t done anything with the above mentioned file, and if it isn’t being referenced as-is, and I assume it isn’t getting utilized, then I was hoping someone could help me understand how to get these events added with the tools I have.

 

(Please forgive and feel free to correct any incorrect terminology, a lot of this server installation involved some pretty alien methods of data management to me)

 

I’ve been using Navicat for the SQL database, and XAMPP to host the SQL connection, but I also have the program MySQL from when I was researching building a database for a small business of a family member.

 

Anyway, on to an actual question, out of the three files in the SQL folder of the server, “add_recommended_mysql_events” and “1.0.4.2a_updates.sql” appear to be unused. When I open MySQL (for no better reason than a blind guess at how I might initialize or otherwise activate this “cleanup” scripting) and I connect to the SQL server I’m locally hosting, it plops me down at whats looks like line 1 of a blank text editor, or a command prompt. But I don’t wanna just start mucking about all willy nilly and ruin something I’ve been working on for two days in an obscure way that results in yet another reinstall of 25 gigs at this sub-par connection speed.

I've been creating a list of my steps as I go, with no margins, and 0 spacing...and I'm at page 12 now. So it's a little difficult to keep track of another unique set of commands and variables. But, I assume there are a set of commands for this interface in MySQL to manipulate the creation / removal of events stored in the SQL database?

And if thats the case, would I be typing out the entire "add_recommended_mysql_events" by hand into this prompt exactly as it was written?

I'm sure there is extensive documentation about the use of MySQL, but please humor me. I've spent the past 34 waking hours with 20-30 windows / programs open across two computers and three monitors. Any relief from my trial and error or research(which results in forgetting where I'm at in a number of other steps) would be immensely appreciated.

[BulletProofBill]

ello 

Sry I have enjoyed the playing side and left all of the scripting to my wife :p "Shes way better at it"

I made a couple of servers a few yrs ago but never delved into why the add_recomended_mysql_events.sql  wouldnt work  :\ 

So I spent a few hrs looking at the the problem and found the solution  

All you needed to do was separate the various Create Functions 

I have taken the liberty of doing this you can download them if you wish 

https://www.mediafire.com/folder/fvv8shrrvytgg/recommended_mysql_events

Edited October 29, 2016 by BulletProofBill
tired and messed up what i was writing