From 6786a2bc09757fc6a30a083a0af72a281ef91454 Mon Sep 17 00:00:00 2001 From: Meji Date: Sun, 17 Nov 2024 14:16:25 +0100 Subject: 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 --- .../cata_classic/2024_11_17_03_world_2024_11_05_04_world.sql | 12 ++++++++++++ 1 file changed, 12 insertions(+) create mode 100644 sql/updates/world/cata_classic/2024_11_17_03_world_2024_11_05_04_world.sql (limited to 'sql/updates') 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); -- cgit v1.2.3