aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/SQLite (unfollow)
Commit message (Collapse)AuthorFilesLines
2012-06-07Add the ability to query the MYSQL databse for a list of the stored prim UUIDsMelanie1-0/+4
2012-05-23Environment Module - allows Environment settings for Viewer3 warning: ↵PixelTomsen2-1/+111
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)7-0/+20
2012-02-17Parcel sales support to SQLiteBlueWall2-1/+10
2012-02-17Fillin missing SQLite support for TelehubsBlueWall2-0/+118
2012-02-14Fix: Lightshare Module(Windlight)-Region settings are not applicable for ↵PixelTomsen2-305/+692
database sqlite mantis: http://opensimulator.org/mantis/view.php?id=5888
2012-02-10Fix: Unable to remove AV from friend list (sqldb-bug) ↵PixelTomsen1-1/+1
http://opensimulator.org/mantis/view.php?id=3731
2012-02-03Fix: Covenant changed time not set ↵PixelTomsen2-1/+9
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)
2012-02-02Make ban, eject, freeze and the scripted versions of those work.Melanie1-6/+6
2011-09-20Remove vestigal OpenSim.Data mono addins extension points that don't look ↵Justin Clark-Casey (justincc)1-20/+0
like they've been active for at least 2 and a half years
2011-09-16Reattaching a region was failing if the estate name had not changed (issue ↵Kevin Houlihan1-48/+78
5035). Using the RemoteAdmin API to close then recreate a region would fail if the estate name had not changed. If the estate name /was/ changed then the existing estate would be renamed rather than a new one being created. The problem really arose from a lack of distinction in the data storage layer between creating new estates and loading existing ones.
2011-08-15Remove un-needed ATTACH command in migration script.BlueWall1-3/+1
This was causing issues when using specified paths to database files by using a hard-coded name.
2011-07-16refactor: Pull up Assembly of the SQLite classes as a protected property, so ↵Marck6-11/+32
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-05-27fix bug where generic sqlite table delete wasn't working.Justin Clark-Casey (justincc)1-1/+1
this would have caused dupe links bugs when using the sqlite adaptor
2011-05-22More on HG Friends. Added Delete(string, string) across the board. Added ↵Diva Canto1-0/+5
security to friendship identifiers so that they can safely be deleted across worlds. Had to change Get(string) to use LIKE because the secret in the identifier is not always known -- affects only HG visitors. BOTTOM LINE SO FAR: HG friendships established and deleted safely across grids, local rights working but not (yet?) being transmitted back.
2011-05-21Fixed permissions bug related to friends in PermissionsModule. Added ↵Diva Canto1-1/+6
FriendsData[] GetFriends(string principalID) to IFriendsData and FriendInfo[] GetFriends(string PrincipalID) to IFriendsService. Refactored some more in the FriendsModule. Made client get notification of local friends permissions upon HGLogin. HG Friends object permissions work.
2011-05-19Allow item links to be deleted even when other deletes and purges are disabled.Justin Clark-Casey (justincc)2-6/+32
If these links are not deleted, then they will build up in the player's inventory until they can no longer log in. Accidental deletion of links due to bugs or other causes is potentially inconvenient but on a par with items being accidentally moved. When a link is deleted, the target of the link is never touched. This is a general solution that accounts for the use of links anywhere in the user's inventory.
2011-05-18Accidentally committed too earlyJustin Clark-Casey (justincc)2-32/+6
Revert "Allow item links to be deleted even when other deletes and purges are disabled." This reverts commit 491279f99afc65860d44765ee7829c7dd5e4e38e.
2011-05-17Allow item links to be deleted even when other deletes and purges are disabled.Justin Clark-Casey (justincc)2-6/+32
If these links are not deleted, then they will build up in the player's inventory until they can no longer log in. Accidental deletion of links due to bugs or other causes is potentially inconvenient but on a par with items being accidentally moved. When a link is deleted, the target of the link is never touched. This is a general solution that accounts for the use of links anywhere in the user's inventory.
2011-05-06minor: remove mono compiler warningsJustin Clark-Casey (justincc)2-4/+2
2011-04-05Make the "All Estates" option work from the client (this makes chosen ↵Justin Clark-Casey (justincc)1-0/+22
changes to all the estates that the user owns). This applies to adding/removing estate users, groups, managers and bans. This is the application of the AllEstates_0.5.patch from http://opensimulator.org/mantis/view.php?id=5420 Thanks very much, Snoopy!
2011-03-21On initial region registration, if the user chooses the option to make the ↵Justin Clark-Casey (justincc)1-0/+32
region part of an existing estate, then list the existing region names.
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-25Add the ability for gods to impersonate users. For this, bit 6 needs to beMelanie1-0/+5
set in the target's UserFlags and the impersonator must have UserLevel 200 or above. The user can then log in using the target's name and their own password.
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 Canto2-4/+4
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* One more item for CSharpSqliteTeravus Ovares (Dan Olivares)1-3/+10
* Hopefully this will enable mac people to use SQLite again * Someone cooler then me will need to figure out how to define CSharpSqlite with Mono so the conditional will pick up. * There's also an error that occurs when you first load OpenSimulator under CSharpSQLite that goes away after. * The databases are not byte for byte compatible. Mono.Data.Sqlite is able to read CSharpSqlite made databases but not the reverse way.
2010-09-23* Add CSharpSqlite to prebuildTeravus Ovares (Dan Olivares)12-12/+62
* 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 Hurliman2-0/+18
* 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 Ames2-33/+30
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-09-05Remove "Dwell" support from core and replace it with calls to methodsMelanie Thielker1-3/+0
on IDwellModule
2010-09-01Fix sqlite migration problems by moving migrations in 019_RegionStore.sql ↵Justin Clark-Casey (justincc)3-14/+14
and 020 into RegionStore.migrations This shows that panda is still not running the sqlite database tests since this change fixes the test failure in that area when "nant test" is executed locally
2010-08-30Fix a casting operation to use ToString()Melanie1-1/+1
2010-08-30Implements parcel media setting persistence and packet / CAPS handlingJonathan Freedman2-0/+16
properly for the new media settings. Signed-off-by: Melanie <melanie@t-data.com>
2010-08-30local commit with parcel media bitsJonathan Freedman2-0/+16
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-15Fix SQLite database plugin for UserAccountData queries with a single word.Marck1-1/+1
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-26add missing regionstore migration file for new fields. D'oh!Justin Clark-Casey (justincc)1-0/+6
this should enable persistence now