aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorDr-J <daniel.jarrott0@gmail.com>2016-09-21 13:44:38 +0100
committerjoschiwald <joschiwald.trinity@gmail.com>2017-03-02 20:53:21 +0100
commitf204e758d568608a3b6ee7b8870d679a5d58bbf0 (patch)
treeea1b1751dc66b5708937ea14165a0634905fe98e
parent86ecdaf44aa620530dde0f22aaacac20e64a66a6 (diff)
DB/Quest: Escape from Silverbrook
Even though this was meant to have been fixed once the last commit did not actually fix this also condition for the periodic spell so that it only targets silverbrook worgen rather than agroing neutral deers and stags, hostile npcs like bears and conquest hold guards will still attack the horse but the condition prevents the periodic threat spell from hitting anything other than silverbrook worgen. (cherry picked from commit f7f00d2f08e862dd7ec047b93a595f9f675bbdcf)
-rw-r--r--sql/updates/world/master/2017_03_02_05_world_2016_09_21_01_world.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_03_02_05_world_2016_09_21_01_world.sql b/sql/updates/world/master/2017_03_02_05_world_2016_09_21_01_world.sql
new file mode 100644
index 00000000000..c8dc9b1f7ac
--- /dev/null
+++ b/sql/updates/world/master/2017_03_02_05_world_2016_09_21_01_world.sql
@@ -0,0 +1,6 @@
+UPDATE `smart_scripts` SET `event_flags`=512 WHERE `entryorguid`=27409 AND `source_type`=0;
+UPDATE `smart_scripts` SET `event_flags`=512 WHERE `entryorguid`=2740900 AND `source_type`=9;
+
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`=48682;
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
+(13, 2, 48682, 0, 0, 31, 0, 3, 27417, 0, 0, 0, 0, '', 'Escape from Silverbrook - Periodic Dummy targets Silverbrook Worgen');