Land (database table)
From OpenSimulator
(Difference between revisions)
m (Robot: Cosmetic changes) |
(→LandFlags) |
||
| (3 intermediate revisions by one user not shown) | |||
| 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">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 12:16, 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 |
[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.
- byte & 1
- byte & 2
- byte & 4
- byte & 8
- byte & 16
- byte & 32
- byte & 64
- 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
| 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 | 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.
