DB/Creature: Winterspring Movement

1 files changed, 254 insertions, 0 deletions

diff --git a/sql/updates/world/2015_03_16_04_world.sql b/sql/updates/world/2015_03_16_04_world.sql
new file mode 100644
index 00000000000..099715b23b2
--- /dev/null
+++ b/sql/updates/world/2015_03_16_04_world.sql
@@ -0,0 +1,254 @@
+-- 
+-- Pathing for Entry: 7453 'TDB FORMAT'
+SET @NPC := 277263;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=7137.471,`position_y`=-4932.94,`position_z`=709.7938 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,7137.471,-4932.94,709.7938,0,0,0,0,100,0),
+(@PATH,2,7116.508,-4952.124,712.9629,0,0,0,0,100,0),
+(@PATH,3,7105.256,-4976.592,718.3862,0,0,0,0,100,0);
+-- 0x1C3998002007474000008A0000666599 .go 7137.471 -4932.94 709.7938
+-- Pathing for Entry: 7453 'TDB FORMAT'
+SET @NPC := 277262;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=7105.344,`position_y`=-4976.538,`position_z`=718.2935 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,7105.344,-4976.538,718.2935,0,0,0,0,100,0),
+(@PATH,2,7103.528,-4980.293,718.7722,0,0,0,0,100,0),
+(@PATH,3,7061.037,-5037.344,712.4945,0,0,0,0,100,0),
+(@PATH,4,7089.595,-5007.938,718.2341,0,0,0,0,100,0),
+(@PATH,5,7100.142,-4988.004,718.8002,0,0,0,0,100,0),
+(@PATH,6,7115.443,-4953.817,713.5366,0,0,0,0,100,0),
+(@PATH,7,7133.554,-4937.197,710.8986,0,0,0,0,100,0),
+(@PATH,8,7157.135,-4911.291,707.8239,0,0,0,0,100,0),
+(@PATH,9,7170.106,-4886.438,703.9925,0,0,0,0,100,0),
+(@PATH,10,7189.345,-4858.223,699.2946,0,0,0,0,100,0),
+(@PATH,11,7172.859,-4881.475,703.1406,0,0,0,0,100,0),
+(@PATH,12,7159.049,-4908.233,707.64,0,0,0,0,100,0),
+(@PATH,13,7137.446,-4933.033,709.887,0,0,0,0,100,0),
+(@PATH,14,7116.485,-4952.148,712.9681,0,0,0,0,100,0),
+(@PATH,15,7105.237,-4976.608,718.3914,0,0,0,0,100,0),
+(@PATH,16,7103.582,-4980.233,718.576,0,0,0,0,100,0);
+-- 0x1C3998002007474000008A0000666599 .go 7105.344 -4976.538 718.2935
+DELETE FROM `creature_addon` WHERE `guid` IN (277512, 277520, 277514);
+INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES
+(277512, 0, 0, 0, 0, 1, NULL),
+(277520, 0, 0, 0, 0, 1, NULL),
+(277514, 0, 0, 0, 0, 1, NULL);
+-- Pathing for Entry: 7458 'TDB FORMAT'
+SET @NPC := 276911;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=6566.325,`position_y`=-5201.914,`position_z`=764.9429 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,6566.325,-5201.914,764.9429,0,0,0,0,100,0),
+(@PATH,2,6575.174,-5177.188,769.7847,0,0,0,0,100,0),
+(@PATH,3,6564.959,-5128.947,770.9417,0,0,0,0,100,0),
+(@PATH,4,6575.966,-5172.782,769.9459,0,0,0,0,100,0),
+(@PATH,5,6568.467,-5194.482,766.7494,0,0,0,0,100,0),
+(@PATH,6,6578.56,-5207.592,766.5796,0,0,0,0,100,0),
+(@PATH,7,6606.4,-5208.795,766.1869,0,0,0,0,100,0),
+(@PATH,8,6629.916,-5221.93,761.009,0,0,0,0,100,0),
+(@PATH,9,6644.289,-5255.269,752.8387,0,0,0,0,100,0),
+(@PATH,10,6641.589,-5279.789,753.8105,0,0,0,0,100,0),
+(@PATH,11,6645.497,-5260.147,753.0979,0,0,0,0,100,0),
+(@PATH,12,6633.773,-5226.286,759.0981,0,0,0,0,100,0),
+(@PATH,13,6614.56,-5210.234,765.7307,0,0,0,0,100,0),
+(@PATH,14,6589.438,-5210.639,767.4576,0,0,0,0,100,0),
+(@PATH,15,6566.303,-5201.964,764.929,0,0,0,0,100,0),
+(@PATH,16,6575.107,-5177.374,769.6774,0,0,0,0,100,0);
+-- 0x1C3998002007488000008A000064E93B .go 6566.325 -5201.914 764.9429
+-- Pathing for Entry: 10807 'TDB FORMAT'
+SET @NPC := 276740;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=5648.751,`position_y`=-4618.699,`position_z`=771.1746 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,5648.751,-4618.699,771.1746,0,0,0,0,100,0),
+(@PATH,2,5689.12,-4680.393,778.8788,0,0,0,0,100,0),
+(@PATH,3,5701.02,-4691.902,780.7781,0,0,0,0,100,0),
+(@PATH,4,5709.774,-4700.304,780.6177,0,0,0,0,100,0),
+(@PATH,5,5739.681,-4724.907,777.1263,0,0,0,0,100,0),
+(@PATH,6,5761.202,-4736.823,776.7352,0,0,0,0,100,0),
+(@PATH,7,5788.845,-4754.466,776.5774,0,0,0,0,100,0),
+(@PATH,8,5813.559,-4749.592,770.7727,0,0,0,0,100,0),
+(@PATH,9,5846.619,-4732.072,761.0168,0,0,0,0,100,0),
+(@PATH,10,5855.859,-4703.766,758.3209,0,0,0,0,100,0),
+(@PATH,11,5863.439,-4687.21,757.4078,0,0,0,0,100,0),
+(@PATH,12,5873.563,-4665.864,752.4548,0,0,0,0,100,0),
+(@PATH,13,5900.618,-4633.269,736.8805,0,0,0,0,100,0),
+(@PATH,14,5914.753,-4606.957,729.6884,0,0,0,0,100,0),
+(@PATH,15,5936.95,-4569.866,717.9836,0,0,0,0,100,0),
+(@PATH,16,5950.268,-4542.576,715.5675,0,0,0,0,100,0),
+(@PATH,17,5955.396,-4527.396,713.515,0,0,0,0,100,0),
+(@PATH,18,5961.662,-4503.704,710.3988,0,0,0,0,100,0),
+(@PATH,19,5967.232,-4485.815,706.7623,0,0,0,0,100,0),
+(@PATH,20,5979.453,-4458.936,707.3737,0,0,0,0,100,0),
+(@PATH,21,6006.054,-4422.591,708.9871,0,0,0,0,100,0),
+(@PATH,22,6014.302,-4408.834,711.2253,0,0,0,0,100,0),
+(@PATH,23,6020.136,-4398.585,712.5538,0,0,0,0,100,0),
+(@PATH,24,6029.516,-4378.594,715.494,0,0,0,0,100,0),
+(@PATH,25,6051.132,-4358.396,716.563,0,0,0,0,100,0),
+(@PATH,26,6069.048,-4337.034,722.8481,0,0,0,0,100,0),
+(@PATH,27,6083.582,-4330.367,725.8171,0,0,0,0,100,0),
+(@PATH,28,6113.54,-4323.066,733.0433,0,0,0,0,100,0),
+(@PATH,29,6130.411,-4316.812,736.7444,0,0,0,0,100,0),
+(@PATH,30,6156.093,-4311.238,736.7893,0,0,0,0,100,0),
+(@PATH,31,6213.947,-4293.813,733.0521,0,0,0,0,100,0),
+(@PATH,32,6215.008,-4264.572,735.2877,0,0,0,0,100,0),
+(@PATH,33,6226.857,-4249.232,738.0566,0,0,0,0,100,0),
+(@PATH,34,6253.248,-4226.368,735.1916,0,0,0,0,100,0),
+(@PATH,35,6273.733,-4225.47,727.8517,0,0,0,0,100,0),
+(@PATH,36,6284.836,-4225.425,726.1979,0,0,0,0,100,0),
+(@PATH,37,6305.368,-4225.753,725.4176,0,0,0,0,100,0),
+(@PATH,38,6334.949,-4217.311,720.7787,0,0,0,0,100,0),
+(@PATH,39,6351.212,-4210.416,716.0107,0,0,0,0,100,0),
+(@PATH,40,6376.162,-4192.59,707.6775,0,0,0,0,100,0),
+(@PATH,41,6395.101,-4179.662,703.7349,0,0,0,0,100,0),
+(@PATH,42,6381.396,-4188.968,706.1343,0,0,0,0,100,0),
+(@PATH,43,6353.885,-4208.841,714.7299,0,0,0,0,100,0),
+(@PATH,44,6338.441,-4215.688,719.8574,0,0,0,0,100,0),
+(@PATH,45,6314.177,-4224.836,724.3856,0,0,0,0,100,0),
+(@PATH,46,6301.717,-4225.433,725.8468,0,0,0,0,100,0),
+(@PATH,47,6275.718,-4225.523,727.0695,0,0,0,0,100,0),
+(@PATH,48,6255.941,-4225.716,734.1918,0,0,0,0,100,0),
+(@PATH,49,6235.572,-4239.381,738.0726,0,0,0,0,100,0),
+(@PATH,50,6217.472,-4260.318,736.3972,0,0,0,0,100,0),
+(@PATH,51,6214.817,-4292.466,733.4384,0,0,0,0,100,0),
+(@PATH,52,6183.471,-4306.068,736.7473,0,0,0,0,100,0),
+(@PATH,53,6152.146,-4311.395,736.5862,0,0,0,0,100,0),
+(@PATH,54,6115.85,-4322.032,733.5704,0,0,0,0,100,0),
+(@PATH,55,6096.116,-4326.589,726.9081,0,0,0,0,100,0),
+(@PATH,56,6072.762,-4334.344,723.8291,0,0,0,0,100,0),
+(@PATH,57,6054.525,-4355.155,717.3843,0,0,0,0,100,0),
+(@PATH,58,6045.726,-4362.94,715.9363,0,0,0,0,100,0),
+(@PATH,59,6022.907,-4393.988,713.5073,0,0,0,0,100,0),
+(@PATH,60,6016.278,-4405.039,711.9446,0,0,0,0,100,0),
+(@PATH,61,6008.032,-4420.086,709.5507,0,0,0,0,100,0),
+(@PATH,62,5986.144,-4448.363,708.0036,0,0,0,0,100,0),
+(@PATH,63,5973.533,-4469.824,706.2904,0,0,0,0,100,0),
+(@PATH,64,5962.696,-4501.021,709.6469,0,0,0,0,100,0),
+(@PATH,65,5958.108,-4519.2,712.8943,0,0,0,0,100,0),
+(@PATH,66,5951.027,-4540.779,715.1692,0,0,0,0,100,0),
+(@PATH,67,5940.734,-4563.251,716.6089,0,0,0,0,100,0),
+(@PATH,68,5916.599,-4603.511,727.8939,0,0,0,0,100,0),
+(@PATH,69,5903.969,-4628.674,735.8933,0,0,0,0,100,0),
+(@PATH,70,5876.024,-4662.081,750.1125,0,0,0,0,100,0),
+(@PATH,71,5866.109,-4682.41,756.9871,0,0,0,0,100,0),
+(@PATH,72,5860.89,-4692.448,757.6022,0,0,0,0,100,0),
+(@PATH,73,5852.626,-4718.677,760.3339,0,0,0,0,100,0),
+(@PATH,74,5816.978,-4747.931,769.589,0,0,0,0,100,0),
+(@PATH,75,5794.675,-4756.42,776.863,0,0,0,0,100,0),
+(@PATH,76,5787.91,-4753.686,776.4739,0,0,0,0,100,0),
+(@PATH,77,5742.113,-4726.395,776.4882,0,0,0,0,100,0),
+(@PATH,78,5717.964,-4712.427,780.866,0,0,0,0,100,0),
+(@PATH,79,5716.192,-4711.237,780.9797,0,0,0,0,100,0),
+(@PATH,80,5691.473,-4682.99,779.7195,0,0,0,0,100,0),
+(@PATH,81,5679.313,-4650.769,771.5784,0,0,0,0,100,0),
+(@PATH,82,5678.228,-4647.97,771.2499,0,0,0,0,100,0),
+(@PATH,83,5626.609,-4580.739,771.4092,0,0,0,0,100,0),
+(@PATH,84,5622.033,-4555.714,764.3365,0,0,0,0,100,0),
+(@PATH,85,5614.873,-4538.934,761.8027,0,0,0,0,100,0),
+(@PATH,86,5588.495,-4500.353,760.0676,0,0,0,0,100,0),
+(@PATH,87,5564.071,-4494.821,758.7393,0,0,0,0,100,0),
+(@PATH,88,5576.771,-4495.759,759.148,0,0,0,0,100,0),
+(@PATH,89,5600.532,-4515.448,761.4238,0,0,0,0,100,0),
+(@PATH,90,5620.198,-4550.56,763.2811,0,0,0,0,100,0),
+(@PATH,91,5624.978,-4576.957,770.4901,0,0,0,0,100,0),
+(@PATH,92,5645.084,-4612.734,771.1481,0,0,0,0,100,0),
+(@PATH,93,5648.815,-4618.739,771.1803,0,0,0,0,100,0),
+(@PATH,94,5689.149,-4680.177,778.8832,0,0,0,0,100,0),
+(@PATH,95,5700.999,-4691.828,780.7064,0,0,0,0,100,0),
+(@PATH,96,5709.821,-4700.319,780.6168,0,0,0,0,100,0);
+-- 0x1C399800200A8DC000008A0000666232 .go 5648.751 -4618.699 771.1746
+-- Pathing for Entry: 11754 'TDB FORMAT'
+SET @NPC := 277014;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=6720.784,`position_y`=-4657.231,`position_z`=721.1815 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,6720.784,-4657.231,721.1815,0,0,0,0,100,0),
+(@PATH,2,6712.688,-4694.593,721.6722,0,0,0,0,100,0),
+(@PATH,3,6742.375,-4669.703,722.5077,0,0,0,0,100,0),
+(@PATH,4,6751.504,-4670.746,723.8561,0,0,0,0,100,0),
+(@PATH,5,6750.167,-4670.442,723.4701,0,0,0,0,100,0),
+(@PATH,6,6729.87,-4670.181,721.3218,0,0,0,0,100,0),
+(@PATH,7,6723.56,-4670.309,721.1548,0,0,0,0,100,0),
+(@PATH,8,6712.701,-4694.66,721.6473,0,0,0,0,100,0),
+(@PATH,9,6720.992,-4656.926,721.0239,0,0,0,0,100,0),
+(@PATH,10,6727.398,-4634.59,721.2974,0,0,0,0,100,0),
+(@PATH,11,6727.289,-4634.758,721.0771,0,0,0,0,100,0),
+(@PATH,12,6727.393,-4634.646,721.2531,0,0,0,0,100,0),
+(@PATH,13,6720.8,-4657.175,721.1818,0,0,0,0,100,0);
+-- 0x1C399800200B7A8000003C00005D1BC1 .go 6720.784 -4657.231 721.1815
+-- Pathing for Entry: 11190 'TDB FORMAT'
+SET @NPC := 277021;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=6718.815,`position_y`=-4649.531,`position_z`=721.1697 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,6718.815,-4649.531,721.1697,0,0,0,0,100,0),
+(@PATH,2,6718.783,-4649.535,721.4225,0,0,0,0,100,0),
+(@PATH,3,6719.614,-4656.521,721.302,0,0,0,0,100,0),
+(@PATH,4,6717,-4663.771,721.069,0,0,0,0,100,0),
+(@PATH,5,6716.95,-4663.692,720.99,0,0,0,0,100,0),
+(@PATH,6,6717.275,-4663.325,721.0589,0,0,0,0,100,0);
+-- 0x1C399800200AED8000003C00005AED84 .go 6718.815 -4649.531 721.1697
+-- Pathing for Entry: 11190 'TDB FORMAT'
+SET @NPC := 277061;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=6728.219,`position_y`=-4670.128,`position_z`=721.2576 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,6728.219,-4670.128,721.2576,0,0,0,0,100,0),
+(@PATH,2,6743.886,-4670.578,722.9776,0,0,0,0,100,0),
+(@PATH,3,6756.655,-4670.659,724.0643,0,0,0,0,100,0),
+(@PATH,4,6757.912,-4670.535,724.0609,0,0,0,0,100,0),
+(@PATH,5,6742.673,-4666.933,722.8669,0,0,0,0,100,0),
+(@PATH,6,6736.266,-4663.654,721.8529,0,0,0,0,100,0),
+(@PATH,7,6733.673,-4655.659,721.4637,0,0,0,0,100,0),
+(@PATH,8,6734.015,-4654.013,721.61,0,0,0,0,100,0),
+(@PATH,9,6738.349,-4643.12,721.8862,0,0,0,0,100,0),
+(@PATH,10,6749.037,-4650.289,724.4041,0,0,0,0,100,0),
+(@PATH,11,6749.985,-4651.393,724.5129,0,0,0,0,100,0),
+(@PATH,12,6747.223,-4666.195,724.0955,0,0,0,0,100,0),
+(@PATH,13,6742.063,-4667.552,722.8929,0,0,0,0,100,0),
+(@PATH,14,6733.769,-4665.354,721.3834,0,0,0,0,100,0),
+(@PATH,15,6732.711,-4664.764,721.2361,0,0,0,0,100,0),
+(@PATH,16,6725.651,-4656.119,721.0077,0,0,0,0,100,0),
+(@PATH,17,6723.583,-4648.15,721.3789,0,0,0,0,100,0),
+(@PATH,18,6725.607,-4639.14,721.3022,0,0,0,0,100,0),
+(@PATH,19,6725.688,-4618.812,721.2241,0,0,0,0,100,0),
+(@PATH,20,6726.158,-4620.798,721.011,0,0,0,0,100,0),
+(@PATH,21,6725.985,-4632.64,721.314,0,0,0,0,100,0),
+(@PATH,22,6722.886,-4647.297,721.2972,0,0,0,0,100,0),
+(@PATH,23,6719.054,-4660.822,721.2487,0,0,0,0,100,0),
+(@PATH,24,6718.09,-4669.577,721.0381,0,0,0,0,100,0),
+(@PATH,25,6717.658,-4679.682,721.2125,0,0,0,0,100,0),
+(@PATH,26,6714.254,-4691.013,721.465,0,0,0,0,100,0),
+(@PATH,27,6718.247,-4679.584,721.3595,0,0,0,0,100,0),
+(@PATH,28,6724.794,-4671.702,721.1953,0,0,0,0,100,0),
+(@PATH,29,6728.427,-4670.179,721.2579,0,0,0,0,100,0),
+(@PATH,30,6743.787,-4670.586,722.9696,0,0,0,0,100,0),
+(@PATH,31,6756.599,-4670.691,724.1053,0,0,0,0,100,0),
+(@PATH,32,6757.838,-4670.533,724.0765,0,0,0,0,100,0),
+(@PATH,33,6742.766,-4666.877,722.8699,0,0,0,0,100,0);
+-- 0x1C399800200AED8000003C0001DAED84 .go 6728.219 -4670.128 721.2576
+UPDATE `creature` SET `spawndist`=5, `MovementType`=1 WHERE `guid` IN (277028, 277016, 277002);
+UPDATE `creature` SET `spawndist`=10, `MovementType`=1 WHERE `guid` IN (277004);