Guest User

Untitled

a guest
Mar 13th, 2018
102
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 1.12 KB | None | 0 0
  1. -- BoS DMG Taken Reduction
  2. DELETE FROM `spell_linked_spell` WHERE `spell_trigger` = 20911 AND `spell_effect` = 68066;
  3. INSERT INTO `spell_linked_spell` (`spell_trigger`,`spell_effect`,`type`,`comment`) VALUES
  4. (20911,68066,2, 'Blessing of Sanctuary - Damage Reduction');
  5.  
  6. -- GBoS DMG Taken Reduction
  7. DELETE FROM `spell_linked_spell` WHERE `spell_trigger` = 25899 AND `spell_effect` = 68066;
  8. INSERT INTO `spell_linked_spell` (`spell_trigger`,`spell_effect`,`type`,`comment`) VALUES
  9. (25899,68066,2, 'Greater Blessing of Sanctuary - Damage Reduction');
  10.  
  11. -- Renewed Hope DMG Taken Reduction
  12. DELETE FROM `spell_linked_spell` WHERE `spell_trigger` = 63944 AND `spell_effect` = 68066;
  13. INSERT INTO `spell_linked_spell` (`spell_trigger`,`spell_effect`,`type`,`comment`) VALUES
  14. (63944,68066,2, 'Renewed Hope - Damage Reduction');
  15.  
  16. SET @id = 1115;
  17.  
  18. DELETE FROM `spell_group` WHERE `id` = 1115;
  19. INSERT INTO `spell_group` (`id`, `spell_id`) VALUES
  20. (@id,20911),
  21. (@id,25899),
  22. (@id,63944);
  23.  
  24. DELETE FROM `spell_group_stack_rules` WHERE `group_id` = 1114;
  25. INSERT INTO `spell_group_stack_rules` (`group_id`, `stack_rule`) VALUES
  26. (@id,3);
Add Comment
Please, Sign In to add comment