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 'pvpstats_players' 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 battleground_id bigint(20) unsigned NO PRI NULL character_guid int(10) unsigned NO PRI NULL score_killing_blows mediumint(8) unsigned NO NULL score_deaths mediumint(8) unsigned NO NULL score_honorable_kills mediumint(8) unsigned NO NULL score_bonus_honor mediumint(8) unsigned NO NULL score_damage_done mediumint(8) unsigned NO NULL score_healing_done mediumint(8) unsigned NO NULL attr_1 mediumint(8) unsigned NO '0' attr_2 mediumint(8) unsigned NO '0' attr_3 mediumint(8) unsigned NO '0' attr_4 mediumint(8) unsigned NO '0' attr_5 mediumint(8) unsigned NO '0' Description of the fields battleground_id bigint(20) unsigned character_guid int(10) unsigned score_killing_blows mediumint(8) unsigned score_deaths mediumint(8) unsigned score_honorable_kills mediumint(8) unsigned score_bonus_honor mediumint(8) unsigned score_damage_done mediumint(8) unsigned score_healing_done mediumint(8) unsigned attr_1 mediumint(8) unsigned attr_2 mediumint(8) unsigned attr_3 mediumint(8) unsigned attr_4 mediumint(8) unsigned attr_5 mediumint(8) 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 'pet_spell_cooldown' table for MaNGOSThree This table holds information on pet spell cooldowns. 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 pet. [See character_pet.id] spell int(11) unsigned NO PRI '0' The spell ID to which the cooldown applies. time bigint(20) unsigned NO '0' The time when the cooldown expires, in Unix time. Description of the fields guid int(11) unsigned The GUID of the pet. [See character_pet.id] spell int(11) unsigned The spell ID to which the cooldown applies. time bigint(20) unsigned The time when the cooldown expires, 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 'warden_action' 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 wardenId smallint(5) unsigned NO PRI NULL action tinyint(3) unsigned YES NULL Description of the fields wardenId smallint(5) unsigned action 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 'saved_variables' table for MaNGOSThree Stores server required values. i.e. Character Database cleanup flags and Honor Point / Rank reset date Table Notes This table uses the 'MyISAM' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes NextArenaPointDistributionTime bigint(40) unsigned NO '0' NextDailyQuestResetTime bigint(40) unsigned NO '0' NextWeeklyQuestResetTime bigint(40) unsigned NO '0' NextMonthlyQuestResetTime bigint(40) unsigned NO '0' NextRandomBGResetTime bigint(40) unsigned NO '0' cleaning_flags int(11) unsigned NO '0' The flags controlling character cleanup. Description of the fields NextArenaPointDistributionTime bigint(40) unsigned NextDailyQuestResetTime bigint(40) unsigned NextWeeklyQuestResetTime bigint(40) unsigned NextMonthlyQuestResetTime bigint(40) unsigned NextRandomBGResetTime bigint(40) unsigned cleaning_flags int(11) unsigned The flags controlling character cleanup: Value Enum Name Meaning 0x2 CLEANING_FLAG_SKILLS Clean out obsolete Skills [See character_skills]. 0x4 CLEANING_FLAG_SPELLS Clean out obsolete Spells (See character_spells). 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 'world' table for MaNGOSThree Stores World Status information Table Notes This table uses the 'InnoDB' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes map int(11) unsigned NO PRI '0' The map ID [See Map.dbc] data longtext YES NULL Specific data belonging to the world. Description of the fields map int(11) unsigned The map ID [See Map.dbc] data longtext Specific data belonging to the world. 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 'account_data' table for MaNGOSTwo Table Notes This table uses the 'InnoDB' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes account int(11) unsigned NO PRI '0' type int(11) unsigned NO PRI '0' time bigint(11) unsigned NO '0' data longblob NO NULL Description of the fields account int(11) unsigned type int(11) unsigned time bigint(11) unsigned data longblob auto-generated by the getMaNGOS.eu MAGNET dbdocs module

