[DB/Loot] Some loot contents imported from UDB

[Helias]

I compared the db of tc with udb and I found these npcs loot bugged so I fixed them.

-- pickpocketing_loot_template
UPDATE creature_template SET pickpocketloot=entry WHERE entry=28200;
DELETE FROM `pickpocketing_loot_template` WHERE entry=28200;
INSERT INTO `pickpocketing_loot_template` (`entry`,`item`,`ChanceorQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`) VALUES
-- Dark Necromance
(28200,37467,100,1,0,1,1),-- A Steamy Romance Novel: Forbidden Love
(28200,43575,100,1,0,1,1),-- Reinforced Junkbox
(28200,35952,30,1,0,1,1),-- Briny Hardcheese
(28200,33447,22,1,0,1,1),-- Runic Healing Potion
(28200,35948,10,1,0,1,1),-- Savory Snowplum
(28200,35950,10,1,0,1,1);-- Sweet Potato Bread

[Aokromes]

Core Houn don't have loot on retail.

[Helias]

Thanks, corrected, sorry but I haven't an account on retail so I rely on wowhead and udb

[Exodius]

Pets/Minions of NPCs should not have loot as well.

[DDuarte]

Also remove

-- Death Knight Understud (16803,22708,-100,1,0,1,1),-- Fate of Ramaladni

-- Amani'shi Lookou (24175,33106,-30,1,0,1,1),-- Forest Troll Tusk

-- Mosswalker Victi (28113,38642,-1,1,0,1,1),-- Golden Engagement Ring

-- Ravaged Cavedweller Wor (30177,42510,-20,1,0,1,1);-- Worg Fur

No idea about Sucubus Minion, I can't find any loot table for her. I guess the only valid loot is pickpocketing_loot_template for Dark Necromancer

But good job anyway and as you see, tdb is "not that bad" compared to other DBs. (Try to do the query in the inverse direction and see how much udb is missing :P)

[Helias]

Corrected the code^^

"(Try to do the query in the inverse direction and see how much udb is missing :P)"

I'll do of course. ;)

[malcrom]

This ready to push?

[DDuarte]

Yes