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.
 

Finding out which blueprints are available as bpos (i.e. T1)?
Author
Previous Topic Next Topic
Messenger Of Truth
Butlerian Crusade
#1 - 2015-03-12 16:50:32 UTC
From the blueprint data in the SDE, is it possible to determine which blueprints are T1? There are a few things I can think of that whittle out some of the T2/T3 ones:

1) T1 blueprints may have an invention or copy job listed in the activies (this doesn't exclude t2 bpos)
2) products of the blueprint may have Tech I listed in the invMetaGroups.invMetaGroupName (many items don't have an entry here at all)


The best I can think of is to use the crest api and scan each region for a market sell order for the blueprint, but this is maybe 300,000 requests (although less if we eliminate wormhole regions).

Trade Hub Price Checker: stop.hammerti.me.uk/pricecheck

Visit "Haulers Channel" in game for all matters courier-related.

Structure name/system API: stop.hammerti.me.uk/api
SJ Astralana
Syncore
#2 - 2015-03-12 19:38:21 UTC
Messenger Of Truth wrote:
From the blueprint data in the SDE, is it possible to determine which blueprints are T1? There are a few things I can think of that whittle out some of the T2/T3 ones:

1) T1 blueprints may have an invention or copy job listed in the activies (this doesn't exclude t2 bpos)
2) products of the blueprint may have Tech I listed in the invMetaGroups.invMetaGroupName (many items don't have an entry here at all)


The best I can think of is to use the crest api and scan each region for a market sell order for the blueprint, but this is maybe 300,000 requests (although less if we eliminate wormhole regions).


Have a look at invMetaGroups and invMetaTypes, that will give you T1. Next, look at the published flag. From memory, this will get you to the T1 blueprints that are seeded on market.

Hyperdrive your production business: Eve Production Manager

Messenger Of Truth
Butlerian Crusade
#3 - 2015-03-13 12:22:28 UTC  |  Edited by: Messenger Of Truth
SJ Astralana wrote:
Messenger Of Truth wrote:
From the blueprint data in the SDE, is it possible to determine which blueprints are T1? There are a few things I can think of that whittle out some of the T2/T3 ones:

1) T1 blueprints may have an invention or copy job listed in the activies (this doesn't exclude t2 bpos)
2) products of the blueprint may have Tech I listed in the invMetaGroups.invMetaGroupName (many items don't have an entry here at all)


The best I can think of is to use the crest api and scan each region for a market sell order for the blueprint, but this is maybe 300,000 requests (although less if we eliminate wormhole regions).


Have a look at invMetaGroups and invMetaTypes, that will give you T1. Next, look at the published flag. From memory, this will get you to the T1 blueprints that are seeded on market.


Thanks the published flag is new to me and looks useful to weed out some crap, however this still doesn't get me there. If you query on Merlin and Gnosis, they both have published set to 1, but neither have a T1 or other technology set in invMetaGroups, so I can't programatically determine that Gnosis is available only through a limited number of BPCs, while the Merlin is available through NPC sell orders.

SELECT * FROM invTypes as it LEFT OUTER JOIN invMetaTypes as imt on imt.typeID = it.typeID LEFT OUTER JOIN invMetaGroups as img on imt.metaGroupID = img.metaGroupID where it.typeName = "Gnosis";

Trade Hub Price Checker: stop.hammerti.me.uk/pricecheck

Visit "Haulers Channel" in game for all matters courier-related.

Structure name/system API: stop.hammerti.me.uk/api
SJ Astralana
Syncore
#4 - 2015-03-13 22:12:50 UTC
I did this quite a while ago so I'm code surfing to piece it back together.

For a blueprint, published means it's in game, either on market or as a bpc. If a published blueprint has a valid marketGroupId, then it shows in market, meaning it must be tech I because all others only exist as BPCs. You have to look at published status because there are unpublished blueprints with marketGroupIds.

So yeah my previous post was a waste of time other than starting to jog my memory.

Hyperdrive your production business: Eve Production Manager

Messenger Of Truth
Butlerian Crusade
#5 - 2015-03-16 20:38:15 UTC
Aha that does work for Gnosis - although Gnosis has a marketGroupID, its blueprint does not. Cheers.

Trade Hub Price Checker: stop.hammerti.me.uk/pricecheck

Visit "Haulers Channel" in game for all matters courier-related.

Structure name/system API: stop.hammerti.me.uk/api
Aineko Macx
#6 - 2015-03-17 13:23:54 UTC  |  Edited by: Aineko Macx
SJ Astralana wrote:
If a published blueprint has a valid marketGroupId, then it shows in market, meaning it must be tech I because all others only exist as BPCs.

There are published T2 BPs with marketGroupID, "Taranis Blueprint" for instance.

If you are using Steve's SDE conversion, you can use the industry* tables to find only T1 BPs, for instance like this:
SELECT it.typeName, ia.typeID
FROM industryActivity as ia
JOIN invTypes as it ON ia.typeID = it.typeID
WHERE ia.activityID = 1
AND it.published = 1
AND ia.typeID NOT IN (SELECT productTypeID FROM industryActivityProbabilities)


That won't solve the Gnosis problem, because for all intents and purposes it is a simple T1 BP, it's just not seeded on the market, and the SDE doesn't include that data.

iveeCore 3.0: The PHP engine for industrial activities and CREST library
SJ Astralana
Syncore
#7 - 2015-03-17 19:52:25 UTC
Aineko Macx wrote:

There are published T2 BPs with marketGroupID, "Taranis Blueprint" for instance.


Hmm, this may tie back in to the meta tables I mentioned before. T2/etc is usually/always found there where T1 is often not. It seems likely that if a blueprint is on market and its built meta type isn't T2/faction/storyline then it can be bought and built.

Hyperdrive your production business: Eve Production Manager