DB/Phase: Added phase names for Kalimdor Cup phases

1 files changed, 52 insertions, 0 deletions

diff --git a/sql/updates/world/master/2023_08_25_00_world.sql b/sql/updates/world/master/2023_08_25_00_world.sql
new file mode 100644
index 00000000000..176f3058fb8
--- /dev/null
+++ b/sql/updates/world/master/2023_08_25_00_world.sql
@@ -0,0 +1,52 @@
+DELETE FROM `phase_name` WHERE `ID` IN(20700, 20705, 20706, 20684, 26685, 26686, 20800, 20801, 20802, 20688, 20689, 20690, 20693, 20694, 20695, 20679, 20681, 20682, 20708, 20709, 20710, 20722, 20723, 20724, 20727, 20728, 20729, 20806, 20807, 20808, 20810, 20812, 20813, 20815, 20817, 20818, 20820, 20822, 20823, 20752, 20753, 20754, 20734, 20735, 20736, 20717, 20718, 20719, 20677, 20816);
+INSERT INTO `phase_name` (`ID`, `Name`) VALUES
+(20700, 'Kalimdor Cup - Rocketway Ride - Normal Course'),
+(20705, 'Kalimdor Cup - Rocketway Ride - Advanced Course'),
+(20706, 'Kalimdor Cup - Rocketway Ride - Reverse Course'),
+(20684, 'Kalimdor Cup - Winter Wander - Normal Course'),
+(26685, 'Kalimdor Cup - Winter Wander - Advanced Course'),
+(26686, 'Kalimdor Cup - Winter Wander - Reverse Course'),
+(20800, 'Kalimdor Cup - Thousand Needles Thread - Normal Course'),
+(20801, 'Kalimdor Cup - Thousand Needles Thread - Advanced Course'),
+(20802, 'Kalimdor Cup - Thousand Needles Thread - Reverse Course'),
+(20688, 'Kalimdor Cup - Nordrassil Spiral - Normal Course'),
+(20689, 'Kalimdor Cup - Nordrassil Spiral - Advanced Course'),
+(20690, 'Kalimdor Cup - Nordrassil Spiral - Reverse Course'),
+(20693, 'Kalimdor Cup - Hyjal Hotfoot - Normal Course'),
+(20694, 'Kalimdor Cup - Hyjal Hotfoot - Advanced Course'),
+(20695, 'Kalimdor Cup - Hyjal Hotfoot - Reverse Course'),
+(20679, 'Kalimdor Cup - Felwood Flyover - Normal Course'),
+(20681, 'Kalimdor Cup - Felwood Flyover - Advanced Course'),
+(20682, 'Kalimdor Cup - Felwood Flyover - Reverse Course'),
+(20708, 'Kalimdor Cup - Ashenvale Ambit - Normal Course'),
+(20709, 'Kalimdor Cup - Ashenvale Ambit - Advanced Course'),
+(20710, 'Kalimdor Cup - Ashenvale Ambit - Reverse Course'),
+(20722, 'Kalimdor Cup - Webwinder Weave - Normal Course'),
+(20723, 'Kalimdor Cup - Webwinder Weave - Advanced Course'),
+(20724, 'Kalimdor Cup - Webwinder Weave - Reverse Course'),
+(20727, 'Kalimdor Cup - Desolace Drift - Normal Course'),
+(20728, 'Kalimdor Cup - Desolace Drift - Advanced Course'),
+(20729, 'Kalimdor Cup - Desolace Drift - Reverse Course'),
+(20806, 'Kalimdor Cup - Feralas Ruins Ramble - Normal Course'),
+(20807, 'Kalimdor Cup - Feralas Ruins Ramble - Advanced Course'),
+(20808, 'Kalimdor Cup - Feralas Ruins Ramble - Reverse Course'),
+(20810, 'Kalimdor Cup - Ahn''Qiraj Circuit - Normal Course'),
+(20812, 'Kalimdor Cup - Ahn''Qiraj Circuit - Advanced Course'),
+(20813, 'Kalimdor Cup - Ahn''Qiraj Circuit - Reverse Course'),
+(20815, 'Kalimdor Cup - Uldum Tour - Normal Course'),
+(20817, 'Kalimdor Cup - Uldum Tour - Advanced Course'),
+(20818, 'Kalimdor Cup - Uldum Tour - Reverse Course'),
+(20820, 'Kalimdor Cup - Ungoro Crater Circuit - Normal Course'),
+(20822, 'Kalimdor Cup - Ungoro Crater Circuit - Advanced Course'),
+(20823, 'Kalimdor Cup - Ungoro Crater Circuit - Reverse Course'),
+(20752, 'Kalimdor Cup - Razorfen Roundabout - Normal Course'),
+(20753, 'Kalimdor Cup - Razorfen Roundabout - Advanced Course'),
+(20754, 'Kalimdor Cup - Razorfen Roundabout - Reverse Course'),
+(20734, 'Kalimdor Cup - Great Divide Dive - Normal Course'),
+(20735, 'Kalimdor Cup - Great Divide Dive - Advanced Course'),
+(20736, 'Kalimdor Cup - Great Divide Dive - Reverse Course'),
+(20717, 'Kalimdor Cup - Durotar Tour - Normal Course'),
+(20718, 'Kalimdor Cup - Durotar Tour - Advanced Course'),
+(20719, 'Kalimdor Cup - Durotar Tour - Reverse Course'),
+(20677, 'Kalimdor Cup - Kalimdor - Bronze Dragons for Race?'),
+(20816, 'Kalimdor Cup - Uldum Cataclysm - Bronze Dragons for Race?');