game_event

Table Structure

This table holds definitions for all game events that are activated or deactivated automatically by the Game Event System in the core.

Field

Type

Attributes

Key

Null

Default

Extra

Comment

game_event#eventEntry

tinyint(3)

unsigned

PRI

NO


Unique

Entry of the game event

game_event#start_time

timestamp



YES

NULL


Absolute start date, the event will never start before

game_event#end_time

timestamp



YES

NULL


Absolute end date, the event will never start after

occurrence

bigint(20)

unsigned


NO

5184000


Delay in minutes between occurrences of the event

game_event#length

bigint(20)

unsigned


NO

2592000


Length in minutes of the event

game_event#holiday

mediumint(8)

unsigned


NO

0


Client side holiday id (from dbc)

holidayStagetinyint(3)unsigned
NO0
?

game_event#description

varchar(255)

signed


YES

NULL


Description of the event displayed in console

game_event#world_event

tinyint(3)

unsigned


NO

0


0 if normal event, 1 if world event

announcetinyint(3)unsigned
YES2
0 dont announce, 1 announce, 2 value from config
Field Descriptions

eventEntry

Entry of the event. Keep it as low as possible and prevent making holes in the list. Higher the max id is, the more memory will be used to store the event data.

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.

occurrence

Number of minutes between 2 occurrences of the event. (2880 = 2 days, 1440 = 1 day, etc). Setting this to 0 will crash the server.

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

Holiday ID from  Holidays DBC file. This is sent to the client to update the calender.

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.