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
Amarr
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?

Celebrain
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 http://wiki.eve-id.net/CrpNPCCorporations 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
Amarr
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 https://forums.eveonline.com

These forums are archived and read-only