DB/Creature: Akiak

(cherry picked from commit 28182839299fdcbf9589bdb97df9bc33a016c7b6)

1 files changed, 38 insertions, 0 deletions

diff --git a/sql/updates/world/master/2021_11_13_14_world_2018_10_09_04_world.sql b/sql/updates/world/master/2021_11_13_14_world_2018_10_09_04_world.sql
new file mode 100644
index 00000000000..c07526b2c40
--- /dev/null
+++ b/sql/updates/world/master/2021_11_13_14_world_2018_10_09_04_world.sql
@@ -0,0 +1,38 @@
+-- 
+UPDATE `creature_template` SET `unit_flags`=`unit_flags`|768 WHERE `entry` IN (35467);
+DELETE FROM `creature` WHERE `guid` IN (86812);
+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
+(86812, 35467, 571, '0', 0, 0, 1, 8479.33, 925.866, 547.417, 4.64556, 180, 0, 0, 12600, 3994, 2);
+
+DELETE FROM `creature_addon` WHERE `guid`=86812;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`) VALUES
+(86812,868120,1);
+ 
+DELETE FROM `waypoint_data` WHERE `id`=868120;
+INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES
+(868120, 1, 8475.17, 916.134, 547.293, 0, 0, 0, 0, 100, 0),
+(868120, 2, 8471.26, 872.369, 547.293, 0, 0, 0, 0, 100, 0),
+(868120, 3, 8433.57, 869.6, 547.293, 0, 0, 0, 0, 100, 0),
+(868120, 4, 8383.37, 866.064, 547.996, 0, 0, 0, 0, 100, 0),
+(868120, 5, 8374.31, 854.443, 548.057, 0, 0, 0, 0, 100, 0),
+(868120, 6, 8373.3, 799.335, 547.883, 0, 0, 0, 0, 100, 0),
+(868120, 7, 8398.38, 748.893, 547.294, 0, 0, 0, 0, 100, 0),
+(868120, 8, 8449.56, 700.685, 547.293, 0, 0, 0, 0, 100, 0),
+(868120, 9, 8491.39, 634.759, 547.314, 0, 0, 0, 0, 100, 0),
+(868120, 10, 8530.6, 629.929, 547.87, 0, 0, 0, 0, 100, 0),
+(868120, 11, 8547.71, 644.872, 548.144, 0, 0, 0, 0, 100, 0),
+(868120, 12, 8555.03, 663.977, 547.429, 0, 0, 0, 0, 100, 0),
+(868120, 13, 8556.33, 690.393, 547.294, 0, 0, 0, 0, 100, 0),
+(868120, 14, 8596.05, 737.548, 547.387, 0, 0, 0, 0, 100, 0),
+(868120, 15, 8641.43, 777.416, 547.557, 0, 0, 0, 0, 100, 0),
+(868120, 16, 8644.1, 803.667, 547.542, 0, 0, 0, 0, 100, 0),
+(868120, 17, 8619.9, 828.956, 547.554, 0, 0, 0, 0, 100, 0),
+(868120, 18, 8570.29, 880.802, 547.554, 0, 0, 0, 0, 100, 0),
+(868120, 19, 8572.02, 927.925, 547.554, 0, 0, 0, 0, 100, 0),
+(868120, 20, 8576.05, 992.858, 547.307, 0, 0, 0, 0, 100, 0),
+(868120, 21, 8551.46, 1020.99, 547.293, 0, 0, 0, 0, 100, 0),
+(868120, 22, 8528.56, 1027.69, 547.293, 0, 0, 0, 0, 100, 0),
+(868120, 23, 8486.6, 1024.48, 547.367, 0, 0, 0, 0, 100, 0),
+(868120, 24, 8475.21, 1012, 547.294, 0, 0, 0, 0, 100, 0),
+(868120, 25, 8475.26, 962.42, 547.294, 0, 0, 0, 0, 100, 0),
+(868120, 26, 8474.58, 926.349, 547.294, 0, 0, 0, 0, 100, 0);