These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

Types, Categories, Items, Groups.......

First post
Author
Previous Topic Next Topic
Barrak
The Painted Ones
#1 - 2015-06-16 09:14:21 UTC
Hi,

Can someone please advise as to the hierarchy of the above (and any missing elements).

I'm learning how to extract data from the game in order to create a spread sheet and (eventually) build a database. A key part of this will be able to query Groups, Market groups meta levels etc without having to call the whole market.

I'd also like to know how group and marketgroup differ.

Regards

Barrak
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#2 - 2015-06-16 11:53:13 UTC
Types have groups
groups have categories

Types have market groups
market groups have market groups, which can have market groups. (until it's null)

You don't need to extract this from the game though. It's all in the SDE

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Barrak
The Painted Ones
#3 - 2015-06-17 19:42:11 UTC
Whats the difference between a type and an item?

I seem to have labelled my columns differently and now I'm unsure as to what the difference is.

Regards

Barrak
Ydnari
Estrale Frontiers
#4 - 2015-06-17 21:34:47 UTC
Barrak wrote:
Whats the difference between a type and an item?

I seem to have labelled my columns differently and now I'm unsure as to what the difference is.

Regards

Barrak


1MN Afterburner II is a type.

A 1MN Afterburner II in your hangar is an item.

--
Barrak
The Painted Ones
#5 - 2015-06-17 22:29:21 UTC
Ydnari wrote:
Barrak wrote:
Whats the difference between a type and an item?

I seem to have labelled my columns differently and now I'm unsure as to what the difference is.

Regards

Barrak


1MN Afterburner II is a type.

A 1MN Afterburner II in your hangar is an item.


thanks.

So, for market stuff type is key and for asset management items.

Regards

Barrak
Hel O'Ween
Men On A Mission
#6 - 2015-06-18 16:49:09 UTC
Quote:

So, for market stuff type is key and for asset management items.


Let's put it that way: everytime you want to know the name of the "thing" - be it for wallet transactions, market orders or assets, you take the typeID and look up typeName in the table invTypes.

The itemID in the assets API the unique ID of this item. So, if you've got 3 1MN Afterburner II in your hangar, you'll get

itemID  typeID  typeName
1       438     1MN Afterburner II
2       438     1MN Afterburner II
3       438     1MN Afterburner II

EVEWalletAware - an offline wallet manager.