From cdbc9dc1afd9d67e8594deddee7e7ad84c6448a3 Mon Sep 17 00:00:00 2001 From: PolarCookie Date: Sat, 8 Dec 2018 11:07:29 +0100 Subject: DB/Quest: RoB, AoA kill credit targets (Ring of Blood, Amphitheater of Anguish quests) Closes #22751 --- sql/updates/world/3.3.5/2018_12_08_38_world.sql | 32 +++++++++++++++++++++++++ 1 file changed, 32 insertions(+) create mode 100644 sql/updates/world/3.3.5/2018_12_08_38_world.sql (limited to 'sql') diff --git a/sql/updates/world/3.3.5/2018_12_08_38_world.sql b/sql/updates/world/3.3.5/2018_12_08_38_world.sql new file mode 100644 index 00000000000..1ca1ac0854e --- /dev/null +++ b/sql/updates/world/3.3.5/2018_12_08_38_world.sql @@ -0,0 +1,32 @@ +-- Brokentoe +UPDATE `smart_scripts` SET `target_type` = 27 WHERE `entryorguid` = 18398 AND `source_type` = 0 AND `id` = 1; +-- Murkblood Twin +UPDATE `smart_scripts` SET `target_type` = 27 WHERE `entryorguid` = 18399 AND `source_type` = 0 AND `id` = 4; +-- Rokdar the Sundered Lord +UPDATE `smart_scripts` SET `target_type` = 27 WHERE `entryorguid` = 18400 AND `source_type` = 0 AND `id` = 5; +-- Skra'gath +UPDATE `smart_scripts` SET `target_type` = 27 WHERE `entryorguid` = 18401 AND `source_type` = 0 AND `id` = 3; +-- Warmaul Champion +UPDATE `smart_scripts` SET `target_type` = 27 WHERE `entryorguid` = 18402 AND `source_type` = 0 AND `id` = 5; +-- Mogor +UPDATE `smart_scripts` SET `target_type` = 27 WHERE `entryorguid` = 18069 AND `source_type` = 0 AND `id` = 14; +-- Quel'dorei Magewraith +UPDATE `smart_scripts` SET `target_type` = 27 WHERE `entryorguid` = 17612 AND `source_type` = 0 AND `id` = 5; +-- Yggdras +UPDATE `smart_scripts` SET `target_type` = 27 WHERE `entryorguid` = 30014 AND `source_type` = 0 AND `id` IN (4,5); +-- Stinkbeard +UPDATE `smart_scripts` SET `target_type` = 27 WHERE `entryorguid` = 30017 AND `source_type` = 0 AND `id` = 7; +-- Gargoral the Water Lord +UPDATE `smart_scripts` SET `target_type` = 27 WHERE `entryorguid` = 30024 AND `source_type` = 0 AND `id` = 2; +-- Az'Barin, Prince of the Gust +UPDATE `smart_scripts` SET `target_type` = 27 WHERE `entryorguid` = 30026 AND `source_type` = 0 AND `id` = 2; +-- Duke Singen +UPDATE `smart_scripts` SET `target_type` = 27 WHERE `entryorguid` = 30019 AND `source_type` = 0 AND `id` = 2; +-- Erathius, King of Dirt +UPDATE `smart_scripts` SET `target_type` = 27 WHERE `entryorguid` = 30025 AND `source_type` = 0 AND `id` = 2; +-- Orinoko Tuskbreaker +UPDATE `smart_scripts` SET `target_type` = 27 WHERE `entryorguid` = 30020 AND `source_type` = 0 AND `id` = 7; +-- Korrak the Bloodrager +UPDATE `smart_scripts` SET `target_type` = 27 WHERE `entryorguid` = 30023 AND `source_type` = 0 AND `id` = 8; +-- Vladof the Butcher +UPDATE `smart_scripts` SET `target_type` = 27 WHERE `entryorguid` = 30022 AND `source_type` = 0 AND `id` = 6; -- cgit v1.2.3