| Pages: [1] :: one page |
|
|
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Nerfair
   |
Posted - 2009.09.17 17:41:00 -
[1]
Hi!
in Eve API xml i ve got this
"<row typeID="3359" skillpoints="24000" level="3" />"
but how i can find Skill Name? or Item Name (assets)
|
Dragonaire
Caldari
Corax.
New Eden Retail Federation
|
Posted - 2009.09.17 17:56:00 -
[2]
Need to use the invTypes table from the static data dump do the number-to-name conversions. Most times when there seems to be something missing in one of the APIs like that you'll find the data in the static data. See the stickys for links to the data in several formats.
--
Finds camping stations from the inside much easier.
Designer of Yapeal for Eve API.
|
Ki Tarra
Ki Tech Industries
|
Posted - 2009.09.17 18:18:00 -
[3]
Alternatively, if it is easier for your application to parse XML than to load the data dump, you can get that information from http://api.eve-online.com/eve/SkillTree.xml.aspx
|
Nerfair
|
Posted - 2009.09.17 18:23:00 -
[4]
And for item names i need to use Dragonaire's method? :)
|
Ki Tarra
Ki Tech Industries
|
Posted - 2009.09.17 19:13:00 -
[5]
That or you can try using this API:
http://api.eve-online.com/eve/CharacterName.xml.aspx?ids=3359,2488,519
|
MrRx7
Amarr
Cutting Edge Incorporated
RAZOR Alliance
|
Posted - 2009.09.17 19:31:00 -
[6]
 Originally by: Nerfair
And for item names i need to use Dragonaire's method? :)
You can either use a local sql table or query the api for ever ID, hitting the api for everytime single typeID is a waste of ccp's database :-)
if you are using 2 tables a simple inner join will work just fine
Select * from yourtable yt innerjoin invtypes inv on (yt.typeID = inv.typeID)
That is just a example, don't expect it to work without some minor modifications :-)
|
Ki Tarra
Ki Tech Industries
|
Posted - 2009.09.17 21:57:00 -
[7]
Originally by: MrRx7
hitting the api for everytime single typeID is a waste of ccp's database :-)
Hitting the api seperately for each name is a waste. Hitting it once for several names is not. Notice that it is possible to look up alot of names with a single api query.
The question you need to answer: is it more wasteful to go to the web to get the information, or is it more wasteful to go to a database.
If your application would only use the database to lookup the names of items, then it would be wasteful to include a database for only that purposes. You might as well make a single call to the API if your application is already getting the rest of its data from there.
However, if your application includes a database for other needs, then you will likely want to get the data you need from that location, and only go to the API if your application cannot find the name that it needs in any of the other tables.
|
Catari Taga
Centre Of Attention
Rough Necks
|
Posted - 2009.09.18 11:44:00 -
[8]
Edited by: Catari Taga on 18/09/2009 11:45:23
Originally by: Ki Tarra
The question you need to answer: is it more wasteful to go to the web to get the information, or is it more wasteful to go to a database.
No, the question you need to answer is: Can I really not be bothered to use the datadump rather than hitting CCP's servers, thus putting more load on it and reducing performance for all EVE users? It's a matter of scaling, you may say your little app doesn't put much load on it by itself but there's thousands of these little apps and even more users, that adds up.
Originally by: Ki Tarra
If your application would only use the database to lookup the names of items, then it would be wasteful to include a database for only that purposes.
The typeIDs and typeNames add up to 380 KB if exported as a .csv table, nothing wasteful about including that.
|
Astax
Caldari
|
Posted - 2009.09.18 12:24:00 -
[9]
getting the info from the datadump is allot of work.
just collect all ids you may need (for example all solarsystem IDs) and request the names per ids from the api server in one request. the xml file you get can be saved at your server or you can save it in your db as "id -> name" table.
so you have to run this script once and you collected all data in your own db. no need to ask the api-server again and again and you don't have to extract the needed data form the large datadump
additionally you can add a function to your script that looks up unknown ids to add their names to your table, just as a backup-function if you forgot to look up one or two ids.
|
Nerfair
|
Posted - 2009.09.19 12:07:00 -
[10]
Edited by: Nerfair on 19/09/2009 12:17:08
Edited by: Nerfair on 19/09/2009 12:09:50
Ok i get 1.5 Apocr. sql dump :) but i can't find ItemNames in it =/ Maybe smb can help me, in which table i can find it? :)
Found! Thanks 4 all :) I will not query eveapi each time to get info! :) |
|
|
|
|
| |
|
| Pages: [1] :: one page |
| First page | Previous page | Next page | Last page |