aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MSSQL/MSSQLGridData.cs (unfollow)
Commit message (Collapse)AuthorFilesLines
2009-05-17Thank you kindly, StrawberryFride, for a patch that:Charles Krinke1-5/+4
Adds maturity & access logic for MSSQL platform to mirror that of MySQL as committed in 9502.
2009-02-19* Apply http://opensimulator.org/mantis/view.php?id=3142Justin Clarke Casey1-9/+11
* 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
2008-11-17cleaning up warnings in MSSQL code.Dr Scofield1-1/+1
2008-11-15Mantis#2626: Thank you Ruud Lathrop, for a patch that cleans up MSSQL code.Homer Horwitz1-53/+2
2008-10-27Thank you kindly, Ruud Lathrop for a patch that solves:Charles Krinke1-1/+1
Primary Key violation when just linked a lot of prims using MSSQL.
2008-10-03Add the missing bits for the new region-search:Homer Horwitz1-0/+27
- Added lookup in the data-layer - MySQL works - SQLite doesn't have a grid-db, so it won't work there - I added MSSQL-code to the best of my knowledge; but I don't know MSSQL :-) - Added the plumbing up to OGS1GridServices. This speaks with the grid-server via XMLRPC. - Modified MapSearchModule to use the new data. It's backward compatible; if used with an old grid-server, it just returns one found region instead of a list. - Refactored a bit. Note: This updates data, grid-server and region code. No new files.
2008-09-29* Apply http://opensimulator.org/mantis/view.php?id=2295Justin Clarke Casey1-1/+1
* 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-14Mantis #2124Melanie Thielker1-207/+372
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-7/+7
* 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-08-18Formatting cleanup.Jeff Ames1-6/+6
2008-07-23Thanks, sempuki, for a patch that moves control of Mono.Addins from source ↵Mike Mazur1-5/+0
attributes to external XML files. Fix issues 1682 and 1786.
2008-07-18Thanks, sempuki, for a patch that moves all grid plugins to new PluginLoader ↵Mike Mazur1-5/+17
(issue 1763).
2008-07-17Mantis#1736. Thank you kindly, StrawberryFride for a patch that:Charles Krinke1-71/+52
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-12Mantis#1726. Thank you kindly, StrawberryFride for a patch that:Charles Krinke1-0/+4
On an MSSQL-based Grid OpenSim installation, users could log in to the sim once, then log off - after a short time before retrying users would be unable to log in, and would see an empty alert box on the client with just a "close" button and no text. Despite no users being logged into the sim, user server would report a higher number of logins than logouts.
2008-06-27last round of warning squashing. calling it a day now.Dr Scofield1-4/+4
2008-06-26Apply patch from bug #1609 -- Documentation for Data/MSSQL. Thanks ↵Jeff Ames1-4/+27
kerunix_Flan!
2008-05-28let Grid Servers specify a connect string in their configuration.Sean Dague1-1/+2
2008-05-16Formatting cleanup.Jeff Ames1-9/+9
2008-05-01* Thanks to Mic Bowman for inspiring me to look at that we are still using ↵Adam Frisby1-1/+1
ASCIIEncoder in places we shouldn't.
2008-05-01* Align new fields upgrade sql to have the same 'not null' and default ↵Justin Clarke Casey1-3/+3
settings as when an inventoryitems table is newly created * Normalize logging titles in database code, though this doesn't yet cover invoking code
2008-04-21* Optimised using statements and namespace references across entire project ↵Adam Frisby1-2/+3
(this took a while to run).
2008-04-11* Discerned between AddProfile and UpdateProfile in region registrationlbsa711-8/+73
:: Believe it or not, but INSERT/UPDATE is actually a better pattern than REPLACE, since, with INSERT/UPDATE you can catch erroneous UPDATES to non-INSERTed items as well as catch erroneous re-INSERTS. in 95% of the cases, you SHOULD have a clear INSERT context, and a clear and separate UPDATE context. If you think your case falls within the 5%, maybe you should re-evaluate your code. ::
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-28* Introduced base abstract provider class for GridDatalbsa711-12/+12
2008-03-18Formatting cleanup. Minor refactoring.Jeff Ames1-5/+2
2008-03-18* Added the ability to type the partial name of a region in the start ↵Teravus Ovares1-0/+43
location box and go to that region if it's there. If no close match was found, it sends you home. This is tested on mySQL. There's untested code on grids that are based on sqlite and MSSQL. The SQL statements *should* be right, but your results may very. * Ex, if you want to go to Wright Plaza, you simply need to type Wright Plaza in the start location in the client when you log-in.
2008-03-18Formatting cleanup.Jeff Ames1-29/+28
2008-03-02Thank you kindly, Ahzzmandius for addingCharles Krinke1-4/+4
owner_uuid support to the MSSQL data driver.
2008-02-13* Moved insertRegionRow into MSSQLGridDatalbsa711-3/+74
* 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-91/+36
* 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-2/+4
Changed LogBase to ConsoleBase, which handles console I/O. This is mostly an in-place conversion, so lots of refactoring can still be done.
2007-12-27* Optimized usingslbsa711-25/+21
* shortened references * Removed redundant 'this' * Normalized EOF
2007-12-20Added patch from Johan. First attempt to solve the LibSL.Packet GC problem. ↵Jeff Ames1-1/+1
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-29/+135
* 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-11-13* Added AvatarPicker in Standalone mode. Works for finding avatar to ban, ↵Teravus Ovares1-0/+13
manually trying to add a friend (with the add button) or useful to those who are curious which usernames have visited your standalone sim. Important for future development :D. * Grid mode always returns 0 results until the Grid Communications portion is done.
2007-10-30* Optimized usingslbsa711-2/+2
* Shortened type references * Removed redundant 'this' qualifier
2007-10-17Renamed SimProfileData to RegionProfileDataTleiades Hax1-7/+7
2007-09-10mass update of urls in source code to new websiteSean Dague1-1/+1
2007-07-16changed to native line ending encodingSean Dague1-194/+194
2007-07-03* Optimized usings (the 'LL ate my scripts' commit)lbsa711-10/+12
* added some licensing info
2007-06-27*Fixed all renaming for OpenGridServices.sln, still a reference issue in ↵mingchen1-2/+2
prebuild.xml though