diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2016_12_13_05_world.sql | 350 |
1 files changed, 350 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2016_12_13_05_world.sql b/sql/updates/world/3.3.5/2016_12_13_05_world.sql new file mode 100644 index 00000000000..385d0a24778 --- /dev/null +++ b/sql/updates/world/3.3.5/2016_12_13_05_world.sql @@ -0,0 +1,350 @@ + +-- +-- Birds in Sethekk Halls - spawns and paths +-- Set InhabitType to flying +UPDATE `creature_template` SET `InhabitType`= 4 WHERE `entry` IN (21931,21988); + +SET @GUID := 99126; -- 15 unused GUIDs from TC + +DELETE FROM `creature` WHERE `guid` BETWEEN @GUID AND @GUID+14; +INSERT INTO `creature` (guid, id, map, spawnMask, phaseMask, position_x, position_y, position_z, orientation, spawntimesecs, curhealth, curmana, spawndist, MovementType) VALUES +(@GUID+0, 21931, 556, 3, 1, -69.078, 255.062, 27.6692, 2.23169, 1, 6326, 0, 0, 2), +(@GUID+1, 21931, 556, 3, 1, 84.91618, 251.3969, 37.0668, 3.204143, 1, 6326, 0, 0, 2), +(@GUID+2, 21931, 556, 3, 1, 82.7928, 251.0653, 37.0668, 3.192098, 1, 6326, 0, 0, 2), +(@GUID+3, 21931, 556, 3, 1, -55.35431, 292.4135, 27.84376, 3.334406, 1, 6326, 0, 0, 2), +(@GUID+4, 21931, 556, 3, 1, -56.81138, 293.4768, 27.82975, 1.066901, 1, 6326, 0, 0, 2), +(@GUID+5, 21931, 556, 3, 1, -109.229, 288.209, 53.3584, 3.249347, 1, 6326, 0, 0, 2), +(@GUID+6, 21931, 556, 3, 1, -77.7733, 299.15, 60.5558, 5.757163, 1, 6326, 0, 0, 2), +(@GUID+7, 21931, 556, 3, 1, -52.39689, 293.2879, 27.82958, 1.420948, 1, 6326, 0, 0, 2), +(@GUID+8, 21931, 556, 3, 1, -65.26201, 281.413, 47.28283, 0.8305511, 1, 6326, 0, 0, 2), +(@GUID+9, 21931, 556, 3, 1, -59.42, 289.0999, 27.89292, 2.894336, 1, 6326, 0, 0, 2), +(@GUID+10, 21931, 556, 3, 1, -102.279, 278.86, 56.0703, 5.414571, 1, 6326, 0, 0, 2), +(@GUID+11, 21931, 556, 3, 1, -86.60637, 286.1224, 27.48317, 2.953945, 1, 6326, 0, 0, 2), +(@GUID+12, 21931, 556, 3, 1, -68.3353, 281.741, 61.757, 3.844181, 1, 6326, 0, 0, 2), +(@GUID+13, 21931, 556, 3, 1, -71.9701, 272.574, 59.1446, 6.184331, 1, 6326, 0, 0, 2), +(@GUID+14, 21931, 556, 3, 1, -84.35631, 263.7281, 27.80793, 4.523829, 1, 6326, 0, 0, 2); + +DELETE FROM `creature_addon` WHERE `guid` BETWEEN @GUID AND @GUID+14; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES +(@GUID+0, (@GUID+0) *10, 0, 0, 1, 0, ''), +(@GUID+1, (@GUID+1) *10, 0, 0, 1, 0, ''), +(@GUID+2, (@GUID+2) *10, 0, 0, 1, 0, ''), +(@GUID+3, (@GUID+3) *10, 0, 0, 1, 0, ''), +(@GUID+4, (@GUID+4) *10, 0, 0, 1, 0, ''), +(@GUID+5, (@GUID+5) *10, 0, 0, 1, 0, ''), +(@GUID+6, (@GUID+6) *10, 0, 0, 1, 0, ''), +(@GUID+7, (@GUID+7) *10, 0, 0, 1, 0, ''), +(@GUID+8, (@GUID+8) *10, 0, 0, 1, 0, ''), +(@GUID+9, (@GUID+9) *10, 0, 0, 1, 0, ''), +(@GUID+10, (@GUID+10)*10, 0, 0, 1, 0, ''), +(@GUID+11, (@GUID+11)*10, 0, 0, 1, 0, ''), +(@GUID+12, (@GUID+12)*10, 0, 0, 1, 0, ''), +(@GUID+13, (@GUID+13)*10, 0, 0, 1, 0, ''), +(@GUID+14, (@GUID+14)*10, 0, 0, 1, 0, ''); + +-- 1. +SET @PATH := (@GUID+0) * 10; + +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`) VALUES +(@PATH, 1, -69.078, 255.062, 27.6692), +(@PATH, 2, -69.078, 255.062, 27.6692), +(@PATH, 3, -77.6467, 256.825, 27.8182), +(@PATH, 4, -85.5541, 263.248, 37.4314), +(@PATH, 5, -89.3701, 273.449, 46.1637), +(@PATH, 6, -87.3918, 283.626, 55.5433), +(@PATH, 7, -81.6323, 288.392, 67.374), +(@PATH, 8, -83.6451, 281.803, 77.323), +(@PATH, 9, -97.3242, 280.983, 74.488), +(@PATH, 10, -95.2966, 294.303, 27.4832), +(@PATH, 11, -91.9066, 298.554, 40.3148), +(@PATH, 12, -84.9968, 296.969, 52.3776), +(@PATH, 13, -81.5458, 289.807, 63.8514), +(@PATH, 14, -91.5585, 284.275, 71.9894), +(@PATH, 15, -95.834, 292.943, 27.4832), +(@PATH, 16, -94.3393, 295.352, 41.1404), +(@PATH, 17, -88.5665, 292.19, 53.5047), +(@PATH, 18, -88.0789, 284.173, 65.0211), +(@PATH, 19, -96.7033, 282.247, 75.63), +(@PATH, 20, -92.1857, 296.241, 27.4832); + +-- 2. +SET @PATH := (@GUID+1) * 10; + +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`) VALUES +(@PATH, 1, -84.3563, 263.728, 27.8079), +(@PATH, 2, -87.4666, 261.464, 58.4138), +(@PATH, 3, -94.4575, 270.352, 66.6585), +(@PATH, 4, -95.7386, 284.443, 27.4832), +(@PATH, 5, -91.3219, 290.488, 39.2894), +(@PATH, 6, -84.573, 290.53, 51.5467), +(@PATH, 7, -83.1581, 284.409, 64.0506), +(@PATH, 8, -92.9101, 280.978, 73.484), +(@PATH, 9, -96.079, 293.202, 74.566), +(@PATH, 10, -82.8515, 297.569, 74.9201), +(@PATH, 11, -77.4638, 284.989, 27.4832), +(@PATH, 12, -81.0183, 279.803, 39.9446), +(@PATH, 13, -89.1536, 280.506, 51.3678), +(@PATH, 14, -94.1382, 293.611, 27.4832), +(@PATH, 15, -88.9669, 297.982, 39.6762), +(@PATH, 16, -84.4414, 293.357, 52.098), +(@PATH, 17, -86.5034, 284.787, 63.0289), +(@PATH, 18, -97.8593, 278.945, 26.2094), +(@PATH, 19, -83.9472, 285.452, 63.0513), +(@PATH, 20, -93.4871, 275.608, 26.8408); + +-- 3. +SET @PATH := (@GUID+2) * 10; + +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`) VALUES +(@PATH, 1, 84.9162, 251.397, 37.0668), +(@PATH, 2, 83.9651, 251.088, 37.0668), +(@PATH, 3, 51.4796, 252.183, 37.0668), +(@PATH, 4, 33.2474, 282.432, 37.0668), +(@PATH, 5, -4.58595, 288.248, 37.0668), +(@PATH, 6, -33.1252, 287.388, 33.6501), +(@PATH, 7, -63.6614, 287.145, 37.0668), +(@PATH, 8, -86.5805, 281.312, 37.0668), +(@PATH, 9, -122.867, 287.583, 33.7057), +(@PATH, 10, -166.135, 286.002, 37.0668), +(@PATH, 11, -197.129, 319.599, 41.5668), +(@PATH, 12, -226.722, 321.688, 41.5391), +(@PATH, 13, -241.978, 284.026, 37.0668), +(@PATH, 14, -241.867, 239.697, 34.7891), +(@PATH, 15, -240.409, 205.258, 33.289), +(@PATH, 16, -247.921, 181.826, 37.0668), +(@PATH, 17, -258.541, 176.818, 28.8724), +(@PATH, 18, -254.589, 187.929, 17.5946), +(@PATH, 19, -233.282, 183.525, 9.45569), +(@PATH, 20, -207.969, 174.104, 9.45569), +(@PATH, 21, -174.273, 173.592, 7.17792), +(@PATH, 22, -153.428, 164.087, 10.4835), +(@PATH, 23, -141.719, 162.854, 10.9835), +(@PATH, 24, -125.931, 171.58, 9.15015), +(@PATH, 25, -97.7346, 173.65, 7.15014), +(@PATH, 26, -82.8989, 173.921, 10.3168), +(@PATH, 27, -73.9182, 173.077, 10.3168), +(@PATH, 28, -69.9846, 163.459, 10.3168), +(@PATH, 29, -70.2812, 156.773, 9.34458), +(@PATH, 30, -71.1548, 128.592, 6.7057), +(@PATH, 31, -80.0383, 115.576, 7.51125), +(@PATH, 32, -82.5443, 99.0856, 7.51125), +(@PATH, 33, -74.7056, 88.5289, 7.51125), +(@PATH, 34, -60.1037, 87.1475, 7.51125), +(@PATH, 35, -43.8567, 99.2091, 7.03903), +(@PATH, 36, -21.4774, 99.8071, 7.26125), +(@PATH, 37, 7.50968, 100.248, 7.51125), +(@PATH, 38, 27.4025, 97.8097, 19.3168), +(@PATH, 39, 37.0373, 95.8226, 30.8446); + +-- 4. +SET @PATH := (@GUID+3) * 10; + +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`) VALUES +(@PATH, 1, -119.16, 291.958, 26.7305), +(@PATH, 2, -119.16, 291.958, 26.7305), +(@PATH, 3, -118.246, 291.551, 26.7198), +(@PATH, 4, -116.125, 290.169, 41.5238), +(@PATH, 5, -114.528, 275.12, 40.1532), +(@PATH, 6, -90.689, 265.24, 41.0333), +(@PATH, 7, -62.0894, 286.098, 48.6939), +(@PATH, 8, -76.8407, 304.686, 51.9439), +(@PATH, 9, -98.7576, 303.572, 46.4161); + +-- 5. +SET @PATH := (@GUID+4) * 10; + +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`) VALUES +(@PATH, 1, -56.8114, 293.477, 27.8298), +(@PATH, 2, -58.7468, 295.764, 29.4033), +(@PATH, 3, -80.8255, 317.109, 28.9557), +(@PATH, 4, -84.6018, 313.357, 62.0829), +(@PATH, 5, -100.485, 310.06, 60.6726), +(@PATH, 6, -119.643, 290.201, 57.4676), +(@PATH, 7, -119.602, 271.028, 61.3137), +(@PATH, 8, -99.3827, 260.039, 59.8997), +(@PATH, 9, -62.9444, 265.206, 63.3061), +(@PATH, 10, -53.9817, 286.896, 63.0482), +(@PATH, 11, -66.9341, 300.934, 58.5854), +(@PATH, 12, -82.0958, 309.241, 61.3414), +(@PATH, 13, -100.199, 310.19, 60.9001), +(@PATH, 14, -109.249, 296.2, 58.5368), +(@PATH, 15, -112.956, 287.824, 28.945), +(@PATH, 16, -131.244, 263.41, 30.9794), +(@PATH, 17, -124.562, 262.687, 57.9071), +(@PATH, 18, -89.1208, 261.935, 60.3001), +(@PATH, 19, -66.6449, 264.328, 64.3038), +(@PATH, 20, -56.4546, 270.201, 65.3866), +(@PATH, 21, -53.7442, 287.453, 64.0839), +(@PATH, 22, -56.4072, 293.549, 29.5758); + +-- 6. +SET @PATH := (@GUID+5) * 10; + +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`) VALUES +(@PATH, 1, -59.42, 289.1, 27.8929), +(@PATH, 2, -58.7468, 295.764, 29.4033), +(@PATH, 3, -80.8255, 317.109, 28.9557), +(@PATH, 4, -84.6018, 313.357, 62.0829), +(@PATH, 5, -100.485, 310.06, 60.6726), +(@PATH, 6, -119.643, 290.201, 57.4676), +(@PATH, 7, -119.602, 271.028, 61.3137), +(@PATH, 8, -99.3827, 260.039, 59.8997), +(@PATH, 9, -62.9444, 265.206, 63.3061), +(@PATH, 10, -53.9817, 286.896, 63.0482), +(@PATH, 11, -66.9341, 300.934, 58.5854), +(@PATH, 12, -82.0958, 309.241, 61.3414), +(@PATH, 13, -100.199, 310.19, 60.9001), +(@PATH, 14, -109.249, 296.2, 58.5368), +(@PATH, 15, -112.956, 287.824, 28.945), +(@PATH, 16, -131.244, 263.41, 30.9794), +(@PATH, 17, -124.562, 262.687, 57.9071), +(@PATH, 18, -89.1208, 261.935, 60.3001), +(@PATH, 19, -66.6449, 264.328, 64.3038), +(@PATH, 20, -56.4546, 270.201, 65.3866), +(@PATH, 21, -53.7442, 287.453, 64.0839), +(@PATH, 22, -56.4072, 293.549, 29.5758); + +-- 7. +SET @PATH := (@GUID+6) * 10; + +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`) VALUES +(@PATH, 1, -52.3969, 293.288, 27.8296), +(@PATH, 2, -58.7468, 295.764, 29.4033), +(@PATH, 3, -80.8255, 317.109, 28.9557), +(@PATH, 4, -84.6018, 313.357, 62.0829), +(@PATH, 5, -100.485, 310.06, 60.6726), +(@PATH, 6, -119.643, 290.201, 57.4676), +(@PATH, 7, -119.602, 271.028, 61.3137), +(@PATH, 8, -99.3827, 260.039, 59.8997), +(@PATH, 9, -62.9444, 265.206, 63.3061), +(@PATH, 10, -53.9817, 286.896, 63.0482), +(@PATH, 11, -66.9341, 300.934, 58.5854), +(@PATH, 12, -82.0958, 309.241, 61.3414), +(@PATH, 13, -100.199, 310.19, 60.9001), +(@PATH, 14, -109.249, 296.2, 58.5368), +(@PATH, 15, -112.956, 287.824, 28.945), +(@PATH, 16, -131.244, 263.41, 30.9794), +(@PATH, 17, -124.562, 262.687, 57.9071), +(@PATH, 18, -89.1208, 261.935, 60.3001), +(@PATH, 19, -66.6449, 264.328, 64.3038), +(@PATH, 20, -56.4546, 270.201, 65.3866), +(@PATH, 21, -53.7442, 287.453, 64.0839), +(@PATH, 22, -56.4072, 293.549, 29.5758); + +-- 8. +SET @PATH := (@GUID+7) * 10; + +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`) VALUES +(@PATH, 1, -62.0894, 286.098, 48.6939), +(@PATH, 2, -76.8407, 304.686, 51.9439), +(@PATH, 3, -98.7576, 303.572, 46.4161), +(@PATH, 4, -119.16, 291.958, 26.7305), +(@PATH, 5, -119.16, 291.958, 26.7305), +(@PATH, 6, -118.246, 291.551, 26.7198), +(@PATH, 7, -116.125, 290.169, 41.5238), +(@PATH, 8, -114.528, 275.12, 40.1532), +(@PATH, 9, -90.689, 265.24, 41.0333); + +-- 9. +SET @PATH := (@GUID+8) * 10; + +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`) VALUES +(@PATH, 1, -109.229, 288.209, 53.3584), +(@PATH, 2, -102.279, 278.86, 56.0703), +(@PATH, 3, -88.1313, 272.423, 59.4688), +(@PATH, 4, -71.9701, 272.574, 59.1446), +(@PATH, 5, -68.3353, 281.741, 61.757), +(@PATH, 6, -77.7733, 299.15, 60.5558), +(@PATH, 7, -94.7425, 300.49, 56.1018); + +-- 10. +SET @PATH := (@GUID+9) * 10; + +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`) VALUES +(@PATH, 1, -71.9701, 272.574, 59.1446), +(@PATH, 2, -68.3353, 281.741, 61.757), +(@PATH, 3, -77.7733, 299.15, 60.5558), +(@PATH, 4, -94.7425, 300.49, 56.1018), +(@PATH, 5, -109.229, 288.209, 53.3584), +(@PATH, 6, -102.279, 278.86, 56.0703), +(@PATH, 7, -88.1313, 272.423, 59.4688); + +-- 11. +SET @PATH := (@GUID+10) * 10; + +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`) VALUES +(@PATH, 1, -68.3353, 281.741, 61.757), +(@PATH, 2, -77.7733, 299.15, 60.5558), +(@PATH, 3, -94.7425, 300.49, 56.1018), +(@PATH, 4, -109.229, 288.209, 53.3584), +(@PATH, 5, -102.279, 278.86, 56.0703), +(@PATH, 6, -88.1313, 272.423, 59.4688), +(@PATH, 7, -71.9701, 272.574, 59.1446); + +-- 12. +SET @PATH := (@GUID+11) * 10; + +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`) VALUES +(@PATH, 1, -102.279, 278.86, 56.0703), +(@PATH, 2, -88.1313, 272.423, 59.4688), +(@PATH, 3, -71.9701, 272.574, 59.1446), +(@PATH, 4, -68.3353, 281.741, 61.757), +(@PATH, 5, -77.7733, 299.15, 60.5558), +(@PATH, 6, -94.7425, 300.49, 56.1018), +(@PATH, 7, -109.229, 288.209, 53.3584); + +-- 13. +SET @PATH := (@GUID+12) * 10; + +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`) VALUES +(@PATH, 1, -77.7733, 299.15, 60.5558), +(@PATH, 2, -94.7425, 300.49, 56.1018), +(@PATH, 3, -109.229, 288.209, 53.3584), +(@PATH, 4, -102.279, 278.86, 56.0703), +(@PATH, 5, -88.1313, 272.423, 59.4688), +(@PATH, 6, -71.9701, 272.574, 59.1446), +(@PATH, 7, -68.3353, 281.741, 61.757); + +-- 14. +SET @PATH := (@GUID+13) * 10; + +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`) VALUES +(@PATH, 1, -86.6064, 286.122, 27.4832), +(@PATH, 2, -84.2669, 286.076, 57.4227), +(@PATH, 3, -71.9701, 272.574, 59.1446), +(@PATH, 4, -68.3353, 281.741, 61.757), +(@PATH, 5, -77.7733, 299.15, 60.5558), +(@PATH, 6, -94.7425, 300.49, 56.1018), +(@PATH, 7, -109.229, 288.209, 53.3584), +(@PATH, 8, -102.279, 278.86, 56.0703), +(@PATH, 9, -88.1313, 272.423, 59.4688); + +-- 15. +SET @PATH := (@GUID+14) * 10; + +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`) VALUES +(@PATH, 1, 84.9162, 251.397, 37.0668), +(@PATH, 2, 83.9651, 251.088, 37.0668), +(@PATH, 3, 51.4796, 252.183, 37.0668), +(@PATH, 4, 33.2474, 282.432, 37.0668), +(@PATH, 5, -4.58595, 288.248, 37.0668), +(@PATH, 6, -33.1252, 287.388, 33.6501), +(@PATH, 7, -63.6614, 287.145, 37.0668), +(@PATH, 8, -77.5616, 286.325, 98.1903); + +UPDATE `waypoint_data` SET `move_type`=1 WHERE `id` IN ((@GUID+0) * 10,(@GUID+1) * 10,(@GUID+2) * 10,(@GUID+3) * 10,(@GUID+4) * 10,(@GUID+5) * 10,(@GUID+6) * 10,(@GUID+7) * 10,(@GUID+8) * 10,(@GUID+9) * 10, (@GUID+10) * 10, (@GUID+11) * 10, (@GUID+12) * 10, (@GUID+13) * 10, (@GUID+14) * 10); |