<div>Hi</div>
<div> </div>
<div>I've been comparing the OpenSim database tables before and after creating a user account. </div>
<div> </div>
<div>There appear to be three tables affected when a new user is added:</div>
<div> </div>
<div>auth</div>
<div>inventoryfolders</div>
<div>
<div>UserAccounts</div><br>auth and UserAccounts look quite straightforward to write to using an external PHP script, but inventoryfolders looks a complete nightmare as it appears to be completely regenerated.</div>
<div> </div>
<div>Does anyone have any idea if I modify the OpenSim 0.6.9 self registration scripts to write to auth and UserAccounts if OpenSim will automatically recognise the new records and make the appropriate additions to the inventoryfolders tables???</div>
<div> </div>
<div>Suggestions most welcome.</div>
<div> </div>
<div>Clive</div>
<div><br><br> </div>
<div class="gmail_quote">On Fri, Mar 11, 2011 at 4:32 PM, Diva Canto <span dir="ltr"><<a href="mailto:diva@metaverseink.com">diva@metaverseink.com</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">
<div text="#000000" bgcolor="#ffffff">I don't see any differences besides capitalization, which works differently in linux and Windows.
<div>
<div></div>
<div class="h5"><br><br>On 3/11/2011 8:30 AM, Clive Gould wrote:
<blockquote type="cite">
<div>Hi Diva</div>
<div> </div>
<div>Looking at the new table structure shown in the diagram on the Wiki it appears to bear little resemblance to the table structure on my fresh install of opensim.0.7.0.2 standalone taken from git head this morning</div>
<div> </div>
<div>Am I missing something here???</div>
<div> </div>
<div>Thanks</div>
<div> </div>
<div>Clive</div>
<div> </div>
<div><font face="courier new,monospace">mysql> show tables;<br>+-------------------+<br>| Tables_in_opensim |<br>+-------------------+<br>| Avatars |<br>| Friends |<br>| GridUser |<br>| UserAccounts |<br>
| assets |<br>| auth |<br>| estate_groups |<br>| estate_managers |<br>| estate_map |<br>| estate_settings |<br>| estate_users |<br>| estateban |<br>| inventoryfolders |<br>
| inventoryitems |<br>| land |<br>| landaccesslist |<br>| migrations |<br>| primitems |<br>| prims |<br>| primshapes |<br>| regionban |<br>| regions |<br>
| regionsettings |<br>| regionwindlight |<br>| terrain |<br>| tokens |<br>+-------------------+<br>26 rows in set (0.00 sec)<br></font></div>
<div> </div>
<div> </div>
<div class="gmail_quote">On Fri, Mar 11, 2011 at 3:53 PM, Diva Canto <span dir="ltr"><<a href="mailto:diva@metaverseink.com" target="_blank">diva@metaverseink.com</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT: rgb(204,204,204) 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">
<div text="#000000" bgcolor="#ffffff">The release notes describe the database changes:<br><a href="http://opensimulator.org/wiki/0.7_Release" target="_blank">http://opensimulator.org/wiki/0.7_Release</a>
<div>
<div><br><br>On 3/11/2011 7:43 AM, Clive Gould wrote: </div></div>
<blockquote type="cite">
<div>
<div>
<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></div></div><pre><fieldset></fieldset>
_______________________________________________
Opensim-users mailing list
<div><a href="mailto:Opensim-users@lists.berlios.de" target="_blank">Opensim-users@lists.berlios.de</a>
<a href="https://lists.berlios.de/mailman/listinfo/opensim-users" target="_blank">https://lists.berlios.de/mailman/listinfo/opensim-users</a>
</div></pre></blockquote><br></div></blockquote></div><br></blockquote><br></div></div></div></blockquote></div><br>