open All Channels
seplocked EVE Technology Lab
blankseplocked Simple question about typeIcons
 
This thread is older than 90 days and has been locked due to inactivity.


 
Author Topic

wardson
Posted - 2011.07.14 11:37:00 - [1]
 

My quick and simple question is about the typeIcons in the static data dumps.

I'm building a web application wich now is in the phase where I need to fetch the icons of certain item types. My problem is that I DL-ed the current version of database dump and the updated version of the image types pack yet when I do a query for a list of items there are some of them wich don't get their image.

To get the proper image wich stands for the queried item, I request the iconId from the invTypes table. The result is that there are items wich have their icons and there are a few wich don't.

I checked the images folder and I can't find the correspondig files by hand neither, that's why I guess, that the names don't mach.

Can anyone help me with this? What is it that I'm doing wrong?

Thanks in advance Embarassed

Trenker
Posted - 2011.07.14 13:27:00 - [2]
 

iconID refers to the eveIcons table, which has a iconFile column. This is the name of the actual icon image
eg.:

SELECT
t1.typeName AS NAME, IF(t2.iconFile IS NULL, 'none', CONCAT(t2.iconFile, '.png')) AS icon
FROM invTypes AS t1
LEFT JOIN eveIcons AS t2 ON t1.iconID = t2.iconID

wardson
Posted - 2011.07.14 13:57:00 - [3]
 

Originally by: Trenker
iconID refers to the eveIcons table, which has a iconFile column. This is the name of the actual icon image
eg.:

SELECT
t1.typeName AS NAME, IF(t2.iconFile IS NULL, 'none', CONCAT(t2.iconFile, '.png')) AS icon
FROM invTypes AS t1
LEFT JOIN eveIcons AS t2 ON t1.iconID = t2.iconID


My God... Thank you, and please forgive me for my stupidness Sad


 

This thread is older than 90 days and has been locked due to inactivity.


 


The new forums are live

Please adjust your bookmarks to https://forums.eveonline.com

These forums are archived and read-only