NOTE: This page is auto-generated from the MAGNET DBDocs module, Any changes made directly to this page will be lost when it is regenerated. Description of the 'ahbot_category' table for MaNGOSTwo Table Notes This table uses the 'InnoDB' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes id bigint(20) NO PRI NULL 'auto_increment' category varchar(45) YES MUL {Blank String} multiplier decimal(20,2) NO NULL max_auction_count bigint(20) NO NULL expire_time bigint(20) NO NULL Description of the fields id bigint(20) Notes: Unique identifier of the category category varchar(45) Notes: An Item category Id multiplier decimal(20,2) Notes: The cost multiplier max_auction_count bigint(20) Notes: The max number of items of this category in the AH. expire_time bigint(20) Notes: The UNIX time when the item will expire. 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 'ahbot_price' table for MaNGOSTwo Table Notes This table uses the 'InnoDB' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes id bigint(20) NO PRI NULL 'auto_increment' item varchar(45) YES MUL {Blank String} price decimal(20,2) NO NULL auction_house bigint(20) NO NULL Description of the fields id bigint(20) item varchar(45) price decimal(20,2) auction_house bigint(20) 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 'ahbot_history' table for MaNGOSTwo Table Notes This table uses the 'InnoDB' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes id bigint(20) NO PRI NULL 'auto_increment' buytime bigint(20) NO NULL item bigint(20) NO NULL bid bigint(20) NO NULL buyout bigint(20) NO NULL won bigint(20) NO MUL NULL category varchar(45) YES MUL {Blank String} auction_house bigint(20) NO MUL NULL Description of the fields id bigint(20) buytime bigint(20) item bigint(20) bid bigint(20) buyout bigint(20) won bigint(20) category varchar(45) Notes: An Item category Id from the list below: auction_house bigint(20) 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 'ai_playerbot_names' table for MaNGOSTwo 'PlayerbotAI AutoBot names' Table Notes This table uses the 'MyISAM' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes name_id mediumint(8) NO PRI NULL 'auto_increment' name varchar(13) NO UNI {Blank String} gender tinyint(3) unsigned NO NULL race smallint(5) unsigned NO NULL class smallint(5) unsigned NO NULL purpose int(11) unsigned NO NULL priority bit(1) NO NULL in_use bit(1) NO NULL Description of the fields name_id mediumint(8) name varchar(13) gender tinyint(3) unsigned Notes: The Gender of the bot race smallint(5) unsigned Notes: The Race of the bot class smallint(5) unsigned purpose int(11) unsigned priority bit(1) in_use bit(1) 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 'ai_playerbot_random_bots' table for MaNGOSTwo Table Notes This table uses the 'InnoDB' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes 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 'arena_team' table for MaNGOSTwo Table Notes This table uses the 'InnoDB' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes arenateamid int(10) unsigned NO PRI '0' name char(255) NO {Blank String} captainguid int(10) unsigned NO '0' type tinyint(3) unsigned NO '0' BackgroundColor int(10) unsigned NO '0' EmblemStyle int(10) unsigned NO '0' EmblemColor int(10) unsigned NO '0' BorderStyle int(10) unsigned NO '0' BorderColor int(10) unsigned NO '0' Description of the fields arenateamid int(10) unsigned name char(255) captainguid int(10) unsigned type tinyint(3) unsigned BackgroundColor int(10) unsigned EmblemStyle int(10) unsigned EmblemColor int(10) unsigned BorderStyle int(10) unsigned BorderColor 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 'arena_team_stats' table for MaNGOSTwo Table Notes This table uses the 'InnoDB' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes arenateamid int(10) unsigned NO PRI '0' rating int(10) unsigned NO '0' games_week int(10) unsigned NO '0' wins_week int(10) unsigned NO '0' games_season int(10) unsigned NO '0' wins_season int(10) unsigned NO '0' rank int(10) unsigned NO '0' Description of the fields arenateamid int(10) unsigned rating int(10) unsigned games_week int(10) unsigned wins_week int(10) unsigned games_season int(10) unsigned wins_season int(10) unsigned rank 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 'arena_team_member' table for MaNGOSTwo Table Notes This table uses the 'InnoDB' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes arenateamid int(10) unsigned NO PRI '0' guid int(10) unsigned NO PRI '0' played_week int(10) unsigned NO '0' wons_week int(10) unsigned NO '0' played_season int(10) unsigned NO '0' wons_season int(10) unsigned NO '0' personal_rating int(10) unsigned NO '0' Description of the fields arenateamid int(10) unsigned guid int(10) unsigned played_week int(10) unsigned wons_week int(10) unsigned played_season int(10) unsigned wons_season int(10) unsigned personal_rating int(10) unsigned auto-generated by the getMaNGOS.eu MAGNET dbdocs module

