aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/SQLite/SQLiteSimulationData.cs (unfollow)
Commit message (Collapse)AuthorFilesLines
2012-08-15Add a skeleton for a name value storage associated with regionsMelanie1-0/+12
2012-05-23Environment Module - allows Environment settings for Viewer3 warning: ↵PixelTomsen1-1/+100
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>
2012-02-29Use correct casing of RegionSettings.Sandbox in the various database modules.Justin Clark-Casey (justincc)1-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.
2012-02-21Add 64 bit Windows sqlite3.dll and use this if running a 64-bit windows process.Justin Clark-Casey (justincc)1-0/+3
2012-02-17Parcel sales support to SQLiteBlueWall1-0/+3
2012-02-17Fillin missing SQLite support for TelehubsBlueWall1-0/+102
2012-02-14Fix: Lightshare Module(Windlight)-Region settings are not applicable for ↵PixelTomsen1-305/+622
database sqlite mantis: http://opensimulator.org/mantis/view.php?id=5888
2012-02-03Fix: Covenant changed time not set ↵PixelTomsen1-0/+3
http://opensimulator.org/mantis/view.php?id=5869 Signed-off-by: BlueWall <jamesh@bluewallgroup.com>
2012-02-02Replace ParcelAccessEntry with a new struct, LandAccessEntry, which moreMelanie1-6/+6
accurately reflects the data sent by the viewer. Add times bans and the expiration of timed bans. Warning: Contains a Migration (and nuts)
2011-07-16refactor: Pull up Assembly of the SQLite classes as a protected property, so ↵Marck1-2/+6
that it can be overwritten in subclasses. That way extensions can decide in which assembly migration resources should be looked up. This is a refactor similar to commit 9923a2ff1002d722ccebea8bf4d71718ed4e2a03 for MySQL -- no functional changes.
2011-02-11In SQLiteSimulationData.RemoveLandObject(), don't manually remove the row ↵Justin Clark-Casey (justincc)1-6/+0
from the data adaptor's Rows list in addition to calling Delete. This matches the behaviour for other deletions and stops this operation failing on Windows .NET (though mono is fine with the duplication). Probably a holdover from copying code from the older legacy adaptor. Resolves http://opensimulator.org/mantis/view.php?id=5361
2010-11-23Fix joining land parcels not being stored correctly in SQLite. Thank you to ↵Marck1-0/+3
goetz for the initial patch in Mantis #5230.
2010-11-21Added creator info across the board -- TaskInventoryItems and InventoryItems ↵Diva Canto1-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).
2010-11-21Updated SQLite/SQLiteSimulationData to use SOP.CreatorInformation instead of ↵Diva Canto1-2/+2
SOP.CreatorID. Untested, but should work.
2010-11-03Add lsClearWindlightScene() to the lightshare module to remove WL settingsMelanie1-0/+3
from a region and allow normal day cycles to be reestablished
2010-09-23* Add CSharpSqlite to prebuildTeravus Ovares (Dan Olivares)1-1/+5
* Use a conditional define to determine whether we're using CSharpSqlite or Mono.Data.Sqlite #if CSharpSqlite using Community.CsharpSqlite.Sqlite; #else using Mono.Data.Sqlite; #endif * Hopefully, this will restore sqlite functionality on a Mac. In visual studio, you can edit the OpenSim.Data.SQLite project, go to the Build tab and enter CSharpSqlite in the box. I'm not sure how to define CSharpSqlite in Mono, someone better at it then me will have to take the job of figuring out the best way to define it in Mono.
2010-09-16Changed SceneObjectGroup to store parts with the fast and thread-safe ↵John Hurliman1-1/+1
MapAndArray collection
2010-09-12* Added ISimulationDataService and IEstateDataServiceJohn Hurliman1-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
2010-09-12Formatting cleanup.Jeff Ames1-30/+27
2010-09-11Changed all string references of "IRegionDataStore" to "ISimulationDataStore"John Hurliman1-2/+0
2010-09-11Fixed the naming mess around data connectors for simulation dataJohn Hurliman1-1/+1
2010-09-05Remove "Dwell" support from core and replace it with calls to methodsMelanie Thielker1-3/+0
on IDwellModule
2010-08-30Fix a casting operation to use ToString()Melanie1-1/+1
2010-08-30Implements parcel media setting persistence and packet / CAPS handlingJonathan Freedman1-0/+6
properly for the new media settings. Signed-off-by: Melanie <melanie@t-data.com>
2010-08-30local commit with parcel media bitsJonathan Freedman1-0/+6
Signed-off-by: Melanie <melanie@t-data.com>
2010-08-26Remove parts locking from data classes since these are using a copy of the ↵Justin Clark-Casey (justincc)1-6/+3
scene object
2010-08-26Improve consistency of locking for SOG.m_parts in order to avoid race ↵Justin Clark-Casey (justincc)1-3/+6
conditions in linking and unlinking
2010-08-03get rid of PrimitiveBaseShape.MediaRaw staging postJustin Clark-Casey (justincc)1-3/+5
using an OSD serialization rather than auto forces serialization code to be placed in OpenSim.Framework this makes the media texture raw data staging post in PrimitiveBaseShape redundant, now we just directly call the code in PrimitiveBaseShape.MediaList itself
2010-07-26relocate serialization code from SQLiteRegionData to MoapModule using load ↵Justin Clark-Casey (justincc)1-53/+2
and save events. This is better modularity. It also allows MoapModule to be replaced with some other media module that may behave completely differently in the future. Remaining non-modularity: PrimitiveBaseShape needs explicit Media and MediaRaw fields. MediaRaw is required in order to shuttle the pre-serialization data back and forth from the database layer. The database also needs to know about MediaRaw though not about Media. IMO, it would be extremely nice to remove these hard codings but this is a bridge too far at the present time.
2010-07-26Put a wrapper around the media texture region serializationJustin Clark-Casey (justincc)1-15/+43
THIS WILL BREAK EXISTING MEDIA TEXTURE PERSISTENCE. Please delete your existing sqlite databases if you are experimenting with this branch. This wrapper will make it easier to maintain compatibility if the media texture data evolves. This will also make it easier to store non-sl media texture data.
2010-07-26fix bug where prim persistence would fail if media had never been setJustin Clark-Casey (justincc)1-6/+9
2010-07-26fix problem persisting when only one face had a media textureJustin Clark-Casey (justincc)1-2/+8
2010-07-26Implement media texture persistence over server restarts for sqliteJustin Clark-Casey (justincc)1-4/+32
This is currently persisting media as an OSDArray serialized to LLSD XML.
2010-07-26relocate serialization code from SQLiteRegionData to MoapModule using load ↵Justin Clark-Casey (justincc)1-53/+2
and save events. This is better modularity. It also allows MoapModule to be replaced with some other media module that may behave completely differently in the future. Remaining non-modularity: PrimitiveBaseShape needs explicit Media and MediaRaw fields. MediaRaw is required in order to shuttle the pre-serialization data back and forth from the database layer. The database also needs to know about MediaRaw though not about Media. IMO, it would be extremely nice to remove these hard codings but this is a bridge too far at the present time.
2010-07-26Put a wrapper around the media texture region serializationJustin Clark-Casey (justincc)1-15/+43
THIS WILL BREAK EXISTING MEDIA TEXTURE PERSISTENCE. Please delete your existing sqlite databases if you are experimenting with this branch. This wrapper will make it easier to maintain compatibility if the media texture data evolves. This will also make it easier to store non-sl media texture data.
2010-07-14fix bug where prim persistence would fail if media had never been setJustin Clark-Casey (justincc)1-6/+9
2010-07-12fix problem persisting when only one face had a media textureJustin Clark-Casey (justincc)1-2/+8
2010-07-01Implement media texture persistence over server restarts for sqliteJustin Clark-Casey (justincc)1-4/+32
This is currently persisting media as an OSDArray serialized to LLSD XML.
2010-06-04Fix bug where prim items were not loaded in the new sqlite database handlerJustin Clark-Casey (justincc)1-27/+39
This addresses mantis http://opensimulator.org/mantis/view.php?id=4739
2010-05-09* Fixed spamming the assets table with map tiles. The tile image ID is now ↵Diva Canto1-0/+3
stored in regionsettings. Upon generation of a new tile image, the old one is deleted. Tested for SQLite and MySql standalone. * Fixed small bug with map search where the local sim regions weren't found.
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