aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL/MySQLRegionData.cs (follow)
Commit message (Collapse)AuthorAgeFilesLines
* * If an orphaned group is found in the mysql or mssql databases (i.e. there ↵Justin Clarke Casey2009-01-291-1/+15
| | | | | | | | | | | | is no prim where UUID = SceneGroupID), then force one prim to have UUID = SceneGroupID. * A warning is posted about this on startup giving the location of the object * This should allow one class of persistently undeletable prims to be removed * This change should not cause any issues, but I still suggest that you backup your database beforehand * If this doesn't work for previously linked objects, then you could also try the workaround in http://opensimulator.org/mantis/view.php?id=3059 * This change has been made to mysql and mssql, but sqlite appears to work in a different way
* * Fix http://opensimulator.org/mantis/view.php?id=2889Justin Clarke Casey2008-12-231-2/+2
| | | | | | * Primshapes uuid wasn't being converted to raw (non-dashed) format before being used in primshapes delete command
* change a UUID cast to an actual new UUID call to be consistant withSean Dague2008-12-081-1/+1
| | | | | the rest of the assignments here.
* fix an issue I found where primshapes weren't every being removedSean Dague2008-12-081-9/+82
| | | | | | | | because of a logic error. attempt to speed up deletes a bit by batching up all the primitem deletes and primshape deletes into single delete statements. This removes the lock/release/lock/release/lock/release for loop.
* * Resolve http://opensimulator.org/mantis/view.php?id=2743 and ↵Justin Clarke Casey2008-12-021-5/+3
| | | | | | | | | | | | http://opensimulator.org/mantis/view.php?id=2739 by no longer bothering to store or retrieve the local parentID in the region database * The original issue is that the now randomly generated local ids do not fit into the int parentID datatype * However, as far as I know it's actually pointless to store this local parent ID anyway (we already store the groupUUID), especially as we don't bother to store the localID (as opposed to UUID itself). * Conservatively, the actual column will be removed in a later commit
* Catch all possible exceptions in the mysql module. It throws non-mysqlMelanie Thielker2008-12-021-2/+2
| | | | | | exceptions as well.
* Fix the terrain loaderMelanie Thielker2008-12-011-1/+1
|
* More reverts. Revert the MySQL database module. This caused more issuesMelanie Thielker2008-12-011-474/+513
| | | | | | than it solved by trying to use, and then exhausting, the connection pool
* More changes to the MySQL adapter. take advantage of pooling and run lock-free.Melanie Thielker2008-11-301-507/+472
| | | | | | | | This should finally kill the "There is already an open data reader associated with this connection, which must be closed first" error that makes people's builds not save
* Update svn properties. Add copyright header. Minor formatting cleanup.Jeff Ames2008-11-301-1/+1
|
* Explicitly Dispose() all cmd objectsMelanie Thielker2008-11-291-1/+15
|
* * minor: remove mono compiler warningsJustin Clarke Casey2008-11-271-1/+0
|
* * restore deleted method documentation, some to IRegionDataStore and some to ↵Justin Clarke Casey2008-11-261-1/+10
| | | | | | | | MySQLRegionData * I would like to keep documentation on methods, even if it sometimes seems obvious (and not all of these are)
* Yay for unit tests. Increased the type width of the prims and primshapesMelanie Thielker2008-11-261-38/+38
| | | | | | | tables, and changed the database modules to actually push these doubles down into the database layer.
* 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-261-1472/+740
| | | | | | | | 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.
* * 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
* Mantis#2656. Thank you kindly, Nlin for a patch that:Charles Krinke2008-11-191-0/+9
| | | | | | Attached patch implements llCollisionSound. Thanks T. Sado.
* Fixed MySQL and SQLite so they will save theSean Dague2008-11-181-0/+11
| | | | | | | 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)
* * 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).
* - 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-181-0/+6
| | | | | | | | 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.
* * minor: comment out persisting prim inventory log messagesJustin Clarke Casey2008-10-151-1/+1
|
* Add database persistence for material settingMelanie Thielker2008-10-031-0/+5
|
* 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.
* * 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
|
* - 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 #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
* Thanks, nlin, for a patch implementing persistence for "When Left Clicked"Mike Mazur2008-09-101-0/+5
| | | | | | object property. Fix issue 2149.
* Implement proper persistence of the following prim properties:Melanie Thielker2008-09-081-3/+17
| | | | | | | | | Floating text, Rotation, Texture animation, Particle System This will make "Eye Candy" scripts work without modification in XEngine. The use of the CHANGED_REGION_RESTART hack is no longer needed. Implemented in MySQL only, hovertext also in SQLite.
* * This is the fabled LibOMV update with all of the libOMV types from JHurlimanTeravus Ovares2008-09-061-69/+69
| | | | | | | * 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.
* apparently I missed one of the old version routines that could beSean Dague2008-09-021-39/+0
| | | | | | removed. Removing that now.
* we're past checkin 6000, so now cleaning up all the cruft of the preSean Dague2008-08-271-302/+3
| | | | | | migration database upgrade paths. This is coming in in stages.
* Selling an object in-place (as original) now works. Builders canMelanie Thielker2008-08-241-2/+14
| | | | | | now ply their trade. Is that nuts?
* Plumb the data path for all those eye candy values. Saves textureMelanie Thielker2008-08-241-55/+139
| | | | | | | | animation, target omega, looped sound, script access pin, allowed drop state and sale data. Loads it, too. Not all tested. Code: No Nuts. Data: Cannot Guarantee Nut Free.
* Formatting cleanup.Jeff Ames2008-08-181-60/+59
|
* * Rename *DataStore classes to *RegionData to align with SQLiteJustin Clarke Casey2008-08-161-0/+2360