DB/Spell: Add effects to some serverside spells

(cherry picked from commit d58ac3a10a206f323363c1a3dfbe5f73274f371b)

1 files changed, 177 insertions, 0 deletions

diff --git a/sql/updates/world/master/2022_03_05_19_world_2020_12_24_03_world.sql b/sql/updates/world/master/2022_03_05_19_world_2020_12_24_03_world.sql
new file mode 100644
index 00000000000..88163b9452d
--- /dev/null
+++ b/sql/updates/world/master/2022_03_05_19_world_2020_12_24_03_world.sql
@@ -0,0 +1,177 @@
+--
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` IN (45413,47067,54033,66685); -- Stun, Stun Self
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 42236; -- Darkmoon Faire Carnie Appearance A
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 42237; -- Darkmoon Faire Carnie Appearance B
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 42238; -- Darkmoon Faire Carnie Appearance C
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 42239; -- Darkmoon Faire Carnie Appearance D
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 42240; -- Darkmoon Faire Carnie Appearance E
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 42241; -- Darkmoon Faire Carnie Appearance F
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 71666; -- Friendly Melee Ring Replacement
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 71667; -- Honored Melee Ring Replacement
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 71668; -- Revered Melee Ring Replacement
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 71669; -- Exalted Melee Ring Replacement
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 71670; -- Friendly Tank Ring Replacement
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 71671; -- Honored Tank Ring Replacement
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 71672; -- Revered Tank Ring Replacement
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 71673; -- Exalted Tank Ring Replacement
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 71674; -- Friendly Healer Ring Replacement
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 71675; -- Honored Healer Ring Replacement
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 71676; -- Revered Healer Ring Replacement
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 71677; -- Exalted Healer Ring Replacement
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 71678; -- Friendly Caster Ring Replacement
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 71679; -- Honored Caster Ring Replacement
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 71680; -- Revered Caster Ring Replacement
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 71681; -- Exalted Caster Ring Replacement
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 74778; -- Friendly Strength Ring Replacement
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 74779; -- Honored Strength Ring Replacement
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 74782; -- Revered Strength Ring Replacement
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 74784; -- Exalted Strength Ring Replacement
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 44921; -- Archer - BE Female Transform Tier 1
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 44922; -- Archer - BE Female Transform Tier 2
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 44923; -- Archer - BE Female Transform Tier 3
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 44924; -- Archer - BE Female Transform Tier 4
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 44962; -- Archer - BE Male Transform Tier 1
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 44918; -- Archer - BE Male Transform Tier 2
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 44919; -- Archer - BE Male Transform Tier 3
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 44920; -- Archer - BE Male Transform Tier 4
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 44929; -- Archer - Draenei Female Transform Tier 1
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 44930; -- Archer - Draenei Female Transform Tier 2
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 44931; -- Archer - Draenei Female Transform Tier 3
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 44932; -- Archer - Draenei Female Transform Tier 4
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 44925; -- Archer - Draenei Male Transform Tier 1
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 44926; -- Archer - Draenei Male Transform Tier 2
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 44927; -- Archer - Draenei Male Transform Tier 3
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 44928; -- Archer - Draenei Male Transform Tier 4
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 44989; -- Christmas Grand Warlock Nethekurse
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 44990; -- Christmas Grandmaster Vorpil
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 44991; -- Christmas Exarch Maladaar
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 44992; -- Christmas Captain Skarloc
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 44995; -- Christmas Nethermancer Sepethrea
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 44996; -- Christmas High Botanist Freywinn
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 40804; -- Create Mingo's Fortune
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 40805; -- Create Mingo's Fortune
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 40806; -- Create Mingo's Fortune
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 40807; -- Create Mingo's Fortune
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 40808; -- Create Mingo's Fortune
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 40809; -- Create Mingo's Fortune
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 40908; -- Create Mingo's Fortune
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 40910; -- Create Mingo's Fortune
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 40911; -- Create Mingo's Fortune
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 40912; -- Create Mingo's Fortune
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 40913; -- Create Mingo's Fortune
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 40914; -- Create Mingo's Fortune
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 40915; -- Create Mingo's Fortune
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 40916; -- Create Mingo's Fortune
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 40918; -- Create Mingo's Fortune
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 40919; -- Create Mingo's Fortune
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 40920; -- Create Mingo's Fortune
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 40921; -- Create Mingo's Fortune
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 40922; -- Create Mingo's Fortune
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 40923; -- Create Mingo's Fortune
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 45155; -- Warrior - BE Female Transform Tier 1
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 45156; -- Warrior - BE Female Transform Tier 2
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 45157; -- Warrior - BE Female Transform Tier 3
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 45158; -- Warrior - BE Female Transform Tier 4
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 45159; -- Warrior - BE Male Transform Tier 1
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 45160; -- Warrior - BE Male Transform Tier 2
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 45161; -- Warrior - BE Male Transform Tier 3
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 45162; -- Warrior - BE Male Transform Tier 4
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 45163; -- Warrior - Draenei Female Transform Tier 1
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 45164; -- Warrior - Draenei Female Transform Tier 2
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 45165; -- Warrior - Draenei Female Transform Tier 3
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 45166; -- Warrior - Draenei Female Transform Tier 4
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 45167; -- Warrior - Draenei Male Transform Tier 1
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 45168; -- Warrior - Draenei Male Transform Tier 2
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 45169; -- Warrior - Draenei Male Transform Tier 3
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 45170; -- Warrior - Draenei Male Transform Tier 4
+
+DELETE FROM `serverside_spell_effect` WHERE `SpellID` IN (45413,47067,54033,66685,42236,42237,42238,42239,42240,42241,71666,71667,71668,71669,71670,71671,71672,71673,71674,71675,71676,71677,71678,71679,71680,71681,74778,74779,74782,74784,44921,44922,44923,44924,44962,44918,44919,44920,44929,44930,44931,44932,44925,44926,44927,44928,44989,44990,44991,44992,44995,44996,40804,40805,40806,40807,40808,40809,40908,40910,40911,40912,40913,40914,40915,40916,40918,40919,40920,40921,40922,40923,45155,45156,45157,45158,45159,45160,45161,45162,45163,45164,45165,45166,45167,45168,45169,45170);
+INSERT INTO `serverside_spell_effect` (`SpellID`, `EffectIndex`, `Effect`, `EffectAura`, `EffectItemType`, `EffectMiscValue1`, `ImplicitTarget1`) VALUES
+(45413, 0,   6, 12,     0,     0,  1),
+(47067, 0,   6, 12,     0,     0,  1),
+(54033, 0,   6, 12,     0,     0,  1),
+(66685, 0,   6, 12,     0,     0,  1),
+(42236, 0,   6, 56,     0, 23629,  1),
+(42237, 0,   6, 56,     0, 23630,  1),
+(42238, 0,   6, 56,     0, 23631,  1),
+(42239, 0,   6, 56,     0, 23632,  1),
+(42240, 0,   6, 56,     0, 23633,  1),
+(42241, 0,   6, 56,     0, 23634,  1),
+(71666, 0,  24,  0, 50376,     0, 25),
+(71667, 0,  24,  0, 50387,     0, 25),
+(71668, 0,  24,  0, 50401,     0, 25),
+(71669, 0,  24,  0, 50402,     0, 25),
+(71670, 0,  24,  0, 50375,     0, 25),
+(71671, 0,  24,  0, 50388,     0, 25),
+(71672, 0,  24,  0, 50403,     0, 25),
+(71673, 0,  24,  0, 50404,     0, 25),
+(71674, 0,  24,  0, 50378,     0, 25),
+(71675, 0,  24,  0, 50386,     0, 25),
+(71676, 0,  24,  0, 50399,     0, 25),
+(71677, 0,  24,  0, 50400,     0, 25),
+(71678, 0,  24,  0, 50377,     0, 25),
+(71679, 0,  24,  0, 50384,     0, 25),
+(71680, 0,  24,  0, 50397,     0, 25),
+(71681, 0,  24,  0, 50398,     0, 25),
+(74778, 0,  24,  0, 52569,     0, 25),
+(74779, 0,  24,  0, 52570,     0, 25),
+(74782, 0,  24,  0, 52571,     0, 25),
+(74784, 0,  24,  0, 52572,     0, 25),
+(44921, 0,   6, 56,     0, 24942,  1),
+(44922, 0,   6, 56,     0, 24943,  1),
+(44923, 0,   6, 56,     0, 24944,  1),
+(44924, 0,   6, 56,     0, 24945,  1),
+(44962, 0,   6, 56,     0, 24963,  1),
+(44918, 0,   6, 56,     0, 24939,  1),
+(44919, 0,   6, 56,     0, 24940,  1),
+(44920, 0,   6, 56,     0, 24941,  1),
+(44929, 0,   6, 56,     0, 24950,  1),
+(44930, 0,   6, 56,     0, 24951,  1),
+(44931, 0,   6, 56,     0, 24952,  1),
+(44932, 0,   6, 56,     0, 24953,  1),
+(44925, 0,   6, 56,     0, 24946,  1),
+(44926, 0,   6, 56,     0, 24947,  1),
+(44927, 0,   6, 56,     0, 24948,  1),
+(44928, 0,   6, 56,     0, 24949,  1),
+(44989, 0,   6, 56,     0, 24984,  1),
+(44990, 0,   6, 56,     0, 24985,  1),
+(44991, 0,   6, 56,     0, 24986,  1),
+(44992, 0,   6, 56,     0, 24987,  1),
+(44995, 0,   6, 56,     0, 24988,  1),
+(44996, 0,   6, 56,     0, 24990,  1),
+(40804, 0,  24,  0, 32688,     0, 25),
+(40805, 0,  24,  0, 32689,     0, 25),
+(40806, 0,  24,  0, 32690,     0, 25),
+(40807, 0,  24,  0, 32691,     0, 25),
+(40808, 0,  24,  0, 32692,     0, 25),
+(40809, 0,  24,  0, 32693,     0, 25),
+(40908, 0,  24,  0, 32700,     0, 25),
+(40910, 0,  24,  0, 32701,     0, 25),
+(40911, 0,  24,  0, 32702,     0, 25),
+(40912, 0,  24,  0, 32703,     0, 25),
+(40913, 0,  24,  0, 32704,     0, 25),
+(40914, 0,  24,  0, 32705,     0, 25),
+(40915, 0,  24,  0, 32706,     0, 25),
+(40916, 0,  24,  0, 32707,     0, 25),
+(40918, 0,  24,  0, 32708,     0, 25),
+(40919, 0,  24,  0, 32709,     0, 25),
+(40920, 0,  24,  0, 32710,     0, 25),
+(40921, 0,  24,  0, 32711,     0, 25),
+(40922, 0,  24,  0, 32712,     0, 25),
+(40923, 0,  24,  0, 32713,     0, 25),
+(45155, 0,   6, 56,     0, 25116,  1),
+(45156, 0,   6, 56,     0, 25117,  1),
+(45157, 0,   6, 56,     0, 25118,  1),
+(45158, 0,   6, 56,     0, 25119,  1),
+(45159, 0,   6, 56,     0, 25120,  1),
+(45160, 0,   6, 56,     0, 25121,  1),
+(45161, 0,   6, 56,     0, 25122,  1),
+(45162, 0,   6, 56,     0, 25123,  1),
+(45163, 0,   6, 56,     0, 25124,  1),
+(45164, 0,   6, 56,     0, 25125,  1),
+(45165, 0,   6, 56,     0, 25126,  1),
+(45166, 0,   6, 56,     0, 25127,  1),
+(45167, 0,   6, 56,     0, 25128,  1),
+(45168, 0,   6, 56,     0, 25129,  1),
+(45169, 0,   6, 56,     0, 25130,  1),
+(45170, 0,   6, 56,     0, 25131,  1);