aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL (follow)
Commit message (Collapse)AuthorAgeFilesLines
* Removed unused code that checked wait_timeout in MySQLEstateDataOren Hurvitz2015-08-111-34/+0
|
* Correcting errors in previous change: MySQL needs int unsigned, notMelanie Thielker2015-07-141-1/+1
| | | | unsigned int. PGSQL has no unsigned types, changing to bigint.
* Mantis #7629: Change LandFlags column to unsigned. Thanks, Jim!Melanie Thielker2015-07-141-0/+8
|
* Bringing FSAssets more inline with current OpenSim standards. * If no ↵AliciaRaven2015-07-122-25/+100
| | | | | | connection string found in assets config, fallback to using default database config * Create database storage interface to allow other db connectors to be written at some point * Add MySQL migrations file to create the initial db table * Added new config option named DaysBetweenAccessTimeUpdates to reduce db load by only updating access times when fetching assets if the last access time was over the threshold. This idea was taken from XAssets service. * Change log message headers to indicate FS assets is the source not just assets Signed-off-by: Melanie Thielker <melanie@t-data.com>
* Some cleanup, add prebuild project, correct pathMelanie Thielker2015-07-111-4/+0
|
* Rename for uniformity, add data moduleMelanie Thielker2015-07-111-0/+361
|
* Removing the Store methods in the DB layer of AgentPreferences, as they were ↵Diva Canto2015-06-141-5/+0
| | | | simply calling the base ones.
* Quell three new warnings I introduced with AgentPrefsData, return an empty ↵Cinder2015-06-141-2/+2
| | | | | | llsd map instead of an empty llsd block when no AgentPrefs service is available to try and appease Firestorm Signed-off-by: Diva Canto <diva@metaverseink.com>
* Refactor AgentPreferences so that database operations happen centrally. the ↵Cinder2015-06-131-15/+2
| | | | | | opensim way. Signed-off-by: Diva Canto <diva@metaverseink.com>
* Relicense AgentPreferences files to BSD and OpenSimulatorCinder2015-06-131-23/+24
| | | | Signed-off-by: Diva Canto <diva@metaverseink.com>
* Support for Linden AgentPreferences capability and friends ↵Cinder2015-06-132-0/+91
| | | | | | (UpdateAgentLanguage and UpdateAgentInformation) and Mantis #7157 Signed-off-by: Diva Canto <diva@metaverseink.com>
* Updated all occurrences of AssemblyVersion("0.8.1.*") to ↵Diva Canto2015-04-291-1/+1
| | | | AssemblyVersion("0.8.2.*")
* Change UserProfiles so that the parcel name is used for a ProfilePick and ↵AliciaRaven2015-04-121-2/+4
| | | | | | not the parcel owners name. This change also fixes a bug where if the avatar enters and does not move, creating or editing a ProfilePick would set the parcelId as an empty UUID. This is because ScenePresence.currentParcelUUID is not set until the avatar moves. Signed-off-by: Michael Cerquoni <nebadon2025@gmail.com>
* Alter the migrations so that it is a no-op as the columns are unused and the ↵BlueWall2015-03-042-4/+2
| | | | operation is very expensive
* Chase latest change to asset description length with an update to ↵Cinder2015-03-041-1/+9
| | | | | | XAssetStore db tables Signed-off-by: BlueWall <jamesh@bluewallgroup.com>
* Revert "Chase latest change to asset description length with an update to ↵BlueWall2015-03-041-9/+1
| | | | | | XAssetStore db tables" This reverts commit e520364f65e1915e13d28b829e9dd62f6904957d.
* Chase latest change to asset description length with an update to ↵Cinder2015-03-041-1/+9
| | | | | | XAssetStore db tables Signed-off-by: BlueWall <jamesh@bluewallgroup.com>
* Follow up to last commit, fix field lengthCinder2015-03-031-0/+3
| | | | Signed-off-by: BlueWall <jamesh@bluewallgroup.com>
* Fix MySQL and PGSQL *UserProfilesData.GetUserAppData() calls to correctly ↵Justin Clark-Casey (justincc)2015-01-131-1/+1
| | | | | | set the UserId parameter instead of the non-existing Id parameter when writing a record because none yet exists. SQLite version is already correct for this.
* Fix whitespace hoping to avoid a floggingBlueWall2014-11-251-5/+5
|
* Re-work handling of email notifications settings.BlueWall2014-11-241-3/+0
|
* Fix handling of user preference updates where no email address is suppliedBlueWall2014-11-231-4/+9
|
* Add hypergrid teleporting support to user profiles picksBlueWall2014-10-272-3/+12
|
* Fix logging level to Error in exception handlersBlueWall2014-10-151-18/+18
|
* Remove database connection locking in MySQLXAssetData. This is unnecessary ↵Justin Clark-Casey (justincc)2014-08-221-186/+168
| | | | as connections aren't shared and transactions are already in place where necessary.
* Remove query locking in MySQLUserProfileData. This is not necessary as the ↵Justin Clark-Casey (justincc)2014-08-221-20/+8
| | | | connection is not shared.
* Remove some use of database connection locking from MySQLSimulationData - ↵Justin Clark-Casey (justincc)2014-08-221-318/+298
| | | | | | | | | this has not been necessary for some time as database connections are not shared. However, many locks remain since they may effectively be providing transactionality in some operations (e.g. prim updates across multiple tables). These are candidates for being replaced with proper database transactions, since this would not block unrelated operations (e.g. land save and object save) or unrelated operations on the same tables (e.g. storage of one linkset whilst another is being removed). In practice, any performance deg due to contention is probably rare and short lived as the major prim operations are performed in memory and only persisted some time afterwards.
* Remove lock in MySQLFramework. This is not necessary as the connection is ↵Justin Clark-Casey (justincc)2014-08-221-21/+12
| | | | not shared.
* Removing locking on requests in MySQLAssetData.Justin Clark-Casey (justincc)2014-08-221-161/+144
| | | | | | These locks are not necessary since the connection is taken from the underlying mysql pool and not shared. Such locking is already not done by some other parts of OpenSim.Data.MySQL. Pointed out by arribasim-dev
* Add missing parts to profiles - classified deleteBlueWall2014-07-211-7/+3
|
* Change assembly versions to 0.8.1Justin Clark-Casey (justincc)2014-06-171-1/+1
|
* Fix a bug where estate not found would result in a dummy estate record with ↵Diva Canto2014-05-311-2/+9
| | | | | | erroneous information. Also, added conversion of EstateSettings from/to key-value pairs in preparation for robust net work connectors.
* 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-241-5/+0
| | | | constructing the HTTP requests manually. This allows the calls to be logged when using "debug http all 6".
* Eliminated many warningsOren Hurvitz2014-04-232-2/+2
|
* 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-222-8/+8
| | | | pre-truncate the description of dynamic textures.
* Better logging in PresenceService, to help diagnose presence problems.Oren Hurvitz2014-04-211-1/+9
|
* Added assets service method AssetsExist(), which returns whether the given ↵Oren Hurvitz2014-04-022-43/+39
| | | | | | 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.
* 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.
* Repair database routines so they properly return null when asked forRobert Adams2014-01-281-1/+5
| | | | the heighmap of a region that does not exist.
* Merge branch 'master' into varregionRobert Adams2014-01-191-1/+11
|\
| * Merge branch 'justincc-master'Justin Clark-Casey (justincc)2014-01-161-1/+11
| |\
| | * In the offline message table, store the sender.Oren Hurvitz2014-01-161-1/+11
| | | | | | | | | | | | 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-172-27/+42
|\ \ \ | |/ / | | | | | | | | | | | | | | | | | | 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-161-6/+10
| |/ | | | | | | return an error indicating no email is on record for the user.
generated by cgit v1.1 at 2024-10-11 17:06:52 +0000