Database:Agents
From OpenSimulator
| Line 27: | Line 27: | ||
'''sessionID''' | '''sessionID''' | ||
<br> | <br> | ||
| + | For Future Use | ||
| + | <br> | ||
| + | <br> | ||
| + | '''SecureSessionID''' | ||
| + | <br> | ||
| + | For Future Use | ||
| + | <br> | ||
| + | <br> | ||
| + | '''agentIP''' | ||
| + | <br> | ||
| + | IP address of logged-in agent?<br> | ||
| + | Does not appear to be updated at this time | ||
| + | <br> | ||
| + | <br> | ||
| + | '''agentPort''' | ||
| + | Port the agent is connected on<br> | ||
| + | Does not appear to be updated at this time | ||
| + | <br> | ||
| + | <br> | ||
| + | '''agentOnLine''' | ||
| + | <br> | ||
| + | Status of agent (Online/Offline)<br> | ||
| + | <br> | ||
| + | <br> | ||
| + | '''loginTime''' | ||
| + | <br> | ||
| + | Time the agent logged in at | ||
| + | <br> | ||
| + | <br> | ||
| + | '''logoutTime''' | ||
| + | <br> | ||
| + | Time the agent logged out at | ||
| + | <br> | ||
| + | <br> | ||
| + | '''currentRegion''' | ||
| + | <br> | ||
| + | Region UUID for the region the av is presently resident in | ||
| + | <br> | ||
| + | <br> | ||
| + | '''currentHandle''' | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
currentPos | currentPos | ||
Revision as of 19:04, 21 July 2008
agents Records agent (Avatar/User) login details
The current structure of the agents table is as follows:
| Field | Type | Null | Key | Default | Extra | |
| UUID | varchar(36) | NO | PRI | NULL | ||
| sessionID | varchar(36) | NO | UNI | NULL | ||
| secureSessionID | varchar(36) | NO | UNI | NULL | ||
| agentIP | varchar(16) | NO | NULL | |||
| agentPort | int(11) | NO | NULL | |||
| agentOnline | tinyint(4) | NO | NULL | |||
| loginTime | int(11) | NO | NULL | |||
| logoutTime | int(11) | NO | NULL | |||
| currentRegion | varchar(36) | NO | NULL | |||
| currentHandle | bigint(20) unsigned | NO | NULL | |||
| currentPos | varchar(64) | NO | NULL |
UUID
The UUID uniquely identifies the avatar associated with the user's account. This master ID 'number' is used for everything the avatar interacts with - it is used to determine permissions, identify belongings, and route messages to and from system and other avatars.
sessionID
For Future Use
SecureSessionID
For Future Use
agentIP
IP address of logged-in agent?
Does not appear to be updated at this time
agentPort
Port the agent is connected on
Does not appear to be updated at this time
agentOnLine
Status of agent (Online/Offline)
loginTime
Time the agent logged in at
logoutTime
Time the agent logged out at
currentRegion
Region UUID for the region the av is presently resident in
currentHandle
currentPos
