aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorModoX <moardox@gmail.com>2024-05-12 05:50:11 +0200
committerModoX <moardox@gmail.com>2024-05-12 05:50:11 +0200
commit7b0d2eb39e7f2b0295b1d40b70b8d757c20f5d72 (patch)
tree64d230a56e628e86834b06032fc0782cb0775cae
parentb8a79c89431ec44e76164de26f318b7f927779eb (diff)
DB/Phases: Added Northrend Cup phase names
-rw-r--r--sql/updates/world/master/2024_05_12_03_world.sql39
1 files changed, 39 insertions, 0 deletions
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');