diff options
| author | Dr-J <daniel.jarrott0@gmail.com> | 2016-01-17 11:26:28 +0000 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2016-04-10 12:36:48 +0200 |
| commit | c4683842d5f167010ba7a83ce41c1145379e50d5 (patch) | |
| tree | be219c5b269247ecdc4f2ecec453da86180a9423 | |
| parent | 46a75bae001da8557fa8fbd6b84db160d670b4ce (diff) | |
DB/Misc: Flight Master SAI
Use proper spells to summon enraged wyverns, gryphons, hippogryphs and felbats instead of directly summoning with SAI action 12, also remove second line of all scripts as all of these used 2 lines of sai to summon two npcs on agro, the spells summon 2 in one cast so only one line needed.
(cherry picked from commit 83efabefe896146cf6d55d0341abed2a47c7459f)
| -rw-r--r-- | sql/updates/world/2016_04_10_06_world_2016_01_17_05_world.sql | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/sql/updates/world/2016_04_10_06_world_2016_01_17_05_world.sql b/sql/updates/world/2016_04_10_06_world_2016_01_17_05_world.sql new file mode 100644 index 00000000000..081b0147b3c --- /dev/null +++ b/sql/updates/world/2016_04_10_06_world_2016_01_17_05_world.sql @@ -0,0 +1,16 @@ +UPDATE `spelleffect_dbc` SET `Effect`=28, `EffectMiscValueB`=64 WHERE `EffectSpellId` IN (14313,14307,14252) AND `EffectIndex`=0; + +-- Spell 14313 Summon Enraged Gryphon +-- Spell 14307 Summon Enraged Wyvern +-- Spell 14252 Summon Enraged Felbat +-- Spell 14329 Summon Enraged Hippogryph + +DELETE FROM `smart_scripts` WHERE `source_type` =0 AND `action_type` =12 AND `action_param1` =9297 AND `id`=1; +DELETE FROM `smart_scripts` WHERE `source_type` =0 AND `action_type` =12 AND `action_param1` =9526 AND `id`=1; +DELETE FROM `smart_scripts` WHERE `source_type` =0 AND `action_type` =12 AND `action_param1` =9521 AND `id`=1; +DELETE FROM `smart_scripts` WHERE `source_type` =0 AND `action_type` =12 AND `action_param1` =9527 AND `id`=1; + +UPDATE `smart_scripts` SET `action_type`=11, `action_param1`=14307, `action_param2`=2, `action_param3`=0,`link`=0 WHERE `source_type` =0 AND `action_type` =12 AND `action_param1` =9297; +UPDATE `smart_scripts` SET `action_type`=11, `action_param1`=14313, `action_param2`=2, `action_param3`=0,`link`=0 WHERE `source_type` =0 AND `action_type` =12 AND `action_param1` =9526; +UPDATE `smart_scripts` SET `action_type`=11, `action_param1`=14252, `action_param2`=2, `action_param3`=0,`link`=0 WHERE `source_type` =0 AND `action_type` =12 AND `action_param1` =9521; +UPDATE `smart_scripts` SET `action_type`=11, `action_param1`=14329, `action_param2`=2, `action_param3`=0,`link`=0 WHERE `source_type` =0 AND `action_type` =12 AND `action_param1` =9527; |