API tools faq
paste
Advertisement
nimzo_asc

sword n thunder nimzo

nimzo_asc
Nov 16th, 2020
50
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 12.27 KB | None | 0 0
raw download clone embed print report
  1. DELETE FROM `spell_proc` WHERE `SpellId` IN (50227,850227);
  2. INSERT INTO `spell_proc` (`SpellId`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `ProcFlags`, `SpellTypeMask`, `SpellPhaseMask`, `HitMask`, `AttributesMask`, `ProcsPerMinute`, `Chance`, `Cooldown`, `Charges`, `Comment`) VALUES
  3. (50227,0,4,0,512,0,16,0,1,0,0,0,100,0,1,'Sword and Board -> Shield Slam'),
  4. (850227,0,4,128,0,0,256,0,1,0,0,0,100,0,1,'Sword and Thunder -> Thunder Clap');
  5.  
  6. DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN (50227,- );
  7. INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES
  8. (50227,850227,0,'Sword and Board -> Sword and Thunder'),
  9. (-850227,-50227,0,'Sword and Thunder -> Sword and Board');
  10.  
  11. DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` = 17 AND `SourceEntry` = 850227;
  12. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
  13. (17,0,850227,0,0,1,0,979777,0,0,0,0,0,'','Sword and Thunder removal SLS');
  14.  
  15. DELETE FROM `spell` WHERE `ID`=50227;
  16. 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 (50227, 0, 0, 0, 16, 0, 0, 0, 0, 0, 64, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 16, 100, 1, 0, 0, 1, 28, 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, -1, 0, 0, 6, 6, 6, 1, 1, 1, 0, 0, 0, -101, 19, -1, 0, 0, 0, 1, 1, 1, 0, 0, 0, 0, 0, 0, 108, 108, 108, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 14, 2, 14, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 512, 0, 0, 512, 0, 128, 0, 0, 345, 0, 2780, 0, 50, 'Sword and Board', 'Sword and Board', 'Epée et bouclier', 'Schwert und Schild', '劍盾合璧', '劍盾合璧', 'Escudo y espada', 'Escudo y espada', 'Щит и меч', 0, 0, 0, 0, 0, 0, 0, 16712190, '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 16712190, 'When your Devastate or Revenge ability deals damage they have a chance of refreshing the cooldown of your Shield Slam ability and reducing its cost by $50227s1% for $50227d.', 'When your Devastate or Revenge ability deals damage they have a chance of refreshing the cooldown of your Shield Slam ability and reducing its cost by $50227s1% for $50227d.', 'Quand vos techniques Dévaster ou Vengeance infligent des dégâts, elles ont une chance de mettre fin au temps de recharge de votre technique Heurt de bouclier et de réduire son coût de $50227s1% pendant $50227d.', 'Wenn Eure Fähigkeiten \'Verwüsten\' oder \'Rache\' Schaden verursachen, haben sie eine Chance, die Abklingzeit von \'Schildschlag\' abzuschließen und die Kosten der Fähigkeit $50227d lang um $50227s1% zu verringern.', '當你的挫敗或復仇技能造成傷害時，有一定的機率重置你的盾牌猛擊冷卻時間，並降低其消耗的怒氣$50227s1%，持續$50227d。', '當你的挫敗或復仇技能造成傷害時，有一定的機率重置你的盾牌猛擊冷卻時間，並降低其消耗的怒氣$50227s1%，持續$50227d。', 'Cuando tus facultades Devastar o Revancha infligen daño, tienen una probabilidad de reiniciar el tiempo de reutilización de Embate con escudo y reducir su coste un $50227s1% durante $50227d.', 'Cuando tus facultades Devastar o Revancha infligen daño, tienen una probabilidad de reiniciar el tiempo de reutilización de Embate con escudo y reducir su coste un $50227s1% durante $50227d.', 'При нанесении урона способностями "Сокрушение" или "Реванш" с некоторой вероятностью мгновенно восстановится способность "Мощный удар щитом", а расход ярости на ее применение снизится на $50227s1% на $50227d.', 0, 0, 0, 0, 0, 0, 0, 16712190, 'Shield Slam rage cost reduced by $s1% and threat increased by $s2%.', 'Shield Slam rage cost reduced by $s1%.', 'Coût en rage de Heurt de bouclier réduit de $s1%.', 'Wutkosten für \'Schildschlag\' um $s1% verringert.', '盾牌猛擊的怒氣消耗降低$s1%。', '盾牌猛擊的怒氣消耗降低$s1%。', 'Coste de ira de Embate con escudo reducido un $s1%.', 'Coste de ira de Embate con escudo reducido un $s1%.', 'Для применения способности "Мощный удар щитом" требуется на $s1% меньше ярости.', 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, 4, 0, 0, 8192, 0, 0, 0, 0, 1, 1, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0);
  17. DELETE FROM `spell` WHERE `ID`=850227;
  18. INSERT INTO `spell` VALUES (850227, 0, 0, 0, 400, 268435456, 0, 0, 0, 0, 64, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 16, 100, 1, 0, 0, 1, 28, 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, -1, 0, 0, 0, 0, 6, 1, 1, 1, 0, 0, 0, -101, 19, -1, 0, 0, 0, 1, 1, 1, 0, 0, 0, 0, 0, 0, 108, 108, 108, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 14, 2, 14, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 512, 0, 0, 512, 0, 128, 0, 0, 345, 0, 2780, 0, 50, 'Sword and Board', 'Sword and Board', 'Epée et bouclier', 'Schwert und Schild', '劍盾合璧', '劍盾合璧', 'Escudo y espada', 'Escudo y espada', 'Щит и меч', 0, 0, 0, 0, 0, 0, 0, 16712190, '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 16712190, 'When your Devastate or Revenge ability deals damage they have a chance of refreshing the cooldown of your Shield Slam ability and reducing its cost by $50227s1% for $50227d.', 'When your Devastate or Revenge ability deals damage they have a chance of refreshing the cooldown of your Shield Slam ability and reducing its cost by $50227s1% for $50227d.', 'Quand vos techniques Dévaster ou Vengeance infligent des dégâts, elles ont une chance de mettre fin au temps de recharge de votre technique Heurt de bouclier et de réduire son coût de $50227s1% pendant $50227d.', 'Wenn Eure Fähigkeiten \'Verwüsten\' oder \'Rache\' Schaden verursachen, haben sie eine Chance, die Abklingzeit von \'Schildschlag\' abzuschließen und die Kosten der Fähigkeit $50227d lang um $50227s1% zu verringern.', '當你的挫敗或復仇技能造成傷害時，有一定的機率重置你的盾牌猛擊冷卻時間，並降低其消耗的怒氣$50227s1%，持續$50227d。', '當你的挫敗或復仇技能造成傷害時，有一定的機率重置你的盾牌猛擊冷卻時間，並降低其消耗的怒氣$50227s1%，持續$50227d。', 'Cuando tus facultades Devastar o Revancha infligen daño, tienen una probabilidad de reiniciar el tiempo de reutilización de Embate con escudo y reducir su coste un $50227s1% durante $50227d.', 'Cuando tus facultades Devastar o Revancha infligen daño, tienen una probabilidad de reiniciar el tiempo de reutilización de Embate con escudo y reducir su coste un $50227s1% durante $50227d.', 'При нанесении урона способностями "Сокрушение" или "Реванш" с некоторой вероятностью мгновенно восстановится способность "Мощный удар щитом", а расход ярости на ее применение снизится на $50227s1% на $50227d.', 0, 0, 0, 0, 0, 0, 0, 16712190, 'Shield Slam rage cost reduced by $s1% and threat increased by $s2%.', 'Shield Slam rage cost reduced by $s1%.', 'Coût en rage de Heurt de bouclier réduit de $s1%.', 'Wutkosten für \'Schildschlag\' um $s1% verringert.', '盾牌猛擊的怒氣消耗降低$s1%。', '盾牌猛擊的怒氣消耗降低$s1%。', 'Coste de ira de Embate con escudo reducido un $s1%.', 'Coste de ira de Embate con escudo reducido un $s1%.', 'Для применения способности "Мощный удар щитом" требуется на $s1% меньше ярости.', 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, 4, 0, 0, 8192, 0, 0, 0, 0, 1, 1, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0);
  19.  
  20.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!