Database:Agents
From OpenSimulator
(New page: '''agents''' ''Records agent (Avatar/User) login details'' <br> The current structure of the agents table is as follows:<br> <br> <code> <table> <tr><td>Field<br></td><td>Type</td><td>Null...) |
m (Robot: Cosmetic changes) |
||
| (16 intermediate revisions by 5 users not shown) | |||
| Line 1: | Line 1: | ||
| − | '''agents''' ''Records agent (Avatar/User) login details'' | + | __NOTOC__ |
| − | <br> | + | {{Quicklinks}} |
| − | The current structure of the agents table is as follows:<br> | + | |
| − | <br | + | '''agents''' ''Records agent (Avatar/User) login details'' (back to [[Database Documentation]])<br /> |
| − | + | <br /><br /> | |
| + | The current structure of the agents table is as follows:<br /> | ||
| + | <br /> | ||
<table> | <table> | ||
| − | <tr><td>Field<br></td><td>Type</td><td>Null</td><td>Key</td><td>Default</td><td>Extra</td></tr> | + | <tr><td>Field<br /></td><td>Type</td><td>Null</td><td>Key</td><td>Default</td><td>Extra</td></tr> |
<tr><td> </td></tr> | <tr><td> </td></tr> | ||
<tr><td>UUID</td><td>varchar(36)</td><td>NO</td><td>PRI</td><td>NULL</td><td> </td></tr> | <tr><td>UUID</td><td>varchar(36)</td><td>NO</td><td>PRI</td><td>NULL</td><td> </td></tr> | ||
| Line 16: | Line 18: | ||
<tr><td>logoutTime</td><td>int(11)</td><td>NO</td><td></td><td>NULL</td><td></td><td></td></tr> | <tr><td>logoutTime</td><td>int(11)</td><td>NO</td><td></td><td>NULL</td><td></td><td></td></tr> | ||
<tr><td>currentRegion</td><td>varchar(36)</td><td>NO</td><td></td><td>NULL</td><td></td><td></td><tr> | <tr><td>currentRegion</td><td>varchar(36)</td><td>NO</td><td></td><td>NULL</td><td></td><td></td><tr> | ||
| − | <tr><td>currentHandle | + | <tr><td>currentHandle</td><td>bigint(20) unsigned</td><td>NO</td><td></td><td>NULL</td><td></td></tr> |
| − | <tr><td>currentPos | + | <tr><td>currentPos</td><td>varchar(64)</td><td>NO</td><td></td><td>NULL</td><td></td><td></td><br /> |
| + | <tr><td>currentLookAt</td><td>varchar(36)</td><td>NO</td><td></td><td>NULL</td><td></td><td></td><br /> | ||
</table> | </table> | ||
| − | </ | + | <br /> |
| − | <br> | + | <br /> |
| + | (back to [[Database Documentation]])<br /> | ||
| + | ---- | ||
| + | '''UUID''' | ||
| + | <br /> | ||
| + | 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. | ||
| + | <br /> | ||
| + | <br /> | ||
| + | '''sessionID''' | ||
| + | <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''' | ||
| + | <br /> | ||
| + | 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 /> | ||
| + | '''loginTime''' | ||
| + | <br /> | ||
| + | Time the agent last logged in | ||
| + | <br /> | ||
| + | <br /> | ||
| + | '''logoutTime''' | ||
| + | <br /> | ||
| + | Time the agent last logged out | ||
| + | <br /> | ||
| + | <br /> | ||
| + | '''currentRegion''' | ||
| + | <br /> | ||
| + | Region UUID for the region the av is presently resident within | ||
| + | <br /> | ||
| + | <br /> | ||
| + | '''currentHandle''' | ||
| + | <br /> | ||
| + | Records the grid position of the region the av is presently resident within | ||
| + | <br /> | ||
| + | <br /> | ||
| + | '''currentPos''' | ||
| + | <br /> | ||
| + | Records the av's current position with the region in which it is currently resident | ||
| + | <br /> | ||
| + | <br /> | ||
| + | '''currentLookAt''' | ||
| + | <br /> | ||
| + | The direction the agent is facing given as x, y and z co-ordinates relative to "currentPos" | ||
| + | <br /> | ||
| + | <br /> | ||
| + | ---- | ||
| + | (back to [[Database Documentation]])<br /> | ||
| + | |||
| + | [[Category:Database]] | ||
| + | [[Category:Database]] | ||
Latest revision as of 18:54, 3 March 2012
 |
Languages: |
|
agents Records agent (Avatar/User) login details (back to Database Documentation)
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 | |||
| currentLookAt | varchar(36) | NO | NULL |
(back to Database Documentation)
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 last logged in
logoutTime
Time the agent last logged out
currentRegion
Region UUID for the region the av is presently resident within
currentHandle
Records the grid position of the region the av is presently resident within
currentPos
Records the av's current position with the region in which it is currently resident
currentLookAt
The direction the agent is facing given as x, y and z co-ordinates relative to "currentPos"
(back to Database Documentation)
