aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MSSQL/MSSQLManager.cs (unfollow)
Commit message (Collapse)AuthorFilesLines
2012-03-31Add MSSQL login processing fix for servers run on different locales.Justin Clark-Casey (justincc)1-0/+5
This may no longer be an issue with better locale enforcement in OpenSimulator but it doesn't hurt to have this patch. http://opensimulator.org/mantis/view.php?id=4680 Thanks to controlbreak for this
2011-03-31remove some mono compiler warningsJustin Clark-Casey (justincc)1-3/+1
2010-03-10Formatting cleanup. Add copyright notices.Jeff Ames1-2/+2
2010-02-24MSSQL Additions for Presence Refactor branch. Most functionality tested and ↵StrawberryFride1-221/+4
works, some outstanding issues around login location and border crossings on y axis. Signed-off-by: Melanie <melanie@t-data.com>
2009-11-02Reverting the memory leak patch for MySQL. Problems have been reported with ↵John Hurliman1-0/+4
the grid server after running for several hours
2009-10-04* MySQL data tests now pass by fixing a bad fix for a bad cast on the asset ↵John Hurliman1-4/+0
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-06-01Minor: Change OpenSim to OpenSimulator in older copyright headers and ↵Jeff Ames1-1/+1
LICENSE.txt.
2009-02-19* Apply http://opensimulator.org/mantis/view.php?id=3142Justin Clarke Casey1-4/+8
* 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-2/+2
2009-01-12* Apply http://opensimulator.org/mantis/view.php?id=2980Justin Clarke Casey1-0/+4
* Add single conversion to MSSQLManager.DbTypeFromType * May resolve storage of prim information under MSSQL * Thanks SirKimba
2009-01-07Thank you kindly, StrawberryFride for a patch that:Charles Krinke1-1/+14
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.
2008-09-14Mantis #2124Melanie Thielker1-330/+44
Thank you, RuudL, for a patch that brings MSSQL up to the same implementation level as MySQL.
2008-09-06* This is the fabled LibOMV update with all of the libOMV types from JHurlimanTeravus Ovares1-19/+19
* 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-01Mantis #2095Melanie Thielker1-4/+112
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-18Formatting cleanup.Jeff Ames1-4/+4
2008-07-20Mantis#1796. Thank you kindly, StrawberryFride for a patch that:Charles Krinke1-1/+59
Agent table code (INSERT / UPDATE, etc) now added to MSSQL provider.
2008-07-17Mantis#1736. Thank you kindly, StrawberryFride for a patch that:Charles Krinke1-82/+59
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-02* Drop InvType from the assets table since it is no longer usedJustin Clarke Casey1-1/+0
* Migration should be automatic on sqlite and mysql * Migration is not automatic on mssql, you will need to drop the invType column manually * Migration should be fine, but as for any db change, I would recommend making sure you have backups before moving past this revision
2008-06-27last round of warning squashing. calling it a day now.Dr Scofield1-1/+1
2008-06-26Apply patch from bug #1609 -- Documentation for Data/MSSQL. Thanks ↵Jeff Ames1-4/+32
kerunix_Flan!
2008-05-16Formatting cleanup.Jeff Ames1-2/+2
2008-05-08* You can haz more spring cleaning.Adam Frisby1-6/+1
* Eventually this codebase will be clean. >_>
2008-04-21* Optimised using statements and namespace references across entire project ↵Adam Frisby1-2/+2
(this took a while to run).
2008-04-10renaming of attributes in UserAgentData for readabilitySean Dague1-3/+3
2008-04-10changing UserAgentData to use properties. This caused moreSean Dague1-11/+14
grief than expected, as monodevelop doesn't like to refactor properties of properties.
2008-04-10further renaming of properties for claritySean Dague1-7/+7
2008-04-10moved fields to properties for UserDataProfile, which wasSean Dague1-19/+19
actually a little more work than I expected given the copious use of out params.
2008-04-02fix ups to include OpenSim.Framework explicit includes (theySean Dague1-0/+1
were implicitly included before). Everything builds again. Now off to testing.
2008-04-02attempt to fix up all refernces to new directory structureSean Dague1-1/+1
2008-04-02whole lot more movingSean Dague1-0/+0
2008-03-18Formatting cleanup.Jeff Ames1-26/+25
2008-03-15Thank you kindly, Grumly57 for:Charles Krinke1-1/+1
Added MSSQLDataStore.cs to OpenSim.Framework.Data.MSSQL and changed it to reflect the actual capabilites of MySQLDataStore.cs
2008-03-03* More compiler warning nukage.Adam Frisby1-1/+1
2008-03-02Thank you kindly, Ahzzmandius for addingCharles Krinke1-2/+7
owner_uuid support to the MSSQL data driver.
2008-02-13* Moved insertUserRow into MSSQLUserData so 'create user' works againlbsa711-95/+1
[Provided by openlifegrid.com]
2008-02-13* Moved insertRegionRow into MSSQLGridDatalbsa711-167/+83
* Split table test and creation into table by table * Debugged table creation Sql * Added missing CreateUserFriendsTable.sql
2008-02-13* Split out MSSQLManager Test/Init into each provider.lbsa711-66/+1
* Made regions table name configurable (MSSQL only) * Added a note in ini.example pointing out that the sql resources have to change if you change table names * Removed duplicate picker method from GridData interface [Provided by openlifegrid.com]
2008-02-05Converted logging to use log4net.Jeff Ames1-7/+9
Changed LogBase to ConsoleBase, which handles console I/O. This is mostly an in-place conversion, so lots of refactoring can still be done.
2008-01-15* Mother of all commits:Adam Frisby1-6/+6
* Cleaned up copyright notices in AssemblyInfo.cs's * Added Copyright headers to a bunch of files missing them * Replaced several common string instances with a static constant to prevent reallocation of the same strings thousands of times. "" -> String.Empty is the first such candidate.
2008-01-09* Added a hashtable based HTTP processor in preparation of the web_login_keyTeravus Ovares1-3/+21
* Added the web_login_key to the users table * Added happy configurable http error message pages * This update is large enough to have 'awe' value.. so backup your users or weep. * Not tested on MSSQL, even though I added code to update the tables!
2007-12-27* Optimized usingslbsa711-127/+134
* shortened references * Removed redundant 'this' * Normalized EOF
2007-12-20Added patch from Johan. First attempt to solve the LibSL.Packet GC problem. ↵Jeff Ames1-4/+4
Works with LibSL rev>1532
2007-12-10saved OpenSim source code from the giant rampaging unterminated copyright ↵Jeff Ames1-1/+1
notice of doom
2007-12-05* Applied MSSQL Patch from akokko, Thanks! akokkoTeravus Ovares1-45/+571
* This hasn't been tested in MSSQL mode, however it's been checked to make sure it doesn't cause any issues with mySQL/SQLlite
2007-10-30* Optimized usingslbsa711-32/+36
* Shortened type references * Removed redundant 'this' qualifier
2007-10-17Renamed SimProfileData to RegionProfileDataTleiades Hax1-3/+3
2007-09-10mass update of urls in source code to new websiteSean Dague1-1/+1
2007-07-16changed to native line ending encodingSean Dague1-211/+211
2007-07-03* Optimized usings (the 'LL ate my scripts' commit)lbsa711-5/+2
* added some licensing info
2007-07-01Fixed SimpleApp - aka thankgoditssundaycommitlbsa711-1/+1
* Updated SimpleApp with various introduced dependencies * Extracted ScenePrescence creation in Scene * removed try-catchall from UserManagerBase (that actually hid a bug) * Refactored RegionInfo * handle is calculated * it will explode upon accessing x,y,ip,port,externalip if not explicitly initialized * Removed superfluous 'ref' keywords * Removed a shitload of 'catch Exception e' that causes build warnings * Lots of small refactorings, renames et c * Ignored some bins