Posted February 17, 2017 Title: Hira SnowdawnBugtracker Link: https://firestorm-servers.com/en/report/see_report/11801Patch Content: DELETE FROM `npc_trainer` WHERE ID ='31238'; INSERT INTO `npc_trainer` (`entry`, `Spell`, `Spellcost`, `ReqSkillValue`, `ReqLevel`) VALUES ('31238', '33388', '40000', '0', '20'), ('31238', '33391', '500000', '75', '40'), ('31238', '34090', '2500000', '150', '60'), ('31238', '90267', '2500000', '225', '60'), ('31238', '54197', '5000000', '225', '68'), ('31238', '34091', '50000000', '225', '70'), ('31238', '90265', '50000000', '300', '80'); DELETE FROM `npc_vendor` WHERE `entry`=31238; INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `ExtendedCost`, `type`, `PlayerConditionID`, `IgnoreFiltering`, `VerifiedBuild`) VALUES ('31238', '0', '49177', '0', '0','1', '0', '0', '0'); Share this post Link to post Share on other sites
Posted July 10, 2017 New report on Sylvanas, same patch can be applied:https://firestorm-servers.com/en/report/see_report/45035 Share this post Link to post Share on other sites
Posted July 10, 2017 UPDATE `creature_template` SET `npcflag`=16+128 WHERE `entry`=31238; to check: SELECT `npcflag` FROM `creature_template` WHERE `entry`=31238 should return 8192 (Flight Master) before applying the fix https://trinitycore.atlassian.net/wiki/display/tc/creature_template#creature_template-npcflag Share this post Link to post Share on other sites