NOTE: This page is auto-generated from the MAGNET DBDocs module, Any changes made directly to this page will be lost when it is regenerated. |
Description of the 'npc_trainer' table for MaNGOSOne
This table holds all the information on training NPCs.
All spells listed in the table are learning spells.
This means that the main effect of the spells listed here is to teach spells to the target (which is the player in this case).
Any other spell that is not a learning spell will be ignored and an error message will be shown in the console window.
Learning spells usually have the same name as their actual spell counterparts and are listed as Uncategorized in Wowhead.
Table Notes
This table uses the 'MyISAM' DB Engine
The Field definitions follow:
Field Name | Field Type | Nullable | Key | Default Value | Attributes | Notes |
---|---|---|---|---|---|---|
entry | mediumint(8) unsigned | NO | PRI | '0' | Creature ID [See creature_template.entry]. | |
spell | mediumint(8) unsigned | NO | PRI | '0' | Learning spell ID [See Spell.dbc]. | |
spellcost | int(10) unsigned | NO | '0' | Learning cost (coppers). | ||
reqskill | smallint(5) unsigned | NO | '0' | Required skill type. | ||
reqskillvalue | smallint(5) unsigned | NO | '0' | Required skill value. | ||
reqlevel | tinyint(3) unsigned | NO | '0' | Required level. |
Description of the fields
entry mediumint(8) unsigned
ID of NPC which is a trainer, see creature_template.entry.
spell mediumint(8) unsigned
Spell ID [See Spell.dbc]. The spell should have SPELL_EFFECT_LEARN_SPELL=36 as one of it effects. In other case it will be ignored.
spellcost int(10) unsigned
The sum in coppers required to pay for learning the spell.
reqskill smallint(5) unsigned
Type of the skill required to learn the spell.
Skill name | Value |
---|---|
SKILL_FROST | 6 |
SKILL_FIRE | 8 |
SKILL_ARMS | 26 |
SKILL_COMBAT | 38 |
SKILL_SUBTLETY | 39 |
SKILL_POISONS | 40 |
SKILL_SWORDS | 43 |
SKILL_AXES | 44 |
SKILL_BOWS | 45 |
SKILL_GUNS | 46 |
SKILL_BEAST_MASTERY | 50 |
SKILL_SURVIVAL | 51 |
SKILL_MACES | 54 |
SKILL_2H_SWORDS | 55 |
SKILL_HOLY | 56 |
SKILL_SHADOW | 78 |
SKILL_DEFENSE | 95 |
SKILL_LANG_COMMON | 98 |
SKILL_RACIAL_DWARVEN | 101 |
SKILL_LANG_ORCISH | 109 |
SKILL_LANG_DWARVEN | 111 |
SKILL_LANG_DARNASSIAN | 113 |
SKILL_LANG_TAURAHE | 115 |
SKILL_DUAL_WIELD | 118 |
SKILL_RACIAL_TAUREN | 124 |
SKILL_ORC_RACIAL | 125 |
SKILL_RACIAL_NIGHT_ELF | 126 |
SKILL_FIRST_AID | 129 |
SKILL_FERAL_COMBAT | 134 |
SKILL_STAVES | 136 |
SKILL_LANG_THALASSIAN | 137 |
SKILL_LANG_DRACONIC | 138 |
SKILL_LANG_DEMON_TONGUE | 139 |
SKILL_LANG_TITAN | 140 |
SKILL_LANG_OLD_TONGUE | 141 |
SKILL_SURVIVAL2 | 142 |
SKILL_RIDING_HORSE | 148 |
SKILL_RIDING_WOLF | 149 |
SKILL_RIDING_TIGER | 150 |
SKILL_RIDING_RAM | 152 |
SKILL_SWIMING | 155 |
SKILL_2H_MACES | 160 |
SKILL_UNARMED | 162 |
SKILL_MARKSMANSHIP | 163 |
SKILL_BLACKSMITHING | 164 |
SKILL_LEATHERWORKING | 165 |
SKILL_ALCHEMY | 171 |
SKILL_2H_AXES | 172 |
SKILL_DAGGERS | 173 |
SKILL_THROWN | 176 |
SKILL_HERBALISM | 182 |
SKILL_GENERIC_DND | 183 |
SKILL_RETRIBUTION | 184 |
SKILL_COOKING | 185 |
SKILL_MINING | 186 |
SKILL_PET_IMP | 188 |
SKILL_PET_FELHUNTER | 189 |
SKILL_TAILORING | 197 |
SKILL_ENGINEERING | 202 |
SKILL_PET_SPIDER | 203 |
SKILL_PET_VOIDWALKER | 204 |
SKILL_PET_SUCCUBUS | 205 |
SKILL_PET_INFERNAL | 206 |
SKILL_PET_DOOMGUARD | 207 |
SKILL_PET_WOLF | 208 |
SKILL_PET_CAT | 209 |
SKILL_PET_BEAR | 210 |
SKILL_PET_BOAR | 211 |
SKILL_PET_CROCILISK | 212 |
SKILL_PET_CARRION_BIRD | 213 |
SKILL_PET_CRAB | 214 |
SKILL_PET_GORILLA | 215 |
SKILL_PET_RAPTOR | 217 |
SKILL_PET_TALLSTRIDER | 218 |
SKILL_RACIAL_UNDED | 220 |
SKILL_CROSSBOWS | 226 |
SKILL_WANDS | 228 |
SKILL_POLEARMS | 229 |
SKILL_PET_SCORPID | 236 |
SKILL_ARCANE | 237 |
SKILL_PET_TURTLE | 251 |
SKILL_ASSASSINATION | 253 |
SKILL_FURY | 256 |
SKILL_PROTECTION | 257 |
SKILL_BEAST_TRAINING | 261 |
SKILL_PROTECTION2 | 267 |
SKILL_PET_TALENTS | 270 |
SKILL_PLATE_MAIL | 293 |
SKILL_LANG_GNOMISH | 313 |
SKILL_LANG_TROLL | 315 |
SKILL_ENCHANTING | 333 |
SKILL_DEMONOLOGY | 354 |
SKILL_AFFLICTION | 355 |
SKILL_FISHING | 356 |
SKILL_ENHANCEMENT | 373 |
SKILL_RESTORATION | 374 |
SKILL_ELEMENTAL_COMBAT | 375 |
SKILL_SKINNING | 393 |
SKILL_MAIL | 413 |
SKILL_LEATHER | 414 |
SKILL_CLOTH | 415 |
SKILL_SHIELD | 433 |
SKILL_FIST_WEAPONS | 473 |
SKILL_RIDING_RAPTOR | 533 |
SKILL_RIDING_MECHANOSTRIDER | 553 |
SKILL_RIDING_UNDEAD_HORSE | 554 |
SKILL_RESTORATION2 | 573 |
SKILL_BALANCE | 574 |
SKILL_DESTRUCTION | 593 |
SKILL_HOLY2 | 594 |
SKILL_DISCIPLINE | 613 |
SKILL_LOCKPICKING | 633 |
SKILL_PET_BAT | 653 |
SKILL_PET_HYENA | 654 |
SKILL_PET_OWL | 655 |
SKILL_PET_WIND_SERPENT | 656 |
SKILL_LANG_GUTTERSPEAK | 673 |
SKILL_RIDING_KODO | 713 |
SKILL_RACIAL_TROLL | 733 |
SKILL_RACIAL_GNOME | 753 |
SKILL_RACIAL_HUMAN | 754 |
SKILL_PET_EVENT_RC | 758 |
SKILL_RIDING | 762 |
reqskillvalue smallint(5) unsigned
Value of the skill required to learn the spell.
reqlevel tinyint(3) unsigned
Minimal level of character required to learn the spell.
auto-generated by the getMaNGOS.eu MAGNET dbdocs module
Edited by Antz
Recommended Comments
There are no comments to display.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now