aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data (follow)
Commit message (Collapse)AuthorAgeFilesLines
* * Apply similar bounds checks on name and description fields on MSSQL ↵Justin Clarke Casey2009-07-241-6/+25
| | | | UpdateAsset
* * Apply http://opensimulator.org/mantis/view.php?id=3902Justin Clarke Casey2009-07-242-6/+36
| | | | | | | * Restrict asset and inventory name descriptions so as not to overflow MSSQL field lengths * Thanks StrawberryFride
* * Added a user friendly message to the sqlite regionsettings saver giving ↵Teravus Ovares2009-07-101-1/+17
| | | | | | | them troubleshooting options and telling them to restart the simulator. This situation, hopefully is temporary and generates an exception when sqlite users first start OpenSimulator because of an unexpected condition in the database layer. Restart and all is well. * Added a user friendly message to the 'No IInventoryService available' condition with troubleshooting options.
* Thank you, StrawberryFride, for a patch to fix MSSQL parameter naming.Melanie Thielker2009-07-091-2/+2
|
* From: Chris Yeoh <yeohc@au1.ibm.com>Sean Dague2009-06-301-1/+1
| | | | | | | Ooops, sorry there was a bug in the patch and causes an exception on some system (I think it only happens on windows since it didn't occur during my testin). I've attached a one liner which fixes the problem.
* Thanks StrawberryFride, for a patch that fixes MSSQL migration:Arthur Valadares2009-06-291-3/+3
| | | | | Minor tweak to a region migration SQL script for the OAR DateTime field - SQL Server syntax slightly different from MySQL (and there is no unsigned in MSSQL, sadly)
* From: Chris Yeoh <yeohc@au1.ibm.com>Sean Dague2009-06-294-27/+23
| | | | | | | | Attached is a patch that changes the oar file saving of creation date/time to an integer instead of a string. I did this after justincc emailed me saying there is a problem with internationalisation doing it the old way and I said I'd fix it. Its been tested with MySQL and I've made the changes for MSSQL but that hasn't been well tested.
* Formatting cleanup, ignore some generated files.Jeff Ames2009-06-221-1/+1
|
* more type clean fixes for mono 2.4.2Sean Dague2009-06-191-8/+8
|
* mono 2.4.2 seems a little more type strict, fix some sqlite tests to passSean Dague2009-06-181-2/+2
|
* Applied patch from Mantis #3817, which fixes a error when using MSSQL. I ↵MW2009-06-182-12/+0
| | | | don't use MSSQL so couldn't test this myself. But there was certainly duplicated instructions in these files...which this patch fixes. Thanks Grumly57
* Add the missing resource files for MSSQLMelanie Thielker2009-06-172-0/+24
| | | | | | Mantis #3800
* Fixes Mantis #3793 . Committing thomax/Snoopy's patch to allow deeding of ↵Melanie Thielker2009-06-144-68/+37
| | | | | | | | | | objects, with changes: - Set OwnerID = GroupID for deeded objects. - Close a security loophole that would have allowed a user with deed rights in a group to deed ANY object to that group, even if it's not owned by them and/or not set to that group - Set LastOwnerID correctly. Handle objects vs. prims correctly.
* Thank you kindly, BlueWall, for a patch that solves:Charles Krinke2009-06-101-9/+9
| | | | | SQLite error on creating user.
* Formatting cleanup.Jeff Ames2009-06-103-6/+6
|
* From: Chris Yeoh <yeohc@au1.ibm.com>Dr Scofield2009-06-032-2/+31
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | This patch adds oar file date and time (UTC) meta data to an oar file when it is created. It also adds a unique ID, though this id does not in anyway identify the machine that the oar file was created on. When an oar file with this meta data is loaded this extra information is saved with the region settings and available via LSL through: - osLoadedCreationDate() - osLoadedCreationTime() - osLoadedCreationID() If there is no meta data these fields will be blank. Subsequent oar file loads will erase the information for the previous oar file load. Persistence has only been implemented for MySQL, the other backends need updating. Overall this allows us to much more easily identify the specific version of software that clients are using. Its very straightforward to edit the oar file to change the ID string to be something more human friendly. Included in the patch is a new file OpenSim/Data/MySQL/Resources/030_RegionStore.sql required for the MySQL DB migration. btw I had a chat with justincc about this a few weeks ago since he wrote the oar file import/export and he sounded happy to accept something that included date/time information but didn't want anything that would silently leak private information like machine names.
* Minor: Change OpenSim to OpenSimulator in older copyright headers and ↵Jeff Ames2009-06-01103-103/+103
| | | | LICENSE.txt.
* Thank you kindly, StrawberryFride for a patch that:Charles Krinke2009-05-311-7/+50
| | | | | | | | | | | | Added in some key code to read properties from MSSQL for user profiles which fixes issues of users having trouble editing estate settings on a grid where estate managers are not god, and fixes the option of enabling grid god functionality on MSSQL grids. I have applied this to trunk only. I need someone else to examine and apply to 0.6.5-Post-Fixes, or give me some direction, please.
* From: Chris Yeoh <cyeoh@au1.ibm.com>Dr Scofield2009-05-272-2/+17
| | | | | | | | | | | | The attached patch implements llPassTouches. It has been added to the export/import XML along with the flag for AllowedInventoryDrop. The MySQL backend has been updated as well, though I haven't done one of those before so could do with a check. I added the migration mysql file as well. The other data backends need updating as well.
* * Upped version number to 0.6.5lbsa712009-05-255-10/+10
|
* Revert "From: Chris Yeoh <cyeoh@au1.ibm.com>"Dr Scofield2009-05-251-12/+2
| | | | | This reverts r9666. for some reason the mysql update does not work.
* From: Chris Yeoh <cyeoh@au1.ibm.com>Dr Scofield2009-05-251-2/+12
| | | | | | | | | | | | The attached patch implements llPassTouches. It has been added to the export/import XML along with the flag for AllowedInventoryDrop. The MySQL backend has been updated as well, though I haven't done one of those before so could do with a check. I added the migration mysql file as well. The other data backends need updating as well.
* Update svn properties.Jeff Ames2009-05-201-5/+5
|
* Thank you kindly, StrawberryFride, for a patch that:Charles Krinke2009-05-175-155/+168
| | | | | | | Adds maturity & access logic for MSSQL platform to mirror that of MySQL as committed in 9502.
* Update svn properties.Jeff Ames2009-05-171-5/+5
|
* * Change default sqlite asset db back to Asset.db instead of AssetStorage.dbJustin Clarke Casey2009-05-151-2/+2
| | | | | | | * This inconsistency has actually existed for some time but only the recent change brought it to light * In the past, the default in ConfigurationLoader took precedence over the one in SQLiteAssetData
* Thank you kindly, Patnad, for a patch that:Charles Krinke2009-05-124-5/+30
| | | | | | | | | This is to handle the changes in the v1.23 viewer of LL regarding the adult rating. With this patch a region can be changed to the adult rating from LL viewer v1.23 and above.
* WARNING: contains migrationSean Dague2009-05-081-0/+7
| | | | | Since creatorID is no longer treated as a UUID type in the code from the database we need to make sure that it isn't null in the database. This updates all empty string and null values for this column to the Zero UUID, and makes the column a not null definition with a default fo the Zero UUID.
* now that creatorID is no longer a strict UUID, and the column can still be NULL,Sean Dague2009-05-081-1/+10
| | | | | | we lost protection from NULL strings. This puts some protection in for that case. This may address many of the inventory issues that are being seen intermitently.
* * Consistently used dashed uuid format for mysql region data, as is done for ↵Justin Clarke Casey2009-05-072-29/+105
| | | | | | | | | | all other tables * This revision contains a mysql data migration. Please backup your mysql region database as a precaution before using this code. * I also advise that you do a runprebuild[.sh|.bat] and a clean build ("nant clean build" if you're using the command line). * This change is needed for future id schemes
* * Consistently use dashed uuid format for sqlite region data, as was ↵Justin Clarke Casey2009-05-072-38/+114
| | | | | | | | | | | previously done for sqlite inventory data. * This revision contains a data migration. Please backup your sqlite region db as a precaution before using this code * I also advise that you do a runprebuild[.sh|.bat] and a clean build ("nant clean build" if you're using the command line). * This change is needed for future id schemes
* * minor: remove some mono compiler warningsJustin Clarke Casey2009-04-291-5/+0
|
* Thanks, Ewe Loon for a patch thatHomer Horwitz2009-04-252-15/+278
| | | | | | provides persistent AvatarAppearance for SQLite. Fixes Mantis #3296.
* silly C# not letting me use a File.Exists test for a directory. Don'tSean Dague2009-04-245-5/+5
| | | | | you know a directory is just a special kind of file on Linux.
* change power linux detection method, the previous method only workedSean Dague2009-04-245-10/+10
| | | | | with interactive logins, not under panda.
* * Allow interested user data plugins to store temporary user profilesJustin Clarke Casey2009-04-232-2/+15
| | | | | | * Database and the OGS1 plugins are not interested and hence ignore these calls
* * Resolve http://opensimulator.org/mantis/view.php?id=3509 by putting some ↵Justin Clarke Casey2009-04-221-1/+2
| | | | | | | | service initialization into CommsManager * What is really needed is a plugin and interface request system as being done for region modules
* * Allow plugins to play nicely in UserManagerBaseJustin Clarke Casey2009-04-221-1/+1
| | | | | | | * Some methods were returning the value of the first plugin queried, even if the return was null * Other methods are probably best off querying more than one plugin and aggregating results
* add if exists to the drop tableSean Dague2009-04-222-30/+30
|
* add cleardb to estate testsSean Dague2009-04-221-16/+24
|
* ensure we've got a clean data environment prior to running the regionSean Dague2009-04-221-17/+24
| | | | | tests
* * Fission OGS1UserServices into user service and OGS1 user data plugin ↵Justin Clarke Casey2009-04-222-2/+12
| | | | | | | | | components * Make OGS1UserServices inherit from UserManagerBase * This allows grid mode regions to use the same user data plugin infrastructure as grid servers and standalone OpenSims
* make the asserts spit out messages about their test namesSean Dague2009-04-135-378/+378
|
* * Some more experimental work on distributed assets. Nothing hotwired yet.lbsa712009-04-135-59/+70
| | | | | | | | | * Introduced preprocess step in FetchAsset (Might revert this later) * Some minor CCC * Added actual implementation of GetUserProfile( uri ) and the corresponding handler to OGS1. * Introduced non-functioning GetUserUri( userProfile) awaiting user server wireup (this might move elsewhere)
* * Apply http://opensimulator.org/mantis/view.php?id=3439Justin Clarke Casey2009-04-103-11/+11
| | | | | | | * This corrects problems seen on some SQLite systems where the migration fails because the two argument substr() isn't implemented * Thanks RemedyTomm!
* * minor: correct some documentation in SQLiteAssetData.csJustin Clarke Casey2009-04-091-8/+2
|
* * Change SQLite asset UUID to dashed format to be consistentJustin Clarke Casey2009-04-092-6/+13
| | | | | | | * Remaining inconsistent uuids (non dashed) are in region store for sqlite and mysql * Migration of these will happen at a later date, unless someone else wants to do it
* * Change UUIDs in SQLite user db to dashed format to match representations ↵Justin Clarke Casey2009-04-093-11/+22
| | | | elsewhere
* * Improve inventory uuid conversions to make sure that we aren't converting ↵Justin Clarke Casey2009-04-092-9/+30
| | | | | | | | anything that already contains a - * Among other things, this means that if a migration is interrupted, it can simply be retried
* * Migrate UUID representations in SQLite inventory store to dashed formatJustin Clarke Casey2009-04-092-28/+42
| | | | | | * This makes the representation consistent with that most commonly used in the other supported database layers