Advertisement
IcariumQA

Dark Apotheosis meta tank

Dec 7th, 2020 (edited)
106
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 19.34 KB | None | 0 0
  1. DELETE FROM `db_spellitemenchantment_12340` WHERE `ID`=980056;
  2. INSERT INTO `db_spellitemenchantment_12340` VALUES (980056, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 980056, 0, 0, 'Equip: Dark Apotheosis - While in Metamorphosis your damage done is reduced by 15%, but your threat generated is increased by 30%, and increases the duration of your Immolation aura by 25 seconds. In addition, you learn the ability Demon Spikes.  The cooldown of Metamorphosis is reduced by 50%, but you only benefit from its armor increase effects. [the reduced chance to be critically hit, the bonus damage increase, or the reduced duration of stuns and snares. ]  While dual-wielding or using a single two-hander,  your Immolation Aura now increases your maximum health by 25%, reduces your chance to be critically hit by 3%, and increases the healing from Soul Leech by 100%. ', 'Equip: Dark Apotheosis - While in Metamorphosis your damage done is reduced by 15%, but your threat generated is increased by 30%, and increases the duration of your Immolation aura by 25 seconds. In addition, you learn the ability Demon Spikes.  The cooldown of Metamorphosis is reduced by 50%, but you only benefit from its armor increase effects. [the reduced chance to be critically hit, the bonus damage increase, or the reduced duration of stuns and snares. ]  While dual-wielding or using a single two-hander,  your Immolation Aura now increases your maximum health by 25%, reduces your chance to be critically hit by 3%, and increases the healing from Soul Leech by 100%. ', 'Equip: Dark Apotheosis - While in Metamorphosis your damage done is reduced by 15%, but your threat generated is increased by 30%, and increases the duration of your Immolation aura by 25 seconds. In addition, you learn the ability Demon Spikes.  The cooldown of Metamorphosis is reduced by 50%, but you only benefit from its armor increase effects. [the reduced chance to be critically hit, the bonus damage increase, or the reduced duration of stuns and snares. ]  While dual-wielding or using a single two-hander,  your Immolation Aura now increases your maximum health by 25%, reduces your chance to be critically hit by 3%, and increases the healing from Soul Leech by 100%. ', 'Equip: Dark Apotheosis - While in Metamorphosis your damage done is reduced by 15%, but your threat generated is increased by 30%, and increases the duration of your Immolation aura by 25 seconds. In addition, you learn the ability Demon Spikes.  The cooldown of Metamorphosis is reduced by 50%, but you only benefit from its armor increase effects. [the reduced chance to be critically hit, the bonus damage increase, or the reduced duration of stuns and snares. ]  While dual-wielding or using a single two-hander,  your Immolation Aura now increases your maximum health by 25%, reduces your chance to be critically hit by 3%, and increases the healing from Soul Leech by 100%. ', 'Equip: Dark Apotheosis - While in Metamorphosis your damage done is reduced by 15%, but your threat generated is increased by 30%, and increases the duration of your Immolation aura by 25 seconds. In addition, you learn the ability Demon Spikes.  The cooldown of Metamorphosis is reduced by 50%, but you only benefit from its armor increase effects. [the reduced chance to be critically hit, the bonus damage increase, or the reduced duration of stuns and snares. ]  While dual-wielding or using a single two-hander,  your Immolation Aura now increases your maximum health by 25%, reduces your chance to be critically hit by 3%, and increases the healing from Soul Leech by 100%. ', 'Equip: Dark Apotheosis - While in Metamorphosis your damage done is reduced by 15%, but your threat generated is increased by 30%, and increases the duration of your Immolation aura by 25 seconds. In addition, you learn the ability Demon Spikes.  The cooldown of Metamorphosis is reduced by 50%, but you only benefit from its armor increase effects. [the reduced chance to be critically hit, the bonus damage increase, or the reduced duration of stuns and snares. ]  While dual-wielding or using a single two-hander,  your Immolation Aura now increases your maximum health by 25%, reduces your chance to be critically hit by 3%, and increases the healing from Soul Leech by 100%. ', 'Equip: Dark Apotheosis - While in Metamorphosis your damage done is reduced by 15%, but your threat generated is increased by 30%, and increases the duration of your Immolation aura by 25 seconds. In addition, you learn the ability Demon Spikes.  The cooldown of Metamorphosis is reduced by 50%, but you only benefit from its armor increase effects. [the reduced chance to be critically hit, the bonus damage increase, or the reduced duration of stuns and snares. ]  While dual-wielding or using a single two-hander,  your Immolation Aura now increases your maximum health by 25%, reduces your chance to be critically hit by 3%, and increases the healing from Soul Leech by 100%. ', 'Equip: Dark Apotheosis - While in Metamorphosis your damage done is reduced by 15%, but your threat generated is increased by 30%, and increases the duration of your Immolation aura by 25 seconds. In addition, you learn the ability Demon Spikes.  The cooldown of Metamorphosis is reduced by 50%, but you only benefit from its armor increase effects. [the reduced chance to be critically hit, the bonus damage increase, or the reduced duration of stuns and snares. ]  While dual-wielding or using a single two-hander,  your Immolation Aura now increases your maximum health by 25%, reduces your chance to be critically hit by 3%, and increases the healing from Soul Leech by 100%. ', 'Equip: Dark Apotheosis - While in Metamorphosis your damage done is reduced by 15%, but your threat generated is increased by 30%, and increases the duration of your Immolation aura by 25 seconds. In addition, you learn the ability Demon Spikes.  The cooldown of Metamorphosis is reduced by 50%, but you only benefit from its armor increase effects. [the reduced chance to be critically hit, the bonus damage increase, or the reduced duration of stuns and snares. ]  While dual-wielding or using a single two-hander,  your Immolation Aura now increases your maximum health by 25%, reduces your chance to be critically hit by 3%, and increases the healing from Soul Leech by 100%. ', 'Equip: Dark Apotheosis - While in Metamorphosis your damage done is reduced by 15%, but your threat generated is increased by 30%, and increases the duration of your Immolation aura by 25 seconds. In addition, you learn the ability Demon Spikes.  The cooldown of Metamorphosis is reduced by 50%, but you only benefit from its armor increase effects. [the reduced chance to be critically hit, the bonus damage increase, or the reduced duration of stuns and snares. ]  While dual-wielding or using a single two-hander,  your Immolation Aura now increases your maximum health by 25%, reduces your chance to be critically hit by 3%, and increases the healing from Soul Leech by 100%. ', 'Equip: Dark Apotheosis - While in Metamorphosis your damage done is reduced by 15%, but your threat generated is increased by 30%, and increases the duration of your Immolation aura by 25 seconds. In addition, you learn the ability Demon Spikes.  The cooldown of Metamorphosis is reduced by 50%, but you only benefit from its armor increase effects. [the reduced chance to be critically hit, the bonus damage increase, or the reduced duration of stuns and snares. ]  While dual-wielding or using a single two-hander,  your Immolation Aura now increases your maximum health by 25%, reduces your chance to be critically hit by 3%, and increases the healing from Soul Leech by 100%. ', 'Equip: Dark Apotheosis - While in Metamorphosis your damage done is reduced by 15%, but your threat generated is increased by 30%, and increases the duration of your Immolation aura by 25 seconds. In addition, you learn the ability Demon Spikes.  The cooldown of Metamorphosis is reduced by 50%, but you only benefit from its armor increase effects. [the reduced chance to be critically hit, the bonus damage increase, or the reduced duration of stuns and snares. ]  While dual-wielding or using a single two-hander,  your Immolation Aura now increases your maximum health by 25%, reduces your chance to be critically hit by 3%, and increases the healing from Soul Leech by 100%. ', 'Equip: Dark Apotheosis - While in Metamorphosis your damage done is reduced by 15%, but your threat generated is increased by 30%, and increases the duration of your Immolation aura by 25 seconds. In addition, you learn the ability Demon Spikes.  The cooldown of Metamorphosis is reduced by 50%, but you only benefit from its armor increase effects. [the reduced chance to be critically hit, the bonus damage increase, or the reduced duration of stuns and snares. ]  While dual-wielding or using a single two-hander,  your Immolation Aura now increases your maximum health by 25%, reduces your chance to be critically hit by 3%, and increases the healing from Soul Leech by 100%. ', 'Equip: Dark Apotheosis - While in Metamorphosis your damage done is reduced by 15%, but your threat generated is increased by 30%, and increases the duration of your Immolation aura by 25 seconds. In addition, you learn the ability Demon Spikes.  The cooldown of Metamorphosis is reduced by 50%, but you only benefit from its armor increase effects. [the reduced chance to be critically hit, the bonus damage increase, or the reduced duration of stuns and snares. ]  While dual-wielding or using a single two-hander,  your Immolation Aura now increases your maximum health by 25%, reduces your chance to be critically hit by 3%, and increases the healing from Soul Leech by 100%. ', 'Equip: Dark Apotheosis - While in Metamorphosis your damage done is reduced by 15%, but your threat generated is increased by 30%, and increases the duration of your Immolation aura by 25 seconds. In addition, you learn the ability Demon Spikes.  The cooldown of Metamorphosis is reduced by 50%, but you only benefit from its armor increase effects. [the reduced chance to be critically hit, the bonus damage increase, or the reduced duration of stuns and snares. ]  While dual-wielding or using a single two-hander,  your Immolation Aura now increases your maximum health by 25%, reduces your chance to be critically hit by 3%, and increases the healing from Soul Leech by 100%. ', '', 16712190, 0, 0, 0, 0, 0, 0, 0);
  3.  
  4.  
  5.  
  6. DELETE FROM `item_enchantment_random_tiers` WHERE `enchantID`=980056;
  7. INSERT INTO `item_enchantment_random_tiers` VALUES (980056, 1, 'ARMOR', NULL, 980056, 'Dark Apotheosis', 0, 100);
  8.  
  9. DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=980056 AND `spell_effect`=980057 AND `type`=2;
  10. INSERT INTO `spell_linked_spell` VALUES (980056, 980057, 2, 'Dark Apotheosis remove metamorphosis bonuses');
  11. DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=980056 AND `spell_effect`=980058 AND `type`=2;
  12. INSERT INTO `spell_linked_spell` VALUES (980056, 980058, 2, 'Dark Apotheosis Immolation Aura buffs');
  13.  
  14. DELETE FROM `spell` WHERE `ID`=980056;
  15. INSERT INTO `spell` VALUES (980056, 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, 0, 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, -51, -36, -1, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 108, 107, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 11, 23, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 8192, 0, 0, 8192, 0, 0, 0, 112224, 0, 4962, 0, 0, 'Dark Apotheosis', 'Dark Apotheosis', 'Dark Apotheosis', 'Dark Apotheosis', 'Dark Apotheosis', 'Dark Apotheosis', 'Dark Apotheosis', 'Dark Apotheosis', 'Dark Apotheosis', 0, 0, 0, 0, 0, 0, 0, 16712190, 'Rank 5', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 16712190, 'While in Metamorphosis your damage done is reduced by 15%, but your threat generated is increased by 30%, and increases the duration of your Immolation aura by 25 seconds. In addition, you learn the ability Demon Spikes.  The cooldown of Metamorphosis is reduced by 50%, but you only benefit from its armor increase effects. [the reduced chance to be critically hit, the bonus damage increase, or the reduced duration of stuns and snares. ]  While dual-wielding or using a single two-hander,  your Immolation Aura now increases your maximum health by 25%, reduces your chance to be critically hit by 3%, and increases the healing from Soul Leech by 100%. ', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 16712190, '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, 5, 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);
  16.  
  17.  
  18.  
  19. #980057 remove Metamorphosis passive effects
  20. DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=980056 AND `spell_effect`=980057 AND `type`=2;
  21. INSERT INTO `spell_linked_spell` VALUES (980056, 980057, 2, 'Dark Apotheosis remove metamorphosis bonuses');
  22. DELETE FROM `spell` WHERE `ID`=980057;
  23. INSERT INTO `spell` VALUES (980057, 0, 0, 0, 464, 0, 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, 65536, 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, 6, 1, 1, 1, 0, 0, 0, 49, 49, 5, 0, 0, 0, 1, 1, 1, 0, 0, 0, 0, 0, 0, 107, 107, 107, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, 12, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 8388608, 0, 0, 8388608, 0, 0, 16777216, 0, 0, 4962, 0, 0, 'Dark Apotheosis', 'Dark Apotheosis', 'Dark Apotheosis', 'Dark Apotheosis', 'Dark Apotheosis', 'Dark Apotheosis', 'Dark Apotheosis', 'Dark Apotheosis', 'Dark Apotheosis', 0, 0, 0, 0, 0, 0, 0, 16712190, '', 'Rank 5', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 16712190, 'Removes Snare duration reduction of Metamorphosis by $s1% and stun duration reduction by $s2%. In addition reduces the reduction to the chance to be critically hit in melee by $s3%. ', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 16712190, '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, 5, 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);
  24.  
  25. #980058 duration and proc on immolation aura, + metamorphosis threat buff
  26. DELETE FROM `spell_proc` WHERE `SpellId`=980058;
  27. INSERT INTO `spell_proc` VALUES (980058, 0, 5, 0, 0, 268435456, 349440, 1, 1, 0, 0, 0, 100, 0, 0, '');
  28. DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=980056 AND `spell_effect`=980058 AND `type`=2;
  29. INSERT INTO `spell_linked_spell` VALUES (980056, 980058, 2, 'Dark Apotheosis Immolation Aura buffs');
  30. DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=24 AND `SourceGroup`=0 AND `SourceEntry`=980058 AND `SourceId`=0 AND `ElseGroup`=0 AND `ConditionTypeOrReference`=1 AND `ConditionTarget`=0 AND `ConditionValue1`=774997 AND `ConditionValue2`=0 AND `ConditionValue3`=0 AND `NegativeCondition`=1 AND `ErrorType`=0 AND `ErrorTextId`=0 AND `ScriptName`='';
  31. INSERT INTO `conditions` VALUES (24, 0, 980058, 0, 0, 1, 0, 774997, 0, 0, 1, 0, 0, '', 'Dark Apotheosis no proc with held-in-offhand');
  32. DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=24 AND `SourceGroup`=0 AND `SourceEntry`=980058 AND `SourceId`=0 AND `ElseGroup`=0 AND `ConditionTypeOrReference`=1 AND `ConditionTarget`=0 AND `ConditionValue1`=774998 AND `ConditionValue2`=0 AND `ConditionValue3`=0 AND `NegativeCondition`=1 AND `ErrorType`=0 AND `ErrorTextId`=0 AND `ScriptName`='';
  33. INSERT INTO `conditions` VALUES (24, 0, 980058, 0, 0, 1, 0, 774998, 0, 0, 1, 0, 0, '', 'Dark Apotheosis no proc with shield');
  34. DELETE FROM `spell` WHERE `ID`=980058;
  35. INSERT INTO `spell` VALUES (980058, 0, 0, 0, 448, 0, 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, 6, 1, 1, 1, 0, 0, 0, 24999, -1, 29, 0, 0, 0, 1, 1, 1, 0, 0, 0, 0, 0, 0, 107, 42, 107, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 3, 0, 0, 0, 0, 980059, 0, 0, 0, 0, 0, 0, 268435456, 0, 0, 268435456, 0, 0, 4194304, 0, 0, 4962, 0, 0, 'Dark Apotheosis', 'Dark Apotheosis', 'Dark Apotheosis', 'Dark Apotheosis', 'Dark Apotheosis', 'Dark Apotheosis', 'Dark Apotheosis', 'Dark Apotheosis', 'Dark Apotheosis', 0, 0, 0, 0, 0, 0, 0, 16712190, '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 16712190, 'Adds $s1 ms to Immolation Aura. Procs 980059 on Immolation Aura. Increases threat while in Metamorphosis by $s3.', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 16712190, '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, 5, 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);
  36.  
  37. #980059 max health, crit hit reduction, soul leech buff
  38. DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=-50589 AND `spell_effect`=-980059 AND `type`=0;
  39. INSERT INTO `spell_linked_spell` VALUES (-50589, -980059, 0, 'Immolation Aura loses Dark Apotheosis buff');
  40. DELETE FROM `spell` WHERE `ID`=980059;
  41. INSERT INTO `spell` VALUES (980059, 0, 0, 0, 0, 0, 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, 65536, 100, 0, 0, 0, 0, 125, 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, 6, 1, 1, 1, 0, 0, 0, 24, -4, 101, 0, 0, 0, 1, 1, 1, 0, 0, 0, 0, 0, 0, 133, 187, 108, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 11, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 262144, 112224, 0, 4962, 0, 0, 'Dark Apotheosis', 'Dark Apotheosis', 'Dark Apotheosis', 'Dark Apotheosis', 'Dark Apotheosis', 'Dark Apotheosis', 'Dark Apotheosis', 'Dark Apotheosis', 'Dark Apotheosis', 0, 0, 0, 0, 0, 0, 0, 16712190, '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 16712190, 'Increases maximum health by $s1%, reduces your chance to be critically hit by $s2%, and increases health gained from Soul Leech by 100%. Lasts $d.', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 16712190, 'Increases maximum health by $s1%, reduces your chance to be critically hit by $s2%, and increases health gained from Soul Leech by 100%. Lasts $d.', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, 5, 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);
  42.  
  43. #980060
  44. DELETE FROM `spell` WHERE `ID`=980060;
  45. INSERT INTO `spell` VALUES (980060, 0, 0, 0, 16, 0, 0, 0, 0, 0, 0, 0, 2097152, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 65536, 100, 0, 0, 0, 0, 32, 1, 1000, 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, 6, 1, 1, 1, 0, 0, 0, 199, -6, 4, 0, 0, 0, 1, 1, 1, 0, 0, 0, 0, 0, 0, 182, 87, 107, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 126, 8, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16384, 0, 0, 4927, 0, 0, 'Demon Spikes', 'Dark Apotheosis', 'Dark Apotheosis', 'Dark Apotheosis', 'Dark Apotheosis', 'Dark Apotheosis', 'Dark Apotheosis', 'Dark Apotheosis', 'Dark Apotheosis', 0, 0, 0, 0, 0, 0, 0, 16712190, '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 16712190, 'Increases your armor by an amount equal to $s1% of your Intellect and reduces spell damage taken by $s2%. In addition, the percentage of damage shared via your Soul Link is increased $s3%. This effect lasts 6 seconds.', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 16712190, 'Increases your armor by an amount equal to $s1% of your Intellect and reduces spell damage taken by $s2%. In addition, the percentage of damage shared via your Soul Link is increased $s3%. This effect lasts 6 seconds.', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, 5, 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);
  46.  
  47.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement