Hi I've been comparing the OpenSim database tables before and after creating a user account.
There appear to be three tables affected when a new user is added: auth inventoryfolders UserAccounts 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. 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??? Suggestions most welcome. Clive On Fri, Mar 11, 2011 at 4:32 PM, Diva Canto <[email protected]> wrote: > 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 <[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]https://lists.berlios.de/mailman/listinfo/opensim-users >> >> >> > >
_______________________________________________ Opensim-users mailing list [email protected] https://lists.berlios.de/mailman/listinfo/opensim-users
