Land (database table)
From OpenSimulator
(Difference between revisions)
(→LandFlags) |
(→LandFlags) |
||
| Line 131: | Line 131: | ||
<table> | <table> | ||
<caption>OpenMetaverse.ParcelFlags</caption> | <caption>OpenMetaverse.ParcelFlags</caption> | ||
| − | <tr><th>Name</th><th align="left">Decimal</th><th align="left">Description</th></tr> | + | <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 139: | 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 144: | 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 149: | 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 154: | 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 160: | 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 165: | 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 170: | 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 175: | 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 180: | 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 185: | 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 190: | 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 195: | 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 200: | 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 205: | 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 210: | 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 215: | 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 220: | 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 225: | 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 230: | 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 235: | 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 240: | 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 245: | 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 250: | 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 255: | 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 260: | Line 285: | ||
<th scope="row">AllowGroupScripts</th> | <th scope="row">AllowGroupScripts</th> | ||
<td>33554432</td> | <td>33554432</td> | ||
| + | <td>1000000</td> | ||
<td>Allow group-owned scripts to run</td> | <td>Allow group-owned scripts to run</td> | ||
</tr> | </tr> | ||
| Line 265: | Line 291: | ||
<th scope="row">CreateGroupObjects</th> | <th scope="row">CreateGroupObjects</th> | ||
<td>67108864</td> | <td>67108864</td> | ||
| + | <td>2000000</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 270: | Line 297: | ||
<th scope="row">AllowAPrimitiveEntry</th> | <th scope="row">AllowAPrimitiveEntry</th> | ||
<td>134217728</td> | <td>134217728</td> | ||
| + | <td>4000000</td> | ||
<td>Allow all objects to enter this parcel</td> | <td>Allow all objects to enter this parcel</td> | ||
</tr> | </tr> | ||
| Line 275: | Line 303: | ||
<th scope="row">AllowGroupObjectEntry</th> | <th scope="row">AllowGroupObjectEntry</th> | ||
<td>268435456</td> | <td>268435456</td> | ||
| + | <td>8000000</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 280: | Line 309: | ||
<th scope="row">AllowVoiceChat</th> | <th scope="row">AllowVoiceChat</th> | ||
<td>536870912</td> | <td>536870912</td> | ||
| + | <td>10000000</td> | ||
<td>Voice Enabled on this parcel</td> | <td>Voice Enabled on this parcel</td> | ||
</tr> | </tr> | ||
| Line 285: | Line 315: | ||
<th scope="row">UseEstateVoiceChan</th> | <th scope="row">UseEstateVoiceChan</th> | ||
<td>1073741824</td> | <td>1073741824</td> | ||
| + | <td>20000000</td> | ||
<td>Use Estate Voice channel for Voice on this parcel</td> | <td>Use Estate Voice channel for Voice on this parcel</td> | ||
</tr> | </tr> | ||
| Line 290: | Line 321: | ||
<th scope="row">DenyAgeUnverified</th> | <th scope="row">DenyAgeUnverified</th> | ||
<td>2147483648</td> | <td>2147483648</td> | ||
| + | <td>40000000</td> | ||
<td>Deny Age Unverified Users</td> | <td>Deny Age Unverified Users</td> | ||
</tr> | </tr> | ||
Revision as of 12:08, 18 October 2012
 |
