aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorQAston <none@none>2009-06-29 22:17:26 +0200
committerQAston <none@none>2009-06-29 22:17:26 +0200
commit527f36108b45f987efcc757e471e7774b9822efc (patch)
treea3b0f688931264185e770a9e7182ef7ffb4b2e45
parentac298912791642051c3df4d03282f68089758409 (diff)
*PPM for instant and wound poison.
--HG-- branch : trunk
-rw-r--r--sql/FULL/world_spell_full.sql37
-rw-r--r--sql/updates/4320_world_.sql20
2 files changed, 48 insertions, 9 deletions
diff --git a/sql/FULL/world_spell_full.sql b/sql/FULL/world_spell_full.sql
index 6f947ee09b4..f4ad2cbc48c 100644
--- a/sql/FULL/world_spell_full.sql
+++ b/sql/FULL/world_spell_full.sql
@@ -1437,15 +1437,34 @@ INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `Spell
-- --------
TRUNCATE TABLE `spell_enchant_proc_data`;
INSERT INTO spell_enchant_proc_data (`entry`, `customChance`, `PPMChance`,`procEx`) VALUES
-(2, 0, 8.8,0), -- Frostbrand Weapon
-(12, 0, 8.8,0), -- Frostbrand Weapon
-(524, 0, 8.8,0), -- Frostbrand Weapon
-(1667, 0, 8.8,0), -- Frostbrand Weapon
-(1668, 0, 8.8,0), -- Frostbrand Weapon
-(2635, 0, 8.8,0), -- Frostbrand Weapon
-(3782, 0, 8.8,0), -- Frostbrand Weapon
-(3783, 0, 8.8,0), -- Frostbrand Weapon
-(3784, 0, 8.8,0); -- Frostbrand Weapon
+ -- Frostbrand Weapon
+(2, 0, 8.8,0),
+(12, 0, 8.8,0),
+(524, 0, 8.8,0),
+(1667, 0, 8.8,0),
+(1668, 0, 8.8,0),
+(2635, 0, 8.8,0),
+(3782, 0, 8.8,0),
+(3783, 0, 8.8,0),
+(3784, 0, 8.8,0),
+ -- Wound Poison
+(703, 0, 21.43,0),
+(704, 0, 21.43,0),
+(705, 0, 21.43,0),
+(706, 0, 21.43,0),
+(2644, 0, 21.43,0),
+(3772, 0, 21.43,0),
+(3773, 0, 21.43,0),
+ -- Instant Poison
+(323, 0, 8.53,0),
+(324, 0, 8.53,0),
+(325, 0, 8.53,0),
+(623, 0, 8.53,0),
+(624, 0, 8.53,0),
+(625, 0, 8.53,0),
+(2641, 0, 8.53,0),
+(3768, 0, 8.53,0),
+(3769, 0, 8.53,0);
-- --------
-- SPELL AFFECT
diff --git a/sql/updates/4320_world_.sql b/sql/updates/4320_world_.sql
new file mode 100644
index 00000000000..a89e44b88b2
--- /dev/null
+++ b/sql/updates/4320_world_.sql
@@ -0,0 +1,20 @@
+DELETE FROM `spell_enchant_proc_data` WHERE `entry` IN (703, 704, 705, 706, 2644, 3772, 3773, 323, 324, 325, 623, 624, 625, 2641, 3768, 3769);
+INSERT INTO spell_enchant_proc_data (`entry`, `customChance`, `PPMChance`,`procEx`) VALUES
+ -- Wound Poison
+(703, 0, 21.43,0),
+(704, 0, 21.43,0),
+(705, 0, 21.43,0),
+(706, 0, 21.43,0),
+(2644, 0, 21.43,0),
+(3772, 0, 21.43,0),
+(3773, 0, 21.43,0),
+ -- Instant Poison
+(323, 0, 8.53,0),
+(324, 0, 8.53,0),
+(325, 0, 8.53,0),
+(623, 0, 8.53,0),
+(624, 0, 8.53,0),
+(625, 0, 8.53,0),
+(2641, 0, 8.53,0),
+(3768, 0, 8.53,0),
+(3769, 0, 8.53,0);