Had a boring day at work so I figured I'll rework the event schedule.
The new event server now allows you to set schedule in the database.
There is a new table and a new stored procedure to handle the schedules
EventSchedule - contains the schedule.
EventType column takes one of 4 values:
GUILD_TOURNAMENT - guild vs guild fight
CREATOR - resetting the schedule, it basically re-reads the data in the table. it's good for scheduling an event a day ahead and waiting for the event server to refresh itself.
RUBY_EYE - some monster spawn stuff, cant remember now
GOLDEN_INVASION - same, but with other monsters.
StartTime - time when the event starts to be announced.
Takes time in HH:MM format, like 09:55 or 13:55 for example
Changes required on your side:
update your settings.ini file with 3 new configuration values
dbName=GM Tool
dbLogin=your db login
dbPass=your db password
then you need to execute the 3 sql scripts found in the archive. it should be done in this order:
1. create table
2. insert into
3. create stored procedure
after that you can place the new Dekaron Event Server & sqlapi.dll in your event server folder.
I'm not hosting a server so I'm begging you guys for some testing and feedback....