NOTE: This page is auto-generated from the MAGNET DBDocs module, Any changes made directly to this page will be lost when it is regenerated. Description of the 'auction' table for MaNGOSTwo Contains all information about the currently ongoing auctions in the auction houses. It controls what items are put up for auction and who put it up, who is the highest bidder, etc. Table Notes This table uses the 'InnoDB' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes id int(11) unsigned NO PRI '0' Unique identifier for every auction. houseid int(11) unsigned NO '0' The AuctionHouseId [See AuctionHouse.dbc] itemguid int(11) unsigned NO '0' The GUID of the item that is up for auction. [See item_instance.guid] item_template int(11) unsigned NO '0' The entry of the item up for auction. See (item_template.entry) item_count int(11) unsigned NO '0' The stack count of the item item_randompropertyid int(11) NO '0' A link to the Item's RandomProperty Id [See item_template.Randompropertyid]. itemowner int(11) unsigned NO '0' The GUID of the owner of the item up for auction. [See character.guid] buyoutprice int(11) NO '0' The buyout price of the item in copper. time bigint(40) unsigned NO '0' The time when this auction will end, measured in Unix time. moneyTime bigint(40) unsigned NO '0' buyguid int(11) unsigned NO '0' The GUID of the highest bidder. See (character.guid) lastbid int(11) NO '0' The amount of copper of the last bid made on the item. startbid int(11) NO '0' The amount of copper of the starting bid made on the item. deposit int(11) NO '0' The amount of copper spent on the deposit. Description of the fields id int(11) unsigned Unique identifier for every auction. houseid int(11) unsigned The AuctionHouseId [See AuctionHouse.dbc] itemguid int(11) unsigned The GUID of the item that is up for auction. [See item_instance.guid] item_template int(11) unsigned The entry of the item up for auction. See (item_template.entry) item_count int(11) unsigned The stack count of the item item_randompropertyid int(11) A link to the Item's RandomProperty Id [See item_template.Randompropertyid]. itemowner int(11) unsigned The GUID of the owner of the item up for auction. [See character.guid] buyoutprice int(11) The buyout price of the item in copper. Divide by 100 to get silver and by 100 again to get gold. time bigint(40) unsigned The time when this auction will end, measured in Unix time (number of seconds from 00:00 Jan 1, 1970). moneyTime bigint(40) unsigned buyguid int(11) unsigned The GUID of the highest bidder. See (character.guid) lastbid int(11) The amount of copper of the last bid made on the item. startbid int(11) The amount of copper of the starting bid made on the item. deposit int(11) The amount of copper spent on the deposit. auto-generated by the getMaNGOS.eu MAGNET dbdocs module

NOTE: This page is auto-generated from the MAGNET DBDocs module, Any changes made directly to this page will be lost when it is regenerated. Description of the 'calendar_events' table for MaNGOSTwo Table Notes This table uses the 'InnoDB' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes eventId bigint(10) unsigned NO PRI '0' creatorGuid int(10) unsigned NO '0' guildId int(10) unsigned NO '0' type tinyint(3) unsigned NO '4' flags int(10) unsigned NO '0' dungeonId int(10) NO '-1' eventTime int(10) unsigned NO '0' title varchar(128) NO {Blank String} description varchar(1024) NO {Blank String} Description of the fields eventId bigint(10) unsigned creatorGuid int(10) unsigned guildId int(10) unsigned type tinyint(3) unsigned flags int(10) unsigned dungeonId int(10) eventTime int(10) unsigned title varchar(128) description varchar(1024) auto-generated by the getMaNGOS.eu MAGNET dbdocs module

NOTE: This page is auto-generated from the MAGNET DBDocs module, Any changes made directly to this page will be lost when it is regenerated. Description of the 'bugreport' table for MaNGOSTwo This table stores all the Bugs/Suggestions submitted in-game by Players. Table Notes This table uses the 'MyISAM' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes id int(11) NO PRI NULL 'auto_increment' Auto generated value when records are inserted by the core. type longtext NO NULL The text description of the type of bug report / suggestion. content longtext NO NULL The text content of the bug/suggestion. Description of the fields id int(11) Auto generated value when records are inserted by the core. This id is just here to be a primary key and eases the data insertion. This field is also a auto increment field type longtext The text description of the type of bug report / suggestion. content longtext The text content of the bug/suggestion. auto-generated by the getMaNGOS.eu MAGNET dbdocs module

