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.
 

Getting item slot from DB Dump
Author
Previous Topic Next Topic
Crystal Wolf
Invision Hosting
#1 - 2011-11-02 16:38:18 UTC
Hey guys

I am working on a small project and i know how to find most item information in the DB Dump but where can i find what slot an item occupies eg. High or low slot

Thanks in Advance

Crystal

.
Nathan WAKE
Deep Core Mining Inc.
Caldari State
#2 - 2011-11-02 16:54:08 UTC  |  Edited by: Nathan WAKE
This info is in the dgmeffects table.

effect ID :


  • 11 -> low slot
  • 12 ->high slot
  • 13 -> medium slot
  • 2663 -> rig slot
  • 3772 -> subsystem slot


Modules in general are categoryID 7 and sybsystems are categoryID 32

Could do something like :

Quote:
SELECT
invtypes.typeName AS 'Module name',
dgmeffects.effectName AS `Slot required`
FROM
invtypes
LEFT JOIN invgroups ON invtypes.groupID = invgroups.groupID
LEFT JOIN dgmtypeeffects ON dgmtypeeffects.typeID = invtypes.typeID
LEFT JOIN dgmeffects ON dgmtypeeffects.effectID = dgmeffects.effectID
WHERE
invgroups.categoryID IN (7,32) AND
invtypes.published = 1 AND
dgmtypeeffects.effectID IN (11,12,13,2663,3772)


If I forgot something, I'm sure other readers of this forum will correct me Big smile

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

Zaza Gabor
Crystal Wolf
Invision Hosting
#3 - 2011-11-03 01:28:30 UTC
Thank you very much Nathan it works perfectly.

Cheers

Crystal

.