-- (33167) Absolution (Rank 1) - New
DELETE FROM `spell_affect` WHERE `entry` IN (33167);
INSERT INTO `spell_affect` VALUES (33167, 0, 0, 0x00, 0, 0, 0, 

0x0000000100000000, 0);

-- (33171) Absolution (Rank 2)
DELETE FROM `spell_affect` WHERE `entry` IN (33171);
INSERT INTO `spell_affect` VALUES (33171, 0, 0, 0x00, 0, 0, 0, 

0x0000000100000000, 0);

-- (33172) Absolution (Rank 3)
DELETE FROM `spell_affect` WHERE `entry` IN (33172);
INSERT INTO `spell_affect` VALUES (33172, 0, 0, 0x00, 0, 0, 0, 

0x0000000100000000, 0);

-- (23236) Benediction () - Convert to FamilyMask
-- Added 2^36 (new racial spell, Chastise)
DELETE FROM `spell_affect` WHERE `entry` IN (23236);
INSERT INTO `spell_affect` VALUES (23236, 0, 0, 0x00, 0, 0, 0, 

0x0000003419541EC0, 0);

-- (37880) Blessing of Lower City () - New only heal spells
-- Added 2^37 (Prayer of Mending)
DELETE FROM `spell_affect` WHERE `entry` IN (37880);
INSERT INTO `spell_affect` VALUES (37880, 0, 0, 0x00, 0, 0, 0, 

0x0000000411041E40, 0);

-- (15259) Darkness (Rank 1) - Convert and remove non damage spells
-- Split in DOTs and direct Dmg, added 2^23 (Mind Flay)
DELETE FROM `spell_affect` WHERE `entry` IN (15259);
INSERT INTO `spell_affect` VALUES (15259, 0, 0, 0x00, 0, 0, 0, 

0x0000000202002000, 0);
INSERT INTO `spell_affect` VALUES (15259, 1, 0, 0x00, 0, 0, 0, 

0x0000040000808000, 0);

-- (15307) Darkness (Rank 2)
DELETE FROM `spell_affect` WHERE `entry` IN (15307);
INSERT INTO `spell_affect` VALUES (15307, 0, 0, 0x00, 0, 0, 0, 

0x0000000202002000, 0);
INSERT INTO `spell_affect` VALUES (15307, 1, 0, 0x00, 0, 0, 0, 

0x0000040000808000, 0);

-- (15308) Darkness (Rank 3)
DELETE FROM `spell_affect` WHERE `entry` IN (15308);
INSERT INTO `spell_affect` VALUES (15308, 0, 0, 0x00, 0, 0, 0, 

0x0000000202002000, 0);
INSERT INTO `spell_affect` VALUES (15308, 1, 0, 0x00, 0, 0, 0, 

0x0000040000808000, 0);

-- (15309) Darkness (Rank 4)
DELETE FROM `spell_affect` WHERE `entry` IN (15309);
INSERT INTO `spell_affect` VALUES (15309, 0, 0, 0x00, 0, 0, 0, 

0x0000000202002000, 0);
INSERT INTO `spell_affect` VALUES (15309, 1, 0, 0x00, 0, 0, 0, 

0x0000040000808000, 0);

-- (15310) Darkness (Rank 5)
DELETE FROM `spell_affect` WHERE `entry` IN (15310);
INSERT INTO `spell_affect` VALUES (15310, 0, 0, 0x00, 0, 0, 0, 

0x0000000202002000, 0);
INSERT INTO `spell_affect` VALUES (15310, 1, 0, 0x00, 0, 0, 0, 

0x0000040000808000, 0);

-- (14743) Focused Casting (Rank 1) - Convert and remove instant cast spells
-- added 2^23 (Mind Flay) and 2^36 (new racial spell, Chastise)
DELETE FROM `spell_affect` WHERE `entry` IN (14743);
INSERT INTO `spell_affect` VALUES (14743, 0, 0, 0x00, 0, 0, 0, 

0x0000049440963E90, 0);

-- (27828) Focused Casting (Rank 2)
DELETE FROM `spell_affect` WHERE `entry` IN (27828);
INSERT INTO `spell_affect` VALUES (27828, 0, 0, 0x00, 0, 0, 0, 

0x0000049440963E90, 0);

-- (33186) Focused Power (Rank 1)
DELETE FROM `spell_affect` WHERE `entry` IN (33186);
INSERT INTO `spell_affect` VALUES (33186, 0, 0, 0x00, 0, 0, 0, 

0x0000008000000000, 0);
INSERT INTO `spell_affect` VALUES (33186, 1, 0, 0x00, 0, 0, 0, 

0x0000008000002080, 0);

