Can you get db for every single items exist in WoW (in-game)?

[Layback_]

Hi all,

Just being curious with this, but could also be stupid question to ask.

As long as I know, :GetItemInfo() method will return an item info of passed item ID, item name or item link.

If that particular item exists in Cache/your WoW locale/Item-sparse.dba, it will get an info from there, otherwise will request a server to pass one (and save it into Item-sparse.dba).

My question is would there be any possible solution to get item info of all items exist in WoW, so that you can keep a db within a game?

+ Would Wowhead allow you to export items db into JSON format?

Thank you!

[Lombra]

You can simply loop over item IDs from 1 to some plausible number. I have no idea what item IDs exists these days. Maybe 200 000 or something? You probably can't do it all at once, though, or you might get disconnected. I don't know what the throttling rate is.

[Layback_]

Originally Posted by Lombra You can simply loop over item IDs from 1 to some plausible number. I have no idea what item IDs exists these days. Maybe 200 000 or something? You probably can't do it all at once, though, or you might get disconnected. I don't know what the throttling rate is.

Hi Lombra,

So, there is no solid answer for this but going through the for loop over 200,000 times?

That's bit sad

What about using a data that is obtained from other database in JSON format?
EDIT: Nevermind... I am actually being contradictory to myself... haha

[Ketho]

Originally Posted by Layback_ My question is would there be any possible solution to get item info of all items exist in WoW

There are tools like CascView, CASCExplorer and DBCViewer to extract/open the DB2 files. I personally use LuaCASC

For example the first 2 fields of ItemSearchName.db2 (the item ID goes up to around 144,438 for the current build)
https://gist.githubusercontent.com/a...SearchName.db2

• https://wowdev.wiki/DB/Item
• https://wowdev.wiki/DB/ItemSearchName

[Layback_]

Originally Posted by Ketho There are tools like CascView, CASCExplorer and DBCViewer to extract/open the DB2 files. I personally use LuaCASC For example the first 2 fields of ItemSearchName.db2 (the item ID goes up to around 144,438 for the current build) https://gist.githubusercontent.com/a...SearchName.db2 https://wowdev.wiki/DB/Item https://wowdev.wiki/DB/ItemSearchName

Hi Ketho,

mmmmmmmmmmmmm....

Seems it's getting complex than I thought

I can't seem to find DB2 or CASC files within WoW folder.

The only file formats that I see in Cache folder are ADB and WDB.

[Kanegasi]

Originally Posted by Layback_ Hi Ketho, mmmmmmmmmmmmm.... Seems it's getting complex than I thought I can't seem to find DB2 or CASC files within WoW folder. The only file formats that I see in Cache folder are ADB and WDB.

The Cache folder only holds what you have loaded in the game, not everything. When using a CASC program, you need to load the files found in the Data folder. There's also another Cache folder in the Data folder, ignore that one as well.

[Layback_]

Originally Posted by Kanegasi The Cache folder only holds what you have loaded in the game, not everything. When using a CASC program, you need to load the files found in the Data folder. There's also another Cache folder in the Data folder, ignore that one as well.

Hi Kanegasi,

You mean those folders with 2 digits or letters within Data folder, right?

I'll have a go when I get back home and let you know!

Thank you!

EDIT: Okay, just had a look at data folder, but unfortunately I failed to find items db within it.

Using a listfile I could've seen a bunch of folders with proper names, but most of them were textures (.BLP) and I could've not found dbs from them

Maybe I should just stop my research here

[jonvuo]

Is there a updated list to https://gist.githubusercontent.com/a...SearchName.db2