Regions (database table)

The regions table contains information concerning all the regions currently connected to the grid. (back to Database Documentation)

regions Table Structure
The structure of the regions table is as follows:

(back to Database Documentation)

regions Fields
uuid
 * The region's unique identifier

regionHandle
 * The absolute address of the origin coordinates, specified in metres, of the region calculated from LocX and LocY as
 * (LocX*256*65536)+(LocY*256).

regionName
 * The region's name as it appears on maps - not necesarily unique

regionRecvKey
 * The key used by the region server to verify authenticity of communications from other regions

regionSendKey
 * The key used by the region server when verifying its identity in communications with other regions

regionSecret
 * more detail req'd

regionDataURI
 * more detail req'd

serverIP
 * IP address of region server

serverPort
 * connection port for region server

serverURI
 * more detail req'd

locX
 * X coordinate of region on the grid

locY
 * Y coordinate of region on the grid

locZ
 * Z coordinate of region on the grid *grinz*

eastOverrideHandle
 * more detail req'd

westOverrideHandle
 * more detail req'd

southOverrideHandle
 * more detail req'd

northOverrideHandle
 * more detail req'd

regionAssetURI
 * The URL and port number of the Asset Server for the grid

regionAssetRecvKey
 * Key used to verify the authenticity of communications received from the asset server

regionAssetSendKey
 * Key used to verify the authenticity of communications sent to the asset server

regionUserURI
 * The URL and port number of the User Server for the grid

regionUserRecvKey
 * Key used to verify the authenticity of communications received from the user server

regionUserSendKey
 * Key used to verify the authenticity of communications sent to the user server

regionMapTexture
 * Texture for the map as displayed in the client minimap

serverHttpPort
 * Port the region will answer on for HTTP requests

serverRemotingPort
 * more detail req'd

owner_uuid
 * UUID of the avatar/account which owns the region

originUUID
 * more detail req'd, currently seems to contain the current UUID of the region.

access
 * PG=13 Region is set to PG
 * Moderate=21 Region is set to Moderate
 * Adult=42 Region is set to Adult

ScopeID
 * more detail req'd

sizeX
 * X size of region (in m)

sizeY
 * Y size of region (in m)

flags
 * DefaultRegion=1 Default region for new avatars. Region is randomly selected if multiple regions have fallback flag set.
 * FallbackRegion=2 Regions we redirect to when the destination is down
 * RegionOnline=4 Set when a region comes online, unset when it unregisters and DeleteOnUnregister is false
 * NoDirectLogin=8 Region unavailable for direct logins (by name)
 * Persistent=16 Don't remove on unregister
 * LockedOut=32 Don't allow registration
 * NoMove=64 Don't allow moving this region
 * Reservation=128 This is an inactive reservation
 * Authenticate=256 Require authentication
 * Hyperlink=512 Record represents a HG link
 * DefaultHGRegion=1024 Record represents a default region for hypergrid teleports only.

last_seen
 * more detail req'd

PrincipalID
 * more detail req'd

Token
 * more detail req'd

(back to Database Documentation)