AzerothCore
Pages :
Important: As of 19/09/24 all versions of MariaDB, MySQL 5.7 and 8.1 will no longer be supported. Consider upgrading to MySQL 8.0 or 8.4.
skill_extra_item_template
The `skill_extra_item_template` table
This table holds information about when using certain profession spells, you have the chance of creating more than one copy of the item.
Table Structure
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| spellId | MEDIUMINT | UNSIGNED | PRI | NO | 0 | SpellId of the item creation spell | |
| requiredSpecialization | MEDIUMINT | UNSIGNED | NO | 0 | Specialization spell id | ||
| additionalCreateChance | FLOAT | SIGNED | NO | 0 | chance to create add | ||
| additionalMaxNum | TINYINT | UNSIGNED | NO | 0 | max num of adds |
Description of the fields
spellId
The spell ID that creates the item. See Spell.dbc
requiredSpecialization
The required specialization spell ID. The character must have the spell ID specified here learned to have a chance at making another item instantly.
additionalCreateChance
The chance that the player will make another item instantly.
additionalMaxNum
The number of extra copies that can be made.