From 7b0d2eb39e7f2b0295b1d40b70b8d757c20f5d72 Mon Sep 17 00:00:00 2001 From: ModoX Date: Sun, 12 May 2024 05:50:11 +0200 Subject: DB/Phases: Added Northrend Cup phase names --- sql/updates/world/master/2024_05_12_03_world.sql | 39 ++++++++++++++++++++++++ 1 file changed, 39 insertions(+) create mode 100644 sql/updates/world/master/2024_05_12_03_world.sql diff --git a/sql/updates/world/master/2024_05_12_03_world.sql b/sql/updates/world/master/2024_05_12_03_world.sql new file mode 100644 index 00000000000..2fe153820dc --- /dev/null +++ b/sql/updates/world/master/2024_05_12_03_world.sql @@ -0,0 +1,39 @@ +DELETE FROM `phase_name` WHERE `ID` IN(22061,22145,22146,22147,22136,22137,22138,22086,22087,22088,22064,22067,22068,22074,22083,22084,22091,22092,22093,22506,22507,22508,22121,22122,22123,22161,22162,22163,22172,22173,22174,22210,22211,22212,22519,22524,22525); +INSERT INTO `phase_name` (`ID`, `Name`) VALUES +-- (22061, 'Northrend Cup - Unk'), +(22145, 'Northrend Cup - Dragonblight Dragon Flight - Basic Course'), +(22146, 'Northrend Cup - Dragonblight Dragon Flight - Advanced Course'), +(22147, 'Northrend Cup - Dragonblight Dragon Flight - Reverse Course'), +(22136, 'Northrend Cup - Crystalsong Crisis - Basic Course'), +(22137, 'Northrend Cup - Crystalsong Crisis - Advanced Course'), +(22138, 'Northrend Cup - Crystalsong Crisis - Reverse Course'), +(22086, 'Northrend Cup - Blackriver Burble - Basic Course'), +(22087, 'Northrend Cup - Blackriver Burble - Advanced Course'), +(22088, 'Northrend Cup - Blackriver Burble - Reverse Course'), +(22064, 'Northrend Cup - Scalawag Slither - Basic Course'), +(22067, 'Northrend Cup - Scalawag Slither - Advanced Course'), +(22068, 'Northrend Cup - Scalawag Slither - Reverse Course'), +(22074, 'Northrend Cup - Daggercap Dart - Basic Course'), +(22083, 'Northrend Cup - Daggercap Dart - Advanced Course'), +(22084, 'Northrend Cup - Daggercap Dart - Reverse Course'), +(22091, 'Northrend Cup - Zul''Drak Zephyr - Basic Course'), +(22092, 'Northrend Cup - Zul''Drak Zephyr - Advanced Course'), +(22093, 'Northrend Cup - Zul''Drak Zephyr - Reverse Course'), +(22506, 'Northrend Cup - Gundrak Fast Track - Basic Course'), +(22507, 'Northrend Cup - Gundrak Fast Track - Advanced Course'), +(22508, 'Northrend Cup - Gundrak Fast Track - Reverse Course'), +(22121, 'Northrend Cup - Makers'' Marathon - Basic Course'), +(22122, 'Northrend Cup - Makers'' Marathon - Advanced Course'), +(22123, 'Northrend Cup - Makers'' Marathon - Reverse Course'), +(22161, 'Northrend Cup - Citadel Sortie - Basic Course'), +(22162, 'Northrend Cup - Citadel Sortie - Advanced Course'), +(22163, 'Northrend Cup - Citadel Sortie - Reverse Course'), +(22172, 'Northrend Cup - Sholazar Spree - Basic Course'), +(22173, 'Northrend Cup - Sholazar Spree - Advanced Course'), +(22174, 'Northrend Cup - Sholazar Spree - Reverse Course'), +(22210, 'Northrend Cup - Geothermal Jaunt - Basic Course'), +(22211, 'Northrend Cup - Geothermal Jaunt - Advanced Course'), +(22212, 'Northrend Cup - Geothermal Jaunt - Reverse Course'), +(22519, 'Northrend Cup - Coldarra Climb - Basic Course'), +(22524, 'Northrend Cup - Coldarra Climb - Advanced Course'), +(22525, 'Northrend Cup - Coldarra Climb - Reverse Course'); -- cgit v1.2.3