Database:Users/de
From OpenSimulator
 |
Languages: |
|
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' | ||
| varchar(250) | YES | NULL | |||
| scopeID | char(36) | NO | '00000000-0000-0000-0000-000000000000' |
(back to Database Documentation)
- UUID
- The unique id of the user
- username
- The first name of the user
- lastname
- The last name of the user
- passwordHash
- The MD5-hash from password and salt.
- Currently the hash is calculated as follows: md5(md5("password") + ":")
- passwordSalt
- The password salt. Does not appear to be used at the moment.
- homeRegion
- 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
- created
- Creation timestamp of the profile (in seconds since UNIX-epoch (Jan 1st, 1971))
- lastLogin
- Time of last login (in seconds since UNIX-epoch)
- userInventoryURI
- needs to be documented
- userAssetURI
- needs to be documented
- profileCanDoMask
- Ein Bitfeld, bei dem jedes Bit etwas anzeigt, was der Avatar tun kann (seine Fähigkeitenliste)
- Bit 0 - Texturen
- Bit 1 - Architektur
- Bit 2 - Eventplanung
- Bit 3 - Modellierung
- Bit 4 - Skripting
- Bit 5 - Benutzerdefinierte Charaktere
- HINWEIS: Diese Informationen gelten als korrekt, wurden jedoch nicht verifiziert
- profileWantDoMask
- Ein Bitfeld, bei dem jedes Bit etwas anzeigt, was der Avatar tun möchte (seine "will ich tun" Liste)
- Bit 0 - Bauen
- Bit 1 - Erforschen
- Bit 2 - Treffen
- Bit 3 - Gruppe
- Bit 4 - Kaufen
- Bit 5 - Verkaufen
- Bit 6 - Angestellt werden
- Bit 7 - Einstellen
- HINWEIS: Diese Informationen gelten als korrekt, wurden jedoch nicht verifiziert
- profileAboutText
- The text in the about field of the profile dialog
- profileFirstText
- The text in the first-life field of the profile dialog
- profileImage
- The UUID of the profile image
- profileFirstImage
- The UUID of the first-life image
- webLoginKey
- needs to be documented
- homeRegionID
- The region UUID of the home-region
- userFlags
- This field consists of two different values. Bit 0-7 are a field of bit flags that define certain characteristics of the user. Bits 8-11 are the user account level, Bits 12-15 are not used.
- Account Types:
- 0 = Normaler Benutzer (Resident)
- 1 = Probe-Mitglied
- 2 = Stammmitglied
- 3 = Mitarbeiter von Linden Labs
- Bitflags:
- 1 (0x01) Erlaube externen Diensten wie Google, das Benutzerprofil zu indizieren
- 2 (0x02) Der Inhalt des Profils ist "erwachsen" und sollte nicht auf Webseiten erscheinen, die Kinder erreichen können
- 4 (0x04) Der Avatar hat Zahlungsinformationen bereitgestellt und ist daher identifiziert
- 8 (0x08) Der Avatar hat mindestens eine erfolgreiche Zahlung mit seinen Zahlungsinformationen getätigt
- 16 (0x10) Der Avatar ist online (Dieses Flag hat keinen Effekt in der Datenbank, es wird dynamisch verwaltet)
- 32 (0x20) Der Avatar wurde mithilfe eines externen Dienstes (wie LL's Aristotle) altersverifiziert
- godLevel
- Admins:
- Fügen Sie 200 ein, um dem Benutzer die Administratorberechtigung zu ermöglichen (erweitert -> Administrator anfordern)
- New Info by courtneywise
- customType
- 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
- partner
- The UUID of a user that will appear in the partner field of the profile dialog
- The email address of the user
- scopeID
- needs to be documented
(back to Database Documentation)
