aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MSSQL (unfollow)
Commit message (Collapse)AuthorFilesLines
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.
2008-04-21* Optimised using statements and namespace references across entire project ↵Adam Frisby6-18/+21
(this took a while to run).
2008-04-11* Discerned between AddProfile and UpdateProfile in region registrationlbsa711-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. ::
2008-04-10renaming of attributes in UserAgentData for readabilitySean Dague1-3/+3
2008-04-10changing UserAgentData to use properties. This caused moreSean Dague1-11/+14
grief than expected, as monodevelop doesn't like to refactor properties of properties.
2008-04-10further renaming of properties for claritySean Dague2-20/+20
2008-04-10moved fields to properties for UserDataProfile, which wasSean Dague2-53/+53
actually a little more work than I expected given the copious use of out params.
2008-04-08further refactor and rename of InventoryFolderBase propertiesSean Dague1-3/+3
to reflect what they really are.
2008-04-07more refactoring, this time on InventoryFolderBaseSean Dague1-25/+25
* wrap attributes in properties * clean up names a little bit * clean up name styles
2008-04-07Refactor InventoryItemBase to do the following:Sean Dague1-41/+41
* wrap fields as Properties * rename some fields/properties to more sensible names * set style to PropName to match more standard C# approach
2008-04-03Update svn properties.Jeff Ames1-44/+44