game_event
Structure
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| eventEntry | tinyint | unsigned | PRI | NO | Entry of the game event | ||
| start_time | timestamp | YES | NULL | Absolute start date, the event will never start before | |||
| end_time | timestamp | YES | NULL | Absolute end date, the event will never start after | |||
| occurence | bigint | unsigned | NO | 5184000 | Delay in minutes between occurences of the event | ||
| length | bigint | unsigned | NO | 2592000 | Length in minutes of the event | ||
| holiday | int | unsigned | NO | 0 | Client side holiday id | ||
| holidayStage | tinyint | unsigned | NO | 0 | |||
| description | varchar(255) | YES | NULL | Description of the event displayed in console | |||
| world_event | tinyint | unsigned | NO | 0 | 0 if normal event, 1 if world event | ||
| announce | tinyint | unsigned | YES | 2 | 0 dont announce, 1 announce, 2 value from config | ||
Description of fields
eventEntry
Entry of the event. Keep it as low as possible and prevent making holes in the list.
start_time
Absolute start date of the event. The event will start occurring only if the local time at the server is after the one set here.
end_time
Absolute end date of the event. The event will stop occurring if the local time at the server is after the one set here.
occurence
Number of minutes between 2 occurrences of the event. (2880 = 2 days, 1440 = 1 day, etc).
length
Number of minutes the event will last after the start of the occurrence. (2880 = 2 days, 1440 = 1 day, etc) This value must be lower than occurrence one or the event will never stop.
holiday
HolidayID from Holidays.db2
holidayStage
Index of the main event stage. (see HolidayDuration)
(e.g.: Darkmoon Faire has a preparation stage where it sets up.)
min.: 1 - max.: MAX_HOLIDAY_DURATIONS (10)
description
String containing the name of the event displayed in console each time it starts or stops.
world_event
This is a boolean field that determines if this game event is a world event or not. 0 = normal event, 1 = world event. If you want conditions for the event, you need to choose world event. For the world event to work, you need to at a minimum, populate game_event_condition and game_event_quest_condition.
announce
| Value | Description |
|---|---|
| 0 | Don't announce |
| 1 | Announce |
| 2 | Use value of Event.Announce in worldserver.conf |