<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#ffffff">
The release notes describe the database changes:<br>
<a class="moz-txt-link-freetext" href="http://opensimulator.org/wiki/0.7_Release">http://opensimulator.org/wiki/0.7_Release</a><br>
<br>
On 3/11/2011 7:43 AM, Clive Gould wrote:
<blockquote
cite="mid:AANLkTimf3mCg6RHSZtrPCCTXmBNhCMz_T2nBkAdkoZyF@mail.gmail.com"
type="cite">
<div>Hi</div>
<div> </div>
<div>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.</div>
<div> </div>
<div>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.</div>
<div> </div>
<div>Looking at the original script, which worked with 0.6.9 the
following user table settings are written:</div>
<div> </div>
<div>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</div>
<div> </div>
<div>Looking at the new database structure with 0.7 the
UserAccounts table now contains the following fields:</div>
<div> </div>
<div>PrincipalID, ScopeID, FirstName, LastName, Email, ServiceURLs, Created, UserLevel, UserFlags, UserTitle</div>
<div> </div>
<div>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?</div>
<div> </div>
<div>Thanks very much</div>
<div> </div>
<div>Clive</div>
<div> </div>
<div> </div>
<div> </div>
<div> </div>
<div> </div>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
Opensim-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Opensim-users@lists.berlios.de">Opensim-users@lists.berlios.de</a>
<a class="moz-txt-link-freetext" href="https://lists.berlios.de/mailman/listinfo/opensim-users">https://lists.berlios.de/mailman/listinfo/opensim-users</a>
</pre>
</blockquote>
<br>
</body>
</html>