I'm a complete maroon when it comes to SQL (I barely scrape on by when it comes to scripting for the server!)
Creating an event and scheduling it to occur with navicat to restock the traders and remove destroyed vehicles is no problem. I've got that in and working... But the cleanup of unused items is giving me all sorts of problems.
I dont know how or what to do what anything in that Server Installation Instructions Extended.
I went into my.ini and turned on the event_scheduler (i think)
When i run the sql query SET GLOBAL event_scheduler = 1;
I get this....
[SQL] SET GLOBAL event_scheduler = 1;
Affected rows: 0
Time: 0.000ms
So I assume that it's working but then if I were to hit Explain (not sure if i should be doing that or not, but I did it because the next steps dont work either!)
EXPLAIN SET GLOBAL event_scheduler = 1;
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SET GLOBAL event_scheduler = 1' at line 1
If i try to execute those sql's then i get this....
Question
FAQdaWorld
Can someone make like an idiots guide to this?
http://dayzepoch.com/wiki/index.php?title=Server_Installation_Instructions_Extended
I'm a complete maroon when it comes to SQL (I barely scrape on by when it comes to scripting for the server!)
Creating an event and scheduling it to occur with navicat to restock the traders and remove destroyed vehicles is no problem. I've got that in and working... But the cleanup of unused items is giving me all sorts of problems.
I dont know how or what to do what anything in that Server Installation Instructions Extended.
I went into my.ini and turned on the event_scheduler (i think)
When i run the sql query SET GLOBAL event_scheduler = 1;
I get this....
If i try to execute those sql's then i get this....
If i try to run this on the entire database (127.0.0.1) i get this...
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now