Land (database table)

From OpenSimulator

(Difference between revisions)
Jump to: navigation, search
(wikification)
(→‎LandFlags)
 
(5 intermediate revisions by 2 users not shown)
Line 1: Line 1:
−
{{Template:Quicklinks}}
+
{{Quicklinks}}
 
''      (back to [[Database Documentation]])
 
''      (back to [[Database Documentation]])
−
<br><br>
+
<br /><br />
−
The current structure of the Land table is as follows:<br>
+
The current structure of the Land table is as follows:<br />
−
<br>
+
<br />
 
<table>
 
<table>
−
<tr><td>Field<br></td><td>Type</td><td>Null</td><td>Key</td><td>Default</td><td>Extra</td></tr>
+
<tr><td>Field<br /></td><td>Type</td><td>Null</td><td>Key</td><td>Default</td><td>Extra</td></tr>
 
<tr><td>&nbsp;</td></tr>
 
<tr><td>&nbsp;</td></tr>
 
<tr><td>UUID</td><td>varchar(255)</td><td>NO</td><td>PRI</td><td></td><td></td></tr>
 
<tr><td>UUID</td><td>varchar(255)</td><td>NO</td><td>PRI</td><td></td><td></td></tr>
Line 124: Line 124:
 
''From OpenMetaverse.ParcelStatus''
 
''From OpenMetaverse.ParcelStatus''
 
* -1 : None
 
* -1 : None
−
* 0 : Leased
+
* 0 : Leased
−
* 1 : LeasePending
+
* 1 : LeasePending
−
* 2 : Abandoned
+
* 2 : Abandoned
  
 
== LandFlags ==
 
== LandFlags ==
 
<table>
 
<table>
 
<caption>OpenMetaverse.ParcelFlags</caption>
 
<caption>OpenMetaverse.ParcelFlags</caption>
 +
<tr><th>Name</th><th align="left">Decimal</th><th align="left">Hex</th><th align="left">Description</th></tr>
 
<tr>
 
<tr>
 
<th scope="row">None</th>
 
<th scope="row">None</th>
 +
<td>0</td>
 
<td>0</td>
 
<td>0</td>
 
<td>No flags set</td>
 
<td>No flags set</td>
Line 138: Line 140:
 
<tr>
 
<tr>
 
<th scope="row">AllowFly</th>
 
<th scope="row">AllowFly</th>
 +
<td>1</td>
 
<td>1</td>
 
<td>1</td>
 
<td>Allow avatars to fly (a client-side only restriction)</td>
 
<td>Allow avatars to fly (a client-side only restriction)</td>
Line 143: Line 146:
 
<tr>
 
<tr>
 
<th scope="row">AllowOtherScripts</th>
 
<th scope="row">AllowOtherScripts</th>
 +
<td>2</td>
 
<td>2</td>
 
<td>2</td>
 
<td>Allow foreign scripts to run</td>
 
<td>Allow foreign scripts to run</td>
Line 148: Line 152:
 
<tr>
 
<tr>
 
<th scope="row">ForSale</th>
 
<th scope="row">ForSale</th>
 +
<td>4</td>
 
<td>4</td>
 
<td>4</td>
 
<td>This parcel is for sale</td>
 
<td>This parcel is for sale</td>
Line 153: Line 158:
 
<tr>
 
<tr>
 
<th scope="row">AllowLandmark</th>
 
<th scope="row">AllowLandmark</th>
 +
<td>8</td>
 
<td>8</td>
 
<td>8</td>
 
<td>Allow avatars to create a landmark on this parcel</td>
 
<td>Allow avatars to create a landmark on this parcel</td>
Line 159: Line 165:
 
<th scope="row">AllowTerraform</th>
 
<th scope="row">AllowTerraform</th>
 
<td>16</td>
 
<td>16</td>
 +
<td>10</td>
 
<td>Allows all avatars to edit the terrain on this parcel</td>
 
<td>Allows all avatars to edit the terrain on this parcel</td>
 
</tr>
 
</tr>
Line 164: Line 171:
 
<th scope="row">AllowDamage</th>
 
<th scope="row">AllowDamage</th>
 
<td>32</td>
 
<td>32</td>
 +
<td>20</td>
 
<td>Avatars have health and can take damage on this parcel.  If set, avatars can be killed and sent home here</td>
 
<td>Avatars have health and can take damage on this parcel.  If set, avatars can be killed and sent home here</td>
 
</tr>
 
</tr>
Line 169: Line 177:
 
<th scope="row">CreateObjects</th>
 
<th scope="row">CreateObjects</th>
 
<td>64</td>
 
<td>64</td>
 +
<td>40</td>
 
<td>Foreign avatars can create objects here</td>
 
<td>Foreign avatars can create objects here</td>
 
</tr>
 
</tr>
Line 174: Line 183:
 
<th scope="row">ForSaleObjects</th>
 
<th scope="row">ForSaleObjects</th>
 
<td>128</td>
 
<td>128</td>
 +
<td>80</td>
 
<td>All objects on this parcel can be purchased</td>
 
<td>All objects on this parcel can be purchased</td>
 
</tr>
 
</tr>
Line 179: Line 189:
 
<th scope="row">UseAccessGroup</th>
 
<th scope="row">UseAccessGroup</th>
 
<td>256</td>
 
<td>256</td>
 +
<td>100</td>
 
<td>Access is restricted to a group</td>
 
<td>Access is restricted to a group</td>
 
</tr>
 
</tr>
Line 184: Line 195:
 
<th scope="row">UseAccessList</th>
 
<th scope="row">UseAccessList</th>
 
<td>512</td>
 
<td>512</td>
 +
<td>200</td>
 
<td>Access is restricted to a whitelist</td>
 
<td>Access is restricted to a whitelist</td>
 
</tr>
 
</tr>
Line 189: Line 201:
 
<th scope="row">UseBanList</th>
 
<th scope="row">UseBanList</th>
 
<td>1024</td>
 
<td>1024</td>
 +
<td>400</td>
 
<td>Ban blacklist is enabled</td>
 
<td>Ban blacklist is enabled</td>
 
</tr>
 
</tr>
Line 194: Line 207:
 
<th scope="row">UsePassList</th>
 
<th scope="row">UsePassList</th>
 
<td>2048</td>
 
<td>2048</td>
 +
<td>800</td>
 
<td>Unknown</td>
 
<td>Unknown</td>
 
</tr>
 
</tr>
Line 199: Line 213:
 
<th scope="row">ShowDirectory</th>
 
<th scope="row">ShowDirectory</th>
 
<td>4096</td>
 
<td>4096</td>
 +
<td>1000</td>
 
<td>List this parcel in the search directory</td>
 
<td>List this parcel in the search directory</td>
 
</tr>
 
</tr>
Line 204: Line 219:
 
<th scope="row">AllowDeedToGroup</th>
 
<th scope="row">AllowDeedToGroup</th>
 
<td>8192</td>
 
<td>8192</td>
 +
<td>2000</td>
 
<td>Allow personally owned parcels to be deeded to group</td>
 
<td>Allow personally owned parcels to be deeded to group</td>
 
</tr>
 
</tr>
Line 209: Line 225:
 
<th scope="row">ContributeWithDeed</th>
 
<th scope="row">ContributeWithDeed</th>
 
<td>16384</td>
 
<td>16384</td>
 +
<td>4000</td>
 
<td>If Deeded, owner contributes required tier to group parcel is deeded to</td>
 
<td>If Deeded, owner contributes required tier to group parcel is deeded to</td>
 
</tr>
 
</tr>
Line 214: Line 231:
 
<th scope="row">SoundLocal</th>
 
<th scope="row">SoundLocal</th>
 
<td>32768</td>
 
<td>32768</td>
 +
<td>8000</td>
 
<td>Restrict sounds originating on this parcel to the parcel boundaries</td>
 
<td>Restrict sounds originating on this parcel to the parcel boundaries</td>
 
</tr>
 
</tr>
Line 219: Line 237:
 
<th scope="row">SellParcelObjects</th>
 
<th scope="row">SellParcelObjects</th>
 
<td>65536</td>
 
<td>65536</td>
 +
<td>10000</td>
 
<td>Objects on this parcel are sold when the land is purchsaed</td>
 
<td>Objects on this parcel are sold when the land is purchsaed</td>
 
</tr>
 
</tr>
Line 224: Line 243:
 
<th scope="row">AllowPublish</th>
 
<th scope="row">AllowPublish</th>
 
<td>131072</td>
 
<td>131072</td>
 +
<td>20000</td>
 
<td>Allow this parcel to be published on the web</td>
 
<td>Allow this parcel to be published on the web</td>
 
</tr>
 
</tr>
Line 229: Line 249:
 
<th scope="row">MaturePublish</th>
 
<th scope="row">MaturePublish</th>
 
<td>262144</td>
 
<td>262144</td>
 +
<td>40000</td>
 
<td>The information for this parcel is mature content</td>
 
<td>The information for this parcel is mature content</td>
 
</tr>
 
</tr>
Line 234: Line 255:
 
<th scope="row">UrlWebPage</th>
 
<th scope="row">UrlWebPage</th>
 
<td>524288</td>
 
<td>524288</td>
 +
<td>80000</td>
 
<td>The media URL is an HTML page</td>
 
<td>The media URL is an HTML page</td>
 
</tr>
 
</tr>
Line 239: Line 261:
 
<th scope="row">UrlRawHtml</th>
 
<th scope="row">UrlRawHtml</th>
 
<td>1048576</td>
 
<td>1048576</td>
 +
<td>100000</td>
 
<td>The media URL is a raw HTML string</td>
 
<td>The media URL is a raw HTML string</td>
 
</tr>
 
</tr>
Line 244: Line 267:
 
<th scope="row">RestrictPushObject</th>
 
<th scope="row">RestrictPushObject</th>
 
<td>2097152</td>
 
<td>2097152</td>
 +
<td>200000</td>
 
<td>Restrict foreign object pushes</td>
 
<td>Restrict foreign object pushes</td>
 
</tr>
 
</tr>
Line 249: Line 273:
 
<th scope="row">DenyAnonymous</th>
 
<th scope="row">DenyAnonymous</th>
 
<td>4194304</td>
 
<td>4194304</td>
 +
<td>400000</td>
 
<td>Ban all non identified/transacted avatars</td>
 
<td>Ban all non identified/transacted avatars</td>
 
</tr>
 
</tr>
Line 254: Line 279:
 
<th scope="row">LindenHome</th>
 
<th scope="row">LindenHome</th>
 
<td>8388608</td>
 
<td>8388608</td>
 +
<td>800000</td>
 
<td>No comment in documentation or this one!</td>
 
<td>No comment in documentation or this one!</td>
 
</tr>
 
</tr>
Line 259: Line 285:
 
<th scope="row">AllowGroupScripts</th>
 
<th scope="row">AllowGroupScripts</th>
 
<td>33554432</td>
 
<td>33554432</td>
 +
<td>2000000</td>
 
<td>Allow group-owned scripts to run</td>
 
<td>Allow group-owned scripts to run</td>
 
</tr>
 
</tr>
Line 264: Line 291:
 
<th scope="row">CreateGroupObjects</th>
 
<th scope="row">CreateGroupObjects</th>
 
<td>67108864</td>
 
<td>67108864</td>
 +
<td>4000000</td>
 
<td>Allow object creation by group members or group objects</td>
 
<td>Allow object creation by group members or group objects</td>
 
</tr>
 
</tr>
Line 269: Line 297:
 
<th scope="row">AllowAPrimitiveEntry</th>
 
<th scope="row">AllowAPrimitiveEntry</th>
 
<td>134217728</td>
 
<td>134217728</td>
 +
<td>8000000</td>
 
<td>Allow all objects to enter this parcel</td>
 
<td>Allow all objects to enter this parcel</td>
 
</tr>
 
</tr>
Line 274: Line 303:
 
<th scope="row">AllowGroupObjectEntry</th>
 
<th scope="row">AllowGroupObjectEntry</th>
 
<td>268435456</td>
 
<td>268435456</td>
 +
<td>10000000</td>
 
<td>Only allow group and owner objects to enter this parcel</td>
 
<td>Only allow group and owner objects to enter this parcel</td>
 
</tr>
 
</tr>
Line 279: Line 309:
 
<th scope="row">AllowVoiceChat</th>
 
<th scope="row">AllowVoiceChat</th>
 
<td>536870912</td>
 
<td>536870912</td>
 +
<td>20000000</td>
 
<td>Voice Enabled on this parcel</td>
 
<td>Voice Enabled on this parcel</td>
 
</tr>
 
</tr>
Line 284: Line 315:
 
<th scope="row">UseEstateVoiceChan</th>
 
