open All Channels
seplocked EVE Technology Lab
blankseplocked Faction/Corporation Logo's from the Dump
This thread is older than 90 days and has been locked due to inactivity.

Author Topic

Princess Corrino
Hinata Inn
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.

select f.corporationID,f.factionID,f.factionName,f.description,i.iconFile
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?

1st Steps Academy
Fidelas Constans
Posted - 2011.02.20 01:53:00 - [2]

Yeah, it is a bit ridiculous isn't it... I based mine off of to help resolve the inconsistencies. I think that list was made up manually before they included any such data in the data dump.

Narusegawa Mei
Posted - 2011.02.20 12:03:00 - [3]

Edited by: Narusegawa Mei on 20/02/2011 12:06:52
The export is pretty bad with regards to faction information and icons, hope they change that in the future.

Princess Corrino
Hinata Inn
Posted - 2011.02.20 12:06:00 - [4]

Thanks for that.

I've made an "Out of EVE" plugin for my own website that shows Standings now.
Please visit your user settings to re-enable images.


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


The new forums are live

Please adjust your bookmarks to

These forums are archived and read-only