From OpenSimulator

(Difference between revisions)
Jump to: navigation, search
m (Removed 'Template:' prefix from template includings and/or changed external-link into internal-link)
m (Changed internal link to non-existing page "How-to" to regular text.)
Line 146: Line 146:
:<i style="color:blue;">Insert 600 to: Member Estatute:Payment info on account</i>
:<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:blue;">Insert 800 to: Linden Contracted</i>
:<i style="color:red;">New Info by Matpratta ( [[How-to]]</i>
:<i style="color:red;">New Info by Matpratta ( How-to</i>

Revision as of 09:05, 3 August 2011

users Stores users profile data      (back to Database Documentation)

The current structure of the users table is as follows:

Field Type Null Key Default Extra
UUID varchar(36) NO PRI
username varchar(32) NO UNI
lastname varchar(32) NO UNI
passwordHash varchar(32) NO
passwordSalt varchar(32) NO
homeRegion bigint(20) unsigned YES NULL
homeLocationX float YES NULL
homeLocationY float YES NULL
homeLocationZ float YES NULL
homeLookAtX float YES NULL
homeLookAtY float YES NULL
homeLookAtZ float YES NULL
created int(11) NO
lastLogin int(11) NO
userInventoryURI varchar(255) YES NULL
userAssetURI varchar(255) YES NULL
profileCanDoMask int(10) unsigned YES NULL
profileWantDoMask int(10) unsigned YES NULL
profileAboutText text YES NULL
profileFirstText text YES NULL
profileImage varchar(36) YES NULL
profileFirstImage varchar(36) YES NULL
webLoginKey varchar(36) YES NULL
homeRegionID char(36) NO '00000000-0000-0000-0000-000000000000'
userFlags int(11) NO 0
godLevel int(11) NO 0
customType varchar(32) NO
partner char(36) NO '00000000-0000-0000-0000-000000000000'
email varchar(250) YES NULL
scopeID char(36) NO '00000000-0000-0000-0000-000000000000'

      (back to Database Documentation)

The unique id of the user
The first name of the user
The last name of the user
The MD5-hash from password and salt.
Currently the hash is calculated as follows: md5(md5("password") + ":")
The password salt. Does not appear to be used at the moment.
The region-handle of the home-region.
The value is the regions X location in a grid times 256*65536 (shifted left by 40 bits) plus the regions Y location in a grid times 256 (shifted left by 8 bits).
homeLocationX, homeLocationY, homeLocationZ
The home-location within the home-region
homeLookAtX, homeLookAtY, homeLookAtZ
The direction the avatar looks after TP to the home-location
Creation timestamp of the profile (in seconds since UNIX-epoch (Jan 1st, 1971))
Time of last login (in seconds since UNIX-epoch)
needs to be documented
needs to be documented
needs to be documented
needs to be documented
The text in the about field of the profile dialog
The text in the first-life field of the profile dialog
The UUID of the profile image
The UUID of the first-life image
needs to be documented
The region UUID of the home-region
Account Types:
Insert 200 to: Resident:Payment info on account
Insert 300 to: Testing:Payment info on account
Insert 400 to: Testing:No payment info on account
Insert 600 to: Member Estatute:Payment info on account
Insert 800 to: Linden Contracted
New Info by Matpratta ( How-to
Insert 200 to: allow user to get admin level (advanced -> request admin)
New Info by courtneywise
Custom Account Names:
enter what ever you want and it will be show as your user type so you can have custom account types then the default set ones under userFlags
New Info by courtneywise
The UUID of a user that will appear in the partner field of the profile dialog
The email address of the user
needs to be documented

      (back to Database Documentation)

Personal tools
About This Wiki