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.
 

Blueprint base + extra materials from static dump

Author
Gaius Henry
The Scope
Gallente Federation
#1 - 2013-07-16 21:44:33 UTC
According to http://wiki.eve-id.net/Bill_of_Materials BASE materials are gathered via this query:

SELECT materialTypeID, quantity FROM invTypeMaterials WHERE typeID = TYPE_ID;

And EXTRA materials are gathered by this query:

SELECT requiredTypeID, quantity FROM ramTypeRequirements WHERE typeID = BLUEPRINT_TYPE_ID AND activityID = 1;

... while the extra materials are correct, base ones aren't. Take for example the Brutix blueprint, it says (base materials, perfect, in-game / database):

  • Tritanium 2,094,871 / 1,904,428
  • Pyerite 463,308 / 421,189
  • Mexallon 166,674 / 151,522
  • Nocxium 9,834 / 8,940
  • Zydrine 1,813 / 1,648
  • Megacyte 943 / 857


As you can see the DB values are ~91% the "real" thing (90.90%). How can I correctly get them? I'm a newbye in the game, maybe the "perfect" price is not the best one and you can make it for less?
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#2 - 2013-07-16 22:18:24 UTC  |  Edited by: Steve Ronuken
https://www.fuzzwork.co.uk/2012/10/24/eve-sde-sql-blueprint-details/

Should answer your questions. (short version: you're not taking into account waste due to ME 0)

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter

Gaius Henry
The Scope
Gallente Federation
#3 - 2013-07-17 09:27:45 UTC
Thanks Steve :)