Description of the 'account_data' table for MaNGOSThree

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

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

Description of the 'ahbot_category' table for MaNGOSThree

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 MaNGOSThree

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 MaNGOSThree

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 MaNGOSThree

'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 MaNGOSThree

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 MaNGOSThree

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 MaNGOSThree

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 MaNGOSThree

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 MaNGOSThree

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 bigint(40)

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 bigint(40)

The amount of copper of the last bid made on the item.

startbid bigint(40)

The amount of copper of the starting bid made on the item.

deposit bigint(40)

The amount of copper spent on the deposit.

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'bugreport' table for MaNGOSThree

This table stores all the Bugs/Suggestions submitted in-game by Players.

Table Notes

This table uses the 'InnoDB' 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 'calendar_events' table for MaNGOSThree

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

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

Description of the 'calendar_invites' table for MaNGOSThree

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

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

Description of the 'character_account_data' table for MaNGOSThree

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

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

Description of the 'character_achievement' table for MaNGOSThree

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

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

Description of the 'character_achievement_progress' table for MaNGOSThree

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

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

Description of the 'character_action' table for MaNGOSThree

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 'InnoDB' DB Engine

The Field definitions follow:

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.

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 MaNGOSThree

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 MaNGOSThree

This table holds information about the character when it joins a battleground.

Table Notes

This table uses the 'InnoDB' 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.

taxi_start int(11)

taxi_end int(11)

mount_spell int(11)

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'character_currencies' table for MaNGOSThree

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

Description of the fields

guid int(11) unsigned

id smallint(5) unsigned

totalCount int(11) unsigned

weekCount int(11) unsigned

seasonCount int(11) unsigned

flags tinyint(2) unsigned

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'character_declinedname' table for MaNGOSThree

Table Notes

This table uses the 'InnoDB' 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_equipmentsets' table for MaNGOSThree

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

Description of the fields

guid int(11)

setguid bigint(20) unsigned

setindex tinyint(4)

name varchar(100)

iconname varchar(100)

ignore_mask int(11) unsigned

item0 int(11) unsigned

item1 int(11) unsigned

item2 int(11) unsigned

item3 int(11) unsigned

item4 int(11) unsigned

item5 int(11) unsigned

item6 int(11) unsigned

item7 int(11) unsigned

item8 int(11) unsigned

item9 int(11) unsigned

item10 int(11) unsigned

item11 int(11) unsigned

item12 int(11) unsigned

item13 int(11) unsigned

item14 int(11) unsigned

item15 int(11) unsigned

item16 int(11) unsigned

item17 int(11) unsigned

item18 int(11) unsigned

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'character_gifts' table for MaNGOSThree

This table holds data about wrapped/gift items.

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

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_glyphs' table for MaNGOSThree

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

Description of the fields

guid int(11) unsigned

spec tinyint(3) unsigned

slot tinyint(3) unsigned

glyph int(11) unsigned

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'character_homebind' table for MaNGOSThree

Contains information on the location where characters get teleported when they use for example the soul stone or the .start command.

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

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 MaNGOSThree

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 MaNGOSThree

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

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

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 MaNGOSThree

This table holds the pet data for each pet summoned by anyone in the game.

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

Description of the fields

id int(11) unsigned

The special pet ID. This is a unique identifier among all pets.

entry int(11) unsigned

The creature entry of this pet. [See creature_template.entry].

owner int(11) unsigned

The GUID of the pet's owner. [See character.guid].

modelid int(11) unsigned

The model ID to use to display the pet.

CreatedBySpell int(11) unsigned

The ID of the spell that has created this pet. For hunters, this is usually the Tame Beast spell. For warlocks or other classes (mages), it is the spell ID that summoned the creature. [See Spell.dbc column 1]

PetType tinyint(3) unsigned

The type of pet that this is. 0 = summoned pet, 1 = tamed pet

level int(11) unsigned

The current level of the pet.

exp int(11) unsigned

The current experience that this pet has. For summoned pets, this field is always 0.

Reactstate tinyint(1) unsigned

The current reaction state of the pet (passive, aggressive, etc).

name varchar(100)

The pet's name.

renamed tinyint(1) unsigned

Boolean 1 or 0. 1 = Pet has been renamed, 0 = Pet has never been renamed and still uses the same name as the creature that was tamed.

slot int(11) unsigned

The pet slot that the pet is in. The slot is a number between 0 and 3 inclusive.

curhealth int(11) unsigned

The current pet health at the time it was saved to DB.

curmana int(11) unsigned

The current pet mana at the time it was saved to DB.

savetime bigint(20) unsigned

The time when the pet was last saved, in Unix time.

resettalents_cost int(11) unsigned

This is the cost to "untrain" the pet talents.

resettalents_time bigint(20) unsigned

How many times the pets talents have been reset.

abdata longtext

data about pet action bar and action type ten pairs of action bar entry (from 1 to 10) and action or spell IDs

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'character_pet_declinedname' table for MaNGOSThree

Table Notes

This table uses the 'InnoDB' 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_phase_data' table for MaNGOSThree

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

Description of the fields

guid int(11)

map smallint(6)

phase int(11)

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'character_queststatus' table for MaNGOSThree

Holds information on the quest status of each character.

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

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

itemcount5 int(11) unsigned

itemcount6 int(11) unsigned

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'character_queststatus_daily' table for MaNGOSThree

'Player System'

Table Notes

This table uses the 'InnoDB' 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_queststatus_monthly' table for MaNGOSThree

'Player System'

Table Notes

This table uses the 'InnoDB' 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_queststatus_weekly' table for MaNGOSThree

'Player System'

Table Notes

This table uses the 'InnoDB' 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 MaNGOSThree

This table holds the reputation information of each faction for the character.

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

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 MaNGOSThree

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

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

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 MaNGOSThree

Contains data about character's friends/ignored list.

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]

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 MaNGOSThree

Holds information for each character's spells.

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

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 MaNGOSThree

Holds the remaining cooldowns from either character spells or item spells for each character.

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

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 MaNGOSThree

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

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

Description of the fields

guid int(11) unsigned

The guid of the character. [See character.guid].

maxhealth int(10) unsigned

Maximum amount of health that the character has.

maxpower1 int(10) unsigned

Max Mana

maxpower2 int(10) unsigned

Max Rage

maxpower3 int(10) unsigned

Max Focus

maxpower4 int(10) unsigned

Max Energy

maxpower5 int(10) unsigned

Max Happiness

strength int(10) unsigned

Character's current strength value.

agility int(10) unsigned

Character's current agility value

stamina int(10) unsigned

Character's current stamina value.

intellect int(10) unsigned

Character's current intellect value.

spirit int(10) unsigned

Character's current spirit value.

armor int(10) unsigned

Character's current armor value.

resHoly int(10) unsigned

Character's current holy resistance value.

resFire int(10) unsigned

Character's current fire resistance value.

resNature int(10) unsigned

Character's current nature resistance value.

resFrost int(10) unsigned

Character's current frost resistance value.

resShadow int(10) unsigned

Character's current shadow resistance value.

resArcane int(10) unsigned

Character's current arcane resistance value.

blockPct float unsigned

Character's current block chance

dodgePct float unsigned

Character's current dodge chance.

parryPct float unsigned

Character's current parry chance.

critPct float unsigned

Character's current crit chance.

rangedCritPct float unsigned

Character's current ranged crit chance.

spellCritPct float unsigned

attackPower int(10) unsigned

Character's current attackpower.

rangedAttackPower int(10) unsigned

Character's current ranged attackpower.

spellPower int(10) unsigned

auto-generated by the getMaNGOS.eu MAGNET dbdocs module