IcariumQA

Fetch Me Their Bones! adding abilities

Jun 20th, 2021 (edited)
147
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. DELETE FROM `item_enchantment_random_tiers` WHERE `enchantID`=979786;
  2. INSERT INTO `item_enchantment_random_tiers` (`enchantID`, `tier`, `class`, `exclusiveSubClass`, `spellid`, `spellname`, `unstackable`, `chance`, `quality`, `requiredLevel`) VALUES (979786, 1, 'ARMOR', NULL, 979786, 'Fetch Me Their Bones!', 0, 100, 4, 0);
  3. DELETE FROM `db_spellitemenchantment_12340` WHERE `ID`=979786;
  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 (979786, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 979786, 0, 0, 'Equip: Fetch Me Their Bones! - Dealing damage with Arcane Shot, Steady Shot, Raptor Strike, Mongoose Bite, Counterattack, or Wing Clip will reduce the cooldown of Kill Command by 2 seconds. In addition, your Kill Command now increases the damage done by an additional 5% per stack. ', 'Equip: Fetch Me Their Bones! - Dealing damage with Arcane Shot, Steady Shot, Raptor Strike, Mongoose Bite, Counterattack, or Wing Clip will reduce the cooldown of Kill Command by 2 seconds. In addition, your Kill Command now increases the damage done by an additional 5% per stack. ', 'Equip: Fetch Me Their Bones! - Dealing damage with Arcane Shot, Steady Shot, Raptor Strike, Mongoose Bite, Counterattack, or Wing Clip will reduce the cooldown of Kill Command by 2 seconds. In addition, your Kill Command now increases the damage done by an additional 5% per stack. ', 'Equip: Fetch Me Their Bones! - Dealing damage with Arcane Shot, Steady Shot, Raptor Strike, Mongoose Bite, Counterattack, or Wing Clip will reduce the cooldown of Kill Command by 2 seconds. In addition, your Kill Command now increases the damage done by an additional 5% per stack. ', 'Equip: Fetch Me Their Bones! - Dealing damage with Arcane Shot, Steady Shot, Raptor Strike, Mongoose Bite, Counterattack, or Wing Clip will reduce the cooldown of Kill Command by 2 seconds. In addition, your Kill Command now increases the damage done by an additional 5% per stack. ', 'Equip: Fetch Me Their Bones! - Dealing damage with Arcane Shot, Steady Shot, Raptor Strike, Mongoose Bite, Counterattack, or Wing Clip will reduce the cooldown of Kill Command by 2 seconds. In addition, your Kill Command now increases the damage done by an additional 5% per stack. ', 'Equip: Fetch Me Their Bones! - Dealing damage with Arcane Shot, Steady Shot, Raptor Strike, Mongoose Bite, Counterattack, or Wing Clip will reduce the cooldown of Kill Command by 2 seconds. In addition, your Kill Command now increases the damage done by an additional 5% per stack. ', 'Equip: Fetch Me Their Bones! - Dealing damage with Arcane Shot, Steady Shot, Raptor Strike, Mongoose Bite, Counterattack, or Wing Clip will reduce the cooldown of Kill Command by 2 seconds. In addition, your Kill Command now increases the damage done by an additional 5% per stack. ', 'Equip: Fetch Me Their Bones! - Dealing damage with Arcane Shot, Steady Shot, Raptor Strike, Mongoose Bite, Counterattack, or Wing Clip will reduce the cooldown of Kill Command by 2 seconds. In addition, your Kill Command now increases the damage done by an additional 5% per stack. ', 'Equip: Fetch Me Their Bones! - Dealing damage with Arcane Shot, Steady Shot, Raptor Strike, Mongoose Bite, Counterattack, or Wing Clip will reduce the cooldown of Kill Command by 2 seconds. In addition, your Kill Command now increases the damage done by an additional 5% per stack. ', 'Equip: Fetch Me Their Bones! - Dealing damage with Arcane Shot, Steady Shot, Raptor Strike, Mongoose Bite, Counterattack, or Wing Clip will reduce the cooldown of Kill Command by 2 seconds. In addition, your Kill Command now increases the damage done by an additional 5% per stack. ', 'Equip: Fetch Me Their Bones! - Dealing damage with Arcane Shot, Steady Shot, Raptor Strike, Mongoose Bite, Counterattack, or Wing Clip will reduce the cooldown of Kill Command by 2 seconds. In addition, your Kill Command now increases the damage done by an additional 5% per stack. ', 'Equip: Fetch Me Their Bones! - Dealing damage with Arcane Shot, Steady Shot, Raptor Strike, Mongoose Bite, Counterattack, or Wing Clip will reduce the cooldown of Kill Command by 2 seconds. In addition, your Kill Command now increases the damage done by an additional 5% per stack. ', 'Equip: Fetch Me Their Bones! - Dealing damage with Arcane Shot, Steady Shot, Raptor Strike, Mongoose Bite, Counterattack, or Wing Clip will reduce the cooldown of Kill Command by 2 seconds. In addition, your Kill Command now increases the damage done by an additional 5% per stack. ', 'Equip: Fetch Me Their Bones! - Dealing damage with Arcane Shot, Steady Shot, Raptor Strike, Mongoose Bite, Counterattack, or Wing Clip will reduce the cooldown of Kill Command by 2 seconds. In addition, your Kill Command now increases the damage done by an additional 5% per stack. ', '', 16712190, 0, 0, 0, 0, 0, 0, 0);
  5. DELETE FROM `spell_proc` WHERE `SpellId`=979786;
  6. DELETE FROM `spell_proc` WHERE `SpellId`=979786;
  7. INSERT INTO `spell_proc` (`SpellId`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `ProcFlags`, `SpellTypeMask`, `SpellPhaseMask`, `HitMask`, `AttributesMask`, `ProcsPerMinute`, `Chance`, `Cooldown`, `Charges`, `Comment`) VALUES (979786, 0, 9, 2112, 524289, 33619968, 272, 1, 2, 3, 0, 0, 0, 0, 0, '');
  8.  
  9.  
  10. DELETE FROM `spell` WHERE `ID`=979786;
  11. 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 (979786, 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, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 1, 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, 4, -1, -1, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 107, 42, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 979787, 0, 0, 0, 0, 0, 2048, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2163, 0, 0, 'Fetch Me Their Bones!', 'Epic RE', 'Epic RE', 'Epic RE', 'Epic RE', 'Epic RE', 'Epic RE', 'Epic RE', 'Epic RE', 0, 0, 0, 0, 0, 0, 0, 16712190, 'Rank 4', 'Rank 4', 'Rank 4', 'Rank 4', 'Rank 4', 'Rank 4', 'Rank 4', 'Rank 4', 'Rank 4', 0, 0, 0, 0, 0, 0, 0, 16712190, 'Dealing damage with Arcane Shot, Steady Shot, Raptor Strike, Mongoose Bite, Counterattack, or Wing Clip will reduce the cooldown of Kill Command by 2 seconds. In addition, your Kill Command now increases the damage done by an additional 5% per stack. ', 'If you\'re reading this you need to update your patch.', 'If you\'re reading this you need to update your patch.', 'If you\'re reading this you need to update your patch.', 'If you\'re reading this you need to update your patch.', 'If you\'re reading this you need to update your patch.', 'If you\'re reading this you need to update your patch.', 'If you\'re reading this you need to update your patch.', 'If you\'re reading this you need to update your patch.', 0, 0, 0, 0, 0, 0, 0, 16712190, '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, 9, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0);
  12.  
Add Comment
Please, Sign In to add comment