Advertisement
IcariumQA

Remove Active DR uncommon REs

Dec 12th, 2021
1,241
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 4.46 KB | None | 0 0
  1. DELETE FROM dbc_spell_item_enchantment WHERE ID = 87461;
  2. DELETE FROM item_enchantment_random_tiers WHERE enchantID = 87461;
  3. UPDATE spell SET SpellName0 = CONCAT(SpellName0, ' (DEPRECATED)') WHERE ID = 87461 AND SpellName0 NOT LIKE '% (DEPRECATED)';
  4.  DELETE FROM dbc_spell_item_enchantment WHERE ID = 87464;
  5. DELETE FROM item_enchantment_random_tiers WHERE enchantID = 87464;
  6. UPDATE spell SET SpellName0 = CONCAT(SpellName0, ' (DEPRECATED)') WHERE ID = 87464 AND SpellName0 NOT LIKE '% (DEPRECATED)';
  7.  DELETE FROM dbc_spell_item_enchantment WHERE ID = 87468;
  8. DELETE FROM item_enchantment_random_tiers WHERE enchantID = 87468;
  9. UPDATE spell SET SpellName0 = CONCAT(SpellName0, ' (DEPRECATED)') WHERE ID = 87468 AND SpellName0 NOT LIKE '% (DEPRECATED)';
  10.  DELETE FROM dbc_spell_item_enchantment WHERE ID = 87472;
  11. DELETE FROM item_enchantment_random_tiers WHERE enchantID = 87472;
  12. UPDATE spell SET SpellName0 = CONCAT(SpellName0, ' (DEPRECATED)') WHERE ID = 87472 AND SpellName0 NOT LIKE '% (DEPRECATED)';
  13.  DELETE FROM dbc_spell_item_enchantment WHERE ID = 87479;
  14. DELETE FROM item_enchantment_random_tiers WHERE enchantID = 87479;
  15. UPDATE spell SET SpellName0 = CONCAT(SpellName0, ' (DEPRECATED)') WHERE ID = 87479 AND SpellName0 NOT LIKE '% (DEPRECATED)';
  16.  DELETE FROM dbc_spell_item_enchantment WHERE ID = 90070;
  17. DELETE FROM item_enchantment_random_tiers WHERE enchantID = 90070;
  18. UPDATE spell SET SpellName0 = CONCAT(SpellName0, ' (DEPRECATED)') WHERE ID = 90070 AND SpellName0 NOT LIKE '% (DEPRECATED)';
  19.  DELETE FROM dbc_spell_item_enchantment WHERE ID = 95432;
  20. DELETE FROM item_enchantment_random_tiers WHERE enchantID = 95432;
  21. UPDATE spell SET SpellName0 = CONCAT(SpellName0, ' (DEPRECATED)') WHERE ID = 95432 AND SpellName0 NOT LIKE '% (DEPRECATED)';
  22.  DELETE FROM dbc_spell_item_enchantment WHERE ID = 95893;
  23. DELETE FROM item_enchantment_random_tiers WHERE enchantID = 95893;
  24. UPDATE spell SET SpellName0 = CONCAT(SpellName0, ' (DEPRECATED)') WHERE ID = 95893 AND SpellName0 NOT LIKE '% (DEPRECATED)';
  25.  DELETE FROM dbc_spell_item_enchantment WHERE ID = 95900;
  26. DELETE FROM item_enchantment_random_tiers WHERE enchantID = 95900;
  27. UPDATE spell SET SpellName0 = CONCAT(SpellName0, ' (DEPRECATED)') WHERE ID = 95900 AND SpellName0 NOT LIKE '% (DEPRECATED)';
  28.  DELETE FROM dbc_spell_item_enchantment WHERE ID = 95902;
  29. DELETE FROM item_enchantment_random_tiers WHERE enchantID = 95902;
  30. UPDATE spell SET SpellName0 = CONCAT(SpellName0, ' (DEPRECATED)') WHERE ID = 95902 AND SpellName0 NOT LIKE '% (DEPRECATED)';
  31.  DELETE FROM dbc_spell_item_enchantment WHERE ID = 95904;
  32. DELETE FROM item_enchantment_random_tiers WHERE enchantID = 95904;
  33. UPDATE spell SET SpellName0 = CONCAT(SpellName0, ' (DEPRECATED)') WHERE ID = 95904 AND SpellName0 NOT LIKE '% (DEPRECATED)';
  34.  DELETE FROM dbc_spell_item_enchantment WHERE ID = 95910;
  35. DELETE FROM item_enchantment_random_tiers WHERE enchantID = 95910;
  36. UPDATE spell SET SpellName0 = CONCAT(SpellName0, ' (DEPRECATED)') WHERE ID = 95910 AND SpellName0 NOT LIKE '% (DEPRECATED)';
  37.  DELETE FROM dbc_spell_item_enchantment WHERE ID = 95911;
  38. DELETE FROM item_enchantment_random_tiers WHERE enchantID = 95911;
  39. UPDATE spell SET SpellName0 = CONCAT(SpellName0, ' (DEPRECATED)') WHERE ID = 95911 AND SpellName0 NOT LIKE '% (DEPRECATED)';
  40.  DELETE FROM dbc_spell_item_enchantment WHERE ID = 95914;
  41. DELETE FROM item_enchantment_random_tiers WHERE enchantID = 95914;
  42. UPDATE spell SET SpellName0 = CONCAT(SpellName0, ' (DEPRECATED)') WHERE ID = 95914 AND SpellName0 NOT LIKE '% (DEPRECATED)';
  43.  DELETE FROM dbc_spell_item_enchantment WHERE ID = 100531;
  44. DELETE FROM item_enchantment_random_tiers WHERE enchantID = 100531;
  45. UPDATE spell SET SpellName0 = CONCAT(SpellName0, ' (DEPRECATED)') WHERE ID = 100531 AND SpellName0 NOT LIKE '% (DEPRECATED)';
  46.  DELETE FROM dbc_spell_item_enchantment WHERE ID = 100915;
  47. DELETE FROM item_enchantment_random_tiers WHERE enchantID = 100915;
  48. UPDATE spell SET SpellName0 = CONCAT(SpellName0, ' (DEPRECATED)') WHERE ID = 100915 AND SpellName0 NOT LIKE '% (DEPRECATED)';
  49.  DELETE FROM dbc_spell_item_enchantment WHERE ID = 975819;
  50. DELETE FROM item_enchantment_random_tiers WHERE enchantID = 975819;
  51. UPDATE spell SET SpellName0 = CONCAT(SpellName0, ' (DEPRECATED)') WHERE ID = 975819 AND SpellName0 NOT LIKE '% (DEPRECATED)';
  52.  DELETE FROM dbc_spell_item_enchantment WHERE ID = 975911;
  53. DELETE FROM item_enchantment_random_tiers WHERE enchantID = 975911;
  54. UPDATE spell SET SpellName0 = CONCAT(SpellName0, ' (DEPRECATED)') WHERE ID = 975911 AND SpellName0 NOT LIKE '% (DEPRECATED)';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement