Hi,
Recently the trainers have been replaced by a system of tables that are not documented.
The sniffs from Wowpacketparser have entries for some of the trainer tables, yet are missing gossip_menu_option_trainer which is used to link them.
To link this cooking trainer (http://www.wowhead.com/npc=1699/gremlock-pilsnor) to the trainer table, you have to manually work out what it could be by the type of spells in the trainer_spell table, pull it back to the trainer table, then link the gossip_menu_it from creature_template to the gossip_menu_option_trainer
table.
INSERT INTO gossip_menu_option_trainer
(MenuId
,OptionIndex
,TrainerId
)
VALUES
(5853,0,136);
The new system is much better, however it is undocumented, and Wowpacketparser does not fill in that table, so every entry must be reverse engineered and guessed at if there are multiple trainers of the same type.
In case someone wants to get a trainer working manually, the above method works, however if Wowpacketparser can be updated to have entries for the gossip_menu_option_trainer
table then the process would be much simpler.
Thanks,
Glenn