From a35d4f08a3f9f086eae94dccbfda2ff0c8eb5ae3 Mon Sep 17 00:00:00 2001 From: FrancescoBorzi Date: Mon, 25 Feb 2019 19:24:20 +0100 Subject: Import DB wiki from TC 335 --- docs/item_effect.md | 120 ++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 120 insertions(+) create mode 100644 docs/item_effect.md (limited to 'docs/item_effect.md') diff --git a/docs/item_effect.md b/docs/item_effect.md new file mode 100644 index 0000000..cfba6b0 --- /dev/null +++ b/docs/item_effect.md @@ -0,0 +1,120 @@ +# 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](#item_effect-ID) | int(10) | unsigned | PRI | NO | 0 |   |   | +| [ItemID](#item_effect-ItemID) | int(10) | unsigned |   | NO | 0 |   |   | +| [OrderIndex](#item_effect-OrderIndex) | int(10) | unsigned |   | NO | 0 |   |   | +| [SpellID](#item_effect-SpellID) | int(10) | unsigned |   | NO | 0 |   |   | +| [Trigger](#item_effect-Trigger) | int(10) | unsigned |   | NO | 0 |   |   | +| [Charges](#item_effect-Charges) | int(10) | unsigned |   | NO | 0 |   |   | +| [Cooldown](#item_effect-Cooldown) | int(11) | signed |   | NO | 0 |   |   | +| [Category](#item_effect-Category) | int(10) | unsigned |   | NO | 0 |   |   | +| [CategoryCooldown](#item_effect-CategoryCooldown) | int(11) | signed |   | NO | 0 |   |   | +| [VerifiedBuild](#item_effect-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](http://collab.kpsn.org/display/tc/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](http://collab.kpsn.org/display/tc/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. + + ++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
IDTrigger 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](http://collab.kpsn.org/pages/createpage.action?spaceKey=tc&title=realmlist_tc2&linkCreation=true&fromPageId=333456). + +If value is -1 then it is just a place holder until proper data are found on WDBs. -- cgit