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.
 

Ship blueprint info in datadump
Author
Previous Topic Next Topic
Nemesis Darknight
Ministry of War
Amarr Empire
#1 - 2011-10-22 17:46:20 UTC
Hi all,
I've just downloaded the datadump for the 1st time and am a bit lost.

Sorry if this has been asked before but I could only find really old examples and the table names seem to have changed.

I'm trying to get information for ship blueprints out of the datadump.
Specifically, I need the ship name, ship class (frigate, destroyer etc) the tech level and all the quantities of the components needed to build the ship.

Also, is there a site that hosts a queriable copy of the datadump?

Thanks in advance
Nem
Cyerus
University of Caille
Gallente Federation
#2 - 2011-10-23 01:44:21 UTC
It's very hard to find the correct metalevel and techlevel of an item, I'll leave that open for somebody with more experience to answer. Also, I do not think anybody is hosting free database access to an EVE database dump.

I suggest to start with the 3 queries found on this page -> http://wiki.eve-id.net/Denormalizing_itm/rtr
This denormalizes the invTypeMaterials / ramTypeRequirements, basicly combining all the components into one table.

After that you only need to query the new 'materials' table to get a list of materials needed;
Quote:
SELECT *
FROM materials
WHERE blueprintTypeID = 1234
AND activityID = 1;

..to return invTypesID (requiredTypeID) needed to build fictional blueprint 1234.

Don't forget to do the ME calculations afterwards!

---

If you are just looking for a web application to do this all for you, I can suggest http://eve-it.org/market.
A website of my own making, still beta, which is exactly what you need. Prices are outdated, but quantities and ME calculations should be accurate.