API tools faq
paste
Advertisement
gecko32

Engineering loot

gecko32
Sep 15th, 2011
219
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 8.97 KB | None | 0 0
raw download clone embed print report
  1. -- Skin loot entry
  2. SET @LibraryLaborer := 29724;
  3. SET @UldarBoss := 29725;
  4. SET @AirStrip := 29726;
  5. SET @ReavandDispo := 29727;
  6. SET @HallsofStone := 29728;
  7. SET @Dirkee := 29729;
  8. SET @Recovery := 29730;
  9. -- Ref Loot Entry
  10. SET @UldarBossRef := 60001;
  11. SET @AirStripRef := 60002;
  12. SET @HallsofStoneRef := 60003;
  13. SET @ReavandDispoRef := 60004;
  14. SET @LibraryLaborerRef := 60005;
  15. -- Add loot to the skinning table
  16. DELETE FROM `skinning_loot_template` WHERE `entry`=@Recovery;
  17. INSERT INTO `skinning_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
  18. (@Recovery, 41338, 42, 1, 0, 1, 3), -- Sprung Whirlygig
  19. (@Recovery, 41337, 44, 1, 0, 1, 3), -- Whizzed out Gizmo
  20. (@Recovery, 39690, 9, 1, 0, 1, 3), -- Volatile Blasting trigger
  21. (@Recovery, 39681, 4, 1, 0, 2, 4), -- Handfull of copper bolts
  22. (@Recovery, 49050, 0.5, 1, 0, 1, 1), -- jeeves
  23. (@Recovery, 39682, 0.5, 1, 0, 1, 1); -- Overcharged Capacitor
  24. DELETE FROM `skinning_loot_template` WHERE `entry`=@Dirkee;
  25. INSERT INTO `skinning_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
  26. (@Dirkee, 41338, 42, 1, 0, 1, 3), -- Sprung Whirlygig
  27. (@Dirkee, 41337, 44.5, 1, 0, 1, 3), -- Whizzed out Gizmo
  28. (@Dirkee, 39690, 10, 1, 0, 1, 3), -- Volatile Blasting trigger
  29. (@Dirkee, 39681, 3, 1, 0, 2, 4), -- Handfull of copper bolts
  30. (@Dirkee, 49050, 0.5, 1, 0, 1, 1); -- jeeves
  31. DELETE FROM `skinning_loot_template` WHERE `entry`=@LibraryLaborer ;
  32. INSERT INTO `skinning_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
  33. (@LibraryLaborer , 1, 100, 1, 0, -60005, 1);
  34. DELETE FROM `skinning_loot_template` WHERE `entry`=@ReavandDispo;
  35. INSERT INTO `skinning_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
  36. (@ReavandDispo, 1, 100, 1, 0, -60004, 1);
  37. DELETE FROM `skinning_loot_template` WHERE `entry`=@HallsofStone;
  38. INSERT INTO `skinning_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
  39. (@HallsofStone, 1, 100, 1, 0, -60003, 1);
  40. DELETE FROM `skinning_loot_template` WHERE `entry`=@AirStrip;
  41. INSERT INTO `skinning_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
  42. (@AirStrip, 1, 100, 1, 0, -60002, 1);
  43. DELETE FROM `skinning_loot_template` WHERE `entry`=@UldarBoss;
  44. INSERT INTO `skinning_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
  45. (@UldarBoss, 1, 100, 1, 0, -60001, 1);
  46. -- Add loot to the reference table
  47. DELETE FROM `reference_loot_template` WHERE `entry`=@AirStripRef;
  48. INSERT INTO `reference_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
  49. (@AirStripRef, 41338, 33, 1, 0, 1, 1), -- Sprung Whirlygig
  50. (@AirStripRef, 41337, 42, 1, 0, 1, 1), -- Whizzed out Gizmo
  51. (@AirStripRef, 39690, 13, 1, 0, 1, 3), -- Volatile Blasting trigger
  52. (@AirStripRef, 39681, 10, 1, 0, 1, 4), -- Handfull of copper bolts
  53. (@AirStripRef, 39686, 1.2, 1, 0, 1, 1), -- Frost steel Tube
  54. (@AirStripRef, 49050, 0.8, 1, 0, 1, 1); -- jeeves
  55. DELETE FROM `reference_loot_template` WHERE `entry`=@ReavandDispoRef;
  56. INSERT INTO `reference_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
  57. (@ReavandDispoRef, 41338, 40, 1, 0, 1, 3), -- Sprung Whirlygig
  58. (@ReavandDispoRef, 41337, 40, 1, 0, 1, 3), -- Whizzed out Gizmo
  59. (@ReavandDispoRef, 39690, 9.5, 1, 0, 1, 3), -- Volatile Blasting trigger
  60. (@ReavandDispoRef, 39681, 9.5, 1, 0, 2, 4), -- Handfull of copper bolts
  61. (@ReavandDispoRef, 39686, 0.5, 1, 0, 1, 1), -- Frost steel Tube
  62. (@ReavandDispoRef, 49050, 0.5, 1, 0, 1, 1); -- jeeves
  63. DELETE FROM `reference_loot_template` WHERE `entry`=@LibraryLaborerRef;
  64. INSERT INTO `reference_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
  65. (@LibraryLaborerRef, 41338, 43, 1, 0, 1, 3), -- Sprung Whirlygig
  66. (@LibraryLaborerRef, 41337, 42, 1, 0, 1, 3), -- Whizzed out Gizmo
  67. (@LibraryLaborerRef, 39690, 9, 1, 0, 1, 3), -- Volatile Blasting trigger
  68. (@LibraryLaborerRef, 39681, 4, 1, 0, 2, 4), -- Handfull of copper bolts
  69. (@LibraryLaborerRef, 49050, 1, 1, 0, 1, 1), -- jeeves
  70. (@LibraryLaborerRef, 39686, 0.5, 1, 0, 1, 1), -- Frost steel Tube
  71. (@LibraryLaborerRef, 39682, 0.5, 1, 0, 1, 1); -- Overcharged Capacitor
  72. DELETE FROM `reference_loot_template` WHERE `entry`=@HallsofStoneRef;
  73. INSERT INTO `reference_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
  74. (@HallsofStoneRef, 41338, 43.5, 1, 0, 1, 3), -- Sprung Whirlygig
  75. (@HallsofStoneRef, 41337, 42, 1, 0, 1, 3), -- Whizzed out Gizmo
  76. (@HallsofStoneRef, 39690, 8, 1, 0, 1, 3), -- Volatile Blasting trigger
  77. (@HallsofStoneRef, 39681, 5, 1, 0, 2, 4), -- Handfull of copper bolts
  78. (@HallsofStoneRef, 49050, 0.5, 1, 0, 1, 1), -- jeeves
  79. (@HallsofStoneRef, 39686, 0.5, 1, 0, 1, 1), -- Frost steel Tube
  80. (@HallsofStoneRef, 39682, 0.5, 1, 0, 1, 1); -- Overcharged Capacitor
  81. DELETE FROM `reference_loot_template` WHERE `entry`=@UldarBossRef;
  82. INSERT INTO `reference_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
  83. (@UldarBossRef, 35627, 43, 1, 0, 2, 10), -- Eternal Shadow
  84. (@UldarBossRef, 35624, 42, 1, 0, 4, 10), -- Eternal Earth
  85. (@UldarBossRef, 35623, 43, 1, 0, 2, 6), -- Eternal Air
  86. (@UldarBossRef, 36860, 42, 1, 0, 2, 6), -- Eternal Fire
  87. (@UldarBossRef, 39690, 30, 1, 0, 16, 19), -- Volatile Blasting trigger
  88. (@UldarBossRef, 39686, 26, 1, 0, 2, 3), -- Frost steel Tube
  89. (@UldarBossRef, 39682, 22, 1, 0, 5, 5), -- Overcharged Capacitor
  90. (@UldarBossRef, 39681, 21, 1, 0, 8, 10), -- Handfull of copper bolts
  91. (@UldarBossRef, 49050, 2, 1, 0, 1, 1); -- jeeves
  92. -- Library Guardian and Mechagnome Laborer
  93. -- Add the skinloot id to Mechagnome Laborer
  94. UPDATE `creature_template` SET `skinloot`=@LibraryLaborer WHERE `entry`=29389 LIMIT 1;
  95. -- Add the skinloot id to Library Guardian
  96. UPDATE `creature_template` SET `skinloot`=@LibraryLaborer WHERE `entry`=29724 LIMIT 1;
  97. -- Stromforged Reaver and XB-488 Disposalbot
  98. -- Add the skinloot id to XB-488 Disposalbot
  99. UPDATE `creature_template` SET `skinloot`=@ReavandDispo WHERE `entry`=34273 LIMIT 1;
  100. UPDATE `creature_template` SET `skinloot`=@ReavandDispo WHERE `entry`=34274 LIMIT 1; -- hard mode
  101. -- Add the skinloot id to Stromforged Reaver
  102. UPDATE `creature_template` SET `skinloot`=@ReavandDispo WHERE `entry`=29382 LIMIT 1;
  103. -- Add the skinloot id to Dirkee
  104. UPDATE `creature_template` SET `skinloot`=@Dirkee WHERE `entry`=32500 LIMIT 1;
  105. -- Add the skinloot id to Parts Recovery Technician
  106. UPDATE `creature_template` SET `skinloot`=@Recovery WHERE `entry`=34267 LIMIT 1;
  107. UPDATE `creature_template` SET `skinloot`=@Recovery WHERE `entry`=34268 LIMIT 1; -- hard mode
  108. -- AirStrip Mobs
  109. -- Add the skinloot id to Fumblub Gearwind
  110. UPDATE `creature_template` SET `skinloot`=@AirStrip WHERE `entry`=32358 LIMIT 1;
  111. -- Add the skinloot id to Scavenge-bot 005-B6
  112. UPDATE `creature_template` SET `skinloot`=@AirStrip WHERE `entry`=25792 LIMIT 1;
  113. -- Add the skinloot id to Defendo-tank 66D
  114. UPDATE `creature_template` SET `skinloot`=@AirStrip WHERE `entry`=25758 LIMIT 1;
  115. -- Add the skinloot id to Scavenge-bot 004-A8
  116. UPDATE `creature_template` SET `skinloot`=@AirStrip WHERE `entry`=25752 LIMIT 1;
  117. -- Add the skinloot id to Sentry-bot 57-K
  118. UPDATE `creature_template` SET `skinloot`=@AirStrip WHERE `entry`=25753 LIMIT 1;
  119. -- Add the skinloot id to Fizzcrank Mechagnome
  120. UPDATE `creature_template` SET `skinloot`=@AirStrip WHERE `entry`=25814 LIMIT 1;
  121. -- Add the skinloot id to 55-D Collect-a-tron
  122. UPDATE `creature_template` SET `skinloot`=@AirStrip WHERE `entry`=25793 LIMIT 1;
  123. -- Halls of Stone mobs
  124. -- Add the skinloot id to Lightning Construct
  125. UPDATE `creature_template` SET `skinloot`=@HallsofStone WHERE `entry`=27972 LIMIT 1;
  126. UPDATE `creature_template` SET `skinloot`=@HallsofStone WHERE `entry`=31383 LIMIT 1; -- Heroic
  127. -- Add the skinloot id to Unrelenting Construct
  128. UPDATE `creature_template` SET `skinloot`=@HallsofStone WHERE `entry`=27971 LIMIT 1;
  129. UPDATE `creature_template` SET `skinloot`=@HallsofStone WHERE `entry`=31387 LIMIT 1; -- Heroic
  130. -- Uldar Bosses
  131. -- Add the skinloot id to Leviathan Mk II
  132. UPDATE `creature_template` SET `skinloot`=@UldarBoss WHERE `entry`=34332 LIMIT 1;
  133. UPDATE `creature_template` SET `skinloot`=@UldarBoss WHERE `entry`=34106 LIMIT 1; -- hard mode
  134. -- Add the skinloot id to Flame Leviathan
  135. UPDATE `creature_template` SET `skinloot`=@UldarBoss WHERE `entry`=33113 LIMIT 1;
  136. UPDATE `creature_template` SET `skinloot`=@UldarBoss WHERE `entry`=34003 LIMIT 1; -- hard mode
  137. -- Add the skinloot id to XT-002 Deconstructor
  138. UPDATE `creature_template` SET `skinloot`=@UldarBoss WHERE `entry`=33293 LIMIT 1;
  139. UPDATE `creature_template` SET `skinloot`=@UldarBoss WHERE `entry`=33885 LIMIT 1; -- hard mode
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!