EVE Technology Lab

Thank you!

Great work as always,Steve Ronuken

Thanks!

I noticed in another thread you posted the following query:

SELECT materialtypeid,typename,greatest(1,ceil(quantity*(1-(7/100)))) runquantity
FROM industryActivityMaterials 
JOIN invTypes ON (industryActivityMaterials.materialtypeid=invTypes.typeid)
WHERE industryActivityMaterials.typeid=22465 and activityid=1;

+----------------+-------------------------------+-------------+
| materialtypeid | typename | runquantity |
+----------------+-------------------------------+-------------+
| 3828 | Construction Blocks | 22 |
| 11399 | Morphite | 14 |
| 11478 | R.A.M.- Starship Tech | 9 |
| 11533 | Magpulse Thruster | 56 |
| 11534 | Gravimetric Sensor Cluster | 70 |
| 11540 | Quantum Microprocessor | 335 |
| 11544 | Titanium Diborite Armor Plate | 1395 |
| 11550 | Graviton Reactor Unit | 14 |
| 11552 | Scalar Capacitor Unit | 140 |
| 11558 | Sustained Shield Emitter | 36 |
| 16238 | Cormorant | 1 |
+----------------+-------------------------------+-------------+

When I run that, my output is (using the postgres DB, and query modified):

SELECT "materialTypeID","typeName",greatest(1,ceil(quantity*(1-(7/100)))) as runquantity
FROM "industryActivityMaterials" 
JOIN "invTypes" ON ("industryActivityMaterials"."materialTypeID"="invTypes"."typeID")
WHERE "industryActivityMaterials"."typeID"=22465 and "activityID"=1;

 materialTypeID |      typeName      | runquantity 
----------------+--------------------+-------------
              0 | #System            |         150
              2 | Corporation        |          60
              3 | Region             |           1
              4 | Constellation      |          23
              5 | Solar System       |          75
              6 | Sun G5 (Yellow)    |           9
              7 | Sun K7 (Orange)    |        1500
              8 | Sun K5 (Red Giant) |         360
              9 | Sun B0 (Blue)      |          38
             10 | Sun F0 (White)     |          15
(10 rows

When I look at the DB data, the materialTypeID's in the industryActivityMaterials number 0 through 10 for most or all products, appearing to be an index relative to each blueprint rather than ID's to actual invTypes. It appears I could use the info from invTypeMaterials, but I would like to understand the discrepancy here.

Has the DB structure changed since you wrote that query a few months ago? What does materialTypeID refer to?

Also, the values for industryActivityProducts productTypeID appear to be missing.

If I look at the Oceanus sqlite DB, the values appear as I would have expected them.

Thanks!

This is the exact same problem as I reported here for the early phoebe SDE : https://forums.eveonline.com/default.aspx?g=posts&m=5128325#post5128325

I was hoping it'll be fixed :/

I have passed word of this on to others, but it's the weekend now and with the Phoebe release on Tuesday it may be a bit before a response.

Ah yes, it does appear to have been an issue in the conversion as the YAML and such all seems fine.

That's it updated.

If you need just the industry tables (on mysql) https://www.fuzzwork.co.uk/dump/phoebe-1.0-107269/industryTables.sql.bz2

The blueprints.yaml and hence the conversion still have Data Interfaces as materials for invention.

e.g.

10679:
  activities:
    copying:
      time: 720
    invention:
      materials:
      - quantity: 1
        typeID: 20412
      - quantity: 1
        typeID: 20414
      - quantity: 1
       typeID: 25556

25556 is Incognito Data Interface, 10679 is 125mm Railgun I Blueprint.

http://community.eveonline.com/news/dev-blogs/invention-updates/ says Data Interfaces are going away.

Before the removal of interfaces, we could get the groupID of compatible decryptors for invention via dgmAttributeType=1115 of the used interface. Now that they are gone, there doesn't seem to be a clean way to get this data.

Also I found data inconsistencies in blueprints.yaml data. https://forums.eveonline.com/default.aspx?g=posts&m=5174902#post5174902

ignore