diff options
| author | offl <offl@users.noreply.github.com> | 2020-11-28 02:13:50 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2022-03-01 23:45:19 +0100 |
| commit | b5d088c13e45793604781e5c46ffee05847b8a6a (patch) | |
| tree | a6ca991edee1433f030732a09b5e8f35c8031b2b | |
| parent | f53ac12d2dc1bef4d5559057d7317db1f8270ea9 (diff) | |
DB/Creature: Add CREATURE_FLAG_EXTRA_NO_COMBAT to jewelcrafting stone statues & root them
Closes #20406
(cherry picked from commit 73d247240475138f5d7f9e3feba057c647ed77aa)
| -rw-r--r-- | sql/updates/world/master/2022_03_01_16_world_2020_11_28_00_world.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_03_01_16_world_2020_11_28_00_world.sql b/sql/updates/world/master/2022_03_01_16_world_2020_11_28_00_world.sql new file mode 100644 index 00000000000..cca56a14537 --- /dev/null +++ b/sql/updates/world/master/2022_03_01_16_world_2020_11_28_00_world.sql @@ -0,0 +1,10 @@ +-- Add CREATURE_FLAG_EXTRA_NO_COMBAT to jewelcrafting stone statues & root them, taken from CreatureDifficulty +UPDATE `creature_template` SET `flags_extra` = `flags_extra` | 0x00002000 WHERE `entry` IN (18372,18734,18735,18736,18737,18738); +DELETE FROM `creature_template_movement` WHERE `CreatureId` IN (18372,18734,18735,18736,18737,18738); +INSERT INTO `creature_template_movement` (`CreatureId`,`Ground`,`Swim`,`Flight`,`Rooted`,`Chase`,`Random`) VALUES +(18372,1,1,0,1,0,0), +(18734,1,1,0,1,0,0), +(18735,1,1,0,1,0,0), +(18736,1,1,0,1,0,0), +(18737,1,1,0,1,0,0), +(18738,1,1,0,1,0,0); |