DB/Game_event: add missing game_event_gameobject entries

Closes #28627 by @Foldor

1 files changed, 33 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2023_04_06_00_world.sql b/sql/updates/world/3.3.5/2023_04_06_00_world.sql
new file mode 100644
index 00000000000..7515a92ee56
--- /dev/null
+++ b/sql/updates/world/3.3.5/2023_04_06_00_world.sql
@@ -0,0 +1,33 @@
+--
+DELETE FROM `game_event_gameobject` WHERE `guid` IN (28140, 28142, 28143, 28144, 28150, 28152, 28156, 28157, 28160, 28161, 28162, 28163, 28168, 28169, 28171, 28173, 28176, 28177, 28178, 28180, 28188, 77739, 77740, 77742, 77743, 77745, 77746, 77747) AND `eventEntry` IN (1, 12);
+INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES 
+-- MFF Cleanup
+(1, 28140),
+(1, 28142),
+(1, 28143),
+(1, 28144),
+(1, 28150),
+(1, 28152),
+(1, 28156),
+(1, 28157),
+(1, 28160),
+(1, 28161),
+(1, 28162),
+(1, 28163),
+(1, 28168),
+(1, 28169),
+(1, 28171),
+(1, 28173),
+(1, 28176),
+(1, 28177),
+(1, 28178),
+(1, 28180),
+(1, 28188),
+-- Hallow's End Cleanup
+(12, 77739),
+(12, 77740),
+(12, 77742),
+(12, 77743),
+(12, 77745),
+(12, 77746),
+(12, 77747);