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

  • game_event

     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

      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

    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

  • 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