Languages: |
|
(back to Database Documentation)
The current structure of the Land table is as follows:
| Field | Type | Null | Key | Default | Extra |
| UUID | varchar(255) | NO | PRI | ||
| RegionUUID | varchar(255) | YES | |||
| LocalLandID | int(11) | YES | |||
| Bitmap | longblob | YES | |||
| Name | varchar(255) | YES | |||
| Description | varchar(255) | YES | |||
| OwnerUUID | varchar(255) | YES | |||
| IsGroupOwned | int(11) | YES | |||
| Area | int(11) | YES | |||
| AuctionID | int(11) | YES | |||
| Category | int(11) | YES | |||
| ClaimDate | int(11) | YES | |||
| ClaimPrice | int(11) | YES | |||
| GroupUUID | varchar(255) | YES | |||
| SalePrice | int(11) | YES | |||
| LandStatus | int(11) | YES | |||
| LandFlags | int(11) | YES | |||
| MediaAutoScale | int(11) | YES | |||
| MediaTextureUUID | varchar(255) | YES | |||
| MediaURL | varchar(255) | YES | |||
| MUSICURL | varchar(255) | YES | |||
| Passhours | float | YES | |||
| PassPrice | int(11) | YES | |||
| SnapshotUUID | varchar(255) | YES | |||
| UserLocationX | int(11) | YES | |||
| UserLocationY | int(11) | YES | |||
| UserLocationZ | int(11) | YES | |||
| UserLookAtX | int(11) | YES | |||
| UserLookAtY | int(11) | YES | |||
| UserLookAtZ | int(11) | YES | |||
| AuthBuyerID | varchar(255) | NO | 00000000-0000-0000-0000-000000000000 | ||
| OtherCleanTime | int(11) | NO | |||
| Dwell | int(11) | NO |
UUID
The unique ID of the Land Parcel.
RegionUUID
The UUID of the region containing this land parcel.
LocalLandID
The number of the parcel.
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.
- byte & 1
- byte & 2
- byte & 4
- byte & 8
- byte & 16
- byte & 32
- byte & 64
- byte & 128
Name
The name of this land parcel.
Description
A description of this land parcel.
OwnerUUID
The UUID of the user who owns this land parcel.
IsGroupOwned
This is set to 1 if the parcel is owned by a group. If it is not group owned it will be 0.
Area
The size of the parcel (in square meters).
AuctionID
To be identified.
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.
ClaimDate
The date the parcel of land was claimed by an avatar (ie. the date of sale).
ClaimPrice
To be identified.
GroupUUID
To be identified when Groups are implemented.
SalePrice
If the land is for sale this is the price asked.
LandStatus
From OpenMetaverse.ParcelStatus
- -1 : None
- 0 : Leased
- 1 : LeasePending
- 2 : Abandoned
LandFlags
| Name | Decimal | Hex | Description |
|---|---|---|---|
| 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 | 1000000 | Allow group-owned scripts to run |
| CreateGroupObjects | 67108864 | 2000000 | Allow object creation by group members or group objects |
| AllowAPrimitiveEntry | 134217728 | 4000000 | Allow all objects to enter this parcel |
| AllowGroupObjectEntry | 268435456 | 8000000 | Only allow group and owner objects to enter this parcel |
| AllowVoiceChat | 536870912 | 10000000 | Voice Enabled on this parcel |
| UseEstateVoiceChan | 1073741824 | 20000000 | Use Estate Voice channel for Voice on this parcel |
| DenyAgeUnverified | 2147483648 | 40000000 | Deny Age Unverified Users |
LandingType
The landing point setting for the parcel: 0 is Blocked, 1 is 1anding point set, 2 is for landing allowed anywhere.
MediaAutoScale
A boolean (1 or 0) indicating whether media should be stretched to fit the face of the prim it's displayed on.
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.
MediaURL
The URL of the video stream, or media, to be played in this land.
MusicURL
The URL of the Music station to be played in this land.
Passhours
The length of time that a pass to his parcel is valid.
PassPrice
The cost of a pass to this parcel.
SnapshotUUID
The UUID (key) on the asset table of a picture of this parcel.
UserLocationX
The X co-ordinate of the parcel's landing zone (if set).
UserLocationY
The Y co-ordinate of the parcel's landing zone (if set).
UserLocationZ
The Z co-ordinate of the parcel's landing zone (if set).
UserLookAtX
To be identified.
UserLookAtY
To be identified.
UserLookAtZ
To be identified.
AuthBuyID
The UUID of the User authorised to buy this land.
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.
Dwell
To be identified.
