WoWCreador

Scale Items by Percentage

Apr 11th, 2020
174
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 34.75 KB | None | 0 0
  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