diff options
| -rw-r--r-- | sql/updates/world/master/2022_02_28_41_world_2020_10_20_03_world.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_02_28_41_world_2020_10_20_03_world.sql b/sql/updates/world/master/2022_02_28_41_world_2020_10_20_03_world.sql new file mode 100644 index 00000000000..13b4a44df37 --- /dev/null +++ b/sql/updates/world/master/2022_02_28_41_world_2020_10_20_03_world.sql @@ -0,0 +1,10 @@ +-- +UPDATE `creature_template` SET `speed_walk` = 0.6, `speed_run` = 0.21428, `BaseAttackTime` = 2000, `RangeAttackTime` = 2000, `unit_flags` = 33555200 WHERE `entry` = 17408; +DELETE FROM `creature_template_addon` WHERE `entry` = 17408; +INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `visibilityDistanceType`, `auras`) VALUES +(17408,0,0,0,1,0,0,"30627"); + +DELETE FROM `creature` WHERE `guid` IN (131087,131088) AND `id` = 17408; +INSERT INTO `creature` (`guid`, `id`, `map`, `spawnDifficulties`, `phaseId`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `MovementType`, `VerifiedBuild`) VALUES +(131087, 17408, 530, '0', 0, 0, 2887.78, 3226.63, 174.500, 2.43434, 3600, 15, 1, 14007), +(131088, 17408, 530, '0', 0, 0, 2796.53, 4342.95, 143.658, 5.30526, 3600, 15, 1, 14007); |