DB/Faction Change: Prevent breaking of Dungeon Set 2 Quests when player changes faction

Closes #27791

(cherry picked from commit 410c3ff25f1484858263255bd3433f52280fa8ec)

1 files changed, 42 insertions, 0 deletions

diff --git a/sql/updates/world/master/2022_03_26_16_world_2022_02_18_00_world.sql b/sql/updates/world/master/2022_03_26_16_world_2022_02_18_00_world.sql
new file mode 100644
index 00000000000..c2ba986142f
--- /dev/null
+++ b/sql/updates/world/master/2022_03_26_16_world_2022_02_18_00_world.sql
@@ -0,0 +1,42 @@
+-- Prevent breaking of T0,5 Questchain when a player changes faction
+DELETE FROM `player_factionchange_quests` WHERE `alliance_id` IN (8905, 8906, 8907, 8908, 8909, 8910, 8911, 8912, 8922, 8926, 8929, 8931, 8932, 8933, 8934, 8935, 8936, 8937, 8951, 8952, 8953, 8954, 8955, 8956, 8958, 8959, 8977, 8999, 9000, 9001, 9002, 9003, 9004, 9005, 9006, 10492, 10494, 10496, 10498);
+INSERT INTO `player_factionchange_quests` (`alliance_id`, `horde_id`) VALUES
+(8905, 8913),
+(8906, 8914),
+(8907, 8915),
+(8908, 10493),
+(8909, 8916),
+(8910, 8917),
+(8911, 8919),
+(8912, 8920),
+(8922, 8923),
+(8926, 8927),
+(8929, 8930),
+(8931, 8938),
+(8932, 8939),
+(8933, 10495),
+(8934, 8940),
+(8935, 8941),
+(8936, 8943),
+(8937, 8944),
+(8951, 9016),
+(8952, 9017),
+(8953, 9018),
+(8954, 10497),
+(8955, 9019),
+(8956, 9020),
+(8958, 9021),
+(8959, 9022),
+(8977, 8978),
+(8999, 9007),
+(9000, 9008),
+(9001, 9014),
+(9002, 10499),
+(9003, 9009),
+(9004, 9010),
+(9005, 9012),
+(9006, 9013),
+(10492, 8918),
+(10494, 8942),
+(10496, 8957),
+(10498, 9011);