-- https://tracker.legionbugs.com/view.php?id=26675
UPDATE `quest_template_locale` SET `QuestCompletionLog` = 'Return to Jale Rivermane at Riverbend.' WHERE `ID` = 39498 AND `locale` = 'enUS';

-- https://tracker.legionbugs.com/view.php?id=26760
UPDATE `quest_offer_reward_locale` SET `OfferRewardText` = '$n! Ты где $gбыл:была;?$B$BА, неважно... Рад видеть тебя целым и невредимым.' WHERE `ID` = 14265 AND `Locale` = 'ruRU';

-- Защита падения в оплоте воина
DELETE FROM `eventobject_template` WHERE `entry` = 8900;
INSERT INTO `eventobject_template` (`entry`, `name`, `radius`, `SpellID`, `WorldSafeLocID`, `Flags`, `ScriptName`) VALUES
(8900, 'Catcher Warrior Class Hail', 45, 228931, 0, 0, 'SmartEventObject');

DELETE FROM `eventobject` WHERE `guid` IN (8900);
INSERT INTO `eventobject`(`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `PhaseId`, `position_x`, `position_y`, `position_z`, `orientation`, `LoadBuild`, `LoadExpansion`) VALUES
 (8900, 8900, 1479, 7813, 7813, 1, 1, '', 1098.2391, 7222.5044, 20.172928, 3.109219, 0, 6);

-- Доспехи Воеводы
DELETE FROM `creature_template_addon` WHERE `entry` = 116609;
INSERT INTO `creature_template_addon` (`entry`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `auras`, `LoadBuild`, `LoadExpansion`) VALUES
(116609, 0, 0, 0, 0, 12290, 0, 0, NULL, 0, 6);

DELETE FROM `creature` WHERE `id` = 116609;
INSERT INTO `creature` (`id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `PhaseId`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `randomMoveType`, `randomMoveMinTimer`, `randomMoveMaxTimer`, `ScriptName`, `npcflag`, `npcflag2`, `unit_flags`, `unit_flags3`, `dynamicflags`, `isActive`, `skipClone`, `personal_size`, `isTeemingSpawn`, `MiscData`, `GroupID`, `inhabitType`, `realmMask`, `VerifiedBuild`, `Comment`, `LoadBuild`, `LoadExpansion`) VALUES
(116609, 1479, 7813, 7813, 1, 1, '', 0, 0, 1073.71, 7249.52, 97.9163, 5.85357, 300, 0, 0, 1039267, 0, 0, 1, 500, 3500, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, '', 0, 6);

-- Доспехи Ордена Серебряной Длани
DELETE FROM `creature_template_addon` WHERE `entry` = 116608;
INSERT INTO `creature_template_addon` (`entry`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `auras`, `LoadBuild`, `LoadExpansion`) VALUES
(116608, 0, 0, 0, 0, 12290, 0, 0, NULL, 0, 6);

DELETE FROM `creature` WHERE `id` = 116608;
INSERT INTO `creature` (`id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `PhaseId`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `randomMoveType`, `randomMoveMinTimer`, `randomMoveMaxTimer`, `ScriptName`, `npcflag`, `npcflag2`, `unit_flags`, `unit_flags3`, `dynamicflags`, `isActive`, `skipClone`, `personal_size`, `isTeemingSpawn`, `MiscData`, `GroupID`, `inhabitType`, `realmMask`, `VerifiedBuild`, `Comment`, `LoadBuild`, `LoadExpansion`) VALUES
(116608, 0, 139, 7638, 1, 1, '', 0, 0, 2387.23, -5344.42, 53.8992, 1.8075, 300, 0, 0, 1039267, 0, 0, 1, 500, 3500, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, '', 0, 6);

-- Доспехи Предсказателя
DELETE FROM `creature` WHERE `id` = 116604;
INSERT INTO `creature` (`id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `PhaseId`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `randomMoveType`, `randomMoveMinTimer`, `randomMoveMaxTimer`, `ScriptName`, `npcflag`, `npcflag2`, `unit_flags`, `unit_flags3`, `dynamicflags`, `isActive`, `skipClone`, `personal_size`, `isTeemingSpawn`, `MiscData`, `GroupID`, `inhabitType`, `realmMask`, `VerifiedBuild`, `Comment`, `LoadBuild`, `LoadExpansion`) VALUES
(116604, 1469, 7745, 7753, 1, 1, '', 0, 0, 942.351, 1093.73, 17.2446, 5.18352, 300, 0, 0, 1039267, 0, 0, 1, 500, 3500, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, '', 0, 6);

