Going Bearback

gistfile1.sql

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

-- Fix for Quest (12851)  Going Bearback
-- Change the Questrequirements
-- ################################################################################
-- Set the Rquirements
-- ################################################################################
UPDATE quest_template SET ReqCreatureOrGOId1='29358' WHERE entry='12851' AND title='Going Bearback';
UPDATE quest_template SET ReqCreatureOrGOId2='29351' WHERE entry='12851' AND title='Going Bearback';
UPDATE quest_template SET ReqCreatureOrGOCount1='7' WHERE entry='12851' AND title='Going Bearback';
UPDATE quest_template SET ReqCreatureOrGOCount2='15' WHERE entry='12851' AND title='Going Bearback';
-- ################################################################################
-- Set Requirements and Spells for Icefang ( Bear-Mount)
UPDATE creature_template SET IconName='vehichleCursor', faction_A='35', faction_H='35', npcflag='0', speed_walk='1', speed_run='1.74', spell1='74525', spell2='54907', spell3='0', spell4='0', spell5='0', spell6='0', spell7='0', spell8='0', AIName='NullAI', vehicle_id='308', ScriptName='' WHERE entry='29598' AND name='Icefang' ;
DELETE FROM `creature_spell` WHERE guid='29598';
INSERT INTO `creature_spell` (`guid`, `spell`, `index`, `active`, `disabled`, `flags`) VALUES (29598, 74525, 0, 0, 0, 0);
INSERT INTO `creature_spell` (`guid`, `spell`, `index`, `active`, `disabled`, `flags`) VALUES (29598, 54907, 1, 0, 0, 0);