diff options
| author | offl <offl@users.noreply.github.com> | 2020-11-28 02:13:50 +0200 |
|---|---|---|
| committer | offl <offl@users.noreply.github.com> | 2020-11-28 02:13:50 +0200 |
| commit | 73d247240475138f5d7f9e3feba057c647ed77aa (patch) | |
| tree | a455eef9be0e186ff5349485e2dce3d95db07966 | |
| parent | b2fd442f64c5671709a4dc6e0521855b94f9b0b9 (diff) | |
DB/Creature: Add CREATURE_FLAG_EXTRA_NO_COMBAT to jewelcrafting stone statues & root them
Closes #20406
| -rw-r--r-- | sql/updates/world/3.3.5/2020_11_28_00_world.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2020_11_28_00_world.sql b/sql/updates/world/3.3.5/2020_11_28_00_world.sql new file mode 100644 index 00000000000..cca56a14537 --- /dev/null +++ b/sql/updates/world/3.3.5/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); |