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.
 

CSV Export

Author
DejaPeaux
Last Stand Enterprises
#1 - 2011-12-19 10:48:56 UTC
Would anyone have a CSV export of all the BPO's with the base Price on them.

Or is there a easy way for me to get this information out of the Static Dump.

Thanks in advance.

Deja Big smile

.

Lutz Major
Austriae Est Imperare Orbi Universo
#2 - 2011-12-19 11:05:41 UTC
SELECT invTypes.typeName, invTypes.basePrice * 0.9
FROM invTypes, invBlueprintTypes
WHERE invTypes.typeID = invBlueprintTypes.blueprintTypeID
AND invTypes.published = 1

-- narrow query down to available BPOs on the market ...
AND invTypes.marketGroupID IS NOT NULL

-- ... and only Tech 1 blueprints
AND invBlueprintTypes.techLevel = 1


If you don't actually have the dump, let me know and I make the CSV file
DejaPeaux
Last Stand Enterprises
#3 - 2011-12-19 12:03:31 UTC
Lutz Major wrote:
SELECT invTypes.typeName, invTypes.basePrice * 0.9
FROM invTypes, invBlueprintTypes
WHERE invTypes.typeID = invBlueprintTypes.blueprintTypeID
AND invTypes.published = 1

-- narrow query down to available BPOs on the market ...
AND invTypes.marketGroupID IS NOT NULL

-- ... and only Tech 1 blueprints
AND invBlueprintTypes.techLevel = 1


If you don't actually have the dump, let me know and I make the CSV file

Thanks..

That worked..

.

Max Kolonko
Caldari Provisions
Caldari State
#4 - 2011-12-19 20:03:41 UTC
why base_price * 0.9 ?
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#5 - 2011-12-19 22:59:29 UTC
If an item isn't bought from an npc vendor, in time the price drops. by up to 10%.

On the other hand, as it is bought, the price rises. by up to 10%

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter