aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorKillyana <morphone1@gmail.com>2019-09-07 14:17:51 +0200
committerShauren <shauren.trinity@gmail.com>2021-12-18 21:46:58 +0100
commiteb83175e9137685710a4128c655d12a05d94c4c6 (patch)
tree34e873f6f8c2700f4c058333117dc828e300fcbc /sql
parentcc0940fe25bc4627ad0be47243992a4733ab43a8 (diff)
DB/Quest: Fix chaining an DB errors
(cherry picked from commit c892f867d578a0d847979135c9191fbdb8be805b)
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/master/2021_12_18_30_world_2019_09_07_00_world.sql10
1 files changed, 10 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_12_18_30_world_2019_09_07_00_world.sql b/sql/updates/world/master/2021_12_18_30_world_2019_09_07_00_world.sql
new file mode 100644
index 00000000000..4b5eb530785
--- /dev/null
+++ b/sql/updates/world/master/2021_12_18_30_world_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);