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

[Clive Gould]

Hi Diva

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

Am I missing something here???

Thanks

Clive

mysql> show tables;
+-------------------+
| Tables_in_opensim |
+-------------------+
| Avatars           |
| Friends           |
| GridUser          |
| UserAccounts      |
| assets            |
| auth              |
| estate_groups     |
| estate_managers   |
| estate_map        |
| estate_settings   |
| estate_users      |
| estateban         |
| inventoryfolders  |
| inventoryitems    |
| land              |
| landaccesslist    |
| migrations        |
| primitems         |
| prims             |
| primshapes        |
| regionban         |
| regions           |
| regionsettings    |
| regionwindlight   |
| terrain           |
| tokens            |
+-------------------+
26 rows in set (0.00 sec)


On Fri, Mar 11, 2011 at 3:53 PM, Diva Canto <diva at metaverseink.com> wrote:

> The release notes describe the database changes:
> http://opensimulator.org/wiki/0.7_Release
>
>
> On 3/11/2011 7:43 AM, Clive Gould wrote:
>
>   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
>
>
>
>
>
>
>
> _______________________________________________
> Opensim-users mailing list
> Opensim-users at lists.berlios.dehttps://lists.berlios.de/mailman/listinfo/opensim-users
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://opensimulator.org/pipermail/opensim-users/attachments/20110311/325c7470/attachment.html>