aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MSSQL (follow)
Commit message (Collapse)AuthorAgeFilesLines
* * minor: comment out persisting prim inventory log messagesJustin Clarke Casey2008-10-151-1/+1
|
* Add the missing bits for the new region-search:Homer Horwitz2008-10-031-0/+27
| | | | | | | | | | | | | | | | - Added lookup in the data-layer - MySQL works - SQLite doesn't have a grid-db, so it won't work there - I added MSSQL-code to the best of my knowledge; but I don't know MSSQL :-) - Added the plumbing up to OGS1GridServices. This speaks with the grid-server via XMLRPC. - Modified MapSearchModule to use the new data. It's backward compatible; if used with an old grid-server, it just returns one found region instead of a list. - Refactored a bit. Note: This updates data, grid-server and region code. No new files.
* * Add missing mssql migration files from ↵Justin Clarke Casey2008-09-293-0/+76
| | | | | | | | http://opensimulator.org/mantis/view.php?id=2295 * Sorry about that
* * Apply http://opensimulator.org/mantis/view.php?id=2295Justin Clarke Casey2008-09-294-72/+103
| | | | | | | | | | * Updated MSSQL to reflect resend changes * Added the new columns in prims table. * Created a implementation for getting gestures. * Remove configurable table names for user. * Thanks Ruud Lathorp
* Mantis#2291. Thank you kindly, StrawberryFride for a patch that solves:Charles Krinke2008-09-283-53/+0
| | | | | | | | | | User server won't start up for a MSSQL grid migrating from a significantly older version to current version due to duplication in three of the migrations code files. Patch included takes out the duplicated code from the three files so a smooth update should happen on start up.
* * Patch from JHurlimanTeravus Ovares2008-09-262-3/+3
| | | | | | | | | * Updates to libomv r2243, * Remove lots of unnecessary typecasts * Improves SendWindData() Thanks jhurliman. * Will update OpenSim-libs in 10 minutes..
* Add persistence of active gestures. This needs an UGAIM update to work.Homer Horwitz2008-09-241-0/+5
| | | | | | | | | Active gestures are sent as part of the login-response. Added fetchActiveGestures to SQLite and MySQL; added an empty one for MSSQL and NHibernate. Using the empty ones won't cause errors, but doesn't provide persistence either, of course.
* - Add Dispose method to IRegionDataStoreHomer Horwitz2008-09-181-0/+5
| | | | | | | | - Add necessary dummy Dispose-methods where they are missing - Implement the SQLite Dispose-methods (currently only used for unit tests, in the next commit)
* Mantis #2124Melanie Thielker2008-09-1420-1716/+2534
| | | | | | | Thank you, RuudL, for a patch that brings MSSQL up to the same implementation level as MySQL.
* * Make fix to MSSQLRegionData.cs in LoadLandObjects as recommended by ↵Justin Clarke Casey2008-09-121-1/+1
| | | | | | | | Garrett Hussey in Re: [Opensim-dev] MSSQL runtime error in latest build.. * Thanks!
* Update svn properties, formatting cleanup.Jeff Ames2008-09-091-2/+2
|
* * This is the fabled LibOMV update with all of the libOMV types from JHurlimanTeravus Ovares2008-09-067-197/+197
| | | | | | | * This is a HUGE OMG update and will definitely have unknown side effects.. so this is really only for the strong hearted at this point. Regular people should let the dust settle. * This has been tested to work with most basic functions. However.. make sure you back up 'everything' before using this. It's that big! * Essentially we're back at square 1 in the testing phase.. so lets identify things that broke.
* * Blind fix what looks like a bug in the new land MSSQL codeJustin Clarke Casey2008-09-061-1/+1
| | | | | | | * The data returned from the db was never inserted in the list to be processed and return * This is an example where a warning has revealed a bug
* * Remove lots of warnings from the CMS moduleJustin Clarke Casey2008-09-062-3/+2
| | | | | | * Remove a few other miscellaneous warnings
* Committing the missing resource file for MSSQL. Sorry...Melanie Thielker2008-09-021-0/+161
|
* Mantis #2102Melanie Thielker2008-09-022-8/+10
| | | | | | | Thank you, RuudL, for a patch that supplements the previous MSSQL patch.
* Mantis #2095Melanie Thielker2008-09-0110-1366/+1966
| | | | | | | Thank you, RuudL, for a complete adaptation of migration and estate data to MSSQL, and the updating of the RegionData handling in MSSQL.
* Attachment persistence (Mantis #1711)Melanie Thielker2008-08-191-31/+4
| | | | | | | | | Change user server to handle attachment assets record properly. Ensure that attachments are not re-rezzed on region crossing. Persistence will NOT WORK with earliser UGAI!! Change region server to match.
* Formatting cleanup.Jeff Ames2008-08-185-25/+25
|
* * Rename *DataStore classes to *RegionData to align with SQLiteJustin Clarke Casey2008-08-161-0/+0
|
* Thanks, zaki, for a patch that embeds plugin manifest files into plugin ↵Mike Mazur2008-08-061-0/+23
| | | | dlls. Fix issue 1876.
* Apply updated patch from issue 1871. Thanks sempuki.Mike Mazur2008-07-311-1/+1
|
* Thanks, sempuki, for a patch that moves all Grid Server's plugins toMike Mazur2008-07-313-8/+22
| | | | | | PluginLoader. Fix issue 1871.
* refactor TaskInventoryItem Mask -> Permissions to be consistant with how thingsSean Dague2008-07-231-10/+10
| | | | | | are stored in the db.
* refactored LandData to use properties, and cleaned up the naming onSean Dague2008-07-231-66/+66
| | | | | | | the properties a bit to be more consistant with other objects (having things like .Name .Description, etc).
* Thanks, sempuki, for a patch that moves control of Mono.Addins from source ↵Mike Mazur2008-07-232-11/+0
| | | | attributes to external XML files. Fix issues 1682 and 1786.
* 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
|