/sql/old/ancient/3.3.5a/TDB49_to_TDB50_updates/world/2012_09_19_00_world_reference_loot_template.sql

https://gitlab.com/trinitycore/TrinityCore_434 · SQL · 449 lines · 428 code · 0 blank · 21 comment · 0 complexity · 813734291aaad5b1f89d6936899f2b48 MD5 · raw file

  1. -- Changes To VOA Loot
  2. -- Update gold drops for bosses
  3. -- Archavon 10 & 25
  4. UPDATE `creature_template` SET `mingold`=1700000,`maxgold`=1800000 WHERE `entry` IN (31125,31722);
  5. -- Emalon & koralon 10 & 25
  6. UPDATE `creature_template` SET `mingold`=1800000,`maxgold`=1900000 WHERE `entry` IN (33993,33994,35013,35360);
  7. -- Toravon 10 & 25
  8. UPDATE `creature_template` SET `mingold`=1900000,`maxgold`=2000000 WHERE `entry` IN (38433,38462);
  9. -- Combine PVP and PVE ref templates so loot has chance to be all pvp or all pve not one of each
  10. -- Revome deadly items other than chest lega and hands from Archavon 25 loot
  11. -- Toravon 25 drops 3 items
  12. SET @ARCHAVON10 = 34209;
  13. SET @ARCHAVON25 = 34216;
  14. SET @EMALON10 = 34208;
  15. SET @EMALON25 = 34215;
  16. SET @TORAVON10 = 34206;
  17. SET @TORAVON25 = 34207;
  18. SET @KORALON10 = 34204;
  19. SET @KORALON25 = 34205;
  20. -- Create Reference loot template for @ARCHAVON25 T7(25) & Deadly Chest,Legs,Hands
  21. DELETE FROM `reference_loot_template` WHERE `entry` IN (@ARCHAVON25,@KORALON25,@EMALON25);
  22. INSERT INTO `reference_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`) VALUES
  23. (@ARCHAVON25,40550,0,1,1,1,1), -- Valorous Scourgeborne Battleplate
  24. (@ARCHAVON25,40552,0,1,1,1,1), -- Valorous Scourgeborne Gauntlets
  25. (@ARCHAVON25,40556,0,1,1,1,1), -- Valorous Scourgeborne Legplates
  26. (@ARCHAVON25,40559,0,1,1,1,1), -- Valorous Scourgeborne Chestguard
  27. (@ARCHAVON25,40563,0,1,1,1,1), -- Valorous Scourgeborne Handguards
  28. (@ARCHAVON25,40567,0,1,1,1,1), -- Valorous Scourgeborne Legguards
  29. (@ARCHAVON25,40463,0,1,1,1,1), -- Valorous Dreamwalker Robe
  30. (@ARCHAVON25,40460,0,1,1,1,1), -- Valorous Dreamwalker Handguards
  31. (@ARCHAVON25,40462,0,1,1,1,1), -- Valorous Dreamwalker Leggings
  32. (@ARCHAVON25,40503,0,1,1,1,1), -- Valorous Cryptstalker Tunic
  33. (@ARCHAVON25,40504,0,1,1,1,1), -- Valorous Cryptstalker Handguards
  34. (@ARCHAVON25,40506,0,1,1,1,1), -- Valorous Cryptstalker Legguards
  35. (@ARCHAVON25,40418,0,1,1,1,1), -- Valorous Frostfire Robe
  36. (@ARCHAVON25,40415,0,1,1,1,1), -- Valorous Frostfire Gloves
  37. (@ARCHAVON25,40417,0,1,1,1,1), -- Valorous Frostfire Leggings
  38. (@ARCHAVON25,40569,0,1,1,1,1), -- Valorous Redemption Tunic
  39. (@ARCHAVON25,40570,0,1,1,1,1), -- Valorous Redemption Gloves
  40. (@ARCHAVON25,40572,0,1,1,1,1), -- Valorous Redemption Greaves
  41. (@ARCHAVON25,40579,0,1,1,1,1), -- Valorous Redemption Breastplate
  42. (@ARCHAVON25,40580,0,1,1,1,1), -- Valorous Redemption Handguards
  43. (@ARCHAVON25,40583,0,1,1,1,1), -- Valorous Redemption Legguards
  44. (@ARCHAVON25,40574,0,1,1,1,1), -- Valorous Redemption Chestpiece
  45. (@ARCHAVON25,40575,0,1,1,1,1), -- Valorous Redemption Gauntlets
  46. (@ARCHAVON25,40577,0,1,1,1,1), -- Valorous Redemption Legplates
  47. (@ARCHAVON25,40449,0,1,1,1,1), -- Valorous Robe of Faith
  48. (@ARCHAVON25,40445,0,1,1,1,1), -- Valorous Gloves of Faith
  49. (@ARCHAVON25,40448,0,1,1,1,1), -- Valorous Leggings of Faith
  50. (@ARCHAVON25,40458,0,1,1,1,1), -- Valorous Raiments of Faith
  51. (@ARCHAVON25,40454,0,1,1,1,1), -- Valorous Handwraps of Faith
  52. (@ARCHAVON25,40457,0,1,1,1,1), -- Valorous Pants of Faith
  53. (@ARCHAVON25,40495,0,1,1,1,1), -- Valorous Bonescythe Breastplate
  54. (@ARCHAVON25,40496,0,1,1,1,1), -- Valorous Bonescythe Gauntlets
  55. (@ARCHAVON25,40500,0,1,1,1,1), -- Valorous Bonescythe Legplates
  56. (@ARCHAVON25,40514,0,1,1,1,1), -- Valorous Earthshatter Hauberk
  57. (@ARCHAVON25,40515,0,1,1,1,1), -- Valorous Earthshatter Gloves
  58. (@ARCHAVON25,40517,0,1,1,1,1), -- Valorous Earthshatter Kilt
  59. (@ARCHAVON25,40523,0,1,1,1,1), -- Valorous Earthshatter Chestguard
  60. (@ARCHAVON25,40520,0,1,1,1,1), -- Valorous Earthshatter Grips
  61. (@ARCHAVON25,40522,0,1,1,1,1), -- Valorous Earthshatter War-Kilt
  62. (@ARCHAVON25,40508,0,1,1,1,1), -- Valorous Earthshatter Tunic
  63. (@ARCHAVON25,40509,0,1,1,1,1), -- Valorous Earthshatter Handguards
  64. (@ARCHAVON25,40512,0,1,1,1,1), -- Valorous Earthshatter Legguards
  65. (@ARCHAVON25,40423,0,1,1,1,1), -- Valorous Plagueheart Robe
  66. (@ARCHAVON25,40420,0,1,1,1,1), -- Valorous Plagueheart Gloves
  67. (@ARCHAVON25,40422,0,1,1,1,1), -- Valorous Plagueheart Leggings
  68. (@ARCHAVON25,40525,0,1,1,1,1), -- Valorous Dreadnaught Battleplate
  69. (@ARCHAVON25,40527,0,1,1,1,1), -- Valorous Dreadnaught Gauntlets
  70. (@ARCHAVON25,40529,0,1,1,1,1), -- Valorous Dreadnaught Legplates
  71. (@ARCHAVON25,40544,0,1,1,1,1), -- Valorous Dreadnaught Breastplate
  72. (@ARCHAVON25,40545,0,1,1,1,1), -- Valorous Dreadnaught Handguards
  73. (@ARCHAVON25,40547,0,1,1,1,1), -- Valorous Dreadnaught Legguards
  74. (@ARCHAVON25,40469,0,1,1,1,1), -- Valorous Dreamwalker Vestments
  75. (@ARCHAVON25,40466,0,1,1,1,1), -- Valorous Dreamwalker Gloves
  76. (@ARCHAVON25,40468,0,1,1,1,1), -- Valorous Dreamwalker Trousers
  77. (@ARCHAVON25,40471,0,1,1,1,1), -- Valorous Dreamwalker Raiments
  78. (@ARCHAVON25,40472,0,1,1,1,1), -- Valorous Dreamwalker Handgrips
  79. (@ARCHAVON25,40493,0,1,1,1,1), -- Valorous Dreamwalker Legguards
  80. (@ARCHAVON25,40786,0,1,1,1,1), -- Deadly Gladiator's Plate Chestpiece
  81. (@ARCHAVON25,41951,0,1,1,1,1), -- Deadly Gladiator's Silk Raiment
  82. (@ARCHAVON25,41997,0,1,1,1,1), -- Deadly Gladiator's Felweave Raiment
  83. (@ARCHAVON25,41649,0,1,1,1,1), -- Deadly Gladiator's Leather Tunic
  84. (@ARCHAVON25,40784,0,1,1,1,1), -- Deadly Gladiator's Dreadplate Chestpiece
  85. (@ARCHAVON25,41086,0,1,1,1,1), -- Deadly Gladiator's Chain Armor
  86. (@ARCHAVON25,41920,0,1,1,1,1), -- Deadly Gladiator's Satin Robe
  87. (@ARCHAVON25,40785,0,1,1,1,1), -- Deadly Gladiator's Scaled Chestpiece
  88. (@ARCHAVON25,41660,0,1,1,1,1), -- Deadly Gladiator's Dragonhide Robes
  89. (@ARCHAVON25,41858,0,1,1,1,1), -- Deadly Gladiator's Mooncloth Robe
  90. (@ARCHAVON25,40905,0,1,1,1,1), -- Deadly Gladiator's Ornamented Chestguard
  91. (@ARCHAVON25,40990,0,1,1,1,1), -- Deadly Gladiator's Ringmail Armor
  92. (@ARCHAVON25,41315,0,1,1,1,1), -- Deadly Gladiator's Wyrmhide Robes
  93. (@ARCHAVON25,41309,0,1,1,1,1), -- Deadly Gladiator's Kodohide Robes
  94. (@ARCHAVON25,41080,0,1,1,1,1), -- Deadly Gladiator's Linked Armor
  95. (@ARCHAVON25,40991,0,1,1,1,1), -- Deadly Gladiator's Mail Armor
  96. (@ARCHAVON25,40926,0,1,1,1,1), -- Deadly Gladiator's Ornamented Gloves
  97. (@ARCHAVON25,40938,0,1,1,1,1), -- Deadly Gladiator's Ornamented Legplates
  98. (@ARCHAVON25,40846,0,1,1,1,1), -- Deadly Gladiator's Scaled Legguards
  99. (@ARCHAVON25,41863,0,1,1,1,1), -- Deadly Gladiator's Mooncloth Leggings
  100. (@ARCHAVON25,41926,0,1,1,1,1), -- Deadly Gladiator's Satin Leggings
  101. (@ARCHAVON25,41873,0,1,1,1,1), -- Deadly Gladiator's Mooncloth Gloves
  102. (@ARCHAVON25,41032,0,1,1,1,1), -- Deadly Gladiator's Mail Leggings
  103. (@ARCHAVON25,41006,0,1,1,1,1), -- Deadly Gladiator's Mail Gauntlets
  104. (@ARCHAVON25,41198,0,1,1,1,1), -- Deadly Gladiator's Linked Leggings
  105. (@ARCHAVON25,41666,0,1,1,1,1), -- Deadly Gladiator's Dragonhide Legguards
  106. (@ARCHAVON25,41772,0,1,1,1,1), -- Deadly Gladiator's Dragonhide Gloves
  107. (@ARCHAVON25,41000,0,1,1,1,1), -- Deadly Gladiator's Ringmail Gauntlets
  108. (@ARCHAVON25,41136,0,1,1,1,1), -- Deadly Gladiator's Linked Gauntlets
  109. (@ARCHAVON25,41286,0,1,1,1,1), -- Deadly Gladiator's Kodohide Gloves
  110. (@ARCHAVON25,40805,0,1,1,1,1), -- Deadly Gladiator's Scaled Gauntlets
  111. (@ARCHAVON25,41939,0,1,1,1,1), -- Deadly Gladiator's Satin Gloves
  112. (@ARCHAVON25,41297,0,1,1,1,1), -- Deadly Gladiator's Kodohide Legguards
  113. (@ARCHAVON25,41026,0,1,1,1,1), -- Deadly Gladiator's Ringmail Leggings
  114. (@ARCHAVON25,41958,0,1,1,1,1), -- Deadly Gladiator's Silk Trousers
  115. (@ARCHAVON25,41970,0,1,1,1,1), -- Deadly Gladiator's Silk Handguards
  116. (@ARCHAVON25,40844,0,1,1,1,1), -- Deadly Gladiator's Plate Legguards
  117. (@ARCHAVON25,41303,0,1,1,1,1), -- Deadly Gladiator's Wyrmhide Legguards
  118. (@ARCHAVON25,41292,0,1,1,1,1), -- Deadly Gladiator's Wyrmhide Gloves
  119. (@ARCHAVON25,42004,0,1,1,1,1), -- Deadly Gladiator's Felweave Trousers
  120. (@ARCHAVON25,41142,0,1,1,1,1), -- Deadly Gladiator's Chain Gauntlets
  121. (@ARCHAVON25,40845,0,1,1,1,1), -- Deadly Gladiator's Dreadplate Legguards
  122. (@ARCHAVON25,40804,0,1,1,1,1), -- Deadly Gladiator's Plate Gauntlets
  123. (@ARCHAVON25,42016,0,1,1,1,1), -- Deadly Gladiator's Felweave Handguards
  124. (@ARCHAVON25,40806,0,1,1,1,1), -- Deadly Gladiator's Dreadplate Gauntlets
  125. (@ARCHAVON25,41654,0,1,1,1,1), -- Deadly Gladiator's Leather Legguards
  126. (@ARCHAVON25,41766,0,1,1,1,1), -- Deadly Gladiator's Leather Gloves
  127. (@ARCHAVON25,41204,0,1,1,1,1), -- Deadly Gladiator's Chain Leggings
  128. -- Create Ref for Emalon 25 furious PVP + T8(25) (chest,hands,legs)
  129. (@EMALON25,41640,0,1,1,1,1), -- Furious Gladiator's Armwraps of Dominance
  130. (@EMALON25,41625,0,1,1,1,1), -- Furious Gladiator's Armwraps of Salvation
  131. (@EMALON25,41840,0,1,1,1,1), -- Furious Gladiator's Armwraps of Triumph
  132. (@EMALON25,42116,0,1,1,1,1), -- Furious Gladiator's Band of Dominance
  133. (@EMALON25,42117,0,1,1,1,1), -- Furious Gladiator's Band of Triumph
  134. (@EMALON25,41630,0,1,1,1,1), -- Furious Gladiator's Belt of Dominance
  135. (@EMALON25,41617,0,1,1,1,1), -- Furious Gladiator's Belt of Salvation
  136. (@EMALON25,41832,0,1,1,1,1), -- Furious Gladiator's Belt of Triumph
  137. (@EMALON25,41635,0,1,1,1,1), -- Furious Gladiator's Boots of Dominance
  138. (@EMALON25,41621,0,1,1,1,1), -- Furious Gladiator's Boots of Salvation
  139. (@EMALON25,41836,0,1,1,1,1), -- Furious Gladiator's Boots of Triumph
  140. (@EMALON25,40983,0,1,1,1,1), -- Furious Gladiator's Bracers of Salvation
  141. (@EMALON25,40889,0,1,1,1,1), -- Furious Gladiator's Bracers of Triumph
  142. (@EMALON25,41143,0,1,1,1,1), -- Furious Gladiator's Chain Gauntlets
  143. (@EMALON25,41205,0,1,1,1,1), -- Furious Gladiator's Chain Leggings
  144. (@EMALON25,42071,0,1,1,1,1), -- Furious Gladiator's Cloak of Ascendancy
  145. (@EMALON25,42073,0,1,1,1,1), -- Furious Gladiator's Cloak of Deliverance
  146. (@EMALON25,42069,0,1,1,1,1), -- Furious Gladiator's Cloak of Dominance
  147. (@EMALON25,42072,0,1,1,1,1), -- Furious Gladiator's Cloak of Salvation
  148. (@EMALON25,42070,0,1,1,1,1), -- Furious Gladiator's Cloak of Subjugation
  149. (@EMALON25,42074,0,1,1,1,1), -- Furious Gladiator's Cloak of Triumph
  150. (@EMALON25,42075,0,1,1,1,1), -- Furious Gladiator's Cloak of Victory
  151. (@EMALON25,41898,0,1,1,1,1), -- Furious Gladiator's Cord of Dominance
  152. (@EMALON25,41881,0,1,1,1,1), -- Furious Gladiator's Cord of Salvation
  153. (@EMALON25,41909,0,1,1,1,1), -- Furious Gladiator's Cuffs of Dominance
  154. (@EMALON25,41893,0,1,1,1,1), -- Furious Gladiator's Cuffs of Salvation
  155. (@EMALON25,41773,0,1,1,1,1), -- Furious Gladiator's Dragonhide Gloves
  156. (@EMALON25,41667,0,1,1,1,1), -- Furious Gladiator's Dragonhide Legguards
  157. (@EMALON25,40809,0,1,1,1,1), -- Furious Gladiator's Dreadplate Gauntlets
  158. (@EMALON25,42017,0,1,1,1,1), -- Furious Gladiator's Felweave Handguards
  159. (@EMALON25,42005,0,1,1,1,1), -- Furious Gladiator's Felweave Trousers
  160. (@EMALON25,40976,0,1,1,1,1), -- Furious Gladiator's Girdle of Salvation
  161. (@EMALON25,40881,0,1,1,1,1), -- Furious Gladiator's Girdle of Triumph
  162. (@EMALON25,40977,0,1,1,1,1), -- Furious Gladiator's Greaves of Salvation
  163. (@EMALON25,40882,0,1,1,1,1), -- Furious Gladiator's Greaves of Triumph
  164. (@EMALON25,41287,0,1,1,1,1), -- Furious Gladiator's Kodohide Gloves
  165. (@EMALON25,41298,0,1,1,1,1), -- Furious Gladiator's Kodohide Legguards
  166. (@EMALON25,41767,0,1,1,1,1), -- Furious Gladiator's Leather Gloves
  167. (@EMALON25,41655,0,1,1,1,1), -- Furious Gladiator's Leather Legguards
  168. (@EMALON25,41137,0,1,1,1,1), -- Furious Gladiator's Linked Gauntlets
  169. (@EMALON25,41199,0,1,1,1,1), -- Furious Gladiator's Linked Leggings
  170. (@EMALON25,41007,0,1,1,1,1), -- Furious Gladiator's Mail Gauntlets
  171. (@EMALON25,41033,0,1,1,1,1), -- Furious Gladiator's Mail Leggings
  172. (@EMALON25,41874,0,1,1,1,1), -- Furious Gladiator's Mooncloth Gloves
  173. (@EMALON25,41864,0,1,1,1,1), -- Furious Gladiator's Mooncloth Leggings
  174. (@EMALON25,40927,0,1,1,1,1), -- Furious Gladiator's Ornamented Gloves
  175. (@EMALON25,40939,0,1,1,1,1), -- Furious Gladiator's Ornamented Legplates
  176. (@EMALON25,42037,0,1,1,1,1), -- Furious Gladiator's Pendant of Ascendancy
  177. (@EMALON25,42039,0,1,1,1,1), -- Furious Gladiator's Pendant of Deliverance
  178. (@EMALON25,42036,0,1,1,1,1), -- Furious Gladiator's Pendant of Dominance
  179. (@EMALON25,42040,0,1,1,1,1), -- Furious Gladiator's Pendant of Salvation
  180. (@EMALON25,42038,0,1,1,1,1), -- Furious Gladiator's Pendant of Subjugation
  181. (@EMALON25,46373,0,1,1,1,1), -- Furious Gladiator's Pendant of Sundering
  182. (@EMALON25,42034,0,1,1,1,1), -- Furious Gladiator's Pendant of Triumph
  183. (@EMALON25,42035,0,1,1,1,1), -- Furious Gladiator's Pendant of Victory
  184. (@EMALON25,40807,0,1,1,1,1), -- Furious Gladiator's Plate Gauntlets
  185. (@EMALON25,40847,0,1,1,1,1), -- Furious Gladiator's Plate Legguards
  186. (@EMALON25,41001,0,1,1,1,1), -- Furious Gladiator's Ringmail Gauntlets
  187. (@EMALON25,41027,0,1,1,1,1), -- Furious Gladiator's Ringmail Leggings
  188. (@EMALON25,41075,0,1,1,1,1), -- Furious Gladiator's Sabatons of Dominance
  189. (@EMALON25,41055,0,1,1,1,1), -- Furious Gladiator's Sabatons of Salvation
  190. (@EMALON25,41230,0,1,1,1,1), -- Furious Gladiator's Sabatons of Triumph
  191. (@EMALON25,41940,0,1,1,1,1), -- Furious Gladiator's Satin Gloves
  192. (@EMALON25,41927,0,1,1,1,1), -- Furious Gladiator's Satin Leggings
  193. (@EMALON25,40808,0,1,1,1,1), -- Furious Gladiator's Scaled Gauntlets
  194. (@EMALON25,40849,0,1,1,1,1), -- Furious Gladiator's Scaled Legguards
  195. (@EMALON25,41971,0,1,1,1,1), -- Furious Gladiator's Silk Handguards
  196. (@EMALON25,41959,0,1,1,1,1), -- Furious Gladiator's Silk Trousers
  197. (@EMALON25,41903,0,1,1,1,1), -- Furious Gladiator's Slippers of Dominance
  198. (@EMALON25,41885,0,1,1,1,1), -- Furious Gladiator's Slippers of Salvation
  199. (@EMALON25,41070,0,1,1,1,1), -- Furious Gladiator's Waistguard of Dominance
  200. (@EMALON25,41051,0,1,1,1,1), -- Furious Gladiator's Waistguard of Salvation
  201. (@EMALON25,41235,0,1,1,1,1), -- Furious Gladiator's Waistguard of Triumph
  202. (@EMALON25,41065,0,1,1,1,1), -- Furious Gladiator's Wristguards of Dominance
  203. (@EMALON25,41060,0,1,1,1,1), -- Furious Gladiator's Wristguards of Salvation
  204. (@EMALON25,41225,0,1,1,1,1), -- Furious Gladiator's Wristguards of Triumph
  205. (@EMALON25,41293,0,1,1,1,1), -- Furious Gladiator's Wyrmhide Gloves
  206. (@EMALON25,41304,0,1,1,1,1), -- Furious Gladiator's Wyrmhide Legguards
  207. (@EMALON25,40811,0,1,1,1,1), -- Furious Gladiator's Girdle of Triumph
  208. (@EMALON25,46155,0,1,1,1,1), -- Conqueror's Aegis Gauntlets
  209. (@EMALON25,46179,0,1,1,1,1), -- Conqueror's Aegis Gloves
  210. (@EMALON25,46181,0,1,1,1,1), -- Conqueror's Aegis Greaves
  211. (@EMALON25,46174,0,1,1,1,1), -- Conqueror's Aegis Handguards
  212. (@EMALON25,46176,0,1,1,1,1), -- Conqueror's Aegis Legguards
  213. (@EMALON25,46153,0,1,1,1,1), -- Conqueror's Aegis Legplates
  214. (@EMALON25,46113,0,1,1,1,1), -- Conqueror's Darkruned Gauntlets
  215. (@EMALON25,46119,0,1,1,1,1), -- Conqueror's Darkruned Handguards
  216. (@EMALON25,46121,0,1,1,1,1), -- Conqueror's Darkruned Legguards
  217. (@EMALON25,46116,0,1,1,1,1), -- Conqueror's Darkruned Legplates
  218. (@EMALON25,46135,0,1,1,1,1), -- Conqueror's Deathbringer Gloves
  219. (@EMALON25,46139,0,1,1,1,1), -- Conqueror's Deathbringer Leggings
  220. (@EMALON25,46188,0,1,1,1,1), -- Conqueror's Gloves of Sanctification
  221. (@EMALON25,46163,0,1,1,1,1), -- Conqueror's Handwraps of Sanctification
  222. (@EMALON25,46132,0,1,1,1,1), -- Conqueror's Kirin Tor Gauntlets
  223. (@EMALON25,46133,0,1,1,1,1), -- Conqueror's Kirin Tor Leggings
  224. (@EMALON25,46195,0,1,1,1,1), -- Conqueror's Leggings of Sanctification
  225. (@EMALON25,46189,0,1,1,1,1), -- Conqueror's Nightsong Gloves
  226. (@EMALON25,46158,0,1,1,1,1), -- Conqueror's Nightsong Handgrips
  227. (@EMALON25,46183,0,1,1,1,1), -- Conqueror's Nightsong Handguards
  228. (@EMALON25,46185,0,1,1,1,1), -- Conqueror's Nightsong Leggings
  229. (@EMALON25,46160,0,1,1,1,1), -- Conqueror's Nightsong Legguards
  230. (@EMALON25,46192,0,1,1,1,1), -- Conqueror's Nightsong Trousers
  231. (@EMALON25,46170,0,1,1,1,1), -- Conqueror's Pants of Sanctification
  232. (@EMALON25,46142,0,1,1,1,1), -- Conqueror's Scourgestalker Handguards
  233. (@EMALON25,46144,0,1,1,1,1), -- Conqueror's Scourgestalker Legguards
  234. (@EMALON25,46148,0,1,1,1,1), -- Conqueror's Siegebreaker Gauntlets
  235. (@EMALON25,46164,0,1,1,1,1), -- Conqueror's Siegebreaker Handguards
  236. (@EMALON25,46169,0,1,1,1,1), -- Conqueror's Siegebreaker Legguards
  237. (@EMALON25,46150,0,1,1,1,1), -- Conqueror's Siegebreaker Legplates
  238. (@EMALON25,46124,0,1,1,1,1), -- Conqueror's Terrorblade Gauntlets
  239. (@EMALON25,46126,0,1,1,1,1), -- Conqueror's Terrorblade Legplates
  240. (@EMALON25,46207,0,1,1,1,1), -- Conqueror's Worldbreaker Gloves
  241. (@EMALON25,46200,0,1,1,1,1), -- Conqueror's Worldbreaker Grips
  242. (@EMALON25,46199,0,1,1,1,1), -- Conqueror's Worldbreaker Handguards
  243. (@EMALON25,46210,0,1,1,1,1), -- Conqueror's Worldbreaker Kilt
  244. (@EMALON25,46202,0,1,1,1,1), -- Conqueror's Worldbreaker Legguards
  245. (@EMALON25,46208,0,1,1,1,1), -- Conqueror's Worldbreaker War-Kilt
  246. -- Create Ref for koralon 25 relentless + T9.5 (hands,legs)
  247. (@KORALON25,41641,0,1,1,1,1), -- Relentless Gladiator's Armwraps of Dominance
  248. (@KORALON25,41626,0,1,1,1,1), -- Relentless Gladiator's Armwraps of Salvation
  249. (@KORALON25,41841,0,1,1,1,1), -- Relentless Gladiator's Armwraps of Triumph
  250. (@KORALON25,42118,0,1,1,1,1), -- Relentless Gladiator's Band of Ascendancy
  251. (@KORALON25,42119,0,1,1,1,1), -- Relentless Gladiator's Band of Victory
  252. (@KORALON25,41631,0,1,1,1,1), -- Relentless Gladiator's Belt of Dominance
  253. (@KORALON25,41618,0,1,1,1,1), -- Relentless Gladiator's Belt of Salvation
  254. (@KORALON25,41833,0,1,1,1,1), -- Relentless Gladiator's Belt of Triumph
  255. (@KORALON25,41636,0,1,1,1,1), -- Relentless Gladiator's Boots of Dominance
  256. (@KORALON25,41622,0,1,1,1,1), -- Relentless Gladiator's Boots of Salvation
  257. (@KORALON25,41837,0,1,1,1,1), -- Relentless Gladiator's Boots of Triumph
  258. (@KORALON25,40984,0,1,1,1,1), -- Relentless Gladiator's Bracers of Salvation
  259. (@KORALON25,40890,0,1,1,1,1), -- Relentless Gladiator's Bracers of Triumph
  260. (@KORALON25,41144,0,1,1,1,1), -- Relentless Gladiator's Chain Gauntlets
  261. (@KORALON25,41206,0,1,1,1,1), -- Relentless Gladiator's Chain Leggings
  262. (@KORALON25,42078,0,1,1,1,1), -- Relentless Gladiator's Cloak of Ascendancy
  263. (@KORALON25,42080,0,1,1,1,1), -- Relentless Gladiator's Cloak of Deliverance
  264. (@KORALON25,42076,0,1,1,1,1), -- Relentless Gladiator's Cloak of Dominance
  265. (@KORALON25,42079,0,1,1,1,1), -- Relentless Gladiator's Cloak of Salvation
  266. (@KORALON25,42077,0,1,1,1,1), -- Relentless Gladiator's Cloak of Subjugation
  267. (@KORALON25,42081,0,1,1,1,1), -- Relentless Gladiator's Cloak of Triumph
  268. (@KORALON25,42082,0,1,1,1,1), -- Relentless Gladiator's Cloak of Victory
  269. (@KORALON25,41899,0,1,1,1,1), -- Relentless Gladiator's Cord of Dominance
  270. (@KORALON25,41882,0,1,1,1,1), -- Relentless Gladiator's Cord of Salvation
  271. (@KORALON25,41910,0,1,1,1,1), -- Relentless Gladiator's Cuffs of Dominance
  272. (@KORALON25,41894,0,1,1,1,1), -- Relentless Gladiator's Cuffs of Salvation
  273. (@KORALON25,41774,0,1,1,1,1), -- Relentless Gladiator's Dragonhide Gloves
  274. (@KORALON25,41668,0,1,1,1,1), -- Relentless Gladiator's Dragonhide Legguards
  275. (@KORALON25,40851,0,1,1,1,1), -- Relentless Gladiator's Dreadplate Legguards
  276. (@KORALON25,42018,0,1,1,1,1), -- Relentless Gladiator's Felweave Handguards
  277. (@KORALON25,42006,0,1,1,1,1), -- Relentless Gladiator's Felweave Trousers
  278. (@KORALON25,40978,0,1,1,1,1), -- Relentless Gladiator's Girdle of Salvation
  279. (@KORALON25,40883,0,1,1,1,1), -- Relentless Gladiator's Girdle of Triumph
  280. (@KORALON25,40979,0,1,1,1,1), -- Relentless Gladiator's Greaves of Salvation
  281. (@KORALON25,40884,0,1,1,1,1), -- Relentless Gladiator's Greaves of Triumph
  282. (@KORALON25,41288,0,1,1,1,1), -- Relentless Gladiator's Kodohide Gloves
  283. (@KORALON25,41299,0,1,1,1,1), -- Relentless Gladiator's Kodohide Legguards
  284. (@KORALON25,41768,0,1,1,1,1), -- Relentless Gladiator's Leather Gloves
  285. (@KORALON25,41656,0,1,1,1,1), -- Relentless Gladiator's Leather Legguards
  286. (@KORALON25,41138,0,1,1,1,1), -- Relentless Gladiator's Linked Gauntlets
  287. (@KORALON25,41200,0,1,1,1,1), -- Relentless Gladiator's Linked Leggings
  288. (@KORALON25,41008,0,1,1,1,1), -- Relentless Gladiator's Mail Gauntlets
  289. (@KORALON25,41034,0,1,1,1,1), -- Relentless Gladiator's Mail Leggings
  290. (@KORALON25,41875,0,1,1,1,1), -- Relentless Gladiator's Mooncloth Gloves
  291. (@KORALON25,41865,0,1,1,1,1), -- Relentless Gladiator's Mooncloth Leggings
  292. (@KORALON25,40928,0,1,1,1,1), -- Relentless Gladiator's Ornamented Gloves
  293. (@KORALON25,40940,0,1,1,1,1), -- Relentless Gladiator's Ornamented Legplates
  294. (@KORALON25,42044,0,1,1,1,1), -- Relentless Gladiator's Pendant of Ascendancy
  295. (@KORALON25,42046,0,1,1,1,1), -- Relentless Gladiator's Pendant of Deliverance
  296. (@KORALON25,42043,0,1,1,1,1), -- Relentless Gladiator's Pendant of Dominance
  297. (@KORALON25,42047,0,1,1,1,1), -- Relentless Gladiator's Pendant of Salvation
  298. (@KORALON25,42045,0,1,1,1,1), -- Relentless Gladiator's Pendant of Subjugation
  299. (@KORALON25,46374,0,1,1,1,1), -- Relentless Gladiator's Pendant of Sundering
  300. (@KORALON25,42041,0,1,1,1,1), -- Relentless Gladiator's Pendant of Triumph
  301. (@KORALON25,42042,0,1,1,1,1), -- Relentless Gladiator's Pendant of Victory
  302. (@KORALON25,40810,0,1,1,1,1), -- Relentless Gladiator's Plate Gauntlets
  303. (@KORALON25,40850,0,1,1,1,1), -- Relentless Gladiator's Plate Legguards
  304. (@KORALON25,41002,0,1,1,1,1), -- Relentless Gladiator's Ringmail Gauntlets
  305. (@KORALON25,41028,0,1,1,1,1), -- Relentless Gladiator's Ringmail Leggings
  306. (@KORALON25,41076,0,1,1,1,1), -- Relentless Gladiator's Sabatons of Dominance
  307. (@KORALON25,41056,0,1,1,1,1), -- Relentless Gladiator's Sabatons of Salvation
  308. (@KORALON25,41231,0,1,1,1,1), -- Relentless Gladiator's Sabatons of Triumph
  309. (@KORALON25,41941,0,1,1,1,1), -- Relentless Gladiator's Satin Gloves
  310. (@KORALON25,41928,0,1,1,1,1), -- Relentless Gladiator's Satin Leggings
  311. (@KORALON25,40812,0,1,1,1,1), -- Relentless Gladiator's Scaled Gauntlets
  312. (@KORALON25,40852,0,1,1,1,1), -- Relentless Gladiator's Scaled Legguards
  313. (@KORALON25,41972,0,1,1,1,1), -- Relentless Gladiator's Silk Handguards
  314. (@KORALON25,41960,0,1,1,1,1), -- Relentless Gladiator's Silk Trousers
  315. (@KORALON25,41904,0,1,1,1,1), -- Relentless Gladiator's Treads of Dominance
  316. (@KORALON25,41886,0,1,1,1,1), -- Relentless Gladiator's Treads of Salvation
  317. (@KORALON25,41071,0,1,1,1,1), -- Relentless Gladiator's Waistguard of Dominance
  318. (@KORALON25,41052,0,1,1,1,1), -- Relentless Gladiator's Waistguard of Salvation
  319. (@KORALON25,41236,0,1,1,1,1), -- Relentless Gladiator's Waistguard of Triumph
  320. (@KORALON25,41066,0,1,1,1,1), -- Relentless Gladiator's Wristguards of Dominance
  321. (@KORALON25,41061,0,1,1,1,1), -- Relentless Gladiator's Wristguards of Salvation
  322. (@KORALON25,41226,0,1,1,1,1), -- Relentless Gladiator's Wristguards of Triumph
  323. (@KORALON25,41294,0,1,1,1,1), -- Relentless Gladiator's Wyrmhide Gloves
  324. (@KORALON25,41305,0,1,1,1,1), -- Relentless Gladiator's Wyrmhide Legguards
  325. (@KORALON25,48094,0,1,1,1,1), -- Zabra's Pants of Triumph
  326. (@KORALON25,48064,0,1,1,1,1), -- Zabra's Leggings of Triumph
  327. (@KORALON25,48096,0,1,1,1,1), -- Zabra's Handwraps of Triumph
  328. (@KORALON25,48066,0,1,1,1,1), -- Zabra's Gloves of Triumph
  329. (@KORALON25,48271,0,1,1,1,1), -- Windrunner's Legguards of Triumph
  330. (@KORALON25,48273,0,1,1,1,1), -- Windrunner's Handguards of Triumph
  331. (@KORALON25,48362,0,1,1,1,1), -- Thrall's War-Kilt of Triumph
  332. (@KORALON25,48303,0,1,1,1,1), -- Thrall's Legguards of Triumph
  333. (@KORALON25,48332,0,1,1,1,1), -- Thrall's Kilt of Triumph
  334. (@KORALON25,48301,0,1,1,1,1), -- Thrall's Handguards of Triumph
  335. (@KORALON25,48364,0,1,1,1,1), -- Thrall's Grips of Triumph
  336. (@KORALON25,48334,0,1,1,1,1), -- Thrall's Gloves of Triumph
  337. (@KORALON25,47770,0,1,1,1,1), -- Sunstrider's Leggings of Triumph
  338. (@KORALON25,47772,0,1,1,1,1), -- Sunstrider's Gauntlets of Triumph
  339. (@KORALON25,48180,0,1,1,1,1), -- Runetotem's Trousers of Triumph
  340. (@KORALON25,48195,0,1,1,1,1), -- Runetotem's Legguards of Triumph
  341. (@KORALON25,48150,0,1,1,1,1), -- Runetotem's Leggings of Triumph
  342. (@KORALON25,48152,0,1,1,1,1), -- Runetotem's Handguards of Triumph
  343. (@KORALON25,48193,0,1,1,1,1), -- Runetotem's Handgrips of Triumph
  344. (@KORALON25,48182,0,1,1,1,1), -- Runetotem's Gloves of Triumph
  345. (@KORALON25,48623,0,1,1,1,1), -- Liadrin's Legplates of Triumph
  346. (@KORALON25,48660,0,1,1,1,1), -- Liadrin's Legguards of Triumph
  347. (@KORALON25,48658,0,1,1,1,1), -- Liadrin's Handguards of Triumph
  348. (@KORALON25,48591,0,1,1,1,1), -- Liadrin's Greaves of Triumph
  349. (@KORALON25,48593,0,1,1,1,1), -- Liadrin's Gloves of Triumph
  350. (@KORALON25,48625,0,1,1,1,1), -- Liadrin's Gauntlets of Triumph
  351. (@KORALON25,48497,0,1,1,1,1), -- Koltira's Legplates of Triumph
  352. (@KORALON25,48554,0,1,1,1,1), -- Koltira's Legguards of Triumph
  353. (@KORALON25,48556,0,1,1,1,1), -- Koltira's Handguards of Triumph
  354. (@KORALON25,48499,0,1,1,1,1), -- Koltira's Gauntlets of Triumph
  355. (@KORALON25,48394,0,1,1,1,1), -- Hellscream's Legplates of Triumph
  356. (@KORALON25,48464,0,1,1,1,1), -- Hellscream's Legguards of Triumph
  357. (@KORALON25,48462,0,1,1,1,1), -- Hellscream's Handguards of Triumph
  358. (@KORALON25,48392,0,1,1,1,1), -- Hellscream's Gauntlets of Triumph
  359. (@KORALON25,47805,0,1,1,1,1), -- Gul'dan's Leggings of Triumph
  360. (@KORALON25,47803,0,1,1,1,1), -- Gul'dan's Gloves of Triumph
  361. (@KORALON25,48239,0,1,1,1,1), -- Garona's Legplates of Triumph
  362. (@KORALON25,48241,0,1,1,1,1), -- Garona's Gauntlets of Triumph
  363. (@KORALON25,48379,0,1,2,1,1), -- Wrynn's Legplates of Triumph
  364. (@KORALON25,48446,0,1,2,1,1), -- Wrynn's Legguards of Triumph
  365. (@KORALON25,48452,0,1,2,1,1), -- Wrynn's Handguards of Triumph
  366. (@KORALON25,48377,0,1,2,1,1), -- Wrynn's Gauntlets of Triumph
  367. (@KORALON25,48258,0,1,2,1,1), -- Windrunner's Legguards of Triumph
  368. (@KORALON25,48256,0,1,2,1,1), -- Windrunner's Handguards of Triumph
  369. (@KORALON25,48079,0,1,2,1,1), -- Velen's Pants of Triumph
  370. (@KORALON25,48077,0,1,2,1,1), -- Velen's Handwraps of Triumph
  371. (@KORALON25,47983,0,1,2,1,1), -- Velen's Gloves of Triumph
  372. (@KORALON25,48226,0,1,2,1,1), -- VanCleef's Legplates of Triumph
  373. (@KORALON25,48224,0,1,2,1,1), -- VanCleef's Gauntlets of Triumph
  374. (@KORALON25,48610,0,1,2,1,1), -- Turalyon's Legplates of Triumph
  375. (@KORALON25,48638,0,1,2,1,1), -- Turalyon's Legguards of Triumph
  376. (@KORALON25,48640,0,1,2,1,1), -- Turalyon's Handguards of Triumph
  377. (@KORALON25,48578,0,1,2,1,1), -- Turalyon's Greaves of Triumph
  378. (@KORALON25,48576,0,1,2,1,1), -- Turalyon's Gloves of Triumph
  379. (@KORALON25,48608,0,1,2,1,1), -- Turalyon's Gauntlets of Triumph
  380. (@KORALON25,48484,0,1,2,1,1), -- Thassarian's Legplates of Triumph
  381. (@KORALON25,48541,0,1,2,1,1), -- Thassarian's Legguards of Triumph
  382. (@KORALON25,48539,0,1,2,1,1), -- Thassarian's Handguards of Triumph
  383. (@KORALON25,48482,0,1,2,1,1), -- Thassarian's Gauntlets of Triumph
  384. (@KORALON25,48349,0,1,2,1,1), -- Nobundo's War-Kilt of Triumph
  385. (@KORALON25,48288,0,1,2,1,1), -- Nobundo's Legguards of Triumph
  386. (@KORALON25,48319,0,1,2,1,1), -- Nobundo's Kilt of Triumph
  387. (@KORALON25,48286,0,1,2,1,1), -- Nobundo's Handguards of Triumph
  388. (@KORALON25,48347,0,1,2,1,1), -- Nobundo's Grips of Triumph
  389. (@KORALON25,48317,0,1,2,1,1), -- Nobundo's Gloves of Triumph
  390. (@KORALON25,48165,0,1,2,1,1), -- Malfurion's Trousers of Triumph
  391. (@KORALON25,48210,0,1,2,1,1), -- Malfurion's Legguards of Triumph
  392. (@KORALON25,48135,0,1,2,1,1), -- Malfurion's Leggings of Triumph
  393. (@KORALON25,48133,0,1,2,1,1), -- Malfurion's Handguards of Triumph
  394. (@KORALON25,48212,0,1,2,1,1), -- Malfurion's Handgrips of Triumph
  395. (@KORALON25,48163,0,1,2,1,1), -- Malfurion's Gloves of Triumph
  396. (@KORALON25,47755,0,1,2,1,1), -- Khadgar's Leggings of Triumph
  397. (@KORALON25,47753,0,1,2,1,1), -- Khadgar's Gauntlets of Triumph
  398. (@KORALON25,47780,0,1,2,1,1), -- Kel'Thuzad's Leggings of Triumph
  399. (@KORALON25,47782,0,1,2,1,1), -- Kel'Thuzad's Gloves of Triumph
  400. (@KORALON25,47985,0,1,2,1,1); -- Velen's Leggings of Triumph
  401. -- Merge PVP and PVE items to one ref
  402. UPDATE `reference_loot_template` SET `entry`=@TORAVON25 WHERE `entry`=34214; -- 25 Toravon
  403. UPDATE `reference_loot_template` SET `entry`=@TORAVON10 WHERE `entry`=34213; -- 10 Toravon
  404. UPDATE `reference_loot_template` SET `entry`=@ARCHAVON10 WHERE `entry`=34210; -- 10 Archavon
  405. UPDATE `reference_loot_template` SET `entry`=@EMALON10 WHERE `entry`=34211; -- 10 Emalon
  406. UPDATE `reference_loot_template` SET `entry`=@KORALON10 WHERE `entry`=34212; -- 10 Koralon
  407. -- Assign to cratures
  408. SET @Tora10 =38433;
  409. SET @Tora25 =38462;
  410. SET @Arch10 =31125;
  411. SET @Arch25 =31722;
  412. SET @Emal10 =33993;
  413. SET @Emal25 =33994;
  414. SET @Kora10 =35013;
  415. SET @Kora25 =35360;
  416. DELETE FROM `creature_loot_template` WHERE `entry`IN (@Tora10,@Tora25,@Arch10,@Arch25,@Emal10,@Emal25,@Kora10,@Kora25);
  417. INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`) VALUES
  418. -- Update loot template for Toravon 10
  419. (@Tora10,47241,100,1,0,2,2), -- Emblem of triumph
  420. (@Tora10,1,100,1,0,-@TORAVON10,2), -- Gear(Relentless PVP,T10 PVE)
  421. (@Tora10,2,1,1,0,-34203,1), -- Mount
  422. -- Update loot template for Toravon 25 to drop 3 items
  423. (@Tora25,49426,100,1,0,2,2), -- Emblem of frost
  424. (@Tora25,1,100,1,0,-@TORAVON25,3), -- Gear(Wrathful PVP,T10.5 PVE)
  425. (@Tora25,2,1,1,0,-34203,1), -- Mount
  426. -- Update loot template for Archavon 10
  427. (@Arch10,47241,100,1,0,2,2), -- Emblem of triumph
  428. (@Arch10,1,100,1,0,-@ARCHAVON10,2), -- Gear(Hate PVP,T7 PVE)
  429. (@Arch10,2,1,1,0,-34203,1), -- Mount
  430. -- Update loot template for Archavon 25
  431. (@Arch25,47241,100,1,0,2,2), -- Emblem of triumph
  432. (@Arch25,1,100,1,0,-@ARCHAVON25,4), -- Gear(Deadly PVP,T7(25) PVE)
  433. (@Arch25,2,1,1,0,-34203,1), -- Mount
  434. -- Update loot template for Emalon 10
  435. (@Emal10,47241,100,1,0,2,2), -- Emblem of triumph
  436. (@Emal10,1,100,1,0,-@EMALON10,2), -- Gear(Deadly PVP,T8 PVE)
  437. (@Emal10,2,1,1,0,-34203,1), -- Mount
  438. -- Update loot template for Emalon 25
  439. (@Emal25,47241,100,1,0,2,2), -- Emblem of triumph
  440. (@Emal25,1,100,1,0,-@EMALON25,4), -- Gear(Deadly PVP,T8(25) PVE)
  441. (@Emal25,2,1,1,0,-34203,1), -- Mount
  442. -- Update loot template for Koralon 10
  443. (@Kora10,47241,100,1,0,2,2), -- Emblem of triumph
  444. (@Kora10,1,100,1,0,-@KORALON10,2), -- Gear(Furious PVP,T9 PVE)
  445. (@Kora10,2,1,1,0,-34203,1), -- Mount
  446. -- Update loot template for Koralon 25
  447. (@Kora25,47241,100,1,0,2,2), -- Emblem of triumph
  448. (@Kora25,1,100,1,0,-@KORALON25,4), -- Gear(Relentless PVP,T9.5 PVE)
  449. (@Kora25,2,1,1,0,-34203,1); -- Mount