aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL (follow)
Commit message (Collapse)AuthorAgeFilesLines
* * refactor: Rip out SOP inventory from the partial into a separate classJustin Clarke Casey2008-11-211-1/+1
| | | | | | | | * SceneObjectPartInventory.cs isn't a particularly good name but it's probably not got a long life * A proper inventory interface to follow * Parallel changes for other inventory partial classes to follow at a later date
* Update svn properties, minor formatting cleanup.Jeff Ames2008-11-211-6/+6
|
* Mantis#2656. Thank you kindly, Nlin for a patch that:Charles Krinke2008-11-192-0/+15
| | | | | | Attached patch implements llCollisionSound. Thanks T. Sado.
* Fixed MySQL and SQLite so they will save theSean Dague2008-11-182-0/+19
| | | | | | | variable sun vector, adding 3 new fields on both. From: Arthur Rodrigo S Valadares <arthursv@linux.vnet.ibm.com>
* Make a quick stab at the "Open data reader" issue.Melanie Thielker2008-11-161-8/+20
| | | | | | | MySqlDataReader needs to be Close()d explicitly. Disposing it or letting it fall out of scope will not free it's hold on the connection.
* Mantis#2552: Thanks idb, for a patch that fixes persistence of physical prims.Homer Horwitz2008-11-151-2/+1
| | | | | | (added a fix for the broken build from last commit, too)
* Add SQLite and the missing migrations files for last commitMelanie Thielker2008-11-141-0/+5
|
* 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 avatar picker search to work with OpenSearch people searchMelanie Thielker2008-11-131-2/+2
|
* * refactor: Expose SOG.SetRootPart for outsiders to use rather than setting ↵Justin Clarke Casey2008-11-101-2/+2
| | | | | | | | RootPart and adding the part separately * Make RootPart read only
* Mantis#2598: Thanks Fly-Man- for a patch that fixes a client-thread crash byHomer Horwitz2008-11-081-1/+1
| | | | | | allowing landFlags bit 31 to be used (Int32 -> UInt32).
* Remove empty OSUUID.cs file. Add copyright headers. Minor formatting cleanup.Jeff Ames2008-11-081-1/+28
|
* add create_time and access_time to asset db for mysql, as wellSean Dague2008-11-062-2/+52
| | | | | | | | | | | | as the code to update these at the appropriate time. This isn't surfaced in AssetBase yet. Change the replace into to an insert into for asset create. Assets are not supposed to be updatable, and the replace into is more expensive. From: Sean Dague <sdague@gmail.com>
* From: arthursv@linux.vnet.ibm.comSean Dague2008-11-062-21/+21
| | | | | | | Add more unit tests for user cases Persist more user fields into mysql that already had columns defined but weren't getting passed to the mysql manager.
* add some null protection on emailSean Dague2008-11-041-1/+1
| | | | | From: Sean Dague <sdague@gmail.com>
* implement email field for MySQL and SQLiteSean Dague2008-11-043-15/+23
| | | | | From: Sean Dague <sdague@gmail.com>
* * Minor cleanupAdam Frisby2008-11-011-1/+0
| | | | | * Added additional error message when a Object/SOG DB save fails so we can trace why.
* Megapatch that fixes/adds: friend offer/deny/accept, friendship termination,Homer Horwitz2008-11-011-0/+43
| | | | | | | | | | | | | | on-/offline updates, calling cards for friends. This adds methods in the DB layer and changes the MessagingServer, so a full update (incl. UGAIM) is necessary to get it working. Older regions shouldn't break, nor should older UGAIM break newer regions, but friends/presence will only work with all concerned parts (UGAIM, source region and destination region) at this revision (or later). I added the DB code for MSSQL, too, but couldn't test that. BEWARE: May contain bugs.
* Fix a compile warning about unreachable codeHomer Horwitz2008-11-011-2/+0
|
* A stab a getting the user server to act right. Move acquisition of theMelanie Thielker2008-11-012-18/+21
| | | | | | | | locks to just before the try/catch/finally block, so that an exception thrown between taking the lock and entering the try doesn't leave a mutex locked
* * Added some debug information to MySQL UserDataManager to help diagnose a ↵Adam Frisby2008-10-312-18/+25
| | | | potential issue when in high load. Related to mantis #2508.
* - Includes consistency test for new and updated objects, asSean Dague2008-10-301-3/+2
| | | | | | | some fixes in MySQL and SQLite From: Arthur Rodrigo S Valadares <arthursv@linux.vnet.ibm.com>
* Mid-work, trying to fix region part insertion and retrievalSean Dague2008-10-301-7/+29
| | | | | | | | SQLite reports System NUll Reference, but works, inside LoadItems, on SQLiteRegionData.cs From: Arthur Rodrigo S Valadares <arthursv@linux.vnet.ibm.com>
* Megapatch. :) Fix skull attachment editing. Streamline Object terse updates.Melanie Thielker2008-10-182-0/+13
| | | | | | | | Add rezzing time to objects. Add Object return and traffic fields to land database. Add plumbing for auto return. Implement auto return. Contains a migration. May contain nuts.
* - Enforced no user or agent with UUID 0 on agent DB insertionSean Dague2008-10-161-0/+4
|
* * minor: comment out persisting prim inventory log messagesJustin Clarke Casey2008-10-151-1/+1
|
* - Makes MySQL reject inserting UUID 0Sean Dague2008-10-151-0/+5
| | | | | | | | | | - Makes SQLite mimick MySQL default behavior on first and last name already on db: it does not insert the new record. - Added tests for UUID 0 and for new UUID with existing first and last name.
* Add the missing bits for the new region-search:Homer Horwitz2008-10-031-0/+46
| | | | | | | | | | | | | | | | - 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.
* Add database persistence for material settingMelanie Thielker2008-10-032-0/+11
|
* add delete prim tests. Found and fixed bugs where regionSean Dague2008-10-011-2/+2
| | | | | | | | is not respected by sqlite or mysql drivers so that deleting and object in a region actually deletes that object from any region.
* Update svn properties. Minor formatting cleanup. Fix a compiler warning. ↵Jeff Ames2008-09-281-2/+2
| | | | Fix a UUID vs null comparison.
* * Patch from JHurlimanTeravus Ovares2008-09-261-3/+3
| | | | | | | | | * Updates to libomv r2243, * Remove lots of unnecessary typecasts * Improves SendWindData() Thanks jhurliman. * Will update OpenSim-libs in 10 minutes..
* removal of more dead alter table codeSean Dague2008-09-251-39/+2
|
* light mysql user testsSean Dague2008-09-241-0/+88
|
* expose it for real, missed the public keywordSean Dague2008-09-241-1/+1
|
* expose MySQLUserData class so that it can be testedSean Dague2008-09-241-1/+1
|
* remove configurable table names from the mysql user driver. ThatSean Dague2008-09-241-24/+3
| | | | | | | doesn't work in a world of migrations anyway, and is only cruft that will confuse people.
* 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.
* light the mysql region testsSean Dague2008-09-241-0/+97
|
* let the asset tests run on MySQL. Interesting difference here, theSean Dague2008-09-243-1/+92
| | | | | | | sqlite driver can handle .Data = Null, the mysql driver can not. We should decide which is the right behavior and adjust code for it.
* create the first attempted mysql test. This only runs locally if youSean Dague2008-09-231-8/+19
| | | | | | | have a database configured as opensim-nunit with user opensim-nunit / password opensim-nunit that has full perms on the database.
* remove log4net references, see if that helps fix bambooSean Dague2008-09-231-9/+1
|
* check in stubbing for mysql tests. This is ignored withSean Dague2008-09-231-0/+74
| | | | | | | | Assert.Ignore() for now, so it won't change anything, but I want to make sure it doesn't break the bamboo infrastructure in it's current state.
* - Add Dispose method to IRegionDataStoreHomer Horwitz2008-09-181-0/+2
| | | | | | | | - Add necessary dummy Dispose-methods where they are missing - Implement the SQLite Dispose-methods (currently only used for unit tests, in the next commit)
* Mantis #2124Melanie Thielker2008-09-141-1/+1
| | | | | | | Thank you, RuudL, for a patch that brings MSSQL up to the same implementation level as MySQL.
* Thank you kindly, CMickeyb for a patch that:Charles Krinke2008-09-141-0/+6
| | | | | | | | | Moved intialization of appearance from the SendInitialData event handler into CompleteMovement handler. That ensures that m_appearance is initialized before the inventory is retrieved (so there is a place to check on attachments).
* * Add userstore sql upgrade I carelessly forgot to check in a couple of ↵Justin Clarke Casey2008-09-121-0/+5
| | | | | | | | revisions ago * Hopefully there wasn't a problem anyway, since the look at stuff isn't enabled yet
* * Check in first part of http://opensimulator.org/mantis/view.php?id=2073Justin Clarke Casey2008-09-121-3/+6
| | | | | | | | | * This patch aims to introduce look at direction persistence between logins. It won't be active until the second part of the patch is committed in about two weeks time. At this point, region servers that haven't upgraded past this revision may run into problems * This checkin upgrades the user database. As always, we recommend you have backups in case something goes wrong. * Many thanks to tyre for this patch.
* Mantis #511Melanie Thielker2008-09-101-1/+2
| | | | | | | Allow parsing of hexadecimal int constants from strings. Also fixes a DBNull value in the touch type field crashing the sim