Jump to content
  • We are looking for staff for the Wiki area!
    If interested please
    click here and select "Documentation Team"

  • npc_trainer


    antz
     Share

     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 MaNGOSThree

    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 'InnoDB' 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

     Share


    User Feedback

    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 account

    Sign in

    Already have an account? Sign in here.

    Sign In Now

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use