[8249] Implement support `spell_proc_item_enchant` table for ppm item enchantments triggering at hit.

    * Added a new SQL table, spell_proc_item_enchant, for "custom" ppmRates on Item Enchants that do not use auras.
      With table data this must fix ppm for effect from 8033 and ranks enchanting, and item 6947/10918 and ranks enchanting.

    * Implemented SPELLMOD_FREQUENCY_OF_SUCCESS (26).
      That must fix work talent 14113, spell 32645 with ranks, glyph 41094 and item set effect 64917 in frequency part.

    Thanks to MaS0n as author alternative patch that partly used in this patch.
    Thanks to Thenecromancer as author alternative patch that ideas inspire MaS0n's patch writing and then this patch also.

Author: nos4r2zod

*Note: has been implemented before. Only use part of the patch.

--HG--
branch : trunk

2 files changed, 44 insertions, 0 deletions

diff --git a/sql/updates/8249_01_mangos_spell_proc_item_enchant.sql.tbd b/sql/updates/8249_01_mangos_spell_proc_item_enchant.sql.tbd
new file mode 100644
index 00000000000..d1502ba40fe
--- /dev/null
+++ b/sql/updates/8249_01_mangos_spell_proc_item_enchant.sql.tbd
@@ -0,0 +1,13 @@
+ALTER TABLE db_version CHANGE COLUMN required_8247_01_mangos_spell_bonus_data required_8249_01_mangos_spell_proc_item_enchant bit;
+
+DROP TABLE IF EXISTS `spell_proc_item_enchant`;
+CREATE TABLE `spell_proc_item_enchant` (
+  `entry` mediumint unsigned NOT NULL,
+  `ppmRate` float NOT NULL default '0',
+  PRIMARY KEY  (`entry`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+INSERT INTO `spell_proc_item_enchant` (`entry`, `ppmRate`) VALUES
+(8034, 9),        -- Frostbrand Weapon
+(8680, 8.5714),   -- Instant Poison
+(13218, 21.4286); -- Wound Poison
diff --git a/sql/updates/8249_02_mangos_spell_chain.sql.tbd b/sql/updates/8249_02_mangos_spell_chain.sql.tbd
new file mode 100644
index 00000000000..f3fda91c872
--- /dev/null
+++ b/sql/updates/8249_02_mangos_spell_chain.sql.tbd
@@ -0,0 +1,31 @@
+ALTER TABLE db_version CHANGE COLUMN required_8249_01_mangos_spell_proc_item_enchant required_8249_02_mangos_spell_chain bit;
+
+DELETE FROM `spell_chain` WHERE `spell_id` IN
+(8034, 8037, 10458, 16352, 16353, 25501, 58797, 58798, 58799, 8680, 8685, 8689, 11335, 11336, 11337, 26890, 57964, 57965, 13218, 13222, 13223, 13224, 27189, 57974, 57975);
+
+INSERT INTO `spell_chain` (`spell_id`, `prev_spell`, `first_spell`, `rank`, `req_spell`) VALUES
+(8034,0,8034,1,0),     -- Frostbrand Attack
+(8037,8034,8034,2,0),
+(10458,8037,8034,3,0),
+(16352,10458,8034,4,0),
+(16353,16352,8034,5,0),
+(25501,16353,8034,6,0),
+(58797,25501,8034,7,0),
+(58798,58797,8034,8,0),
+(58799,58798,8034,9,0),
+(8680,0,8680,1,0),     -- Instant Poison
+(8685,8680,8680,2,0),
+(8689,8685,8680,3,0),
+(11335,8689,8680,4,0),
+(11336,11335,8680,5,0),
+(11337,11336,8680,6,0),
+(26890,11337,8680,7,0),
+(57964,26890,8680,8,0),
+(57965,57964,8680,9,0),
+(13218,0,13218,1,0),   -- Wound Poison
+(13222,13218,13218,2,0),
+(13223,13222,13218,3,0),
+(13224,13223,13218,4,0),
+(27189,13224,13218,5,0),
+(57974,27189,13218,6,0),
+(57975,57974,13218,7,0);