aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MSSQL (unfollow)
Commit message (Collapse)AuthorFilesLines
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.
2008-05-16Formatting cleanup.Jeff Ames7-42/+42
2008-05-15testing avatar appearance as a user serviceSean Dague1-9/+9
2008-05-15remove my UserAppearance object, switch all code to useSean Dague1-3/+3
AvatarAppearance instead.
2008-05-08* You can haz more spring cleaning.Adam Frisby1-6/+1
* Eventually this codebase will be clean. >_>
2008-05-08* Reduced sleep durations in a number of files.Adam Frisby1-6/+0
2008-05-06De-tabify source.Jeff Ames1-7/+6
2008-05-04* Implemented DIE_AT_EDGE and Temporary objects don't save to the database.Teravus Ovares1-1/+3
2008-05-02plumb in connection string to the user database paths. mysql and mssqlSean Dague1-3/+4
just ignore this for now, but it lets us get connect strings to sqlite and nhibernate.
2008-05-02minor refactoring. Change getName and GetVersion methods (yes the had ↵Sean Dague1-4/+4
different casings) to Name and Version properties for the User stores.
2008-05-01added stubs for appearance bits to all the db layersSean Dague1-0/+27
2008-05-01* Thanks to Mic Bowman for inspiring me to look at that we are still using ↵Adam Frisby1-1/+1
ASCIIEncoder in places we shouldn't.
2008-05-01* Rolled back a few changes.Adam Frisby1-1/+1
2008-05-01* Cleaning code still.Adam Frisby1-1/+1
2008-05-01* In ur code. Making it static.Adam Frisby2-24/+24
* Converted a bunch of functions to static functions.
2008-05-01* Align new fields upgrade sql to have the same 'not null' and default ↵Justin Clarke Casey3-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
2008-04-30* Spring cleaned a bunch of '//TODO: unused' marked functions.Adam Frisby1-8/+0
2008-04-30* Add a scratch implementation of the new inventory fields to the mssql ↵Justin Clarke Casey2-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)
2008-04-30* Change new inventory groupID field to 36 rather than 63Justin Clarke Casey1-1/+7
* Add updated stub mssql inventory sql (only really because I was in the middle of this when I spotted the numeric transposition)
2008-04-30* Patch by Melanie. Implements proper objectflags on child objects. Thanks ↵Teravus Ovares1-1/+1
Melanie! RE: 0001079: r4387. touch() event does not fire when touch script is in root prim and child prims are touched
2008-04-23allow for Inventory database source to be specified in mainSean Dague1-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.
2008-04-23changes to allow asset_source to be specified in the opensim.iniSean Dague1-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.