|
Author |
Thread Statistics | Show CCP posts - 3 post(s) |

Vessper
The Graduates Brutally Clever Empire
|
Posted - 2007.12.04 17:30:00 -
[1]
Excellent - thank your sir  --------------
EveHQ Character App | Item Database |

Vessper
The Graduates Brutally Clever Empire
|
Posted - 2007.12.19 08:53:00 -
[2]
Originally by: Cata Clysms I have a little Problem to find some Attributes for my Shiplist from the Database.
I cant find:
- Structure of a Ship - Turret Hardpoints - Launcher Hardpoints
All other Attributes are defined in invtypes or dgmtypeattributes table. Someone knows the location of that data? 
You must have missed them - they are all in the dgmTypeAttributes table:
Structure: attributeID = 9 (hp) Launchers: attributeID = 101 (Launcher hardpoints) Turrets: attributeID = 102 (Turret hardpoints)
--------------
EveHQ Character App | Item Database |

Vessper
The Graduates Brutally Clever Empire
|
Posted - 2007.12.21 12:39:00 -
[3]
Edited by: Vessper on 21/12/2007 12:45:03
Originally by: Nuran DeSiad Hi,
I'm trying to create a list of implants. So far I am able to extract a list which covers the name, the description and the value and type of modifier. Now I want to add the slot in which the implant is placed to the list. But I am not able to find this. Can anyone help me out on this ?
If you're looking at the dgmTypeAttributes table, check out attributeID=331 - I believe that is the implant slot number.
BTW, if anyone else needs to find a particular attribute for an item, check out my online database. It contains attributes (which the ID number) and materials for all ingame items built from the CCP data export 
--------------
EveHQ Character App | Item Database |

Vessper
Indicium Technologies
|
Posted - 2008.02.13 09:28:00 -
[4]
Check the dgmTypeAttributes table. You'll find details of slots where attributeID=:
12 (low slot) 13 (mid slot) 14 (high slot) 1137 (rig slot) 101 (launcher slot) 102 (turret slot)
- - - - - -
EveHQ Character App | Item DB |

Vessper
The Machmen
|
Posted - 2008.05.08 08:37:00 -
[5]
Originally by: Dewar Scrabulous I'm working with the Access database provided in this thread trying to find an accurate count of how much minerals I can get for recycling something, as the Item Database here on eve-online.com appears to be out of date. I've found the item typeID from the invtypes table, but I'm not sure where I have to take that value to find how much of each type of mineral it provides when recycled. I'm sure I'm just missing something obvious, it's been a while since I worked with databases. Can anyone help me out?
Check out the TL2Materials table. It should provide details of all materials used to build (activity=1) as well as what you get from recycling (activity=6).
- - - - - -
EveHQ Char App | Item DB |
|
|
|