blob: be6ea091091a28009fc4354137d769639b5d98b0 (
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
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
|
# item\_effect
**`Back-to:Hotfixes`**
**The \`item\_effect\` table**
This table contains some of the item effect data regarding item hotfixes. This table is primarily used to hotfix spells on items.
**Structure**
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|-----------------------|-------------|------------|-----|------|---------|-------|---------|
| [ID][1] | INT | UNSIGNED | PRI | NO | 0 | | |
| [ItemID][2] | INT | UNSIGNED | | NO | 0 | | |
| [OrderIndex][3] | INT | UNSIGNED | | NO | 0 | | |
| [SpellID][4] | INT | UNSIGNED | | NO | 0 | | |
| [Trigger][5] | INT | UNSIGNED | | NO | 0 | | |
| [Charges][6] | INT | UNSIGNED | | NO | 0 | | |
| [Cooldown][7] | INT | SIGNED | | NO | 0 | | |
| [Category][8] | INT | UNSIGNED | | NO | 0 | | |
| [CategoryCooldown][9] | INT | SIGNED | | NO | 0 | | |
| [VerifiedBuild][10] | SMALLINT | SIGNED | | NO | 0 | | |
[1]: #id
[2]: #itemid
[3]: #orderindex
[4]: #spellid
[5]: #trigger
[6]: #charges
[7]: #cooldown
[8]: #category
[9]: #categorycooldown
[10]: #verifiedbuild
**Description of the fields**
### ID
This is the unique ID for the item\_effect table and has no relation whatsoever to the item ID that is being hotfixed.
This value links to [hotfix\_data.RecordID](hotfix_data#hotfix_data-hotfix_data-RecordID) with the proper TableHash accompanied.
### ItemID
This is the unique ID for the item that has received a hotfix.
This value links to [hotfix\_data.RecordID](hotfix_data_2130074.html#hotfix_data-hotfix_data-hotfix_data-RecordID) with the proper TableHash accompanied, [item.ID](hotfixes_item_2130073.html#hotfixes_item-hotfixes_item-ID) and [item\_sparse.ID](item_sparse#item_sparse-ID).
### OrderIndex
The order in which the spells are displayed on the item tooltip and are placed upon the item. Starts at 0.
### SpellID
The spell ID of the spell that the item can cast or trigger.
### Trigger
The type of trigger for the spell.
| ID | Trigger Type |
|----|-------------------|
| 0 | Use |
| 1 | On Equip |
| 2 | Chance on Hit |
| 4 | Soulstone |
| 5 | Use with no delay |
| 6 | Learn Spell ID |
### Charges
The number of times that the item can cast the spell:
- If 0, then infinite charges are possible.
- If negative, after the number of charges is depleted the item is deleted as well.
- If positive, the item is not deleted after all the charges are spent.
### Cooldown
The cooldown in milliseconds for the specific spell controlling how often the spell can be used.
Use -1 to use the default spell cooldown.
Note: this is not the "internal cooldown" of procs commonly found on items such as trinkets with "Chance on hit" effects.
### Category
The category that the spell is in.
### CategoryCooldown
The cooldown time in milliseconds that is applied to all other spells in the category that the triggered spell is also in.
Use -1 to use the default spell cooldown.
### 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.
|
