API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Sep 21st, 2017
72
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 18.92 KB | None | 0 0
raw download clone embed print report
  1. -- Harold Winston <Jewelry Vendor> 32172
  2. UPDATE creature_template SET `modelid3` = "0", `npcflag` = "128" WHERE entry=32172;
  3. DELETE FROM `creature` WHERE `id`='32172';
  4. INSERT INTO `creature` (`id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`)
  5. VALUES
  6. ('32172', '571', '1', '1', '0', '0', '5878.83', '717.447', '643.103', '2.0936', '1200', '0', '0', '10635', '0', '0', '0');
  7. DELETE FROM `npc_vendor` WHERE `entry`='32172';
  8. INSERT INTO `npc_vendor` (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`)
  9. VALUES
  10. ('32172', '36919', '0', '0', '2484'),
  11. ('32172', '36922', '0', '0', '2484'),
  12. ('32172', '36925', '0', '0', '2484'),
  13. ('32172', '36928', '0', '0', '2484'),
  14. ('32172', '36931', '0', '0', '2484'),
  15. ('32172', '36934', '0', '0', '2484'),
  16. ('32172', '40585', '0', '0', '0'),
  17. ('32172', '40586', '0', '0', '0'),
  18. ('32172', '40678', '0', '0', '2523'),
  19. ('32172', '40679', '0', '0', '2523'),
  20. ('32172', '40680', '0', '0', '2523'),
  21. ('32172', '40681', '0', '0', '2523'),
  22. ('32172', '40717', '0', '0', '2534'),
  23. ('32172', '40718', '0', '0', '2534'),
  24. ('32172', '40719', '0', '0', '2534'),
  25. ('32172', '40720', '0', '0', '2534'),
  26. ('32172', '44934', '0', '0', '0'),
  27. ('32172', '44935', '0', '0', '0'),
  28. ('32172', '45688', '0', '0', '2591'),
  29. ('32172', '45689', '0', '0', '2593'),
  30. ('32172', '45690', '0', '0', '2594'),
  31. ('32172', '45691', '0', '0', '2595'),
  32. ('32172', '45819', '0', '0', '2606'),
  33. ('32172', '45820', '0', '0', '2606'),
  34. ('32172', '45821', '0', '0', '2606'),
  35. ('32172', '45822', '0', '0', '2606'),
  36. ('32172', '45823', '0', '0', '2606'),
  37. ('32172', '48954', '0', '0', '2702'),
  38. ('32172', '48955', '0', '0', '2703'),
  39. ('32172', '48956', '0', '0', '2704'),
  40. ('32172', '48957', '0', '0', '2705');
  41.  
  42. -- Timothy Jones <Grand Master Jewelcrafting Trainer> 28701
  43. UPDATE creature_template SET `modelid3` = "0", `gossip_menu_id` = "9873", `npcflag` = "211" WHERE entry=28701;
  44. DELETE FROM `gossip_menu` WHERE `entry`='9873';
  45. INSERT INTO `gossip_menu` (`entry`, `text_id`, `cond_1`, `cond_1_val_1`, `cond_1_val_2`, `cond_2`, `cond_2_val_1`, `cond_2_val_2`)
  46. VALUES
  47. ('9873', '13690', '0', '0', '0', '0', '0', '0');
  48. DELETE FROM `gossip_menu_option` WHERE `menu_id`='9873';
  49. INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `action_script_id`, `box_coded`, `box_money`, `box_text`, `cond_1`, `cond_1_val_1`, `cond_1_val_2`, `cond_2`, `cond_2_val_1`, `cond_2_val_2`, `cond_3`, `cond_3_val_1`, `cond_3_val_2`)
  50. VALUES
  51. ('9873', '1', '3', 'Train me', '5', '16', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  52. ('9873', '2', '1', 'May I browse your epic recipes?', '3', '128', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0');
  53. DELETE FROM `npc_vendor` WHERE `entry`='28701';
  54. INSERT INTO `npc_vendor` (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`)
  55. VALUES
  56. ('28701', '46897', '0', '0', '2436'),
  57. ('28701', '46898', '0', '0', '2436'),
  58. ('28701', '46899', '0', '0', '2436'),
  59. ('28701', '46900', '0', '0', '2436'),
  60. ('28701', '46901', '0', '0', '2436'),
  61. ('28701', '46902', '0', '0', '2436'),
  62. ('28701', '46903', '0', '0', '2436'),
  63. ('28701', '46904', '0', '0', '2436'),
  64. ('28701', '46905', '0', '0', '2436'),
  65. ('28701', '46906', '0', '0', '2436'),
  66. ('28701', '46907', '0', '0', '2436'),
  67. ('28701', '46908', '0', '0', '2436'),
  68. ('28701', '46909', '0', '0', '2436'),
  69. ('28701', '46910', '0', '0', '2436'),
  70. ('28701', '46911', '0', '0', '2436'),
  71. ('28701', '46912', '0', '0', '2436'),
  72. ('28701', '46913', '0', '0', '2436'),
  73. ('28701', '46914', '0', '0', '2436'),
  74. ('28701', '46915', '0', '0', '2436'),
  75. ('28701', '46916', '0', '0', '2436'),
  76. ('28701', '46917', '0', '0', '2436'),
  77. ('28701', '46918', '0', '0', '2436'),
  78. ('28701', '46919', '0', '0', '2436'),
  79. ('28701', '46920', '0', '0', '2436'),
  80. ('28701', '46921', '0', '0', '2436'),
  81. ('28701', '46922', '0', '0', '2436'),
  82. ('28701', '46923', '0', '0', '2436'),
  83. ('28701', '46924', '0', '0', '2436'),
  84. ('28701', '46925', '0', '0', '2436'),
  85. ('28701', '46926', '0', '0', '2436'),
  86. ('28701', '46927', '0', '0', '2436'),
  87. ('28701', '46928', '0', '0', '2436'),
  88. ('28701', '46929', '0', '0', '2436'),
  89. ('28701', '46930', '0', '0', '2436'),
  90. ('28701', '46931', '0', '0', '2436'),
  91. ('28701', '46932', '0', '0', '2436'),
  92. ('28701', '46933', '0', '0', '2436'),
  93. ('28701', '46934', '0', '0', '2436'),
  94. ('28701', '46935', '0', '0', '2436'),
  95. ('28701', '46936', '0', '0', '2436'),
  96. ('28701', '46937', '0', '0', '2436'),
  97. ('28701', '46938', '0', '0', '2436'),
  98. ('28701', '46939', '0', '0', '2436'),
  99. ('28701', '46940', '0', '0', '2436'),
  100. ('28701', '46941', '0', '0', '2436'),
  101. ('28701', '46942', '0', '0', '2436'),
  102. ('28701', '46943', '0', '0', '2436'),
  103. ('28701', '46944', '0', '0', '2436'),
  104. ('28701', '46945', '0', '0', '2436'),
  105. ('28701', '46946', '0', '0', '2436'),
  106. ('28701', '46947', '0', '0', '2436'),
  107. ('28701', '46948', '0', '0', '2436'),
  108. ('28701', '46949', '0', '0', '2436'),
  109. ('28701', '46950', '0', '0', '2436'),
  110. ('28701', '46951', '0', '0', '2436'),
  111. ('28701', '46952', '0', '0', '2436'),
  112. ('28701', '46953', '0', '0', '2436'),
  113. ('28701', '46956', '0', '0', '2436'),
  114. ('28701', '47007', '0', '0', '2436'),
  115. ('28701', '47008', '0', '0', '2436'),
  116. ('28701', '47010', '0', '0', '2436'),
  117. ('28701', '47011', '0', '0', '2436'),
  118. ('28701', '47012', '0', '0', '2436'),
  119. ('28701', '47015', '0', '0', '2436'),
  120. ('28701', '47016', '0', '0', '2436'),
  121. ('28701', '47017', '0', '0', '2436'),
  122. ('28701', '47018', '0', '0', '2436'),
  123. ('28701', '47019', '0', '0', '2436'),
  124. ('28701', '47020', '0', '0', '2436'),
  125. ('28701', '47021', '0', '0', '2436'),
  126. ('28701', '47022', '0', '0', '2436'),
  127. ('28701', '47023', '0', '0', '2436'),
  128. ('28701', '49112', '0', '0', '2436');
  129.  
  130. -- Tiffany Cartier <Jewelcrafting Supplies> 28721
  131. UPDATE creature_template SET `modelid3` = "0", `npcflag` = "131" WHERE entry=28721;
  132. DELETE FROM `creature` WHERE `id`='28721';
  133. INSERT INTO `creature` (`id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`)
  134. VALUES
  135. ('28721', '571', '1', '65535', '0', '0', '5871.99', '714.992', '643.099', '1.36568', '600', '0', '0', '10635', '0', '0', '0');
  136. DELETE FROM `npc_vendor` WHERE `entry`='28721';
  137. INSERT INTO `npc_vendor` (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`)
  138. VALUES
  139. ('28721', '20815', '0', '0', '0'),
  140. ('28721', '20824', '0', '0', '0'),
  141. ('28721', '40585', '0', '0', '0'),
  142. ('28721', '40586', '0', '0', '0'),
  143. ('28721', '41576', '0', '0', '2429'),
  144. ('28721', '41577', '0', '0', '2429'),
  145. ('28721', '41578', '0', '0', '2429'),
  146. ('28721', '41579', '0', '0', '2429'),
  147. ('28721', '41580', '0', '0', '2429'),
  148. ('28721', '41581', '0', '0', '2429'),
  149. ('28721', '41582', '0', '0', '2429'),
  150. ('28721', '41596', '0', '0', '2710'),
  151. ('28721', '41686', '0', '0', '2429'),
  152. ('28721', '41687', '0', '0', '2429'),
  153. ('28721', '41688', '0', '0', '2429'),
  154. ('28721', '41689', '0', '0', '2429'),
  155. ('28721', '41690', '0', '0', '2429'),
  156. ('28721', '41692', '0', '0', '2429'),
  157. ('28721', '41693', '0', '0', '2429'),
  158. ('28721', '41694', '0', '0', '2429'),
  159. ('28721', '41696', '0', '0', '2429'),
  160. ('28721', '41697', '0', '0', '2429'),
  161. ('28721', '41698', '0', '0', '2429'),
  162. ('28721', '41699', '0', '0', '2429'),
  163. ('28721', '41701', '0', '0', '2429'),
  164. ('28721', '41702', '0', '0', '2429'),
  165. ('28721', '41703', '0', '0', '2429'),
  166. ('28721', '41704', '0', '0', '2430'),
  167. ('28721', '41705', '0', '0', '2430'),
  168. ('28721', '41706', '0', '0', '2430'),
  169. ('28721', '41707', '0', '0', '2430'),
  170. ('28721', '41708', '0', '0', '2430'),
  171. ('28721', '41709', '0', '0', '2430'),
  172. ('28721', '41710', '0', '0', '2430'),
  173. ('28721', '41711', '0', '0', '2430'),
  174. ('28721', '41719', '0', '0', '2429'),
  175. ('28721', '41747', '0', '0', '2429'),
  176. ('28721', '42138', '0', '0', '2429'),
  177. ('28721', '42225', '0', '0', '2433'),
  178. ('28721', '42298', '0', '0', '2434'),
  179. ('28721', '42299', '0', '0', '2434'),
  180. ('28721', '42300', '0', '0', '2434'),
  181. ('28721', '42301', '0', '0', '2434'),
  182. ('28721', '42302', '0', '0', '2434'),
  183. ('28721', '42303', '0', '0', '2434'),
  184. ('28721', '42304', '0', '0', '2434'),
  185. ('28721', '42305', '0', '0', '2434'),
  186. ('28721', '42306', '0', '0', '2434'),
  187. ('28721', '42307', '0', '0', '2434'),
  188. ('28721', '42308', '0', '0', '2434'),
  189. ('28721', '42309', '0', '0', '2434'),
  190. ('28721', '42310', '0', '0', '2434'),
  191. ('28721', '42311', '0', '0', '2434'),
  192. ('28721', '42312', '0', '0', '2434'),
  193. ('28721', '42313', '0', '0', '2434'),
  194. ('28721', '42314', '0', '0', '2434'),
  195. ('28721', '42315', '0', '0', '2434'),
  196. ('28721', '42648', '0', '0', '2558'),
  197. ('28721', '42649', '0', '0', '2558'),
  198. ('28721', '42650', '0', '0', '2558'),
  199. ('28721', '42651', '0', '0', '2558'),
  200. ('28721', '42652', '0', '0', '2558'),
  201. ('28721', '42653', '0', '0', '2558'),
  202. ('28721', '43317', '0', '0', '2436'),
  203. ('28721', '43318', '0', '0', '2436'),
  204. ('28721', '43319', '0', '0', '2436'),
  205. ('28721', '43320', '0', '0', '2436'),
  206. ('28721', '43485', '0', '0', '2436'),
  207. ('28721', '43497', '0', '0', '2436'),
  208. ('28721', '43597', '0', '0', '2558');
  209.  
  210.  
  211. -- Titanium ore prospecting
  212. DELETE FROM `prospecting_loot_template` WHERE `entry`='36910';
  213. INSERT INTO `prospecting_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`)
  214. VALUES
  215. ('36910', '46849', '58.0176', '0', '1', '2', '0', '0', '0'),
  216. ('36910', '36932', '25.6149', '0', '1', '1', '0', '0', '0'),
  217. ('36910', '36917', '25.4335', '0', '1', '1', '0', '0', '0'),
  218. ('36910', '36929', '24.9293', '0', '1', '1', '0', '0', '0'),
  219. ('36910', '36926', '24.8775', '0', '1', '1', '0', '0', '0'),
  220. ('36910', '36923', '24.7738', '0', '1', '1', '0', '0', '0'),
  221. ('36910', '36920', '24.5264', '0', '1', '1', '0', '0', '0'),
  222. ('36910', '36931', '4.7498', '0', '1', '1', '0', '0', '0'),
  223. ('36910', '36928', '4.5401', '0', '1', '1', '0', '0', '0'),
  224. ('36910', '36934', '4.5048', '0', '1', '1', '0', '0', '0'),
  225. ('36910', '36919', '4.4977', '0', '1', '1', '0', '0', '0'),
  226. ('36910', '36922', '4.3445', '0', '1', '1', '0', '0', '0'),
  227. ('36910', '36925', '4.2715', '0', '1', '1', '0', '0', '0'),
  228. ('36910', '36918', '4.2621', '0', '1', '1', '0', '0', '0'),
  229. ('36910', '36930', '4.2197', '0', '1', '1', '0', '0', '0'),
  230. ('36910', '36927', '4.1914', '0', '1', '1', '0', '0', '0'),
  231. ('36910', '36924', '4.1584', '0', '1', '1', '0', '0', '0'),
  232. ('36910', '36933', '4.0712', '0', '1', '1', '0', '0', '0'),
  233. ('36910', '36921', '4.0029', '0', '1', '1', '0', '0', '0');
  234.  
  235. -- Icy Prism epic gems
  236. INSERT INTO `reference_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`)
  237. VALUES
  238. ('44943', '36919', '0', '1', '1', '1', '1', '0', '0', '0'),
  239. ('44943', '36922', '0', '1', '1', '1', '1', '0', '0', '0'),
  240. ('44943', '36925', '0', '1', '1', '1', '1', '0', '0', '0'),
  241. ('44943', '36928', '0', '1', '1', '1', '1', '0', '0', '0'),
  242. ('44943', '36931', '0', '1', '1', '1', '1', '0', '0', '0'),
  243. ('44943', '36934', '0', '1', '1', '1', '1', '0', '0', '0');
  244.  
  245.  
  246. -- JC Recipes Use text
  247. UPDATE item_template SET `description` = "Teaches you how to cut an Enduring Eye of Zul." WHERE entry=46897;
  248. UPDATE item_template SET `description` = "Teaches you how to cut a Steady Eye of Zul." WHERE entry=46898;
  249. UPDATE item_template SET `description` = "Teaches you how to cut a Vivid Eye of Zul." WHERE entry=46899;
  250. UPDATE item_template SET `description` = "Teaches you how to cut a Dazzling Eye of Zul." WHERE entry=46900;
  251. UPDATE item_template SET `description` = "Teaches you how to cut a Jagged Eye of Zul." WHERE entry=46901;
  252. UPDATE item_template SET `description` = "Teaches you how to cut a Timeless Eye of Zul." WHERE entry=46902;
  253. UPDATE item_template SET `description` = "Teaches you how to cut a Seer\'s Eye of Zul." WHERE entry=46903;
  254. UPDATE item_template SET `description` = "Teaches you how to cut a Forceful Eye of Zul." WHERE entry=46904;
  255. UPDATE item_template SET `description` = "Teaches you how to cut a Misty Eye of Zul." WHERE entry=46905;
  256. UPDATE item_template SET `description` = "Teaches you how to cut a Sundered Eye of Zul." WHERE entry=46906;
  257. UPDATE item_template SET `description` = "Teaches you how to cut a Shining Eye of Zul." WHERE entry=46907;
  258. UPDATE item_template SET `description` = "Teaches you how to cut a Tense Eye of Zul." WHERE entry=46908;
  259. UPDATE item_template SET `description` = "Teaches you how to cut a Lambent Eye of Zul." WHERE entry=46909;
  260. UPDATE item_template SET `description` = "Teaches you how to cut an Intricate Eye of Zul." WHERE entry=46910;
  261. UPDATE item_template SET `description` = "Teaches you how to cut a Radiant Eye of Zul." WHERE entry=46911;
  262. UPDATE item_template SET `description` = "Teaches you how to cut an Energized Eye of Zul." WHERE entry=46912;
  263. UPDATE item_template SET `description` = "Teaches you how to cut a Shattered Eye of Zul." WHERE entry=46913;
  264. UPDATE item_template SET `description` = "Teaches you how to cut an Opaque Eye of Zul." WHERE entry=46914;
  265. UPDATE item_template SET `description` = "Teaches you how to cut a Turbid Eye of Zul." WHERE entry=46915;
  266. UPDATE item_template SET `description` = "Teaches you how to cut a Runed Cardinal Ruby." WHERE entry=46916;
  267. UPDATE item_template SET `description` = "Teaches you how to cut a Bold Cardinal Ruby." WHERE entry=46917;
  268. UPDATE item_template SET `description` = "Teaches you how to cut a Delicate Cardinal Ruby." WHERE entry=46918;
  269. UPDATE item_template SET `description` = "Teaches you how to cut a Bright Cardinal Ruby." WHERE entry=46919;
  270. UPDATE item_template SET `description` = "Teaches you how to cut a Precise Cardinal Ruby." WHERE entry=46920;
  271. UPDATE item_template SET `description` = "Teaches you how to cut a Fractured Cardinal Ruby." WHERE entry=46921;
  272. UPDATE item_template SET `description` = "Teaches you how to cut a Subtle Cardinal Ruby." WHERE entry=46922;
  273. UPDATE item_template SET `description` = "Teaches you how to cut a Flashing Cardinal Ruby." WHERE entry=46923;
  274. UPDATE item_template SET `description` = "Teaches you how to cut a Solid Majestic Zircon." WHERE entry=46924;
  275. UPDATE item_template SET `description` = "Teaches you how to cut a Sparkling Majestic Zircon." WHERE entry=46925;
  276. UPDATE item_template SET `description` = "Teaches you how to cut a Stormy Majestic Zircon." WHERE entry=46926;
  277. UPDATE item_template SET `description` = "Teaches you how to cut a Lustrous Majestic Zircon." WHERE entry=46927;
  278. UPDATE item_template SET `description` = "Teaches you how to cut a Rigid King\'s Amber." WHERE entry=46928;
  279. UPDATE item_template SET `description` = "Teaches you how to cut a Smooth King\'s Amber." WHERE entry=46929;
  280. UPDATE item_template SET `description` = "Teaches you how to cut a Brilliant King\'s Amber." WHERE entry=46930;
  281. UPDATE item_template SET `description` = "Teaches you how to cut a Thick King\'s Amber." WHERE entry=46931;
  282. UPDATE item_template SET `description` = "Teaches you how to cut a Mystic King\'s Amber." WHERE entry=46932;
  283. UPDATE item_template SET `description` = "Teaches you how to cut a Quick King\'s Amber." WHERE entry=46933;
  284. UPDATE item_template SET `description` = "Teaches you how to cut a Balanced Dreadstone." WHERE entry=46934;
  285. UPDATE item_template SET `description` = "Teaches you how to cut a Sovereign Dreadstone." WHERE entry=46935;
  286. UPDATE item_template SET `description` = "Teaches you how to cut a Glowing Dreadstone." WHERE entry=46936;
  287. UPDATE item_template SET `description` = "Teaches you how to cut a Purified Dreadstone." WHERE entry=46937;
  288. UPDATE item_template SET `description` = "Teaches you how to cut a Shifting Dreadstone." WHERE entry=46938;
  289. UPDATE item_template SET `description` = "Teaches you how to cut a Royal Dreadstone." WHERE entry=46939;
  290. UPDATE item_template SET `description` = "Teaches you how to cut a Regal Dreadstone." WHERE entry=46940;
  291. UPDATE item_template SET `description` = "Teaches you how to cut a Defender\'s Dreadstone." WHERE entry=46941;
  292. UPDATE item_template SET `description` = "Teaches you how to cut a Guardian\'s Dreadstone." WHERE entry=46942;
  293. UPDATE item_template SET `description` = "Teaches you how to cut a Mysterious Dreadstone." WHERE entry=46943;
  294. UPDATE item_template SET `description` = "Teaches you how to cut a Puissant Dreadstone." WHERE entry=46944;
  295. UPDATE item_template SET `description` = "Teaches you how to cut an Infused Dreadstone." WHERE entry=46945;
  296. UPDATE item_template SET `description` = "Teaches you how to cut a Tenuous Dreadstone." WHERE entry=46946;
  297. UPDATE item_template SET `description` = "Teaches you how to cut a Luminous Ametrine." WHERE entry=46947;
  298. UPDATE item_template SET `description` = "Teaches you how to cut an Inscribed Ametrine." WHERE entry=46948;
  299. UPDATE item_template SET `description` = "Teaches you how to cut a Deadly Ametrine." WHERE entry=46949;
  300. UPDATE item_template SET `description` = "Teaches you how to cut a Potent Ametrine." WHERE entry=46950;
  301. UPDATE item_template SET `description` = "Teaches you how to cut a Veiled Ametrine." WHERE entry=46951;
  302. UPDATE item_template SET `description` = "Teaches you how to cut a Durable Ametrine." WHERE entry=46952;
  303. UPDATE item_template SET `description` = "Teaches you how to cut an Etched Ametrine" WHERE entry=46953;
  304. UPDATE item_template SET `description` = "Teaches you how to cut a Pristine Ametrine." WHERE entry=46956;
  305. UPDATE item_template SET `description` = "Teaches you how to cut a Reckless Ametrine." WHERE entry=47007;
  306. UPDATE item_template SET `description` = "Teaches you how to cut a Glinting Ametrine." WHERE entry=47008;
  307. UPDATE item_template SET `description` = "Teaches you how to cut an Accurate Ametrine." WHERE entry=47010;
  308. UPDATE item_template SET `description` = "Teaches you how to cut a Wicked Ametrine." WHERE entry=47011;
  309. UPDATE item_template SET `description` = "Teaches you how to cut a Glimmering Ametrine." WHERE entry=47012;
  310. UPDATE item_template SET `description` = "Teaches you how to cut a Champion\'s Ametrine." WHERE entry=47015;
  311. UPDATE item_template SET `description` = "Teaches you how to cut an Empowered Ametrine." WHERE entry=47016;
  312. UPDATE item_template SET `description` = "Teaches you how to cut a Stalwart Ametrine." WHERE entry=47017;
  313. UPDATE item_template SET `description` = "Teaches you how to cut a Resplendent Ametrine." WHERE entry=47018;
  314. UPDATE item_template SET `description` = "Teaches you how to cut a Fierce Ametrine." WHERE entry=47019;
  315. UPDATE item_template SET `description` = "Teaches you how to cut a Deft Ametrine." WHERE entry=47020;
  316. UPDATE item_template SET `description` = "Teaches you how to cut a Lucent Ametrine." WHERE entry=47021;
  317. UPDATE item_template SET `description` = "Teaches you how to cut a Resolute Ametrine." WHERE entry=47022;
  318. UPDATE item_template SET `description` = "Teaches you how to cut a Stark Ametrine." WHERE entry=47023;
  319. UPDATE item_template SET `description` = "Teaches you how to cut a Nightmare Tear." WHERE entry=49112;
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!