| Pages: [1] :: one page |
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Beseiged
Minmatar
Rim Collection RC
Kraftwerk.
   |
Posted - 2008.09.16 02:42:00 -
[1]
Can anyone provide me with some information on which tables and how, you look up skill requirements of an item, more specifically ships through the database?
Your signature exceeds the maximum allowed dimensions of 400x120 pixels and filesize of 24000 bytes -Rauth Kivaro ([email protected])
|
Immersive
Immersive Technology Solutions
|
Posted - 2008.09.16 15:07:00 -
[2]
Names of Items are in table: invTypes
Names of Attributes are in table: dgmAttributeTypes
Values of Attributes are in table: dgmTypeAttributes
Have fun with the SQL 
---
New to the API? GrabRaw XML
It's coming...
|
Beseiged
Minmatar
Rim Collection RC
Kraftwerk.
|
Posted - 2008.09.16 15:12:00 -
[3]
 Originally by: Immersive
Names of Items are in table: invTypes
Names of Attributes are in table: dgmAttributeTypes
Values of Attributes are in table: dgmTypeAttributes
Have fun with the SQL
I suppose that is a start.
Your signature exceeds the maximum allowed dimensions of 400x120 pixels and filesize of 24000 bytes -Rauth Kivaro ([email protected])
|
Chibisuke
Gallente
Children of Avalon
|
Posted - 2008.09.16 16:05:00 -
[4]
Edited by: Chibisuke on 16/09/2008 16:08:13
SELECT at.attributeName,
IF(a.valueInt > 5,ta.typeName,NULL) as skillName,
IF(a.valueInt < 6, a.valueInt, NULL) as skillLevel
FROM EVE_invTypes t
INNER JOIN dgmTypeAttributes a
ON a.typeID = t.typeID
INNER JOIN dgmAttributeTypes at
ON at.attributeID = a.attributeID
LEFT OUTER JOIN invTypes ta
ON ta.typeID = a.valueInt
WHERE at.attributeName LIKE 'requiredSkill%'
AND t.typeName LIKE 'Kestrel'
Results in
+---------------------+-----------------+------------+
| attributeName | skillName | skillLevel |
+---------------------+-----------------+------------+
| requiredSkill1 | Caldari Frigate | NULL |
| requiredSkill1Level | NULL | 3 |
+---------------------+-----------------+------------+
2 rows in set (0.42 sec)
One could now encaplse this into a another query to have is in the same row, but I'll surpose I'll leave that up to you. and yes, this works for modules, and skills too.
so If you want to build the skill tree, call it recursively until you get a empty result set.
Have fun
|
Beseiged
Minmatar
Rim Collection RC
Kraftwerk.
|
Posted - 2008.09.22 02:22:00 -
[5]
Ok I still find parts of how this database schema works rather confusing... so I am going to post another question and maybe I can learn a little bit more about how it works. I basically, want to look up from the database all the different ship classes that eve has. "Battleships", "Assault Frigates", "Titan", "Black Ops", etc. etc. etc. Any help would be great... again.
Your signature exceeds the maximum allowed dimensions of 400x120 pixels and filesize of 24000 bytes -Rauth Kivaro ([email protected])
|
Ix Forres
Caldari
Vanguard Frontiers
Violent-Tendencies
|
Posted - 2008.09.22 10:49:00 -
[6]
Originally by: Beseiged
Ok I still find parts of how this database schema works rather confusing... so I am going to post another question and maybe I can learn a little bit more about how it works. I basically, want to look up from the database all the different ship classes that eve has. "Battleships", "Assault Frigates", "Titan", "Black Ops", etc. etc. etc. Any help would be great... again.
Easiest way would be to grab all market groups with the parent group 'ships'.
SELECT * FROM invmarketgroups WHERE parentGroupID=4
--
Ix Forres
EVE Application Developer
ISKsense | RLS-EVE | Blog |
| |
|
| Pages: [1] :: one page |
| First page | Previous page | Next page | Last page |