[Opensim-users] Matching, mapping user UUIDs between servers

[Jeff Kelley]

At 6:33 PM -0400 5/27/13, Rick Anderson wrote:

>  Is there a way to migrate that creator/owner user to a new system 
>and keep their UUID?

SET @region = uuid of the region;
SET @group  = uuid of the avatar;
SET @mask  = 2147483647; # (0x7FFFFFFF)

Change all prims owner:

UPDATE prims SET OwnerID=@owner,OwnerMask=@mask WHERE RegionUUID=@region;

Change all prims' content owner:

UPDATE primitems JOIN prims ON primitems.parentFolderID=prims.UUID 
SET primitems.OwnerID=@owner,primitems.currentPermissions=@mask WHERE 
prims.RegionUUID=@region;

Use with caution.


-- Jeff