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.
 

Assets list - How to turn ItemID into something understandable?
Author
Previous Topic Next Topic
Alexis Prey
The Scope
Gallente Federation
#1 - 2011-09-08 23:47:25 UTC
I don't see any reference on how to handle this. I have a bunch of ItemID numbers, and no way to turn them into like an actual Item name.. Can someone please explain or link me?
Hobson's Choice
Nos Decipiat
#2 - 2011-09-09 00:23:39 UTC
The IDs from the API pull references a tuple in a table of the static data dump.

ItemID prolly means you want invTypes: http://wiki.eve-id.net/InvTypes_%28CCP_DB%29

You can use a database, spreadsheet or other program to complete the lookup between your ID and the static database.

Personally, everything i do is in google docs.

HTH
Alexis Prey
The Scope
Gallente Federation
#3 - 2011-09-09 17:58:07 UTC
Hobson's Choice wrote:
The IDs from the API pull references a tuple in a table of the static data dump.

ItemID prolly means you want invTypes: http://wiki.eve-id.net/InvTypes_%28CCP_DB%29

You can use a database, spreadsheet or other program to complete the lookup between your ID and the static database.

Personally, everything i do is in google docs.

HTH


Can you explain this please? I have a MySQL database obviously, but I don't know anything about this data dump. I'm pretty new in php programming, (about 6 months), and while I understand how to use the IGB, and APIs, I've never had to work with a data dump before.
Desmont McCallock
#4 - 2011-09-09 18:40:46 UTC
Get a copy of the SDD for MySQL from here. Then use the PHP's MySQLi or PDO extension to do queries to the DB.
Callean Drevus
Perkone
Caldari State
#5 - 2011-09-10 13:50:52 UTC
What Hobson probably meant to say, is that in addition to the itemID's you got from *somewhere* (I'm going to assume the API) there probably also were typeID's (if from the API, they're in the same xml element), the typeID is the thing that you really want to use if you want to make something useful of the data.

typeID = the type of the item, 'Antimatter Charge S', 'Foxfire Rocket' or 'Small Pulse Laser I' for example.
itemID = the ID of the specific item on a specific location somewhere in game.

For a more complete description of both, you can look at this page: here

Developer/Creator of EVE Marketeer
Alexis Prey
The Scope
Gallente Federation
#6 - 2011-09-12 01:34:43 UTC
Callean Drevus wrote:
What Hobson probably meant to say, is that in addition to the itemID's you got from *somewhere* (I'm going to assume the API) there probably also were typeID's (if from the API, they're in the same xml element), the typeID is the thing that you really want to use if you want to make something useful of the data.

typeID = the type of the item, 'Antimatter Charge S', 'Foxfire Rocket' or 'Small Pulse Laser I' for example.
itemID = the ID of the specific item on a specific location somewhere in game.

For a more complete description of both, you can look at this page: here


Both of you area really helpful. Thanks to both of you! Thanks again :)