Tavarok

[Quinzy]

When you mine Tavarok you only get a Crystalline Fragments, while you should be getting adamantite ore and lesser planer essence and possible chance for uncommen and rare gems.

http://www.wowhead.com/npc=18343/tavarok#mining

See comments for the essence

[AnonXS]

http://wowwiki.wikia.com/wiki/Tavarok?oldid=1569814

When Tavarok is killed, it can be mined. It can yield 4-8 [Adamantite Ore] and various uncommon gems, as well as [Lesser Planar Essence].

His corpse can be mined:

4-8 [Adamantite Ore]
1-2 [Eternium Ore]
3-6 [Lesser Planar Essence] 

[AnonXS]

positive interpretation:

UPDATE `creature_template` SET `skinloot` = 80010 WHERE `entry` = 18343; -- 80004
UPDATE `creature_template` SET `skinloot` = 80011 WHERE `entry` = 20268; -- 80004

DELETE FROM `skinning_loot_template` WHERE `entry` = 80010;
INSERT INTO `skinning_loot_template` VALUES (80010, 23425, 100, 0, 4, 8, 0, 0, 0);
INSERT INTO `skinning_loot_template` VALUES (80010, 23427, 75, 0, 1, 2, 0, 0, 0);
INSERT INTO `skinning_loot_template` VALUES (80010, 22447, 50, 0, 3, 6, 0, 0, 0);
INSERT INTO `skinning_loot_template` VALUES (80010, 21929, 0, 1, 1, 2, 0, 0, 0);
INSERT INTO `skinning_loot_template` VALUES (80010, 23077, 0, 2, 1, 2, 0, 0, 0);
INSERT INTO `skinning_loot_template` VALUES (80010, 23079, 0, 1, 1, 2, 0, 0, 0);
INSERT INTO `skinning_loot_template` VALUES (80010, 23107, 0, 1, 1, 2, 0, 0, 0);
INSERT INTO `skinning_loot_template` VALUES (80010, 23112, 0, 2, 1, 2, 0, 0, 0);
INSERT INTO `skinning_loot_template` VALUES (80010, 23117, 0, 2, 1, 2, 0, 0, 0);

DELETE FROM `skinning_loot_template` WHERE `entry` = 80011;
INSERT INTO `skinning_loot_template` VALUES (80011, 23425, 100, 0, 4, 8, 0, 0, 0);
INSERT INTO `skinning_loot_template` VALUES (80011, 23427, 75, 0, 1, 2, 0, 0, 0);
INSERT INTO `skinning_loot_template` VALUES (80011, 22447, 50, 0, 3, 6, 0, 0, 0);
INSERT INTO `skinning_loot_template` VALUES (80011, 21929, 0, 1, 1, 2, 0, 0, 0);
INSERT INTO `skinning_loot_template` VALUES (80011, 23077, 0, 2, 1, 2, 0, 0, 0);
INSERT INTO `skinning_loot_template` VALUES (80011, 23079, 0, 1, 1, 2, 0, 0, 0);
INSERT INTO `skinning_loot_template` VALUES (80011, 23107, 0, 1, 1, 2, 0, 0, 0);
INSERT INTO `skinning_loot_template` VALUES (80011, 23112, 0, 2, 1, 2, 0, 0, 0);
INSERT INTO `skinning_loot_template` VALUES (80011, 23117, 0, 2, 1, 2, 0, 0, 0);
INSERT INTO `skinning_loot_template` VALUES (80011, 23439, 0, 3, 1, 1, 0, 0, 0);
INSERT INTO `skinning_loot_template` VALUES (80011, 23436, 0, 3, 1, 1, 0, 0, 0);
INSERT INTO `skinning_loot_template` VALUES (80011, 23437, 0, 3, 1, 1, 0, 0, 0);
INSERT INTO `skinning_loot_template` VALUES (80011, 23441, 0, 3, 1, 1, 0, 0, 0);
INSERT INTO `skinning_loot_template` VALUES (80011, 23440, 0, 3, 1, 1, 0, 0, 0);
INSERT INTO `skinning_loot_template` VALUES (80011, 23438, 0, 3, 1, 1, 0, 0, 0);

[AnonXS]

https://github.com/Looking4Group/L4G_Core/pull/3755/commits/a0fa5c8775195b7bbb960044fb904fc7c6848001