aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MSSQL (follow)
Commit message (Collapse)AuthorAgeFilesLines
* Thank you, StrawberryFride, for a patch to fix MSSQL parameter naming.Melanie Thielker2009-07-091-2/+2
|
* 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-292-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.
* Formatting cleanup, ignore some generated files.Jeff Ames2009-06-221-1/+1
|
* 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.
* Minor: Change OpenSim to OpenSimulator in older copyright headers and ↵Jeff Ames2009-06-0110-10/+10
| | | | 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.
* * Upped version number to 0.6.5lbsa712009-05-251-2/+2
|
* 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.
* * Some more experimental work on distributed assets. Nothing hotwired yet.lbsa712009-04-131-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)
* * Make it possible to store creator strings in user inventory items as well ↵Justin Clarke Casey2009-04-081-13/+14
| | | | | | | | | as UUIDs * All existing functionality should be unaffected. * Database schemas have not been changed.
* Thanks StrawberryFride for a MSSQL patch to mirror r9011.Homer Horwitz2009-04-051-0/+1
| | | | | Fixes Mantis #3409
* * Upped trunk version number to 0.6.4 as we just tagged 0.6.4-releaselbsa712009-04-011-1/+1
|
* Thank you, StrawberryFride, for a patch that adds offline inventoryMelanie Thielker2009-03-311-2/+15
| | | | | | | functionality to the MSSQL module. Fixes Mantis #3370
* * This updates LibOMV to the current release 0.6.0 on March 19 2009Teravus Ovares2009-03-271-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.
* Committing partial work on passing folders across instances. This may crash.Melanie Thielker2009-03-231-0/+5
|
* Add a QueryItem method to the inventory subsystem. Currently implemented forMelanie Thielker2009-03-211-0/+5
| | | | | | | MySQL only, stubs for the others. This allows updating the cache with a single item from the database.
* * Apply http://opensimulator.org/mantis/view.php?id=3280Justin Clarke Casey2009-03-092-43/+44
| | | | | | | * Some small syntax and refactoring tweaks for asset and inventory MSSQL * This means the MSSQL db plugin now requires SQL Server 2005
* Implemented FetchAssetMetadataSet in DB backends.Mike Mazur2009-03-091-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
* * Refactored SOP.FolderID weirdness by removing calls to empty setter. YEs, ↵lbsa712009-02-251-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.
* Mantis#3218. Thank you kindly, TLaukkan (Tommil) for a patch that:Charles Krinke2009-02-221-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.
* * Applied a patch that: Added estate ban table to migration scripts and ↵lbsa712009-02-211-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!
* * Upped VersionInfo to 0.6.3 and in the process, changed assemblyinfo to ↵lbsa712009-02-201-3/+3
| | | | 0.6.3.* to better track down dll ref and overwrite problems.
* * Apply http://opensimulator.org/mantis/view.php?id=3142Justin Clarke Casey2009-02-1930-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)
* - remove the Metadata property from AssetBase and return all previousMike Mazur2009-02-171-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
* - remove dependency on OpenSim.Grid.AssetServer.Plugins.Opensim inMike Mazur2009-02-161-1/+0
| | | | | | | | OpenSim.Data.*.addin.xml, this is cruft left over from previous testing - fix example SQLite connection string in AssetInventoryServer.ini.example
* - add OpenSim.Grid.AssetServer.Plugins.OpenSim as a dependency for ↵Mike Mazur2009-02-161-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
* * optimized usings.lbsa712009-02-129-14/+12
|
* This changeset is the step 1 of 2 in refactoringDr Scofield2009-02-062-3/+3
| | | | | | | | | | | | | | | | | | | | OpenSim.Region.Environment into a "framework" part and a modules only part. This first changeset refactors OpenSim.Region.Environment.Scenes, OpenSim.Region.Environment.Interfaces, and OpenSim.Region.Interfaces into OpenSim.Region.Framework.{Interfaces,Scenes} leaving only region modules in OpenSim.Region.Environment. The next step will be to move region modules up from OpenSim.Region.Environment.Modules to OpenSim.Region.CoreModules and then sort out which modules are really core modules and which should move out to forge. I've been very careful to NOT BREAK anything. i hope i've succeeded. as this is the work of a whole week i hope i managed to keep track with the applied patches of the last week --- could any of you that did check in stuff have a look at whether it survived? thx!
* - add OpenSim.Framework.AssetMetadata class. AssetBase is now composed of itMike Mazur2009-02-041-20/+20
| | | | | - trim trailing whitespace
* - move IAssetDataPlugin from OpenSim/Framework/IAssetProvider.cs toMike Mazur2009-02-031-2/+2
| | | | | | OpenSim/Data/IAssetData.cs - remove some trailing whitespace
* Rename IAssetProviderPlugin to IAssetDataPlugin aligning with the other data ↵Mike Mazur2009-02-031-1/+1
| | | | plugins.
* * If an orphaned group is found in the mysql or mssql databases (i.e. there ↵Justin Clarke Casey2009-01-291-12/+21
| | | | | | | | | | | | is no prim where UUID = SceneGroupID), then force one prim to have UUID = SceneGroupID. * A warning is posted about this on startup giving the location of the object * This should allow one class of persistently undeletable prims to be removed * This change should not cause any issues, but I still suggest that you backup your database beforehand * If this doesn't work for previously linked objects, then you could also try the workaround in http://opensimulator.org/mantis/view.php?id=3059 * This change has been made to mysql and mssql, but sqlite appears to work in a different way
* * Remove unused prims.ParentID field from SQLite and MySQLJustin Clarke Casey2009-01-191-2/+0
| | | | | | | * Since this is a db change, as always I strongly recommend that you backup your database before updating to this revision * Haven't touched MSSQL in case I get it wrong - looking for some kind soul to take care of this.
* * Apply http://opensimulator.org/mantis/view.php?id=2995Justin Clarke Casey2009-01-141-2/+2
| | | | | | | * This fixes MSSQL for user friends lookups * Thanks StrawberryFride
* * Apply http://opensimulator.org/mantis/view.php?id=2965Justin Clarke Casey2009-01-121-0/+1
| | | | | | | * Adds first version of MsSql2005Dialect support for NHibernate * Thanks mpallari
* * Apply http://opensimulator.org/mantis/view.php?id=2980Justin Clarke Casey2009-01-121-0/+4
| | | | | | | | * Add single conversion to MSSQLManager.DbTypeFromType * May resolve storage of prim information under MSSQL * Thanks SirKimba
* Update svn properties, minor formatting cleanup.Jeff Ames2009-01-081-5/+5
|
* Thank you kindly, StrawberryFride for a patch that:Charles Krinke2009-01-073-629/+592
| | | | | | | Solves the problem of unable to load prim items on region start in MSSQL. The error was in the MSSQLRegionData code that loads objects from the database, due to reliance on the ParentID field that is not used.
* * Stop bothering to populate and retrieve the parent local ids for MSSQL, as ↵Justin Clarke Casey2009-01-051-2/+0
| | | | | | | | was done for SQLite and MySQL in r7586 * This may resolve http://opensimulator.org/mantis/view.php?id=2939
* Thank you kindly, StrawberryFride for a patch that:Charles Krinke2008-12-281-1/+6
| | | | | Persists appearance with MSSQL more properly.
* Mantis#2881. Thank you kindly, SirKimba for a patch that:Charles Krinke2008-12-201-5/+5
| | | | | | | | Solves inserting Wolrdparameters in SQL Database with OpenSim.Data.MSSQL.dll always crash cause there were missing some fields in the Insert-String
* Mantis#2730. Thank you kindly, StrawberryFride for a patch that:Charles Krinke2008-12-011-2/+2
| | | | | | | | MSSQL Fix to accommodate random ParentIDs. uint values now cleanly converted to ints and vice versa to hopefully prevent outofrange exceptions on prim storage.
* * Remove unused and largely unimplemented UpdateUserCurrentRegion()Justin Clarke Casey2008-11-271-11/+0
| | | | | | * please say if this causes you a problem
* Plumb in the presence notifications and region shutdown/restart messagesMelanie Thielker2008-11-231-0/+4
| | | | | | | | | from the presence module to the message server, through the user server and on into the database. This should fix the "Already logged in" issue that grids see after a sim crashes, or a user crashes out of a sim. Not yet a 100% solution for friends, but getting there.
* * Comment out unused access time method in MSSQLJustin Clarke Casey2008-11-211-18/+18
| | | | | | * This should probably be being called in FetchAsset() instead as for all the other databases, but I lack the means to test MSSQL
* * refactor: Rip out SOP inventory from the partial into a separate classJustin Clarke Casey2008-11-211-1/+1
| | | | | | | | * SceneObjectPartInventory.cs isn't a particularly good name but it's probably not got a long life * A proper inventory interface to follow * Parallel changes for other inventory partial classes to follow at a later date