Description of the 'spell_elixir' table for MaNGOSTwo

This table holds elixir information to be used to properly stack the elixirs.

Table Notes

This table uses the 'MyISAM' DB Engine

The Field definitions follow:

Description of the fields

entry int(11) unsigned

Spell ID [See Spell.dbc].

mask tinyint(1) unsigned

Defines what type of potion/food spell this is. The following table lists the available values.

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'spell_learn_spell' table for MaNGOSTwo

This table holds information on spells that should be learned at the same time a player learns another spell. For example the few spells that are automatically learned when a player first learns a new profession. All fields in this table use spell IDs from Spell.dbc NOTE: Spells with spell effects SPELL_EFFECT_LEARN_SPELL should NOT be included in this table.

Table Notes

This table uses the 'MyISAM' DB Engine

The Field definitions follow:

Description of the fields

entry smallint(5) unsigned

Spell ID [See Spell.dbc] of the triggering spell.

SpellID smallint(5) unsigned

Spell ID [See Spell.dbc] of the additional spell to learn.

Active tinyint(3) unsigned

The active flag. If set, the spell is enabled as active, i.e. allowed to be casted.

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'spell_loot_template' table for MaNGOSTwo

'Loot System'

Table Notes

This table uses the 'MyISAM' DB Engine

The Field definitions follow:

Description of the fields

entry mediumint(8) unsigned

item mediumint(8) unsigned

ChanceOrQuestChance float

groupid tinyint(3) unsigned

mincountOrRef mediumint(9)

maxcount tinyint(3) unsigned

condition_id mediumint(8) unsigned

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'spell_pet_auras' table for MaNGOSTwo

This table holds information for additional auras due to the pet. This mechanic implements character talents modifying the pet properties. If the character has aura/knows spell, then the pet get additional aura.

Table Notes

This table uses the 'MyISAM' DB Engine

The Field definitions follow:

Description of the fields

spell mediumint(8) unsigned

Spell ID [See Spell.dbc] of the triggering spell. One of its spelleffects should be either EFFECT_DUMMY or applying the aura AURA_DUMMY.

effectId tinyint(3) unsigned

pet mediumint(8) unsigned

Pet creature ID, see creature_template.enrty.

aura mediumint(8) unsigned

Spell ID [See Spell.dbc] of the aura spell to be applied on the pet.

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'spell_proc_event' table for MaNGOSTwo

This table holds information on what events (or procs) certain spells are activated. All spells in this table must have apply a SPELL_AURA_PROC_TRIGGER_SPELL (42) aura. Any nonzero entries in this table will overwrite the existing proc settings in the spell's DBC entry.

Table Notes

This table uses the 'MyISAM' DB Engine

The Field definitions follow:

Description of the fields

entry mediumint(8) unsigned

Spell ID [See Spell.dbc] of the aura that may proc during another spellcast or under other conditions defined in this table.

SchoolMask tinyint(4) unsigned

Spell school mask. Spell School is defined in in the second field of Spell.dbc entry. This value is the bitmask [See enum SpellSchoolMask in SharedDefines.h], where different schools may be combined.

SpellFamilyName smallint(5) unsigned

Spell family name classifies the spell as intended mostly for specific character class, see enum SpellFamily in DBCEnums.h. The field is defined for each spell in Spell.dbc, see SpellFamilyName field of struct SpellEntry in DBCStructure.h.

SpellFamilyMaskA0 int(10) unsigned

SpellFamilyMaskA1 int(10) unsigned

SpellFamilyMaskA2 int(10) unsigned

SpellFamilyMaskB0 int(10) unsigned

SpellFamilyMaskB1 int(10) unsigned

SpellFamilyMaskB2 int(10) unsigned

SpellFamilyMaskC0 int(10) unsigned

SpellFamilyMaskC1 int(10) unsigned

SpellFamilyMaskC2 int(10) unsigned

procFlags int(10) unsigned

Bitmask defining conditions for aura to proc. Values may be combined by adding. If equals to 0, the value form Spell.dbc is used.

procEx int(10) unsigned

Flags refining proc condition, optional.

ppmRate float

The value limits the proc frequency. For melee (ranged?) damage spells it is the proc rate per minute. The actual proc may happen less frequently but not more frequently than defined here.
If zero, falls back to flat chance from Spell.dbc.

CustomChance float

Chance of proc. If equals to 0, the standard value from Spell.dbc is used, else overrides it.
Mostly used for spell debugging when it is convenient to set the chance to 100%.

Cooldown int(10) unsigned

A hidden cooldown used for some spell proc events, applied to _triggered_spell_.

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'spell_proc_item_enchant' table for MaNGOSTwo

This table holds information for proc chances of spells which enchant weapons.

This also includes shaman weapon enchants.

Table Notes

This table uses the 'MyISAM' DB Engine

The Field definitions follow:

Description of the fields

entry mediumint(8) unsigned

Spell ID [See Spell.dbc]. Should be the first rank spell if in the rank chain.

ppmRate float

The value (times per minute) limits the enchant proc frequency.

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'spell_script_target' table for MaNGOSTwo

Used to control SpellEffect with ImpliciteTargetA-B == 7|8|38|40|46|52. These spell effects require a specific target in either alive or dead state (for creatures).

Table Notes

This table uses the 'MyISAM' DB Engine

The Field definitions follow:

Description of the fields

entry mediumint(8) unsigned

