Advertisement
IcariumQA

Heroic items with spell procs fix

Oct 17th, 2020 (edited)
120
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 4.91 KB | None | 0 0
  1. #HC Romulo's Poison Vial has no spell proc, causing it to trigger on all hits
  2. DELETE FROM `spell_proc` WHERE `SpellId`=234586;
  3. INSERT INTO `spell_proc` VALUES (234586, 0, 0, 0, 0, 0, 340, 1, 2, 0, 0, 2.5, 100, 0, 0, 'Romulo\'s Poison');
  4.  
  5. #HC scarab brooch Never triggered the shield
  6. DELETE FROM `spell_proc` WHERE `SpellId`=226467;
  7. INSERT INTO `spell_proc` VALUES (226467, 0, 0, 0, 0, 0, 0, 2, 2, 0, 128, 0, 0, 0, 0, 'Persistent Shield Heroic');
  8.  
  9. #Badge of the Swarmguard  has no spell proc, causing it to trigger on all hits
  10. DELETE FROM `spell_proc` WHERE `SpellId`=226480;
  11. INSERT INTO `spell_proc` VALUES (226480, 0, 0, 0, 0, 0, 0, 1, 2, 0, 0, 3, 0, 0, 0, 'Badge of the Swarmguard Heroic');
  12.  
  13. #Heart of Wyrmthalak   has no spell proc, causing it to trigger on all hits
  14. DELETE FROM `spell_proc` WHERE `SpellId`=227656;
  15. INSERT INTO `spell_proc` VALUES (227656, 0, 0, 0, 0, 0, 0, 1, 2, 0, 0, 3, 0, 0, 0, 'Flame Lash - Heroic');
  16.  
  17. #Pendant of the Violet Eye triggered on 0 mana cost abilities such as aspects
  18. DELETE FROM `spell_proc` WHERE `SpellId`=229601;
  19. INSERT INTO `spell_proc` VALUES (229601, 0, 0, 0, 0, 0, 0, 0, 2, 0, 4, 0, 0, 0, 0, 'Enlightenment Heroic');
  20.  
  21. #The Lightning Capacitor did not work
  22. DELETE FROM `spell_proc` WHERE `SpellId`=237657;
  23. INSERT INTO `spell_proc` VALUES (237657, 0, 0, 0, 0, 0, 0, 1, 2, 2, 0, 0, 0, 2500, 0, 'Lightning Capacitor Heroic');
  24.  
  25. #Tome of Fiery Redemption normal and heroic was missing proc chance in spell proc
  26. DELETE FROM `spell_proc` WHERE `SpellId`=37197;
  27. INSERT INTO `spell_proc` VALUES (37197, 0, 0, 0, 0, 0, 87056, 3, 2, 0, 0, 0, 15, 45000, 0, 'Spell Damage');
  28. DELETE FROM `spell_proc` WHERE `SpellId`=237197;
  29. INSERT INTO `spell_proc` VALUES (237197, 0, 0, 0, 0, 0, 87056, 3, 2, 0, 0, 0, 15, 45000, 0, 'Spell Damage Heroic');
  30.  
  31. #Warp-Spring Coil has no spell proc, causing it to trigger on all hits, normal was missing proc chance
  32. DELETE FROM `spell_proc` WHERE `SpellId`=37173;
  33. INSERT INTO `spell_proc` VALUES (37173, 1, 0, 0, 0, 0, 16, 1, 2, 3, 0, 0, 25, 45000, 0, 'Armor Penetration');
  34. DELETE FROM `spell_proc` WHERE `SpellId`=237173;
  35. INSERT INTO `spell_proc` VALUES (237173, 1, 0, 0, 0, 0, 16, 1, 2, 3, 0, 0, 25, 45000, 0, 'Armor Penetration Heroic');
  36.  
  37. #Fel Reaver's Piston didn't have proc chance, didn't trigger.
  38. DELETE FROM `spell_proc` WHERE `SpellId`=38299;
  39. INSERT INTO `spell_proc` VALUES (38299, 0, 0, 0, 0, 0, 0, 2, 2, 0, 0, 0, 15, 12000, 0, 'HoTs on Heals');
  40. DELETE FROM `spell_proc` WHERE `SpellId`=238299;
  41. INSERT INTO `spell_proc` VALUES (238299, 0, 0, 0, 0, 0, 0, 2, 2, 0, 0, 0, 15, 12000, 0, 'HoTs on Heals Heroic');
  42.  
  43. #Sextant of Unstable Currents didn't have proc chance, didn't trigger.
  44. DELETE FROM `spell_proc` WHERE `SpellId`=38347;
  45. INSERT INTO `spell_proc` VALUES (38347, 0, 0, 0, 0, 0, 0, 0, 2, 2, 0, 0, 0, 45000, 0, 'Crit Proc Spell Damage');
  46. DELETE FROM `spell_proc` WHERE `SpellId`=238347;
  47. INSERT INTO `spell_proc` VALUES (238347, 0, 0, 0, 0, 0, 0, 0, 2, 2, 0, 0, 0, 45000, 0, 'Crit Proc Spell Damage Heroic');
  48.  
  49. #Tsunami Talisman didn't have proc chance, didn't trigger.
  50. DELETE FROM `spell_proc` WHERE `SpellId`=42083;
  51. INSERT INTO `spell_proc` VALUES (42083, 0, 0, 0, 0, 0, 0, 1, 2, 2, 0, 0, 10, 45000, 0, 'Fury of the Crashing Waves');
  52. DELETE FROM `spell_proc` WHERE `SpellId`=242083;
  53. INSERT INTO `spell_proc` VALUES (242083, 0, 0, 0, 0, 0, 0, 1, 2, 2, 0, 0, 10, 45000, 0, 'Fury of the Crashing Waves Heroic');
  54.  
  55. #Fathom-Brooch of the Tidewalker didn't have proc chance, didn't trigger.
  56. DELETE FROM `spell_proc` WHERE `SpellId`=37247;
  57. INSERT INTO `spell_proc` VALUES (37247, 8, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0, 15, 45000, 0, 'Regain Mana');
  58. DELETE FROM `spell_proc` WHERE `SpellId`=237247;
  59. INSERT INTO `spell_proc` VALUES (237247, 8, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0, 15, 45000, 0, 'Regain Mana Heroic');
  60.  
  61. #Serpent-Coil Braid didn't proc on heroic
  62. DELETE FROM `spell_proc` WHERE `SpellId`=37447;
  63. INSERT INTO `spell_proc` VALUES (37447, 0, 3, 0, 256, 0, 16384, 4, 2, 0, 0, 0, 0, 0, 0, 'Improved Mana Gems');
  64. DELETE FROM `spell_proc` WHERE `SpellId`=237447;
  65. INSERT INTO `spell_proc` VALUES (237447, 0, 3, 0, 256, 0, 16384, 4, 2, 0, 0, 0, 0, 0, 0, 'Improved Mana Gems Heroic');
  66.  
  67. #Blackened Naaru Sliver  has no spell proc, causing it to trigger on all hits, normal was missing proc chance
  68. DELETE FROM `spell_proc` WHERE `SpellId`=45355;
  69. INSERT INTO `spell_proc` VALUES (45355, 0, 0, 0, 0, 0, 0, 1, 2, 0, 0, 0, 10, 45000, 0, 'Item - T7 Melee Trinket Base');
  70. DELETE FROM `spell_proc` WHERE `SpellId`=245355;
  71. INSERT INTO `spell_proc` VALUES (245355, 0, 0, 0, 0, 0, 0, 1, 2, 0, 0, 0, 10, 45000, 0, 'Item - T7 Melee Trinket Base Heroic');
  72.  
  73. #Solarian's Sapphire
  74. DELETE FROM `spell_proc` WHERE `SpellId`=37536;
  75. INSERT INTO `spell_proc` VALUES (37536, 0, 4, 65536, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 'Improved Battle Shout');
  76. DELETE FROM `spell_proc` WHERE `SpellId`=237536;
  77. INSERT INTO `spell_proc` VALUES (237536, 0, 4, 65536, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 'Improved Battle Shout Heroic');
  78.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement