aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MSSQL (unfollow)
Commit message (Collapse)AuthorFilesLines
2008-10-03Add the missing bits for the new region-search:Homer Horwitz1-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.
2008-09-29* Add missing mssql migration files from ↵Justin Clarke Casey3-0/+76
http://opensimulator.org/mantis/view.php?id=2295 * Sorry about that
2008-09-29* Apply http://opensimulator.org/mantis/view.php?id=2295Justin Clarke Casey4-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
2008-09-28Mantis#2291. Thank you kindly, StrawberryFride for a patch that solves:Charles Krinke3-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.
2008-09-26* Patch from JHurlimanTeravus Ovares2-3/+3
* Updates to libomv r2243, * Remove lots of unnecessary typecasts * Improves SendWindData() Thanks jhurliman. * Will update OpenSim-libs in 10 minutes..
2008-09-24Add persistence of active gestures. This needs an UGAIM update to work.Homer Horwitz1-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.
2008-09-18- Add Dispose method to IRegionDataStoreHomer Horwitz1-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)
2008-09-14Mantis #2124Melanie Thielker20-1716/+2534
Thank you, RuudL, for a patch that brings MSSQL up to the same implementation level as MySQL.
2008-09-12* Make fix to MSSQLRegionData.cs in LoadLandObjects as recommended by ↵Justin Clarke Casey1-1/+1
Garrett Hussey in Re: [Opensim-dev] MSSQL runtime error in latest build.. * Thanks!
2008-09-09Update svn properties, formatting cleanup.Jeff Ames1-2/+2
2008-09-06* This is the fabled LibOMV update with all of the libOMV types from JHurlimanTeravus Ovares7-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.
2008-09-06* Blind fix what looks like a bug in the new land MSSQL codeJustin Clarke Casey1-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
2008-09-06* Remove lots of warnings from the CMS moduleJustin Clarke Casey2-3/+2
* Remove a few other miscellaneous warnings
2008-09-02Committing the missing resource file for MSSQL. Sorry...Melanie Thielker1-0/+161
2008-09-02Mantis #2102Melanie Thielker2-8/+10
Thank you, RuudL, for a patch that supplements the previous MSSQL patch.
2008-09-01Mantis #2095Melanie Thielker10-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.
2008-08-19Attachment persistence (Mantis #1711)Melanie Thielker1-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.
2008-08-18Formatting cleanup.Jeff Ames5-25/+25
2008-08-16* Rename *DataStore classes to *RegionData to align with SQLiteJustin Clarke Casey1-0/+0
2008-08-06Thanks, zaki, for a patch that embeds plugin manifest files into plugin ↵Mike Mazur1-0/+23
dlls. Fix issue 1876.
2008-07-31Apply updated patch from issue 1871. Thanks sempuki.Mike Mazur1-1/+1
2008-07-31Thanks, sempuki, for a patch that moves all Grid Server's plugins toMike Mazur3-8/+22
PluginLoader. Fix issue 1871.
2008-07-23refactor TaskInventoryItem Mask -> Permissions to be consistant with how thingsSean Dague1-10/+10
are stored in the db.
2008-07-23refactored LandData to use properties, and cleaned up the naming onSean Dague1-66/+66
the properties a bit to be more consistant with other objects (having things like .Name .Description, etc).
2008-07-23Thanks, sempuki, for a patch that moves control of Mono.Addins from source ↵Mike Mazur2-11/+0
attributes to external XML files. Fix issues 1682 and 1786.
2008-07-20Mantis#1796. Thank you kindly, StrawberryFride for a patch that:Charles Krinke2-2/+67
Agent table code (INSERT / UPDATE, etc) now added to MSSQL provider.
2008-07-19Update svn properties. Fix some inconsistent newlines.Jeff Ames1-216/+216
2008-07-18Introduce a separate connection string for estates, which defaults to the one giMelanie Thielker1-21/+1
ven for the region datastore. Removes the flag to store prim inventories, which are now always stored.
2008-07-18Thanks, sempuki, for a patch that moves all grid plugins to new PluginLoader ↵Mike Mazur2-11/+41
(issue 1763).
2008-07-18Patch #9151Melanie Thielker1-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.
2008-07-17Mantis#1736. Thank you kindly, StrawberryFride for a patch that:Charles Krinke8-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.
2008-07-12Mantis#1726. Thank you kindly, StrawberryFride for a patch that:Charles Krinke1-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.
2008-07-07change SitTarget calls from functions to propertiesSean Dague1-14/+15
2008-07-07* remove unused CommitAssets() hook for nowJustin Clarke Casey1-7/+0
2008-07-02* Drop InvType from the assets table since it is no longer usedJustin Clarke Casey3-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
2008-06-29patch and files from mantis #1630, Thanks MelanieMW1-0/+9
2008-06-27last round of warning squashing. calling it a day now.Dr Scofield3-7/+7
2008-06-27Mantis#1591. Thank you graciously, Sempuki for a patch that:Charles Krinke1-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.
2008-06-26Apply patch from bug #1609 -- Documentation for Data/MSSQL. Thanks ↵Jeff Ames6-29/+446
kerunix_Flan!
2008-06-26Mantis#1595. Thank you, Melanie for a patch that:Charles Krinke1-0/+3
Adds pipes for the prim item flags field
2008-06-21* Adds Region ban capability to Regions. You access this by going to ↵Teravus Ovares1-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.
2008-06-12* minor: Remove and tidy duplicate 'storing object to scene' messages in logJustin Clarke Casey1-1/+1
2008-06-11Mantis#1528. Thank you kindly, Boscata for:Charles Krinke2-29/+168
MSSQL Avatar appearance solved. Appearance functions and modified table.
2008-06-09*Patched CreateItemsTable.sql (MSSQL). Patch by Kyle and Chris from G2.mingchen1-1/+1
2008-06-06MSSQL Inventory Fix. Patch by Kyle and Chris from G2mingchen1-82/+89
2008-06-05Mantis#1450. Thank you kindly, Boscata for a patch that addresses:Charles Krinke2-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.
2008-05-31* Implements UserServer logoff in a few situationsTeravus Ovares1-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.
2008-05-28actually user the database_connect string for mysql. Sean Dague1-8/+0
This means you can run all the OpenSim grid services without needing a mysql_connection.ini
2008-05-28let Grid Servers specify a connect string in their configuration.Sean Dague2-2/+4
2008-05-21this removes use of the mapper for wearables, and I can confirm thingsSean Dague1-9/+9
get saved to the database. There are still issues on wearing things after a cleared cache that I'm looking at now.