aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL (unfollow)
Commit message (Collapse)AuthorFilesLines
2014-06-10Fix 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.
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-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.
2013-09-22Preserve attachment point & position when attachment is rezzed in worldAleric Inglewood2-5/+34
Patch taken from http://opensimulator.org/mantis/view.php?id=4905 originally by Greg C. Fixed to apply to r/23314 commit ba9daf849e7c8db48e7c03e7cdedb77776b2052f (cherry picked from commit 4ff9fbca441110cc2b93edc7286e0e9339e61cbe)
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.
2013-07-28This makes group search work (Groups V2).Diva Canto1-1/+1
2013-07-14Cleanup old hg sessions (older than 2 days)Diva Canto2-0/+11
2013-07-14HG UAS: Moved hg-session data from memory to DB storage. This makes it so ↵Diva Canto2-0/+87
that traveling info survives Robust resets. It should also eliminate the cause of empty IP addresses in agent circuit data that we saw in CC grid. MySQL only.
2013-07-04HG Friends: migration #3 is failing on some installations of MySql. Setting ↵Diva Canto1-1/+1
the table to InnoDB seems to fix the problem.
2013-07-02Fix SQL statementDiva Canto1-1/+1
2013-07-02Really make it call the method with the query interfaceDiva Canto1-1/+1
2013-07-02This should have a strong effect on the Unknown User issue mantis #6625Diva Canto1-2/+5
2013-06-28In XAssetService, on a delete asset request also delete the asset in any ↵Justin Clark-Casey (justincc)1-0/+2
chained service. This eliminates the async migration since it causes a race condition with the "delete asset" console command
2013-06-27Make the concept of namespaces explicit in dynamic attributesJustin Clark-Casey (justincc)1-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.
2013-06-12* This fixes having to select and deselect prim to get keyframemotion to ↵teravus1-2/+0
start running when pulled from data storage.
2013-06-06Database persistence for keyframes. Contains a Migration.Melanie2-4/+32
2013-05-31Adding standard OpenSim header to source filesBlueWall1-0/+27
2013-05-31Fill in fields with default values on profile creationBlueWall1-2/+48
2013-05-30UserProfilesBlueWall2-0/+1106
UserProfiles for Robust and Standalone. Includes service and connectors for Robust and standalone opensim plus matching region module.
2013-05-11Send up the part missing from the Avination Estate commit.Melanie1-0/+6
Warning - contains a small migration.
2013-04-28Fix wrong sql statement in offline im.Diva Canto1-5/+2
2013-04-25Recover a lost "virtual". Downstream projects need this.Diva Canto1-1/+1
2013-04-10minor: Make exceptions thrown by MySQLAssetData more consistent.Justin Clark-Casey (justincc)1-10/+19
2013-03-15Change the table and field names of XAssetService mysql db tables to be ↵Justin Clark-Casey (justincc)2-62/+60
capitalized like Avatars, Friends, etc. Also fixes access time being set on assets rather than XAssetsMeta This is to try and be somewhat consistent with other service tables that are mainly in this style. No migration is supplied, since nobody should be using this service yet except on a test basis.
2013-03-15Implement access time updates on assets for XAssetService.Justin Clark-Casey (justincc)1-38/+57
This only happens if access time is older than 30 days currently, in order to reduce database updates. The idea is to give some idea of assets which haven't been accessed for a very, very long time. These might conceivably be deleteable, though this will be a risk due to caching at other points in the chain. This is actually currently much less useable on the xasset service since access time is on metadata rather than the data itself. And many metadata entries may point to the same data. Probably need to address this.
2013-02-27Add more information to warnings logged when asset names and descriptions ↵Justin Clark-Casey (justincc)2-4/+12
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).
2013-02-19Deleted all AssemblyFileVersion directivesDiva Canto1-1/+1
2013-02-19First commit of Diva Groups. The Data bits went to OpenSim.Data core, the ↵Diva Canto2-0/+599
rest to Addons.Groups.dll.
2013-02-19Offline IM: moved the Data and MySQL bits to the corresponding places in ↵Diva Canto2-0/+86
core, so that it will be easier to plugin a SQLite backend, if anyone is interested in doing that.
2013-02-18I need these for OfflineIM and Groups.Diva Canto1-0/+60