aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorSerpaa <Serpaa@users.noreply.github.com>2017-10-10 17:22:26 +0200
committerKillyana <morphone1@gmail.com>2017-10-10 17:22:26 +0200
commit11941c6fa785624f6c51705a3bd974f12ade9756 (patch)
treea2d7c09a38d386ad2ec54d1925c37a506d370032
parentef09ea484b492d8b1a38e7c6749e6e1c4a8cc0c4 (diff)
DB/Creature: Waypoint/Movement overhaul of Dawnstar Spire
Closes #20569
-rw-r--r--sql/updates/world/3.3.5/2017_10_10_02_world.sql92
1 files changed, 92 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2017_10_10_02_world.sql b/sql/updates/world/3.3.5/2017_10_10_02_world.sql
new file mode 100644
index 00000000000..0e6a88f3aa0
--- /dev/null
+++ b/sql/updates/world/3.3.5/2017_10_10_02_world.sql
@@ -0,0 +1,92 @@
+-- Dawnstart Spire overhaul
+SET @GUID_1 := 81865; -- Arcane Reaver #1
+SET @GUID_2 := 81867; -- Arcane Reaver #2
+SET @GUID_3 := 81869; -- Arcane Reaver #3
+SET @GUID_4 := 81860; -- Arcane Reaver #4
+SET @PATHID_1 := @GUID_1 * 10;
+SET @PATHID_2 := @GUID_2 * 10;
+SET @PATHID_3 := @GUID_3 * 10;
+SET @PATHID_4 := @GUID_4 * 10;
+
+UPDATE `creature` SET `spawndist`=0, `MovementType`=0 WHERE `guid` IN (81863, 81861, 81859, 81858);
+UPDATE `creature` SET `position_x`=7818.52, `position_y`=-7875.30, `position_z`=167.145, `orientation`=1.7218, `spawndist`=0, `MovementType`=0 WHERE `guid`=81938;
+UPDATE `creature` SET `position_x`=7830.56, `position_y`=-7877.31, `position_z`=169.147, `orientation`=4.6435, `spawndist`=0, `MovementType`=2 WHERE `guid`=@GUID_1;
+UPDATE `creature` SET `position_x`=7830.46, `position_y`=-7883.70, `position_z`=169.238, `orientation`=4.6435, `spawndist`=0, `MovementType`=2 WHERE `guid`=@GUID_2;
+UPDATE `creature` SET `position_x`=7788.29, `position_y`=-7866.93, `position_z`=167.249, `orientation`=1.6346, `spawndist`=0, `MovementType`=2 WHERE `guid`=@GUID_3;
+UPDATE `creature` SET `position_x`=7866.38, `position_y`=-7865.52, `position_z`=169.709, `orientation`=1.7868, `spawndist`=0, `MovementType`=2 WHERE `guid`=@GUID_4;
+
+DELETE FROM `creature` WHERE `guid` IN (81868, 81862);
+
+DELETE FROM `creature_addon` WHERE `guid` IN (@GUID_1, @GUID_2, @GUID_3, @GUID_4);
+INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES
+(@GUID_1, @PATHID_1, 4097),
+(@GUID_2, @PATHID_2, 4097),
+(@GUID_3, @PATHID_3, 4097),
+(@GUID_4, @PATHID_4, 4097);
+
+DELETE FROM `waypoint_data` WHERE `id` IN (@PATHID_1, @PATHID_2, @PATHID_3, @PATHID_4);
+INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`) VALUES
+(@PATHID_1, 1, 7830.25, -7906.69, 169.243),
+(@PATHID_1, 2, 7826.57, -7907.71, 169.240),
+(@PATHID_1, 3, 7824.40, -7911.16, 169.240),
+(@PATHID_1, 4, 7808.62, -7917.26, 169.244),
+(@PATHID_1, 5, 7812.92, -7927.34, 170.889),
+(@PATHID_1, 6, 7821.23, -7932.56, 173.071),
+(@PATHID_1, 7, 7830.24, -7934.47, 175.291),
+(@PATHID_1, 8, 7838.78, -7932.69, 177.055),
+(@PATHID_1, 9, 7847.03, -7928.16, 178.839),
+(@PATHID_1, 10, 7851.27, -7920.12, 180.428),
+(@PATHID_1, 11, 7854.10, -7911.47, 180.429),
+(@PATHID_1, 12, 7867.72, -7911.44, 180.715),
+(@PATHID_1, 13, 7878.59, -7911.82, 182.803),
+(@PATHID_1, 14, 7867.72, -7911.44, 180.715),
+(@PATHID_1, 15, 7854.10, -7911.47, 180.429),
+(@PATHID_1, 16, 7851.27, -7920.12, 180.428),
+(@PATHID_1, 17, 7847.03, -7928.16, 178.839),
+(@PATHID_1, 18, 7838.78, -7932.69, 177.055),
+(@PATHID_1, 19, 7830.24, -7934.47, 175.291),
+(@PATHID_1, 20, 7821.23, -7932.56, 173.071),
+(@PATHID_1, 21, 7812.92, -7927.34, 170.889),
+(@PATHID_1, 22, 7808.62, -7917.26, 169.244),
+(@PATHID_1, 23, 7824.40, -7911.16, 169.240),
+(@PATHID_1, 24, 7826.57, -7907.71, 169.240),
+(@PATHID_1, 25, 7830.25, -7906.69, 169.243),
+(@PATHID_1, 26, 7830.56, -7877.31, 169.147),
+(@PATHID_2, 1, 7830.90, -7842.99, 169.391),
+(@PATHID_2, 2, 7846.70, -7841.67, 170.134),
+(@PATHID_2, 3, 7846.84, -7824.87, 170.581),
+(@PATHID_2, 4, 7835.30, -7817.69, 170.466),
+(@PATHID_2, 5, 7800.81, -7815.93, 170.603),
+(@PATHID_2, 6, 7795.67, -7818.42, 170.734),
+(@PATHID_2, 7, 7794.67, -7834.75, 169.453),
+(@PATHID_2, 8, 7808.46, -7840.24, 168.951),
+(@PATHID_2, 9, 7821.20, -7833.64, 170.003),
+(@PATHID_2, 10, 7827.38, -7834.57, 170.058),
+(@PATHID_2, 11, 7830.90, -7842.99, 169.391),
+(@PATHID_2, 12, 7830.46, -7883.70, 169.238),
+(@PATHID_2, 13, 7830.90, -7842.99, 169.391),
+(@PATHID_2, 14, 7827.38, -7834.57, 170.058),
+(@PATHID_2, 15, 7821.20, -7833.64, 170.003),
+(@PATHID_2, 16, 7808.46, -7840.24, 168.951),
+(@PATHID_2, 17, 7794.67, -7834.75, 169.453),
+(@PATHID_2, 18, 7795.67, -7818.42, 170.734),
+(@PATHID_2, 19, 7800.81, -7815.93, 170.603),
+(@PATHID_2, 20, 7835.30, -7817.69, 170.466),
+(@PATHID_2, 21, 7846.84, -7824.87, 170.581),
+(@PATHID_2, 22, 7846.70, -7841.67, 170.134),
+(@PATHID_2, 23, 7830.90, -7842.99, 169.391),
+(@PATHID_2, 24, 7830.46, -7883.70, 169.238),
+(@PATHID_3, 1, 7785.77, -7833.79, 170.696),
+(@PATHID_3, 2, 7788.42, -7818.38, 171.033),
+(@PATHID_3, 3, 7785.77, -7833.79, 170.696),
+(@PATHID_3, 4, 7788.29, -7866.93, 167.249),
+(@PATHID_3, 5, 7791.01, -7896.47, 166.752),
+(@PATHID_3, 6, 7792.55, -7906.87, 167.080),
+(@PATHID_3, 7, 7791.01, -7896.47, 166.752),
+(@PATHID_3, 8, 7788.29, -7866.93, 167.249),
+(@PATHID_4, 1, 7857.40, -7825.82, 170.856),
+(@PATHID_4, 2, 7866.38, -7865.52, 169.704),
+(@PATHID_4, 3, 7870.51, -7891.75, 167.853),
+(@PATHID_4, 4, 7870.07, -7903.79, 167.394),
+(@PATHID_4, 5, 7870.51, -7891.75, 167.852),
+(@PATHID_4, 6, 7866.38, -7865.52, 169.703);