diff options
| -rw-r--r-- | sql/updates/world/2015_05_09_07_world.sql | 103 |
1 files changed, 103 insertions, 0 deletions
diff --git a/sql/updates/world/2015_05_09_07_world.sql b/sql/updates/world/2015_05_09_07_world.sql new file mode 100644 index 00000000000..459c0c3e1f8 --- /dev/null +++ b/sql/updates/world/2015_05_09_07_world.sql @@ -0,0 +1,103 @@ +-- +UPDATE `smart_scripts` SET `event_type`=25, `event_flags`=0 WHERE `entryorguid` IN (21784,21815, 21801) AND `source_type`=0 AND `id`=0; + +DELETE FROM `creature_formations` WHERE `leaderGUID`=76082; +INSERT INTO `creature_formations` (`leaderGUID`,`memberGUID`,`dist`,`angle`,`groupAI`) VALUES +(76082,76082,0,0,2), +(76082,76083,7,360,2), +(76082,76084,14,360,2), +(76082,76085,21,360,2); + +UPDATE `creature` SET `MovementType`=0, `spawndist`=0 WHERE `guid` IN (76083, 76084, 76085); +UPDATE `creature` SET `MovementType`=2 WHERE `guid` IN (76082); +DELETE FROM `creature_addon` WHERE `guid` IN (76082); +INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes1`,`bytes2`, `emote`, `auras`) VALUES +(76082,760820,16777216,4097,0,""); +DELETE FROM `creature` WHERE `id`=21998; -- wrong spawn, must be summoned by quest item only + +DELETE FROM `waypoint_data` WHERE (`id`=760820); +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES +(760820, 1, -3116.419922, 821.828979, -21.856766, 0, 0, 1, 0, 100, 0), +(760820, 2, -3127.299561, 795.134766, -22.401117, 0, 0, 1, 0, 100, 0), +(760820, 3, -3150.103027, 782.489380, -21.864737, 0, 0, 1, 0, 100, 0), +(760820, 4, -3219.880615, 780.314880, -19.754417, 0, 0, 1, 0, 100, 0), +(760820, 5, -3251.568604, 783.067688, -19.069899, 0, 0, 1, 0, 100, 0), +(760820, 6, -3295.924072, 767.111877, -21.192102, 0, 0, 1, 0, 100, 0), +(760820, 7, -3403.222656, 752.732056, -35.531361, 0, 0, 1, 0, 100, 0), +(760820, 8, -3617.548828, 732.945862, -8.339263, 0, 0, 1, 0, 100, 0), +(760820, 9, -3631.188965, 727.337463, -5.722647, 0, 0, 1, 0, 100, 0), +(760820, 10, -3733.907471, 751.174744, 7.209823, 0, 0, 1, 0, 100, 0), +(760820, 11, -3782.882813, 746.945984, 9.761057, 0, 0, 1, 0, 100, 0), +(760820, 12, -3859.570068, 752.093506, 10.382468, 0, 0, 1, 0, 100, 0), +(760820, 13, -3879.040283, 773.671936, 9.449715, 0, 0, 1, 0, 100, 0), +(760820, 14, -3888.581787, 854.766663, 15.828053, 0, 0, 1, 0, 100, 0), +(760820, 15, -3880.752930, 897.569763, 19.081347, 0, 0, 1, 0, 100, 0), +(760820, 16, -3886.515137, 944.770691, 21.956785, 0, 0, 1, 0, 100, 0), +(760820, 17, -3880.704834, 985.264221, 23.311592, 0, 0, 1, 0, 100, 0), +(760820, 18, -3883.812012, 1007.772705, 23.589699, 0, 0, 1, 0, 100, 0), +(760820, 19, -3975.737061, 1099.026733, 30.213566, 0, 0, 1, 0, 100, 0), +(760820, 20, -4000.627197, 1143.911499, 41.125046, 0, 0, 1, 0, 100, 0), +(760820, 21, -4036.700928, 1163.023804, 51.072033, 0, 0, 1, 0, 100, 0), +(760820, 22, -4052.043457, 1183.807129, 57.569439, 0, 0, 1, 0, 100, 0), +(760820, 23, -4053.111816, 1202.003784, 62.920666, 0, 0, 1, 0, 100, 0), +(760820, 24, -4037.213623, 1261.900757, 78.336632, 0, 0, 1, 0, 100, 0), +(760820, 25, -4038.152588, 1296.390991, 83.919540, 0, 0, 1, 0, 100, 0), +(760820, 26, -4053.791504, 1370.539185, 84.908981, 0, 0, 1, 0, 100, 0), +(760820, 27, -4054.700439, 1618.686279, 93.997330, 0, 0, 1, 0, 100, 0), +(760820, 28, -4045.018799, 1643.987061, 94.251122, 0, 0, 1, 0, 100, 0), +(760820, 29, -3983.812988, 1705.642944, 97.803833, 0, 0, 1, 0, 100, 0), +(760820, 30, -3938.369141, 1738.914917, 98.837524, 0, 0, 1, 0, 100, 0), +(760820, 31, -3900.309814, 1758.672363, 97.922089, 0, 0, 1, 0, 100, 0), +(760820, 32, -3867.449707, 1786.059937, 94.361740, 0, 0, 1, 0, 100, 0), +(760820, 33, -3850.530273, 1826.876221, 90.358040, 0, 0, 1, 0, 100, 0), +(760820, 34, -3847.338867, 1880.751831, 86.640762, 0, 0, 1, 0, 100, 0), +(760820, 35, -3814.812988, 1960.993286, 85.844566, 0, 0, 1, 0, 100, 0), +(760820, 36, -3756.163574, 2030.727905, 84.516495, 0, 0, 1, 0, 100, 0), +(760820, 37, -3752.126221, 2094.629395, 78.208092, 0, 0, 1, 0, 100, 0), +(760820, 38, -3755.360352, 2146.251221, 75.892380, 0, 0, 1, 0, 100, 0), +(760820, 39, -3743.547119, 2204.366699, 76.086136, 0, 0, 1, 0, 100, 0), +(760820, 40, -3744.448975, 2262.760742, 76.763046, 0, 0, 1, 0, 100, 0), +(760820, 41, -3714.628662, 2328.074219, 76.275826, 0, 0, 1, 0, 100, 0), +(760820, 42, -3688.062256, 2347.847168, 76.348412, 0, 0, 1, 0, 100, 0), +(760820, 43, -3674.596680, 2318.612061, 75.835876, 0, 0, 1, 0, 100, 0), +(760820, 44, -3624.145264, 2310.810791, 74.901398, 0, 0, 1, 0, 100, 0), +(760820, 45, -3596.897217, 2321.221191, 73.494583, 0, 0, 1, 0, 100, 0), +(760820, 46, -3570.569824, 2315.111572, 71.091606, 0, 0, 1, 0, 100, 0), +(760820, 47, -3505.514648, 2275.580811, 66.201355, 0, 0, 1, 0, 100, 0), +(760820, 48, -3444.574219, 2289.437500, 63.707752, 0, 0, 1, 0, 100, 0), +(760820, 49, -3402.431396, 2291.413818, 62.819668, 0, 0, 1, 0, 100, 0), +(760820, 50, -3344.245605, 2280.061523, 61.217396, 0, 0, 1, 0, 100, 0), +(760820, 51, -3266.743164, 2283.391113, 60.007225, 0, 0, 1, 0, 100, 0), +(760820, 52, -3233.561279, 2292.924561, 59.882648, 0, 0, 1, 0, 100, 0), +(760820, 53, -3221.570313, 2250.202393, 61.123081, 0, 0, 1, 0, 100, 0), +(760820, 54, -3189.590088, 2199.339844, 64.705276, 0, 0, 1, 0, 100, 0), +(760820, 55, -3175.489502, 2098.237549, 75.678909, 0, 0, 1, 0, 100, 0), +(760820, 56, -3160.424316, 2081.004150, 80.764908, 0, 0, 1, 0, 100, 0), +(760820, 57, -3141.073242, 2027.865112, 92.255219, 0, 0, 1, 0, 100, 0), +(760820, 58, -3100.545654, 1987.315796, 100.928787, 0, 0, 1, 0, 100, 0), +(760820, 59, -3079.955811, 1952.478638, 109.271744, 0, 0, 1, 0, 100, 0), +(760820, 60, -3043.312744, 1921.660156, 112.361816, 0, 0, 1, 0, 100, 0), +(760820, 61, -2973.852539, 1910.639648, 104.475471, 0, 0, 1, 0, 100, 0), +(760820, 62, -2956.038086, 1893.901855, 99.170197, 0, 0, 1, 0, 100, 0), +(760820, 63, -2950.733643, 1858.555664, 88.703011, 0, 0, 1, 0, 100, 0), +(760820, 64, -2923.169678, 1824.131348, 70.827278, 0, 0, 1, 0, 100, 0), +(760820, 65, -2889.111816, 1758.524658, 47.417206, 0, 0, 1, 0, 100, 0), +(760820, 66, -2879.456299, 1722.608887, 39.589905, 0, 0, 1, 0, 100, 0), +(760820, 67, -2865.740723, 1710.794922, 36.381069, 0, 0, 1, 0, 100, 0), +(760820, 68, -2848.158691, 1707.713623, 32.244236, 0, 0, 1, 0, 100, 0), +(760820, 69, -2824.067383, 1685.606934, 23.045313, 0, 0, 1, 0, 100, 0), +(760820, 70, -2819.241943, 1641.792847, 13.334887, 0, 0, 1, 0, 100, 0), +(760820, 71, -2871.091064, 1569.277466, 15.303233, 0, 0, 1, 0, 100, 0), +(760820, 72, -2893.539063, 1492.087402, 14.836093, 0, 0, 1, 0, 100, 0), +(760820, 73, -2981.375000, 1436.377686, 11.891064, 0, 0, 1, 0, 100, 0), +(760820, 74, -2987.835693, 1401.822510, 11.926711, 0, 0, 1, 0, 100, 0), +(760820, 75, -2988.486572, 1347.793457, 9.330483, 0, 0, 1, 0, 100, 0), +(760820, 76, -3078.444580, 1254.076050, 10.399191, 0, 0, 1, 0, 100, 0), +(760820, 77, -3090.341797, 1206.203125, 18.388882, 0, 0, 1, 0, 100, 0), +(760820, 78, -3114.885986, 1174.320313, 25.699680, 0, 0, 1, 0, 100, 0), +(760820, 79, -3112.093506, 1126.753174, 24.259985, 0, 0, 1, 0, 100, 0), +(760820, 80, -3120.531982, 1096.862549, 19.402412, 0, 0, 1, 0, 100, 0), +(760820, 81, -3113.394287, 1034.310425, 4.188662, 0, 0, 1, 0, 100, 0), +(760820, 82, -3117.856445, 982.948914, -7.988031, 0, 0, 1, 0, 100, 0), +(760820, 83, -3091.906494, 930.465881, -17.414244, 0, 0, 1, 0, 100, 0), +(760820, 84, -3116.419922, 821.828979, -21.856766, 0, 0, 1, 0, 100, 0); |