Scripts/Spells: Fixed remaining spells with SPELL_ATTR3_CAN_PROC_FROM_PROCS attribute

1 files changed, 234 insertions, 0 deletions

diff --git a/sql/updates/world/master/2023_06_27_01_world.sql b/sql/updates/world/master/2023_06_27_01_world.sql
new file mode 100644
index 00000000000..9d7ebbe393d
--- /dev/null
+++ b/sql/updates/world/master/2023_06_27_01_world.sql
@@ -0,0 +1,234 @@
+DELETE FROM `spell_proc` WHERE `SpellId` IN (107971,109794,109796,109939,109956,109960,144586,144671,144909,190493,191336,205039,208051,209352,234867,235641,235897,236578,236763,242057,242058,272892,284558,284567,287378,288846,297721,299375,299377,
+335054,335891,335893,335894,335895,335896,335902,336063,336065,336215,336902,336907,336908,337159,337163,337169,338339,338340,338343,338492,339230,339423,339424,340006,340694,341324,342632,342779,342793,342799,345672,346279,348908,354569,357833,
+363500,363682,364470,366779,370455,371032,373748,373761,376103,376938,378014,378268,378269,378750,378848,381773,382888,383115,383394,383634,383958,383977,383980,384667,385627,385726,385728,386737,386878,387432,388218,389102,389449,390154,390370,
+390371,391102,391165,391172,391683,392296,392972,393647,393648,393654,393670,393672,393688,394298,394312,394366,394667,395006,404522,404542,405547,405549,408461,408575,410530,410939,410964);
+INSERT INTO `spell_proc` (`SpellId`,`SchoolMask`,`SpellFamilyName`,`SpellFamilyMask0`,`SpellFamilyMask1`,`SpellFamilyMask2`,`SpellFamilyMask3`,`ProcFlags`,`ProcFlags2`,`SpellTypeMask`,`SpellPhaseMask`,`HitMask`,`AttributesMask`,`DisableEffectsMask`,`ProcsPerMinute`,`Chance`,`Cooldown`,`Charges`) VALUES
+(107971,0x00,0,0x00000000,0x00000000,0x00000000,0x00000000,0x0,0x0,0x1,0x2,0x403,0x0,0x0,0,0,0,0), -- Item - Dragon Soul Stacking Caster Trinket
+(109794,0x00,0,0x00000000,0x00000000,0x00000000,0x00000000,0x0,0x0,0x1,0x2,0x403,0x0,0x0,0,0,0,0), -- Item - Dragon Soul Stacking Caster Trinket
+(109796,0x00,0,0x00000000,0x00000000,0x00000000,0x00000000,0x0,0x0,0x1,0x2,0x403,0x0,0x0,0,0,0,0), -- Item - Dragon Soul Stacking Caster Trinket
+(109939,0x00,0,0x00000000,0x00000000,0x00000000,0x00000000,0x0,0x0,0x1,0x2,0x403,0x0,0x0,0,0,0,0), -- Item - Dragon Soul Legendary Daggers
+(109956,0x00,0,0x00000000,0x00000000,0x00000000,0x00000000,0x0,0x0,0x1,0x2,0x403,0x0,0x0,0,0,0,0), -- Item - Dragon Soul Legendary Daggers
+(109960,0x00,0,0x00000000,0x00000000,0x00000000,0x00000000,0x0,0x0,0x1,0x2,0x403,0x0,0x0,0,0,0,0), -- Item - Dragon Soul Legendary Daggers
+(144586,0x00,10,0x00000000,0x00000002,0x00000000,0x00000000,0x0,0x0,0x1,0x2,0x403,0x0,0x0,0,0,0,0), -- Item - Paladin T16 Retribution 2P Bonus
+(144671,0x00,9,0x00000001,0x00000000,0x00000000,0x00000400,0x0,0x0,0x1,0x2,0x403,0x0,0x0,0,0,0,0), -- Item - Hunter T16 BM 4P Player Driver
+(144909,0x00,15,0x00000000,0x00000000,0x00000000,0x00000000,0x0,0x0,0x1,0x2,0x403,0x0,0x0,0,0,0,0), -- Item - Death Knight T16 DPS 4P Bonus (Hidden)
+(190493,0x00,11,0x00000003,0x80000000,0x00000000,0x00000001,0x0,0x0,0x1,0x2,0x403,0x0,0x0,0,0,0,0), -- Fulmination
+(191336,0x00,9,0x00080000,0x00000000,0x00000000,0x00000000,0x0,0x0,0x1,0x2,0x403,0x0,0x0,0,0,0,0), -- Hunting Companion
+(205039,0x00,3,0x00000000,0x00000000,0x00000000,0x00000000,0x0,0x0,0x1,0x2,0x403,0x0,0x0,0,0,0,0), -- Erosion
+(208051,0x00,0,0x00000000,0x00000000,0x00000000,0x00000000,0x0,0x0,0x7,0x2,0x5403,0x0,0x0,0,0,0,0), -- Sephuz's Secret
+(209352,0x00,0,0x00000000,0x00000000,0x00000000,0x00000000,0x0,0x0,0x4,0x2,0x403,0x0,0x0,0,0,0,0), -- Boost 2.0 [Paladin+Priest] - Watch for Shield
+(234867,0x00,0,0x00000000,0x00000000,0x00000000,0x00000000,0x0,0x0,0x7,0x2,0x5403,0x0,0x0,0,0,0,0), -- Sephuz's Secret
+(235641,0x00,0,0x00000000,0x00000000,0x00000000,0x00000000,0x0,0x0,0x1,0x2,0x403,0x0,0x0,0,0,0,0), -- Furious Strides
+(235897,0x00,0,0x00000000,0x00000000,0x00000000,0x00000000,0x0,0x0,0x1,0x2,0x403,0x0,0x0,0,0,0,0), -- Faith of the Brotherhood
+(236578,0x00,107,0x00000000,0x00000000,0x00000000,0x00000000,0x0,0x0,0x0,0x2,0x0,0x0,0x1,0,0,0,0), -- Demon Soul Detection
+(236763,0x00,0,0x00000000,0x00000000,0x00000000,0x00000000,0x0,0x0,0x7,0x2,0x5403,0x0,0x0,0,0,0,0), -- Sephuz's Secret
+(242057,0x00,15,0x00000000,0x00000000,0x00000000,0x00000000,0x0,0x0,0x0,0x4,0x403,0x0,0x0,0,0,0,0), -- Rune Empowered
+(242058,0x00,15,0x00200000,0x00000000,0x00000000,0x00000000,0x0,0x0,0x4,0x2,0x1,0x0,0x0,0,0,0,0), -- Item - Death Knight T20 Frost 2P Bonus
+(272892,0x00,5,0x00000000,0x00000000,0x00000000,0x00000000,0x0,0x0,0x4,0x2,0x1,0x0,0x0,0,0,0,0), -- Wracking Brilliance
+(284558,0x00,0,0x00000000,0x00000000,0x00000000,0x00000000,0x0,0x0,0x2,0x2,0x403,0x0,0x0,0,0,0,0), -- Amethyst of the Shadow King
+(284567,0x00,0,0x00000000,0x00000000,0x00000000,0x00000000,0x0,0x0,0x2,0x2,0x403,0x0,0x0,0,0,0,0), -- Tailwind Sapphire
+(287378,0x00,4,0x00000000,0x00000001,0x00000000,0x00000000,0x0,0x0,0x4,0x2,0x1,0x0,0x0,0,0,0,0), -- Bastion of Might
+(288846,0x00,15,0x00100000,0x00000000,0x00000000,0x00000000,0x0,0x0,0x4,0x2,0x1,0x0,0x0,0,0,0,0), -- Bloody Runeblade
+(297721,0x00,0,0x00000000,0x00000000,0x00000000,0x00000000,0x0,0x0,0x1,0x2,0x403,0x0,0x0,0,0,0,0), -- Subjugator's Manacles
+(299375,0x00,0,0x00000000,0x00000000,0x00000000,0x00000000,0x0,0x0,0x0,0x2,0x401,0x0,0x1,0,0,0,0), -- Reckless Force
+(299377,0x00,0,0x00000000,0x00000000,0x00000000,0x00000000,0x0,0x0,0x0,0x2,0x401,0x0,0x1,0,0,0,0), -- Reckless Force
+(335054,0x00,10,0x00000000,0x00000100,0x00000080,0x00000000,0x0,0x0,0x4,0x2,0x1,0x0,0x0,0,0,0,0), -- Faintly Glowing Ember
+(335891,0x00,11,0x00000000,0x00000000,0x00000000,0x00200000,0x0,0x0,0x4,0x4,0x1,0x0,0x0,0,0,0,0), -- Spiritwalker's Tidal Totem
+(335893,0x00,11,0x00000080,0x00000000,0x00010000,0x00000000,0x0,0x0,0x2,0x2,0x403,0x0,0x0,0,0,0,0), -- Jonat's Natural Focus
+(335894,0x00,11,0x00000000,0x00000000,0x00000000,0x00000000,0x0,0x0,0x2,0x2,0x403,0x8,0x0,0,0,0,1), -- Jonat's Natural Focus
+(335895,0x00,11,0x10000000,0x00000000,0x00000000,0x00000000,0x0,0x0,0x1,0x2,0x403,0x0,0x0,0,0,0,0), -- Primal Lava Actuators
+(335896,0x00,11,0x00000000,0x00000000,0x00000004,0x00000000,0x0,0x0,0x1,0x2,0x403,0x8,0x0,0,0,0,1), -- Primal Lava Actuators
+(335902,0x00,11,0x00000000,0x00000000,0x00000000,0x00000000,0x0,0x0,0x4,0x4,0x1,0x0,0x0,0,0,0,0), -- Doom Winds
+(336063,0x00,11,0x00100000,0x00000000,0x00000000,0x00000000,0x0,0x0,0x1,0x2,0x403,0x0,0x0,0,0,0,0), -- Windspeaker's Lava Resurgence
+(336065,0x00,11,0x00000000,0x00000000,0x00000000,0x00000000,0x0,0x0,0x1,0x2,0x0,0x8,0x0,0,0,0,0), -- Windspeaker's Lava Resurgence
+(336215,0x00,11,0x00100000,0x00000000,0x00000000,0x00000000,0x0,0x0,0x1,0x2,0x403,0x0,0x0,0,0,0,0), -- Echoes of Great Sundering
+(336902,0x00,9,0x00004000,0x00000000,0x00000000,0x00000000,0x0,0x0,0x1,0x2,0x403,0x0,0x0,0,0,0,0), -- Latent Poison Injectors
+(336907,0x00,9,0x00000000,0x00000000,0x00010000,0x00000001,0x0,0x0,0x1,0x2,0x403,0x0,0x0,0,0,0,0), -- Butcher's Bone Fragments
+(336908,0x00,9,0x00000000,0x00000040,0x00000080,0x00000000,0x0,0x0,0x1,0x2,0x403,0x0,0x0,0,0,0,1), -- Butcher's Bone Fragments
+(337159,0x00,5,0x00000001,0x00000000,0x00000000,0x00000000,0x0,0x0,0x1,0x2,0x403,0x0,0x0,0,0,0,0), -- Balespider's Burning Core
+(337163,0x00,5,0x00100000,0x00000000,0x00000000,0x00000000,0x0,0x0,0x4,0x2,0x1,0x0,0x0,0,0,0,0), -- Odr, Shawl of the Ymirjar
+(337169,0x00,5,0x00000000,0x00002000,0x00000000,0x00000000,0x0,0x0,0x1,0x2,0x403,0x0,0x0,0,0,0,0), -- Madness of the Azj'Aqir
+(338339,0x00,11,0x00080000,0x00000000,0x00000000,0x01000000,0x0,0x0,0x0,0x4,0x0,0x0,0x0,0,0,0,0), -- Swirling Currents
+(338340,0x00,11,0x00000080,0x00000000,0x00010000,0x00000000,0x0,0x0,0x2,0x2,0x403,0x8,0x0,0,0,0,0), -- Swirling Currents
+(338343,0x00,11,0x00000000,0x00000000,0x00000000,0x00020000,0x0,0x0,0x0,0x4,0x0,0x0,0x0,0,0,0,0), -- Heavy Rainfall
+(338492,0x00,15,0x00000000,0x00000004,0x00000000,0x00000000,0x0,0x0,0x4,0x2,0x1,0x0,0x0,0,0,0,0), -- Unleashed Frenzy
+(339230,0x00,107,0x00000020,0x00000000,0x00000000,0x00000000,0x0,0x0,0x1,0x2,0x403,0x0,0x0,0,0,0,0), -- Serrated Glaive
+(339423,0x00,107,0x00100000,0x00000000,0x00000000,0x00000000,0x0,0x0,0x2,0x2,0x403,0x0,0x0,0,0,0,0), -- Soul Furnace
+(339424,0x00,107,0x80000000,0x00000000,0x00000000,0x00000000,0x0,0x0,0x1,0x2,0x403,0x8,0x0,0,0,0,1), -- Soul Furnace
+(340006,0x00,10,0x00004000,0x00000000,0x00000000,0x00000000,0x0,0x0,0x1,0x2,0x403,0x0,0x0,0,0,0,0), -- Vengeful Shock
+(340694,0x00,7,0x00000000,0x10000080,0x20200000,0x00001000,0x0,0x0,0x5,0x2,0x403,0x0,0x0,0,0,0,0), -- Sudden Ambush
+(341324,0x00,0,0x00000000,0x00000000,0x00000000,0x00000000,0x0,0x0,0x1,0x2,0x403,0x0,0x0,0,0,0,0), -- Uncontrolled Darkness
+(342632,0x00,0,0x00000000,0x00000000,0x00000000,0x00000000,0x0,0x0,0x4,0x2,0x1,0x0,0x0,0,0,0,0), -- Malevolent Stitching
+(342779,0x00,0,0x00000000,0x00000000,0x00000000,0x00000000,0x0,0x0,0x4,0x2,0x1,0x0,0x0,0,0,0,0), -- Crystallized Dreams
+(342793,0x00,0,0x00000000,0x00000000,0x00000000,0x00000000,0x0,0x0,0x4,0x2,0x1,0x0,0x0,0,0,0,0), -- Murmuring Shawl
+(342799,0x00,0,0x00000000,0x00000000,0x00000000,0x00000000,0x0,0x0,0x4,0x2,0x1,0x0,0x0,0,0,0,0), -- Gnarled Key
+(345672,0x00,0,0x00000000,0x00000000,0x00000000,0x00000000,0x0,0x0,0x4,0x2,0x1,0x0,0x0,0,0,0,0), -- Flesh Infusion
+(346279,0x00,107,0x00000001,0x00001000,0x00000000,0x00000000,0x0,0x0,0x1,0x2,0x403,0x0,0x0,0,0,0,0), -- Burning Wound
+(348908,0x00,0,0x00000000,0x00000000,0x00000000,0x00000000,0x0,0x0,0x4,0x2,0x1,0x0,0x0,0,0,0,0), -- Ethereal Wildseed
+(354569,0x00,0,0x00000000,0x00000000,0x00000000,0x00000000,0x0,0x0,0x6,0x2,0x1,0x0,0x0,0,0,0,0), -- Potent Potion
+(357833,0x00,0,0x00000000,0x00000000,0x00000000,0x00000000,0x0,0x0,0x4,0x2,0x4000,0x0,0x0,0,0,0,0), -- Words of Purity
+(363500,0x00,3,0x00000000,0x04000000,0x00000000,0x00000000,0x0,0x0,0x4,0x2,0x1,0x0,0x0,0,0,0,0), -- Fiery Rush
+(363682,0x00,3,0x00000000,0x00000000,0x00010000,0x00000000,0x0,0x0,0x4,0x2,0x1,0x0,0x0,0,0,0,0), -- Arcane Lucidity
+(364470,0x00,11,0x00000000,0x00000000,0x00000000,0x00000000,0x0,0x0,0x2,0x2,0x2,0x0,0x0,0,0,0,0), -- Heal the Soul
+(366779,0x00,11,0x00000100,0x00000000,0x00000000,0x00000000,0x0,0x0,0x2,0x2,0x403,0x8,0x0,0,0,0,1), -- Heal the Soul
+(370455,0x00,224,0x00000000,0x00000000,0x00000000,0x00000000,0x0,0x0,0x1,0x2,0x403,0x0,0x0,0,0,0,0), -- Charged Blast
+(371032,0x00,224,0x00000000,0x00000004,0x00000000,0x00000000,0x0,0x0,0x1,0x2,0x403,0x0,0x0,0,0,0,0), -- Terror of the Skies
+(373748,0x00,224,0x00000000,0x00000000,0x00000000,0x00000000,0x0,0x0,0x1,0x2,0x403,0x0,0x0,0,0,0,0), -- Vicious Whelpling
+(373761,0x00,224,0x00000000,0x00020000,0x00000000,0x00000000,0x0,0x0,0x0,0x4,0x0,0x0,0x0,0,0,0,0), -- Poisonous Spores
+(376103,0x00,3,0x00000000,0x00000000,0x00000000,0x00000000,0x0,0x0,0x1,0x2,0x403,0x0,0x0,0,0,0,0), -- Radiant Spark
+(376938,0x00,15,0x00000000,0x00000000,0x00000000,0x40000000,0x0,0x0,0x1,0x2,0x403,0x0,0x0,0,0,0,0), -- Everfrost
+(378014,0x00,9,0x00004000,0x00000000,0x00000000,0x00000000,0x0,0x0,0x1,0x2,0x403,0x0,0x0,0,0,0,0), -- Poison Injection
+(378268,0x00,11,0x00100000,0x00000000,0x00080000,0x00000004,0x0,0x0,0x4,0x4,0x1,0x0,0x0,0,0,0,0), -- Windspeaker's Lava Resurgence
+(378269,0x00,11,0x00000000,0x00001000,0x00000000,0x00000000,0x0,0x0,0x1,0x2,0x403,0x8,0x0,0,0,0,0), -- Windspeaker's Lava Resurgence
+(378750,0x00,9,0x00000000,0x00000000,0x00400000,0x00000000,0x0,0x0,0x1,0x2,0x403,0x0,0x0,0,0,0,0), -- Cobra Sting
+(378848,0x00,15,0x00000400,0x00000000,0x00000000,0x00000000,0x0,0x0,0x4,0x2,0x1000,0x0,0x0,0,0,0,0), -- Coldthirst
+(381773,0x00,224,0x00000000,0x00000000,0x00000000,0x00000000,0x0,0x0,0x1,0x2,0x403,0x0,0x0,0,0,0,0), -- Permeating Chill
+(382888,0x00,11,0x00000000,0x00000000,0x00000000,0x00000000,0x0,0x0,0x1,0x2,0x402,0x0,0x0,0,0,0,0), -- Flurry
+(383115,0x00,4,0x00000000,0x00000000,0x00000000,0x00000000,0x0,0x0,0x4,0x2,0x1000,0x0,0x0,0,0,0,0), -- Concussive Blows
+(383394,0x00,3,0x00000002,0x00000000,0x00000000,0x00000000,0x0,0x0,0x1,0x2,0x403,0x0,0x0,0,0,0,0), -- Feel the Burn
+(383634,0x00,3,0x00000000,0x04000000,0x00000000,0x00000000,0x0,0x0,0x4,0x2,0x1,0x0,0x0,0,0,0,0), -- Fiery Rush
+(383958,0x00,4,0x00000000,0x00000400,0x00000000,0x00000000,0x0,0x0,0x1,0x2,0x402,0x0,0x0,0,0,0,0), -- Cold Steel, Hot Blood
+(383977,0x00,4,0x00000000,0x00000400,0x00000000,0x00000000,0x0,0x0,0x1,0x2,0x402,0x0,0x0,0,0,0,0), -- Cold Steel, Hot Blood
+(383980,0x00,3,0x00000000,0x00008000,0x00000000,0x00000000,0x0,0x0,0x0,0x1,0x0,0x0,0x0,0,0,0,0), -- Arcane Tempo
+(384667,0x00,7,0x00000000,0x10000080,0x20200000,0x00001000,0x0,0x0,0x5,0x2,0x403,0x0,0x0,0,0,0,0), -- Sudden Ambush
+(385627,0x00,8,0x00010000,0x00000000,0x00000000,0x00000000,0x0,0x0,0x1,0x2,0x403,0x0,0x0,0,0,0,0), -- Kingsbane
+(385726,0x00,10,0x00004000,0x00000000,0x00000000,0x00000000,0x0,0x0,0x1,0x2,0x403,0x0,0x0,0,0,0,0), -- Barricade of Faith
+(385728,0x00,10,0x00000000,0x80000000,0x00000000,0x00000000,0x0,0x0,0x1,0x2,0x403,0x0,0x0,0,0,0,0), -- Seal of the Crusader
+(386737,0x00,3,0x00004000,0x00000000,0x00000000,0x00000000,0x0,0x0,0x4,0x2,0x1000,0x0,0x0,0,0,0,0), -- Hyper Impact
+(386878,0x00,9,0x00000000,0x00200000,0x00000000,0x00000000,0x0,0x0,0x4,0x2,0x1,0x0,0x0,0,0,0,0), -- Unerring Vision
+(387432,0x00,5,0x00000001,0x00000000,0x00000000,0x00000000,0x0,0x0,0x1,0x2,0x403,0x0,0x0,0,0,0,0), -- Fel Covenant
+(388218,0x00,53,0x01000000,0x00000000,0x00000000,0x00000000,0x0,0x0,0x2,0x2,0x403,0x0,0x0,0,0,0,0), -- Calming Coalescence
+(389102,0x00,0,0x00000000,0x00000000,0x00000000,0x00000000,0x2,0x0,0x0,0x0,0x0,0x1,0x0,0,0,0,0), -- Dragon Rider's Set
+(389449,0x00,9,0x00000000,0x00200000,0x00000000,0x00000000,0x0,0x0,0x4,0x2,0x1,0x0,0x0,0,0,0,0), -- Eagletalon's True Focus
+(390154,0x00,107,0x00000020,0x00000000,0x00000000,0x00000000,0x0,0x0,0x1,0x2,0x403,0x0,0x0,0,0,0,0), -- Serrated Glaive
+(390370,0x00,11,0x10000000,0x00000000,0x00000000,0x00000000,0x0,0x0,0x1,0x2,0x403,0x0,0x0,0,0,0,0), -- Ashen Catalyst
+(390371,0x00,11,0x00000000,0x00000004,0x00000000,0x00000000,0x0,0x0,0x1,0x2,0x403,0x8,0x0,0,0,0,1), -- Ashen Catalyst
+(391102,0x00,3,0x00000000,0x00000000,0x00000100,0x00000000,0x0,0x0,0x4,0x2,0x1,0x0,0x0,0,0,0,0), -- Mass Slow
+(391165,0x00,107,0x00100000,0x00000000,0x00000000,0x00000000,0x0,0x0,0x2,0x2,0x403,0x0,0x0,0,0,0,0), -- Soul Furnace
+(391172,0x00,107,0x80000000,0x00000000,0x00000010,0x00000000,0x0,0x0,0x1,0x2,0x403,0x8,0x0,0,0,0,1), -- Soul Furnace
+(391683,0x00,4,0x00000000,0x00000000,0x00000000,0x00000080,0x10,0x0,0x4,0x2,0x1,0x0,0x0,0,0,0,0), -- Dancing Blades
+(392296,0x00,9,0x00000000,0x00000800,0x00000000,0x00000000,0x0,0x0,0x1,0x2,0x403,0x8,0x0,0,0,0,1), -- Cobra Sting
+(392972,0x00,53,0x00100000,0x00000000,0x00000000,0x00000000,0x0,0x0,0x1,0x4,0x403,0x0,0x0,0,0,0,0), -- Open Palm Strikes
+(393647,0x00,9,0x00000000,0x00000000,0x00004000,0x00000000,0x0,0x0,0x1,0x2,0x403,0x0,0x0,0,0,0,0), -- Hunter Beast Mastery Class Set 4pc
+(393648,0x00,9,0x00001000,0x00000080,0x00000000,0x00000200,0x0,0x0,0x1,0x2,0x402,0x0,0x0,0,0,0,0), -- Hunter Marksmanship Class Set 2pc
+(393654,0x00,3,0x20001000,0x00000000,0x00000000,0x00000000,0x0,0x0,0x0,0x4,0x402,0x0,0x0,0,0,0,0), -- Mage Arcane Class Set 4pc
+(393670,0x00,10,0x00200000,0x00010000,0x00000000,0x00000000,0x0,0x0,0x3,0x2,0x403,0x0,0x0,0,0,0,0), -- Paladin Holy Class Set 2pc
+(393672,0x00,10,0x40000000,0x00000000,0x00044400,0x00000002,0x0,0x0,0x2,0x2,0x402,0x0,0x0,0,0,0,0), -- Paladin Holy Class Set 4pc
+(393688,0x00,11,0x00000003,0x80001004,0x00400000,0x00000021,0x0,0x0,0x1,0x4,0x403,0x0,0x0,0,0,0,0), -- Shaman Elemental Class Set 2pc
+(394298,0x00,9,0x00000000,0x00000800,0x00000000,0x00000000,0x0,0x0,0x1,0x2,0x403,0x8,0x0,0,0,0,1), -- Lethal Command
+(394312,0x00,3,0x00000000,0x00000000,0x40000000,0x00000000,0x0,0x0,0x1,0x2,0x403,0x0,0x0,0,0,0,0), -- Battering Ram
+(394366,0x00,9,0x00020000,0x00000000,0x00000000,0x00000000,0x0,0x0,0x1,0x2,0x403,0x0,0x0,0,0,0,0), -- Find The Mark
+(394667,0x00,10,0x00200000,0x00010000,0x00000000,0x00000000,0x0,0x0,0x3,0x2,0x403,0x8,0x0,0,0,0,0), -- Lightspark
+(395006,0x00,3,0x00000000,0x00008000,0x00000000,0x00000000,0x0,0x0,0x1,0x2,0x403,0x8,0x0,0,0,0,1), -- Bursting Energy
+(404522,0x00,11,0x00000000,0x00000000,0x00000000,0x00200000,0x0,0x0,0x4,0x4,0x1,0x0,0x0,0,0,0,0), -- Spiritwalker's Tidal Totem
+(404542,0x00,10,0x00000000,0x80000000,0x00000000,0x00000000,0x0,0x0,0x1,0x2,0x403,0x0,0x0,0,0,0,0), -- Crusading Strikes
+(405547,0x00,10,0x00004000,0x00000000,0x00000000,0x00000000,0x0,0x0,0x1,0x2,0x403,0x0,0x0,0,0,0,0), -- Paladin Protection 10.1 Class Set 2pc
+(405549,0x00,10,0x00000000,0x00000080,0x00000000,0x00000000,0x0,0x0,0x1,0x2,0x403,0x0,0x0,0,0,0,0), -- Paladin Retribution 10.1 Class Set 2pc
+(408461,0x00,10,0x00000000,0x00000000,0x00000000,0x00000000,0x0,0x0,0x1,0x2,0x403,0x0,0x0,0,0,0,0), -- Heartfire
+(408575,0x00,11,0x00000003,0x00000000,0x00000000,0x00000000,0x0,0x0,0x1,0x2,0x403,0x8,0x0,0,0,0,1), -- Volcanic Surge (PvP Talent)
+(410530,0x00,0,0x00000000,0x00000000,0x00000000,0x00000000,0x0,0x0,0x7,0x2,0x5403,0x0,0x0,0,0,0,0), -- Mettle
+(410939,0x00,3,0x00010000,0x00000000,0x00000000,0x00000000,0x0,0x0,0x4,0x2,0x1,0x0,0x0,0,0,0,0), -- Ethereal Blink
+(410964,0x00,0,0x00000000,0x00000000,0x00000000,0x00000000,0x0,0x0,0x7,0x2,0x5403,0x0,0x0,0,0,0,0); -- Mettle
+
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_item_sephuzs_secret';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_gen_boost_2_0_paladin_priest_watch_for_shield';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_dk_t20_2p_rune_empowered';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_item_wracking_brilliance';
+DELETE FROM `spell_script_names` WHERE `spell_id` IN (272893) AND `ScriptName`='spell_azerite_gen_aura_calc_from_2nd_effect_triggered_spell';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_torghast_subjugators_manacles';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_sha_doom_winds_legendary';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_sha_earthquake';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_hun_latent_poison_injectors_damage';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_hun_latent_poison_injectors_trigger';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_dh_soul_furnace_conduit';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_dru_sudden_ambush';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_torghast_uncontrolled_darkness';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_torghast_uncontrolled_darkness_proc';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_torghast_fleshcraft_shield_proc';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_torghast_soulshape_proc';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_torghast_door_of_shadows_proc';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_torghast_flicker_proc';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_torghast_potent_potion_proc';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_torghast_potent_potion_calc';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_evo_charged_blast';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_evo_permeating_chill';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_torghast_poisonous_spores';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_mage_radiant_spark';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_hun_latent_poison_damage';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_hun_latent_poison_trigger';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_sha_windspeakers_lava_resurgence';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_hun_cobra_sting';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_mage_feel_the_burn';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_rog_kingsbane';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_mage_hyper_impact';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_monk_life_cocoon';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_dh_soul_furnace';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_hun_t29_2p_marksmanship_bonus';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_sha_earth_shock';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_pal_crusading_strikes';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_pal_t30_2p_protection_bonus';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_pal_t30_2p_protection_bonus_heal';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_item_infurious_crafted_gear_mettle';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_mage_ethereal_blink';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_mage_ethereal_blink_triggered';
+INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES
+(208051,'spell_item_sephuzs_secret'),
+(209352,'spell_gen_boost_2_0_paladin_priest_watch_for_shield'),
+(234867,'spell_item_sephuzs_secret'),
+(236763,'spell_item_sephuzs_secret'),
+(242057,'spell_dk_t20_2p_rune_empowered'),
+(272892,'spell_item_wracking_brilliance'),
+(272893,'spell_azerite_gen_aura_calc_from_2nd_effect_triggered_spell'),
+(297721,'spell_torghast_subjugators_manacles'),
+(335902,'spell_sha_doom_winds_legendary'),
+(61882,'spell_sha_earthquake'),
+(336904,'spell_hun_latent_poison_injectors_damage'),
+(186270,'spell_hun_latent_poison_injectors_trigger'),
+(259387,'spell_hun_latent_poison_injectors_trigger'),
+(339424,'spell_dh_soul_furnace_conduit'),
+(340694,'spell_dru_sudden_ambush'),
+(384667,'spell_dru_sudden_ambush'),
+(341324,'spell_torghast_uncontrolled_darkness'),
+(343174,'spell_torghast_uncontrolled_darkness_proc'),
+(342632,'spell_torghast_fleshcraft_shield_proc'),
+(342779,'spell_torghast_soulshape_proc'),
+(342793,'spell_torghast_door_of_shadows_proc'),
+(345672,'spell_torghast_fleshcraft_shield_proc'),
+(348908,'spell_torghast_flicker_proc'),
+(354569,'spell_torghast_potent_potion_proc'),
+(354706,'spell_torghast_potent_potion_calc'),
+(370455,'spell_evo_charged_blast'),
+(381773,'spell_evo_permeating_chill'),
+(373761,'spell_torghast_poisonous_spores'),
+(376103,'spell_mage_radiant_spark'),
+(378016,'spell_hun_latent_poison_damage'),
+(19434,'spell_hun_latent_poison_trigger'),
+(186270,'spell_hun_latent_poison_trigger'),
+(217200,'spell_hun_latent_poison_trigger'),
+(259387,'spell_hun_latent_poison_trigger'),
+(378269,'spell_sha_windspeakers_lava_resurgence'),
+(378750,'spell_hun_cobra_sting'),
+(383395,'spell_mage_feel_the_burn'),
+(385627,'spell_rog_kingsbane'),
+(386737,'spell_mage_hyper_impact'),
+(116849,'spell_monk_life_cocoon'),
+(391166,'spell_dh_soul_furnace'),
+(394366,'spell_hun_t29_2p_marksmanship_bonus'),
+(8042,'spell_sha_earth_shock'),
+(406833,'spell_pal_crusading_strikes'),
+(405547,'spell_pal_t30_2p_protection_bonus'),
+(410530,'spell_pal_t30_2p_protection_bonus_heal'),
+(408461,'spell_item_infurious_crafted_gear_mettle'),
+(410964,'spell_item_infurious_crafted_gear_mettle'),
+(410939,'spell_mage_ethereal_blink'),
+(410941,'spell_mage_ethereal_blink_triggered');
+
+DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=324867 AND `spell_effect`=-342662 AND `type`=3;
+DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=324867 AND `spell_effect`=-345673 AND `type`=3;
+DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=310143 AND `spell_effect`=-342783 AND `type`=3;
+DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=190319 AND `spell_effect`=-383637 AND `type`=3;
+INSERT INTO `spell_linked_spell` (`spell_trigger`,`spell_effect`,`type`,`comment`) VALUES
+(324867,-342662,3,'Fleshcraft - on remove - remove Malevolent Stitching'),
+(324867,-345673,3,'Fleshcraft - on remove - remove Flesh Infusion'),
+(310143,-342783,3,'Soulshape - on remove - remove Crystallized Dreams'),
+(190319,-383637,3,'Combustion - on remove - remove Fiery Rush');