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.
 

database dump inconsistencies?
Author
Previous Topic Next Topic
Dementorius
Bean-shidh
The Nameless Alliance
#1 - 2012-12-15 21:03:08 UTC
Hello everyone!

I've downloaded latest mssql dump (DATADUMP201212071204.bak) and restored it in MS SQL server.
I have tested several items and their required materials with simple query:

SELECT
item.typeName,
material.typeName,
requirement.quantity
FROM
invTypeMaterials as requirement,
invTypes as item,
invTypes as material
WHERE (item.typeID = requirement.typeID and
material.typeID = requirement.materialTypeID and
item.typeName = 'ITEM')

And I've got strange:

For Medium Cargohold Optimization I:
typeName typeName quantity
Medium Cargohold Optimization I Alloyed Tritanium Bar 20
Medium Cargohold Optimization I Tripped Power Circuit 14
Medium Cargohold Optimization I Fried Interface Circuit 24

The same values as ingame and on website - as perfect values

But for 425mm AutoCannon II:

typeName typeName quantity
425mm AutoCannon II Tritanium 4405
425mm AutoCannon II Pyerite 1986
425mm AutoCannon II Mexallon 2667
425mm AutoCannon II Nocxium 2
425mm AutoCannon II Morphite 8

They are completly different than ingame.

Also for Minmatar Shuttle there is 2500 units and on website there is 2750 listed.

How should i treat those values?

Thanks for any tips what's wrong
Acid Kanshi
AIFAM
#2 - 2012-12-15 21:30:08 UTC  |  Edited by: Acid Kanshi
There are primary and secondary materials for items. Therefor materials for items are in two tables, invtypematerials and ramtyperequirements. You will find rest of the materials from the second table.

EVE-Cost is a manufacturing tool for EVE players. http://www.eve-cost.eu
Dementorius
Bean-shidh
The Nameless Alliance
#3 - 2012-12-16 09:06:43 UTC
Hello!

I know about second table (minerals aren't there) but it's not a point where is the rest - it's about wrong numbers I see in invtypematerials.
Iume
Federal Navy Academy
Gallente Federation
#4 - 2012-12-16 09:13:25 UTC
Hi,

What I just posted here, describes your problem, too. Big smile

https://forums.eveonline.com/default.aspx?g=posts&m=2329603#post2329603

EveXup http://www.digitalcreaturesnetwork.com/EveXup/ EveAssembler http://www.digitalcreaturesnetwork.com/EveAssembler/ EveIskBox http://www.digitalcreaturesnetwork.com/EveISKBox/
Dementorius
Bean-shidh
The Nameless Alliance
#5 - 2012-12-16 10:37:53 UTC
Hello!

Thanks for pointing this out. I've did few queries and confirmed that tech 2 item contains tech 1 item materials. IMO it's stupid (because of impact for ME=-4 or any other) but fixable for me now.

Since I'm dumping this database into my own project i think i will just do caluclations while migration so it will be usuable later.

Thanks for help.
Desmont McCallock
#6 - 2012-12-16 13:40:46 UTC
@Dementorious
I feel like I can say it now. Do a search before posting. This topic has been covered soooo many times. In fact it's sooooo many that we (3rd party app veteran devs) refuse to answered it anymore.
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#7 - 2012-12-17 00:42:53 UTC