aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MSSQL (unfollow)
Commit message (Collapse)AuthorFilesLines
2012-05-23Environment Module - allows Environment settings for Viewer3 warning: ↵PixelTomsen2-0/+80
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-03-31Add MSSQL login processing fix for servers run on different locales.Justin Clark-Casey (justincc)1-0/+5
This may no longer be an issue with better locale enforcement in OpenSimulator but it doesn't hurt to have this patch. http://opensimulator.org/mantis/view.php?id=4680 Thanks to controlbreak for this
2012-03-06Updates to MSSQL store for 0.7.3 to include:Chris Hart4-7/+169
* Telehub support * Bugfix to Friends lookups * Updates to Creator fields to store up to 255 characters for HG item creator storage
2012-02-29Use correct casing of RegionSettings.Sandbox in the various database modules.Justin Clark-Casey (justincc)1-2/+2
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-14Fix: MSSQLDB Grid - unable to register region ↵PixelTomsen1-1/+8
http://opensimulator.org/mantis/view.php?id=5886
2012-02-14Revert "Add GridStore migration for MSSQL."Justin Clark-Casey (justincc)1-8/+0
This reverts commit 0b17a66e683f7ffca3877c1601c4179684b62144.
2012-02-14Add GridStore migration for MSSQL.Justin Clark-Casey (justincc)1-0/+8
This is done blind since I don't use MSSQL. If this doesn't work, then one will have to wait for it to be updated for the 0.7.3 opensim release.
2012-02-03Fix: Covenant changed time not set ↵PixelTomsen2-4/+13
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-09-20Remove vestigal OpenSim.Data mono addins extension points that don't look ↵Justin Clark-Casey (justincc)1-23/+0
like they've been active for at least 2 and a half years
2011-09-16MSSQL Bug fix in user account retrieval, plus migrations for FriendsStore ↵Chris Hart3-7/+71
and InventoryStore
2011-09-16Reattaching a region was failing if the estate name had not changed (issue ↵Kevin Houlihan1-48/+69
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-09-01Remove code which was automatically deleting non-root prims from scene ↵Justin Clark-Casey (justincc)1-15/+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
2011-08-18minor: remove some mono compiler warningsJustin Clark-Casey (justincc)2-2/+2
2011-06-01Updates to MSSQL to most recent compatibility, also included Windlight ↵Chris Hart10-48/+828
support. Needs plenty of testing but clean install and migration from 0.6.9 have been tested and work, a few indexes still need to be added for performance.
2011-05-31Fix dumb sql mistake in MSSQLGenericTableHandler.Delete()Justin Clark-Casey (justincc)1-1/+1
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-0/+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-12/+33
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-33/+12
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-12/+33
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-07Mantis #5470 -- add forgotten MSSQL's GridUserStore. Thank you MrMonkEDiva Canto1-0/+19
2011-04-28Thank you MrMonkE for a patch that seems to bring the MSSQL data layer up to ↵Diva Canto11-32/+199
speed with 0.7.x.
2011-04-05Make the "All Estates" option work from the client (this makes chosen ↵Justin Clark-Casey (justincc)1-0/+5
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-31remove some mono compiler warningsJustin Clark-Casey (justincc)6-10/+8
2011-03-21On initial region registration, if the user chooses the option to make the ↵Justin Clark-Casey (justincc)1-0/+17
region part of an existing estate, then list the existing region names.
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-16Changed SceneObjectGroup to store parts with the fast and thread-safe ↵John Hurliman1-2/+2
MapAndArray collection
2010-09-12* Added ISimulationDataService and IEstateDataServiceJohn Hurliman2-0/+19
* 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-3/+3
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-4/+2
on IDwellModule
2010-08-26Remove parts locking from data classes since these are using a copy of the ↵Justin Clark-Casey (justincc)1-49/+45
scene object
2010-08-26Improve consistency of locking for SOG.m_parts in order to avoid race ↵Justin Clark-Casey (justincc)1-46/+48
conditions in linking and unlinking
2010-08-13refactor: Use SOP.Flags rather than SOP.ObjectFlagsJustin Clark-Casey (justincc)1-2/+2
2010-08-08Thank you, Marck00, for a patch that implemented region distance sortingMelanie Thielker1-2/+5
for fallback regions. Applied with changes.
2010-08-04fix mysql/mssql prim serialization problemJustin Clark-Casey (justincc)1-6/+2
2010-08-03Implement MediaUrl persistence for MySQL and MsSQLJustin Clark-Casey (justincc)1-4/+10
Not sure how I forgot this. This may resolve problems with media textures not persisting over restart for these databases.
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-31White space from previous commit.Diva Canto1-27/+27
2010-07-31Implemented console command "show hyperlinks".Marck1-28/+27
2010-07-26add mssql support for media on a primJustin Clark-Casey (justincc)2-4/+15
compiles but not tested. please test and correct if necessary!
2010-07-26add mssql support for media on a primJustin Clark-Casey (justincc)2-4/+15
compiles but not tested. please test and correct if necessary!
2010-05-23Removed (unused?) empty SQL files from MSSQL resource dirAlexRa9-0/+0
There was a whole bunch of these SQL files, all empty and apparently unused. Removing them is just a clean-up, if anybody has a reason for these files to be there, feel free to revert.
2010-05-23MSSQL Migration: CreatorID in InventoryItems changed to VARCHAR(36)AlexRa1-0/+70
Again, the same thing about potentially having non-GUID CreatorID.
2010-05-23Further corrections to MS SQL stores (now passes all tests)AlexRa2-89/+49
Besides, AssetData is slightly optimized to StoreAsset in one request ("IF EXISTS() UPDATE ... ELSE INSERT ...") The main change in the MS SQL Inventory implem. is that it now return empty list (or whatever) when called with UUID.Zero, which is consistent with how the code for other DBs work. I did no changes at all in XInventory, as there is no test set for them.
2010-05-23MSSQL: added asset_flags, CreatorID to migrationsAlexRa1-0/+6
2010-05-23MSSQLAssetData updated to support [CreatorID], [asset_flags]AlexRa1-5/+11
2010-05-23MSSQLAssetData: fixed some weirdnessAlexRa1-7/+12
Fixed unfinished SQL in FetchAssetMetadataSet, fixed SQL in UpdateAsset (must not modify ID). NOT tested! But apparently shouldn't work worse than the previous version, esp. the FetchMetadata thing.
2010-05-23All data tests made DBMS-independentAlexRa1-1/+1