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.
 

Ice Mining Laser I - SQL / SDE issue
Author
Previous Topic Next Topic
Dangra Mu'zgob
Parasitic Trading Systems
#1 - 2016-01-01 19:55:10 UTC  |  Edited by: Dangra Mu'zgob
I suddenly noticed Ice Mining Laser I (invtypes.typeid = 37450) returns different Mineral Types when querying latest SQLite SDE (2015-12-07 13:42).

Query:

SELECT M.TYPEID SRC
,M.QUANTITY
,T.[typeName]
FROM INVTYPEMATERIALS AS M INNER JOIN INVTYPES AS T
ON M.MATERIALTYPEID = T.TYPEID
Where m.typeid = 37450

--returns all 7 minerals which does not match current EVE reprocessed minerals :Tritanium, Pyerite, Mexallon, Isogen, Nocxium

Am i missing something ?

Trading for living / living for trading.

Alt of Shangra Mu'zgob
Dangra Mu'zgob
Parasitic Trading Systems
#2 - 2016-01-03 09:45:48 UTC
I compared data contained in tables INVTYPEMATERIALS and (industryActivityProducts + industryActivityMaterials) and following list of items does not match (material quantity is different ).

When i'm using table INVTYPEMATERIALS for my reprocess formula , result is wrong for mentioned items. Any ideas? 

typeID    typeName
4386    Mobile Large Jump Disruptor I
11578    Covert Ops Cloaking Device II
12198    Mobile Small Warp Disruptor I
12199    Mobile Medium Warp Disruptor I
12200    Mobile Large Warp Disruptor I
17912    Modulated Strip Miner II
19994    Arch Angel Carbonized Lead M
20002    Arch Angel Titanium Sabot M
21334    Guristas Antimatter Charge S
21947    Structure Construction Parts
21949    Structure Hangar Array
21951    Structure Storage Bay
21953    Structure Laboratory
21955    Structure Factory
21957    Structure Repair Facility
21959    Structure Reprocessing Plant
21961    Structure Docking Bay
21963    Structure Market Network
21965    Structure Medical Center
21967    Structure Office Center
21969    Structure Mission Network
24305    Modulated Deep Core Strip Miner II
26888    Mobile Large Warp Disruptor II
26890    Mobile Medium Warp Disruptor II
26892    Mobile Small Warp Disruptor II
27542    Serpentis Large Blaster Battery
27616    Serpentis Medium Railgun Battery
27618    Shadow Medium Railgun Battery
27625    Blood Medium Beam Laser Battery
27627    Dark Blood Medium Beam Laser Battery
27631    Blood Small Beam Laser Battery
27633    Dark Blood Small Beam Laser Battery
27644    Angel Medium Artillery Battery
27646    Domination Medium Artillery Battery
27655    Domination Small AutoCannon Battery
27768    Sansha Medium Beam Laser Battery
27770    Sansha Small Beam Laser Battery
27774    True Sansha Medium Beam Laser Battery
27776    True Sansha Small Beam Laser Battery
27778    Serpentis Sensor Dampening Battery
33475    Mobile Tractor Unit
33700    'Packrat' Mobile Tractor Unit
33702    'Magpie' Mobile Tractor Unit
34266    Small Higgs Anchor I
34268    Medium Higgs Anchor I
34272    Polarized Small Focused Pulse Laser
34274    Polarized Heavy Pulse Laser
34276    Polarized Mega Pulse Laser
34278    Polarized Light Neutron Blaster
34280    Polarized Heavy Neutron Blaster
34282    Polarized Neutron Blaster Cannon
34284    Polarized 200mm AutoCannon
34286    Polarized 425mm AutoCannon
34288    Polarized 800mm Repeating Cannon
34292    Polarized Heavy Assault Missile Launcher
34294    Polarized Torpedo Launcher
34306    Large Higgs Anchor I
34308    Capital Higgs Anchor I
35779    Imp
35781    Fiend
37450    Ice Mining Laser I
37479    Micro Jump Field Generator
37543    Guidance Disruptor I
40307    Noir. Modified Entosis Link
40308    Spectre Fleet's Modified Entosis Link
40309    Affirmative. Modified Entosis Link
40310    Pandemic SPHERE Modified Entosis Link

Trading for living / living for trading.

Alt of Shangra Mu'zgob
Desmont McCallock
#3 - 2016-01-03 11:25:07 UTC
Depends on what you are looking at in EVE client.

In case of the Ice Mining Laser I if you are looking at the "Information" window in the "Industry" tab the materials shown are those needed to build that item.
"Reprocessed materials" is a misleading description as they are in fact the BoM ("Required input materials" as shown in the items Blueprint Information window).

Now if you look at the Reprocessing Plant window, you should see the actual materials and their quantities minus the penalties (diff from base yield, reduction from station owner tax, etc).
Dangra Mu'zgob
Parasitic Trading Systems
#4 - 2016-01-03 11:40:44 UTC
I'm in reprocess-related business for couple of years and i had no issues so far with my queries, that's why i'm posting my findings now (i'm not saying i'm 100% right, just i had no issues yet...)
As per my understanding table INVTYPEMATERIALS should contain reprocessed materials for each item. for the Ice Mining Laser I (and others listed above) the materials and their quantities are incorrect :

- ie for Ice Mining Laser I:
SELECT M.QUANTITY,T.typeName
FROM INVTYPEMATERIALS AS M INNER JOIN INVTYPES AS T
ON M.MATERIALTYPEID = T.TYPEID 
Where m.typeid = 37450


result is:

quantity    typeName
30710    Tritanium
17250    Pyerite
4921    Mexallon
1527    Isogen
597    Nocxium
300    Zydrine
512    Megacyte


however Zydrine and Megacite should not be there and quantity is also wrong.

Trading for living / living for trading.

Alt of Shangra Mu'zgob
Desmont McCallock
#5 - 2016-01-03 13:20:26 UTC
This time I actually opened the client and you seem to be correct in your report.
Looks like someone in CCP forgot to update the invTypeMaterials table in the SDE.
File a bug report.
Dangra Mu'zgob
Parasitic Trading Systems
#6 - 2016-01-03 14:34:57 UTC
Bug report submitted, thanks.

Trading for living / living for trading.

Alt of Shangra Mu'zgob