OpenSimulator - User contributions [en]

PhysicsEngines

2010-03-06T12:40:37Z

TerrorBite: Updated from 2007

__NOTOC__
{{Template:Quicklinks}}
 

There are several physics engines available for use in OpenSim. Currently, they are "basicphysics", "OpenDynamicsEngine" & "BulletX" (modified version). As of OpenSim 0.6.9, the plugin "OpenDynamicsEngine" is the default and can be seen in the <tt>OpenSim.ini</tt> file. [In Linux you must run the included shell script, <tt>opensim-ode.sh</tt> or type <tt>ulimit -s 262144</tt> before running mono OpenSim.exe. '''The ulimit -s 262144 in Linux protects you against stack collisions and corrupted memory when there are a large amount of physical objects roaming around your Simulator.''']

* When starting OpenSim in Windows, one can add <tt>-physics=basicphysics</tt> to run the (very!) basic physics engine instead of OpenDynamicsEngine (ODE), or change the corresponding parameter in <tt>OpenSim.ini.</tt>.

* When starting OpenSim in either Windows or Linux, one can add <tt>-physics=modified_BulletX</tt> to run a modified version of the BulletX Physics Engine aka ''Modified BulletX''. See the next [[PhysicsEngines#Modified BulletX|information]] about details and progress.

To conclude, basicphysics & OpenDynamicsEngine both are appropriate for Linux and in addition. Modified BulletX should be fine for Windows and Linux (not the original BulletX).

ODE has received the bulk of testing. As of 2010 it supports collisions with all prims (cubes, spheres, cylinders etc) with any combination of distortions including hollow, taper, twist, path cut etc. In combination with Meshmerizer it also supports correctly colliding with sculpted prims. As of 2007 Bullet supported box-shaped prims and appears stable; there had been little testing, and it is known to have issues with friction (you skate around on non-level surfaces).

== Compiling ODE from source (Linux) ==
If you want to compile the OpenDynamicsEngine (ODE) by yourself, get the latest OpenSim libraries source code (Ver. 0.9 as of Oct '07) from the SVN: http://opensimulator.org/svn/opensim-lib & switch to the ode(trunk\unmanaged\OpenDynamicsEngine2) directory ('''Q:''' ''Is this also available through git?'')

svn co http://opensimulator.org/svn/opensim-libs/trunk opensim-libs
cd opensim-libs/unmanaged/OpenDynamicsEngine/

Ensure that the file ../ou/bootstrap is executable and then bootstrap the build process as follows:

It might be necessary to make the bootstrap file executable(if it is not) with this optional next step:

$ cd ou
$ chmod +x bootstrap

Now get ready and run autogen

$ sh autogen.sh

and compile it as shown below. Depending on how permissions are setup, you may need to sudo for the make install step:

./configure --enable-shared --disable-demos --disable-asserts
make
make install
cp /usr/local/lib/libode.so /my/opensim/production/dir

If you run into issues after doing this try the debug library by using the following line;

./configure --enable-shared --disable-demos

(I used to suggest --with-trimesh=gimpact, but no longer. As of ODE 0.9, Opcode is the preferred and best-supported collision library)

This should create a <tt>libode.a</tt> and <tt>lidode.so</tt> file in the <tt>src/ode</tt> subdirectory. Copy these two files to the opensim <tt>bin</tt> directory (after having backed up the original files there). [er, I don't think the .a file is necessary to put in bin!]

Try to play a bit with the avatar-settings in OpenSim.ini, if the avatar has it's feet stick in the terrain or if the basic-position is crouching.
These settings seem to work on Linux64: (Note that these are old settings and may not work with the latest OpenSim versions)
av_capsule_radius = 0.68
av_capsule_standup_tensor_linux = 1900000
av_density = 90

== Compiling ODE from source (Mac OS X) ==

You can use essentially the same build process on OS X as on Linux,
but there are a couple of minor differences.

First, the <tt>autogen.sh</tt> script tries to automatically determine
the name of the libtoolize binary (which is named glibtoolize on OS
X). To do this, it uses the <tt>which</tt> command under bash, but
the error code returned by <tt>which</tt> is always 0 in bash. If you
see an error message like this:

autogen.sh: line 44: no: command not found

then open autogen.sh in a text editor and change the first
<pre>LIBTOOLIZE=`which libtoolize`</pre> to <pre>LIBTOOLIZE=`which glibtoolize`</pre>
and re-run it.

Also, you must have automake 1.10 or later. You can check your
current version with:

automake --version

You can get version 1.10 from [http://www.macports.org/ MacPorts] or
[http://www.finkproject.org/ fink] if yours is older. Be sure to
place the new binary directories ahead of your system binary
directories in your PATH. You may have to open a new shell for your
changes to take effect.

Then you can follow the Linux instructions to build the library. When it has built, copy the <tt>ode/src/.libs/libode.dylib</tt> file to the OpenSim <tt>bin</tt> directory.

== Compiling ODE from source (Windows) ==

The standard distribution has a build directory, in which you will find subdirs for several Microsoft compilers.

The standard .sln files (at least for VS2005) compile ode.dll such that it depends on at least two Microsoft runtime dll's. This can cause failure and confusion, so do the following:
Right-click on ode in Solution Explorer, and select properties.
under Configuration Properties/General, change "Use of MFC" to read "Use MFC in a Static Library"

Under Configuration Properties/Linker/System. Change Stack Reserve Size to 262144000. Click the OK button then compile as usual.

== ODE Plugin in OpenSim ==
Currently, the ODE Plugin suports collisions Av2Av, Av2Prim and Prim2Prim. Avies and (active)physical prim movement supported.

The currently collision behavior is:
* For avies, a capsule of .2m of radius and a length based on the avatar height and 80Kg of mass
* For prims, like a Box or Sphere with a mass of a Box of = 0.5Kg/l = 0.5Kg/dm3 = 500Kg/m3.

* Prim are separated into ~30m space islands with their own bounding box to speed 'near' calculation.

* friction is reduced on avatar to object/ground collisions when the avatar is moving

=== To-do list (next changes) ===
* Tune all collisions
* DONE: Introduce Prim Shape Type to have more than the box shape using the Meshmerizer tri-mesh generator
* Fix bugs
* Physical(active) Linksets
* Vehicles (almost done, waiting on implementation of LSL functions)

==== Known bugs ====
* Linkset + Physical/Active are not working: ''Making a linkset physical, leaves the geometries of it's child prim where they are.. even if the root prim moves.'' Probably fixed by now.
* Certain distributions of Debian utilize 100% of the CPU while running the ODEPlugin.
* ODE Asserts

==== Recent changes ====
* Implemented Grab and Throw
* Implemented llApplyImpulse in the global frame
* Replaced the 'Avatar Wobble' with an 'Angular Motor' to keep the avatar capsule from toppling. Results in less bouncing and improved stability.
* Linksets are now collidable as long as they are not set Physical(active)

== BulletX Plugin in OpenSim: Modified BulletX ==
BulletX Plugin in OpenSim runs the modified version of BulletX. The original version of BulletX runs under and has code-dependencies with MS.XNA. The orginal BulletX can be found at [http://www.codeplex.com/xnadevru XNADev.ru]. The modified version removes all code dependencies with MS.XNA. On the other hand, it needs another library to work. This library is based on Mono.Xna and it's called MonoCompactMaths. The modified BulletX and the MonoXnaCompactMaths can be found on the svn of OpenSim. Because its code independency of MS.XNA, the modified BulletX should can be run under either MS.Net or Mono and, therefore, either Windows or Linux (obviously you can combine Windows + Mono)

Currently, BulletX Plugin suports collisions Av2Av, Av2Prim and Prim2Prim. Prims and avies movement supported. By the way, collisions needs tunning. The currently collision's behavoir are:
* For avies, like and sphere of 1m of radious and 50Kg of mass
* For prims, like a Box of the prim-size and a mass that it depends of its sizes. The mass it's the mass of Box of water with density = 1Kg/l = 1Kg/dm3 = 1000Kg/m3 (Be water my friend! :D).

=== To-do list (next changes) ===
* Tune collision
* Introduce Prim Shape Type to have more than the box shape.
* More than 1 region in a Sim and then more than 1 sim (grid)
* Fix bugs
==== Known bugs ====
* Icy bug: ''an avatar acts like it is on ice and tends to drift off the edge of the sim after a while''
* Crash on BulletX. You will find the next message in console sometimes: ''Overflow in AABB, object removed from simulation If you can reproduce this, please email bugs@continuousphysics.com Please include above information, your Platform, version of OS. Thanks.''
* <del>Rotation doesn't seem to work</del> 

== POS Plugin in OpenSim ==
POS is Physics Of Simplicity. It is BasicPhysics with collisions.

I took out my old wiki stuff because it was just plain wrong. The algorithm which is implemented in POS does not model the avatar as a sphere; rather, it models it as a rectilinear solid, same as the prims. However, collision detection is always done in the rotational frame of the prim, so depending on which prim you check against, the avatar is actually oriented differently.

=== To-do list (next changes) ===
* TODO

==== Known bugs ====
* TODO

== Physics Testing Videos ==

===ODE===
* ODE 25 Physical Spheres on Windows Server 2008 Dual Pentium 3 1000mhz with 1 gb of ram. [01/24/2008 rev.3170]
QuickTime > http://www.nebadonizumi.com/vid/opensim/windows2008_ODE_2.mov
YouTube > http://www.youtube.com/watch?v=DGyhne2llRI
* 360 Physical Prims (Sim Crashes) [11/08/2007 rev.2308] 
QuickTime > http://www.nebadonizumi.com/vid/opensim/opensim_ODE_physics_test_01.mov
Stage6 > http://stage6.divx.com/user/3dlibre/video/1847652/
YouTube > http://www.youtube.com/watch?v=Y0olsWlTc0A
* 180 Physical Prims (Sim Does Not Crash) [11/08/2007 rev.2308] 
QuickTime > http://www.nebadonizumi.com/vid/opensim/opensim_ODE_physics_test_02.mov
Stage6 > http://stage6.divx.com/user/3dlibre/video/1847715/
YouTube > http://www.youtube.com/watch?v=9lR_2H7VODU
* 90 Physical Prims (Sim Does Not Crash) [11/08/2007 rev.2308] 
Quicktime > http://www.nebadonizumi.com/vid/opensim/opensim_ODE_physics_test_03.mov
Stage6 > http://stage6.divx.com/user/3dlibre/video/1847731/
YouTube > http://www.youtube.com/watch?v=t9ulYO8I26Q

===BulletX===
* 360 Physical Prims (Sim Crashes) [11/08/2007 rev.2308] 
QuickTime > http://www.nebadonizumi.com/vid/opensim/opensim_BulletX_physics_test_01.mov
Stage6 > http://stage6.divx.com/user/3dlibre/video/1847745/
* 180 Physical Prims (Sim Crashes) [11/08/2007 rev.2308] 
QuickTime > http://www.nebadonizumi.com/vid/opensim/opensim_BulletX_physics_test_02.mov
* 90 Physical Prims (Sim Crashes) [11/08/2007 rev.2308] 
QuickTime > http://www.nebadonizumi.com/vid/opensim/opensim_BulletX_physics_test_03.mov

===Second Life Havok 1===
* 360 Physical Prims [11/08/2007] 
http://www.nebadonizumi.com/vid/opensim/SecondLife_physics_test_01.mov

===Second Life Havok 4===
* 360 Physical Prims [11/08/2007] 
http://www.nebadonizumi.com/vid/opensim/SecondLifeBetaHavok_physics_test_01.mov
* 1000 Physical Prims [11/09/2007] 
http://www.nebadonizumi.com/vid/opensim/SecondLifeBetaHavok_physics_test_02.mov
* 1000 Physical Prims [11/09/2007] 
http://www.nebadonizumi.com/vid/opensim/SecondLifeBetaHavok_physics_test_03.mov
[[Category:Development]]

LSL Status

2010-01-27T15:32:40Z

TerrorBite: /* Latest LSL News */ New subsection

__NOTOC__
{{Template:Quicklinks}}

[[Technical Reference | Technical Reference]] -> [[Technical Reference/terms | Terms]] -> [[Status | Status Page]] -> [[LSL Status | LSL Main Status Page]]

{{content}}

=What is the current LSL Status?=

==Introduction==

This page is for those who want to flesh out the LSL ScriptEngine. The file you modify is [http://opensimulator.org/viewgit/?a=viewblob&p=opensim&h=c9998c0d8675a59fe06c98a2f1c93b3d309c7662&hb=910d2177ad1e90d8b5748fbc8ffe9dbfe0c0fc9b&f=OpenSim/Region/ScriptEngine/Shared/Api/Implementation/LSL_Api.cs OpenSim/Region/ScriptEngine/Shared/Api/Implementation/LSL_Api.cs] (link current as of 27 Jan 2010).

'''This page is always under construction and perpetually being updated, don't consider the info here to be 100% updated or correct.'''
''If you find a feature that works that is not listed as "working" here,''
''Please fully test it out and update it here or make a note that it is working and ready to be tested, if you can't test it.''

== LSL Status | Quick Progress Guide ==

'''Script tests'''
{| style="border: 1px solid black" cellspacing=1 width=50% height=15x align=left
|align=center width=48.0% style=background:#00E000|
|align=center width=52.0% style=background:#E00000|

|}

'''Types'''
{| style="border: 1px solid black" cellspacing=1 width=50% height=15x align=left
|align=center width=60% style=background:#00E000|
|align=center width=40.0% style=background:#E00000|

|}

'''Events'''
{| style="border: 1px solid black" cellspacing=1 width=50% height=15x align=left
|align=center width=92.0% style=background:#00E000|
|align=center width=6.0% style=background:#E00000|
|}

'''Functions'''
{| style="border: 1px solid black" cellspacing=1 width=50% height=15x align=left
|align=center width=85.0% style=background:#00E000|
|align=center width=15.0% style=background:#E00000|
|}

== Latest LSL News ==

* OpenSim's own scripting team is accepting ideas/requests/wishlists for [[OSSL_Proposals|custom functions]].
* Some notes on converting [[LSL:PrimitiveParams]] to OpenSim PrimitiveBaseShape
* Currently (''as of when? Please clarify'') LSL is in a state of uncertainty based off the recent LibSL fiasco.
* Once that is smoothed out, all LSL that previously tested fine, will be retested.
* Because of the aforementioned issues, these numbers here likely are incorrect and need to be updated.

=== Related Links ===
* Current [[Status|OpenSim Status]]
* Latest [[News|OpenSim News & Feature Requests]]
* [[LSL_Status|LSL Status]]
* [[LSL_Status/Types|LSL-Types Status]]
* [[LSL_Status/Events|LSL-Events Status]]
* [[LSL_Status/Functions|LSL-Functions Status]]
* [[OSSL_Status|OSSL Status]]
* [[OSSL_Status/Types|OSSL-Types Status]]
* [[OSSL_Status/Events|OSSL-Events Status]]
* [[OSSL_Status/Functions|OSSL-Functions Status]]

==Kan-Ed Tests==
[[LSL_Status/Kan-ed|OpenSim Kan-Ed Tests]]

[http://www.kan-ed.org/second-life/using-LSL.html Kan-Ed Test reference] (Link actually not working please update..)

[http://web.archive.org/web/20080212083741/http://www.kan-ed.org/second-life/using-LSL.html Old version through Archive.org]

Note: Link dead and no existence of these scripts on the Kan-Ed site as of 3/25/08. Please use the included examples on this wiki for reference at this point.

==Types==
[[LSL_Status/Types|OpenSim LSL-Types Status]] 
[http://www.lslwiki.net/lslwiki/wakka.php?wakka=types LSL-reference]

==Events==
[[LSL_Status/Events|OpenSim LSL-Events Status]] 
[http://www.lslwiki.net/lslwiki/wakka.php?wakka=events LSL-reference]

==Functions==
[[LSL_Status/Functions|OpenSim LSL-Functions Status]] 
[http://www.lslwiki.net/lslwiki/wakka.php?wakka=functions LSL-reference]

==Known Issues==

The list memory hack shown below is not supported. See [[http://opensimulator.org/mantis/view.php?id=3187 Mantis 3187]].
<pre>
list foo = [ "foo" ];
foo = (foo=[]) + foo + [ "bar" ];
</pre>

See [http://opensimulator.org/mantis/ Bug Tracker] for known issues and Bug status updates.

= See Also =

* [[Status|Main Status Page]]
* [[LSL Status|LSL Status Page]]
* [[LSL Status/Types|LSL Types Status Page]]
* [[LSL Status/Events|LSL Events Status Page]]
* [[LSL Status/Functions|LSL Functions Status Page]]
* [[LSL_Status/functions/summary | LSL Functions Status Summary]]
* [[OSSL Status|OSSL Status Page]]
* [[OSSL Status/Types|OSSL Types Status Page]]
* [[OSSL Status/Events|OSSL Events Status Page]]
* [[OSSL Status/Functions|OSSL Functions Status Page]]
* [[OSSL_Status/Functions/Summary | OSSL Functions Status Summary]]
* [[OSSL_Implemented | OSSL Implemented Functions]]
* [[Technical_Reference|Technical Reference Page]]

[[Category:Users]]
[[Category:Support]]
[[Category:Tech Reference]]
[[Category:Help]]
[[Category:Configuration]]
[[Category:Getting_Started]]
[[Category:Development]]
[[Category:Todo]]

Talk:LSL Status

2010-01-27T15:24:17Z

TerrorBite: Link 404 fixed by my edit

the custom ossl proposal link has been changed because of naming issues(lsl!=ossl), and because the table is better aligned in the updated page. I had some rather unpleasant comments from someone, who thought i just deleted this page. It's not deleted. It's just renamed to [[OSSL_proposals]]. I think it better reflects the content of the page. If this is a problem, please let me know, so ill drop it. - Phrearch

________

[http://opensimulator.org/svn/opensim/trunk/OpenSim/Grid/ScriptEngine/DotNetEngine/Compiler/Server_API/LSL_BuiltIn_Commands.cs This link] throws a 404. - Kahiro

:Fixed by my edit. OpenSim now uses git instead of svn, so replaced the link with a link to the relevant file on viewgit. The file itself has also changed, as ScriptEngine.DotNetEngine has been superseded by XEngine. The page has been updated to reflect these changes. --[[User:TerrorBite|TerrorBite]] 15:24, 27 January 2010 (UTC)
_______

LSL Status

2010-01-27T15:17:38Z

TerrorBite: /* Introduction */ Changed to current file that includes ll* function definitions

__NOTOC__
{{Template:Quicklinks}}

[[Technical Reference | Technical Reference]] -> [[Technical Reference/terms | Terms]] -> [[Status | Status Page]] -> [[LSL Status | LSL Main Status Page]]

{{content}}

=What is the current LSL Status?=

==Introduction==

This page is for those who want to flesh out the LSL ScriptEngine. The file you modify is [http://opensimulator.org/viewgit/?a=viewblob&p=opensim&h=c9998c0d8675a59fe06c98a2f1c93b3d309c7662&hb=910d2177ad1e90d8b5748fbc8ffe9dbfe0c0fc9b&f=OpenSim/Region/ScriptEngine/Shared/Api/Implementation/LSL_Api.cs OpenSim/Region/ScriptEngine/Shared/Api/Implementation/LSL_Api.cs] (link current as of 27 Jan 2010).

'''This page is always under construction and perpetually being updated, don't consider the info here to be 100% updated or correct.'''
''If you find a feature that works that is not listed as "working" here,''
''Please fully test it out and update it here or make a note that it is working and ready to be tested, if you can't test it.''

== LSL Status | Quick Progress Guide ==

'''Script tests'''
{| style="border: 1px solid black" cellspacing=1 width=50% height=15x align=left
|align=center width=48.0% style=background:#00E000|
|align=center width=52.0% style=background:#E00000|

|}

'''Types'''
{| style="border: 1px solid black" cellspacing=1 width=50% height=15x align=left
|align=center width=60% style=background:#00E000|
|align=center width=40.0% style=background:#E00000|

|}

'''Events'''
{| style="border: 1px solid black" cellspacing=1 width=50% height=15x align=left
|align=center width=92.0% style=background:#00E000|
|align=center width=6.0% style=background:#E00000|
|}

'''Functions'''
{| style="border: 1px solid black" cellspacing=1 width=50% height=15x align=left
|align=center width=85.0% style=background:#00E000|
|align=center width=15.0% style=background:#E00000|
|}

== Latest LSL News ==

* OpenSim's own scripting team is accepting ideas/requests/wishlists for [[OSSL_Proposals|custom functions]].
* Some notes on converting [[LSL:PrimitiveParams]] to OpenSim PrimitiveBaseShape
* Currently LSL is in a state of uncertainty based off the recent LibSL fiasco.
* Once that is smoothed out, all LSL that previously tested fine, will be retested.
* Because of the aforementioned issues, these numbers here likely are incorrect and need to be updated.
* Current [[Status|OpenSim Status]]
* Latest [[News|OpenSim News & Feature Requests]]
* [[LSL_Status|LSL Status]]
* [[LSL_Status/Types|LSL-Types Status]]
* [[LSL_Status/Events|LSL-Events Status]]
* [[LSL_Status/Functions|LSL-Functions Status]]
* [[OSSL_Status|OSSL Status]]
* [[OSSL_Status/Types|OSSL-Types Status]]
* [[OSSL_Status/Events|OSSL-Events Status]]
* [[OSSL_Status/Functions|OSSL-Functions Status]]

==Kan-Ed Tests==
[[LSL_Status/Kan-ed|OpenSim Kan-Ed Tests]]

[http://www.kan-ed.org/second-life/using-LSL.html Kan-Ed Test reference] (Link actually not working please update..)

[http://web.archive.org/web/20080212083741/http://www.kan-ed.org/second-life/using-LSL.html Old version through Archive.org]

Note: Link dead and no existence of these scripts on the Kan-Ed site as of 3/25/08. Please use the included examples on this wiki for reference at this point.

==Types==
[[LSL_Status/Types|OpenSim LSL-Types Status]] 
[http://www.lslwiki.net/lslwiki/wakka.php?wakka=types LSL-reference]

==Events==
[[LSL_Status/Events|OpenSim LSL-Events Status]] 
[http://www.lslwiki.net/lslwiki/wakka.php?wakka=events LSL-reference]

==Functions==
[[LSL_Status/Functions|OpenSim LSL-Functions Status]] 
[http://www.lslwiki.net/lslwiki/wakka.php?wakka=functions LSL-reference]

==Known Issues==

The list memory hack shown below is not supported. See [[http://opensimulator.org/mantis/view.php?id=3187 Mantis 3187]].
<pre>
list foo = [ "foo" ];
foo = (foo=[]) + foo + [ "bar" ];
</pre>

See [http://opensimulator.org/mantis/ Bug Tracker] for known issues and Bug status updates.

= See Also =

* [[Status|Main Status Page]]
* [[LSL Status|LSL Status Page]]
* [[LSL Status/Types|LSL Types Status Page]]
* [[LSL Status/Events|LSL Events Status Page]]
* [[LSL Status/Functions|LSL Functions Status Page]]
* [[LSL_Status/functions/summary | LSL Functions Status Summary]]
* [[OSSL Status|OSSL Status Page]]
* [[OSSL Status/Types|OSSL Types Status Page]]
* [[OSSL Status/Events|OSSL Events Status Page]]
* [[OSSL Status/Functions|OSSL Functions Status Page]]
* [[OSSL_Status/Functions/Summary | OSSL Functions Status Summary]]
* [[OSSL_Implemented | OSSL Implemented Functions]]
* [[Technical_Reference|Technical Reference Page]]

[[Category:Users]]
[[Category:Support]]
[[Category:Tech Reference]]
[[Category:Help]]
[[Category:Configuration]]
[[Category:Getting_Started]]
[[Category:Development]]
[[Category:Todo]]

Database:Users

2010-01-18T11:58:07Z

TerrorBite: Added information regarding the way password hashes are calculated

__NOTOC__
{{Template: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]])
<hr>
;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
:needs to be documented

;profileWantDoMask
:needs to be documented

;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
: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 (matpratta@gmail.com)[http://opensimulator.org/wiki/How-to]

;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
 
<hr>
      (back to [[Database Documentation]])
 
[[Category:Database]]