Spell area
Материал из YTDB DataBase
|
Back to world database list of tables.
The `spell_area` table
This table holds information on what spells are applied to npcs/players in some areas.
Structure
Field | Type | Null | Key | Default | Extra |
spell | mediumint(8) unsigned | NO | PRI | 0 | |
area | mediumint(8) unsigned | NO | PRI | 0 | |
quest_start | mediumint(8) unsigned | NO | PRI | 0 | |
quest_start_active | tinyint(1) unsigned | NO | PRI | 0 | |
quest_end | mediumint(8) unsigned | NO | 0 | ||
aura_spell | mediumint(8) | NO | PRI | 0 | |
racemask | mediumint(8) unsigned | NO | PRI | 0 | |
gender | tinyint(1) unsigned | NO | PRI | 2 | |
autocast | tinyint(1) unsigned | NO | 0 |
Description of the fields
spell
The spell ID that will be castet. Reference to Spell.dbc.
area
Reference to AreaTable.dbc. Player must be in this area.
quest_start
Reference to quest_template. This quest must be available or active and must not be completed. Exact behaviour depends on quest_start_active.
quest_start_active
Boolean value. If set to 0 the quest quest_start must be available and not activ. If set to 1 the quest quest_start must be available or active in players' log.
quest_end
Reference to quest_template. This quest must not be completed.
aura_spell
Reference to Spell.dbc. Player must have this aura to activate the spell. Negativ values stand for "not has aura" requirement.
racemask
Only these races are target of the spell.
Race
These values are 2^ID taken from ChrRaces.dbc
Examples
0,1791 = All Races
(2 + 16 + 32 + 128 + 512) = 690 = only Horde
(1 + 4 + 8 + 64 + 1024) = 1101 = only Alliance
gender
Only this gender is target of the spell.
- 0: Male
- 1: Female
- 2: Both
autocast
Boolean value.