Realm: Sylvanas
Character: Brunark, Alliance, 78
When i talk to this NPC, it does not bring up the flying training box.
This issue can be reproduced by Right clicking this NPC
She should teach the same spells as http://www.wowhead.com/npc=43769/bralla-cloudwing -- Alli
and http://www.wowhead.com/npc=44919/maztha -- Horde
Solution for TrinityCore:
SELECT `ID`,`SpellID`,`MoneyCost`,`ReqSkillLine`,`ReqSkillRank`,`ReqLevel` FROM `npc_trainer` WHERE ID=43769 -- Bralla Cloudwing
-- these records need to be copied with ID changed to 31238
-- if it returns 1 record with SpellID = 202012, then the following insert will do the copy:
SET @RidingHighlevel := 202012;
INSERT INTO `npc_trainer` (`ID`,`SpellID`,`MoneyCost`,`ReqSkillLine`,`ReqSkillRank`,`ReqLevel`)
VALUES (31238,-@RidingHighlevel,0,0,0,0); -- Trainer Hira Snowdawn - Dalaran
Alternatively the solution used on WoD (same source):
http://us.forum.firestorm-servers.com/index.php?/topic/18309-warlords-of-draenor-hira-snowdawn/
The report on WoD: https://firestorm-servers.com/en/report/see_report/11801
The npcflag needs to be altered too, she's a Flight Master now, but should be Trainer + Vendor.
https://trinitycore.atlassian.net/wiki/display/tc/creature_template#creature_template-npcflag
add: 16 0x0000 0010 Trainer
add: 128 0x0000 0080 Vendor
rem: 8192 0x0000 2000 Flight Master
to check:
SELECT `npcflag` FROM `creature_template` WHERE `entry`=31238
should return 8192 (Flight Master) before applying the fix
to fix:
UPDATE `creature_template` SET `npcflag`=16+128 WHERE `entry`=31238;