DB/Pathing: Stratholme - Hall of Light

(cherry picked from commit 8a6a5d32ff462a1732686d55d44929480c13d989)

1 files changed, 204 insertions, 0 deletions

diff --git a/sql/updates/world/2015_09_25_04_world_2015_08_13_02.sql b/sql/updates/world/2015_09_25_04_world_2015_08_13_02.sql
new file mode 100644
index 00000000000..e2863aea0f7
--- /dev/null
+++ b/sql/updates/world/2015_09_25_04_world_2015_08_13_02.sql
@@ -0,0 +1,204 @@
+-- Stratholme - Hall of Light
+-- 1.
+SET @NPC := 54085;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3616.438,`position_y`=-3097.423,`position_z`=134.3719 WHERE `guid`=@NPC;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=0,`position_x`=3616.438,`position_y`=-3097.423,`position_z`=134.3719 WHERE `guid`=54071;
+DELETE FROM `creature_addon` WHERE `guid`=@NPC;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,3616.438,-3097.423,134.3719,0,0,0,0,100,0),
+(@PATH,2,3614.938,-3098.173,134.3719,0,0,0,0,100,0),
+(@PATH,3,3612.438,-3099.173,134.3719,0,0,0,0,100,0),
+(@PATH,4,3606.938,-3101.423,134.3719,0,0,0,0,100,0),
+(@PATH,5,3606.734,-3101.405,134.6407,0,0,0,0,100,0),
+(@PATH,6,3604.484,-3102.155,134.6407,0,0,0,0,100,0),
+(@PATH,7,3600.234,-3096.655,134.6407,0,0,0,0,100,0),
+(@PATH,8,3598.984,-3095.155,135.8907,0,0,0,0,100,0),
+(@PATH,9,3598.234,-3094.155,135.8907,0,0,0,0,100,0),
+(@PATH,10,3595.816,-3091.076,135.9108,0,0,0,0,100,0),
+(@PATH,11,3587.79,-3079.112,135.9129,0,0,0,0,100,0),
+(@PATH,12,3587.842,-3079.453,135.662,0,0,0,0,100,0),
+(@PATH,13,3588.163,-3079.576,135.9112,0,0,0,0,100,0),
+(@PATH,14,3596.181,-3091.539,135.891,0,0,0,0,100,0),
+(@PATH,15,3598.431,-3094.289,135.891,0,0,0,0,100,0),
+(@PATH,16,3598.931,-3095.039,135.891,0,0,0,0,100,0),
+(@PATH,17,3599.931,-3096.539,134.891,0,0,0,0,100,0),
+(@PATH,18,3604.416,-3102.23,134.1847,0,0,0,0,100,0),
+(@PATH,19,3606.416,-3101.48,134.1847,0,0,0,0,100,0),
+(@PATH,20,3612.416,-3098.98,134.1847,0,0,0,0,100,0),
+(@PATH,21,3614.166,-3098.23,134.1847,0,0,0,0,100,0),
+(@PATH,22,3614.522,-3098.114,134.3642,0,0,0,0,100,0),
+(@PATH,23,3616.772,-3097.114,134.3642,0,0,0,0,100,0),
+(@PATH,24,3621.522,-3093.864,134.3642,0,0,0,0,100,0),
+(@PATH,25,3623.522,-3092.114,134.3642,0,0,0,0,100,0),
+(@PATH,26,3632.772,-3086.114,134.3642,0,0,0,0,100,0),
+(@PATH,27,3633.048,-3085.9,134.3664,0,0,0,0,100,0),
+(@PATH,28,3634.048,-3085.4,134.3664,0,0,0,0,100,0),
+(@PATH,29,3636.548,-3083.65,134.3664,0,0,0,0,100,0),
+(@PATH,30,3638.048,-3082.9,134.3664,0,0,0,0,100,0),
+(@PATH,31,3639.548,-3081.9,134.3664,0,0,0,0,100,0),
+(@PATH,32,3639.528,-3081.807,134.366,0,0,0,0,100,0),
+(@PATH,33,3638.028,-3082.807,134.366,0,0,0,0,100,0),
+(@PATH,34,3636.778,-3083.557,134.366,0,0,0,0,100,0);
+
+DELETE FROM `creature_formations` WHERE `leaderGUID`=54085;
+INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES 
+(54085, 54085, 0, 0, 2, 0, 0),
+(54085, 54071, 3, 0, 2, 0, 0);
+
+-- 2.
+SET @NPC := 52141;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3535.722,`position_y`=-3057.91,`position_z`=135.3322 WHERE `guid`=@NPC;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=0,`position_x`=3535.722,`position_y`=-3057.91,`position_z`=135.3322 WHERE `guid`=54169;
+DELETE FROM `creature_addon` WHERE `guid`=@NPC;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,3535.722,-3057.91,135.3322,0,0,0,0,100,0),
+(@PATH,2,3540.984,-3066.577,135.6673,0,0,0,0,100,0),
+(@PATH,3,3537.299,-3060.883,135.6673,0,0,0,0,100,0),
+(@PATH,4,3535.783,-3058.649,135.6673,0,0,0,0,100,0),
+(@PATH,5,3535.532,-3058.017,135.5822,0,0,0,0,100,0),
+(@PATH,6,3533.794,-3055.673,134.997,0,0,0,0,100,0),
+(@PATH,7,3529.241,-3048.929,134.997,0,0,0,0,100,0),
+(@PATH,8,3530.385,-3053.843,134.997,0,0,0,0,100,0),
+(@PATH,9,3529.099,-3054.688,135.247,0,0,0,0,100,0),
+(@PATH,10,3524.849,-3056.438,135.247,0,0,0,0,100,0),
+(@PATH,11,3524.898,-3057.071,135.247,0,0,0,0,100,0),
+(@PATH,12,3517.685,-3062.228,134.997,0,0,0,0,100,0),
+(@PATH,13,3515.195,-3063.973,134.997,0,0,0,0,100,0),
+(@PATH,14,3517.849,-3062.096,134.997,0,0,0,0,100,0),
+(@PATH,15,3512.628,-3065.658,135.247,0,0,0,0,100,0),
+(@PATH,16,3512.88,-3065.546,134.997,0,0,0,0,100,0),
+(@PATH,17,3512.397,-3065.865,135.247,0,0,0,0,100,0),
+(@PATH,18,3507.873,-3069.02,134.997,0,0,0,0,100,0),
+(@PATH,19,3501.293,-3073.773,134.997,0,0,0,0,100,0),
+(@PATH,20,3502.973,-3072.586,134.997,0,0,0,0,100,0),
+(@PATH,21,3500.175,-3074.654,135.247,0,0,0,0,100,0),
+(@PATH,22,3498.175,-3076.154,135.247,0,0,0,0,100,0),
+(@PATH,23,3498.078,-3076.195,134.997,0,0,0,0,100,0),
+(@PATH,24,3497.885,-3076.195,135.247,0,0,0,0,100,0),
+(@PATH,25,3496.635,-3077.195,135.247,0,0,0,0,100,0),
+(@PATH,26,3498.074,-3076.204,134.997,0,0,0,0,100,0),
+(@PATH,27,3500.452,-3074.542,135.247,0,0,0,0,100,0),
+(@PATH,28,3503.016,-3072.576,134.997,0,0,0,0,100,0),
+(@PATH,29,3509.555,-3067.772,134.997,0,0,0,0,100,0),
+(@PATH,30,3507.929,-3069.026,134.997,0,0,0,0,100,0),
+(@PATH,31,3512.387,-3065.935,135.247,0,0,0,0,100,0),
+(@PATH,32,3512.517,-3065.823,135.247,0,0,0,0,100,0),
+(@PATH,33,3519.535,-3060.917,134.997,0,0,0,0,100,0),
+(@PATH,34,3517.873,-3062.076,134.997,0,0,0,0,100,0),
+(@PATH,35,3524.547,-3057.446,134.997,0,0,0,0,100,0),
+(@PATH,36,3522.894,-3058.655,134.997,0,0,0,0,100,0),
+(@PATH,37,3525.393,-3056.905,135.247,0,0,0,0,100,0),
+(@PATH,38,3528.643,-3054.905,135.247,0,0,0,0,100,0),
+(@PATH,39,3527.923,-3055.323,134.997,0,0,0,0,100,0),
+(@PATH,40,3528.969,-3054.581,135.247,0,0,0,0,100,0),
+(@PATH,41,3532.499,-3054.48,134.997,0,0,0,0,100,0);
+
+DELETE FROM `creature_formations` WHERE `leaderGUID`=52141;
+INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES 
+(52141, 52141, 0, 0, 2, 0, 0),
+(52141, 54169, 3, 0, 2, 0, 0);
+
+-- 3.
+SET @NPC := 52144;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3443.406,`position_y`=-3083.562,`position_z`=135.0021 WHERE `guid`=@NPC;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=0,`position_x`=3443.406,`position_y`=-3083.562,`position_z`=135.0021 WHERE `guid`=54170;
+DELETE FROM `creature_addon` WHERE `guid`=@NPC;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,3443.406,-3083.562,135.0021,0,0,0,0,100,0),
+(@PATH,2,3438.447,-3078.663,135.5136,0,0,0,0,100,0),
+(@PATH,3,3438.595,-3078.601,135.0019,0,0,0,0,100,0),
+(@PATH,4,3442.701,-3082.71,135.0021,0,0,0,0,100,0),
+(@PATH,5,3444.575,-3084.654,135.0022,0,0,0,0,100,0),
+(@PATH,6,3445.956,-3083.634,135.0022,0,0,0,0,100,0),
+(@PATH,7,3446.778,-3083.367,135.2478,0,0,0,0,100,0),
+(@PATH,8,3449.778,-3082.867,135.2478,0,0,0,0,100,0),
+(@PATH,9,3449.807,-3082.485,135.2462,0,0,0,0,100,0),
+(@PATH,10,3457.698,-3077.302,134.9976,0,0,0,0,100,0),
+(@PATH,11,3455.978,-3078.373,134.9957,0,0,0,0,100,0),
+(@PATH,12,3458.637,-3076.211,135.2484,0,0,0,0,100,0),
+(@PATH,13,3460.387,-3075.211,135.2484,0,0,0,0,100,0),
+(@PATH,14,3460.28,-3075.071,135.2505,0,0,0,0,100,0),
+(@PATH,15,3465.067,-3071.659,135.2512,0,0,0,0,100,0),
+(@PATH,16,3465.241,-3071.764,135.2516,0,0,0,0,100,0),
+(@PATH,17,3472.513,-3066.586,135.0025,0,0,0,0,100,0),
+(@PATH,18,3470.79,-3067.797,135.0025,0,0,0,0,100,0),
+(@PATH,19,3474.771,-3064.983,135.2522,0,0,0,0,100,0),
+(@PATH,20,3474.693,-3065.094,135.2523,0,0,0,0,100,0),
+(@PATH,21,3482.48,-3059.7,135.0017,0,0,0,0,100,0),
+(@PATH,22,3480.787,-3060.873,135.0018,0,0,0,0,100,0),
+(@PATH,23,3478.327,-3062.577,135.002,0,0,0,0,100,0),
+(@PATH,24,3476.108,-3064.115,135.0021,0,0,0,0,100,0),
+(@PATH,25,3475.113,-3064.708,135.2523,0,0,0,0,100,0),
+(@PATH,26,3472.919,-3066.325,135.0025,0,0,0,0,100,0),
+(@PATH,27,3471.327,-3067.427,135.0025,0,0,0,0,100,0),
+(@PATH,28,3465.504,-3071.557,135.2518,0,0,0,0,100,0),
+(@PATH,29,3466.285,-3070.921,135.0025,0,0,0,0,100,0),
+(@PATH,30,3465.06,-3071.76,135.2514,0,0,0,0,100,0),
+(@PATH,31,3460.56,-3074.76,135.2514,0,0,0,0,100,0),
+(@PATH,32,3461.687,-3074.164,135.0022,0,0,0,0,100,0),
+(@PATH,33,3460.227,-3075.276,135.2483,0,0,0,0,100,0),
+(@PATH,34,3458.727,-3076.276,135.2483,0,0,0,0,100,0),
+(@PATH,35,3456.701,-3077.72,134.9965,0,0,0,0,100,0),
+(@PATH,36,3450.072,-3082.449,134.9891,0,0,0,0,100,0),
+(@PATH,37,3451.695,-3081.291,134.9909,0,0,0,0,100,0),
+(@PATH,38,3449.717,-3082.664,135.247,0,0,0,0,100,0),
+(@PATH,39,3447.467,-3084.164,135.247,0,0,0,0,100,0),
+(@PATH,40,3447.448,-3084.141,135.2488,0,0,0,0,100,0),
+(@PATH,41,3445.289,-3083.674,135.0022,0,0,0,0,100,0);
+
+DELETE FROM `creature_formations` WHERE `leaderGUID`=52144;
+INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES 
+(52144, 52144, 0, 0, 2, 0, 0),
+(52144, 54170, 3, 0, 2, 0, 0);
+
+-- 4.
+SET @NPC := 54205;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3581.3,`position_y`=-2994.275,`position_z`=125.25 WHERE `guid`=@NPC;
+DELETE FROM `creature_addon` WHERE `guid`=@NPC;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,3581.3,-2994.275,125.25,0,0,0,0,100,0),
+(@PATH,2,3582.05,-2995.275,125.25,0,0,0,0,100,0),
+(@PATH,3,3581.05,-2995.775,125.25,0,0,0,0,100,0),
+(@PATH,4,3575.3,-2999.775,125.25,0,0,0,0,100,0),
+(@PATH,5,3573.05,-3001.275,125.25,0,0,0,0,100,0),
+(@PATH,6,3571.8,-3002.025,125.25,0,0,0,0,100,0),
+(@PATH,7,3569.3,-3004.025,125.25,0,0,0,0,100,0),
+(@PATH,8,3565.3,-3006.775,125.25,0,0,0,0,100,0),
+(@PATH,9,3562.695,-3008.538,125.2498,0,0,0,0,100,0),
+(@PATH,10,3555.445,-3014.038,125.2498,0,0,0,0,100,0),
+(@PATH,11,3553.945,-3015.288,125.2498,0,0,0,0,100,0),
+(@PATH,12,3551.945,-3016.788,125.2498,0,0,0,0,100,0),
+(@PATH,13,3546.965,-3020.639,125.3795,0,0,0,0,100,0),
+(@PATH,14,3550.465,-3026.139,125.3795,0,0,0,0,100,0),
+(@PATH,15,3550.965,-3027.139,125.3795,0,0,0,0,100,0),
+(@PATH,16,3552.215,-3028.389,125.3795,0,0,0,0,100,0),
+(@PATH,17,3552.715,-3029.889,125.3795,0,0,0,0,100,0),
+(@PATH,18,3553.965,-3031.639,126.1295,0,0,0,0,100,0),
+(@PATH,19,3553.932,-3031.731,126.1293,0,0,0,0,100,0),
+(@PATH,20,3552.932,-3029.731,125.3793,0,0,0,0,100,0),
+(@PATH,21,3552.182,-3028.981,125.3793,0,0,0,0,100,0),
+(@PATH,22,3551.182,-3026.981,125.3793,0,0,0,0,100,0),
+(@PATH,23,3550.432,-3025.981,125.3793,0,0,0,0,100,0),
+(@PATH,24,3546.863,-3020.401,125.2494,0,0,0,0,100,0),
+(@PATH,25,3551.863,-3016.651,125.2494,0,0,0,0,100,0),
+(@PATH,26,3553.863,-3015.401,125.2494,0,0,0,0,100,0),
+(@PATH,27,3555.363,-3014.151,125.2494,0,0,0,0,100,0),
+(@PATH,28,3562.876,-3008.442,125.2495,0,0,0,0,100,0),
+(@PATH,29,3565.126,-3006.692,125.2495,0,0,0,0,100,0),
+(@PATH,30,3569.376,-3003.942,125.2495,0,0,0,0,100,0),
+(@PATH,31,3571.876,-3002.192,125.2495,0,0,0,0,100,0),
+(@PATH,32,3573.126,-3001.442,125.2495,0,0,0,0,100,0),
+(@PATH,33,3575.376,-2999.942,125.2495,0,0,0,0,100,0),
+(@PATH,34,3581.126,-2995.942,125.2495,0,0,0,0,100,0);