Rnd loot fix

[Tavari]

-- Large Ammo Crate (http/www.wowhead.com/object=234633/large-ammo-crate)
-- Object ID #234633
DELETE FROM `gameobject_loot_template` WHERE `entry`='234633';
INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`, `itembonuses`) VALUES
('234633', '120945', '15', '1', '0', '1', '1', '');

-- Small Ammo Pile (http://www.wowhead.com/object=234635/small-ammo-pile)
-- Object ID #234635
DELETE FROM `gameobject_loot_template` WHERE `entry`='234635';
INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`, `itembonuses`) VALUES
('234635', '120945', '16', '1', '0', '1', '2', '');

 -- Small Ammo Barrel (http://www.wowhead.com/object=234636/small-ammo-barrel)
-- Object ID # 234636
DELETE FROM `gameobject_loot_template` WHERE `entry`='234636 ';
INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`, `itembonuses`) VALUES
('234636 ', '120945', '16', '1', '0', '1', '2', '');

 -- Stonemaul Slaver (http://www.wowhead.com/npc=75835/stonemaul-slaver)
-- Object ID #75835
DELETE FROM `gameobject_loot_template` WHERE `entry`='75835 ';
INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`, `itembonuses`) VALUES
('75835 ', '117491', '60', '1', '0', '1', '3', ''),
('75835 ', '108898', '31', '1', '0', '1', '3', ''),
('75835 ', '116481', '0.06', '1', '0', '1', '1', ''),
('75835 ', '106440', '0.04', '1', '0', '1', '1', ''),
('75835 ', '106442', '0.04', '1', '0', '1', '1', ''),
('75835 ', '116520', '0.04', '1', '0', '1', '1', ''),
('75835 ', '106473', '0.04', '1', '0', '1', '1', ''),
('75835 ', '106507', '0.04', '1', '0', '1', '1', ''),
('75835 ', '106425', '0.04', '1', '0', '1', '1', ''),
('75835 ', '106458', '0.04', '1', '0', '1', '1', ''),
('75835 ', '106460', '0.04', '1', '0', '1', '1', ''),
('75835 ', '106482', '0.04', '1', '0', '1', '1', ''),
('75835 ', '106443', '0.03', '1', '0', '1', '1', ''),
('75835 ', '106447', '0.03', '1', '0', '1', '1', ''),
('75835 ', '116508', '0.03', '1', '0', '1', '1', ''),
('75835 ', '116523', '0.03', '1', '0', '1', '1', ''),
('75835 ', '116516', '0.03', '1', '0', '1', '1', ''),
('75835 ', '116521', '0.03', '1', '0', '1', '1', ''),
('75835 ', '116702', '0.03', '1', '0', '1', '1', ''),
('75835 ', '116703', '0.03', '1', '0', '1', '1', ''),
('75835 ', '106448', '0.03', '1', '0', '1', '1', ''),
('75835 ', '106452', '0.03', '1', '0', '1', '1', ''),
('75835 ', '106515', '0.03', '1', '0', '1', '1', ''),
('75835 ', '106517', '0.03', '1', '0', '1', '1', ''),
('75835 ', '106520', '0.03', '1', '0', '1', '1', ''),
('75835 ', '106475', '0.03', '1', '0', '1', '1', ''),
('75835 ', '106476', '0.03', '1', '0', '1', '1', ''),
('75835 ', '106477', '0.03', '1', '0', '1', '1', ''),
('75835 ', '106478', '0.03', '1', '0', '1', '1', ''),
('75835 ', '106480', '0.03', '1', '0', '1', '1', ''),
('75835 ', '116474', '0.03', '1', '0', '1', '1', ''),
('75835 ', '116475', '0.03', '1', '0', '1', '1', ''),
('75835 ', '116477', '0.03', '1', '0', '1', '1', ''),
('75835 ', '116478', '0.03', '1', '0', '1', '1', ''),
('75835 ', '116484', '0.03', '1', '0', '1', '1', ''),
('75835 ', '116485', '0.03', '1', '0', '1', '1', ''),
('75835 ', '106508', '0.03', '1', '0', '1', '1', ''),
('75835 ', '106509', '0.03', '1', '0', '1', '1', ''),
('75835 ', '106509', '0.03', '1', '0', '1', '1', ''),
('75835 ', '106511', '0.03', '1', '0', '1', '1', ''),
('75835 ', '116696', '0.03', '1', '0', '1', '1', ''),
('75835 ', '116483', '0.03', '1', '0', '1', '1', ''),
('75835 ', '106426', '0.03', '1', '0', '1', '1', ''),
('75835 ', '106430', '0.03', '1', '0', '1', '1', ''),
('75835 ', '106461', '0.03', '1', '0', '1', '1', ''),
('75835 ', '106462', '0.03', '1', '0', '1', '1', ''),
('75835 ', '106463', '0.03', '1', '0', '1', '1', ''),
('75835 ', '106464', '0.03', '1', '0', '1', '1', ''),
('75835 ', '106489', '0.03', '1', '0', '1', '1', ''),
('75835 ', '106490', '0.03', '1', '0', '1', '1', ''),
('75835 ', '106491', '0.03', '1', '0', '1', '1', '');

 

[Tavari]

-- coldsnout-boar (http://www.wowhead.com/npc=75416/coldsnout-boar)
-- Object ID #75416
DELETE FROM `gameobject_loot_template` WHERE `entry`='75416';
INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`, `itembonuses`) VALUES
('75416', '111557', '49', '1', '0', '1', '3', ''),
('75416', '109136', '35', '1', '0', '1', '1', '');

 

[Mikrole]

6 hours ago, Rymnor said:

-- coldsnout-boar (http://www.wowhead.com/npc=75416/coldsnout-boar)
-- Object ID #75416
DELETE FROM `gameobject_loot_template` WHERE `entry`='75416';
INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`, `itembonuses`) VALUES
('75416', '111557', '49', '1', '0', '1', '3', ''),
('75416', '109136', '35', '1', '0', '1', '1', '');

 

Hello Rymnor. You're using the wrong table for a NPC, for NPCs its creature_loot_template. More Infos can be found here: https://trinitycore.atlassian.net/wiki/display/tc/World

[Hypnos]

Ok, you correct the patch and i will accept it please.