TQDB: Titan Quest Database - All equipment and sets

[Fonzy]

Hi everybody,

Like most of you I used the several Titan Quest resources that were available to us over the years, from the offline CFM pages to gamebanshee's website, to the excel sheets with all the bosses and drop chances.

With the beta and the incredibly welcome changes to both gameplay and equipment, I wanted to setup an up-to-date database for all the equipment and set items, and eventually re-create the awesome titancalc.com system.

A long story short: http://www.tq-db.net

I just parsed the latest database (TQ Anniversary edition, Ragnarok DLC) and pushed that so everything should be as it is currently in-game.

A few notes on usage
The website has 4 main resources that contain all the info: 3 JSON files and 1 large spritesheet. Together these make up about 8MB of data (little bit less due to compression). These will only need to be loaded once (until you clear all your internet files). So your first load you'll probably notice not all the images show up until about 5-10 seconds later, but every time you visit the page after that it should be instantaneous.

I built the website so that you should have a VERY smooth user experience when you're switching between categories or searching for items, there are no page reloads at ALL.

Things missing/bugs/etc
In order to make it a bit easier for me to track bugs & feature requests, please use https://github.com/fonsleenaars/tqdb/issues.

Wrap up
Hope the database ends up being useful for some of you, I've enjoyed having it open on my other monitor or laptop/tablet as I play and think about what kind of gear I want :p

See you on the battlefield. Happy TQ-ing!

Updated as of December 25th, 2017

--

Note for moderators: cross/copy posting this from my thread on the TQ:IT community, hope that's ok.

[Innoruuk]

update? any release?

[Fonzy]

Started the initial parse of ragnarok, got about 80% of the way through before the parser broke (see github). Working on fixing that, ETA still next 2 weeks (trying my best for Xmas)

[hal9000]

Αναρτήθηκε αρχικά από Fonzy:

Started the initial parse of ragnarok, got about 80% of the way through before the parser broke (see github). Working on fixing that, ETA still next 2 weeks (trying my best for Xmas)

Thanks for all the effort Fonz. Looking forward to this.

[Jyu Viole Grace]

If you need any help, I have ms sql and code in coldfusion. Based in the UK.

[flamish]

you need to put where i can find them o where they drop and also i cant find trowing weapons like hoi polloi in there

[EPinter]

Αναρτήθηκε αρχικά από flamishboy:

you need to put where i can find them o where they drop and also i cant find trowing weapons like hoi polloi in there

Hoi Polloi drops on ACT1 Normal, by this mobs:

Awakened Dead ~ Soldier
Maenad ~ Tracker
Exhumed Dead ~ Soldier
Desecrated Dead ~ Soldier

[Fonzy]

Αναρτήθηκε αρχικά από Jyu Viole Grace:

If you need any help, I have ms sql and code in coldfusion. Based in the UK.

Appreciate the offer! After this new version I'll make a list of outstanding issues that people can add onto so that I don't have to manage it myself. That way you can see if there's anything in there you could help out with.

So! I'm almost done, I'll be working on it for the rest of tonight & tomorrow a bit before all the family shows up, but here's a quick peek: http://puu.sh/yN6vW/1d8b1c9495.jpg

Few last things, fixing search with the new structure, getting artifacts & relics displayed properly and then go back and check the data. I already found a few bugs that I have to work out in the parser, but nothing major anymore.

Once that is done I'll write up a quick post detailing how the new loot table works and what the numbers mean, then I'll release it on tq-db.net.

Merry Xmas eve everybody, I'm going to do my best to ship this out as a Christmas present to the community by tomorrow!

[Syn]

That's great news Fonzy, thanks a bunch and Merry Christmas! Affix list not in beta anymore as well? Adding the addon items and all loot tables, that is some impressive work

[Fonzy]

It's live: http://www.tq-db.net/ (hit CTRL+F5 if you don't see it right away).

Merry Xmas everybody! I'll check in tomorrow to see if I missed a lot of things, first I'm going to sleep a while :p

[KZavi]

Excellent job, Fonzy! Thanks for the work, and happy holidays)

One question: would it be possible to sort between the base items and ones from Ragnarok (or even IT, if possible)? It would surely be useful.

As for the issues, the loot drop list for the selected item sometimes extends beyond the item card. but I have yet to notice anything else.

[Syn]

Good job so far! Browsing some stuff for a few minutes I realized a few things: The 3 row list was way better for MI searching purposes. The stat requirements are missing now, removed on purpose? And lastly the MIs are not sorted properly by difficulty level anymore.

[Fonzy]

Αναρτήθηκε αρχικά από KZavi:

One question: would it be possible to sort between the base items and ones from Ragnarok (or even IT, if possible)? It would surely be useful.

As for the issues, the loot drop list for the selected item sometimes extends beyond the item card. but I have yet to notice anything else.

1. Sure, I'll add ragnarok filtering to the issue list.
2. There should be a scrollbar in those cases, is there not for you?

Αναρτήθηκε αρχικά από Syn:

Good job so far! Browsing some stuff for a few minutes I realized a few things: The 3 row list was way better for MI searching purposes. The stat requirements are missing now, removed on purpose? And lastly the MIs are not sorted properly by difficulty level anymore.

1. I'll take a look at it, maybe make it configurable (setting the width of cards to a percentage yourself or something)
2. Stat requirements; derp, I'll re-add them soon, honestly just forgot
3. Yep, I'll re-organize them from normal => epic => legendary, good one.

[FagnerK]

Fantastic job!
Can you please add stats requirments and search for properties in itens ? I mean, i'm trying to look for new itens with pet bonuses. Is it possible just write "pet" in search bar and it list all itens with pet bonuses in itens properties. Thank You.

[Force]

Awesome! Thanks for updating the database! The loot table data is a really great addition!
One question though: Are throwing weapons going to be added too? I can't seem to find a section for them at the weapons, are you going to add then too? (or are they actually there and am I missing something on the site?)
Again, thank you so much for updating your database!

[Fonzy]

Αναρτήθηκε αρχικά από Force:

One question though: Are throwing weapons going to be added too? I can't seem to find a section for them at the weapons, are you going to add then too? (or are they actually there and am I missing something on the site?)

Oh, I've barely had time to play the expansion so I hadn't even run into them yet. I'll take a look at where they're stored, mind giving me a quick run down of how they work? Are there epics/legendaries/infrequents just like regular weapons?