Advertisement
IcariumQA

spell_talentid old before renames

Apr 1st, 2022
1,048
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 3.94 KB | None | 0 0
  1. DELETE FROM `spell_talentid` WHERE `SpellID`=2782 AND `OldTalentID`='2782' AND `TalentID`='2782' AND `spellname`='Remove Curse';
  2. INSERT INTO `spell_talentid` (`SpellID`, `OldTalentID`, `TalentID`, `spellname`) VALUES (2782, '2782', '2782', 'Remove Curse');
  3. DELETE FROM `spell_talentid` WHERE `SpellID`=11190 AND `OldTalentID`='64t1' AND `TalentID` IS NULL AND `spellname`='Improved Cone of Cold';
  4. INSERT INTO `spell_talentid` (`SpellID`, `OldTalentID`, `TalentID`, `spellname`) VALUES (11190, '64t1', NULL, 'Improved Cone of Cold');
  5. DELETE FROM `spell_talentid` WHERE `SpellID`=11222 AND `OldTalentID`='76t1' AND `TalentID` IS NULL AND `spellname`='Arcane Focus';
  6. INSERT INTO `spell_talentid` (`SpellID`, `OldTalentID`, `TalentID`, `spellname`) VALUES (11222, '76t1', NULL, 'Arcane Focus');
  7. DELETE FROM `spell_talentid` WHERE `SpellID`=12299 AND `OldTalentID`='140t1' AND `TalentID` IS NULL AND `spellname`='Toughness';
  8. INSERT INTO `spell_talentid` (`SpellID`, `OldTalentID`, `TalentID`, `spellname`) VALUES (12299, '140t1', NULL, 'Toughness');
  9. DELETE FROM `spell_talentid` WHERE `SpellID`=13712 AND `OldTalentID`='186t1' AND `TalentID` IS NULL AND `spellname`='Lightning Reflexes';
  10. INSERT INTO `spell_talentid` (`SpellID`, `OldTalentID`, `TalentID`, `spellname`) VALUES (13712, '186t1', NULL, 'Lightning Reflexes');
  11. DELETE FROM `spell_talentid` WHERE `SpellID`=13713 AND `OldTalentID`='187t1' AND `TalentID` IS NULL AND `spellname`='Deflection';
  12. INSERT INTO `spell_talentid` (`SpellID`, `OldTalentID`, `TalentID`, `spellname`) VALUES (13713, '187t1', NULL, 'Deflection');
  13. DELETE FROM `spell_talentid` WHERE `SpellID`=14079 AND `OldTalentID`='263t1' AND `TalentID` IS NULL AND `spellname`='Improved Ambush';
  14. INSERT INTO `spell_talentid` (`SpellID`, `OldTalentID`, `TalentID`, `spellname`) VALUES (14079, '263t1', NULL, 'Improved Ambush');
  15. DELETE FROM `spell_talentid` WHERE `SpellID`=14523 AND `OldTalentID`='352t1' AND `TalentID` IS NULL AND `spellname`='Silent Resolve';
  16. INSERT INTO `spell_talentid` (`SpellID`, `OldTalentID`, `TalentID`, `spellname`) VALUES (14523, '352t1', NULL, 'Silent Resolve');
  17. DELETE FROM `spell_talentid` WHERE `SpellID`=16254 AND `OldTalentID`='601t1' AND `TalentID` IS NULL AND `spellname`='Anticipation';
  18. INSERT INTO `spell_talentid` (`SpellID`, `OldTalentID`, `TalentID`, `spellname`) VALUES (16254, '601t1', NULL, 'Anticipation');
  19. DELETE FROM `spell_talentid` WHERE `SpellID`=18174 AND `OldTalentID`='1005t1' AND `TalentID` IS NULL AND `spellname`='Suppression';
  20. INSERT INTO `spell_talentid` (`SpellID`, `OldTalentID`, `TalentID`, `spellname`) VALUES (18174, '1005t1', NULL, 'Suppression');
  21. DELETE FROM `spell_talentid` WHERE `SpellID`=19295 AND `OldTalentID`='1311t1' AND `TalentID` IS NULL AND `spellname`='Deflection';
  22. INSERT INTO `spell_talentid` (`SpellID`, `OldTalentID`, `TalentID`, `spellname`) VALUES (19295, '1311t1', NULL, 'Deflection');
  23. DELETE FROM `spell_talentid` WHERE `SpellID`=20060 AND `OldTalentID`='1403t1' AND `TalentID` IS NULL AND `spellname`='Deflection';
  24. INSERT INTO `spell_talentid` (`SpellID`, `OldTalentID`, `TalentID`, `spellname`) VALUES (20060, '1403t1', NULL, 'Deflection');
  25. DELETE FROM `spell_talentid` WHERE `SpellID`=20196 AND `OldTalentID`='1429t1' AND `TalentID` IS NULL AND `spellname`='One-Handed Weapon Specialization';
  26. INSERT INTO `spell_talentid` (`SpellID`, `OldTalentID`, `TalentID`, `spellname`) VALUES (20196, '1429t1', NULL, 'One-Handed Weapon Specialization');
  27. DELETE FROM `spell_talentid` WHERE `SpellID`=29192 AND `OldTalentID`='1647t1' AND `TalentID` IS NULL AND `spellname`='Improved Windfury Totem';
  28. INSERT INTO `spell_talentid` (`SpellID`, `OldTalentID`, `TalentID`, `spellname`) VALUES (29192, '1647t1', NULL, 'Improved Windfury Totem');
  29. DELETE FROM `spell_talentid` WHERE `SpellID`=33886 AND `OldTalentID`='1789t1' AND `TalentID` IS NULL AND `spellname`='Empowered Rejuvenation';
  30. INSERT INTO `spell_talentid` (`SpellID`, `OldTalentID`, `TalentID`, `spellname`) VALUES (33886, '1789t1', NULL, 'Empowered Rejuvenation');
  31.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement