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 MaNGOSTwo
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 'InnoDB' 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
entry | description |
---|---|
1 | Midsummer Fire Festival |
2 | Winter Veil |
3 | Darkmoon Faire (Terokkar Forest) |
4 | Darkmoon Faire (Elwynn Forest) |
5 | Darkmoon Faire (Mulgore) |
6 | New Year's Eve |
7 | Lunar Festival |
8 | Love is in the Air |
9 | Feast of Winter Veil - Presents |
10 | Children's Week |
11 | Harvest Festival |
12 | Hallow's End |
13 | Elemental Invasions |
14 | Fishing Extravaganza Announce |
15 | Fishing Extravaganza |
16 | Gurubashi Arena Booty Run |
17 | Scourge Invasion |
18 | Call to Arms: Alterac Valley! |
19 | Call to Arms: Warsong Gulch! |
20 | Call to Arms: Arathi Basin! |
21 | Call to Arms: Eye of the Storm! |
22 | AQ War Effort |
23 | Darkmoon Faire Building 2 (Elwynn Forest) |
24 | Kalu'ak Fishing Derby |
25 | Call to Arms: Strand of the Ancients! |
26 | Brewfest |
27 | Nights |
28 | Noblegarden |
29 | Edge of Madness, Gri'lek |
30 | Edge of Madness, Hazza'rah |
31 | Edge of Madness, Renataki |
32 | Edge of Madness, Wushoolay |
33 | Arena Tournament |
34 | L70ETC Concert |
35 | Day of the Dead |
36 | Fishing Extravaganza Turn-in |
37 | Pilgrim's Bounty |
38 | Call to Arms: Isle of Conquest! |
39 | Kalu'ak Fishing Derby (Pre) |
40 | Kalu'ak Fishing Derby (Post) |
41 | Leader of Jin'Alai, Kutube'sa |
42 | Leader of Jin'Alai, Gawanil |
43 | Leader of Jin'Alai, Chulo |
45 | Brew of the Month, January |
46 | Brew of the Month, February |
47 | Brew of the Month, March |
48 | Brew of the Month, April |
49 | Brew of the Month, May |
50 | Brew of the Month, June |
51 | Brew of the Month, July |
52 | Brew of the Month, August |
53 | Brew of the Month, September |
54 | Brew of the Month, October |
55 | Brew of the Month, November |
56 | Brew of the Month, December |
57 | World's End Tavern - Perry Gatner Announce |
58 | World's End Tavern - Perry Gatner Standup Comedy |
59 | World's End Tavern - L70ETC Concert Announce |
60 | World's End Tavern - L70ETC Concert |
61 | Stormwind City - Stockades Jail Break |
62 | Darkmoon Faire Building 1 (Terokkar Forest) |
63 | Darkmoon Faire Building 2 (Terokkar Forest) |
64 | Darkmoon Faire Building 1 (Mulgore) |
65 | Darkmoon Faire Building 2 (Mulgore) |
66 | Darkmoon Faire Building 1 (Elwynn Forest) |
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