aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL/MySQLInventoryData.cs (follow)
Commit message (Collapse)AuthorAgeFilesLines
* Consistently use using() to make sure we dispose of used MySqlCommands where ↵Justin Clark-Casey (justincc)2012-04-301-63/+67
| | | | this is not already being done.
* Plug a security hole in the inventory serviceMelanie2011-10-311-1/+2
|
* Prevent activation and deactivation of gestures from clobbering the slamMelanie2011-01-181-1/+1
| | | | bits
* Formatting cleanup.Jeff Ames2010-09-121-1/+1
|
* Some more corrections after MySQL connector updateAlexRa2010-05-191-1/+1
|
* All (?) MySQL stores fixed to use DBGuid.FromDB()AlexRa2010-05-191-20/+13
| | | | | | | | | | | | | This was needed if we want to update to the latest MySQL connector dll. It automatically converts CHAR(36) to Guids, so getting them as strings no longer works. By using DBGuid.FromDB(), we unlink from any particular storage format of GUIDs, could even make them BINARY(16) if we like. Actually not all MySql units are touched, but the remaining ones don't seem to be affected (they don't read GUIDs from DB)
* Just a bit of spellchecking in the commentsAlexRa2010-04-281-2/+2
|
* Updated MySQL connection management to use the MySQL connection pooling. ↵Master ScienceSim2010-02-051-511/+336
| | | | This should accommodate various timeout problems that exist with the current connection pool code in a more general and standard way.
* * Fixed the Cable Beach inventory server to save the CreatorID as well as ↵OpenSim Master2010-02-051-2/+2
| | | | properly handling null item names and descriptions * Fixed the MySQL reader to safely handle null values in string columns that can be null
* Formatting cleanup. Add copyright headers.Jeff Ames2010-01-041-3/+3
|
* Prevent the creation of duplicate inventory folders in the case of a loginMelanie2010-01-011-1/+1
| | | | database issue. Now the login will instaead fail later.
* * Implements OSSL function: osGetSimulatorMemory - returns the current ↵Adam Frisby2009-12-131-0/+3
| | | | | | | | amount of memory allocated to the simulator process (Moderate Threat Level). * Cleans redundant information out of the Simulator Version. Versions now look like: "OpenSimulator 0.6.9(dev) Unix/Mono" * [Minor] additional log info for MySQLInventoryData
* * Implements SQL Rollback support to Inventory Service for quicker backup ↵Adam Frisby2009-11-231-0/+154
| | | | | | | | | | restoration. * Can optionally replace the OpenGridMode committed earlier. * Will create a series of incrementing restore SQL files, one per user, in folders listed per-day. * For MySql Section of InventoryService INI: rollback = "true" rollbackdir = "/absolute/path/to/rollback/storage/dir"
* * Adds a modicum of additional checking to the Inventory Service (MySQL only)Adam Frisby2009-11-231-5/+22
| | | | | * Enable "opengridmode=true" in your Inventory Connector (where the mysql connection strings are) to enable if you are running a 'wide-open-grid'. * More comprehensive rollback support being implemented, should be available later today.
* Reverting the memory leak patch for MySQL. Problems have been reported with ↵John Hurliman2009-11-021-166/+169
| | | | 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-169/+166
| | | | | | 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-6/+6
|
* Add copyright headers. Formatting cleanup. Fix a compiler warning.Jeff Ames2009-08-171-1/+1
|
* * Fixed MySQL/MySQLAssetData.cs to properly do updates * Removed an extra ↵Kunnis2009-08-161-1/+1
| | | | parameter from MySQL/MySQLInventoryData.cs * Fixed a bug in SQLite/SQLiteAssetData.cs that was causing a NRE when updating an asset. * Improved the BasicAssetTest.cs to do full create/update/get testing * Improved the BasicInventoryTest.cs to do full create/update/get of both a folder and an item * Moved the null ref tests to the start of the PropertyCompareConstraint.cs, so that it doesn't throw when passing in a null item
* Adding in Reflection-based testing, to ensure that all properties are covered.Kunnis2009-08-161-5/+6
|
* * Apply asset and inventory name and description bound checks to MySQLJustin Clarke Casey2009-07-241-3/+24
|
* Minor: Change OpenSim to OpenSimulator in older copyright headers and ↵Jeff Ames2009-06-011-1/+1
| | | | LICENSE.txt.
* now that creatorID is no longer a strict UUID, and the column can still be NULL,Sean Dague2009-05-081-1/+10
| | | | | | we lost protection from NULL strings. This puts some protection in for that case. This may address many of the inventory issues that are being seen intermitently.
* * Make it possible to store creator strings in user inventory items as well ↵Justin Clarke Casey2009-04-081-7/+5
| | | | | | | | | as UUIDs * All existing functionality should be unaffected. * Database schemas have not been changed.
* Committing partial work on passing folders across instances. This may crash.Melanie Thielker2009-03-231-0/+5
|
* MYSQL Only: Make items given while offline appear in inventory withoutMelanie Thielker2009-03-221-0/+9
| | | | | | the need to clear cache.
* 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.
* * optimized usings.lbsa712009-02-121-1/+1
|
* Add group permissions to agent inventory.Melanie Thielker2008-11-141-2/+4
| | | | | | | | | | Contains a migration. May contain nuts. Please back up your inventory data store. This revision changes the interface version!! No older regions can connect to these new UGAIM, and the new regions can't connect to the old UGAIM. Fixes a long-standing issue of permissions loss Currently persisted on MySQL only.
* make inventory item listing more robust. It turns out that a bad itemSean Dague2008-11-131-8/+28
| | | | | | | | | | | | | (one that won't parse right) will prevent all other items in that folder to load when inventory is requested. This is very careful to no longer add inventory items that return as null to the hash table for getInventoryInFolder, as well as be more careful parsing UUIDs for fields that aren't marked not null in MySQL. The net result, you may see previously missing inventory items return after this checkin. Folders probably need to be hardened in the same way, but I'm out of time for today.
* Update svn properties. Minor formatting cleanup. Fix a compiler warning. ↵Jeff Ames2008-09-281-2/+2
| | | | Fix a UUID vs null comparison.
* Add persistence of active gestures. This needs an UGAIM update to work.Homer Horwitz2008-09-241-0/+36
| | | | | | | | | 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.
* * This is the fabled LibOMV update with all of the libOMV types from JHurlimanTeravus Ovares2008-09-061-27/+27
| | | | | | | * 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.
* remove pre-Migration upgrade pathsSean Dague2008-08-271-92/+0
|
* Formatting cleanup.Jeff Ames2008-08-181-9/+9
|
* Minor formatting cleanup.Jeff Ames2008-08-121-1/+1
|
* Mantis#1903. Thank you kindly, CMickeyb for a patch that:Charles Krinke2008-08-101-5/+108
| | | | | | | | | patch attached replaces the tree walk algorithm used to build the folder hierarchy with a single database query. That is, we replace 1 database query per folder with 1 query for the root folder's properties and 1 query to retrieve the entire collection of folders for a user.
* Thanks, sempuki, for a patch that moves all Grid Server's plugins toMike Mazur2008-07-311-7/+13
| | | | | | PluginLoader. Fix issue 1871.
* Mantis#1661. Thank you kindly, CMickeyb for a patch that:Charles Krinke2008-07-031-0/+24
| | | | | | | patch attached to check for timeouts on mysql connections *before* operations occur that are likely to timeout. if timeout occurs or the connections is down, it is reconnected before the operation fails.
* Apply patch from bug #1601 -- more documentation for Data/MySQL. Thanks ↵Jeff Ames2008-06-261-17/+40
| | | | kerunix_Flan!
* Add patch from bug #1596 - adds Doxygen documentation in OpenSim.Data.MySQL ↵Jeff Ames2008-06-261-2/+29
| | | | files. Thanks kerunix_Flan!
* Update svn properties, clean up formatting, refactor out duplicate ↵Jeff Ames2008-06-131-1/+1
| | | | hard-coded port numbers.
* Fix mysql migrations. This is tested with an existing up to date schema,Sean Dague2008-06-121-1/+1
| | | | | | | | | and no schema. It should also work with a non up to date schema as well. Btw, meetings in which I can get code done are the right kind of meetings.
* this, in theory, adds migration support to mysql for all Sean Dague2008-06-121-4/+30
| | | | | | | | data sources besides the grid store. It is only lightly tested so the less adventurous should wait a couple of checkins before upgrading.
* Update svn properties. Formatting cleanup.Jeff Ames2008-05-301-1/+1
|
* actually user the database_connect string for mysql. Sean Dague2008-05-281-20/+19
| | | | | | | This means you can run all the OpenSim grid services without needing a mysql_connection.ini
* Formatting cleanup.Jeff Ames2008-05-161-12/+12
|
* De-tabify source.Jeff Ames2008-05-061-1/+1
|
* * Refactor: Remove the unused userID parameter that was being passed into ↵Justin Clarke Casey2008-05-011-56/+7
| | | | | | | | almost every inventory method * This allows lots of redundant inventory methods with only slightly different names to be eliminated.
* * In ur code. Making it static.Adam Frisby2008-05-011-2/+2
| | | | | * Converted a bunch of functions to static functions.