Spell chain
Материал из YTDB DataBase
NeatElves (Обсуждение | вклад) |
NeatElves (Обсуждение | вклад) (→rank) |
||
| (4 промежуточные версии не показаны) | |||
| Строка 2: | Строка 2: | ||
| __TOC__ | | __TOC__ | ||
|} | |} | ||
| + | [[Category: Mangos world database tables]] | ||
К описанию таблиц [[mangosdb_struct|базы данных mangos]]. | К описанию таблиц [[mangosdb_struct|базы данных mangos]]. | ||
| Строка 22: | Строка 23: | ||
|[[#spell_id|spell_id]] | |[[#spell_id|spell_id]] | ||
|mediumint(9) | |mediumint(9) | ||
| + | | | ||
|NO | |NO | ||
|PRI | |PRI | ||
| Строка 29: | Строка 31: | ||
|[[#prev_spell|prev_spell]] | |[[#prev_spell|prev_spell]] | ||
|mediumint(9) | |mediumint(9) | ||
| + | | | ||
|NO | |NO | ||
| | | | ||
| Строка 36: | Строка 39: | ||
|[[#first_spell|first_spell]] | |[[#first_spell|first_spell]] | ||
|mediumint(9) | |mediumint(9) | ||
| + | | | ||
|NO | |NO | ||
| | | | ||
| Строка 43: | Строка 47: | ||
|[[#rank|rank]] | |[[#rank|rank]] | ||
|tinyint(4) | |tinyint(4) | ||
| + | | | ||
|NO | |NO | ||
| | | | ||
| Строка 50: | Строка 55: | ||
|[[#req_spell|req_spell]] | |[[#req_spell|req_spell]] | ||
|mediumint(9) | |mediumint(9) | ||
| + | | | ||
|NO | |NO | ||
| | | | ||
| Строка 59: | Строка 65: | ||
<big>'''Описание полей'''</big> | <big>'''Описание полей'''</big> | ||
====spell_id==== | ====spell_id==== | ||
| - | + | Идентификатор текущего заклинания в данной цепочке. См. [[Spell.dbc]] | |
| + | |||
====prev_spell==== | ====prev_spell==== | ||
The spell that came before the spell in [[#spell_id|spell_id]]. If the spell defined above is the first rank, then this field MUST be 0. If the spell chain is such that new ranks supersede older ranks, then the spell in this field will be unlearned when the spell in [[#spell_id|spell_id]] is learned. | The spell that came before the spell in [[#spell_id|spell_id]]. If the spell defined above is the first rank, then this field MUST be 0. If the spell chain is such that new ranks supersede older ranks, then the spell in this field will be unlearned when the spell in [[#spell_id|spell_id]] is learned. | ||
| Строка 65: | Строка 72: | ||
The very first spell in the chain. The spell put in this field is usually the Rank 1 spell version in the chain. If the ID used in [[#spell_id|spell_id]] is equal to the ID in this field (meaning that the spell we are looking at is the first one in the chain), then the rank must be either 0 or 1. | The very first spell in the chain. The spell put in this field is usually the Rank 1 spell version in the chain. If the ID used in [[#spell_id|spell_id]] is equal to the ID in this field (meaning that the spell we are looking at is the first one in the chain), then the rank must be either 0 or 1. | ||
====rank==== | ====rank==== | ||
| - | + | Поле определяет ранг заклинания из [[#spell_id|spell_id]]. | |
Текущая версия на 10:29, 4 апреля 2013
|
К описанию таблиц базы данных mangos.
Таблица `spell_chain`
This table defines spell chains. A spell chain is a series of spells which all share the same name and all do the same thing; however, each has a different rank and as the rank increases, so does the spell damage/heal/etc values. This table also controls what spells are replaced by their more powerful later ranks; however, that is also decided by other factors as well (if mana costs for both spells are the same, etc). All fields in this table except rank are spell IDs from Spell.dbc.
Структура
| Field | Type | Attributes | Null | Key | Default | Comments |
| spell_id | mediumint(9) | NO | PRI | 0 | ||
| prev_spell | mediumint(9) | NO | 0 | |||
| first_spell | mediumint(9) | NO | 0 | |||
| rank | tinyint(4) | NO | 0 | |||
| req_spell | mediumint(9) | NO | 0 |
Описание полей
spell_id
Идентификатор текущего заклинания в данной цепочке. См. Spell.dbc
prev_spell
The spell that came before the spell in spell_id. If the spell defined above is the first rank, then this field MUST be 0. If the spell chain is such that new ranks supersede older ranks, then the spell in this field will be unlearned when the spell in spell_id is learned.
first_spell
The very first spell in the chain. The spell put in this field is usually the Rank 1 spell version in the chain. If the ID used in spell_id is equal to the ID in this field (meaning that the spell we are looking at is the first one in the chain), then the rank must be either 0 or 1.
rank
Поле определяет ранг заклинания из spell_id.
