More actions
added some SDE content |
added some SDE content |
||
| Line 32: | Line 32: | ||
! Table name !! What it contains | ! Table name !! What it contains | ||
|- | |- | ||
| [https://www.fuzzwork.co.uk/dump/latest/agtAgents.csv.bz2 agtAgents.csv.bz2]|| Contains information regarding agents such as location, corporation, type, level, and locator (boolean) | | [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> | ||
agentID - defined ID for this table | agentID - defined ID for this table<br> | ||
divisionID - | divisionID - <br> | ||
corporationID - the ID of the agent's NPC corporation. Corresponds to itemID in invNames | corporationID - the ID of the agent's NPC corporation. Corresponds to itemID in invNames<br> | ||
locationID - the ID of the agent's NPC station. Corresponds to itemID in invNames | locationID - the ID of the agent's NPC station. Corresponds to itemID in invNames<br> | ||
level - agent's level (1-5) | level - agent's level (1-5)<br> | ||
quality - not used | quality - not used<br> | ||
agentTypeID - the ID of agent's type. Corresponds to agentTypeID in agtAgentTypes | agentTypeID - the ID of agent's type. Corresponds to agentTypeID in agtAgentTypes<br> | ||
isLocator - 1 if the agent is a Locator agent, 0 otherwise | isLocator - 1 if the agent is a Locator agent, 0 otherwise | ||
|- | |- | ||
| | |[https://www.fuzzwork.co.uk/dump/latest/agtAgentsInSpace.csv.bz2 agtAgentsInSpace.csv.bz2]|| Contains information regarding agents in space<br> | ||
agentID - defined ID for this table<br> | |||
dungeonID - <br> | |||
solarSystemID - the ID of the agent's solar system. Corresponds to solarSystemID in mapSolarSystems<br> | |||
spawnPointID - <br> | |||
typeID - the ID of the agent's ship. Corresponds to typeID in invTypes | |||
|- | |- | ||
| [https://www.fuzzwork.co.uk/dump/latest/agtAgentTypes.csv.bz2 agtAgentTypes.csv.bz2]|| | | [https://www.fuzzwork.co.uk/dump/latest/agtAgentTypes.csv.bz2 agtAgentTypes.csv.bz2]|| Defines agent types<br> | ||
agentTypeID - defined ID for this table<br> | |||
agentType - defined agent type | |||
|- | |- | ||
| [https://www.fuzzwork.co.uk/dump/latest/agtResearchAgents.csv.bz2 agtResearchAgents.csv.bz2]|| | | [https://www.fuzzwork.co.uk/dump/latest/agtResearchAgents.csv.bz2 agtResearchAgents.csv.bz2]|| Defines skills for each Research Agent<br> | ||
agentID - the ID of the agent. Corresponds to itemID in invNames<br> | |||
typeID - the ID of a skill of the agent. Corresponds to typeID in invTypes | |||
|- | |- | ||
| [https://www.fuzzwork.co.uk/dump/latest/certCerts.csv.bz2 certCerts.csv.bz2]|| | | [https://www.fuzzwork.co.uk/dump/latest/certCerts.csv.bz2 certCerts.csv.bz2]|| Defines in-game certificates<br> | ||
certID - defined ID for this table<br> | |||
description - description of the certificate<br> | |||
groupID - the ID of the skill group for the certificate. Corresponds to groupID in invGroups<br> | |||
name - the name of the group the certificate applies to | |||
|- | |- | ||
| [https://www.fuzzwork.co.uk/dump/latest/certMasteries.csv.bz2 certMasteries.csv.bz2]|| | | [https://www.fuzzwork.co.uk/dump/latest/certMasteries.csv.bz2 certMasteries.csv.bz2]|| Defines the level of Mastery for flying ships<br> | ||
typeID - the ID of the ship. Corresponds to typeID in invTypes<br> | |||
masteryLevel - defines each mastery level<br> | |||
certID - the ID of each certificate required for this mastery level. Corresponds to certID in certCerts | |||
|- | |- | ||
| [https://www.fuzzwork.co.uk/dump/latest/certSkills.csv.bz2 certSkills.csv.bz2]|| | | [https://www.fuzzwork.co.uk/dump/latest/certSkills.csv.bz2 certSkills.csv.bz2]|| | ||