diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2022_03_05_19_world_2020_12_24_03_world.sql | 177 |
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); |