-- Alliance
-- --------------------------------------- --
-- Fix quest
-- --------------------------------------- --
UPDATE  `quest_template` SET  `LimitTime` =  '240',
`SrcSpell` =  '43883' WHERE `entry` =11318;
-- --------------------------------------- --
-- Insert creatures, needed for quest
-- --------------------------------------- --
INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(2966428, 24263, 0, 1, 0, 0, -5219.21, -475.952, 386.672, 4.08515, 25, 0, 0, 100, 0, 0, 0),
(2966802, 24264, 0, 1, 0, 0, -5311.19, -523.653, 388.333, 2.83679, 25, 0, 0, 100, 0, 0, 0),
(2967028, 24265, 0, 1, 0, 0, -5454.27, -515.558, 397.448, 3.28132, 25, 0, 0, 100, 0, 0, 0);
-- --------------------------------------- --
-- Insert they into game event
-- --------------------------------------- --
INSERT INTO `game_event_creature` (`guid`, `event`) VALUES
('2966428', '26');
('2966802', '26');
('2967028', '26');
-- --------------------------------------- --
-- Horde
-- --------------------------------------- --
-- Fix quest
-- --------------------------------------- --
UPDATE  `quest_template` SET  `LimitTime` =  '240',
`SrcSpell` =  '43883' WHERE `entry` =11409;
-- --------------------------------------- --
-- Insert creatures, needed for quest
-- --------------------------------------- --
INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(2969190, 24265, 1, 1, 0, 0, 1006.63, -4443.23, 11.2479, 0.449826, 25, 0, 0, 100, 0, 0, 0),
(2969163, 24264, 1, 1, 0, 0, 1139.06, -4418.3, 21.0567, 3.29463, 25, 0, 0, 100, 0, 0, 0),
(2969130, 24263, 1, 1, 0, 0, 1224.26, -4419.25, 22.2751, 3.13201, 25, 0, 0, 100, 0, 0, 0);
-- --------------------------------------- --
-- Insert they into gave event
-- --------------------------------------- --
INSERT INTO `game_event_creature` (`guid`, `event`) VALUES
('2969190', '26');
('2969163', '26');
('2969130', '26');
-- --------------------------------------- --
-- Fix rabbits(creatures, nedeed for quest), because they are so agressive.
-- --------------------------------------- --
UPDATE `creature_template` SET  `faction_A` =  '15', `faction_H` =  '15' WHERE  `entry` =24263;
UPDATE `creature_template` SET  `faction_A` =  '15', `faction_H` =  '15' WHERE  `entry` =24264;
UPDATE `creature_template` SET  `faction_A` =  '15', `faction_H` =  '15' WHERE  `entry` =24265;
-- --------------------------------------- --
-- Spell_linked_spell - need for increase speed of ram. This I've found on YTDB.
-- --------------------------------------- --
DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN (-43880, -43883, 42994, 42993, 42992, 43310, 43332, -43332);
INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES
(-43883, -42146, 0, 'Remove brewfest speed buffs when player dismounted'),
(-43883, -42992, 0, 'Remove brewfest speed buffs when player dismounted'),
(-43883, -42993, 0, 'Remove brewfest speed buffs when player dismounted'),
(-43883, -42994, 0, 'Remove brewfest speed buffs when player dismounted'),
(-43883, -43052, 0, 'Remove brewfest speed buffs when player dismounted'),
(-43883, -43310, 0, 'Remove brewfest speed buffs when player dismounted'),
(-43883, -43332, 0, 'Remove brewfest speed buffs when player dismounted'),
(-43883, -43492, 0, 'Remove brewfest speed buffs when player dismounted'),
(-43880, -43492, 0, 'Remove brewfest speed buffs when player dismounted'),
(-43880, -43332, 0, 'Remove brewfest speed buffs when player dismounted'),
(-43880, -43310, 0, 'Remove brewfest speed buffs when player dismounted'),
(-43880, -43052, 0, 'Remove brewfest speed buffs when player dismounted'),
(-43880, -42994, 0, 'Remove brewfest speed buffs when player dismounted'),
(-43880, -42993, 0, 'Remove brewfest speed buffs when player dismounted'),
(-43880, -42992, 0, 'Remove brewfest speed buffs when player dismounted'),
(-43880, -42146, 0, 'Remove brewfest speed buffs when player dismounted'),
(42992, -43332, 0, 'Switch brewfest speed buffs - Exhausted'),
(42992, -43310, 0, 'Switch brewfest speed buffs - Neutral'),
(42992, -42994, 0, 'Switch brewfest speed buffs - Gallop'),
(42992, -42993, 0, 'Switch brewfest speed buffs - Canter'),
(42993, -43332, 0, 'Switch brewfest speed buffs - Exhausted'),
(42993, -43310, 0, 'Switch brewfest speed buffs - Neutral'),
(42993, -42994, 0, 'Switch brewfest speed buffs - Gallop'),
(42993, -42992, 0, 'Switch brewfest speed buffs - Trot'),
(42994, -43332, 0, 'Switch brewfest speed buffs - Exhausted'),
(42994, -43310, 0, 'Switch brewfest speed buffs - Neutral'),
(42994, -42993, 0, 'Switch brewfest speed buffs - Canter'),
(42994, -42992, 0, 'Switch brewfest speed buffs - Trot'),
(43310, -43332, 0, 'Switch brewfest speed buffs - Exhausted'),
(43310, -42994, 0, 'Switch brewfest speed buffs - Gallop'),
(43310, -42993, 0, 'Switch brewfest speed buffs - Canter'),
(43310, -42992, 0, 'Switch brewfest speed buffs - Trot'),
(-43332, 43310, 0, 'Switch brewfest speed buffs - Neutral'),
(43332, -43310, 0, 'Switch brewfest speed buffs - Neutral'),
(43332, -42994, 0, 'Switch brewfest speed buffs - Gallop'),
(43332, -42993, 0, 'Switch brewfest speed buffs - Canter'),
(43332, -42992, 0, 'Switch brewfest speed buffs - Trot');