From 5d5753c8bc3a3ca9cd426c01eea9036f4416cd67 Mon Sep 17 00:00:00 2001 From: Dr-J Date: Mon, 26 Sep 2016 11:43:48 +0100 Subject: DB/Misc: Updates 1) http://www.wowhead.com/item=24330 should drop if player is on or is rewarded for http://www.wowhead.com/quest=9720/balance-must-be-preserved not only if rewarded for it 2) http://www.wowhead.com/quest=7170/earned-reverence http://www.wowhead.com/quest=7171/legendary-heroes and http://www.wowhead.com/quest=7172/the-eye-of-command should not be repeatable, especially when they require insignia from previous quest and when set as repeatable since quest status never gets saved in database player cannot proceed and when player already turned quest in and received next tier insignia the quest can never be repeated. 3) Fix a issue with http://www.wowhead.com/npc=3771/bleakheart-hellcaller spamming summons 4) Fix timed action list for http://www.wowhead.com/quest=11429/drop-it-then-rock-it --- sql/updates/world/3.3.5/2016_09_26_01_world.sql | 6 ++++++ 1 file changed, 6 insertions(+) create mode 100644 sql/updates/world/3.3.5/2016_09_26_01_world.sql (limited to 'sql') diff --git a/sql/updates/world/3.3.5/2016_09_26_01_world.sql b/sql/updates/world/3.3.5/2016_09_26_01_world.sql new file mode 100644 index 00000000000..04b3804fce7 --- /dev/null +++ b/sql/updates/world/3.3.5/2016_09_26_01_world.sql @@ -0,0 +1,6 @@ +UPDATE `smart_scripts` SET `event_flags`=`event_flags`|0x200 WHERE `entryorguid`IN(2464000) AND `source_type`=9; +UPDATE `conditions` SET `ElseGroup`=1, `ConditionValue1`=9720, `NegativeCondition`=0 WHERE `SourceTypeOrReferenceId`=1 AND `SourceEntry`=24330 AND `ConditionValue1`=9731; +UPDATE `quest_template_addon` SET `SpecialFlags`=0 WHERE `ID` IN(7170,7171,7172); +UPDATE `smart_scripts` SET `event_flags`=1 WHERE `entryorguid`=3771 AND `source_type`=0 AND `id` IN(1,3); +UPDATE `smart_scripts` SET `link`=2 WHERE `entryorguid`=3771 AND `source_type`=0 AND `id`=3 AND `link`=0; +UPDATE `smart_scripts` SET `event_type`=25 WHERE `entryorguid`=3771 AND `source_type`=0 AND `id`=0 AND `link`=0; -- cgit v1.2.3