Hi guys i see this problem more than 2 years ago at rev 600+. And i see it now.. at rev 2334...... At sunwell plateau all mobs have incorrect loot! From mobs don't drop ring.... recipes... and other items... link at wowhead from thiis mob drops 200+ items http://eu.wowhead.com/npc=25507   at our db from it mob drop 13 items.... Maybe who do normal drop? please share....

Taking loot from wowhead can be inconsistent with the relevant data that was available when 2.4.3 was up. Of course there are many other resources to use that would help us identify what is supposed to drop what.

Our wiki is a good place to start, from there you can see how to write the code to add drops for these npcs.

LordUsagi wrote:

Taking loot from wowhead can be inconsistent with the relevant data that was available when 2.4.3 was up. Of course there are many other resources to use that would help us identify what is supposed to drop what.

Our wiki is a good place to start, from there you can see how to write the code to add drops for these npcs.

yes i know... but from this mobs always drops cool rings for healer.... polearm... off hand first weapon... and many recipes.... Ok i try to add this loot by myself!!! And if i do it... I post it!! ;-)

Sounds good! I'd be happy to assist.

Sorry I keep missing you in IRC btw! You're usually on when I'm in bed smile

Yes i do it))) One-two minutes and complete))). Use this loot id(25593) for creatures like Sunblade Protector and others.
code for loot_template

DELETE FROM `creature_loot_template` WHERE (`entry`=25593);
INSERT INTO `creature_loot_template` VALUES
(25593, 21877, 28, 0, 2, 3, 0, 0, 0),
(25593, 22540, 0.01, 0, 1, 1, 0, 0, 0),
(25593, 24001, 5, 1, -24001, 1, 0, 0, 0),
(25593, 24002, 5, 1, -24002, 1, 0, 0, 0),
(25593, 24011, 1, 1, -24011, 1, 0, 0, 0),
(25593, 24012, 0.5, 1, -24012, 1, 0, 0, 0),
(25593, 24013, 1, 1, -24013, 1, 0, 0, 0),
(25593, 24014, 0.5, 1, -24014, 1, 0, 0, 0),
(25593, 24015, 0.1, 1, -24015, 1, 0, 0, 0),
(25593, 32897, 15, 0, 1, 1, 0, 0, 0),
(25593, 34091, 6, 1, -34091, 1, 0, 0, 0),
(25593, 34092, 2, 1, -34092, 1, 0, 0, 0),
(25593, 34093, 5, 1, -34093, 1, 0, 0, 0),
(25593, 34094, 1, 1, -34094, 1, 0, 0, 0),
(25593, 34183, 0.3, 0, 1, 1, 0, 0, 0),
(25593, 34346, 0.3, 0, 1, 1, 0, 0, 0),
(25593, 34350, 0.3, 0, 1, 1, 0, 0, 0),
(25593, 34351, 0.3, 0, 1, 1, 0, 0, 0),
(25593, 34664, 5, 0, 1, 1, 0, 0, 0),
(25593, 35186, 0.03, 0, 1, 1, 0, 0, 0),
(25593, 35187, 0.03, 0, 1, 1, 0, 0, 0),
(25593, 35189, 0.03, 0, 1, 1, 0, 0, 0),
(25593, 35190, 0.03, 0, 1, 1, 0, 0, 0),
(25593, 35191, 0.03, 0, 1, 1, 0, 0, 0),
(25593, 35192, 0.03, 0, 1, 1, 0, 0, 0),
(25593, 35193, 0.03, 0, 1, 1, 0, 0, 0),
(25593, 35194, 0.03, 0, 1, 1, 0, 0, 0),
(25593, 35195, 0.03, 0, 1, 1, 0, 0, 0),
(25593, 35196, 0.03, 0, 1, 1, 0, 0, 0),
(25593, 35197, 0.03, 0, 1, 1, 0, 0, 0),
(25593, 35198, 0.04, 0, 1, 1, 0, 0, 0),
(25593, 35199, 0.04, 0, 1, 1, 0, 0, 0),
(25593, 35200, 0.04, 0, 1, 1, 0, 0, 0),
(25593, 35201, 0.04, 0, 1, 1, 0, 0, 0),
(25593, 35202, 0.04, 0, 1, 1, 0, 0, 0),
(25593, 35203, 0.04, 0, 1, 1, 0, 0, 0),
(25593, 35204, 0.04, 0, 1, 1, 0, 0, 0),
(25593, 35205, 0.04, 0, 1, 1, 0, 0, 0),
(25593, 35206, 0.04, 0, 1, 1, 0, 0, 0),
(25593, 35207, 0.04, 0, 1, 1, 0, 0, 0),
(25593, 35208, 0.04, 0, 1, 1, 0, 0, 0),
(25593, 35209, 0.04, 0, 1, 1, 0, 0, 0),
(25593, 35210, 0.04, 0, 1, 1, 0, 0, 0),
(25593, 35211, 0.04, 0, 1, 1, 0, 0, 0),
(25593, 35212, 0.04, 0, 1, 1, 0, 0, 0),
(25593, 35214, 0.04, 0, 1, 1, 0, 0, 0),
(25593, 35215, 0.04, 0, 1, 1, 0, 0, 0),
(25593, 35216, 0.04, 0, 1, 1, 0, 0, 0),
(25593, 35217, 0.04, 0, 1, 1, 0, 0, 0),
(25593, 35218, 0.04, 0, 1, 1, 0, 0, 0),
(25593, 35219, 0.04, 0, 1, 1, 0, 0, 0),
(25593, 35733, 0.3, 0, 1, 1, 0, 0, 0);



