From 92260903567c51e9df11c48655e771a10c66b63f Mon Sep 17 00:00:00 2001 From: Naddley Date: Fri, 20 Dec 2024 19:07:25 +0100 Subject: DB/Phase: Name some phases for Siren Isle and Lingering Shadows questchain --- sql/updates/world/master/2024_12_20_03_world.sql | 42 ++++++++++++++++++++++++ 1 file changed, 42 insertions(+) create mode 100644 sql/updates/world/master/2024_12_20_03_world.sql (limited to 'sql') diff --git a/sql/updates/world/master/2024_12_20_03_world.sql b/sql/updates/world/master/2024_12_20_03_world.sql new file mode 100644 index 00000000000..fb6150e9f23 --- /dev/null +++ b/sql/updates/world/master/2024_12_20_03_world.sql @@ -0,0 +1,42 @@ +-- Phase Names +DELETE FROM `phase_name` WHERE `ID` IN (25497, 25056, 24738, 24737, 24858, 24857, 25191, 25192, 24684, 25070, 24695, 24788, 24806, 24808, 24933, 25307, 25306, 23897, 23970, 23969, 23968, 23994, 23998, 23996, 24013, 24012, 24103, 24014, 24017, 24018, 25396, 24981, 24856, 24104, 25409, 24458, 24457, 24459, 24968); +INSERT INTO `phase_name` (`ID`, `Name`) VALUES +(25497, 'Cosmetic - See Goblins infront of Dawn in the Foundation Hall'), +(25056, 'Cosmetic - See Skaggit to depart from Dornogal'), +(24738, 'Cosmetic - See Skaggit arrived at Siren Island'), +(24737, 'Cosmetic - See Skaggit enter Flotsam Shoal'), +(24858, 'Cosmetic - See Apprentice Tanmar before carry Radiant Remnants'), +(24857, 'Cosmetic - See Apprentice Tanmar after carry Radiant Remnants'), +(25191, 'Cosmetic - See Crate with Radiant Remnants before moved'), +(25192, 'Cosmetic - See Crate with Radiant Remnants after moved'), +(24684, 'Cosmetic - See Bargus concentrated to work'), +(25070, 'Cosmetic - See Bargus after Scan a Crystal'), +(24695, 'Cosmetic - See Bargus at the first Signal'), +(24788, 'Cosmetic - See Bargus at the second Signal'), +(24806, 'Cosmetic - See Rocks at the entrance of The Sacred Hollow'), +(24808, 'Cosmetic - See Bargus in The Sacred Hollow'), +(24933, 'Cosmetic - See Glittering Ancient Tablets in The Forgotten Vault'), +(25307, 'Cosmetic - See Dawn at the Flotsam Shoal'), +(25306, 'Cosmetic - See Rune-Seared Spear (gob)'), +(23897, 'Cosmetic - See Spindle caged in Meesks Retreat'), +(23970, 'Cosmetic - See On''Hiea evacuated'), +(23969, 'Cosmetic - See Ney''Leia evacuated'), +(23968, 'Cosmetic - See Greenspeaker Nay''Laro evacuated'), +(23994, 'Cosmetic - See Orweyna and Hannan in Sanguine Grasps'), +(23998, 'Cosmetic - See Hannan at Rumshackle'), +(23996, 'Cosmetic - See Orweyna at Rumshackle'), +(24013, 'Cosmetic - See Haxle Drillbits at Camp Murroch'), +(24012, 'Cosmetic - See Orweyna and Monte Gazlowe at Camp Murroch'), +(24103, 'Cosmetic - See Orweyna fly around Haxle Drillbits'), +(24014, 'Cosmetic - See Haxle Drillbits Cart'), +(24017, 'Cosmetic - See Orweyna at the Opportunity Point'), +(24018, 'Cosmetic - See Renzik "The Shiv" at the Abyssal Excavation'), +(25396, 'Cosmetic - See Orweyna in Dornogal, Foundation Hall'), +(24981, 'Spirit Scarred Cave - Inhyldir the Cursed'), +(24856, 'Cosmetic - See Survey Devices (gob)'), +(24104, 'Siren Isle - Storm Phase'), +(25409, 'Cosmetic - See Starving Snapdragon (Stage 1)'), +(24458, 'Cosmetic - See Siren Isle Vyrkul Camp gameobject spawns'), +(24457, 'Cosmetic - See Siren Isle Naga Camp gameobject spawns'), +(24459, 'Cosmetic - See Siren Isle Pirate Camp gameobject spawns'), +(24968, 'Cosmetic - See Alleria Windrunner in Dornogal, Foundation Hall'); -- cgit v1.2.3