NOTE: This page is auto-generated from the MAGNET DBDocs module, Any changes made directly to this page will be lost when it is regenerated. Description of the 'calendar_invites' table for MaNGOSTwo Table Notes This table uses the 'InnoDB' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes inviteId bigint(10) unsigned NO PRI '0' eventId bigint(10) unsigned NO '0' inviteeGuid int(10) unsigned NO '0' senderGuid int(3) unsigned NO '0' status tinyint(10) unsigned NO '0' lastUpdateTime int(10) unsigned NO '0' rank tinyint(10) unsigned NO '0' Description of the fields inviteId bigint(10) unsigned eventId bigint(10) unsigned inviteeGuid int(10) unsigned senderGuid int(3) unsigned status tinyint(10) unsigned lastUpdateTime int(10) unsigned rank tinyint(10) unsigned auto-generated by the getMaNGOS.eu MAGNET dbdocs module

NOTE: This page is auto-generated from the MAGNET DBDocs module, Any changes made directly to this page will be lost when it is regenerated. Description of the 'characters' table for MaNGOSTwo This table holds vital static information for each character. This information loaded and used to create the player objects in-game. Table Notes This table uses the 'MyISAM' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes guid int(11) unsigned NO PRI '0' The character global unique identifier. account int(11) unsigned NO MUL '0' The account ID in which this character resides [See account.id] in the realm db. name varchar(12) NO MUL {Blank String} The name of the character. race tinyint(3) unsigned NO '0' The race of the character. class tinyint(3) unsigned NO '0' The Class Id of the character [See chrclasses.dbc]. gender tinyint(3) unsigned NO '0' The Sex/Gender of the character. level tinyint(3) unsigned NO '0' The current level of the designated player. xp int(10) unsigned NO '0' The total amount of xp that the signified player has. money int(10) unsigned NO '0' This is the amount of copper the character possesses. playerBytes int(10) unsigned NO '0' This defines the physical attributes of the character. playerBytes2 int(10) unsigned NO '0' This defines the facial hair physical attribute of the character. playerFlags int(10) unsigned NO '0' These are the player flags, such as GM mode on or off. position_x float NO '0' The x position of the character's location. position_y float NO '0' The y position of the character's location. position_z float NO '0' The z position of the character's location. map int(11) unsigned NO '0' The map ID the character is in [See maps.dbc] dungeon_difficulty tinyint(1) unsigned NO '0' orientation float NO '0' The orientation the character is facing. (North = 0.0, South = 3.14159) taximask longtext YES NULL online tinyint(3) unsigned NO MUL '0' Records whether the character is online (1) or offline (0). cinematic tinyint(3) unsigned NO '0' Boolean 1 or 0 controlling whether the start cinematic has been shown or not. totaltime int(11) unsigned NO '0' The total time that the character has been active in the world. leveltime int(11) unsigned NO '0' The total time the character has spent in the world at the current level. logout_time bigint(20) unsigned NO '0' The time when the character last logged out, measured in Unix time. is_logout_resting tinyint(3) unsigned NO '0' Boolean 1 or 0 controlling if the character is currently in a resting zone. rest_bonus float NO '0' This is the rest bonus for the character. resettalents_cost int(11) unsigned NO '0' The cost for the character to reset its talents, measured in copper. resettalents_time bigint(20) unsigned NO '0' trans_x float NO '0' The X coordinate of the character on the transport it is travelling on. trans_y float NO '0' The Y coordinate of the character on the transport it is travelling on. trans_z float NO '0' The Z coordinate of the character on the transport it is travelling on. trans_o float NO '0' The orientation of the character on the transport it is travelling on. transguid bigint(20) unsigned NO '0' This is the transprt the character is currently travelling on. extra_flags int(11) unsigned NO '0' These flags control certain player specific attributes, mostly GM features. stable_slots tinyint(1) unsigned NO '0' The number of stable slots the player has available. Maximum is 2. at_login int(11) unsigned NO '0' The status of the character. zone int(11) unsigned NO '0' The zone ID the character is in. death_expire_time bigint(20) unsigned NO '0' Time when a character can be resurrected. taxi_path text YES NULL Stores the players current taxi path (TaxiPath.dbc) if logged off while on one. arenaPoints int(10) unsigned NO '0' totalHonorPoints int(10) unsigned NO '0' todayHonorPoints int(10) unsigned NO '0' yesterdayHonorPoints int(10) unsigned NO '0' totalKills int(10) unsigned NO '0' todayKills smallint(5) unsigned NO '0' yesterdayKills smallint(5) unsigned NO '0' chosenTitle int(10) unsigned NO '0' knownCurrencies bigint(20) unsigned NO '0' watchedFaction int(10) unsigned NO '0' The faction whose rep is being followed on the experience bar. drunk tinyint(3) unsigned NO '0' This represents the alcoholic strength of the drink. health int(10) unsigned NO '0' The character's health when logging out. power1 int(10) unsigned NO '0' If a mana user, then this is a character's mana level when logging out. power2 int(10) unsigned NO '0' If a warrior, then this is a character's rage level when logging out. power3 int(10) unsigned NO '0' This is a hunter pet's focus level. power4 int(10) unsigned NO '0' If a rogue, then this is a character's energy level when logging out. power5 int(10) unsigned NO '0' This is the current active pet's happiness level. power6 int(10) unsigned NO '0' power7 int(10) unsigned NO '0' specCount tinyint(3) unsigned NO '1' activeSpec tinyint(3) unsigned NO '0' exploredZones longtext YES NULL This is a record of all areas discovered by the character. equipmentCache longtext YES NULL This is a record of all items that are currently equipped. ammoId int(10) unsigned NO '0' This is the item_template Entry ID of the ammo currently equipped. knownTitles longtext YES NULL actionBars tinyint(3) unsigned NO '0' This represents which action bars are currently active. deleteInfos_Account int(11) unsigned YES NULL This is the account number from the characters table. deleteInfos_Name varchar(12) YES {Blank String} The is the name of the character being deleted. deleteDate bigint(20) unsigned YES NULL This is the date the character was deleted, Description of the fields guid int(11) unsigned The character global unique identifier. This number must be unique and is the best way to identify separate characters. account int(11) unsigned The account ID in which this character resides. [See account.id] in the realm database. name varchar(12) The name of the character. race tinyint(3) unsigned The race of the character. Index Value Race Name 1 1 Human 2 2 Orc 3 4 Dwarf 4 8 Night Elf 5 16 Undead 6 32 Tauren 7 64 Gnome 8 128 Troll class tinyint(3) unsigned The Class Id of the character [See chrclasses.dbc] gender tinyint(3) unsigned The Sex/Gender of the character. Value Gender 0 Male 1 Female level tinyint(3) unsigned The current level of the designated player. xp int(10) unsigned The total amount of xp that the signified player has. money int(10) unsigned This is the amount of copper the character possesses. playerBytes int(10) unsigned This defines the following physical attributes of the character: skin, face, hairstyle, hair colour Attribute Offset Bits skin 0 0 - 7 face 8 8 - 15 hairStyle 16 16 - 23 hairColor 24 24 - 31 TODO (an example of setting an attribute) playerBytes2 int(10) unsigned This defines the facial hair physical attribute of the character. As with playerBytes, playerBytes2's bits (0 to 7) are used to change the character's facial hair TODO (an example of setting this attribute) playerFlags int(10) unsigned These are the player flags. They are represented as decimal values in the database table, and hexidecimal values in the table below. Flag Value Description PLAYER_FLAGS_NONE 0x00000000 PLAYER_FLAGS_GROUP_LEADER 0x00000001 PLAYER_FLAGS_AFK 0x00000002 Player is away from keyboard PLAYER_FLAGS_DND 0x00000004 Player has do not disturb set PLAYER_FLAGS_GM 0x00000008 GM mode is on PLAYER_FLAGS_GHOST 0x00000010 PLAYER_FLAGS_RESTING 0x00000020 Player is in a rest area, such as a town PLAYER_FLAGS_UNK7 0x00000040 admin? PLAYER_FLAGS_FFA_PVP 0x00000080 PLAYER_FLAGS_CONTESTED_PVP 0x00000100 Player has been involved in a PvP combat and will be attacked by contested guards PLAYER_FLAGS_IN_PVP 0x00000200 PLAYER_FLAGS_HIDE_HELM 0x00000400 Player has hide helm set PLAYER_FLAGS_HIDE_CLOAK 0x00000800 Player has hide cloak set PLAYER_FLAGS_PARTIAL_PLAY_TIME 0x00001000 played long time PLAYER_FLAGS_NO_PLAY_TIME 0x00002000 played too long time PLAYER_FLAGS_UNK15 0x00004000 PLAYER_FLAGS_UNK16 0x00008000 strange visual effect (2.0.1), looks like PLAYER_FLAGS_GHOST flag PLAYER_FLAGS_SANCTUARY 0x00010000 player entered sanctuary PLAYER_FLAGS_TAXI_BENCHMARK 0x00020000 taxi benchmark mode (on/off) (2.0.1) PLAYER_FLAGS_PVP_TIMER 0x00040000 position_x float The x position of the character's location. position_y float The y position of the character's location. position_z float The z position of the character's location. map int(11) unsigned The map ID the character is in. [See map.dbc] dungeon_difficulty tinyint(1) unsigned orientation float The orientation the character is facing. (North = 0.0, South = 3.14159) taximask longtext online tinyint(3) unsigned Records whether the character is online (1) or offline (0). cinematic tinyint(3) unsigned Boolean 1 or 0 controlling whether the start cinematic has been shown or not. totaltime int(11) unsigned The total time that the character has been active in the world, measured in seconds. leveltime int(11) unsigned The total time the character has spent in the world at the current level, measured in seconds. logout_time bigint(20) unsigned The time when the character last logged out, measured in Unix time. is_logout_resting tinyint(3) unsigned Boolean 1 or 0 controlling if the character is currently in a resting zone or not. rest_bonus float This is part of the rest system, and is used to calculate how much rest bonus to give the player when they have been offline. Rest bonus affects the amount of experience the character can earn, resettalents_cost int(11) unsigned The cost for the character to reset its talents, measured in copper. resettalents_time bigint(20) unsigned trans_x float The X coordinate of the character on the transport it is travelling on at the point of logging off. trans_y float The Y coordinate of the character on the transport it is travelling on at the point of logging off. trans_z float The Z coordinate of the character on the transport it is travelling on at the point of logging off. trans_o float The orientation of the character on the transport it is travelling on at the point of logging off. transguid bigint(20) unsigned This is the transprt the character is currently travelling on. It's the entry ID from the transports table. extra_flags int(11) unsigned These flags control certain player specific attributes, mostly GM features Bit Name Description 1 PLAYER_EXTRA_GM_ON Defines GM state 2 PLAYER_EXTRA_GM_ACCEPT_TICKETS Defines if tickets are accepted 4 PLAYER_EXTRA_ACCEPT_WHISPERS Defines if whispers are accepted 8 PLAYER_EXTRA_TAXICHEAT Sets taxicheat 16 PLAYER_EXTRA_GM_INVISIBLE Control's GM's invisibly 32 PLAYER_EXTRA_GM_CHAT Show GM badge in chat messages 64 PLAYER_EXTRA_PVP_DEATH Store PvP death status until corpse creating stable_slots tinyint(1) unsigned The number of stable slots the player has available. Maximum is 2. at_login int(11) unsigned The status of the character. Value Meaning 1 Force character to change name 2 Reset spells (professions as well) 4 Reset talents 8 Character Customization enabled zone int(11) unsigned The zone ID the character is in. death_expire_time bigint(20) unsigned Time when a character can be resurrected in case of a server crash or client exit while in ghost form. taxi_path text Stores the players current taxi path (TaxiPath.dbc) if logged off while on one. arenaPoints int(10) unsigned totalHonorPoints int(10) unsigned todayHonorPoints int(10) unsigned yesterdayHonorPoints int(10) unsigned totalKills int(10) unsigned todayKills smallint(5) unsigned yesterdayKills smallint(5) unsigned chosenTitle int(10) unsigned knownCurrencies bigint(20) unsigned watchedFaction int(10) unsigned The faction whose rep is being followed on the experience bar. Only one faction at a time can be followed. The ID of the faction being followed will appear in this field, e.g. 18 for Gnomeragan Exiles 20 for Ironforge 21 for Darnassus These are not the same as the Faction IDs from the DBC file. drunk tinyint(3) unsigned This represents the alcoholic strength of the drink. The stronger the drinker, the longer your character is drunk for health int(10) unsigned The character's health when logging out. power1 int(10) unsigned The character's mana level when logging out. power2 int(10) unsigned If a warrior, then this is character's rage level when logging out. power3 int(10) unsigned This is a hunter pet's focus level at point of logging off. power4 int(10) unsigned If a rogue, then this is character's energy level when logging out. power5 int(10) unsigned This is the current active pet's happiness level at the point of logging off. power6 int(10) unsigned power7 int(10) unsigned specCount tinyint(3) unsigned activeSpec tinyint(3) unsigned exploredZones longtext This is a record of all areas discovered by the character. equipmentCache longtext This is a record of all items that are currently equipped. Changing this information does not affect what is equipped. It will just revert back to what was originally equipped. ammoId int(10) unsigned This is the item_template Entry ID of the ammo currently equipped. e.g. 2516 light shot knownTitles longtext actionBars tinyint(3) unsigned This represents which action bars are currently active. Value Action bar 1 bottom left 2 bottom right 4 right action bar 12 right action bar and action bar2 A combination of the above gives you which action bars are currently active, e.g. 3 will be bottom left and bottom right, 7 will be bottom left and right bars and the right action bar, and 19 will be all action bars active. deleteInfos_Account int(11) unsigned This is the account number from the characters table, that the deleted character is on. deleteInfos_Name varchar(12) The is the name of the character being deleted. deleteDate bigint(20) unsigned This is the date the character was deleted, auto-generated by the getMaNGOS.eu MAGNET dbdocs module

