API tools faq
paste
Advertisement
nimzo_asc

temple guardian w IF

nimzo_asc
Dec 3rd, 2020
54
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 13.00 KB | None | 0 0
raw download clone embed print report
  1. DELETE FROM `db_spellitemenchantment_12340` WHERE `ID`=977751;
  2. INSERT INTO `db_spellitemenchantment_12340` VALUES (977751, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 977751, 0, 0, 'Equip: Temple Guardian - Using Intervene a friendly target with Weakened Soul will remove the debuff from them and reset the cooldown of your Intervene. This effect has a 15 second cooldown. In addition, Inner Fire now increases your block chance by 5%.', 'Equip: Temple Guardian - Using Intervene a friendly target with Weakened Soul will remove the debuff from them and reset the cooldown of your Intervene. This effect has a 15 second cooldown. In addition, Inner Fire now increases your block chance by 5%.', 'Equip: Temple Guardian - Using Intervene a friendly target with Weakened Soul will remove the debuff from them and reset the cooldown of your Intervene. This effect has a 15 second cooldown. In addition, Inner Fire now increases your block chance by 5%.', 'Equip: Temple Guardian - Using Intervene a friendly target with Weakened Soul will remove the debuff from them and reset the cooldown of your Intervene. This effect has a 15 second cooldown. In addition, Inner Fire now increases your block chance by 5%.', 'Equip: Temple Guardian - Using Intervene a friendly target with Weakened Soul will remove the debuff from them and reset the cooldown of your Intervene. This effect has a 15 second cooldown. In addition, Inner Fire now increases your block chance by 5%.', 'Equip: Temple Guardian - Using Intervene a friendly target with Weakened Soul will remove the debuff from them and reset the cooldown of your Intervene. This effect has a 15 second cooldown. In addition, Inner Fire now increases your block chance by 5%.', 'Equip: Temple Guardian - Using Intervene a friendly target with Weakened Soul will remove the debuff from them and reset the cooldown of your Intervene. This effect has a 15 second cooldown. In addition, Inner Fire now increases your block chance by 5%.', 'Equip: Temple Guardian - Using Intervene a friendly target with Weakened Soul will remove the debuff from them and reset the cooldown of your Intervene. This effect has a 15 second cooldown. In addition, Inner Fire now increases your block chance by 5%.', 'Equip: Temple Guardian - Using Intervene a friendly target with Weakened Soul will remove the debuff from them and reset the cooldown of your Intervene. This effect has a 15 second cooldown. In addition, Inner Fire now increases your block chance by 5%.', 'Equip: Temple Guardian - Using Intervene a friendly target with Weakened Soul will remove the debuff from them and reset the cooldown of your Intervene. This effect has a 15 second cooldown. In addition, Inner Fire now increases your block chance by 5%.', 'Equip: Temple Guardian - Using Intervene a friendly target with Weakened Soul will remove the debuff from them and reset the cooldown of your Intervene. This effect has a 15 second cooldown. In addition, Inner Fire now increases your block chance by 5%.', 'Equip: Temple Guardian - Using Intervene a friendly target with Weakened Soul will remove the debuff from them and reset the cooldown of your Intervene. This effect has a 15 second cooldown. In addition, Inner Fire now increases your block chance by 5%.', 'Equip: Temple Guardian - Using Intervene a friendly target with Weakened Soul will remove the debuff from them and reset the cooldown of your Intervene. This effect has a 15 second cooldown. In addition, Inner Fire now increases your block chance by 5%.', 'Equip: Temple Guardian - Using Intervene a friendly target with Weakened Soul will remove the debuff from them and reset the cooldown of your Intervene. This effect has a 15 second cooldown. In addition, Inner Fire now increases your block chance by 5%.', 'Equip: Temple Guardian - Using Intervene a friendly target with Weakened Soul will remove the debuff from them and reset the cooldown of your Intervene. This effect has a 15 second cooldown. In addition, Inner Fire now increases your block chance by 5%.', '', 16712190, 0, 0, 0, 0, 0, 0, 0);
  3. DELETE FROM `item_enchantment_random_tiers` WHERE `enchantID`=977751;
  4. INSERT INTO `item_enchantment_random_tiers` VALUES (977751, 1, 'ARMOR', NULL, 977751, 'Temple Guardian', 0, 100);
  5. DELETE FROM `spell` WHERE `ID`=977751;
  6. INSERT INTO `spell` VALUES (977751, 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, 1, 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, 977752, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 24844, 0, 0, 'Temple Guardian', 'Unknown Spell', 'Unknown Spell', 'Unknown Spell', 'Unknown Spell', 'Unknown Spell', 'Unknown Spell', 'Unknown Spell', 'Unknown Spell', 0, 0, 0, 0, 0, 0, 0, 16712190, 'Rank 4', 'Rank 4', 'Rank 4', 'Rank 4', 'Rank 4', 'Rank 4', 'Rank 4', 'Rank 4', 'Rank 4', 0, 0, 0, 0, 0, 0, 0, 16712190, 'Using Intervene a friendly target with Weakened Soul will remove the debuff from them and reset the cooldown of your Intervene. This effect has a 15 second cooldown. In addition, Inner Fire now increases your block chance by 5%.', '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, 3, 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);
  7. DELETE FROM `spell` WHERE `ID`=977756;
  8. INSERT INTO `spell` VALUES (977756, 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, 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, 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, 977757, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18965, 0, 0, 'Temple Guardian inner fire part', 'Unknown Spell', 'Unknown Spell', 'Unknown Spell', 'Unknown Spell', 'Unknown Spell', 'Unknown Spell', 'Unknown Spell', 'Unknown Spell', 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, '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.', '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, 3, 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);
  9. DELETE FROM `spell` WHERE `ID`=977757;
  10. INSERT INTO `spell` VALUES (977757, 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, 1, 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, 4, -1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 51, 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18965, 0, 0, 'Temple Guardian Inner Fire', 'Unknown Spell', 'Unknown Spell', 'Unknown Spell', 'Unknown Spell', 'Unknown Spell', 'Unknown Spell', 'Unknown Spell', 'Unknown Spell', 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, 'Increases your block chance by 5%.', '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, 3, 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);
  11.  
  12. DELETE FROM `spell` WHERE `ID`=977752;
  13. INSERT INTO `spell` VALUES (977752, 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, 5, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 165, 164, 0, 1, 1, 0, 0, 0, 0, -40001, -1, 0, 0, 0, 0, 1, 21, 0, 0, 0, 0, 0, 0, 0, 107, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3411, 0, 0, 0, 0, 0, 0, 6788, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 24844, 0, 0, 'Temple Guardian', 'Unknown Spell', 'Unknown Spell', 'Unknown Spell', 'Unknown Spell', 'Unknown Spell', 'Unknown Spell', 'Unknown Spell', 'Unknown Spell', 0, 0, 0, 0, 0, 0, 0, 16712190, 'Rank 4', 'Rank 4', 'Rank 4', 'Rank 4', 'Rank 4', 'Rank 4', 'Rank 4', 'Rank 4', 'Rank 4', 0, 0, 0, 0, 0, 0, 0, 16712190, '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.', '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, 3, 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);
  14. DELETE FROM `spell_proc` WHERE `SpellId`=977756;
  15. INSERT INTO `spell_proc` VALUES (977756, 0, 6, 2, 0, 0, 349524, 0, 1, 0, 0, 0, 0, 0, 0, '');
  16. DELETE FROM `spell_proc` WHERE `SpellId`=977751;
  17. INSERT INTO `spell_proc` VALUES (977751, 0, 4, 0, 65536, 0, 349524, 0, 1, 0, 0, 0, 0, 15000, 0, '');
  18. DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=24 AND `SourceGroup`=0 AND `SourceEntry`=977751 AND `SourceId`=0 AND `ElseGroup`=0 AND `ConditionTypeOrReference`=1 AND `ConditionTarget`=1 AND `ConditionValue1`=6788 AND `ConditionValue2`=0 AND `ConditionValue3`=0 AND `NegativeCondition`=0 AND `ErrorType`=0 AND `ErrorTextId`=0 AND `ScriptName`='';
  19. INSERT INTO `conditions` VALUES (24, 0, 977751, 0, 0, 1, 1, 6788, 0, 0, 0, 0, 0, '', 'Temple Guardian req Weakened Soul');
  20. DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=977751 AND `spell_effect`=977756 AND `type`=2;
  21. INSERT INTO `spell_linked_spell` VALUES (977751, 977756, 2, 'Temple Guardian Inner Fire SLS');
  22. DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=-1006 AND `spell_effect`=-977757 AND `type`=0;
  23. INSERT INTO `spell_linked_spell` VALUES (-1006, -977757, 0, 'Temple Guardian Inner Fire removal');
  24. DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=-7128 AND `spell_effect`=-977757 AND `type`=0;
  25. INSERT INTO `spell_linked_spell` VALUES (-7128, -977757, 0, 'Temple Guardian Inner Fire removal');
  26. DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=-10952 AND `spell_effect`=-977757 AND `type`=0;
  27. INSERT INTO `spell_linked_spell` VALUES (-10952, -977757, 0, 'Temple Guardian Inner Fire removal');
  28. DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=-10951 AND `spell_effect`=-977757 AND `type`=0;
  29. INSERT INTO `spell_linked_spell` VALUES (-10951, -977757, 0, 'Temple Guardian Inner Fire removal');
  30. DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=-48040 AND `spell_effect`=-977757 AND `type`=0;
  31. INSERT INTO `spell_linked_spell` VALUES (-48040, -977757, 0, 'Temple Guardian Inner Fire removal');
  32. DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=-602 AND `spell_effect`=-977757 AND `type`=0;
  33. INSERT INTO `spell_linked_spell` VALUES (-602, -977757, 0, 'Temple Guardian Inner Fire removal');
  34. DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=-25431 AND `spell_effect`=-977757 AND `type`=0;
  35. INSERT INTO `spell_linked_spell` VALUES (-25431, -977757, 0, 'Temple Guardian Inner Fire removal');
  36. DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=-588 AND `spell_effect`=-977757 AND `type`=0;
  37. INSERT INTO `spell_linked_spell` VALUES (-588, -977757, 0, 'Temple Guardian Inner Fire removal');
  38. DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=-48168 AND `spell_effect`=-977757 AND `type`=0;
  39. INSERT INTO `spell_linked_spell` VALUES (-48168, -977757, 0, 'Temple Guardian Inner Fire removal');
  40.  
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!