aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MSSQL/MSSQLRegionData.cs (unfollow)
Commit message (Collapse)AuthorFilesLines
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
2008-06-29patch and files from mantis #1630, Thanks MelanieMW1-0/+9
2008-06-27last round of warning squashing. calling it a day now.Dr Scofield1-2/+2
2008-06-26Apply patch from bug #1609 -- Documentation for Data/MSSQL. Thanks ↵Jeff Ames1-4/+226
kerunix_Flan!
2008-06-26Mantis#1595. Thank you, Melanie for a patch that:Charles Krinke1-0/+3
Adds pipes for the prim item flags field
2008-06-21* Adds Region ban capability to Regions. You access this by going to ↵Teravus Ovares1-0/+16
World->Region/Estate. Then on the Estate tab, at the lower right hand corner, clicking the 'Add' button and picking an avatar. * It only persists across reboots for the mySQL datastore currently. * Currently have stubs in the other datastores.
2008-06-12* minor: Remove and tidy duplicate 'storing object to scene' messages in logJustin Clarke Casey1-1/+1
2008-05-16Formatting cleanup.Jeff Ames1-13/+13
2008-05-08* Reduced sleep durations in a number of files.Adam Frisby1-6/+0
2008-05-04* Implemented DIE_AT_EDGE and Temporary objects don't save to the database.Teravus Ovares1-1/+3
2008-05-01* In ur code. Making it static.Adam Frisby1-22/+22
* Converted a bunch of functions to static functions.
2008-05-01* Align new fields upgrade sql to have the same 'not null' and default ↵Justin Clarke Casey1-15/+15
settings as when an inventoryitems table is newly created * Normalize logging titles in database code, though this doesn't yet cover invoking code