diff options
author | Teravus Ovares | 2008-01-09 18:57:03 +0000 |
---|---|---|
committer | Teravus Ovares | 2008-01-09 18:57:03 +0000 |
commit | 49fe4eb3cdf4b5cb11e5fe0980bb7c3a3d47b6ea (patch) | |
tree | 37de8fc8d0f2507fd892b6f24ae6b5899a0f0bd7 /OpenSim/Framework/Data.MSSQL | |
parent | default to OpenSim.Framework.Data.SQLite which is the new storage (diff) | |
download | opensim-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.cs | 13 |
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(); |