-- (33190) Focused Power (Rank 2)
DELETE FROM `spell_affect` WHERE `entry` IN (33190);
INSERT INTO `spell_affect` VALUES (33190, 0, 0, 0x00, 0, 0, 0, 

0x0000008000000000, 0);
INSERT INTO `spell_affect` VALUES (33190, 1, 0, 0x00, 0, 0, 0, 

0x0000008000002080, 0);

-- (18544) Force of Will (Rank 1) - Convert and add only damage spells
--1: 41202F8A090 (2 OR 3)
--2: 01202582090 only direct dmg added 2^19 (Touch of Weakness) and 2^36 (new 

racial spell, Chastise)
--3: 40000A08000 only dots added 2^23 (Mind Flay)
DELETE FROM `spell_affect` WHERE `entry` IN (18544);
INSERT INTO `spell_affect` VALUES (18544, 0, 0, 0x00, 0, 0, 0, 

0x0000041202F8A090, 0);
INSERT INTO `spell_affect` VALUES (18544, 1, 0, 0x00, 0, 0, 0, 

0x0000001202582090, 0);
INSERT INTO `spell_affect` VALUES (18544, 2, 0, 0x00, 0, 0, 0, 

0x0000040000A08000, 0);

-- (18547) Force of Will (Rank 2)
DELETE FROM `spell_affect` WHERE `entry` IN (18547);
INSERT INTO `spell_affect` VALUES (18547, 0, 0, 0x00, 0, 0, 0, 

0x0000041202F8A090, 0);
INSERT INTO `spell_affect` VALUES (18547, 1, 0, 0x00, 0, 0, 0, 

0x0000001202582090, 0);
INSERT INTO `spell_affect` VALUES (18547, 2, 0, 0x00, 0, 0, 0, 

0x0000040000A08000, 0);

-- (18548) Force of Will (Rank 3)
DELETE FROM `spell_affect` WHERE `entry` IN (18548);
INSERT INTO `spell_affect` VALUES (18548, 0, 0, 0x00, 0, 0, 0, 

0x0000041202F8A090, 0);
INSERT INTO `spell_affect` VALUES (18548, 1, 0, 0x00, 0, 0, 0, 

0x0000001202582090, 0);
INSERT INTO `spell_affect` VALUES (18548, 2, 0, 0x00, 0, 0, 0, 

0x0000040000A08000, 0);

-- (18549) Force of Will (Rank 4)
DELETE FROM `spell_affect` WHERE `entry` IN (18549);
INSERT INTO `spell_affect` VALUES (18549, 0, 0, 0x00, 0, 0, 0, 

0x0000041202F8A090, 0);
INSERT INTO `spell_affect` VALUES (18549, 1, 0, 0x00, 0, 0, 0, 

0x0000001202582090, 0);
INSERT INTO `spell_affect` VALUES (18549, 2, 0, 0x00, 0, 0, 0, 

0x0000040000A08000, 0);

-- (18550) Force of Will (Rank 5)
DELETE FROM `spell_affect` WHERE `entry` IN (18550);
INSERT INTO `spell_affect` VALUES (18550, 0, 0, 0x00, 0, 0, 0, 

0x0000041202F8A090, 0);
INSERT INTO `spell_affect` VALUES (18550, 1, 0, 0x00, 0, 0, 0, 

0x0000001202582090, 0);
INSERT INTO `spell_affect` VALUES (18550, 2, 0, 0x00, 0, 0, 0, 

0x0000040000A08000, 0);

-- (14913) Healing Focus (Rank 1)
-- added 2^34 (Binding Heal)
DELETE FROM `spell_affect` WHERE `entry` IN (14913);
INSERT INTO `spell_affect` VALUES (14913, 0, 0, 0x00, 0, 0, 0, 

0x0000000400041E00, 0);

-- (15012) Healing Focus (Rank 2)
DELETE FROM `spell_affect` WHERE `entry` IN (15012);
INSERT INTO `spell_affect` VALUES (15012, 0, 0, 0x00, 0, 0, 0, 

0x0000000400041E00, 0);

-- (37706) Healing Trance ()
-- Added 2^37 (Prayer of Mending)
DELETE FROM `spell_affect` WHERE `entry` IN (37706);
INSERT INTO `spell_affect` VALUES (37706, 0, 0, 0x00, 0, 0, 0, 

0x0000000411041E40, 0);

