Quantcast Can you get db for every single items exist in WoW (in-game)? - WoWInterface
Thread Tools Display Modes
03-07-17, 04:33 PM   #1
Layback_
An Onyxian Warder
Join Date: Feb 2016
Posts: 356
Can you get db for every single items exist in WoW (in-game)?

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!
  Reply With Quote
03-07-17, 06:30 PM   #2
Lombra
A Molten Giant
 
Lombra's Avatar
AddOn Author - Click to view addons
Join Date: Nov 2006
Posts: 554
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.
__________________
Grab your sword and fight the Horde!
  Reply With Quote
03-07-17, 08:47 PM   #3
Layback_
An Onyxian Warder
Join Date: Feb 2016
Posts: 356
Originally Posted by Lombra View Post
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

Last edited by Layback_ : 03-07-17 at 08:54 PM.
  Reply With Quote
03-08-17, 12:14 AM   #4
Ketho
A Molten Giant
AddOn Author - Click to view addons
Join Date: Mar 2010
Posts: 847
Originally Posted by Layback_ View Post
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

Last edited by Ketho : 03-08-17 at 12:26 AM.
  Reply With Quote
03-08-17, 01:11 AM   #5
Layback_
An Onyxian Warder
Join Date: Feb 2016
Posts: 356
Originally Posted by Ketho View Post
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
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.
  Reply With Quote
03-08-17, 08:18 AM   #6
Kanegasi
A Frostmaul Preserver
 
Kanegasi's Avatar
AddOn Author - Click to view addons
Join Date: Apr 2007
Posts: 284
Originally Posted by Layback_ View Post
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.
  Reply With Quote
03-08-17, 06:16 PM   #7
Layback_
An Onyxian Warder
Join Date: Feb 2016
Posts: 356
Originally Posted by Kanegasi View Post
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

Last edited by Layback_ : 03-09-17 at 04:30 PM.
  Reply With Quote

WoWInterface » Developer Discussions » General Authoring Discussion » Can you get db for every single items exist in WoW (in-game)?

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off