Number of changes made look correct.. and you are actually going to npc's for training that have "Classname Guildmast" at the end of the name correct?
some of the classes like.. druid and ranger didn't have that tagged onto the end of ther names so as a result those trainers won't work..
if you know an NPC should be a trainer and doesn't have that tagged into their name you can manually update their class in the npc_types table in the database with the corresponding classnumber as you posted in your list of classes above.
All my sql statements do is make the changes based on information already contained in the database so there are some class trainers that simply won't work because their name did not reflect that they were a guildmaster so they wouldn't get changed.
Its one of those things where the database isn't complete so i can only work with whats present in it. which reinforces the fact that more people need to run the packet collector to fill in all the missing information.
I've long since retired from EQ and have no active accounts or every session I played would have been collected. The extent of my contributions to the project will basically be to add functionality when i see a means to do it. To that end I am about halfway done with re-numbering all of the old perl_quests to work with the MW_057DR2 DB since all the npcid's changed with this DB. and they may change again in the future as well.
again some way work others might not.. but i feel that anything that makes the world more complete is a good thing. I do know that most of the trainers in the freeport area do work. there are some classes that no matter where you go will not work..
Making an individual change in the DB is relatively simple if you know a mob should be a trainer for a particular class.
|