DB/World: Drop wrong spawns for Hallow's End

(cherry picked from commit 5385fd9c15bfbf1934942b587f8ee584c2538965)

# Conflicts:
#	sql/old/4.4.x/world/24061_2024_10_27/2024_11_05_04_world.sql

1 files changed, 12 insertions, 0 deletions

diff --git a/sql/updates/world/cata_classic/2024_11_17_03_world_2024_11_05_04_world.sql b/sql/updates/world/cata_classic/2024_11_17_03_world_2024_11_05_04_world.sql
new file mode 100644
index 00000000000..8467954fcdd
--- /dev/null
+++ b/sql/updates/world/cata_classic/2024_11_17_03_world_2024_11_05_04_world.sql
@@ -0,0 +1,12 @@
+-- Creature templates
+UPDATE `waypoint_path` SET `Comment`='Black Cat - Cosmetic Path' WHERE `PathId`=2281600;
+UPDATE `waypoint_path_node` SET `Delay`=10 WHERE `PathId`=2281600 AND `NodeId` IN (0,1);
+
+-- Spawns
+DELETE FROM `gameobject` WHERE `guid`=3808020 AND `id`=180448;
+SET @UPDATED := EXISTS(SELECT * FROM `gameobject` WHERE `guid`=3808020);
+UPDATE `gameobject` SET `guid`=`guid`-1 WHERE @UPDATED=0 AND `guid` BETWEEN 3808021 AND 3808386;
+DELETE FROM `gameobject` WHERE `guid`=3808387 AND `id`=180453;
+SET @UPDATED := EXISTS(SELECT * FROM `gameobject` WHERE `guid` IN (3808386,3808387));
+UPDATE `gameobject` SET `guid`=`guid`-2 WHERE @UPDATED=0 AND `guid` BETWEEN 3808387 AND 3808498;
+DELETE FROM `game_event_gameobject` WHERE `guid` IN (3808497,3808498);