EVE Technology Lab

I have been going through Trenker's very helpful API tutorials on his site (great work btw ). I can pull information from the dump and display it but as i'm a bit of a noob to all this, i was wondering if there's any info out there about displaying the related icons to the database items in a page (i.e. having the picture of a deimos appear next to the ship data). I have looked for the info and googled it endlessly and am getting fed up (and a little demoralized tbh) with hitting dead ends and seemingly irrelevant info (like i said, i am a bit of a noob to this so the info may be useful but i can't 'see the wood for the trees' at the moment). Any pointers, code snippets or links would be most helpful and really appreciated.

Many thanks in advance :)

yp, i'm using php and mysql. Thanks for the example , i'm looking more for how to code that into the output. I can retrieve the data using sql query in php, but how to code in displaying the image?

just stick an image tag into your output, using the typeid of the thing.

< img src="http://image.eveonline.com/InventoryType/< ? echo $row->typeid; ?>_64.png">

Obviously, remove the spaces after the < or it'll not work (that's the forums for you.)


If you want some code to poke through, have a look at
https://github.com/fuzzysteve/eve-blueprint-calc
It's got some stuff in it (memcache mostly) which makes a bit more complicated, but if you're just reading it, it's not that tricky. If you'd like a simpler sample, I can put one together.





http://image.eveonline.com/ explains what images are available.

Thanks for the info and the help

I've started getting the kind of results i'm looking for now from the database dump, however i'm now getting these kinds of image results:

"res:/Texture/Landmark/{image}.jpg"*

...on some queries. Is there anywhere locally on my machine they are retrieveable from or not? I have the database dump plus all the image files that go with it but i can't seem to find this group of images at all
-Any pointers (even if it's 'nope, can't get at them images') Would be most appreciated...

*Substitute {image} for any given image name in that category

If you provide a specific query, that yield these or similar results, I might be able to help you with figuring that out.

If you look in the 'maplandmarks' table and follow an entry's 'iconID' link, the entry you are taken to in the 'eveicons' table invariably has "res:/Texture/Landmark/{image}.jpg" as it's image path... Similar story with some other tables/items and so forth...

Thanks for confirming that :)

Although this next issue is to do with the DB dump, i don't want to start another thread... I've been trying to get a query where i list the stars and constellations in a region. I can query one or the other, but when i try to combine the two queries (and i have tried many ways) it fails in some way -either with an error or returning no rows. The two queries i have adapted from an existing example query in the eve id.net wiki. Here they are:

Display Systems:
SELECT solarSystemName AS systems
FROM mapSolarSystems
INNER JOIN mapRegions ON mapSolarSystems.regionID=mapRegions.regionID AND mapRegions.regionName='Essence';

and

Display Constellations:
SELECT constellationName AS constellation
FROM mapconstellations
INNER JOIN mapRegions ON mapconstellations.regionID=mapRegions.regionID AND mapRegions.regionName='Essence';

I am really newbish to this but i am learning loads as i go along, i have just hit a bit of a wall with this -probably another case of not seeing the wood for the trees. If anyone can give me a pointer as to how i merge the two queries together, that would be of enormous help, thx :)

My final aim is to be able to retrieve a list of solar systems in a given region by constellation to allow me to then keep track of inspace corp assets by adding them in from a website. Since i am in the middle of learning php and mysql i'm looking to do this with these technologies. I may need to refine my explanation further but that's the basic gist

ok, so even if i don't include that in the search as it's irrelevant, i'd still like the facility to have the constellation listed so if necessary the results can be grouped by that category -if you see what i mean...

Fair enough, but i do. Although i appreciate your insights (and the pointer to mapdenormalize was a huge help ), i'd like to know whether it's possible, not whether you feel it is relevant for me to be doing... If it's not at all possible, then fair enough but if it is...