Advertisement
IcariumQA

Restorative Shadow

Oct 30th, 2020 (edited)
103
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 8.77 KB | None | 0 0
  1. DELETE FROM `db_spellitemenchantment_12340` WHERE `ID`=980052;
  2. INSERT INTO `db_spellitemenchantment_12340` VALUES (980052, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 980052, 0, 0, 'Equip: Restorative Shadows - Your Shadow Bolt and Mind Blast now generate 10 energy on hit.', 'Equip: Restorative Shadows - Your Shadow Bolt and Mind Blast now generate 10 energy on hit.', 'Equip: Restorative Shadows - Your Shadow Bolt and Mind Blast now generate 10 energy on hit.', 'Equip: Restorative Shadows - Your Shadow Bolt and Mind Blast now generate 10 energy on hit.', 'Equip: Restorative Shadows - Your Shadow Bolt and Mind Blast now generate 10 energy on hit.', 'Equip: Restorative Shadows - Your Shadow Bolt and Mind Blast now generate 10 energy on hit.', 'Equip: Restorative Shadows - Your Shadow Bolt and Mind Blast now generate 10 energy on hit.', 'Equip: Restorative Shadows - Your Shadow Bolt and Mind Blast now generate 10 energy on hit.', 'Equip: Restorative Shadows - Your Shadow Bolt and Mind Blast now generate 10 energy on hit.', 'Equip: Restorative Shadows - Your Shadow Bolt and Mind Blast now generate 10 energy on hit.', 'Equip: Restorative Shadows - Your Shadow Bolt and Mind Blast now generate 10 energy on hit.', 'Equip: Restorative Shadows - Your Shadow Bolt and Mind Blast now generate 10 energy on hit.', 'Equip: Restorative Shadows - Your Shadow Bolt and Mind Blast now generate 10 energy on hit.', 'Equip: Restorative Shadows - Your Shadow Bolt and Mind Blast now generate 10 energy on hit.', 'Equip: Restorative Shadows - Your Shadow Bolt and Mind Blast now generate 10 energy on hit.', '', 16712190, 0, 0, 0, 0, 0, 0, 0);
  3.  
  4. DELETE FROM `item_enchantment_random_tiers` WHERE `enchantID`=980052;
  5. INSERT INTO `item_enchantment_random_tiers` VALUES (980052, 1, 'ANY', NULL, 980052, 'Restorative Shadows', 0, 100);
  6.  
  7. DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=980052 AND `spell_effect`=980054 AND `type`=2;
  8. INSERT INTO `spell_linked_spell` VALUES (980052, 980054, 2, 'Restorative Shadows - Warlock');
  9. DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=980052 AND `spell_effect`=980055 AND `type`=2;
  10. INSERT INTO `spell_linked_spell` VALUES (980052, 980055, 2, 'Restorative Shadows - Priest');
  11.  
  12. DELETE FROM `spell` WHERE `ID`=980052;
  13. INSERT INTO `spell` VALUES (980052, 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, 0, 0, 1, 1, 0, 0, 0, 0, 9, -1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 107, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3141, 0, 0, 'Restorative Shadows', 'Focused Attacks', 'Focused Attacks', 'Focused Attacks', 'Focused Attacks', 'Focused Attacks', 'Ataques centrados', 'Ataques centrados', 'Целенаправленные атаки', 0, 0, 0, 0, 0, 0, 0, 16712190, 'Rank 3', 'Rank 1', 'Rank 1', 'Rank 1', 'Rank 1', 'Rank 1', 'Rank 1', 'Rank 1', 'Уровень 1', 0, 0, 0, 0, 0, 0, 0, 16712190, 'Your Shadow Bolt and Mind Blast now generate 10 energy on hit.', 'Your melee critical strikes have a $h% chance to give you $s1 energy.', 'Your melee critical strikes have a $h% chance to give you $s1 energy.', 'Your melee critical strikes have a $h% chance to give you $s1 energy.', 'Your melee critical strikes have a $h% chance to give you $s1 energy.', 'Your melee critical strikes have a $h% chance to give you $s1 energy.', 'Your melee critical strikes have a $h% chance to give you $s1 energy.', 'Your melee critical strikes have a $h% chance to give you $s1 energy.', 'При нанесении критических ударов в ближнем бою вы можете восполнить $s1 энергии с шансом $h%. ', 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, 0, 0, 0, 0, 0, 0, 0, 0, 0);
  14. DELETE FROM `spell` WHERE `ID`=980053;
  15. INSERT INTO `spell` VALUES (980053, 0, 0, 0, 0, 0, 4, 67108864, 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, 30, 0, 0, 1, 1, 0, 0, 0, 0, -1, -1, 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, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3141, 0, 0, 'Restorative Shadows', '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', 0, 0, 0, 0, 0, 0, 0, 16712190, 'Your Shadow Bolt and Mind Blast now generate 10 energy on hit.', '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, 8, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0);
  16. DELETE FROM `spell` WHERE `ID`=980054;
  17. INSERT INTO `spell` VALUES (980054, 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 6, 0, 0, 1, 1, 0, 0, 0, 0, -1, -1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 42, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 980053, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3141, 0, 0, 'Restorative Shadows', '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', 0, 0, 0, 0, 0, 0, 0, 16712190, 'Your Shadow Bolt now generates 10 energy on hit.', '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, 5, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0);
  18. DELETE FROM `spell` WHERE `ID`=980055;
  19. INSERT INTO `spell` VALUES (980055, 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 6, 0, 0, 1, 1, 0, 0, 0, 0, -1, -1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 42, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 980053, 0, 0, 0, 0, 0, 8192, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3141, 0, 0, 'Restorative Shadows', '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', 0, 0, 0, 0, 0, 0, 0, 16712190, 'Your Mind Blast now generates 10 energy on hit.', '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, 6, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0);
  20.  
  21. DELETE FROM `spell_proc` WHERE `SpellId`=980054;
  22. INSERT INTO `spell_proc` VALUES (980054, 0, 5, 1, 0, 0, 65536, 1, 2, 0, 0, 0, 100, 1000, 0, 'Restorative Shadows - Warlock');
  23. DELETE FROM `spell_proc` WHERE `SpellId`=980055;
  24. INSERT INTO `spell_proc` VALUES (980055, 0, 6, 8192, 0, 0, 65536, 1, 2, 0, 0, 0, 100, 1000, 0, 'Restorative Shadows - Priest');
  25.  
  26. DELETE FROM `spell_affect` WHERE `entry`=980052 AND `effectId`=0 AND `spellId`=980053;
  27. INSERT INTO `spell_affect` VALUES (980052, 0, 980053, 'Restorative Shadows (EFF_0) -> Restorative Shadows');
  28.  
  29.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement