aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MSSQL/MSSQLUserData.cs (unfollow)
Commit message (Collapse)AuthorFilesLines
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]
2008-02-13* Introduced customizable table names on MySQL and MSSQL UserData plug-ins.lbsa711-12/+34
[Provided by openlifegrid.com]
2008-02-05Converted logging to use log4net.Jeff Ames1-12/+14
Changed LogBase to ConsoleBase, which handles console I/O. This is mostly an in-place conversion, so lots of refactoring can still be done.
2008-01-20* Added hooks for logout to all IUserService and all that implement it.Teravus Ovares1-4/+1
* Added a Logout message with a name on the console * Added a *fixme* message to figure out why the current agent session is null * After updating you may notice that there's a login <user> and also a logout<user>