Skill discovery template

From OregonCore Wiki
Jump to: navigation, search

Back to world database list of tables.


The `skill_discovery_template` table

This table controls the so called "discovery" system of learning spells. This system is solely (?) used by the alchemy profession and controls the chance for a player to "discover" another recipe while creating items with other recipes.

Schema Last Modified: TC1-1828 - Schema Verified: Rev 665


Structure

Field Type Attributes Key Null Default Extra Comment
spellId mediumint(8) unsigned PRI NO 0 SpellId of the discoverable spell
reqSpell mediumint(8) unsigned NO 0 spell requirement
chance float signed NO 0 chance to discover


Description of the fields

spellId

The recipe spell ID that has a chance to be automatically discovered. See Spell.dbc

reqSpell

If nonzero, this field controls what spell must be specifically used to trigger the discovery (eg, spell 41458 will only be discovered while using spell 28575). If it is zero, then any recipe use can trigger the discovery. See Spell.dbc

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