aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL/MySQLRegionData.cs (unfollow)
Commit message (Collapse)AuthorFilesLines
2009-01-29* If an orphaned group is found in the mysql or mssql databases (i.e. there ↵Justin Clarke Casey1-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
2008-12-23* Fix http://opensimulator.org/mantis/view.php?id=2889Justin Clarke Casey1-2/+2
* Primshapes uuid wasn't being converted to raw (non-dashed) format before being used in primshapes delete command
2008-12-08change a UUID cast to an actual new UUID call to be consistant withSean Dague1-1/+1
the rest of the assignments here.
2008-12-08fix an issue I found where primshapes weren't every being removedSean Dague1-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.
2008-12-02* Resolve http://opensimulator.org/mantis/view.php?id=2743 and ↵Justin Clarke Casey1-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
2008-12-02Catch all possible exceptions in the mysql module. It throws non-mysqlMelanie Thielker1-2/+2
exceptions as well.
2008-12-01Fix the terrain loaderMelanie Thielker1-1/+1
2008-12-01More reverts. Revert the MySQL database module. This caused more issuesMelanie Thielker1-474/+513
than it solved by trying to use, and then exhausting, the connection pool
2008-11-30More changes to the MySQL adapter. take advantage of pooling and run lock-free.Melanie Thielker1-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
2008-11-30Update svn properties. Add copyright header. Minor formatting cleanup.Jeff Ames1-1/+1
2008-11-29Explicitly Dispose() all cmd objectsMelanie Thielker1-1/+15
2008-11-27* minor: remove mono compiler warningsJustin Clarke Casey1-1/+0
2008-11-26* restore deleted method documentation, some to IRegionDataStore and some to ↵Justin Clarke Casey1-1/+10
MySQLRegionData * I would like to keep documentation on methods, even if it sometimes seems obvious (and not all of these are)
2008-11-26Yay for unit tests. Increased the type width of the prims and primshapesMelanie Thielker1-38/+38
tables, and changed the database modules to actually push these doubles down into the database layer.
2008-11-26Fix 2 of the failed tests. Cause terrain queries to return null when noMelanie Thielker1-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.
2008-11-26Committing the LCO database layer. Native MySQL, no ADO. New reconnectMelanie Thielker1-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.
2008-11-23Remove code from an experimantal patch that wasn't supposed to be committedMelanie Thielker1-39/+13
2008-11-23Don't serve texture preview from other people's objects if youMelanie Thielker1-13/+39
havenever seen that texture before.
2008-11-21* refactor: Rip out SOP inventory from the partial into a separate classJustin Clarke Casey1-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
2008-11-19Mantis#2656. Thank you kindly, Nlin for a patch that:Charles Krinke1-0/+9
Attached patch implements llCollisionSound. Thanks T. Sado.
2008-11-18Fixed MySQL and SQLite so they will save theSean Dague1-0/+11
variable sun vector, adding 3 new fields on both. From: Arthur Rodrigo S Valadares <arthursv@linux.vnet.ibm.com>
2008-11-16Make a quick stab at the "Open data reader" issue.Melanie Thielker1-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.
2008-11-15Mantis#2552: Thanks idb, for a patch that fixes persistence of physical prims.Homer Horwitz1-2/+1
(added a fix for the broken build from last commit, too)
2008-11-10* refactor: Expose SOG.SetRootPart for outsiders to use rather than setting ↵Justin Clarke Casey1-2/+2
RootPart and adding the part separately * Make RootPart read only
2008-11-08Mantis#2598: Thanks Fly-Man- for a patch that fixes a client-thread crash byHomer Horwitz1-1/+1
allowing landFlags bit 31 to be used (Int32 -> UInt32).
2008-10-30- Includes consistency test for new and updated objects, asSean Dague1-3/+2
some fixes in MySQL and SQLite From: Arthur Rodrigo S Valadares <arthursv@linux.vnet.ibm.com>
2008-10-30Mid-work, trying to fix region part insertion and retrievalSean Dague1-7/+29
SQLite reports System NUll Reference, but works, inside LoadItems, on SQLiteRegionData.cs From: Arthur Rodrigo S Valadares <arthursv@linux.vnet.ibm.com>
2008-10-18Megapatch. :) Fix skull attachment editing. Streamline Object terse updates.Melanie Thielker1-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.
2008-10-15* minor: comment out persisting prim inventory log messagesJustin Clarke Casey1-1/+1
2008-10-03Add database persistence for material settingMelanie Thielker1-0/+5
2008-10-01add delete prim tests. Found and fixed bugs where regionSean Dague1-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.
2008-09-26* Patch from JHurlimanTeravus Ovares1-3/+3
* Updates to libomv r2243, * Remove lots of unnecessary typecasts * Improves SendWindData() Thanks jhurliman. * Will update OpenSim-libs in 10 minutes..
2008-09-25removal of more dead alter table codeSean Dague1-39/+2
2008-09-18- Add Dispose method to IRegionDataStoreHomer Horwitz1-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)
2008-09-10Mantis #511Melanie Thielker1-1/+2
Allow parsing of hexadecimal int constants from strings. Also fixes a DBNull value in the touch type field crashing the sim
2008-09-10Thanks, nlin, for a patch implementing persistence for "When Left Clicked"Mike Mazur1-0/+5
object property. Fix issue 2149.
2008-09-08Implement proper persistence of the following prim properties:Melanie Thielker1-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.
2008-09-06* This is the fabled LibOMV update with all of the libOMV types from JHurlimanTeravus Ovares1-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.
2008-09-02apparently I missed one of the old version routines that could beSean Dague1-39/+0
removed. Removing that now.
2008-08-27we're past checkin 6000, so now cleaning up all the cruft of the preSean Dague1-302/+3
migration database upgrade paths. This is coming in in stages.
2008-08-24Selling an object in-place (as original) now works. Builders canMelanie Thielker1-2/+14
now ply their trade. Is that nuts?
2008-08-24Plumb the data path for all those eye candy values. Saves textureMelanie Thielker1-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.
2008-08-18Formatting cleanup.Jeff Ames1-60/+59
2008-08-16* Rename *DataStore classes to *RegionData to align with SQLiteJustin Clarke Casey1-0/+0
2008-08-07Minor formatting cleanup.Jeff Ames1-2/+2
2008-07-26The hazards if unclean sourc trees. Yours truly got bitten this time.Melanie Thielker1-2/+4
Re-fix the re-fix from a clean build. This makes the region based settings work as advertised
2008-07-26Re-Fix the fixMelanie Thielker1-1/+1
2008-07-26Fix Mantis #1830Melanie Thielker1-0/+1
Makes region settings save on second and subsequent sim restarts after upgrading.
2008-07-25Patch #9155 (Mantis #1793)Melanie Thielker1-0/+1
Fix a regression that caused the region settings not to save. Still no SQLite support for region settings. MySQL now functional.
2008-07-23refactor TaskInventoryItem Mask -> Permissions to be consistant with how thingsSean Dague1-10/+10
are stored in the db.