These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

DB query questions...
Author
Previous Topic Next Topic
King Bradly
School of Applied Knowledge
Caldari State
#1 - 2012-03-18 08:26:44 UTC  |  Edited by: King Bradly
Sorry if someone already asked, but...

How to get IconID from DB for specific item/ship type?
Nyx for example. typeID = 23913
There is NULL in "invTypes" table...
Desmont McCallock
#2 - 2012-03-18 08:34:57 UTC
I think using IconID is pretty useless. If you wan to get the image of an item/ship you fetch it from the Image server using the typeID.
Callean Drevus
Perkone
Caldari State
#3 - 2012-03-18 10:50:38 UTC
IconID's are only used for marketgroups as far as I'm aware.

Developer/Creator of EVE Marketeer
King Bradly
School of Applied Knowledge
Caldari State
#4 - 2012-03-22 03:41:10 UTC  |  Edited by: King Bradly
Yhea, thx. I'm already find that way =)

And i have new question.
How i can upgrade this: https://forums.eveonline.com/default.aspx?g=warning&l=http%3a%2f%2fpastebin.com%2f6mpks40z&domain=pastebin.com query to add some information about sp needed and/or skill train lvl? Meaning a possibility to calculate how much time needed to learn the skill.
Prefer MySQL syntax.
Louis Vitton
Viziam
Amarr Empire
#5 - 2012-03-24 04:29:41 UTC
King Bradly wrote:
Yhea, thx. I'm already find that way =)

And i have new question.
How i can upgrade this: https://forums.eveonline.com/default.aspx?g=warning&l=http%3a%2f%2fpastebin.com%2f6mpks40z&domain=pastebin.com query to add some information about sp needed and/or skill train lvl? Meaning a possibility to calculate how much time needed to learn the skill.
Prefer MySQL syntax.

Message CCP prismx he was the one who wrote it for us.