Spell template

Материал из YTDB DataBase

Перейти к: навигация, поиск

К описанию таблиц базы данных mangos.


Таблица `spell_template`

Содержит все заклинания, которые используются в игре.


Структура

Field Type Attributes Null Key Default Comments
id int(11) unsigned NO PRI 0
Category int(11) unsigned NO 0
Dispel int(11) unsigned NO 0
Mechanic int(11) unsigned NO 0
Attributes int(11) unsigned NO 0
AttributesEx int(11) unsigned NO 0
AttributesEx2 int(11) unsigned NO 0
AttributesEx3 int(11) unsigned NO 0
AttributesEx4 int(11) unsigned NO 0
AttributesEx5 int(11) unsigned NO 0
AttributesEx6 int(11) unsigned NO 0
AttributesEx7 int(11) unsigned NO 0
Stances int(11) unsigned NO 0
StancesNot int(11) unsigned NO 0
Targets int(11) unsigned NO 0
TargetCreatureType int(11) unsigned NO 0
RequiresSpellFocus int(11) unsigned NO 0
FacingCasterFlags int(11) unsigned NO 0
CasterAuraState int(11) unsigned NO 0
TargetAuraState int(11) unsigned NO 0
CasterAuraStateNot int(11) unsigned NO 0
TargetAuraStateNot int(11) unsigned NO 0
CasterAuraSpell int(11) unsigned NO 0
TargetAuraSpell int(11) unsigned NO 0
ExcludeCasterAuraSpell int(11) unsigned NO 0
ExcludeTargetAuraSpell int(11) unsigned NO 0
CastingTimeIndex int(11) unsigned NO 0
RecoveryTime int(11) unsigned NO 0
CategoryRecoveryTime int(11) unsigned NO 0
InterruptFlags int(11) unsigned NO 0
AuraInterruptFlags int(11) unsigned NO 0
ChannelInterruptFlags int(11) unsigned NO 0
ProcFlags int(11) unsigned NO 0
ProcChance int(11) unsigned NO 0
ProcCharges int(11) unsigned NO 0
MaxLevel int(11) unsigned NO 0
BaseLevel int(11) unsigned NO 0
SpellLevel int(11) unsigned NO 0
DurationIndex int(11) unsigned NO 0
PowerType int(11) unsigned NO 0
ManaCost int(11) unsigned NO 0
ManaCostPerlevel int(11) unsigned NO 0
ManaPerSecond int(11) unsigned NO 0
ManaPerSecondPerLevel int(11) unsigned NO 0
RangeIndex int(11) unsigned NO 0
Speed float NO 0
StackAmount int(11) unsigned NO 0
Totem1 int(11) unsigned NO 0
Totem2 int(11) unsigned NO 0
Reagent1 int(11) NO 0
Reagent2 int(11) NO 0
Reagent3 int(11) NO 0
Reagent4 int(11) NO 0
Reagent5 int(11) NO 0
Reagent6 int(11) NO 0
Reagent7 int(11) NO 0
Reagent8 int(11) NO 0
ReagentCount1 int(11) unsigned NO 0
ReagentCount2 int(11) unsigned NO 0
ReagentCount3 int(11) unsigned NO 0
ReagentCount4 int(11) unsigned NO 0
ReagentCount5 int(11) unsigned NO 0
ReagentCount6 int(11) unsigned NO 0
ReagentCount7 int(11) unsigned NO 0
ReagentCount8 int(11) unsigned NO 0
EquippedItemClass int(11) NO -1
EquippedItemSubClassMask int(11) NO 0
EquippedItemInventoryTypeMask int(11) NO 0
Effect1 int(11) unsigned NO 0
Effect2 int(11) unsigned NO 0
Effect3 int(11) unsigned NO 0
EffectDieSides1 int(11) NO 0
EffectDieSides2 int(11) NO 0
EffectDieSides3 int(11) NO 0
EffectRealPointsPerLevel1 float NO 0
EffectRealPointsPerLevel2 float NO 0
EffectRealPointsPerLevel3 float NO 0
EffectBaseDice1 int(11) unsigned NO 0
EffectBaseDice2 int(11) unsigned NO 0
EffectBaseDice3 int(11) unsigned NO 0
EffectMechanic1 int(11) unsigned NO 0
EffectMechanic2 int(11) unsigned NO 0
EffectMechanic3 int(11) unsigned NO 0
EffectImplicitTargetA1 int(11) unsigned NO 0
EffectImplicitTargetA2 int(11) unsigned NO 0
EffectImplicitTargetA3 int(11) unsigned NO 0
EffectImplicitTargetB1 int(11) unsigned NO 0
EffectImplicitTargetB2 int(11) unsigned NO 0
EffectImplicitTargetB3 int(11) unsigned NO 0
EffectRadiusIndex1 int(11) unsigned NO 0
EffectRadiusIndex2 int(11) unsigned NO 0
EffectRadiusIndex3 int(11) unsigned NO 0
EffectApplyAuraName1 int(11) unsigned NO 0
EffectApplyAuraName2 int(11) unsigned NO 0
EffectApplyAuraName3 int(11) unsigned NO 0
EffectAmplitude1 int(11) unsigned NO 0
EffectAmplitude2 int(11) unsigned NO 0
EffectAmplitude3 int(11) unsigned NO 0
EffectMultipleValue1 float NO 0
EffectMultipleValue2 float NO 0
EffectMultipleValue3 float NO 0
EffectChainTarget1 int(11) unsigned NO 0
EffectChainTarget2 int(11) unsigned NO 0
EffectChainTarget3 int(11) unsigned NO 0
EffectItemType1 int(11) unsigned NO 0
EffectItemType2 int(11) unsigned NO 0
EffectItemType3 int(11) unsigned NO 0
EffectMiscValue1 int(11) NO 0
EffectMiscValue2 int(11) NO 0
EffectMiscValue3 int(11) NO 0
EffectMiscValueB1 int(11) NO 0
EffectMiscValueB2 int(11) NO 0
EffectMiscValueB3 int(11) NO 0
EffectTriggerSpell1 int(11) unsigned NO 0
EffectTriggerSpell2 int(11) unsigned NO 0
EffectTriggerSpell3 int(11) unsigned NO 0
EffectPointsPerComboPoint1 float NO 0
EffectPointsPerComboPoint2 float NO 0
EffectPointsPerComboPoint3 float NO 0
EffectSpellClassMask1_1 int(11) unsigned NO 0
EffectSpellClassMask1_2 int(11) unsigned NO 0
EffectSpellClassMask1_3 int(11) unsigned NO 0
EffectSpellClassMask2_1 int(11) unsigned NO 0
EffectSpellClassMask2_2 int(11) unsigned NO 0
EffectSpellClassMask2_3 int(11) unsigned NO 0
EffectSpellClassMask3_1 int(11) unsigned NO 0
EffectSpellClassMask3_2 int(11) unsigned NO 0
EffectSpellClassMask3_3 int(11) unsigned NO 0
SpellVisual int(11) unsigned NO 0
SpellVisua2 int(11) unsigned NO 0
SpellIconID int(11) unsigned NO 0
ActiveIconID int(11) unsigned NO 0
SpellPriority int(11) unsigned NO 0
SpellName text NO
SpellName2 text
SpellName3 text
SpellName4 text
SpellName5 text
SpellName6 text
SpellName7 text
SpellName8 text
SpellName9 text
SpellName10 text
SpellName11 text
SpellName12 text
SpellName13 text
SpellName14 text
SpellName15 text
SpellName16 text
Rank text
Rank2 text
Rank3 text
Rank4 text
Rank5 text
Rank6 text
Rank7 text
Rank8 text
Rank9 text
Rank10 text
Rank11 text
Rank12 text
Rank13 text
Rank14 text
Rank15 text
Rank16 text
ManaCostPercentage int(11) unsign NO 0
StartRecoveryCategory int(11) unsign NO 0
StartRecoveryTime int(11) unsign NO 0
MaxTargetLevel int(11) unsign NO 0
SpellFamilyName int(11) unsign NO 0
SpellFamilyFlags bigint(20) unsign NO 0
SpellFamilyFlags2 int(11) unsign NO 0
MaxAffectedTargets int(11) unsign NO 0
DmgClass int(11) unsign NO 0
PreventionType int(11) unsign NO 0
DmgMultiplier1 float NO 0
DmgMultiplier2 float NO 0
DmgMultiplier3 float NO 0
TotemCategory1 int(11) unsign NO 0
TotemCategory2 int(11) unsign NO 0
AreaId int(11) unsign NO 0
SchoolMask int(11) unsign NO 0
RuneCostID int(11) unsign NO 0
SpellDifficultyId int(11) unsign NO 0
IsServerSide int(11) unsign NO 0

Описание полей

Источник — «http://wiki.ytdb.ru:89/index.php/Spell_template»
Личные инструменты