aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL/MySQLRegionData.cs (unfollow)
Commit message (Collapse)AuthorFilesLines
2019-11-14work on previus 2 patchsUbitUmarov1-23/+1
2019-11-14Attempt to fix the issue where, when logging into the grid, the user ↵Terry1-1/+24
supplies a region name, but instead of going to the specific region, they are sent to a region "Like" the one specified. Signed-off-by: Terry <terry@digiworldz.com> Signed-off-by: UbitUmarov <ajlduarte@sapo.pt>
2019-05-19Dump OpenSim 0.9.0.1 into it's own branch.onefang1-1/+77
2017-05-06 MySQLConnector is not a MS productUbitUmarov1-0/+3
2017-01-05Massive tab and trailing space cleanupMelanie Thielker1-1/+1
2016-12-01 fix a typo in dbs region rangeUbitUmarov1-1/+1
2016-11-03Initial update to OpenSim 0.8.2.1 source code.David Walter Seikel1-0/+5
2015-08-23 fix db region find by range for varregions ( ignoring others than Mysql)UbitUmarov1-0/+33
2015-08-23 fix db region search by a position, for varregions ( ignoring other thatUbitUmarov1-0/+40
mysql for now )
2013-09-02Allow one to specify a DefaultHGRegion flag in [GridService] in order to ↵Justin Clark-Casey (justincc)1-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.
2012-11-15Revert "Merge master into teravuswork", it should have been avination, not ↵teravus1-2/+2
master. This reverts commit dfac269032300872c4d0dc507f4f9062d102b0f4, reversing changes made to 619c39e5144f15aca129d6d999bcc5c34133ee64.
2012-10-09Move OpenSim.Data.RegionFlags -> OpenSim.Framework.RegionFlags to make it ↵Justin Clark-Casey (justincc)1-2/+2
easier for other code to use (e.g. LSL_Api) without having to reference OpenSim.Data just for this.
2012-04-30Consistently use using() to make sure we dispose of used MySqlCommands where ↵Justin Clark-Casey (justincc)1-6/+7
this is not already being done.
2012-04-24Fixed problem with MySQL: it was possible for one thread to use an ↵Oren Hurvitz1-11/+18
incomplete list of column names if another thread was creating the list at the same time. Now this is thread-safe.
2012-04-24When reading a region, use null objects to represent NULL fields.Oren Hurvitz1-1/+5
Previously NULL fields were converted to an empty string due to the use of ToString(). But if the field was an Int (e.g., "locZ"), then the subsequent attempt to convert an empty string to an int caused an exception. Now the field is null so we don't try to convert it, so there's no exception.
2011-03-08Pull up Assembly of the MySQL classes as a protected property, so that it ↵Diva Canto1-1/+8
can be overwritten in subclasses. That way extensions can decide in which assembly migration resources should be looked up. This is just a refactor -- no functional changes whatsoever.
2010-12-05Fixed some inconsistency with trailing /. Made debug messages consistent. ↵Diva Canto1-2/+2
Changed the stored region names of HG regions. Increased the size of regionName in DB.
2010-10-18Alphabetize results on region search by prefix matchingMelanie1-0/+2
2010-08-10Enforce DB limits on region name to 32 chars, or else (not good). Removed a ↵Diva Canto1-0/+3
piece of code from Hyperlinker that didn't work anyway. Shortened the hyperlink region name.
2010-08-08Thank you, Marck00, for a patch that implemented region distance sortingMelanie Thielker1-2/+4
for fallback regions. Applied with changes.
2010-08-08Thank you, Marck00, for a patch that implemented region distance sortingMelanie Thielker1-2/+4
for fallback regions. Applied with changes.
2010-07-31White space from previous commit.Diva Canto1-25/+25
2010-07-31Implemented console command "show hyperlinks".Marck1-23/+26
2010-05-19All (?) MySQL stores fixed to use DBGuid.FromDB()AlexRa1-6/+4
This was needed if we want to update to the latest MySQL connector dll. It automatically converts CHAR(36) to Guids, so getting them as strings no longer works. By using DBGuid.FromDB(), we unlink from any particular storage format of GUIDs, could even make them BINARY(16) if we like. Actually not all MySql units are touched, but the remaining ones don't seem to be affected (they don't read GUIDs from DB)
2010-02-05Updated MySQL connection management to use the MySQL connection pooling. ↵Master ScienceSim1-124/+133
This should accommodate various timeout problems that exist with the current connection pool code in a more general and standard way.
2010-01-09Preliminary work on the new default region setting mechanismMelanie1-0/+26
2009-11-02Reverting the memory leak patch for MySQL. Problems have been reported with ↵John Hurliman1-114/+114
the grid server after running for several hours
2009-10-12Stop null values from being returned on database queriesMelanie1-1/+4
2009-10-06Remove the using() constructs from the new style database modules; they causedMelanie1-1/+1
the underlying connection of a reader or command to be closed before the reader or command itself. Added the proper logic to Close and dispose items in CloseDBConnection. Readers and Connections need Close(), Commands need Dispose(), in the order Reader, Command, Connection. Also reinstated 80-column-friendly formatting
2009-10-05Added CloseDBConnection() to replace the old CloseReaderCommand(). This will ↵John Hurliman1-0/+2
close the MySQLConnection attached to a MySQLCommand. I'm not sure if this accounts for every time a database connection needs to be closed, but it matches up 1:1 with the places where the database connection was previously being closed
2009-10-04* MySQL data tests now pass by fixing a bad fix for a bad cast on the asset ↵John Hurliman1-121/+119
Local member in MySQLAssetData * First pass at applying the using(){} pattern to IDisposable objects. Always use the using pattern on IDisposable objects whenever possible, do not manually call .Close() or .Dispose() unless there is no other way to write the code. This pass mostly covers OpenSim.Data.MySQL, and should have no functional change (tests still pass)
2009-09-27Make the RegionData plugin store the RegionNameMelanie1-2/+3
2009-09-27Prevent manually setting Data["locX"] and Data["locY"], since that wouldMelanie1-0/+4
overwrite the posX and posY members of the structure
2009-09-27Add the Migration for the regions tableMelanie1-8/+14
2009-09-25minor: remove some mono compiler warningsJustin Clark-Casey (justincc)1-1/+1
2009-09-24All tests pass for MySQL/MySQLRegionData.Diva Canto1-12/+3
Added OpenSim.GridServer.ini.example that I have been using for testing the ROBUST grid service with the GridClient.
2009-09-16Adding the MySQL RegionData service.Melanie1-1471/+144
2009-09-02Thank you, dslake, for a set of patches to improve OpenSim startupMelanie1-9/+40
and idle performance.
2009-08-16Adding in Reflection-based testing, to ensure that all properties are covered.Kunnis1-7/+10
2009-08-07* Remove hard coded 256 limitations from various places. There's no more ↵Teravus Ovares (Dan Olivares)1-6/+6
256m limitation within the OpenSimulator framework, however, the LLClient ClientView does not support regions larger then 256 meters so, if you try and make your region larger by setting Constants.RegionSize = 512; in OpenSim.Framework.Constants.cs, the terrain will not display on clients using the LLUDP protocol
2009-07-25* Updates libOMV to version 0.7.0Teravus Ovares1-2/+2
* Uses mantis #3811 as a base (thanks jhuliman) with changes. * E-mail regarding interface changes sent to the opensim-dev list * Archive: https://lists.berlios.de/pipermail/opensim-dev/2009-July/007219.html
2009-06-30From: Chris Yeoh <yeohc@au1.ibm.com>Sean Dague1-1/+1
Ooops, sorry there was a bug in the patch and causes an exception on some system (I think it only happens on windows since it didn't occur during my testin). I've attached a one liner which fixes the problem.
2009-06-29From: Chris Yeoh <yeohc@au1.ibm.com>Sean Dague1-13/+4
Attached is a patch that changes the oar file saving of creation date/time to an integer instead of a string. I did this after justincc emailed me saying there is a problem with internationalisation doing it the old way and I said I'd fix it. Its been tested with MySQL and I've made the changes for MSSQL but that hasn't been well tested.
2009-06-03From: Chris Yeoh <yeohc@au1.ibm.com>Dr Scofield1-2/+24
This patch adds oar file date and time (UTC) meta data to an oar file when it is created. It also adds a unique ID, though this id does not in anyway identify the machine that the oar file was created on. When an oar file with this meta data is loaded this extra information is saved with the region settings and available via LSL through: - osLoadedCreationDate() - osLoadedCreationTime() - osLoadedCreationID() If there is no meta data these fields will be blank. Subsequent oar file loads will erase the information for the previous oar file load. Persistence has only been implemented for MySQL, the other backends need updating. Overall this allows us to much more easily identify the specific version of software that clients are using. Its very straightforward to edit the oar file to change the ID string to be something more human friendly. Included in the patch is a new file OpenSim/Data/MySQL/Resources/030_RegionStore.sql required for the MySQL DB migration. btw I had a chat with justincc about this a few weeks ago since he wrote the oar file import/export and he sounded happy to accept something that included date/time information but didn't want anything that would silently leak private information like machine names.
2009-06-01Minor: Change OpenSim to OpenSimulator in older copyright headers and ↵Jeff Ames1-1/+1
LICENSE.txt.
2009-05-27From: Chris Yeoh <cyeoh@au1.ibm.com>Dr Scofield1-2/+12
The attached patch implements llPassTouches. It has been added to the export/import XML along with the flag for AllowedInventoryDrop. The MySQL backend has been updated as well, though I haven't done one of those before so could do with a check. I added the migration mysql file as well. The other data backends need updating as well.
2009-05-25Revert "From: Chris Yeoh <cyeoh@au1.ibm.com>"Dr Scofield1-12/+2
This reverts r9666. for some reason the mysql update does not work.
2009-05-25From: Chris Yeoh <cyeoh@au1.ibm.com>Dr Scofield1-2/+12
The attached patch implements llPassTouches. It has been added to the export/import XML along with the flag for AllowedInventoryDrop. The MySQL backend has been updated as well, though I haven't done one of those before so could do with a check. I added the migration mysql file as well. The other data backends need updating as well.
2009-05-07* Consistently used dashed uuid format for mysql region data, as is done for ↵Justin Clarke Casey1-29/+26
all other tables * This revision contains a mysql data migration. Please backup your mysql region database as a precaution before using this code. * I also advise that you do a runprebuild[.sh|.bat] and a clean build ("nant clean build" if you're using the command line). * This change is needed for future id schemes
2009-02-25* Refactored SOP.FolderID weirdness by removing calls to empty setter. YEs, ↵lbsa711-4/+0
I do realize the setter has to be there for legacy reasons, but since the calls will never acually DO anyhting, I'm removing them. * So, SOP.FolderID is actually a cruft field that should be removed.