NOTE: This page is auto-generated from the MAGNET DBDocs module, Any changes made directly to this page will be lost when it is regenerated. Description of the 'character_achievement' table for MaNGOSTwo Table Notes This table uses the 'InnoDB' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes guid int(11) unsigned NO PRI NULL achievement int(11) unsigned NO PRI NULL date bigint(11) unsigned NO '0' Description of the fields guid int(11) unsigned achievement int(11) unsigned date bigint(11) unsigned auto-generated by the getMaNGOS.eu MAGNET dbdocs module

NOTE: This page is auto-generated from the MAGNET DBDocs module, Any changes made directly to this page will be lost when it is regenerated. Description of the 'character_account_data' table for MaNGOSTwo Table Notes This table uses the 'InnoDB' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes guid int(11) unsigned NO PRI '0' type int(11) unsigned NO PRI '0' time bigint(11) unsigned NO '0' data longblob NO NULL Description of the fields guid int(11) unsigned type int(11) unsigned time bigint(11) unsigned data longblob auto-generated by the getMaNGOS.eu MAGNET dbdocs module

NOTE: This page is auto-generated from the MAGNET DBDocs module, Any changes made directly to this page will be lost when it is regenerated. Description of the 'character_action' table for MaNGOSTwo This table contains all the individual button data for each character. A button is any of the places in the GUI where you can place for example a spell, item, or macro as a shortcut. Table Notes This table uses the 'MyISAM' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes guid int(11) unsigned NO PRI '0' The GUID of the character [See character.id]. spec tinyint(3) unsigned NO PRI '0' button tinyint(3) unsigned NO PRI '0' The ID of the button on the action bar where the action icon will be placed. action int(11) unsigned NO '0' Depending on the type value, this could be various values. type tinyint(3) unsigned NO '0' The type of action. Description of the fields guid int(11) unsigned The GUID of the character. [See character.id] spec tinyint(3) unsigned button tinyint(3) unsigned The ID of the button on the action bar where the action icon will be placed. Special bars are used for stances, auras, pets, stealth, and other similar special modes. Button ID's Set (key) 1-11 1 (SHIFT + 1) 12-23 2 (SHIFT + 2) 24-35 3 (SHIFT + 3) == Right Side Bar 36-47 4 (SHIFT + 4) == Right Side Bar 2 48-59 5 (SHIFT + 5) == Bottom Right Bar 60-71 6 (SHIFT + 6) == Bottom Left Bar 72-83 1 SpecialA 84-95 1 SpecialB 96-107 1 SpecialC 108-119 1 SpecialD action int(11) unsigned Depending on the type value, this could be either the spell ID (Spell.dbc), the item_template.entry or macro ID. type tinyint(3) unsigned The type of action: Value Possible types 0 Spell 64 Macro 128 Item auto-generated by the getMaNGOS.eu MAGNET dbdocs module

