Spell template
Материал из YTDB DataBase
(Различия между версиями)
NeatElves (Обсуждение | вклад) |
NeatElves (Обсуждение | вклад) |
||
| Строка 549: | Строка 549: | ||
|NO | |NO | ||
| | | | ||
| - | |-1 | + | | -1 |
| | | | ||
|- | |- | ||
Версия 17:57, 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 | -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 |
