[Declined][Warlords of Draenor]: Jandi Herbalism trainer

[Tavari]

Title: Jandi Herbalism trainer
Bugtracker Link:

https://firestorm-servers.com/en/report/see_report/18164

Patch Content:

DELETE FROM `npc_trainer` WHERE ID ='3404';
INSERT INTO `npc_trainer` (`entry`, `Spell`, `Spellcost`,  `ReqSkillValue`, `ReqLevel`) VALUES
('3404', '2366', '10', '0', '1'),
('3404', '2368', '500', '50', '1'),
('3404', '3570', '5000', '125', '1'),
('3404', '11993', '50000', '200', '1'),
('3404', '28695', '100000', '275', '1'),
('3404', '50300', '350000', '350', '1'),
('3404', '74519', '500000', '425', '1'),
('3404', '110413', '600000', '500', '1');

 

[Mikrole]

DELETE FROM `npc_trainer` WHERE ID ='3404';

entry, not ID.
 

INSERT INTO `npc_trainer` (`entry`, `Spell`, `Spellcost`,  `ReqSkillValue`, `ReqLevel`) VALUES
('3404', '2366', '10', '0', '1'),
('3404', '2368', '500', '50', '1'),
('3404', '3570', '5000', '125', '1'),
('3404', '11993', '50000', '200', '1'),
('3404', '28695', '100000', '275', '1'),
('3404', '50300', '350000', '350', '1'),
('3404', '74519', '500000', '425', '1'),
('3404', '110413', '600000', '500', '1');

reqskill is missing. Correct would be :
 

INSERT INTO `npc_trainer` (`entry`, `Spell`, `Spellcost`,  `reqskill`, `ReqSkillValue`, `ReqLevel`) VALUES
('3404', '2366', '10', '182', '0', '1'),
('3404', '2368', '500', '182', '50', '1'),
('3404', '3570', '5000', '182', '125', '1'),
('3404', '11993', '50000', '182', '200', '1'),
('3404', '28695', '100000', '182', '275', '1'),
('3404', '50300', '350000', '182', '350', '1'),
('3404', '74519', '500000', '182', '425', '1'),
('3404', '110413', '600000', '182', '500', '1');

But anyways, seems like theres also another problem on this NPC which blocks it's gossip.