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

[Diva Canto]

I don't see any differences besides capitalization, which works 
differently in linux and Windows.

On 3/11/2011 8:30 AM, Clive Gould wrote:
> 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 
> <mailto: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.de
>>     <mailto:Opensim-users at lists.berlios.de>
>>     https://lists.berlios.de/mailman/listinfo/opensim-users
>
>

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