diff options
| author | Dr-J <daniel.jarrott0@gmail.com> | 2016-08-14 14:30:47 +0100 |
|---|---|---|
| committer | joschiwald <joschiwald.trinity@gmail.com> | 2017-02-12 14:54:00 +0100 |
| commit | a71aa14d3ed72f92cbd58bebbd224b648271c0c9 (patch) | |
| tree | f482cd4d0ee5abf64a40d829323e9e5066874a03 | |
| parent | 4f7db62f4b48b94431dba63d40b4003442aec29f (diff) | |
DB/Misc: Updates
1) Update to conditions for Zombiefest as previous conditions appear to have stopped working correctly
2) Update for Dark Subjugator to prevent these becoming bugged, also correct unit flags for the sentrys to prevent these from agroing player if too close and dropping immune subjugator if killed
3) Conditions to prevent console spam from Bone Warrior closes #17655
(cherry picked from commit c515cdc636beefa83bb1a022a18f34ca053dcd53)
| -rw-r--r-- | sql/updates/world/master/2017_02_12_03_world_2016_08_14_02_world.sql | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_02_12_03_world_2016_08_14_02_world.sql b/sql/updates/world/master/2017_02_12_03_world_2016_08_14_02_world.sql new file mode 100644 index 00000000000..e05f32dac7a --- /dev/null +++ b/sql/updates/world/master/2017_02_12_03_world_2016_08_14_02_world.sql @@ -0,0 +1,16 @@ +UPDATE `conditions` SET `ConditionValue1`=12, `ConditionValue3`=0 WHERE `SourceTypeOrReferenceId`=22 AND `Comment`='Execute SAI only if Arthas Started'; +UPDATE`conditions` SET `ConditionValue1`=1 WHERE `SourceTypeOrReferenceId`=22 AND `Comment`='Execute SAI only if Salramm not done'; + +UPDATE`creature_template` SET `unit_flags`=256 WHERE `entry`=32292; + +DELETE FROM `smart_scripts` WHERE `entryorguid`=32236 AND `source_type`=0 AND `id`=10; +DELETE FROM `smart_scripts` WHERE `entryorguid`=32236 AND `source_type`=0 AND `id`>14; +INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(32236, 0, 10, 15, 61, 0, 100, 0, 0, 0, 0, 0, 48, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Dark Subjugator - Link - Set Active'), +(32236, 0, 15, 16, 61, 0, 100, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Dark Subjugator - Link - Set Passive'), +(32236, 0, 16, 17, 61, 0, 100, 0, 0, 0, 0, 0, 20, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Dark Subjugator - Link - Disable Auto Attack'), +(32236, 0, 17, 0, 61, 0, 100, 0, 0, 0, 0, 0, 21, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Dark Subjugator - Link - Disable Combat Movement'); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=22 AND `SourceEntry`=25758; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(22, 1, 25758, 0, 0, 31, 0, 4, 0, 0, 0, 0, 0, '', 'Defendo-tank 66D - Only run SAI if invoker is player'); |