From c892f867d578a0d847979135c9191fbdb8be805b Mon Sep 17 00:00:00 2001 From: Killyana Date: Sat, 7 Sep 2019 14:17:51 +0200 Subject: DB/Quest: Fix chaining an DB errors --- sql/updates/world/3.3.5/2019_09_07_00_world.sql | 10 ++++++++++ 1 file changed, 10 insertions(+) create mode 100644 sql/updates/world/3.3.5/2019_09_07_00_world.sql (limited to 'sql') diff --git a/sql/updates/world/3.3.5/2019_09_07_00_world.sql b/sql/updates/world/3.3.5/2019_09_07_00_world.sql new file mode 100644 index 00000000000..4b5eb530785 --- /dev/null +++ b/sql/updates/world/3.3.5/2019_09_07_00_world.sql @@ -0,0 +1,10 @@ +-- +DELETE FROM `disables` WHERE `sourceType`=1 AND `entry`=13381; +DELETE FROM `quest_template_addon` WHERE `ID` IN (13404, 13382); +INSERT INTO `quest_template_addon` (`ID`, `PrevQuestID`, `SpecialFlags`) VALUES +(13404, 13380,1), +(13382, 13381,1); +UPDATE `quest_template_addon` SET `PrevQuestID`=13374 WHERE `id`=13376; +DELETE FROM `player_factionchange_quests` WHERE `alliance_id`=13404; +INSERT INTO `player_factionchange_quests` (`alliance_id`, `horde_id`) VALUES +(13404, 13406); -- cgit v1.2.3