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