aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorQAston <none@none>2009-05-18 19:00:20 +0200
committerQAston <none@none>2009-05-18 19:00:20 +0200
commit6c7f2d2b242f950ab0e80a9da546806e672d37c1 (patch)
tree905e7a9a829721f2c65cbf075c86f4f5b6d724d4 /sql
parente45c57f298acfb496947be150dd379e3f39bc673 (diff)
*Spell_proc_event entries for Malestorm Weapon - by throneinc
*Fix bug that some spells can't proc *Add spell_proc_event entries for some items. --HG-- branch : trunk
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/3392_world_spell_proc_event.sql20
1 files changed, 20 insertions, 0 deletions
diff --git a/sql/updates/3392_world_spell_proc_event.sql b/sql/updates/3392_world_spell_proc_event.sql
new file mode 100644
index 00000000000..d0965c1a7ab
--- /dev/null
+++ b/sql/updates/3392_world_spell_proc_event.sql
@@ -0,0 +1,20 @@
+DELETE FROM `spell_proc_event` WHERE `entry` IN
+(27521, 55381, 62459, 60176, 60529, 60717, 62147, 57907, 51528, 51529, 51530, 51531, 51532);
+INSERT INTO `spell_proc_event`
+(`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`)
+VALUES
+-- malestorm weapon
+(51528, 0, 0, 0, 0, 0, 0, 0, 2.5, 0, 0),
+(51529, 0, 0, 0, 0, 0, 0, 0, 5, 0, 0),
+(51530, 0, 0, 0, 0, 0, 0, 0, 7.5, 0, 0),
+(51531, 0, 0, 0, 0, 0, 0, 0, 10, 0, 0),
+(51532, 0, 0, 0, 0, 0, 0, 0, 12.5, 0, 0),
+
+(27521, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00010000, 0.000000, 0.000000, 15),
+(55381, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00010000, 0.000000, 0.000000, 15),
+(62459, 0x00, 15, 0x00000004, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 0),
+(60176, 0x00, 4, 0x00000020, 0x00000010, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 0),
+(60529, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 45),
+(60717, 0x00, 7, 0x00000002, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 100.000000, 0),
+(62147, 0x00, 15, 0x00000002, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 0),
+(57907, 0x00, 7, 0x00000002, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 0);