Awesome db, dude!

There are some problems with recipes, though. For example, quebrith (http://www.chalonverse.com/tw2db/item.php?id=4953) is listed as a component for amethyst dust and oil, which is incorrect.

Good catch! So it turns out there's actually two schematics for both Amethyst Dust and Oil in the game data. One uses alchemy, and one doesn't. I just checked in game and verified that. So it SHOULD show up on those lists.

Anyway, I changed it so the Item page can take into account multiple schematics, so it shows both now.

Wow. Great job, chalonverse.

Lots of work went into this. +1

Thanks

By popular demand, I've added schematics browsing. Search queries will also now pick up the schematics, and the tooltips work correctly, as well.

I think the next update I'll focus on is adding the vendor information.

Just an update. I added shop information, so each item page shows which vendors sell a particular item. I also ended up adding the common/magical/rare/epic tags after all, since it was easy and I figured I might as well.

I updated the OP with info on the upcoming features.

Great project, thank you for your dedication!

Excellent database, however I'd VERY much like to see some info about where you can find the items (chapter, vendor/drop/fixed spawn, path (some items aren't available unless you take a certain path)).

If you could implement that, it'd be fantastic! I know it's a lot of work, so if you need some help, I'd be glad to do it.

Yeah, that's a feature I'm slowly adding support for. The first step was adding the shops information I did, the next one would be loot tables.

I'm waiting a bit on adding any quest information, because I want to see first if that information can be extracted from the script files if/when they're reversed engineered (or CDPR releases the development tools).

Otherwise, the information may have to manually be added which like you said, would be really time consuming.

I added some tabs to the item page, so it's easier to navigate through the various lists.

Also, there was an issue where Firefox would sort of jitter whenever you moused over a tooltip, and that was due to the font being reloaded. That's been fixed as well.

Thanks again for this. It's an absolutely fantastic resource. I have used it many times already. The new functionality just makes it that much better. YOU ROCK!

I'm glad you like it.

As another update, I've added in the loot tables that were in the CSV files. It seems very incomplete though. Several of the CSV files refer to items that clearly don't exist, and then other items seem to be missing completely.

I wonder if the CSV files are left over from an earlier implementation of the engine, and the current game uses something else in the w2scripts files to determine drops.

Maybe non-item categories, like shops and npcs, should be in a separate drop-down list or menu?

I could put them in a different drop down, but I don't know if that necessarily makes it easier or harder to use.

Also, good news! The w2strings format has been figured out, so I was able to get all the correct English item names updated, as well as all the item flavor texts.

That's great! Can you add book texts then?

That's a good idea. It should be easy enough to do, I'll look at it tomorrow.