diff options
| -rw-r--r-- | sql/updates/world/2015_07_19_01_world_2015_07_15_01.sql | 399 |
1 files changed, 399 insertions, 0 deletions
diff --git a/sql/updates/world/2015_07_19_01_world_2015_07_15_01.sql b/sql/updates/world/2015_07_19_01_world_2015_07_15_01.sql new file mode 100644 index 00000000000..b9b7d92072a --- /dev/null +++ b/sql/updates/world/2015_07_19_01_world_2015_07_15_01.sql @@ -0,0 +1,399 @@ +-- Dragonblight Pathing - Moa'ki Harbor + Azure Dragonshrine + +-- 1. rndmmovement +UPDATE `creature` SET `spawndist`=20 WHERE `guid` IN (106644, 106699, 106698, 106714, 106736, 131071, 106695, 106720); + +-- 2. emotes +DELETE FROM `creature_addon` WHERE `guid` IN (109020, 109041); +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES +(109020,0,0,0,1,51, ''), +(109041,0,0,0,1,51, ''); + +-- 3. +SET @NPC := 106347; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3328.549,`position_y`=35.32029,`position_z`=68.77303 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,3328.549,35.32029,68.77303,0,0,0,0,100,0), +(@PATH,2,3328.281,35.21631,68.51276,0,0,0,0,100,0), +(@PATH,3,3328.231,35.3801,68.81226,0,0,0,0,100,0), +(@PATH,4,3326.481,39.1301,69.56226,0,0,0,0,100,0), +(@PATH,5,3324.981,42.3801,70.06226,0,0,0,0,100,0), +(@PATH,6,3323.481,44.8801,70.56226,0,0,0,0,100,0), +(@PATH,7,3323.24,45.35506,70.7541,0,0,0,0,100,0), +(@PATH,8,3322.99,45.85506,70.7541,0,0,0,0,100,0), +(@PATH,9,3321.24,48.35506,71.2541,0,0,0,0,100,0), +(@PATH,10,3321.963,47.37666,71.00128,0,0,0,0,100,0), +(@PATH,11,3322.048,47.26694,71.02554,0,0,0,0,100,0), +(@PATH,12,3323.298,45.51694,70.77554,0,0,0,0,100,0), +(@PATH,13,3324.798,42.01694,70.02554,0,0,0,0,100,0), +(@PATH,14,3326.298,39.51694,69.52554,0,0,0,0,100,0); + +-- 4. foxus warlock emotes +DELETE FROM `creature_addon` WHERE `guid` IN (114036, 114035, 114040, 114039, 114041, 114002, 114005, 114003, 113973, 113995, 114000, 113996, 113998, 114038, 113999); +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES +(114036,0,0,0,1,69, ''), +(114035,0,0,0,1,69, ''), +(114040,0,0,0,1,69, ''), +(114039,0,0,0,1,69, ''), +(114041,0,0,0,1,69, ''), +(114002,0,0,0,1,69, ''), +(114005,0,0,0,1,69, ''), +(114003,0,0,0,1,69, ''), +(113973,0,0,0,1,69, ''), +(113995,0,0,0,1,69, ''), +(114000,0,0,0,1,69, ''), +(113996,0,0,0,1,69, ''), +(113998,0,0,0,1,69, ''), +(114038,0,0,0,1,69, ''), +(113999,0,0,0,1,69, ''); + +-- 5. mage hunter emotes +DELETE FROM `creature_addon` WHERE `guid` IN (111759, 111757, 111756, 111758, 111760, 111761, 111802, 111801, 111800); +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES +(111759,0,0,0,1,27, ''), +(111757,0,0,0,1,27, ''), +(111756,0,0,0,1,27, ''), +(111758,0,0,0,1,27, ''), +(111760,0,0,0,1,27, ''), +(111761,0,0,0,1,27, ''), +(111802,0,0,0,1,27, ''), +(111801,0,0,0,1,27, ''), +(111800,0,0,0,1,27, ''); + +-- 6. Beefwps +SET @NPC := 111043; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3357.819,`position_y`=518.5552,`position_z`=78.31688 WHERE `guid`=@NPC; +UPDATE `creature` SET `spawndist`=0,`MovementType`=0,`position_x`=3357.819,`position_y`=518.5552,`position_z`=78.31688 WHERE `guid`=111211; +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,3357.819,518.5552,78.31688,0,0,0,0,100,0), +(@PATH,2,3364.319,524.5552,78.81688,0,0,0,0,100,0), +(@PATH,3,3368.569,528.3052,79.31688,0,0,0,0,100,0), +(@PATH,4,3375.445,534.399,79.33154,0,0,0,0,100,0), +(@PATH,5,3391.695,551.649,78.83154,0,0,0,0,100,0), +(@PATH,6,3395.945,555.899,78.08154,0,0,0,0,100,0), +(@PATH,7,3406.195,566.649,77.58154,0,0,0,0,100,0), +(@PATH,8,3407.308,568.47,77.32245,0,0,0,0,100,0), +(@PATH,9,3395.808,585.72,78.07245,0,0,0,0,100,0), +(@PATH,10,3393.808,588.97,78.32245,0,0,0,0,100,0), +(@PATH,11,3388.808,596.47,79.07245,0,0,0,0,100,0), +(@PATH,12,3384.558,603.22,79.57245,0,0,0,0,100,0), +(@PATH,13,3384.328,603.3331,79.72012,0,0,0,0,100,0), +(@PATH,14,3383.578,604.5831,79.97012,0,0,0,0,100,0), +(@PATH,15,3372.078,617.0831,80.47012,0,0,0,0,100,0), +(@PATH,16,3369.578,619.8331,80.97012,0,0,0,0,100,0), +(@PATH,17,3354.531,636.454,81.09949,0,0,0,0,100,0), +(@PATH,18,3352.031,648.204,81.84949,0,0,0,0,100,0), +(@PATH,19,3351.031,654.954,82.09949,0,0,0,0,100,0), +(@PATH,20,3347.781,671.454,82.84949,0,0,0,0,100,0), +(@PATH,21,3347.66,671.6125,82.84419,0,0,0,0,100,0), +(@PATH,22,3348.41,668.6125,82.09419,0,0,0,0,100,0), +(@PATH,23,3350.16,658.8625,82.59419,0,0,0,0,100,0), +(@PATH,24,3351.16,653.1125,82.09419,0,0,0,0,100,0), +(@PATH,25,3352.91,644.3625,81.59419,0,0,0,0,100,0), +(@PATH,26,3354.698,636.1382,80.88446,0,0,0,0,100,0), +(@PATH,27,3371.948,617.3882,80.38446,0,0,0,0,100,0), +(@PATH,28,3374.698,614.3882,79.88446,0,0,0,0,100,0), +(@PATH,29,3383.664,604.2737,79.74067,0,0,0,0,100,0), +(@PATH,30,3387.164,599.2737,79.24067,0,0,0,0,100,0), +(@PATH,31,3393.164,590.0237,78.49067,0,0,0,0,100,0), +(@PATH,32,3395.664,586.0237,77.99067,0,0,0,0,100,0), +(@PATH,33,3398.414,582.0237,77.49067,0,0,0,0,100,0), +(@PATH,34,3407.336,568.2035,77.34898,0,0,0,0,100,0), +(@PATH,35,3404.086,564.4535,78.09898,0,0,0,0,100,0), +(@PATH,36,3394.336,554.4535,78.59898,0,0,0,0,100,0), +(@PATH,37,3389.836,549.4535,79.09898,0,0,0,0,100,0), +(@PATH,38,3375.294,534.2694,79.25139,0,0,0,0,100,0), +(@PATH,39,3365.794,525.7694,78.75139,0,0,0,0,100,0), +(@PATH,40,3361.294,521.7694,78.25139,0,0,0,0,100,0), +(@PATH,41,3357.338,518.4061,78.19955,0,0,0,0,100,0), +(@PATH,42,3353.588,514.9061,78.94955,0,0,0,0,100,0), +(@PATH,43,3349.838,511.6561,79.44955,0,0,0,0,100,0), +(@PATH,44,3346.088,508.4061,80.19955,0,0,0,0,100,0), +(@PATH,45,3343.338,505.9061,80.69955,0,0,0,0,100,0), +(@PATH,46,3336.588,500.1561,81.19955,0,0,0,0,100,0), +(@PATH,47,3331.361,495.4106,81.15448,0,0,0,0,100,0), +(@PATH,48,3311.611,470.6606,80.40448,0,0,0,0,100,0), +(@PATH,49,3308.507,466.9263,79.84391,0,0,0,0,100,0), +(@PATH,50,3307.007,463.1763,79.34391,0,0,0,0,100,0), +(@PATH,51,3304.757,457.6763,78.59391,0,0,0,0,100,0), +(@PATH,52,3303.257,453.4263,78.09391,0,0,0,0,100,0), +(@PATH,53,3300.507,446.9263,77.59391,0,0,0,0,100,0), +(@PATH,54,3298.613,441.5379,76.93367,0,0,0,0,100,0), +(@PATH,55,3303.113,424.2879,77.43367,0,0,0,0,100,0), +(@PATH,56,3306.613,411.0379,76.93367,0,0,0,0,100,0), +(@PATH,57,3307.363,408.0379,76.18367,0,0,0,0,100,0), +(@PATH,58,3308.363,404.2879,75.93367,0,0,0,0,100,0), +(@PATH,59,3307.172,408.4494,76.61504,0,0,0,0,100,0), +(@PATH,60,3306.172,412.1994,77.36504,0,0,0,0,100,0), +(@PATH,61,3298.596,441.697,77.28619,0,0,0,0,100,0), +(@PATH,62,3301.596,449.197,77.78619,0,0,0,0,100,0), +(@PATH,63,3303.596,454.447,78.28619,0,0,0,0,100,0), +(@PATH,64,3305.346,459.197,78.78619,0,0,0,0,100,0), +(@PATH,65,3307.346,463.947,79.53619,0,0,0,0,100,0), +(@PATH,66,3308.805,467.3031,80.26054,0,0,0,0,100,0), +(@PATH,67,3312.055,471.0531,80.76054,0,0,0,0,100,0), +(@PATH,68,3318.305,479.0531,81.26054,0,0,0,0,100,0); + +DELETE FROM `creature_formations` WHERE `leaderGUID`=111043; +INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(111043, 111043, 0, 0, 2, 0, 0), +(111043, 111211, 7, 0, 0, 0, 0); + +-- 7. casting emotes gnomes +DELETE FROM `creature_addon` WHERE `guid` IN (109040, 109039); +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES +(109040,0,0,0,1,51, ''), +(109039,0,0,0,1,51, ''); + +-- 8. Attackemotes for hunter + warlocks (all 3 caves) +DELETE FROM `creature_addon` WHERE `guid` IN (111789, 111827, 114030, 111796, 111811, 111813, 114029, 111834, 114069, 111812, 114049, 111750, 113966, 111768, 111766, 114010, 111770, 114008, 111769, 111767, 114009, 111734, 111779, 114020, 111776, 111774, 111775, 111747, 111754, 111755, 111753, 113951, 113968, 113969, 113964, 111717, 113967, 111735, 113970, 111728, 113940, 113965, 114006, 111727, 111743, 111763, 111764); +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES +(111789, 0,0,0,1,27, ''), +(111827, 0,0,0,1,27, ''), +(114030, 0,0,0,1,27, ''), +(111796, 0,0,0,1,27, ''), +(111811, 0,0,0,1,27, ''), +(111813, 0,0,0,1,27, ''), +(114029, 0,0,0,1,27, ''), +(111834, 0,0,0,1,27, ''), +(114069, 0,0,0,1,27, ''), +(111812, 0,0,0,1,27, ''), +(114049, 0,0,0,1,27, ''), +(111750, 0,0,0,1,27, ''), +(113966, 0,0,0,1,27, ''), +(111768, 0,0,0,1,27, ''), +(111766, 0,0,0,1,27, ''), +(114010, 0,0,0,1,27, ''), +(111770, 0,0,0,1,27, ''), +(114008, 0,0,0,1,27, ''), +(111769, 0,0,0,1,27, ''), +(111767, 0,0,0,1,27, ''), +(114009, 0,0,0,1,27, ''), +(111734, 0,0,0,1,27, ''), +(111779, 0,0,0,1,27, ''), +(114020, 0,0,0,1,27, ''), +(111776, 0,0,0,1,27, ''), +(111774, 0,0,0,1,27, ''), +(111775, 0,0,0,1,27, ''), +(111747, 0,0,0,1,27, ''), +(111754, 0,0,0,1,27, ''), +(111755, 0,0,0,1,27, ''), +(111753, 0,0,0,1,27, ''), +(113951, 0,0,0,1,27, ''), +(113968, 0,0,0,1,27, ''), +(113969, 0,0,0,1,27, ''), +(113964, 0,0,0,1,27, ''), +(111717, 0,0,0,1,27, ''), +(113967, 0,0,0,1,27, ''), +(111735, 0,0,0,1,27, ''), +(113970, 0,0,0,1,27, ''), +(111728, 0,0,0,1,27, ''), +(113940, 0,0,0,1,27, ''), +(113965, 0,0,0,1,27, ''), +(114006, 0,0,0,1,27, ''), +(111727, 0,0,0,1,27, ''), +(111743, 0,0,0,1,27, ''), +(111763, 0,0,0,1,27, ''), +(111764,0,0,0,1,27, ''); + +-- 9. Moa'ki Warrior +SET @NPC := 99801; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=2942.45,`position_y`=874.4968,`position_z`=35.30196 WHERE `guid`=@NPC; +UPDATE `creature` SET `spawndist`=0,`MovementType`=0,`position_x`=2942.45,`position_y`=874.4968,`position_z`=35.30196 WHERE `guid`=99802; +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,2942.45,874.4968,35.30196,0,0,0,0,100,0), +(@PATH,2,2940.95,874.7468,35.05196,0,0,0,0,100,0), +(@PATH,3,2938.95,874.4968,34.55196,0,0,0,0,100,0), +(@PATH,4,2935.95,873.9968,33.55196,0,0,0,0,100,0), +(@PATH,5,2934.2,873.7468,33.05196,0,0,0,0,100,0), +(@PATH,6,2932.45,873.4968,32.55196,0,0,0,0,100,0), +(@PATH,7,2929.45,873.2468,31.80196,0,0,0,0,100,0), +(@PATH,8,2926.45,872.9968,31.05196,0,0,0,0,100,0), +(@PATH,9,2923.45,872.4968,30.05196,0,0,0,0,100,0), +(@PATH,10,2923.197,872.4724,29.89659,0,0,0,0,100,0), +(@PATH,11,2921.197,872.2224,29.39659,0,0,0,0,100,0), +(@PATH,12,2919.197,871.7224,28.89659,0,0,0,0,100,0), +(@PATH,13,2916.447,870.9724,28.14659,0,0,0,0,100,0), +(@PATH,14,2914.447,870.4724,27.39659,0,0,0,0,100,0), +(@PATH,15,2910.697,869.9724,26.89659,0,0,0,0,100,0), +(@PATH,16,2907.697,869.2224,26.14659,0,0,0,0,100,0), +(@PATH,17,2904.947,868.4724,25.64659,0,0,0,0,100,0), +(@PATH,18,2902.995,868.2098,24.81467,0,0,0,0,100,0), +(@PATH,19,2899.995,868.9598,24.31467,0,0,0,0,100,0), +(@PATH,20,2896.245,869.9598,23.56467,0,0,0,0,100,0), +(@PATH,21,2893.495,870.7098,23.06467,0,0,0,0,100,0), +(@PATH,22,2890.495,871.4598,22.56467,0,0,0,0,100,0), +(@PATH,23,2885.745,872.7098,21.81467,0,0,0,0,100,0), +(@PATH,24,2885.609,872.7776,21.46217,0,0,0,0,100,0), +(@PATH,25,2884.109,873.2776,21.21217,0,0,0,0,100,0), +(@PATH,26,2880.109,873.2776,20.71217,0,0,0,0,100,0), +(@PATH,27,2873.359,873.2776,20.21217,0,0,0,0,100,0), +(@PATH,28,2868.175,873.5178,19.47064,0,0,0,0,100,0), +(@PATH,29,2860.175,880.7678,18.97064,0,0,0,0,100,0), +(@PATH,30,2857.271,883.4542,18.24871,0,0,0,0,100,0), +(@PATH,31,2851.021,886.2042,17.74871,0,0,0,0,100,0), +(@PATH,32,2843.771,889.4542,17.24871,0,0,0,0,100,0), +(@PATH,33,2843.393,889.6986,17.05721,0,0,0,0,100,0), +(@PATH,34,2842.643,889.9486,17.05721,0,0,0,0,100,0), +(@PATH,35,2836.893,892.1986,16.30721,0,0,0,0,100,0), +(@PATH,36,2829.259,895.6682,16.03611,0,0,0,0,100,0), +(@PATH,37,2826.259,899.6682,16.78611,0,0,0,0,100,0), +(@PATH,38,2824.759,901.9182,17.28611,0,0,0,0,100,0), +(@PATH,39,2823.009,904.1682,18.03611,0,0,0,0,100,0), +(@PATH,40,2820.759,907.4182,18.78611,0,0,0,0,100,0), +(@PATH,41,2818.548,910.2606,19.6723,0,0,0,0,100,0), +(@PATH,42,2815.048,912.5106,20.1723,0,0,0,0,100,0), +(@PATH,43,2811.798,914.5106,20.4223,0,0,0,0,100,0), +(@PATH,44,2807.798,917.0106,21.1723,0,0,0,0,100,0), +(@PATH,45,2804.548,919.2606,21.9223,0,0,0,0,100,0), +(@PATH,46,2804.113,919.4464,22.19062,0,0,0,0,100,0), +(@PATH,47,2802.863,920.4464,22.19062,0,0,0,0,100,0), +(@PATH,48,2802.113,936.1964,22.69062,0,0,0,0,100,0), +(@PATH,49,2801.614,942.2058,22.90605,0,0,0,0,100,0), +(@PATH,50,2794.46,955.9167,22.82833,0,0,0,0,100,0), +(@PATH,51,2789.868,969.0771,22.71787,0,0,0,0,100,0), +(@PATH,52,2789.86,968.7522,22.44791,0,0,0,0,100,0), +(@PATH,53,2790.052,968.7579,22.57249,0,0,0,0,100,0), +(@PATH,54,2794.692,955.4985,22.95527,0,0,0,0,100,0), +(@PATH,55,2801.604,942.0818,22.84189,0,0,0,0,100,0), +(@PATH,56,2802.354,929.3318,22.34189,0,0,0,0,100,0), +(@PATH,57,2803.029,920.1268,22.10619,0,0,0,0,100,0), +(@PATH,58,2807.279,917.3768,21.60619,0,0,0,0,100,0), +(@PATH,59,2809.779,916.1268,20.85619,0,0,0,0,100,0), +(@PATH,60,2813.779,913.3768,20.35619,0,0,0,0,100,0), +(@PATH,61,2817.029,911.3768,19.85619,0,0,0,0,100,0), +(@PATH,62,2817.245,910.9927,19.40564,0,0,0,0,100,0), +(@PATH,63,2818.745,909.9927,19.40564,0,0,0,0,100,0), +(@PATH,64,2820.995,906.7427,18.40564,0,0,0,0,100,0), +(@PATH,65,2823.245,903.7427,17.65564,0,0,0,0,100,0), +(@PATH,66,2825.495,900.7427,17.15564,0,0,0,0,100,0), +(@PATH,67,2827.245,898.2427,16.65564,0,0,0,0,100,0), +(@PATH,68,2827.63,897.9916,16.59999,0,0,0,0,100,0), +(@PATH,69,2829.38,895.2416,16.09999,0,0,0,0,100,0), +(@PATH,70,2839.38,891.2416,16.59999,0,0,0,0,100,0), +(@PATH,71,2842.658,889.7286,17.27651,0,0,0,0,100,0), +(@PATH,72,2849.908,886.7286,17.52651,0,0,0,0,100,0), +(@PATH,73,2855.408,884.2286,18.27651,0,0,0,0,100,0), +(@PATH,74,2857.304,883.3358,18.64834,0,0,0,0,100,0), +(@PATH,75,2861.054,879.8358,18.89834,0,0,0,0,100,0), +(@PATH,76,2868.077,873.4034,19.59505,0,0,0,0,100,0), +(@PATH,77,2874.077,873.4034,20.09505,0,0,0,0,100,0), +(@PATH,78,2879.827,873.4034,20.59505,0,0,0,0,100,0), +(@PATH,79,2884.046,873.29,21.49246,0,0,0,0,100,0), +(@PATH,80,2888.046,872.04,22.24246,0,0,0,0,100,0), +(@PATH,81,2892.546,870.79,22.74246,0,0,0,0,100,0), +(@PATH,82,2895.546,870.29,23.24246,0,0,0,0,100,0), +(@PATH,83,2898.296,869.54,23.99246,0,0,0,0,100,0), +(@PATH,84,2901.296,868.54,24.49246,0,0,0,0,100,0), +(@PATH,85,2901.368,868.5389,24.78852,0,0,0,0,100,0), +(@PATH,86,2903.118,868.0389,25.03852,0,0,0,0,100,0), +(@PATH,87,2906.118,868.7889,25.53852,0,0,0,0,100,0), +(@PATH,88,2908.868,869.5389,26.28852,0,0,0,0,100,0), +(@PATH,89,2911.618,870.2889,26.78852,0,0,0,0,100,0), +(@PATH,90,2915.618,870.7889,27.53852,0,0,0,0,100,0), +(@PATH,91,2917.618,871.2889,28.28852,0,0,0,0,100,0), +(@PATH,92,2920.368,872.0389,29.03852,0,0,0,0,100,0), +(@PATH,93,2920.589,872.1874,29.30408,0,0,0,0,100,0), +(@PATH,94,2921.339,872.4374,29.55408,0,0,0,0,100,0), +(@PATH,95,2924.339,872.6874,30.55408,0,0,0,0,100,0), +(@PATH,96,2927.339,873.1874,31.30408,0,0,0,0,100,0), +(@PATH,97,2930.089,873.1874,31.80408,0,0,0,0,100,0), +(@PATH,98,2933.089,873.6874,32.80408,0,0,0,0,100,0), +(@PATH,99,2935.089,873.9374,33.30408,0,0,0,0,100,0), +(@PATH,100,2937.089,874.1874,34.05408,0,0,0,0,100,0), +(@PATH,101,2940.089,874.6874,34.80408,0,0,0,0,100,0), +(@PATH,102,2940.357,874.6572,35.2282,0,0,0,0,100,0), +(@PATH,103,2941.357,874.6572,35.4782,0,0,0,0,100,0), +(@PATH,104,2944.357,874.4072,36.2282,0,0,0,0,100,0), +(@PATH,105,2947.357,874.1572,36.7282,0,0,0,0,100,0), +(@PATH,106,2949.107,873.9072,37.4782,0,0,0,0,100,0), +(@PATH,107,2953.107,873.9072,38.2282,0,0,0,0,100,0), +(@PATH,108,2955.857,873.6572,38.9782,0,0,0,0,100,0), +(@PATH,109,2953.459,873.7681,38.4597,0,0,0,0,100,0); + +DELETE FROM `creature_formations` WHERE `leaderGUID`=99801; +INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(99801, 99801, 0, 0, 2, 0, 0), +(99801, 99802, 3, 90, 2, 0, 0); +UPDATE `smart_scripts` SET `action_param1`=1 WHERE `entryorguid`=27178 AND `source_type`=0 AND `id`=0 AND `link`=1; + +-- 10. Moa'ki Warrior +SET @NPC := 99815; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=2734.04,`position_y`=908.0725,`position_z`=3.249194 WHERE `guid`=@NPC; +UPDATE `creature` SET `spawndist`=0,`MovementType`=0,`position_x`=2734.04,`position_y`=908.0725,`position_z`=3.249194 WHERE `guid`=99814; +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,2734.04,908.0725,3.249194,0,0,0,0,100,0), +(@PATH,2,2736.54,905.0725,3.749194,0,0,0,0,100,0), +(@PATH,3,2739.04,901.8225,4.249194,0,0,0,0,100,0), +(@PATH,4,2740.54,899.8225,4.749194,0,0,0,0,100,0), +(@PATH,5,2743.79,895.8225,5.249194,0,0,0,0,100,0), +(@PATH,6,2746.789,892.0921,5.316426,0,0,0,0,100,0), +(@PATH,7,2765.288,879.248,5.514341,0,0,0,0,100,0), +(@PATH,8,2788.071,876.0192,5.926539,0,0,0,0,100,0), +(@PATH,9,2796.821,876.0192,6.676539,0,0,0,0,100,0), +(@PATH,10,2802.821,876.0192,6.926539,0,0,0,0,100,0), +(@PATH,11,2806.821,875.7692,7.676539,0,0,0,0,100,0), +(@PATH,12,2806.909,875.7591,7.908364,0,0,0,0,100,0), +(@PATH,13,2807.659,875.7591,8.158364,0,0,0,0,100,0), +(@PATH,14,2810.159,877.7591,8.658364,0,0,0,0,100,0), +(@PATH,15,2812.159,879.5091,9.158364,0,0,0,0,100,0), +(@PATH,16,2813.909,880.5091,9.908364,0,0,0,0,100,0), +(@PATH,17,2816.159,882.2591,10.65836,0,0,0,0,100,0), +(@PATH,18,2817.659,883.5091,11.40836,0,0,0,0,100,0), +(@PATH,19,2816.375,882.6917,10.97033,0,0,0,0,100,0), +(@PATH,20,2818.125,883.9417,11.72033,0,0,0,0,100,0), +(@PATH,21,2818.875,884.6917,11.72033,0,0,0,0,100,0), +(@PATH,22,2820.375,885.9417,12.72033,0,0,0,0,100,0), +(@PATH,23,2821.375,887.4417,12.97033,0,0,0,0,100,0), +(@PATH,24,2822.875,888.6917,13.72033,0,0,0,0,100,0), +(@PATH,25,2824.125,890.1917,14.47033,0,0,0,0,100,0), +(@PATH,26,2825.375,891.6917,15.22033,0,0,0,0,100,0), +(@PATH,27,2824.66,890.6411,14.79578,0,0,0,0,100,0), +(@PATH,28,2823.16,889.3911,14.04578,0,0,0,0,100,0), +(@PATH,29,2821.41,887.3911,13.29578,0,0,0,0,100,0), +(@PATH,30,2818.638,884.2707,11.69823,0,0,0,0,100,0), +(@PATH,31,2816.388,882.5207,10.69823,0,0,0,0,100,0), +(@PATH,32,2813.888,880.7707,9.948226,0,0,0,0,100,0), +(@PATH,33,2812.638,879.5207,9.448226,0,0,0,0,100,0), +(@PATH,34,2810.388,877.7707,8.698226,0,0,0,0,100,0), +(@PATH,35,2807.556,875.8849,7.826558,0,0,0,0,100,0), +(@PATH,36,2803.556,876.1349,7.076558,0,0,0,0,100,0), +(@PATH,37,2798.556,876.1349,6.826558,0,0,0,0,100,0), +(@PATH,38,2790.806,876.3849,6.076558,0,0,0,0,100,0), +(@PATH,39,2790.671,876.3419,5.86481,0,0,0,0,100,0), +(@PATH,40,2787.671,876.3419,5.86481,0,0,0,0,100,0), +(@PATH,41,2764.954,879.5082,5.60566,0,0,0,0,100,0), +(@PATH,42,2746.52,892.532,5.507929,0,0,0,0,100,0), +(@PATH,43,2741.77,898.782,4.757929,0,0,0,0,100,0), +(@PATH,44,2739.27,901.532,4.257929,0,0,0,0,100,0), +(@PATH,45,2736.77,904.782,3.757929,0,0,0,0,100,0), +(@PATH,46,2734.27,907.782,3.257929,0,0,0,0,100,0), +(@PATH,47,2733.933,908.0688,3.006025,0,0,0,0,100,0), +(@PATH,48,2733.683,908.3188,3.006025,0,0,0,0,100,0), +(@PATH,49,2732.933,911.3188,2.256025,0,0,0,0,100,0), +(@PATH,50,2732.183,914.3188,1.756025,0,0,0,0,100,0), +(@PATH,51,2731.183,918.8188,1.256025,0,0,0,0,100,0), +(@PATH,52,2728.75,928.4617,0.6681505,0,0,0,0,100,0), +(@PATH,53,2731.75,918.9617,1.418151,0,0,0,0,100,0), +(@PATH,54,2732.5,915.2117,1.668151,0,0,0,0,100,0); + +DELETE FROM `creature_formations` WHERE `leaderGUID`=99815; +INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(99815, 99815, 0, 0, 2, 0, 0), +(99815, 99814, 3, 90, 2, 0, 0); |