item_effect
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 | int(10) | unsigned | PRI | NO | 0 | ||
| ItemID | int(10) | unsigned | NO | 0 | |||
| OrderIndex | int(10) | unsigned | NO | 0 | |||
| SpellID | int(10) | unsigned | NO | 0 | |||
| Trigger | int(10) | unsigned | NO | 0 | |||
| Charges | int(10) | unsigned | NO | 0 | |||
| Cooldown | int(11) | signed | NO | 0 | |||
| Category | int(10) | unsigned | NO | 0 | |||
| CategoryCooldown | int(11) | signed | NO | 0 | |||
| VerifiedBuild | smallint(6) | signed | NO | 0 |
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 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 with the proper TableHash accompanied, item.ID and 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 is used by the TrinityDB Team 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.