aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MSSQL/MSSQLRegionData.cs (unfollow)
Commit message (Collapse)AuthorFilesLines
2009-10-05MSSQL changes for Grid server in ROBUST plus some code tweaks 'n tidy upunknown1-1418/+198
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 Ames1-1/+1
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-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-09Thank you, StrawberryFride, for a patch to fix MSSQL parameter naming.Melanie Thielker1-2/+2
2009-06-29From: Chris Yeoh <yeohc@au1.ibm.com>Sean Dague1-14/+5
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-14Fixes Mantis #3793 . Committing thomax/Snoopy's patch to allow deeding of ↵Melanie Thielker1-7/+31
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 Ames1-1/+1
LICENSE.txt.
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-19* Apply http://opensimulator.org/mantis/view.php?id=3142Justin Clarke Casey1-51/+54
* 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-12* optimized usings.lbsa711-1/+1
2009-02-06This changeset is the step 1 of 2 in refactoringDr Scofield1-2/+2
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!
2009-01-29* If an orphaned group is found in the mysql or mssql databases (i.e. there ↵Justin Clarke Casey1-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
2009-01-19* Remove unused prims.ParentID field from SQLite and MySQLJustin Clarke Casey1-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.
2009-01-12* Apply http://opensimulator.org/mantis/view.php?id=2965Justin Clarke Casey1-0/+1
* Adds first version of MsSql2005Dialect support for NHibernate * Thanks mpallari
2009-01-07Thank you kindly, StrawberryFride for a patch that:Charles Krinke1-628/+573
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.
2009-01-05* Stop bothering to populate and retrieve the parent local ids for MSSQL, as ↵Justin Clarke Casey1-2/+0
was done for SQLite and MySQL in r7586 * This may resolve http://opensimulator.org/mantis/view.php?id=2939
2008-12-20Mantis#2881. Thank you kindly, SirKimba for a patch that:Charles Krinke1-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
2008-12-01Mantis#2730. Thank you kindly, StrawberryFride for a patch that:Charles Krinke1-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.
2008-11-21* refactor: Rip out SOP inventory from the partial into a separate classJustin Clarke Casey1-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
2008-11-19Mantis#2658. Thank you kindly, StrawberryFride for a patch that:Charles Krinke1-0/+6
Keeping up with MySQL and SQLite. Small code changes and another resource file to add.
2008-11-19Mantis#2657. Thank you kindly, StrawberryFride for a patch that:Charles Krinke1-52/+30
Added access_time and create_time, plus the new sun position data to MSSQL code.
2008-11-15Mantis#2626: Thank you Ruud Lathrop, for a patch that cleans up MSSQL code.Homer Horwitz1-1/+1
2008-11-15Mantis#2552: Thanks idb, for a patch that fixes persistence of physical prims.Homer Horwitz1-2/+1
(added a fix for the broken build from last commit, too)
2008-11-10* refactor: Expose SOG.SetRootPart for outsiders to use rather than setting ↵Justin Clarke Casey1-2/+2
RootPart and adding the part separately * Make RootPart read only
2008-10-27Thank you kindly, Ruud Lathrop for a patch that solves:Charles Krinke1-156/+181
Primary Key violation when just linked a lot of prims using MSSQL.
2008-10-18Thank you, Strawberry Fride, for a patch that brings MSSQL even with MySQLMelanie Thielker1-31/+35
2008-10-15* minor: comment out persisting prim inventory log messagesJustin Clarke Casey1-1/+1
2008-09-29* Apply http://opensimulator.org/mantis/view.php?id=2295Justin Clarke Casey1-46/+51
* Updated MSSQL to reflect resend changes * Added the new columns in prims table. * Created a implementation for getting gestures. * Remove configurable table names for user. * Thanks Ruud Lathorp
2008-09-26* Patch from JHurlimanTeravus Ovares1-2/+2
* Updates to libomv r2243, * Remove lots of unnecessary typecasts * Improves SendWindData() Thanks jhurliman. * Will update OpenSim-libs in 10 minutes..
2008-09-18- Add Dispose method to IRegionDataStoreHomer Horwitz1-0/+5
- Add necessary dummy Dispose-methods where they are missing - Implement the SQLite Dispose-methods (currently only used for unit tests, in the next commit)
2008-09-14Mantis #2124Melanie Thielker1-102/+104
Thank you, RuudL, for a patch that brings MSSQL up to the same implementation level as MySQL.
2008-09-12* Make fix to MSSQLRegionData.cs in LoadLandObjects as recommended by ↵Justin Clarke Casey1-1/+1
Garrett Hussey in Re: [Opensim-dev] MSSQL runtime error in latest build.. * Thanks!
2008-09-09Update svn properties, formatting cleanup.Jeff Ames1-2/+2
2008-09-06* This is the fabled LibOMV update with all of the libOMV types from JHurlimanTeravus Ovares1-72/+72
* This is a HUGE OMG update and will definitely have unknown side effects.. so this is really only for the strong hearted at this point. Regular people should let the dust settle. * This has been tested to work with most basic functions. However.. make sure you back up 'everything' before using this. It's that big! * Essentially we're back at square 1 in the testing phase.. so lets identify things that broke.
2008-09-06* Blind fix what looks like a bug in the new land MSSQL codeJustin Clarke Casey1-1/+1
* The data returned from the db was never inserted in the list to be processed and return * This is an example where a warning has revealed a bug
2008-09-06* Remove lots of warnings from the CMS moduleJustin Clarke Casey1-1/+0
* Remove a few other miscellaneous warnings
2008-09-02Mantis #2102Melanie Thielker1-1/+2
Thank you, RuudL, for a patch that supplements the previous MSSQL patch.
2008-09-01Mantis #2095Melanie Thielker1-1362/+1048
Thank you, RuudL, for a complete adaptation of migration and estate data to MSSQL, and the updating of the RegionData handling in MSSQL.
2008-08-16* Rename *DataStore classes to *RegionData to align with SQLiteJustin Clarke Casey1-0/+0
2008-07-23refactor TaskInventoryItem Mask -> Permissions to be consistant with how thingsSean Dague1-10/+10
are stored in the db.
2008-07-23refactored LandData to use properties, and cleaned up the naming onSean Dague1-66/+66
the properties a bit to be more consistant with other objects (having things like .Name .Description, etc).
2008-07-18Introduce a separate connection string for estates, which defaults to the one giMelanie Thielker1-21/+1
ven for the region datastore. Removes the flag to store prim inventories, which are now always stored.
2008-07-18Patch #9151Melanie Thielker1-4/+4
Makes the estate dialog fully functional. Implements all client facing functionality. Moves estate data from estate_settings.xml, which is used to provide defaults, to the region data store. Creates one estate for each region, and places the region in it. Converts all region bans to estate bans.
2008-07-17Mantis#1736. Thank you kindly, StrawberryFride for a patch that:Charles Krinke1-1/+1
Many issues with handling connections in MSSQL, have rearchitected to ensure that connections are always opened and closed in a timely fashion & disposed of cleanly, and removed unnecessary lock statements. SQL Server performance seems to have improved considerably as a result, and various timeout errors seem to have been fixed.
2008-07-07change SitTarget calls from functions to propertiesSean Dague1-14/+15