DB/Misc: removed most post Cataclysm spawns and wiped scenarios and scene_template tables

1 files changed, 58 insertions, 0 deletions

diff --git a/sql/updates/world/cata_classic/2024_03_12_00_world.sql b/sql/updates/world/cata_classic/2024_03_12_00_world.sql
new file mode 100644
index 00000000000..19f05eae278
--- /dev/null
+++ b/sql/updates/world/cata_classic/2024_03_12_00_world.sql
@@ -0,0 +1,58 @@
+-- Remove post cataclysm spawns
+-- Creatures
+SET @CGUIDSTART := 5000000;
+SET @CGUIDEND := 9999999;
+DELETE FROM `creature` WHERE `guid` BETWEEN @CGUIDSTART AND @CGUIDEND;
+DELETE FROM `creature_addon` WHERE `guid` BETWEEN @CGUIDSTART AND @CGUIDEND;
+DELETE FROM `creature_formations` WHERE `leaderGUID` BETWEEN @CGUIDSTART AND @CGUIDEND;
+DELETE FROM `creature_formations` WHERE `memberGUID` BETWEEN @CGUIDSTART AND @CGUIDEND;
+DELETE FROM `creature_movement_override` WHERE `spawnId` BETWEEN @CGUIDSTART AND @CGUIDEND;
+DELETE FROM `game_event_creature` WHERE `guid` BETWEEN @CGUIDSTART AND @CGUIDEND;
+DELETE FROM `pool_members` WHERE `type`=0 AND `spawnId` BETWEEN @CGUIDSTART AND @CGUIDEND;
+DELETE FROM `spawn_group` WHERE `spawnType`=0 AND `spawnId` BETWEEN @CGUIDSTART AND @CGUIDEND;
+DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid` BETWEEN -@CGUIDEND AND -@CGUIDSTART;
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=22 AND `SourceId`=0 AND `SourceEntry` BETWEEN -@CGUIDEND AND -@CGUIDSTART;
+DELETE FROM `conversation_actors` WHERE `ConversationActorGuid` BETWEEN @CGUIDSTART AND @CGUIDEND;
+
+SET @CGUIDSTART := 450000;
+SET @CGUIDEND := 1249999;
+DELETE FROM `creature` WHERE `guid` BETWEEN @CGUIDSTART AND @CGUIDEND;
+DELETE FROM `creature_addon` WHERE `guid` BETWEEN @CGUIDSTART AND @CGUIDEND;
+DELETE FROM `creature_formations` WHERE `leaderGUID` BETWEEN @CGUIDSTART AND @CGUIDEND;
+DELETE FROM `creature_formations` WHERE `memberGUID` BETWEEN @CGUIDSTART AND @CGUIDEND;
+DELETE FROM `creature_movement_override` WHERE `spawnId` BETWEEN @CGUIDSTART AND @CGUIDEND;
+DELETE FROM `game_event_creature` WHERE `guid` BETWEEN @CGUIDSTART AND @CGUIDEND;
+DELETE FROM `pool_members` WHERE `type`=0 AND `spawnId` BETWEEN @CGUIDSTART AND @CGUIDEND;
+DELETE FROM `spawn_group` WHERE `spawnType`=0 AND `spawnId` BETWEEN @CGUIDSTART AND @CGUIDEND;
+DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid` BETWEEN -@CGUIDEND AND -@CGUIDSTART;
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=22 AND `SourceId`=0 AND `SourceEntry` BETWEEN -@CGUIDEND AND -@CGUIDSTART;
+DELETE FROM `conversation_actors` WHERE `ConversationActorGuid` BETWEEN @CGUIDSTART AND @CGUIDEND;
+
+-- gameobjects
+SET @CGUIDSTART := 5000000;
+SET @CGUIDEND := 9999999;
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUIDSTART AND @OGUIDEND;
+DELETE FROM `gameobject_addon` WHERE `guid` BETWEEN @OGUIDSTART AND @OGUIDEND;
+DELETE FROM `gameobject_overrides` WHERE `spawnId` BETWEEN @OGUIDSTART AND @OGUIDEND;
+DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN @OGUIDSTART AND @OGUIDEND;
+DELETE FROM `pool_members` WHERE `type`=1 AND `spawnId` BETWEEN @OGUIDSTART AND @OGUIDEND;
+DELETE FROM `spawn_group` WHERE `spawnType`=1 AND `spawnId` BETWEEN @OGUIDSTART AND @OGUIDEND;
+DELETE FROM `smart_scripts` WHERE `source_type`=1 AND `entryorguid` BETWEEN -@OGUIDEND AND -@OGUIDSTART;
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=22 AND `SourceId`=1 AND `SourceEntry` BETWEEN -@OGUIDEND AND -@OGUIDSTART;
+
+SET @CGUIDSTART := 300000;
+SET @CGUIDEND := 699999;
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUIDSTART AND @OGUIDEND;
+DELETE FROM `gameobject_addon` WHERE `guid` BETWEEN @OGUIDSTART AND @OGUIDEND;
+DELETE FROM `gameobject_overrides` WHERE `spawnId` BETWEEN @OGUIDSTART AND @OGUIDEND;
+DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN @OGUIDSTART AND @OGUIDEND;
+DELETE FROM `pool_members` WHERE `type`=1 AND `spawnId` BETWEEN @OGUIDSTART AND @OGUIDEND;
+DELETE FROM `spawn_group` WHERE `spawnType`=1 AND `spawnId` BETWEEN @OGUIDSTART AND @OGUIDEND;
+DELETE FROM `smart_scripts` WHERE `source_type`=1 AND `entryorguid` BETWEEN -@OGUIDEND AND -@OGUIDSTART;
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=22 AND `SourceId`=1 AND `SourceEntry` BETWEEN -@OGUIDEND AND -@OGUIDSTART;
+
+-- Wipe all scenarios
+DELETE FROM `scenarios`;
+
+-- Wipe all scenes
+DELETE FROM `scene_template`;