[Missing loot][Timeless Island] Bufo

[Eldarion]

• NPC: http://www.db.pandawow.me?npc=72775/bufo
  
• Issue: does not drop http://www.db.pandawow.me?item=104169/gulp-froglet
  
• Date: 28/02/2015
  
• Priority: 8/10
  
• Realm: x100
  

 

Loot table x1

 

DELETE FROM `creature_loot_template` WHERE `entry`=72775;
INSERT INTO `creature_loot_template` (`entry`, `item`, `chanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(72775, 103642, 4, 1, 0, 1, 1),
(72775, 103643, 4, 1, 0, 1, 1),
(72775, 103641, 4, 1, 0, 1, 1),
(72775, 103982, 3, 1, 0, 1, 1),
(72775, 104169, 3, 1, 0, 1, 1),
(72775, 102318, 2, 1, 0, 1, 1),
(72775, 102291, 1.4, 1, 0, 1, 1),
(72775, 104241, 1, 1, 0, 1, 1),
(72775, 104347, 1, 1, 0, 1, 1),
(72775, 102285, 0.9, 1, 0, 1, 1),
(72775, 102273, 0.9, 1, 0, 1, 1),
(72775, 102321, 0.8, 1, 0, 1, 1),
(72775, 102288, 0.8, 1, 0, 1, 1),
(72775, 102271, 0.8, 1, 0, 1, 1),
(72775, 102269, 0.8, 1, 0, 1, 1),
(72775, 102264, 0.8, 1, 0, 1, 1),
(72775, 102265, 0.8, 1, 0, 1, 1),
(72775, 102266, 0.8, 1, 0, 1, 1),
(72775, 102267, 0.8, 1, 0, 1, 1),
(72775, 102290, 0.7, 1, 0, 1, 1),
(72775, 102286, 0.7, 1, 0, 1, 1),
(72775, 102287, 0.7, 1, 0, 1, 1),
(72775, 102289, 0.7, 1, 0, 1, 1),
(72775, 102283, 0.7, 1, 0, 1, 1),
(72775, 102278, 0.7, 1, 0, 1, 1),
(72775, 102322, 0.7, 1, 0, 1, 1),
(72775, 102277, 0.7, 1, 0, 1, 1),
(72775, 102279, 0.7, 1, 0, 1, 1),
(72775, 102280, 0.7, 1, 0, 1, 1),
(72775, 102281, 0.7, 1, 0, 1, 1),
(72775, 102282, 0.7, 1, 0, 1, 1),
(72775, 102323, 0.7, 1, 0, 1, 1),
(72775, 102270, 0.7, 1, 0, 1, 1),
(72775, 102272, 0.7, 1, 0, 1, 1),
(72775, 102274, 0.7, 1, 0, 1, 1),
(72775, 102320, 0.7, 1, 0, 1, 1),
(72775, 102268, 0.7, 1, 0, 1, 1),
(72775, 102284, 0.6, 1, 0, 1, 1),
(72775, 102276, 0.6, 1, 0, 1, 1),
(72775, 102275, 0.6, 1, 0, 1, 1),
(72775, 102263, 0.6, 1, 0, 1, 1),
(72775, 104345, 0.4, 1, 0, 1, 1);
UPDATE `creature_template` SET `lootid`=72775 WHERE `entry`=72775;

INSERT INTO `creature_currency` (`creature_id`, `CurrencyId1`, `CurrencyId2`, `CurrencyId3`, `CurrencyCount1`, `CurrencyCount2`, `CurrencyCount3`) VALUES
(72775, 777, 738, 0, 48, 33, 0);

 

 

Loot table x20 as on x100 realm

 

DELETE FROM `creature_loot_template` WHERE `entry`=72775;
INSERT INTO `creature_loot_template` (`entry`, `item`, `chanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(72775, 103642, 80, 1, 0, 1, 1),
(72775, 103643, 80, 1, 0, 1, 1),
(72775, 103641, 80, 1, 0, 1, 1),
(72775, 103982, 60, 1, 0, 1, 1),
(72775, 104169, 60, 1, 0, 1, 1),
(72775, 102318, 40, 1, 0, 1, 1),
(72775, 102291, 28, 1, 0, 1, 1),
(72775, 104241, 20, 1, 0, 1, 1),
(72775, 104347, 20, 1, 0, 1, 1),
(72775, 102285, 18, 1, 0, 1, 1),
(72775, 102273, 18, 1, 0, 1, 1),
(72775, 102321, 16, 1, 0, 1, 1),
(72775, 102288, 16, 1, 0, 1, 1),
(72775, 102271, 16, 1, 0, 1, 1),
(72775, 102269, 16, 1, 0, 1, 1),
(72775, 102264, 16, 1, 0, 1, 1),
(72775, 102265, 16, 1, 0, 1, 1),
(72775, 102266, 16, 1, 0, 1, 1),
(72775, 102267, 16, 1, 0, 1, 1),
(72775, 102290, 14, 1, 0, 1, 1),
(72775, 102286, 14, 1, 0, 1, 1),
(72775, 102287, 14, 1, 0, 1, 1),
(72775, 102289, 14, 1, 0, 1, 1),
(72775, 102283, 14, 1, 0, 1, 1),
(72775, 102278, 14, 1, 0, 1, 1),
(72775, 102322, 14, 1, 0, 1, 1),
(72775, 102277, 14, 1, 0, 1, 1),
(72775, 102279, 14, 1, 0, 1, 1),
(72775, 102280, 14, 1, 0, 1, 1),
(72775, 102281, 14, 1, 0, 1, 1),
(72775, 102282, 14, 1, 0, 1, 1),
(72775, 102323, 14, 1, 0, 1, 1),
(72775, 102270, 14, 1, 0, 1, 1),
(72775, 102272, 14, 1, 0, 1, 1),
(72775, 102274, 14, 1, 0, 1, 1),
(72775, 102320, 14, 1, 0, 1, 1),
(72775, 102268, 14, 1, 0, 1, 1),
(72775, 102284, 12, 1, 0, 1, 1),
(72775, 102276, 12, 1, 0, 1, 1),
(72775, 102275, 12, 1, 0, 1, 1),
(72775, 102263, 12, 1, 0, 1, 1),
(72775, 104345, 8, 1, 0, 1, 1);
UPDATE `creature_template` SET `lootid`=72775 WHERE `entry`=72775;

INSERT INTO `creature_currency` (`creature_id`, `CurrencyId1`, `CurrencyId2`, `CurrencyId3`, `CurrencyCount1`, `CurrencyCount2`, `CurrencyCount3`) VALUES
(72775, 777, 738, 0, 48, 33, 0);

 

Edited February 28, 2015 by Eldarion
added table from wowhead

[Wuvius]

Already Fixed