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.
 

'invmetatypes' question
Author
Previous Topic Next Topic
Nathan WAKE
Deep Core Mining Inc.
Caldari State
#1 - 2011-10-23 11:43:07 UTC
Hello everybody,

I'm back with some more questions Big smile

Let's take typeID 29966 (Legion Defensive - Augmented Plating) - under this typeID in the invmetatypes table, we find metaGroupID 14 which correspond to Tech III.

If you take typeID 29964 (Legion Defensive - Adaptive Augmenter) - under this typeID in the invmetatypes table, I find nothing...

And parentTypeID for 29966 is 29964. Am I supposed to query the parentTypeID as well Question

Really, I find it hard to get a list of items with tech levels and/or metaGroupNames (Faction, Stotyline, Officer...).

It looks like the same query does not apply to all categoryID (6 Ships, 7 Modules, 8 Charges, 18 Drones and 32 Subsystems).

But then, if it was not hard, it would not be fun right ? Big smile





"I'm a very good housekeeper. Each time I get a divorce, I keep the house"

Zaza Gabor
Desmont McCallock
#2 - 2011-10-23 12:06:28 UTC  |  Edited by: Desmont McCallock
I will tell you how we do it in EVEMon, though I don't know if it will help you.

First we look into dgmTypeAttributes table for the questioned typeID.
In that table we look if typeID has attributeID '422' (which in dgmAttributeTypes refers to 'techLevel').
Notice that attributeID for 'metagroupID' is '1692'.
In case 29964 its value is '3', therefore it's Tech III. Then we manually assign the metagroup to that Tech.
Nathan WAKE
Deep Core Mining Inc.
Caldari State
#3 - 2011-10-23 14:04:30 UTC
Thank you Desmond, yes it helped a lot in understanding how the tables articulates between them. What is still unclear to me is the following :

If :

attributeID 422 refers to techlevel of an item
attributeID 633 refers to the metaLevel of an item
attributeID 1692 refers to the metagroupID of an item.

Item like typeID 24698 (Drake) have attributeID 422 = 1 (tech 1), and 633 and 1692 are empty. I UNDERSTAND
item like typeID 24692 (Abaddon) have attributeID 422 and 1692 empty and 633 = 0 . I DON'T UNDERSTAND

Why do 2 tech 1 ships have not the same attribute distribution ? Why sometime 422 and sometime 1692 ?

I suppose this query is completely out of line and that I'm not going anywhere with it :

Quote:

SELECT
invtypes.typeID,
invtypes.typeName,
dgmtypeattributes.valueInt,
dgmtypeattributes.valueFloat,
dgmtypeattributes.attributeID,
dgmattributetypes.attributeName,
invgroups.categoryID,
invmetagroups.metaGroupName
FROM
invtypes
LEFT JOIN dgmtypeattributes ON dgmtypeattributes.typeID = invtypes.typeID
LEFT JOIN dgmattributetypes ON dgmtypeattributes.attributeID = dgmattributetypes.attributeID
LEFT JOIN invgroups ON invtypes.groupID = invgroups.groupID
LEFT JOIN invmetatypes ON invtypes.typeID = invmetatypes.typeID
LEFT JOIN invmetagroups ON invmetatypes.metaGroupID = invmetagroups.metaGroupID
WHERE
invgroups.categoryID = 6 AND -- 6 for ships, change according to what I want
-- invtypes.typeID = 29964 AND
invtypes.published = 1 AND -- 1 for published true
dgmtypeattributes.attributeID in (422,633,1692) -- the 3 attributes I need
ORDER BY typename ASC



What I am trying to do is :

- get a complete list of ships/modules/charges/drones/subsystems (in seperate tables)
with for each :
- tech level and additionnal attribute like if it is standard, faction/officer, deadspace/storyline (by the way, what is teh difference between faction/officer ?).
- for the ships, I'm trying to pull out as well number of high, med, low, rig slots and subsystems when applicable.

I already have those tables, but most of the time, they are not complete - missing number of slots for some ships, just to mention this.

"I'm a very good housekeeper. Each time I get a divorce, I keep the house"

Zaza Gabor
Nathan WAKE
Deep Core Mining Inc.
Caldari State
#4 - 2011-10-23 14:19:10 UTC
To be more precise, I am not creating tables but views, as Tonto Auri mentionned in a previous post that it was dangerous Big smile

For example, the ship view should give something like
typeID
ship name
race / faction (for icon display)
low slots nbr
med slots nbr
high slots nbr
rig slots nbr
subsystems slots nbr
tech level
additionnal detail like deadspace, officer and so on

Seems I am not able to do all that in a single query.

"I'm a very good housekeeper. Each time I get a divorce, I keep the house"

Zaza Gabor
Desmont McCallock
#5 - 2011-10-23 14:23:05 UTC  |  Edited by: Desmont McCallock
TechLevel and metagroup are the same as far as it concerns me.

MetaLevel is a derived level (variation) from the original Tech (i.e. MetaLevel 5 is sometimes assigned to Tech II items).