9
3

tinkered-items_july20_2022.sql 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206
  1. ALTER TABLE `items` ADD COLUMN `tinkered` TINYINT(1) NOT NULL DEFAULT '0' AFTER `effect_type`;
  2. UPDATE items SET tinkered=1 WHERE NAME='%miscalibrated%';
  3. UPDATE items SET tinkered=1 WHERE NAME LIKE '%miscalibrated%';
  4. UPDATE items SET tinkered=1 WHERE NAME LIKE '%automated%';
  5. UPDATE items SET tinkered=1 WHERE NAME LIKE '%Calibrated%';
  6. UPDATE items SET tinkered=1 WHERE NAME LIKE '%Overclocked%';
  7. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=9028;
  8. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=45002;
  9. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=46503;
  10. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=46502;
  11. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=46500;
  12. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=46433;
  13. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=46499;
  14. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=46515;
  15. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=46514;
  16. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=46513;
  17. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=46512;
  18. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=46511;
  19. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=46510;
  20. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=46508;
  21. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=46507;
  22. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=46506;
  23. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=46504;
  24. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=46505;
  25. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=46516;
  26. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=46654;
  27. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=155621;
  28. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=155631;
  29. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=155635;
  30. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=155643;
  31. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=155652;
  32. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=181705;
  33. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10045002;
  34. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10046499;
  35. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10046500;
  36. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10046502;
  37. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10046503;
  38. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10046504;
  39. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10046505;
  40. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10046506;
  41. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10046507;
  42. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10046508;
  43. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10046510;
  44. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10046511;
  45. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10046512;
  46. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10046513;
  47. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10046514;
  48. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10046515;
  49. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10046516;
  50. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10046654;
  51. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10155621;
  52. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10155631;
  53. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10155635;
  54. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10155643;
  55. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10155652;
  56. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=9028;
  57. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=155687;
  58. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=154346;
  59. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=180676;
  60. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=185002;
  61. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10154346;
  62. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10155687;
  63. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=174513;
  64. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10174513;
  65. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10180676;
  66. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=47706;
  67. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10047706;
  68. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=47701;
  69. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=48982;
  70. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10047701;
  71. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10048982;
  72. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=46301;
  73. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10046301;
  74. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10046708;
  75. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=46708;
  76. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=48161;
  77. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10048161;
  78. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10046702;
  79. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=46702;
  80. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=45927;
  81. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=46628;
  82. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=46812;
  83. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10045927;
  84. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10046628;
  85. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10046812;
  86. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=47069;
  87. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10047069;
  88. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10046424;
  89. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=46424;
  90. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=132721;
  91. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=147147;
  92. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=166369;
  93. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10132721;
  94. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10147147;
  95. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10166369;
  96. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=49139;
  97. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10049139;
  98. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=45528;
  99. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10045528;
  100. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10046831;
  101. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=46831;
  102. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10557;
  103. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10558;
  104. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10559;
  105. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=47553;
  106. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=47554;
  107. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=47555;
  108. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=47556;
  109. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=47557;
  110. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=47558;
  111. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=47559;
  112. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=47560;
  113. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=47563;
  114. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=47564;
  115. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=47565;
  116. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=47566;
  117. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=47567;
  118. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=47568;
  119. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10047553;
  120. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10047554;
  121. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10047555;
  122. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10047556;
  123. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10047557;
  124. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10047558;
  125. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10047559;
  126. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10047560;
  127. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10047563;
  128. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10047564;
  129. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10047565;
  130. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10047566;
  131. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10047567;
  132. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10047568;
  133. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10172622;
  134. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=172622;
  135. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=46477;
  136. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10046477;
  137. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=46492;
  138. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10046492;
  139. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10046517;
  140. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=46517;
  141. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10046916;
  142. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=46916;
  143. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10046334;
  144. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=46334;
  145. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10047659;
  146. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=47659;
  147. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10046609;
  148. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=46609;
  149. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10046425;
  150. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=46425;
  151. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10046335;
  152. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=46335;
  153. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10047368;
  154. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=47368;
  155. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10046154;
  156. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=46154;
  157. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10046289;
  158. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=46289;
  159. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10049148;
  160. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=49148;
  161. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10047968;
  162. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=47968;
  163. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10045311;
  164. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=45311;
  165. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=46899;
  166. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10046899;
  167. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=48552;
  168. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10048552;
  169. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=49163;
  170. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=49164;
  171. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=49165;
  172. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=49166;
  173. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10049163;
  174. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10049164;
  175. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10049165;
  176. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10049166;
  177. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=48550;
  178. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10048550;
  179. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=46250;
  180. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=46251;
  181. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10046250;
  182. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10046251;
  183. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10045461;
  184. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=45461;
  185. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=45527;
  186. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10045527;
  187. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=45768;
  188. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10045768;
  189. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10046629;
  190. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10048996;
  191. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=48996;
  192. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=50321;
  193. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=51680;
  194. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=53369;
  195. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10050321;
  196. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10051680;
  197. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10053369;
  198. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=140568;
  199. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=167761;
  200. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=175803;
  201. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10140568;
  202. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10167761;
  203. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10175803;
  204. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=10048397;
  205. UPDATE `eq2emu`.`items` SET `tinkered`='1' WHERE `id`=48397;