DB/graveyard: add graveyard zones to map 870

- Jade Forest
- Valley of the Four Winds
- Vale of Eternal Blossoms
- Kun-Lai Summit
- Townlong Steppes
- Krasarang Wilds
- Dread Wastes
- Timeless Isle
- Isle of Giants

Closes #14160

1 files changed, 118 insertions, 0 deletions

diff --git a/sql/updates/world/master/2016_12_11_01_world.sql b/sql/updates/world/master/2016_12_11_01_world.sql
new file mode 100644
index 00000000000..c3e490a4eaf
--- /dev/null
+++ b/sql/updates/world/master/2016_12_11_01_world.sql
@@ -0,0 +1,118 @@
+-- Graveyard zones map 870
+DELETE FROM `graveyard_zone` WHERE `GhostZone` IN (5785,5805,5840,5841,5842,6134,6138,6757,6661);
+INSERT INTO `graveyard_zone` (`ID`,`GhostZone`,`Faction`,`Comment`) VALUES
+
+-- Jade Forest GY
+(3168, 5785, 469, "The Jade Forest, Alliance GY"),
+(3568, 5785, 0, "The Jade Forest, Arboretum GY 90+"),
+(3566, 5785, 0, "The Jade Forest, Cliff Village GY"),
+(4150, 5785, 0, "The Jade Forest, Cliff Village GY"),
+(4371, 5785, 0, "The Jade Forest, Cliff Village GY"),
+(3567, 5785, 0, "The Jade Forest, Dawnblossom GY"),
+(3565, 5785, 0, "The Jade Forest, East Temple GY"),
+(4298, 5785, 0, "The Jade Forest, East Temple GY"),
+(3572, 5785, 0, "The Jade Forest, Fishing Village GY"),
+(3564, 5785, 0, "The Jade Forest, Fox Grove GY"),
+(3170, 5785, 67, "The Jade Forest, Horde GY"),
+(4391, 5785, 67, "The Jade Forest, Horde GY"),
+(4402, 5785, 67, "The Jade Forest, Horde GY"),
+(3571, 5785, 0, "The Jade Forest, Mogu Ruins GY"),
+(3569, 5785, 0, "The Jade Forest, Spire of Solitude GY"),
+(3560, 5785, 0, "The Jade Forest, Swamp GY East"),
+(3570, 5785, 0, "The Jade Forest, Training Temple GY"),
+
+-- Valley of the Four Winds GY
+(3253, 5805, 0, "Valley of the Four Winds, Temp GY"),
+(4098, 5805, 0, "Valley of the Four Winds, Fruited Fields GY"),
+(4099, 5805, 0, "Valley of the Four Winds, Stoneplow Fields GY"),
+(4100, 5805, 0, "Valley of the Four Winds, Thirsty Alley GY"),
+(4105, 5805, 0, "Valley of the Four Winds, Zhu Province GY"),
+(4147, 5805, 0, "Valley of the Four Winds, Zhu Province GY"),
+(4148, 5805, 0, "Valley of the Four Winds, Zhu Province GY"),
+(4149, 5805, 0, "Valley of the Four Winds, Zhu Province GY"),
+(4369, 5805, 0, "Valley of the Four Winds, Skyrange GY 2"),
+(4370, 5805, 0, "Valley of the Four Winds, Skyrange GY 1"),
+(4389, 5805, 0, "Valley of the Four Winds, Zhu Province GY"),
+
+-- Vale of Eternal Blossoms GY
+(4052, 5840, 0, "Vale of Eternal Blossoms, Temp GY"),
+(4276, 5840, 469, "Vale of Eternal Blossoms - Alliance GY"),
+(4277, 5840, 67, "Vale of Eternal Blossoms - Horde GY"),
+(4278, 5840, 0, "Vale of Eternal Blossoms - Guo-Lai GY"),
+(4279, 5840, 0, "Vale of Eternal Blossoms - Guo-Lai 02 GY"),
+(4280, 5840, 0, "Vale of Eternal Blossoms - Great Wall GY"),
+(4281, 5840, 0, "Vale of Eternal Blossoms - Mistfall Village GY"),
+(4356, 5840, 0, "Vale of Eternal Blossoms - Great Wall GY"),
+(4407, 5840, 0, "Vale of Eternal Blossoms - Ancestral Rise GY"),
+(4575, 5840, 0, "Vale of Eternal Blossoms - Vale Raid GY"),
+
+-- Kun-Lai Summit GY
+(3573, 5841, 0, "Kun-Lai Summit - Binan Village GY"),
+(3574, 5841, 0, "Kun-Lai Summit - Northern Temple GY"),
+(3575, 5841, 0, "Kun-Lai Summit - Northern Balloon Village GY"),
+(3576, 5841, 0, "Kun-Lai Summit - Troll Village GY"),
+(3578, 5841, 0, "Kun-Lai Summit - Mountain Valley GY"),
+(3579, 5841, 0, "Kun-Lai Summit - Monkaris GY"),
+(3580, 5841, 0, "Kun-Lai Summit - Top of the World GY"),
+(3581, 5841, 0, "Kun-Lai Summit - Shadowpan Hideout GY"),
+(3582, 5841, 0, "Kun-Lai Summit - West Mountain Valley GY"),
+(3583, 5841, 0, "Kun-Lai Summit - Shadowpan Battleground GY"),
+(3590, 5841, 0, "Kun-Lai Summit - Alliance/Horde GY"),
+(3591, 5841, 0, "Kun-Lai Summit - West Fishing Village GY"),
+(3593, 5841, 0, "Kun-Lai Summit - Valley of the Kings GY"),
+(4270, 5841, 0, "Kun-Lai Summit - Valley of the Kings GY"),
+(4396, 5841, 0, "Kun-Lai Summit - Great Wall GY - Western Span"),
+(4397, 5841, 0, "Kun-Lai Summit - Great Wall GY - Middle Span"),
+(4399, 5841, 0, "Kun-Lai Summit - Great Wall GY - Eastern Span"),
+(4401, 5841, 0, "Kun-Lai Summit - West Mountain Valley GY"),
+
+-- Townlong Steppes GY
+(4095, 5842, 0, "Townlong Steppes, Temp GY"),
+(4106, 5842, 0, "Townlong Steppes, Osul Mesa GY"),
+(4325, 5842, 0, "Townlong Steppes, Osul Mesa GY"),
+(4326, 5842, 0, "Townlong Steppes, Osul Mesa GY"),
+(4327, 5842, 0, "Townlong Steppes, Osul Mesa GY"),
+(4328, 5842, 0, "Townlong Steppes, Osul Mesa GY"),
+(4337, 5842, 0, "Townlong Steppes, Osul Mesa GY"),
+(4357, 5842, 0, "Townlong Steppes, Osul Mesa GY"),
+(4380, 5842, 0, "Townlong Steppes, Osul Mesa GY"),
+(4381, 5842, 0, "Townlong Steppes, Osul Mesa GY"),
+(4383, 5842, 0, "Townlong Steppes, Osul Mesa GY"),
+(4387, 5842, 0, "Townlong Steppes, Osul Mesa GY"),
+
+-- Krasarang Wilds GY
+(4101, 6134, 0, "Krasarang Wilds - Kea Krak GY"),
+(4102, 6134, 0, "Krasarang Wilds - The Deepwild GY"),
+(4103, 6134, 0, "Krasarang Wilds - Dojani River GY"),
+(4104, 6134, 0, "Krasarang Wilds - The Forbidden Junlge"),
+(4408, 6134, 0, "Krasarang Wilds - Narsong Spire - Beach GY"),
+(4443, 6134, 0, "Krasarang Wilds - Kea Krak GY"),
+-- Krasarang Wilds TSGY missing
+
+-- Dread Wastes GY
+(4107, 6138, 0, "Dread Wastes, Dread Wastes GY"),
+(4299, 6138, 0, "Dread Wastes, Dread Wastes GY"),
+(4300, 6138, 0, "Dread Wastes, Dread Wastes GY"),
+(4301, 6138, 0, "Dread Wastes, Dread Wastes GY"),
+(4302, 6138, 0, "Dread Wastes, Dread Wastes GY"),
+(4303, 6138, 0, "Dread Wastes, Dread Wastes GY"),
+(4304, 6138, 0, "Dread Wastes, Dread Wastes GY"),
+(4305, 6138, 0, "Dread Wastes, Dread Wastes GY"),
+(4390, 6138, 0, "Dread Wastes, Dread Wastes GY"),
+(4405, 6138, 0, "Dread Wastes, Dread Wastes - Amber Hibernal Teleport Pad"),
+
+-- Timeless Isle GY
+(4558, 6757, 469, "Timeless Isle - Alliance Landing gy"),
+(4559, 6757, 67, "Timeless Isle - Horde Landing gy"),
+(4622, 6757, 0, "Timeless Isle - Grotto gy"),
+(4623, 6757, 0, "Timeless Isle - Ordon Sanc GY"),
+(4629, 6757, 0, "Timeless Isle - Three-Breeze/Misty Strand"),
+(4630, 6757, 0, "Timeless Isle - Pi'jiu GY"),
+(4631, 6757, 0, "Timeless Isle - Celestial Court GY"),
+(4632, 6757, 0, "Timeless Isle - Celestial Court GY 2"),
+(4633, 6757, 0, "Timeless Isle - Firewalker Ruins GY"),
+(4634, 6757, 0, "Timeless Isle - Firewalker's Path Lower"),
+(4635, 6757, 0, "Timeless Isle - Firewalker's Path Upper"),
+
+-- Isle of Giants GY
+(4469, 6661, 0, "Isle of Giants - Graveyard");