From 73d247240475138f5d7f9e3feba057c647ed77aa Mon Sep 17 00:00:00 2001 From: offl Date: Sat, 28 Nov 2020 02:13:50 +0200 Subject: DB/Creature: Add CREATURE_FLAG_EXTRA_NO_COMBAT to jewelcrafting stone statues & root them Closes #20406 --- sql/updates/world/3.3.5/2020_11_28_00_world.sql | 10 ++++++++++ 1 file changed, 10 insertions(+) create mode 100644 sql/updates/world/3.3.5/2020_11_28_00_world.sql (limited to 'sql') 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); -- cgit v1.2.3