Kirise
OG
Interested in collaborating on a fun (?) project, to set up an auction house monitor for BoEs with sockets and tertiary stats? I figure the project needs three parts:
1) A host site for the database and other code
2) Information on how to filter for sockets, tertiaries, and ilvl
3) A legible front end, to make reading the results easy
I spent all of last Saturday figuring out most of part 2. If a couple of people want to tackle 1 and 3, we can get this project off the ground and make gearing up a little better for everyone!
---------------------------------
(technical details of part 2 follow)
Holy smokes, were those filters a pain in the ass to figure out. So here's an info dump on how that works.
Blizzard's API updates active auction house data once an hour (at different times of the hour for different realms). When we pull the data, we get a whole mess of info about the items, formatted into different fields. One of those fields is the bonus_list field.
The bonus_list field can contain anywhere from two to five (maybe more?) numbers (older gear often doesn't even have the bonus_list field), and thanks to a winding road that led me to https://www.raidbots.com/static/data/live/bonuses.json, I dug up the numbers we need. Note that some of the numbers in that link are deprecated, thanks to deprecated stats from previous expansions, so I didn't include them below.
41 is leech
42 is speed
523
563
564
565
572
608
715 through 719
721 through 752
1808
3475
3522
4802
6514
6672
6935
...all of these numbers indicate a socket.
It's possible we would only need to use the four digit numbers for filtering gear with a socket (those numbers were the only ones I saw when looking through live auction house data), but I haven't been able to rule out the 3-digit numbers yet.
Most normal BoE gear has two items in the bonus_list. The first item shows the ilvl range, and the second item defines the combination of secondary stats.
For example, I found a 39 wearing an Ashvane Company Cloak of the Harmonious (gear info for individual characters is available within the Blizzard API) at ilvl 48. The bonus_list contained two items: 6654 and 1713. 6654 is the ilvl range, and 1713 is one of the several "of the Harmonious" combinations of mastery and versatility. Somehow the combination of those two numbers, plus something else I haven't figured out yet, yields the actual stats for that cloak.
My 29 has the same named cloak, but with leech and a socket. The bonus_list contains four items: 6654 4802 41 1716. 6654 shows the same ilvl range as the 39's cloak, 4802 is the socket, 41 is leech, and 1716 denotes a slightly different proportion of mastery and versatility than the 39's cloak.
I don't know how the Undermine Journal figures out item level (and it doesn't work for some raid BoE drops), and WoWhead clearly struggles with item level as well (but the URLs they generated helped me figure out what the bonus_list items were doing).
While I don't yet have an ID list of realms for auction houses and connected realms for merged auction houses, I'm willing to grind that info out of the API when someone is ready to pull data.
1) A host site for the database and other code
2) Information on how to filter for sockets, tertiaries, and ilvl
3) A legible front end, to make reading the results easy
I spent all of last Saturday figuring out most of part 2. If a couple of people want to tackle 1 and 3, we can get this project off the ground and make gearing up a little better for everyone!
---------------------------------
(technical details of part 2 follow)
Holy smokes, were those filters a pain in the ass to figure out. So here's an info dump on how that works.
Blizzard's API updates active auction house data once an hour (at different times of the hour for different realms). When we pull the data, we get a whole mess of info about the items, formatted into different fields. One of those fields is the bonus_list field.
The bonus_list field can contain anywhere from two to five (maybe more?) numbers (older gear often doesn't even have the bonus_list field), and thanks to a winding road that led me to https://www.raidbots.com/static/data/live/bonuses.json, I dug up the numbers we need. Note that some of the numbers in that link are deprecated, thanks to deprecated stats from previous expansions, so I didn't include them below.
41 is leech
42 is speed
523
563
564
565
572
608
715 through 719
721 through 752
1808
3475
3522
4802
6514
6672
6935
...all of these numbers indicate a socket.
It's possible we would only need to use the four digit numbers for filtering gear with a socket (those numbers were the only ones I saw when looking through live auction house data), but I haven't been able to rule out the 3-digit numbers yet.
Most normal BoE gear has two items in the bonus_list. The first item shows the ilvl range, and the second item defines the combination of secondary stats.
For example, I found a 39 wearing an Ashvane Company Cloak of the Harmonious (gear info for individual characters is available within the Blizzard API) at ilvl 48. The bonus_list contained two items: 6654 and 1713. 6654 is the ilvl range, and 1713 is one of the several "of the Harmonious" combinations of mastery and versatility. Somehow the combination of those two numbers, plus something else I haven't figured out yet, yields the actual stats for that cloak.
My 29 has the same named cloak, but with leech and a socket. The bonus_list contains four items: 6654 4802 41 1716. 6654 shows the same ilvl range as the 39's cloak, 4802 is the socket, 41 is leech, and 1716 denotes a slightly different proportion of mastery and versatility than the 39's cloak.
I don't know how the Undermine Journal figures out item level (and it doesn't work for some raid BoE drops), and WoWhead clearly struggles with item level as well (but the URLs they generated helped me figure out what the bonus_list items were doing).
While I don't yet have an ID list of realms for auction houses and connected realms for merged auction houses, I'm willing to grind that info out of the API when someone is ready to pull data.
