DB/Phase: Name some phases for Siren Isle and Lingering Shadows questchain

1 files changed, 42 insertions, 0 deletions

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');