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

  • guild_eventlog


    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 'guild_eventlog' table for MaNGOSOne

    This table holds information about changes in guilds membership.

    Table Notes

    This table uses the 'InnoDB' DB Engine

    The Field definitions follow:

    Field Name Field Type Nullable Key Default Value Attributes Notes
    guildid int(11) unsigned NO PRI NULL   Id of related guild. [See guild.guildid].
    LogGuid int(11) unsigned NO PRI NULL   A unique identifier given to each log entry to distinguish it.
    EventType tinyint(1) unsigned NO NULL   The Guild Event Type.
    PlayerGuid1 int(11) unsigned NO MUL NULL   Guid of character who made the change. [See character.guid]
    PlayerGuid2 int(11) unsigned NO MUL NULL   Guid of character who was "changed". [See character.guid]
    NewRank tinyint(2) unsigned NO NULL   Id of new rank of PlayerGuid2. [See guild_rank.rid]
    TimeStamp bigint(20) unsigned NO NULL   Unix timestamp of when the event happened.

    Description of the fields

    guildid int(11) unsigned

    Id of related guild. [See guild.guildid].

    LogGuid int(11) unsigned

    A unique identifier given to each log entry to distinguish one entry from another. Two guild event logs can NOT have same GUID.

    EventType tinyint(1) unsigned

    The Guild Event Type:

    Value Meaning
    1 GUILD_EVENT_LOG_INVITE_PLAYER
    2 GUILD_EVENT_LOG_JOIN_GUILD
    3 GUILD_EVENT_LOG_PROMOTE_PLAYER
    4 GUILD_EVENT_LOG_DEMOTE_PLAYER
    5 GUILD_EVENT_LOG_UNINVITE_PLAYER
    6 GUILD_EVENT_LOG_LEAVE_GUILD


    PlayerGuid1 int(11) unsigned

    Guid of character who made the change. [See character.guid]

    PlayerGuid2 int(11) unsigned

    Guid of character who was "changed". [See character.guid]

    NewRank tinyint(2) unsigned

    Id of new rank of PlayerGuid2. [See guild_rank.rid]

    TimeStamp bigint(20) unsigned

    Unix timestamp of when the event happened.


    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