| Pages: [1] :: one page |
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Wes Camus
The Creators
0
   |
Posted - 2012.02.12 16:59:00 -
[1] - Quote
Hello!
I have problem with getting proper material amounts for T2 items. For T1 it seems values in DB are correct but for T2 they're different than those ingame. ie. Tachyon Beam Laser II.
"Tritanium";132616
"Pyerite";34767
"Mexallon";10516
"Isogen";3179
"Nocxium";502
"Zydrine";28
"Megacyte";44
"Morphite";16
Those are amount for 10% wastage and perfect skills. While ie. ingame Isogen is 556, Tritanium is 19875...
I have no clue how to get correct amounts. Any tips?
Query I'm using for this example:
SELECT t.typeName, round((round(10 * m.quantity))/100 + m.quantity)
FROM invTypeMaterials AS m
INNER JOIN invTypes AS t
ON m.materialTypeID = t.typeID
WHERE m.typeID =3065
|
Velicitia
Open Designs
566
|
Posted - 2012.02.12 17:22:00 -
[2] - Quote
You need a (built) Tachyon Beam Laser I, plus morphite, and probably a few other T2 construction bits (some of these MAY require the minerals though ... I haven't bothered with T2 lasers yet). |
Wes Camus
The Creators
0
|
Posted - 2012.02.12 17:25:00 -
[3] - Quote
Well... BPO says you need, and beside that also T1 and other items.
PS.
Your answer just made me thinking abouts something and it seems its correct. No idea who designed that DB but amounts of materials include those materials required for T1. So for T2 in DB = T2 materials + T1 materials. LOL
Thanks anyway for clue ;) |
Lutz Major
Austriae Est Imperare Orbi Universo
290
|
Posted - 2012.02.12 18:25:00 -
[4] - Quote
Wes Camus wrote:Well... BPO says you need, and beside that also T1 and other items.
PS.
Your answer just made me thinking abouts something and it seems its correct. No idea who designed that DB but amounts of materials include those materials required for T1. So for T2 in DB = T2 materials + T1 materials. LOL
Thanks anyway for clue ;)
No, it doesn't. Or at least not in the way you thought.
Some items (including T2 ) use extra materials, which are stored in the ramTypeRequirements table (the blueprintID Istanbul the key!!!). To say it simple - WHICH IT IS NOT!!!- the extra materials are not affected by waste (in fact they are but I said simple)
To correctly calculate the materials you must use both tables...... again very simple put.
Edit: WTF Istanbul?!?!? Damn you autocorrect! I meant is the key :/ |
Wes Camus
The Creators
0
|
Posted - 2012.02.12 18:29:00 -
[5] - Quote
Yes that's corrent I know about ram table aswell, but in invtypematerials quantity shows for me T1 + T2 mineral amounts. So to get just minerals needed for T2 I need to subtract from amounts for T2 blueprint amounts for T1 blueprint... strange ;) Unless it's somehow different database :P |
Steve Ronuken
Fuzzwork Enterprises
221
|
Posted - 2012.02.12 20:30:00 -
[6] - Quote
if a module is marked as recyclable in the ram table, you have to remove its materials from the invtypematerials table (to a minimum of 0)
If a material exists in the invtypematerials table, /and/ in the ram table, the extra materials are affected by your production efficiency waste (but not ME based waste).
If you want to skip the math yourself, there's a xml feed on my site, through the blueprint calculator.Though it's currently only for production efficiency 5.
http://wiki.eve-id.net/Bill_of_Materials is also useful.
FuzzWork Enterprises
http://www.fuzzwork.co.uk/
Blueprint calculator and other 'useful' utilities. |
Wes Camus
The Creators
0
|
Posted - 2012.02.12 20:37:00 -
[7] - Quote
Thanks m8 that clears things a lot :) |
| |
|
| Pages: [1] :: one page |
| First page | Previous page | Next page | Last page |