skill_discovery_template
This table controls the so called "discovery" system of learning spells. This system is used by the alchemy and inscription profession and controls the chance for a player to "discover" another recipe while creating items with known recipes.
Structure
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| spellId | int | unsigned | PRI | NO | 0 | SpellId of the discoverable spell | |
| reqSpell | int | unsigned | PRI | NO | 0 | spell requirement | |
| reqSkillValue | smallint | unsigned | NO | 0 | skill points requirement | ||
| chance | float | NO | 0 | chance to discover | |||
Description of fields
spellId
The recipe Spell ID that has a chance to be automatically discovered.
reqSpell
- reqSpell = 0: Any recipe spell can trigger the discovery
- reqSpell > 0: Must use a specific recipe to trigger the discovery (e.g.: Cauldron of Major Arcane Protection will only be discovered while using Major Arcane Protection Potion).
reqSkillValue
The minimum points requirement in profession skill to discover spellId.
chance
The chance, in percent, that a recipe has of being automatically "discovered", whether by any recipe use or by the specific recipe use defined in reqSpell.