aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL (unfollow)
Commit message (Collapse)AuthorFilesLines
2015-06-13Support for Linden AgentPreferences capability and friends ↵Cinder2-0/+91
(UpdateAgentLanguage and UpdateAgentInformation) and Mantis #7157 Signed-off-by: Diva Canto <diva@metaverseink.com>
2015-04-29Updated all occurrences of AssemblyVersion("0.8.1.*") to ↵Diva Canto1-1/+1
AssemblyVersion("0.8.2.*")
2015-04-12Change UserProfiles so that the parcel name is used for a ProfilePick and ↵AliciaRaven1-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>
2015-03-27varregion: refactor use of 'double heightmap[,]' into references to new ↵Robert Adams1-27/+39
class TerrainData and push the implementation from Scene into the database readers and writers.
2015-03-04Alter the migrations so that it is a no-op as the columns are unused and the ↵BlueWall2-4/+2
operation is very expensive
2015-03-04Chase latest change to asset description length with an update to ↵Cinder1-1/+9
XAssetStore db tables Signed-off-by: BlueWall <jamesh@bluewallgroup.com>
2015-03-04Revert "Chase latest change to asset description length with an update to ↵BlueWall1-9/+1
XAssetStore db tables" This reverts commit e520364f65e1915e13d28b829e9dd62f6904957d.
2015-03-04Chase latest change to asset description length with an update to ↵Cinder1-1/+9
XAssetStore db tables Signed-off-by: BlueWall <jamesh@bluewallgroup.com>
2015-03-03Follow up to last commit, fix field lengthCinder1-0/+3
Signed-off-by: BlueWall <jamesh@bluewallgroup.com>
2015-01-13Fix MySQL and PGSQL *UserProfilesData.GetUserAppData() calls to correctly ↵Justin Clark-Casey (justincc)1-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.
2014-11-25Fix whitespace hoping to avoid a floggingBlueWall1-5/+5
2014-11-24Re-work handling of email notifications settings.BlueWall1-3/+0
2014-11-23Fix handling of user preference updates where no email address is suppliedBlueWall1-4/+9
2014-10-27Add hypergrid teleporting support to user profiles picksBlueWall2-3/+12
2014-10-15Fix logging level to Error in exception handlersBlueWall1-18/+18
2014-09-21 remove redundant lockUbitUmarov1-1/+2
2014-08-22Remove database connection locking in MySQLXAssetData. This is unnecessary ↵Justin Clark-Casey (justincc)1-186/+168
as connections aren't shared and transactions are already in place where necessary.
2014-08-22Remove query locking in MySQLUserProfileData. This is not necessary as the ↵Justin Clark-Casey (justincc)1-20/+8
connection is not shared.
2014-08-22Remove some use of database connection locking from MySQLSimulationData - ↵Justin Clark-Casey (justincc)1-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.
2014-08-22Remove lock in MySQLFramework. This is not necessary as the connection is ↵Justin Clark-Casey (justincc)1-21/+12
not shared.
2014-08-22Removing locking on requests in MySQLAssetData.Justin Clark-Casey (justincc)1-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
2014-08-09Give extra info on the call stack when SQL errors happenMelanie Thielker1-0/+1
2014-07-29Persist new land fields for access controlMelanie Thielker1-2/+14
2014-07-21Add missing parts to profiles - classified deleteBlueWall1-7/+3
2014-06-17Change assembly versions to 0.8.1Justin Clark-Casey (justincc)1-1/+1
2014-05-31Fix a bug where estate not found would result in a dummy estate record with ↵Diva Canto1-2/+9
erroneous information. Also, added conversion of EstateSettings from/to key-value pairs in preparation for robust net work connectors.
2014-05-15Escape find string in MySQL core groups pluginJustin Clark-Casey (justincc)1-1/+1
2014-04-24When sending JSON-RPC calls (for UserProfile), use WebUtil instead of ↵Oren Hurvitz1-5/+0
constructing the HTTP requests manually. This allows the calls to be logged when using "debug http all 6".
2014-04-23Eliminated many warningsOren Hurvitz2-2/+2
2014-04-23Changed table 'im_offline' to use UTF8 characters. This fixes a problem with ↵Oren Hurvitz1-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").
2014-04-22Changed the maximum asset name and description lengths to constants. Also, ↵Oren Hurvitz2-8/+8
pre-truncate the description of dynamic textures.
2014-04-21Better logging in PresenceService, to help diagnose presence problems.Oren Hurvitz1-1/+9
2014-04-02Added assets service method AssetsExist(), which returns whether the given ↵Oren Hurvitz2-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.
2014-03-24Fixed updating usersettings in the databaseOren Hurvitz1-2/+2
Resolves http://opensimulator.org/mantis/view.php?id=6938
2014-03-24Don't show hidden groups in search resultsOren Hurvitz1-3/+3
Resolves http://opensimulator.org/mantis/view.php?id=6937
2014-03-18Fix a bug in previous commit 01520bb where I accidentally saved ↵Justin Clark-Casey (justincc)1-1/+1
OtherCleanTime instead of Dwell
2014-03-18Save and load dwell parcel stat in MySQL DB adaptor. Field in table already ↵Justin Clark-Casey (justincc)1-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.
2014-01-28Repair database routines so they properly return null when asked forRobert Adams1-1/+5
the heighmap of a region that does not exist.
2014-01-16In the offline message table, store the sender.Oren Hurvitz1-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.
2014-01-05Remove the core module extra profile settings support carried in with the latestMelanie1-2/+2
patches. We don't need it.
2013-12-16Fix issue with editing notes for other avatarsBlueWall1-0/+4
2013-12-16Populate user preferences with UserAccount email if it is present, else ↵BlueWall1-6/+10
return an error indicating no email is on record for the user.
2013-12-07Revert "Add support for user preferences (im via email)"Melanie2-28/+21
This reverts commit 1842388bb4dcf5ecd57732ffa877b6ca1a3dec7b.
2013-12-06Add support for user preferences (im via email)BlueWall2-21/+28
2013-12-05Stop writing partner id to record when updating profile data. This should be ↵BlueWall1-2/+0
changed only by admin in backend.
2013-11-01varregion: push TerrainData implementation up and down the database storage ↵Robert Adams1-21/+11
stack. Implement both LoadTerrain and StoreTerrain for all DBs. Move all database blob serialization/deserialization into TerrainData.
2013-10-07varregion: plug in TerrainData class and modify TerrainModule and ↵Robert Adams1-30/+17
LLClientView to use same. This passes a terrain info class around rather than passing a one dimensional array thus allowing variable regions. Update the database storage for variable region sizes. This should be downward compatible (same format for 256x256 regions).
2013-10-04Bump OPenSimulator version and assembly versions up to 0.8.0 DevJustin Clark-Casey (justincc)1-1/+1
2013-09-28Remove time based terrain storage in SQLite so revision number can be usedRobert Adams1-3/+4
to denote terrain format revision. Add terrain DB format revision codes to ISimulationDataStore.cs. Setup so legacy compatible terrain storage and fetch is possible while allowing future format extensions.
2013-09-25Remove time based terrain storage in SQLite so revision number can be usedRobert Adams1-3/+4
to denote terrain format revision. Add terrain DB format revision codes to ISimulationDataStore.cs. Setup so legacy compatible terrain storage and fetch is possible while allowing future format extensions.