aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MSSQL (follow)
Commit message (Collapse)AuthorAgeFilesLines
* Allow one to specify a DefaultHGRegion flag in [GridService] in order to ↵Justin Clark-Casey (justincc)2013-09-041-0/+5
| | | | | | | | | | allow different default regions for HG and direct grid logins. This requires a new GridService.GetDefaultHypergridRegions() so ROBUST services require updating but not simulators. This method still returns regions flagged with just DefaultRegion after any DefaultHGRegions, so if no DefaultHGRegions are specified then existing configured defaults will still work. Immediate use is for conference where we need to be able to specify different defaults However, this is also generally useful to send experienced HG users to one default location and local users whose specified region fails (e.g. no "home" or "last") to another.
* Fix SQL statementDiva Canto2013-07-021-1/+1
|
* Do the same for SQLite and MSSQLDiva Canto2013-07-021-1/+1
|
* This should have a strong effect on the Unknown User issue mantis #6625Diva Canto2013-07-021-1/+6
|
* 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.
* Change recent MSSQL migrations to drop COLUMN from ALTER TABLE which is ↵Justin Clark-Casey (justincc)2013-04-021-6/+6
| | | | | | either not syntactical or unnecessary. May fix http://opensimulator.org/mantis/view.php?id=6593
* Add more information to warnings logged when asset names and descriptions ↵Justin Clark-Casey (justincc)2013-02-271-2/+6
| | | | | | | have to be truncated for database storage On balance, I still think this is useful because asset names and descriptions can sometimes be helpful in determining what things are. Even though they are never subsequently (inventory names/descriptions are always used instead).
* Deleted all AssemblyFileVersion directivesDiva Canto2013-02-191-1/+1
|
* Added physics parameters support to MSSQL and SQLite (not tested)Oren Hurvitz2013-02-092-3/+30
|
* Merge branch 'dynamic-attributes2'Justin Clark-Casey (justincc)2013-02-052-5/+21
|\
| * 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-252-11/+3
| |
| * 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-252-6/+26
| | | | | | | | mssql is untested
* | Bump version and assembly version numbers from 0.7.5 to 0.7.6Justin Clark-Casey (justincc)2013-02-051-1/+1
|/ | | | | | | | This is mostly Bluewall's work but I am also bumping the general version number OpenSimulator 0.7.5 remains in the release candidate stage. I'm doing this because master is significantly adding things that will not be in 0.7.5 This update should not cause issues with existing external binary DLLs because our DLLs do not have strong names and so the exact version match requirement is not in force.
* Restrict IPresenceData.VerifyAgentBlueWall2012-12-091-5/+7
| | | | Restrict IPresenceData.VerifyAgent to only return bool result
* Add agent verification to PresenceBlueWall2012-12-081-0/+11
|
* refactor: move common inventory folder version update code to parent class ↵Justin Clark-Casey (justincc)2012-11-151-38/+9
| | | | in mysql, mssql and sqlite database plugins
* Improve inventory folder version updating for mssql database plugin.Justin Clark-Casey (justincc)2012-11-151-14/+102
| | | | | I am not in a position to test this so the updates have been done blind. If it needs any fixing will probably require patches.
* Updated all existing AssemblyVersions's to 0.7.5.*. Many DLLs still don't ↵Diva Canto2012-11-131-1/+1
| | | | have an AssemblyInfo file.
* Update parent inventory folder version numbers when folders are ↵Justin Clark-Casey (justincc)2012-11-091-42/+86
| | | | | | | | moved/created/deleted to match version numbers cached by viewers. This is done in the way that one would expect (e.g. moving a folder increments version number on both source and destination parent folders). This should hopefully improve viewer reuse of its cached inventory information. Currently MySQL only but will be implement for SQLite/MSSQL if there are no issues.
* Move OpenSim.Data.RegionFlags -> OpenSim.Framework.RegionFlags to make it ↵Justin Clark-Casey (justincc)2012-10-091-0/+1
| | | | easier for other code to use (e.g. LSL_Api) without having to reference OpenSim.Data just for this.
* 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-232-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>
* Add MSSQL login processing fix for servers run on different locales.Justin Clark-Casey (justincc)2012-03-311-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
* Updates to MSSQL store for 0.7.3 to include:Chris Hart2012-03-064-7/+169
| | | | | | * Telehub support * Bugfix to Friends lookups * Updates to Creator fields to store up to 255 characters for HG item creator storage
* Use correct casing of RegionSettings.Sandbox in the various database modules.Justin Clark-Casey (justincc)2012-02-291-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.
* Fix: MSSQLDB Grid - unable to register region ↵PixelTomsen2012-02-141-1/+8
| | | | http://opensimulator.org/mantis/view.php?id=5886
* Revert "Add GridStore migration for MSSQL."Justin Clark-Casey (justincc)2012-02-141-8/+0
| | | | This reverts commit 0b17a66e683f7ffca3877c1601c4179684b62144.
* Add GridStore migration for MSSQL.Justin Clark-Casey (justincc)2012-02-141-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.
* Fix: Covenant changed time not set ↵PixelTomsen2012-02-032-4/+13
| | | | | | 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-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)
* Remove vestigal OpenSim.Data mono addins extension points that don't look ↵Justin Clark-Casey (justincc)2011-09-201-23/+0
| | | | like they've been active for at least 2 and a half years
* MSSQL Bug fix in user account retrieval, plus migrations for FriendsStore ↵Chris Hart2011-09-163-7/+71
| | | | and InventoryStore
* Reattaching a region was failing if the estate name had not changed (issue ↵Kevin Houlihan2011-09-161-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.
* Remove code which was automatically deleting non-root prims from scene ↵Justin Clark-Casey (justincc)2011-09-011-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
* minor: remove some mono compiler warningsJustin Clark-Casey (justincc)2011-08-182-2/+2
|
* 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