<th scope="row">UseEstateVoiceChan</th>
 
<td>1073741824</td>
 
<td>1073741824</td>
−
<td>Use Estate Voice channel for Voice on this parcel</td>
+
<td>40000000</td>
 +
<td>Use Estate Voice channel for Voice on this parcel.  This correspond to unchecking "Restrict voice to this parcel" in the viewer.</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<th scope="row">DenyAgeUnverified</th>
 
<th scope="row">DenyAgeUnverified</th>
 
<td>2147483648</td>
 
<td>2147483648</td>
 +
<td>80000000</td>
 
<td>Deny Age Unverified Users</td>
 
<td>Deny Age Unverified Users</td>
 
</tr>
 
</tr>

Latest revision as of 13:16, 18 October 2012

Languages Languages: 

En.png English

      (back to Database Documentation)

The current structure of the Land table is as follows:

Field
TypeNullKeyDefaultExtra
 
UUIDvarchar(255)NOPRI
RegionUUIDvarchar(255)YES
LocalLandIDint(11)YES
BitmaplongblobYES
Namevarchar(255)YES
Descriptionvarchar(255)YES
OwnerUUIDvarchar(255)YES
IsGroupOwnedint(11)YES
Areaint(11)YES
AuctionIDint(11)YES
Categoryint(11)YES
ClaimDateint(11)YES
ClaimPriceint(11)YES
GroupUUIDvarchar(255)YES
SalePriceint(11)YES
LandStatusint(11)YES
LandFlagsint(11)YES
MediaAutoScaleint(11)YES
MediaTextureUUIDvarchar(255)YES
MediaURLvarchar(255)YES
MUSICURLvarchar(255)YES
PasshoursfloatYES
PassPriceint(11)YES
SnapshotUUIDvarchar(255)YES
UserLocationXint(11)YES
UserLocationYint(11)YES
UserLocationZint(11)YES
UserLookAtXint(11)YES
UserLookAtYint(11)YES
UserLookAtZint(11)YES
AuthBuyerIDvarchar(255)NO00000000-0000-0000-0000-000000000000
OtherCleanTimeint(11)NO
Dwellint(11)NO

Contents

[edit] UUID

The unique ID of the Land Parcel.

[edit] RegionUUID

The UUID of the region containing this land parcel.

[edit] LocalLandID

The number of the parcel.

[edit] Bitmap

A block of 512 bytes (4,096 bits) of data with each bit of each byte indicating whether a 4m x 4m piece of a region (the smallest selectable) is in the parcel of land. The block of bytes starts in the bottom left corner of the region, proceeding west-east, south-north. As there are 8 bits in a byte, each byte corresponds to 8 pieces of land in a 256x256 region.

The first bit in the first byte refers to the square piece of land with corners (in region co-ordinates) at:

  • (0, 0)
  • (4, 0)
  • (4, 4)
  • (0, 4)

The first byte corresponds to a rectangle with corners at:

  • (0 ,0)
  • (32,0)
  • (32,4)
  • (0, 4)

The second byte corresponds to a rectangle with corners at:

  • (32, 0)
  • (64, 0)
  • (64, 4)
  • (32, 4)

The ninth byte thus corresponds to a rectangle with corners at:

  • (0, 4)
  • (32,4)
  • (32,8)
  • (0, 8)

To determine if a piece of land in the region belongs to the parcel, one should perform a bitwise operation on the byte, e.g.

  1. byte & 1
  2. byte & 2
  3. byte & 4
  4. byte & 8
  5. byte & 16
  6. byte & 32
  7. byte & 64
  8. byte & 128

[edit] Name

The name of this land parcel.

[edit] Description

A description of this land parcel.

[edit] OwnerUUID

The UUID of the user who owns this land parcel.

[edit] IsGroupOwned

This is set to 1 if the parcel is owned by a group. If it is not group owned it will be 0.

[edit] Area

The size of the parcel (in square meters).

[edit] AuctionID

To be identified.

[edit] Category

This specifies the category the parcel of land is in when doing a search. A value of 0 indicates no category was set, -1 is any category, and positive numbers indicate a specific category.

[edit] ClaimDate

The date the parcel of land was claimed by an avatar (ie. the date of sale).

[edit] ClaimPrice

To be identified.

[edit] GroupUUID

To be identified when Groups are implemented.

[edit] SalePrice

