Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Alexis Prey
Aurora Industrial Coalition Externus Hostis
3
|
Posted - 2011.09.08 23:47:00 -
[1] - Quote
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
Juggalicious
0
|
Posted - 2011.09.09 00:23:00 -
[2] - Quote
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
Aurora Industrial Coalition Externus Hostis
3
|
Posted - 2011.09.09 17:58:00 -
[3] - Quote
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%29You 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
21
|
Posted - 2011.09.09 18:40:00 -
[4] - Quote
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
Icosahedron Crafts and Shipping Silent Infinity
6
|
Posted - 2011.09.10 13:50:00 -
[5] - Quote
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 [img]http://www.evemarketeer.com/player/sig/511049420[/img] Want images? |
Alexis Prey
Aurora Industrial Coalition Externus Hostis
3
|
Posted - 2011.09.12 01:34:00 -
[6] - Quote
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 :) |
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |