Description of the 'ahbot_category' table for MaNGOSOne

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

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

Description of the 'ahbot_history' table for MaNGOSOne

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

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

Description of the 'ahbot_price' table for MaNGOSOne

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

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

Description of the 'ai_playerbot_names' table for MaNGOSOne

'PlayerbotAI AutoBot names'

Table Notes

This table uses the 'MyISAM' DB Engine

The Field definitions follow:

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

Description of the 'ai_playerbot_random_bots' table for MaNGOSOne

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

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

Description of the 'arena_team' table for MaNGOSOne

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

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

Description of the 'arena_team_member' table for MaNGOSOne

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

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

Description of the 'arena_team_stats' table for MaNGOSOne

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

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

Description of the 'auction' table for MaNGOSOne

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:

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).

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

Description of the 'bugreport' table for MaNGOSOne

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:

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

Description of the 'character_action' table for MaNGOSOne

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:

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.

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:

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'character_aura' table for MaNGOSOne

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:

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

Description of the 'character_battleground_data' table for MaNGOSOne

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:

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

Description of the 'character_declinedname' table for MaNGOSOne

Table Notes

This table uses the 'MyISAM' DB Engine

The Field definitions follow:

Description of the fields

guid int(11) unsigned

Notes: Global Unique Identifier

genitive varchar(15)

dative varchar(15)

accusative varchar(15)

instrumental varchar(15)

prepositional varchar(15)

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'character_gifts' table for MaNGOSOne

This table holds data about wrapped/gift items.

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

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

Description of the 'character_homebind' table for MaNGOSOne

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:

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

Description of the 'character_instance' table for MaNGOSOne

Contains the instance data for characters.

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

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

Description of the 'character_inventory' table for MaNGOSOne

Contains all the character inventory data, including the bank data.

Table Notes

This table uses the 'MyISAM' DB Engine

The Field definitions follow:

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:

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

Description of the 'character_pet' table for MaNGOSOne

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:

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.

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

Description of the 'character_pet_declinedname' table for MaNGOSOne

Table Notes

This table uses the 'MyISAM' DB Engine

The Field definitions follow:

Description of the fields

id int(11) unsigned

owner int(11) unsigned

genitive varchar(12)

dative varchar(12)

accusative varchar(12)

instrumental varchar(12)

prepositional varchar(12)

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'character_queststatus' table for MaNGOSOne

Holds information on the quest status of each character.

Table Notes

This table uses the 'MyISAM' DB Engine

The Field definitions follow:

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.

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

Description of the 'character_queststatus_daily' table for MaNGOSOne

'Player System'

Table Notes

This table uses the 'MyISAM' DB Engine

The Field definitions follow:

Description of the fields

guid int(11) unsigned

Notes: Global Unique Identifier

quest int(11) unsigned

Notes: Quest Identifier

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'character_reputation' table for MaNGOSOne

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:

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.

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'character_skills' table for MaNGOSOne

This table holds a listing of all skill for each character.

Table Notes

This table uses the 'MyISAM' DB Engine

The Field definitions follow:

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

Description of the 'character_social' table for MaNGOSOne

Contains data about character's friends/ignored list.

Table Notes

This table uses the 'MyISAM' DB Engine

The Field definitions follow:

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.

note varchar(48)

Notes: Friend Note

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'character_spell' table for MaNGOSOne

Holds information for each character's spells.

Table Notes

This table uses the 'MyISAM' DB Engine

The Field definitions follow:

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

Description of the 'character_spell_cooldown' table for MaNGOSOne

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:

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

Description of the 'character_stats' table for MaNGOSOne

This table holds information on all the stats regarding the character.

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

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.

spellCritPct float unsigned

attackPower int(10) unsigned

Character's current attackpower.

rangedAttackPower int(10) unsigned

Character's current ranged attackpower.

spellPower int(10) unsigned

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'character_ticket' table for MaNGOSOne

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:

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

Description of the 'character_tutorial' table for MaNGOSOne

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:

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

Description of the 'character_whispers' table for MaNGOSOne

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:

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

Description of the 'characters' table for MaNGOSOne

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:

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.

class tinyint(3) unsigned

The Class Id of the character [See chrclasses.dbc]

gender tinyint(3) unsigned

The Sex/Gender of the character.

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

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.

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

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.

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

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

knownTitles longtext

actionBars tinyint(3) unsigned

This represents which action bars are currently 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

Description of the 'corpse' table for MaNGOSOne

This table is used to store status of players corpse.

Table Notes

This table uses the 'MyISAM' DB Engine

The Field definitions follow:

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:

instance int(11) unsigned

The instance ID that the corpse is in.

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'creature_respawn' table for MaNGOSOne

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:

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

Description of the 'db_version' table for MaNGOSOne

This table holds the current version of the MaNGOS world database

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

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

Description of the 'game_event_status' table for MaNGOSOne

Lists the currently active game events, ie. Darkmoon faire etc.

Table Notes

This table uses the 'MyISAM' DB Engine

The Field definitions follow:

Description of the fields

event smallint(6) unsigned

The Event Id [See game_event.is] of currently active game events.
Once the event is complete, the entry is removed.

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'gameobject_respawn' table for MaNGOSOne

This table holds the re-spawn time when game objects should be respawned in the world. In case of a server crash, this table holds the re-spawn data so that the game objects don't re-spawn immediately on server restart. How often the re-spawn time is saved for game objects can be controlled in mangosd.conf. Usually the only objects that despawn and need to be re-spawned are chests and doors.

Table Notes

This table uses the 'MyISAM' DB Engine

The Field definitions follow:

Description of the fields

guid int(10) unsigned

Global unique ID of the game object.

respawntime bigint(20) unsigned

Time till the game object should respawn, as in 60000 for 1 minute after server start..

instance mediumint(8) unsigned

Instance ID that the game object will spawn in.

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'group_instance' table for MaNGOSOne

This table tracks a group of characters in an instance.

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

Description of the fields

leaderGuid int(11) unsigned

The Guid of the group leader. [See characters.guid]

instance int(11) unsigned

ID of the Instance session the group has enterd.

permanent tinyint(1) unsigned

Boolean flag if the group is bound to the Instance or not

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'group_member' table for MaNGOSOne

This table holds info about group members.

Table Notes

This table uses the 'MyISAM' DB Engine

The Field definitions follow:

Description of the fields

groupId int(11) unsigned

The group ID from the groups table.

memberGuid int(11) unsigned

The GUID of the character in the group.

assistant tinyint(1) unsigned

Flag stating whether or not the character is the assist.

The assits controls which mobs to attack and in what order.

subgroup smallint(6) unsigned

This is the group number within a raid (8 groups max).

Group numbering starts at 0 and end at 7.

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'groups' table for MaNGOSOne

This table holds basic info about groups.

Table Notes

This table uses the 'MyISAM' DB Engine

The Field definitions follow:

Description of the fields

groupId int(11) unsigned

Uniquie ID for the group.

leaderGuid int(11) unsigned

Guid of the group's leader, from the characters table.

mainTank int(11) unsigned

Guid of the character who is that main tank.

mainAssistant int(11) unsigned

Guid of the character who is that main assit.

This group member calls the shots as to the order in which mobs are taken on.

lootMethod tinyint(4) unsigned

This is the loot method used by the group.

looterGuid int(11) unsigned

Guid of the character who retrieves the loot.

lootThreshold tinyint(4) unsigned

The quality of theitems in the loot to be rolled for. This will be the minimum quality level to throw for, any loot below that will not be thrown for.

icon1 int(11) unsigned

Guid of the target that has the star raid target on it.

These are placed on playesr and mobs, and can be used for controlling kill orders, crowd control, and assigning players to mobs.

icon2 int(11) unsigned

Guid of the target that has the circle raid target on it.

These are placed on playesr and mobs, and can be used for controlling kill orders, crowd control, and assigning players to mobs.

icon3 int(11) unsigned

Guid of target that has the dimond raid target on it.

These are placed on playesr and mobs, and can be used for controlling kill orders, crowd control, and assigning players to mobs.

icon4 int(11) unsigned

Guid of the target that has the triangler raid target on it.

These are placed on playesr and mobs, and can be used for controlling kill orders, crowd control, and assigning players to mobs.

icon5 int(11) unsigned

Guid of the target that has the moon raid target on it.

These are placed on playesr and mobs, and can be used for controlling kill orders, crowd control, and assigning players to mobs.

icon6 int(11) unsigned

Guid of the target that has the square raid target on it.

These are placed on playesr and mobs, and can be used for controlling kill orders, crowd control, and assigning players to mobs.

icon7 int(11) unsigned

Guid of the target that has the cross raid target on it.

These are placed on playesr and mobs, and can be used for controlling kill orders, crowd control, and assigning players to mobs.

icon8 int(11) unsigned

Guid of the target that has the skull raid target on it.

These are placed on playesr and mobs, and can be used for controlling kill orders, crowd control, and assigning players to mobs.

isRaid tinyint(1) unsigned

Flag set for if group is part of a raid or not (1 = raid, 0 = not raid).

difficulty tinyint(3) unsigned

auto-generated by the getMaNGOS.eu MAGNET dbdocs module