Spell template

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

(Различия между версиями)
Перейти к: навигация, поиск
Строка 11: Строка 11:
-
<big>'''Структура'''</big>
+
  <big>'''Структура'''</big>
{| border="1"
{| border="1"
|'''Field'''
|'''Field'''
Строка 29: Строка 29:
|
|
|-
|-
-
|[[#attr|attr]]
+
|[[#Category|Category]]
|int(11)
|int(11)
|unsigned
|unsigned
Строка 37: Строка 37:
|
|
|-
|-
-
|[[#attr_ex|attr_ex]]
+
 
 +
 
 +
|[[#Dispel|Dispel]]
|int(11)
|int(11)
|unsigned
|unsigned
Строка 45: Строка 47:
|
|
|-
|-
-
|[[#attr_ex2|attr_ex2]]
+
|[[#Mechanic|Mechanic]]
|int(11)
|int(11)
|unsigned
|unsigned
Строка 53: Строка 55:
|
|
|-
|-
-
|[[#proc_flags|proc_flags]]
+
|[[#Attributes|Attributes]]
|int(11)
|int(11)
|unsigned
|unsigned
Строка 61: Строка 63:
|
|
|-
|-
-
|[[#proc_chance|proc_chance]]
+
|[[#AttributesEx|AttributesEx]]
|int(11)
|int(11)
|unsigned
|unsigned
Строка 69: Строка 71:
|
|
|-
|-
-
|[[#duration_index|duration_index]]
+
|[[#AttributesEx2|AttributesEx2]]
|int(11)
|int(11)
|unsigned
|unsigned
Строка 77: Строка 79:
|
|
|-
|-
-
|[[#effect0|effect0]]
+
|[[#AttributesEx3|AttributesEx3]]
|int(11)
|int(11)
|unsigned
|unsigned
Строка 85: Строка 87:
|
|
|-
|-
-
|[[#effect0_implicit_target_a|effect0_implicit_target_a]]
+
|[[#AttributesEx4|AttributesEx4]]
|int(11)
|int(11)
|unsigned
|unsigned
Строка 93: Строка 95:
|
|
|-
|-
-
|[[#effect0_implicit_target_b|effect0_implicit_target_b]]
+
|[[#AttributesEx5|AttributesEx5]]
|int(11)
|int(11)
|unsigned
|unsigned
Строка 101: Строка 103:
|
|
|-
|-
-
|[[#effect0_radius_idx|effect0_radius_idx]]
+
|[[#AttributesEx6|AttributesEx6]]
|int(11)
|int(11)
|unsigned
|unsigned
Строка 109: Строка 111:
|
|
|-
|-
-
|[[#effect0_apply_aura_name|effect0_apply_aura_name]]
+
|[[#AttributesEx7|AttributesEx7]]
|int(11)
|int(11)
|unsigned
|unsigned
Строка 117: Строка 119:
|
|
|-
|-
-
|[[#effect0_misc_value|effect0_misc_value]]
+
|[[#Stances|Stances]]
|int(11)
|int(11)
|unsigned
|unsigned
Строка 125: Строка 127:
|
|
|-
|-
-
|[[#effect0_misc_value_b|effect0_misc_value_b]]
+
|[[#StancesNot|StancesNot]]
|int(11)
|int(11)
|unsigned
|unsigned
Строка 133: Строка 135:
|
|
|-
|-
-
|[[#effect0_trigger_spell|effect0_trigger_spell]]
+
|[[#Targets|Targets]]
|int(11)
|int(11)
|unsigned
|unsigned
Строка 141: Строка 143:
|
|
|-
|-
-
|[[#comments|comments]]
+
|[[#TargetCreatureType|TargetCreatureType]]
-
|varchar(255)
+
|int(11)
 +
|unsigned
 +
|NO
|
|
 +
|0
 +
|
 +
|-
 +
|[[#RequiresSpellFocus|RequiresSpellFocus]]
 +
|int(11)
 +
|unsigned
|NO
|NO
|
|
 +
|0
|
|
 +
|-
 +
|[[#FacingCasterFlags|FacingCasterFlags]]
 +
|int(11)
 +
|unsigned
 +
|NO
|
|
-
|}
+
|0
 +
|
 +
|-
 +
|[[#CasterAuraState|CasterAuraState]]
 +
|int(11)
 +
|unsigned
 +
|NO
 +
|
 +
|0
 +
|
 +
|-
 +
|[[#TargetAuraState|TargetAuraState]]
 +
|int(11)
 +
|unsigned
 +
|NO
 +
|
 +
|0
 +
|
 +
|-
 +
|[[#CasterAuraStateNot|CasterAuraStateNot]]
 +
|int(11)
 +
|unsigned
 +
|NO
 +
|
 +
|0
 +
|
 +
|-
 +
|[[#TargetAuraStateNot|TargetAuraStateNot]]
 +
|int(11)
 +
|unsigned
 +
|NO
 +
|
 +
|0
 +
|
 +
|-
 +
|[[#CasterAuraSpell|CasterAuraSpell]]
 +
|int(11)
 +
|unsigned
 +
|NO
 +
|
 +
|0
 +
|
 +
|-
 +
|[[#TargetAuraSpell|TargetAuraSpell]]
 +
|int(11)
 +
|unsigned
 +
|NO
 +
|
 +
|0
 +
|
 +
|-
 +
|[[#ExcludeCasterAuraSpell|ExcludeCasterAuraSpell]]
 +
|int(11)
 +
|unsigned
 +
|NO
 +
|
 +
|0
 +
|
 +
|-
 +
|[[#ExcludeTargetAuraSpell|ExcludeTargetAuraSpell]]
 +
|int(11)
 +
|unsigned
 +
|NO
 +
|
 +
|0
 +
|
 +
|-
 +
|[[#CastingTimeIndex|CastingTimeIndex]]
 +
|int(11)
 +
|unsigned
 +
|NO
 +
|
 +
|0
 +
|
 +
|-
 +
|[[#RecoveryTime|RecoveryTime]]
 +
|int(11)
 +
|unsigned
 +
|NO
 +
|
 +
|0
 +
|
 +
|-
 +
|[[#CategoryRecoveryTime|CategoryRecoveryTime]]
 +
|int(11)
 +
|unsigned
 +
|NO
 +
|
 +
|0
 +
|
 +
|-
 +
|[[#InterruptFlags|InterruptFlags]]
 +
|int(11)
 +
|unsigned
 +
|NO
 +
|
 +
|0
 +
|
 +
|-
 +
|[[#AuraInterruptFlags|AuraInterruptFlags]]
 +
|int(11)
 +
|unsigned
 +
|NO
 +
|
 +
|0
 +
|
 +
|-
 +
|[[#ChannelInterruptFlags|ChannelInterruptFlags]]
 +
|int(11)
 +
|unsigned
 +
|NO
 +
|
 +
|0
 +
|
 +
|-
 +
 
 +
|[[#ProcFlags|ProcFlags]]
 +
|int(11)
 +
|unsigned
 +
|NO
 +
|
 +
|0
 +
|
 +
|-
 +
|[[#ProcChance|ProcChance]]
 +
|int(11)
 +
|unsigned
 +
|NO
 +
|
 +
|0
 +
|
 +
|-
 +
|[[#ProcCharges|ProcCharges]]
 +
|int(11)
 +
|unsigned
 +
|NO
 +
|
 +
|0
 +
|
 +
|-
 +
|[[#MaxLevel|MaxLevel]]
 +
|int(11)
 +
|unsigned
 +
|NO
 +
|
 +
|0
 +
|
 +
|-
 +
|[[#BaseLevel|BaseLevel]]
 +
|int(11)
 +
|unsigned
 +
|NO
 +
|
 +
|0
 +
|
 +
|-
 +
|[[#SpellLevel|SpellLevel]]
 +
|int(11)
 +
|unsigned
 +
|NO
 +
|
 +
|0
 +
|
 +
|-
 +
|[[#DurationIndex|DurationIndex]]
 +
|int(11)
 +
|unsigned
 +
|NO
 +
|
 +
|0
 +
|
 +
|-
 +
|[[#PowerType|PowerType]]
 +
|int(11)
 +
|unsigned
 +
|NO
 +
|
 +
|0
 +
|
 +
|-
 +
|[[#ManaCost|ManaCost]]
 +
|int(11)
 +
|unsigned
 +
|NO
 +
|
 +
|0
 +
|
 +
|-
 +
|[[#ManaCostPerlevel|ManaCostPerlevel]]
 +
|int(11)
 +
|unsigned
 +
|NO
 +
|
 +
|0
 +
|
 +
|-
 +
|[[#ManaPerSecond|ManaPerSecond]]
 +
|int(11)
 +
|unsigned
 +
|NO
 +
|
 +
|0
 +
|
 +
|-
 +
|[[#ManaPerSecondPerLevel|ManaPerSecondPerLevel]]
 +
|int(11)
 +
|unsigned
 +
|NO
 +
|
 +
|0
 +
|
 +
|-
 +
|[[#RangeIndex|RangeIndex]]
 +
|int(11)
 +
|unsigned
 +
|NO
 +
|
 +
|0
 +
|
 +
|-
 +
|[[#Speed|Speed]]
 +
|float
 +
|
 +
|NO
 +
|
 +
|0
 +
|
 +
|-
 +
|[[#StackAmount|StackAmount]]
 +
|int(11)
 +
|unsigned
 +
|NO
 +
|
 +
|0
 +
|
 +
|-
 +
|[[#Totem1|Totem1]]
 +
|int(11)
 +
|unsigned
 +
|NO
 +
|
 +
|0
 +
|
 +
|-
 +
|[[#Totem2|Totem2]]
 +
|int(11)
 +
|unsigned
 +
|NO
 +
|
 +
|0
 +
|
 +
|-
 +
|[[#Reagent1|Reagent1]]
 +
|int(11)
 +
|
 +
|NO
 +
|
 +
|0
 +
|
 +
|-
 +
|[[#Reagent2|Reagent2]]
 +
|int(11)
 +
|
 +
|NO
 +
|
 +
|0
 +
|
 +
|-
 +
|[[#Reagent3|Reagent3]]
 +
|int(11)
 +
|
 +
|NO
 +
|
 +
|0
 +
|
 +
|-
 +
|[[#Reagent4|Reagent4]]
 +
|int(11)
 +
|
 +
|NO
 +
|
 +
|0
 +
|
 +
|-
 +
|[[#Reagent5|Reagent5]]
 +
|int(11)
 +
|
 +
|NO
 +
|
 +
|0
 +
|
 +
|-
 +
|[[#Reagent6|Reagent6]]
 +
|int(11)
 +
|
 +
|NO
 +
|
 +
|0
 +
|
 +
|-
 +
|[[#Reagent7|Reagent7]]
 +
|int(11)
 +
|
 +
|NO
 +
|
 +
|0
 +
|
 +
|-
 +
|[[#Reagent8|Reagent8]]
 +
|int(11)
 +
|
 +
|NO
 +
|
 +
|0
 +
|
 +
|-
 +
|[[#ReagentCount1|ReagentCount1]]
 +
|int(11)
 +
|unsigned
 +
|NO
 +
|
 +
|0
 +
|
 +
|-
 +
|[[#ReagentCount2|ReagentCount2]]
 +
|int(11)
 +
|unsigned
 +
|NO
 +
|
 +
|0
 +
|
 +
|-
 +
|[[#ReagentCount3|ReagentCount3]]
 +
|int(11)
 +
|unsigned
 +
|NO
 +
|
 +
|0
 +
|
 +
|-
 +
|[[#ReagentCount4|ReagentCount4]]
 +
|int(11)
 +
|unsigned
 +
|NO
 +
|
 +
|0
 +
|
 +
|-
 +
|[[#ReagentCount5|ReagentCount5]]
 +
|int(11)
 +
|unsigned
 +
|NO
 +
|
 +
|0
 +
|
 +
|-
 +
|[[#ReagentCount6|ReagentCount6]]
 +
|int(11)
 +
|unsigned
 +
|NO
 +
|
 +
|0
 +
|
 +
|-
 +
|[[#ReagentCount7|ReagentCount7]]
 +
|int(11)
 +
|unsigned
 +
|NO
 +
|
 +
|0
 +
|
 +
|-
 +
|[[#ReagentCount8|ReagentCount8]]
 +
|int(11)
 +
|unsigned
 +
|NO
 +
|
 +
|0
 +
|
 +
|-
 +
|[[#EquippedItemClass|EquippedItemClass]]
 +
|int(11)
 +
|
 +
|NO
 +
|
 +
|-1
 +
|
 +
|-
 +
|[[#EquippedItemSubClassMask|EquippedItemSubClassMask]]
 +
|int(11)
 +
|
 +
|NO
 +
|
 +
|0
 +
|
 +
|-
 +
|[[#EquippedItemInventoryTypeMask|EquippedItemInventoryTypeMask]]
 +
|int(11)
 +
|
 +
|NO
 +
|
 +
|0
 +
|
 +
|-
 +
|[[#Effect1|Effect1]]
 +
|int(11)
 +
|unsigned
 +
|NO
 +
|
 +
|0
 +
|
 +
|-
 +
|[[#Effect2|Effect2]]
 +
|int(11)
 +
|unsigned
 +
|NO
 +
|
 +
|0
 +
|
 +
|-
 +
|[[#Effect3|Effect3]]
 +
|int(11)
 +
|unsigned
 +
|NO
 +
|
 +
|0
 +
|
 +
|-
 +
|[[#EffectDieSides1|EffectDieSides1]]
 +
|int(11)
 +
|
 +
|NO
 +
|
 +
|0
 +
|
 +
|-
 +
|[[#EffectDieSides2|EffectDieSides2]]
 +
|int(11)
 +
|
 +
|NO
 +
|
 +
|0
 +
|
 +
|-
 +
|[[#EffectDieSides3|EffectDieSides3]]
 +
|int(11)
 +
|
 +
|NO
 +
|
 +
|0
 +
|
 +
|-
<big>'''Описание полей'''</big>
<big>'''Описание полей'''</big>

Версия 17:56, 17 декабря 2016

К описанию таблиц базы данных 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
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
Источник — «http://wiki.ytdb.ru:89/index.php/Spell_template»
Личные инструменты