aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MSSQL (unfollow)
Commit message (Collapse)AuthorFilesLines
2009-10-05Adapt to renamed members in landObjectMelanie1-10/+10
2009-10-05MSSQL changes for Grid server in ROBUST plus some code tweaks 'n tidy upunknown5-1456/+1776
2009-10-04* MySQL data tests now pass by fixing a bad fix for a bad cast on the asset ↵John Hurliman4-19/+3
Local member in MySQLAssetData * First pass at applying the using(){} pattern to IDisposable objects. Always use the using pattern on IDisposable objects whenever possible, do not manually call .Close() or .Dispose() unless there is no other way to write the code. This pass mostly covers OpenSim.Data.MySQL, and should have no functional change (tests still pass)
2009-10-02- cleaning up LandData/ILandObject capitalization issuesdr scofield (aka dirk husemann)1-4/+4
- adding LandDataSerializer to OAR mechanics
2009-10-01Formatting cleanup.Jeff Ames5-8/+8
2009-09-29Add copyright header. Formatting cleanup.Jeff Ames2-2/+2
2009-09-06Thank you, StrawberryFride, for a hit-and-run patch to add authenticationMelanie3-0/+413
and user services to MSSQL
2009-09-03MSSQL Minor tweak to recent patch for region loading (Thanks Grumly57 for ↵Chris Hart1-0/+1
spotting it!)
2009-09-02MSSQL patch to mirror mantis 4077 for MySQL to improve region load timesChris Hart1-24/+38
2009-08-19Fixing a spot I missed in assets. Switching Grid to the new naming schema ↵Kunnis1-15/+12
with Store/Get
2009-08-19* Switching IAssetData to follow the new naming schema, removing the ↵Kunnis1-5/+14
separate insert and update methods.
2009-08-07* Remove hard coded 256 limitations from various places. There's no more ↵Teravus Ovares (Dan Olivares)1-6/+6
256m limitation within the OpenSimulator framework, however, the LLClient ClientView does not support regions larger then 256 meters so, if you try and make your region larger by setting Constants.RegionSize = 512; in OpenSim.Framework.Constants.cs, the terrain will not display on clients using the LLUDP protocol
2009-07-25* Updates libOMV to version 0.7.0Teravus Ovares1-2/+2
* Uses mantis #3811 as a base (thanks jhuliman) with changes. * E-mail regarding interface changes sent to the opensim-dev list * Archive: https://lists.berlios.de/pipermail/opensim-dev/2009-July/007219.html
2009-07-24* minor: spacing adjustment to retrigger pandaJustin Clarke Casey1-2/+1
2009-07-24* Extend mssql name string size checking to create/update folderJustin Clarke Casey1-3/+18
2009-07-24* Extend inventory name and description length checks to UpdateItem for mssqlJustin Clarke Casey1-2/+20
2009-07-24* Correct minor bug where item description bounded string was not actually ↵Justin Clarke Casey1-1/+2
being used in the previous patches.
2009-07-24* Apply similar bounds checks on name and description fields on MSSQL ↵Justin Clarke Casey1-6/+25
UpdateAsset
2009-07-24* Apply http://opensimulator.org/mantis/view.php?id=3902Justin Clarke Casey2-6/+36
* Restrict asset and inventory name descriptions so as not to overflow MSSQL field lengths * Thanks StrawberryFride
2009-07-09Thank you, StrawberryFride, for a patch to fix MSSQL parameter naming.Melanie Thielker1-2/+2
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 Dague2-14/+12
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-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-01Minor: Change OpenSim to OpenSimulator in older copyright headers and ↵Jeff Ames10-10/+10
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-25* Upped version number to 0.6.5lbsa711-2/+2
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-04-13* Some more experimental work on distributed assets. Nothing hotwired yet.lbsa711-39/+39
* 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-08* Make it possible to store creator strings in user inventory items as well ↵Justin Clarke Casey1-13/+14
as UUIDs * All existing functionality should be unaffected. * Database schemas have not been changed.
2009-04-05Thanks StrawberryFride for a MSSQL patch to mirror r9011.Homer Horwitz1-0/+1
Fixes Mantis #3409
2009-04-01* Upped trunk version number to 0.6.4 as we just tagged 0.6.4-releaselbsa711-1/+1
2009-03-31Thank you, StrawberryFride, for a patch that adds offline inventoryMelanie Thielker1-2/+15
functionality to the MSSQL module. Fixes Mantis #3370
2009-03-27* This updates LibOMV to the current release 0.6.0 on March 19 2009Teravus Ovares1-1/+1
* Important: HttpServer.dll was changed to HttpServer_OpenSim.dll so that the HttpServer references do not conflict if you've copied the OpenMetaverse.Http.dll and requirements to the OpenSimulator bin folder. This means that if you reference HttpServer.dll in any projects, you will need to change the reference to HttpServer_OpenSim.dll. It still uses the Same HttpServer namespace though.
2009-03-23Committing partial work on passing folders across instances. This may crash.Melanie Thielker1-0/+5
2009-03-21Add a QueryItem method to the inventory subsystem. Currently implemented forMelanie Thielker1-0/+5
MySQL only, stubs for the others. This allows updating the cache with a single item from the database.
2009-03-09* Apply http://opensimulator.org/mantis/view.php?id=3280Justin Clarke Casey2-43/+44
* Some small syntax and refactoring tweaks for asset and inventory MSSQL * This means the MSSQL db plugin now requires SQL Server 2005
2009-03-09Implemented FetchAssetMetadataSet in DB backends.Mike Mazur1-0/+36
This method fetches metadata for a subset of the entries in the assets database. This functionality is used in the ForEach calls in the asset storage providers in AssetInventoryServer. With this implemented, frontends such as the BrowseFrontend should now work. - MySQL: implemented, sanity tested - SQLite: implemented, sanity tested - MSSQL: implemented, not tested - NHibernate: not implemented
2009-02-25* Refactored SOP.FolderID weirdness by removing calls to empty setter. YEs, ↵lbsa711-4/+1
I do realize the setter has to be there for legacy reasons, but since the calls will never acually DO anyhting, I'm removing them. * So, SOP.FolderID is actually a cruft field that should be removed.
2009-02-22Mantis#3218. Thank you kindly, TLaukkan (Tommil) for a patch that:Charles Krinke1-2/+1
* Added log4net dependency to physxplugin in prebuild.xml. * Added missing m_log fields to classes. * Replaced Console.WriteLine with appropriate m_log.Xxxx * Tested that nant test target runs succesfully. * Tested that local opensim sandbox starts up without errors.
2009-02-21* Applied a patch that: Added estate ban table to migration scripts and ↵lbsa711-4/+4
nhibernate mapping. Refactored property getters and setters for estate ban object to support NHibernate. * Added estate ban table to migration scripts of all supported databases. * Added nhibernate mapping for EstateBans property of EstateSettings * Refactored property accessors for EstateBan object. * Added comments for EstateBan properties. * Ensured that NHibernate tests pass with NUnitGUI. * Ensured that nant test target passes. This fixes mantis #3210. Thank you, tlaukkan!
2009-02-20* Upped VersionInfo to 0.6.3 and in the process, changed assemblyinfo to ↵lbsa711-3/+3
0.6.3.* to better track down dll ref and overwrite problems.
2009-02-19* Apply http://opensimulator.org/mantis/view.php?id=3142Justin Clarke Casey30-180/+1125
* Changes varchar(36) columns to UUID type in MSSQL - this will be much more efficient * ===As always, please, please backup your database before applying this patch=== * Thanks Ruud Lathrop (for the patch) and StrawberryFride (for the review)
2009-02-17- remove the Metadata property from AssetBase and return all previousMike Mazur1-20/+20
properties as before - prefix private variables with m_ in AssetBase.cs - related to Mantis #3122, as mentioned in https://lists.berlios.de/pipermail/opensim-dev/2009-February/005088.html - all services will likely need to be upgraded after this commit
2009-02-16- remove dependency on OpenSim.Grid.AssetServer.Plugins.Opensim inMike Mazur1-1/+0
OpenSim.Data.*.addin.xml, this is cruft left over from previous testing - fix example SQLite connection string in AssetInventoryServer.ini.example
2009-02-16- add OpenSim.Grid.AssetServer.Plugins.OpenSim as a dependency for ↵Mike Mazur1-0/+1
OpenSim.Data.*.addin.xml - remove OpenSim.Grid.NewAssetServer.exe from bin/OpenSim.Data.addin.xml - add prebuild.xml section for OpenSim.Grid.AssetServer.Plugins.OpenSim.dll
2009-02-12* optimized usings.lbsa719-14/+12