OpenSimulator - User contributions [en]

Main Page

2009-02-27T17:10:03Z

Matpratta: /* Participating in the OpenSimulator Community */

{{Template:Quicklinks}}
__NOTOC__
=== What is OpenSimulator? ===
[[image:Opensim_Wright_Plaza.jpg|250px|thumb|right|Wright Plaza on OSGrid]]

OpenSimulator is a 3D Application Server. It can be used to create a virtual world which can be accessed through a variety of clients, on multiple protocols. OpenSimulator allows you to develop your world using the technologies you feel work best - we've designed the software to be easily extendable through [[Getting Started with Region Modules|loadable modules]] to build completely custom environments. OpenSimulator is released under a [[BSD License]], making it both open source, and commercially friendly to embed in products.

Out of the box, OpenSimulator can be used to simulate a virtual world similar to Second Life™ (including client compatibility), however can be extended with modules to support MXP or realXtend clients too. For a list of availible third party modules, check our [http://forge.opensimulator.org/gf/ forge site].

Although OpenSimulator is still considered '''alpha software''', many people are [http://technorati.com/search/opensim?authority=a4&language=en doing exciting things with it].

=== Features ===
Even though OpenSimulator is relatively young software it already has many useful features
* Supports creating multiple 'worlds' in a single application instance.
* Supports multiple clients and protocols - access the same world at the same time via multiple protocols.
* Extensive ability to customize your avatar, both with custom clothing, skins, and attached objects.
* Realtime Physics Simulation, with multiple engine options including ODE, PhysX, Bullet and more.
* The ability to create content real time in the environment using in world building tools. What you see is what you get.
* In world application development using a number of different languages, including LSL/OSSL, C#, JScript and VB.NET

=== Using OpenSimulator ===
The fastest way to get started using OpenSimulator is to create an account on [http://osgrid.org OSGrid], then download the [http://opensim-viewer.sourceforge.net/ Hippo Viewer] or [http://secondlife.com/support/downloads.php Linden Lab's Second Life viewer] (amongst others) to connect to OSGrid. This process should take no longer than 10 minutes, and will give you a flavor for what OpenSimulator is like.

You can also easily connect to any one of the many [[Grid_List|public grids]] on the internet.

Or you could run a simple standalone OpenSim on your Windows desktop to create and preview content. [http://www.youtube.com/watch?v=ZcR7Jcar_8k Here is an tutorial showing how to get opensimulator in stand-alone mode.].

=== Running your own OpenSimulator ===
If you are interested in running your own OpenSimulator server, to host your own 3D environments you'll want to check out the following links:
* [[Download|Getting OpenSimulator]]
* [[Build_Instructions|Building OpenSimulator]]
* [[Configuration|Configuring OpenSimulator]]
* [[Running|Running OpenSimulator]]
* [[FAQ|Frequently Asked Questions in Running OpenSimulator]]

=== Participating in the OpenSimulator Community ===
OpenSimulator is an [http://en.wikipedia.org/wiki/Open_source open source] project, and is powered by the community members that devote time and energy to the effort. There are many ways to participate and contribute to the community:
* Participate via [http://en.wikipedia.org/wiki/Internet_Relay_Chat IRC] - [irc://irc.freenode.net/opensim #opensim] (for users) and [irc://irc.freenode.net/opensim-dev #opensim-dev]
* [[WikiStructure|Contribute to this wiki]], making the OpenSimulator documentation even better.
* Report [[bugs]], submit [[Submitting_code_to_OpenSim|patches]] or submit content contributions via our [http://opensimulator.org/mantis/ mantis bug tracker]
* Create an OpenSimulator related project hosted on the [http://forge.opensimulator.org Forge] or [http://opensimulator.org/wiki/Related_Software elsewhere] on the web. In the forge there are over a dozen registered projects, and it's a great way to further extend the OpenSimulator community.
* Blog about OpenSimulator, and let us know about that blog on [irc://irc.freenode.net/opensim #opensim] so it can be added to [http://planet.opensim.us Planet OpenSim]
* Participate in one of the weekly [[Office Hours]] for OpenSimulator. We currently have weekly office hours for development, wiki work, and testing.
* Secure project infrastructure by [[Donations|donating]] to the [[Donations|OpenSim Project Infrastructure Fund]].

''Pages by Category:'' [[:Category:Users|User's Pages]], [[:Category:Development|Development Pages]], [[:Category:Scripts|Scripts]],[[Special:Recentchanges| Recent Wiki Changes]]<br />
''Wiki Translations:'' [[OpenSimSpanish | Spanish]], [[OpenSimGerman | German]], [[fr | Francais]], [[OpenSimItalian | Italian]], [[PT| Português]], [http://64.233.179.104/translate_c?hl=ja&langpair=en%7Cja&u=http://opensimulator.org/wiki/Main_Page Japanese]
[[Category:Main]]
[[Category:Getting Started]]
[[Category:Development]]
<cleanpage title=hide cats=hide />
-----
I need help!!!! http://opensimulator.org/wiki/Create_games_on_opensimulator - Matpratta

Database:Users

2009-01-23T17:14:02Z

Matpratta:

'''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' ||
|}

;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
;passwordSalt
:The password salt

;homeRegion
:The region-handle of the home-region

;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
:<i style="color:red;">needs to be documented</i>

;userAssetURI
:<i style="color:red;">needs to be documented</i>

;profileCanDoMask
:<i style="color:red;">needs to be documented</i>

;profileWantDoMask
:<i style="color:red;">needs to be documented</i>

;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
:<i style="color:red;">needs to be documented</i>

;homeRegionID
:The region UUID of the home-region

;userFlags
:<i style="color:green;">Account Types:</i>
:<i style="color:blue;">Insert 200 to: Resident:Payment info on account</i>
:<i style="color:blue;">Insert 300 to: Testing:Payment info on account</i>
:<i style="color:blue;">Insert 400 to: Testing:No 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:red;">New Info by Matpratta (matpratta@gmail.com)[http://opensimulator.org/wiki/How-to]</i>

;godLevel
:<i style="color:red;">needs to be documented</i>

;customType
:<i style="color:red;">needs to be documented</i>

;partner
:The UUID of a user that will appear in the partner field of the profile dialog
[[Category:Database]]

Testing

2009-01-23T16:53:28Z

Matpratta: /* Avatar */

{{content}}

= Automated Testing =
For information on the current continuous integration system for OpenSim go to [[Automated Testing]].

= Current functionality =

* Standalone region tested with svn version 7082
* Grid region tested with svn version 7082

== Account ==
<table border="1" cellpadding="5" cellspacing="0">
<tr>
<th width="200"> </th>
<th width="200">Standalone</th>
<th width="200">Grid</th>
</tr>
<tr>
<td>login</td>
<td bgcolor="lime">OK</td>
<td bgcolor="lime">OK</td>
</tr>
<tr>
<td>logout</td>
<td bgcolor="lime">OK</td>
<td bgcolor="lime">OK</td>
</tr>
<tr>
<td>relog</td>
<td bgcolor="lime">OK</td>
<td bgcolor="lime">OK</td>
</tr>
<tr>
<td>Home - Login Start Location</td>
<td bgcolor="yellow">unknown</td>
<td bgcolor="lime">OK - Configurable by Region</td>
</tr>
<tr>
<td>Alt Home - if Home unavailable</td>
<td bgcolor="yellow">unknown</td>
<td bgcolor="lime">Alternate Region hardset by GRID</td>
</tr>
</table>

== World ==
<table border="1" cellpadding="5" cellspacing="0">
<tr>
<th width="200"> </th>
<th width="200">Standalone</th>
<th width="200">Grid</th>
</tr>
<tr>
<td>day / night cycle</td>
<td bgcolor="lime">OK</td>
<td bgcolor="lime">OK</td>
</tr>
<tr>
<td>windlight</td>
<td bgcolor="lime">OK</td>
<td bgcolor="lime">OK</td>
</tr>
<tr>
<td>clouds</td>
<td bgcolor="red">not working</td>
<td bgcolor="red">not working</td>
</tr>
<tr>
<td>wind</td>
<td bgcolor="yellow">partially working?</td>
<td bgcolor="yellow">partially working?</td>
</tr>
<tr>
<td>water and water texture</td>
<td bgcolor="lime">OK</td>
<td bgcolor="lime">OK</td>
</tr>
<tr>
<td>terrain and terrain textures</td>
<td bgcolor="lime">OK</td>
<td bgcolor="yellow">Partial</td>
</tr>
</table>

== Accounts and permissions ==
<table border="1" cellpadding="5" cellspacing="0">
<tr>
<th width="200"> </th>
<th width="200">Standalone</th>
<th width="200">Grid</th>
</tr>
<tr>
<td>multiple account creation</td>
<td bgcolor="lime">OK</td>
<td bgcolor="lime">OK</td>
</tr>
<tr>
<td>permissions per account</td>
<td bgcolor="yellow">partially working</td>
<td bgcolor="yellow">minimal</td>
</tr>
<tr>
<td>account has inventory</td>
<td bgcolor="lime">OK</td>
<td bgcolor="lime">OK - Early stages</td>
</tr>
<tr>
<td>sim supports multiple logins</td>
<td bgcolor="lime">OK</td>
<td bgcolor="lime">OK</td>
</tr>
</table>

== Avatar ==
<table border="1" cellpadding="5" cellspacing="0">
<tr>
<th width="200"> </th>
<th width="200">Standalone</th>
<th width="200">Grid</th>
</tr>
<tr>
<td>teleport within region</td>
<td bgcolor="yellow">partially working (always facing north after teleport)</td>
<td bgcolor="yellow">partially working (go inside ground when teleport from low to high position,always facing north after teleport)</td>
</tr>
<tr>
<td>teleport between regions</td>
<td bgcolor="yellow">partially working (Sometimes may fail)</td>
<td bgcolor="lime">OK</td>
</tr>
<tr>
<td>built-in animations (walking, flying, sitting)</td>
<td bgcolor="yellow">partially working</td>
<td bgcolor="yellow">partially working</td>
</tr>
<tr>
<td>uploaded animations / gestures</td>
<td bgcolor="yellow">partially working (play locally, but not in world)</td>
<td bgcolor="lime">OK</td>
</tr>
<tr>
<td>uploaded sounds</td>
<td bgcolor="yellow">partially working (play locally, but not in world)</td>
<td bgcolor="lime">OK</td>
</tr>
<tr>
<td>can wear clothes</td>
<td bgcolor="lime">Working (sometimes need to rewear)</td>
<td bgcolor="lime">OK</td>
</tr>
<tr>
<td>can attach items</td>
<td bgcolor="lime">Working, sometimes dont</td>
<td bgcolor="yellow">basic support but lost attach if reboot serve</td>
</tr>
<tr>
<td>profile</td>
<td bgcolor="red">unknown</td>
<td bgcolor="lime">pics & text</td>
</tr>
<tr>
<td>DRAG / CTRL DRAG objects</td>
<td bgcolor="lime">OK</td>
<td bgcolor="lime">OK</td>
</tr>
</table>

== Building ==
<table border="1" cellpadding="5" cellspacing="0">
<tr>
<th width="200"> </th>
<th width="200">Standalone</th>
<th width="200">Grid</th>
</tr>
<tr>
<td>create prim</td>
<td bgcolor="lime">OK</td>
<td bgcolor="lime">OK</td>
</tr>
<tr>
<td>change prim type</td>
<td bgcolor="lime">OK</td>
<td bgcolor="lime">OK</td>
</tr>
<tr>
<td>change prim transparency</td>
<td bgcolor="lime">OK</td>
<td bgcolor="lime">OK</td>
</tr>
<tr>
<td>change prim colour</td>
<td bgcolor="lime">OK</td>
<td bgcolor="lime">OK</td>
</tr>
<tr>
<td>change prim texture (including uploaded textures)</td>
<td bgcolor="lime">OK</td>
<td bgcolor="lime">OK</td>
</tr>
<tr>
<td>change prim size, cut, hollow, etc</td>
<td bgcolor="yellow">partially working (issues with prim stretching)</td>
<td bgcolor="lime">OK</td>
</tr>
<tr>
<td>prim light, fullbright and flexi</td>
<td bgcolor="lime">OK</td>
<td bgcolor="lime">OK</td>
</tr>
<tr>
<td>link prims</td>
<td bgcolor="lime">OK</td>
<td bgcolor="lime">OK</td>
</tr>
<tr>
<td>unlink prims</td>
<td bgcolor="lime">OK</td>
<td bgcolor="lime">OK</td>
</tr>
<tr>
<td>permissions</td>
<td bgcolor="yellow">partially working</td>
<td bgcolor="yellow">Some (TBA)</td>
</tr>
<tr>
<td>objects persist in world across login / logoff and server restart</td>
<td bgcolor="lime">OK</td>
<td bgcolor="lime">OK</td>
</tr>
<tr>
<td>parcel support</td>
<td bgcolor="yellow">partially working</td>
<td bgcolor="lime">OK See Parcels Below</td>
</tr>
</table>

== Terraforming ==
<table border="1" cellpadding="5" cellspacing="0">
<tr>
<th width="200"> </th>
<th width="200">Standalone</th>
<th width="200">Grid</th>
</tr>
<tr>
<td>select land</td>
<td bgcolor="lime">OK</td>
<td bgcolor="lime">OK</td>
</tr>
<tr>
<td>raise land</td>
<td bgcolor="lime">OK</td>
<td bgcolor="lime">OK</td>
</tr>
<tr>
<td>lower land</td>
<td bgcolor="lime">OK</td>
<td bgcolor="lime">OK</td>
</tr>
<tr>
<td>flatten land</td>
<td bgcolor="lime">OK</td>
<td bgcolor="lime">OK</td>
</tr>
<tr>
<td>roughen land</td>
<td bgcolor="lime">OK</td>
<td bgcolor="red">no causes lower</td>
</tr>
<tr>
<td>smooth land</td>
<td bgcolor="lime">OK - but slow!</td>
<td bgcolor="lime">OK (brush only)</td>
</tr>
</table>

== Land and parcels ==
<table border="1" cellpadding="5" cellspacing="0">
<tr>
<th width="200"> </th>
<th width="200">Standalone</th>
<th width="200">Grid</th>
</tr>
<tr>
<td>subdivide</td>
<td bgcolor="lime">Working</td>
<td bgcolor="lime">Working</td>
</tr>
<tr>
<td>join</td>
<td bgcolor="lime">Working</td>
<td bgcolor="lime">Working</td>
</tr>
<tr>
<td>buy and sell</td>
<td bgcolor="orange">Partial, sell and buy, but no money recieved.</td>
<td bgcolor="red">Not Yet Implemented</td>
</tr>
<tr>
<td>Set Land To Group</td>
<td bgcolor="red">Not Yet Implemented</td>
<td bgcolor="red">Not Yet Implemented</td>
</tr>
<tr>
<td>Allow Deed To Group</td>
<td bgcolor="red">not working</td>
<td bgcolor="red">Not Yet Implemented</td>
</tr>
<tr>
<td>Owner Makes Contribution With Deed</td>
<td bgcolor="red">not working</td>
<td bgcolor="red">Not Yet Implemented</td>
</tr>
<tr>
<td>Buy Pass - (Temporary Paid Access)</td>
<td bgcolor="red">not working</td>
<td bgcolor="red">Not Yet Implemented</td>
</tr>
<tr>
<td>Buy For Group</td>
<td bgcolor="red">not working</td>
<td bgcolor="red">Not Used</td>
</tr>
<td><b>Covenants</b></td>
<tr>
<td>Buy For Group</td>
<td bgcolor="red">not working</td>
<td bgcolor="red">Not Used</td>
</tr>
<tr>
<td>Estate Owner</td>
<td bgcolor="red">not working</td>
<td bgcolor="red">Not Yet Implemented</td>
</tr>
<td><b>Land Objects</b></td>
<tr>
<td>Sim Usage</td>
<td bgcolor="lime">OK</td>
<td bgcolor="lime">OK</td>
</tr>
<tr>
<td>Prims on Parcel</td>
<td bgcolor="lime">OK</td>
<td bgcolor="lime">OK</td>
</tr>
<tr>
<td>Return Parcel Primitives</td>
<td bgcolor="red">Not Yet Implemented</td>
<td bgcolor="red">Not Yet Implemented</td>
</tr>
<tr>
<td>AutoReturn of Prims</td>
<td bgcolor="red">Not Yet Implemented</td>
<td bgcolor="red">Not Yet Implemented</td>
</tr>
<tr>
<td>Show Owners (Land Menu)</td>
<td bgcolor="yellow">Works, but Disabled for Bug Testing</td>
<td bgcolor="yellow">Works, but Disabled for Bug Testing</td>
</tr>
<td><b>Land Options</b></td>
<tr>
<td>Show Owners (Land Menu)</td>
<td bgcolor="red">not working</td>
<td bgcolor="red">Not Yet Implemented</td>
</tr>
<td><b>Land Media</b></td>
<tr>
<td>Replace Texture With Media</td>
<td bgcolor="lime">Working</td>
<td bgcolor="lime">OK - Persists</td>
</tr>
<tr>
<td>Music Stream URL</td>
<td bgcolor="lime">Working</td>
<td bgcolor="lime">OK - Persists</td>
</tr>
<tr>
<td>Restrict Spatialized Sounds to Parcel</td>
<td bgcolor="red">Not Yet Implemented</td>
<td bgcolor="red">Not Yet Implemented</td>
</tr>
<td><b>Land Access</b></td>
<tr>
<td>Show Owners (Land Menu)</td>
<td bgcolor="red">not working</td>
<td bgcolor="red">Not Yet Implemented</td>
</tr>
<td><b>Land Bans</b></td>
<tr>
<td>Limit Access to Group</td>
<td bgcolor="red">Not Yet Implementedg</td>
<td bgcolor="red">Not Yet Implemented</td>
</tr>
<tr>
<td>Limit Access by Avatar</td>
<td bgcolor="yellow">Somewhat Implemented</td>
<td bgcolor="yellow">Somewhat Implemented</td>
</tr>
<tr>
<td>Individual Avatar Ban</td>
<td bgcolor="lime">Working</td>
<td bgcolor="lime">Working - Grid can disable feature gridwide</td>
</tr>
</table>

== UI ==
<table border="1" cellpadding="5" cellspacing="0">
<tr>
<th width="200"> </th>
<th width="200">Standalone</th>
<th width="200">Grid</th>
</tr>
<tr>
<td>friends list</td>
<td bgcolor="lime">OK</td>
<td bgcolor="lime">OK</td>
</tr>
<tr>
<td>uploads</td>
<td bgcolor="lime">OK</td>
<td bgcolor="lime">OK, jpg, bmp,tga (alpha)</td>
</tr>
<tr>
<td>edit profile</td>
<td bgcolor="grey">unknown</td>
<td bgcolor="red">not working (not persistent)</td>
</tr>
<tr>
<td>search</td>
<td bgcolor="red">not working</td>
<td bgcolor="red">not working</td>
</tr>
<tr>
<td>large map</td>
<td bgcolor="lime">OK</td>
<td bgcolor="yellow">OK(currently map textures are a little broken - unavailable for locations not yet visited)</td>
</tr>
<tr>
<td>minimap</td>
<td bgcolor="lime">OK</td>
<td bgcolor="lime">OK</td>
</tr>
<tr>
<td>money</td>
<td bgcolor="red">not working</td>
<td bgcolor="red">not working</td>
</tr>
<tr>
<td>HUD attachments</td>
<td bgcolor="red">not working</td>
<td bgcolor="red">not working</td>
</tr>
</table>

== Friends ==
<table border="1" cellpadding="5" cellspacing="0">
<tr>
<th width="200"> </th>
<th width="200">Standalone</th>
<th width="200">Grid</th>
</tr>
<tr>
<td>add</td>
<td bgcolor="lime">OK</td>
<td bgcolor="lime">OK</td>
</tr>
<tr>
<td>remove</td>
<td bgcolor="lime">OK</td>
<td bgcolor="lime">OK</td>
</tr>
<tr>
<td>permissions</td>
<td bgcolor="red">not working</td>
<td bgcolor="red">not working</td>
</tr>
<tr>
<td>mapping</td>
<td bgcolor="red">not working</td>
<td bgcolor="red">not working</td>
</tr>
<tr>
<td>online visibility</td>
<td bgcolor="red">not working</td>
<td bgcolor="red">not working</td>
</tr>
<tr>
<td>can edit my objects</td>
<td bgcolor="red">no</td>
<td bgcolor="grey">no friends = generic perms application only</td>
</tr>
<tr>
<td>send teleport</td>
<td bgcolor="red">not working</td>
<td bgcolor="red">not working</td>
</tr>

</table>

== Groups ==
Groups are not yet implemented as at SVN 2492
<table border="1" cellpadding="5" cellspacing="0">
<tr>
<th width="200"> </th>
<th width="200">Standalone</th>
<th width="200">Grid</th>
</tr>
<tr>
<td>create</td>
<td bgcolor="red">not working</td>
<td bgcolor="red">Not Yet Implemented</td>
</tr>
<tr>
<td>join</td>
<td bgcolor="red">not working</td>
<td bgcolor="red">Not Yet Implemented</td>
</tr>
<tr>
<td>description</td>
<td bgcolor="grey">unknown</td>
<td bgcolor="red">Not Yet Implemented</td>
</tr>
<tr>
<td>graphic</td>
<td bgcolor="grey">unknown</td>
<td bgcolor="red">Not Yet Implemented</td>
</tr>
<tr>
<td>notices</td>
<td bgcolor="grey">unknown</td>
<td bgcolor="red">Not Yet Implemented</td>
</tr>
<tr>
<td>vote</td>
<td bgcolor="grey">unknown</td>
<td bgcolor="red">Not Yet Implemented</td>
</tr>
<tr>
<td>invite</td>
<td bgcolor="grey">unknown</td>
<td bgcolor="red">Not Yet Implemented</td>
</tr>
<tr>
<td>remove</td>
<td bgcolor="grey">unknown</td>
<td bgcolor="red">Not Yet Implemented</td>
</tr>
<tr>
<td>members</td>
<td bgcolor="grey">unknown</td>
<td bgcolor="red">Not Yet Implemented</td>
</tr>
<tr>
<td>group list</td>
<td bgcolor="grey">unknown</td>
<td bgcolor="red">Not Yet Implemented</td>
</tr>
<tr>
<td>publish</td>
<td bgcolor="grey">unknown</td>
<td bgcolor="red">Not Yet Implemented</td>
</tr>
<tr>
<td>set title</td>
<td bgcolor="grey">unknown</td>
<td bgcolor="red">Not Yet Implemented</td>
</tr>
<tr>
<td>change active title</td>
<td bgcolor="grey">unknown</td>
<td bgcolor="red">Not Yet Implemented</td>
</tr>
<tr>
<td>enrollment fee</td>
<td bgcolor="grey">unknown</td>
<td bgcolor="red">Not Yet Implemented</td>
</tr>
<tr>
<td>open enrollment</td>
<td bgcolor="grey">unknown</td>
<td bgcolor="red">Not Yet Implemented</td>
</tr>
<tr>
<td>set mature flag</td>
<td bgcolor="grey">unknown</td>
<td bgcolor="red">Not Yet Implemented</td>
</tr>
<tr>
<td>group land</td>
<td bgcolor="grey">unknown</td>
<td bgcolor="red">Not Yet Implemented</td>
</tr>
</table>

=== Group Roles ===
<table border="1" cellpadding="5" cellspacing="0">
<tr>
<th width="200"> </th>
<th width="200">Standalone</th>
<th width="200">Grid</th>
</tr>
<tr>
<td>create</td>
<td bgcolor="grey">unknown</td>
<td bgcolor="red">Not Yet Implemented</td>
</tr>
<tr>
<td>edit</td>
<td bgcolor="grey">unknown</td>
<td bgcolor="red">Not Yet Implemented</td>
</tr>
<tr>
<td>remove</td>
<td bgcolor="grey">unknown</td>
<td bgcolor="red">Not Yet Implemented</td>
</tr>
<tr>
<td>add person</td>
<td bgcolor="grey">unknown</td>
<td bgcolor="red">Not Yet Implemented</td>
</tr>
<tr>
<td>remove person</td>
<td bgcolor="grey">unknown</td>
<td bgcolor="red">Not Yet Implemented</td>
</tr>
<tr>
<td>abilities</td>
<td bgcolor="grey">unknown</td>
<td bgcolor="red">Not Yet Implemented</td>
</tr>
Groups are not yet implemented as at SVN 2492
</table>

== Chat, IM, Voice ==
<table border="1" cellpadding="5" cellspacing="0">
<tr>
<th width="200"> </th>
<th width="200">Standalone</th>
<th width="200">Grid</th>
</tr>
<tr>
<td>local chat</td>
<td bgcolor="lime">OK</td>
<td bgcolor="lime">OK - Plus Configurable Distance (server)</td>
</tr>
<tr>
<td>Shout</td>
<td bgcolor="lime">OK</td>
<td bgcolor="lime">OK - Plus Configurable Distance (server)</td>
</tr>
<tr>
<td>send / receive IM</td>
<td bgcolor="lime">OK</td>
<td bgcolor="lime">OK</td>
</tr>
<tr>
<td>offline IM</td>
<td bgcolor="red">unknown</td>
<td bgcolor="red">Not Yet Implemented</td>
</tr>
<tr>
<td>group IM</td>
<td bgcolor="red">unknown</td>
<td bgcolor="red">Not Yet Implemented</td>
</tr>
<tr>
<td>multiple friend IM</td>
<td bgcolor="red">unknown</td>
<td bgcolor="red">Not Yet Implemented</td>
</tr>
<tr>
<td>participant list</td>
<td bgcolor="red">unknown</td>
<td bgcolor="red">Not Yet Implemented</td>
</tr>
<tr>
<td>voice</td>
<td bgcolor="red">unknown</td>
<td bgcolor="red">Not Yet Implemented</td>
</tr>
<tr>
<td>IRC bridge</td>
<td bgcolor="lime">OK</td>
<td bgcolor="lime">OK (Configurable on Server)</td>
</tr>
</table>

== Physics / Collision ==
<table border="1" cellpadding="5" cellspacing="0">
<tr>
<th width="150"> </th>
<th width="150">basicphysics</th>
<th width="150">POS</th>
<th width="150">OpenDynamicsEngine</th>
<th width="150">modified_BulletX</th>
<th width="150">RealPhysX</th>
</tr>
<tr>
<td>walk on ground</td>
<td bgcolor="lime">OK</td>
<td bgcolor="lime">OK</td>
<td bgcolor="lime">OK</td>
<td bgcolor="yellow">partially working (ground is very slippery)</td>
<td bgcolor="grey">unknown</td>
</tr>
<tr>
<td>fly</td>
<td bgcolor="lime">OK</td>
<td bgcolor="lime">OK</td>
<td bgcolor="lime">OK</td>
<td bgcolor="lime">OK</td>
<td bgcolor="grey">unknown</td>
</tr>
<tr>
<td>sit on ground</td>
<td bgcolor="lime">OK</td>
<td bgcolor="lime">OK</td>
<td bgcolor="lime">OK</td>
<td bgcolor="red">not working</td>
<td bgcolor="red">not working</td>
</tr>
<tr>
<td>sit on object</td>
<td bgcolor="lime">OK</td>
<td bgcolor="red">not working</td>
<td bgcolor="yellow">partially working (autopilot has trouble getting to the right spot 'try phantom prim')</td>
<td bgcolor="grey">unknown</td>
<td bgcolor="grey">unknown</td>
</tr>
<tr>
<td>walk on object</td>
<td bgcolor="red">not working</td>
<td bgcolor="lime">OK</td>
<td bgcolor="lime">OK</td>
<td bgcolor="grey">unknown</td>
<td bgcolor="grey">unknown</td>
</tr>
<tr>
<td>bump into object</td>
<td bgcolor="red">not working</td>
<td bgcolor="lime">OK</td>
<td bgcolor="lime">OK</td>
<td bgcolor="grey">unknown</td>
<td bgcolor="grey">unknown</td>
</tr>
<tr>
<td>Collidable Linksets</td>
<td bgcolor="red">not working</td>
<td bgcolor="lime">OK</td>
<td bgcolor="lime">OK</td>
<td bgcolor="grey">unknown</td>
<td bgcolor="grey">unknown</td>
</tr>

<tr>
<td>Avatar Land on Prim</td>
<td bgcolor="red">not working</td>
<td bgcolor="lime">OK</td>
<td bgcolor="lime">OK</td>
<td bgcolor="grey">unknown</td>
<td bgcolor="grey">unknown</td>
</tr>
<tr>
<td>prim physics</td>
<td bgcolor="red">not working</td>
<td bgcolor="red">not working</td>
<td bgcolor="lime">OK</td>
<td bgcolor="grey">unknown</td>
<td bgcolor="grey">unknown</td>
</tr>
<tr>
<td>Physical (active) Linksets</td>
<td bgcolor="red">not working</td>
<td bgcolor="red">not working</td>
<td bgcolor="red">not working</td>
<td bgcolor="red">not working</td>
<td bgcolor="red">not working</td>
</tr>
<tr>
<td>cut/hollow/dimpled prim (non)collisions</td>
<td bgcolor="grey">unknown</td>
<td bgcolor="grey">unknown</td>
<td bgcolor="yellow">partially working</td>
<td bgcolor="grey">unknown</td>
<td bgcolor="grey">unknown</td>
</tr>
</table>

== Scripting ==
<table border="1" cellpadding="5" cellspacing="0">
<tr>
<th width="200"> </th>
<th width="200">Standalone</th>
<th width="200">Grid</th>
</tr>
<tr>
<td>create LSL script</td>
<td bgcolor="yellow">partially working</td>
<td bgcolor="lime">OK, see supported commands</td>
</tr>
<tr>
<td>add script to object</td>
<td bgcolor="lime">OK</td>
<td bgcolor="lime">Drag from inventory into prim</td>
</tr>
<tr>
<td>execute script in object</td>
<td bgcolor="lime">OK</td>
<td bgcolor="lime">OK</td>
</tr>
</table>

Note: not all scripting features are supported yet.
Check [[LSL Status]] for currently implemented features.

== Inventory ==
<table border="1" cellpadding="5" cellspacing="0">
<tr>
<th width="200"> </th>
<th width="200">Standalone</th>
<th width="200">Grid</th>
</tr>
<tr>
<td>create new items (folder, notes, body, clothes, prims, scripts)</td>
<td bgcolor="lime">OK</td>
<td bgcolor="lime">OK</td>
</tr>
<tr>
<td>delete prims -> trash</td>
<td bgcolor="lime">OK</td>
<td bgcolor="lime">OK</td>
</tr>
<tr>
<td>delete items -> trash</td>
<td bgcolor="lime">OK</td>
<td bgcolor="lime">OK</td>
</tr>
<tr>
<td>trash folder functions (restore, purge)</td>
<td bgcolor="lime">OK</td>
<td bgcolor="lime">OK</td>
</tr>
<tr>
<td>search inventory</td>
<td bgcolor="lime">OK</td>
<td bgcolor="lime">OK</td>
</tr>
<tr>
<td>"recent items" list</td>
<td bgcolor="red">not working</td>
<td bgcolor="red">Not Yet Implemented</td>
</tr>
<tr>
<td>inventory persists across logout / login</td>
<td bgcolor="lime">OK</td>
<td bgcolor="lime">OK</td>
</tr>
<tr>
<td>drag items to / from world</td>
<td bgcolor="lime">OK</td>
<td bgcolor="yellow">half... still in progress grid wide</td>
</tr>
<tr>
<td>give inventory items to other avatars</td>
<td bgcolor="red">Not implemented ?</td>
<td bgcolor="yellow">Implemented, but no clue on screen</td>
</tr>
Inventory should not yet be treated as permanent, whilst development is still occurring.
</table>

== Permissions ==
<table border="1" cellpadding="5" cellspacing="0">
<tr>
<th width="200"> </th>
<th width="200">Standalone - Allowed User</th>
<th width="200">Standalone - Denied User</th>
<th width="200">Grid - Allowed User</th>
<th width="200">Grid - Denied User</th>
</tr>
<tr>
<td>Run Script - Estate Disabled</td>
<td bgcolor="grey">unknown</td>
<td bgcolor="grey">unknown</td>
<td bgcolor="lime">no</td>
<td bgcolor="lime">no</td>
</tr>
<tr>
<td>Run Script - Parcel Disabled</td>
<td bgcolor="grey">unknown</td>
<td bgcolor="grey">unknown</td>
<td bgcolor="lime">yes</td>
<td bgcolor="lime">no</td>
</tr>
<tr>
<td>Rez Object - Estate Disabled</td>
<td bgcolor="grey">unknown</td>
<td bgcolor="grey">unknown</td>
<td bgcolor="grey">N/A</td>
<td bgcolor="grey">N/A</td>
</tr>
<tr>
<td>Rez Object - Parcel Disabled</td>
<td bgcolor="grey">unknown</td>
<td bgcolor="grey">unknown</td>
<td bgcolor="lime">yes</td>
<td bgcolor="red">yes</td>
</tr>
<tr>
<td>Edit Estate Settings</td>
<td bgcolor="grey">unknown</td>
<td bgcolor="grey">unknown</td>
<td bgcolor="lime">yes</td>
<td bgcolor="lime">no</td>
</tr>
<tr>
<td>Edit Terrain</td>
<td bgcolor="grey">unknown</td>
<td bgcolor="grey">unknown</td>
<td bgcolor="lime">yes</td>
<td bgcolor="red">yes</td>
</tr>
<tr>
<td>Duplicate (Drag-Duplicate AND Ctrl-D) Object</td>
<td bgcolor="grey">unknown</td>
<td bgcolor="grey">unknown</td>
<td bgcolor="lime">yes</td>
<td bgcolor="red">yes</td>
</tr>
<tr>
<td>Take Object</td>
<td bgcolor="grey">unknown</td>
<td bgcolor="grey">unknown</td>
<td bgcolor="lime">yes</td>
<td bgcolor="red">yes</td>
</tr>
<tr>
<td>Move Object</td>
<td bgcolor="grey">unknown</td>
<td bgcolor="grey">unknown</td>
<td bgcolor="lime">yes</td>
<td bgcolor="red">yes</td>
</tr>
<tr>
<td>Copy Object</td>
<td bgcolor="grey">unknown</td>
<td bgcolor="grey">unknown</td>
<td bgcolor="lime">yes</td>
<td bgcolor="red">yes</td>
</tr>
<tr>
<td>Edit Object</td>
<td bgcolor="grey">unknown</td>
<td bgcolor="grey">unknown</td>
<td bgcolor="lime">yes</td>
<td bgcolor="red">yes</td>
</tr>
<tr>
<td>Delete Object</td>
<td bgcolor="grey">unknown</td>
<td bgcolor="grey">unknown</td>
<td bgcolor="lime">yes</td>
<td bgcolor="red">yes</td>
</tr>
<tr>
<td>Add/Remove to Object's Inventory</td>
<td bgcolor="grey">unknown</td>
<td bgcolor="grey">unknown</td>
<td bgcolor="lime">yes</td>
<td bgcolor="red">yes</td>
</tr>
</table>

-- note --
new objects had to be rezzed for each change in permissions for a test - new permissions settings did not apply to existing objects
[[Category:Development]]

Database:Users

2009-01-22T16:32:34Z

Matpratta:

'''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' ||
|}

;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
;passwordSalt
:The password salt

;homeRegion
:The region-handle of the home-region

;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
:<i style="color:red;">needs to be documented</i>

;userAssetURI
:<i style="color:red;">needs to be documented</i>

;profileCanDoMask
:<i style="color:red;">needs to be documented</i>

;profileWantDoMask
:<i style="color:red;">needs to be documented</i>

;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
:<i style="color:red;">needs to be documented</i>

;homeRegionID
:The region UUID of the home-region

;userFlags
:<i style="color:green;">Account Types:</i>
:<i style="color:blue;">Insert 200 to: Resident:Payment info on account</i>
:<i style="color:blue;">Insert 300 to: Testing:Payment info on account</i>
:<i style="color:blue;">Insert 400 to: Testing:No 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:red;">New Info by Matpratta (matpratta@gmail.com)</i>

;godLevel
:<i style="color:red;">needs to be documented</i>

;customType
:<i style="color:red;">needs to be documented</i>

;partner
:The UUID of a user that will appear in the partner field of the profile dialog
[[Category:Database]]