[MaNGOS] loot system

[blukkiee]

I don't really get how the loot template system works on MaNGOS.
When I look up the loot of, for example, Onyxia, I see 9 items and that's not all she drops. Because when I kill her in-game, she drops everything that she can drop. But not all is listed in the creature_loot_template table.

So where does mangos get the data from, when it's not in the DB?
I need the full loot templates of a few mobs for what I want to do.

Thanks in advance.

[Kiev]

Im sure its located in the database somewhere, are you sure your looking fully at Onxiya's loot tables? How are you viewing them?

[blukkiee]

select * from creature_loot_template where entry = 10184

is what I used. Should show all of them, but only shows 9 results with onyxia's entry.

[Kiev]

Hm. That should select them all yes, are there any other tables that could handle creature loot?

[blukkiee]

Not that I know of, no. Have been lurking around the database today but creature_loot_template seems to be the only one.

[Kiev]

Hmmm, in which case are you sure that you dont have two databases that are seperate?

[blukkiee]

Eh? Obviously I use a single World database...

[Kiev]

Was wondering as some people have two or three. In which case this has me stumped. Sorry.

[blukkiee]

I found this: Loot template - UDB
And I found the table reference_loot_table which is a weird table.

This is goddamn complicated, I don't really see why they made it this difficult, ArcEmu/Ascent was alot easier.

[Kiev]

Haha, MaNGOS is for those that like it blizzlike, but they handle everything different, have you managed to find the part yet?