aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Framework/Data.MSSQL
diff options
context:
space:
mode:
authorTeravus Ovares2008-01-09 18:57:03 +0000
committerTeravus Ovares2008-01-09 18:57:03 +0000
commit49fe4eb3cdf4b5cb11e5fe0980bb7c3a3d47b6ea (patch)
tree37de8fc8d0f2507fd892b6f24ae6b5899a0f0bd7 /OpenSim/Framework/Data.MSSQL
parentdefault to OpenSim.Framework.Data.SQLite which is the new storage (diff)
downloadopensim-SC-49fe4eb3cdf4b5cb11e5fe0980bb7c3a3d47b6ea.zip
opensim-SC-49fe4eb3cdf4b5cb11e5fe0980bb7c3a3d47b6ea.tar.gz
opensim-SC-49fe4eb3cdf4b5cb11e5fe0980bb7c3a3d47b6ea.tar.bz2
opensim-SC-49fe4eb3cdf4b5cb11e5fe0980bb7c3a3d47b6ea.tar.xz
* This may be broken.. it hasn't been tested, however I wanted to get the last database changes in before sdauge changes them significantly.
Diffstat (limited to 'OpenSim/Framework/Data.MSSQL')
-rw-r--r--OpenSim/Framework/Data.MSSQL/MSSQLUserData.cs13
1 files changed, 11 insertions, 2 deletions
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
297 return null; 297 return null;
298 } 298 }
299 } 299 }
300 300 public void StoreWebLoginKey(LLUUID AgentID, LLUUID WebLoginKey)
301 {
302 UserProfileData user = GetUserByUUID(AgentID);
303 user.webLoginKey = WebLoginKey;
304 UpdateUserProfile(user);
305
306 }
301 /// <summary> 307 /// <summary>
302 /// Creates a new users profile 308 /// Creates a new users profile
303 /// </summary> 309 /// </summary>
@@ -358,7 +364,8 @@ namespace OpenSim.Framework.Data.MSSQL
358 "profileAboutText = @profileAboutText," + 364 "profileAboutText = @profileAboutText," +
359 "profileFirstText = @profileFirstText," + 365 "profileFirstText = @profileFirstText," +
360 "profileImage = @profileImage," + 366 "profileImage = @profileImage," +
361 "profileFirstImage = @profileFirstImage where " + 367 "profileFirstImage = @profileFirstImage, " +
368 "webLoginKey = @webLoginKey where " +
362 "UUID = @keyUUUID;", database.getConnection()); 369 "UUID = @keyUUUID;", database.getConnection());
363 SqlParameter param1 = new SqlParameter("@uuid", user.UUID.ToString()); 370 SqlParameter param1 = new SqlParameter("@uuid", user.UUID.ToString());
364 SqlParameter param2 = new SqlParameter("@username", user.username); 371 SqlParameter param2 = new SqlParameter("@username", user.username);
@@ -383,6 +390,7 @@ namespace OpenSim.Framework.Data.MSSQL
383 SqlParameter param21 = new SqlParameter("@profileImage", LLUUID.Zero.ToString()); 390 SqlParameter param21 = new SqlParameter("@profileImage", LLUUID.Zero.ToString());
384 SqlParameter param22 = new SqlParameter("@profileFirstImage", LLUUID.Zero.ToString()); 391 SqlParameter param22 = new SqlParameter("@profileFirstImage", LLUUID.Zero.ToString());
385 SqlParameter param23 = new SqlParameter("@keyUUUID", user.UUID.ToString()); 392 SqlParameter param23 = new SqlParameter("@keyUUUID", user.UUID.ToString());
393 SqlParameter param24 = new SqlParameter("@webLoginKey", user.webLoginKey.UUID.ToString());
386 command.Parameters.Add(param1); 394 command.Parameters.Add(param1);
387 command.Parameters.Add(param2); 395 command.Parameters.Add(param2);
388 command.Parameters.Add(param3); 396 command.Parameters.Add(param3);
@@ -406,6 +414,7 @@ namespace OpenSim.Framework.Data.MSSQL
406 command.Parameters.Add(param21); 414 command.Parameters.Add(param21);
407 command.Parameters.Add(param22); 415 command.Parameters.Add(param22);
408 command.Parameters.Add(param23); 416 command.Parameters.Add(param23);
417 command.Parameters.Add(param24);
409 try 418 try
410 { 419 {
411 int affected = command.ExecuteNonQuery(); 420 int affected = command.ExecuteNonQuery();