More actions
added more SDE info |
added more SDE info |
||
| Line 27: | Line 27: | ||
I hope this short guide helped you somewhat get into the SDE, I might write one for the Fuzzwork conversions soon. If you have any issues, pop me a message here [[User:Asgore Astroficus|Asgore Astroficus]] ([[User talk:Asgore Astroficus|talk]]). | I hope this short guide helped you somewhat get into the SDE, I might write one for the Fuzzwork conversions soon. If you have any issues, pop me a message here [[User:Asgore Astroficus|Asgore Astroficus]] ([[User talk:Asgore Astroficus|talk]]). | ||
== | == Content of each table (version 2025-07-07) == | ||
{| class="wikitable sortable" | {| class="wikitable sortable" | ||
|- | |- | ||
! Table name !! | ! Table name !! Content | ||
|- | |- | ||
| [https://www.fuzzwork.co.uk/dump/latest/agtAgents.csv.bz2 agtAgents.csv.bz2]|| Contains information regarding agents in NPC stations such as location, corporation, type, level, and locator (boolean)<br> | | [https://www.fuzzwork.co.uk/dump/latest/agtAgents.csv.bz2 agtAgents.csv.bz2]|| Contains information regarding agents in NPC stations such as location, corporation, type, level, and locator (boolean)<br> | ||
| Line 303: | Line 303: | ||
'''quantity''' - the items' quantity. Quantity = -1 means unlimited quantity | '''quantity''' - the items' quantity. Quantity = -1 means unlimited quantity | ||
|- | |- | ||
| [https://www.fuzzwork.co.uk/dump/latest/invMarketGroups.csv.bz2 invMarketGroups.csv.bz2]|| Defines the market group hierarchy | | [https://www.fuzzwork.co.uk/dump/latest/invMarketGroups.csv.bz2 invMarketGroups.csv.bz2]|| Defines the market group hierarchy<br> | ||
'''marketGroupID''' - defined ID for this table<br> | |||
'''parentGroupID''' - the ID of the parent marketing group, if any. Corresponds to marketGroupID in invMarketGroups<br> | |||
'''marketGroupName''' - defines names of marketing groups<br> | |||
'''description''' - description of marketing groups<br> | |||
'''iconID''' - the ID of icons for marketing groups. Corresponds to iconID in eveIcons<br> | |||
'''hasTypes''' - Boolean flag to mark marketing groups that are also parent groups | |||
|- | |- | ||
| [https://www.fuzzwork.co.uk/dump/latest/invMetaGroups.csv.bz2 invMetaGroups.csv.bz2]|| | | [https://www.fuzzwork.co.uk/dump/latest/invMetaGroups.csv.bz2 invMetaGroups.csv.bz2]|| Description of meta groups<br> | ||
'''metaGroupID''' - defined ID for this table<br> | |||
'''metaGroupName''' - defines names of meta groups<br> | |||
'''description''' - description of meta groups<br> | |||
'''iconID''' - the ID of icons for meta groups. Corresponds to iconID in eveIcons | |||
|- | |- | ||
| [https://www.fuzzwork.co.uk/dump/latest/invMetaTypes.csv.bz2 invMetaTypes.csv.bz2]|| typeID | | [https://www.fuzzwork.co.uk/dump/latest/invMetaTypes.csv.bz2 invMetaTypes.csv.bz2]|| Assigns item types to meta groups<br> | ||
'''typeID''' - the ID of the item type. Corresponds to typeID in invTypes<br> | |||
'''parentTypeID''' - the ID of the item type's parent, if any (the Tech I item for a Tech II item etc.). Corresponds to typeID in invTypes<br> | |||
'''metaGroupID''' - the ID of the item type's meta group. Corresponds to metaGroupID in invMetaGroups | |||
|- | |- | ||
| [https://www.fuzzwork.co.uk/dump/latest/invNames.csv.bz2 invNames.csv.bz2]|| itemID for everything. Not that itemID is not typeID. | | [https://www.fuzzwork.co.uk/dump/latest/invNames.csv.bz2 invNames.csv.bz2]|| itemID for everything. Not that itemID is not typeID. | ||