Manni at 14:24, 10 January 2024

2024-01-10T14:24:06Z

Manni: Created page with "NOTOC {{Quicklinks}}
'''users''' ''Stores users profile data'' (back to Database Documentation) The current structure of the..."

2024-01-10T14:20:59Z

Created page with "__NOTOC__ {{Quicklinks}} '''users''' ''Stores users profile data'' (back to Database Documentation) The current structure of the..."

New page

__NOTOC__
{{Quicklinks}}
 
'''users''' ''Stores users profile data''      (back to [[Database Documentation]])

The current structure of the users table is as follows:
{| cellpadding="5" cellspacing="0" border="1"
!align="left"| Field
!align="left"| Type
!align="left"| Null
!align="left"| Key
!align="left"| Default
!align="left"| 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]])
----
;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:
:Insert 200 to: allow user to get admin level (advanced -> request admin)
: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

;email
:The email address of the user

;scopeID
:needs to be documented
 
----
      (back to [[Database Documentation]])
 

[[Category:Database]]

@@ Line 174: / Line 174: @@
 ;godLevel
 :<i style="color:green;">Admins:</i>
-:<i style="color:blue;">Insert 200 to: allow user to get admin level (advanced -> request admin)</i>
+:<i style="color:blue;">Fügen Sie 200 ein, um dem Benutzer die Administratorberechtigung zu ermöglichen (erweitert -> Administrator anfordern)</i>
 :<i style="color:red;">New Info by courtneywise</i>

Database:Users/de - Revision history

Manni at 14:24, 10 January 2024

Manni: Created page with "__NOTOC__ {{Quicklinks}} '''users''' ''Stores users profile data'' (back to Database Documentation) The current structure of the..."

Manni: Created page with "NOTOC {{Quicklinks}}
'''users''' ''Stores users profile data'' (back to Database Documentation) The current structure of the..."