diff options
| -rw-r--r-- | sql/updates/world/master/2021_11_21_17_world_2019_01_12_08_world.sql | 205 |
1 files changed, 205 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_11_21_17_world_2019_01_12_08_world.sql b/sql/updates/world/master/2021_11_21_17_world_2019_01_12_08_world.sql new file mode 100644 index 00000000000..d58c703bbc4 --- /dev/null +++ b/sql/updates/world/master/2021_11_21_17_world_2019_01_12_08_world.sql @@ -0,0 +1,205 @@ +-- +DELETE FROM `creature` WHERE `guid` IN (72680,72681,72682,72683,72684,72685,72686,72687,72688,72689,72690,72691,72692); +INSERT INTO `creature` (`guid`, `id`, `map`, `spawnDifficulties`, `phaseid`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`) VALUES +(72680, 20557, 530, '0', 0, 0, 0, 2838.165, 7074.903, 365.8945, 0.1715328, 300, 0, 0, 7181, 0, 2), +(72681, 20557, 530, '0', 0, 0, 0, 2842.261, 6902.901, 363.2647, 0.7992094, 300, 0, 0, 7181, 0, 2), +(72682, 20557, 530, '0', 0, 0, 0, 2920.676, 7068.314, 365.3216, 4.2203280, 300, 0, 0, 7181, 0, 2), +(72683, 20557, 530, '0', 0, 0, 0, 2772.758, 6985.622, 364.4864, 5.9456690, 300, 0, 0, 7181, 0, 2), +(72684, 20557, 530, '0', 0, 0, 0, 3044.654, 7037.556, 364.1739, 3.4676890, 300, 0, 0, 7181, 0, 2), +(72685, 20557, 530, '0', 0, 0, 0, 2925.073, 6933.827, 366.7077, 0.1519892, 300, 0, 0, 7181, 0, 2), +(72686, 20557, 530, '0', 0, 0, 0, 2979.515, 6775.853, 364.9106, 3.4206140, 300, 0, 0, 7181, 0, 2), +(72687, 20557, 530, '0', 0, 0, 0, 3055.043, 6975.298, 365.2459, 3.8626440, 300, 0, 0, 7181, 0, 2), +(72688, 20557, 530, '0', 0, 0, 0, 3012.340, 6776.294, 365.3947, 0.2156671, 300, 0, 0, 7181, 0, 2), +(72689, 20557, 530, '0', 0, 0, 0, 2872.627, 6877.586, 364.2757, 0.6837065, 300, 0, 0, 7181, 0, 2), +(72690, 20557, 530, '0', 0, 0, 0, 2986.388, 7111.833, 364.8571, 3.8502830, 300, 0, 0, 7181, 0, 2), +(72691, 20557, 530, '0', 0, 0, 0, 2890.417, 7154.899, 365.0332, 4.3647220, 300, 0, 0, 7181, 0, 2), +(72692, 20557, 530, '0', 0, 0, 0, 2944.051, 7158.121, 365.5524, 2.6713950, 300, 0, 0, 7181, 0, 2); + +DELETE FROM `creature_addon` WHERE `guid` IN (72680,72681,72682,72683,72684,72685,72686,72687,72688,72689,72690,72691,72692); +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES +(72680, 726800, 0, 0, 0, ""), +(72681, 726810, 0, 0, 0, ""), +(72682, 726820, 0, 0, 0, ""), +(72683, 726830, 0, 0, 0, ""), +(72684, 726840, 0, 0, 0, ""), +(72685, 726850, 0, 0, 0, ""), +(72686, 726860, 0, 0, 0, ""), +(72687, 726870, 0, 0, 0, ""), +(72688, 726880, 0, 0, 0, ""), +(72689, 726890, 0, 0, 0, ""), +(72690, 726900, 0, 0, 0, ""), +(72691, 726910, 0, 0, 0, ""), +(72692, 726920, 0, 0, 0, ""); + +DELETE FROM `waypoint_data` WHERE `id` IN (726800,726810,726820,726830,726840,726850,726860,726870,726880,726890,726900,726910,726920); +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`action`, `action_chance`) VALUES +(726800, 1, 2855.671, 7077.936, 365.5835, 0, 0, 100), +(726800, 2, 2874.210, 7093.193, 364.5575, 0, 0, 100), +(726800, 3, 2891.624, 7108.722, 365.8233, 0, 0, 100), +(726800, 4, 2917.283, 7118.713, 365.5226, 0, 0, 100), +(726800, 5, 2942.211, 7126.026, 365.5009, 0, 0, 100), +(726800, 6, 2961.035, 7143.308, 364.4117, 0, 0, 100), +(726800, 7, 2985.638, 7150.231, 364.8322, 0, 0, 100), +(726800, 8, 2961.035, 7143.308, 364.4117, 0, 0, 100), +(726800, 9, 2942.211, 7126.026, 365.5009, 0, 0, 100), +(726800, 10, 2917.283, 7118.713, 365.5226, 0, 0, 100), +(726800, 11, 2891.624, 7108.722, 365.8233, 0, 0, 100), +(726800, 12, 2874.466, 7093.397, 364.5389, 0, 0, 100), +(726800, 13, 2855.671, 7077.936, 365.5835, 0, 0, 100), +(726800, 14, 2838.286, 7062.887, 363.9167, 0, 0, 100), +(726810, 1, 2861.496, 6922.694, 364.3198, 0, 0, 100), +(726810, 2, 2885.192, 6946.924, 366.5784, 0, 0, 100), +(726810, 3, 2914.277, 6977.952, 364.4723, 0, 0, 100), +(726810, 4, 2941.384, 6994.946, 364.8961, 0, 0, 100), +(726810, 5, 2971.893, 7021.884, 365.1461, 0, 0, 100), +(726810, 6, 2941.384, 6994.946, 364.8961, 0, 0, 100), +(726810, 7, 2914.277, 6977.952, 364.4723, 0, 0, 100), +(726810, 8, 2885.192, 6946.924, 366.5784, 0, 0, 100), +(726810, 9, 2861.496, 6922.694, 364.3198, 0, 0, 100), +(726810, 10, 2841.480, 6895.969, 361.6937, 0, 0, 100), +(726820, 1, 2912.490, 7053.045, 365.5347, 0, 0, 100), +(726820, 2, 2904.558, 7024.238, 365.2241, 0, 0, 100), +(726820, 3, 2884.616, 7001.505, 365.4165, 0, 0, 100), +(726820, 4, 2872.280, 6984.476, 365.3120, 0, 0, 100), +(726820, 5, 2849.484, 6963.466, 364.6788, 0, 0, 100), +(726820, 6, 2831.692, 6931.862, 364.2488, 0, 0, 100), +(726820, 7, 2849.260, 6963.265, 364.8068, 0, 0, 100), +(726820, 8, 2872.280, 6984.476, 365.3120, 0, 0, 100), +(726820, 9, 2884.605, 7001.477, 365.4031, 0, 0, 100), +(726820, 10, 2904.558, 7024.238, 365.2241, 0, 0, 100), +(726820, 11, 2912.490, 7053.045, 365.5347, 0, 0, 100), +(726820, 12, 2925.117, 7076.473, 365.5374, 0, 0, 100), +(726830, 1, 2808.239, 6973.178, 364.6633, 0, 0, 100), +(726830, 2, 2843.901, 6982.093, 364.5683, 0, 0, 100), +(726830, 3, 2862.078, 7015.368, 364.0882, 0, 0, 100), +(726830, 4, 2877.513, 7039.922, 364.7142, 0, 0, 100), +(726830, 5, 2905.716, 7062.371, 365.6126, 0, 0, 100), +(726830, 6, 2924.071, 7085.791, 364.3985, 0, 0, 100), +(726830, 7, 2905.716, 7062.371, 365.6126, 0, 0, 100), +(726830, 8, 2877.541, 7039.970, 364.7294, 0, 0, 100), +(726830, 9, 2862.078, 7015.368, 364.0882, 0, 0, 100), +(726830, 10, 2843.901, 6982.093, 364.5683, 0, 0, 100), +(726830, 11, 2808.239, 6973.178, 364.6633, 0, 0, 100), +(726830, 12, 2778.558, 6978.680, 364.9259, 0, 0, 100), +(726840, 1, 3022.978, 7030.222, 365.0060, 0, 0, 100), +(726840, 2, 2999.585, 7013.088, 365.1461, 0, 0, 100), +(726840, 3, 2967.995, 6986.986, 365.4838, 0, 0, 100), +(726840, 4, 2946.548, 6970.201, 365.2419, 0, 0, 100), +(726840, 5, 2925.980, 6951.931, 364.2752, 0, 0, 100), +(726840, 6, 2903.839, 6926.905, 365.4123, 0, 0, 100), +(726840, 7, 2886.072, 6907.559, 364.3848, 0, 0, 100), +(726840, 8, 2858.626, 6876.403, 364.7575, 0, 0, 100), +(726840, 9, 2886.072, 6907.559, 364.3848, 0, 0, 100), +(726840, 10, 2903.839, 6926.905, 365.4123, 0, 0, 100), +(726840, 11, 2925.980, 6951.931, 364.2752, 0, 0, 100), +(726840, 12, 2946.548, 6970.201, 365.2419, 0, 0, 100), +(726840, 13, 2967.995, 6986.986, 365.4838, 0, 0, 100), +(726840, 14, 2999.425, 7012.979, 365.1397, 0, 0, 100), +(726840, 15, 3022.978, 7030.222, 365.0060, 0, 0, 100), +(726840, 16, 3054.184, 7042.173, 364.5567, 0, 0, 100), +(726850, 1, 2947.726, 6937.300, 364.9930, 0, 0, 100), +(726850, 2, 2985.193, 6934.610, 366.0233, 0, 0, 100), +(726850, 3, 3015.171, 6924.756, 365.9351, 0, 0, 100), +(726850, 4, 3034.863, 6903.272, 365.5850, 0, 0, 100), +(726850, 5, 3051.356, 6868.200, 364.1719, 0, 0, 100), +(726850, 6, 3056.705, 6837.825, 365.6625, 0, 0, 100), +(726850, 7, 3055.995, 6811.346, 363.9293, 0, 0, 100), +(726850, 8, 3051.553, 6788.479, 364.4403, 0, 0, 100), +(726850, 9, 3025.939, 6773.630, 364.6453, 0, 0, 100), +(726850, 10, 2997.430, 6779.065, 364.7881, 0, 0, 100), +(726850, 11, 2964.531, 6769.958, 364.9076, 0, 0, 100), +(726850, 12, 2930.315, 6776.338, 364.9512, 0, 0, 100), +(726850, 13, 2918.285, 6806.885, 364.6190, 0, 0, 100), +(726850, 14, 2912.431, 6842.140, 365.7422, 0, 0, 100), +(726850, 15, 2907.044, 6877.755, 364.9791, 0, 0, 100), +(726850, 16, 2916.668, 6926.684, 365.7089, 0, 0, 100), +(726850, 17, 2930.061, 6932.938, 366.6436, 0, 0, 100), +(726860, 1, 2951.619, 6767.854, 364.6956, 0, 0, 100), +(726860, 2, 2922.737, 6785.164, 364.3832, 0, 0, 100), +(726860, 3, 2914.164, 6816.449, 365.0359, 0, 0, 100), +(726860, 4, 2920.628, 6849.005, 364.0598, 0, 0, 100), +(726860, 5, 2923.062, 6874.683, 364.3661, 0, 0, 100), +(726860, 6, 2920.628, 6849.005, 364.0598, 0, 0, 100), +(726860, 7, 2914.164, 6816.449, 365.0359, 0, 0, 100), +(726860, 8, 2922.737, 6785.164, 364.3832, 0, 0, 100), +(726860, 9, 2951.619, 6767.854, 364.6956, 0, 0, 100), +(726860, 10, 2978.603, 6774.031, 364.6295, 0, 0, 100), +(726870, 1, 3039.297, 6961.447, 364.1785, 0, 0, 100), +(726870, 2, 3012.485, 6945.107, 364.1169, 0, 0, 100), +(726870, 3, 2995.014, 6930.641, 366.1848, 0, 0, 100), +(726870, 4, 2968.909, 6917.897, 364.4906, 0, 0, 100), +(726870, 5, 2940.915, 6905.415, 364.8960, 0, 0, 100), +(726870, 6, 2917.003, 6881.560, 363.7619, 0, 0, 100), +(726870, 7, 2904.496, 6860.631, 364.7486, 0, 0, 100), +(726870, 8, 2917.003, 6881.560, 363.7619, 0, 0, 100), +(726870, 9, 2940.915, 6905.415, 364.8960, 0, 0, 100), +(726870, 10, 2968.909, 6917.897, 364.4906, 0, 0, 100), +(726870, 11, 2995.014, 6930.641, 366.1848, 0, 0, 100), +(726870, 12, 3012.485, 6945.107, 364.1169, 0, 0, 100), +(726870, 13, 3039.297, 6961.447, 364.1785, 0, 0, 100), +(726870, 14, 3064.207, 6977.887, 364.1757, 0, 0, 100), +(726880, 1, 3044.975, 6783.440, 364.5978, 0, 0, 100), +(726880, 2, 3062.011, 6816.901, 365.1671, 0, 0, 100), +(726880, 3, 3063.646, 6845.110, 365.4035, 0, 0, 100), +(726880, 4, 3059.866, 6880.194, 364.2898, 0, 0, 100), +(726880, 5, 3063.646, 6845.110, 365.4035, 0, 0, 100), +(726880, 6, 3062.011, 6816.901, 365.1671, 0, 0, 100), +(726880, 7, 3044.975, 6783.440, 364.5978, 0, 0, 100), +(726880, 8, 3009.408, 6773.854, 365.3167, 0, 0, 100), +(726890, 1, 2898.859, 6898.955, 365.2638, 0, 0, 100), +(726890, 2, 2931.555, 6930.920, 366.7287, 0, 0, 100), +(726890, 3, 2964.605, 6955.362, 364.8635, 0, 0, 100), +(726890, 4, 2995.130, 6974.602, 365.3798, 0, 0, 100), +(726890, 5, 3030.536, 6990.398, 365.0394, 0, 0, 100), +(726890, 6, 3062.585, 7010.932, 365.6774, 0, 0, 100), +(726890, 7, 3030.536, 6990.398, 365.0394, 0, 0, 100), +(726890, 8, 2995.130, 6974.602, 365.3798, 0, 0, 100), +(726890, 9, 2964.605, 6955.362, 364.8635, 0, 0, 100), +(726890, 10, 2931.555, 6930.920, 366.7287, 0, 0, 100), +(726890, 11, 2898.859, 6898.955, 365.2638, 0, 0, 100), +(726890, 12, 2862.580, 6872.323, 364.4011, 0, 0, 100), +(726900, 1, 2978.880, 7105.396, 364.6908, 0, 0, 100), +(726900, 2, 2992.279, 7090.904, 364.7131, 0, 0, 100), +(726900, 3, 3016.816, 7084.032, 366.2536, 0, 0, 100), +(726900, 4, 3020.800, 7063.650, 365.4578, 0, 0, 100), +(726900, 5, 3020.802, 7046.065, 365.1304, 0, 0, 100), +(726900, 6, 3043.988, 7025.776, 366.3173, 0, 0, 100), +(726900, 7, 3061.027, 6997.979, 364.6350, 0, 0, 100), +(726900, 8, 3043.988, 7025.776, 366.3173, 0, 0, 100), +(726900, 9, 3020.802, 7046.065, 365.1304, 0, 0, 100), +(726900, 10, 3020.800, 7063.650, 365.4578, 0, 0, 100), +(726900, 11, 3016.816, 7084.032, 366.2536, 0, 0, 100), +(726900, 12, 2992.279, 7090.904, 364.7131, 0, 0, 100), +(726900, 13, 2978.880, 7105.396, 364.6908, 0, 0, 100), +(726900, 14, 2955.366, 7108.196, 365.3616, 0, 0, 100), +(726910, 1, 2880.686, 7128.017, 365.7320, 0, 0, 100), +(726910, 2, 2874.922, 7090.022, 364.8263, 0, 0, 100), +(726910, 3, 2873.347, 7047.713, 364.5892, 0, 0, 100), +(726910, 4, 2875.338, 7014.307, 364.8738, 0, 0, 100), +(726910, 5, 2881.305, 6991.716, 365.9776, 0, 0, 100), +(726910, 6, 2905.550, 6968.209, 365.4919, 0, 0, 100), +(726910, 7, 2942.239, 6956.793, 364.9129, 0, 0, 100), +(726910, 8, 2976.514, 6972.401, 364.4939, 0, 0, 100), +(726910, 9, 3005.753, 6985.610, 364.3358, 0, 0, 100), +(726910, 10, 3018.676, 7017.822, 364.7350, 0, 0, 100), +(726910, 11, 3019.727, 7052.344, 364.0334, 0, 0, 100), +(726910, 12, 3008.217, 7083.816, 364.1286, 0, 0, 100), +(726910, 13, 2985.435, 7114.537, 365.0980, 0, 0, 100), +(726910, 14, 2960.736, 7129.825, 365.3180, 0, 0, 100), +(726910, 15, 2945.326, 7145.546, 365.4655, 0, 0, 100), +(726910, 16, 2921.095, 7161.554, 365.1239, 0, 0, 100), +(726910, 17, 2894.340, 7156.020, 365.1386, 0, 0, 100), +(726920, 1, 2931.752, 7164.380, 365.3788, 0, 0, 100), +(726920, 2, 2896.417, 7145.616, 366.1021, 0, 0, 100), +(726920, 3, 2873.247, 7126.979, 365.7324, 0, 0, 100), +(726920, 4, 2844.990, 7116.991, 366.0155, 0, 0, 100), +(726920, 5, 2807.834, 7085.617, 365.9453, 0, 0, 100), +(726920, 6, 2781.440, 7062.177, 366.1049, 0, 0, 100), +(726920, 7, 2753.918, 7045.331, 365.4569, 0, 0, 100), +(726920, 8, 2781.440, 7062.177, 366.1049, 0, 0, 100), +(726920, 9, 2807.834, 7085.617, 365.9453, 0, 0, 100), +(726920, 10, 2844.990, 7116.991, 366.0155, 0, 0, 100), +(726920, 11, 2873.247, 7126.979, 365.7324, 0, 0, 100), +(726920, 12, 2896.417, 7145.616, 366.1021, 0, 0, 100), +(726920, 13, 2931.752, 7164.380, 365.3788, 0, 0, 100), +(726920, 14, 2959.552, 7175.740, 364.7140, 0, 0, 100); |