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 |
Attributes |
Key |
Null |
Default |
Extra |
Comment |
mediumint(8) |
unsigned |
PRI |
NO |
|
|
|
|
timestamp |
signed |
|
NO |
0000-00-00 00:00:00 |
|
|
|
timestamp |
signed |
|
NO |
0000-00-00 00:00:00 |
|
|
|
bigint(20) |
unsigned |
|
NO |
5184000 |
|
|
|
bigint(20) |
unsigned |
|
NO |
2592000 |
|
|
|
mediumint(8) |
unsigned |
|
NO |
0 |
|
|
|
varchar(255) |
signed |
YES |
NULL |
|
|
||
tinyint(3) |
unsigned |
|
NO |
0 |
|
|
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
field-no-description|6
description
String containing the name of the event displayed in console each time it starts or stops.
world_event
field-no-description|8