aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL (follow)
Commit message (Collapse)AuthorAgeFilesLines
* Yay for unit tests. Increased the type width of the prims and primshapesMelanie Thielker2008-11-262-75/+79
| | | | | | | tables, and changed the database modules to actually push these doubles down into the database layer.
* A migration to make the floats in prims table be doublesMelanie Thielker2008-11-261-0/+41
|
* A migration to convert the floats int the database to doubles.Melanie Thielker2008-11-262-0/+60
| | | | | | Maybe we don't have to say "Shift happens" as often anymore....
* Fix 2 of the failed tests. Cause terrain queries to return null when noMelanie Thielker2008-11-261-1/+1
| | | | | | | | | terrain is found, rather than a default "0" terrain. Remove the "remove object wrong region" test. UUIDs either are unique or they're not. This test tested a bad behavior I have chosen not to duplicate.
* Committing the LCO database layer. Native MySQL, no ADO. New reconnectMelanie Thielker2008-11-262-1472/+746
| | | | | | | | mechanism to prevent prim loss. Preserve link order on sim restart and drag copy. Fix drag-copied prims' inventories. Fix persistence of child prim inventories.
* Remove code from an experimantal patch that wasn't supposed to be committedMelanie Thielker2008-11-231-39/+13
|
* Don't serve texture preview from other people's objects if youMelanie Thielker2008-11-231-13/+39
| | | | | | havenever seen that texture before.
* Plumb in the presence notifications and region shutdown/restart messagesMelanie Thielker2008-11-231-0/+26
| | | | | | | | | from the presence module to the message server, through the user server and on into the database. This should fix the "Already logged in" issue that grids see after a sim crashes, or a user crashes out of a sim. Not yet a 100% solution for friends, but getting there.
* * 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.