diff options
| -rw-r--r-- | sql/updates/world/master/2021_11_21_15_world_2019_01_12_06_world.sql | 70 |
1 files changed, 70 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_11_21_15_world_2019_01_12_06_world.sql b/sql/updates/world/master/2021_11_21_15_world_2019_01_12_06_world.sql new file mode 100644 index 00000000000..b168e80e7f3 --- /dev/null +++ b/sql/updates/world/master/2021_11_21_15_world_2019_01_12_06_world.sql @@ -0,0 +1,70 @@ +-- +DELETE FROM `creature` WHERE `guid` IN (78317,78318,78319,78320,78321,78322,78323); +DELETE FROM `creature_addon` WHERE `guid` IN (78317,78318,78319,78320,78321,78322,78323); +DELETE FROM `spawn_group` WHERE `spawnType`=0 AND `spawnId` IN (78317,78318,78319,78320,78321,78322,78323); +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 +(78317, 22282, 530, '0', 0, 0, 0, 2806.079, 7076.457, 365.5324, 5.671391, 300, 0, 0, 349, 0, 2), +(78318, 22282, 530, '0', 0, 0, 0, 2990.224, 6785.195, 364.8759, 6.074828, 300, 0, 0, 349, 0, 2), +(78319, 22282, 530, '0', 0, 0, 0, 2910.094, 7068.237, 364.9525, 1.489692, 300, 0, 0, 349, 0, 2); + +DELETE FROM `creature_addon` WHERE `guid` IN (78317,78318,78319); +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES +(78317, 783170, 0, 0, 0, "8278 8279"), +(78318, 783180, 0, 0, 0, "8278 8279"), +(78319, 783190, 0, 0, 0, "8278 8279"); + +DELETE FROM `waypoint_data` WHERE `id` IN (783170,783180,783190); +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`action`, `action_chance`) VALUES +(783170, 1, 2852.453, 7043.906, 364.9724, 0, 0, 100), +(783170, 2, 2851.765, 7012.301, 364.6559, 0, 0, 100), +(783170, 3, 2829.326, 6977.799, 364.4576, 0, 0, 100), +(783170, 4, 2801.134, 6979.436, 365.2224, 0, 0, 100), +(783170, 5, 2778.260, 6996.175, 363.9151, 0, 0, 100), +(783170, 6, 2762.791, 7004.948, 365.7821, 0, 0, 100), +(783170, 7, 2747.056, 7022.587, 364.3496, 0, 0, 100), +(783170, 8, 2758.387, 7045.114, 365.2759, 0, 0, 100), +(783170, 9, 2785.369, 7059.199, 365.5059, 0, 0, 100), +(783170, 10, 2806.417, 7073.966, 365.1748, 0, 0, 100), +(783170, 11, 2826.553, 7073.792, 364.4439, 0, 0, 100), +(783170, 12, 2839.854, 7063.182, 364.3952, 0, 0, 100), +(783180, 1, 3004.284, 6782.222, 364.5349, 0, 0, 100), +(783180, 2, 3027.782, 6782.367, 364.5132, 0, 0, 100), +(783180, 3, 3046.018, 6798.135, 364.0664, 0, 0, 100), +(783180, 4, 3053.277, 6812.616, 363.8491, 0, 0, 100), +(783180, 5, 3047.935, 6837.430, 364.5686, 0, 0, 100), +(783180, 6, 3038.779, 6852.491, 364.0435, 0, 0, 100), +(783180, 7, 3037.607, 6879.542, 365.1363, 0, 0, 100), +(783180, 8, 3027.673, 6905.063, 363.9569, 0, 0, 100), +(783180, 9, 3004.303, 6913.749, 364.1187, 0, 0, 100), +(783180, 10, 2980.841, 6915.414, 364.1449, 0, 0, 100), +(783180, 11, 2954.499, 6915.431, 364.1512, 0, 0, 100), +(783180, 12, 2934.219, 6898.214, 363.9237, 0, 0, 100), +(783180, 13, 2927.351, 6874.112, 364.6876, 0, 0, 100), +(783180, 14, 2936.430, 6849.208, 364.0913, 0, 0, 100), +(783180, 15, 2927.728, 6827.473, 364.3772, 0, 0, 100), +(783180, 16, 2928.914, 6804.495, 364.5570, 0, 0, 100), +(783180, 17, 2942.147, 6790.945, 367.7448, 0, 0, 100), +(783180, 18, 2970.093, 6787.654, 366.9110, 0, 0, 100), +(783180, 19, 2993.219, 6783.612, 364.5096, 0, 0, 100), +(783190, 1, 2912.509, 7098.010, 366.5352, 0, 0, 100), +(783190, 2, 2917.027, 7111.693, 365.4970, 0, 0, 100), +(783190, 3, 2931.005, 7119.402, 365.3638, 0, 0, 100), +(783190, 4, 2955.236, 7115.543, 365.7521, 0, 0, 100), +(783190, 5, 2965.510, 7102.121, 365.2693, 0, 0, 100), +(783190, 6, 2970.492, 7091.273, 365.5998, 0, 0, 100), +(783190, 7, 3009.455, 7077.002, 363.8786, 0, 0, 100), +(783190, 8, 3017.801, 7054.702, 364.5884, 0, 0, 100), +(783190, 9, 3010.720, 7028.245, 364.7604, 0, 0, 100), +(783190, 10, 2995.655, 7015.955, 364.8122, 0, 0, 100), +(783190, 11, 2969.312, 7020.586, 365.2711, 0, 0, 100), +(783190, 12, 2956.298, 7005.951, 364.1656, 0, 0, 100), +(783190, 13, 2939.820, 6990.127, 364.7526, 0, 0, 100), +(783190, 14, 2912.716, 6998.517, 366.2108, 0, 0, 100), +(783190, 15, 2900.004, 7025.863, 365.1796, 0, 0, 100), +(783190, 16, 2904.133, 7044.475, 365.6597, 0, 0, 100), +(783190, 17, 2909.150, 7063.064, 365.5295, 0, 0, 100), +(783190, 18, 2917.076, 7082.824, 364.2726, 0, 0, 100); + +DELETE FROM `creature_template_addon` WHERE entry = 22282; +INSERT INTO `creature_template_addon` (`entry`, `auras`) VALUES +(22282, "8278 8279"); |