Posted - 2011.02.19 22:21:00 - [1
I'm trying to get the correct iconFile's from the database for both Corporation, and Factions. However they seem a rather large mismatch.
from chrFactions f
left outer join eveIcons i on f.iconID = i.iconID
This returns most of them okay. However for the 4 main factions you have to look in the items/xx_yy/ folder for example. 19_03 is the Gallente one.
Okay, fair enough, but then when you hit The Servant Sisters of EVE you would get 14_01. If you look in items/xx_yy/ you would get some projectile ammo icon!
The Khanid Kingdom returns a NULL. Yet in reality this is actually found corporations/xx_yy/ as 45_03.
How exactly ARE we meant to use this to get the correct faction icon?