*Fix Death Knight Bloodworms (Heal every hit)

--HG--
branch : trunk

4 files changed, 25 insertions, 2 deletions

diff --git a/sql/FULL/world_spell_full.sql b/sql/FULL/world_spell_full.sql
index 08ae9073047..e02cb7e8fad 100644
--- a/sql/FULL/world_spell_full.sql
+++ b/sql/FULL/world_spell_full.sql
@@ -1496,8 +1496,8 @@ INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `Spell
 ( 48545, 0x00,   7, 0x00000010, 0x04000000, 0x00000000, 0x00040000, 0x00000000,   0,   0,   0), -- Revitalize
 ( 53234, 0x00,   9, 0x00020000, 0x00000001, 0x00000001, 0x00000000, 0x00000002,   0,   0,   0), -- Piercing Shots (Rank 1)
 ( 53237, 0x00,   9, 0x00020000, 0x00000001, 0x00000001, 0x00000000, 0x00000002,   0,   0,   0), -- Piercing Shots (Rank 2)
-( 53238, 0x00,   9, 0x00020000, 0x00000001, 0x00000001, 0x00000000, 0x00000002,   0,   0,   0); -- Piercing Shots (Rank 3)
-
+( 53238, 0x00,   9, 0x00020000, 0x00000001, 0x00000001, 0x00000000, 0x00000002,   0,   0,   0), -- Piercing Shots (Rank 3)
+( 50453, 0x00,   0, 0x00000000, 0x00000000, 0x00000000, 0x00000004, 0x00000000,   0, 100,   0); -- Health Leech (Passive)
 
 -- --------
 -- ENCHANT PROC
diff --git a/sql/FULL/world_tmp_full.sql b/sql/FULL/world_tmp_full.sql
index bfbb28a38b5..e9b7308ac22 100644
--- a/sql/FULL/world_tmp_full.sql
+++ b/sql/FULL/world_tmp_full.sql
@@ -168,6 +168,12 @@ update creature_template set maxhealth = 133525, minhealth = 133525, maxmana = 5
 
 UPDATE `creature` SET `phaseMask`=128 WHERE `id` IN (31082,29173,29199,29204,29200);
 
+-- Bloodworms Health Leech Aura
+INSERT INTO `creature_template_addon` (`entry`, `auras`) VALUES 
+('28017', '50453 0') # Health Leech (Passive) Aura
+ON DUPLICATE KEY UPDATE
+auras = VALUES(auras);
+
 -- --------
 -- NAXXARAMAS
 -- --------
diff --git a/sql/updates/4663_world.sql b/sql/updates/4663_world.sql
new file mode 100644
index 00000000000..a205226b0fd
--- /dev/null
+++ b/sql/updates/4663_world.sql
@@ -0,0 +1,5 @@
+DELETE FROM `spell_proc_event` WHERE `entry` = 50453;
+INSERT INTO `spell_proc_event` (`entry`, `procFlags`, `CustomChance`) VALUES ('50453', '0x00000004', '100');
+
+DELETE FROM `creature_template_addon` WHERE `entry` = 28017;
+INSERT INTO `creature_template_addon` (`entry`, `auras`) VALUES ('28017', '50453 0');
\ No newline at end of file
diff --git a/src/game/Unit.cpp b/src/game/Unit.cpp
index a42a9de65de..c72187df8f3 100644
--- a/src/game/Unit.cpp
+++ b/src/game/Unit.cpp
@@ -4923,6 +4923,18 @@ bool Unit::HandleDummyAuraProc(Unit *pVictim, uint32 damage, AuraEffect* trigger
         {
             switch (dummySpell->Id)
             {
+                // BloodWorms Health Leech
+                case 50453:
+                {
+                    if (Unit *owner = this->GetOwner())
+                    {
+                        basepoints0 = int32(damage);
+                        target = owner;
+                        triggered_spell_id = 50454;
+                        break;
+                    } 
+                    return false;
+                }
                 // Improved Divine Spirit
                 case 33174:
                 case 33182: