aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/SQLite/SQLiteRegionData.cs (unfollow)
Commit message (Collapse)AuthorFilesLines
2010-04-30take out some debug logging in the sqlite db adaptorJustin Clark-Casey (justincc)1-3/+3
2010-04-30rename SQLiteNG to SQLite and SQLite to SQLiteLegacyJustin Clark-Casey (justincc)1-101/+158
this seems the least evil way forward since mono 2.6 and later will see increasing usage, and this only works with what was SQLiteNG MAC USERS WILL NEED TO CHANGE REFERENCES TO "OpenSim.Data.SQLite.dll" to "OpenSim.Data.SQLiteLegacy.dll" in OpenSim.ini and config-include/StandaloneCommon.ini (if using standalone) See the OpenSim.ini.example and StandaloneCommon.ini.example files for more details This commit also temporarily changes unsigned ParentEstateID values in the OpenSim.Data.Tests to signed temporarily, since the new plugin enforces creation of signed fields in the database (which is what the SQL actually specifies). And change data columns in sqlite is a pita.
2010-03-31Committing the LightShare code, which was developed by TomMeta of Meta7.Melanie1-2/+11
This allows scripts to set WindLight parameters for clients connecting to a region. Currently, this is only supported by the Meta7 viewer.
2010-02-13* SQLite match code casing with regionsettings table field casing (what's ↵Teravus Ovares (Dan Olivares)1-1/+1
with the upper case S in Sandbox while the rest is lower case 0.o) * It's doubtful that this will have any effect on mantis http://opensimulator.org/mantis/view.php?id=4577 . Sqlite 3 is required, Sqlite 2 was reported.
2010-02-13* This is an attempt to resolve mantis 4437 by using SqliteAdapter type ↵Teravus Ovares (Dan Olivares)1-11/+100
statements instead of blanket SQL statements. The hope is that this makes SQLite work on Linux/Mono again. Re: http://opensimulator.org/mantis/view.php?id=4437 * Added a 'Create Update Statement' method that takes two fields for a primary key * Added an Update and Delete command for parcels and land access list table rows.
2009-11-02Removing duplicate SceneObjectPart.RotationalVelocity propertyJohn Hurliman1-4/+4
2009-10-02* Creates Util.UTF8 and switches some references of Encoding.UTF8 to ↵John Hurliman1-5/+9
Util.UTF8 (not all references were switched since not all OpenSim libraries reference OpenSim.Framework) * Shrinks the largest in-memory object, the LLRAW.HeightmapLookupValue struct (only used for exporting to LLRAW terrain files), to the minimum possible size. This seems to have the odd side effect of cutting the size of the two double[256,256] terrain objects in half. Possibly an alignment optimization?
2009-10-02reducing region DB log spamdr scofield (aka dirk husemann)1-1/+1
2009-10-02- cleaning up LandData/ILandObject capitalization issuesdr scofield (aka dirk husemann)1-6/+6
- adding LandDataSerializer to OAR mechanics
2009-10-01Formatting cleanup.Jeff Ames1-1/+1
2009-09-16SceneObjectGroup cleanup. Removes the default constructor and unnecessary ↵John Hurliman1-2/+1
null checks on m_rootPart
2009-08-16* Modified SQLite/SQLiteInventoryStore.cs to not throw if the inventory row ↵Kunnis1-17/+12
does not exist, to match the mysql behavior. * Modified SQLite/SQLiteRegionData.cs to only persist temporary items following the same rules mysql uses. * Added another ignore to the inventory test that was missing. * Added a few more ignores to the RegionTest that the first version of my test were missing. * Added ignoring the root Folder ID, which is set by the inventory system. * Added several improvements to the PropertyCompareConstraint: Protection against infinite loops, added IComparable<T> (for UUID) and moved IComparable before the property matching. * Fixed a bug where I was saving the inside of the ignore expression instead of the outside of it.
2009-08-09Formatting cleanup.Jeff Ames1-1/+1
2009-08-07* Remove hard coded 256 limitations from various places. There's no more ↵Teravus Ovares (Dan Olivares)1-9/+9
256m limitation within the OpenSimulator framework, however, the LLClient ClientView does not support regions larger then 256 meters so, if you try and make your region larger by setting Constants.RegionSize = 512; in OpenSim.Framework.Constants.cs, the terrain will not display on clients using the LLUDP protocol
2009-07-25* Updates libOMV to version 0.7.0Teravus Ovares1-2/+2
* Uses mantis #3811 as a base (thanks jhuliman) with changes. * E-mail regarding interface changes sent to the opensim-dev list * Archive: https://lists.berlios.de/pipermail/opensim-dev/2009-July/007219.html
2009-07-10* Added a user friendly message to the sqlite regionsettings saver giving ↵Teravus Ovares1-1/+17
them troubleshooting options and telling them to restart the simulator. This situation, hopefully is temporary and generates an exception when sqlite users first start OpenSimulator because of an unexpected condition in the database layer. Restart and all is well. * Added a user friendly message to the 'No IInventoryService available' condition with troubleshooting options.
2009-06-19more type clean fixes for mono 2.4.2Sean Dague1-8/+8
2009-06-01Minor: Change OpenSim to OpenSimulator in older copyright headers and ↵Jeff Ames1-1/+1
LICENSE.txt.
2009-05-07* Consistently use dashed uuid format for sqlite region data, as was ↵Justin Clarke Casey1-38/+35
previously done for sqlite inventory data. * This revision contains a data migration. Please backup your sqlite region db as a precaution before using this code * I also advise that you do a runprebuild[.sh|.bat] and a clean build ("nant clean build" if you're using the command line). * This change is needed for future id schemes
2009-02-25* Refactored SOP.FolderID weirdness by removing calls to empty setter. YEs, ↵lbsa711-7/+0
I do realize the setter has to be there for legacy reasons, but since the calls will never acually DO anyhting, I'm removing them. * So, SOP.FolderID is actually a cruft field that should be removed.
2009-02-12* optimized usings.lbsa711-3/+2
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/+4
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
2009-01-19* Remove unused prims.ParentID field from SQLite and MySQLJustin Clarke Casey1-4/+3
* Since this is a db change, as always I strongly recommend that you backup your database before updating to this revision * Haven't touched MSSQL in case I get it wrong - looking for some kind soul to take care of this.
2008-12-22Thanks Gerhard for a patch that implements part 3 of VolumeDetection / ↵Dahlia Trimble1-0/+10
persistance
2008-12-14Color was set twice, first correctly, then incorrectly, in SQLiteRegionData.Homer Horwitz1-2/+0
Removed the second set. Fixes Mantis#2380.
2008-12-02* Resolve http://opensimulator.org/mantis/view.php?id=2743 and ↵Justin Clarke Casey1-3/+0
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-11-30Try to fix Mantis#2727. SQLite seems to be able to store bigger numbers inHomer Horwitz1-1/+1
an INTEGER column (using 6 bytes), but the mapping was wrong. Question: Should we move localIDs to int instead of uint to save some bytes?
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/+10
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-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-4/+3
RootPart and adding the part separately * Make RootPart read only
2008-10-30- Includes consistency test for new and updated objects, asSean Dague1-13/+4
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-8/+34
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/+7
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-03fix the sqlite break. There were two issue here:Sean Dague1-1/+2
1. type issues on column create in ado.net 2. not setting a field in the ado.net row translates into explicitely setting it to null in sqlite land (because it can't read the defaults stanzas out of the database) Things should work again after this.
2008-10-03Add database persistence for material settingMelanie Thielker1-0/+6
2008-10-01add delete prim tests. Found and fixed bugs where regionSean Dague1-1/+1
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-29add a test for updating region settings and fix a bug in uuidSean Dague1-1/+1
translation in sqlite uncovered by this test.
2008-09-26* Patch from JHurlimanTeravus Ovares1-5/+5
* Updates to libomv r2243, * Remove lots of unnecessary typecasts * Improves SendWindData() Thanks jhurliman. * Will update OpenSim-libs in 10 minutes..
2008-09-24remove a bunch of out of date inline ALTER table commands that would onlySean Dague1-84/+17
confuse people.
2008-09-19Small formatting cleanup, before chi11ken notices. Me bad.Homer Horwitz1-10/+19
2008-09-18- Add Dispose method to IRegionDataStoreHomer Horwitz1-0/+40
- 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-18* Updates the SQLite region database to support the same properties that the ↵Teravus Ovares1-0/+152
MySQL version does for the table, prims. * If this causes any unit tests to fail, the tests need to be updated.
2008-09-16Added some terrain tests, and found a fun race condition in the sqliteSean Dague1-15/+15
terrain driver in the process, which is now fixed. yay for unit tests!
2008-09-13* Adds regiondata and estatedata persistence in Sqlite. This commit is ↵Teravus Ovares1-0/+3
actually an assist. 99% of the work was already done by Melanie.
2008-09-13Formatting cleanup.Jeff Ames1-1/+1
2008-09-13* Fixes SQLite load crash. Teravus Ovares1-2/+3
* added primary key to regionsettings table in the cached table * initialized the data adapter. * Still untested fully, so watch out!
2008-09-13Add region settings support to SQLite (untested!)Melanie Thielker1-1/+183