If the land is for sale this is the price asked.

[edit] LandStatus

From OpenMetaverse.ParcelStatus

  • -1 : None
  • 0 : Leased
  • 1 : LeasePending
  • 2 : Abandoned

[edit] LandFlags

OpenMetaverse.ParcelFlags
NameDecimalHexDescription
None 0 0 No flags set
AllowFly 1 1 Allow avatars to fly (a client-side only restriction)
AllowOtherScripts 2 2 Allow foreign scripts to run
ForSale 4 4 This parcel is for sale
AllowLandmark 8 8 Allow avatars to create a landmark on this parcel
AllowTerraform 16 10 Allows all avatars to edit the terrain on this parcel
AllowDamage 32 20 Avatars have health and can take damage on this parcel. If set, avatars can be killed and sent home here
CreateObjects 64 40 Foreign avatars can create objects here
ForSaleObjects 128 80 All objects on this parcel can be purchased
UseAccessGroup 256 100 Access is restricted to a group
UseAccessList 512 200 Access is restricted to a whitelist
UseBanList 1024 400 Ban blacklist is enabled
UsePassList 2048 800 Unknown
ShowDirectory 4096 1000 List this parcel in the search directory
AllowDeedToGroup 8192 2000 Allow personally owned parcels to be deeded to group
ContributeWithDeed 16384 4000 If Deeded, owner contributes required tier to group parcel is deeded to
SoundLocal 32768 8000 Restrict sounds originating on this parcel to the parcel boundaries
SellParcelObjects 65536 10000 Objects on this parcel are sold when the land is purchsaed
AllowPublish 131072 20000 Allow this parcel to be published on the web
MaturePublish 262144 40000 The information for this parcel is mature content
UrlWebPage 524288 80000 The media URL is an HTML page
UrlRawHtml 1048576 100000 The media URL is a raw HTML string
RestrictPushObject 2097152 200000 Restrict foreign object pushes
DenyAnonymous 4194304 400000 Ban all non identified/transacted avatars
LindenHome 8388608 800000 No comment in documentation or this one!
AllowGroupScripts 33554432 2000000 Allow group-owned scripts to run
CreateGroupObjects 67108864 4000000 Allow object creation by group members or group objects
AllowAPrimitiveEntry 134217728 8000000 Allow all objects to enter this parcel
AllowGroupObjectEntry 268435456 10000000 Only allow group and owner objects to enter this parcel
AllowVoiceChat 536870912 20000000 Voice Enabled on this parcel
UseEstateVoiceChan 1073741824 40000000 Use Estate Voice channel for Voice on this parcel. This correspond to unchecking "Restrict voice to this parcel" in the viewer.
DenyAgeUnverified 2147483648 80000000 Deny Age Unverified Users

[edit] LandingType

The landing point setting for the parcel: 0 is Blocked, 1 is 1anding point set, 2 is for landing allowed anywhere.

[edit] MediaAutoScale

A boolean (1 or 0) indicating whether media should be stretched to fit the face of the prim it's displayed on.

[edit] MediaTextureUUID

The UUID of a texture. Objects using this texture will show a video stream or web page after they click the video play arrow in their viewer.

[edit] MediaURL

The URL of the video stream, or media, to be played in this land.

[edit] MusicURL

The URL of the Music station to be played in this land.

[edit] Passhours

The length of time that a pass to his parcel is valid.

[edit] PassPrice

The cost of a pass to this parcel.

[edit] SnapshotUUID

The UUID (key) on the asset table of a picture of this parcel.

[edit] UserLocationX

The X co-ordinate of the parcel's landing zone (if set).

[edit] UserLocationY

The Y co-ordinate of the parcel's landing zone (if set).

[edit] UserLocationZ

The Z co-ordinate of the parcel's landing zone (if set).

[edit] UserLookAtX

To be identified.

[edit] UserLookAtY

To be identified.

[edit] UserLookAtZ

To be identified.

[edit] AuthBuyID

The UUID of the User authorised to buy this land.

[edit] OtherCleanTime

Other residents objects in the parcel will be automatically returned after this many minutes has elapsed. Set to 0 to disable auto-return of objects.

[edit] Dwell

To be identified.

Retrieved from "http://opensimulator.org/index.php?title=Land_(database_table)&oldid=31037"
Personal tools
General
About This Wiki