Skip to content
killerwife edited this page Oct 1, 2017 · 4 revisions

Back to world database list of tables.

The `game_event` table

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

Structure

Field Type Null Key Default Extra
entry mediumint(8) unsigned NO PRI
start_time timestamp NO 0000-00-00 00:00:00
end_time timestamp NO 0000-00-00 00:00:00
occurence bigint(20) unsigned NO 5184000
holiday mediumint(8) unsigned NO 0
linkedTo mediumint(8) unsigned NO 0
EventGroup mediumint(8) unsigned NO 0
description varchar(255) YES None

Description of the fields

entry

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.

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

Holiday ID from enum HolidayIds in SharedDefines.h

linkedTo

Linked event which must be active for this event to be able to be activated.

EventGroup

Group of events, which are launched automatically daily(length=1440) or weekly(length=10080).

description

String containing the name of the event displayed in console each time it starts or stops.

Clone this wiki locally