From 66bd3459e4bdcdec8bcd86631e585b5614061666 Mon Sep 17 00:00:00 2001 From: Killyana Date: Wed, 24 May 2017 17:03:39 +0200 Subject: DB/GamObject: Sons of Hodir Gameobject quest givers Visibility Closes #19787 --- sql/updates/world/3.3.5/2017_05_24_01_world.sql | 9 +++++++++ 1 file changed, 9 insertions(+) create mode 100644 sql/updates/world/3.3.5/2017_05_24_01_world.sql (limited to 'sql/updates') diff --git a/sql/updates/world/3.3.5/2017_05_24_01_world.sql b/sql/updates/world/3.3.5/2017_05_24_01_world.sql new file mode 100644 index 00000000000..38301839719 --- /dev/null +++ b/sql/updates/world/3.3.5/2017_05_24_01_world.sql @@ -0,0 +1,9 @@ +-- +UPDATE `gameobject_addon` SET `invisibilityType`=9, `invisibilityValue`=1000 WHERE `guid`=270; +UPDATE `gameobject_addon` SET `invisibilityType`=8, `invisibilityValue`=1000 WHERE `guid`=21077; +UPDATE `gameobject_addon` SET `invisibilityType`=5, `invisibilityValue`=1000 WHERE `guid`=21079; +DELETE FROM `spell_area` WHERE `spell` IN (56773,56772,56774) AND `area`=4438; +INSERT INTO `spell_area` (`spell`, `area`, `quest_start`, `quest_end`, `aura_spell`, `racemask`, `gender`, `autocast`, `quest_start_status`, `quest_end_status`) VALUES +(56773, 4438, 12987, 0, 0, 0, 2, 1, 66, 0), +(56772, 4438, 13001, 0, 0, 0, 2, 1, 64, 0), +(56774, 4438, 12976, 0, 0, 0, 2, 1, 64, 0); -- cgit v1.2.3