diff options
| author | FrancescoBorzi <borzifrancesco@gmail.com> | 2019-02-25 19:24:20 +0100 |
|---|---|---|
| committer | FrancescoBorzi <borzifrancesco@gmail.com> | 2019-02-25 19:24:20 +0100 |
| commit | a35d4f08a3f9f086eae94dccbfda2ff0c8eb5ae3 (patch) | |
| tree | 91e0cde00f6f27b730b0df3f4338fcf99fa8447a /docs/spell_required.md | |
| parent | d8d1823802ded97300fa57405d80b16736603489 (diff) | |
| download | wiki-a35d4f08a3f9f086eae94dccbfda2ff0c8eb5ae3.tar.gz wiki-a35d4f08a3f9f086eae94dccbfda2ff0c8eb5ae3.tar.bz2 wiki-a35d4f08a3f9f086eae94dccbfda2ff0c8eb5ae3.zip | |
Import DB wiki from TC 335
Diffstat (limited to 'docs/spell_required.md')
| -rw-r--r-- | docs/spell_required.md | 66 |
1 files changed, 61 insertions, 5 deletions
diff --git a/docs/spell_required.md b/docs/spell_required.md index 016d4a2..9e1cfbe 100644 --- a/docs/spell_required.md +++ b/docs/spell_required.md @@ -1,6 +1,62 @@ -[Database Structure](Database-Structure) > [World-Database](World-Database) > [spell_required](spell_required) +# spell\_required -Column | Type | Description ---- | --- | --- -Spell_id | mediumint(8) | -Req_spell | mediumint(8) | +`Back-to:World` + +**The \`spell\_required\` table** + +Table used to add restrictions for learning spells from trainer. Player can't learn spell 'spell\_id' till he learns 'req\_spell', when he loses 'req\_spell' 'spell\_id' will be lost too. Table is used also for profession specialisations as specialisations require profession of certain rank to learn. + +<table> +<colgroup> +<col width="12%" /> +<col width="12%" /> +<col width="12%" /> +<col width="12%" /> +<col width="12%" /> +<col width="12%" /> +<col width="12%" /> +<col width="12%" /> +</colgroup> +<tbody> +<tr class="odd"> +<td><p><strong>Field</strong></p></td> +<td><p><strong>Type</strong></p></td> +<td><p><strong>Attributes</strong></p></td> +<td><p><strong>Key</strong></p></td> +<td><p><strong>Null</strong></p></td> +<td><p><strong>Default</strong></p></td> +<td><p><strong>Extra</strong></p></td> +<td><p><strong>Comment</strong></p></td> +</tr> +<tr class="even"> +<td><p><a href="#spell_required-spell_id">spell_id</a></p></td> +<td><p>mediumint(9)</p></td> +<td><p>signed</p></td> +<td><p>PRI</p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +<td><p> </p></td> +</tr> +<tr class="odd"> +<td><p><a href="#spell_required-req_spell">req_spell</a></p></td> +<td><p>mediumint(9)</p></td> +<td><p>signed</p></td> +<td><p>PRI</p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +<td><p> </p></td> +</tr> +</tbody> +</table> + +**Description of the fields** + +### spell\_id + +Spell ID from Spell.dbc, which require knowing \`req\_spell\` to learn from trainer. + +### req\_spell + +Spell ID from Spell.dbc, which is required to be known before \`spell\_id\` can be learned from trainer. |