aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKillyana <morphone1@gmail.com>2019-09-07 14:17:51 +0200
committerKillyana <morphone1@gmail.com>2019-09-07 14:17:51 +0200
commitc892f867d578a0d847979135c9191fbdb8be805b (patch)
tree0d963dac46777a1b10dd388f8c87dcbddbfb554d
parentf8d7b260476c69e09ab0329cb7cd6c277f5473a7 (diff)
DB/Quest: Fix chaining an DB errors
-rw-r--r--sql/updates/world/3.3.5/2019_09_07_00_world.sql10
1 files changed, 10 insertions, 0 deletions
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);