From 65a204c5b24746237177e5ce8abbaca5a1bbdcf0 Mon Sep 17 00:00:00 2001 From: Killyana Date: Mon, 29 Jun 2020 22:15:27 +0200 Subject: DB/Creature: Fix some models and add missing auras for Ice Crown creatures --- sql/updates/world/3.3.5/2020_06_29_05_world.sql | 8 ++++++++ 1 file changed, 8 insertions(+) create mode 100644 sql/updates/world/3.3.5/2020_06_29_05_world.sql (limited to 'sql') diff --git a/sql/updates/world/3.3.5/2020_06_29_05_world.sql b/sql/updates/world/3.3.5/2020_06_29_05_world.sql new file mode 100644 index 00000000000..da9da9e8d39 --- /dev/null +++ b/sql/updates/world/3.3.5/2020_06_29_05_world.sql @@ -0,0 +1,8 @@ +-- +DELETE FROM `creature_template_addon` WHERE `entry` IN (32149,32255); +INSERT INTO `creature_template_addon` (`entry`, `bytes1`, `bytes2`, `auras`) VALUES +(32149, 0, 1, "54262"), +(32255, 0, 1, "54262 60231"); +UPDATE `creature` SET `modelid`=27774 WHERE `id`=32257; +UPDATE `creature` SET `modelid`=25796 WHERE `guid`IN (123325,123293,123294,123295,123296,123297,123298,123299,123300,123301,123302,123303,123323,123321,123320,123307,123324,123315,123310,123311,123312); +UPDATE `creature` SET `modelid`=27775 WHERE `guid`IN (123313,123314,123309,123316,123317,123318,123319,123306,123305,123322,123304,123308,123292); -- cgit v1.2.3