<!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">
I don't see any differences besides capitalization, which works
differently in linux and Windows.<br>
<br>
On 3/11/2011 8:30 AM, Clive Gould wrote:
<blockquote
cite="mid:AANLkTikukYG688OGzCvNeE6b0FA0rZLyoGjiiJPzVVxC@mail.gmail.com"
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 moz-do-not-send="true"
href="mailto:diva@metaverseink.com">diva@metaverseink.com</a>></span>
wrote:<br>
<blockquote style="border-left: 1px solid rgb(204, 204, 204);
margin: 0px 0px 0px 0.8ex; padding-left: 1ex;"
class="gmail_quote">
<div bgcolor="#ffffff" text="#000000">The release notes
describe the database changes:<br>
<a moz-do-not-send="true"
href="http://opensimulator.org/wiki/0.7_Release"
target="_blank">http://opensimulator.org/wiki/0.7_Release</a>
<div>
<div class="h5"><br>
<br>
On 3/11/2011 7:43 AM, Clive Gould wrote: </div>
</div>
<blockquote type="cite">
<div>
<div class="h5">
<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 class="im"><a moz-do-not-send="true" href="mailto:Opensim-users@lists.berlios.de" target="_blank">Opensim-users@lists.berlios.de</a>
<a moz-do-not-send="true" 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>
</body>
</html>