From 4a345301b84b5ab86a966ea473aed98b1608b2a6 Mon Sep 17 00:00:00 2001 From: Naddley Date: Sat, 17 May 2025 16:59:21 +0200 Subject: DB/Drustvar: Handle Krazzlefrazz and Swiftwind Outpost phases + clientside gameobject spawns --- sql/updates/world/master/2025_05_17_01_world.sql | 18 ++++++++++++++++++ 1 file changed, 18 insertions(+) create mode 100644 sql/updates/world/master/2025_05_17_01_world.sql (limited to 'sql') diff --git a/sql/updates/world/master/2025_05_17_01_world.sql b/sql/updates/world/master/2025_05_17_01_world.sql new file mode 100644 index 00000000000..37da7fcf131 --- /dev/null +++ b/sql/updates/world/master/2025_05_17_01_world.sql @@ -0,0 +1,18 @@ +-- Phase +DELETE FROM `phase_name` WHERE `ID` IN (10892,10893,10894,10895,10896,11356); +INSERT INTO `phase_name` (`ID`, `Name`) VALUES +(10892, 'Cosmetic - See Horde Krazzlefrazz Outpost Building 1'), +(10893, 'Cosmetic - See Horde Krazzlefrazz Outpost Building 2'), +(10894, 'Cosmetic - See Horde Krazzlefrazz Outpost Building 5 - Torch'), +(10895, 'Cosmetic - See Horde Krazzlefrazz Outpost Building 4'), +(10896, 'Cosmetic - See Horde Krazzlefrazz Outpost Building 5'), +(11356, 'Cosmetic - See Horde Swiftwind Post Buildings'); + +DELETE FROM `phase_area` WHERE `PhaseId` IN (10892,10893,10894,10895,10896,11356); +INSERT INTO `phase_area` (`AreaId`, `PhaseId`, `Comment`) VALUES +(8721, 10892, 'See Horde Krazzlefrazz Outpost Building 1'), +(8721, 10893, 'See Horde Krazzlefrazz Outpost Building 2'), +(8721, 10894, 'See Horde Krazzlefrazz Outpost Building 5 - Torch'), +(8721, 10895, 'See Horde Krazzlefrazz Outpost Building 4'), +(8721, 10896, 'See Horde Krazzlefrazz Outpost Building 5'), +(8721, 11356, 'See Horde Swiftwind Post Buildings'); -- cgit v1.2.3