*Add some procflags- by Darkshines.

*Add new spell_coefficient data-by cccyril and Sephiroth1983

--HG--
branch : trunk

3 files changed, 88 insertions, 2 deletions

diff --git a/sql/updates/1693_world.sql b/sql/updates/1693_world.sql
new file mode 100644
index 00000000000..6806dab4c42
--- /dev/null
+++ b/sql/updates/1693_world.sql
@@ -0,0 +1,86 @@
+-- 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');
diff --git a/sql/updates/CMakeLists.txt b/sql/updates/CMakeLists.txt
index 984885be39c..0a14069a933 100644
--- a/sql/updates/CMakeLists.txt
+++ b/sql/updates/CMakeLists.txt
@@ -61,4 +61,5 @@ INSTALL(FILES
 1663_mangos_7376_01_world_spell_area.sql
 1679_world.sql
 1688_mangos_7382_01_world_creature_template.sql
+1693_world.sql
 DESTINATION share/trinity/sql/updates)
diff --git a/src/game/Unit.cpp b/src/game/Unit.cpp
index c201c73d1ab..60018a88a9c 100644
--- a/src/game/Unit.cpp
+++ b/src/game/Unit.cpp
@@ -8705,8 +8705,7 @@ uint32 Unit::SpellHealingBonus(Unit *pVictim, SpellEntry const *spellProto, uint
         spellProto->Id == 33778 || spellProto->Id == 379   ||
         spellProto->Id == 38395 || spellProto->Id == 40972 ||
         spellProto->Id == 22845 || spellProto->Id == 33504 ||
-        spellProto->Id == 34299 || spellProto->Id == 27813 ||
-        spellProto->Id == 27817 || spellProto->Id == 27818)
+        spellProto->Id == 34299)
         return healamount;
 
     // Healing Done