aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL/MySQLRegionData.cs (unfollow)
Commit message (Collapse)AuthorFilesLines
2009-02-12* optimized usings.lbsa711-4/+4
2009-02-06This changeset is the step 1 of 2 in refactoringDr Scofield1-2/+2
OpenSim.Region.Environment into a "framework" part and a modules only part. This first changeset refactors OpenSim.Region.Environment.Scenes, OpenSim.Region.Environment.Interfaces, and OpenSim.Region.Interfaces into OpenSim.Region.Framework.{Interfaces,Scenes} leaving only region modules in OpenSim.Region.Environment. The next step will be to move region modules up from OpenSim.Region.Environment.Modules to OpenSim.Region.CoreModules and then sort out which modules are really core modules and which should move out to forge. I've been very careful to NOT BREAK anything. i hope i've succeeded. as this is the work of a whole week i hope i managed to keep track with the applied patches of the last week --- could any of you that did check in stuff have a look at whether it survived? thx!
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.