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

  • game_event


    antz
     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

    entrydescription
      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


    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