fonsleenaars / tqdb

Python parser for the Titan Quest Anniversary Edition, Ragnarok, Atlantis, Eternal Ember DLC database.
https://tq-db.net
MIT License
50 stars 15 forks source link

Aionios - no droptable #52

Open MartyAlencar opened 5 years ago

MartyAlencar commented 5 years ago

Hello,

Aionios doesn't have any droptable - is this thing undroppable or wasn't the droptable transferred correctly?

Best regards

fonsleenaars commented 5 years ago

Hm, good question. I'll take a look at the raw files today, but if it has no drop table, it means either:

I will look over the files today and get back to you, thanks for reporting it.

fonsleenaars commented 5 years ago

So it looks like it just doesn't drop anywhere at the moment, I did a file content search of all files in records - which holds all item data, loot drop data, etc, and it's not showing up anywhere.

There's another thing I can check; it's a drop from the original expansion Immortal Throne, and it's a Legendary Shield, so I'll find the drop tables for other shields around the same level and see where those are located. Perhaps I'll find a misspelling/error in those files, which SHOULD refer to this item, but don't.

fonsleenaars commented 5 years ago

Ah, nevermind I found it, my search query accidentally had case sensitivity on 😅 .

Okay, I've found the table that drops it, the next obstacle is matching it to bosses, and then evaluating the equation that determines what level the player needs to be for it to potentially drop. This will take a day or two, I'll get back to you!

MartyAlencar commented 5 years ago

Thank you for the quick feedback! Take your time. 👍

MartyAlencar commented 5 years ago

Do you have an update for me? (:

fonsleenaars commented 5 years ago

Not quite yet, had to pack up last few days and moving today. Should have something either this weekend or early next week!

fonsleenaars commented 5 years ago

So what I believe is happening is that the loot table in which the item is included has a level filter, and the bosses that are assigned that loot table, filter out the item by their level.

I'm going to compare this up against some other results and see if I can make sense of it, I believe the player level also factors into it so I'll update later with some examples of bosses & player levels and the respective chances for this item.

This might mean other items are also affected, so good find!

MartyAlencar commented 5 years ago

Any updates if Aionios is ever available? :) There are indeed some legendaries which can't be found. Another one would be Demonskin Walkers. And probably Aphrodite's Favor as well.

fonsleenaars commented 5 years ago

Not yet, sorry! I'm putting in some more hours these next two weeks so I should have some actual updates for you soon!

fonsleenaars commented 5 years ago

I think when I solve #54 I will solve this one as well, it's starting to look like figuring out the "starting point" for a drop will then lead to all other tables being added correctly.

The tricky part is that some loot tables look at:

and then determine the loot that can even drop. Obviously I can't really add that "interaction" to the database, so I'll have to establish a baseline (1 player, player level = boss level or something). Anyway, if I can figure out #54 I think I'll have a useful update for you too.

giffsapros commented 5 years ago

So, I know what's going on here, since I spent many hours farming for Aionios without any success. The issue is the same balancing change as the one I found and posted about in #36, where Sapros no longer drops from the Hydra as a result of item level rescaling. As part of this same item level rescaling, I found that Aionios' item level had been scaled (up to level 80) such that it no longer drops from any loot tables at all, because its item level is outside of all maxItemLevelEquation values for the loot tables I could find - in particular, it was higher than the max droppable item level for all Act 5 bosses. @MartyAlencar mentioned Demonskin Walkers and Aphrodite's Favor as two other undroppable items - those were items that I believe also have an item level of 80, and similarly cannot be dropped after the Ragnarok rebalancing.

Granted, it's been months since I did that investigation and the game devs might have tweaked this again, but the fact that tq-db shows no drop sources for Aionios is consistent with what I found then.

I thought this was a pretty dumb bug (why make these items droppable pre-Ragnarok but no longer available?), so I ended up modding game files to lower Aionios' level and make it droppable.

I should mention that as part of this modding effort, I did in fact verify that Aionios no longer drops by tweaking Hades' drop table to always drop legendary shields. With this tweak in place, without lowering Aionios' level, I got 0 Aionios in ~20 runs; after lowering its level, I got ~15 Aionios in ~20 runs, which seems like evidence that the reason why Aionios does not drop is due to its item level being too high.

fonsleenaars commented 5 years ago

Awesome investigating work!

It's going to be tricky to see what I can do to list chances based on level, since that would require some sort of interactive data set, but perhaps I can just list some sort of cap when things will no longer be available.

Thanks!

Ailonel commented 5 years ago

Does that mean that my attempts to drop Aionios and Demonskin Walkers were futile?

echonax commented 2 years ago

I guess this is fixed with Eternal Embers: https://www.youtube.com/watch?v=OUEtKdNi2ek&ab_channel=TheLineofEpicHeroes

Update: I can confirm that it dropped for me as well. Same spot: Burial Vaults in the Necropolis Outskirts waypoint area. I also noticed that the sarcophagi in this area tends to drop a lot of unique shields in general.