Jump to content
  • We are looking for staff for the Wiki area!
    If interested please
    click here and select "Documentation Team"

  • Sign in to follow this  


     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

    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

      1  Midsummer Fire Festival
      2  Feast of Winter Veil
      4  Darkmoon Faire (Elwynn)
      5  Darkmoon Faire (Mulgore)
      6  New Year's Eve
      7  Lunar Festival
      8  Love is in the Air
      9  Noblegarden
      10  Children's Week
      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!
      22  AQ War Effort
      23  Darkmoon Faire Building (Elwynn)
      27  Nights
      29  Edge of Madness, Gri'lek
      30  Edge of Madness, Hazza'rah
      31  Edge of Madness, Renataki
      32  Edge of Madness, Wushoolay
      33  Harvest Festival
      34  Fishing Extravaganza Turn-in
      35  Winter Season Fishing
      36  Summer Season Fishing
      61  Stormwind City - Stockades Jail Break
      3  Pyrewood Village - Worgen Curse
      21  Winter Veil: Gifts
      24  Hallow's End - Wickerman Ember's
      25  Hallow's End - Banshee Queen

    auto-generated by the getMaNGOS.eu MAGNET dbdocs module

    Edited by Antz

    Sign in to follow this  

    User Feedback

    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 account

    Sign in

    Already have an account? Sign in here.

    Sign In Now

Contact Us

To contact us click here
You can also email us at [email protected]

Privacy Policy | Terms & Conditions


The Link to the master list
of MaNGOS repositories:
Copyright © getMaNGOS. All rights Reserved.

This website is in no way associated with or endorsed by Blizzard Entertainment®
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use