aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL/MySQLSimulationData.cs (follow)
Commit message (Collapse)AuthorAgeFilesLines
* Remove some use of database connection locking from MySQLSimulationData - ↵Justin Clark-Casey (justincc)2014-08-221-318/+298
| | | | | | | | | this has not been necessary for some time as database connections are not shared. However, many locks remain since they may effectively be providing transactionality in some operations (e.g. prim updates across multiple tables). These are candidates for being replaced with proper database transactions, since this would not block unrelated operations (e.g. land save and object save) or unrelated operations on the same tables (e.g. storage of one linkset whilst another is being removed). In practice, any performance deg due to contention is probably rare and short lived as the major prim operations are performed in memory and only persisted some time afterwards.
* Fix a bug in previous commit 01520bb where I accidentally saved ↵Justin Clark-Casey (justincc)2014-03-181-1/+1
| | | | OtherCleanTime instead of Dwell
* Save and load dwell parcel stat in MySQL DB adaptor. Field in table already ↵Justin Clark-Casey (justincc)2014-03-181-3/+4
| | | | | | exists! The SQLite database adaptor was loading and saving dwell whilst MySQL was not, even though the field already exists in the db table.
* Repair database routines so they properly return null when asked forRobert Adams2014-01-281-1/+5
| | | | the heighmap of a region that does not exist.
* varregion: push TerrainData implementation up and down the database storage ↵Robert Adams2013-11-011-21/+11
| | | | | | | stack. Implement both LoadTerrain and StoreTerrain for all DBs. Move all database blob serialization/deserialization into TerrainData.
* varregion: plug in TerrainData class and modify TerrainModule and ↵Robert Adams2013-10-071-30/+17
| | | | LLClientView to use same. This passes a terrain info class around rather than passing a one dimensional array thus allowing variable regions. Update the database storage for variable region sizes. This should be downward compatible (same format for 256x256 regions).
* Remove time based terrain storage in SQLite so revision number can be usedRobert Adams2013-09-281-3/+4
| | | | | | | to denote terrain format revision. Add terrain DB format revision codes to ISimulationDataStore.cs. Setup so legacy compatible terrain storage and fetch is possible while allowing future format extensions.
* Preserve attachment point & position when attachment is rezzed in worldAleric Inglewood2013-09-221-5/+24
| | | | | | | | | | Patch taken from http://opensimulator.org/mantis/view.php?id=4905 originally by Greg C. Fixed to apply to r/23314 commit ba9daf849e7c8db48e7c03e7cdedb77776b2052f (cherry picked from commit 4ff9fbca441110cc2b93edc7286e0e9339e61cbe)
* Make the concept of namespaces explicit in dynamic attributesJustin Clark-Casey (justincc)2013-06-271-1/+1
| | | | | | | | This is in order to reduce the likelihood of naming clashes, make it easier to filter in/out attributes, ensure uniformity, etc. All dynattrs in the opensim distro itself or likely future ones should be in the "OpenSim" namespace. This does alter the underlying dynattrs data structure. All data in previous structures may not be available, though old structures should not cause errors. This is done without notice since this feature has been explicitly labelled as experimental, subject to change and has not been in a release. However, existing materials data is being preserved by moving it to the "Materials" store in the "OpenSim" namespace.
* * This fixes having to select and deselect prim to get keyframemotion to ↵teravus2013-06-121-2/+0
| | | | start running when pulled from data storage.
* Database persistence for keyframes. Contains a Migration.Melanie2013-06-061-4/+25
|
* Recover a lost "virtual". Downstream projects need this.Diva Canto2013-04-251-1/+1
|
* Added physics parameters support to MSSQL and SQLite (not tested)Oren Hurvitz2013-02-091-9/+10
|
* Rename "Bounciness" to "Restitution"Melanie2013-02-071-2/+2
|
* Fix a bug I brought in by manually editing a diff file. Terrain is if cource ↵Melanie2013-02-061-1/+1
| | | | not always at 20m.
* Partial port of Avination's support for the new physics parameters.Melanie2013-02-061-18/+38
| | | | | | | | Implements the parameters as properties, the serialization and database storage (MySQL only). Implements llSetPrimitiveParams for prim physics shape and the other 4 extra params. Only the prim shape type "None" is currently functional. No support for the Viewer UI (yet), that will be ported in due course. Lots more to port, this is a large-ish changeset.
* Store NULL in the 'DynAttrs' column if the prim doesn't have any dynamic ↵Oren Hurvitz2013-01-251-1/+5
| | | | attributes
* Stopped storing dynamic attributes in the PrimShapeOren Hurvitz2013-01-251-8/+2
|
* Added missing DynAttrs references in MySQLOren Hurvitz2013-01-251-3/+6
|
* Encapsulate an OSDMap in DAMap (was DynAttrsOSDMap) rather than inheriting ↵Justin Clark-Casey (justincc)2013-01-251-4/+4
| | | | | | from it This is the easier way to give us control over locking, rather than asking that OSDMap IDictionary methods be virtual
* Implement dynamic attribute persistence on mysql and mssqlJustin Clark-Casey (justincc)2013-01-251-2/+14
| | | | mssql is untested
* Also do other MySQL region settings related calls under m_dbLock, in common ↵Justin Clark-Casey (justincc)2012-08-311-117/+130
| | | | with other calls.
* Do Windlight storage and removal calls in MySQL under m_dbLock, as is done ↵Justin Clark-Casey (justincc)2012-08-311-102/+108
| | | | with all the other database calls.
* Fix and finish the extra parameters storage system for MySQLMelanie2012-08-151-1/+57
|
* Add a skeleton for a name value storage associated with regionsMelanie2012-08-151-0/+13
|
* Environment Module - allows Environment settings for Viewer3 warning: ↵PixelTomsen2012-05-231-0/+62
| | | | | | | | | | | | | includes database region store migrations for mssql, mysql, sqlite enable/disable this module: Cap_EnvironmentSettings = "localhost" (for enable) Cap_EnvironmentSettings = "" (for disable) at ClientStack.LindenCaps section (OpenSimDefaults.ini file) or owerwrite in OpenSim.ini mantis: http://opensimulator.org/mantis/view.php?id=5860 Signed-off-by: BlueWall <jamesh@bluewallgroup.com>
* If there are no new prim items to store then don't bother opening the ↵Justin Clark-Casey (justincc)2012-04-301-3/+3
| | | | MySqlConnection only to do nothing with it.
* Consistently use using() to make sure we dispose of used MySqlCommands where ↵Justin Clark-Casey (justincc)2012-04-301-134/+133
| | | | this is not already being done.
* Use correct casing of RegionSettings.Sandbox in the various database modules.Justin Clark-Casey (justincc)2012-02-291-1/+1
| | | | | | MySQL and MSSQL have it as Sandbox, sqlite as sandbox. In various different places in every plugin the wrong casing is used... Consistency, who needs it? Or one day sqlite can change to Sandbox.
* Fix: Covenant changed time not set ↵PixelTomsen2012-02-031-3/+4
| | | | | | http://opensimulator.org/mantis/view.php?id=5869 Signed-off-by: BlueWall <jamesh@bluewallgroup.com>
* Replace ParcelAccessEntry with a new struct, LandAccessEntry, which moreMelanie2012-02-021-8/+9
| | | | | | accurately reflects the data sent by the viewer. Add times bans and the expiration of timed bans. Warning: Contains a Migration (and nuts)
* Add ParcelImageID to RegionSettings so we can have that overlay.Melanie2012-01-301-2/+4
| | | | | Warning: Contains a Migration. Warning: May contain nuts.
* Add a forgotten parameterMelanie2012-01-241-1/+1
|
* Change Telehubs to store only the data that is really needed and notMelanie2012-01-241-40/+13
| | | | additional redundant information.
* Fix up some parameter namingMelanie2012-01-221-2/+2
|
* Finish connecting Telehub to databaseBlueWall2012-01-221-3/+19
|
* Hooking up new telehub data to the databaseBlueWall2012-01-221-0/+14
|
* Move Telehub tables and data from EstateSettings to RegionSettings.Melanie2012-01-221-0/+70
| | | | | | | | | | This is damage control es EstateSettings is not the place this can be put. EstateSettings is nt unique to a region and therefore would introduce a hard limit of one telehub per estate, completely shutting off the option of having SL style telehubs, e.g. one per region. Whole estate teleport routing can still be implemented id desiresd, this way all options are open while the other way most options get closed off.
* Save the default terrain texture UUIDs for a new region instead of leaving ↵Justin Clark-Casey (justincc)2011-09-091-1/+0
| | | | | | | | | | | them as UUID.Zero. Leaving them at UUID.Zero meant that when a viewer 2 logged into a region that had been freshly created, it received UUID.Zero for these textures, and hence display the land as plain white. On a simulator restart, the problem would go away since when the database adapators loaded the new region settings, RegionSettings itself has code to use default textures instead of UUID.Zero. This commit resolves the problem by saving the default texture UUIDs instead of Zero. However, we currently have to do this in a roundabout way by resaving once the RegionSettings have been created by the database for the first time. This needless complexity should be addressed. This change will also have the effect of replacing any existing UUID.Zero terrain textures with the default ones. However, this shouldn't have any effect since the UUID.Zeros were already being replaced in memory with those same UUIDs.
* Remove code which was automatically deleting non-root prims from scene ↵Justin Clark-Casey (justincc)2011-09-011-17/+0
| | | | | | | objects that had previous been attachments. Looks like this code was accidentally uncommented in e1b5c612 from feb 2010. Appears to resolve the rest of http://opensimulator.org/mantis/view.php?id=5664
* Pull up Assembly of the MySQL classes as a protected property, so that it ↵Diva Canto2011-03-081-2/+6
| | | | can be overwritten in subclasses. That way extensions can decide in which assembly migration resources should be looked up. This is just a refactor -- no functional changes whatsoever.
* Added creator info across the board -- TaskInventoryItems and InventoryItems ↵Diva Canto2010-11-211-2/+2
| | | | | | themselves. Tested. Seems to be working, main tests pass. Nothing done for IARs or HG transfers yet -- this only works for OARs for the time being. New migration in inventory table in order to make CreatorID varchar(255).
* Global creator information working on MySQL DB and on load/save OARs. ↵Diva Canto2010-11-211-2/+2
| | | | | | | Creator name properly shown on the viewer as first.last @authority. New option added to save oar -profile=url. Migration on RegionStore making CreatorID be 255 chars. Moved Handling of user UUID -> name requests to a new module UserManagement/UserManagementModule.
* Add lsClearWindlightScene() to the lightshare module to remove WL settingsMelanie2010-11-031-0/+15
| | | | from a region and allow normal day cycles to be reestablished
* When LightShare is enabled, the standard day cycle is bypassed and replaced byMelanie2010-11-031-0/+1
| | | | | | midday defaults when no specific LightShare profile is set. This prevents LightShare info being send out when the region has no LightShare profile, allowing normal day/night cycles to happen.
* UPdated the MySql driver to 6.2.4. Also established a much larger ↵Diva Canto2010-10-151-0/+1
| | | | MySqlCommand timeout on fetching prims.
* Changed SceneObjectGroup to store parts with the fast and thread-safe ↵John Hurliman2010-09-161-1/+1
| | | | MapAndArray collection
* MergedJohn Hurliman2010-09-121-11/+11
|\
| * Formatting cleanup.Jeff Ames2010-09-121-11/+11
| |
* | * Added ISimulationDataService and IEstateDataServiceJohn Hurliman2010-09-121-0/+9
|/ | | | | * Removed StorageManager * CONFIG CHANGE: There are no more database settings in OpenSim.ini. Check the config-include configuration files for region store and estate store database settings