diff options
| -rw-r--r-- | sql/updates/world/2015_05_24_04_world.sql | 902 |
1 files changed, 902 insertions, 0 deletions
diff --git a/sql/updates/world/2015_05_24_04_world.sql b/sql/updates/world/2015_05_24_04_world.sql new file mode 100644 index 00000000000..70cc65fb490 --- /dev/null +++ b/sql/updates/world/2015_05_24_04_world.sql @@ -0,0 +1,902 @@ +-- Complete Grizzlyhills Movement +DELETE FROM `creature_addon` WHERE `guid` IN (109382, 109390,109409,110794, 110792,110787,110793, 110791,110797,110796,110795,110799,110798, 110801,98066, 98056, 98060, 118835, 98047, 98059, 98053); +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES +(118835,0,0,1,1,0, ''), +(98047,0,0,1,1,0, ''), +(98059,0,0,0,1,69, ''), +(98060,0,0,0,1,234, ''), +(98053,0,0,0,1,1, ''), +(98056,0,0,0,1,234, ''), +(98066,0,0,0,1,234, ''), +(110801,0,0,0,1,234, ''), +(110798,0,0,0,1,234, ''), +(110799,0,0,0,1,234, ''), +(110795,0,0,0,1,234, ''), +(110796,0,0,0,1,234, ''), +(110797,0,0,0,1,234, ''), +(110791,0,0,0,1,234, ''), +(110793,0,0,0,1,234, ''), +(110787,0,0,0,1,234, ''), +(110792,0,0,0,1,234, ''), +(110794,0,0,0,1,234, ''), +(109409,0,0,8,1,0, ''), +(109390,0,0,8,1,0, ''), +(109382,0,0,8,1,0, ''); + +SET @NPC := 109402; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4642.88,`position_y`=-5573.969,`position_z`=43.38401 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,4642.88,-5573.969,43.38401,0,0,0,0,100,0), +(@PATH,2,4642.38,-5575.719,43.63401,0,0,0,0,100,0), +(@PATH,3,4639.13,-5580.469,42.88401,0,0,0,0,100,0), +(@PATH,4,4637.13,-5583.719,41.63401,0,0,0,0,100,0), +(@PATH,5,4635.38,-5586.219,40.38401,0,0,0,0,100,0), +(@PATH,6,4635.204,-5586.526,40.13166,0,0,0,0,100,0), +(@PATH,7,4634.204,-5587.776,39.63166,0,0,0,0,100,0), +(@PATH,8,4633.204,-5587.776,38.88166,0,0,0,0,100,0), +(@PATH,9,4632.204,-5588.026,38.13166,0,0,0,0,100,0), +(@PATH,10,4631.204,-5588.026,37.63166,0,0,0,0,100,0), +(@PATH,11,4630.204,-5588.026,36.88166,0,0,0,0,100,0), +(@PATH,12,4629.204,-5588.026,36.38166,0,0,0,0,100,0), +(@PATH,13,4628.204,-5588.026,35.63166,0,0,0,0,100,0), +(@PATH,14,4626.204,-5588.026,35.13166,0,0,0,0,100,0), +(@PATH,15,4625.204,-5588.026,34.38166,0,0,0,0,100,0), +(@PATH,16,4624.204,-5588.026,33.88166,0,0,0,0,100,0), +(@PATH,17,4623.454,-5588.026,33.38166,0,0,0,0,100,0), +(@PATH,18,4622.454,-5588.276,32.88166,0,0,0,0,100,0), +(@PATH,19,4621.454,-5588.276,32.13166,0,0,0,0,100,0), +(@PATH,20,4620.454,-5588.276,31.63166,0,0,0,0,100,0), +(@PATH,21,4618.454,-5588.276,30.38166,0,0,0,0,100,0), +(@PATH,22,4616.454,-5588.276,29.63166,0,0,0,0,100,0), +(@PATH,23,4615.454,-5588.276,28.88166,0,0,0,0,100,0), +(@PATH,24,4613.454,-5588.276,27.88166,0,0,0,0,100,0), +(@PATH,25,4615.112,-5588.271,28.6151,0,0,0,0,100,0), +(@PATH,26,4613.112,-5588.271,27.6151,0,0,0,0,100,0), +(@PATH,27,4612.612,-5588.271,27.3651,0,0,0,0,100,0), +(@PATH,28,4609.862,-5587.021,25.8651,0,0,0,0,100,0), +(@PATH,29,4608.112,-5586.021,24.8651,0,0,0,0,100,0), +(@PATH,30,4606.362,-5585.021,24.1151,0,0,0,0,100,0), +(@PATH,31,4604.612,-5584.021,22.8651,0,0,0,0,100,0), +(@PATH,32,4602.862,-5583.021,21.6151,0,0,0,0,100,0), +(@PATH,33,4601.112,-5582.021,20.8651,0,0,0,0,100,0), +(@PATH,34,4599.362,-5581.021,19.3651,0,0,0,0,100,0), +(@PATH,35,4597.612,-5580.021,18.3651,0,0,0,0,100,0), +(@PATH,36,4595.362,-5578.521,16.8651,0,0,0,0,100,0), +(@PATH,37,4593.612,-5577.771,15.6151,0,0,0,0,100,0), +(@PATH,38,4591.862,-5576.771,14.6151,0,0,0,0,100,0), +(@PATH,39,4590.112,-5575.771,13.8651,0,0,0,0,100,0), +(@PATH,40,4588.362,-5574.771,13.1151,0,0,0,0,100,0), +(@PATH,41,4586.612,-5573.771,12.1151,0,0,0,0,100,0), +(@PATH,42,4584.862,-5572.771,11.6151,0,0,0,0,100,0), +(@PATH,43,4583.112,-5571.771,10.8651,0,0,0,0,100,0), +(@PATH,44,4580.612,-5570.271,10.1151,0,0,0,0,100,0), +(@PATH,45,4578.862,-5569.271,9.365101,0,0,0,0,100,0), +(@PATH,46,4578.588,-5569.066,9.268532,0,0,0,0,100,0), +(@PATH,47,4577.088,-5568.316,8.768532,0,0,0,0,100,0), +(@PATH,48,4575.838,-5565.566,7.768532,0,0,0,0,100,0), +(@PATH,49,4575.338,-5563.816,7.018532,0,0,0,0,100,0), +(@PATH,50,4574.588,-5562.066,6.518532,0,0,0,0,100,0), +(@PATH,51,4573.588,-5560.316,5.768532,0,0,0,0,100,0), +(@PATH,52,4572.338,-5557.566,5.018532,0,0,0,0,100,0), +(@PATH,53,4572.302,-5557.273,4.829211,0,0,0,0,100,0), +(@PATH,54,4571.052,-5554.523,4.079211,0,0,0,0,100,0), +(@PATH,55,4570.302,-5551.523,3.579211,0,0,0,0,100,0), +(@PATH,56,4569.302,-5544.773,3.079211,0,0,0,0,100,0), +(@PATH,57,4565.425,-5523.652,2.546694,0,0,0,0,100,0), +(@PATH,58,4558.431,-5505.637,2.508454,0,0,0,0,100,0), +(@PATH,59,4558.492,-5505.963,2.279056,0,0,0,0,100,0), +(@PATH,60,4558.656,-5505.855,2.526844,0,0,0,0,100,0), +(@PATH,61,4565.748,-5523.84,2.603909,0,0,0,0,100,0), +(@PATH,62,4569.748,-5548.34,3.103909,0,0,0,0,100,0), +(@PATH,63,4570.498,-5552.09,3.603909,0,0,0,0,100,0), +(@PATH,64,4571.125,-5554.945,4.307666,0,0,0,0,100,0), +(@PATH,65,4572.375,-5557.695,5.057666,0,0,0,0,100,0), +(@PATH,66,4573.375,-5559.445,5.807666,0,0,0,0,100,0), +(@PATH,67,4574.375,-5561.945,6.307666,0,0,0,0,100,0), +(@PATH,68,4575.125,-5563.695,7.057666,0,0,0,0,100,0), +(@PATH,69,4575.875,-5565.445,7.807666,0,0,0,0,100,0), +(@PATH,70,4577.315,-5568.442,8.979671,0,0,0,0,100,0), +(@PATH,71,4580.065,-5569.942,9.979671,0,0,0,0,100,0), +(@PATH,72,4581.815,-5570.942,10.72967,0,0,0,0,100,0), +(@PATH,73,4584.315,-5572.442,11.47967,0,0,0,0,100,0), +(@PATH,74,4586.065,-5573.442,12.22967,0,0,0,0,100,0), +(@PATH,75,4587.815,-5574.442,12.97967,0,0,0,0,100,0), +(@PATH,76,4589.565,-5575.442,13.72967,0,0,0,0,100,0), +(@PATH,77,4591.315,-5576.442,14.72967,0,0,0,0,100,0), +(@PATH,78,4593.065,-5577.442,15.72967,0,0,0,0,100,0), +(@PATH,79,4594.565,-5578.192,16.47967,0,0,0,0,100,0), +(@PATH,80,4596.315,-5579.192,17.47967,0,0,0,0,100,0), +(@PATH,81,4598.065,-5580.192,18.72967,0,0,0,0,100,0), +(@PATH,82,4599.815,-5581.192,19.72967,0,0,0,0,100,0), +(@PATH,83,4601.565,-5582.192,20.97967,0,0,0,0,100,0), +(@PATH,84,4603.315,-5583.192,21.97967,0,0,0,0,100,0), +(@PATH,85,4605.065,-5583.942,22.72967,0,0,0,0,100,0), +(@PATH,86,4606.815,-5584.942,24.22967,0,0,0,0,100,0), +(@PATH,87,4609.315,-5586.442,25.47967,0,0,0,0,100,0), +(@PATH,88,4611.065,-5587.442,26.72967,0,0,0,0,100,0), +(@PATH,89,4611.174,-5587.652,26.94344,0,0,0,0,100,0), +(@PATH,90,4612.674,-5588.402,27.69344,0,0,0,0,100,0), +(@PATH,91,4615.674,-5588.402,28.94344,0,0,0,0,100,0), +(@PATH,92,4616.674,-5588.402,29.69344,0,0,0,0,100,0), +(@PATH,93,4618.674,-5588.152,30.44344,0,0,0,0,100,0), +(@PATH,94,4619.674,-5588.152,31.19344,0,0,0,0,100,0), +(@PATH,95,4621.674,-5588.152,32.19344,0,0,0,0,100,0), +(@PATH,96,4622.424,-5588.152,32.94344,0,0,0,0,100,0), +(@PATH,97,4623.424,-5588.152,33.19344,0,0,0,0,100,0), +(@PATH,98,4624.424,-5588.152,33.94344,0,0,0,0,100,0), +(@PATH,99,4625.424,-5588.152,34.44344,0,0,0,0,100,0), +(@PATH,100,4626.424,-5588.152,35.19344,0,0,0,0,100,0), +(@PATH,101,4627.424,-5588.152,35.69344,0,0,0,0,100,0), +(@PATH,102,4628.424,-5588.152,36.44344,0,0,0,0,100,0), +(@PATH,103,4629.424,-5587.902,36.94344,0,0,0,0,100,0), +(@PATH,104,4630.424,-5587.902,37.69344,0,0,0,0,100,0), +(@PATH,105,4631.424,-5587.902,38.19344,0,0,0,0,100,0), +(@PATH,106,4632.424,-5587.902,38.94344,0,0,0,0,100,0), +(@PATH,107,4633.424,-5587.902,39.44344,0,0,0,0,100,0), +(@PATH,108,4632.743,-5587.937,39.25474,0,0,0,0,100,0), +(@PATH,109,4633.743,-5587.937,39.75474,0,0,0,0,100,0), +(@PATH,110,4634.243,-5587.937,40.00474,0,0,0,0,100,0), +(@PATH,111,4635.993,-5585.437,40.75474,0,0,0,0,100,0), +(@PATH,112,4636.993,-5583.687,41.50474,0,0,0,0,100,0), +(@PATH,113,4638.493,-5581.437,42.25474,0,0,0,0,100,0), +(@PATH,114,4640.743,-5578.187,43.50474,0,0,0,0,100,0), +(@PATH,115,4641.032,-5577.918,43.48087,0,0,0,0,100,0), +(@PATH,116,4642.532,-5575.418,43.48087,0,0,0,0,100,0), +(@PATH,117,4643.532,-5572.418,42.98087,0,0,0,0,100,0), +(@PATH,118,4644.032,-5570.668,42.23087,0,0,0,0,100,0), +(@PATH,119,4644.532,-5567.668,41.23087,0,0,0,0,100,0), +(@PATH,120,4645.032,-5565.668,40.23087,0,0,0,0,100,0), +(@PATH,121,4645.532,-5564.168,38.98087,0,0,0,0,100,0), +(@PATH,122,4646.032,-5562.168,37.98087,0,0,0,0,100,0), +(@PATH,123,4646.532,-5560.168,36.98087,0,0,0,0,100,0), +(@PATH,124,4647.032,-5558.168,35.98087,0,0,0,0,100,0), +(@PATH,125,4647.782,-5555.418,35.23087,0,0,0,0,100,0), +(@PATH,126,4648.282,-5553.418,34.48087,0,0,0,0,100,0), +(@PATH,127,4648.611,-5553.267,34.28629,0,0,0,0,100,0), +(@PATH,128,4648.861,-5552.517,33.78629,0,0,0,0,100,0), +(@PATH,129,4649.361,-5550.767,33.03629,0,0,0,0,100,0), +(@PATH,130,4650.361,-5547.767,32.28629,0,0,0,0,100,0), +(@PATH,131,4651.111,-5546.017,31.78629,0,0,0,0,100,0), +(@PATH,132,4651.611,-5544.267,31.28629,0,0,0,0,100,0), +(@PATH,133,4652.111,-5542.517,30.78629,0,0,0,0,100,0), +(@PATH,134,4653.611,-5538.767,30.03629,0,0,0,0,100,0), +(@PATH,135,4654.861,-5534.767,29.53629,0,0,0,0,100,0), +(@PATH,136,4655.176,-5534.61,29.14608,0,0,0,0,100,0), +(@PATH,137,4655.426,-5533.86,29.14608,0,0,0,0,100,0), +(@PATH,138,4658.176,-5528.61,28.39608,0,0,0,0,100,0), +(@PATH,139,4661.176,-5522.61,28.14608,0,0,0,0,100,0), +(@PATH,140,4663.296,-5518.52,27.41638,0,0,0,0,100,0), +(@PATH,141,4666.796,-5515.52,26.66638,0,0,0,0,100,0), +(@PATH,142,4667.602,-5514.735,26.7351,0,0,0,0,100,0), +(@PATH,143,4664.102,-5517.985,27.2351,0,0,0,0,100,0), +(@PATH,144,4663.71,-5518.2,27.46549,0,0,0,0,100,0), +(@PATH,145,4663.21,-5518.7,27.71549,0,0,0,0,100,0), +(@PATH,146,4660.71,-5523.2,27.96549,0,0,0,0,100,0), +(@PATH,147,4657.71,-5529.2,28.71549,0,0,0,0,100,0), +(@PATH,148,4655.082,-5533.99,29.53152,0,0,0,0,100,0), +(@PATH,149,4653.332,-5538.74,30.03152,0,0,0,0,100,0), +(@PATH,150,4652.332,-5542.49,30.78152,0,0,0,0,100,0), +(@PATH,151,4651.832,-5544.24,31.28152,0,0,0,0,100,0), +(@PATH,152,4651.082,-5546.24,31.78152,0,0,0,0,100,0), +(@PATH,153,4650.332,-5547.99,32.28152,0,0,0,0,100,0), +(@PATH,154,4649.832,-5549.99,33.03152,0,0,0,0,100,0), +(@PATH,155,4648.461,-5552.834,34.08023,0,0,0,0,100,0), +(@PATH,156,4647.961,-5554.834,34.83023,0,0,0,0,100,0), +(@PATH,157,4647.461,-5556.584,35.58023,0,0,0,0,100,0), +(@PATH,158,4646.961,-5558.584,36.58023,0,0,0,0,100,0), +(@PATH,159,4646.461,-5560.584,37.58023,0,0,0,0,100,0), +(@PATH,160,4645.711,-5563.334,38.33023,0,0,0,0,100,0), +(@PATH,161,4645.461,-5565.084,39.58023,0,0,0,0,100,0), +(@PATH,162,4644.961,-5567.084,40.83023,0,0,0,0,100,0), +(@PATH,163,4644.461,-5569.084,41.83023,0,0,0,0,100,0), +(@PATH,164,4643.961,-5570.834,42.58023,0,0,0,0,100,0), +(@PATH,165,4642.961,-5573.834,43.33023,0,0,0,0,100,0), +(@PATH,166,4642.868,-5574.016,43.39613,0,0,0,0,100,0), +(@PATH,167,4642.368,-5575.766,43.64613,0,0,0,0,100,0), +(@PATH,168,4639.118,-5580.516,42.89613,0,0,0,0,100,0), +(@PATH,169,4637.118,-5583.766,41.64613,0,0,0,0,100,0), +(@PATH,170,4635.368,-5586.266,40.39613,0,0,0,0,100,0); + +SET @NPC := 110474; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4974.067,`position_y`=-4702.151,`position_z`=211.6858 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,4974.067,-4702.151,211.6858,0,0,0,0,100,0), +(@PATH,2,4973.567,-4694.401,211.6858,0,0,0,0,100,0), +(@PATH,3,4972.317,-4684.151,211.6858,0,0,0,0,100,0), +(@PATH,4,4972.449,-4684.032,211.6815,0,0,0,0,100,0), +(@PATH,5,4972.199,-4683.032,211.6815,0,0,0,0,100,0), +(@PATH,6,4972.073,-4683.314,211.4305,0,0,0,0,100,0), +(@PATH,7,4972.434,-4683.377,211.6818,0,0,0,0,100,0), +(@PATH,8,4973.184,-4694.377,211.6818,0,0,0,0,100,0), +(@PATH,9,4974.222,-4702.475,211.6772,0,0,0,0,100,0), +(@PATH,10,4976.222,-4706.975,211.6772,0,0,0,0,100,0), +(@PATH,11,4979.872,-4716.739,211.652,0,0,0,0,100,0), +(@PATH,12,4979.707,-4716.649,211.4221,0,0,0,0,100,0), +(@PATH,13,4979.64,-4716.295,211.6743,0,0,0,0,100,0), +(@PATH,14,4976.14,-4707.045,211.6743,0,0,0,0,100,0); + +SET @NPC := 110473; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4971.524,`position_y`=-4651.398,`position_z`=211.6646 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,4971.524,-4651.398,211.6646,0,0,0,0,100,0), +(@PATH,2,4971.524,-4650.148,211.6646,0,0,0,0,100,0), +(@PATH,3,4971.274,-4642.898,211.6646,0,0,0,0,100,0), +(@PATH,4,4971.195,-4642.912,211.4312,0,0,0,0,100,0), +(@PATH,5,4971.593,-4650.481,211.6812,0,0,0,0,100,0), +(@PATH,6,4971.843,-4651.481,211.6812,0,0,0,0,100,0), +(@PATH,7,4972.093,-4657.231,211.6812,0,0,0,0,100,0), +(@PATH,8,4972.093,-4659.231,211.6812,0,0,0,0,100,0), +(@PATH,9,4972.093,-4660.231,211.6812,0,0,0,0,100,0), +(@PATH,10,4972.593,-4665.231,211.6812,0,0,0,0,100,0), +(@PATH,11,4972.628,-4665.171,211.6984,0,0,0,0,100,0), +(@PATH,12,4972.378,-4661.171,211.6984,0,0,0,0,100,0), +(@PATH,13,4972.128,-4659.421,211.6984,0,0,0,0,100,0), +(@PATH,14,4972.128,-4657.421,211.6984,0,0,0,0,100,0), +(@PATH,15,4971.628,-4651.671,211.6984,0,0,0,0,100,0); + +SET @NPC := 110472; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=5006.468,`position_y`=-4761.551,`position_z`=211.3855 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,5006.468,-4761.551,211.3855,0,0,0,0,100,0), +(@PATH,2,5005.218,-4760.301,211.3855,0,0,0,0,100,0), +(@PATH,3,5003.468,-4759.551,211.3855,0,0,0,0,100,0), +(@PATH,4,5001.968,-4758.551,211.6355,0,0,0,0,100,0), +(@PATH,5,4999.169,-4756.928,211.6723,0,0,0,0,100,0), +(@PATH,6,4999.078,-4756.74,211.6491,0,0,0,0,100,0), +(@PATH,7,4995.578,-4756.99,211.6491,0,0,0,0,100,0), +(@PATH,8,4994.328,-4755.24,211.6491,0,0,0,0,100,0), +(@PATH,9,4994.02,-4755.05,211.6453,0,0,0,0,100,0), +(@PATH,10,4994.472,-4755.252,211.6491,0,0,0,0,100,0), +(@PATH,11,4995.472,-4757.002,211.6491,0,0,0,0,100,0), +(@PATH,12,4999.36,-4757.021,211.6276,0,0,0,0,100,0), +(@PATH,13,5001.86,-4758.521,211.6276,0,0,0,0,100,0), +(@PATH,14,5003.61,-4759.271,211.3776,0,0,0,0,100,0), +(@PATH,15,5003.792,-4759.599,211.3631,0,0,0,0,100,0), +(@PATH,16,5005.542,-4760.349,211.6131,0,0,0,0,100,0), +(@PATH,17,5006.792,-4761.849,211.6131,0,0,0,0,100,0), +(@PATH,18,5011.292,-4766.849,211.6131,0,0,0,0,100,0), +(@PATH,19,5014.042,-4769.599,211.6131,0,0,0,0,100,0), +(@PATH,20,5014.364,-4769.94,211.6148,0,0,0,0,100,0), +(@PATH,21,5014.864,-4770.44,211.6148,0,0,0,0,100,0), +(@PATH,22,5018.389,-4774.991,211.6234,0,0,0,0,100,0), +(@PATH,23,5020.639,-4778.491,211.6234,0,0,0,0,100,0), +(@PATH,24,5021.389,-4779.741,211.3734,0,0,0,0,100,0), +(@PATH,25,5021.803,-4779.973,211.3778,0,0,0,0,100,0), +(@PATH,26,5023.303,-4782.723,211.6278,0,0,0,0,100,0), +(@PATH,27,5031.042,-4794.147,211.6393,0,0,0,0,100,0), +(@PATH,28,5032.792,-4795.897,211.6393,0,0,0,0,100,0), +(@PATH,29,5037.042,-4799.647,211.6393,0,0,0,0,100,0), +(@PATH,30,5023.104,-4782.475,211.6226,0,0,0,0,100,0), +(@PATH,31,5021.354,-4779.975,211.6226,0,0,0,0,100,0), +(@PATH,32,5020.854,-4778.725,211.6226,0,0,0,0,100,0), +(@PATH,33,5018.14,-4774.706,211.6087,0,0,0,0,100,0), +(@PATH,34,5014.669,-4770.225,211.5951,0,0,0,0,100,0), +(@PATH,35,5011.419,-4766.725,211.5951,0,0,0,0,100,0); + +DELETE FROM `creature_template_addon` WHERE `entry`=26268; +INSERT INTO `creature_template_addon` (`entry`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES +(26268,0,0,0,1,27, ''); + +SET @NPC := 110556; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4970.492,`position_y`=-4715.575,`position_z`=219.7441 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,4970.492,-4715.575,219.7441,0,0,0,0,100,0), +(@PATH,2,4971.992,-4715.325,220.4941,0,0,0,0,100,0), +(@PATH,3,4973.492,-4714.825,221.2441,0,0,0,0,100,0), +(@PATH,4,4975.742,-4714.325,221.7441,0,0,0,0,100,0), +(@PATH,5,4978.742,-4713.825,222.2441,0,0,0,0,100,0), +(@PATH,6,4980.742,-4713.575,221.9941,0,0,0,0,100,0), +(@PATH,7,4981.992,-4713.325,221.7441,0,0,0,0,100,0), +(@PATH,8,4983.742,-4712.825,221.2441,0,0,0,0,100,0), +(@PATH,9,4985.242,-4712.575,220.4941,0,0,0,0,100,0), +(@PATH,10,4986.242,-4712.325,219.7441,0,0,0,0,100,0), +(@PATH,11,4968.5,-4716.197,219.4686,0,0,0,0,100,0), +(@PATH,12,4968.5,-4716.197,219.4686,0.2173836,0,0,0,100,0), +(@PATH,13,4970.5,-4714.933,219.7303,0,0,0,0,100,0), +(@PATH,14,4971.75,-4714.433,220.4803,0,0,0,0,100,0), +(@PATH,15,4973,-4713.683,221.2303,0,0,0,0,100,0), +(@PATH,16,4975,-4712.683,221.7303,0,0,0,0,100,0), +(@PATH,17,4976,-4712.183,221.9803,0,0,0,0,100,0), +(@PATH,18,4978,-4711.183,222.2303,0,0,0,0,100,0), +(@PATH,19,4979.75,-4710.183,222.2303,0,0,0,0,100,0), +(@PATH,20,4982.5,-4708.683,221.4803,0,0,0,0,100,0), +(@PATH,21,4984,-4707.933,220.7303,0,0,0,0,100,0), +(@PATH,22,4985,-4707.433,219.7303,0,0,0,0,100,0), +(@PATH,23,4985.5,-4707.183,219.7303,0,0,0,0,100,0), +(@PATH,24,4987.75,-4704.183,219.7303,0,0,0,0,100,0), +(@PATH,25,4985.311,-4707.438,219.4958,0,0,0,0,100,0), +(@PATH,26,4985.311,-4707.438,219.4958,0.6189525,0,0,0,100,0), +(@PATH,27,4987.121,-4708.128,219.7317,0,0,0,0,100,0), +(@PATH,28,4996.999,-4712.775,219.6996,0,0,0,0,100,0), +(@PATH,29,4997.249,-4716.525,219.6996,0,0,0,0,100,0), +(@PATH,30,4996.261,-4712.509,219.4735,0,0,0,0,100,0), +(@PATH,31,4996.261,-4712.509,219.4735,5.849536,0,0,0,100,0), +(@PATH,32,4997.006,-4716.74,219.7261,0,0,0,0,100,0), +(@PATH,33,4997.506,-4720.74,219.4761,0,0,0,0,100,0), +(@PATH,34,4998.006,-4723.49,219.7261,0,0,0,0,100,0), +(@PATH,35,4998.103,-4723.636,219.7025,0,0,0,0,100,0), +(@PATH,36,4997.853,-4720.886,219.7025,0,0,0,0,100,0), +(@PATH,37,4997.595,-4720.635,219.7042,0,0,0,0,100,0), +(@PATH,38,4997.345,-4720.135,219.7042,0,0,0,0,100,0), +(@PATH,39,4997.345,-4716.885,219.4542,0,0,0,0,100,0), +(@PATH,40,4997.056,-4712.651,219.6972,0,0,0,0,100,0), +(@PATH,41,4991.556,-4700.401,219.6972,0,0,0,0,100,0), +(@PATH,42,4988.556,-4693.901,219.6972,0,0,0,0,100,0), +(@PATH,43,4986.112,-4688.446,219.7411,0,0,0,0,100,0), +(@PATH,44,4988.362,-4693.696,219.7411,0,0,0,0,100,0), +(@PATH,45,4989.805,-4696.215,219.7516,0,0,0,0,100,0), +(@PATH,46,4991.805,-4699.465,219.7516,0,0,0,0,100,0), +(@PATH,47,4988.768,-4694.563,219.4946,0,0,0,0,100,0), +(@PATH,48,4988.768,-4694.563,219.4946,5.140615,0,0,0,100,0), +(@PATH,49,4987.719,-4703.979,219.9336,0,0,0,0,100,0), +(@PATH,50,4985.469,-4706.229,219.9336,0,0,0,0,100,0), +(@PATH,51,4984.969,-4707.479,220.4336,0,0,0,0,100,0), +(@PATH,52,4984.469,-4708.479,220.4336,0,0,0,0,100,0), +(@PATH,53,4983.469,-4710.229,221.1836,0,0,0,0,100,0), +(@PATH,54,4982.217,-4712.462,221.5245,0,0,0,0,100,0), +(@PATH,55,4980.967,-4712.462,221.7745,0,0,0,0,100,0), +(@PATH,56,4978.467,-4712.962,222.0245,0,0,0,0,100,0), +(@PATH,57,4976.467,-4713.462,221.7745,0,0,0,0,100,0), +(@PATH,58,4976.035,-4713.909,221.9419,0,0,0,0,100,0), +(@PATH,59,4974.785,-4714.159,221.6919,0,0,0,0,100,0), +(@PATH,60,4973.035,-4714.659,221.1919,0,0,0,0,100,0), +(@PATH,61,4972.035,-4714.909,220.6919,0,0,0,0,100,0), +(@PATH,62,4970.535,-4715.409,219.9419,0,0,0,0,100,0), +(@PATH,63,4978.076,-4713.338,221.915,0,0,0,0,100,0), +(@PATH,64,4978.076,-4713.338,221.915,3.368376,0,0,0,100,0), +(@PATH,65,4976.91,-4713.574,221.9563,0,0,0,0,100,0), +(@PATH,66,4975.91,-4713.574,221.9563,0,0,0,0,100,0), +(@PATH,67,4972.91,-4713.824,221.2063,0,0,0,0,100,0), +(@PATH,68,4971.41,-4714.074,220.7063,0,0,0,0,100,0), +(@PATH,69,4970.16,-4714.324,219.9563,0,0,0,0,100,0), +(@PATH,70,4967.606,-4714.529,219.4961,0,0,0,0,100,0), +(@PATH,71,4967.606,-4714.529,219.4961,3.254826,0,0,0,100,0), +(@PATH,72,4965.34,-4710.163,219.7599,0,0,0,0,100,0), +(@PATH,73,4963.59,-4707.163,219.7599,0,0,0,0,100,0), +(@PATH,74,4959.034,-4705.619,219.5352,0,0,0,0,100,0), +(@PATH,75,4959.39,-4705.551,219.7635,0,0,0,0,100,0), +(@PATH,76,4959.64,-4707.801,219.7635,0,0,0,0,100,0), +(@PATH,77,4960.14,-4711.551,219.7635,0,0,0,0,100,0), +(@PATH,78,4960.938,-4715.122,219.7473,0,0,0,0,100,0), +(@PATH,79,4968.219,-4716.248,219.9708,0,0,0,0,100,0), +(@PATH,80,4970.219,-4715.498,219.9708,0,0,0,0,100,0), +(@PATH,81,4971.719,-4714.998,220.4708,0,0,0,0,100,0), +(@PATH,82,4972.969,-4714.748,221.2208,0,0,0,0,100,0), +(@PATH,83,4975.053,-4713.824,221.6586,0,0,0,0,100,0), +(@PATH,84,4976.303,-4713.574,221.9086,0,0,0,0,100,0), +(@PATH,85,4978.303,-4713.324,222.1586,0,0,0,0,100,0), +(@PATH,86,4980.553,-4712.824,221.9086,0,0,0,0,100,0), +(@PATH,87,4975.714,-4713.883,221.6543,0,0,0,0,100,0), +(@PATH,88,4975.714,-4713.883,221.6543,0.2268625,0,0,0,100,0), +(@PATH,89,4978.577,-4713.063,222.0859,0,0,0,0,100,0), +(@PATH,90,4980.827,-4712.813,221.8359,0,0,0,0,100,0), +(@PATH,91,4983.827,-4712.563,221.0859,0,0,0,0,100,0), +(@PATH,92,4985.077,-4712.313,220.5859,0,0,0,0,100,0), +(@PATH,93,4986.077,-4712.063,219.8359,0,0,0,0,100,0); + +SET @NPC := 118822; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3494.382,`position_y`=-4552.813,`position_z`=224.2461 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,3494.382,-4552.813,224.2461,0,0,0,0,100,0), +(@PATH,2,3495.632,-4551.813,223.9961,0,0,0,0,100,0), +(@PATH,3,3497.382,-4550.813,222.9961,0,0,0,0,100,0), +(@PATH,4,3499.882,-4549.313,222.4961,0,0,0,0,100,0), +(@PATH,5,3501.382,-4548.313,221.9961,0,0,0,0,100,0), +(@PATH,6,3503.882,-4546.813,221.2461,0,0,0,0,100,0), +(@PATH,7,3506.382,-4545.313,220.4961,0,0,0,0,100,0), +(@PATH,8,3506.673,-4544.896,220.2739,0,0,0,0,100,0), +(@PATH,9,3507.423,-4544.646,220.2739,0,0,0,0,100,0), +(@PATH,10,3508.673,-4543.396,219.7739,0,0,0,0,100,0), +(@PATH,11,3511.423,-4540.896,219.2739,0,0,0,0,100,0), +(@PATH,12,3514.411,-4538.24,218.5021,0,0,0,0,100,0), +(@PATH,13,3515.411,-4534.24,217.7521,0,0,0,0,100,0), +(@PATH,14,3516.161,-4531.74,217.2521,0,0,0,0,100,0), +(@PATH,15,3517.161,-4528.74,216.7521,0,0,0,0,100,0), +(@PATH,16,3518.161,-4524.99,216.2521,0,0,0,0,100,0), +(@PATH,17,3518.383,-4524.767,216.0448,0,0,0,0,100,0), +(@PATH,18,3518.883,-4523.517,215.7948,0,0,0,0,100,0), +(@PATH,19,3521.883,-4521.517,215.2948,0,0,0,0,100,0), +(@PATH,20,3523.383,-4520.267,214.7948,0,0,0,0,100,0), +(@PATH,21,3524.552,-4519.662,214.4079,0,0,0,0,100,0), +(@PATH,22,3526.552,-4519.912,213.4079,0,0,0,0,100,0), +(@PATH,23,3528.552,-4519.912,212.6579,0,0,0,0,100,0), +(@PATH,24,3530.552,-4519.912,211.9079,0,0,0,0,100,0), +(@PATH,25,3533.302,-4520.162,211.4079,0,0,0,0,100,0), +(@PATH,26,3535.302,-4520.162,210.6579,0,0,0,0,100,0), +(@PATH,27,3537.302,-4520.412,209.9079,0,0,0,0,100,0), +(@PATH,28,3537.519,-4520.006,209.603,0,0,0,0,100,0), +(@PATH,29,3539.019,-4520.256,209.103,0,0,0,0,100,0), +(@PATH,30,3542.519,-4518.756,208.353,0,0,0,0,100,0), +(@PATH,31,3541.411,-4519.309,208.4283,0,0,0,0,100,0), +(@PATH,32,3538.654,-4520.119,209.2209,0,0,0,0,100,0), +(@PATH,33,3536.654,-4520.119,209.7209,0,0,0,0,100,0), +(@PATH,34,3534.654,-4519.869,210.4709,0,0,0,0,100,0), +(@PATH,35,3532.654,-4519.869,211.2209,0,0,0,0,100,0), +(@PATH,36,3530.904,-4519.869,211.9709,0,0,0,0,100,0), +(@PATH,37,3528.904,-4519.619,212.7209,0,0,0,0,100,0), +(@PATH,38,3526.904,-4519.619,213.4709,0,0,0,0,100,0), +(@PATH,39,3524.904,-4519.619,214.2209,0,0,0,0,100,0), +(@PATH,40,3524.787,-4519.809,214.4233,0,0,0,0,100,0), +(@PATH,41,3524.287,-4519.809,214.6733,0,0,0,0,100,0), +(@PATH,42,3522.537,-4520.809,214.9233,0,0,0,0,100,0), +(@PATH,43,3520.537,-4522.309,215.6733,0,0,0,0,100,0), +(@PATH,44,3520.155,-4522.621,215.7749,0,0,0,0,100,0), +(@PATH,45,3518.655,-4523.871,216.2749,0,0,0,0,100,0), +(@PATH,46,3517.655,-4527.621,216.7749,0,0,0,0,100,0), +(@PATH,47,3516.905,-4530.121,217.0249,0,0,0,0,100,0), +(@PATH,48,3515.655,-4534.121,217.7749,0,0,0,0,100,0), +(@PATH,49,3514.23,-4538.046,218.7422,0,0,0,0,100,0), +(@PATH,50,3511.48,-4540.546,219.2422,0,0,0,0,100,0), +(@PATH,51,3507.98,-4544.046,219.9922,0,0,0,0,100,0), +(@PATH,52,3507.672,-4544.28,220.189,0,0,0,0,100,0), +(@PATH,53,3507.172,-4544.78,220.439,0,0,0,0,100,0), +(@PATH,54,3503.672,-4547.03,221.439,0,0,0,0,100,0), +(@PATH,55,3501.922,-4547.78,221.939,0,0,0,0,100,0), +(@PATH,56,3499.672,-4549.28,222.439,0,0,0,0,100,0), +(@PATH,57,3497.922,-4550.28,223.189,0,0,0,0,100,0), +(@PATH,58,3495.37,-4551.927,224.1924,0,0,0,0,100,0), +(@PATH,59,3493.12,-4553.927,224.9424,0,0,0,0,100,0), +(@PATH,60,3491.37,-4555.177,225.4424,0,0,0,0,100,0), +(@PATH,61,3489.37,-4556.927,226.1924,0,0,0,0,100,0), +(@PATH,62,3487.12,-4558.677,226.9424,0,0,0,0,100,0), +(@PATH,63,3488.252,-4557.707,226.4908,0,0,0,0,100,0), +(@PATH,64,3490.502,-4555.957,225.7408,0,0,0,0,100,0), +(@PATH,65,3492.002,-4554.957,225.2408,0,0,0,0,100,0), +(@PATH,66,3494.252,-4552.957,224.4908,0,0,0,0,100,0), +(@PATH,67,3494.369,-4552.621,224.1573,0,0,0,0,100,0), +(@PATH,68,3495.619,-4551.871,223.9073,0,0,0,0,100,0), +(@PATH,69,3497.369,-4550.621,223.1573,0,0,0,0,100,0), +(@PATH,70,3499.869,-4549.121,222.4073,0,0,0,0,100,0), +(@PATH,71,3501.369,-4548.371,222.1573,0,0,0,0,100,0), +(@PATH,72,3503.869,-4546.871,221.4073,0,0,0,0,100,0), +(@PATH,73,3506.369,-4545.371,220.6573,0,0,0,0,100,0); +UPDATE `smart_scripts` SET `action_param1`=1 WHERE `entryorguid`=26356 AND `source_type`=0 AND `id`=0 AND `link`=1; + +SET @NPC := 98061; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4037.801,`position_y`=-4305.377,`position_z`=252.4434 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,4037.801,-4305.377,252.4434,0,0,0,0,100,0), +(@PATH,2,4029.266,-4311.001,252.5234,0,0,0,0,100,0), +(@PATH,3,4029.175,-4310.955,252.2501,0,0,0,0,100,0), +(@PATH,4,4029.509,-4310.642,252.4412,0,0,0,0,100,0), +(@PATH,5,4037.943,-4305.163,252.2845,0,0,0,0,100,0), +(@PATH,6,4054.193,-4300.913,251.7845,0,0,0,0,100,0), +(@PATH,7,4062.19,-4298.607,251.5605,0,0,0,0,100,0), +(@PATH,8,4086.898,-4293.291,251.9268,0,0,0,0,100,0), +(@PATH,9,4086.576,-4293.453,251.7249,0,0,0,0,100,0), +(@PATH,10,4086.678,-4293.366,251.7816,0,0,0,0,100,0), +(@PATH,11,4062,-4298.887,251.8086,0,0,0,0,100,0), +(@PATH,12,4046.75,-4302.637,252.0586,0,0,0,0,100,0), +(@PATH,13,4037.769,-4305.386,252.4443,0,0,0,0,100,0), +(@PATH,14,4029.219,-4311.032,252.5237,0,0,0,0,100,0), +(@PATH,15,4029.175,-4310.955,252.2501,0,0,0,0,100,0); + +UPDATE `smart_scripts` SET `action_param1`=1 WHERE `entryorguid`=26389 AND `source_type`=0 AND `id`=0 AND `link`=1; +SET @NPC := 98054; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4043.963,`position_y`=-4430.786,`position_z`=261.5165 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,4043.963,-4430.786,261.5165,0,0,0,0,100,0), +(@PATH,2,4044.963,-4432.786,262.0165,0,0,0,0,100,0), +(@PATH,3,4044.713,-4435.286,262.7665,0,0,0,0,100,0), +(@PATH,4,4045.213,-4436.286,263.0165,0,0,0,0,100,0), +(@PATH,5,4045.463,-4436.786,263.0165,0,0,0,0,100,0), +(@PATH,6,4047.463,-4438.786,262.7665,0,0,0,0,100,0), +(@PATH,7,4047.963,-4439.786,263.5165,0,0,0,0,100,0), +(@PATH,8,4047.949,-4440.013,263.7135,0,0,0,0,100,0), +(@PATH,9,4049.949,-4440.513,264.2135,0,0,0,0,100,0), +(@PATH,10,4048.949,-4441.763,264.7135,0,0,0,0,100,0), +(@PATH,11,4048.949,-4443.763,265.2135,0,0,0,0,100,0), +(@PATH,12,4047.699,-4445.763,266.2135,0,0,0,0,100,0), +(@PATH,13,4046.199,-4447.263,266.7135,0,0,0,0,100,0), +(@PATH,14,4043.449,-4446.763,267.4635,0,0,0,0,100,0), +(@PATH,15,4042.699,-4448.013,267.9635,0,0,0,0,100,0), +(@PATH,16,4041.949,-4448.513,267.9635,0,0,0,0,100,0), +(@PATH,17,4041.449,-4453.513,267.4635,0,0,0,0,100,0), +(@PATH,18,4041.242,-4453.717,267.8022,0,0,0,0,100,0), +(@PATH,19,4040.242,-4454.467,268.3022,0,0,0,0,100,0), +(@PATH,20,4040.242,-4456.467,268.8022,0,0,0,0,100,0), +(@PATH,21,4040.242,-4460.217,269.5522,0,0,0,0,100,0), +(@PATH,22,4040.489,-4464.713,269.6811,0,0,0,0,100,0), +(@PATH,23,4046.239,-4480.213,269.1811,0,0,0,0,100,0), +(@PATH,24,4046.276,-4479.878,269.3551,0,0,0,0,100,0), +(@PATH,25,4044.026,-4474.378,270.1051,0,0,0,0,100,0), +(@PATH,26,4040.298,-4464.532,269.725,0,0,0,0,100,0), +(@PATH,27,4040.298,-4459.782,269.225,0,0,0,0,100,0), +(@PATH,28,4040.298,-4455.782,268.475,0,0,0,0,100,0), +(@PATH,29,4040.299,-4455.474,268.2261,0,0,0,0,100,0), +(@PATH,30,4040.299,-4454.224,267.9761,0,0,0,0,100,0), +(@PATH,31,4042.799,-4453.224,267.7261,0,0,0,0,100,0), +(@PATH,32,4046.049,-4454.224,267.7261,0,0,0,0,100,0), +(@PATH,33,4047.799,-4452.974,267.2261,0,0,0,0,100,0), +(@PATH,34,4048.549,-4450.474,266.7261,0,0,0,0,100,0), +(@PATH,35,4049.049,-4444.724,265.7261,0,0,0,0,100,0), +(@PATH,36,4050.049,-4444.724,265.7261,0,0,0,0,100,0), +(@PATH,37,4050.549,-4442.974,264.9761,0,0,0,0,100,0), +(@PATH,38,4049.437,-4441.189,263.9388,0,0,0,0,100,0), +(@PATH,39,4047.937,-4438.439,262.9388,0,0,0,0,100,0), +(@PATH,40,4045.687,-4436.939,262.9388,0,0,0,0,100,0), +(@PATH,41,4044.687,-4436.189,262.9388,0,0,0,0,100,0), +(@PATH,42,4043.937,-4433.189,261.9388,0,0,0,0,100,0), +(@PATH,43,4043.437,-4430.439,261.4388,0,0,0,0,100,0), +(@PATH,44,4043.437,-4428.939,261.4388,0,0,0,0,100,0), +(@PATH,45,4038.512,-4412.942,261.4726,0,0,0,0,100,0), +(@PATH,46,4045.009,-4403.787,261.2599,0,0,0,0,100,0), +(@PATH,47,4050.509,-4398.787,260.7599,0,0,0,0,100,0), +(@PATH,48,4054.184,-4395.831,260.5081,0,0,0,0,100,0), +(@PATH,49,4060.914,-4401.005,260.7264,0,0,0,0,100,0), +(@PATH,50,4060.763,-4401.35,260.5203,0,0,0,0,100,0), +(@PATH,51,4060.835,-4401.013,260.7022,0,0,0,0,100,0); + +-- Earthen Warrior SAI +SET @ENTRY := 26282; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,1,0,100,0,5000,5000,10000,10000,49,0,0,0,0,0,0,19,26284,10,0,0,0,0,0,"Earthen Warrior - Out of Combat - Start Attacking"); + +SET @NPC := 112260; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4626.77,`position_y`=-4468.18,`position_z`=188.7218 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,4626.77,-4468.18,188.7218,0,0,0,0,100,0), +(@PATH,2,4628.02,-4468.43,188.7218,0,0,0,0,100,0), +(@PATH,3,4633.77,-4469.43,189.2218,0,0,0,0,100,0), +(@PATH,4,4638.52,-4470.18,189.7218,0,0,0,0,100,0), +(@PATH,5,4642.52,-4470.93,190.4718,0,0,0,0,100,0), +(@PATH,6,4644.66,-4471.42,191.0322,0,0,0,0,100,0), +(@PATH,7,4647.66,-4471.42,191.5322,0,0,0,0,100,0), +(@PATH,8,4651.41,-4471.42,191.7822,0,0,0,0,100,0), +(@PATH,9,4655.41,-4471.42,192.5322,0,0,0,0,100,0), +(@PATH,10,4659.563,-4471.758,193.4037,0,0,0,0,100,0), +(@PATH,11,4667.063,-4474.758,193.9037,0,0,0,0,100,0), +(@PATH,12,4667.158,-4472.282,193.5602,0,0,0,0,100,0), +(@PATH,13,4659.328,-4471.715,193.0153,0,0,0,0,100,0), +(@PATH,14,4655.328,-4471.715,192.5153,0,0,0,0,100,0), +(@PATH,15,4651.578,-4471.465,191.7653,0,0,0,0,100,0), +(@PATH,16,4647.578,-4471.465,191.5153,0,0,0,0,100,0), +(@PATH,17,4644.492,-4471.189,190.7167,0,0,0,0,100,0), +(@PATH,18,4640.492,-4470.439,189.9667,0,0,0,0,100,0), +(@PATH,19,4635.742,-4469.689,189.7167,0,0,0,0,100,0), +(@PATH,20,4630.992,-4468.939,188.9667,0,0,0,0,100,0), +(@PATH,21,4627.861,-4468.194,188.4529,0,0,0,0,100,0), +(@PATH,22,4625.361,-4467.944,188.7029,0,0,0,0,100,0), +(@PATH,23,4619.689,-4466.896,187.1016,0,0,0,0,100,0), +(@PATH,24,4609.689,-4465.646,184.6016,0,0,0,0,100,0), +(@PATH,25,4608.689,-4465.646,184.6016,0,0,0,0,100,0), +(@PATH,26,4608.402,-4465.411,184.3824,0,0,0,0,100,0), +(@PATH,27,4605.652,-4465.161,184.3824,0,0,0,0,100,0), +(@PATH,28,4595.808,-4461.938,184.4014,0,0,0,0,100,0), +(@PATH,29,4595.772,-4462.198,184.1551,0,0,0,0,100,0), +(@PATH,30,4595.927,-4462.176,184.3824,0,0,0,0,100,0), +(@PATH,31,4605.99,-4465.424,184.4906,0,0,0,0,100,0), +(@PATH,32,4609.24,-4465.924,183.9906,0,0,0,0,100,0), +(@PATH,33,4619.987,-4467.194,187.3334,0,0,0,0,100,0), +(@PATH,34,4626.487,-4467.944,188.5834,0,0,0,0,100,0), +(@PATH,35,4626.743,-4468.349,188.8552,0,0,0,0,100,0), +(@PATH,36,4627.993,-4468.349,188.8552,0,0,0,0,100,0), +(@PATH,37,4633.993,-4469.349,189.1052,0,0,0,0,100,0), +(@PATH,38,4638.493,-4470.099,189.8552,0,0,0,0,100,0), +(@PATH,39,4642.493,-4470.849,190.3552,0,0,0,0,100,0); + +SET @NPC := 112265; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4740.915,`position_y`=-4506.604,`position_z`=199.756 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,4740.915,-4506.604,199.756,0,0,0,0,100,0), +(@PATH,2,4739.165,-4508.604,200.256,0,0,0,0,100,0), +(@PATH,3,4736.571,-4511.472,200.7764,0,0,0,0,100,0), +(@PATH,4,4732.571,-4516.722,201.2764,0,0,0,0,100,0), +(@PATH,5,4729.089,-4521.665,201.4696,0,0,0,0,100,0), +(@PATH,6,4729.089,-4524.915,202.2196,0,0,0,0,100,0), +(@PATH,7,4727.339,-4528.165,202.7196,0,0,0,0,100,0), +(@PATH,8,4725.089,-4532.415,203.2196,0,0,0,0,100,0), +(@PATH,9,4720.262,-4531.4,203.6031,0,0,0,0,100,0), +(@PATH,10,4719.762,-4532.4,203.8531,0,0,0,0,100,0), +(@PATH,11,4719.762,-4533.4,204.1031,0,0,0,0,100,0), +(@PATH,12,4718.512,-4536.15,204.6031,0,0,0,0,100,0), +(@PATH,13,4715.762,-4538.4,205.1031,0,0,0,0,100,0), +(@PATH,14,4714.762,-4539.65,205.6031,0,0,0,0,100,0), +(@PATH,15,4715.869,-4538.347,205.2154,0,0,0,0,100,0), +(@PATH,16,4717.119,-4536.597,204.7154,0,0,0,0,100,0), +(@PATH,17,4718.119,-4535.847,204.4654,0,0,0,0,100,0), +(@PATH,18,4717.619,-4533.347,204.4654,0,0,0,0,100,0), +(@PATH,19,4719.119,-4530.597,203.4654,0,0,0,0,100,0), +(@PATH,20,4719.277,-4530.432,203.2003,0,0,0,0,100,0), +(@PATH,21,4720.527,-4531.182,203.4503,0,0,0,0,100,0), +(@PATH,22,4721.527,-4529.432,202.9503,0,0,0,0,100,0), +(@PATH,23,4723.027,-4525.432,202.4503,0,0,0,0,100,0), +(@PATH,24,4726.277,-4523.432,201.7003,0,0,0,0,100,0), +(@PATH,25,4729.367,-4521.513,201.2202,0,0,0,0,100,0), +(@PATH,26,4736.9,-4511.23,200.8284,0,0,0,0,100,0), +(@PATH,27,4739.9,-4507.73,199.8284,0,0,0,0,100,0), +(@PATH,28,4742.65,-4504.73,199.5784,0,0,0,0,100,0); + +SET @NPC := 112263; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4763.436,`position_y`=-4489.991,`position_z`=196.598 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,4763.436,-4489.991,196.598,0,0,0,0,100,0), +(@PATH,2,4777.686,-4503.491,197.098,0,0,0,0,100,0), +(@PATH,3,4777.988,-4503.717,197.3403,0,0,0,0,100,0), +(@PATH,4,4779.238,-4504.967,197.3403,0,0,0,0,100,0), +(@PATH,5,4787.988,-4509.217,197.5903,0,0,0,0,100,0), +(@PATH,6,4797.488,-4514.217,198.3403,0,0,0,0,100,0), +(@PATH,7,4791.602,-4511.282,197.6792,0,0,0,0,100,0), +(@PATH,8,4781.352,-4506.032,197.4292,0,0,0,0,100,0), +(@PATH,9,4779.015,-4504.664,197.1621,0,0,0,0,100,0), +(@PATH,10,4764.765,-4491.164,196.6621,0,0,0,0,100,0), +(@PATH,11,4764.466,-4490.788,196.5181,0,0,0,0,100,0), +(@PATH,12,4763.216,-4489.788,196.5181,0,0,0,0,100,0), +(@PATH,13,4757.216,-4483.288,195.7681,0,0,0,0,100,0), +(@PATH,14,4751.675,-4477.44,195.3216,0,0,0,0,100,0), +(@PATH,15,4740.917,-4467.688,195.4378,0,0,0,0,100,0), +(@PATH,16,4733.417,-4458.938,194.9378,0,0,0,0,100,0), +(@PATH,17,4730.063,-4454.976,194.4022,0,0,0,0,100,0), +(@PATH,18,4726.313,-4450.476,193.9022,0,0,0,0,100,0), +(@PATH,19,4721.563,-4444.476,193.4022,0,0,0,0,100,0), +(@PATH,20,4721.331,-4444.313,193.3035,0,0,0,0,100,0), +(@PATH,21,4719.581,-4442.063,193.0535,0,0,0,0,100,0), +(@PATH,22,4712.081,-4433.313,192.5535,0,0,0,0,100,0), +(@PATH,23,4706.962,-4427.567,192.1902,0,0,0,0,100,0), +(@PATH,24,4700.712,-4420.317,191.6902,0,0,0,0,100,0), +(@PATH,25,4704.823,-4424.94,191.8282,0,0,0,0,100,0), +(@PATH,26,4705.068,-4425.129,192.0756,0,0,0,0,100,0), +(@PATH,27,4707.318,-4427.629,192.3256,0,0,0,0,100,0), +(@PATH,28,4714.318,-4435.879,192.8256,0,0,0,0,100,0), +(@PATH,29,4719.729,-4442.429,193.2542,0,0,0,0,100,0), +(@PATH,30,4725.229,-4449.179,193.7542,0,0,0,0,100,0), +(@PATH,31,4729.479,-4454.679,194.2542,0,0,0,0,100,0), +(@PATH,32,4729.81,-4454.901,194.5507,0,0,0,0,100,0), +(@PATH,33,4730.31,-4455.401,194.5507,0,0,0,0,100,0), +(@PATH,34,4734.56,-4460.401,195.0507,0,0,0,0,100,0), +(@PATH,35,4741.313,-4467.867,195.4152,0,0,0,0,100,0); + +-- correction +-- Grizzly Hills Giant SAI +SET @ENTRY := 26261; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,8,0,100,0,47394,0,0,0,33,26261,0,0,0,0,0,7,0,0,0,0,0,0,0,"Grizzly Hills Giant - On Spellhit 'Kurun's Blessing' - Quest Credit 'Rallying the Troops'"), +(@ENTRY,0,1,0,1,0,100,0,2000,5000,4000,6000,11,46815,0,0,0,0,0,19,26264,100,0,0,0,0,0,"Grizzly Hills Giant - Out of Combat - Cast 'Toss Boulder'"); + +SET @NPC := 110559; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4974.938,`position_y`=-4745.822,`position_z`=219.5011 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,4974.938,-4745.822,219.5011,0,0,0,0,100,0), +(@PATH,2,4974.938,-4745.822,219.5011,2.057687,0,0,0,100,0), +(@PATH,3,4974.938,-4745.822,219.5011,0,0,0,0,100,0), +(@PATH,4,4974.938,-4745.822,219.5011,2.057687,0,0,0,100,0), +(@PATH,5,4970.268,-4736.388,219.75,0,0,0,0,100,0), +(@PATH,6,4969.018,-4734.138,219.75,0,0,0,0,100,0), +(@PATH,7,4968.648,-4734.162,219.7481,0,0,0,0,100,0), +(@PATH,8,4969.148,-4736.162,219.7481,0,0,0,0,100,0), +(@PATH,9,4970.325,-4738.761,219.7499,0,0,0,0,100,0), +(@PATH,10,4974.973,-4749.851,219.75,0,0,0,0,100,0), +(@PATH,11,4977.148,-4754.923,219.7599,0,0,0,0,100,0), +(@PATH,12,4977.898,-4756.173,219.7599,0,0,0,0,100,0), +(@PATH,13,4976.332,-4753.346,219.5004,0,0,0,0,100,0), +(@PATH,14,4976.332,-4753.346,219.5004,5.131248,0,0,0,100,0), +(@PATH,15,4978.357,-4755.924,219.7322,0,0,0,0,100,0), +(@PATH,16,4985.357,-4766.174,219.7322,0,0,0,0,100,0), +(@PATH,17,4988.607,-4770.424,219.7322,0,0,0,0,100,0), +(@PATH,18,4990.607,-4773.424,219.7322,0,0,0,0,100,0), +(@PATH,19,4978.615,-4756.599,219.5061,0,0,0,0,100,0), +(@PATH,20,4978.615,-4756.599,219.5061,5.324385,0,0,0,100,0), +(@PATH,21,4989.826,-4764.923,219.9392,0,0,0,0,100,0), +(@PATH,22,4992.076,-4766.923,220.9392,0,0,0,0,100,0), +(@PATH,23,4994.826,-4767.173,219.9392,0,0,0,0,100,0), +(@PATH,24,4997.076,-4766.923,220.9392,0,0,0,0,100,0), +(@PATH,25,4998.326,-4766.423,221.4392,0,0,0,0,100,0), +(@PATH,26,5002.076,-4765.673,221.9392,0,0,0,0,100,0), +(@PATH,27,5004.826,-4765.173,222.1892,0,0,0,0,100,0), +(@PATH,28,5005.213,-4765.373,222.2207,0,0,0,0,100,0), +(@PATH,29,5006.713,-4764.873,221.9707,0,0,0,0,100,0), +(@PATH,30,5008.463,-4763.873,221.7207,0,0,0,0,100,0), +(@PATH,31,5010.463,-4762.623,221.2207,0,0,0,0,100,0), +(@PATH,32,5011.713,-4762.123,220.7207,0,0,0,0,100,0), +(@PATH,33,5012.463,-4761.623,219.9707,0,0,0,0,100,0), +(@PATH,34,5014.963,-4760.373,219.9707,0,0,0,0,100,0), +(@PATH,35,5013.416,-4761.159,219.5162,0,0,0,0,100,0), +(@PATH,36,5013.416,-4761.159,219.5162,0.5364561,0,0,0,100,0), +(@PATH,37,5012.949,-4758.56,219.7025,0,0,0,0,100,0), +(@PATH,38,5011.449,-4752.56,219.7025,0,0,0,0,100,0), +(@PATH,39,5011.199,-4749.81,219.7025,0,0,0,0,100,0), +(@PATH,40,5010.699,-4747.81,219.7025,0,0,0,0,100,0), +(@PATH,41,5011.182,-4745.968,219.433,0,0,0,0,100,0), +(@PATH,42,5013.682,-4748.968,219.683,0,0,0,0,100,0), +(@PATH,43,5014.682,-4750.218,219.683,0,0,0,0,100,0), +(@PATH,44,5013.822,-4749.14,219.4679,0,0,0,0,100,0), +(@PATH,45,5015.072,-4750.64,219.7179,0,0,0,0,100,0), +(@PATH,46,5015.822,-4751.89,219.7179,0,0,0,0,100,0), +(@PATH,47,5016.797,-4758.994,219.9411,0,0,0,0,100,0), +(@PATH,48,5014.797,-4760.244,219.9411,0,0,0,0,100,0), +(@PATH,49,5013.047,-4760.994,219.9411,0,0,0,0,100,0), +(@PATH,50,5011.547,-4761.994,220.6911,0,0,0,0,100,0), +(@PATH,51,5010.547,-4762.744,221.1911,0,0,0,0,100,0), +(@PATH,52,5008.547,-4763.994,221.6911,0,0,0,0,100,0), +(@PATH,53,5007.547,-4764.494,221.9411,0,0,0,0,100,0), +(@PATH,54,5016.685,-4757.653,219.5163,0,0,0,0,100,0), +(@PATH,55,5016.685,-4757.653,219.5163,4.85295,0,0,0,100,0), +(@PATH,56,5014.053,-4759.563,219.7658,0,0,0,0,100,0), +(@PATH,57,5012.553,-4760.563,219.7658,0,0,0,0,100,0), +(@PATH,58,5011.053,-4761.563,220.5158,0,0,0,0,100,0), +(@PATH,59,5010.053,-4762.563,221.2658,0,0,0,0,100,0), +(@PATH,60,5007.553,-4764.063,221.7658,0,0,0,0,100,0), +(@PATH,61,5005.303,-4765.813,222.0158,0,0,0,0,100,0), +(@PATH,62,5003.553,-4767.063,222.0158,0,0,0,0,100,0), +(@PATH,63,5000.803,-4769.063,221.2658,0,0,0,0,100,0), +(@PATH,64,4999.553,-4769.813,220.5158,0,0,0,0,100,0), +(@PATH,65,4998.303,-4770.813,219.7658,0,0,0,0,100,0), +(@PATH,66,5015.091,-4758.8,219.5454,0,0,0,0,100,0), +(@PATH,67,5015.091,-4758.8,219.5454,3.765347,0,0,0,100,0), +(@PATH,68,5013.777,-4759.399,219.7824,0,0,0,0,100,0), +(@PATH,69,5012.027,-4760.149,219.5324,0,0,0,0,100,0), +(@PATH,70,5010.527,-4760.399,220.5324,0,0,0,0,100,0), +(@PATH,71,5009.027,-4761.149,221.2824,0,0,0,0,100,0), +(@PATH,72,5007.277,-4761.899,221.5324,0,0,0,0,100,0), +(@PATH,73,5005.277,-4761.899,222.0324,0,0,0,0,100,0), +(@PATH,74,5003.527,-4763.399,222.2824,0,0,0,0,100,0), +(@PATH,75,5001.527,-4764.899,222.2824,0,0,0,0,100,0), +(@PATH,76,4998.527,-4766.399,221.2824,0,0,0,0,100,0), +(@PATH,77,4997.527,-4767.149,220.7824,0,0,0,0,100,0), +(@PATH,78,4996.527,-4767.399,219.7824,0,0,0,0,100,0), +(@PATH,79,4995.777,-4767.649,219.7824,0,0,0,0,100,0), +(@PATH,80,4991.527,-4767.899,219.7824,0,0,0,0,100,0), +(@PATH,81,4987.777,-4765.649,219.7824,0,0,0,0,100,0), +(@PATH,82,4981.399,-4761.659,219.763,0,0,0,0,100,0), +(@PATH,83,4977.899,-4756.159,219.763,0,0,0,0,100,0), +(@PATH,84,4977.707,-4755.765,219.7526,0,0,0,0,100,0), +(@PATH,85,4976.957,-4754.515,219.7526,0,0,0,0,100,0), +(@PATH,86,4974.813,-4749.59,219.7486,0,0,0,0,100,0), +(@PATH,87,4975.045,-4750.456,219.4998,0,0,0,0,100,0), +(@PATH,88,4975.045,-4750.456,219.4998,1.989743,0,0,0,100,0), +(@PATH,89,4969.571,-4736.454,219.7493,0,0,0,0,100,0), +(@PATH,90,4968.821,-4734.204,219.7493,0,0,0,0,100,0), +(@PATH,91,4972.802,-4744.884,219.4986,0,0,0,0,100,0), +(@PATH,92,4972.802,-4744.884,219.4986,1.953552,0,0,0,100,0), +(@PATH,93,4969.699,-4736.418,219.7488,0,0,0,0,100,0), +(@PATH,94,4968.699,-4734.168,219.7488,0,0,0,0,100,0); + +-- Runed Giant SAI +SET @ENTRY := 26417; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0 AND `id`=2; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,2,0,1,0,100,0,5000,5000,10000,10000,49,0,0,0,0,0,0,19,26261,15,0,0,0,0,0,"Runed Giant - Out of Combat - Start Attacking"); + +SET @NPC := 86438; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4795.183,`position_y`=-4858.25,`position_z`=25.82121 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,4795.183,-4858.25,25.82121,0,0,0,0,100,0), +(@PATH,2,4793.933,-4857.25,25.82121,0,0,0,0,100,0), +(@PATH,3,4786.933,-4851,25.82121,0,0,0,0,100,0), +(@PATH,4,4783.933,-4848.5,25.57121,0,0,0,0,100,0), +(@PATH,5,4775.606,-4841.151,25.45528,0,0,0,0,100,0), +(@PATH,6,4775.606,-4841.151,25.45528,2.513274,0,0,0,100,0), +(@PATH,7,4783.6,-4848.556,25.60373,0,0,0,0,100,0), +(@PATH,8,4786.35,-4851.306,25.85373,0,0,0,0,100,0), +(@PATH,9,4793.35,-4858.056,25.85373,0,0,0,0,100,0), +(@PATH,10,4793.512,-4857.986,25.97804,0,0,0,0,100,0), +(@PATH,11,4794.762,-4859.236,25.97804,0,0,0,0,100,0), +(@PATH,12,4798.762,-4857.986,25.72804,0,0,0,0,100,0), +(@PATH,13,4800.262,-4857.736,25.72804,0,0,0,0,100,0), +(@PATH,14,4802.262,-4856.986,25.72804,0,0,0,0,100,0), +(@PATH,15,4810.12,-4854.692,25.79934,0,0,0,0,100,0), +(@PATH,16,4816.12,-4851.192,25.79934,0,0,0,0,100,0), +(@PATH,17,4818.37,-4850.192,25.54934,0,0,0,0,100,0), +(@PATH,18,4819.37,-4849.692,25.54934,0,0,0,0,100,0), +(@PATH,19,4821.12,-4848.942,25.79934,0,0,0,0,100,0), +(@PATH,20,4823.87,-4847.192,25.54934,0,0,0,0,100,0), +(@PATH,21,4825.23,-4846.544,25.45987,5.550147,0,0,0,100,0), +(@PATH,22,4823.903,-4847.049,25.59635,0,0,0,0,100,0), +(@PATH,23,4821.653,-4848.049,25.59635,0,0,0,0,100,0), +(@PATH,24,4820.403,-4848.549,25.59635,0,0,0,0,100,0), +(@PATH,25,4816.653,-4850.049,25.59635,0,0,0,0,100,0), +(@PATH,26,4814.903,-4850.549,25.59635,0,0,0,0,100,0), +(@PATH,27,4803.903,-4854.799,25.84635,0,0,0,0,100,0), +(@PATH,28,4800.153,-4856.299,25.84635,0,0,0,0,100,0), +(@PATH,29,4799.153,-4856.799,25.84635,0,0,0,0,100,0), +(@PATH,30,4795.174,-4858.254,25.82136,0,0,0,0,100,0), +(@PATH,31,4793.924,-4857.254,25.82136,0,0,0,0,100,0), +(@PATH,32,4786.924,-4851.004,25.82136,0,0,0,0,100,0), +(@PATH,33,4783.924,-4848.504,25.57136,0,0,0,0,100,0), +(@PATH,34,4775.606,-4841.151,25.45528,0,0,0,0,100,0), +(@PATH,35,4775.606,-4841.151,25.45528,2.513274,0,0,0,100,0); + +SET @NPC := 86437; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4766.285,`position_y`=-4851.221,`position_z`=25.88538 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,4766.285,-4851.221,25.88538,0,0,0,0,100,0), +(@PATH,2,4764.035,-4852.971,25.63538,0,0,0,0,100,0), +(@PATH,3,4762.535,-4853.971,25.38538,0,0,0,0,100,0), +(@PATH,4,4761.535,-4853.971,25.38538,0,0,0,0,100,0), +(@PATH,5,4760.035,-4853.971,25.63538,0,0,0,0,100,0), +(@PATH,6,4758.785,-4853.971,26.13538,0,0,0,0,100,0), +(@PATH,7,4758.035,-4854.221,26.38538,0,0,0,0,100,0), +(@PATH,8,4756.035,-4854.471,26.38538,0,0,0,0,100,0), +(@PATH,9,4753.785,-4854.971,26.38538,0,0,0,0,100,0), +(@PATH,10,4752.035,-4855.221,26.38538,0,0,0,0,100,0), +(@PATH,11,4748.035,-4856.471,26.38538,0,0,0,0,100,0), +(@PATH,12,4745.785,-4856.721,26.38538,0,0,0,0,100,0), +(@PATH,13,4739.535,-4857.221,26.38538,0,0,0,0,100,0), +(@PATH,14,4733.245,-4857.637,26.4931,0,0,0,0,100,0), +(@PATH,15,4733.245,-4857.637,26.4931,2.617994,0,0,0,100,0), +(@PATH,16,4737.667,-4857.782,26.4303,0,0,0,0,100,0), +(@PATH,17,4739.417,-4857.782,26.4303,0,0,0,0,100,0), +(@PATH,18,4745.917,-4857.782,26.4303,0,0,0,0,100,0), +(@PATH,19,4747.667,-4857.782,26.1803,0,0,0,0,100,0), +(@PATH,20,4750.917,-4857.782,26.1803,0,0,0,0,100,0), +(@PATH,21,4752.667,-4857.782,26.1803,0,0,0,0,100,0), +(@PATH,22,4755.667,-4857.782,26.1803,0,0,0,0,100,0), +(@PATH,23,4755.755,-4857.606,26.16596,0,0,0,0,100,0), +(@PATH,24,4758.755,-4857.606,25.91596,0,0,0,0,100,0), +(@PATH,25,4761.005,-4855.856,25.66596,0,0,0,0,100,0), +(@PATH,26,4762.505,-4854.356,25.41596,0,0,0,0,100,0), +(@PATH,27,4764.255,-4853.106,25.66596,0,0,0,0,100,0), +(@PATH,28,4766.005,-4851.606,25.66596,0,0,0,0,100,0); + +-- Shade of Arugal SAI +SET @ENTRY := 27018; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,1,0,100,0,1000,1000,20000,20000,11,48185,0,0,0,0,0,19,27024,20,0,0,0,0,0,"Shade of Arugal - Out of Combat - Cast 'Arugal Channel'"), +(@ENTRY,0,1,0,0,0,100,0,2000,3000,2000,3000,11,53086,0,0,0,0,0,2,0,0,0,0,0,0,0,"Shade of Arugal - In Combat - Cast 'Shadow Bolt'"); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceGroup`=1 AND `SourceEntry`=48185; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(13, 1, 48185, 0, 0, 31, 0, 3, 27024, 0, 0, 0, 0, '', 'Arugal Channel only target Cultists'); |