-- Update Proc Rate INSERT INTO `spell_proc_event` VALUES ('60442', '0', '0', '0', '0', '0', '0', '0', '0', '0', '45'); INSERT INTO `spell_proc_event` VALUES ('57345', '0', '0', '0', '0', '0', '0', '0', '0', '0', '45'); INSERT INTO `spell_proc_event` VALUES ('61356', '0', '0', '0', '0', '0', '0', '0', '0', '0', '45'); INSERT INTO `spell_proc_event` VALUES ('54707', '0', '0', '0', '0', '0', '0', '0', '0', '0', '60'); INSERT INTO `spell_proc_event` VALUES ('54808', '0', '0', '0', '0', '0', '0', '0', '0', '0', '60'); -- Update Spell Coefficients DELETE FROM `spell_bonus_data` WHERE `entry` IN ('689', '18790', '172', '42223', '42224', '42225', '42226', '42218', '47817', '47818', '1949', '5857', '11681', '11682', '27214', '47822', '27243', '30108', '17962', '6789', '48181', '29722', '5676', '686', '17877', '30283', '1120', '30294', '44425', '42208', '42209', '42210', '42211', '42212', '42213', '42198', '42937', '42938', '11113', '31661', '120', '19750', '635', '25914', '25913', '25903', '27175', '33074', '48820', '48821', '58597', '31803', '53742', '31893', '32221', '53719', '53718', '20167', '20424', '31804', '53733', '31898', '32220', '53726', '53725', '20267', '20187', '20467', '53600', '596', '2944', '8092', '27813', '27817', '27818', '33619'); INSERT INTO `spell_bonus_data` (`entry`, `direct_bonus`, `dot_bonus`, `ap_bonus`, `comments`) VALUES ('689', '0', '0.143', '0', 'Warlock - Drain Life'), ('18790', '0', '0', '0','Warlock - Fel Stamina'), ('172', '0', '0.2', '0', 'Warlock - Corruption'), ('42223', '0.6932', '0', '0', 'Warlock - Rain of Fire Triggered Rank 1'), ('42224', '0.6932', '0', '0', 'Warlock - Rain of Fire Triggered Rank 2'), ('42225', '0.6932', '0', '0', 'Warlock - Rain of Fire Triggered Rank 3'), ('42226', '0.6932', '0', '0', 'Warlock - Rain of Fire Triggered Rank 4'), ('42218', '0.6932', '0', '0', 'Warlock - Rain of Fire Triggered Rank 5'), ('47817', '0.6932', '0', '0', 'Warlock - Rain of Fire Triggered Rank 6'), ('47818', '0.6932', '0', '0', 'Warlock - Rain of Fire Triggered Rank 7'), ('1949', '0', '0.0949', '0', 'Warlock - Hellfire'), ('5857', '0.1427', '0', '0', 'Warlock - Hellfire Effect on Enemy Rank 1'), ('11681', '0.1427', '0', '0', 'Warlock - Hellfire Effect on Enemy Rank 2'), ('11682', '0.1427', '0', '0', 'Warlock - Hellfire Effect on Enemy Rank 3'), ('27214', '0.1427', '0', '0', 'Warlock - Hellfire Effect on Enemy Rank 4'), ('47822', '0.1427', '0', '0', 'Warlock - Hellfire Effect on Enemy Rank 5'), ('27243', '0.2129', '0.25', '0', 'Warlock - Seed of Corruption'), ('30108', '0', '0.2', '0', 'Warlock - Unstable Affliction'), ('17962', '0.4293', '0', '0', 'Warlock - Conflagrate'), ('6789', '0.214', '0', '0', 'Warlock - Death Coil'), ('48181', '0.4793', '0', '0', 'Warlock - Haunt'), ('29722', '0.7139', '0', '0', 'Warlock - Incinerate'), ('5676', '0.4293', '0', '0', 'Warlock - Searing Pain'), ('686', '0.8569', '0', '0', 'Warlock - Shadow Bolt'), ('17877', '0.4293', '0', '0', 'Warlock - Shadowburn'), ('30283', '0.1932', '0', '0', 'Warlock - Shadowfury'), ('1120', '0', '0.429', '0', 'Warlock - Drain Soul'), ('30294', '0', '0', '0', 'Warlock - Soul Leech'), ('44425', '0.7143', '0', '0', 'Mage - Arcane Barrage'), ('42208', '0.1437', '0', '0', 'Mage - Blizzard Triggered Spell Rank 1'), ('42209', '0.1437', '0', '0', 'Mage - Blizzard Triggered Spell Rank 2'), ('42210', '0.1437', '0', '0', 'Mage - Blizzard Triggered Spell Rank 3'), ('42211', '0.1437', '0', '0', 'Mage - Blizzard Triggered Spell Rank 4'), ('42212', '0.1437', '0', '0', 'Mage - Blizzard Triggered Spell Rank 5'), ('42213', '0.1437', '0', '0', 'Mage - Blizzard Triggered Spell Rank 6'), ('42198', '0.1437', '0', '0', 'Mage - Blizzard Triggered Spell Rank 7'), ('42937', '0.1437', '0', '0', 'Mage - Blizzard Triggered Spell Rank 8'), ('42938', '0.1437', '0', '0', 'Mage - Blizzard Triggered Spell Rank 9'), ('11113', '0.1936', '0', '0', 'Mage - Blast Wave Rank'), ('31661', '0.1936', '0', '0', 'Mage - Dragons Breath'), ('120', '0.214', '0', '0', 'Mage - Cone of Cold'), ('19750', '1', '0', '0', 'Paladin - Flash of Light'), ('635', '1.66', '0', '0', 'Paladin - Holy Light'), ('25914', '0.81', '0', '0', 'Paladin - Holy Shock Triggered Heal Rank 1'), ('25913', '0.81', '0', '0', 'Paladin - Holy Shock Triggered Heal Rank 2'), ('25903', '0.81', '0', '0', 'Paladin - Holy Shock Triggered Heal Rank 3'), ('27175', '0.81', '0', '0', 'Paladin - Holy Shock Triggered Heal Rank 4'), ('33074', '0.81', '0', '0', 'Paladin - Holy Shock Triggered Heal Rank 5'), ('48820', '0.81', '0', '0', 'Paladin - Holy Shock Triggered Heal Rank 6'), ('48821', '0.81', '0', '0', 'Paladin - Holy Shock Triggered Heal Rank 7'), ('58597', '0.75', '0', '0', 'Paladin - Sacred Shield'), ('31803', '0', '0.018', '0.03', 'Paladin - Holy Vengeance'), ('53742', '0', '0.018', '0.03', 'Paladin - Blood Corruption'), ('31893', '0', '0', '0', 'Paladin - Seal of Blood Enemy Proc'), ('32221', '0', '0', '0', 'Paladin - Seal of Blood Self Proc'), ('53719', '0', '0', '0', 'Paladin - Seal of The Martyr Enemy Proc'), ('53718', '0', '0', '0', 'Paladin - Seal of The Martyr Self Proc'), ('20167', '0.15', '0', '0.15', 'Paladin - Seal of Light Proc'), ('20424', '0.1035', '0', '0', 'Paladin - Seal of Command Proc'), ('31804', '0.22', '0', '0.14', 'Paladin - Judgement of Vengeance'), ('53733', '0.22', '0', '0.14', 'Paladin - Judgement of Corruption'), ('31898', '0.25', '0', '0.16', 'Paladin - Judgement of Blood Enemy'), ('32220', '0', '0', '0', 'Paladin - Judgement of Blood Self'), ('53726', '0.25', '0', '0.16', 'Paladin - Judgement of the Martyr Enemy'), ('53725', '0', '0', '0', 'Paladin - Judgement of the Martyr Self'), ('20267', '0.1', '0', '0.1', 'Paladin - Judgement of Light Proc'), ('20187', '0.4', '0', '0.25', 'Paladin - Judgement of Righteousness'), ('20467', '0.25', '0', '0.16', 'Paladin - Judgement of Command'), ('53600', '0', '0', '0', 'Paladin - Shield of Righteousness'), ('596', '0.8068', '0', '0', 'Priest - Prayer of Healing'), ('2944', '0.8149', '0', '0', 'Priest - Devouring Plague'), ('8092', '0.428', '0', '0', 'Priest - Mind Blast'), ('27813', '0', '0', '0', 'Priest - Blessed Recovery Rank 1'), ('27817', '0', '0', '0', 'Priest - Blessed Recovery Rank 2'), ('27818', '0', '0', '0', 'Priest - Blessed Recovery Rank 3'), ('33619', '0', '0', '0', 'Priest - Reflective Shield');