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 'arena_team_member' table for MaNGOSTwo Table Notes This table uses the 'InnoDB' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes arenateamid int(10) unsigned NO PRI '0' guid int(10) unsigned NO PRI '0' played_week int(10) unsigned NO '0' wons_week int(10) unsigned NO '0' played_season int(10) unsigned NO '0' wons_season int(10) unsigned NO '0' personal_rating int(10) unsigned NO '0' Description of the fields arenateamid int(10) unsigned guid int(10) unsigned played_week int(10) unsigned wons_week int(10) unsigned played_season int(10) unsigned wons_season int(10) unsigned personal_rating int(10) unsigned 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 'auction' table for MaNGOSTwo Contains all information about the currently ongoing auctions in the auction houses. It controls what items are put up for auction and who put it up, who is the highest bidder, etc. 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' Unique identifier for every auction. houseid int(11) unsigned NO '0' The AuctionHouseId [See AuctionHouse.dbc] itemguid int(11) unsigned NO '0' The GUID of the item that is up for auction. [See item_instance.guid] item_template int(11) unsigned NO '0' The entry of the item up for auction. See (item_template.entry) item_count int(11) unsigned NO '0' The stack count of the item item_randompropertyid int(11) NO '0' A link to the Item's RandomProperty Id [See item_template.Randompropertyid]. itemowner int(11) unsigned NO '0' The GUID of the owner of the item up for auction. [See character.guid] buyoutprice int(11) NO '0' The buyout price of the item in copper. time bigint(40) unsigned NO '0' The time when this auction will end, measured in Unix time. moneyTime bigint(40) unsigned NO '0' buyguid int(11) unsigned NO '0' The GUID of the highest bidder. See (character.guid) lastbid int(11) NO '0' The amount of copper of the last bid made on the item. startbid int(11) NO '0' The amount of copper of the starting bid made on the item. deposit int(11) NO '0' The amount of copper spent on the deposit. Description of the fields id int(11) unsigned Unique identifier for every auction. houseid int(11) unsigned The AuctionHouseId [See AuctionHouse.dbc] itemguid int(11) unsigned The GUID of the item that is up for auction. [See item_instance.guid] item_template int(11) unsigned The entry of the item up for auction. See (item_template.entry) item_count int(11) unsigned The stack count of the item item_randompropertyid int(11) A link to the Item's RandomProperty Id [See item_template.Randompropertyid]. itemowner int(11) unsigned The GUID of the owner of the item up for auction. [See character.guid] buyoutprice int(11) The buyout price of the item in copper. Divide by 100 to get silver and by 100 again to get gold. time bigint(40) unsigned The time when this auction will end, measured in Unix time (number of seconds from 00:00 Jan 1, 1970). moneyTime bigint(40) unsigned buyguid int(11) unsigned The GUID of the highest bidder. See (character.guid) lastbid int(11) The amount of copper of the last bid made on the item. startbid int(11) The amount of copper of the starting bid made on the item. deposit int(11) The amount of copper spent on the deposit. 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 'calendar_events' table for MaNGOSTwo Table Notes This table uses the 'InnoDB' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes eventId bigint(10) unsigned NO PRI '0' creatorGuid int(10) unsigned NO '0' guildId int(10) unsigned NO '0' type tinyint(3) unsigned NO '4' flags int(10) unsigned NO '0' dungeonId int(10) NO '-1' eventTime int(10) unsigned NO '0' title varchar(128) NO {Blank String} description varchar(1024) NO {Blank String} Description of the fields eventId bigint(10) unsigned creatorGuid int(10) unsigned guildId int(10) unsigned type tinyint(3) unsigned flags int(10) unsigned dungeonId int(10) eventTime int(10) unsigned title varchar(128) description varchar(1024) 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 'bugreport' table for MaNGOSTwo This table stores all the Bugs/Suggestions submitted in-game by Players. 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) NO PRI NULL 'auto_increment' Auto generated value when records are inserted by the core. type longtext NO NULL The text description of the type of bug report / suggestion. content longtext NO NULL The text content of the bug/suggestion. Description of the fields id int(11) Auto generated value when records are inserted by the core. This id is just here to be a primary key and eases the data insertion. This field is also a auto increment field type longtext The text description of the type of bug report / suggestion. content longtext The text content of the bug/suggestion. 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 'calendar_invites' table for MaNGOSTwo Table Notes This table uses the 'InnoDB' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes inviteId bigint(10) unsigned NO PRI '0' eventId bigint(10) unsigned NO '0' inviteeGuid int(10) unsigned NO '0' senderGuid int(3) unsigned NO '0' status tinyint(10) unsigned NO '0' lastUpdateTime int(10) unsigned NO '0' rank tinyint(10) unsigned NO '0' Description of the fields inviteId bigint(10) unsigned eventId bigint(10) unsigned inviteeGuid int(10) unsigned senderGuid int(3) unsigned status tinyint(10) unsigned lastUpdateTime int(10) unsigned rank tinyint(10) unsigned 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 'characters' table for MaNGOSTwo This table holds vital static information for each character. This information loaded and used to create the player objects in-game. 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. account int(11) unsigned NO MUL '0' The account ID in which this character resides [See account.id] in the realm db. name varchar(12) NO MUL {Blank String} The name of the character. race tinyint(3) unsigned NO '0' The race of the character. class tinyint(3) unsigned NO '0' The Class Id of the character [See chrclasses.dbc]. gender tinyint(3) unsigned NO '0' The Sex/Gender of the character. level tinyint(3) unsigned NO '0' The current level of the designated player. xp int(10) unsigned NO '0' The total amount of xp that the signified player has. money int(10) unsigned NO '0' This is the amount of copper the character possesses. playerBytes int(10) unsigned NO '0' This defines the physical attributes of the character. playerBytes2 int(10) unsigned NO '0' This defines the facial hair physical attribute of the character. playerFlags int(10) unsigned NO '0' These are the player flags, such as GM mode on or off. position_x float NO '0' The x position of the character's location. position_y float NO '0' The y position of the character's location. position_z float NO '0' The z position of the character's location. map int(11) unsigned NO '0' The map ID the character is in [See maps.dbc] dungeon_difficulty tinyint(1) unsigned NO '0' orientation float NO '0' The orientation the character is facing. (North = 0.0, South = 3.14159) taximask longtext YES NULL online tinyint(3) unsigned NO MUL '0' Records whether the character is online (1) or offline (0). cinematic tinyint(3) unsigned NO '0' Boolean 1 or 0 controlling whether the start cinematic has been shown or not. totaltime int(11) unsigned NO '0' The total time that the character has been active in the world. leveltime int(11) unsigned NO '0' The total time the character has spent in the world at the current level. logout_time bigint(20) unsigned NO '0' The time when the character last logged out, measured in Unix time. is_logout_resting tinyint(3) unsigned NO '0' Boolean 1 or 0 controlling if the character is currently in a resting zone. rest_bonus float NO '0' This is the rest bonus for the character. resettalents_cost int(11) unsigned NO '0' The cost for the character to reset its talents, measured in copper. resettalents_time bigint(20) unsigned NO '0' trans_x float NO '0' The X coordinate of the character on the transport it is travelling on. trans_y float NO '0' The Y coordinate of the character on the transport it is travelling on. trans_z float NO '0' The Z coordinate of the character on the transport it is travelling on. trans_o float NO '0' The orientation of the character on the transport it is travelling on. transguid bigint(20) unsigned NO '0' This is the transprt the character is currently travelling on. extra_flags int(11) unsigned NO '0' These flags control certain player specific attributes, mostly GM features. stable_slots tinyint(1) unsigned NO '0' The number of stable slots the player has available. Maximum is 2. at_login int(11) unsigned NO '0' The status of the character. zone int(11) unsigned NO '0' The zone ID the character is in. death_expire_time bigint(20) unsigned NO '0' Time when a character can be resurrected. taxi_path text YES NULL Stores the players current taxi path (TaxiPath.dbc) if logged off while on one. arenaPoints int(10) unsigned NO '0' totalHonorPoints int(10) unsigned NO '0' todayHonorPoints int(10) unsigned NO '0' yesterdayHonorPoints int(10) unsigned NO '0' totalKills int(10) unsigned NO '0' todayKills smallint(5) unsigned NO '0' yesterdayKills smallint(5) unsigned NO '0' chosenTitle int(10) unsigned NO '0' knownCurrencies bigint(20) unsigned NO '0' watchedFaction int(10) unsigned NO '0' The faction whose rep is being followed on the experience bar. drunk tinyint(3) unsigned NO '0' This represents the alcoholic strength of the drink. health int(10) unsigned NO '0' The character's health when logging out. power1 int(10) unsigned NO '0' If a mana user, then this is a character's mana level when logging out. power2 int(10) unsigned NO '0' If a warrior, then this is a character's rage level when logging out. power3 int(10) unsigned NO '0' This is a hunter pet's focus level. power4 int(10) unsigned NO '0' If a rogue, then this is a character's energy level when logging out. power5 int(10) unsigned NO '0' This is the current active pet's happiness level. power6 int(10) unsigned NO '0' power7 int(10) unsigned NO '0' specCount tinyint(3) unsigned NO '1' activeSpec tinyint(3) unsigned NO '0' exploredZones longtext YES NULL This is a record of all areas discovered by the character. equipmentCache longtext YES NULL This is a record of all items that are currently equipped. ammoId int(10) unsigned NO '0' This is the item_template Entry ID of the ammo currently equipped. knownTitles longtext YES NULL actionBars tinyint(3) unsigned NO '0' This represents which action bars are currently active. deleteInfos_Account int(11) unsigned YES NULL This is the account number from the characters table. deleteInfos_Name varchar(12) YES {Blank String} The is the name of the character being deleted. deleteDate bigint(20) unsigned YES NULL This is the date the character was deleted, Description of the fields guid int(11) unsigned The character global unique identifier. This number must be unique and is the best way to identify separate characters. account int(11) unsigned The account ID in which this character resides. [See account.id] in the realm database. name varchar(12) The name of the character. race tinyint(3) unsigned The race of the character. Index Value Race Name 1 1 Human 2 2 Orc 3 4 Dwarf 4 8 Night Elf 5 16 Undead 6 32 Tauren 7 64 Gnome 8 128 Troll class tinyint(3) unsigned The Class Id of the character [See chrclasses.dbc] gender tinyint(3) unsigned The Sex/Gender of the character. Value Gender 0 Male 1 Female level tinyint(3) unsigned The current level of the designated player. xp int(10) unsigned The total amount of xp that the signified player has. money int(10) unsigned This is the amount of copper the character possesses. playerBytes int(10) unsigned This defines the following physical attributes of the character: skin, face, hairstyle, hair colour Attribute Offset Bits skin 0 0 - 7 face 8 8 - 15 hairStyle 16 16 - 23 hairColor 24 24 - 31 TODO (an example of setting an attribute) playerBytes2 int(10) unsigned This defines the facial hair physical attribute of the character. As with playerBytes, playerBytes2's bits (0 to 7) are used to change the character's facial hair TODO (an example of setting this attribute) playerFlags int(10) unsigned These are the player flags. They are represented as decimal values in the database table, and hexidecimal values in the table below. Flag Value Description PLAYER_FLAGS_NONE 0x00000000 PLAYER_FLAGS_GROUP_LEADER 0x00000001 PLAYER_FLAGS_AFK 0x00000002 Player is away from keyboard PLAYER_FLAGS_DND 0x00000004 Player has do not disturb set PLAYER_FLAGS_GM 0x00000008 GM mode is on PLAYER_FLAGS_GHOST 0x00000010 PLAYER_FLAGS_RESTING 0x00000020 Player is in a rest area, such as a town PLAYER_FLAGS_UNK7 0x00000040 admin? PLAYER_FLAGS_FFA_PVP 0x00000080 PLAYER_FLAGS_CONTESTED_PVP 0x00000100 Player has been involved in a PvP combat and will be attacked by contested guards PLAYER_FLAGS_IN_PVP 0x00000200 PLAYER_FLAGS_HIDE_HELM 0x00000400 Player has hide helm set PLAYER_FLAGS_HIDE_CLOAK 0x00000800 Player has hide cloak set PLAYER_FLAGS_PARTIAL_PLAY_TIME 0x00001000 played long time PLAYER_FLAGS_NO_PLAY_TIME 0x00002000 played too long time PLAYER_FLAGS_UNK15 0x00004000 PLAYER_FLAGS_UNK16 0x00008000 strange visual effect (2.0.1), looks like PLAYER_FLAGS_GHOST flag PLAYER_FLAGS_SANCTUARY 0x00010000 player entered sanctuary PLAYER_FLAGS_TAXI_BENCHMARK 0x00020000 taxi benchmark mode (on/off) (2.0.1) PLAYER_FLAGS_PVP_TIMER 0x00040000 position_x float The x position of the character's location. position_y float The y position of the character's location. position_z float The z position of the character's location. map int(11) unsigned The map ID the character is in. [See map.dbc] dungeon_difficulty tinyint(1) unsigned orientation float The orientation the character is facing. (North = 0.0, South = 3.14159) taximask longtext online tinyint(3) unsigned Records whether the character is online (1) or offline (0). cinematic tinyint(3) unsigned Boolean 1 or 0 controlling whether the start cinematic has been shown or not. totaltime int(11) unsigned The total time that the character has been active in the world, measured in seconds. leveltime int(11) unsigned The total time the character has spent in the world at the current level, measured in seconds. logout_time bigint(20) unsigned The time when the character last logged out, measured in Unix time. is_logout_resting tinyint(3) unsigned Boolean 1 or 0 controlling if the character is currently in a resting zone or not. rest_bonus float This is part of the rest system, and is used to calculate how much rest bonus to give the player when they have been offline. Rest bonus affects the amount of experience the character can earn, resettalents_cost int(11) unsigned The cost for the character to reset its talents, measured in copper. resettalents_time bigint(20) unsigned trans_x float The X coordinate of the character on the transport it is travelling on at the point of logging off. trans_y float The Y coordinate of the character on the transport it is travelling on at the point of logging off. trans_z float The Z coordinate of the character on the transport it is travelling on at the point of logging off. trans_o float The orientation of the character on the transport it is travelling on at the point of logging off. transguid bigint(20) unsigned This is the transprt the character is currently travelling on. It's the entry ID from the transports table. extra_flags int(11) unsigned These flags control certain player specific attributes, mostly GM features Bit Name Description 1 PLAYER_EXTRA_GM_ON Defines GM state 2 PLAYER_EXTRA_GM_ACCEPT_TICKETS Defines if tickets are accepted 4 PLAYER_EXTRA_ACCEPT_WHISPERS Defines if whispers are accepted 8 PLAYER_EXTRA_TAXICHEAT Sets taxicheat 16 PLAYER_EXTRA_GM_INVISIBLE Control's GM's invisibly 32 PLAYER_EXTRA_GM_CHAT Show GM badge in chat messages 64 PLAYER_EXTRA_PVP_DEATH Store PvP death status until corpse creating stable_slots tinyint(1) unsigned The number of stable slots the player has available. Maximum is 2. at_login int(11) unsigned The status of the character. Value Meaning 1 Force character to change name 2 Reset spells (professions as well) 4 Reset talents 8 Character Customization enabled zone int(11) unsigned The zone ID the character is in. death_expire_time bigint(20) unsigned Time when a character can be resurrected in case of a server crash or client exit while in ghost form. taxi_path text Stores the players current taxi path (TaxiPath.dbc) if logged off while on one. arenaPoints int(10) unsigned totalHonorPoints int(10) unsigned todayHonorPoints int(10) unsigned yesterdayHonorPoints int(10) unsigned totalKills int(10) unsigned todayKills smallint(5) unsigned yesterdayKills smallint(5) unsigned chosenTitle int(10) unsigned knownCurrencies bigint(20) unsigned watchedFaction int(10) unsigned The faction whose rep is being followed on the experience bar. Only one faction at a time can be followed. The ID of the faction being followed will appear in this field, e.g. 18 for Gnomeragan Exiles 20 for Ironforge 21 for Darnassus These are not the same as the Faction IDs from the DBC file. drunk tinyint(3) unsigned This represents the alcoholic strength of the drink. The stronger the drinker, the longer your character is drunk for health int(10) unsigned The character's health when logging out. power1 int(10) unsigned The character's mana level when logging out. power2 int(10) unsigned If a warrior, then this is character's rage level when logging out. power3 int(10) unsigned This is a hunter pet's focus level at point of logging off. power4 int(10) unsigned If a rogue, then this is character's energy level when logging out. power5 int(10) unsigned This is the current active pet's happiness level at the point of logging off. power6 int(10) unsigned power7 int(10) unsigned specCount tinyint(3) unsigned activeSpec tinyint(3) unsigned exploredZones longtext This is a record of all areas discovered by the character. equipmentCache longtext This is a record of all items that are currently equipped. Changing this information does not affect what is equipped. It will just revert back to what was originally equipped. ammoId int(10) unsigned This is the item_template Entry ID of the ammo currently equipped. e.g. 2516 light shot knownTitles longtext actionBars tinyint(3) unsigned This represents which action bars are currently active. Value Action bar 1 bottom left 2 bottom right 4 right action bar 12 right action bar and action bar2 A combination of the above gives you which action bars are currently active, e.g. 3 will be bottom left and bottom right, 7 will be bottom left and right bars and the right action bar, and 19 will be all action bars active. deleteInfos_Account int(11) unsigned This is the account number from the characters table, that the deleted character is on. deleteInfos_Name varchar(12) The is the name of the character being deleted. deleteDate bigint(20) unsigned This is the date the character was deleted, 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_achievement' table for MaNGOSTwo 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 NULL achievement int(11) unsigned NO PRI NULL date bigint(11) unsigned NO '0' Description of the fields guid int(11) unsigned achievement int(11) unsigned date bigint(11) unsigned 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_account_data' table for MaNGOSTwo 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' type int(11) unsigned NO PRI '0' time bigint(11) unsigned NO '0' data longblob NO NULL Description of the fields guid int(11) unsigned type int(11) unsigned time bigint(11) unsigned data longblob 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_action' table for MaNGOSTwo This table contains all the individual button data for each character. A button is any of the places in the GUI where you can place for example a spell, item, or macro as a shortcut. 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.id]. spec tinyint(3) unsigned NO PRI '0' button tinyint(3) unsigned NO PRI '0' The ID of the button on the action bar where the action icon will be placed. action int(11) unsigned NO '0' Depending on the type value, this could be various values. type tinyint(3) unsigned NO '0' The type of action. Description of the fields guid int(11) unsigned The GUID of the character. [See character.id] spec tinyint(3) unsigned button tinyint(3) unsigned The ID of the button on the action bar where the action icon will be placed. Special bars are used for stances, auras, pets, stealth, and other similar special modes. Button ID's Set (key) 1-11 1 (SHIFT + 1) 12-23 2 (SHIFT + 2) 24-35 3 (SHIFT + 3) == Right Side Bar 36-47 4 (SHIFT + 4) == Right Side Bar 2 48-59 5 (SHIFT + 5) == Bottom Right Bar 60-71 6 (SHIFT + 6) == Bottom Left Bar 72-83 1 SpecialA 84-95 1 SpecialB 96-107 1 SpecialC 108-119 1 SpecialD action int(11) unsigned Depending on the type value, this could be either the spell ID (Spell.dbc), the item_template.entry or macro ID. type tinyint(3) unsigned The type of action: Value Possible types 0 Spell 64 Macro 128 Item 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_achievement_progress' table for MaNGOSTwo 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 NULL criteria int(11) unsigned NO PRI NULL counter int(11) unsigned NO NULL date bigint(11) unsigned NO '0' Description of the fields guid int(11) unsigned criteria int(11) unsigned counter int(11) unsigned date bigint(11) unsigned 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_aura' table for MaNGOSTwo Contains aura information that is loaded when a character is loaded, so the auras that were on the character when it logged out are still kept when it logs back in. A spell can have up to three auras, one in each of its effects. 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 (Full Global Unique Identifier) of the target affected by the aura. caster_guid bigint(20) unsigned NO PRI '0' The GUID (Global Unique Identifier) of the player who cast the aura. item_guid int(11) unsigned NO PRI '0' The GUID (Global Unique Identifier) of the item which casted the aura. spell int(11) unsigned NO PRI '0' The spell from which the aura was applied. [See Spell.dbc] stackcount int(11) unsigned NO '1' Determines how many stacks of the spell the character has. remaincharges int(11) unsigned NO '0' The number of charges remaining on the aura. basepoints0 int(11) NO '0' Primary effect. basepoints1 int(11) NO '0' Secondary effect (healing) basepoints2 int(11) NO '0' Secondary effect (damage) periodictime0 int(11) unsigned NO '0' Primary effect over time counter. periodictime1 int(11) unsigned NO '0' Primary effect (healing) over time counter. periodictime2 int(11) unsigned NO '0' Primary effect (damage) over time counter. maxduration int(11) NO '0' The maximum duration of the aura. remaintime int(11) NO '0' The time remaining in seconds on the aura. -1 means that the aura is indefinite. effIndexMask int(11) unsigned NO '0' The effect index of the spell from which the aura came from. Description of the fields guid int(11) unsigned The GUID (Full Global Unique Identifier) of the target affected by the aura. [See character.id]. caster_guid bigint(20) unsigned The GUID (Global Unique Identifier) of the player who cast the aura. [See character.id]. item_guid int(11) unsigned The GUID (Global Unique Identifier) of the item which casted the aura. [See item_instance.guid]. spell int(11) unsigned The spell from which the aura was applied. [See Spell.dbc column 1] stackcount int(11) unsigned Determines how many stacks of the spell the character has. remaincharges int(11) unsigned The number of charges remaining on the aura. basepoints0 int(11) Primary effect, such as Priest's heal, Warloack Demon skin, or Paladin's Seal of Righteousness. The effect can be positive or negative. basepoints1 int(11) This is a secondary effect and appears to be healing related, such as the Warlock Demon skin heal over time. basepoints2 int(11) This is a secondary effect, and appears to be damage related, such unleasing the Paladin's Seal of Righteousness. periodictime0 int(11) unsigned Primary effect over time counter, such as the Priest's heal. periodictime1 int(11) unsigned Primary effect (healing) over time counter. periodictime2 int(11) unsigned Primary effect (damage) over time counter. maxduration int(11) The maximum duration of the aura. remaintime int(11) The time remaining in seconds on the aura. -1 means that the aura is indefinite. effIndexMask int(11) unsigned The effect index of the spell from which the aura came from. A spell has up to three effects, with the index being 0, 1, or 2. 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_battleground_data' table for MaNGOSTwo This table holds information about the character when it joins a battleground. 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 battleground datar global unique identifier. instance_id int(11) unsigned NO '0' The unique ID of the battleground instance the character has entered. team int(11) unsigned NO '0' Neutral, Horde, or Alliance join_x float NO '0' The character's X coordinate in the battleground. join_y float NO '0' The character's Y coordinate in the battleground. join_z float NO '0' The character's Z coordinate in the battleground. join_o float NO '0' The character's orientation in the battleground. join_map int(11) NO '0' Battleground map ID where the character will spawn. taxi_start int(11) NO '0' taxi_end int(11) NO '0' mount_spell int(11) NO '0' Description of the fields guid int(11) unsigned The character battleground datar global unique identifier. instance_id int(11) unsigned The unique ID of the battleground instance the character has entered. team int(11) unsigned Neutral, Horde, or Alliance join_x float The character's X coordinate in the battleground. join_y float The character's Y coordinate in the battleground. join_z float The character's Z coordinate in the battleground. join_o float The character's orientation in the battleground. join_map int(11) Battleground map ID where the character will spawn. taxi_start int(11) taxi_end int(11) mount_spell int(11) 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_battleground_random' table for MaNGOSTwo 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' Description of the fields guid int(11) unsigned 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_equipmentsets' table for MaNGOSTwo 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) NO MUL '0' setguid bigint(20) unsigned NO PRI NULL 'auto_increment' setindex tinyint(4) NO MUL '0' name varchar(100) NO {Blank String} iconname varchar(100) NO {Blank String} ignore_mask int(11) unsigned NO '0' item0 int(11) unsigned NO '0' item1 int(11) unsigned NO '0' item2 int(11) unsigned NO '0' item3 int(11) unsigned NO '0' item4 int(11) unsigned NO '0' item5 int(11) unsigned NO '0' item6 int(11) unsigned NO '0' item7 int(11) unsigned NO '0' item8 int(11) unsigned NO '0' item9 int(11) unsigned NO '0' item10 int(11) unsigned NO '0' item11 int(11) unsigned NO '0' item12 int(11) unsigned NO '0' item13 int(11) unsigned NO '0' item14 int(11) unsigned NO '0' item15 int(11) unsigned NO '0' item16 int(11) unsigned NO '0' item17 int(11) unsigned NO '0' item18 int(11) unsigned NO '0' Description of the fields guid int(11) setguid bigint(20) unsigned setindex tinyint(4) name varchar(100) iconname varchar(100) ignore_mask int(11) unsigned item0 int(11) unsigned item1 int(11) unsigned item2 int(11) unsigned item3 int(11) unsigned item4 int(11) unsigned item5 int(11) unsigned item6 int(11) unsigned item7 int(11) unsigned item8 int(11) unsigned item9 int(11) unsigned item10 int(11) unsigned item11 int(11) unsigned item12 int(11) unsigned item13 int(11) unsigned item14 int(11) unsigned item15 int(11) unsigned item16 int(11) unsigned item17 int(11) unsigned item18 int(11) unsigned 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_declinedname' table for MaNGOSTwo 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' genitive varchar(15) NO {Blank String} dative varchar(15) NO {Blank String} accusative varchar(15) NO {Blank String} instrumental varchar(15) NO {Blank String} prepositional varchar(15) NO {Blank String} Description of the fields guid int(11) unsigned Notes: Global Unique Identifier genitive varchar(15) dative varchar(15) accusative varchar(15) instrumental varchar(15) prepositional varchar(15) 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_gifts' table for MaNGOSTwo This table holds data about wrapped/gift items. 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(20) unsigned NO MUL '0' The GUID (Global Unique Identifier) of the character. [See character.guid]. item_guid int(11) unsigned NO PRI '0' The GUID of the item. [See item_instance.guid]. entry int(20) unsigned NO '0' The entry of the item. [See item_template.entry]. flags int(20) unsigned NO '0' Description of the fields guid int(20) unsigned The GUID (Global Unique Identifier) of the character. [See character.guid]. item_guid int(11) unsigned The GUID of the item. [See item_instance.guid]. entry int(20) unsigned The entry of the item. [See item_template.entry]. flags int(20) unsigned TODO - find out what this field is used for! What has been attempted so far in the search to identify this field's purpose: 1) moved gift between bags and bank 2) gave gift to another character via trade 3) sent gift by mail to another character After the above, the value in the field did not change, it was always 0. 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_glyphs' table for MaNGOSTwo 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 NULL spec tinyint(3) unsigned NO PRI '0' slot tinyint(3) unsigned NO PRI '0' glyph int(11) unsigned NO '0' Description of the fields guid int(11) unsigned spec tinyint(3) unsigned slot tinyint(3) unsigned glyph int(11) unsigned 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_homebind' table for MaNGOSTwo Contains information on the location where characters get teleported when they use for example the soul stone or the .start command. 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]. map int(11) unsigned NO '0' The Map Identifier where the character gets teleported to. [See Maps.dbc]. zone int(11) unsigned NO '0' The Zone Identifier where the character gets teleported to. position_x float NO '0' The x position where the character gets teleported to. position_y float NO '0' The y position where the character gets teleported to. position_z float NO '0' The z position where the character gets teleported to. Description of the fields guid int(11) unsigned The GUID (Global Unique Identifier) of the character. [See character.guid]. map int(11) unsigned The Map Identifier where the character gets teleported to [See Map.dbc]. zone int(11) unsigned The zone ID (Zone Identifier) where the character gets teleported to [See WorldMapArea.dbc]. position_x float The x position where the character gets teleported to. position_y float The y position where the character gets teleported to. position_z float The z position where the character gets teleported to. 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_inventory' table for MaNGOSTwo Contains all the character inventory data, including the bank data. 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 MUL '0' The GUID (Global Unique Identifier) of the character. [See character.guid]. bag int(11) unsigned NO '0' If it isn't 0, then it is the bag's item GUID (Global Unique Identifier). slot tinyint(3) unsigned NO '0' The slot is the slot in the bag where the item is. item int(11) unsigned NO PRI '0' The item's GUID. [See item_instance.guid]. item_template int(11) unsigned NO '0' The item's template entry (Item Identifier). [See item_template.entry]. Description of the fields guid int(11) unsigned The GUID (Global Unique Identifier) of the character. [See character.guid]. bag int(11) unsigned If it isn't 0, then it is the bag's item GUID (Global Unique Identifier). [See item_instance.guid]. slot tinyint(3) unsigned If the bag field is non-zero, then the slot is the slot in the bag where the item is kept. The range can differ depending on the number of slots the bag has. If the bag field is zero, then the slot has a range of 0 to 84 and the value stands for the following: Slot # Slot Name 0 Head 1 Neck 2 Shoulders 3 Body 4 Chest 5 Waist 6 Legs 7 Feet 8 Wrists 9 Hands 10 Finger 1 11 Finger 2 12 Trinket 1 13 Trinket 2 14 Back 15 Main Hand 16 Off Hand 17 Ranged 18 Tabard 19-22 Equipped Bags 23-38 Main Backpack 39-62 Main Bank - 24 positions 63-68 Bank Bags - 6 positions later changed to 39-67 Main Bank - 28 positions ? 68-74 Bank Bags - 7 positions ? item int(11) unsigned The item's GUID. [See item_instance.guid]. item_template int(11) unsigned The item's template entry (Item Identifier). [See item_template.entry]. 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_instance' table for MaNGOSTwo Contains the instance data for characters. 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) of the character. instance int(11) unsigned NO PRI '0' The instance ID. [See instance.id]. permanent tinyint(1) unsigned NO '0' Boolean 0 or 1 controlling if the player has been bound to the instance. Description of the fields guid int(11) unsigned The GUID (Global Unique Identifier) of the character [See character.guid]. instance int(11) unsigned The instance ID. [See instance.id]. permanent tinyint(1) unsigned Boolean 0 or 1 controlling if the player has been bound to the instance. A player is bound to the instance only when he (or his party/raid) kills a creature with the CREATURE_FLAG_EXTRA_INSTANCE_BIND flag set in the (creature_template.flags_extra) field. 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_pet' table for MaNGOSTwo This table holds the pet data for each pet summoned by anyone in the game. 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 special pet ID. This is a unique identifier among all pets. entry int(11) unsigned NO '0' The creature entry of this pet. [See creature_template.entry]. owner int(11) unsigned NO MUL '0' The GUID of the pet's owner. [See character.guid]. modelid int(11) unsigned YES '0' The model ID to use to display the pet. CreatedBySpell int(11) unsigned NO '0' The ID of the spell that has created this pet. PetType tinyint(3) unsigned NO '0' The type of pet that this is. 0 = summoned pet, 1 = tamed pet level int(11) unsigned NO '1' The current level of the pet. exp int(11) unsigned NO '0' The current experience that this pet has. Reactstate tinyint(1) unsigned NO '0' The current reaction state of the pet (passive, aggressive, etc). name varchar(100) YES 'Pet' The pet's name. renamed tinyint(1) unsigned NO '0' Boolean 1 or 0. 1 = Pet has been renamed. slot int(11) unsigned NO '0' The pet slot that the pet is in. The slot is a number between 0 and 3 inclusive. curhealth int(11) unsigned NO '1' The current pet health at the time it was saved to DB. curmana int(11) unsigned NO '0' The current pet mana at the time it was saved to DB. curhappiness int(11) unsigned NO '0' The current pet happiness. savetime bigint(20) unsigned NO '0' The time when the pet was last saved, in Unix time. resettalents_cost int(11) unsigned NO '0' This is the cost to "untrain" the pet talents. resettalents_time bigint(20) unsigned NO '0' How many times the pets talents have been reset. abdata longtext YES NULL Data about pet action bar and action type ten pairs of action bar entry. Description of the fields id int(11) unsigned The special pet ID. This is a unique identifier among all pets. entry int(11) unsigned The creature entry of this pet. [See creature_template.entry]. owner int(11) unsigned The GUID of the pet's owner. [See character.guid]. modelid int(11) unsigned The model ID to use to display the pet. CreatedBySpell int(11) unsigned The ID of the spell that has created this pet. For hunters, this is usually the Tame Beast spell. For warlocks or other classes (mages), it is the spell ID that summoned the creature. [See Spell.dbc column 1] PetType tinyint(3) unsigned The type of pet that this is. 0 = summoned pet, 1 = tamed pet level int(11) unsigned The current level of the pet. exp int(11) unsigned The current experience that this pet has. For summoned pets, this field is always 0. Reactstate tinyint(1) unsigned The current reaction state of the pet (passive, aggressive, etc). name varchar(100) The pet's name. renamed tinyint(1) unsigned Boolean 1 or 0. 1 = Pet has been renamed, 0 = Pet has never been renamed and still uses the same name as the creature that was tamed. slot int(11) unsigned The pet slot that the pet is in. The slot is a number between 0 and 3 inclusive. curhealth int(11) unsigned The current pet health at the time it was saved to DB. curmana int(11) unsigned The current pet mana at the time it was saved to DB. curhappiness int(11) unsigned The current pet happiness. savetime bigint(20) unsigned The time when the pet was last saved, in Unix time. resettalents_cost int(11) unsigned This is the cost to "untrain" the pet talents. resettalents_time bigint(20) unsigned How many times the pets talents have been reset. abdata longtext data about pet action bar and action type ten pairs of action bar entry (from 1 to 10) and action or spell IDs 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_pet_declinedname' table for MaNGOSTwo 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' owner int(11) unsigned NO MUL '0' genitive varchar(12) NO {Blank String} dative varchar(12) NO {Blank String} accusative varchar(12) NO {Blank String} instrumental varchar(12) NO {Blank String} prepositional varchar(12) NO {Blank String} Description of the fields id int(11) unsigned owner int(11) unsigned genitive varchar(12) dative varchar(12) accusative varchar(12) instrumental varchar(12) prepositional varchar(12) 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_queststatus' table for MaNGOSTwo Holds information on the quest status of 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 '0' The GUID of the character. [See character.guid]. quest int(11) unsigned NO PRI '0' The quest ID. [See quest_template.entry]. status int(11) unsigned NO '0' The current quest status. rewarded tinyint(1) unsigned NO '0' Boolean 1 or 0 representing whether the quest has been rewarded or not. explored tinyint(1) unsigned NO '0' Boolean 1 or 0 representing if the character has explored what was needed. timer bigint(20) unsigned NO '0' Remaining time left on the quest if the quest has a timer [See quest_template]. mobcount1 int(11) unsigned NO '0' Current count of the first number of kills or casts. mobcount2 int(11) unsigned NO '0' Current count of the second number of kills or casts. mobcount3 int(11) unsigned NO '0' Current count of the third number of kills or casts. mobcount4 int(11) unsigned NO '0' Current count of the forth number of kills or casts. itemcount1 int(11) unsigned NO '0' Current item count for the first item in a delivery quest, if any. itemcount2 int(11) unsigned NO '0' Current item count for the second item in a delivery quest, if any. itemcount3 int(11) unsigned NO '0' Current item count for the third item in a delivery quest, if any. itemcount4 int(11) unsigned NO '0' Current item count for the forth item in a delivery quest, if any. itemcount5 int(11) unsigned NO '0' itemcount6 int(11) unsigned NO '0' Description of the fields guid int(11) unsigned The GUID of the character. [See character.guid]. quest int(11) unsigned The quest ID. [See quest_template.entry]. status int(11) unsigned The current quest status. Value Status Flag Notes 0 QUEST_STATUS_NONE Quest isn't shown in quest list - default value 1 QUEST_STATUS_COMPLETE Quest has been completed. 2 QUEST_STATUS_UNAVAILABLE Quest is unavailable to the character. 3 QUEST_STATUS_INCOMPLETE Quest is active in quest log but incomplete 4 QUEST_STATUS_AVAILABLE Quest is available to be taken by character 5 QUEST_STATUS_FAILED Quest requires not achieved. (i.e. Woo Ping must survive) 6 QUEST_STATUS_FORCE_COMPLETE This quest was force completed by GM command rewarded tinyint(1) unsigned Boolean 1 or 0 representing whether the quest has been rewarded or not. explored tinyint(1) unsigned Boolean 1 or 0 representing if the character has explored what was needed to explore for the quest. timer bigint(20) unsigned Remaining time left on the quest if the quest has a timer. [See quest_template.LimitTime]. mobcount1 int(11) unsigned Current count of the number of kills or casts on the second creature or gameobject, if any. Corresponds with quest_template.ReqCreatureOrGOCount1 mobcount2 int(11) unsigned Current count of the number of kills or casts on the second creature or gameobject, if any. Corresponds with quest_template.ReqCreatureOrGOCount2 mobcount3 int(11) unsigned Current count of the number of kills or casts on the third creature or gameobject, if any. Corresponds with quest_template.ReqCreatureOrGOCount3 mobcount4 int(11) unsigned Current count of the number of kills or casts on the forth creature or gameobject, if any. Corresponds with quest_template.ReqCreatureOrGOCount4 itemcount1 int(11) unsigned Current item count for the first item in a delivery quest, if any. Corresponds with quest_template.ReqItemCount1 itemcount2 int(11) unsigned Current item count for the second item in a delivery quest, if any. Corresponds with quest_template.ReqItemCount2 itemcount3 int(11) unsigned Current item count for the third item in a delivery quest, if any. Corresponds with quest_template.ReqItemCount3 itemcount4 int(11) unsigned Current item count for the forth item in a delivery quest, if any. Corresponds with quest_template.ReqItemCount4 itemcount5 int(11) unsigned itemcount6 int(11) unsigned 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_queststatus_daily' table for MaNGOSTwo 'Player System' 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' quest int(11) unsigned NO PRI '0' Description of the fields guid int(11) unsigned Notes: Global Unique Identifier quest int(11) unsigned Notes: Quest Identifier 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_queststatus_weekly' table for MaNGOSTwo 'Player System' 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' quest int(11) unsigned NO PRI '0' Description of the fields guid int(11) unsigned Notes: Global Unique Identifier quest int(11) unsigned Notes: Quest Identifier auto-generated by the getMaNGOS.eu MAGNET dbdocs module