28 lines
1.5 KiB
Markdown
28 lines
1.5 KiB
Markdown
## Summary of Findings:
|
|
|
|
### 1. **Identifying Modules:**
|
|
- Modules are items with `categoryID = 7` ("Module") or `categoryID = 66` ("Structure Module")
|
|
- Query: `SELECT typeID FROM invTypes WHERE groupID IN (SELECT groupID FROM invGroups WHERE categoryID = 7)`
|
|
|
|
### 2. **Which Slot Modules Can Fit Into:**
|
|
- Modules have effects in `dgmTypeEffects` that indicate slot requirements:
|
|
- **effectID 11** = `loPower` - "Requires a low power slot"
|
|
- **effectID 12** = `hiPower` - "Requires a high power slot"
|
|
- **effectID 13** = `medPower` - "Requires a medium power slot"
|
|
- **effectID 2663** = `rigSlot` - "Must be installed into an open rig slot"
|
|
- Query: `SELECT typeID FROM dgmTypeEffects WHERE effectID IN (11, 12, 13, 2663)`
|
|
|
|
### 3. **Finding What Modules Are Fitted on Killmails:**
|
|
- The `flag` field in the `Item` table (zkill_items) contains the `flagID` indicating where the item is located
|
|
- **Fitted modules have flags:**
|
|
- **FlagIDs 11-18** = Low slots (LoSlot0 through LoSlot7)
|
|
- **FlagIDs 19-26** = Medium slots (MedSlot0 through MedSlot7)
|
|
- **FlagIDs 27-34** = High slots (HiSlot0 through HiSlot7)
|
|
- **Rig slots** have different flagIDs (need to check for rig-specific flags)
|
|
- If `flag` is between 11-34, the item is fitted in a slot
|
|
- If `flag` is outside this range (e.g., cargo flags), it's not fitted
|
|
|
|
### To identify fitted modules on killmails:
|
|
1. Check if `item_type_id` is a module (categoryID = 7)
|
|
2. Check if `flag` is between 11-34 (fitted in a slot)
|
|
3. The `flag` value tells you the exact slot (LoSlot0-7, MedSlot0-7, or HiSlot0-7) |