DB/Misc: fixed various difficulty, spawn and post Cataclysm related startup errors

1 files changed, 20 insertions, 0 deletions

diff --git a/sql/updates/world/cata_classic/2024_08_23_01_world.sql b/sql/updates/world/cata_classic/2024_08_23_01_world.sql
new file mode 100644
index 00000000000..58c4de49559
--- /dev/null
+++ b/sql/updates/world/cata_classic/2024_08_23_01_world.sql
@@ -0,0 +1,20 @@
+-- Remove all entries which were tied to post Cata difficulties
+DELETE FROM `creature_template_difficulty` WHERE `DifficultyID` NOT IN (0, 1, 2, 3, 4, 5, 6, 9, 148, 173, 174, 175, 176, 193, 194);
+
+DELETE FROM `class_expansion_requirement` WHERE `ClassID` IN (10, 12, 13);
+DELETE FROM `class_expansion_requirement` WHERE `RaceID` IN (24, 25, 26, 27, 28, 29, 30, 31, 32, 34, 35, 36, 37);
+DELETE FROM `race_unlock_requirement` WHERE `RaceID` IN (24, 25, 26, 27, 28, 29, 30, 31, 32, 34, 35, 36, 37, 52, 70);
+
+-- Note that we are aware that some spawns belong to 25m only but these spawns have been blended together in the master branch so we just convert data
+-- Move black temple spawns back to difficulty 4
+UPDATE `creature` SET `spawnDifficulties`= '4' WHERE `map`= 564;
+UPDATE `gameobject` SET `spawnDifficulties`= '4' WHERE `map`= 564;
+-- Move ulduar spawns back to difficulty 3 and 4
+UPDATE `creature` SET `spawnDifficulties`= '3,4' WHERE `map`= 603;
+UPDATE `gameobject` SET `spawnDifficulties`= '3,4' WHERE `map`= 603;
+-- Move firelands spawns back to difficulty 3, 4, 5, 6
+UPDATE `creature` SET `spawnDifficulties`= '3,4,5,6' WHERE `map`= 720;
+UPDATE `gameobject` SET `spawnDifficulties`= '3,4,5,6' WHERE `map`= 720;
+
+DELETE FROM `creature_questitem` WHERE `ItemId` IN (89052, 89053, 129912, 129913, 129915, 129916, 134806, 136616, 138951, 138952, 138953, 142345, 142349, 142352, 142353, 142354, 142355, 142385, 142386, 142387, 142388, 150774, 157030, 181354, 192493);
+DELETE FROM `gameobject_questitem` WHERE `ItemId` IN (138953, 138952, 79039, 80227, 80229, 80230);