Jump to content
Sign in to follow this  

Inconsistent creature_template table; spell_dbc questions

Recommended Posts

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,


Edited by asd12asd

Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.

  • Create New...