Database:Users - Revision history

Melanie at 01:32, 22 June 2016

2016-06-22T01:32:43Z

2015-03-01T19:23:10Z

Added information about the profileCanDo and profileWantDo bitfields

2012-03-04T02:56:20Z

Robot: Cosmetic changes

2011-08-03T17:05:11Z

Changed internal link to non-existing page "How-to" to regular text.

2011-06-10T14:20:19Z

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

2010-11-23T17:16:17Z

2010-01-18T11:58:07Z

Added information regarding the way password hashes are calculated

2009-12-04T17:08:03Z

Added details regarding the calculation of the value for homeRegion.

2009-11-24T22:36:06Z

Changed message to 'needs to be documented'

2009-11-24T22:32:53Z

Added missing default values

@@ Line 156: / Line 156: @@
 ;userFlags
 :<i style="color:green;">Account Types:</i>
-:<i style="color:blue;">Insert 200 to: Resident:Payment info on account</i>
+:0 = Normal user (Resident)
-:<i style="color:blue;">Insert 300 to: Testing:Payment info on account</i>
+:1 = Trial Member
-:<i style="color:blue;">Insert 400 to: Testing:No payment info on account</i>
+:2 = Charter Member
-:<i style="color:blue;">Insert 600 to: Member Estatute:Payment info on account</i>
+:3 = Linden Labs Employee
-:<i style="color:blue;">Insert 800 to: Linden Contracted</i>
-:<i style="color:red;">New Info by Matpratta (matpratta@gmail.com) How-to</i>
+:<i style="color:green;">Bit flags:</i>
 ;godLevel

@@ Line 116: / Line 116: @@
 ;profileCanDoMask
-:<i style="color:red;">needs to be documented</i>
+:A bitfield where each bit indicates something the avatar can do (their skills list)
 ;profileWantDoMask
-:<i style="color:red;">needs to be documented</i>
+:A bitfield where each bit indicates something the avatar is interested in doing (their "want to" list)
 ;profileAboutText

@@ Line 73: / Line 73: @@
 | scopeID|| char(36) || NO || || '00000000-0000-0000-0000-000000000000' ||
 |}
-<br>
+<br />
-<br>
+<br />
 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])
-<hr>
+----
 ;UUID
 :The unique id of the user
@@ Line 166: / Line 166: @@
 ;scopeID
 :<i style="color:red;">needs to be documented</i>
-<br>
+<br />
-<hr>
+----
 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])
-<br>
+<br />
 [[Category:Database]]

@@ Line 146: / Line 146: @@
 :<i style="color:blue;">Insert 600 to: Member Estatute:Payment info on account</i>
 :<i style="color:blue;">Insert 800 to: Linden Contracted</i>
-:<i style="color:red;">New Info by Matpratta (matpratta@gmail.com) [[How-to]]</i>
+:<i style="color:red;">New Info by Matpratta (matpratta@gmail.com) How-to</i>
 ;godLevel

@@ Line 1: / Line 1: @@
 __NOTOC__
-{{Template:Quicklinks}}
+{{Quicklinks}}
 <br />
 '''users'''	''Stores users profile data''&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])

@@ Line 87: / Line 87: @@
 ;passwordHash
-:The MD5-hash from password and salt
+:The MD5-hash from password and salt.
 ;passwordSalt
-:The password salt
+:The password salt. Does not appear to be used at the moment.
 ;homeRegion

@@ Line 92: / Line 92: @@
 ;homeRegion
-:The region-handle of the home-region
+:The region-handle of the home-region.
 ;homeLocationX, homeLocationY, homeLocationZ

@@ Line 61: / Line 61: @@
 | homeRegionID || char(36) || NO || || '00000000-0000-0000-0000-000000000000' ||
 |-
-| userFlags || int(11) || NO || || '0' ||
+| userFlags || int(11) || NO || || 0 ||
 |-
-| godLevel || int(11) || NO || || '0' ||
+| godLevel || int(11) || NO || || 0 ||
 |-
 | customType || varchar(32) || NO || || '' ||
@@ Line 69: / Line 69: @@
 | partner || char(36) || NO || || '00000000-0000-0000-0000-000000000000' ||
 |-
-| email|| varchar(250) || YES || || ''||
+| email|| varchar(250) || YES || || NULL ||
 |-
-| scopeID|| char(36) || NO || || ''||
+| scopeID|| char(36) || NO || || '00000000-0000-0000-0000-000000000000' ||
 |}
 <br>