-- (37571) Improved Mind Flay and Smite ()
-- split in direct and over time damage
DELETE FROM `spell_affect` WHERE `entry` IN (37571);
INSERT INTO `spell_affect` VALUES (37571, 0, 0, 0x00, 0, 0, 0, 

0x0000000000000080, 0);
INSERT INTO `spell_affect` VALUES (37571, 1, 0, 0x00, 0, 0, 0, 

0x0000000000800000, 0);

-- (14751) Inner Focus ()
-- should be usable on all spells not only the ones with cast time
DELETE FROM `spell_affect` WHERE `entry` IN (14751);
INSERT INTO `spell_affect` VALUES (14751, 0, 0, 0x00, 0, 0, 0, 

0xFFFFFFFFFFFFFFFF, 0);
INSERT INTO `spell_affect` VALUES (14751, 1, 0, 0x00, 0, 0, 0, 

0xFFFFFFFFFFFFFFFF, 0);

-- (14520) Mental Agility (Rank 1) - New Add all instant spells
-- removed 2^19 (proc, 0 mana), 2^23 (not instant)
-- added 2^24(Desperate Prayer), 2^31 (different spells)
DELETE FROM `spell_affect` WHERE `entry` IN (14520);
INSERT INTO `spell_affect` VALUES (14520, 0, 0, 0x00, 0, 0, 0, 

0x00000963BF61C16F, 0);

-- (14780) Mental Agility (Rank 2)
DELETE FROM `spell_affect` WHERE `entry` IN (14780);
INSERT INTO `spell_affect` VALUES (14780, 0, 0, 0x00, 0, 0, 0, 

0x00000963BF61C16F, 0);

-- (14781) Mental Agility (Rank 3)
DELETE FROM `spell_affect` WHERE `entry` IN (14781);
INSERT INTO `spell_affect` VALUES (14781, 0, 0, 0x00, 0, 0, 0, 

0x00000963BF61C16F, 0);

-- (14782) Mental Agility (Rank 4)
DELETE FROM `spell_affect` WHERE `entry` IN (14782);
INSERT INTO `spell_affect` VALUES (14782, 0, 0, 0x00, 0, 0, 0, 

0x00000963BF61C16F, 0);

-- (14783) Mental Agility (Rank 5)
DELETE FROM `spell_affect` WHERE `entry` IN (14783);
INSERT INTO `spell_affect` VALUES (14783, 0, 0, 0x00, 0, 0, 0, 

0x00000963BF61C16F, 0);

-- (33206) Pain Suppression ()
-- don't see reason why this needs spell_affect

-- (28808) Reduced Threat ()
-- mask didn't make sense
-- took the one from (37880) Blessing of Lower City
DELETE FROM `spell_affect` WHERE `entry` IN (28808);
INSERT INTO `spell_affect` VALUES (28808, 0, 0, 0x00, 0, 0, 0, 

0x0000000411041E40, 0);

-- (15318) Shadow Affinity (Rank 1) - Convert remove all non damage spells
-- description doesn't say "damage" should affect all shadow spells
DELETE FROM `spell_affect` WHERE `entry` IN (15318);
INSERT INTO `spell_affect` VALUES (15318, 0, 0, 0x00, 0, 0, 0, 

0x00000D4A068BE104, 0);

-- (15272) Shadow Affinity (Rank 2)
DELETE FROM `spell_affect` WHERE `entry` IN (15272);
INSERT INTO `spell_affect` VALUES (15272, 0, 0, 0x00, 0, 0, 0, 

0x00000D4A068BE104, 0);

-- (15320) Shadow Affinity (Rank 3)
DELETE FROM `spell_affect` WHERE `entry` IN (15320);
INSERT INTO `spell_affect` VALUES (15320, 0, 0, 0x00, 0, 0, 0, 

0x00000D4A068BE104, 0);

-- (15260) Shadow Focus (Rank 1) - Convert remove positive spells
DELETE FROM `spell_affect` WHERE `entry` IN (15260);
INSERT INTO `spell_affect` VALUES (15260, 0, 0, 0x00, 0, 0, 0, 

0x00000442068BA000, 0);

-- (15327) Shadow Focus (Rank 2)
DELETE FROM `spell_affect` WHERE `entry` IN (15327);
INSERT INTO `spell_affect` VALUES (15327, 0, 0, 0x00, 0, 0, 0, 

0x00000442068BA000, 0);

-- (15328) Shadow Focus (Rank 3)
DELETE FROM `spell_affect` WHERE `entry` IN (15328);
INSERT INTO `spell_affect` VALUES (15328, 0, 0, 0x00, 0, 0, 0, 

0x00000442068BA000, 0);

