diff options
| -rw-r--r-- | sql/updates/world/master/2021_12_16_24_world_2019_07_21_00_world.sql | 42 |
1 files changed, 42 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_12_16_24_world_2019_07_21_00_world.sql b/sql/updates/world/master/2021_12_16_24_world_2019_07_21_00_world.sql new file mode 100644 index 00000000000..f5a77858ee5 --- /dev/null +++ b/sql/updates/world/master/2021_12_16_24_world_2019_07_21_00_world.sql @@ -0,0 +1,42 @@ +-- +DELETE FROM `creature` WHERE `id` IN (24401) AND `guid` IN (3413); +INSERT INTO `creature` (`guid`, `id`, `map`, `spawnDifficulties`, `phaseId`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `MovementType`) VALUES +(3413, 24401, 571, '0', 0, 0, 2095.209, -3292.818, 101.3649, 4.641705, 300, 0, 2); + +DELETE FROM `creature_addon` WHERE `guid` IN (3413); +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes1`, `bytes2`, `auras`) VALUES +(3413,34130,0,1,''); + +DELETE FROM `waypoint_data` WHERE `id` IN (34130); +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`, `orientation`, `action_chance`, `move_type`, `wpguid`) VALUES +(34130,1,2095.20922, -3292.81884, 101.364, 4.641705,100,0,0), +(34130,2,2094.89111, -3311.33300, 101.955, 6.145737,100,0,0), +(34130,3,2099.41210, -3311.42675, 101.954, 0.121730,100,0,0), +(34130,4,2099.97973, -3307.15014, 100.179, 1.537576,100,0,0), +(34130,5,2100.40771, -3298.41064, 94.3826, 1.521868,100,0,0), +(34130,6,2101.35864, -3288.54223, 94.2854, 1.474744,100,0,0), +(34130,7,2101.49902, -3280.49340, 88.7989, 1.561138,100,0,0), +(34130,8,2101.70336, -3270.23266, 88.5468, 1.502233,100,0,0), +(34130,9,2101.09228, -3257.89111, 82.4200, 1.655385,100,0,0), +(34130,10,2097.74365, -3249.10278, 83.2737, 2.052012,100,0,0), +(34130,11,2086.64428, -3243.50390, 81.2624, 2.523251,100,0,0), +(34130,12,2062.80493, -3220.85498, 66.3459, 2.330827,100,0,0), +(34130,13,2052.91210, -3211.60668, 61.8431, 2.413294,100,0,0), +(34130,14,2033.85388, -3218.87426, 60.4876, 3.528560,100,0,0), +(34130,15,2038.03088, -3230.86474, 67.1839, 5.040448,100,0,0), +(34130,16,2039.27075, -3234.91210, 67.8137, 5.071866,100,0,0), +(34130,17,2029.62963, -3239.62109, 67.8150, 3.587464,100,0,0), +(34130,18,2021.72204, -3231.11962, 73.1200, 2.358315,100,0,0), +(34130,19,2017.34863, -3226.76318, 74.9953, 2.413291,100,0,0), +(34130,20,2013.76757, -3232.61157, 75.1035, 4.137241,100,0,0), +(34130,21,2012.68872, -3246.90820, 76.3393, 4.651675,100,0,0), +(34130,22,2003.27307, -3243.10229, 81.4615, 2.747084,100,0,0), +(34130,23,1995.15039, -3246.12280, 87.2953, 3.905547,100,0,0), +(34130,24,1989.51843, -3251.86377, 90.3872, 4.035137,100,0,0), +(34130,25,1987.91503, -3262.31054, 90.2657, 4.647748,100,0,0), +(34130,26,2003.28906, -3262.70239, 84.4219, 0.002111,100,0,0), +(34130,27,2035.14440, -3262.96313, 81.8778, 6.269589,100,0,0), +(34130,28,2064.42260, -3263.36108, 89.8672, 6.269589,100,0,0), +(34130,29,2065.47338, -3282.10278, 96.0460, 4.757699,100,0,0), +(34130,30,2066.49877, -3291.60571, 99.0877, 4.840164,100,0,0), +(34130,31,2083.29345, -3292.95312, 100.413, 6.269583,100,0,0); |