open All Channels
seplocked EVE Technology Lab
blankseplocked Extracting ALL Blueprints
 		This thread is older than 90 days and has been locked due to inactivity.


 
Author Topic

Agnemon
Posted - 2011.05.08 08:04:00 - [1]
 
EveAI 1.5
Can someone show me an efficient way of extracting a list of all buildable blueprints including sov and POS structures and T3.

if I use

product.Group.Category.Name == "Blueprint"

I have to set up if statements to exclude unwanted items (lots)

This is causing me to lose what little hair I have left

Thanks in advance

Agnemon
Posted - 2011.05.08 08:08:00 - [2]
 
hmmmm

pays to reply to a thread, not start a new topic.

personally, I blame it on the beer.

if someone wants to reduce my embarrassment somewhat, they can delete these posts, and I will "REPLY" to the correct topicEmbarassed.

dungabee
Minmatar
Molden Heath Software Company
Posted - 2011.05.08 16:29:00 - [3]
 
This should do it:

select invblueprinttypes.producttypeid, invtypes.typename
from invblueprinttypes, invtypes
where
invblueprinttypes.producttypeid = invtypes.typeid ;

Xaroth Brook
Minmatar
BIG
Gentlemen's Agreement
Posted - 2011.05.09 09:04:00 - [4]
 
You might also want to filter out all types (both blueprint and product) who are not published, for good measure.


 

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