Working as of 7/24/2019, latest TrinityCore 3.3.5a revision
I've gotten into WoW emulation recently, and it seems like there was a big shift in the database layout some time in 2019, which made all NPC trainer SQL prior to this year completely useless. There is also no full up-to-date documentation on the new layout, so I've decided to get to work and figure it out myself.
Here are my results: https://pastebin.com/Dkzz5eqP
The entire SQL code is commented so everything should be quite clear. Especially when it comes to the new layout of the trainer, trainer_spell and creature_default_trainer tables.
It should give you insight into creating trainers of all the different types, as it's essentially just modifying a few values from the SQL code and adding new spell IDS at the bottom. Mess around with it, see what you can make! Maybe an all-professions trainer? An all-class trainer? Maybe GM-spells trainer? Try it out!
Here's a screenshot of the NPC in action:
I've gotten into WoW emulation recently, and it seems like there was a big shift in the database layout some time in 2019, which made all NPC trainer SQL prior to this year completely useless. There is also no full up-to-date documentation on the new layout, so I've decided to get to work and figure it out myself.
Here are my results: https://pastebin.com/Dkzz5eqP
The entire SQL code is commented so everything should be quite clear. Especially when it comes to the new layout of the trainer, trainer_spell and creature_default_trainer tables.
It should give you insight into creating trainers of all the different types, as it's essentially just modifying a few values from the SQL code and adding new spell IDS at the bottom. Mess around with it, see what you can make! Maybe an all-professions trainer? An all-class trainer? Maybe GM-spells trainer? Try it out!
Here's a screenshot of the NPC in action:
Last edited:
