aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MSSQL (follow)
Commit message (Collapse)AuthorAgeFilesLines
* Updates to MSSQL to most recent compatibility, also included Windlight ↵Chris Hart2011-06-0110-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.
* Fix dumb sql mistake in MSSQLGenericTableHandler.Delete()Justin Clark-Casey (justincc)2011-05-311-1/+1
|
* More on HG Friends. Added Delete(string, string) across the board. Added ↵Diva Canto2011-05-221-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.
* Fixed permissions bug related to friends in PermissionsModule. Added ↵Diva Canto2011-05-211-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.
* Allow item links to be deleted even when other deletes and purges are disabled.Justin Clark-Casey (justincc)2011-05-192-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.
* Accidentally committed too earlyJustin Clark-Casey (justincc)2011-05-182-33/+12
| | | | | | Revert "Allow item links to be deleted even when other deletes and purges are disabled." This reverts commit 491279f99afc65860d44765ee7829c7dd5e4e38e.
* Allow item links to be deleted even when other deletes and purges are disabled.Justin Clark-Casey (justincc)2011-05-172-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.
* Mantis #5470 -- add forgotten MSSQL's GridUserStore. Thank you MrMonkEDiva Canto2011-05-071-0/+19
|
* Thank you MrMonkE for a patch that seems to bring the MSSQL data layer up to ↵Diva Canto2011-04-2811-32/+199
| | | | speed with 0.7.x.
* Make the "All Estates" option work from the client (this makes chosen ↵Justin Clark-Casey (justincc)2011-04-051-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!
* remove some mono compiler warningsJustin Clark-Casey (justincc)2011-03-316-10/+8
|
* On initial region registration, if the user chooses the option to make the ↵Justin Clark-Casey (justincc)2011-03-211-0/+17
| | | | region part of an existing estate, then list the existing region names.
* Add lsClearWindlightScene() to the lightshare module to remove WL settingsMelanie2010-11-031-0/+3
| | | | from a region and allow normal day cycles to be reestablished
* Changed SceneObjectGroup to store parts with the fast and thread-safe ↵John Hurliman2010-09-161-2/+2
| | | | MapAndArray collection
* MergedJohn Hurliman2010-09-121-3/+3
|\
| * Formatting cleanup.Jeff Ames2010-09-121-3/+3
| |
* | * Added ISimulationDataService and IEstateDataServiceJohn Hurliman2010-09-122-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
* Fixed the naming mess around data connectors for simulation dataJohn Hurliman2010-09-111-1/+1
|
* Remove "Dwell" support from core and replace it with calls to methodsMelanie Thielker2010-09-051-4/+2
| | | | on IDwellModule
* Remove parts locking from data classes since these are using a copy of the ↵Justin Clark-Casey (justincc)2010-08-261-49/+45
| | | | scene object
* Improve consistency of locking for SOG.m_parts in order to avoid race ↵Justin Clark-Casey (justincc)2010-08-261-46/+48
| | | | conditions in linking and unlinking
* refactor: Use SOP.Flags rather than SOP.ObjectFlagsJustin Clark-Casey (justincc)2010-08-131-2/+2
|
* Thank you, Marck00, for a patch that implemented region distance sortingMelanie Thielker2010-08-081-2/+5
| | | | for fallback regions. Applied with changes.
* Merge branch 'moap'Justin Clark-Casey (justincc)2010-08-062-8/+23
|\
| * fix mysql/mssql prim serialization problemJustin Clark-Casey (justincc)2010-08-041-6/+2
| |
| * Implement MediaUrl persistence for MySQL and MsSQLJustin Clark-Casey (justincc)2010-08-031-4/+10
| | | | | | | | Not sure how I forgot this. This may resolve problems with media textures not persisting over restart for these databases.
| * get rid of PrimitiveBaseShape.MediaRaw staging postJustin Clark-Casey (justincc)2010-08-031-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
| * add mssql support for media on a primJustin Clark-Casey (justincc)2010-07-262-4/+15
| | | | | | | | compiles but not tested. please test and correct if necessary!
* | White space from previous commit.Diva Canto2010-07-311-27/+27
| |
* | Implemented console command "show hyperlinks".Marck2010-07-311-28/+27
|/
* Removed (unused?) empty SQL files from MSSQL resource dirAlexRa2010-05-239-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.
* MSSQL Migration: CreatorID in InventoryItems changed to VARCHAR(36)AlexRa2010-05-231-0/+70
| | | | Again, the same thing about potentially having non-GUID CreatorID.
* Further corrections to MS SQL stores (now passes all tests)AlexRa2010-05-232-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.
* MSSQL: added asset_flags, CreatorID to migrationsAlexRa2010-05-231-0/+6
|
* MSSQLAssetData updated to support [CreatorID], [asset_flags]AlexRa2010-05-231-5/+11
|
* MSSQLAssetData: fixed some weirdnessAlexRa2010-05-231-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.
* All data tests made DBMS-independentAlexRa2010-05-231-1/+1
|
* Merge commit 'alex/mssql-estate-bugfix'Melanie2010-05-181-49/+41
|\ | | | | | | | | | | | | This fixes some type conversion bugs and also makes the estate lists work properly for MSSQL. Strawberry, please check this. Signed-off-by: Melanie <melanie@t-data.com>
| * Massive bugfix in MSSQLEstateData (now works!)AlexRa2010-05-181-49/+41
| |
* | MS SQL migrations converted to the new formatAlexRa2010-05-1677-2008/+2273
| |
* | Converted MySQL migration history to the new formatAlexRa2010-05-161-6/+0
|/ | | | | Replaced all NNN_StoreName.sql migration resources with a more readable, single-file-per-store
* Implement the "delete" path for assets. Adds a new option to allow remote ↵Melanie2010-05-091-0/+4
| | | | asset deletion in robust handler.
* GridUserService in place. Replaces the contrived concept of storing user's ↵Diva Canto2010-05-072-75/+5
| | | | | | home and position info in the presence service. WARNING: I violated a taboo by deleting 2 migration files and simplifying the original table creation for Presence. This should not cause any problems to anyone, though. Things will work with the new simplified table, as well as with the previous contrived one. If there are any problems, solving them is as easy as dropping the presence table and deleting its row in the migrations table. The presence info only exists during a user's session anyway. BTW, the Meshing files want to be committed too -- EOFs.
* Committing the LightShare code, which was developed by TomMeta of Meta7.Melanie2010-03-311-2/+11
| | | | | This allows scripts to set WindLight parameters for clients connecting to a region. Currently, this is only supported by the Meta7 viewer.
* First stage of the new interactive region creation. This will allow creationMelanie2010-03-231-0/+25
| | | | | | | of a region and joining it to an existing estate or creating a new estate, as well as creating an estate owner if in standalone, and assigning estate owners. In Grid mode, existing users must be used. MySQL ONLY!!!! so far, as I can't develop or test for either SQLite or MSSQL.
* Remove the reading of estate_settings.xml and the associated processing ofMelanie2010-03-221-21/+2
| | | | | defaults. Adding code to facilitate estate creation / managemment as part of first time start up
* Formatting cleanup. Add copyright notices.Jeff Ames2010-03-105-9/+9
|
* MSSQL tweaks for latest ROBUST - friends handling fixed, GridUserData ↵unknown2010-03-097-3/+101
| | | | | | placeholder added. Signed-off-by: Melanie <melanie@t-data.com>
* Remove some obsolete files from MSSQL. Fix a missing constructor arg thatMelanie2010-02-243-1821/+2
| | | | was introdiced by the latest jhurlipatch
* MSSQL Additions for Presence Refactor branch. Most functionality tested and ↵StrawberryFride2010-02-2425-842/+3262
| | | | | | works, some outstanding issues around login location and border crossings on y axis. Signed-off-by: Melanie <melanie@t-data.com>