DELETE FROM `creature_template_addon` WHERE `entry` = 116604;
INSERT INTO `creature_template_addon` (`entry`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `auras`, `LoadBuild`, `LoadExpansion`) VALUES
(116604, 0, 0, 0, 0, 12290, 0, 0, NULL, 0, 6);

-- Доспехи Совета Мрачной Жатвы
DELETE FROM `creature` WHERE `id` = 116611;
INSERT INTO `creature` (`id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `PhaseId`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `randomMoveType`, `randomMoveMinTimer`, `randomMoveMaxTimer`, `ScriptName`, `npcflag`, `npcflag2`, `unit_flags`, `unit_flags3`, `dynamicflags`, `isActive`, `skipClone`, `personal_size`, `isTeemingSpawn`, `MiscData`, `GroupID`, `inhabitType`, `realmMask`, `VerifiedBuild`, `Comment`, `LoadBuild`, `LoadExpansion`) VALUES
(116611, 1107, 7875, 7875, 1, 1, '', 0, 0, 3113.22, 943.29, 257.429, 2.1988, 300, 0, 0, 1039267, 0, 0, 1, 500, 3500, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, '', 0, 6);

DELETE FROM `creature_template_addon` WHERE `entry` = 116611;
INSERT INTO `creature_template_addon` (`entry`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `auras`, `LoadBuild`, `LoadExpansion`) VALUES
(116611, 0, 0, 0, 0, 12290, 0, 0, NULL, 0, 6);


-- https://tracker.legionbugs.com/view.php?id=26845
UPDATE `quest_template_addon` SET `PrevQuestID` = 13420, `SpecialFlags` = 1 WHERE `ID` = 13421;

-- https://tracker.legionbugs.com/view.php?id=22878
DELETE FROM `creature_onkill_reputation` WHERE `creature_id` IN (18037,18065,18064,17138,17134,17135,17148,17146,17147,18033,18391);
INSERT INTO `creature_onkill_reputation` (`creature_id`, `RewFaction`, `RewValueMin`, `RewValueMax`, `MaxStanding`, `SpawnMask`, `PlayerTeam`) VALUES
(18037, 978, 10, 10, 7, 0, 469),
(18037, 941, 10, 10, 7, 0, 67),
(18065, 978, 10, 10, 7, 0, 469),
(18065, 941, 10, 10, 7, 0, 67),
(18064, 978, 10, 10, 7, 0, 469),
(18064, 941, 10, 10, 7, 0, 67),
(17138, 978, 10, 10, 7, 0, 469),
(17138, 941, 10, 10, 7, 0, 67),
(17134, 978, 10, 10, 7, 0, 469),
(17134, 941, 10, 10, 7, 0, 67),
(17135, 978, 10, 10, 7, 0, 469),
(17135, 941, 10, 10, 7, 0, 67),
(17148, 978, 10, 10, 7, 0, 469),
(17148, 941, 10, 10, 7, 0, 67),
(17146, 978, 10, 10, 7, 0, 469),
(17146, 941, 10, 10, 7, 0, 67),
(17147, 978, 10, 10, 7, 0, 469),
(17147, 941, 10, 10, 7, 0, 67),
(18033, 978, 10, 10, 7, 0, 469),
(18033, 941, 10, 10, 7, 0, 67),
(18391, 978, 10, 10, 7, 0, 469),
(18391, 941, 10, 10, 7, 0, 67);