And for item_template because in our DB missed two RECIPES!!! ID 35205 and 35214(if im not mistake)



REPLACE INTO `item_template` (`entry`, `class`, `subclass`, `name`, `displayid`, `Quality`, `Flags`, `BuyCount`, `BuyPrice`, `SellPrice`, `InventoryType`, `AllowableClass`, `AllowableRace`, `ItemLevel`, `RequiredLevel`, `RequiredSkill`, `RequiredSkillRank`, `requiredspell`, `requiredhonorrank`, `RequiredCityRank`, `RequiredReputationFaction`, `RequiredReputationRank`, `maxcount`, `stackable`, `ContainerSlots`, `stat_type1`, `stat_value1`, `stat_type2`, `stat_value2`, `stat_type3`, `stat_value3`, `stat_type4`, `stat_value4`, `stat_type5`, `stat_value5`, `stat_type6`, `stat_value6`, `stat_type7`, `stat_value7`, `stat_type8`, `stat_value8`, `stat_type9`, `stat_value9`, `stat_type10`, `stat_value10`, `dmg_min1`, `dmg_max1`, `dmg_type1`, `dmg_min2`, `dmg_max2`, `dmg_type2`, `armor`, `holy_res`, `fire_res`, `nature_res`, `frost_res`, `shadow_res`, `arcane_res`, `delay`, `ammo_type`, `RangedModRange`, `spellid_1`, `spelltrigger_1`, `spellcharges_1`, `spellppmRate_1`, `spellcooldown_1`, `spellcategory_1`, `spellcategorycooldown_1`, `spellid_2`, `spelltrigger_2`, `spellcharges_2`, `spellppmRate_2`, `spellcooldown_2`, `spellcategory_2`, `spellcategorycooldown_2`, `spellid_3`, `spelltrigger_3`, `spellcharges_3`, `spellppmRate_3`, `spellcooldown_3`, `spellcategory_3`, `spellcategorycooldown_3`, `spellid_4`, `spelltrigger_4`, `spellcharges_4`, `spellppmRate_4`, `spellcooldown_4`, `spellcategory_4`, `spellcategorycooldown_4`, `spellid_5`, `spelltrigger_5`, `spellcharges_5`, `spellppmRate_5`, `spellcooldown_5`, `spellcategory_5`, `spellcategorycooldown_5`, `bonding`, `description`, `PageText`, `LanguageID`, `PageMaterial`, `startquest`, `lockid`, `Material`, `sheath`, `RandomProperty`, `RandomSuffix`, `block`, `itemset`, `MaxDurability`, `area`, `Map`, `BagFamily`, `TotemCategory`, `socketColor_1`, `socketContent_1`, `socketColor_2`, `socketContent_2`, `socketColor_3`, `socketContent_3`, `socketBonus`, `GemProperties`, `RequiredDisenchantSkill`, `ArmorDamageModifier`, `ScriptName`, `DisenchantID`, `FoodType`, `minMoneyLoot`, `maxMoneyLoot`, `Duration`) VALUES (35205, 9, 10, 'Pattern: Hands of Eternal Light', 7085, 4, 64, 1, 140000, 35000, 0, -1, -1, 70, 0, 197, 365, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 483, 0, -1, 0, -1, 0, -1, 46129, 6, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 1, 'Teaches you how to sew Hands of Eternal Light.', 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, '', 0, 0, 0, 0, 0);



