EVE Technology Lab

A useful info for players in the industrial side of EVE could be the daily destruction of ships and components, so they can plan what repositions are needed.

This could be gor in principle by taking a good sample of the ships listed in the killboards and then using the local kill statistics, from CREST, to scale the sample to get an estimate of the total destruction and decompose it into raw materials.

Now, is some of the killboards offering itself an API to obtain such sample, or can you think another technique? Perhaps some RSS feed of recent kills?

As Steve said, leverage the kill mails from zKill. To decompose into raw materials is a trickier function.

Depending on whether or not the item destroyed was buildable from a blueprint you need to determine what the ideal Material Efficiency of said item's blueprint was. Or you could nominate an ideal ME, or a set limit to the value itself.

T2 items would need to have such things as the adjusted ME/PE after invention (unless you have T2 BPOs on hand) accounted for, and if you wanted to get tricky the invention success rate (ideal or nominal) divided by the cost of the datacores to have a ballpark indication of how many datacores and invention attempts would equal one successful invention.

To do all of this, you will need to store the kill data on a local database server, use the EVE Static Data Dump and write either timed events to into SQL to generate a daily brief of kills and ships/modules destroyed and then use said daily data to calculate the materials required to build the destroyed items.

Big job, but I can see where and how it would be used too.

About the zkill API, has somebody got an estimate of how deep its coverage is? I guess that most PvP killings are in the list; but I can not think how to get same info (or any info at all) for the ships losts in PvE missions.




Well, both things are tricky, it seems, in the same recursive way, but I think I can work with it. On the raw material side, it is a bit of inconvenience that Capital Ships are actually built from subcomponentes plus minerals, so two steps are needed to recover the initial composicion. And in the killmails, I notice that besides the ship I should add all the fittings which are destroyed too, plus the no recovered cargo.

As for ME, I favor the diea of an ideal ME. I guess that most of the production is run under optimal ME, isn't it?

The static database is an incredible resource. invTypeMaterials table seems all I need to run the decomposition.

Ok, here is a first try, and a couple of questions:

https://gist.github.com/arivero/9938726

1) I wonder which is the best method to query zkillboard for all the kills. At the moment, there is a loop for all the known GroupIDs that can be killed, and I am not sure if it is complete. The alternative was to loop for Solar Systems or Regions, but the Regional query does not seem to work (or needs extra parameters).

2) I am in doubt about the full decomposition of some materials. In a test run, the final decomposition is as follows:




Some products seem to be finals according the table invTypeMaterials but not according the Evelopedia. For instane, "Construction Blocks", aka typeID=3828, is not in invTypeMaterials. I guess here I need some of the UNIONS that KnifeOrSpoon was mentioning, do I?

I see In this case only a sample from time to time is needed, and I guess I could minimize the queries by grouping the groupIDs.