IcariumQA

Righteous Flames (rare) buff + rename

May 7th, 2021 (edited)
136
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 9.62 KB | None | 0 0
  1. DELETE FROM `item_enchantment_random_tiers` WHERE `enchantID`=965412;
  2. INSERT INTO `item_enchantment_random_tiers` (`enchantID`, `tier`, `class`, `exclusiveSubClass`, `spellid`, `spellname`, `unstackable`, `chance`, `quality`) VALUES (965412, 1, 'ANY', NULL, 965412, 'Righteous Fire', 0, 100, 3);
  3. DELETE FROM `db_spellitemenchantment_12340` WHERE `ID`=965412;
  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 (965412, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 965412, 0, 0, 'Equip: Righteous Fire - Increases the damage over time effect of your Holy Fire ability by 60% and increases the duration of your Holy Fire damage over time effect by 1 second.', 'Equip: Righteous Fire - Increases the damage over time effect of your Holy Fire ability by 60% and increases the duration of your Holy Fire damage over time effect by 1 second.', 'Equip: Righteous Fire - Increases the damage over time effect of your Holy Fire ability by 60% and increases the duration of your Holy Fire damage over time effect by 1 second.', 'Equip: Righteous Fire - Increases the damage over time effect of your Holy Fire ability by 60% and increases the duration of your Holy Fire damage over time effect by 1 second.', 'Equip: Righteous Fire - Increases the damage over time effect of your Holy Fire ability by 60% and increases the duration of your Holy Fire damage over time effect by 1 second.', 'Equip: Righteous Fire - Increases the damage over time effect of your Holy Fire ability by 60% and increases the duration of your Holy Fire damage over time effect by 1 second.', 'Equip: Righteous Fire - Increases the damage over time effect of your Holy Fire ability by 60% and increases the duration of your Holy Fire damage over time effect by 1 second.', 'Equip: Righteous Fire - Increases the damage over time effect of your Holy Fire ability by 60% and increases the duration of your Holy Fire damage over time effect by 1 second.', 'Equip: Righteous Fire - Increases the damage over time effect of your Holy Fire ability by 60% and increases the duration of your Holy Fire damage over time effect by 1 second.', 'Equip: Righteous Fire - Increases the damage over time effect of your Holy Fire ability by 60% and increases the duration of your Holy Fire damage over time effect by 1 second.', 'Equip: Righteous Fire - Increases the damage over time effect of your Holy Fire ability by 60% and increases the duration of your Holy Fire damage over time effect by 1 second.', 'Equip: Righteous Fire - Increases the damage over time effect of your Holy Fire ability by 60% and increases the duration of your Holy Fire damage over time effect by 1 second.', 'Equip: Righteous Fire - Increases the damage over time effect of your Holy Fire ability by 60% and increases the duration of your Holy Fire damage over time effect by 1 second.', 'Equip: Righteous Fire - Increases the damage over time effect of your Holy Fire ability by 60% and increases the duration of your Holy Fire damage over time effect by 1 second.', 'Equip: Righteous Fire - Increases the damage over time effect of your Holy Fire ability by 60% and increases the duration of your Holy Fire damage over time effect by 1 second.', '', 16712190, 0, 0, 0, 0, 0, 0, 0);
  5. DELETE FROM `spell` WHERE `ID`=965412;
  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`, `SpellDescriptionVariableID`, `SpellDifficultyID`) VALUES (965412, 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, 6, 0, 1, 1, 1, 0, 0, 0, 59, 999, 3999, 0, 0, 0, 1, 1, 1, 0, 0, 0, 0, 0, 0, 108, 107, 107, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 22, 1, 11, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1048576, 0, 0, 1048576, 0, 0, 1024, 0, 0, 0, 0, 156, 0, 0, 'Righteous Fire', 'Item - Mage T8 2P Bonus', 'Righteous Flames', 'Righteous Flames', 'Righteous Flames', 'Righteous Flames', 'Righteous Flames', 'Righteous Flames', 'Праведное пламя', 0, 0, 0, 0, 0, 0, 0, 16712190, 'Rank 3', 'Rank 5', '', '', '', '', '', '', 'Уровень 1', 0, 0, 0, 0, 0, 0, 0, 16712190, 'Increases the damage over time effect of your Holy Fire ability by 60% and increases the duration of your Holy Fire damage over time effect by 1 second.', 'Your Arcane Blast, Frostbolt, Frostfire Bolt, and Fireball spells have a chance to grant you $64868s1 spell power for $64868d.', '', '', '', '', '', '', 'Увеличивает урон со временем от вашей способности "Священный огонь" на $s1%.', 0, 0, 0, 0, 0, 0, 0, 16712190, '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, 6, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 1, 0, 0, 0);
  7.  
Add Comment
Please, Sign In to add comment