open All Channels
seplocked EVE Technology Lab
blankseplocked List of BPO's with NPC Prices
 
This thread is older than 90 days and has been locked due to inactivity.


 
Author Topic

DejaPeaux
Mine 'N' Refine
The Unforgiven Alliance
Posted - 2011.07.16 22:38:00 - [1]
 

Edited by: DejaPeaux on 16/07/2011 22:38:34
I have been looking at the database dump, trying to get a list of BPO's with the NPC price, But i can't find any price column
I found the following sql script on http://wiki.eve-id.net Which returns Lists all BPO’s
Is it possible to get the NPC Price using the DataDump or do I need to use the API

SELECT blueprintType.typeID,
blueprintType.typeName Blueprint,
productType.typeID,
productType.typeName Item,
productGraphic.iconFile ItemGraphic,
productGroup.groupName ItemGroup,
productCategory.categoryName ItemCategory,
blueprints.productionTime,
blueprints.techLevel,
blueprints.researchProductivityTime,
blueprints.researchMaterialTime,
blueprints.researchCopyTime,
blueprints.researchTechTime,
blueprints.productivityModifier,
blueprints.materialModifier,
blueprints.wasteFactor,
blueprints.maxProductionLimit
FROM invBlueprintTypes AS blueprints
INNER JOIN invTypes AS blueprintType ON blueprints.blueprintTypeID = blueprintType.typeID
INNER JOIN invTypes AS productType ON blueprints.productTypeID = productType.typeID
INNER JOIN invGroups AS productGroup ON productType.groupID = productGroup.groupID
INNER JOIN invCategories AS productCategory ON productGroup.categoryID = productCategory.categoryID
INNER JOIN eveGraphics AS blueprintGraphic ON blueprintType.graphicID = blueprintGraphic.graphicID
INNER JOIN eveIcons AS productGraphic ON productType.iconID = productGraphic.iconID
WHERE blueprintType.published = 1

Ruziel
Minmatar
Twilight Military Industrial Complex
Posted - 2011.07.17 00:38:00 - [2]
 

Edited by: Ruziel on 17/07/2011 00:41:19
invTypes.basePrice

The NPC price fluctuates ±10% from the basePrice based on market activity, so most blueprints end up being 90% of the basePrice.

DejaPeaux
Mine 'N' Refine
The Unforgiven Alliance
Posted - 2011.07.17 00:55:00 - [3]
 

Edited by: DejaPeaux on 17/07/2011 01:03:56
Thanks... I don't know why i didn't see that..

I know this is a still question why is the baseprice 10% cheaper in game.

Ruziel
Minmatar
Twilight Military Industrial Complex
Posted - 2011.07.17 01:58:00 - [4]
 

Because NPC orders adjust over time based on how active they are. If people keep buying from an NPC order, the price gradually adjusts to 110% of the base price, conversely, they adjust to 90% of the base price if nobody is buying from them. Because of the low volume on most NPC BPO orders, they most often adjust down.


 

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