[Mangos Zero] Database: Rare Loot

[syncrosised]

I run Develop 21, with the latest release of the database. all updates applied.

There is a high droprate for rare (blue) items.

If you start killing lvl20+ mobs there is like 30% chance to get a rare drop.

Is this database related? or does the core recalculate the droprate?

In the .conf file the droprate is set to 1.

Example.

The item Skycaller - Item - World of Warcraft drops.

And i cant even find it in the loot table.

[magic]

Hey there,

We fixed this at MW around a week ago, I will post the code here also. It wasn't as easy as imagined, took us some time to figure out just how to do it:

-- Grey fix

-- Normal mob grey % drop

update creature_loot_template set chanceorquestchance=2.5 where item in (select entry from reference_loot_template

where item in ( select entry from item_template where quality=0)) and chanceorquestchance=5 and entry in ( select lootid from creature_template where rank=0) and mincountOrRef<0;

-- Rare fix

-- Normal mob rare % drop

update creature_loot_template set chanceorquestchance=0.01 where item in (select entry from reference_loot_template

where item in ( select entry from item_template where quality=3)) and chanceorquestchance<0.5 and entry in ( select lootid from creature_template where rank=0) and mincountOrRef<0;

-- Elite mob rare % drop

update creature_loot_template set chanceorquestchance=0.025 where item in (select entry from reference_loot_template

where item in ( select entry from item_template where quality=3)) and chanceorquestchance<0.5 and entry in ( select lootid from creature_template where rank=1) and mincountOrRef<0;

-- Epic fix

-- Normal mob epic % drop

update creature_loot_template set chanceorquestchance=0.0025 where item in (select entry from reference_loot_template

where item in ( select entry from item_template where quality=4)) and chanceorquestchance<0.5 and entry in ( select lootid from creature_template where rank=0) and mincountOrRef<0;

-- Elite mob epic % drop

update creature_loot_template set chanceorquestchance=0.005 where item in (select entry from reference_loot_template

where item in ( select entry from item_template where quality=4)) and chanceorquestchance<0.5 and entry in ( select lootid from creature_template where rank=1) and mincountOrRef<0;