aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL (unfollow)
Commit message (Collapse)AuthorFilesLines
2012-07-07Fix storing vehicle dataMelanie1-2/+2
2012-07-07Add saving vehicle physics data to the databaseMelanie1-2/+17
2012-06-26Prevent bad prim in the database from crashing the sim, list affectedMelanie1-26/+34
ids and skip them.
2012-06-07Typo fixMelanie1-3/+5
2012-06-07Add the ability to query the MYSQL databse for a list of the stored prim UUIDsMelanie1-0/+31
2012-05-23Environment Module - allows Environment settings for Viewer3 warning: ↵PixelTomsen2-0/+73
includes database region store migrations for mssql, mysql, sqlite enable/disable this module: Cap_EnvironmentSettings = "localhost" (for enable) Cap_EnvironmentSettings = "" (for disable) at ClientStack.LindenCaps section (OpenSimDefaults.ini file) or owerwrite in OpenSim.ini mantis: http://opensimulator.org/mantis/view.php?id=5860 Signed-off-by: BlueWall <jamesh@bluewallgroup.com>
2012-05-15Port the mel/dahlia fixMelanie1-1/+8
2012-04-30If there are no new prim items to store then don't bother opening the ↵Justin Clark-Casey (justincc)1-3/+3
MySqlConnection only to do nothing with it.
2012-04-30Consistently use using() to make sure we dispose of used MySqlCommands where ↵Justin Clark-Casey (justincc)9-431/+446
this is not already being done.
2012-04-24Fixed problem with MySQL: it was possible for one thread to use an ↵Oren Hurvitz3-21/+37
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.
2012-03-20Fix an invalid cast that only showed at runtimeMelanie1-1/+1
2012-03-20Store and reload extra physics from databaseMelanie1-2/+20
2012-03-19Fix configuration problems where XAssetDatabasePlugin was picked up ↵Justin Clark-Casey (justincc)1-11/+11
accidentally. The asset data plugin now implements IXAssetData rather than IAssetData so the ordinary AssetService should no longer pick it up. This replaces the changes in 92b1ade. There is no longer any need to adjust your StandaloneCommon.ini/Robust.ini/Robust.HG.ini files. This may explain very recent issues in the last few weeks where textures have been disappearing or turning white (as they were going to different places). Unfortunately, you will need to rollback to an earlier database backup or reupload the textures.
2012-03-12Rename the stream extension method WebUtil.CopyTo() to WebUtil.CopyStream().Robert Adams1-1/+1
.NET 4.0 added the method Stream.CopyTo(stream, bufferSize). For .NET 3.5 and before, WebUtil defined an extension method for Stream with the signature Stream.CopyTo(stream, maxBytesToCopy). The meaning of the second parameter is different in the two forms and depending on which compiler and/or runtime you use, you could get one form or the other. Crashes ensue. This change renames the WebUtil stream copy method to something that cannot be confused with the new CopyTo method defined in .NET 4.0.
2012-03-09Fix a merge artefactMelanie1-4/+5
2012-03-09minor: move some compression related var setup inside compression if/then switchJustin Clark-Casey (justincc)1-4/+3
2012-03-09Put big fat EXPERIMENTAL warning in xassetservice database pluginJustin Clark-Casey (justincc)1-0/+10
This should not currently be used in any circumstances except for experimentation. Database tables used by this plugin can still change at any time with no migration path.
2012-03-06Switch to sha256 from sha1 in order to avoid future asset hash collisions.Justin Clark-Casey (justincc)2-9/+17
Some successful collision attacks have been carried out on sha1 with speculation that more are possible. http://en.wikipedia.org/wiki/Cryptographic_hash_function#Cryptographic_hash_algorithms No successful attacks have been shown on sha256, which makes it less likely that anybody will be able to engineer an asset hash collision in the future. Tradeoff is more storage required for hashes, and more cpu to hash, though this is neglible compared to db operations and network access.
2012-03-05remove unnecessary hash local variableJustin Clark-Casey (justincc)1-2/+0
2012-03-03Make asset compression optional. Currently set to false and not ↵Justin Clark-Casey (justincc)1-16/+24
configurable from outside MySQLXAssetData.
2012-03-03Implement basic gzip compression for xassetdataJustin Clark-Casey (justincc)1-10/+41
Whether this is worthwhile is debatable since here we are not transmitting data over a network In addition, jpeg2000 (the biggest data hog) is already a compressed image format. May not remain.
2012-03-03If asset data already exists with the required hash then don't rewrite itJustin Clark-Casey (justincc)1-17/+59
2012-03-02Perform asset storage transactionallyJustin Clark-Casey (justincc)1-57/+69
2012-03-02Make xassetservice execute one query to retrieve the asset, not twoJustin Clark-Casey (justincc)1-28/+4
2012-03-02Make XAssetService a de-duplicating asset service.Justin Clark-Casey (justincc)2-0/+443
This is an extremely crude implemenation which almost works by accident. Nevertheless it does work. It can be tested with the instructions at http://opensimulator.org/wiki/Feature_Proposals/Deduplicating_Asset_Service#Testing It does not interact at all with the existing asset service or any data stored there. This code is subject to change without notice and should not be used for anything other than gawking.
2012-02-29Use correct casing of RegionSettings.Sandbox in the various database modules.Justin Clark-Casey (justincc)1-1/+1
MySQL and MSSQL have it as Sandbox, sqlite as sandbox. In various different places in every plugin the wrong casing is used... Consistency, who needs it? Or one day sqlite can change to Sandbox.
2012-02-26Move KeyframeMotion from SOG to SOP because we can't persist it anyMelanie1-2/+23
other way because SOG doesn't technically exist in the DB
2012-02-04Add default value to TelehubObjectBlueWall1-0/+10
2012-02-03Fix: Covenant changed time not set ↵PixelTomsen2-3/+9
http://opensimulator.org/mantis/view.php?id=5869 Signed-off-by: BlueWall <jamesh@bluewallgroup.com>
2012-02-02Replace ParcelAccessEntry with a new struct, LandAccessEntry, which moreMelanie2-8/+15
accurately reflects the data sent by the viewer. Add times bans and the expiration of timed bans. Warning: Contains a Migration (and nuts)
2012-02-02Make ban, eject, freeze and the scripted versions of those work.Melanie1-8/+9
2012-01-30Add the needed column in the regions table and a few tweaks.Melanie1-0/+9
Warning: Contains a Migration Warning: Cannot guarantee nut free
2012-01-30Add ParcelImageID to RegionSettings so we can have that overlay.Melanie2-2/+10
Warning: Contains a Migration. Warning: May contain nuts.
2012-01-28Completely disable NPC being sensed as agents, the abuse potential is too greatMelanie1-1/+6
2012-01-24Correct some SQL syntaxMelanie1-1/+1
2012-01-24Fix merge artefacts and build breakMelanie1-1/+1
2012-01-24Add a forgotten parameterMelanie1-1/+1
2012-01-24Change Telehubs to store only the data that is really needed and notMelanie1-40/+13
additional redundant information.
2012-01-23IMPORTANT!!!!! Please READ. DO NOT Use this version or any before it since theMelanie1-12/+3
Telehub commits! They will eat your babies and corrupt your database while they munch. DO NOT use anything from the first Telehub commit to this one. FIRST GOOD COMMIT is the one FOLLOWING this one. You have been warned.
2012-01-22Fix up some parameter namingMelanie1-2/+2
2012-01-22Finish connecting Telehub to databaseBlueWall1-3/+19
2012-01-22Hooking up new telehub data to the databaseBlueWall1-0/+14
2012-01-22Change the key name I missed in last commitMelanie1-1/+1
2012-01-22Move Telehub tables and data from EstateSettings to RegionSettings.Melanie4-87/+95
This is damage control es EstateSettings is not the place this can be put. EstateSettings is nt unique to a region and therefore would introduce a hard limit of one telehub per estate, completely shutting off the option of having SL style telehubs, e.g. one per region. Whole estate teleport routing can still be implemented id desiresd, this way all options are open while the other way most options get closed off.
2012-01-21Telehub Support:BlueWall2-1/+86
Telehub settings now persist to the database and are saved across sim restarts. So-far this only works on MySQL. this is a work in progress, teleport routing is not yet implemented.
2011-12-13Spin off terrain save into a new thread and make it so that it uses the oldMelanie1-29/+34
values for places where NaN are found.
2011-12-05Don't allow deletion of a terrain from the database unless we have one to ↵Melanie1-7/+21
replace it with
2011-10-31Plug a security hole in the inventory serviceMelanie1-1/+2
2011-10-31Plug a security hole in the inventory serviceMelanie1-1/+2