From f7f00d2f08e862dd7ec047b93a595f9f675bbdcf Mon Sep 17 00:00:00 2001 From: Dr-J Date: Wed, 21 Sep 2016 13:44:38 +0100 Subject: 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. --- sql/updates/world/3.3.5/2016_09_21_01_world.sql | 6 ++++++ 1 file changed, 6 insertions(+) create mode 100644 sql/updates/world/3.3.5/2016_09_21_01_world.sql (limited to 'sql') diff --git a/sql/updates/world/3.3.5/2016_09_21_01_world.sql b/sql/updates/world/3.3.5/2016_09_21_01_world.sql new file mode 100644 index 00000000000..c8dc9b1f7ac --- /dev/null +++ b/sql/updates/world/3.3.5/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'); -- cgit v1.2.3