REPLACE INTO `item_template` (`entry`, `class`, `subclass`, `name`, `displayid`, `Quality`, `Flags`, `BuyCount`, `BuyPrice`, `SellPrice`, `InventoryType`, `AllowableClass`, `AllowableRace`, `ItemLevel`, `RequiredLevel`, `RequiredSkill`, `RequiredSkillRank`, `requiredspell`, `requiredhonorrank`, `RequiredCityRank`, `RequiredReputationFaction`, `RequiredReputationRank`, `maxcount`, `stackable`, `ContainerSlots`, `stat_type1`, `stat_value1`, `stat_type2`, `stat_value2`, `stat_type3`, `stat_value3`, `stat_type4`, `stat_value4`, `stat_type5`, `stat_value5`, `stat_type6`, `stat_value6`, `stat_type7`, `stat_value7`, `stat_type8`, `stat_value8`, `stat_type9`, `stat_value9`, `stat_type10`, `stat_value10`, `dmg_min1`, `dmg_max1`, `dmg_type1`, `dmg_min2`, `dmg_max2`, `dmg_type2`, `armor`, `holy_res`, `fire_res`, `nature_res`, `frost_res`, `shadow_res`, `arcane_res`, `delay`, `ammo_type`, `RangedModRange`, `spellid_1`, `spelltrigger_1`, `spellcharges_1`, `spellppmRate_1`, `spellcooldown_1`, `spellcategory_1`, `spellcategorycooldown_1`, `spellid_2`, `spelltrigger_2`, `spellcharges_2`, `spellppmRate_2`, `spellcooldown_2`, `spellcategory_2`, `spellcategorycooldown_2`, `spellid_3`, `spelltrigger_3`, `spellcharges_3`, `spellppmRate_3`, `spellcooldown_3`, `spellcategory_3`, `spellcategorycooldown_3`, `spellid_4`, `spelltrigger_4`, `spellcharges_4`, `spellppmRate_4`, `spellcooldown_4`, `spellcategory_4`, `spellcategorycooldown_4`, `spellid_5`, `spelltrigger_5`, `spellcharges_5`, `spellppmRate_5`, `spellcooldown_5`, `spellcategory_5`, `spellcategorycooldown_5`, `bonding`, `description`, `PageText`, `LanguageID`, `PageMaterial`, `startquest`, `lockid`, `Material`, `sheath`, `RandomProperty`, `RandomSuffix`, `block`, `itemset`, `MaxDurability`, `area`, `Map`, `BagFamily`, `TotemCategory`, `socketColor_1`, `socketContent_1`, `socketColor_2`, `socketContent_2`, `socketColor_3`, `socketContent_3`, `socketBonus`, `GemProperties`, `RequiredDisenchantSkill`, `ArmorDamageModifier`, `ScriptName`, `DisenchantID`, `FoodType`, `minMoneyLoot`, `maxMoneyLoot`, `Duration`) VALUES (35214, 9, 1, 'Pattern: Gloves of Immortal Dusk', 7085, 4, 64, 1, 80000, 20000, 0, -1, -1, 75, 0, 165, 365, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 483, 0, -1, 0, -1, 0, -1, 46134, 6, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 1, 'Teaches you how to craft Gloves of Immortal Dusk.', 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, '', 0, 0, 0, 0, 0);

It could be possible to use reference loot so all trash shares the same loot table. Other then that, awesome work.

You could use WoWHead Clones from good maintained p server projects to get the most correct generic data around in this days (maybe not 100% accurate but better then everything else)

here example link of a good db: http://db.hellground.net/