blob: 7a141b46fa5cee345e7024bbdf3a2c003c5d8350 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
|
# creature_template_resistance
[<-Back-to:World](database-world.md)
**The \`creature_template_resistance\` table**
**Structure**
| Field | Type | Attribute | Key | Null | Default | Extra | Comment
:--- | :--- | :--- | :--- | :--- | :--- | :--- | :---
[CreatureID][1] | MEDIUMINT | UNSIGNED | PRI | NO
[School][2] | TINYINT | UNSIGNED | PRI | NO
[Resistance][3] | SMALLINT | SIGNED | | YES | Null
[VerifiedBuild][4] | SMALLINT | SIGNED | | YES | 0
[1]: #creatureid
[2]: #school
[3]: #resistance
[4]: #verifiedbuild
**Description of the fields**
### CreatureID
Creature entry from [creature_template.entry](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 was used to determine whether a template has been verified from WDB files.
If value is 0 then it has not been parsed yet.
If value is above 0 then it has been parsed with WDB files from that specific client build.
If value is -1 then it is just a place holder until proper data are found on WDBs.
If value is -Client Build then it was parsed with WDB files from that specific client build and manually edited later for some special necessity.
|
