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_declinedname' table for MaNGOSThree 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' 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_currencies' table for MaNGOSThree 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' id smallint(5) unsigned NO PRI '0' totalCount int(11) unsigned NO '0' weekCount int(11) unsigned NO '0' seasonCount int(11) unsigned NO '0' flags tinyint(2) unsigned NO '0' Description of the fields guid int(11) unsigned id smallint(5) unsigned totalCount int(11) unsigned weekCount int(11) unsigned seasonCount int(11) unsigned flags tinyint(2) 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 MaNGOSThree 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_gifts' table for MaNGOSThree 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_homebind' table for MaNGOSThree 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 '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. [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_glyphs' table for MaNGOSThree 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_instance' table for MaNGOSThree 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_inventory' table for MaNGOSThree Contains all the character inventory data, including the bank data. 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 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_pet' table for MaNGOSThree This table holds the pet data for each pet summoned by anyone in the game. 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 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. 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. 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 MaNGOSThree 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' 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 MaNGOSThree Holds information on the quest status of 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 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_phase_data' table for MaNGOSThree 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 PRI NULL map smallint(6) NO NULL phase int(11) NO '0' Description of the fields guid int(11) map smallint(6) phase 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_queststatus_monthly' table for MaNGOSThree 'Player System' 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' 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_daily' table for MaNGOSThree 'Player System' 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' 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_reputation' table for MaNGOSThree This table holds the reputation information of each faction for 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]. 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_queststatus_weekly' table for MaNGOSThree 'Player System' 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' 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_skills' table for MaNGOSThree This table holds a listing of all skill 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 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 MaNGOSThree Holds information for each character's spells. 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. [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_social' table for MaNGOSThree Contains data about character's friends/ignored list. 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] 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. note varchar(48) NO {Blank String} 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 note varchar(48) Notes: Friend Note 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 MaNGOSThree 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 MaNGOSThree 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 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. spellCritPct float unsigned NO '0' attackPower int(10) unsigned NO '0' Character's current attackpower. rangedAttackPower int(10) unsigned NO '0' Character's current ranged attackpower. spellPower int(10) unsigned NO '0' 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 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. spellCritPct float unsigned attackPower int(10) unsigned Character's current attackpower. rangedAttackPower int(10) unsigned Character's current ranged attackpower. spellPower 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 'character_talent' table for MaNGOSThree 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 talent_id int(11) unsigned NO PRI NULL current_rank tinyint(3) unsigned NO '0' spec tinyint(3) unsigned NO PRI '0' Description of the fields guid int(11) unsigned talent_id int(11) unsigned current_rank tinyint(3) unsigned spec tinyint(3) 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_tutorial' table for MaNGOSThree This table is used to store the tutorial state of all the characters. Table Notes This table uses the 'InnoDB' 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 MaNGOSThree Holds ticket information from tickets written through the client help request -function. Table Notes This table uses the 'InnoDB' 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. 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. 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 MaNGOSThree This table is used to store status of players corpse. 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 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] phaseMask int(11) unsigned NO '1' 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] phaseMask int(11) unsigned 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