Advertisement
IcariumQA

Fix to exchange epic/LREs

Dec 23rd, 2020 (edited)
144
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 15.34 KB | None | 0 0
  1. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84737;
  2. INSERT INTO `custom_nerfed_enchants` VALUES (84737, 'Deviant 12/23');
  3. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84739;
  4. INSERT INTO `custom_nerfed_enchants` VALUES (84739, 'Creative Destruction 12/23');
  5. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84741;
  6. INSERT INTO `custom_nerfed_enchants` VALUES (84741, 'Natural Aberrator 12/23');
  7. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84743;
  8. INSERT INTO `custom_nerfed_enchants` VALUES (84743, 'Icebound Arcanist 12/23');
  9. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84745;
  10. INSERT INTO `custom_nerfed_enchants` VALUES (84745, 'Adumbral Conjurer 12/23');
  11. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84733;
  12. INSERT INTO `custom_nerfed_enchants` VALUES (84733, 'Illusionist 12/23');
  13. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84729;
  14. INSERT INTO `custom_nerfed_enchants` VALUES (84729, 'Druid of the Night 12/23');
  15. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84725;
  16. INSERT INTO `custom_nerfed_enchants` VALUES (84725, 'Caustic 12/23');
  17. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84727;
  18. INSERT INTO `custom_nerfed_enchants` VALUES (84727, 'Black Flames 12/23');
  19. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84713;
  20. INSERT INTO `custom_nerfed_enchants` VALUES (84713, 'Icy Seraph 12/23');
  21. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84715;
  22. INSERT INTO `custom_nerfed_enchants` VALUES (84715, 'Incompatible 12/23');
  23. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84717;
  24. INSERT INTO `custom_nerfed_enchants` VALUES (84717, 'Tundra Walker 12/23');
  25. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84719;
  26. INSERT INTO `custom_nerfed_enchants` VALUES (84719, 'Frostbite 12/23');
  27. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84721;
  28. INSERT INTO `custom_nerfed_enchants` VALUES (84721, 'Icy Magics 12/23');
  29. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84723;
  30. INSERT INTO `custom_nerfed_enchants` VALUES (84723, 'Void-touched 12/23');
  31. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84709;
  32. INSERT INTO `custom_nerfed_enchants` VALUES (84709, 'Fey-born 12/23');
  33. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84711;
  34. INSERT INTO `custom_nerfed_enchants` VALUES (84711, 'Viking 12/23');
  35. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84701;
  36. INSERT INTO `custom_nerfed_enchants` VALUES (84701, 'Sunrider 12/23');
  37. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84703;
  38. INSERT INTO `custom_nerfed_enchants` VALUES (84703, 'Draconic Druid 12/23');
  39. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84705;
  40. INSERT INTO `custom_nerfed_enchants` VALUES (84705, 'Hoarfrost 12/23');
  41. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84691;
  42. INSERT INTO `custom_nerfed_enchants` VALUES (84691, 'Counterproductive 12/23');
  43. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84693;
  44. INSERT INTO `custom_nerfed_enchants` VALUES (84693, 'Thermal Trauma 12/23');
  45. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84695;
  46. INSERT INTO `custom_nerfed_enchants` VALUES (84695, 'Umbral Scion 12/23');
  47. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84687;
  48. INSERT INTO `custom_nerfed_enchants` VALUES (84687, 'Flame Blood 12/23');
  49. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84689;
  50. INSERT INTO `custom_nerfed_enchants` VALUES (84689, 'Hallowed Flames 12/23');
  51. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84679;
  52. INSERT INTO `custom_nerfed_enchants` VALUES (84679, 'Sentinel of the Grove 12/23');
  53. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84681;
  54. INSERT INTO `custom_nerfed_enchants` VALUES (84681, 'Frigid Crusader 12/23');
  55. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84683;
  56. INSERT INTO `custom_nerfed_enchants` VALUES (84683, 'Dusk Knight 12/23');
  57. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84685;
  58. INSERT INTO `custom_nerfed_enchants` VALUES (84685, 'Blasphemy 12/23');
  59. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84675;
  60. INSERT INTO `custom_nerfed_enchants` VALUES (84675, 'Enforcer 12/23');
  61. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84671;
  62. INSERT INTO `custom_nerfed_enchants` VALUES (84671, 'Feral Gnasher 12/23');
  63. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84669;
  64. INSERT INTO `custom_nerfed_enchants` VALUES (84669, 'Frost Reaver 12/23');
  65. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84665;
  66. INSERT INTO `custom_nerfed_enchants` VALUES (84665, 'Fire Bug 12/23');
  67. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84667;
  68. INSERT INTO `custom_nerfed_enchants` VALUES (84667, 'Primalist 12/23');
  69. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84653;
  70. INSERT INTO `custom_nerfed_enchants` VALUES (84653, 'Prepared Ritual 12/23');
  71. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84655;
  72. INSERT INTO `custom_nerfed_enchants` VALUES (84655, 'Calculated Demolition 12/23');
  73. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84657;
  74. INSERT INTO `custom_nerfed_enchants` VALUES (84657, 'Natural Abhors Order 12/23');
  75. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84659;
  76. INSERT INTO `custom_nerfed_enchants` VALUES (84659, 'Icy Conjuror 12/23');
  77. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84661;
  78. INSERT INTO `custom_nerfed_enchants` VALUES (84661, 'Amplify Shadows 12/23');
  79. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84663;
  80. INSERT INTO `custom_nerfed_enchants` VALUES (84663, 'Bible Belter 12/23');
  81. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84651;
  82. INSERT INTO `custom_nerfed_enchants` VALUES (84651, 'Mindful Violence 12/23');
  83. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84643;
  84. INSERT INTO `custom_nerfed_enchants` VALUES (84643, 'In Flames, My Sweet Shadow 12/23');
  85. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84645;
  86. INSERT INTO `custom_nerfed_enchants` VALUES (84645, 'Nocturnal Predator 12/23');
  87. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84647;
  88. INSERT INTO `custom_nerfed_enchants` VALUES (84647, 'Niflheim 12/23');
  89. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84637;
  90. INSERT INTO `custom_nerfed_enchants` VALUES (84637, 'Slow Down for Boom 12/23');
  91. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84639;
  92. INSERT INTO `custom_nerfed_enchants` VALUES (84639, 'Dark Operation 12/23');
  93. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84641;
  94. INSERT INTO `custom_nerfed_enchants` VALUES (84641, 'Return to the Light 12/23');
  95. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84633;
  96. INSERT INTO `custom_nerfed_enchants` VALUES (84633, 'Spring Thraw 12/23');
  97. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84635;
  98. INSERT INTO `custom_nerfed_enchants` VALUES (84635, 'Frigid Darkness 12/23');
  99. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84629;
  100. INSERT INTO `custom_nerfed_enchants` VALUES (84629, 'Frozen Crusade 12/23');
  101. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84627;
  102. INSERT INTO `custom_nerfed_enchants` VALUES (84627, 'Cold Break 12/23');
  103. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84621;
  104. INSERT INTO `custom_nerfed_enchants` VALUES (84621, 'Winter Solstice 12/23');
  105. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84623;
  106. INSERT INTO `custom_nerfed_enchants` VALUES (84623, 'Coax to Darkness 12/23');
  107. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84617;
  108. INSERT INTO `custom_nerfed_enchants` VALUES (84617, 'Druidic Rites 12/23');
  109. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84615;
  110. INSERT INTO `custom_nerfed_enchants` VALUES (84615, 'Growing Rage 12/23');
  111. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84611;
  112. INSERT INTO `custom_nerfed_enchants` VALUES (84611, 'Shadow Propellant 12/23');
  113. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84609;
  114. INSERT INTO `custom_nerfed_enchants` VALUES (84609, 'Ice the Burn 12/23');
  115. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84581;
  116. INSERT INTO `custom_nerfed_enchants` VALUES (84581, 'Kindle for the Fire 12/23');
  117. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84603;
  118. INSERT INTO `custom_nerfed_enchants` VALUES (84603, 'Just Warming Up 12/23');
  119. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84605;
  120. INSERT INTO `custom_nerfed_enchants` VALUES (84605, 'Witch Burning 12/23');
  121. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84597;
  122. INSERT INTO `custom_nerfed_enchants` VALUES (84597, 'Freeze the Faith 12/23');
  123. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84599;
  124. INSERT INTO `custom_nerfed_enchants` VALUES (84599, 'Corrupted Church 12/23');
  125. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84587;
  126. INSERT INTO `custom_nerfed_enchants` VALUES (84587, 'What We Do in the Shadows 12/23');
  127. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84589;
  128. INSERT INTO `custom_nerfed_enchants` VALUES (84589, 'Big Brain Big Muscles 12/23');
  129. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84583;
  130. INSERT INTO `custom_nerfed_enchants` VALUES (84583, 'Naturally Strong 12/23');
  131. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84585;
  132. INSERT INTO `custom_nerfed_enchants` VALUES (84585, 'Prepare for Shatter 12/23');
  133. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84735;
  134. INSERT INTO `custom_nerfed_enchants` VALUES (84735, 'Jack of All Trades 12/23');
  135. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84731;
  136. INSERT INTO `custom_nerfed_enchants` VALUES (84731, 'Permafrost 12/23');
  137. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84707;
  138. INSERT INTO `custom_nerfed_enchants` VALUES (84707, 'Grove Corruptor 12/23');
  139. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84699;
  140. INSERT INTO `custom_nerfed_enchants` VALUES (84699, 'Groveborn 12/23');
  141. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84697;
  142. INSERT INTO `custom_nerfed_enchants` VALUES (84697, 'Empyreal Arcanist 12/23');
  143. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84677;
  144. INSERT INTO `custom_nerfed_enchants` VALUES (84677, 'Dragon Knight 12/23');
  145. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84673;
  146. INSERT INTO `custom_nerfed_enchants` VALUES (84673, 'Spellhammer 12/23');
  147. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84649;
  148. INSERT INTO `custom_nerfed_enchants` VALUES (84649, 'The Dark Magician 12/23');
  149. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84631;
  150. INSERT INTO `custom_nerfed_enchants` VALUES (84631, 'Leftovers 12/23');
  151. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84625;
  152. INSERT INTO `custom_nerfed_enchants` VALUES (84625, 'The Natural Order 12/23');
  153. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84619;
  154. INSERT INTO `custom_nerfed_enchants` VALUES (84619, 'Seeds of Flame 12/23');
  155. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84613;
  156. INSERT INTO `custom_nerfed_enchants` VALUES (84613, 'Fiery Barrage 12/23');
  157. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84607;
  158. INSERT INTO `custom_nerfed_enchants` VALUES (84607, 'Rebirth Through Fire 12/23');
  159. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84595;
  160. INSERT INTO `custom_nerfed_enchants` VALUES (84595, 'Wiccan Ways 12/23');
  161. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84601;
  162. INSERT INTO `custom_nerfed_enchants` VALUES (84601, 'Holy Magics 12/23');
  163. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84591;
  164. INSERT INTO `custom_nerfed_enchants` VALUES (84591, 'Deadly Indoctrination 12/23');
  165. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84593;
  166. INSERT INTO `custom_nerfed_enchants` VALUES (84593, 'Convert or Burn 12/23');
  167. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=81250;
  168. INSERT INTO `custom_nerfed_enchants` VALUES (81250, 'Mass Slow 12/23');
  169. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=81310;
  170. INSERT INTO `custom_nerfed_enchants` VALUES (81310, 'Charged Up 12/23');
  171. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84449;
  172. INSERT INTO `custom_nerfed_enchants` VALUES (84449, 'Blades of Blood 12/23');
  173. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84447;
  174. INSERT INTO `custom_nerfed_enchants` VALUES (84447, 'Judge, Jury, Executioner 12/23');
  175. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84451;
  176. INSERT INTO `custom_nerfed_enchants` VALUES (84451, 'Tooth and Nail 12/23');
  177. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84535;
  178. INSERT INTO `custom_nerfed_enchants` VALUES (84535, 'Lunar Spirits 12/23');
  179. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84453;
  180. INSERT INTO `custom_nerfed_enchants` VALUES (84453, 'Flash of Adrenaline 12/23');
  181. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84455;
  182. INSERT INTO `custom_nerfed_enchants` VALUES (84455, 'Death or Glory 12/23');
  183. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84515;
  184. INSERT INTO `custom_nerfed_enchants` VALUES (84515, 'Unbounded Harbinger of Flame 12/23');
  185. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84466;
  186. INSERT INTO `custom_nerfed_enchants` VALUES (84466, 'Throw Weapon 12/23');
  187. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84472;
  188. INSERT INTO `custom_nerfed_enchants` VALUES (84472, 'Blood Rain 12/23');
  189. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84508;
  190. INSERT INTO `custom_nerfed_enchants` VALUES (84508, 'Unbounded Righteous Zealot 12/23');
  191. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84510;
  192. INSERT INTO `custom_nerfed_enchants` VALUES (84510, 'Unbounded Spell Slinger 12/23');
  193. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84512;
  194. INSERT INTO `custom_nerfed_enchants` VALUES (84512, 'Unbounded Frost Lich 12/23');
  195. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84527;
  196. INSERT INTO `custom_nerfed_enchants` VALUES (84527, 'Zany Zealot 12/23');
  197. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84459;
  198. INSERT INTO `custom_nerfed_enchants` VALUES (84459, 'Battle Fervor 12/23');
  199. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84464;
  200. INSERT INTO `custom_nerfed_enchants` VALUES (84464, 'Mortal Wounds 12/23');
  201. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84506;
  202. INSERT INTO `custom_nerfed_enchants` VALUES (84506, 'Unbounded Deathbringer 12/23');
  203. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=101277;
  204. INSERT INTO `custom_nerfed_enchants` VALUES (101277, 'Ice Warden 12/23');
  205. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=101278;
  206. INSERT INTO `custom_nerfed_enchants` VALUES (101278, 'Arcane Fulmination 12/23');
  207. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=101279;
  208. INSERT INTO `custom_nerfed_enchants` VALUES (101279, 'Natural Disaster 12/23');
  209. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84524;
  210. INSERT INTO `custom_nerfed_enchants` VALUES (84524, 'Counterpoise 12/23');
  211. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84529;
  212. INSERT INTO `custom_nerfed_enchants` VALUES (84529, 'Crazy Cultist 12/23');
  213. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84531;
  214. INSERT INTO `custom_nerfed_enchants` VALUES (84531, 'Deranged Druid 12/23');
  215. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84533;
  216. INSERT INTO `custom_nerfed_enchants` VALUES (84533, 'Eccentric Elementalist 12/23');
  217. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84445;
  218. INSERT INTO `custom_nerfed_enchants` VALUES (84445, 'Spartan Kick 12/23');
  219. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84388;
  220. INSERT INTO `custom_nerfed_enchants` VALUES (84388, 'Holy Retribution 12/23');
  221. DELETE FROM `custom_nerfed_enchants` WHERE `enchantID`=84579;
  222. INSERT INTO `custom_nerfed_enchants` VALUES (84579, 'Faithful Flex 12/23');
  223.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement