Gorilla Fangs


-- enraged silverback gorilla

DELETE FROM `creature_loot_template` WHERE `entry`=1551 AND `item`=2799;

INSERT INTO `creature_loot_template`(`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES ('1551', '2799', '67', '1', '0', '1', '1');

-- mistvale gorilla

DELETE FROM `creature_loot_template` WHERE `entry`=1108 AND `item`=2799;

INSERT INTO `creature_loot_template`(`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES ('1108', '2799', '56', '1', '0', '1', '1');

-- jungle thunderer

DELETE FROM `creature_loot_template` WHERE `entry`=1114 AND `item`=2799;

INSERT INTO `creature_loot_template`(`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES ('1114', '2799', '52', '1', '0', '1', '1');

-- elder mistvale gorilla

DELETE FROM `creature_loot_template` WHERE `entry`=1557 AND `item`=2799;

INSERT INTO `creature_loot_template`(`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES ('1557', '2799', '44', '1', '0', '1', '1');

-- groddoc thunderer

DELETE FROM `creature_loot_template` WHERE `entry`=5262 AND `item`=2799;

INSERT INTO `creature_loot_template`(`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES ('5262', '2799', '36', '1', '0', '1', '1');

-- ungoro gorilla

DELETE FROM `creature_loot_template` WHERE `entry`=6514 AND `item`=2799;

INSERT INTO `creature_loot_template`(`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES ('6514', '2799', '34', '1', '0', '1', '1');

-- ungoro stomper

DELETE FROM `creature_loot_template` WHERE `entry`=6513 AND `item`=2799;

INSERT INTO `creature_loot_template`(`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES ('6513', '2799', '34', '1', '0', '1', '1');

-- ungoro thunderer

DELETE FROM `creature_loot_template` WHERE `entry`=6516 AND `item`=2799;

INSERT INTO `creature_loot_template`(`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES ('6516', '2799', '34', '1', '0', '1', '1');

-- silverback patriarch

DELETE FROM `creature_loot_template` WHERE `entry`=1558 AND `item`=2799;

INSERT INTO `creature_loot_template`(`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES ('1558', '2799', '34', '1', '0', '1', '1');

-- Ucha

DELETE FROM `creature_loot_template` WHERE `entry`=9622 AND `item`=2799;

INSERT INTO `creature_loot_template`(`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES ('9622', '2799', '34', '1', '0', '1', '1');

-- Uhkloc

DELETE FROM `creature_loot_template` WHERE `entry`=6585 AND `item`=2799;

INSERT INTO `creature_loot_template`(`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES ('6585', '2799', '34', '1', '0', '1', '1');

-- kurmokk

DELETE FROM `creature_loot_template` WHERE `entry`=14491 AND `item`=2799;

INSERT INTO `creature_loot_template`(`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES ('14491', '2799', '30', '1', '0', '1', '1');

-- groddoc Ape

DELETE FROM `creature_loot_template` WHERE `entry`=5260 AND `item`=2799;

INSERT INTO `creature_loot_template`(`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES ('5260', '2799', '5', '1', '0', '1', '1');

-- King Mukla

DELETE FROM `creature_loot_template` WHERE `entry`=1559 AND `item`=2799;

INSERT INTO `creature_loot_template`(`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES ('1559', '2799', '0.3', '1', '0', '1', '1');

-- skymane gorilla

DELETE FROM `creature_loot_template` WHERE `entry`=2521 AND `item`=2799;

INSERT INTO `creature_loot_template`(`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES ('2521', '2799', '0.11', '1', '0', '1', '1');

Problem:

  • Some gorillas weren’t dropping the item Gorilla Fang and this SQL query makes all the creatures that should drop the item function properly in regards to their gorilla fang loot template.

-wrong section, sorry, please move this thread-

Thanks for contributing but try to follow our SQL standards.

SET @Fang = 2799;
DELETE FROM `creature_loot_template` WHERE `entry` IN (1551,1108,1114,1557,5262,6514,6513,6516,1558,9622,6585,5260,1559,2521) AND `item`=@Fang;
INSERT INTO `creature_loot_template`(`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(1551,@Fang,67,1,0,1,1), -- enraged silverback gorilla
(1108,@Fang,56,1,0,1,1),  -- mistvale gorilla
(1114,@Fang,52,1,0,1,1), -- jungle thunderer
(1557,@Fang,44,1,0,1,1), -- elder mistvale gorilla
(5262,@Fang,36,1,0,1,1), -- groddoc thunderer
(6514,@Fang,34,1,0,1,1), -- ungoro gorilla
(6513,@Fang,34,1,0,1,1), -- ungoro stomper
(6516,@Fang,34,1,0,1,1), -- ungoro thunderer
(1558,@Fang,34,1,0,1,1), -- silverback patriarch
(9622,@Fang,34,1,0,1,1), -- Ucha
(6585,@Fang,34,1,0,1,1), -- Uhkloc
(5260, @Fang, 5, 1, 0, 1, 1), -- groddoc Ape
(1559, @Fang, 0.3, 1, 0, 1, 1), -- King Mukla
(2521, @Fang, 0.11, 1, 0, 1, 1), -- skymane gorilla
(14491, @Fang, 30, 1, 0, 1, 1); -- kurmokk

What DB are you running? SELECT * FROM `creature_loot_template` WHERE `item` = 2799;
returns 15 entries in TDB 41.

Do not post in any Completed section even if your query is completed. Devs & mods should move the topics to those sections if needed.

I apologize for not following nor reading the SQL guidelines before contributing to the official TC forums /emoticons/default_smile.png

I’m also using TDB 41, but the Fangs did not drop from what I recall. Nor did they drop on a server I’m moderating on, which also uses TDB.

Noted. Thanks /emoticons/default_smile.png

Confirmed that the drop rate is extremely low or not dropping at all. I’m using TDB 41

I don’t have any problems with gorilla fangs. The ape’s that are in STV had a low drop rate at first but the second time I went through the area almost all of them dropped. I have a lvl 58 rogue I’ve been leveling that has at least two stacks (and at least three stacks vendored) in the bank from random leveling drops

I wrote it off to a “loot-table not getting updated until the second spawn” type of deal as I’ve had it happen with other mobs and drops.

entry item ChanceOrQuestChance lootmode groupid mincountOrRef maxcount

1511 2799 100 1 0 1 1

2521 2799 50 1 0 1 1

5260 2799 50 1 0 1 1

5262 2799 50 1 0 1 1

6513 2799 50 1 0 1 1

6514 2799 50 1 0 1 1

6516 2799 50 1 0 1 1

6585 2799 50 1 0 1 1

1108 2799 -50 1 0 1 1

9622 2799 50 1 0 1 1

1114 2799 55 1 2 1 1

1558 2799 -50 1 0 1 1

1557 2799 -50 1 0 1 1

14491 2799 50 1 0 1 1

1559 2799 -50 1 0 1 1

(It seems that I can’t post tables in a proper format)

Drop chance doesn’t seem that low. Where’s the problem?

Some of those are quest only drops, they should be an all the time drop.

The SQL query that I posted had correct droprates directly imported from wowhead.com

Some people might have problems with this, some not. This will at least fix it for those who has the problem.

Wowhead drop rates are based on statistics and in most cases with a low “data set”. We prefer to use other sources.

Wowhead %chances on questitems are usually too low, because some players either dont record all loot, or because a certain questitem doesnt always drop if your not on the quest

this as well

yes but the fix for that is not what is posted

I’ve made the drop entries > 0 which means they’re not related to any quests and are all time drops.

im not saying they shouldnt be positive, im just saying that modifying the percentages isnt needed imo