DB/SAI: The Demoniac Scryer (Update)

Changes to script so that credit is only given at end of event rather than after first wave of mobs due to timer aura been removed on evade

(cherry picked from commit 4b6930e2d0a5b37ae1eb697964cfe785b8dfb2a6)

1 files changed, 6 insertions, 0 deletions

diff --git a/sql/updates/world/master/2020_07_17_06_world_2017_06_16_00_world.sql b/sql/updates/world/master/2020_07_17_06_world_2017_06_16_00_world.sql
new file mode 100644
index 00000000000..9d3e0109ae4
--- /dev/null
+++ b/sql/updates/world/master/2020_07_17_06_world_2017_06_16_00_world.sql
@@ -0,0 +1,6 @@
+UPDATE `smart_scripts` SET `event_flags`=512 WHERE  `entryorguid`=22258 AND `source_type`=0 AND `id`IN(4,5);
+UPDATE `smart_scripts` SET `action_type`=22, `action_param1`=2, `comment`='Demoniac Scryer - Script - Set Phase 2' WHERE  `entryorguid`=2225800 AND `source_type`=9 AND `id` IN(25,27,29);
+UPDATE `smart_scripts` SET `event_phase_mask`=2, `comment`='Demoniac Scryer - On Gossip Hello (Phase 2) - Send Gossip' WHERE  `entryorguid`=22258 AND `source_type`=0 AND `id`=10 AND `link`=0;
+UPDATE `smart_scripts` SET `link`=0, `event_type`=54, `comment`='Demoniac Scryer - On Just SUmmoned  - Cast Magic Sucker Device timer' WHERE  `entryorguid`=22258 AND `source_type`=0 AND `id`=4 AND `link`=5;
+UPDATE `smart_scripts` SET `event_type`=1, `event_param3`=1000, `event_param4`=1000, `comment`='Demoniac Scryer - OOC  - Cast Magic Sucker Device Bunny Appearance' WHERE  `entryorguid`=22258 AND `source_type`=0 AND `id`=5 AND `link`=0;
+DELETE FROM `conditions` WHERE  `SourceTypeOrReferenceId`=22 AND `SourceGroup`=11 AND `SourceEntry`=22258 AND `SourceId`=0 AND `ElseGroup`=0 AND `ConditionTypeOrReference`=1 AND `ConditionTarget`=1 AND `ConditionValue1`=38672 AND `ConditionValue2`=0 AND `ConditionValue3`=0;