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.
 

[Q] Eve DB Dump | Invetion
Author
Previous Topic Next Topic
Javani
Brutor Tribe
Minmatar Republic
#1 - 2012-05-30 23:40:43 UTC
Hi folks,

i dont get it. How can i find the entrys for which invention need which datacores and how many of them?

Greeting
Javani
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#2 - 2012-05-31 00:07:28 UTC
The table you want is ramTypeRequirements, with the activity id 8 (defined in ramActivities as invention)

select typename,quantity,damagePerJob from ramTypeRequirements rtr,invTypes it where it.typeid=rtr.requiredTypeID and activity=8 and rtr.typeid=1318;

Where the 1318 is the type id for an Expanded Cargohold I Blueprint.

you'll get :
*************************** 1. row ***************************
typename: Datacore - Molecular Engineering
quantity: 2
damagePerJob: 1
*************************** 2. row ***************************
typename: Datacore - Nanite Engineering
quantity: 2
damagePerJob: 1
*************************** 3. row ***************************
typename: Cryptic Data Interface
quantity: 1
damagePerJob: 1



It's lying about the damage to the cryptic data interface. It's not used up.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Javani
Brutor Tribe
Minmatar Republic
#3 - 2012-05-31 07:42:52 UTC
Many thanks!

thats helps :)