Database:Agents - Revision history

MakoBot: Robot: Cosmetic changes

2012-03-04T02:54:59Z

Robot: Cosmetic changes

MakoBot: Removed 'Template:' prefix from template includings and/or changed external-link into internal-link

2011-06-10T14:19:20Z

Removed 'Template:' prefix from template includings and/or changed external-link into internal-link

Ideia Boa at 10:28, 21 May 2009

2009-05-21T10:28:28Z

Peetr maynard at 17:26, 16 April 2009

2009-04-16T17:26:14Z

Peetr maynard at 08:45, 12 March 2009

2009-03-12T08:45:53Z

Peetr maynard at 20:05, 22 February 2009

2009-02-22T20:05:57Z

Twitch at 23:29, 6 October 2008

2008-10-06T23:29:02Z

Twitch: Agents moved to Database:Agents: tidy up namespace per sdague

2008-10-06T23:20:47Z

Agents moved to Database:Agents: tidy up namespace per sdague

SeanDague at 22:25, 6 October 2008

2008-10-06T22:25:44Z

Twitch at 22:45, 22 July 2008

2008-07-22T22:45:43Z

@@ Line 2: / Line 2: @@
 {{Quicklinks}}
-[[Category:Database]]
+'''agents'''	''Records agent (Avatar/User) login details''&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])<br />
+<br /><br />
-'''agents'''	''Records agent (Avatar/User) login details''&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])<br>
+The current structure of the agents table is as follows:<br />
-<br><br>
+<br />
 The current structure of the agents table is as follows:<br>
 <br>
 <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>&nbsp;</td></tr>
 <tr><td>UUID</td><td>varchar(36)</td><td>NO</td><td>PRI</td><td>NULL</td><td>&nbsp;</td></tr>
@@ Line 21: / Line 19: @@
 <tr><td>currentRegion</td><td>varchar(36)</td><td>NO</td><td></td><td>NULL</td><td></td><td></td><tr>
 <tr><td>currentHandle</td><td>bigint(20) unsigned</td><td>NO</td><td></td><td>NULL</td><td></td></tr>
-<tr><td>currentPos</td><td>varchar(64)</td><td>NO</td><td></td><td>NULL</td><td></td><td></td><br>
+<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>
+<tr><td>currentLookAt</td><td>varchar(36)</td><td>NO</td><td></td><td>NULL</td><td></td><td></td><br />
 </table>
-<br>
+<br />
-<br>
+<br />
-&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])<br>
+&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])<br />
-<hr>
+----
 '''UUID'''
-<br>
+<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 />
-<br>
+<br />
 '''sessionID'''
-<br>
+<br />
 For Future Use
-<br>
+<br />
-<br>
+<br />
 '''SecureSessionID'''
-<br>
+<br />
 For Future Use
-<br>
+<br />
-<br>
+<br />
 '''agentIP'''
-<br>
+<br />
-IP address of logged-in agent?<br>
+IP address of logged-in agent?<br />
 Does not appear to be updated at this time
-<br>
+<br />
-<br>
+<br />
 '''agentPort'''
-<br>
+<br />
-Port the agent is connected on<br>
+Port the agent is connected on<br />
 Does not appear to be updated at this time
-<br>
+<br />
-<br>
+<br />
 '''agentOnLine'''
-<br>
+<br />
 Status of agent (Online/Offline)
-<br>
+<br />
-<br>
+<br />
 '''loginTime'''
-<br>
+<br />
 Time the agent last logged in
-<br>
+<br />
-<br>
+<br />
 '''logoutTime'''
-<br>
+<br />
 Time the agent last logged out
-<br>
+<br />
-<br>
+<br />
 '''currentRegion'''
-<br>
+<br />
 Region UUID for the region the av is presently resident within
-<br>
+<br />
-<br>
+<br />
 '''currentHandle'''
-<br>
+<br />
 Records the grid position of the region the av is presently resident within
-<br>
+<br />
-<br>
+<br />
 '''currentPos'''
-<br>
+<br />
 Records the av's current position with the region in which it is currently resident
-<br>
+<br />
-<br>
+<br />
 '''currentLookAt'''
-<br>
+<br />
 The direction the agent is facing given as x, y and z co-ordinates relative to "currentPos"
-<br>
+<br />
-<br>
+<br />
-<hr>
+----
-&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])<br>
+&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])<br />
 [[Category:Database]]

@@ Line 1: / Line 1: @@
 __NOTOC__
-{{Template:Quicklinks}}
+{{Quicklinks}}
 [[Category:Database]]

← Older revision		Revision as of 10:28, 21 May 2009
Line 1:		Line 1:
		+	__NOTOC__
		+	{{Template:Quicklinks}}
		+
	[[Category:Database]]		[[Category:Database]]

@@ Line 80: / Line 80: @@
 <br>
 Records the av's current position with the region in which it is currently resident
 <br>
 <br>

@@ Line 47: / Line 47: @@
 <br>
 '''agentPort'''
 Port the agent is connected on<br>
 Does not appear to be updated at this time
@@ Line 58: / Line 59: @@
 '''loginTime'''
 <br>
-Time the agent logged in at
+Time the agent last logged in
 <br>
 <br>
 '''logoutTime'''
 <br>
-Time the agent logged out at
+Time the agent last logged out
 <br>
 <br>

← Older revision		Revision as of 23:29, 6 October 2008
Line 82:		Line 82:
	<hr>		<hr>
	(back to [[Database Documentation]])<br>		(back to [[Database Documentation]])<br>
		+	[[Category:Database]]

← Older revision		Revision as of 22:25, 6 October 2008
Line 1:		Line 1:
		+	[[Category:Database]]
		+
	'''agents''' ''Records agent (Avatar/User) login details''      (back to [[Database Documentation]])<br>		'''agents''' ''Records agent (Avatar/User) login details''      (back to [[Database Documentation]])<br>
	<br><br>		<br><br>