NOTE: This page is auto-generated from the MAGNET DBDocs module, Any changes made directly to this page will be lost when it is regenerated. Description of the 'character_achievement_progress' table for MaNGOSTwo Table Notes This table uses the 'InnoDB' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes guid int(11) unsigned NO PRI NULL criteria int(11) unsigned NO PRI NULL counter int(11) unsigned NO NULL date bigint(11) unsigned NO '0' Description of the fields guid int(11) unsigned criteria int(11) unsigned counter int(11) unsigned date bigint(11) unsigned auto-generated by the getMaNGOS.eu MAGNET dbdocs module

NOTE: This page is auto-generated from the MAGNET DBDocs module, Any changes made directly to this page will be lost when it is regenerated. Description of the 'character_aura' table for MaNGOSTwo Contains aura information that is loaded when a character is loaded, so the auras that were on the character when it logged out are still kept when it logs back in. A spell can have up to three auras, one in each of its effects. Table Notes This table uses the 'MyISAM' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes guid int(11) unsigned NO PRI '0' The GUID (Full Global Unique Identifier) of the target affected by the aura. caster_guid bigint(20) unsigned NO PRI '0' The GUID (Global Unique Identifier) of the player who cast the aura. item_guid int(11) unsigned NO PRI '0' The GUID (Global Unique Identifier) of the item which casted the aura. spell int(11) unsigned NO PRI '0' The spell from which the aura was applied. [See Spell.dbc] stackcount int(11) unsigned NO '1' Determines how many stacks of the spell the character has. remaincharges int(11) unsigned NO '0' The number of charges remaining on the aura. basepoints0 int(11) NO '0' Primary effect. basepoints1 int(11) NO '0' Secondary effect (healing) basepoints2 int(11) NO '0' Secondary effect (damage) periodictime0 int(11) unsigned NO '0' Primary effect over time counter. periodictime1 int(11) unsigned NO '0' Primary effect (healing) over time counter. periodictime2 int(11) unsigned NO '0' Primary effect (damage) over time counter. maxduration int(11) NO '0' The maximum duration of the aura. remaintime int(11) NO '0' The time remaining in seconds on the aura. -1 means that the aura is indefinite. effIndexMask int(11) unsigned NO '0' The effect index of the spell from which the aura came from. Description of the fields guid int(11) unsigned The GUID (Full Global Unique Identifier) of the target affected by the aura. [See character.id]. caster_guid bigint(20) unsigned The GUID (Global Unique Identifier) of the player who cast the aura. [See character.id]. item_guid int(11) unsigned The GUID (Global Unique Identifier) of the item which casted the aura. [See item_instance.guid]. spell int(11) unsigned The spell from which the aura was applied. [See Spell.dbc column 1] stackcount int(11) unsigned Determines how many stacks of the spell the character has. remaincharges int(11) unsigned The number of charges remaining on the aura. basepoints0 int(11) Primary effect, such as Priest's heal, Warloack Demon skin, or Paladin's Seal of Righteousness. The effect can be positive or negative. basepoints1 int(11) This is a secondary effect and appears to be healing related, such as the Warlock Demon skin heal over time. basepoints2 int(11) This is a secondary effect, and appears to be damage related, such unleasing the Paladin's Seal of Righteousness. periodictime0 int(11) unsigned Primary effect over time counter, such as the Priest's heal. periodictime1 int(11) unsigned Primary effect (healing) over time counter. periodictime2 int(11) unsigned Primary effect (damage) over time counter. maxduration int(11) The maximum duration of the aura. remaintime int(11) The time remaining in seconds on the aura. -1 means that the aura is indefinite. effIndexMask int(11) unsigned The effect index of the spell from which the aura came from. A spell has up to three effects, with the index being 0, 1, or 2. auto-generated by the getMaNGOS.eu MAGNET dbdocs module

