From cefd1f94d71c67d7c74e50c0ae1a8ed873ddc9bd Mon Sep 17 00:00:00 2001 From: Killyana Date: Wed, 6 Feb 2019 10:47:44 +0100 Subject: DB/Creature: Add invisibility auras related Roanauk Icemist (cherry picked from commit 3a83dc60d5bde02312c4efe5c59506fe2d5ca8b8) --- .../2021_11_23_14_world_2019_02_06_02_world.sql | 24 ++++++++++++++++++++++ 1 file changed, 24 insertions(+) create mode 100644 sql/updates/world/master/2021_11_23_14_world_2019_02_06_02_world.sql (limited to 'sql/updates') diff --git a/sql/updates/world/master/2021_11_23_14_world_2019_02_06_02_world.sql b/sql/updates/world/master/2021_11_23_14_world_2019_02_06_02_world.sql new file mode 100644 index 00000000000..d0537b308ed --- /dev/null +++ b/sql/updates/world/master/2021_11_23_14_world_2019_02_06_02_world.sql @@ -0,0 +1,24 @@ +-- +UPDATE `creature_template_addon` SET `auras`="47395" WHERE `entry` IN (26654,26772,26656,26608); +DELETE FROM `creature_template_addon` WHERE `entry` IN (26319,26606,26777,26676,26778); +INSERT INTO `creature_template_addon` (`entry`, `auras`) VALUES +(26676,"47396"),(26319,"47396"),(26606,"47396"),(26777,"47395"),(26778,"47395"); +UPDATE `creature_addon` SET `auras` ="47396" WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` IN (26319, 26606)); + +DELETE FROM `spell_area` WHERE `area` IN (4163) AND `spell`=47396; +INSERT INTO `spell_area` (`spell`,`area`,`quest_start`,`quest_end`,`aura_spell`,`racemask`,`gender`,`flags`,`quest_start_status`, `quest_end_status`) VALUES +(47396, 4163, 0, 12069, 0, 0, 2, 3, 0, 11); + +DELETE FROM `gameobject_addon` WHERE `guid`=5544; +INSERT INTO `gameobject_addon` (`guid`, `invisibilityType`, `invisibilityValue`) VALUES (5544, 5, 1000); + +DELETE FROM `creature_template_addon` WHERE `entry` IN (26810); +INSERT INTO `creature_template_addon` (`entry`, `auras`) VALUES +(26810,"47417"); + +DELETE FROM `spell_area` WHERE `area` IN (4165) AND `spell`=47418; +INSERT INTO `spell_area` (`spell`,`area`,`quest_start`,`quest_end`,`aura_spell`,`racemask`,`gender`,`flags`,`quest_start_status`, `quest_end_status`) VALUES +(47418, 4165, 12069, 0, 0, 0, 2, 3, 64, 0); + +UPDATE `creature_addon` SET `auras` ="47418" WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` IN (26437)); +UPDATE `creature_template_addon` SET `auras`="47786 47418" WHERE `entry`=26379; -- cgit v1.2.3