aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MSSQL/MSSQLInventoryData.cs (follow)
Commit message (Collapse)AuthorAgeFilesLines
* Updates to MSSQL store for 0.7.3 to include:Chris Hart2012-03-061-1/+1
| | | | | | * Telehub support * Bugfix to Friends lookups * Updates to Creator fields to store up to 255 characters for HG item creator storage
* Further corrections to MS SQL stores (now passes all tests)AlexRa2010-05-231-19/+32
| | | | | | | | | | | Besides, AssetData is slightly optimized to StoreAsset in one request ("IF EXISTS() UPDATE ... ELSE INSERT ...") The main change in the MS SQL Inventory implem. is that it now return empty list (or whatever) when called with UUID.Zero, which is consistent with how the code for other DBs work. I did no changes at all in XInventory, as there is no test set for them.
* MSSQL Additions for Presence Refactor branch. Most functionality tested and ↵StrawberryFride2010-02-241-103/+103
| | | | | | works, some outstanding issues around login location and border crossings on y axis. Signed-off-by: Melanie <melanie@t-data.com>
* Reverting the memory leak patch for MySQL. Problems have been reported with ↵John Hurliman2009-11-021-0/+2
| | | | the grid server after running for several hours
* * MySQL data tests now pass by fixing a bad fix for a bad cast on the asset ↵John Hurliman2009-10-041-2/+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)
* Formatting cleanup.Jeff Ames2009-10-011-2/+2
|
* * minor: spacing adjustment to retrigger pandaJustin Clarke Casey2009-07-241-2/+1
|
* * Extend mssql name string size checking to create/update folderJustin Clarke Casey2009-07-241-3/+18
|
* * Extend inventory name and description length checks to UpdateItem for mssqlJustin Clarke Casey2009-07-241-2/+20
|
* * Correct minor bug where item description bounded string was not actually ↵Justin Clarke Casey2009-07-241-1/+2
| | | | being used in the previous patches.
* * Apply http://opensimulator.org/mantis/view.php?id=3902Justin Clarke Casey2009-07-241-2/+13
| | | | | | | * Restrict asset and inventory name descriptions so as not to overflow MSSQL field lengths * Thanks StrawberryFride
* Minor: Change OpenSim to OpenSimulator in older copyright headers and ↵Jeff Ames2009-06-011-1/+1
| | | | LICENSE.txt.
* * 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.
* Thank you, StrawberryFride, for a patch that adds offline inventoryMelanie Thielker2009-03-311-2/+15
| | | | | | | functionality to the MSSQL module. Fixes Mantis #3370
* 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-091-42/+43
| | | | | | | * Some small syntax and refactoring tweaks for asset and inventory MSSQL * This means the MSSQL db plugin now requires SQL Server 2005
* * Apply http://opensimulator.org/mantis/view.php?id=3142Justin Clarke Casey2009-02-191-11/+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)
* * optimized usings.lbsa712009-02-121-1/+1
|
* Mantis#2626: Thank you Ruud Lathrop, for a patch that cleans up MSSQL code.Homer Horwitz2008-11-151-85/+2
|
* Mantis #2618Melanie Thielker2008-11-141-2/+4
| | | | | | | Thank you, StrawberryFride, for a patch that adds group permission support to MSSQL. Contains a migration, back up your database.
* * Apply http://opensimulator.org/mantis/view.php?id=2295Justin Clarke Casey2008-09-291-4/+26
| | | | | | | | | | * 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
* Add persistence of active gestures. This needs an UGAIM update to work.Homer Horwitz2008-09-241-0/+5
| | | | | | | | | Active gestures are sent as part of the login-response. Added fetchActiveGestures to SQLite and MySQL; added an empty one for MSSQL and NHibernate. Using the empty ones won't cause errors, but doesn't provide persistence either, of course.
* Mantis #2124Melanie Thielker2008-09-141-393/+425
| | | | | | | Thank you, RuudL, for a patch that brings MSSQL up to the same implementation level as MySQL.
* * This is the fabled LibOMV update with all of the libOMV types from JHurlimanTeravus Ovares2008-09-061-24/+24
| | | | | | | * 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.
* Thanks, sempuki, for a patch that moves all Grid Server's plugins toMike Mazur2008-07-311-7/+13
| | | | | | PluginLoader. Fix issue 1871.
* Mantis#1736. Thank you kindly, StrawberryFride for a patch that:Charles Krinke2008-07-171-187/+170
| | | | | | | | | 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.
* Apply patch from bug #1609 -- Documentation for Data/MSSQL. Thanks ↵Jeff Ames2008-06-261-5/+33
| | | | kerunix_Flan!
* MSSQL Inventory Fix. Patch by Kyle and Chris from G2mingchen2008-06-061-82/+89
|
* Mantis#1450. Thank you kindly, Boscata for a patch that addresses:Charles Krinke2008-06-051-1/+1
| | | | | | | | | | I have detected a bug of conversion data type in OpenSim.Data.MSSQL.MSSQLInventoryData.addInventoryItem(InventoryItemBase item) in the GroupOwned field. My sollution is to change the flield to bit in the table. In the readInventoryItem(IDataReader reader) change too item.Flags = (uint) reader["flags"]; to item.Flags = Convert.ToUInt32(reader["flags"]); Now Inventory runs fine.
* actually user the database_connect string for mysql. Sean Dague2008-05-281-8/+0
| | | | | | | This means you can run all the OpenSim grid services without needing a mysql_connection.ini
* Formatting cleanup.Jeff Ames2008-05-161-8/+8
|
* De-tabify source.Jeff Ames2008-05-061-7/+6
|
* * In ur code. Making it static.Adam Frisby2008-05-011-2/+2
| | | | | * Converted a bunch of functions to static functions.
* * Add a scratch implementation of the new inventory fields to the mssql ↵Justin Clarke Casey2008-04-301-3/+23
| | | | | | | | | database adapter * I don't use mssql so this may not work, corrections (in the form of patches) are welcome. * Unlike mysql, mssql requires manual updating of existing tables here (which should mean just adding the new fields manually)
* allow for Inventory database source to be specified in mainSean Dague2008-04-231-0/+6
| | | | | | | | configs. This works with sqlite and nhibernate backends, and stays with default seperate ini files for mysql and mssql until someone writes those.
* * Optimised using statements and namespace references across entire project ↵Adam Frisby2008-04-211-2/+3
| | | | (this took a while to run).
* further refactor and rename of InventoryFolderBase propertiesSean Dague2008-04-081-3/+3
| | | | | | to reflect what they really are.
* more refactoring, this time on InventoryFolderBaseSean Dague2008-04-071-25/+25
| | | | | | | | * wrap attributes in properties * clean up names a little bit * clean up name styles
* Refactor InventoryItemBase to do the following:Sean Dague2008-04-071-41/+41
| | | | | | | | * wrap fields as Properties * rename some fields/properties to more sensible names * set style to PropName to match more standard C# approach
* fix ups to include OpenSim.Framework explicit includes (theySean Dague2008-04-021-0/+1
| | | | | | | were implicitly included before). Everything builds again. Now off to testing.
* attempt to fix up all refernces to new directory structureSean Dague2008-04-021-1/+1
|
* whole lot more movingSean Dague2008-04-021-0/+728