API tools faq
paste
WoWCreador

Scale Items by Percentage

WoWCreador
Apr 11th, 2020
218
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 34.75 KB | None | 0 0
raw download clone embed print report
  1. SET @itemlevel = itemlevel
  2. UPDATE item_template SET stat_value1 = stat_value1 + stat_value1*-.70 WHERE stat_type1 = 3 AND itemlevel = @itemlevel
  3. UPDATE item_template SET stat_value1 = stat_value1 + stat_value1*-.70 WHERE stat_type1 = 4 AND itemlevel = @itemlevel
  4. UPDATE item_template SET stat_value1 = stat_value1 + stat_value1*-.70 WHERE stat_type1 = 5 AND itemlevel = @itemlevel
  5. UPDATE item_template SET stat_value1 = stat_value1 + stat_value1*-.70 WHERE stat_type1 = 6 AND itemlevel = @itemlevel
  6. UPDATE item_template SET stat_value1 = stat_value1 + stat_value1*-.70 WHERE stat_type1 = 7 AND itemlevel = @itemlevel
  7. UPDATE item_template SET stat_value1 = stat_value1 + stat_value1*-.70 WHERE stat_type1 = 12 AND itemlevel = @itemlevel
  8. UPDATE item_template SET stat_value1 = stat_value1 + stat_value1*-.70 WHERE stat_type1 = 13 AND itemlevel = @itemlevel
  9. UPDATE item_template SET stat_value1 = stat_value1 + stat_value1*-.70 WHERE stat_type1 = 14 AND itemlevel = @itemlevel
  10. UPDATE item_template SET stat_value1 = stat_value1 + stat_value1*-.70 WHERE stat_type1 = 15 AND itemlevel = @itemlevel
  11. UPDATE item_template SET stat_value1 = stat_value1 + stat_value1*-.70 WHERE stat_type1 = 16 AND itemlevel = @itemlevel
  12. UPDATE item_template SET stat_value1 = stat_value1 + stat_value1*-.70 WHERE stat_type1 = 17 AND itemlevel = @itemlevel
  13. UPDATE item_template SET stat_value1 = stat_value1 + stat_value1*-.70 WHERE stat_type1 = 18 AND itemlevel = @itemlevel
  14. UPDATE item_template SET stat_value1 = stat_value1 + stat_value1*-.70 WHERE stat_type1 = 19 AND itemlevel = @itemlevel
  15. UPDATE item_template SET stat_value1 = stat_value1 + stat_value1*-.70 WHERE stat_type1 = 20 AND itemlevel = @itemlevel
  16. UPDATE item_template SET stat_value1 = stat_value1 + stat_value1*-.70 WHERE stat_type1 = 21 AND itemlevel = @itemlevel
  17. UPDATE item_template SET stat_value1 = stat_value1 + stat_value1*-.70 WHERE stat_type1 = 22 AND itemlevel = @itemlevel
  18. UPDATE item_template SET stat_value1 = stat_value1 + stat_value1*-.70 WHERE stat_type1 = 23 AND itemlevel = @itemlevel
  19. UPDATE item_template SET stat_value1 = stat_value1 + stat_value1*-.70 WHERE stat_type1 = 24 AND itemlevel = @itemlevel
  20. UPDATE item_template SET stat_value1 = stat_value1 + stat_value1*-.70 WHERE stat_type1 = 25 AND itemlevel = @itemlevel
  21. UPDATE item_template SET stat_value1 = stat_value1 + stat_value1*-.70 WHERE stat_type1 = 26 AND itemlevel = @itemlevel
  22. UPDATE item_template SET stat_value1 = stat_value1 + stat_value1*-.70 WHERE stat_type1 = 27 AND itemlevel = @itemlevel
  23. UPDATE item_template SET stat_value1 = stat_value1 + stat_value1*-.70 WHERE stat_type1 = 28 AND itemlevel = @itemlevel
  24. UPDATE item_template SET stat_value1 = stat_value1 + stat_value1*-.70 WHERE stat_type1 = 29 AND itemlevel = @itemlevel
  25. UPDATE item_template SET stat_value1 = stat_value1 + stat_value1*-.70 WHERE stat_type1 = 30 AND itemlevel = @itemlevel
  26. UPDATE item_template SET stat_value1 = stat_value1 + stat_value1*-.70 WHERE stat_type1 = 31 AND itemlevel = @itemlevel
  27. UPDATE item_template SET stat_value1 = stat_value1 + stat_value1*-.70 WHERE stat_type1 = 32 AND itemlevel = @itemlevel
  28. UPDATE item_template SET stat_value1 = stat_value1 + stat_value1*-.70 WHERE stat_type1 = 33 AND itemlevel = @itemlevel
  29. UPDATE item_template SET stat_value1 = stat_value1 + stat_value1*-.70 WHERE stat_type1 = 34 AND itemlevel = @itemlevel
  30. UPDATE item_template SET stat_value1 = stat_value1 + stat_value1*-.70 WHERE stat_type1 = 35 AND itemlevel = @itemlevel
  31. UPDATE item_template SET stat_value1 = stat_value1 + stat_value1*-.70 WHERE stat_type1 = 36 AND itemlevel = @itemlevel
  32. UPDATE item_template SET stat_value1 = stat_value1 + stat_value1*-.70 WHERE stat_type1 = 37 AND itemlevel = @itemlevel
  33. UPDATE item_template SET stat_value1 = stat_value1 + stat_value1*-.70 WHERE stat_type1 = 38 AND itemlevel = @itemlevel
  34. UPDATE item_template SET stat_value1 = stat_value1 + stat_value1*-.70 WHERE stat_type1 = 39 AND itemlevel = @itemlevel
  35. UPDATE item_template SET stat_value1 = stat_value1 + stat_value1*-.70 WHERE stat_type1 = 40 AND itemlevel = @itemlevel
  36. UPDATE item_template SET stat_value1 = stat_value1 + stat_value1*-.70 WHERE stat_type1 = 41 AND itemlevel = @itemlevel
  37. UPDATE item_template SET stat_value1 = stat_value1 + stat_value1*-.70 WHERE stat_type1 = 42 AND itemlevel = @itemlevel
  38. UPDATE item_template SET stat_value1 = stat_value1 + stat_value1*-.70 WHERE stat_type1 = 43 AND itemlevel = @itemlevel
  39. UPDATE item_template SET stat_value1 = stat_value1 + stat_value1*-.70 WHERE stat_type1 = 44 AND itemlevel = @itemlevel
  40. UPDATE item_template SET stat_value1 = stat_value1 + stat_value1*-.70 WHERE stat_type1 = 45 AND itemlevel = @itemlevel
  41. UPDATE item_template SET stat_value1 = stat_value1 + stat_value1*-.70 WHERE stat_type1 = 46 AND itemlevel = @itemlevel
  42. UPDATE item_template SET stat_value1 = stat_value1 + stat_value1*-.70 WHERE stat_type1 = 47 AND itemlevel = @itemlevel
  43. UPDATE item_template SET stat_value1 = stat_value1 + stat_value1*-.70 WHERE stat_type1 = 48 AND itemlevel = @itemlevel
  44.  
  45. UPDATE item_template SET stat_value2 = stat_value2 + stat_value2*-.70 WHERE stat_type2 = 3 AND itemlevel = @itemlevel
  46. UPDATE item_template SET stat_value2 = stat_value2 + stat_value2*-.70 WHERE stat_type2 = 4 AND itemlevel = @itemlevel
  47. UPDATE item_template SET stat_value2 = stat_value2 + stat_value2*-.70 WHERE stat_type2 = 5 AND itemlevel = @itemlevel
  48. UPDATE item_template SET stat_value2 = stat_value2 + stat_value2*-.70 WHERE stat_type2 = 6 AND itemlevel = @itemlevel
  49. UPDATE item_template SET stat_value2 = stat_value2 + stat_value2*-.70 WHERE stat_type2 = 7 AND itemlevel = @itemlevel
  50. UPDATE item_template SET stat_value2 = stat_value2 + stat_value2*-.70 WHERE stat_type2 = 12 AND itemlevel = @itemlevel
  51. UPDATE item_template SET stat_value2 = stat_value2 + stat_value2*-.70 WHERE stat_type2 = 13 AND itemlevel = @itemlevel
  52. UPDATE item_template SET stat_value2 = stat_value2 + stat_value2*-.70 WHERE stat_type2 = 14 AND itemlevel = @itemlevel
  53. UPDATE item_template SET stat_value2 = stat_value2 + stat_value2*-.70 WHERE stat_type2 = 15 AND itemlevel = @itemlevel
  54. UPDATE item_template SET stat_value2 = stat_value2 + stat_value2*-.70 WHERE stat_type2 = 16 AND itemlevel = @itemlevel
  55. UPDATE item_template SET stat_value2 = stat_value2 + stat_value2*-.70 WHERE stat_type2 = 17 AND itemlevel = @itemlevel
  56. UPDATE item_template SET stat_value2 = stat_value2 + stat_value2*-.70 WHERE stat_type2 = 18 AND itemlevel = @itemlevel
  57. UPDATE item_template SET stat_value2 = stat_value2 + stat_value2*-.70 WHERE stat_type2 = 19 AND itemlevel = @itemlevel
  58. UPDATE item_template SET stat_value2 = stat_value2 + stat_value2*-.70 WHERE stat_type2 = 20 AND itemlevel = @itemlevel
  59. UPDATE item_template SET stat_value2 = stat_value2 + stat_value2*-.70 WHERE stat_type2 = 21 AND itemlevel = @itemlevel
  60. UPDATE item_template SET stat_value2 = stat_value2 + stat_value2*-.70 WHERE stat_type2 = 22 AND itemlevel = @itemlevel
  61. UPDATE item_template SET stat_value2 = stat_value2 + stat_value2*-.70 WHERE stat_type2 = 23 AND itemlevel = @itemlevel
  62. UPDATE item_template SET stat_value2 = stat_value2 + stat_value2*-.70 WHERE stat_type2 = 24 AND itemlevel = @itemlevel
  63. UPDATE item_template SET stat_value2 = stat_value2 + stat_value2*-.70 WHERE stat_type2 = 25 AND itemlevel = @itemlevel
  64. UPDATE item_template SET stat_value2 = stat_value2 + stat_value2*-.70 WHERE stat_type2 = 26 AND itemlevel = @itemlevel
  65. UPDATE item_template SET stat_value2 = stat_value2 + stat_value2*-.70 WHERE stat_type2 = 27 AND itemlevel = @itemlevel
  66. UPDATE item_template SET stat_value2 = stat_value2 + stat_value2*-.70 WHERE stat_type2 = 28 AND itemlevel = @itemlevel
  67. UPDATE item_template SET stat_value2 = stat_value2 + stat_value2*-.70 WHERE stat_type2 = 29 AND itemlevel = @itemlevel
  68. UPDATE item_template SET stat_value2 = stat_value2 + stat_value2*-.70 WHERE stat_type2 = 30 AND itemlevel = @itemlevel
  69. UPDATE item_template SET stat_value2 = stat_value2 + stat_value2*-.70 WHERE stat_type2 = 31 AND itemlevel = @itemlevel
  70. UPDATE item_template SET stat_value2 = stat_value2 + stat_value2*-.70 WHERE stat_type2 = 32 AND itemlevel = @itemlevel
  71. UPDATE item_template SET stat_value2 = stat_value2 + stat_value2*-.70 WHERE stat_type2 = 33 AND itemlevel = @itemlevel
  72. UPDATE item_template SET stat_value2 = stat_value2 + stat_value2*-.70 WHERE stat_type2 = 34 AND itemlevel = @itemlevel
  73. UPDATE item_template SET stat_value2 = stat_value2 + stat_value2*-.70 WHERE stat_type2 = 35 AND itemlevel = @itemlevel
  74. UPDATE item_template SET stat_value2 = stat_value2 + stat_value2*-.70 WHERE stat_type2 = 36 AND itemlevel = @itemlevel
  75. UPDATE item_template SET stat_value2 = stat_value2 + stat_value2*-.70 WHERE stat_type2 = 37 AND itemlevel = @itemlevel
  76. UPDATE item_template SET stat_value2 = stat_value2 + stat_value2*-.70 WHERE stat_type2 = 38 AND itemlevel = @itemlevel
  77. UPDATE item_template SET stat_value2 = stat_value2 + stat_value2*-.70 WHERE stat_type2 = 39 AND itemlevel = @itemlevel
  78. UPDATE item_template SET stat_value2 = stat_value2 + stat_value2*-.70 WHERE stat_type2 = 40 AND itemlevel = @itemlevel
  79. UPDATE item_template SET stat_value2 = stat_value2 + stat_value2*-.70 WHERE stat_type2 = 41 AND itemlevel = @itemlevel
  80. UPDATE item_template SET stat_value2 = stat_value2 + stat_value2*-.70 WHERE stat_type2 = 42 AND itemlevel = @itemlevel
  81. UPDATE item_template SET stat_value2 = stat_value2 + stat_value2*-.70 WHERE stat_type2 = 43 AND itemlevel = @itemlevel
  82. UPDATE item_template SET stat_value2 = stat_value2 + stat_value2*-.70 WHERE stat_type2 = 44 AND itemlevel = @itemlevel
  83. UPDATE item_template SET stat_value2 = stat_value2 + stat_value2*-.70 WHERE stat_type2 = 45 AND itemlevel = @itemlevel
  84. UPDATE item_template SET stat_value2 = stat_value2 + stat_value2*-.70 WHERE stat_type2 = 46 AND itemlevel = @itemlevel
  85. UPDATE item_template SET stat_value2 = stat_value2 + stat_value2*-.70 WHERE stat_type2 = 47 AND itemlevel = @itemlevel
  86. UPDATE item_template SET stat_value2 = stat_value2 + stat_value2*-.70 WHERE stat_type2 = 48 AND itemlevel = @itemlevel
  87.  
  88. UPDATE item_template SET stat_value3 = stat_value3 + stat_value3*-.70 WHERE stat_type3 = 3 AND itemlevel = @itemlevel
  89. UPDATE item_template SET stat_value3 = stat_value3 + stat_value3*-.70 WHERE stat_type3 = 4 AND itemlevel = @itemlevel
  90. UPDATE item_template SET stat_value3 = stat_value3 + stat_value3*-.70 WHERE stat_type3 = 5 AND itemlevel = @itemlevel
  91. UPDATE item_template SET stat_value3 = stat_value3 + stat_value3*-.70 WHERE stat_type3 = 6 AND itemlevel = @itemlevel
  92. UPDATE item_template SET stat_value3 = stat_value3 + stat_value3*-.70 WHERE stat_type3 = 7 AND itemlevel = @itemlevel
  93. UPDATE item_template SET stat_value3 = stat_value3 + stat_value3*-.70 WHERE stat_type3 = 12 AND itemlevel = @itemlevel
  94. UPDATE item_template SET stat_value3 = stat_value3 + stat_value3*-.70 WHERE stat_type3 = 13 AND itemlevel = @itemlevel
  95. UPDATE item_template SET stat_value3 = stat_value3 + stat_value3*-.70 WHERE stat_type3 = 14 AND itemlevel = @itemlevel
  96. UPDATE item_template SET stat_value3 = stat_value3 + stat_value3*-.70 WHERE stat_type3 = 15 AND itemlevel = @itemlevel
  97. UPDATE item_template SET stat_value3 = stat_value3 + stat_value3*-.70 WHERE stat_type3 = 16 AND itemlevel = @itemlevel
  98. UPDATE item_template SET stat_value3 = stat_value3 + stat_value3*-.70 WHERE stat_type3 = 17 AND itemlevel = @itemlevel
  99. UPDATE item_template SET stat_value3 = stat_value3 + stat_value3*-.70 WHERE stat_type3 = 18 AND itemlevel = @itemlevel
  100. UPDATE item_template SET stat_value3 = stat_value3 + stat_value3*-.70 WHERE stat_type3 = 19 AND itemlevel = @itemlevel
  101. UPDATE item_template SET stat_value3 = stat_value3 + stat_value3*-.70 WHERE stat_type3 = 20 AND itemlevel = @itemlevel
  102. UPDATE item_template SET stat_value3 = stat_value3 + stat_value3*-.70 WHERE stat_type3 = 21 AND itemlevel = @itemlevel
  103. UPDATE item_template SET stat_value3 = stat_value3 + stat_value3*-.70 WHERE stat_type3 = 22 AND itemlevel = @itemlevel
  104. UPDATE item_template SET stat_value3 = stat_value3 + stat_value3*-.70 WHERE stat_type3 = 23 AND itemlevel = @itemlevel
  105. UPDATE item_template SET stat_value3 = stat_value3 + stat_value3*-.70 WHERE stat_type3 = 24 AND itemlevel = @itemlevel
  106. UPDATE item_template SET stat_value3 = stat_value3 + stat_value3*-.70 WHERE stat_type3 = 25 AND itemlevel = @itemlevel
  107. UPDATE item_template SET stat_value3 = stat_value3 + stat_value3*-.70 WHERE stat_type3 = 26 AND itemlevel = @itemlevel
  108. UPDATE item_template SET stat_value3 = stat_value3 + stat_value3*-.70 WHERE stat_type3 = 27 AND itemlevel = @itemlevel
  109. UPDATE item_template SET stat_value3 = stat_value3 + stat_value3*-.70 WHERE stat_type3 = 28 AND itemlevel = @itemlevel
  110. UPDATE item_template SET stat_value3 = stat_value3 + stat_value3*-.70 WHERE stat_type3 = 29 AND itemlevel = @itemlevel
  111. UPDATE item_template SET stat_value3 = stat_value3 + stat_value3*-.70 WHERE stat_type3 = 30 AND itemlevel = @itemlevel
  112. UPDATE item_template SET stat_value3 = stat_value3 + stat_value3*-.70 WHERE stat_type3 = 31 AND itemlevel = @itemlevel
  113. UPDATE item_template SET stat_value3 = stat_value3 + stat_value3*-.70 WHERE stat_type3 = 32 AND itemlevel = @itemlevel
  114. UPDATE item_template SET stat_value3 = stat_value3 + stat_value3*-.70 WHERE stat_type3 = 33 AND itemlevel = @itemlevel
  115. UPDATE item_template SET stat_value3 = stat_value3 + stat_value3*-.70 WHERE stat_type3 = 34 AND itemlevel = @itemlevel
  116. UPDATE item_template SET stat_value3 = stat_value3 + stat_value3*-.70 WHERE stat_type3 = 35 AND itemlevel = @itemlevel
  117. UPDATE item_template SET stat_value3 = stat_value3 + stat_value3*-.70 WHERE stat_type3 = 36 AND itemlevel = @itemlevel
  118. UPDATE item_template SET stat_value3 = stat_value3 + stat_value3*-.70 WHERE stat_type3 = 37 AND itemlevel = @itemlevel
  119. UPDATE item_template SET stat_value3 = stat_value3 + stat_value3*-.70 WHERE stat_type3 = 38 AND itemlevel = @itemlevel
  120. UPDATE item_template SET stat_value3 = stat_value3 + stat_value3*-.70 WHERE stat_type3 = 39 AND itemlevel = @itemlevel
  121. UPDATE item_template SET stat_value3 = stat_value3 + stat_value3*-.70 WHERE stat_type3 = 40 AND itemlevel = @itemlevel
  122. UPDATE item_template SET stat_value3 = stat_value3 + stat_value3*-.70 WHERE stat_type3 = 41 AND itemlevel = @itemlevel
  123. UPDATE item_template SET stat_value3 = stat_value3 + stat_value3*-.70 WHERE stat_type3 = 42 AND itemlevel = @itemlevel
  124. UPDATE item_template SET stat_value3 = stat_value3 + stat_value3*-.70 WHERE stat_type3 = 43 AND itemlevel = @itemlevel
  125. UPDATE item_template SET stat_value3 = stat_value3 + stat_value3*-.70 WHERE stat_type3 = 44 AND itemlevel = @itemlevel
  126. UPDATE item_template SET stat_value3 = stat_value3 + stat_value3*-.70 WHERE stat_type3 = 45 AND itemlevel = @itemlevel
  127. UPDATE item_template SET stat_value3 = stat_value3 + stat_value3*-.70 WHERE stat_type3 = 46 AND itemlevel = @itemlevel
  128. UPDATE item_template SET stat_value3 = stat_value3 + stat_value3*-.70 WHERE stat_type3 = 47 AND itemlevel = @itemlevel
  129. UPDATE item_template SET stat_value3 = stat_value3 + stat_value3*-.70 WHERE stat_type3 = 48 AND itemlevel = @itemlevel
  130.  
  131. UPDATE item_template SET stat_value4 = stat_value4 + stat_value4*-.70 WHERE stat_type4 = 3 AND itemlevel = @itemlevel
  132. UPDATE item_template SET stat_value4 = stat_value4 + stat_value4*-.70 WHERE stat_type4 = 4 AND itemlevel = @itemlevel
  133. UPDATE item_template SET stat_value4 = stat_value4 + stat_value4*-.70 WHERE stat_type4 = 5 AND itemlevel = @itemlevel
  134. UPDATE item_template SET stat_value4 = stat_value4 + stat_value4*-.70 WHERE stat_type4 = 6 AND itemlevel = @itemlevel
  135. UPDATE item_template SET stat_value4 = stat_value4 + stat_value4*-.70 WHERE stat_type4 = 7 AND itemlevel = @itemlevel
  136. UPDATE item_template SET stat_value4 = stat_value4 + stat_value4*-.70 WHERE stat_type4 = 12 AND itemlevel = @itemlevel
  137. UPDATE item_template SET stat_value4 = stat_value4 + stat_value4*-.70 WHERE stat_type4 = 13 AND itemlevel = @itemlevel
  138. UPDATE item_template SET stat_value4 = stat_value4 + stat_value4*-.70 WHERE stat_type4 = 14 AND itemlevel = @itemlevel
  139. UPDATE item_template SET stat_value4 = stat_value4 + stat_value4*-.70 WHERE stat_type4 = 15 AND itemlevel = @itemlevel
  140. UPDATE item_template SET stat_value4 = stat_value4 + stat_value4*-.70 WHERE stat_type4 = 16 AND itemlevel = @itemlevel
  141. UPDATE item_template SET stat_value4 = stat_value4 + stat_value4*-.70 WHERE stat_type4 = 17 AND itemlevel = @itemlevel
  142. UPDATE item_template SET stat_value4 = stat_value4 + stat_value4*-.70 WHERE stat_type4 = 18 AND itemlevel = @itemlevel
  143. UPDATE item_template SET stat_value4 = stat_value4 + stat_value4*-.70 WHERE stat_type4 = 19 AND itemlevel = @itemlevel
  144. UPDATE item_template SET stat_value4 = stat_value4 + stat_value4*-.70 WHERE stat_type4 = 20 AND itemlevel = @itemlevel
  145. UPDATE item_template SET stat_value4 = stat_value4 + stat_value4*-.70 WHERE stat_type4 = 21 AND itemlevel = @itemlevel
  146. UPDATE item_template SET stat_value4 = stat_value4 + stat_value4*-.70 WHERE stat_type4 = 22 AND itemlevel = @itemlevel
  147. UPDATE item_template SET stat_value4 = stat_value4 + stat_value4*-.70 WHERE stat_type4 = 23 AND itemlevel = @itemlevel
  148. UPDATE item_template SET stat_value4 = stat_value4 + stat_value4*-.70 WHERE stat_type4 = 24 AND itemlevel = @itemlevel
  149. UPDATE item_template SET stat_value4 = stat_value4 + stat_value4*-.70 WHERE stat_type4 = 25 AND itemlevel = @itemlevel
  150. UPDATE item_template SET stat_value4 = stat_value4 + stat_value4*-.70 WHERE stat_type4 = 26 AND itemlevel = @itemlevel
  151. UPDATE item_template SET stat_value4 = stat_value4 + stat_value4*-.70 WHERE stat_type4 = 27 AND itemlevel = @itemlevel
  152. UPDATE item_template SET stat_value4 = stat_value4 + stat_value4*-.70 WHERE stat_type4 = 28 AND itemlevel = @itemlevel
  153. UPDATE item_template SET stat_value4 = stat_value4 + stat_value4*-.70 WHERE stat_type4 = 29 AND itemlevel = @itemlevel
  154. UPDATE item_template SET stat_value4 = stat_value4 + stat_value4*-.70 WHERE stat_type4 = 30 AND itemlevel = @itemlevel
  155. UPDATE item_template SET stat_value4 = stat_value4 + stat_value4*-.70 WHERE stat_type4 = 31 AND itemlevel = @itemlevel
  156. UPDATE item_template SET stat_value4 = stat_value4 + stat_value4*-.70 WHERE stat_type4 = 32 AND itemlevel = @itemlevel
  157. UPDATE item_template SET stat_value4 = stat_value4 + stat_value4*-.70 WHERE stat_type4 = 33 AND itemlevel = @itemlevel
  158. UPDATE item_template SET stat_value4 = stat_value4 + stat_value4*-.70 WHERE stat_type4 = 34 AND itemlevel = @itemlevel
  159. UPDATE item_template SET stat_value4 = stat_value4 + stat_value4*-.70 WHERE stat_type4 = 35 AND itemlevel = @itemlevel
  160. UPDATE item_template SET stat_value4 = stat_value4 + stat_value4*-.70 WHERE stat_type4 = 36 AND itemlevel = @itemlevel
  161. UPDATE item_template SET stat_value4 = stat_value4 + stat_value4*-.70 WHERE stat_type4 = 37 AND itemlevel = @itemlevel
  162. UPDATE item_template SET stat_value4 = stat_value4 + stat_value4*-.70 WHERE stat_type4 = 38 AND itemlevel = @itemlevel
  163. UPDATE item_template SET stat_value4 = stat_value4 + stat_value4*-.70 WHERE stat_type4 = 39 AND itemlevel = @itemlevel
  164. UPDATE item_template SET stat_value4 = stat_value4 + stat_value4*-.70 WHERE stat_type4 = 40 AND itemlevel = @itemlevel
  165. UPDATE item_template SET stat_value4 = stat_value4 + stat_value4*-.70 WHERE stat_type4 = 41 AND itemlevel = @itemlevel
  166. UPDATE item_template SET stat_value4 = stat_value4 + stat_value4*-.70 WHERE stat_type4 = 42 AND itemlevel = @itemlevel
  167. UPDATE item_template SET stat_value4 = stat_value4 + stat_value4*-.70 WHERE stat_type4 = 43 AND itemlevel = @itemlevel
  168. UPDATE item_template SET stat_value4 = stat_value4 + stat_value4*-.70 WHERE stat_type4 = 44 AND itemlevel = @itemlevel
  169. UPDATE item_template SET stat_value4 = stat_value4 + stat_value4*-.70 WHERE stat_type4 = 45 AND itemlevel = @itemlevel
  170. UPDATE item_template SET stat_value4 = stat_value4 + stat_value4*-.70 WHERE stat_type4 = 46 AND itemlevel = @itemlevel
  171. UPDATE item_template SET stat_value4 = stat_value4 + stat_value4*-.70 WHERE stat_type4 = 47 AND itemlevel = @itemlevel
  172. UPDATE item_template SET stat_value4 = stat_value4 + stat_value4*-.70 WHERE stat_type4 = 48 AND itemlevel = @itemlevel
  173.  
  174.  
  175. UPDATE item_template SET stat_value5 = stat_value5 + stat_value5*-.70 WHERE stat_type5 = 3 AND itemlevel = @itemlevel
  176. UPDATE item_template SET stat_value5 = stat_value5 + stat_value5*-.70 WHERE stat_type5 = 4 AND itemlevel = @itemlevel
  177. UPDATE item_template SET stat_value5 = stat_value5 + stat_value5*-.70 WHERE stat_type5 = 5 AND itemlevel = @itemlevel
  178. UPDATE item_template SET stat_value5 = stat_value5 + stat_value5*-.70 WHERE stat_type5 = 6 AND itemlevel = @itemlevel
  179. UPDATE item_template SET stat_value5 = stat_value5 + stat_value5*-.70 WHERE stat_type5 = 7 AND itemlevel = @itemlevel
  180. UPDATE item_template SET stat_value5 = stat_value5 + stat_value5*-.70 WHERE stat_type5 = 12 AND itemlevel = @itemlevel
  181. UPDATE item_template SET stat_value5 = stat_value5 + stat_value5*-.70 WHERE stat_type5 = 13 AND itemlevel = @itemlevel
  182. UPDATE item_template SET stat_value5 = stat_value5 + stat_value5*-.70 WHERE stat_type5 = 14 AND itemlevel = @itemlevel
  183. UPDATE item_template SET stat_value5 = stat_value5 + stat_value5*-.70 WHERE stat_type5 = 15 AND itemlevel = @itemlevel
  184. UPDATE item_template SET stat_value5 = stat_value5 + stat_value5*-.70 WHERE stat_type5 = 16 AND itemlevel = @itemlevel
  185. UPDATE item_template SET stat_value5 = stat_value5 + stat_value5*-.70 WHERE stat_type5 = 17 AND itemlevel = @itemlevel
  186. UPDATE item_template SET stat_value5 = stat_value5 + stat_value5*-.70 WHERE stat_type5 = 18 AND itemlevel = @itemlevel
  187. UPDATE item_template SET stat_value5 = stat_value5 + stat_value5*-.70 WHERE stat_type5 = 19 AND itemlevel = @itemlevel
  188. UPDATE item_template SET stat_value5 = stat_value5 + stat_value5*-.70 WHERE stat_type5 = 20 AND itemlevel = @itemlevel
  189. UPDATE item_template SET stat_value5 = stat_value5 + stat_value5*-.70 WHERE stat_type5 = 21 AND itemlevel = @itemlevel
  190. UPDATE item_template SET stat_value5 = stat_value5 + stat_value5*-.70 WHERE stat_type5 = 22 AND itemlevel = @itemlevel
  191. UPDATE item_template SET stat_value5 = stat_value5 + stat_value5*-.70 WHERE stat_type5 = 23 AND itemlevel = @itemlevel
  192. UPDATE item_template SET stat_value5 = stat_value5 + stat_value5*-.70 WHERE stat_type5 = 24 AND itemlevel = @itemlevel
  193. UPDATE item_template SET stat_value5 = stat_value5 + stat_value5*-.70 WHERE stat_type5 = 25 AND itemlevel = @itemlevel
  194. UPDATE item_template SET stat_value5 = stat_value5 + stat_value5*-.70 WHERE stat_type5 = 26 AND itemlevel = @itemlevel
  195. UPDATE item_template SET stat_value5 = stat_value5 + stat_value5*-.70 WHERE stat_type5 = 27 AND itemlevel = @itemlevel
  196. UPDATE item_template SET stat_value5 = stat_value5 + stat_value5*-.70 WHERE stat_type5 = 28 AND itemlevel = @itemlevel
  197. UPDATE item_template SET stat_value5 = stat_value5 + stat_value5*-.70 WHERE stat_type5 = 29 AND itemlevel = @itemlevel
  198. UPDATE item_template SET stat_value5 = stat_value5 + stat_value5*-.70 WHERE stat_type5 = 30 AND itemlevel = @itemlevel
  199. UPDATE item_template SET stat_value5 = stat_value5 + stat_value5*-.70 WHERE stat_type5 = 31 AND itemlevel = @itemlevel
  200. UPDATE item_template SET stat_value5 = stat_value5 + stat_value5*-.70 WHERE stat_type5 = 32 AND itemlevel = @itemlevel
  201. UPDATE item_template SET stat_value5 = stat_value5 + stat_value5*-.70 WHERE stat_type5 = 33 AND itemlevel = @itemlevel
  202. UPDATE item_template SET stat_value5 = stat_value5 + stat_value5*-.70 WHERE stat_type5 = 34 AND itemlevel = @itemlevel
  203. UPDATE item_template SET stat_value5 = stat_value5 + stat_value5*-.70 WHERE stat_type5 = 35 AND itemlevel = @itemlevel
  204. UPDATE item_template SET stat_value5 = stat_value5 + stat_value5*-.70 WHERE stat_type5 = 36 AND itemlevel = @itemlevel
  205. UPDATE item_template SET stat_value5 = stat_value5 + stat_value5*-.70 WHERE stat_type5 = 37 AND itemlevel = @itemlevel
  206. UPDATE item_template SET stat_value5 = stat_value5 + stat_value5*-.70 WHERE stat_type5 = 38 AND itemlevel = @itemlevel
  207. UPDATE item_template SET stat_value5 = stat_value5 + stat_value5*-.70 WHERE stat_type5 = 39 AND itemlevel = @itemlevel
  208. UPDATE item_template SET stat_value5 = stat_value5 + stat_value5*-.70 WHERE stat_type5 = 40 AND itemlevel = @itemlevel
  209. UPDATE item_template SET stat_value5 = stat_value5 + stat_value5*-.70 WHERE stat_type5 = 41 AND itemlevel = @itemlevel
  210. UPDATE item_template SET stat_value5 = stat_value5 + stat_value5*-.70 WHERE stat_type5 = 42 AND itemlevel = @itemlevel
  211. UPDATE item_template SET stat_value5 = stat_value5 + stat_value5*-.70 WHERE stat_type5 = 43 AND itemlevel = @itemlevel
  212. UPDATE item_template SET stat_value5 = stat_value5 + stat_value5*-.70 WHERE stat_type5 = 44 AND itemlevel = @itemlevel
  213. UPDATE item_template SET stat_value5 = stat_value5 + stat_value5*-.70 WHERE stat_type5 = 45 AND itemlevel = @itemlevel
  214. UPDATE item_template SET stat_value5 = stat_value5 + stat_value5*-.70 WHERE stat_type5 = 46 AND itemlevel = @itemlevel
  215. UPDATE item_template SET stat_value5 = stat_value5 + stat_value5*-.70 WHERE stat_type5 = 47 AND itemlevel = @itemlevel
  216. UPDATE item_template SET stat_value5 = stat_value5 + stat_value5*-.70 WHERE stat_type5 = 48 AND itemlevel = @itemlevel
  217.  
  218.  
  219. UPDATE item_template SET stat_value6 = stat_value6 + stat_value6*-.70 WHERE stat_type6 = 3 AND itemlevel = @itemlevel
  220. UPDATE item_template SET stat_value6 = stat_value6 + stat_value6*-.70 WHERE stat_type6 = 4 AND itemlevel = @itemlevel
  221. UPDATE item_template SET stat_value6 = stat_value6 + stat_value6*-.70 WHERE stat_type6 = 5 AND itemlevel = @itemlevel
  222. UPDATE item_template SET stat_value6 = stat_value6 + stat_value6*-.70 WHERE stat_type6 = 6 AND itemlevel = @itemlevel
  223. UPDATE item_template SET stat_value6 = stat_value6 + stat_value6*-.70 WHERE stat_type6 = 7 AND itemlevel = @itemlevel
  224. UPDATE item_template SET stat_value6 = stat_value6 + stat_value6*-.70 WHERE stat_type6 = 12 AND itemlevel = @itemlevel
  225. UPDATE item_template SET stat_value6 = stat_value6 + stat_value6*-.70 WHERE stat_type6 = 13 AND itemlevel = @itemlevel
  226. UPDATE item_template SET stat_value6 = stat_value6 + stat_value6*-.70 WHERE stat_type6 = 14 AND itemlevel = @itemlevel
  227. UPDATE item_template SET stat_value6 = stat_value6 + stat_value6*-.70 WHERE stat_type6 = 15 AND itemlevel = @itemlevel
  228. UPDATE item_template SET stat_value6 = stat_value6 + stat_value6*-.70 WHERE stat_type6 = 16 AND itemlevel = @itemlevel
  229. UPDATE item_template SET stat_value6 = stat_value6 + stat_value6*-.70 WHERE stat_type6 = 17 AND itemlevel = @itemlevel
  230. UPDATE item_template SET stat_value6 = stat_value6 + stat_value6*-.70 WHERE stat_type6 = 18 AND itemlevel = @itemlevel
  231. UPDATE item_template SET stat_value6 = stat_value6 + stat_value6*-.70 WHERE stat_type6 = 19 AND itemlevel = @itemlevel
  232. UPDATE item_template SET stat_value6 = stat_value6 + stat_value6*-.70 WHERE stat_type6 = 20 AND itemlevel = @itemlevel
  233. UPDATE item_template SET stat_value6 = stat_value6 + stat_value6*-.70 WHERE stat_type6 = 21 AND itemlevel = @itemlevel
  234. UPDATE item_template SET stat_value6 = stat_value6 + stat_value6*-.70 WHERE stat_type6 = 22 AND itemlevel = @itemlevel
  235. UPDATE item_template SET stat_value6 = stat_value6 + stat_value6*-.70 WHERE stat_type6 = 23 AND itemlevel = @itemlevel
  236. UPDATE item_template SET stat_value6 = stat_value6 + stat_value6*-.70 WHERE stat_type6 = 24 AND itemlevel = @itemlevel
  237. UPDATE item_template SET stat_value6 = stat_value6 + stat_value6*-.70 WHERE stat_type6 = 25 AND itemlevel = @itemlevel
  238. UPDATE item_template SET stat_value6 = stat_value6 + stat_value6*-.70 WHERE stat_type6 = 26 AND itemlevel = @itemlevel
  239. UPDATE item_template SET stat_value6 = stat_value6 + stat_value6*-.70 WHERE stat_type6 = 27 AND itemlevel = @itemlevel
  240. UPDATE item_template SET stat_value6 = stat_value6 + stat_value6*-.70 WHERE stat_type6 = 28 AND itemlevel = @itemlevel
  241. UPDATE item_template SET stat_value6 = stat_value6 + stat_value6*-.70 WHERE stat_type6 = 29 AND itemlevel = @itemlevel
  242. UPDATE item_template SET stat_value6 = stat_value6 + stat_value6*-.70 WHERE stat_type6 = 30 AND itemlevel = @itemlevel
  243. UPDATE item_template SET stat_value6 = stat_value6 + stat_value6*-.70 WHERE stat_type6 = 31 AND itemlevel = @itemlevel
  244. UPDATE item_template SET stat_value6 = stat_value6 + stat_value6*-.70 WHERE stat_type6 = 32 AND itemlevel = @itemlevel
  245. UPDATE item_template SET stat_value6 = stat_value6 + stat_value6*-.70 WHERE stat_type6 = 33 AND itemlevel = @itemlevel
  246. UPDATE item_template SET stat_value6 = stat_value6 + stat_value6*-.70 WHERE stat_type6 = 34 AND itemlevel = @itemlevel
  247. UPDATE item_template SET stat_value6 = stat_value6 + stat_value6*-.70 WHERE stat_type6 = 35 AND itemlevel = @itemlevel
  248. UPDATE item_template SET stat_value6 = stat_value6 + stat_value6*-.70 WHERE stat_type6 = 36 AND itemlevel = @itemlevel
  249. UPDATE item_template SET stat_value6 = stat_value6 + stat_value6*-.70 WHERE stat_type6 = 37 AND itemlevel = @itemlevel
  250. UPDATE item_template SET stat_value6 = stat_value6 + stat_value6*-.70 WHERE stat_type6 = 38 AND itemlevel = @itemlevel
  251. UPDATE item_template SET stat_value6 = stat_value6 + stat_value6*-.70 WHERE stat_type6 = 39 AND itemlevel = @itemlevel
  252. UPDATE item_template SET stat_value6 = stat_value6 + stat_value6*-.70 WHERE stat_type6 = 40 AND itemlevel = @itemlevel
  253. UPDATE item_template SET stat_value6 = stat_value6 + stat_value6*-.70 WHERE stat_type6 = 41 AND itemlevel = @itemlevel
  254. UPDATE item_template SET stat_value6 = stat_value6 + stat_value6*-.70 WHERE stat_type6 = 42 AND itemlevel = @itemlevel
  255. UPDATE item_template SET stat_value6 = stat_value6 + stat_value6*-.70 WHERE stat_type6 = 43 AND itemlevel = @itemlevel
  256. UPDATE item_template SET stat_value6 = stat_value6 + stat_value6*-.70 WHERE stat_type6 = 44 AND itemlevel = @itemlevel
  257. UPDATE item_template SET stat_value6 = stat_value6 + stat_value6*-.70 WHERE stat_type6 = 45 AND itemlevel = @itemlevel
  258. UPDATE item_template SET stat_value6 = stat_value6 + stat_value6*-.70 WHERE stat_type6 = 46 AND itemlevel = @itemlevel
  259. UPDATE item_template SET stat_value6 = stat_value6 + stat_value6*-.70 WHERE stat_type6 = 47 AND itemlevel = @itemlevel
  260. UPDATE item_template SET stat_value6 = stat_value6 + stat_value6*-.70 WHERE stat_type6 = 48 AND itemlevel = @itemlevel
  261.  
  262. UPDATE item_template SET stat_value7 = stat_value7 + stat_value7*-.70 WHERE stat_type7 = 3 AND itemlevel = @itemlevel
  263. UPDATE item_template SET stat_value7 = stat_value7 + stat_value7*-.70 WHERE stat_type7 = 4 AND itemlevel = @itemlevel
  264. UPDATE item_template SET stat_value7 = stat_value7 + stat_value7*-.70 WHERE stat_type7 = 5 AND itemlevel = @itemlevel
  265. UPDATE item_template SET stat_value7 = stat_value7 + stat_value7*-.70 WHERE stat_type7 = 6 AND itemlevel = @itemlevel
  266. UPDATE item_template SET stat_value7 = stat_value7 + stat_value7*-.70 WHERE stat_type7 = 7 AND itemlevel = @itemlevel
  267. UPDATE item_template SET stat_value7 = stat_value7 + stat_value7*-.70 WHERE stat_type7 = 12 AND itemlevel = @itemlevel
  268. UPDATE item_template SET stat_value7 = stat_value7 + stat_value7*-.70 WHERE stat_type7 = 13 AND itemlevel = @itemlevel
  269. UPDATE item_template SET stat_value7 = stat_value7 + stat_value7*-.70 WHERE stat_type7 = 14 AND itemlevel = @itemlevel
  270. UPDATE item_template SET stat_value7 = stat_value7 + stat_value7*-.70 WHERE stat_type7 = 15 AND itemlevel = @itemlevel
  271. UPDATE item_template SET stat_value7 = stat_value7 + stat_value7*-.70 WHERE stat_type7 = 16 AND itemlevel = @itemlevel
  272. UPDATE item_template SET stat_value7 = stat_value7 + stat_value7*-.70 WHERE stat_type7 = 17 AND itemlevel = @itemlevel
  273. UPDATE item_template SET stat_value7 = stat_value7 + stat_value7*-.70 WHERE stat_type7 = 18 AND itemlevel = @itemlevel
  274. UPDATE item_template SET stat_value7 = stat_value7 + stat_value7*-.70 WHERE stat_type7 = 19 AND itemlevel = @itemlevel
  275. UPDATE item_template SET stat_value7 = stat_value7 + stat_value7*-.70 WHERE stat_type7 = 20 AND itemlevel = @itemlevel
  276. UPDATE item_template SET stat_value7 = stat_value7 + stat_value7*-.70 WHERE stat_type7 = 21 AND itemlevel = @itemlevel
  277. UPDATE item_template SET stat_value7 = stat_value7 + stat_value7*-.70 WHERE stat_type7 = 22 AND itemlevel = @itemlevel
  278. UPDATE item_template SET stat_value7 = stat_value7 + stat_value7*-.70 WHERE stat_type7 = 23 AND itemlevel = @itemlevel
  279. UPDATE item_template SET stat_value7 = stat_value7 + stat_value7*-.70 WHERE stat_type7 = 24 AND itemlevel = @itemlevel
  280. UPDATE item_template SET stat_value7 = stat_value7 + stat_value7*-.70 WHERE stat_type7 = 25 AND itemlevel = @itemlevel
  281. UPDATE item_template SET stat_value7 = stat_value7 + stat_value7*-.70 WHERE stat_type7 = 26 AND itemlevel = @itemlevel
  282. UPDATE item_template SET stat_value7 = stat_value7 + stat_value7*-.70 WHERE stat_type7 = 27 AND itemlevel = @itemlevel
  283. UPDATE item_template SET stat_value7 = stat_value7 + stat_value7*-.70 WHERE stat_type7 = 28 AND itemlevel = @itemlevel
  284. UPDATE item_template SET stat_value7 = stat_value7 + stat_value7*-.70 WHERE stat_type7 = 29 AND itemlevel = @itemlevel
  285. UPDATE item_template SET stat_value7 = stat_value7 + stat_value7*-.70 WHERE stat_type7 = 30 AND itemlevel = @itemlevel
  286. UPDATE item_template SET stat_value7 = stat_value7 + stat_value7*-.70 WHERE stat_type7 = 31 AND itemlevel = @itemlevel
  287. UPDATE item_template SET stat_value7 = stat_value7 + stat_value7*-.70 WHERE stat_type7 = 32 AND itemlevel = @itemlevel
  288. UPDATE item_template SET stat_value7 = stat_value7 + stat_value7*-.70 WHERE stat_type7 = 33 AND itemlevel = @itemlevel
  289. UPDATE item_template SET stat_value7 = stat_value7 + stat_value7*-.70 WHERE stat_type7 = 34 AND itemlevel = @itemlevel
  290. UPDATE item_template SET stat_value7 = stat_value7 + stat_value7*-.70 WHERE stat_type7 = 35 AND itemlevel = @itemlevel
  291. UPDATE item_template SET stat_value7 = stat_value7 + stat_value7*-.70 WHERE stat_type7 = 36 AND itemlevel = @itemlevel
  292. UPDATE item_template SET stat_value7 = stat_value7 + stat_value7*-.70 WHERE stat_type7 = 37 AND itemlevel = @itemlevel
  293. UPDATE item_template SET stat_value7 = stat_value7 + stat_value7*-.70 WHERE stat_type7 = 38 AND itemlevel = @itemlevel
  294. UPDATE item_template SET stat_value7 = stat_value7 + stat_value7*-.70 WHERE stat_type7 = 39 AND itemlevel = @itemlevel
  295. UPDATE item_template SET stat_value7 = stat_value7 + stat_value7*-.70 WHERE stat_type7 = 40 AND itemlevel = @itemlevel
  296. UPDATE item_template SET stat_value7 = stat_value7 + stat_value7*-.70 WHERE stat_type7 = 41 AND itemlevel = @itemlevel
  297. UPDATE item_template SET stat_value7 = stat_value7 + stat_value7*-.70 WHERE stat_type7 = 42 AND itemlevel = @itemlevel
  298. UPDATE item_template SET stat_value7 = stat_value7 + stat_value7*-.70 WHERE stat_type7 = 43 AND itemlevel = @itemlevel
  299. UPDATE item_template SET stat_value7 = stat_value7 + stat_value7*-.70 WHERE stat_type7 = 44 AND itemlevel = @itemlevel
  300. UPDATE item_template SET stat_value7 = stat_value7 + stat_value7*-.70 WHERE stat_type7 = 45 AND itemlevel = @itemlevel
  301. UPDATE item_template SET stat_value7 = stat_value7 + stat_value7*-.70 WHERE stat_type7 = 46 AND itemlevel = @itemlevel
  302. UPDATE item_template SET stat_value7 = stat_value7 + stat_value7*-.70 WHERE stat_type7 = 47 AND itemlevel = @itemlevel
  303. UPDATE item_template SET stat_value7 = stat_value7 + stat_value7*-.70 WHERE stat_type7 = 48 AND itemlevel = @itemlevel
  304. UPDATE item_template SET armor = armor + armor*-.70 WHERE itemlevel = @itemlevel
  305. UPDATE item_template SET dmg_min1 = dmg_min1 + dmg_min1*-.70 WHERE class = 2 AND itemlevel = @itemlevel
  306. UPDATE item_template SET dmg_max1 = dmg_max1 + dmg_max1*-.70 WHERE class = 2 AND itemlevel = @itemlevel
Add Comment
Please, Sign In to add comment
Public Pastes
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!