From 5acdd6373f99baa8480dba867974b136ea11c6ca Mon Sep 17 00:00:00 2001 From: Aokromes Date: Mon, 24 Mar 2014 15:11:34 +0100 Subject: DB/Misc: Miscellaneous fixes By dr-j, closes #11780 Fix wrong loot in two chests for quest 'The Shadow Tomb'. Fix turning in of 13120 Deaths Gaze. Fix torching sunfury hold. --- sql/updates/world/2014_03_24_09_world_misc.sql | 6 ++++++ 1 file changed, 6 insertions(+) create mode 100644 sql/updates/world/2014_03_24_09_world_misc.sql diff --git a/sql/updates/world/2014_03_24_09_world_misc.sql b/sql/updates/world/2014_03_24_09_world_misc.sql new file mode 100644 index 00000000000..7b31ac09df7 --- /dev/null +++ b/sql/updates/world/2014_03_24_09_world_misc.sql @@ -0,0 +1,6 @@ +-- +UPDATE `gameobject_loot_template` SET `item`=31708 WHERE `entry`=21872 AND `item`=31709; +UPDATE `gameobject_loot_template` SET `item`=31709 WHERE `entry`=21870 AND `item`=31708; +UPDATE `smart_scripts` SET `target_type`=1 WHERE `entryorguid`=1972300 AND `source_type`=9 AND `id`=1 AND `link`=0; +UPDATE `smart_scripts` SET `target_type`=1 WHERE `entryorguid`=1972400 AND `source_type`=9 AND `id`=1 AND `link`=0; +UPDATE `conditions` SET `ElseGroup`=0 WHERE `ConditionValue1` = 13105 AND `SourceEntry` = 13120; -- cgit v1.2.3