NOTE: This page is auto-generated from the MAGNET DBDocs module, Any changes made directly to this page will be lost when it is regenerated. |
Description of the 'game_event' table for MaNGOSZero
This table contains definitions for all game events that are activated or deactivated automatically by the Game Event System in the core.
NOTE: an object (creature, GO etc.) cannot be related to a more than 1 game event. For example, if you wish something to happen only at March nights, you cannot combine events "March" and "Nights", but have to define a new event like "Nights" starting March 1 and ending April 1 of the same year.
Table Notes
This table uses the 'MyISAM' DB Engine
The Field definitions follow:
Field Name | Field Type | Nullable | Key | Default Value | Attributes | Notes |
---|---|---|---|---|---|---|
entry | mediumint(8) unsigned | NO | PRI | NULL | ID of the event. | |
start_time | timestamp | NO | '0000-00-00 00:00:00' | Global starting date for the event. | ||
end_time | timestamp | NO | '0000-00-00 00:00:00' | Global ending date of the event. | ||
occurence | bigint(20) unsigned | NO | '86400' | Event periodicity (minutes). | ||
length | bigint(20) unsigned | NO | '43200' | Event duration (minutes). | ||
holiday | mediumint(8) unsigned | NO | '0' | Holiday ID. | ||
description | varchar(255) | YES | {Blank String} | Description of the event. |
Description of the fields
entry mediumint(8) unsigned
ID of the event. May be any, should be as low as possible.
start_time timestamp
Starting date for the event. Defines the first event occurence only, see occurence and length for the next ones.
NOTE: due to occurence/length event definition, the seasonal events require an editing in leap-years. The simplest solution is to change start_time to the event start at such year.
end_time timestamp
Ending date of the event. After this date, the event will never happen.
occurence bigint(20) unsigned
The interval (minutes) between consequent starts of the event.
length bigint(20) unsigned
The interval (in minutes) between start and end of single event occurence
Note:
If length is > occurence, an event would never stop.
holiday mediumint(8) unsigned
Holiday ID is a number, associated with the seasonal events and strictly defined since 3.x (WotLK) client version. Ignore this if you do not know one.
description varchar(255)
Textual comment about the event.
Table Contents
description | entry |
---|---|
Midsummer Fire Festival | 1 |
Feast of Winter Veil | 2 |
Darkmoon Faire (Elwynn) | 4 |
Darkmoon Faire (Mulgore) | 5 |
New Year's Eve | 6 |
Lunar Festival | 7 |
Love is in the Air | 8 |
Noblegarden | 9 |
Children's Week | 10 |
Hallow's End | 12 |
Elemental Invasions | 13 |
Fishing Extravaganza Announce | 14 |
Fishing Extravaganza | 15 |
Gurubashi Arena Booty Run | 16 |
Scourge Invasion | 17 |
Call to Arms: Alterac Valley! | 18 |
Call to Arms: Warsong Gulch! | 19 |
Call to Arms: Arathi Basin! | 20 |
AQ War Effort | 22 |
Darkmoon Faire Building (Elwynn) | 23 |
Nights | 27 |
Edge of Madness, Gri'lek | 29 |
Edge of Madness, Hazza'rah | 30 |
Edge of Madness, Renataki | 31 |
Edge of Madness, Wushoolay | 32 |
Harvest Festival | 33 |
Fishing Extravaganza Turn-in | 34 |
Winter Season Fishing | 35 |
Summer Season Fishing | 36 |
Stormwind City - Stockades Jail Break | 61 |
Pyrewood Village - Worgen Curse | 3 |
Winter Veil: Gifts | 21 |
Hallow's End - Wickerman Ember's | 24 |
Hallow's End - Banshee Queen | 25 |
auto-generated by the getMaNGOS.eu MAGNET dbdocs module
Edited by Antz
Recommended Comments
There are no comments to display.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now