I'll try to bring back this discussion - with the new patch, upgraded stats now compensate for sockets (which aren't upgraded, obviously), so the formula changes.
Since item data now appears to be stored client-side (Item-sparse.db2), you can get stat allocation and socket multipliers for every item, so the formula is something like this:
Code:
statAfterUpgrade = (statBeforeUpgrade + socketMultiplier * 160) * upgradeFactor - socketMultiplier * 160
I'm getting upgradeFactor from weapon damage data (ItemDamageTwoHand.dbc), and it seems to work fine except for rounding issues (maybe if I find out how to use stat allocation values I'd get it right).
Anyway, the obvious problem is that socketMultiplier is not available in lua code, and there's no general rule to calculate it - e.g. if some items have 1 for primary stat and 0.5 for both secondary stats, some would have 1 for primary, and 0.25/0.75 for secondary (assuming 2 sockets).
By the way, here's the new upgrade id to item level table:
Lua Code:
local upTable = {
[1] = 8, -- 1/1
[373] = 4, -- 1/2
[374] = 8, -- 2/2
[375] = 4, -- 1/3
[376] = 4, -- 2/3
[377] = 4, -- 3/3
[378] = 7, -- 1/1
[379] = 4, -- 1/2
[380] = 4, -- 2/2
[445] = 0, -- 0/2
[446] = 4, -- 1/2
[447] = 8, -- 2/2
[451] = 0, -- 0/1
[452] = 8, -- 1/1
[453] = 0, -- 0/2
[454] = 4, -- 1/2
[455] = 8, -- 2/2
[456] = 0, -- 0/1
[457] = 8, -- 1/1
[458] = 0, -- 0/4
[459] = 4, -- 1/4
[460] = 8, -- 2/4
[461] = 12, -- 3/4
[462] = 16, -- 4/4
[465] = 0, -- 0/2
[466] = 4, -- 1/2
[467] = 8, -- 2/2
[468] = 0, -- 0/4
[469] = 4, -- 1/4
[470] = 8, -- 2/4
[471] = 12, -- 3/4
[472] = 16, -- 4/4
[476] = 0, -- ?
[479] = 0, -- ?
}
Threaded Mode
