aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MSSQL/MSSQLInventoryData.cs (unfollow)
Commit message (Collapse)AuthorFilesLines
2009-07-24* minor: spacing adjustment to retrigger pandaJustin Clarke Casey1-2/+1
2009-07-24* Extend mssql name string size checking to create/update folderJustin Clarke Casey1-3/+18
2009-07-24* Extend inventory name and description length checks to UpdateItem for mssqlJustin Clarke Casey1-2/+20
2009-07-24* Correct minor bug where item description bounded string was not actually ↵Justin Clarke Casey1-1/+2
being used in the previous patches.
2009-07-24* Apply http://opensimulator.org/mantis/view.php?id=3902Justin Clarke Casey1-2/+13
* Restrict asset and inventory name descriptions so as not to overflow MSSQL field lengths * Thanks StrawberryFride
2009-06-01Minor: Change OpenSim to OpenSimulator in older copyright headers and ↵Jeff Ames1-1/+1
LICENSE.txt.
2009-04-08* Make it possible to store creator strings in user inventory items as well ↵Justin Clarke Casey1-13/+14
as UUIDs * All existing functionality should be unaffected. * Database schemas have not been changed.
2009-03-31Thank you, StrawberryFride, for a patch that adds offline inventoryMelanie Thielker1-2/+15
functionality to the MSSQL module. Fixes Mantis #3370
2009-03-23Committing partial work on passing folders across instances. This may crash.Melanie Thielker1-0/+5
2009-03-21Add a QueryItem method to the inventory subsystem. Currently implemented forMelanie Thielker1-0/+5
MySQL only, stubs for the others. This allows updating the cache with a single item from the database.
2009-03-09* Apply http://opensimulator.org/mantis/view.php?id=3280Justin Clarke Casey1-42/+43
* Some small syntax and refactoring tweaks for asset and inventory MSSQL * This means the MSSQL db plugin now requires SQL Server 2005
2009-02-19* Apply http://opensimulator.org/mantis/view.php?id=3142Justin Clarke Casey1-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)
2009-02-12* optimized usings.lbsa711-1/+1
2008-11-15Mantis#2626: Thank you Ruud Lathrop, for a patch that cleans up MSSQL code.Homer Horwitz1-85/+2
2008-11-14Mantis #2618Melanie Thielker1-2/+4
Thank you, StrawberryFride, for a patch that adds group permission support to MSSQL. Contains a migration, back up your database.
2008-09-29* Apply http://opensimulator.org/mantis/view.php?id=2295Justin Clarke Casey1-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
2008-09-24Add persistence of active gestures. This needs an UGAIM update to work.Homer Horwitz1-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.
2008-09-14Mantis #2124Melanie Thielker1-393/+425
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-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.
2008-07-31Thanks, sempuki, for a patch that moves all Grid Server's plugins toMike Mazur1-7/+13
PluginLoader. Fix issue 1871.
2008-07-17Mantis#1736. Thank you kindly, StrawberryFride for a patch that:Charles Krinke1-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.
2008-06-26Apply patch from bug #1609 -- Documentation for Data/MSSQL. Thanks ↵Jeff Ames1-5/+33
kerunix_Flan!
2008-06-06MSSQL Inventory Fix. Patch by Kyle and Chris from G2mingchen1-82/+89
2008-06-05Mantis#1450. Thank you kindly, Boscata for a patch that addresses:Charles Krinke1-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.
2008-05-28actually user the database_connect string for mysql. Sean Dague1-8/+0
This means you can run all the OpenSim grid services without needing a mysql_connection.ini
2008-05-16Formatting cleanup.Jeff Ames1-8/+8
2008-05-06De-tabify source.Jeff Ames1-7/+6
2008-05-01* In ur code. Making it static.Adam Frisby1-2/+2
* Converted a bunch of functions to static functions.
2008-04-30* Add a scratch implementation of the new inventory fields to the mssql ↵Justin Clarke Casey1-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)
2008-04-23allow for Inventory database source to be specified in mainSean Dague1-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.
2008-04-21* Optimised using statements and namespace references across entire project ↵Adam Frisby1-2/+3
(this took a while to run).
2008-04-08further refactor and rename of InventoryFolderBase propertiesSean Dague1-3/+3
to reflect what they really are.
2008-04-07more refactoring, this time on InventoryFolderBaseSean Dague1-25/+25
* wrap attributes in properties * clean up names a little bit * clean up name styles
2008-04-07Refactor InventoryItemBase to do the following:Sean Dague1-41/+41
* wrap fields as Properties * rename some fields/properties to more sensible names * set style to PropName to match more standard C# approach
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-28* Send full inventory folder skeleton to standalone client logins rather ↵Justin Clarke Casey1-6/+2
than just the root child folders * This may resolve some current problems with non root child folders on standalone installations. * A fix for the same problem in grid mode will come soon.
2008-03-28* fixed pk_violation on rename for MSSQLInventoryDatalbsa711-0/+6
("le fix le plus ugly for le problem trés dumb")
2008-03-18Formatting cleanup.Jeff Ames1-29/+27
2008-02-05Converted logging to use log4net.Jeff Ames1-16/+18
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-05Fix for typo in updateInventoryItem in MSSQLInventoryData.cs (thanks Grumly!)Brian McBee1-1/+1
2007-12-27* Optimized usingslbsa711-82/+81
* shortened references * Removed redundant 'this' * Normalized EOF
2007-12-23Miscellaneous small tweaks and more logging messages to move towards ↵Justin Clarke Casey1-1/+1
resolving inventory problems
2007-12-20Added patch from Johan. First attempt to solve the LibSL.Packet GC problem. ↵Jeff Ames1-28/+28
Works with LibSL rev>1532
2007-12-15Grid Inventory feature upgrade: renaming folders should now be correct, ↵Brian McBee1-0/+28
subfolders work, moving folders works. Tested only in MYSQL, but may work in MSSQL and sqlite. Probably not working in standalone mode.
2007-12-10saved OpenSim source code from the giant rampaging unterminated copyright ↵Jeff Ames1-1/+1
notice of doom
2007-12-08This patch fixes mantis 105. Basically, it stops the index exception whenSean Dague1-7/+9
no root folder is found and it makes the user server wait longer for the inventory server to do its work. From Justin Casey (IBM)
2007-12-05* Applied MSSQL Patch from akokko, Thanks! akokkoTeravus Ovares1-0/+697
* 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