DB/Phases: Added phase names for Dragon Glyphs

1 files changed, 53 insertions, 0 deletions

diff --git a/sql/updates/world/master/2023_10_05_06_world_dragonisles_dragon_glyphs.sql b/sql/updates/world/master/2023_10_05_06_world_dragonisles_dragon_glyphs.sql
new file mode 100644
index 00000000000..7a9ce4099bf
--- /dev/null
+++ b/sql/updates/world/master/2023_10_05_06_world_dragonisles_dragon_glyphs.sql
@@ -0,0 +1,53 @@
+DELETE FROM `phase_name` WHERE `ID` IN(19858, 19875, 19871, 19878, 19877, 19874, 19881, 19880, 19876, 19879, 19882, 19873, 19890, 19893, 19892, 19891, 19894, 19884, 19887, 19886, 19888, 19885, 19872, 19883, 19870, 19867, 19863, 19869, 19868, 19866, 19862, 19861, 19864, 19865, 19859, 19860, 19846, 19849, 19850, 19856, 19851, 19857, 19855, 19853, 19854, 19847, 19848, 19852);
+INSERT INTO `phase_name` (`ID`, `Name`) VALUES
+(19858, 'Ohn''ahran Plains Dragon Glyph: Rubyscale Outpost'),
+(19875, 'Ohn''ahran Plains Dragon Glyph: Mirewood Fen'),
+(19871, 'Ohn''ahran Plains Dragon Glyph: Rusza''thar Reach'),
+(19878, 'Ohn''ahran Plains Dragon Glyph: Ohn''ahra''s Roost'),
+(19877, 'Ohn''ahran Plains Dragon Glyph: Nokhudon Hold'),
+(19874, 'Ohn''ahran Plains Dragon Glyph: Emerald Gardens'),
+(19881, 'Ohn''ahran Plains Dragon Glyph: The Eternal Kurgans'),
+(19880, 'Ohn''ahran Plains Dragon Glyph: Szar Skeleth'),
+(19876, 'Ohn''ahran Plains Dragon Glyph: Mirror of the Sky'),
+(19879, 'Ohn''ahran Plains Dragon Glyph: Ohn''iri Springs'),
+(19882, 'Ohn''ahran Plains Dragon Glyph: Windsong Rise'),
+(19873, 'Ohn''ahran Plains Dragon Glyph: Dragonsprings Summit'),
+-- 
+(19890, 'Azure Span Dragon Glyph: Forkriver Crossing'),
+(19893, 'Azure Span Dragon Glyph: Drake Eye''s Pond'),
+(19892, 'Azure Span Dragon Glyph: Brackenhide Hollow'),
+(19891, 'Azure Span Dragon Glyph: Azure Archives'),
+(19894, 'Azure Span Dragon Glyph: Zelthrak Outpost'),
+(19884, 'Azure Span Dragon Glyph: Imbu'),
+(19887, 'Azure Span Dragon Glyph: Ruins of Karnthar'),
+(19886, 'Azure Span Dragon Glyph: Lost Ruins'),
+(19888, 'Azure Span Dragon Glyph: Vakthros Range'),
+(19885, 'Azure Span Dragon Glyph: Rhonin''s Shield'),
+(19872, 'Azure Span Dragon Glyph: The Fallen Course'),
+(19883, 'Azure Span Dragon Glyph: Cobalt Assembly'),
+-- 
+(19870, 'Thaldraszus Dragon Glyph: Temporal Conflux'),
+(19867, 'Thaldraszus Dragon Glyph: Passage of Time'),
+(19863, 'Thaldraszus Dragon Glyph: Gelikyr Overlook'),
+(19869, 'Thaldraszus Dragon Glyph: Stormshroud Peak'),
+(19868, 'Thaldraszus Dragon Glyph: South Hold Gate'),
+(19866, 'Thaldraszus Dragon Glyph: Valdrakken'),
+(19862, 'Thaldraszus Dragon Glyph: Algeth''era'),
+(19861, 'Thaldraszus Dragon Glyph: Algeth''ar Academy'),
+(19864, 'Thaldraszus Dragon Glyph: Tyrhold'),
+(19865, 'Thaldraszus Dragon Glyph: Vault of the Incarnates'),
+(19859, 'Thaldraszus Dragon Glyph: Thaldraszus Apex'),
+(19860, 'Thaldraszus Dragon Glyph: Veiled Ossuary'),
+-- 
+(19846, 'The Waking Shores Dragon Glyph: Scalecracker Peak'),
+(19849, 'The Waking Shores Dragon Glyph: Life-Binder Observatory'),
+(19850, 'The Waking Shores Dragon Glyph: The Overflowing Spring'),
+(19856, 'The Waking Shores Dragon Glyph: Obsidian Throne'),
+(19851, 'The Waking Shores Dragon Glyph: Obsidian Bulwark'),
+(19857, 'The Waking Shores Dragon Glyph: Ruby Life Pools Peaks'),
+(19855, 'The Waking Shores Dragon Glyph: Flashfrost Enclave'),
+(19853, 'The Waking Shores Dragon Glyph: Skytop Observatory Tower'),
+(19854, 'The Waking Shores Dragon Glyph: Skytop Observatory Rostrum'),
+(19847, 'The Waking Shores Dragon Glyph: Crumblind Life Arcway'),
+(19848, 'The Waking Shores Dragon Glyph: Dragonheart Outpost'),
+(19852, 'The Waking Shores Dragon Glyph: Wingrest Embassy');