| Pages: [1] :: one page |
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Dementorius
Federal Defense Union
Gallente Federation
0
   |
Posted - 2012.12.15 21:03:00 -
[1] - Quote
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
Deep Core Mining Inc.
Caldari State
17
|
Posted - 2012.12.15 21:30:00 -
[2] - Quote
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
Federal Defense Union
Gallente Federation
0
|
Posted - 2012.12.16 09:06:00 -
[3] - Quote
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
1
|
Posted - 2012.12.16 09:13:00 -
[4] - Quote
Hi,
What I just posted here, describes your problem, too. 
https://forums.eveonline.com/default.aspx?g=posts&m=2329603#post2329603
EveXup http://www.digitalcreaturesnetwork.com/EveXup/GettingStarted
EveAssembler http://www.digitalcreaturesnetwork.com/EveAssembler/GettingStarted
EveIskBox http://www.digitalcreaturesnetwork.com/EveISKBox/GettingStarted |
Dementorius
Federal Defense Union
Gallente Federation
0
|
Posted - 2012.12.16 10:37:00 -
[5] - Quote
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
230
|
Posted - 2012.12.16 13:40:00 -
[6] - Quote
@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
852
|
Posted - 2012.12.17 00:42:00 -
[7] - Quote
I'm not quite so veteran  But to save myself time, I wrote the following:
http://www.fuzzwork.co.uk/blog/2012/10/24/eve-sde-sql-blueprint-details/
http://www.fuzzwork.co.uk/blog/2012/10/27/eve-sde-sql-blueprint-details-part-2/
FuzzWork Enterprises
http://www.fuzzwork.co.uk/
Blueprint calculator, invention chance calculator, isk/m3 Ore chart-á and other 'useful' utilities.As well as mysql and CSV/XLS conversions of the Static Data Extract. |
| |
|
| Pages: [1] :: one page |
| First page | Previous page | Next page | Last page |