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 'character_reputation' table for MaNGOSZero This table holds the reputation information of each faction for the character. Table Notes This table uses the 'MyISAM' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes guid int(11) unsigned NO PRI '0' The GUID of the character. [See character.guid]. faction int(11) unsigned NO PRI '0' The faction ID that the character has the given reputation in [See Faction.dbc]. standing int(11) NO '0' The current reputation value that the character has. flags int(11) NO '0' This field is a bitmask containing flags that apply to the faction. Description of the fields guid int(11) unsigned The GUID of the character. [See character.guid]. faction int(11) unsigned The faction ID that the character has the given reputation in. [See Faction.dbc]. standing int(11) The current reputation value that the character has. flags int(11) This field is a bitmask containing flags that apply to the faction and how it's displayed to the character. Just like any flag field, you can combine flags by adding them together. If this field is 0, then it is not shown in the reputation list in-game. Flag Flag Name Notes 1 FACTION_FLAG_VISIBLE Displayed in the reputation tab 2 FACTION_FLAG_AT_WAR Active when the player sets the at war checkbox 4 FACTION_FLAG_UNKNOWN UNKNOWN 8 FACTION_FLAG_INVISIBLE Not Displayed in the reputation tab 16 FACTION_FLAG_OWN_TEAM OWN_TEAM 32 FACTION_FLAG_INACTIVE INACTIVE auto-generated by the getMaNGOS.eu MAGNET dbdocs module

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 'character_social' table for MaNGOSZero Contains data about character's friends/ignored list. Table Notes This table uses the 'MyISAM' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes guid int(11) unsigned NO PRI '0' The GUID of the character. [See character.guid] friend int(11) unsigned NO PRI '0' The GUID of the friend/ignored. [See character.guid] flags tinyint(1) unsigned NO PRI '0' Whether the character is a friend or ignored. Description of the fields guid int(11) unsigned The GUID of the character. [See character.guid] friend int(11) unsigned The GUID of the friend/ignored. [See character.guid] flags tinyint(1) unsigned The flag indicating whether the entry is either a friend or ignored. Value Meaning 0 Friend 1 Ignored auto-generated by the getMaNGOS.eu MAGNET dbdocs module

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 'character_skills' table for MaNGOSZero This table holds a listing of all skill for each character. Table Notes This table uses the 'MyISAM' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes guid int(11) unsigned NO PRI NULL The GUID (Global Unique Identifier) of the character. [See character.guid]. skill mediumint(9) unsigned NO PRI NULL The list of skills a character knows. A listing of those can be found in here. value mediumint(9) unsigned NO NULL The current skill rank(value) of the character skills a character has. max mediumint(9) unsigned NO NULL The highest possible value for the given skill within a given rank. Description of the fields guid int(11) unsigned The GUID (Global Unique Identifier) of the character. [See character.guid]. skill mediumint(9) unsigned The list of skills a character knows. A listing of those can be found in here. value mediumint(9) unsigned The current skill rank(value) of the character skills a character has. max mediumint(9) unsigned The highest possible value for the given skill within a given rank. auto-generated by the getMaNGOS.eu MAGNET dbdocs module

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 'character_spell' table for MaNGOSZero Holds information for each character's spells. Table Notes This table uses the 'MyISAM' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes guid int(11) unsigned NO PRI '0' The GUID (Global Unique Identifier) of the character. [See character.guid]. spell int(11) unsigned NO PRI '0' The spell ID (Spell Identifier). [See Spell.dbc] active tinyint(3) unsigned NO '1' Boolean 1 or 0 signifying whether the spell is active (appears in the spell book disabled tinyint(3) unsigned NO '0' Boolean flag 0 or 1 when spell is disabled because of talents. Description of the fields guid int(11) unsigned The GUID (Global Unique Identifier) of the character. [See character.guid]. spell int(11) unsigned The spell ID (Spell Identifier). [See Spell.dbc column 1] active tinyint(3) unsigned Boolean 1 or 0 signifying whether the spell is active (appears in the spell book). disabled tinyint(3) unsigned Boolean flag 0 or 1 when spell is disabled because talent which teaches it has been unlearned. When talent is learned again the spell will be available again. auto-generated by the getMaNGOS.eu MAGNET dbdocs module

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 'character_spell_cooldown' table for MaNGOSZero Holds the remaining cooldowns from either character spells or item spells for each character. Table Notes This table uses the 'InnoDB' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes guid int(11) unsigned NO PRI '0' The GUID (Global Unique Identifier, Low part) of the character. spell int(11) unsigned NO PRI '0' The spell ID (Spell Identifier). [See Spell.dbc] item int(11) unsigned NO '0' If the spell was casted from an item, the item ID (Item Identifier). time bigint(20) unsigned NO '0' The time when the spell cooldown will finish, measured in Unix Time. Description of the fields guid int(11) unsigned The GUID (Global Unique Identifier, Low part) of the character. [See character.guid] spell int(11) unsigned The spell ID (Spell Identifier). [See Spell.dbc column 1] item int(11) unsigned If the spell was casted from an item, the item ID (Item Identifier). [See item_template.entry]. time bigint(20) unsigned The time when the spell cooldown will finish, measured in Unix Time. auto-generated by the getMaNGOS.eu MAGNET dbdocs module

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 'character_stats' table for MaNGOSZero This table holds information on all the stats regarding the character. Table Notes This table uses the 'InnoDB' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes guid int(11) unsigned NO PRI '0' The guid of the character. [See character.guid]. maxhealth int(10) unsigned NO '0' Maximum amount of health that the character has. maxpower1 int(10) unsigned NO '0' Max Mana maxpower2 int(10) unsigned NO '0' Max Rage maxpower3 int(10) unsigned NO '0' Max Focus maxpower4 int(10) unsigned NO '0' Max Energy maxpower5 int(10) unsigned NO '0' Max Happiness maxpower6 int(10) unsigned NO '0' Max Rune maxpower7 int(10) unsigned NO '0' Max Runic Power strength int(10) unsigned NO '0' Character's current strength value. agility int(10) unsigned NO '0' Character's current agility value stamina int(10) unsigned NO '0' Character's current stamina value. intellect int(10) unsigned NO '0' Character's current intellect value. spirit int(10) unsigned NO '0' Character's current spirit value. armor int(10) unsigned NO '0' Character's current armor value. resHoly int(10) unsigned NO '0' Character's current holy resistance value. resFire int(10) unsigned NO '0' Character's current fire resistance value. resNature int(10) unsigned NO '0' Character's current nature resistance value. resFrost int(10) unsigned NO '0' Character's current frost resistance value. resShadow int(10) unsigned NO '0' Character's current shadow resistance value. resArcane int(10) unsigned NO '0' Character's current arcane resistance value. blockPct float unsigned NO '0' Character's current block chance dodgePct float unsigned NO '0' Character's current dodge chance. parryPct float unsigned NO '0' Character's current parry chance. critPct float unsigned NO '0' Character's current crit chance. rangedCritPct float unsigned NO '0' Character's current ranged crit chance. attackPower int(10) unsigned NO '0' Character's current attackpower. rangedAttackPower int(10) unsigned NO '0' Character's current ranged attackpower. Description of the fields guid int(11) unsigned The guid of the character. [See character.guid]. maxhealth int(10) unsigned Maximum amount of health that the character has. maxpower1 int(10) unsigned Max Mana maxpower2 int(10) unsigned Max Rage maxpower3 int(10) unsigned Max Focus maxpower4 int(10) unsigned Max Energy maxpower5 int(10) unsigned Max Happiness maxpower6 int(10) unsigned Max Rune maxpower7 int(10) unsigned Max Runic Power strength int(10) unsigned Character's current strength value. agility int(10) unsigned Character's current agility value stamina int(10) unsigned Character's current stamina value. intellect int(10) unsigned Character's current intellect value. spirit int(10) unsigned Character's current spirit value. armor int(10) unsigned Character's current armor value. resHoly int(10) unsigned Character's current holy resistance value. resFire int(10) unsigned Character's current fire resistance value. resNature int(10) unsigned Character's current nature resistance value. resFrost int(10) unsigned Character's current frost resistance value. resShadow int(10) unsigned Character's current shadow resistance value. resArcane int(10) unsigned Character's current arcane resistance value. blockPct float unsigned Character's current block chance dodgePct float unsigned Character's current dodge chance. parryPct float unsigned Character's current parry chance. critPct float unsigned Character's current crit chance. rangedCritPct float unsigned Character's current ranged crit chance. attackPower int(10) unsigned Character's current attackpower. rangedAttackPower int(10) unsigned Character's current ranged attackpower. auto-generated by the getMaNGOS.eu MAGNET dbdocs module

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 'character_tutorial' table for MaNGOSZero This table is used to store the tutorial state of all the characters. Table Notes This table uses the 'MyISAM' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes account bigint(20) unsigned NO PRI NULL 'auto_increment' The account id of the user. [See account.id]. tut0 int(11) unsigned NO '0' These values are 32bits flags. tut1 int(11) unsigned NO '0' These values are 32bits flags. tut2 int(11) unsigned NO '0' These values are 32bits flags. tut3 int(11) unsigned NO '0' These values are 32bits flags. tut4 int(11) unsigned NO '0' These values are 32bits flags. tut5 int(11) unsigned NO '0' These values are 32bits flags. tut6 int(11) unsigned NO '0' These values are 32bits flags. tut7 int(11) unsigned NO '0' These values are 32bits flags. Description of the fields account bigint(20) unsigned The account id of the user. [See account.id]. tut0 int(11) unsigned These values are 32bits flags. So 8 x 32bits values makes 256 bits available to store 256 tutorial messages status. Each bit means: bc. 0 - Not yet shown 1 - Shown This is used to diplay only tutorial messages that the character did not see before. Unselecting the "Show tutorial" option in game, makes all bits to be set, so all tutX columns will contain then 11111111111111111111111111111111 binary = 4294967295 in decimal after this option is changed. tut1 int(11) unsigned These values are 32bits flags. So 8 x 32bits values makes 256 bits available to store 256 tutorial messages status. Each bit means: bc. 0 - Not yet shown 1 - Shown This is used to diplay only tutorial messages that the character did not see before. Unselecting the "Show tutorial" option in game, makes all bits to be set, so all tutX columns will contain then 11111111111111111111111111111111 binary = 4294967295 in decimal after this option is changed. tut2 int(11) unsigned These values are 32bits flags. So 8 x 32bits values makes 256 bits available to store 256 tutorial messages status. Each bit means: bc. 0 - Not yet shown 1 - Shown This is used to diplay only tutorial messages that the character did not see before. Unselecting the "Show tutorial" option in game, makes all bits to be set, so all tutX columns will contain then 11111111111111111111111111111111 binary = 4294967295 in decimal after this option is changed. tut3 int(11) unsigned These values are 32bits flags. So 8 x 32bits values makes 256 bits available to store 256 tutorial messages status. Each bit means: bc. 0 - Not yet shown 1 - Shown This is used to diplay only tutorial messages that the character did not see before. Unselecting the "Show tutorial" option in game, makes all bits to be set, so all tutX columns will contain then 11111111111111111111111111111111 binary = 4294967295 in decimal after this option is changed. tut4 int(11) unsigned These values are 32bits flags. So 8 x 32bits values makes 256 bits available to store 256 tutorial messages status. Each bit means: bc. 0 - Not yet shown 1 - Shown This is used to diplay only tutorial messages that the character did not see before. Unselecting the "Show tutorial" option in game, makes all bits to be set, so all tutX columns will contain then 11111111111111111111111111111111 binary = 4294967295 in decimal after this option is changed. tut5 int(11) unsigned These values are 32bits flags. So 8 x 32bits values makes 256 bits available to store 256 tutorial messages status. Each bit means: bc. 0 - Not yet shown 1 - Shown This is used to diplay only tutorial messages that the character did not see before. Unselecting the "Show tutorial" option in game, makes all bits to be set, so all tutX columns will contain then 11111111111111111111111111111111 binary = 4294967295 in decimal after this option is changed. tut6 int(11) unsigned These values are 32bits flags. So 8 x 32bits values makes 256 bits available to store 256 tutorial messages status. Each bit means: bc. 0 - Not yet shown 1 - Shown This is used to diplay only tutorial messages that the character did not see before. Unselecting the "Show tutorial" option in game, makes all bits to be set, so all tutX columns will contain then 11111111111111111111111111111111 binary = 4294967295 in decimal after this option is changed. tut7 int(11) unsigned These values are 32bits flags. So 8 x 32bits values makes 256 bits available to store 256 tutorial messages status. Each bit means: bc. 0 - Not yet shown 1 - Shown This is used to diplay only tutorial messages that the character did not see before. Unselecting the "Show tutorial" option in game, makes all bits to be set, so all tutX columns will contain then 11111111111111111111111111111111 binary = 4294967295 in decimal after this option is changed. auto-generated by the getMaNGOS.eu MAGNET dbdocs module

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 'character_ticket' table for MaNGOSZero Holds ticket information from tickets written through the client help request -function. Table Notes This table uses the 'MyISAM' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes ticket_id int(11) unsigned NO PRI NULL 'auto_increment' A unique ticket ID. guid int(11) unsigned NO '0' The GUID of the character sending the ticket. [See character.guid]. ticket_text text YES NULL The ticket description text; the text written by the player. response_text text YES NULL The ticket solution text; the text written by the GM. ticket_lastchange timestamp NO 'CURRENT_TIMESTAMP' Stores the time when this ticket was last changed. resolved tinyint(1) YES '0' Resolved Flag = set to 1 if the GM has sucessfully resolved the ticket Description of the fields ticket_id int(11) unsigned A unique ticket ID. guid int(11) unsigned The GUID of the character sending the ticket. [See character.guid]. ticket_text text The ticket description text; the text written by the player in describing the problem. response_text text The ticket description text; the text written by the GM in describing the solution. ticket_lastchange timestamp Stores the time when this ticket was last changed. resolved tinyint(1) Resolved Flag = set to 1 if the GM has sucessfully resolved the ticket auto-generated by the getMaNGOS.eu MAGNET dbdocs module

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 'character_whispers' table for MaNGOSZero This table is used to store whispers that have been sent by players. By default it only stores whispers made in reply to tickets raised by players, but can be changed in mangos.conf to store all whispers. It can also be completely disabled by the same setting. Table Notes This table uses the 'InnoDB' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes id int(11) unsigned NO PRI NULL 'auto_increment' The unique id of this whisper message to_guid int(10) NO NULL The GUID of the character receiving the whisper. [See character.guid]. from_guid int(10) NO NULL The GUID of the character sending the whisper. [See character.guid]. message varchar(256) NO {Blank String} The body text of the whisper message regarding_ticket_id int(11) unsigned NO '0' The id of the ticket this whisper relates to. [See character_ticket.ticket_id]. sent_on timestamp NO 'CURRENT_TIMESTAMP' Stores the time when this whisper was sent. Description of the fields id int(11) unsigned The unique id of this whisper message to_guid int(10) The GUID of the character receiving the whisper. [See character.guid]. from_guid int(10) The GUID of the character sending the whisper. [See character.guid]. message varchar(256) The body text of the whisper message regarding_ticket_id int(11) unsigned The id of the ticket this whisper relates to. [See character_ticket.ticket_id]. sent_on timestamp Stores the time when this whisper was sent. auto-generated by the getMaNGOS.eu MAGNET dbdocs module

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 'corpse' table for MaNGOSZero This table is used to store status of players corpse. Table Notes This table uses the 'MyISAM' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes guid int(11) unsigned NO PRI '0' The character global unique identifier of the corpse. player int(11) unsigned NO MUL '0' The character global unique identifier. [See characters.guid]. position_x float NO '0' The x position of the character's corpse location. position_y float NO '0' The y position of the character's corpse location. position_z float NO '0' The z position of the character's corpse location. orientation float NO '0' The orientation of the corpse. (North = 0.0, South = 3.14159) map int(11) unsigned NO '0' The map ID the corpse is in. [See maps.dbc] time bigint(20) unsigned NO MUL '0' Time of death. corpse_type tinyint(3) unsigned NO MUL '0' The Display Type of the corpse. instance int(11) unsigned NO MUL '0' The instance ID that the corpse is in. Description of the fields guid int(11) unsigned The character global unique identifier of the corpse. player int(11) unsigned The character global unique identifier. [See characters.guid]. position_x float The x position of the character's corpse location. position_y float The y position of the character's corpse location. position_z float The z position of the character's corpse location. orientation float The orientation of the corpse. (North = 0.0, South = 3.14159) map int(11) unsigned The map ID the corpse is in. [See map.dbc] time bigint(20) unsigned Time of death. corpse_type tinyint(3) unsigned The Display Type of the corpse: Value Member Name Description 0 Bones Bones only corpse. 1 ResurrectablePvE Ressurectable corpse, pve only. 2 ResurrectablePvP Ressurectable corpse, pvp only. instance int(11) unsigned The instance ID that the corpse is in. auto-generated by the getMaNGOS.eu MAGNET dbdocs module

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 'db_version' table for MaNGOSZero This table holds the current version of the MaNGOS world database Table Notes This table uses the 'InnoDB' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes version int(3) NO PRI NULL The Version of the Release structure int(3) NO PRI NULL The current core structure level. content int(3) NO PRI NULL The current core content level. description varchar(30) NO {Blank String} comment varchar(150) YES {Blank String} A comment about the latest database revision. Description of the fields version int(3) The Version of the Release, any mismatch prevents the server from starting. structure int(3) The current core structure level, any mismatch prevents the server from starting. content int(3) The current core content level, The server will start if there is a mismatch, but will issue a warning message description varchar(30) Notes: A short description of the latest database revision. comment varchar(150) A comment about the latest database revision. auto-generated by the getMaNGOS.eu MAGNET dbdocs module

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 'creature_respawn' table for MaNGOSZero This table holds the respawn time when creatures should be respawned in the world. In case of a server crash, this table holds the respawn data so that the creatures don't respawn immediately on server restart. How often the respawn time is saved for creatures can be controlled in mangosd.conf Table Notes This table uses the 'MyISAM' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes guid int(10) unsigned NO PRI '0' respawntime bigint(20) unsigned NO '0' Time till the creature should respawn. instance mediumint(8) unsigned NO PRI '0' Instance ID of the instance the creature is respawning into. Description of the fields guid int(10) unsigned Notes: Global Unique Identifier respawntime bigint(20) unsigned Time till the creature should respawn. instance mediumint(8) unsigned Instance ID of the instance the creature is respawning into. auto-generated by the getMaNGOS.eu MAGNET dbdocs module

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 'groups' table for MaNGOSZero This table holds basic info about groups. Table Notes This table uses the 'MyISAM' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes groupId int(11) unsigned NO PRI NULL Uniquie ID for the group. leaderGuid int(11) unsigned NO UNI NULL Guid of the group's leader mainTank int(11) unsigned NO NULL Guid of the character who is that main tank. mainAssistant int(11) unsigned NO NULL Guid of the character who is that main assist. lootMethod tinyint(4) unsigned NO NULL This is the loot method used by the group. looterGuid int(11) unsigned NO NULL Guid of the character who retrieves the loot. lootThreshold tinyint(4) unsigned NO NULL The quality of the items in the loot to be rolled for. icon1 int(11) unsigned NO NULL Guid of the target that has the star raid target on it. icon2 int(11) unsigned NO NULL Guid of the target that has the circle raid target on it. icon3 int(11) unsigned NO NULL Guid of target that has the dimond raid target on it. icon4 int(11) unsigned NO NULL Guid of the target that has the triangler raid target on it. icon5 int(11) unsigned NO NULL Guid of the target that has the moon raid target on it. icon6 int(11) unsigned NO NULL Guid of the target that has the square raid target on it. icon7 int(11) unsigned NO NULL Guid of the target that has the cross raid target on it. icon8 int(11) unsigned NO NULL Guid of the target that has the skull raid target on it. isRaid tinyint(1) unsigned NO NULL Flag set for if group is part of a raid or not. Description of the fields groupId int(11) unsigned Uniquie ID for the group. leaderGuid int(11) unsigned Guid of the group's leader, from the characters table. mainTank int(11) unsigned Guid of the character who is that main tank. mainAssistant int(11) unsigned Guid of the character who is that main assit. This group member calls the shots as to the order in which mobs are taken on. lootMethod tinyint(4) unsigned This is the loot method used by the group. Method Value FREE_FOR_ALL 0 ROUND_ROBIN 1 MASTER_LOOT 2 GROUP_LOOT 3 NEED_BEFORE_GREED 4 looterGuid int(11) unsigned Guid of the character who retrieves the loot. lootThreshold tinyint(4) unsigned The quality of theitems in the loot to be rolled for. This will be the minimum quality level to throw for, any loot below that will not be thrown for. Quality Value Colour ITEM_QUALITY_POOR 0 GREY ITEM_QUALITY_NORMAL 1 WHITE ITEM_QUALITY_UNCOMMON 2 GREEN ITEM_QUALITY_RARE 3 BLUE ITEM_QUALITY_EPIC 4 PURPLE ITEM_QUALITY_LEGENDAR 5 ORANGE ITEM_QUALITY_ARTIFACT 6 LIGHT YELLOW icon1 int(11) unsigned Guid of the target that has the star raid target on it. These are placed on playesr and mobs, and can be used for controlling kill orders, crowd control, and assigning players to mobs. icon2 int(11) unsigned Guid of the target that has the circle raid target on it. These are placed on playesr and mobs, and can be used for controlling kill orders, crowd control, and assigning players to mobs. icon3 int(11) unsigned Guid of target that has the dimond raid target on it. These are placed on playesr and mobs, and can be used for controlling kill orders, crowd control, and assigning players to mobs. icon4 int(11) unsigned Guid of the target that has the triangler raid target on it. These are placed on playesr and mobs, and can be used for controlling kill orders, crowd control, and assigning players to mobs. icon5 int(11) unsigned Guid of the target that has the moon raid target on it. These are placed on playesr and mobs, and can be used for controlling kill orders, crowd control, and assigning players to mobs. icon6 int(11) unsigned Guid of the target that has the square raid target on it. These are placed on playesr and mobs, and can be used for controlling kill orders, crowd control, and assigning players to mobs. icon7 int(11) unsigned Guid of the target that has the cross raid target on it. These are placed on playesr and mobs, and can be used for controlling kill orders, crowd control, and assigning players to mobs. icon8 int(11) unsigned Guid of the target that has the skull raid target on it. These are placed on playesr and mobs, and can be used for controlling kill orders, crowd control, and assigning players to mobs. isRaid tinyint(1) unsigned Flag set for if group is part of a raid or not (1 = raid, 0 = not raid). auto-generated by the getMaNGOS.eu MAGNET dbdocs module

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_status' table for MaNGOSZero Lists the currently active game events, ie. Darkmoon faire etc. Table Notes This table uses the 'MyISAM' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes event smallint(6) unsigned NO PRI '0' The Event Id [See game_event.is] of currently active game events. Description of the fields event smallint(6) unsigned The Event Id [See game_event.is] of currently active game events. Once the event is complete, the entry is removed. auto-generated by the getMaNGOS.eu MAGNET dbdocs module

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 'gameobject_respawn' table for MaNGOSZero This table holds the re-spawn time when game objects should be respawned in the world. In case of a server crash, this table holds the re-spawn data so that the game objects don't re-spawn immediately on server restart. How often the re-spawn time is saved for game objects can be controlled in mangosd.conf. Usually the only objects that despawn and need to be re-spawned are chests and doors. Table Notes This table uses the 'MyISAM' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes guid int(10) unsigned NO PRI '0' Global unique ID of the game object. respawntime bigint(20) unsigned NO '0' Time till the game object should respawn. instance mediumint(8) unsigned NO PRI '0' Instance ID that the game object will spawn in. Description of the fields guid int(10) unsigned Global unique ID of the game object. respawntime bigint(20) unsigned Time till the game object should respawn, as in 60000 for 1 minute after server start.. instance mediumint(8) unsigned Instance ID that the game object will spawn in. auto-generated by the getMaNGOS.eu MAGNET dbdocs module

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 'group_member' table for MaNGOSZero This table holds info about group members. Table Notes This table uses the 'MyISAM' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes groupId int(11) unsigned NO PRI NULL The group ID from the groups table. memberGuid int(11) unsigned NO PRI NULL The GUID of the character in the group. assistant tinyint(1) unsigned NO NULL Flag stating whether or not the character is the assist. subgroup smallint(6) unsigned NO NULL This is the group number within a raid (8 groups max) Description of the fields groupId int(11) unsigned The group ID from the groups table. memberGuid int(11) unsigned The GUID of the character in the group. assistant tinyint(1) unsigned Flag stating whether or not the character is the assist. The assits controls which mobs to attack and in what order. subgroup smallint(6) unsigned This is the group number within a raid (8 groups max). Group numbering starts at 0 and end at 7. auto-generated by the getMaNGOS.eu MAGNET dbdocs module

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 'group_instance' table for MaNGOSZero This table tracks a group of characters in an instance. Table Notes This table uses the 'InnoDB' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes leaderGuid int(11) unsigned NO PRI '0' The Guid of the group leader. [See characters.guid] instance int(11) unsigned NO PRI '0' ID of the Instance session the group has enterd. permanent tinyint(1) unsigned NO '0' Boolean flag if the group is bound to the Instance or not Description of the fields leaderGuid int(11) unsigned The Guid of the group leader. [See characters.guid] instance int(11) unsigned ID of the Instance session the group has enterd. permanent tinyint(1) unsigned Boolean flag if the group is bound to the Instance or not auto-generated by the getMaNGOS.eu MAGNET dbdocs module

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' table for MaNGOSZero This table holds the main guild information. All created guilds or all guilds in the process of being created have a record in this table. Table Notes This table uses the 'MyISAM' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes guildid int(6) unsigned NO PRI '0' The ID of the guild. name varchar(255) NO {Blank String} The guild name. leaderguid int(6) unsigned NO '0' The GUID of the character who created the guild. [See characters.guid] EmblemStyle int(5) NO '0' The emblem style of the guild tabard. EmblemColor int(5) NO '0' The emblem color of the guild tabard. BorderStyle int(5) NO '0' The border style of the guild tabard. BorderColor int(5) NO '0' The border color of the guild tabard. BackgroundColor int(5) NO '0' The background color of the guild tabard. info varchar(500) NO {Blank String} The text message that appears in the Guild Information box. motd varchar(128) NO {Blank String} The text that appears in the Message Of The Day box. createdate bigint(20) unsigned NO '0' The date when the guild was created. Description of the fields guildid int(6) unsigned The ID of the guild. This number is unique to each guild and is the main method to identify a guild. name varchar(255) The guild name. leaderguid int(6) unsigned The GUID of the character who created the guild. [See characters.guid] EmblemStyle int(5) The emblem style of the guild tabard. EmblemColor int(5) The emblem color of the guild tabard. BorderStyle int(5) The border style of the guild tabard. BorderColor int(5) The border color of the guild tabard. BackgroundColor int(5) The background color of the guild tabard. info varchar(500) The text message that appears in the Guild Information box. motd varchar(128) The text that appears in the Message Of The Day box. createdate bigint(20) unsigned The date when the guild was created. auto-generated by the getMaNGOS.eu MAGNET dbdocs module

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 MaNGOSZero 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

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_member' table for MaNGOSZero This table holds information on the members of all guilds, their ranks in the guild, and any notes made by them or by guild officers. Table Notes This table uses the 'MyISAM' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes guildid int(6) unsigned NO MUL '0' The ID of the guild that the member is a part of. [See guild.guildid] guid int(11) unsigned NO PRI '0' The GUID of the player. [See character.guid] rank tinyint(2) unsigned NO '0' The rank that the player has in the guild. [See guild_rank.rid] pnote varchar(31) NO {Blank String} The Player Note set by the player. offnote varchar(31) NO {Blank String} The Officers Note set by officers in the guild. Description of the fields guildid int(6) unsigned The ID of the guild that the member is a part of. [See guild.guildid] guid int(11) unsigned The GUID of the player. [See character.guid] rank tinyint(2) unsigned The rank that the player has in the guild. [See guild_rank.rid] pnote varchar(31) The Player Note set by the player, which can be read by everyone in the guild. offnote varchar(31) The Officers Note set by officers in the guild, which can only be read by other officers of the guild. auto-generated by the getMaNGOS.eu MAGNET dbdocs module

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_rank' table for MaNGOSZero This table holds the information on all of the ranks available in a guild along with their names and what rights a person with that rank has. Table Notes This table uses the 'MyISAM' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes guildid int(6) unsigned NO PRI '0' The guild ID that the rank is part of. [See guild.guildid] rid int(11) unsigned NO PRI NULL The particular rank ID. This number must be unique to each rank in a guild. rname varchar(255) NO {Blank String} The name of the rank that is displayed in-game. rights int(3) unsigned NO '0' The rights a player with this rank has in the guild. Description of the fields guildid int(6) unsigned The guild ID that the rank is part of. [See guild.guildid] rid int(11) unsigned The particular rank ID. This number must be unique to each rank in a guild. rname varchar(255) The name of the rank that is displayed in-game. rights int(3) unsigned The rights a player with this rank has in the guild. The calculation of multiple rights is a bit different in this case as the rights do not all have 2^n values. To combine ranks, you must do the OR operation (|) on the two flags. Flag Flag Name Meaning 64 GR_RIGHT_EMPTY Having just this flag by itself is equivalent to having no rights at all. 65 GR_RIGHT_GCHATLISTEN Player can read messages in the guild general chat channel. 66 GR_RIGHT_GCHATSPEAK Player can type messages in the guild general chat channel. 68 GR_RIGHT_OFFCHATLISTEN Player can read messages in the guild officers channel. 72 GR_RIGHT_OFFCHATSPEAK Player can type messages in the guild officers channel. 80 GR_RIGHT_INVITE Can invite other players to guild. 96 GR_RIGHT_REMOVE Can kick other players out of guild. 192 GR_RIGHT_PROMOTE Can promote other players. 320 GR_RIGHT_DEMOTE Can demote other players. 4160 GR_RIGHT_SETMOTD Can change the guild message of the day. 8256 GR_RIGHT_EPNOTE Can edit other players' personal notes. 16448 GR_RIGHT_VIEWOFFNOTE Can view the officer notes of other players. 32832 GR_RIGHT_EOFFNOTE Can edit officer notes of other players. 61951 GR_RIGHT_ALL Has all of the rights. auto-generated by the getMaNGOS.eu MAGNET dbdocs module

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 'instance_reset' table for MaNGOSZero This table holds information about the instance reset time. Table Notes This table uses the 'InnoDB' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes mapid int(11) unsigned NO PRI '0' The map ID of the instance. [See Map.dbc] resettime bigint(40) unsigned NO '0' Dungeon reset time in seconds. Description of the fields mapid int(11) unsigned The map ID of the instance. [See Map.dbc] resettime bigint(40) unsigned Dungeon reset time in seconds. auto-generated by the getMaNGOS.eu MAGNET dbdocs module

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 'instance' table for MaNGOSZero This table holds static information on all current instances that have not yet been reset. Table Notes This table uses the 'InnoDB' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes id int(11) unsigned NO PRI '0' The instance ID. This number is unique to every instance. map int(11) unsigned NO MUL '0' The map ID the instance is in. [See Map.dbc] resettime bigint(40) unsigned NO MUL '0' The time when the instance will be reset, in Unix time. data longtext YES NULL Specific data belonging to the individual instance. Description of the fields id int(11) unsigned The instance ID. This number is unique to every instance. map int(11) unsigned The map ID the instance is in. [See Map.dbc] resettime bigint(40) unsigned The time when the instance will be reset, in Unix time. This field is zero for raid and heroic instances. data longtext Specific data belonging to the individual instance. auto-generated by the getMaNGOS.eu MAGNET dbdocs module

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 'item_instance' table for MaNGOSZero This table holds individual item instance information for all items currently equipped or in some kind of character bag or bank. Table Notes This table uses the 'MyISAM' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes guid int(11) unsigned NO PRI '0' The GUID of the item. This number is unique for each item instance. owner_guid int(11) unsigned NO MUL '0' The GUID of the character who has ownership of this item. [See character.guid] data longtext YES NULL Much like the playerbytes fields in the characters table. Description of the fields guid int(11) unsigned The GUID of the item. This number is unique for each item instance. owner_guid int(11) unsigned The GUID of the character who has ownership of this item. [See character.guid] data longtext Much like the playerbytes fields in the characters table, this field has many number fields all separated by a space which contain specific individual item information like any enchantments applied to the item, etc. Index Flag Name Meaning 0 OBJECT_FIELD_GUID Item GUID 2 OBJECT_FIELD_TYPE Should be 3 (TYPE_OBJECT + TYPE_ITEM) 3 OBJECT_FIELD_ENTRY Entry 4 OBJECT_FIELD_SCALE_X 1.0 5 OBJECT_FIELD_PADDING Some padding, need more info here. 6 ITEM_FIELD_OWNER owner_guid 8 ITEM_FIELD_CONTAINED If the item is in a bag, the GUID of the bag item; otherwise owner GUID. 10 ITEM_FIELD_CREATOR GUID of character who created the item. 12 ITEM_FIELD_GIFTCREATOR GUID of character who created the "item". [See character_gifts.item_guid]. 14 ITEM_FIELD_STACK_COUNT Current number of item copies in the stack. 15 ITEM_FIELD_DURATION Current duration (in milliseconds) 16 ITEM_FIELD_SPELL_CHARGES Current Number of charges left in the item 21 ITEM_FIELD_FLAGS Flags from "item_template" (See Item_template.flags). 22 ITEM_FIELD_ENCHANTMENT Unknown 55 ITEM_FIELD_PROPERTY_SEED Also called ITEM_FIELD_SUFFIX_FACTOR 56 ITEM_FIELD_RANDOM_PROPERTIES_ID Unknown 57 ITEM_FIELD_ITEM_TEXT_ID Text id used and shown by the item. 58 ITEM_FIELD_DURABILITY Current item durability. 59 ITEM_FIELD_MAXDURABILITY Maximum item durability. auto-generated by the getMaNGOS.eu MAGNET dbdocs module

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 'item_text' table for MaNGOSZero This table is part of the mail system and holds the text information of every letter. Table Notes This table uses the 'MyISAM' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes id int(11) unsigned NO PRI '0' The text entry ID. This number is unique to every text entry in this table. text longtext YES NULL The actual text that was sent as mail using the mail system. Description of the fields id int(11) unsigned The text entry ID. This number is unique to every text entry in this table. text longtext The actual text that was sent as mail using the mail system. There are some special messages that are sent through the mail and therefore use this table but have a special format to them: Auction won (sent to bidder): "<owner's GUID as hex>:<winning bid in copper>:<buyout price in copper>" Auction successful (sent to owner): "<bidder's GUID as hex>:<winning bid in copper>:0: <deposit in copper>:<auction cut in copper>" auto-generated by the getMaNGOS.eu MAGNET dbdocs module