API tools faq
paste
Advertisement
Guest User

Mangos DB SQL mods

a guest
Oct 4th, 2010
122
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 47.74 KB | None | 0 0
raw download clone embed print report
  1. -- NPC increase to drop percentage for percentages between 0 and 1
  2.  
  3. UPDATE creature_loot_template
  4. SET ChanceOrQuestChance = (ChanceOrQuestChance * 3)
  5. WHERE ChanceOrQuestChance > '0' AND ChanceOrQuestChance < '1';
  6.  
  7. -- Money drops for creatures that do not drop money  
  8.  
  9. UPDATE `creature_template` SET `mingold`='1' , `maxgold`='2' WHERE `maxlevel`='1' AND `mingold`='0' AND `maxgold`='0';
  10. UPDATE `creature_template` SET `mingold`='1' , `maxgold`='2' WHERE `maxlevel`='2' AND `mingold`='0' AND `maxgold`='0';
  11. UPDATE `creature_template` SET `mingold`='1' , `maxgold`='3' WHERE `maxlevel`='3' AND `mingold`='0' AND `maxgold`='0';
  12. UPDATE `creature_template` SET `mingold`='1' , `maxgold`='4' WHERE `maxlevel`='4' AND `mingold`='0' AND `maxgold`='0';
  13. UPDATE `creature_template` SET `mingold`='2' , `maxgold`='5' WHERE `maxlevel`='5' AND `mingold`='0' AND `maxgold`='0';
  14. UPDATE `creature_template` SET `mingold`='3' , `maxgold`='5' WHERE `maxlevel`='6' AND `mingold`='0' AND `maxgold`='0';
  15. UPDATE `creature_template` SET `mingold`='3' , `maxgold`='6' WHERE `maxlevel`='7' AND `mingold`='0' AND `maxgold`='0';
  16. UPDATE `creature_template` SET `mingold`='3' , `maxgold`='6' WHERE `maxlevel`='8' AND `mingold`='0' AND `maxgold`='0';
  17. UPDATE `creature_template` SET `mingold`='4' , `maxgold`='7' WHERE `maxlevel`='9' AND `mingold`='0' AND `maxgold`='0';
  18. UPDATE `creature_template` SET `mingold`='5' , `maxgold`='8' WHERE `maxlevel`='10' AND `mingold`='0' AND `maxgold`='0';
  19. UPDATE `creature_template` SET `mingold`='5' , `maxgold`='10' WHERE `maxlevel`='11' AND `mingold`='0' AND `maxgold`='0';
  20. UPDATE `creature_template` SET `mingold`='6' , `maxgold`='10' WHERE `maxlevel`='12' AND `mingold`='0' AND `maxgold`='0';
  21. UPDATE `creature_template` SET `mingold`='6' , `maxgold`='11' WHERE `maxlevel`='13' AND `mingold`='0' AND `maxgold`='0';
  22. UPDATE `creature_template` SET `mingold`='7' , `maxgold`='12' WHERE `maxlevel`='14' AND `mingold`='0' AND `maxgold`='0';
  23. UPDATE `creature_template` SET `mingold`='8' , `maxgold`='13' WHERE `maxlevel`='15' AND `mingold`='0' AND `maxgold`='0';
  24. UPDATE `creature_template` SET `mingold`='8' , `maxgold`='14' WHERE `maxlevel`='16' AND `mingold`='0' AND `maxgold`='0';
  25. UPDATE `creature_template` SET `mingold`='9' , `maxgold`='14' WHERE `maxlevel`='17' AND `mingold`='0' AND `maxgold`='0';
  26. UPDATE `creature_template` SET `mingold`='10' , `maxgold`='15' WHERE `maxlevel`='18' AND `mingold`='0' AND `maxgold`='0';
  27. UPDATE `creature_template` SET `mingold`='10' , `maxgold`='16' WHERE `maxlevel`='19' AND `mingold`='0' AND `maxgold`='0';
  28. UPDATE `creature_template` SET `mingold`='11' , `maxgold`='17' WHERE `maxlevel`='20' AND `mingold`='0' AND `maxgold`='0';
  29. UPDATE `creature_template` SET `mingold`='12' , `maxgold`='17' WHERE `maxlevel`='21' AND `mingold`='0' AND `maxgold`='0';
  30. UPDATE `creature_template` SET `mingold`='13' , `maxgold`='18' WHERE `maxlevel`='22' AND `mingold`='0' AND `maxgold`='0';
  31. UPDATE `creature_template` SET `mingold`='13' , `maxgold`='20' WHERE `maxlevel`='23' AND `mingold`='0' AND `maxgold`='0';
  32. UPDATE `creature_template` SET `mingold`='14' , `maxgold`='21' WHERE `maxlevel`='24' AND `mingold`='0' AND `maxgold`='0';
  33. UPDATE `creature_template` SET `mingold`='15' , `maxgold`='22' WHERE `maxlevel`='25' AND `mingold`='0' AND `maxgold`='0';
  34. UPDATE `creature_template` SET `mingold`='16' , `maxgold`='23' WHERE `maxlevel`='26' AND `mingold`='0' AND `maxgold`='0';
  35. UPDATE `creature_template` SET `mingold`='17' , `maxgold`='25' WHERE `maxlevel`='27' AND `mingold`='0' AND `maxgold`='0';
  36. UPDATE `creature_template` SET `mingold`='17' , `maxgold`='25' WHERE `maxlevel`='28' AND `mingold`='0' AND `maxgold`='0';
  37. UPDATE `creature_template` SET `mingold`='18' , `maxgold`='26' WHERE `maxlevel`='29' AND `mingold`='0' AND `maxgold`='0';
  38. UPDATE `creature_template` SET `mingold`='19' , `maxgold`='27' WHERE `maxlevel`='30' AND `mingold`='0' AND `maxgold`='0';
  39. UPDATE `creature_template` SET `mingold`='20' , `maxgold`='28' WHERE `maxlevel`='31' AND `mingold`='0' AND `maxgold`='0';
  40. UPDATE `creature_template` SET `mingold`='21' , `maxgold`='30' WHERE `maxlevel`='32' AND `mingold`='0' AND `maxgold`='0';
  41. UPDATE `creature_template` SET `mingold`='22' , `maxgold`='31' WHERE `maxlevel`='33' AND `mingold`='0' AND `maxgold`='0';
  42. UPDATE `creature_template` SET `mingold`='23' , `maxgold`='32' WHERE `maxlevel`='34' AND `mingold`='0' AND `maxgold`='0';
  43. UPDATE `creature_template` SET `mingold`='24' , `maxgold`='33' WHERE `maxlevel`='35' AND `mingold`='0' AND `maxgold`='0';
  44. UPDATE `creature_template` SET `mingold`='25' , `maxgold`='35' WHERE `maxlevel`='36' AND `mingold`='0' AND `maxgold`='0';
  45. UPDATE `creature_template` SET `mingold`='25' , `maxgold`='35' WHERE `maxlevel`='37' AND `mingold`='0' AND `maxgold`='0';
  46. UPDATE `creature_template` SET `mingold`='26' , `maxgold`='36' WHERE `maxlevel`='38' AND `mingold`='0' AND `maxgold`='0';
  47. UPDATE `creature_template` SET `mingold`='27' , `maxgold`='37' WHERE `maxlevel`='39' AND `mingold`='0' AND `maxgold`='0';
  48. UPDATE `creature_template` SET `mingold`='28' , `maxgold`='38' WHERE `maxlevel`='40' AND `mingold`='0' AND `maxgold`='0';
  49. UPDATE `creature_template` SET `mingold`='29' , `maxgold`='40' WHERE `maxlevel`='41' AND `mingold`='0' AND `maxgold`='0';
  50. UPDATE `creature_template` SET `mingold`='30' , `maxgold`='41' WHERE `maxlevel`='42' AND `mingold`='0' AND `maxgold`='0';
  51. UPDATE `creature_template` SET `mingold`='31' , `maxgold`='42' WHERE `maxlevel`='43' AND `mingold`='0' AND `maxgold`='0';
  52. UPDATE `creature_template` SET `mingold`='32' , `maxgold`='44' WHERE `maxlevel`='44' AND `mingold`='0' AND `maxgold`='0';
  53. UPDATE `creature_template` SET `mingold`='33' , `maxgold`='46' WHERE `maxlevel`='45' AND `mingold`='0' AND `maxgold`='0';
  54. UPDATE `creature_template` SET `mingold`='34' , `maxgold`='47' WHERE `maxlevel`='46' AND `mingold`='0' AND `maxgold`='0';
  55. UPDATE `creature_template` SET `mingold`='35' , `maxgold`='50' WHERE `maxlevel`='47' AND `mingold`='0' AND `maxgold`='0';
  56. UPDATE `creature_template` SET `mingold`='37' , `maxgold`='51' WHERE `maxlevel`='48' AND `mingold`='0' AND `maxgold`='0';
  57. UPDATE `creature_template` SET `mingold`='41' , `maxgold`='52' WHERE `maxlevel`='49' AND `mingold`='0' AND `maxgold`='0';
  58. UPDATE `creature_template` SET `mingold`='42' , `maxgold`='55' WHERE `maxlevel`='50' AND `mingold`='0' AND `maxgold`='0';
  59. UPDATE `creature_template` SET `mingold`='45' , `maxgold`='60' WHERE `maxlevel`='51' AND `mingold`='0' AND `maxgold`='0';
  60. UPDATE `creature_template` SET `mingold`='46' , `maxgold`='62' WHERE `maxlevel`='52' AND `mingold`='0' AND `maxgold`='0';
  61. UPDATE `creature_template` SET `mingold`='48' , `maxgold`='64' WHERE `maxlevel`='53' AND `mingold`='0' AND `maxgold`='0';
  62. UPDATE `creature_template` SET `mingold`='49' , `maxgold`='66' WHERE `maxlevel`='54' AND `mingold`='0' AND `maxgold`='0';
  63. UPDATE `creature_template` SET `mingold`='50' , `maxgold`='68' WHERE `maxlevel`='55' AND `mingold`='0' AND `maxgold`='0';
  64. UPDATE `creature_template` SET `mingold`='51' , `maxgold`='70' WHERE `maxlevel`='56' AND `mingold`='0' AND `maxgold`='0';
  65. UPDATE `creature_template` SET `mingold`='52' , `maxgold`='70' WHERE `maxlevel`='57' AND `mingold`='0' AND `maxgold`='0';
  66. UPDATE `creature_template` SET `mingold`='53' , `maxgold`='71' WHERE `maxlevel`='58' AND `mingold`='0' AND `maxgold`='0';
  67. UPDATE `creature_template` SET `mingold`='54' , `maxgold`='72' WHERE `maxlevel`='59' AND `mingold`='0' AND `maxgold`='0';
  68. UPDATE `creature_template` SET `mingold`='55' , `maxgold`='75' WHERE `maxlevel`='60' AND `mingold`='0' AND `maxgold`='0';
  69. UPDATE `creature_template` SET `mingold`='63' , `maxgold`='85' WHERE `maxlevel`='61' AND `mingold`='0' AND `maxgold`='0';
  70. UPDATE `creature_template` SET `mingold`='72' , `maxgold`='95' WHERE `maxlevel`='62' AND `mingold`='0' AND `maxgold`='0';
  71. UPDATE `creature_template` SET `mingold`='83' , `maxgold`='110' WHERE `maxlevel`='63' AND `mingold`='0' AND `maxgold`='0';
  72. UPDATE `creature_template` SET `mingold`='86' , `maxgold`='120' WHERE `maxlevel`='64' AND `mingold`='0' AND `maxgold`='0';
  73. UPDATE `creature_template` SET `mingold`='90' , `maxgold`='130' WHERE `maxlevel`='65' AND `mingold`='0' AND `maxgold`='0';
  74. UPDATE `creature_template` SET `mingold`='105' , `maxgold`='140' WHERE `maxlevel`='66' AND `mingold`='0' AND `maxgold`='0';
  75. UPDATE `creature_template` SET `mingold`='118' , `maxgold`='150' WHERE `maxlevel`='67' AND `mingold`='0' AND `maxgold`='0';
  76. UPDATE `creature_template` SET `mingold`='129' , `maxgold`='160' WHERE `maxlevel`='68' AND `mingold`='0' AND `maxgold`='0';
  77. UPDATE `creature_template` SET `mingold`='142' , `maxgold`='170' WHERE `maxlevel`='69' AND `mingold`='0' AND `maxgold`='0';
  78. UPDATE `creature_template` SET `mingold`='152' , `maxgold`='180' WHERE `maxlevel`='70' AND `mingold`='0' AND `maxgold`='0';
  79. UPDATE `creature_template` SET `mingold`='163' , `maxgold`='190' WHERE `maxlevel`='71' AND `mingold`='0' AND `maxgold`='0';
  80. UPDATE `creature_template` SET `mingold`='172' , `maxgold`='200' WHERE `maxlevel`='72' AND `mingold`='0' AND `maxgold`='0';
  81. UPDATE `creature_template` SET `mingold`='180' , `maxgold`='210' WHERE `maxlevel`='73' AND `mingold`='0' AND `maxgold`='0';
  82. UPDATE `creature_template` SET `mingold`='190' , `maxgold`='220' WHERE `maxlevel`='74' AND `mingold`='0' AND `maxgold`='0';
  83. UPDATE `creature_template` SET `mingold`='200' , `maxgold`='230' WHERE `maxlevel`='75' AND `mingold`='0' AND `maxgold`='0';
  84. UPDATE `creature_template` SET `mingold`='210' , `maxgold`='240' WHERE `maxlevel`='76' AND `mingold`='0' AND `maxgold`='0';
  85. UPDATE `creature_template` SET `mingold`='220' , `maxgold`='250' WHERE `maxlevel`='77' AND `mingold`='0' AND `maxgold`='0';
  86. UPDATE `creature_template` SET `mingold`='230' , `maxgold`='260' WHERE `maxlevel`='78' AND `mingold`='0' AND `maxgold`='0';
  87. UPDATE `creature_template` SET `mingold`='240' , `maxgold`='270' WHERE `maxlevel`='79' AND `mingold`='0' AND `maxgold`='0';
  88. UPDATE `creature_template` SET `mingold`='250' , `maxgold`='280' WHERE `maxlevel`='80' AND `mingold`='0' AND `maxgold`='0';
  89. UPDATE `creature_template` SET `mingold`='260' , `maxgold`='290' WHERE `maxlevel`='81' AND `mingold`='0' AND `maxgold`='0';
  90. UPDATE `creature_template` SET `mingold`='270' , `maxgold`='300' WHERE `maxlevel`='82' AND `mingold`='0' AND `maxgold`='0';
  91. UPDATE `creature_template` SET `mingold`='280' , `maxgold`='310' WHERE `maxlevel`='83' AND `mingold`='0' AND `maxgold`='0';
  92.  
  93. -- All NPC's give honor points
  94.  
  95. UPDATE creature_template SET RacialLeader = '1' WHERE RacialLeader = '0';
  96.  
  97. -- Increase disenchant min and max resource drop rates
  98.  
  99. UPDATE disenchant_loot_template
  100. SET mincountOrRef = (mincountOrRef + 2)
  101. WHERE mincountOrRef > '0';
  102.  
  103. UPDATE disenchant_loot_template
  104. SET maxcount = (maxcount + 3)
  105. WHERE maxcount > '0';
  106.  
  107. -- Increase fishing min and max resource drop rates
  108.  
  109. UPDATE fishing_loot_template
  110. SET mincountOrRef = (mincountOrRef + 2)
  111. WHERE mincountOrRef > '0';
  112.  
  113. UPDATE fishing_loot_template
  114. SET maxcount = (maxcount + 3)
  115. WHERE maxcount > '0';
  116.  
  117. -- Increase drop rates on copper veins (1731)
  118.  
  119. UPDATE `gameobject_loot_template`
  120. SET `mincountOrRef` = (`mincountOrRef` + 2)
  121. WHERE (`entry`=1731);
  122.  
  123. UPDATE `gameobject_loot_template`
  124. SET `maxcount` = (`maxcount` + 4)
  125. WHERE (`entry`=1731);
  126.  
  127. -- Increase drop rates on gold veins (1734)
  128.  
  129. UPDATE `gameobject_loot_template`
  130. SET `mincountOrRef` = (`mincountOrRef` + 2)
  131. WHERE (`entry`=1734);
  132.  
  133. UPDATE `gameobject_loot_template`
  134. SET `maxcount` = (`maxcount` + 4)
  135. WHERE (`entry`=1734);
  136.  
  137. -- Increase drop rates on khorium veins (181557)
  138.  
  139. UPDATE `gameobject_loot_template`
  140. SET `mincountOrRef` = (`mincountOrRef` + 2)
  141. WHERE (`entry`=181557);
  142.  
  143. UPDATE `gameobject_loot_template`
  144. SET `maxcount` = (`maxcount` + 4)
  145. WHERE (`entry`=181557);
  146.  
  147. -- Increase drop rates on rich thorium veins (175404)
  148.  
  149. UPDATE `gameobject_loot_template`
  150. SET `mincountOrRef` = (`mincountOrRef` + 2)
  151. WHERE (`entry`=175404);
  152.  
  153. UPDATE `gameobject_loot_template`
  154. SET `maxcount` = (`maxcount` + 4)
  155. WHERE (`entry`=175404);
  156.  
  157. -- Increase drop rates on silver veins (1733)
  158.  
  159. UPDATE `gameobject_loot_template`
  160. SET `mincountOrRef` = (`mincountOrRef` + 2)
  161. WHERE (`entry`=1733);
  162.  
  163. UPDATE `gameobject_loot_template`
  164. SET `maxcount` = (`maxcount` + 4)
  165. WHERE (`entry`=1733);
  166.  
  167. -- Increase drop rates on tin veins (1732)
  168.  
  169. UPDATE `gameobject_loot_template`
  170. SET `mincountOrRef` = (`mincountOrRef` + 2)
  171. WHERE (`entry`=1732);
  172.  
  173. UPDATE `gameobject_loot_template`
  174. SET `maxcount` = (`maxcount` + 4)
  175. WHERE (`entry`=1732);
  176.  
  177. -- Increase drop rates on titanium veins (191133)
  178.  
  179. UPDATE `gameobject_loot_template`
  180. SET `mincountOrRef` = (`mincountOrRef` + 2)
  181. WHERE (`entry`=191133);
  182.  
  183. UPDATE `gameobject_loot_template`
  184. SET `maxcount` = (`maxcount` + 4)
  185. WHERE (`entry`=191133);
  186.  
  187. -- Increase drop rates on small thorium veins (324)
  188.  
  189. UPDATE `gameobject_loot_template`
  190. SET `mincountOrRef` = (`mincountOrRef` + 2)
  191. WHERE (`entry`=324);
  192.  
  193. UPDATE `gameobject_loot_template`
  194. SET `maxcount` = (`maxcount` + 4)
  195. WHERE (`entry`=324);
  196.  
  197. -- Increase drop rates on iron deposits (1735)
  198.  
  199. UPDATE `gameobject_loot_template`
  200. SET `mincountOrRef` = (`mincountOrRef` + 2)
  201. WHERE (`entry`=1735);
  202.  
  203. UPDATE `gameobject_loot_template`
  204. SET `maxcount` = (`maxcount` + 4)
  205. WHERE (`entry`=1735);
  206.  
  207. -- Increase drop rates on saronite deposits (189980)
  208.  
  209. UPDATE `gameobject_loot_template`
  210. SET `mincountOrRef` = (`mincountOrRef` + 2)
  211. WHERE (`entry`=189980);
  212.  
  213. UPDATE `gameobject_loot_template`
  214. SET `maxcount` = (`maxcount` + 4)
  215. WHERE (`entry`=189980);
  216.  
  217. -- Increase drop rates on rich saronite deposits (189981)
  218.  
  219. UPDATE `gameobject_loot_template`
  220. SET `mincountOrRef` = (`mincountOrRef` + 2)
  221. WHERE (`entry`=189981);
  222.  
  223. UPDATE `gameobject_loot_template`
  224. SET `maxcount` = (`maxcount` + 4)
  225. WHERE (`entry`=189981);
  226.  
  227. -- Increase drop rates on mithril deposits (2040)
  228.  
  229. UPDATE `gameobject_loot_template`
  230. SET `mincountOrRef` = (`mincountOrRef` + 2)
  231. WHERE (`entry`=2040);
  232.  
  233. UPDATE `gameobject_loot_template`
  234. SET `maxcount` = (`maxcount` + 4)
  235. WHERE (`entry`=2040);
  236.  
  237. -- Increase drop rates on truesilver deposits (2047)
  238.  
  239. UPDATE `gameobject_loot_template`
  240. SET `mincountOrRef` = (`mincountOrRef` + 2)
  241. WHERE (`entry`=2047);
  242.  
  243. UPDATE `gameobject_loot_template`
  244. SET `maxcount` = (`maxcount` + 4)
  245. WHERE (`entry`=2047);
  246.  
  247. -- Increase drop rates on adamantite deposits (181556)
  248.  
  249. UPDATE `gameobject_loot_template`
  250. SET `mincountOrRef` = (`mincountOrRef` + 2)
  251. WHERE (`entry`=181556);
  252.  
  253. UPDATE `gameobject_loot_template`
  254. SET `maxcount` = (`maxcount` + 4)
  255. WHERE (`entry`=181556);
  256.  
  257. -- Increase drop rates on fel iron deposits (181555)
  258.  
  259. UPDATE `gameobject_loot_template`
  260. SET `mincountOrRef` = (`mincountOrRef` + 2)
  261. WHERE (`entry`=181555);
  262.  
  263. UPDATE `gameobject_loot_template`
  264. SET `maxcount` = (`maxcount` + 4)
  265. WHERE (`entry`=181555);
  266.  
  267. -- Increase drop rates on rich adamantite deposits (181569)
  268.  
  269. UPDATE `gameobject_loot_template`
  270. SET `mincountOrRef` = (`mincountOrRef` + 2)
  271. WHERE (`entry`=181569);
  272.  
  273. UPDATE `gameobject_loot_template`
  274. SET `maxcount` = (`maxcount` + 4)
  275. WHERE (`entry`=181569);
  276.  
  277. -- Increase drop rates on cobalt deposits (189978)
  278.  
  279. UPDATE `gameobject_loot_template`
  280. SET `mincountOrRef` = (`mincountOrRef` + 2)
  281. WHERE (`entry`=189978);
  282.  
  283. UPDATE `gameobject_loot_template`
  284. SET `maxcount` = (`maxcount` + 4)
  285. WHERE (`entry`=189978);
  286.  
  287. -- Increase drop rates on rich cobalt deposits (189979)
  288.  
  289. UPDATE `gameobject_loot_template`
  290. SET `mincountOrRef` = (`mincountOrRef` + 2)
  291. WHERE (`entry`=189979);
  292.  
  293. UPDATE `gameobject_loot_template`
  294. SET `maxcount` = (`maxcount` + 4)
  295. WHERE (`entry`=189979);
  296.  
  297. -- Increase drop rates on ooze covered truesilver deposits (123309)
  298.  
  299. UPDATE `gameobject_loot_template`
  300. SET `mincountOrRef` = (`mincountOrRef` + 2)
  301. WHERE (`entry`=123309);
  302.  
  303. UPDATE `gameobject_loot_template`
  304. SET `maxcount` = (`maxcount` + 4)
  305. WHERE (`entry`=123309);
  306.  
  307. -- Increase drop rates on dark iron deposits (165658)
  308.  
  309. UPDATE `gameobject_loot_template`
  310. SET `mincountOrRef` = (`mincountOrRef` + 2)
  311. WHERE (`entry`=165658);
  312.  
  313. UPDATE `gameobject_loot_template`
  314. SET `maxcount` = (`maxcount` + 4)
  315. WHERE (`entry`=165658);
  316.  
  317. -- Increase drop rates on ooze covered gold veins (73941)
  318.  
  319. UPDATE `gameobject_loot_template`
  320. SET `mincountOrRef` = (`mincountOrRef` + 2)
  321. WHERE (`entry`=73941);
  322.  
  323. UPDATE `gameobject_loot_template`
  324. SET `maxcount` = (`maxcount` + 4)
  325. WHERE (`entry`=73941);
  326.  
  327. -- Increase drop rates on ooze covered iron deposits (73939)
  328.  
  329. UPDATE `gameobject_loot_template`
  330. SET `mincountOrRef` = (`mincountOrRef` + 2)
  331. WHERE (`entry`=73939);
  332.  
  333. UPDATE `gameobject_loot_template`
  334. SET `maxcount` = (`maxcount` + 4)
  335. WHERE (`entry`=73939);
  336.  
  337. -- Increase drop rates on ooze covered mithril deposits (123310)
  338.  
  339. UPDATE `gameobject_loot_template`
  340. SET `mincountOrRef` = (`mincountOrRef` + 2)
  341. WHERE (`entry`=123310);
  342.  
  343. UPDATE `gameobject_loot_template`
  344. SET `maxcount` = (`maxcount` + 4)
  345. WHERE (`entry`=123310);
  346.  
  347. -- Increase drop rates on ooze covered rich thorium veins (177388)
  348.  
  349. UPDATE `gameobject_loot_template`
  350. SET `mincountOrRef` = (`mincountOrRef` + 2)
  351. WHERE (`entry`=177388);
  352.  
  353. UPDATE `gameobject_loot_template`
  354. SET `maxcount` = (`maxcount` + 4)
  355. WHERE (`entry`=177388);
  356.  
  357. -- Increase drop rates on ooze covered silver veins (73940)
  358.  
  359. UPDATE `gameobject_loot_template`
  360. SET `mincountOrRef` = (`mincountOrRef` + 2)
  361. WHERE (`entry`=73940);
  362.  
  363. UPDATE `gameobject_loot_template`
  364. SET `maxcount` = (`maxcount` + 4)
  365. WHERE (`entry`=73940);
  366.  
  367. -- Increase drop rates on ooze covered thorium veins (123848)
  368.  
  369. UPDATE `gameobject_loot_template`
  370. SET `mincountOrRef` = (`mincountOrRef` + 2)
  371. WHERE (`entry`=123848);
  372.  
  373. UPDATE `gameobject_loot_template`
  374. SET `maxcount` = (`maxcount` + 4)
  375. WHERE (`entry`=123848);
  376.  
  377. -- Increase drop rates on hakkari thorium veins (180215)
  378.  
  379. UPDATE `gameobject_loot_template`
  380. SET `mincountOrRef` = (`mincountOrRef` + 2)
  381. WHERE (`entry`=180215);
  382.  
  383. UPDATE `gameobject_loot_template`
  384. SET `maxcount` = (`maxcount` + 4)
  385. WHERE (`entry`=180215);
  386.  
  387. -- Increase drop rates on incendicite mineral veins (1610)
  388.  
  389. UPDATE `gameobject_loot_template`
  390. SET `mincountOrRef` = (`mincountOrRef` + 2)
  391. WHERE (`entry`=1610);
  392.  
  393. UPDATE `gameobject_loot_template`
  394. SET `maxcount` = (`maxcount` + 4)
  395. WHERE (`entry`=1610);
  396.  
  397. -- Increase drop rates on nethercite deposits (185877)
  398.  
  399. UPDATE `gameobject_loot_template`
  400. SET `mincountOrRef` = (`mincountOrRef` + 2)
  401. WHERE (`entry`=185877);
  402.  
  403. UPDATE `gameobject_loot_template`
  404. SET `maxcount` = (`maxcount` + 4)
  405. WHERE (`entry`=185877);
  406.  
  407. -- Increase drop rates on lesser bloodstone deposits (2653)
  408.  
  409. UPDATE `gameobject_loot_template`
  410. SET `mincountOrRef` = (`mincountOrRef` + 2)
  411. WHERE (`entry`=2653);
  412.  
  413. UPDATE `gameobject_loot_template`
  414. SET `maxcount` = (`maxcount` + 4)
  415. WHERE (`entry`=2653);
  416.  
  417. -- Increase drop rates on pure saronite deposits (195036)
  418.  
  419. UPDATE `gameobject_loot_template`
  420. SET `mincountOrRef` = (`mincountOrRef` + 2)
  421. WHERE (`entry`=195036);
  422.  
  423. UPDATE `gameobject_loot_template`
  424. SET `maxcount` = (`maxcount` + 4)
  425. WHERE (`entry`=195036);
  426.  
  427. -- Increase drop rates on ancient gem vein (185557)
  428.  
  429. UPDATE `gameobject_loot_template`
  430. SET `mincountOrRef` = (`mincountOrRef` + 2)
  431. WHERE (`entry`=185557);
  432.  
  433. UPDATE `gameobject_loot_template`
  434. SET `maxcount` = (`maxcount` + 4)
  435. WHERE (`entry`=185557);
  436.  
  437. -- Increase drop rates on indurium mineral veins (19903)
  438.  
  439. UPDATE `gameobject_loot_template`
  440. SET `mincountOrRef` = (`mincountOrRef` + 2)
  441. WHERE (`entry`=19903);
  442.  
  443. UPDATE `gameobject_loot_template`
  444. SET `maxcount` = (`maxcount` + 4)
  445. WHERE (`entry`=19903);
  446.  
  447. -- Increase drop rates on silverleaf herbs (1617)
  448.  
  449. UPDATE `gameobject_loot_template`
  450. SET `mincountOrRef` = (`mincountOrRef` + 2)
  451. WHERE (`entry`=1617);
  452.  
  453. UPDATE `gameobject_loot_template`
  454. SET `maxcount` = (`maxcount` + 4)
  455. WHERE (`entry`=1617);
  456.  
  457. -- Increase drop rates on peacebloom herbs (1618)
  458.  
  459. UPDATE `gameobject_loot_template`
  460. SET `mincountOrRef` = (`mincountOrRef` + 2)
  461. WHERE (`entry`=1618);
  462.  
  463. UPDATE `gameobject_loot_template`
  464. SET `maxcount` = (`maxcount` + 4)
  465. WHERE (`entry`=1618);
  466.  
  467. -- Increase drop rates on felweed herbs (181270)
  468.  
  469. UPDATE `gameobject_loot_template`
  470. SET `mincountOrRef` = (`mincountOrRef` + 2)
  471. WHERE (`entry`=181270);
  472.  
  473. UPDATE `gameobject_loot_template`
  474. SET `maxcount` = (`maxcount` + 4)
  475. WHERE (`entry`=181270);
  476.  
  477. -- Increase drop rates on icethorn herbs (190172)
  478.  
  479. UPDATE `gameobject_loot_template`
  480. SET `mincountOrRef` = (`mincountOrRef` + 2)
  481. WHERE (`entry`=190172);
  482.  
  483. UPDATE `gameobject_loot_template`
  484. SET `maxcount` = (`maxcount` + 4)
  485. WHERE (`entry`=190172);
  486.  
  487. -- Increase drop rates on lichbloom herbs (190171)
  488.  
  489. UPDATE `gameobject_loot_template`
  490. SET `mincountOrRef` = (`mincountOrRef` + 2)
  491. WHERE (`entry`=190171);
  492.  
  493. UPDATE `gameobject_loot_template`
  494. SET `maxcount` = (`maxcount` + 4)
  495. WHERE (`entry`=190171);
  496.  
  497. -- Increase drop rates on earthroot herbs (1619)
  498.  
  499. UPDATE `gameobject_loot_template`
  500. SET `mincountOrRef` = (`mincountOrRef` + 2)
  501. WHERE (`entry`=1619);
  502.  
  503. UPDATE `gameobject_loot_template`
  504. SET `maxcount` = (`maxcount` + 4)
  505. WHERE (`entry`=1619);
  506.  
  507. -- Increase drop rates on briathorn herbs (1621)
  508.  
  509. UPDATE `gameobject_loot_template`
  510. SET `mincountOrRef` = (`mincountOrRef` + 2)
  511. WHERE (`entry`=1621);
  512.  
  513. UPDATE `gameobject_loot_template`
  514. SET `maxcount` = (`maxcount` + 4)
  515. WHERE (`entry`=1621);
  516.  
  517. -- Increase drop rates on mageroyal herbs (1620)
  518.  
  519. UPDATE `gameobject_loot_template`
  520. SET `mincountOrRef` = (`mincountOrRef` + 2)
  521. WHERE (`entry`=1620);
  522.  
  523. UPDATE `gameobject_loot_template`
  524. SET `maxcount` = (`maxcount` + 4)
  525. WHERE (`entry`=1620);
  526.  
  527. -- Increase drop rates on bruiseweed herbs (1622)
  528.  
  529. UPDATE `gameobject_loot_template`
  530. SET `mincountOrRef` = (`mincountOrRef` + 2)
  531. WHERE (`entry`=1622);
  532.  
  533. UPDATE `gameobject_loot_template`
  534. SET `maxcount` = (`maxcount` + 4)
  535. WHERE (`entry`=1622);
  536.  
  537. -- Increase drop rates on kingblood herbs (1624)
  538.  
  539. UPDATE `gameobject_loot_template`
  540. SET `mincountOrRef` = (`mincountOrRef` + 2)
  541. WHERE (`entry`=1624);
  542.  
  543. UPDATE `gameobject_loot_template`
  544. SET `maxcount` = (`maxcount` + 4)
  545. WHERE (`entry`=1624);
  546.  
  547. -- Increase drop rates on dreaming glory herbs (181271)
  548.  
  549. UPDATE `gameobject_loot_template`
  550. SET `mincountOrRef` = (`mincountOrRef` + 2)
  551. WHERE (`entry`=181271);
  552.  
  553. UPDATE `gameobject_loot_template`
  554. SET `maxcount` = (`maxcount` + 4)
  555. WHERE (`entry`=181271);
  556.  
  557. -- Increase drop rates on goldclover herbs (189973)
  558.  
  559. UPDATE `gameobject_loot_template`
  560. SET `mincountOrRef` = (`mincountOrRef` + 2)
  561. WHERE (`entry`=189973);
  562.  
  563. UPDATE `gameobject_loot_template`
  564. SET `maxcount` = (`maxcount` + 4)
  565. WHERE (`entry`=189973);
  566.  
  567. -- Increase drop rates on frozen herbs (190173)
  568.  
  569. UPDATE `gameobject_loot_template`
  570. SET `mincountOrRef` = (`mincountOrRef` + 2)
  571. WHERE (`entry`=190173);
  572.  
  573. UPDATE `gameobject_loot_template`
  574. SET `maxcount` = (`maxcount` + 4)
  575. WHERE (`entry`=190173);
  576.  
  577. -- Increase drop rates on goldthorn herbs (2046)
  578.  
  579. UPDATE `gameobject_loot_template`
  580. SET `mincountOrRef` = (`mincountOrRef` + 2)
  581. WHERE (`entry`=2046);
  582.  
  583. UPDATE `gameobject_loot_template`
  584. SET `maxcount` = (`maxcount` + 4)
  585. WHERE (`entry`=2046);
  586.  
  587. -- Increase drop rates on wild steelbloom herbs (1623)
  588.  
  589. UPDATE `gameobject_loot_template`
  590. SET `mincountOrRef` = (`mincountOrRef` + 2)
  591. WHERE (`entry`=1623);
  592.  
  593. UPDATE `gameobject_loot_template`
  594. SET `maxcount` = (`maxcount` + 4)
  595. WHERE (`entry`=1623);
  596.  
  597. -- Increase drop rates on sungrass herbs (142142)
  598.  
  599. UPDATE `gameobject_loot_template`
  600. SET `mincountOrRef` = (`mincountOrRef` + 2)
  601. WHERE (`entry`=142142);
  602.  
  603. UPDATE `gameobject_loot_template`
  604. SET `maxcount` = (`maxcount` + 4)
  605. WHERE (`entry`=142142);
  606.  
  607. -- Increase drop rates on khadgars whisker herbs (2043)
  608.  
  609. UPDATE `gameobject_loot_template`
  610. SET `mincountOrRef` = (`mincountOrRef` + 2)
  611. WHERE (`entry`=2043);
  612.  
  613. UPDATE `gameobject_loot_template`
  614. SET `maxcount` = (`maxcount` + 4)
  615. WHERE (`entry`=2043);
  616.  
  617. -- Increase drop rates on dreamfoil herbs (176584)
  618.  
  619. UPDATE `gameobject_loot_template`
  620. SET `mincountOrRef` = (`mincountOrRef` + 2)
  621. WHERE (`entry`=176584);
  622.  
  623. UPDATE `gameobject_loot_template`
  624. SET `maxcount` = (`maxcount` + 4)
  625. WHERE (`entry`=176584);
  626.  
  627. -- Increase drop rates on liferoot herbs (2041)
  628.  
  629. UPDATE `gameobject_loot_template`
  630. SET `mincountOrRef` = (`mincountOrRef` + 2)
  631. WHERE (`entry`=2041);
  632.  
  633. UPDATE `gameobject_loot_template`
  634. SET `maxcount` = (`maxcount` + 4)
  635. WHERE (`entry`=2041);
  636.  
  637. -- Increase drop rates on strangekelp herbs (2045)
  638.  
  639. UPDATE `gameobject_loot_template`
  640. SET `mincountOrRef` = (`mincountOrRef` + 2)
  641. WHERE (`entry`=2045);
  642.  
  643. UPDATE `gameobject_loot_template`
  644. SET `maxcount` = (`maxcount` + 4)
  645. WHERE (`entry`=2045);
  646.  
  647. -- Increase drop rates on golden sansam herbs (176583)
  648.  
  649. UPDATE `gameobject_loot_template`
  650. SET `mincountOrRef` = (`mincountOrRef` + 2)
  651. WHERE (`entry`=176583);
  652.  
  653. UPDATE `gameobject_loot_template`
  654. SET `maxcount` = (`maxcount` + 4)
  655. WHERE (`entry`=176583);
  656.  
  657. -- Increase drop rates on mountain silversage herbs (176586)
  658.  
  659. UPDATE `gameobject_loot_template`
  660. SET `mincountOrRef` = (`mincountOrRef` + 2)
  661. WHERE (`entry`=176586);
  662.  
  663. UPDATE `gameobject_loot_template`
  664. SET `maxcount` = (`maxcount` + 4)
  665. WHERE (`entry`=176586);
  666.  
  667. -- Increase drop rates on purple lotus herbs (142140)
  668.  
  669. UPDATE `gameobject_loot_template`
  670. SET `mincountOrRef` = (`mincountOrRef` + 2)
  671. WHERE (`entry`=142140);
  672.  
  673. UPDATE `gameobject_loot_template`
  674. SET `maxcount` = (`maxcount` + 4)
  675. WHERE (`entry`=142140);
  676.  
  677. -- Increase drop rates on plaguebloom herbs (176587)
  678.  
  679. UPDATE `gameobject_loot_template`
  680. SET `mincountOrRef` = (`mincountOrRef` + 2)
  681. WHERE (`entry`=176587);
  682.  
  683. UPDATE `gameobject_loot_template`
  684. SET `maxcount` = (`maxcount` + 4)
  685. WHERE (`entry`=176587);
  686.  
  687. -- Increase drop rates on blindweed herbs (142143)
  688.  
  689. UPDATE `gameobject_loot_template`
  690. SET `mincountOrRef` = (`mincountOrRef` + 2)
  691. WHERE (`entry`=142143);
  692.  
  693. UPDATE `gameobject_loot_template`
  694. SET `maxcount` = (`maxcount` + 4)
  695. WHERE (`entry`=142143);
  696.  
  697. -- Increase drop rates on firebloom herbs (2866)
  698.  
  699. UPDATE `gameobject_loot_template`
  700. SET `mincountOrRef` = (`mincountOrRef` + 2)
  701. WHERE (`entry`=2866);
  702.  
  703. UPDATE `gameobject_loot_template`
  704. SET `maxcount` = (`maxcount` + 4)
  705. WHERE (`entry`=2866);
  706.  
  707. -- Increase drop rates on tiger lily herbs (190169)
  708.  
  709. UPDATE `gameobject_loot_template`
  710. SET `mincountOrRef` = (`mincountOrRef` + 2)
  711. WHERE (`entry`=190169);
  712.  
  713. UPDATE `gameobject_loot_template`
  714. SET `maxcount` = (`maxcount` + 4)
  715. WHERE (`entry`=190169);
  716.  
  717. -- Increase drop rates on flame cap herbs (181276)
  718.  
  719. UPDATE `gameobject_loot_template`
  720. SET `mincountOrRef` = (`mincountOrRef` + 2)
  721. WHERE (`entry`=181276);
  722.  
  723. UPDATE `gameobject_loot_template`
  724. SET `maxcount` = (`maxcount` + 4)
  725. WHERE (`entry`=181276);
  726.  
  727. -- Increase drop rates on ragveil herbs (181275)
  728.  
  729. UPDATE `gameobject_loot_template`
  730. SET `mincountOrRef` = (`mincountOrRef` + 2)
  731. WHERE (`entry`=181275);
  732.  
  733. UPDATE `gameobject_loot_template`
  734. SET `maxcount` = (`maxcount` + 4)
  735. WHERE (`entry`=181275);
  736.  
  737. -- Increase drop rates on fadeleaf herbs (2042)
  738.  
  739. UPDATE `gameobject_loot_template`
  740. SET `mincountOrRef` = (`mincountOrRef` + 2)
  741. WHERE (`entry`=2042);
  742.  
  743. UPDATE `gameobject_loot_template`
  744. SET `maxcount` = (`maxcount` + 4)
  745. WHERE (`entry`=2042);
  746.  
  747. -- Increase drop rates on adder's tongue herbs (191019)
  748.  
  749. UPDATE `gameobject_loot_template`
  750. SET `mincountOrRef` = (`mincountOrRef` + 2)
  751. WHERE (`entry`=191019);
  752.  
  753. UPDATE `gameobject_loot_template`
  754. SET `maxcount` = (`maxcount` + 4)
  755. WHERE (`entry`=191019);
  756.  
  757. -- Increase drop rates on icecap herbs (176588)
  758.  
  759. UPDATE `gameobject_loot_template`
  760. SET `mincountOrRef` = (`mincountOrRef` + 2)
  761. WHERE (`entry`=176588);
  762.  
  763. UPDATE `gameobject_loot_template`
  764. SET `maxcount` = (`maxcount` + 4)
  765. WHERE (`entry`=176588);
  766.  
  767. -- Increase drop rates on bogblossom herbs (185497)
  768.  
  769. UPDATE `gameobject_loot_template`
  770. SET `mincountOrRef` = (`mincountOrRef` + 2)
  771. WHERE (`entry`=185497);
  772.  
  773. UPDATE `gameobject_loot_template`
  774. SET `maxcount` = (`maxcount` + 4)
  775. WHERE (`entry`=185497);
  776.  
  777. -- Increase drop rates on terocone herbs (181277)
  778.  
  779. UPDATE `gameobject_loot_template`
  780. SET `mincountOrRef` = (`mincountOrRef` + 2)
  781. WHERE (`entry`=181277);
  782.  
  783. UPDATE `gameobject_loot_template`
  784. SET `maxcount` = (`maxcount` + 4)
  785. WHERE (`entry`=181277);
  786.  
  787. -- Increase drop rates on netherbloom herbs (181279)
  788.  
  789. UPDATE `gameobject_loot_template`
  790. SET `mincountOrRef` = (`mincountOrRef` + 2)
  791. WHERE (`entry`=181279);
  792.  
  793. UPDATE `gameobject_loot_template`
  794. SET `maxcount` = (`maxcount` + 4)
  795. WHERE (`entry`=181279);
  796.  
  797. -- Increase drop rates on nightmare vine herbs (181280)
  798.  
  799. UPDATE `gameobject_loot_template`
  800. SET `mincountOrRef` = (`mincountOrRef` + 2)
  801. WHERE (`entry`=181280);
  802.  
  803. UPDATE `gameobject_loot_template`
  804. SET `maxcount` = (`maxcount` + 4)
  805. WHERE (`entry`=181280);
  806.  
  807. -- Increase drop rates on talandra's rose herbs (190170)
  808.  
  809. UPDATE `gameobject_loot_template`
  810. SET `mincountOrRef` = (`mincountOrRef` + 2)
  811. WHERE (`entry`=190170);
  812.  
  813. UPDATE `gameobject_loot_template`
  814. SET `maxcount` = (`maxcount` + 4)
  815. WHERE (`entry`=190170);
  816.  
  817. -- Increase drop rates on arthas's tears herbs (142141)
  818.  
  819. UPDATE `gameobject_loot_template`
  820. SET `mincountOrRef` = (`mincountOrRef` + 2)
  821. WHERE (`entry`=142141);
  822.  
  823. UPDATE `gameobject_loot_template`
  824. SET `maxcount` = (`maxcount` + 4)
  825. WHERE (`entry`=142141);
  826.  
  827. -- Increase drop rates on frost lotus herbs (190176)
  828.  
  829. UPDATE `gameobject_loot_template`
  830. SET `mincountOrRef` = (`mincountOrRef` + 2)
  831. WHERE (`entry`=190176);
  832.  
  833. UPDATE `gameobject_loot_template`
  834. SET `maxcount` = (`maxcount` + 4)
  835. WHERE (`entry`=190176);
  836.  
  837. -- Increase drop rates on bloodpetal sprout herbs (164958)
  838.  
  839. UPDATE `gameobject_loot_template`
  840. SET `mincountOrRef` = (`mincountOrRef` + 2)
  841. WHERE (`entry`=164958);
  842.  
  843. UPDATE `gameobject_loot_template`
  844. SET `maxcount` = (`maxcount` + 4)
  845. WHERE (`entry`=164958);
  846.  
  847. -- Increase drop rates on gromsblood sprout herbs (142145)
  848.  
  849. UPDATE `gameobject_loot_template`
  850. SET `mincountOrRef` = (`mincountOrRef` + 2)
  851. WHERE (`entry`=142145);
  852.  
  853. UPDATE `gameobject_loot_template`
  854. SET `maxcount` = (`maxcount` + 4)
  855. WHERE (`entry`=142145);
  856.  
  857. -- Increase drop rates on bloodthistle sprout herbs (181166)
  858.  
  859. UPDATE `gameobject_loot_template`
  860. SET `mincountOrRef` = (`mincountOrRef` + 2)
  861. WHERE (`entry`=181166);
  862.  
  863. UPDATE `gameobject_loot_template`
  864. SET `maxcount` = (`maxcount` + 4)
  865. WHERE (`entry`=181166);
  866.  
  867. -- Increase drop rates on netherdust bush sprout herbs (185881)
  868.  
  869. UPDATE `gameobject_loot_template`
  870. SET `mincountOrRef` = (`mincountOrRef` + 2)
  871. WHERE (`entry`=185881);
  872.  
  873. UPDATE `gameobject_loot_template`
  874. SET `maxcount` = (`maxcount` + 4)
  875. WHERE (`entry`=185881);
  876.  
  877. -- Increase drop rates on black lotus herbs (176589)
  878.  
  879. UPDATE `gameobject_loot_template`
  880. SET `mincountOrRef` = (`mincountOrRef` + 2)
  881. WHERE (`entry`=176589);
  882.  
  883. UPDATE `gameobject_loot_template`
  884. SET `maxcount` = (`maxcount` + 4)
  885. WHERE (`entry`=176589);
  886.  
  887. -- Increase drop rates on firethorn herbs (191303)
  888.  
  889. UPDATE `gameobject_loot_template`
  890. SET `mincountOrRef` = (`mincountOrRef` + 2)
  891. WHERE (`entry`=191303);
  892.  
  893. UPDATE `gameobject_loot_template`
  894. SET `maxcount` = (`maxcount` + 4)
  895. WHERE (`entry`=191303);
  896.  
  897. -- Increase drop rates on wintersbite herbs (2044)
  898.  
  899. UPDATE `gameobject_loot_template`
  900. SET `mincountOrRef` = (`mincountOrRef` + 2)
  901. WHERE (`entry`=2044);
  902.  
  903. UPDATE `gameobject_loot_template`
  904. SET `maxcount` = (`maxcount` + 4)
  905. WHERE (`entry`=2044);
  906.  
  907. -- Soul Shards stack in groups of 50 up to 500 in inventory
  908.  
  909. UPDATE `item_template` SET `maxcount` = 500 WHERE `entry` = 6265;
  910. UPDATE `item_template` SET `stackable` = 50 WHERE `entry` = 6265;
  911.  
  912. -- Adds 4 slots to all bags that originally started with 28 or less
  913.  
  914. UPDATE `item_template` SET `ContainerSlots`='32' WHERE `ContainerSlots`='28';
  915. UPDATE `item_template` SET `ContainerSlots`='28' WHERE `ContainerSlots`='24';
  916. UPDATE `item_template` SET `ContainerSlots`='26' WHERE `ContainerSlots`='22';
  917. UPDATE `item_template` SET `ContainerSlots`='24' WHERE `ContainerSlots`='20';
  918. UPDATE `item_template` SET `ContainerSlots`='22' WHERE `ContainerSlots`='18';
  919. UPDATE `item_template` SET `ContainerSlots`='20' WHERE `ContainerSlots`='16';
  920. UPDATE `item_template` SET `ContainerSlots`='18' WHERE `ContainerSlots`='14';
  921. UPDATE `item_template` SET `ContainerSlots`='16' WHERE `ContainerSlots`='12';
  922. UPDATE `item_template` SET `ContainerSlots`='14' WHERE `ContainerSlots`='10';
  923. UPDATE `item_template` SET `ContainerSlots`='12' WHERE `ContainerSlots`='8';
  924. UPDATE `item_template` SET `ContainerSlots`='10' WHERE `ContainerSlots`='6';
  925. UPDATE `item_template` SET `ContainerSlots`='8' WHERE `ContainerSlots`='4';
  926.  
  927. -- Increase all armor by 10%
  928.  
  929. UPDATE `item_template` SET `armor` = (armor + (armor * .10));
  930.  
  931. -- Increase milling min and max resource drop rates
  932.  
  933. UPDATE milling_loot_template
  934. SET mincountOrRef = (mincountOrRef + 3)
  935. WHERE mincountOrRef > '0';
  936.  
  937. UPDATE milling_loot_template
  938. SET maxcount = (maxcount + 4)
  939. WHERE maxcount > '0';
  940.  
  941. -- Remove NPC Vendor time constraints
  942.  
  943. UPDATE npc_vendor SET incrtime=0 WHERE incrtime > 0;
  944.  
  945. -- Remove NPC Vendor limits
  946.  
  947. UPDATE npc_vendor SET maxcount=0 WHERE maxcount > 0;
  948.  
  949. -- Increase player base HP and Mana levels by 10% for all levels
  950.  
  951. UPDATE `player_classlevelstats` SET `basehp` = (basehp + (basehp * .10));
  952. UPDATE `player_classlevelstats` SET `basemana` = (basemana + (basemana * .10));
  953.  
  954. -- Increase all player base attributes +1 for all levels
  955.  
  956. UPDATE player_levelstats SET str = (str + 1);
  957. UPDATE player_levelstats SET agi = (agi + 1);
  958. UPDATE player_levelstats SET sta = (sta + 1);
  959. UPDATE player_levelstats SET inte = (inte + 1);
  960. UPDATE player_levelstats SET spi = (spi + 1);
  961.  
  962. -- Added 1 Foror's Crate of Endless Resist Gear Storage to all classes.
  963. -- Added 1 Shortsword and 1 Large Round Shield to the Paladin class.
  964.  
  965. insert  into `playercreateinfo_item`(`race`,`class`,`itemid`,`amount`) values (1,1,23162,1);
  966. insert  into `playercreateinfo_item`(`race`,`class`,`itemid`,`amount`) values (1,2,23162,1);
  967. insert  into `playercreateinfo_item`(`race`,`class`,`itemid`,`amount`) values (1,4,23162,1);
  968. insert  into `playercreateinfo_item`(`race`,`class`,`itemid`,`amount`) values (1,5,23162,1);
  969. insert  into `playercreateinfo_item`(`race`,`class`,`itemid`,`amount`) values (1,8,23162,1);
  970. insert  into `playercreateinfo_item`(`race`,`class`,`itemid`,`amount`) values (1,9,23162,1);
  971. insert  into `playercreateinfo_item`(`race`,`class`,`itemid`,`amount`) values (2,1,23162,1);
  972. insert  into `playercreateinfo_item`(`race`,`class`,`itemid`,`amount`) values (2,3,23162,1);
  973. insert  into `playercreateinfo_item`(`race`,`class`,`itemid`,`amount`) values (2,4,23162,1);
  974. insert  into `playercreateinfo_item`(`race`,`class`,`itemid`,`amount`) values (2,7,23162,1);
  975. insert  into `playercreateinfo_item`(`race`,`class`,`itemid`,`amount`) values (2,9,23162,1);
  976. insert  into `playercreateinfo_item`(`race`,`class`,`itemid`,`amount`) values (3,1,23162,1);
  977. insert  into `playercreateinfo_item`(`race`,`class`,`itemid`,`amount`) values (3,2,23162,1);
  978. insert  into `playercreateinfo_item`(`race`,`class`,`itemid`,`amount`) values (3,3,23162,1);
  979. insert  into `playercreateinfo_item`(`race`,`class`,`itemid`,`amount`) values (3,4,23162,1);
  980. insert  into `playercreateinfo_item`(`race`,`class`,`itemid`,`amount`) values (3,5,23162,1);
  981. insert  into `playercreateinfo_item`(`race`,`class`,`itemid`,`amount`) values (4,1,23162,1);
  982. insert  into `playercreateinfo_item`(`race`,`class`,`itemid`,`amount`) values (4,3,23162,1);
  983. insert  into `playercreateinfo_item`(`race`,`class`,`itemid`,`amount`) values (4,4,23162,1);
  984. insert  into `playercreateinfo_item`(`race`,`class`,`itemid`,`amount`) values (4,5,23162,1);
  985. insert  into `playercreateinfo_item`(`race`,`class`,`itemid`,`amount`) values (4,11,23162,1);
  986. insert  into `playercreateinfo_item`(`race`,`class`,`itemid`,`amount`) values (5,1,23162,1);
  987. insert  into `playercreateinfo_item`(`race`,`class`,`itemid`,`amount`) values (5,4,23162,1);
  988. insert  into `playercreateinfo_item`(`race`,`class`,`itemid`,`amount`) values (5,5,23162,1);
  989. insert  into `playercreateinfo_item`(`race`,`class`,`itemid`,`amount`) values (5,8,23162,1);
  990. insert  into `playercreateinfo_item`(`race`,`class`,`itemid`,`amount`) values (5,9,23162,1);
  991. insert  into `playercreateinfo_item`(`race`,`class`,`itemid`,`amount`) values (6,1,23162,1);
  992. insert  into `playercreateinfo_item`(`race`,`class`,`itemid`,`amount`) values (6,3,23162,1);
  993. insert  into `playercreateinfo_item`(`race`,`class`,`itemid`,`amount`) values (6,7,23162,1);
  994. insert  into `playercreateinfo_item`(`race`,`class`,`itemid`,`amount`) values (6,11,23162,1);
  995. insert  into `playercreateinfo_item`(`race`,`class`,`itemid`,`amount`) values (7,1,23162,1);
  996. insert  into `playercreateinfo_item`(`race`,`class`,`itemid`,`amount`) values (7,4,23162,1);
  997. insert  into `playercreateinfo_item`(`race`,`class`,`itemid`,`amount`) values (7,8,23162,1);
  998. insert  into `playercreateinfo_item`(`race`,`class`,`itemid`,`amount`) values (7,9,23162,1);
  999. insert  into `playercreateinfo_item`(`race`,`class`,`itemid`,`amount`) values (8,1,23162,1);
  1000. insert  into `playercreateinfo_item`(`race`,`class`,`itemid`,`amount`) values (8,3,23162,1);
  1001. insert  into `playercreateinfo_item`(`race`,`class`,`itemid`,`amount`) values (8,4,23162,1);
  1002. insert  into `playercreateinfo_item`(`race`,`class`,`itemid`,`amount`) values (8,5,23162,1);
  1003. insert  into `playercreateinfo_item`(`race`,`class`,`itemid`,`amount`) values (8,7,23162,1);
  1004. insert  into `playercreateinfo_item`(`race`,`class`,`itemid`,`amount`) values (8,8,23162,1);
  1005. insert  into `playercreateinfo_item`(`race`,`class`,`itemid`,`amount`) values (10,2,23162,1);
  1006. insert  into `playercreateinfo_item`(`race`,`class`,`itemid`,`amount`) values (10,3,23162,1);
  1007. insert  into `playercreateinfo_item`(`race`,`class`,`itemid`,`amount`) values (10,4,23162,1);
  1008. insert  into `playercreateinfo_item`(`race`,`class`,`itemid`,`amount`) values (10,5,23162,1);
  1009. insert  into `playercreateinfo_item`(`race`,`class`,`itemid`,`amount`) values (10,8,23162,1);
  1010. insert  into `playercreateinfo_item`(`race`,`class`,`itemid`,`amount`) values (10,9,23162,1);
  1011. insert  into `playercreateinfo_item`(`race`,`class`,`itemid`,`amount`) values (11,1,23162,1);
  1012. insert  into `playercreateinfo_item`(`race`,`class`,`itemid`,`amount`) values (11,2,23162,1);
  1013. insert  into `playercreateinfo_item`(`race`,`class`,`itemid`,`amount`) values (11,3,23162,1);
  1014. insert  into `playercreateinfo_item`(`race`,`class`,`itemid`,`amount`) values (11,5,23162,1);
  1015. insert  into `playercreateinfo_item`(`race`,`class`,`itemid`,`amount`) values (11,7,23162,1);
  1016. insert  into `playercreateinfo_item`(`race`,`class`,`itemid`,`amount`) values (11,8,23162,1);
  1017. insert  into `playercreateinfo_item`(`race`,`class`,`itemid`,`amount`) values (1,2,2131,1);
  1018. insert  into `playercreateinfo_item`(`race`,`class`,`itemid`,`amount`) values (1,2,2129,1);
  1019. insert  into `playercreateinfo_item`(`race`,`class`,`itemid`,`amount`) values (3,2,2131,1);
  1020. insert  into `playercreateinfo_item`(`race`,`class`,`itemid`,`amount`) values (3,2,2129,1);
  1021. insert  into `playercreateinfo_item`(`race`,`class`,`itemid`,`amount`) values (10,2,20849,1);
  1022. insert  into `playercreateinfo_item`(`race`,`class`,`itemid`,`amount`) values (10,2,20912,1);
  1023. insert  into `playercreateinfo_item`(`race`,`class`,`itemid`,`amount`) values (11,2,2131,1);
  1024. insert  into `playercreateinfo_item`(`race`,`class`,`itemid`,`amount`) values (11,2,2129,1);
  1025.  
  1026. -- Added one-Handed Sword skill ability to Human, Dwarf, & Draenei Paladin class.
  1027. -- Added one-handed sword skill ability to all Warlocks.
  1028. -- Added Regeneration racial bonus to all Priests and Mages. (Except Troll which have this ability already.)
  1029. -- Added Expansive Mind racial bonus to all Priests and Mages. (Except Gnome which have this ability already.)
  1030. -- Added Regeneration racial bonus to all Rogues. (Except Troll which have this ability already.)
  1031. -- Added Endurance racial bonus to all Warriors. (Except Tauren which have this ability already.)
  1032. -- Added Endurance racial bonus to all Hunters. (Except Tauren which have this ability already.)
  1033. -- Added Regeneration racial bonus to all Hunters. (Except Troll which have this ability already.)
  1034. -- Added Heroic Presence racial bonus to all Hunters. (Except Draenei which have this ability already.)
  1035. -- Added Expansive Mind racial bonus to all Warlocks. (Except Gnome which have this skill already.)
  1036.  
  1037. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (1,1,20550,'Endurance');
  1038. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (2,1,20550,'Endurance');
  1039. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (3,1,20550,'Endurance');
  1040. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (4,1,20550,'Endurance');
  1041. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (5,1,20550,'Endurance');
  1042. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (7,1,20550,'Endurance');
  1043. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (8,1,20550,'Endurance');
  1044. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (11,1,20550,'Endurance');
  1045. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (2,3,20550,'Endurance');
  1046. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (3,3,20550,'Endurance');
  1047. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (4,3,20550,'Endurance');
  1048. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (8,3,20550,'Endurance');
  1049. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (10,3,20550,'Endurance');
  1050. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (11,3,20550,'Endurance');
  1051. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (1,5,20591,'Expansive Mind');
  1052. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (3,5,20591,'Expansive Mind');
  1053. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (4,5,20591,'Expansive Mind');
  1054. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (5,5,20591,'Expansive Mind');
  1055. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (8,5,20591,'Expansive Mind');
  1056. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (10,5,20591,'Expansive Mind');
  1057. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (11,5,20591,'Expansive Mind');
  1058. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (1,8,20591,'Expansive Mind');
  1059. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (5,8,20591,'Expansive Mind');
  1060. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (8,8,20591,'Expansive Mind');
  1061. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (10,8,20591,'Expansive Mind');
  1062. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (11,8,20591,'Expansive Mind');
  1063. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (1,9,20591,'Expansive Mind');
  1064. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (2,9,20591,'Expansive Mind');
  1065. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (5,9,20591,'Expansive Mind');
  1066. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (10,9,20591,'Expansive Mind');
  1067. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (2,3,6562,'Heroic Presence');
  1068. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (3,3,6562,'Heroic Presence');
  1069. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (4,3,6562,'Heroic Presence');
  1070. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (6,3,6562,'Heroic Presence');
  1071. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (8,3,6562,'Heroic Presence');
  1072. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (10,3,6562,'Heroic Presence');
  1073. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (1,2,201,'One-Handed Swords');
  1074. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (3,2,201,'One-Handed Swords');
  1075. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (11,2,201,'One-Handed Swords');
  1076. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (1,4,201,'One-Handed Swords');
  1077. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (2,4,201,'One-Handed Swords');
  1078. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (3,4,201,'One-Handed Swords');
  1079. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (4,4,201,'One-Handed Swords');
  1080. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (5,4,201,'One-Handed Swords');
  1081. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (7,4,201,'One-Handed Swords');
  1082. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (8,4,201,'One-Handed Swords');
  1083. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (10,4,201,'One-Handed Swords');
  1084. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (1,9,201,'One-Handed Swords');
  1085. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (2,9,201,'One-Handed Swords');
  1086. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (5,9,201,'One-Handed Swords');
  1087. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (7,9,201,'One-Handed Swords');
  1088. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (10,9,201,'One-Handed Swords');
  1089. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (1,5,20555,'Regeneration');
  1090. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (3,5,20555,'Regeneration');
  1091. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (4,5,20555,'Regeneration');
  1092. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (5,5,20555,'Regeneration');
  1093. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (10,5,20555,'Regeneration');
  1094. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (11,5,20555,'Regeneration');
  1095. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (1,8,20555,'Regeneration');
  1096. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (5,8,20555,'Regeneration');
  1097. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (7,8,20555,'Regeneration');
  1098. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (10,8,20555,'Regeneration');
  1099. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (11,8,20555,'Regeneration');
  1100. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (1,4,20555,'Regeneration');
  1101. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (2,4,20555,'Regeneration');
  1102. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (3,4,20555,'Regeneration');
  1103. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (4,4,20555,'Regeneration');
  1104. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (5,4,20555,'Regeneration');
  1105. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (7,4,20555,'Regeneration');
  1106. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (10,4,20555,'Regeneration');
  1107. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (2,3,20555,'Regeneration');
  1108. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (3,3,20555,'Regeneration');
  1109. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (4,3,20555,'Regeneration');
  1110. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (6,3,20555,'Regeneration');
  1111. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (10,3,20555,'Regeneration');
  1112. insert  into `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) values (11,3,20555,'Regeneration');
  1113.  
  1114. -- Increase skinning min and max resource drop rates
  1115.  
  1116. UPDATE skinning_loot_template
  1117. SET mincountOrRef = (mincountOrRef + 4)
  1118. WHERE mincountOrRef > '0';
  1119.  
  1120. UPDATE skinning_loot_template
  1121. SET maxcount = (maxcount + 6)
  1122. WHERE maxcount > '0';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!