Spell ID [See Spell.dbc] of the spell requiring external implicit target definition. The target type of a spelleffect has to be one of the following (look for the values at enum Targets in SharedDefines.h):
TARGET_SCRIPT, TARGET_SCRIPT_COORDINATES, TARGET_FOCUS_OR_SCRIPTED_GAMEOBJECT, TARGET_AREAEFFECT_INSTANT, TARGET_AREAEFFECT_CUSTOM, TARGET_AREAEFFECT_GO_AROUND_SOURCE, TARGET_AREAEFFECT_GO_AROUND_DEST, TARGET_NARROW_FRONTAL_CONE

type tinyint(3) unsigned

Type of the target entry.

targetEntry mediumint(8) unsigned

Creature ID (creature_template.entry) or Gameobject ID (gameobject_template.entry) dependently on the type.

inverseEffectMask mediumint(8) unsigned

The bitmask (bits 0, 1, 2 corresponding to values 1, 2, 4) of the spell effect numbers that do not use this mechanic.

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'spell_target_position' table for MaNGOSTwo

This table holds coordinate information on where the player should be teleported to when a spell with effect SPELL_EFFECT_TELEPORT_UNITS.

Table Notes

This table uses the 'MyISAM' DB Engine

The Field definitions follow:

Description of the fields

id mediumint(8) unsigned

The spell identifier. The value has to match with a defined spell identifier [See Spell.dbc].

target_map smallint(5) unsigned

The target map's identifier. The value has to match with a defined map identifier [See Map.dbc].

target_position_x float

The X position on the target map.

target_position_y float

The Y position on the target map.

target_position_z float

The Z position on the target map.

target_orientation float

The orientation for the character on the target map. This is measured in radians, 0 is north on the mini-map and pi is south on the mini-map etc.

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'spell_template' table for MaNGOSTwo

'MaNGOS server side spells'

Table Notes

This table uses the 'MyISAM' DB Engine

The Field definitions follow:

Description of the fields

id int(11) unsigned

attr int(11) unsigned

attr_ex int(11) unsigned

attr_ex2 int(11) unsigned

attr_ex3 int(11) unsigned

proc_flags int(11) unsigned

proc_chance int(11) unsigned

duration_index int(11) unsigned

effect0 int(11) unsigned

effect0_implicit_target_a int(11) unsigned

effect0_implicit_target_b int(11) unsigned

effect0_radius_idx int(11) unsigned

effect0_apply_aura_name int(11) unsigned

effect0_misc_value int(11) unsigned

effect0_misc_value_b int(11) unsigned

effect0_trigger_spell int(11) unsigned

comments varchar(255)

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'spell_threat' table for MaNGOSTwo

This table holds threat values on all spells that should either give or take away threat.

Table Notes

This table uses the 'MyISAM' DB Engine

The Field definitions follow:

Description of the fields

entry mediumint(8) unsigned

The spell identifier. The value has to match with a spell identifier defined [See Spell.dbc]

Note:
Any spell referenced is required to be rank 1 in the spell chain, and has to have threat values set in the original spell definition.

Threat smallint(6)

The value of threat to add to the characters threat, or to remove from a characters threat. Negative values reduce threat, positive values increase threat.

multiplier float

Any value here will modify the spells threat with the factor given here.

ap_bonus float

Any value here will modify the spells attack power with the factor given here.

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'transports' table for MaNGOSTwo

This table contains all type 15 transports (Boats and Zeppelins).
All other transport types have their frame time read from TransportAnimation.dbc.

Table Notes

This table uses the 'MyISAM' DB Engine

The Field definitions follow:

Description of the fields

entry mediumint(8) unsigned

This references the Gameobject Template table's unique ID [See gameobject_template.entry] of the game object of type 15 (boats and Zeppelins) for which the entry is valid.

name text

A name describing the transport. This is not used in-game, but only here to ease locking up data.

period mediumint(8) unsigned

This is the amount of time that it take for the transport to make one full pass through all the frames in the TaxiNodes [See TaxiNodes.dbc]. When a client change occurs, usually this field must be updated. This values is set in milliseconds.

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'vehicle_accessory' table for MaNGOSTwo

'Vehicle Accessory (passengers that are auto-boarded onto a vehicle)'

Table Notes

This table uses the 'MyISAM' DB Engine

The Field definitions follow:

Description of the fields

vehicle_entry int(10) unsigned

Notes: entry of the npc who has some accessory as vehicle

seat mediumint(8) unsigned

Notes: onto which seat shall the passenger be boarded

accessory_entry int(10) unsigned

Notes: entry of the passenger that is to be boarded

comment varchar(255)

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'warden_build_specific' table for MaNGOSTwo

Table Notes

This table uses the 'MyISAM' DB Engine

The Field definitions follow:

Description of the fields

id smallint(5) unsigned

Notes: Check ID from warden_checks

build smallint(5) unsigned

Notes: Client build

data varchar(48)

str varchar(20)

address int(10) unsigned

length tinyint(3) unsigned

result varchar(24)

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'warden_checks' table for MaNGOSTwo

Table Notes

This table uses the 'MyISAM' DB Engine

The Field definitions follow:

Description of the fields

id smallint(5) unsigned

type tinyint(3) unsigned

data varchar(48)

str varchar(20)

address int(10) unsigned

length tinyint(3) unsigned

result varchar(24)

comment varchar(50)

auto-generated by the getMaNGOS.eu MAGNET dbdocs module