DB/Graveyard: Graveyard of Kultiras and Zandalar

closes #23925 by @osleyder85

1 files changed, 110 insertions, 0 deletions

diff --git a/sql/updates/world/master/2021_03_29_00_world.sql b/sql/updates/world/master/2021_03_29_00_world.sql
new file mode 100644
index 00000000000..51b0bb67aa9
--- /dev/null
+++ b/sql/updates/world/master/2021_03_29_00_world.sql
@@ -0,0 +1,110 @@
+--
+DELETE FROM `graveyard_zone` WHERE `GhostZone` IN (8499, 8500, 8501, 8567, 8721, 9042);
+INSERT INTO `graveyard_zone` (`ID`, `GhostZone`, `Faction`, `Comment`) VALUES
+(6028, 8499, 0, 'Zuldazar - Warbeast Kraal GY'),
+(6029, 8499, 0, 'Zuldazar - Blood Gate GY'),
+(6050, 8499, 0, 'Zuldazar - Harbor GY'),
+(6199, 8499, 0, 'Zuldazar - Zanchul GY'),
+(6310, 8499, 0, 'Zuldazar - Shipyard GY - GJC'),
+(6324, 8499, 0, 'Zuldazar - Covescale GY'),
+(6327, 8499, 0, 'Zuldazar - Golden Road GY'),
+(6366, 8499, 0, 'Zuldazar - Garden of the Loa GY'),
+(6367, 8499, 0, 'Zuldazar - Scaletrader Post GY'),
+(6368, 8499, 0, 'Zuldazar - Nesingwary\'s Trek GY'),
+(6369, 8499, 0, 'Zuldazar - Zeb\'ahari GY'),
+(6370, 8499, 0, 'Zuldazar - Pyramid GY (Horde Only)'),
+(6440, 8499, 0, 'Zuldazar - Atal\'Gral GY'),
+(6650, 8499, 0, 'Zuldazar - Isle of Fangs GY'),
+(6903, 8499, 0, 'Zuldazar - Atal\'Dazar GY (\"The King\'s Gambit)'),
+(6905, 8499, 0, 'Zuldazar - Atal\'Dazar GY (\"The King\'s Gambit\" 01)'),
+(6922, 8499, 0, 'Zuldazar - Rootway Collapse GY'),
+(6927, 8499, 0, 'Zuldazar - Xibala GY'),
+
+(6463, 8500, 0, 'Nazmir, Dark Heart - South West - GY'),
+(6462, 8500, 0, 'Nazmir, Alliance East Hub (Alliance Only) - GY'),
+(6461, 8500, 0, 'Nazmir, Kra\'gwa\'s Shore (Naga Beach) - GY'),
+(6460, 8500, 0, 'Nazmir, Far Reach (Bronto Beach Necropolis) - GY'),
+(6458, 8500, 0, 'Nazmir, Shoaljai Tar Pits - GY'),
+(6456, 8500, 0, 'Nazmir, Plateau - GY'),
+(6455, 8500, 0, 'Nazmir, Alliance West Hub (Alliance Only) - GY'),
+(6339, 8500, 0, 'Nazmir, Necropolis - GY - LWB'),
+(6305, 8500, 0, 'Nazmir, Terrace of Sorrows - GY'),
+(6133, 8500, 0, 'Nazmir, Wayward Shoals - GY - LWB'),
+(6044, 8500, 0, 'Nazmir, DYNAMIC - Zone Intro - GY'),
+(6043, 8500, 0, 'Nazmir, Dark Heart - North - GY'),
+(6042, 8500, 0, 'Nazmir, Sunken Path  - GY'),
+(6041, 8500, 0, 'Nazmir, Dark Heart - East - GY'),
+(6039, 8500, 0, 'Nazmir, Gloom Hollow (Horde Only) - GY'),
+(6037, 8500, 0, 'Nazmir, Forlorn Ruins - GY'),
+(6036, 8500, 0, 'Nazmir, Torga\'s Rest - GY'),
+(6035, 8500, 0, 'Nazmir, Zo\'bal Ruins (Horde Only) - GY'),
+(6033, 8500, 0, 'Nazmir, Zul\'jan Hub (Horde Only) - GY'),
+
+(6547, 8501, 0, 'Vol\'dun, Shatterstone Harbor - GY'),
+(6540, 8501, 0, 'Vol\'dun, Brine Basin - GY'),
+(6539, 8501, 0, 'Vol\'dun, The Eternal Spring - GY'),
+(6538, 8501, 0, 'Vol\'dun, Tempest Canyon - GY'),
+(6537, 8501, 0, 'Vol\'dun, Pyramid NE - GY'),
+(6536, 8501, 0, 'Vol\'dun, Cracked Coast - GY'),
+(6535, 8501, 0, 'Vol\'dun, Oasis SW - GY'),
+(6534, 8501, 0, 'Vol\'dun, Terrace of the Devoted - GY'),
+(6533, 8501, 0, 'Vol\'dun, Court of Zak\'rajan - GY'),
+(6532, 8501, 0, 'Vol\'dun, Bouldered Bluffs - GY'),
+(6531, 8501, 0, 'Vol\'dun, Darkwood Shoal - GY'),
+(6530, 8501, 0, 'Vol\'dun, Spire - GY'),
+(6494, 8501, 0, 'Vol\'dun, Arena - GY'),
+(6424, 8501, 0, 'Vol\'dun, Temple of Sethraliss - GY'),
+(6040, 8501, 0, 'Vol\'dun, Eastern Zone Entrance - GY'),
+
+(6934, 8567, 0, '8.0 Tiragarde Sound - (20) Ski Slope Neutral'),
+(6945, 8567, 0, '8.0 Tiragarde Sound - (21) Wolf\'s Den'),
+(6933, 8567, 0, '8.0 Tiragarde Sound - (19) Waning Glacier Horde'),
+(6647, 8567, 0, '8.0 Tiragarde Sound - (18) Freehold_02'),
+(6498, 8567, 0, '8.0 Tiragarde Sound - (17) Southport Watch'),
+(6496, 8567, 0, '8.0 Tiragarde Sound - (02) Bridgeport'),
+(6495, 8567, 0, '8.0 Tiragarde Sound - (14) Fernwood Ridge'),
+(6493, 8567, 0, '8.0 Tiragarde Sound - (13) Westwind Weald'),
+(6492, 8567, 0, '8.0 Tiragarde Sound - (12) Roughneck Camp'),
+(6491, 8567, 0, '8.0 Tiragarde Sound - (11) Outrigger Post'),
+(6490, 8567, 0, '8.0 Tiragarde Sound - (10) Anglepoint Wharf'),
+(6489, 8567, 0, '8.0 Tiragarde Sound - (09) Norwington Estate'),
+(6477, 8567, 0, '8.0 Tiragarde Sound - (08) Kenning Lodge'),
+(6475, 8567, 0, '8.0 Tiragarde Sound - (07) Castaway POINT'),
+(6474, 8567, 0, '8.0 Tiragarde Sound - (06) Freehold'),
+(6471, 8567, 0, '8.0 Tiragarde Sound - (05) Fizzsprings Resort'),
+(6470, 8567, 0, '8.0 Tiragarde Sound - (04) Stagheart Cliffs'),
+(6469, 8567, 0, '8.0 Tiragarde Sound - (03) Vigil Hill'),
+(6466, 8567, 0, '8.0 Tiragarde Sound - (01) Hatherford'),
+
+(6561, 8721, 0, 'Drustvar - CarversHarborGY'),
+(6553, 8721, 0, 'Drustvar - GolOsgirMtnGY'),
+(6555, 8721, 0, 'Drustvar - TroggCaveGY'),
+(6549, 8721, 0, 'Drustvar - UpperCorlainGY'),
+(6528, 8721, 0, 'Drustvar - Watchman\'sPointGY'),
+(6513, 8721, 0, 'Drustvar - FalconhurstGY'),
+(6527, 8721, 0, 'Drustvar - ChapelGY'),
+(6511, 8721, 0, 'Drustvar - AromsStandGY'),
+(6510, 8721, 0, 'Drustvar - ForestCliffGY'),
+(6334, 8721, 0, 'Drustvar - FletchersGY'),
+(6333, 8721, 0, 'Drustvar - FallhavenGY'),
+(6332, 8721, 0, 'Drustvar - CemetaryGY'),
+
+(6372, 9042, 0, '8.0 Stormsong - Mariner\'s Wake GY - GJC'),
+(6447, 9042, 0, '8.0 Stormsong - East Brennadam GY - GJC'),
+(6481, 9042, 0, '8.0 Stormsong - Windswept Coast GY - GJC'),
+(6482, 9042, 0, '8.0 Stormsong - North Deadwood Wash GY - GJC'),
+(6483, 9042, 0, '8.0 Stormsong - Thresher\'s Wharf GY - GJC'),
+(6484, 9042, 0, '8.0 Stormsong - Hunting Lodge GY - GJC'),
+(6485, 9042, 0, '8.0 Stormsong - Stormsong Keep GY - GJC'),
+(6486, 9042, 0, '8.0 Stormsong - Shrine of the Storm GY - GJC'),
+(6487, 9042, 0, '8.0 Stormsong - Logjam GY - GJC'),
+(6488, 9042, 0, '8.0 Stormsong - Deadwood Reclamation GY - GJC'),
+(6504, 9042, 0, '8.0 Stormsong - Brennadam Square GY - AJB'),
+(6505, 9042, 0, '8.0 Stormsong - Collapsed FIELD GY - AJB'),
+(6506, 9042, 0, '8.0 Stormsong - Millstone Hamlet GY - CAG'),
+(6610, 9042, 0, '8.0 Stormsong - Highland Pass GY - GJC'),
+(6611, 9042, 0, '8.0 Stormsong - Honey Bee Farm GY - GJC'),
+(6626, 9042, 0, '8.0 Stormsong - Fort Daelin GY - CAG'),
+(6941, 9042, 0, '8.0 Stormsong - Shrine of the Storm UPPER GY - GJC'),
+(6942, 9042, 0, '8.0 Stormsong - Fate\'s End GY - SBV'),
+(6956, 9042, 0, '8.0 Stormsong - Forgotten Cove GY - GJC');