diff options
| author | offl <offl@users.noreply.github.com> | 2021-01-08 23:26:25 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2022-03-05 22:30:18 +0100 |
| commit | cbb40fd77701b7712e942b7011a6e573ca24f5f0 (patch) | |
| tree | 22c832f5262ffea036e0042a7590cace022ffbc7 | |
| parent | 395bd7206dd25352a866fbe4226117c76c7fd00e (diff) | |
DB/Creature: Finish replacing UNIT_FLAG_IMMUNE by auras
(cherry picked from commit 2676c13713cb564bf21f2bf4b8c22f3f89670c53)
| -rw-r--r-- | sql/updates/world/master/2022_03_05_59_world_2021_01_08_03_world.sql | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_03_05_59_world_2021_01_08_03_world.sql b/sql/updates/world/master/2022_03_05_59_world_2021_01_08_03_world.sql new file mode 100644 index 00000000000..5f245c9b019 --- /dev/null +++ b/sql/updates/world/master/2022_03_05_59_world_2021_01_08_03_world.sql @@ -0,0 +1,17 @@ +-- +UPDATE `creature_template` SET `unit_flags` = `unit_flags` &~ 2147483648 WHERE `entry` IN (29399,27355,27989,33785,28006,29929,32286,33308); +UPDATE `creature_template` SET `unit_flags` = `unit_flags` &~ 262144 WHERE `entry` IN (27989,29929,32286,33308); +UPDATE `creature_template` SET `speed_walk` = 1.2, `speed_run` = 2 WHERE `entry` = 29929; + +DELETE FROM `creature_template_addon` WHERE `entry` IN (29399,27989,29929,32286,33308); +INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `visibilityDistanceType`, `auras`) VALUES +(29399, 0, 0, 0, 1, 0, 0, '54434'), +(27989, 0, 0, 0, 1, 0, 0, '28782'), +(29929, 0, 0, 0, 1, 0, 0, '60191 28782'), +(32286, 0, 0, 0, 1, 0, 0, '60190 28782'), +(33308, 0, 0, 0, 1, 0, 0, '28782'); -- Related quest was removed, guessed + +-- No idea how both of them are spawned, if one is spawned, second (29929) is not +DELETE FROM `creature` WHERE `guid` = 147173 AND `id` = 32286; +INSERT INTO `creature` (`guid`, `id`, `map`, `spawnDifficulties`, `phaseId`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `MovementType`, `VerifiedBuild`) VALUES +(147173, 32286, 571, '0', 0, 0, 0, 5913.654296875, 733.88067626953125, 641.177734375, 0.78539818525314331, 300, 0, 0, 12340); |