Need help: Item stat calculation

Hi all,

I am working on a project and I am a bit stuck when it comes to calculating the weapon attack speed and attribute requirements for certain items.

I will be using the level 50 “The Butcher of Burrwitch” as a reference.

Weapon attack speed

There are two fields with values populated on the item record when I look for attack speed:

image

The tag just references a string, while the base attack speed does not really seem to correlate with anything.

The attack speed in game for this weapon is 1.78 base, so how would one get to that value from the available data in the DB?

Attribute requirements

There are once again two fields that look relevant here, one being the attribute scale percent and the other being the reference to the calculation formulas:

image

Looking at the available formulas, this seems to be the logical one to use:


0.92*(0.31*((itemLevel22)+6.5((damageAvgBase0.8)(1+(damageAvgPierceRatio/100)))-10*(0.05*(itemLevel^1.62)-1))-4)

“itemLevel” and “damageAvgBase” seems quite self explanatory, but what would the value for “damageAvgPierceRatio” be?
I cannot find any reference to that field on the item record, unless I am completely off track here?

Any help here would be much appreciated.