diff options
| author | Aokromes <Aokromes@users.noreply.github.com> | 2014-03-24 15:11:34 +0100 |
|---|---|---|
| committer | Aokromes <Aokromes@users.noreply.github.com> | 2014-03-24 15:11:34 +0100 |
| commit | 5acdd6373f99baa8480dba867974b136ea11c6ca (patch) | |
| tree | eb21f59c481fa9990ec5e8d6ac99cad3254772ba /sql/updates | |
| parent | 899b6da4dc69b475fb765989742ff3307ec5d759 (diff) | |
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.
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/world/2014_03_24_09_world_misc.sql | 6 |
1 files changed, 6 insertions, 0 deletions
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; |