PageRenderTime 29ms CodeModel.GetById 20ms RepoModel.GetById 0ms app.codeStats 0ms

/sql/old/4.3.4/TDB01_to_TDB02_updates/world/205_creature_loot_template.sql

https://gitlab.com/Lbniese/TrinityCore_434
SQL | 147 lines | 86 code | 39 blank | 22 comment | 0 complexity | a13712e7535612e11e35fe03e027426a MD5 | raw file
    

  1. -- *** FIXES FOR DUN MOROGH ***
    2. 

  2. 

  3. -- Quest #24475 fix : All the Other Stuff.  Add the quest loot to the timber wolf, young wolf and boar
    4. 

  4. DELETE FROM `creature_loot_template` WHERE `entry` = 708 AND `item` = 49747;
    5. 

  5. INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (708, 49747, -39, 1, 0, 1, 1);
    6. 

  6. DELETE FROM `creature_loot_template` WHERE `entry` = 705 AND `item` = 49748;
    7. 

  7. INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (705, 49748, -64, 1, 0, 1, 1);
    8. 

  8. DELETE FROM `creature_loot_template` WHERE `entry` = 704 AND `item` = 49748;
    9. 

  9. INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (704, 49748, -70, 1, 0, 1, 1);
    10. 

  10. 

  11. 

  12. -- Quest #24486 fix : Make Hay While the Sun Shines.  Add the Priceless Rockjaw Artifact loot to the Rockjaw Scavenger so you can complete the quest
    13. 

  13. DELETE FROM `creature_loot_template` WHERE `entry` = 37105 AND `item` = 49751;
    14. 

  14. INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (37105, 49751, -90, 1, 0, 1, 1);
    15. 

  15. UPDATE `creature_template` SET `lootid` = 37105 WHERE `entry` = 37105; 
    16. 

  16. 

  17. 

  18. -- Quest #384 fix: Adding the tender boar meat to the crag boar, the 41% rate is from wowhead
    19. 

  19. DELETE FROM `creature_loot_template` WHERE `entry` = 1125 AND `item` = 60496;
    20. 

  20. INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (1125, 60496, -41, 1, 0, 1, 1);
    21. 

  21. -- Quest #384 fix: Last gossip_menu_id was 1297 but it was preventing players from trading with the innkeeper and setting their heartstone in that region
    22. 

  22. UPDATE `creature_template` SET `gossip_menu_id` = 0 WHERE `entry` = 1247; 
    23. 

  23. 

  24. 

  25. -- Quest #25997 fix: Adding Dark Iron Attack Plans
    26. 

  26. DELETE FROM `creature_loot_template` WHERE `entry` = 6124 AND `item` = 56264;
    27. 

  27. INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (6124, 56264, -100, 1, 0, 1, 1);
    28. 

  28. 

  29. 

  30. 

  31. -- *** FIXES FOR LOCH MODAN ***
    32. 

  32. 

  33. -- Quest #26845 fix: Adding the Foreman Sharpsneer's Head
    34. 

  34. DELETE FROM `creature_loot_template` WHERE `entry` = 44198 AND `item` = 60404;
    35. 

  35. INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (44198, 60404, -100, 1, 0, 1, 1);
    36. 

  36. UPDATE `creature_template` SET `lootid` = 44198 WHERE `entry` = 44198; 
    37. 

  37. 

  38. 

  39. -- Quest #26842 fix: Adding Mosshide Ear
    40. 

  40. DELETE FROM `creature_loot_template` WHERE `entry` = 44162 AND `item` = 60402;
    41. 

  41. DELETE FROM `creature_loot_template` WHERE `entry` = 44161 AND `item` = 60402;
    42. 

  42. DELETE FROM `creature_loot_template` WHERE `entry` = 45384 AND `item` = 60402;
    43. 

  43. INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES 
    44. 

  44. (44162, 60402, -100, 1, 0, 1, 1),
    45. 

  45. (44161, 60402, -100, 1, 0, 1, 1),
    46. 

  46. (45384, 60402, -100, 1, 0, 1, 1);
    47. 

  47. UPDATE `creature_template` SET `lootid` = 44162 WHERE `entry` = 44162; 
    48. 

  48. UPDATE `creature_template` SET `lootid` = 44161 WHERE `entry` = 44161; 
    49. 

  49. UPDATE `creature_template` SET `lootid` = 45384 WHERE `entry` = 45384; 
    50. 

  50. 

  51. 

  52. -- Quest #26928 fix: Adding Murloc Scent Gland, the drop rates are from wowhead
    53. 

  53. DELETE FROM `creature_loot_template` WHERE `entry` = 44176 AND `item` = 60511;
    54. 

  54. DELETE FROM `creature_loot_template` WHERE `entry` = 44292 AND `item` = 60511;
    55. 

  55. DELETE FROM `creature_loot_template` WHERE `entry` = 45401 AND `item` = 60511;
    56. 

  56. INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES 
    57. 

  57. (44176, 60511, -45, 1, 0, 1, 1),
    58. 

  58. (44292, 60511, -38, 1, 0, 1, 1),
    59. 

  59. (45401, 60511, -30, 1, 0, 1, 1);
    60. 

  60. UPDATE `creature_template` SET `lootid` = 44176 WHERE `entry` = 44176; 
    61. 

  61. UPDATE `creature_template` SET `lootid` = 44292 WHERE `entry` = 44292; 
    62. 

  62. UPDATE `creature_template` SET `lootid` = 45401 WHERE `entry` = 45401; 
    63. 

  63. 

  64. 

  65. -- Quest #26929 fix: Adding Intact Crocolisk Jaw, the 44% drop rates is from wowhead
    66. 

  66. DELETE FROM `creature_loot_template` WHERE `entry` = 1693 AND `item` = 57131;
    67. 

  67. INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES 
    68. 

  68. (1693, 57131, -44, 1, 0, 1, 1);
    69. 

  69. 

  70. 

  71. -- Quest #26860 fix: Adding Bear Rump, the 56% drop rates is from wowhead
    72. 

  72. DELETE FROM `creature_loot_template` WHERE `entry` = 1186 AND `item` = 60497;
    73. 

  73. INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES 
    74. 

  74. (1186, 60497, -56, 1, 0, 1, 1);
    75. 

  75. 

  76. 

  77. -- Quest #27031 Wing Nut - fix: Adding the Pristine Flight Feather, the 34% drop rate is from wowhead
    78. 

  78. DELETE FROM `creature_loot_template` WHERE `entry` = 44628 AND `item` = 60792;
    79. 

  79. INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) 
    80. 

  80. VALUES (44628, 60792, -34, 1, 0, 1, 1);
    81. 

  81. UPDATE `creature_template` SET `lootid` = 44628 WHERE `entry` = 44628; 
    82. 

  82. 

  83. 

  84. -- Quest #27028 Hornet Hunting - fix: Adding the Glassy Hornet Wing, the drop % is from wowhead
    85. 

  85. DELETE FROM `creature_loot_template` WHERE `entry` = 44620 AND `item` = 60754;
    86. 

  86. DELETE FROM `creature_loot_template` WHERE `entry` = 45402 AND `item` = 60754;
    87. 

  87. INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES 
    88. 

  88. (44620, 60754, -41, 1, 0, 1, 1),
    89. 

  89. (45402, 60754, -32, 1, 0, 1, 1);
    90. 

  90. UPDATE `creature_template` SET `lootid` = 44620 WHERE `entry` = 44620; 
    91. 

  91. UPDATE `creature_template` SET `lootid` = 45402 WHERE `entry` = 45402; 
    92. 

  92. 

  93. 

  94. -- Quest #27030 Foxtails by the handful - fix: Adding the Fluffy Fox Tail, the drop % is from wowhead
    95. 

  95. DELETE FROM `creature_loot_template` WHERE `entry` = 44635 AND `item` = 60755;
    96. 

  96. DELETE FROM `creature_loot_template` WHERE `entry` = 45380 AND `item` = 60755;
    97. 

  97. INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES 
    98. 

  98. (44635, 60755, -81, 1, 0, 1, 1),
    99. 

  99. (45380, 60755, -53, 1, 0, 1, 1);
    100. 

  100. UPDATE `creature_template` SET `lootid` = 44635 WHERE `entry` = 44635; 
    101. 

  101. UPDATE `creature_template` SET `lootid` = 45380 WHERE `entry` = 45380; 
    102. 

  102. 

  103. 

  104. 

  105. -- *** FIXES FOR THE WETLANDS ***
    106. 

  106. 

  107. -- Quest #25800 When Life Gives You Crabs - fix: Adding the Meaty Crawler Claw, the drop % is from wowhead
    108. 

  108. DELETE FROM `creature_loot_template` WHERE `entry` = 44116 AND `item` = 56013;
    109. 

  109. DELETE FROM `creature_loot_template` WHERE `entry` = 41295 AND `item` = 56013;
    110. 

  110. INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES 
    111. 

  111. (44116, 56013, -43, 1, 0, 1, 1),
    112. 

  112. (41295, 56013, -36, 1, 0, 1, 1);
    113. 

  113. UPDATE `creature_template` SET `lootid` = 44116 WHERE `entry` = 44116; 
    114. 

  114. UPDATE `creature_template` SET `lootid` = 41295 WHERE `entry` = 41295;
    115. 

  115. 

  116. 

  117. -- Quest #25723 Thresh Out of Luck - fix: Adding the Threshadon Chunk, the drop % is from wowhead
    118. 

  118. DELETE FROM `creature_loot_template` WHERE `entry` = 41137 AND `item` = 55232;
    119. 

  119. INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES 
    120. 

  120. (41137, 55232, -94, 1, 0, 1, 1);
    121. 

  121. UPDATE `creature_template` SET `lootid` = 41137 WHERE `entry` = 41137; 
    122. 

  122. 

  123. 

  124. -- Quest #25849 When Archaeology Attacks - fix: Adding the Fossilized Bone, the drop % is from wowhead
    125. 

  125. DELETE FROM `creature_loot_template` WHERE `entry` = 41388 AND `item` = 56083;
    126. 

  126. DELETE FROM `creature_loot_template` WHERE `entry` = 44226 AND `item` = 56083;
    127. 

  127. INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES 
    128. 

  128. (41388, 56083, -68, 1, 0, 1, 3),
    129. 

  129. (44226, 56083, -5, 1, 0, 1, 3);
    130. 

  130. UPDATE `creature_template` SET `lootid` = 41388 WHERE `entry` = 41388; 
    131. 

  131. UPDATE `creature_template` SET `lootid` = 44226 WHERE `entry` = 44226; 
    132. 

  132. 

  133. 

  134. -- Quest #25853 Tooling Around - fix: Adding the Archaeologist's Tools
    135. 

  135. DELETE FROM `gameobject_loot_template` WHERE `entry` = 29626 AND `item` = 56082;
    136. 

  136. INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES 
    137. 

  137. (29626, 56082, -100, 1, 0, 1, 1);
    138. 

  138. 

  139. 

  140. 

  141. -- *** FIXES FOR THE HINTERLANDS ***
    142. 

  142. 

  143. -- Quest #26490 (Alliance) & #26283 (Horde) Prime Slime - fix: Adding the Direglob Sample
    144. 

  144. DELETE FROM `creature_loot_template` WHERE `entry` = 42592 AND `item` = 58082;
    145. 

  145. INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES 
    146. 

  146. (42592, 58082, -100, 1, 0, 1, 1);
    147. 

  147. UPDATE `creature_template` SET `lootid` = 42592 WHERE `entry` = 42592; 
    148. 

  148.