aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data (unfollow)
Commit message (Collapse)AuthorFilesLines
2009-07-09Thank you, StrawberryFride, for a patch to fix MSSQL parameter naming.Melanie Thielker1-2/+2
2009-06-30From: Chris Yeoh <yeohc@au1.ibm.com>Sean Dague1-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.
2009-06-29Thanks StrawberryFride, for a patch that fixes MSSQL migration:Arthur Valadares1-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)
2009-06-29From: Chris Yeoh <yeohc@au1.ibm.com>Sean Dague4-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.
2009-06-22Formatting cleanup, ignore some generated files.Jeff Ames1-1/+1
2009-06-19more type clean fixes for mono 2.4.2Sean Dague1-8/+8
2009-06-18mono 2.4.2 seems a little more type strict, fix some sqlite tests to passSean Dague1-2/+2
2009-06-18Applied patch from Mantis #3817, which fixes a error when using MSSQL. I ↵MW2-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
2009-06-17Add the missing resource files for MSSQLMelanie Thielker2-0/+24
Mantis #3800
2009-06-14Fixes Mantis #3793 . Committing thomax/Snoopy's patch to allow deeding of ↵Melanie Thielker4-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.
2009-06-10Thank you kindly, BlueWall, for a patch that solves:Charles Krinke1-9/+9
SQLite error on creating user.
2009-06-10Formatting cleanup.Jeff Ames3-6/+6
2009-06-03From: Chris Yeoh <yeohc@au1.ibm.com>Dr Scofield2-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.
2009-06-01Minor: Change OpenSim to OpenSimulator in older copyright headers and ↵Jeff Ames103-103/+103
LICENSE.txt.
2009-05-31Thank you kindly, StrawberryFride for a patch that:Charles Krinke1-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.
2009-05-27From: Chris Yeoh <cyeoh@au1.ibm.com>Dr Scofield2-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.
2009-05-25* Upped version number to 0.6.5lbsa715-10/+10
2009-05-25Revert "From: Chris Yeoh <cyeoh@au1.ibm.com>"Dr Scofield1-12/+2
This reverts r9666. for some reason the mysql update does not work.
2009-05-25From: Chris Yeoh <cyeoh@au1.ibm.com>Dr Scofield1-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.
2009-05-20Update svn properties.Jeff Ames1-5/+5
2009-05-17Thank you kindly, StrawberryFride, for a patch that:Charles Krinke5-155/+168
Adds maturity & access logic for MSSQL platform to mirror that of MySQL as committed in 9502.
2009-05-17Update svn properties.Jeff Ames1-5/+5
2009-05-15* Change default sqlite asset db back to Asset.db instead of AssetStorage.dbJustin Clarke Casey1-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
2009-05-12Thank you kindly, Patnad, for a patch that:Charles Krinke4-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.
2009-05-08WARNING: contains migrationSean Dague1-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.
2009-05-08now that creatorID is no longer a strict UUID, and the column can still be NULL,Sean Dague1-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.
2009-05-07* Consistently used dashed uuid format for mysql region data, as is done for ↵Justin Clarke Casey2-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
2009-05-07* Consistently use dashed uuid format for sqlite region data, as was ↵Justin Clarke Casey2-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
2009-04-29* minor: remove some mono compiler warningsJustin Clarke Casey1-5/+0
2009-04-25Thanks, Ewe Loon for a patch thatHomer Horwitz2-15/+278
provides persistent AvatarAppearance for SQLite. Fixes Mantis #3296.
2009-04-24silly C# not letting me use a File.Exists test for a directory. Don'tSean Dague5-5/+5
you know a directory is just a special kind of file on Linux.
2009-04-24change power linux detection method, the previous method only workedSean Dague5-10/+10
with interactive logins, not under panda.
2009-04-23* Allow interested user data plugins to store temporary user profilesJustin Clarke Casey2-2/+15
* Database and the OGS1 plugins are not interested and hence ignore these calls
2009-04-22* Resolve http://opensimulator.org/mantis/view.php?id=3509 by putting some ↵Justin Clarke Casey1-1/+2
service initialization into CommsManager * What is really needed is a plugin and interface request system as being done for region modules
2009-04-22* Allow plugins to play nicely in UserManagerBaseJustin Clarke Casey1-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
2009-04-22add if exists to the drop tableSean Dague2-30/+30
2009-04-22add cleardb to estate testsSean Dague1-16/+24
2009-04-22ensure we've got a clean data environment prior to running the regionSean Dague1-17/+24
tests
2009-04-22* Fission OGS1UserServices into user service and OGS1 user data plugin ↵Justin Clarke Casey2-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
2009-04-13make the asserts spit out messages about their test namesSean Dague5-378/+378
2009-04-13* Some more experimental work on distributed assets. Nothing hotwired yet.lbsa715-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)
2009-04-10* Apply http://opensimulator.org/mantis/view.php?id=3439Justin Clarke Casey3-11/+11
* This corrects problems seen on some SQLite systems where the migration fails because the two argument substr() isn't implemented * Thanks RemedyTomm!
2009-04-09* minor: correct some documentation in SQLiteAssetData.csJustin Clarke Casey1-8/+2
2009-04-09* Change SQLite asset UUID to dashed format to be consistentJustin Clarke Casey2-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
2009-04-09* Change UUIDs in SQLite user db to dashed format to match representations ↵Justin Clarke Casey3-11/+22
elsewhere
2009-04-09* Improve inventory uuid conversions to make sure that we aren't converting ↵Justin Clarke Casey2-9/+30
anything that already contains a - * Among other things, this means that if a migration is interrupted, it can simply be retried
2009-04-09* Migrate UUID representations in SQLite inventory store to dashed formatJustin Clarke Casey2-28/+42
* This makes the representation consistent with that most commonly used in the other supported database layers
2009-04-09* Moved the DatabaseTestAttribute to Test.Common, and thus included ref to ↵lbsa7136-17/+35
that in all db tests. *phew*
2009-04-09* Thank you, mpallari for a patch that updates NHibernate inventory base ↵lbsa711-1/+1
mapping. This fixes mantis #3435
2009-04-09* tagged some more database tests as suchlbsa715-5/+5