aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorTrista <aconstantgoal@abv.bg>2013-03-03 03:15:33 +0200
committerTrista <aconstantgoal@abv.bg>2013-03-03 03:16:17 +0200
commita108a9026af11a2b9d3fb40f37a523c3df7d93a1 (patch)
tree33e8948be23662798c08443667f5bd50f42796b9 /sql
parent6be5bc71eb667536d5f289aa8723766a912105da (diff)
Scripts/Eye of Eternity: Rewrite Arcane Barrage mechanic
* Note that even after last changes happens I'm not sure exactly how the timers are controlled. The wipe chance should be a lot smaller now.. Any further change I can think of is beyond what I see. The main problem is currently. In theory there is chance, If timers get to be same with delay lesser than 2 seconds and if target randomisations select same target for shit out of luck reason. And if starting different timers were matching you can be hit atleast 2-3 times and on 25 mode maybe more. The timers are not with fixed difference for sure is all I know.
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/2013_03_03_00_world_eye_of_eternity.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/2013_03_03_00_world_eye_of_eternity.sql b/sql/updates/world/2013_03_03_00_world_eye_of_eternity.sql
new file mode 100644
index 00000000000..e41f2723e5f
--- /dev/null
+++ b/sql/updates/world/2013_03_03_00_world_eye_of_eternity.sql
@@ -0,0 +1,6 @@
+-- Delete wrongly inserted spell linked spell of Scion of Eternity - "Arcane Barrage".
+-- It should be handled in the original caster spell with spellscript effect.
+DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=56397 AND `spell_effect`=63934 AND`type`=1;
+
+-- Update flags in creature for Malygos since differ from these in creature_template
+UPDATE `creature` SET `unit_flags`=320,`dynamicflags`=8 WHERE `id`=28859;