diff options
| -rw-r--r-- | sql/updates/world/2014_09_20_01_world_creature.sql | 115 |
1 files changed, 115 insertions, 0 deletions
diff --git a/sql/updates/world/2014_09_20_01_world_creature.sql b/sql/updates/world/2014_09_20_01_world_creature.sql new file mode 100644 index 00000000000..857612e2c99 --- /dev/null +++ b/sql/updates/world/2014_09_20_01_world_creature.sql @@ -0,0 +1,115 @@ +-- Some Shadowmoon missing spawns +SET @CGUID := 213235; +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+70; +INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `MovementType`) VALUES +(@CGUID+0,22016,530,1,1,-4096.191,1317.842,63.59529,3.054326,300,0,0), -- Eclipsion Soldier +(@CGUID+1,22016,530,1,1,-4096.357,1322.749,65.64674,2.932153,300,0,0), -- Eclipsion Soldier +(@CGUID+2,22016,530,1,1,-4099.992,1353.743,73.72105,3.293946,300,0,0), -- Eclipsion Soldier +(@CGUID+3,22016,530,1,1,-4100.049,1373.944,79.28508,2.099715,300,0,0), -- Eclipsion Soldier +(@CGUID+4,22016,530,1,1,-4100.065,1377.723,80.54171,2.111848,300,0,0), -- Eclipsion Soldier +(@CGUID+5,22016,530,1,1,-4100.112,1350.39,72.31179,3.054326,300,0,0), -- Eclipsion Soldier +(@CGUID+6,22016,530,1,1,-4108.455,1288.618,54.21447,1.989675,300,0,0), -- Eclipsion Soldier +(@CGUID+7,22016,530,1,1,-4111.45,1286.984,54.4025,2.268928,300,0,0), -- Eclipsion Soldier +(@CGUID+8,22016,530,1,1,-4120.15,1336.899,68.11907,0,300,0,0), -- Eclipsion Soldier +(@CGUID+9,22016,530,1,1,-4120.369,1333.758,66.54772,0.01745329,300,0,0), -- Eclipsion Soldier +(@CGUID+10,22016,530,1,1,-4121.998,1381.514,81.2709,0.715585,300,0,0), -- Eclipsion Soldier +(@CGUID+11,22016,530,1,1,-4124.98,1317.968,58.9916,5.51524,300,0,0), -- Eclipsion Soldier +(@CGUID+12,22016,530,1,1,-4125.009,1385.029,82.06972,0.6806784,300,0,0), -- Eclipsion Soldier +(@CGUID+13,22016,530,1,1,-4127.137,1286,55.26802,1.815142,300,0,0), -- Eclipsion Soldier +(@CGUID+14,22016,530,1,1,-4127.499,1315.508,57.7211,5.707227,300,0,0), -- Eclipsion Soldier +(@CGUID+15,22016,530,1,1,-4131.382,1285.947,55.53052,1.972222,300,0,0), -- Eclipsion Soldier +(@CGUID+16,22016,530,1,1,-4149.733,1310.271,56.65502,4.729842,300,0,0), -- Eclipsion Soldier +(@CGUID+17,22016,530,1,1,-4153.588,1311.411,56.16999,4.625123,300,0,0), -- Eclipsion Soldier +(@CGUID+18,22016,530,1,1,-4173.101,1288.451,57.65374,1.500983,300,0,0), -- Eclipsion Soldier +(@CGUID+19,22016,530,1,1,-4173.19,1316.726,57.28808,4.625123,300,0,0), -- Eclipsion Soldier +(@CGUID+20,22016,530,1,1,-4176.76,1317.902,56.13078,4.665615,300,0,0), -- Eclipsion Soldier +(@CGUID+21,22016,530,1,1,-4177.251,1289.748,58.80741,1.466077,300,0,0), -- Eclipsion Soldier +(@CGUID+22,22016,530,1,1,-4191.07,1296.055,57.67142,1.605703,300,0,0), -- Eclipsion Soldier +(@CGUID+23,22016,530,1,1,-4194.589,1296.483,57.23888,1.553343,300,0,0), -- Eclipsion Soldier +(@CGUID+24,22016,530,1,1,-4203.806,1313.086,56.38221,4.729842,300,0,0), -- Eclipsion Soldier +(@CGUID+25,22016,530,1,1,-4206.372,1313.213,56.97198,4.677482,300,0,0), -- Eclipsion Soldier +(@CGUID+26,22016,530,1,1,-4212.834,1296.573,57.13382,1.570796,300,0,0), -- Eclipsion Soldier +(@CGUID+27,22016,530,1,1,-4216.644,1297.057,56.21738,1.570796,300,0,0), -- Eclipsion Soldier +(@CGUID+28,22016,530,1,1,-4225.272,1314.485,56.76705,4.642576,300,0,0), -- Eclipsion Soldier +(@CGUID+29,22016,530,1,1,-4229.29,1314.141,56.20462,4.834562,300,0,0), -- Eclipsion Soldier +(@CGUID+30,22016,530,1,1,-4234.124,1296.488,57.25279,1.623156,300,0,0), -- Eclipsion Soldier +(@CGUID+31,22016,530,1,1,-4237.948,1296.56,56.6738,1.518436,300,0,0), -- Eclipsion Soldier +(@CGUID+32,22016,530,1,1,-4246.702,1319.209,55.12754,4.729842,300,0,0), -- Eclipsion Soldier +(@CGUID+33,22016,530,1,1,-4250.584,1318.969,54.34119,4.694936,300,0,0), -- Eclipsion Soldier +(@CGUID+34,22016,530,1,1,-4254.897,1297.109,54.1566,1.623156,300,0,0), -- Eclipsion Soldier +(@CGUID+35,22016,530,1,1,-4259.223,1297.016,53.46115,1.570796,300,0,0), -- Eclipsion Soldier +(@CGUID+36,22016,530,1,1,-4296.026,1328.683,65.42085,4.904375,300,0,0), -- Eclipsion Soldier +(@CGUID+37,22016,530,1,1,-4299.64,1328.812,66.22527,4.747295,300,0,0), -- Eclipsion Soldier +(@CGUID+38,22016,530,1,1,-4313.26,1332.713,75.18435,4.869469,300,0,0), -- Eclipsion Soldier +(@CGUID+39,22016,530,1,1,-4316.293,1330.928,75.44308,4.799655,300,0,0), -- Eclipsion Soldier +(@CGUID+40,22016,530,1,1,-4321.846,1306.318,77.87005,1.43117,300,0,0), -- Eclipsion Soldier +(@CGUID+41,22016,530,1,1,-4325.973,1306.922,79.31133,1.553343,300,0,0), -- Eclipsion Soldier +(@CGUID+42,22016,530,1,1,-4333.595,1331.259,81.49699,4.747295,300,0,0), -- Eclipsion Soldier +(@CGUID+43,22016,530,1,1,-4337.558,1331.472,82.28129,4.747295,300,0,0), -- Eclipsion Soldier +(@CGUID+44,22016,530,1,1,-4341.43,1307.242,81.52878,1.605703,300,0,0), -- Eclipsion Soldier +(@CGUID+45,22016,530,1,1,-4345.604,1307.461,81.77303,1.466077,300,0,0), -- Eclipsion Soldier +(@CGUID+46,22017,530,1,1,-4110.106,1287.867,54.45539,2.391101,300,0,0), -- Eclipsion Spellbinder +(@CGUID+47,22017,530,1,1,-4248.659,1319.342,54.67619,4.39823,300,0,0), -- Eclipsion Spellbinder +(@CGUID+48,22017,530,1,1,-4278.104,1312.277,56.58344,2.740167,300,0,0), -- Eclipsion Spellbinder +(@CGUID+49,22017,530,1,1,-4157.983,1285.352,57.4682,0,300,0,0), -- Eclipsion Spellbinder +(@CGUID+50,22017,530,1,1,-4204.949,1314.804,57.78447,4.677482,300,0,0), -- Eclipsion Spellbinder +(@CGUID+51,22017,530,1,1,-4175.284,1288.93,58.04388,1.570796,300,0,0), -- Eclipsion Spellbinder +(@CGUID+52,22017,530,1,1,-4146.76,1283.892,59.42959,2.635447,300,0,0), -- Eclipsion Spellbinder +(@CGUID+53,22017,530,1,1,-4287.814,1313.235,62.81659,6.213372,300,0,0), -- Eclipsion Spellbinder +(@CGUID+54,22017,530,1,1,-4433.133,1253.58,71.40871,2.670354,300,0,0), -- Eclipsion Spellbinder +(@CGUID+55,22017,530,1,1,-4323.755,1306.162,78.73392,1.605703,300,0,0), -- Eclipsion Spellbinder +(@CGUID+56,22017,530,1,1,-4411.285,1278.528,79.11395,2.495821,300,0,0), -- Eclipsion Spellbinder +(@CGUID+57,22017,530,1,1,-4430.338,1293.527,79.38573,5.51524,300,0,0), -- Eclipsion Spellbinder +(@CGUID+58,22017,530,1,1,-4343.598,1307.349,81.73926,1.48353,300,0,0), -- Eclipsion Spellbinder +(@CGUID+59,22017,530,1,1,-4335.564,1331.208,81.76533,4.537856,300,0,0), -- Eclipsion Spellbinder +(@CGUID+60,22017,530,1,1,-4393.921,1293.493,85.24201,2.391101,300,0,0), -- Eclipsion Spellbinder +(@CGUID+61,22017,530,1,1,-4372.298,1299.017,86.82649,1.710423,300,0,0), -- Eclipsion Spellbinder +(@CGUID+62,22018,530,1,1,-4279.213,1299.724,48.06502,3.121056,300,0,0), -- Eclipsion Cavalier +(@CGUID+63,22018,530,1,1,-4223.789,1311.041,56.19987,3.10787,300,0,0), -- Eclipsion Cavalier +(@CGUID+64,22018,530,1,1,-4102.838,1353.306,72.31637,0.1523528,300,0,0), -- Eclipsion Cavalier +(@CGUID+65,22018,530,1,1,-4117.879,1380.962,80.29784,5.423772,300,0,0), -- Eclipsion Cavalier +(@CGUID+66,22018,530,1,1,-4393.687,1296.77,85.9353,5.331202,300,0,0), -- Eclipsion Cavalier +(@CGUID+67,19824,530,1,1,-4153.195,1279.679,57.75654,1.27409,300,0,0), -- Son of Corok +(@CGUID+68,19824,530,1,1,-4204.253,1308.621,56.27257,3.128989,300,0,0), -- Son of Corok +(@CGUID+69,19824,530,1,1,-4281.281,1317.739,58.53769,4.485496,300,0,0), -- Son of Corok +(@CGUID+70,19824,530,1,1,-4333.929,1322.016,77.64864,3.117183,300,0,0); -- Son of Corok + +-- Pathing for Son of Corok Entry: 19824 +SET @NPC := @CGUID+68; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-4231.903,`position_y`=1307.641,`position_z`=55.94048 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,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,-4231.903,1307.641,55.94048,0,0,0,0,100,0), +(@PATH,2,-4258.673,1308.574,51.75086,0,0,0,0,100,0), +(@PATH,3,-4279.65,1299.844,48.04818,0,0,0,0,100,0), +(@PATH,4,-4258.673,1308.574,51.75086,0,0,0,0,100,0), +(@PATH,5,-4231.903,1307.641,55.94048,0,0,0,0,100,0), +(@PATH,6,-4210.623,1308.702,56.31548,0,0,0,0,100,0), +(@PATH,7,-4185.151,1308.381,56.14388,0,0,0,0,100,0), +(@PATH,8,-4154.984,1302.706,55.8171,0,0,0,0,100,0), +(@PATH,9,-4128.466,1303.851,53.66854,0,0,0,0,100,0), +(@PATH,10,-4115.384,1315.77,56.70418,0,0,0,0,100,0), +(@PATH,11,-4128.466,1303.851,53.66854,0,0,0,0,100,0), +(@PATH,12,-4154.984,1302.706,55.8171,0,0,0,0,100,0), +(@PATH,13,-4185.151,1308.381,56.14388,0,0,0,0,100,0), +(@PATH,14,-4210.623,1308.702,56.31548,0,0,0,0,100,0); + +-- Pathing for Son of Corok Entry: 19824 +SET @NPC := @CGUID+70; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-4391.421,`position_y`=1317.775,`position_z`=86.86306 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,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,-4391.421,1317.775,86.86306,0,0,0,0,100,0), +(@PATH,2,-4368.556,1319.71,84.21169,0,0,0,0,100,0), +(@PATH,3,-4351.29,1322.436,82.0905,0,0,0,0,100,0), +(@PATH,4,-4329.943,1321.933,77.08961,0,0,0,0,100,0), +(@PATH,5,-4293.944,1321.216,63.2162,0,0,0,0,100,0), +(@PATH,6,-4329.943,1321.919,77.08363,0,0,0,0,100,0), +(@PATH,7,-4351.29,1322.436,82.0905,0,0,0,0,100,0), +(@PATH,8,-4368.556,1319.71,84.21169,0,0,0,0,100,0); |