DB/Creature: Marauding Geist spawns

Waypoints and formations required

(cherry picked from commit 651aa72dfdf6164d2f512d3d330ca8023c4d5eed)

1 files changed, 29 insertions, 0 deletions

diff --git a/sql/updates/world/master/2020_07_17_20_world_2017_06_25_08_world.sql b/sql/updates/world/master/2020_07_17_20_world_2017_06_25_08_world.sql
new file mode 100644
index 00000000000..24445f37601
--- /dev/null
+++ b/sql/updates/world/master/2020_07_17_20_world_2017_06_25_08_world.sql
@@ -0,0 +1,29 @@
+-- 
+SET @guid:=134935;
+DELETE FROM `creature` WHERE `id` IN (30083);
+INSERT INTO `creature` (`guid`, `id`, `map`, `spawnDifficulties`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `curhealth`, `curmana`, `MovementType`) VALUES 
+(@guid+0, 30083, 533, '3,4', 0, 0, 0, 0, 0, 3410.94, -3084.66, 294.662, 2.42642, 7200, 0, 0,  0, 0),
+(@guid+1, 30083, 533, '3,4', 0, 0, 0, 0, 0, 3409.51, -3086.2, 294.662, 2.39107, 7200, 0, 0,   0, 0),
+(@guid+2, 30083, 533, '3,4', 0, 0, 0, 0, 0, 3410.88, -3087.48, 294.662, 2.39107, 7200, 0, 0,  0, 0),
+(@guid+3, 30083, 533, '3,4', 0, 0, 0, 0, 0, 3412.31, -3086.29, 294.662, 2.26934, 7200, 0, 0,  0, 0),
+(@guid+4, 30083, 533, '3,4', 0, 0, 0, 0, 0, 3414.18, -3084.71, 294.662, 2.27326, 7200, 0, 0,  0, 0),
+(@guid+5, 30083, 533, '3,4', 0, 0, 0, 0, 0, 3412.91, -3083.21, 294.662, 2.27326, 7200, 0, 0,  0, 0),
+(@guid+6, 30083, 533, '3,4', 0, 0, 0, 0, 0, 3411.25, -3081.24, 294.662, 2.27326, 7200, 0, 0,  0, 0),
+(@guid+7, 30083, 533, '3,4', 0, 0, 0, 0, 0, 3409.55, -3082.68, 294.662, 2.27326, 7200, 0, 0,  0, 0),
+(@guid+8, 30083, 533, '3,4', 0, 0, 0, 0, 0, 3407.67, -3084.26, 294.662, 2.26934, 7200, 0, 0,  0, 0),
+(@guid+9, 30083, 533, '3,4', 0, 0, 0, 0, 0, 3452.91, -3281.6, 267.594, 4.66245, 7200, 0, 0,   0, 0),
+(@guid+10, 30083, 533, '3,4', 0, 0, 0, 0, 0, 3453.04, -3278.97, 267.594, 4.66245, 7200, 0, 0, 0, 0),
+(@guid+11, 30083, 533, '3,4', 0, 0, 0, 0, 0, 3450.75, -3280.6, 267.594, 3.74353, 7200, 0, 0,  0, 0),
+(@guid+12, 30083, 533, '3,4', 0, 0, 0, 0, 0, 3451.24, -3284.51, 267.594, 5.49497, 7200, 0, 0, 0, 0),
+(@guid+13, 30083, 533, '3,4', 0, 0, 0, 0, 0, 3455.13, -3283.77, 267.594, 0.146405, 7200, 0,0, 0, 0),
+(@guid+14, 30083, 533, '3,4', 0, 0, 0, 0, 0, 3455.5, -3279.58, 267.594, 1.45409, 7200, 0, 0,  0, 0),
+(@guid+15, 30083, 533, '3,4', 0, 0, 0, 0, 0, 3450.28, -3277.25, 267.594, 2.73037, 7200, 0, 0, 0, 0),
+(@guid+16, 30083, 533, '3,4', 0, 0, 0, 0, 0, 3447.2, -3281.45, 267.594, 4.43075, 7200, 0, 0,  0, 0),
+(@guid+17, 30083, 533, '3,4', 0, 0, 0, 0, 0, 3163.76, -2984.34, 267.594, 3.11914, 7200, 0, 0, 0, 0),
+(@guid+18, 30083, 533, '3,4', 0, 0, 0, 0, 0, 3161.41, -2980.58, 267.594, 2.12953, 7200, 0, 0, 0, 0),
+(@guid+19, 30083, 533, '3,4', 0, 0, 0, 0, 0, 3159.66, -2984.66, 267.594, 4.30116, 7200, 0, 0, 0, 0),
+(@guid+20, 30083, 533, '3,4', 0, 0, 0, 0, 0, 3162.34, -2987.89, 267.594, 5.40464, 7200, 0, 0, 0, 0),
+(@guid+21, 30083, 533, '3,4', 0, 0, 0, 0, 0, 3166.4, -2986.91, 267.594, 0.181745, 7200, 0, 0, 0, 0),
+(@guid+22, 30083, 533, '3,4', 0, 0, 0, 0, 0, 3168.48, -2983.26, 267.594, 1.05354, 7200, 0, 0, 0, 0),
+(@guid+23, 30083, 533, '3,4', 0, 0, 0, 0, 0, 3164.23, -2990.77, 267.594, 4.14801, 7200, 0, 0, 0, 0),
+(@guid+24, 30083, 533, '3,4', 0, 0, 0, 0, 0, 3155.26, -2985.87, 267.594, 2.75393, 7200, 0, 0, 0, 0);