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 'ai_playerbot_random_bots' table for MaNGOSZero Table Notes This table uses the 'InnoDB' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes id bigint(20) NO PRI NULL 'auto_increment' owner bigint(20) NO MUL NULL bot bigint(20) NO MUL NULL time bigint(20) NO NULL validIn bigint(20) YES NULL event varchar(45) YES MUL {Blank String} value bigint(20) YES NULL data varchar(255) YES {Blank String} Description of the fields id bigint(20) owner bigint(20) bot bigint(20) time bigint(20) validIn bigint(20) event varchar(45) value bigint(20) data varchar(255) 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 MaNGOSZero 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 'characters' table for MaNGOSZero 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] 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. honor_highest_rank int(11) unsigned NO '0' This shows the highest honor rank ever earned. honor_standing int(11) unsigned NO '0' stored_honor_rating float NO '0' This is the current amount of honor points. stored_dishonorable_kills int(11) NO '0' The is the total dishonorable kills made by the character. stored_honorable_kills int(11) NO '0' The is the total honorable kills made by the character. watchedFaction int(10) unsigned NO '0' The faction whose rep is being followed on the experience bar. drunk smallint(5) 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. 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. 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] 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. honor_highest_rank int(11) unsigned This shows the highest rank honor ever earned, niot necessarily the current rank. Enlisted ranks Rank Rating Points Alliance Title Horde Title Reward 1 15 HK [See note] Private Scout Tabard 2 2000 Corporal Grunt Team insignia trinket 3 5000 Sergeant Sergeant Superior-quality cloak10% discount on all goods and repairs from your faction's NPCs 4 10000 Master Sergeant Senior Sergeant Superior-quality necklace 5 15000 Sergeant Major First Sergeant Superior-quality bracers Officer ranks Rank Rating Points Alliance Title Horde Title Reward 6 20000 Knight Stone Guard Access to officer's barracksOfficer's tabardOfficer's potions (Combat Healing Potion and Combat Mana Potion) 7 25000 Knight-Lieutenant Blood Guard Superior-quality bootsSuperior-quality gloves 8 30000 Knight-Captain Legionnaire Superior-quality chest armorSuperior-quality leggings 9 35000 Knight-Champion Centurion Battle standard 10 40000 Lieutenant Commander Champion Superior-quality helmSuperior-quality shoulder armor 11 45000 (1.4%) Commander Lieutenant General Epic mountAbility to talk in World Defense 12 50000 Marshal General Epic-quality glovesEpic-quality leggingsEpic-quality boots 13 55000 Field Marshal Warlord Epic-quality helmEpic-quality shoulder armorEpic-quality chest 14 60000 (0.1%) Grand Marshal High Warlord Epic-quality weaponEpic-quality shieldOnly top .1% of players can have this rank honor_standing int(11) unsigned stored_honor_rating float This is the current amount of honor points, and relates to the character's current honor rank. See the tables under honor_highest_rank. stored_dishonorable_kills int(11) The is the total dishonorable kills made by the character. stored_honorable_kills int(11) The is the total honorable kills made by the character. 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 smallint(5) 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. 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 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_aura' table for MaNGOSZero 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_action' table for MaNGOSZero 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]. 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] 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_battleground_data' table for MaNGOSZero 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. 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. 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 MaNGOSZero 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_gifts' table for MaNGOSZero 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_honor_cp' table for MaNGOSZero This table holds information on the honor kills made by 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 MUL '0' The global unique identifier player character (victor) victim_type tinyint(3) unsigned NO '4' This appears to be 4 for a player and 3 for an NPC. victim int(11) unsigned NO '0' The global unique identifier player character (victim) honor float NO '0' Amount of honor earned for the honor kill. date int(11) unsigned NO '0' The date the honor kill occured. type tinyint(3) unsigned NO '0' The is appears to be 1 for player and 2 for NPC. used tinyint(1) NO '0' Description of the fields guid int(11) unsigned The global unique identifier player character (victor) victim_type tinyint(3) unsigned This appears to be 4 for a player and 3 for an NPC. victim int(11) unsigned The global unique identifier player character (victim) honor float Amount of honor earned for the honor kill. date int(11) unsigned The date the honor kill occured. type tinyint(3) unsigned The is appears to be 1 for player and 2 for NPC. used tinyint(1) Notes: =1 if already counted in rank points 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 MaNGOSZero 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 MaNGOSZero 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_pet' table for MaNGOSZero 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). loyaltypoints int(11) NO '0' The current amount of loyalty points the pet has. loyalty int(11) unsigned NO '0' The pet's loyalty level. trainpoint int(11) NO '0' Total training points available to spend. 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. teachspelldata longtext YES NULL This field holds IDs of spells that have been taught to this pet. 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). loyaltypoints int(11) The current amount of loyalty points the pet has. loyalty int(11) unsigned The pet's loyalty level. Loyalty Value REBELLIOUS 1 UNRULY 2 SUBMISSIVE 3 DEPENDABLE 4 FAITHFUL 5 BEST_FRIEND 6 trainpoint int(11) Total training points available to spend. 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 teachspelldata longtext This field holds IDs of spells that have been taught to this pet, abilities that this pet has. 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 MaNGOSZero 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. 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 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 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