aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MSSQL (follow)
Commit message (Collapse)AuthorAgeFilesLines
* Mantis#1796. Thank you kindly, StrawberryFride for a patch that:Charles Krinke2008-07-202-2/+67
| | | | | Agent table code (INSERT / UPDATE, etc) now added to MSSQL provider.
* Update svn properties. Fix some inconsistent newlines.Jeff Ames2008-07-191-216/+216
|
* Introduce a separate connection string for estates, which defaults to the one giMelanie Thielker2008-07-181-21/+1
| | | | | | ven for the region datastore. Removes the flag to store prim inventories, which are now always stored.
* Thanks, sempuki, for a patch that moves all grid plugins to new PluginLoader ↵Mike Mazur2008-07-182-11/+41
| | | | (issue 1763).
* Patch #9151Melanie Thielker2008-07-181-4/+4
| | | | | | Makes the estate dialog fully functional. Implements all client facing functionality. Moves estate data from estate_settings.xml, which is used to provide defaults, to the region data store. Creates one estate for each region, and places the region in it. Converts all region bans to estate bans.
* Mantis#1736. Thank you kindly, StrawberryFride for a patch that:Charles Krinke2008-07-178-709/+780
| | | | | | | | | Many issues with handling connections in MSSQL, have rearchitected to ensure that connections are always opened and closed in a timely fashion & disposed of cleanly, and removed unnecessary lock statements. SQL Server performance seems to have improved considerably as a result, and various timeout errors seem to have been fixed.
* Mantis#1726. Thank you kindly, StrawberryFride for a patch that:Charles Krinke2008-07-121-0/+4
| | | | | | | | | On an MSSQL-based Grid OpenSim installation, users could log in to the sim once, then log off - after a short time before retrying users would be unable to log in, and would see an empty alert box on the client with just a "close" button and no text. Despite no users being logged into the sim, user server would report a higher number of logins than logouts.
* change SitTarget calls from functions to propertiesSean Dague2008-07-071-14/+15
|
* * remove unused CommitAssets() hook for nowJustin Clarke Casey2008-07-071-7/+0
|
* * Drop InvType from the assets table since it is no longer usedJustin Clarke Casey2008-07-023-9/+3
| | | | | | | | * Migration should be automatic on sqlite and mysql * Migration is not automatic on mssql, you will need to drop the invType column manually * Migration should be fine, but as for any db change, I would recommend making sure you have backups before moving past this revision
* patch and files from mantis #1630, Thanks MelanieMW2008-06-291-0/+9
|
* last round of warning squashing. calling it a day now.Dr Scofield2008-06-273-7/+7
|
* Mantis#1591. Thank you graciously, Sempuki for a patch that:Charles Krinke2008-06-271-0/+2
| | | | | | | | | | Currently module loading is done ad-hoc. I propose creating a simple loader class that leverages Mono.Addins (and perhaps the new .NET addins when they become available in mono). Attached is a basic patch for review that compiles into HEAD, but doesn't yet replace any existing ad-hoc loaders.
* Apply patch from bug #1609 -- Documentation for Data/MSSQL. Thanks ↵Jeff Ames2008-06-266-29/+446
| | | | kerunix_Flan!
* Mantis#1595. Thank you, Melanie for a patch that:Charles Krinke2008-06-261-0/+3
| | | | | Adds pipes for the prim item flags field
* * Adds Region ban capability to Regions. You access this by going to ↵Teravus Ovares2008-06-211-0/+16
| | | | | | | | World->Region/Estate. Then on the Estate tab, at the lower right hand corner, clicking the 'Add' button and picking an avatar. * It only persists across reboots for the mySQL datastore currently. * Currently have stubs in the other datastores.
* * minor: Remove and tidy duplicate 'storing object to scene' messages in logJustin Clarke Casey2008-06-121-1/+1
|
* Mantis#1528. Thank you kindly, Boscata for:Charles Krinke2008-06-112-29/+168
| | | | | | MSSQL Avatar appearance solved. Appearance functions and modified table.
* *Patched CreateItemsTable.sql (MSSQL). Patch by Kyle and Chris from G2.mingchen2008-06-091-1/+1
|
* MSSQL Inventory Fix. Patch by Kyle and Chris from G2mingchen2008-06-061-82/+89
|
* Mantis#1450. Thank you kindly, Boscata for a patch that addresses:Charles Krinke2008-06-052-2/+3
| | | | | | | | | | I have detected a bug of conversion data type in OpenSim.Data.MSSQL.MSSQLInventoryData.addInventoryItem(InventoryItemBase item) in the GroupOwned field. My sollution is to change the flield to bit in the table. In the readInventoryItem(IDataReader reader) change too item.Flags = (uint) reader["flags"]; to item.Flags = Convert.ToUInt32(reader["flags"]); Now Inventory runs fine.
* * Implements UserServer logoff in a few situationsTeravus Ovares2008-05-311-2/+2
| | | | | | | * User tries to log-in but is already logged in. Userserver will send message to simulator user was in to log the user out there. * From the UserServer, admin types 'logoff-user firstname lastname message'. * Some regions may not get the message because they're not updated yet.
* actually user the database_connect string for mysql. Sean Dague2008-05-281-8/+0
| | | | | | | This means you can run all the OpenSim grid services without needing a mysql_connection.ini
* let Grid Servers specify a connect string in their configuration.Sean Dague2008-05-282-2/+4
|
* this removes use of the mapper for wearables, and I can confirm thingsSean Dague2008-05-211-9/+9
| | | | | | | get saved to the database. There are still issues on wearing things after a cleared cache that I'm looking at now.
* Formatting cleanup.Jeff Ames2008-05-167-42/+42
|
* testing avatar appearance as a user serviceSean Dague2008-05-151-9/+9
|
* remove my UserAppearance object, switch all code to useSean Dague2008-05-151-3/+3
| | | | | | AvatarAppearance instead.
* * You can haz more spring cleaning.Adam Frisby2008-05-081-6/+1
| | | | | * Eventually this codebase will be clean. >_>
* * Reduced sleep durations in a number of files.Adam Frisby2008-05-081-6/+0
|
* De-tabify source.Jeff Ames2008-05-061-7/+6
|
* * Implemented DIE_AT_EDGE and Temporary objects don't save to the database.Teravus Ovares2008-05-041-1/+3
|
* plumb in connection string to the user database paths. mysql and mssqlSean Dague2008-05-021-3/+4
| | | | | | | just ignore this for now, but it lets us get connect strings to sqlite and nhibernate.
* minor refactoring. Change getName and GetVersion methods (yes the had ↵Sean Dague2008-05-021-4/+4
| | | | | | | | different casings) to Name and Version properties for the User stores.
* added stubs for appearance bits to all the db layersSean Dague2008-05-011-0/+27
|
* * Thanks to Mic Bowman for inspiring me to look at that we are still using ↵Adam Frisby2008-05-011-1/+1
| | | | ASCIIEncoder in places we shouldn't.
* * Rolled back a few changes.Adam Frisby2008-05-011-1/+1
|
* * Cleaning code still.Adam Frisby2008-05-011-1/+1
|
* * In ur code. Making it static.Adam Frisby2008-05-012-24/+24
| | | | | * Converted a bunch of functions to static functions.
* * Align new fields upgrade sql to have the same 'not null' and default ↵Justin Clarke Casey2008-05-013-19/+19
| | | | | | | | settings as when an inventoryitems table is newly created * Normalize logging titles in database code, though this doesn't yet cover invoking code
* * Spring cleaned a bunch of '//TODO: unused' marked functions.Adam Frisby2008-04-301-8/+0
|
* * Add a scratch implementation of the new inventory fields to the mssql ↵Justin Clarke Casey2008-04-302-5/+25
| | | | | | | | | database adapter * I don't use mssql so this may not work, corrections (in the form of patches) are welcome. * Unlike mysql, mssql requires manual updating of existing tables here (which should mean just adding the new fields manually)
* * Change new inventory groupID field to 36 rather than 63Justin Clarke Casey2008-04-301-1/+7
| | | | | | * Add updated stub mssql inventory sql (only really because I was in the middle of this when I spotted the numeric transposition)
* * Patch by Melanie. Implements proper objectflags on child objects. Thanks ↵Teravus Ovares2008-04-301-1/+1
| | | | | | | Melanie! RE: 0001079: r4387. touch() event does not fire when touch script is in root prim and child prims are touched
* allow for Inventory database source to be specified in mainSean Dague2008-04-231-0/+6
| | | | | | | | configs. This works with sqlite and nhibernate backends, and stays with default seperate ini files for mysql and mssql until someone writes those.
* changes to allow asset_source to be specified in the opensim.iniSean Dague2008-04-231-0/+7
| | | | | | | | this will work for sqlite and nhibernate, but will be ignored for mysql and mssql (reverting to their ini files) until someone writes that bit.
* * Optimised using statements and namespace references across entire project ↵Adam Frisby2008-04-216-18/+21
| | | | (this took a while to run).
* * Discerned between AddProfile and UpdateProfile in region registrationlbsa712008-04-111-8/+73
| | | | | :: Believe it or not, but INSERT/UPDATE is actually a better pattern than REPLACE, since, with INSERT/UPDATE you can catch erroneous UPDATES to non-INSERTed items as well as catch erroneous re-INSERTS. in 95% of the cases, you SHOULD have a clear INSERT context, and a clear and separate UPDATE context. If you think your case falls within the 5%, maybe you should re-evaluate your code. ::
* renaming of attributes in UserAgentData for readabilitySean Dague2008-04-101-3/+3
|
* changing UserAgentData to use properties. This caused moreSean Dague2008-04-101-11/+14
| | | | | | | grief than expected, as monodevelop doesn't like to refactor properties of properties.