diff options
| -rw-r--r-- | sql/updates/world/2015_05_31_05_world.sql | 207 |
1 files changed, 207 insertions, 0 deletions
diff --git a/sql/updates/world/2015_05_31_05_world.sql b/sql/updates/world/2015_05_31_05_world.sql new file mode 100644 index 00000000000..bba678d60d6 --- /dev/null +++ b/sql/updates/world/2015_05_31_05_world.sql @@ -0,0 +1,207 @@ +-- Winterskorn Hunter +SET @CGUID := 16403; +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+3; +INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `MovementType`) VALUES +(@CGUID+0, 26663, 571, 1, 1, 869.8931, -4221.893, 170.3676, 2.083399, 120, 0, 0), +(@CGUID+1, 24076, 571, 1, 1, 869.4127, -4231.234, 172.1629, 2.083083, 120, 0, 0), +(@CGUID+2, 26663, 571, 1, 1, 869.4127, -4231.234, 172.1629, 2.083083, 120, 0, 0), +(@CGUID+3, 24076, 571, 1, 1, 1010.354, -4123.357, 172.1629, 2.083083, 120, 0, 0); + +DELETE FROM `creature_formations` WHERE `leaderGUID` IN (@CGUID, @CGUID+2); +INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(@CGUID, @CGUID, 0, 0, 2, 0, 0), +(@CGUID, @CGUID+1, 2, 90, 0, 0, 0), +(@CGUID+2, @CGUID+2, 0, 0, 2, 0, 0), +(@CGUID+2, @CGUID+3, 2, 90, 0, 0, 0); + +SET @NPC := @CGUID; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=864.7987,`position_y`=-4212.048,`position_z`=171.1561 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,864.7987,-4212.048,171.1561,0,0,0,0,100,0), +(@PATH,2,867.7987,-4194.548,170.6561,0,0,0,0,100,0), +(@PATH,3,869.3953,-4186.757,170.9983,0,0,0,0,100,0), +(@PATH,4,871.8953,-4182.507,171.2483,0,0,0,0,100,0), +(@PATH,5,872.6453,-4181.007,171.9983,0,0,0,0,100,0), +(@PATH,6,876.8981,-4172.719,172.1371,0,0,0,0,100,0), +(@PATH,7,886.1481,-4163.469,172.6371,0,0,0,0,100,0), +(@PATH,8,902.6481,-4146.469,172.1371,0,0,0,0,100,0), +(@PATH,9,902.7696,-4146.216,172.1291,0,0,0,0,100,0), +(@PATH,10,903.7696,-4145.216,171.8791,0,0,0,0,100,0), +(@PATH,11,905.7696,-4144.466,171.3791,0,0,0,0,100,0), +(@PATH,12,908.2696,-4143.216,170.6291,0,0,0,0,100,0), +(@PATH,13,910.2696,-4142.216,170.1291,0,0,0,0,100,0), +(@PATH,14,912.0196,-4141.466,169.3791,0,0,0,0,100,0), +(@PATH,15,913.7696,-4140.466,168.6291,0,0,0,0,100,0), +(@PATH,16,917.5196,-4138.716,168.3791,0,0,0,0,100,0), +(@PATH,17,920.0196,-4137.466,167.6291,0,0,0,0,100,0), +(@PATH,18,930.7696,-4132.466,167.1291,0,0,0,0,100,0), +(@PATH,19,938.0196,-4129.216,166.6291,0,0,0,0,100,0), +(@PATH,20,941.5196,-4127.466,165.8791,0,0,0,0,100,0), +(@PATH,21,904.5845,-4145.06,171.5024,0.4463101,5000,0,0,100,0), +(@PATH,22,906.6863,-4144.064,170.8976,0,0,0,0,100,0), +(@PATH,23,909.4363,-4142.564,170.3976,0,0,0,0,100,0), +(@PATH,24,911.1863,-4141.814,169.6476,0,0,0,0,100,0), +(@PATH,25,913.9363,-4140.564,168.6476,0,0,0,0,100,0), +(@PATH,26,917.4363,-4138.814,168.1476,0,0,0,0,100,0), +(@PATH,27,920.1863,-4137.564,167.6476,0,0,0,0,100,0), +(@PATH,28,930.6863,-4132.564,167.1476,0,0,0,0,100,0), +(@PATH,29,937.9363,-4129.064,166.6476,0,0,0,0,100,0), +(@PATH,30,940.6863,-4127.814,165.8976,0,0,0,0,100,0), +(@PATH,31,908.2701,-4143.178,170.7699,0,0,0,0,100,0), +(@PATH,32,909.1838,-4142.718,170.4703,0,0,0,0,100,0), +(@PATH,33,910.9338,-4141.718,169.7203,0,0,0,0,100,0), +(@PATH,34,914.6838,-4140.218,168.9703,0,0,0,0,100,0), +(@PATH,35,917.4338,-4138.718,168.2203,0,0,0,0,100,0), +(@PATH,36,920.1838,-4137.468,167.7203,0,0,0,0,100,0), +(@PATH,37,930.6838,-4132.718,166.9703,0,0,0,0,100,0), +(@PATH,38,937.9338,-4129.218,166.4703,0,0,0,0,100,0), +(@PATH,39,941.4338,-4127.468,165.9703,0,0,0,0,100,0), +(@PATH,40,909.7615,-4142.584,169.8862,0.4461821,5000,0,0,100,0), +(@PATH,41,911.8156,-4141.577,169.3572,0,0,0,0,100,0), +(@PATH,42,915.3156,-4139.827,168.6072,0,0,0,0,100,0), +(@PATH,43,918.0656,-4138.577,167.8572,0,0,0,0,100,0), +(@PATH,44,924.5656,-4135.577,167.3572,0,0,0,0,100,0), +(@PATH,45,935.0656,-4130.577,166.8572,0,0,0,0,100,0), +(@PATH,46,940.5656,-4128.077,166.1072,0,0,0,0,100,0), +(@PATH,47,943.0656,-4126.577,165.3572,0,0,0,0,100,0), +(@PATH,48,913.4222,-4140.722,169.1442,0,0,0,0,100,0), +(@PATH,49,915.3442,-4139.718,168.3767,0,0,0,0,100,0), +(@PATH,50,918.0942,-4138.468,167.6267,0,0,0,0,100,0), +(@PATH,51,924.3442,-4135.468,167.1267,0,0,0,0,100,0), +(@PATH,52,934.8442,-4130.468,166.8767,0,0,0,0,100,0), +(@PATH,53,940.3442,-4127.968,166.1267,0,0,0,0,100,0), +(@PATH,54,943.0942,-4126.718,165.3767,0,0,0,0,100,0), +(@PATH,55,914.8909,-4140.135,168.3818,0.4461821,5000,0,0,100,0), +(@PATH,56,919.6302,-4137.853,167.8549,0,0,0,0,100,0), +(@PATH,57,925.8802,-4134.853,167.1049,0,0,0,0,100,0), +(@PATH,58,934.6302,-4130.603,166.6049,0,0,0,0,100,0), +(@PATH,59,940.1302,-4128.103,166.1049,0,0,0,0,100,0), +(@PATH,60,942.8802,-4126.853,165.3549,0,0,0,0,100,0); + +SET @NPC := @CGUID+2; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=1010.354,`position_y`=-4123.357,`position_z`=156.7801 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,1010.354,-4123.357,156.7801,0,0,0,0,100,0), +(@PATH,2,1024.104,-4121.607,156.2801,0,0,0,0,100,0), +(@PATH,3,1031.805,-4120.534,156.5064,0,0,0,0,100,0), +(@PATH,4,1038.805,-4124.284,156.2564,0,0,0,0,100,0), +(@PATH,5,1049.638,-4130.334,156.4905,0,0,0,0,100,0), +(@PATH,6,1055.138,-4138.584,155.9905,0,0,0,0,100,0), +(@PATH,7,1056.388,-4141.084,155.2405,0,0,0,0,100,0), +(@PATH,8,1057.638,-4142.584,153.4905,0,0,0,0,100,0), +(@PATH,9,1058.638,-4144.334,152.7405,0,0,0,0,100,0), +(@PATH,10,1059.138,-4145.084,151.7405,0,0,0,0,100,0), +(@PATH,11,1060.138,-4146.834,150.7405,0,0,0,0,100,0), +(@PATH,12,1062.888,-4151.084,151.4905,0,0,0,0,100,0), +(@PATH,13,1064.638,-4153.584,152.4905,0,0,0,0,100,0), +(@PATH,14,1064.735,-4153.911,152.6306,0,0,0,0,100,0), +(@PATH,15,1066.735,-4156.911,153.6306,0,0,0,0,100,0), +(@PATH,16,1068.735,-4160.411,154.1306,0,0,0,0,100,0), +(@PATH,17,1078.735,-4179.661,154.6306,0,0,0,0,100,0), +(@PATH,18,1081.652,-4185.499,155.3617,0,0,0,0,100,0), +(@PATH,19,1081.902,-4189.499,155.8617,0,0,0,0,100,0), +(@PATH,20,1082.152,-4205.499,155.3617,0,0,0,0,100,0), +(@PATH,21,1082.402,-4220.249,155.8617,0,0,0,0,100,0), +(@PATH,22,1082.652,-4227.249,156.3617,0,0,0,0,100,0), +(@PATH,23,1082.652,-4232.249,157.1117,0,0,0,0,100,0), +(@PATH,24,1082.636,-4232.529,157.1391,0,0,0,0,100,0), +(@PATH,25,1082.636,-4234.279,157.3891,0,0,0,0,100,0), +(@PATH,26,1081.136,-4236.779,158.1391,0,0,0,0,100,0), +(@PATH,27,1078.636,-4240.029,158.8891,0,0,0,0,100,0), +(@PATH,28,1077.136,-4242.529,159.6391,0,0,0,0,100,0), +(@PATH,29,1074.636,-4245.779,160.3891,0,0,0,0,100,0), +(@PATH,30,1072.386,-4248.779,161.1391,0,0,0,0,100,0), +(@PATH,31,1069.386,-4253.529,161.6391,0,0,0,0,100,0), +(@PATH,32,1061.036,-4264.879,161.6266,0,0,0,0,100,0), +(@PATH,33,1059.286,-4262.629,162.3766,0,0,0,0,100,0), +(@PATH,34,1057.036,-4259.379,162.8766,0,0,0,0,100,0), +(@PATH,35,1051.786,-4252.379,163.3766,0,0,0,0,100,0), +(@PATH,36,1051.524,-4252.102,163.3611,0,0,0,0,100,0), +(@PATH,37,1051.024,-4251.102,163.6111,0,0,0,0,100,0), +(@PATH,38,1047.524,-4247.352,164.3611,0,0,0,0,100,0), +(@PATH,39,1035.274,-4233.352,163.6111,0,0,0,0,100,0), +(@PATH,40,1032.032,-4229.585,163.0954,0,0,0,0,100,0), +(@PATH,41,1022.532,-4224.085,162.5954,0,0,0,0,100,0), +(@PATH,42,1018.532,-4221.585,162.0954,0,0,0,0,100,0), +(@PATH,43,1015.032,-4219.585,161.5954,0,0,0,0,100,0), +(@PATH,44,1010.323,-4216.906,161.2029,0,0,0,0,100,0), +(@PATH,45,1005.323,-4216.656,161.7029,0,0,0,0,100,0), +(@PATH,46,1003.323,-4216.656,162.2029,0,0,0,0,100,0), +(@PATH,47,1000.573,-4216.406,162.9529,0,0,0,0,100,0), +(@PATH,48,996.5729,-4216.406,163.4529,0,0,0,0,100,0), +(@PATH,49,990.4298,-4216.181,163.648,0,0,0,0,100,0), +(@PATH,50,985.9298,-4218.431,162.898,0,0,0,0,100,0), +(@PATH,51,983.4298,-4219.681,162.648,0,0,0,0,100,0), +(@PATH,52,980.9298,-4220.931,161.898,0,0,0,0,100,0), +(@PATH,53,978.1798,-4221.931,161.148,0,0,0,0,100,0), +(@PATH,54,972.6798,-4224.431,161.898,0,0,0,0,100,0), +(@PATH,55,972.4193,-4224.729,162.0995,0,0,0,0,100,0), +(@PATH,56,970.9193,-4225.479,162.3495,0,0,0,0,100,0), +(@PATH,57,968.4193,-4228.479,162.8495,0,0,0,0,100,0), +(@PATH,58,965.4193,-4232.479,163.3495,0,0,0,0,100,0), +(@PATH,59,963.4193,-4234.479,163.8495,0,0,0,0,100,0), +(@PATH,60,959.4193,-4238.979,164.5995,0,0,0,0,100,0), +(@PATH,61,959.306,-4239.212,164.8905,0,0,0,0,100,0), +(@PATH,62,957.056,-4241.712,165.3905,0,0,0,0,100,0), +(@PATH,63,952.806,-4244.462,166.1405,0,0,0,0,100,0), +(@PATH,64,948.556,-4246.962,166.3905,0,0,0,0,100,0), +(@PATH,65,943.806,-4249.962,167.1405,0,0,0,0,100,0), +(@PATH,66,936.056,-4254.712,167.8905,0,0,0,0,100,0), +(@PATH,67,935.7786,-4254.604,167.9532,0,0,0,0,100,0), +(@PATH,68,934.2786,-4255.604,168.2032,0,0,0,0,100,0), +(@PATH,69,930.2786,-4254.604,168.9532,0,0,0,0,100,0), +(@PATH,70,926.5286,-4253.604,169.4532,0,0,0,0,100,0), +(@PATH,71,918.0286,-4251.354,170.2032,0,0,0,0,100,0), +(@PATH,72,914.2786,-4250.354,170.7032,0,0,0,0,100,0), +(@PATH,73,914.0798,-4250.134,171.0802,0,0,0,0,100,0), +(@PATH,74,912.3298,-4249.634,171.3302,0,0,0,0,100,0), +(@PATH,75,899.8298,-4246.134,171.5802,0,0,0,0,100,0), +(@PATH,76,895.3298,-4245.134,172.0802,0,0,0,0,100,0), +(@PATH,77,891.3298,-4244.134,172.8302,0,0,0,0,100,0), +(@PATH,78,880.7011,-4240.813,172.8416,0,0,0,0,100,0), +(@PATH,79,876.2011,-4233.063,172.3416,0,0,0,0,100,0), +(@PATH,80,873.7011,-4227.813,171.8416,0,0,0,0,100,0), +(@PATH,81,871.7011,-4224.563,171.3416,0,0,0,0,100,0), +(@PATH,82,869.7011,-4221.063,170.5916,0,0,0,0,100,0), +(@PATH,83,864.8547,-4212.148,171.1479,0,0,0,0,100,0), +(@PATH,84,867.8547,-4194.648,170.6479,0,0,0,0,100,0), +(@PATH,85,869.3699,-4186.896,170.9984,0,0,0,0,100,0), +(@PATH,86,871.8699,-4182.396,171.2484,0,0,0,0,100,0), +(@PATH,87,872.6199,-4180.896,171.9984,0,0,0,0,100,0), +(@PATH,88,877.054,-4172.754,172.1564,0,0,0,0,100,0), +(@PATH,89,886.054,-4163.504,172.6564,0,0,0,0,100,0), +(@PATH,90,902.554,-4146.504,172.1564,0,0,0,0,100,0), +(@PATH,91,902.903,-4146.336,172.1329,0,0,0,0,100,0), +(@PATH,92,903.903,-4145.336,171.8829,0,0,0,0,100,0), +(@PATH,93,905.653,-4144.336,171.3829,0,0,0,0,100,0), +(@PATH,94,908.403,-4143.086,170.6329,0,0,0,0,100,0), +(@PATH,95,910.153,-4142.336,170.1329,0,0,0,0,100,0), +(@PATH,96,911.903,-4141.336,169.3829,0,0,0,0,100,0), +(@PATH,97,913.903,-4140.586,168.6329,0,0,0,0,100,0), +(@PATH,98,917.403,-4138.836,168.3829,0,0,0,0,100,0), +(@PATH,99,920.153,-4137.586,167.6329,0,0,0,0,100,0), +(@PATH,100,930.653,-4132.586,167.1329,0,0,0,0,100,0), +(@PATH,101,937.903,-4129.086,166.6329,0,0,0,0,100,0), +(@PATH,102,941.403,-4127.336,165.8829,0,0,0,0,100,0), +(@PATH,103,944.5377,-4125.965,165.2894,0,0,0,0,100,0), +(@PATH,104,947.2877,-4124.965,164.5394,0,0,0,0,100,0), +(@PATH,105,960.2877,-4120.465,165.2894,0,0,0,0,100,0), +(@PATH,106,960.4887,-4120.598,165.3131,0,0,0,0,100,0), +(@PATH,107,961.2387,-4120.348,165.3131,0,0,0,0,100,0), +(@PATH,108,964.4887,-4124.098,164.8131,0,0,0,0,100,0), +(@PATH,109,966.9887,-4127.098,164.0631,0,0,0,0,100,0), +(@PATH,110,970.2387,-4131.098,163.5631,0,0,0,0,100,0), +(@PATH,111,971.9887,-4133.348,162.8131,0,0,0,0,100,0), +(@PATH,112,974.9887,-4136.848,162.0631,0,0,0,0,100,0), +(@PATH,113,977.4887,-4140.098,161.5631,0,0,0,0,100,0), +(@PATH,114,979.4887,-4142.348,161.0631,0,0,0,0,100,0), +(@PATH,115,980.7387,-4143.848,160.3131,0,0,0,0,100,0), +(@PATH,116,982.7387,-4146.098,159.5631,0,0,0,0,100,0); |