NOTE: This page is auto-generated from the MAGNET DBDocs module, Any changes made directly to this page will be lost when it is regenerated. Description of the 'character_battleground_data' table for MaNGOSTwo This table holds information about the character when it joins a battleground. Table Notes This table uses the 'MyISAM' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes guid int(11) unsigned NO PRI '0' The character battleground datar global unique identifier. instance_id int(11) unsigned NO '0' The unique ID of the battleground instance the character has entered. team int(11) unsigned NO '0' Neutral, Horde, or Alliance join_x float NO '0' The character's X coordinate in the battleground. join_y float NO '0' The character's Y coordinate in the battleground. join_z float NO '0' The character's Z coordinate in the battleground. join_o float NO '0' The character's orientation in the battleground. join_map int(11) NO '0' Battleground map ID where the character will spawn. taxi_start int(11) NO '0' taxi_end int(11) NO '0' mount_spell int(11) NO '0' Description of the fields guid int(11) unsigned The character battleground datar global unique identifier. instance_id int(11) unsigned The unique ID of the battleground instance the character has entered. team int(11) unsigned Neutral, Horde, or Alliance join_x float The character's X coordinate in the battleground. join_y float The character's Y coordinate in the battleground. join_z float The character's Z coordinate in the battleground. join_o float The character's orientation in the battleground. join_map int(11) Battleground map ID where the character will spawn. taxi_start int(11) taxi_end int(11) mount_spell int(11) auto-generated by the getMaNGOS.eu MAGNET dbdocs module