-- (15329) Shadow Focus (Rank 4)
DELETE FROM `spell_affect` WHERE `entry` IN (15329);
INSERT INTO `spell_affect` VALUES (15329, 0, 0, 0x00, 0, 0, 0, 

0x00000442068BA000, 0);

-- (15330) Shadow Focus (Rank 5)
DELETE FROM `spell_affect` WHERE `entry` IN (15330);
INSERT INTO `spell_affect` VALUES (15330, 0, 0, 0x00, 0, 0, 0, 

0x00000442068BA000, 0);

-- (17322) Shadow Reach (Rank 1) - Convert remove spellsthithout range
-- removed 2^8 not offensive (Shadow Protection)
-- added 2^26 (different spells, e.g. Silence, 2^40 (Shadowfiend)
DELETE FROM `spell_affect` WHERE `entry` IN (17322);
INSERT INTO `spell_affect` VALUES (17322, 0, 0, 0x00, 0, 0, 0, 

0x00000542068AA004, 0);

-- (17323) Shadow Reach (Rank 2)
DELETE FROM `spell_affect` WHERE `entry` IN (17323);
INSERT INTO `spell_affect` VALUES (17323, 0, 0, 0x00, 0, 0, 0, 

0x00000542068AA004, 0);

-- (14523) Silent Resolve (Rank 1) - Convert
-- Dispell chance of ALL spells should be increased, HOLY/DISC is only for 

threat reduction
DELETE FROM `spell_affect` WHERE `entry` IN (14523);
INSERT INTO `spell_affect` VALUES (14523, 1, 0, 0x00, 0, 0, 0, 

0xFFFFFFFFFFFFFFFF, 0);

-- (14784) Silent Resolve (Rank 2)
DELETE FROM `spell_affect` WHERE `entry` IN (14784);
INSERT INTO `spell_affect` VALUES (14784, 1, 0, 0x00, 0, 0, 0, 

0xFFFFFFFFFFFFFFFF, 0);

-- (14785) Silent Resolve (Rank 3)
DELETE FROM `spell_affect` WHERE `entry` IN (14785);
INSERT INTO `spell_affect` VALUES (14785, 1, 0, 0x00, 0, 0, 0, 

0xFFFFFFFFFFFFFFFF, 0);

-- (14786) Silent Resolve (Rank 4)
DELETE FROM `spell_affect` WHERE `entry` IN (14786);
INSERT INTO `spell_affect` VALUES (14786, 1, 0, 0x00, 0, 0, 0, 

0xFFFFFFFFFFFFFFFF, 0);

-- (14787) Silent Resolve (Rank 5)
DELETE FROM `spell_affect` WHERE `entry` IN (14787);
INSERT INTO `spell_affect` VALUES (14787, 1, 0, 0x00, 0, 0, 0, 

0xFFFFFFFFFFFFFFFF, 0);

-- (14912) Improved Healing (Rank 1)
DELETE FROM `spell_affect` WHERE `entry` IN (14912);
INSERT INTO `spell_affect` VALUES (14912, 0, 0, 0x00, 0, 0, 0, 

0x0000000000041400, 0);

-- (15013) Improved Healing (Rank 2)
DELETE FROM `spell_affect` WHERE `entry` IN (15013);
INSERT INTO `spell_affect` VALUES (15013, 0, 0, 0x00, 0, 0, 0, 

0x0000000000041400, 0);

-- (15014) Improved Healing (Rank 3)
DELETE FROM `spell_affect` WHERE `entry` IN (15014);
INSERT INTO `spell_affect` VALUES (15014, 0, 0, 0x00, 0, 0, 0, 

0x0000000000041400, 0);

-- (14747) Improved Inner Fire (Rank 1)
DELETE FROM `spell_affect` WHERE `entry` IN (14747);
INSERT INTO `spell_affect` VALUES (14747, 0, 0, 0x00, 0, 0, 0, 

0x0000000000000002, 0);

-- (14770) Improved Inner Fire (Rank 2)
DELETE FROM `spell_affect` WHERE `entry` IN (14770);
INSERT INTO `spell_affect` VALUES (14770, 0, 0, 0x00, 0, 0, 0, 

0x0000000000000002, 0);

-- (14771) Improved Inner Fire (Rank 3)
DELETE FROM `spell_affect` WHERE `entry` IN (14771);
INSERT INTO `spell_affect` VALUES (14771, 0, 0, 0x00, 0, 0, 0, 

0x0000000000000002, 0);

-- (44297) Improved Psychic Scream ()
DELETE FROM `spell_affect` WHERE `entry` IN (44297);
INSERT INTO `spell_affect` VALUES (44297, 0, 0, 0x00, 0, 0, 0, 

0x0000000000010000, 0);