creature_template_resistance
The `creature_template_resistance` table
Table Structure
| Field | Type | Attribute | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| CreatureID | MEDIUMINT | UNSIGNED | PRI | NO | |||
| School | TINYINT | UNSIGNED | PRI | NO | |||
| Resistance | SMALLINT | SIGNED | YES | NULL | |||
| VerifiedBuild | SMALLINT | SIGNED | YES | 0 |
Description of the fields
CreatureID
Creature entry from creature_template.entry.
School
Value must be within this range. If above or under the SQL will fail on creature_template_resistance_chk_1.
| Value | Name |
|---|---|
| 1 | SPELL_SCHOOL_HOLY |
| 2 | SPELL_SCHOOL_FIRE |
| 3 | SPELL_SCHOOL_NATURE |
| 4 | SPELL_SCHOOL_FROST |
| 5 | SPELL_SCHOOL_SHADOW |
| 6 | SPELL_SCHOOL_ARCANE |
Resistance
Resistance value.
VerifiedBuild
This field is used by the TrinityCore DB Team to determine whether a template has been verified from WDB files.
- If value is 0, it has not been parsed yet.
- If value is > 0, it has been parsed with WDB files from that specific Client Build.
- If value is -1, it is just a place holder until proper data are found on WDBs.
- If value is -Client Build, it was parsed with WDB files from that specific client build and manually edited later for some specific necessity.