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.
 

static data and in game data doesn't match
Author
Previous Topic Next Topic
Driky
Space Drunks Driving
#1 - 2011-12-21 21:43:11 UTC
Hi capsuleers
I'm curently converting the last static data into xml (probably done already but wtf) and that's working nicely the probleme come from the data in itself.
For example with this querry

SELECT *
FROM invTypeMaterials, invTypes
WHERE invTypeMaterials.materialTypeID = invTypes.typeID
AND invTypeMaterials.typeID =179-- itemID

i find the bill of material for "nuclear S" and it give me : 34 Tritanium and 29 pyerite. But In game the (perfect ) bill of material is: 37 Tritanium 32 pyerite.
So i'm guessing there is some sort of math to do on the static data, but the question is what math ? ^^

Any help wil be much apprecited.
Lutz Major
Austriae Est Imperare Orbi Universo
#2 - 2011-12-21 21:57:55 UTC  |  Edited by: Lutz Major
I asume your 'perfect' bill was that from a BPO with ME 0?
Why that is correct then, because you have to apply 10% waste, so ROUND(34 * 1.1) = ROUND(37.4) = 37 Tritanium and ROUND(29 * 1.1) = ROUND(31.9) = 32 Pyr Big smile

Check a perfect ME 6 (34 / 5 = 6.8). That ought to give you the 34 and 29



edit: XML?!?!?!?!? Really? Why?
Driky
Space Drunks Driving
#3 - 2011-12-21 22:06:05 UTC
first BIG THANKS !

that should have been obvious to me.

And for your question:
I'm building my own little app that should help find goot item to manufacture. (someone probably already did it but DIY is the best)
And it's easyer for to access xml than sql with a c# app. I already have some snippet i used a while ago on a rift app that allow very easy parsing of xml data.

sorry if my english is weird, i'm better at reading than writting.
TorTorden
Tors shibari party
#4 - 2011-12-21 22:11:58 UTC
Yea my guess would also be that you are missing the Me waste calculations.
And the data in the sdd (for t1 modules at least) are what you get from perfect recycle.

The waste equation is with alot of others at http://wiki.eve-id.net/Equations

And this http://wiki.eve-id.net/Bill_of_Materials page details the bom very nicely
Driky
Space Drunks Driving
#5 - 2011-12-21 22:14:08 UTC
thank you for the links they will be of great help.