Fix Hunterquest (Bloodelf)

gistfile1.sql

-- SQL for MaNGOS @ Lumen-WoW.com
-- written by Danvinci (Dali) @ Lumen ServerTeam

-- Fix for Hunter-Quests @ Bloodelps
-- ################################################################################
-- Set the Rquirements  for StartQuest (9617) Seek the Farstriders
-- ################################################################################
UPDATE creature_template SET npcflag='19' , trainer_type='3', trainer_class='3' WHERE entry='16271' AND name='Telenus';
UPDATE quest_template SET RequiredClasses='4' , RequiredRaces='690', PrevQuestId='0', NextQuestId='9484', ExclusiveGroup='9617', NextQuestInChain='9484'  WHERE entry='9617' AND title='Seek the Farstriders';
INSERT IGNORE INTO `creature_questrelation` (`id`, `quest`) VALUES ('16271', '9617'); -- QuestGiver
INSERT IGNORE INTO `creature_involvedrelation` (`id`, `quest`) VALUES ('15399', '9617'); -- QuestCloser
-- ################################################################################
-- Quests "Taiming the Beast" for learning : Taming Lesson, Tame Beast, Call Pet 1, Dismiss Pet
-- ################################################################################
UPDATE quest_template SET RequiredClasses='4' , RequiredRaces='690', PrevQuestId='9617', NextQuestId='9486', ExclusiveGroup='0', NextQuestInChain='9486'  WHERE entry='9484' AND title='Taming the Beast';
INSERT IGNORE INTO `creature_questrelation` (`id`, `quest`) VALUES ('15399', '9484'); -- QuestGiver
INSERT IGNORE INTO `creature_involvedrelation` (`id`, `quest`) VALUES ('15399', '9484'); -- QuestCloser
UPDATE quest_template SET RequiredClasses='4' , RequiredRaces='690', PrevQuestId='9484', NextQuestId='9485', ExclusiveGroup='0', NextQuestInChain='9485'  WHERE entry='9486' AND title='Taming the Beast';
INSERT IGNORE INTO `creature_questrelation` (`id`, `quest`) VALUES ('15399', '9486'); -- QuestGiver
INSERT IGNORE INTO `creature_involvedrelation` (`id`, `quest`) VALUES ('15399', '9486'); -- QuestCloser
UPDATE quest_template SET RequiredClasses='4' , RequiredRaces='690', PrevQuestId='9486', NextQuestId='9673', ExclusiveGroup='0', NextQuestInChain='9673'  WHERE entry='9485' AND title='Taming the Beast';
INSERT IGNORE INTO `creature_questrelation` (`id`, `quest`) VALUES ('15399', '9485'); -- QuestGiver
INSERT IGNORE INTO `creature_involvedrelation` (`id`, `quest`) VALUES ('15399', '8485'); -- QuestCloser
-- ################################################################################
-- Quest "Beast Training" for learning : Training Lesson, Feed Pet, Revive Pet
-- ################################################################################
UPDATE quest_template SET RequiredClasses='4' , RequiredRaces='690', PrevQuestId='9485', NextQuestId='0', ExclusiveGroup='0', NextQuestInChain='0'  WHERE entry='9673' AND title='Beast Training';
INSERT IGNORE INTO `creature_questrelation` (`id`, `quest`) VALUES ('15399', '9673'); -- QuestGiver
INSERT IGNORE INTO `creature_involvedrelation` (`id`, `quest`) VALUES ('16675', '9673'); -- QuestCloser
-- ################################################################################
-- END