From 596c0cd5f7f60b5b19a888eb82b51a81bb998ed8 Mon Sep 17 00:00:00 2001 From: megamage Date: Mon, 17 Aug 2009 13:09:42 -0500 Subject: *Fix dk quest chain until "The Scarlet Apocalypse" --HG-- branch : trunk --- sql/FULL/world_spell_full.sql | 22 ++++++++++++++++++++++ sql/updates/5155_world_scripts_dk.sql | 18 ++++++++++++++++++ 2 files changed, 40 insertions(+) create mode 100644 sql/updates/5155_world_scripts_dk.sql (limited to 'sql') diff --git a/sql/FULL/world_spell_full.sql b/sql/FULL/world_spell_full.sql index 3503699d1bf..0296dd296cb 100644 --- a/sql/FULL/world_spell_full.sql +++ b/sql/FULL/world_spell_full.sql @@ -2018,6 +2018,26 @@ INSERT INTO `npc_spellclick_spells` (npc_entry, spell_id, quest_start, quest_sta update item_template set spellppmRate_1 = 1 where entry = 39371; -- persuader +DELETE FROM `creature_questrelation` WHERE `quest` = 12754; +INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (28914, 12754); +DELETE FROM `creature_involvedrelation` WHERE `quest` = 12754; +INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (28914, 12754); +DELETE FROM `creature_questrelation` WHERE `quest` = 12755; +INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (28914, 12755); +DELETE FROM `creature_involvedrelation` WHERE `quest` = 12755; +INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (29077, 12755); +DELETE FROM `creature_questrelation` WHERE `quest` = 12756; +INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (29077, 12756); +DELETE FROM `creature_involvedrelation` WHERE `quest` = 12756; +INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (28914, 12756); +DELETE FROM `creature_questrelation` WHERE `quest` = 12757; +INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (28914, 12757); + +UPDATE `quest_template` SET `PrevQuestId`=12751 WHERE `entry`=12754; + +update spell_area set quest_end = 12756 where spell=53081; + + -- -------- -- NAXXARAMAS -- -------- @@ -2064,6 +2084,8 @@ INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES (27935, 1, 16060), # To Anchor 1 - Gothik (27936, 1, 16060); # To Anchor 2 - Gothik + + -- -------- -- ULDUAR -- -------- diff --git a/sql/updates/5155_world_scripts_dk.sql b/sql/updates/5155_world_scripts_dk.sql new file mode 100644 index 00000000000..341caa75626 --- /dev/null +++ b/sql/updates/5155_world_scripts_dk.sql @@ -0,0 +1,18 @@ +DELETE FROM `creature_questrelation` WHERE `quest` = 12754; +INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (28914, 12754); +DELETE FROM `creature_involvedrelation` WHERE `quest` = 12754; +INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (28914, 12754); +DELETE FROM `creature_questrelation` WHERE `quest` = 12755; +INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (28914, 12755); +DELETE FROM `creature_involvedrelation` WHERE `quest` = 12755; +INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (29077, 12755); +DELETE FROM `creature_questrelation` WHERE `quest` = 12756; +INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (29077, 12756); +DELETE FROM `creature_involvedrelation` WHERE `quest` = 12756; +INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (28914, 12756); +DELETE FROM `creature_questrelation` WHERE `quest` = 12757; +INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (28914, 12757); + +UPDATE `quest_template` SET `PrevQuestId`=12751 WHERE `entry`=12754; + +update spell_area set quest_end = 12756 where spell=53081; -- cgit v1.2.3