aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data (follow)
Commit message (Collapse)AuthorAgeFilesLines
* Change Assembly verson of OpenSim.Data.PGSQL.dll to 0.8.0.* to match all ↵Justin Clark-Casey (justincc)2014-05-271-1/+1
| | | | other assembly versions
* minor: eliminate now unnecessary string.Format in postgresql RetrieveGroups ↵Justin Clark-Casey (justincc)2014-05-151-1/+1
| | | | method
* Escape find string in PgSQL core groups pluginJustin Clark-Casey (justincc)2014-05-152-3/+25
|
* Escape find string in MySQL core groups pluginJustin Clark-Casey (justincc)2014-05-151-1/+1
|
* When sending JSON-RPC calls (for UserProfile), use WebUtil instead of ↵Oren Hurvitz2014-04-242-11/+0
| | | | constructing the HTTP requests manually. This allows the calls to be logged when using "debug http all 6".
* Eliminated many warningsOren Hurvitz2014-04-237-9/+8
|
* Changed table 'im_offline' to use UTF8 characters. This fixes a problem with ↵Oren Hurvitz2014-04-231-1/+9
| | | | | | | | | | | | | | | | Offline IM V2 (only relevant to MySQL). This fixes http://opensimulator.org/mantis/view.php?id=7123 Users that use MySQL should change their MySQL configuration to support UTF8. In the config file /etc/my.cnf (Linux) or my.ini (Windows), add these settings: [mysqld] character-set-server=utf8 [client] default-character-set=utf8 And then restart MySQL (on Linux: "sudo service mysqld restart").
* Changed the maximum asset name and description lengths to constants. Also, ↵Oren Hurvitz2014-04-225-20/+20
| | | | pre-truncate the description of dynamic textures.
* Better logging in PresenceService, to help diagnose presence problems.Oren Hurvitz2014-04-212-4/+20
|
* Fix the presence info caching used in llRequestAgentData(), which was ↵Justin Clark-Casey (justincc)2014-04-111-1/+1
| | | | | | | | completely inoperative. This means the presence info may be out of date by up to 20 seconds, but this avoids scripts potentially triggering constants requests to user accout and presence info services. Relates to http://opensimulator.org/mantis/view.php?id=7088 though I fixed in a different way. Adds regression test for this case.
* Fixed AssetsExist in SQLiteOren Hurvitz2014-04-021-2/+2
|
* Made the SQLite unit tests work on Windows (sqlite3.dll wasn't being loaded)Oren Hurvitz2014-04-021-0/+3
|
* Added assets service method AssetsExist(), which returns whether the given ↵Oren Hurvitz2014-04-0210-83/+166
| | | | | | list of assets exist. This method is used to optimize sending assets with embedded assets: e.g., when a Hypergrid visitor takes an item into the inventory.
* Fix MSSQLInventoryHandler.IncreementFolderVersion where sql accidentally ↵Justin Clark-Casey (justincc)2014-03-261-1/+1
| | | | | | used a MySQL style ?folderID insted of @folderID Thanks to LuciusSirnah in http://opensimulator.org/mantis/view.php?id=7075 for this fix
* minor: remove compiler warning from NullEstateDataJustin Clark-Casey (justincc)2014-03-261-1/+1
|
* Add MSSQL EstateStore.migrations VERSION 10 transaction to add ↵Justin Clark-Casey (justincc)2014-03-261-0/+8
| | | | | | AllowLandMark, AllowParcelChanges and AllowSetHome columns to estate_settings table. Taken from http://opensimulator.org/mantis/view.php?id=7074 by LuciusSirnah. Thanks!
* Fix extra physics params MSSQL migration (version 39).Justin Clark-Casey (justincc)2014-03-261-5/+5
| | | | | | This was failing because it used MySQL syntax This is taken from Lucius Sirnah's entry in http://opensimulator.org/mantis/view.php?id=6593 But with the column existence checking removed, as this should not be necessary in a migration and is inconsistent with all other migrations, though I can see a case for doing it.
* Fixed updating usersettings in the databaseOren Hurvitz2014-03-241-2/+2
| | | | Resolves http://opensimulator.org/mantis/view.php?id=6938
* Don't show hidden groups in search resultsOren Hurvitz2014-03-241-3/+3
| | | | Resolves http://opensimulator.org/mantis/view.php?id=6937
* Fix a bug in previous commit 01520bb where I accidentally saved ↵Justin Clark-Casey (justincc)2014-03-181-1/+1
| | | | OtherCleanTime instead of Dwell
* Save and load dwell parcel stat in MySQL DB adaptor. Field in table already ↵Justin Clark-Casey (justincc)2014-03-181-3/+4
| | | | | | exists! The SQLite database adaptor was loading and saving dwell whilst MySQL was not, even though the field already exists in the db table.
* Add regression test for sending group notices via xmlrpc groups connector.Justin Clark-Casey (justincc)2014-03-072-25/+68
|
* Repair database routines so they properly return null when asked forRobert Adams2014-01-285-4/+21
| | | | the heighmap of a region that does not exist.
* Merge branch 'master' into varregionRobert Adams2014-01-192-2/+13
|\
| * Merge branch 'justincc-master'Justin Clark-Casey (justincc)2014-01-162-2/+13
| |\
| | * In the offline message table, store the sender.Oren Hurvitz2014-01-162-2/+13
| | | | | | | | | | | | This data is useful for preventing abuse (e.g., someone who sends too many messages), or for deleting message if their sender has been deleted.
* | | Merge branch 'master' into varregionRobert Adams2013-12-177-42/+163
|\ \ \ | |/ / | | | | | | | | | | | | | | | | | | Add new region crossing code to varregion Conflicts: OpenSim/Region/CoreModules/Framework/EntityTransfer/EntityTransferModule.cs OpenSim/Region/Framework/Scenes/ScenePresence.cs
| * | Fix issue with editing notes for other avatarsBlueWall2013-12-161-0/+4
| | |
| * | Populate user preferences with UserAccount email if it is present, else ↵BlueWall2013-12-162-7/+12
| |/ | | | | | | return an error indicating no email is on record for the user.
| * Add support for user preferences (im via email)BlueWall2013-12-067-36/+148
| |
* | varregion: rename 'LegacyRegionLocX' back to 'RegionLocX' and same for Y and Z.Robert Adams2013-12-141-4/+4
| | | | | | | | | | | | Rename 'RegionWorldLocX' to 'WorldLocX' and same for Y and Z. This keeps the downward compatibility and follows the scheme of 'region' and 'world' location naming that is happening in the Util module.
* | Merge branch 'master' into varregionRobert Adams2013-12-054-7/+1
|\ \ | |/
| * Adding profile partners fix to SQLite and PgSQL driversBlueWall2013-12-052-4/+0
| |
| * Stop writing partner id to record when updating profile data. This should be ↵BlueWall2013-12-051-2/+0
| | | | | | | | changed only by admin in backend.
| * Reversing back to the row["ColumnName"] case field name. ↵Fernando Oliveira2013-12-061-1/+1
| | | | | | | | http://opensimulator.org/mantis/view.php?id=6868
* | Merge branch 'master' into varregionRobert Adams2013-12-011-2/+2
|\ \ | |/
| * Corrected case to get columns from Regions table from PostgreSQL ↵Fernando Oliveira2013-11-251-2/+2
| | | | | | | | | | | | http://opensimulator.org/mantis/view.php?id=6865 Signed-off-by: Michael Cerquoni <nebadon2025@gmail.com>
* | Merge branch 'master' into varregionRobert Adams2013-11-241-4/+5
|\ \ | |/
| * Fixed the update StoreRegionWindlightSettings() wasn't updating ↵Fernando Oliveira2013-11-221-4/+5
| | | | | | | | | | | | | | regionwindlight table, raising PrimaryKey violation; Signed-off-by: Fernando Oliveira <fernando@oliveira.eti.br> Signed-off-by: Michael Cerquoni <nebadon2025@gmail.com>
* | varregion: elimination of Constants.RegionSize from all over OpenSimulator.Robert Adams2013-11-081-2/+2
| | | | | | | | | | | | | | Routines in Util to compute region world coordinates from region coordinates as well as the conversion to and from region handles. These routines have replaced a lot of math scattered throughout the simulator. Should be no functional changes.
* | varregion: remove unused terrain serialization code in SQLite and PGSQL modulesRobert Adams2013-11-042-40/+0
| |
* | varregion: push TerrainData implementation up and down the database storage ↵Robert Adams2013-11-015-95/+97
| | | | | | | | | | | | | | stack. Implement both LoadTerrain and StoreTerrain for all DBs. Move all database blob serialization/deserialization into TerrainData.
* | Merge branch 'master' into varregionRobert Adams2013-10-283-1/+59
|\ \ | |/
| * Corrected estateID to EstateID on getEstates function at PGSQLEstateData.csFernando Oliveira2013-10-161-1/+1
| |
| * * One More thing, add an appdomain data element to ensure that we don't ↵Fernando Oliveira2013-10-162-4/+15
| | | | | | | | duplicate the assembly resolving.
| * * Fixes mantis mantis 0006803 [PGSQL] - Simulator crashes - ↵Fernando Oliveira2013-10-162-0/+47
| | | | | | | | Mono.Security.dll missing. The root of the issue is that the Postgres driver relies on Mono.Security.dll from the mono project. Unfortunately, when using Mono, including the dll in the distribution causes conflicts. This solution puts Mono.Security.dll in bin/lib/NET/ and, if windows .NET is the runtime, informs the assembly loader to load bin/lib/NET/Mono.Security.dll when .NET is scanning for the Mono.Security namespace. On Mono, the included Mono.Security assembly is ignored.
* | varregion: update PGSQL driver for storing variable terrain size blobs.Robert Adams2013-10-161-15/+30
| |
* | Merge branch 'master' into varregionRobert Adams2013-10-1640-0/+11923
|\ \ | |/
| * * Fixes mantis #6802 Simulator crashes whist loading (lighshare enabled)fernando2013-10-154-9/+40
| | | | | | | | * Please test
| * Fernando Oliveira's Postgress SQL Server Data Connector as a single commit.Fernando Oliveira2013-10-1240-0/+11892
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | * Added PostGreSQL support * Added MySQL/MySQLXGroupData.cs * PostgreSQL data access implementation * PostgreSQL dll binarie and RegionStore.migrations * Migrations Scripts from MSSQL to POSTGRES * Postgres SQL Type fixes * Postgres SQL Connection string * Data type issues * more fixes * tests and +tests * UUID x string - FIGHT! * Fixed PG types to internal csharp types * More data type fix (PostgreSQL fields are case sensitive) :( * more field case sensitive fixes * changed the migration files to be case sensitive for fields. * fixed fields case * finished converting, now search for hidden bugs. * some more fixes * bool type fixed * more case fixes; * creatorID case fixed * case fields fixed * fixed default now() for TMStamp fields with don't allow nulls. * fix case sensitve for Region name and Estate name * fixed case for names for search * fix class name Error * Bug fixed on select and migrations * Un-Reverting my change due to Postgres issue with the ILIKE function * Fixed some issued for Diva Distro * Fixes for integration with Diva Distro * Added System.Core to prebuild.xml for PG project * Configured to make DIff for Push to OpenSim Project * Diffs only to PostgreSQL mods.