[Declined][Legion] Enchanting trainer

[csabikaa97-2]

Bugtracker link: https://firestorm-servers.com/en/report/see_report/30695
wowhead link: http://www.wowhead.com/npc=93531/enchanter-nalthanis
correction: changed npcflag and added illusions to the npc_trainer database just in case it's not there.

Code: UPDATE `world`.`creature_template` SET `npcflag`='130' WHERE  `entry`=93531;

          DELETE FROM `npc_trainer` WHERE `SpellID`=217641;

          DELETE FROM `npc_trainer` WHERE `SpellID`=217644;

          DELETE FROM `npc_trainer` WHERE `SpellID`=217645;

          DELETE FROM `npc_trainer` WHERE `SpellID`=217650;

          DELETE FROM `npc_trainer` WHERE `SpellID`=217637;

          INSERT INTO `world`.`npc_trainer` (`ID`, `SpellID`, `MoneyCost`, `ReqSkillRank`) VALUES ('93531', '217641', '80000', '350');

          INSERT INTO `world`.`npc_trainer` (`ID`, `SpellID`, `MoneyCost`, `ReqSkillRank`) VALUES ('93531', '217644', '150000', '425');

          INSERT INTO `world`.`npc_trainer` (`ID`, `SpellID`, `MoneyCost`, `ReqSkillRank`) VALUES ('93531', '217645', '30000', '500');

          INSERT INTO `world`.`npc_trainer` (`ID`, `SpellID`, `MoneyCost`, `ReqSkillRank`) VALUES ('93531', '217650', '20000', '676');

          INSERT INTO `world`.`npc_trainer` (`ID`, `SpellID`, `MoneyCost`, `ReqSkillRank`) VALUES ('93531', '217637', '12500', '275');

 

[Misahky]

Hello!

Thanks for your patch but I have to decline it as we disabled the trainers until we publish professions.

 

Still, thanks!

Regards.