[Opensim-users] Help: Self registration script no longer working

[Clive Gould]

Hi

I have a set of PHP scripts originally developed at Glagow Caledonian
University that allow users to self register with our OpenSim standalone
installation, provided they have a valid institutional email address.

These worked fine with OpenSim 0.6.9 but no longer work with OpenSim 0.7 as
there appears to have been a change in the database tables between the two
versions.

Looking at the original script, which worked with 0.6.9 the following user
table settings are written:

UUID, username, lastname, passwordHash, passwordSalt, homeRegion,
homeLocationX, homeLocationY, homeLocationZ, homeLookAtX, homeLookAtY,
homeLookAtZ, created, lastLogin, userInventoryURI,userAssetURI,
profileCanDoMask, profileWantDoMask, profileAboutText, profileFirstText,
profileImage, profileFirstImage, webLoginKey,
homeRegionID,userFlags,godLevel,customType,partner,email

Looking at the new database structure with 0.7 the UserAccounts table now
contains the following fields:

PrincipalID, ScopeID, FirstName, LastName, Email, ServiceURLs,
Created, UserLevel, UserFlags, UserTitle

Does anyone have a set of self-registration scripts that will work with
OpenSim 0.7 or can advise me what tables a self registration script would
now need to write to?

Thanks very much

Clive
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://opensimulator.org/pipermail/opensim-users/attachments/20110311/79ef249b/attachment.html>