From 49fe4eb3cdf4b5cb11e5fe0980bb7c3a3d47b6ea Mon Sep 17 00:00:00 2001
From: Teravus Ovares
Date: Wed, 9 Jan 2008 18:57:03 +0000
Subject: * This may be broken..   it hasn't been tested, however I wanted to
 get the last database changes in before sdauge changes them significantly.

---
 OpenSim/Framework/Data.MSSQL/MSSQLUserData.cs | 13 +++++++++++--
 1 file changed, 11 insertions(+), 2 deletions(-)

(limited to 'OpenSim/Framework/Data.MSSQL/MSSQLUserData.cs')

diff --git a/OpenSim/Framework/Data.MSSQL/MSSQLUserData.cs b/OpenSim/Framework/Data.MSSQL/MSSQLUserData.cs
index db3c1d6..429ed39 100644
--- a/OpenSim/Framework/Data.MSSQL/MSSQLUserData.cs
+++ b/OpenSim/Framework/Data.MSSQL/MSSQLUserData.cs
@@ -297,7 +297,13 @@ namespace OpenSim.Framework.Data.MSSQL
                 return null;
             }
         }
-
+        public void StoreWebLoginKey(LLUUID AgentID, LLUUID WebLoginKey)
+        {
+            UserProfileData user = GetUserByUUID(AgentID);
+            user.webLoginKey = WebLoginKey;
+            UpdateUserProfile(user);
+            
+        }
         /// <summary>
         /// Creates a new users profile
         /// </summary>
@@ -358,7 +364,8 @@ namespace OpenSim.Framework.Data.MSSQL
                                                 "profileAboutText = @profileAboutText," +
                                                 "profileFirstText = @profileFirstText," +
                                                 "profileImage = @profileImage," +
-                                                "profileFirstImage = @profileFirstImage where " +
+                                                "profileFirstImage = @profileFirstImage, " +
+                                                "webLoginKey = @webLoginKey  where " +
                                                 "UUID = @keyUUUID;", database.getConnection());
             SqlParameter param1 = new SqlParameter("@uuid", user.UUID.ToString());
             SqlParameter param2 = new SqlParameter("@username", user.username);
@@ -383,6 +390,7 @@ namespace OpenSim.Framework.Data.MSSQL
             SqlParameter param21 = new SqlParameter("@profileImage", LLUUID.Zero.ToString());
             SqlParameter param22 = new SqlParameter("@profileFirstImage", LLUUID.Zero.ToString());
             SqlParameter param23 = new SqlParameter("@keyUUUID", user.UUID.ToString());
+            SqlParameter param24 = new SqlParameter("@webLoginKey", user.webLoginKey.UUID.ToString());
             command.Parameters.Add(param1);
             command.Parameters.Add(param2);
             command.Parameters.Add(param3);
@@ -406,6 +414,7 @@ namespace OpenSim.Framework.Data.MSSQL
             command.Parameters.Add(param21);
             command.Parameters.Add(param22);
             command.Parameters.Add(param23);
+            command.Parameters.Add(param24);
             try
             {
                 int affected = command.ExecuteNonQuery();
-- 
cgit v1.1