Advertisement
IcariumQA

Snow Storm Hailstorm fix

Aug 26th, 2021
416
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 9.02 KB | None | 0 0
  1. DELETE FROM `spell_affect` WHERE `entry`=970161 AND `effectId`=0 AND `spellId`=-10;
  2. INSERT INTO `spell_affect` (`entry`, `effectId`, `spellId`, `Comment`) VALUES (970161, 0, -10, 'Snow Storm (EFF_0) -> Blizzard');
  3. DELETE FROM `db_spellitemenchantment_12340` WHERE `ID`=970161;
  4. INSERT INTO `db_spellitemenchantment_12340` (`ID`, `Charges`, `Effect_1`, `Effect_2`, `Effect_3`, `EffectPointsMin_1`, `EffectPointsMin_2`, `EffectPointsMin_3`, `EffectPointsMax_1`, `EffectPointsMax_2`, `EffectPointsMax_3`, `EffectArg_1`, `EffectArg_2`, `EffectArg_3`, `Name_Lang_enUS`, `Name_Lang_enGB`, `Name_Lang_koKR`, `Name_Lang_frFR`, `Name_Lang_deDE`, `Name_Lang_enCN`, `Name_Lang_zhCN`, `Name_Lang_enTW`, `Name_Lang_zhTW`, `Name_Lang_esES`, `Name_Lang_esMX`, `Name_Lang_ruRU`, `Name_Lang_ptPT`, `Name_Lang_ptBR`, `Name_Lang_itIT`, `Name_Lang_Unk`, `Name_Lang_Mask`, `ItemVisual`, `Flags`, `Src_ItemID`, `Condition_Id`, `RequiredSkillID`, `RequiredSkillRank`, `MinLevel`) VALUES (970161, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 970161, 0, 0, 'Equip: Snow Storm - Increases the channel duration of your Blizzard ability by 2 seconds.', 'Equip: Snow Storm - Increases the channel duration of your Blizzard ability by 2 seconds.', 'Equip: Snow Storm - Increases the channel duration of your Blizzard ability by 2 seconds.', 'Equip: Snow Storm - Increases the channel duration of your Blizzard ability by 2 seconds.', 'Equip: Snow Storm - Increases the channel duration of your Blizzard ability by 2 seconds.', 'Equip: Snow Storm - Increases the channel duration of your Blizzard ability by 2 seconds.', 'Equip: Snow Storm - Increases the channel duration of your Blizzard ability by 2 seconds.', 'Equip: Snow Storm - Increases the channel duration of your Blizzard ability by 2 seconds.', 'Equip: Snow Storm - Increases the channel duration of your Blizzard ability by 2 seconds.', 'Equip: Snow Storm - Increases the channel duration of your Blizzard ability by 2 seconds.', 'Equip: Snow Storm - Increases the channel duration of your Blizzard ability by 2 seconds.', 'Equip: Snow Storm - Increases the channel duration of your Blizzard ability by 2 seconds.', 'Equip: Snow Storm - Increases the channel duration of your Blizzard ability by 2 seconds.', 'Equip: Snow Storm - Increases the channel duration of your Blizzard ability by 2 seconds.', 'Equip: Snow Storm - Increases the channel duration of your Blizzard ability by 2 seconds.', '', 16712190, 0, 0, 0, 0, 0, 0, 0);
  5. DELETE FROM `spell` WHERE `ID`=970161;
  6. INSERT INTO `spell` (`ID`, `Category`, `Dispel`, `Mechanic`, `Attributes`, `AttributesEx`, `AttributesEx2`, `AttributesEx3`, `AttributesEx4`, `AttributesEx5`, `AttributesEx6`, `AttributesEx7`, `Stances`, `Unknown1`, `StancesNot`, `Unknown2`, `Targets`, `TargetCreatureType`, `RequiresSpellFocus`, `FacingCasterFlags`, `CasterAuraState`, `TargetAuraState`, `CasterAuraStateNot`, `TargetAuraStateNot`, `CasterAuraSpell`, `TargetAuraSpell`, `ExcludeCasterAuraSpell`, `ExcludeTargetAuraSpell`, `CastingTimeIndex`, `RecoveryTime`, `CategoryRecoveryTime`, `InterruptFlags`, `AuraInterruptFlags`, `ChannelInterruptFlags`, `ProcFlags`, `ProcChance`, `ProcCharges`, `MaximumLevel`, `BaseLevel`, `SpellLevel`, `DurationIndex`, `PowerType`, `ManaCost`, `ManaCostPerLevel`, `ManaPerSecond`, `ManaPerSecondPerLevel`, `RangeIndex`, `Speed`, `ModalNextSpell`, `StackAmount`, `Totem1`, `Totem2`, `Reagent1`, `Reagent2`, `Reagent3`, `Reagent4`, `Reagent5`, `Reagent6`, `Reagent7`, `Reagent8`, `ReagentCount1`, `ReagentCount2`, `ReagentCount3`, `ReagentCount4`, `ReagentCount5`, `ReagentCount6`, `ReagentCount7`, `ReagentCount8`, `EquippedItemClass`, `EquippedItemSubClassMask`, `EquippedItemInventoryTypeMask`, `Effect1`, `Effect2`, `Effect3`, `EffectDieSides1`, `EffectDieSides2`, `EffectDieSides3`, `EffectRealPointsPerLevel1`, `EffectRealPointsPerLevel2`, `EffectRealPointsPerLevel3`, `EffectBasePoints1`, `EffectBasePoints2`, `EffectBasePoints3`, `EffectMechanic1`, `EffectMechanic2`, `EffectMechanic3`, `EffectImplicitTargetA1`, `EffectImplicitTargetA2`, `EffectImplicitTargetA3`, `EffectImplicitTargetB1`, `EffectImplicitTargetB2`, `EffectImplicitTargetB3`, `EffectRadiusIndex1`, `EffectRadiusIndex2`, `EffectRadiusIndex3`, `EffectApplyAuraName1`, `EffectApplyAuraName2`, `EffectApplyAuraName3`, `EffectAmplitude1`, `EffectAmplitude2`, `EffectAmplitude3`, `EffectMultipleValue1`, `EffectMultipleValue2`, `EffectMultipleValue3`, `EffectChainTarget1`, `EffectChainTarget2`, `EffectChainTarget3`, `EffectItemType1`, `EffectItemType2`, `EffectItemType3`, `EffectMiscValue1`, `EffectMiscValue2`, `EffectMiscValue3`, `EffectMiscValueB1`, `EffectMiscValueB2`, `EffectMiscValueB3`, `EffectTriggerSpell1`, `EffectTriggerSpell2`, `EffectTriggerSpell3`, `EffectPointsPerComboPoint1`, `EffectPointsPerComboPoint2`, `EffectPointsPerComboPoint3`, `EffectSpellClassMaskA1`, `EffectSpellClassMaskA2`, `EffectSpellClassMaskA3`, `EffectSpellClassMaskB1`, `EffectSpellClassMaskB2`, `EffectSpellClassMaskB3`, `EffectSpellClassMaskC1`, `EffectSpellClassMaskC2`, `EffectSpellClassMaskC3`, `SpellVisual1`, `SpellVisual2`, `SpellIconID`, `ActiveIconID`, `SpellPriority`, `SpellName0`, `SpellName1`, `SpellName2`, `SpellName3`, `SpellName4`, `SpellName5`, `SpellName6`, `SpellName7`, `SpellName8`, `SpellNameFlag0`, `SpellNameFlag1`, `SpellNameFlag2`, `SpellNameFlag3`, `SpellNameFlag4`, `SpellNameFlag5`, `SpellNameFlag6`, `SpellNameFlag7`, `SpellRank0`, `SpellRank1`, `SpellRank2`, `SpellRank3`, `SpellRank4`, `SpellRank5`, `SpellRank6`, `SpellRank7`, `SpellRank8`, `SpellRankFlags0`, `SpellRankFlags1`, `SpellRankFlags2`, `SpellRankFlags3`, `SpellRankFlags4`, `SpellRankFlags5`, `SpellRankFlags6`, `SpellRankFlags7`, `SpellDescription0`, `SpellDescription1`, `SpellDescription2`, `SpellDescription3`, `SpellDescription4`, `SpellDescription5`, `SpellDescription6`, `SpellDescription7`, `SpellDescription8`, `SpellDescriptionFlags0`, `SpellDescriptionFlags1`, `SpellDescriptionFlags2`, `SpellDescriptionFlags3`, `SpellDescriptionFlags4`, `SpellDescriptionFlags5`, `SpellDescriptionFlags6`, `SpellDescriptionFlags7`, `SpellToolTip0`, `SpellToolTip1`, `SpellToolTip2`, `SpellToolTip3`, `SpellToolTip4`, `SpellToolTip5`, `SpellToolTip6`, `SpellToolTip7`, `SpellToolTip8`, `SpellToolTipFlags0`, `SpellToolTipFlags1`, `SpellToolTipFlags2`, `SpellToolTipFlags3`, `SpellToolTipFlags4`, `SpellToolTipFlags5`, `SpellToolTipFlags6`, `SpellToolTipFlags7`, `ManaCostPercentage`, `StartRecoveryCategory`, `StartRecoveryTime`, `MaximumTargetLevel`, `SpellFamilyName`, `SpellFamilyFlags`, `SpellFamilyFlags1`, `SpellFamilyFlags2`, `MaximumAffectedTargets`, `DamageClass`, `PreventionType`, `StanceBarOrder`, `EffectDamageMultiplier1`, `EffectDamageMultiplier2`, `EffectDamageMultiplier3`, `MinimumFactionId`, `MinimumReputation`, `RequiredAuraVision`, `TotemCategory1`, `TotemCategory2`, `AreaGroupID`, `SchoolMask`, `RuneCostID`, `SpellMissileID`, `PowerDisplayId`, `EffectBonusMultiplier1`, `EffectBonusMultiplier2`, `EffectBonusMultiplier3`, `DescriptionVariableID`, `SpellDifficultyID`) VALUES (970161, 0, 0, 0, 464, 2048, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 101, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 6, 0, 0, 1, 0, 0, 0, 0, 0, 1999, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 107, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 285, 0, 0, 'Snow Storm', 'Persistent Blizzard', 'Persistent Blizzard', 'Persistent Blizzard', 'Persistent Blizzard', 'Persistent Blizzard', 'Ventisca persistente', 'Ventisca persistente', 'Мощная метелица', 0, 0, 0, 0, 0, 0, 0, 16712190, 'Rank 3', 'Rank 1', 'Rank 1', 'Rank 1', 'Rank 1', 'Rank 1', 'Rank 1', 'Rank 1', 'Уровень 1', 0, 0, 0, 0, 0, 0, 0, 16712190, 'Increases the channel duration of your Blizzard ability by 2 seconds.', 'Increases the duration of your Blizzard ability by $/1000;S1 seconds.', 'Increases the duration of your Blizzard ability by $/1000;S1 seconds.', 'Increases the duration of your Blizzard ability by $/1000;S1 seconds.', 'Increases the duration of your Blizzard ability by $/1000;S1 seconds.', 'Increases the duration of your Blizzard ability by $/1000;S1 seconds.', 'Increases the duration of your Blizzard ability by $/1000;S1 seconds.', 'Increases the duration of your Blizzard ability by $/1000;S1 seconds.', 'Увеличивает длительность способности "Снежная буря" на $/1000;S1 секунд.', 0, 0, 0, 0, 0, 0, 0, 16712190, 'Increases the channel duration of your Blizzard ability by $/1000;S1 seconds.', 'Increases the duration of your Blizzard ability by $/1000;S1 seconds.', 'Increases the duration of your Blizzard ability by $/1000;S1 seconds.', 'Increases the duration of your Blizzard ability by $/1000;S1 seconds.', '', '', 'Increases the duration of your Blizzard ability by $/1000;S1 seconds.', 'Increases the duration of your Blizzard ability by $/1000;S1 seconds.', 'Increases the duration of your Blizzard ability by $/1000;S1 seconds.', 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0);
  7.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement