Salizar Amolkshue
|
Posted - 2010.03.21 00:18:00 -
[1]
I run the following select script against the Eve Datadump (1.1.1.31766) which is the most recent one as far as I know.
SELECT t typeID, t typeName, MAX(CASE WHEN tm materialTypeID = 34 THEN quantity ELSE 0 END) AS Tritanium, MAX(CASE WHEN tm materialTypeID = 35 THEN quantity ELSE 0 END) AS Pyerite, MAX(CASE WHEN tm materialTypeID = 36 THEN quantity ELSE 0 END) AS Mexallon, MAX(CASE WHEN tm materialTypeID = 37 THEN quantity ELSE 0 END) AS Isogen, MAX(CASE WHEN tm materialTypeID = 38 THEN quantity ELSE 0 END) AS Nocxium, MAX(CASE WHEN tm materialTypeID = 39 THEN quantity ELSE 0 END) AS Zydrine, MAX(CASE WHEN tm materialTypeID = 40 THEN quantity ELSE 0 END) AS Megacyte, MAX(CASE WHEN tm materialTypeID = 11399 THEN quantity ELSE 0 END) AS Morphite FROM invTypeMaterials tm JOIN invTypes t ON t typeID = tm typeID WHERE t groupID = 355 GROUP BY t typeID, t typeName, ORDER BY t typeName
This provides the following list of elements, which I thought would be the perfect refine values of the drone poo items.
ID Name Trit Pyer Mex Iso Nocx Zyd Mega Morph 11739 Condensed Alloy 160 40 10 0 0 0 0 0 11741 Crystal Compound 0 0 24 6 0 0 0 0 11735 Dark Compound 0 0 0 32 8 0 0 0 11740 Gleaming Alloy 768 0 0 0 3 0 0 0 11724 Glossy Compound 0 0 384 0 24 0 1 0 11738 Lucent Compound 0 192 48 12 3 0 0 0 11736 Lustering Alloy 0 0 192 48 12 3 0 0 11733 Motley Compound 0 0 0 40 10 0 0 0 11734 Opulent Compound 0 0 0 0 0 0 0 2 11725 Plush Compound 4096 1024 0 64 0 4 0 0 11737 Precious Alloy 0 128 0 8 0 0 0 0 11732 Sheen Compound 512 128 0 8 2 0 0 0
But when I refine a single unit of each of these in-game and add up the "you get, we get, nobody gets" columns, I get these numbers instead
ID Name Trit Pyer Mex Iso Nocx Zyd Mega Morph 11739 Condensed Alloy 88 44 10 0 0 0 0 0 11741 Crystal Compound 0 0 37 2 0 0 0 0 11735 Dark Compound 0 0 0 32 10 0 0 0 11740 Gleaming Alloy 299 0 0 0 5 0 0 0 11724 Glossy Compound 0 0 210 0 4 0 3 0 11738 Lucent Compound 0 175 2 10 5 0 0 0 11736 Lustering Alloy 0 0 88 32 35 1 0 0 11733 Motley Compound 0 0 0 29 12 0 0 0 11734 Opulent Compound 0 0 0 0 0 0 0 2 11725 Plush Compound 3200 800 0 20 0 9 0 0 11737 Precious Alloy 0 7 0 17 0 0 0 0 11732 Sheen Compound 124 44 0 23 1 0 0 0
As you can see, with the exception of Opulent Compound, the numbers are very different. This dramatically changes the refine value of these alloys .
So, did I do something wrong in my select statement from the data dump? Am I missing something in the refine screen in-game? Or is the data dump that badly out of date? When did the numbers change? Is it unique to the drone poo or did the refine values for everything in-game change when I wasn't looking?
Any ideas &/or comments?
-Sal
|
Salizar Amolkshue
|
Posted - 2010.03.21 17:05:00 -
[3]
Originally by: lord cyrez Maybe you are using a station with less than 50% base yield? And/or could it be that you might lack the scrapmetal processing skill (which is required for alloys as far as I remember)?
I don't have scrapmetal processing yet, so I only get 97.5% refine. But the differences between the two sets of numbers is far more than 2.5%. (Sometimes the amount of trit is half...).
But that is interesting. On Sisi I get the same results...
At the exact same station on both Sisi and Tranquiltiy (Amarr VIII (Oris) - Emperor Family, 50% base refine, 8.01 standings), I get completely different results. Sisi matches the data dump, Tranquility matches my earlier results.
Umm, wtf?
|
Catari Taga
Centre Of Attention Rough Necks
|
Posted - 2010.03.21 20:45:00 -
[6]
Originally by: Salizar Amolkshue
Originally by: Catari Taga Known bug with the current datadump.
Ah, thanks Catari. Any idea just how widespread it is? Is it unique to the drone alloys or does it effect most items in the game? I'm assuming they play with the drone alloys composition a bit from time to time when they are balancing the economy, and things with blueprints would be harder to change.
It is unique to the drone alloys, all other items are correct.
|