From d081813212411183d934aed897a9fc64815bf6f0 Mon Sep 17 00:00:00 2001 From: Ovahlord Date: Tue, 28 May 2024 21:15:06 +0200 Subject: DB/Spawns: applied missing cherry pick part exclusive to classic added in 1c56e179a8fb5d37bfdf9371293c3db653403c2a --- .../world/cata_classic/2024_05_28_00_world.sql | 26 ++++++++++++++++++++++ 1 file changed, 26 insertions(+) create mode 100644 sql/updates/world/cata_classic/2024_05_28_00_world.sql (limited to 'sql') diff --git a/sql/updates/world/cata_classic/2024_05_28_00_world.sql b/sql/updates/world/cata_classic/2024_05_28_00_world.sql new file mode 100644 index 00000000000..6077c054c20 --- /dev/null +++ b/sql/updates/world/cata_classic/2024_05_28_00_world.sql @@ -0,0 +1,26 @@ +-- Cata classic only (cherry-pick) +DELETE FROM `creature` WHERE `guid` BETWEEN 3000021 AND 3000025; +DELETE FROM `game_event_creature` WHERE `guid` BETWEEN 3000021 AND 3000025; +DELETE FROM `creature` WHERE `guid` BETWEEN 3000026 AND 3000031; +DELETE FROM `game_event_creature` WHERE `guid` BETWEEN 3000026 AND 3000031; +DELETE FROM `creature` WHERE `guid` BETWEEN 2000000 AND 2000004; +DELETE FROM `game_event_creature` WHERE `guid` BETWEEN 2000000 AND 2000004; +DELETE FROM `creature` WHERE `guid` BETWEEN 3000050 AND 3000054; +DELETE FROM `game_event_creature` WHERE `guid` BETWEEN 3000050 AND 3000054; +DELETE FROM `creature` WHERE `guid` BETWEEN 3000055 AND 3000060; +DELETE FROM `game_event_creature` WHERE `guid` BETWEEN 3000055 AND 3000060; +DELETE FROM `creature` WHERE `guid` BETWEEN 2000005 AND 2000010; +DELETE FROM `game_event_creature` WHERE `guid` BETWEEN 2000005 AND 2000010; + +DELETE FROM `gameobject` WHERE `guid` BETWEEN 3000635 AND 3000719; +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 3000635 AND 3000719; +DELETE FROM `gameobject` WHERE `guid` BETWEEN 3000720 AND 3000860; +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 3000720 AND 3000860; +DELETE FROM `gameobject` WHERE `guid` BETWEEN 2000000 AND 2000154; +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 2000000 AND 2000154; +DELETE FROM `gameobject` WHERE `guid` BETWEEN 3001025 AND 3001144; +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 3001025 AND 3001144; +DELETE FROM `gameobject` WHERE `guid` BETWEEN 3001145 AND 3001258; +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 3001145 AND 3001258; +DELETE FROM `gameobject` WHERE `guid` BETWEEN 2000155 AND 2000376; +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 2000155 AND 2000376; -- cgit v1.2.3