diff options
| author | treeston <treeston.mmoc@gmail.com> | 2016-09-02 23:14:50 +0200 |
|---|---|---|
| committer | treeston <treeston.mmoc@gmail.com> | 2016-09-02 23:14:50 +0200 |
| commit | e9eacae7b2ca3c8899a6ee9c8b8146e21fca54db (patch) | |
| tree | afb091a42277c5c737dbe16ba5bd5072c8d2f1c8 /sql | |
| parent | be8d1136994fd5f0a90b03a52d21c9503857f15f (diff) | |
| parent | 96f90381e3ed696861354ea4ddf4ac0c495031c5 (diff) | |
Merge branch '3.3.5-goshdangitsmartai' into 3.3.5 (PR #17738)
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/3.3.5/2016_09_02_03_world.sql | 27 |
1 files changed, 27 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2016_09_02_03_world.sql b/sql/updates/world/3.3.5/2016_09_02_03_world.sql new file mode 100644 index 00000000000..435919c5071 --- /dev/null +++ b/sql/updates/world/3.3.5/2016_09_02_03_world.sql @@ -0,0 +1,27 @@ +-- set "execute event while charmed" flag on all events except: +-- -) movement actions +-- -) nontriggered cast actions +-- -) talk/emote/sound actions +-- -) ally summon actions +ALTER TABLE `smart_scripts` MODIFY COLUMN `event_flags` SMALLINT(3) UNSIGNED NOT NULL DEFAULT '0'; +UPDATE `smart_scripts` SET `event_flags`=(`event_flags`|0x200) WHERE `source_type`=0 AND + (`action_type` not in (1,4,5,10,11,12,17,25,27,38,39,40,49,62,69,84,85,86,89,92,97,103,107,114) OR + (`action_type` in (11,86) AND (`action_param2`&2)=2)); + + +-- assorted quest fixes (no claim to completeness) +-- Seeds of Chaos (13172) +UPDATE `smart_scripts` SET `event_flags`=(`event_flags`|0x200) WHERE `source_type`=0 AND `entryorguid`=31157; +UPDATE `smart_scripts` SET `event_type`=29, `comment`="Skeletal Assault Gryphon - On Charmed - Start Waypoint" WHERE `source_type`=0 AND `entryorguid`=31157 AND `id`=0; +-- Generosity Abounds (13146) +UPDATE `smart_scripts` SET `event_flags`=(`event_flags`|0x200) WHERE `source_type`=0 AND `entryorguid`=30894; +-- Battling the Elements (12967) +UPDATE `smart_scripts` SET `event_flags`=(`event_flags`|0x200) WHERE `source_type`=0 AND `entryorguid`=30124; +-- Krolmir, Hammer of Storms (13010) +UPDATE `smart_scripts` SET `event_flags`=(`event_flags`|0x200) WHERE `source_type`=0 AND `entryorguid`=30331; +UPDATE `smart_scripts` SET `event_type`=29 WHERE `source_type`=0 AND `entryorguid`=30331 AND `id`=0; +UPDATE `smart_scripts` SET `target_type`=23 WHERE `source_type`=0 AND `entryorguid`=30331 AND `id`=1; +UPDATE `smart_scripts` SET `event_flags`=(`event_flags`|0x200) WHERE `source_type`=9 AND `entryorguid`=3033100; +-- Spy Hunter (12994) +UPDATE `smart_scripts` SET `event_flags`=(`event_flags`|0x200) WHERE `source_type`=0 AND `entryorguid`=30219; +UPDATE `smart_scripts` SET `event_flags`=(`event_flags`|0x200) WHERE `source_type`=9 AND `entryorguid` IN (3021900,3021901,3021902); |