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

Diva Canto Fri, 11 Mar 2011 08:33:20 -0800

I don't see any differences besides capitalization, which worksdifferently 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 itappears to bear little resemblance to the table structure on my freshinstall 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 <[email protected]<mailto:[email protected]>> 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
    [email protected]
    <mailto:[email protected]>
    https://lists.berlios.de/mailman/listinfo/opensim-users

_______________________________________________
Opensim-users mailing list
[email protected]
https://lists.berlios.de/mailman/listinfo/opensim-users

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

Reply via email to