aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MSSQL/MSSQLUserData.cs (unfollow)
Commit message (Collapse)AuthorFilesLines
2009-05-31Thank you kindly, StrawberryFride for a patch that:Charles Krinke1-7/+50
Added in some key code to read properties from MSSQL for user profiles which fixes issues of users having trouble editing estate settings on a grid where estate managers are not god, and fixes the option of enabling grid god functionality on MSSQL grids. I have applied this to trunk only. I need someone else to examine and apply to 0.6.5-Post-Fixes, or give me some direction, please.
2009-05-17Thank you kindly, StrawberryFride, for a patch that:Charles Krinke1-125/+136
Adds maturity & access logic for MSSQL platform to mirror that of MySQL as committed in 9502.
2009-03-27* This updates LibOMV to the current release 0.6.0 on March 19 2009Teravus Ovares1-1/+1
* Important: HttpServer.dll was changed to HttpServer_OpenSim.dll so that the HttpServer references do not conflict if you've copied the OpenMetaverse.Http.dll and requirements to the OpenSimulator bin folder. This means that if you reference HttpServer.dll in any projects, you will need to change the reference to HttpServer_OpenSim.dll. It still uses the Same HttpServer namespace though.
2009-02-19* Apply http://opensimulator.org/mantis/view.php?id=3142Justin Clarke Casey1-44/+44
* Changes varchar(36) columns to UUID type in MSSQL - this will be much more efficient * ===As always, please, please backup your database before applying this patch=== * Thanks Ruud Lathrop (for the patch) and StrawberryFride (for the review)
2009-02-12* optimized usings.lbsa711-1/+1
2009-01-14* Apply http://opensimulator.org/mantis/view.php?id=2995Justin Clarke Casey1-2/+2
* This fixes MSSQL for user friends lookups * Thanks StrawberryFride
2008-12-28Thank you kindly, StrawberryFride for a patch that:Charles Krinke1-1/+6
Persists appearance with MSSQL more properly.
2008-11-27* Remove unused and largely unimplemented UpdateUserCurrentRegion()Justin Clarke Casey1-11/+0
* please say if this causes you a problem
2008-11-23Plumb in the presence notifications and region shutdown/restart messagesMelanie Thielker1-0/+4
from the presence module to the message server, through the user server and on into the database. This should fix the "Already logged in" issue that grids see after a sim crashes, or a user crashes out of a sim. Not yet a 100% solution for friends, but getting there.
2008-11-17cleaning up warnings in MSSQL code.Dr Scofield1-1/+1
2008-11-15Mantis#2626: Thank you Ruud Lathrop, for a patch that cleans up MSSQL code.Homer Horwitz1-110/+4
2008-11-14Mantis #2618Melanie Thielker1-0/+1
Thank you, StrawberryFride, for a patch that adds group permission support to MSSQL. Contains a migration, back up your database.
2008-11-04* Apply http://opensimulator.org/mantis/view.php?id=2555Justin Clarke Casey1-4/+7
* Add new e-mail field to users table for MSSQL * Thanks StrawberryFride
2008-11-01Megapatch that fixes/adds: friend offer/deny/accept, friendship termination,Homer Horwitz1-0/+33
on-/offline updates, calling cards for friends. This adds methods in the DB layer and changes the MessagingServer, so a full update (incl. UGAIM) is necessary to get it working. Older regions shouldn't break, nor should older UGAIM break newer regions, but friends/presence will only work with all concerned parts (UGAIM, source region and destination region) at this revision (or later). I added the DB code for MSSQL, too, but couldn't test that. BEWARE: May contain bugs.
2008-09-29* Apply http://opensimulator.org/mantis/view.php?id=2295Justin Clarke Casey1-21/+25
* 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-26* Patch from JHurlimanTeravus Ovares1-1/+1
* Updates to libomv r2243, * Remove lots of unnecessary typecasts * Improves SendWindData() Thanks jhurliman. * Will update OpenSim-libs in 10 minutes..
2008-09-14Mantis #2124Melanie Thielker1-531/+829
Thank you, RuudL, for a patch that brings MSSQL up to the same implementation level as MySQL.
2008-09-06* This is the fabled LibOMV update with all of the libOMV types from JHurlimanTeravus Ovares1-58/+58
* 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-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 Ames1-9/+9
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 Mazur1-0/+8
PluginLoader. Fix issue 1871.
2008-07-20Mantis#1796. Thank you kindly, StrawberryFride for a patch that:Charles Krinke1-1/+8
Agent table code (INSERT / UPDATE, etc) now added to MSSQL provider.
2008-07-17Mantis#1736. Thank you kindly, StrawberryFride for a patch that:Charles Krinke1-296/+222
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-06-26Apply patch from bug #1609 -- Documentation for Data/MSSQL. Thanks ↵Jeff Ames1-8/+82
kerunix_Flan!
2008-06-11Mantis#1528. Thank you kindly, Boscata for:Charles Krinke1-1/+137
MSSQL Avatar appearance solved. Appearance functions and modified table.
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-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 Ames1-4/+4
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-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-04-21* Optimised using statements and namespace references across entire project ↵Adam Frisby1-6/+7
(this took a while to run).
2008-04-10further renaming of properties for claritySean Dague1-13/+13
2008-04-10moved fields to properties for UserDataProfile, which wasSean Dague1-34/+34
actually a little more work than I expected given the copious use of out params.
2008-04-02fix ups to include OpenSim.Framework explicit includes (theySean Dague1-0/+1
were implicitly included before). Everything builds again. Now off to testing.
2008-04-02attempt to fix up all refernces to new directory structureSean Dague1-1/+1
2008-04-02whole lot more movingSean Dague1-0/+0
2008-03-28* Introduced common abstract UserDataBase providerlbsa711-21/+21
* Weeded out multiple AvatarPickerAvatar classes
2008-03-18Formatting cleanup.Jeff Ames1-26/+26
2008-03-03* Applying Ahzz's profile patch. Thanks Ahzz! Teravus Ovares1-7/+7
* Fixed a few bugs in the patch that are sim crashers. * There's still a bug in mySQL mode/ grid mode where the main userprofile text doesn't save.
2008-02-14* Fixed #564, errors in friend sqllbsa711-4/+4
[Provided by openlifegrid.com]
2008-02-13* Fixed another bug in avatarpicker ('surname'/'lastname' mixup)lbsa711-4/+4
[Provided by openlifegrid.com]
2008-02-13* Fixed bug in avatarpicker so now you can search on single wordlbsa711-2/+1
[Provided by openlifegrid.com]
2008-02-13* Moved insertUserRow into MSSQLUserData so 'create user' works againlbsa711-1/+94
[Provided by openlifegrid.com]
2008-02-13* Moved insertRegionRow into MSSQLGridDatalbsa711-13/+18
* Split table test and creation into table by table * Debugged table creation Sql * Added missing CreateUserFriendsTable.sql
2008-02-13* Copied 'Friends' functionality from the MySQLUserData to MSSQLUserDatalbsa711-5/+136
[Provided by openlifegrid.com]
2008-02-13* Split out MSSQLManager Test/Init into each provider.lbsa711-10/+44
* Made regions table name configurable (MSSQL only) * Added a note in ini.example pointing out that the sql resources have to change if you change table names * Removed duplicate picker method from GridData interface [Provided by openlifegrid.com]