asd12asd Posted December 6, 2019 Report Share Posted December 6, 2019 (edited) Hello TrinityCore forum, Recently I pulled the 3.3.5a branch and compiled it in release mode. Then I extracted all required maps and initialized and populated the MySQL 5.6 databases auth, character and world. The server starts and I can join and play. 1. I can make NPC Vendors. Now I want to make NPC Trainers. I see that on the wiki page - https://trinitycore.atlassian.net/wiki/spaces/tc/pages/2130008/creature+template - the table creature_template has following attributes: trainer_type tinyint(4) signed NO 0 trainer_class tinyint(3) unsigned NO 0 trainer_race tinyint(3) unsigned NO 0 Those are not found in the initialized database what I have. 2. How can I look for spells by name? I see that there is a table spell_dbc with columns SpellName and SpellFamilyName but when I give queries like SELECT * FROM spell_dbc WHERE SpellName like '%Heroic Strike%' OR SpellFamilyName like '%Heroic Strike% I don't find those spells. How can I make NPC-Trainers? I found over the internet some trinity core sql packs, but they are mostly not conform with my databases. Best Wishes, James. Edited December 6, 2019 by asd12asd Link to comment Share on other sites More sharing options...
Aokromes Posted December 8, 2019 Report Share Posted December 8, 2019 for the 1st, outdated wiki. for the 2nd, use ingame command lookup spell <name> the spell_dbc spells are server side only spells. Link to comment Share on other sites More sharing options...
BuddyQc69 Posted January 27, 2020 Report Share Posted January 27, 2020 @Aokromes do you have new Wiki ? Link to comment Share on other sites More sharing options...
Recommended Posts