diff options
Diffstat (limited to 'OpenSim/Data/MSSQL')
-rw-r--r-- | OpenSim/Data/MSSQL/MSSQLManager.cs | 14 | ||||
-rw-r--r-- | OpenSim/Data/MSSQL/MSSQLUserData.cs | 26 |
2 files changed, 20 insertions, 20 deletions
diff --git a/OpenSim/Data/MSSQL/MSSQLManager.cs b/OpenSim/Data/MSSQL/MSSQLManager.cs index e33468a..e327c46 100644 --- a/OpenSim/Data/MSSQL/MSSQLManager.cs +++ b/OpenSim/Data/MSSQL/MSSQLManager.cs | |||
@@ -300,7 +300,7 @@ namespace OpenSim.Data.MSSQL | |||
300 | 300 | ||
301 | if (reader.Read()) | 301 | if (reader.Read()) |
302 | { | 302 | { |
303 | retval.Id = new LLUUID((string)reader["UUID"]); | 303 | retval.ID = new LLUUID((string)reader["UUID"]); |
304 | retval.FirstName = (string)reader["username"]; | 304 | retval.FirstName = (string)reader["username"]; |
305 | retval.SurName = (string)reader["lastname"]; | 305 | retval.SurName = (string)reader["lastname"]; |
306 | 306 | ||
@@ -323,14 +323,14 @@ namespace OpenSim.Data.MSSQL | |||
323 | retval.UserInventoryURI = (string)reader["userInventoryURI"]; | 323 | retval.UserInventoryURI = (string)reader["userInventoryURI"]; |
324 | retval.UserAssetURI = (string)reader["userAssetURI"]; | 324 | retval.UserAssetURI = (string)reader["userAssetURI"]; |
325 | 325 | ||
326 | retval.ProfileCanDoMask = Convert.ToUInt32(reader["profileCanDoMask"].ToString()); | 326 | retval.CanDoMask = Convert.ToUInt32(reader["profileCanDoMask"].ToString()); |
327 | retval.ProfileWantDoMask = Convert.ToUInt32(reader["profileWantDoMask"].ToString()); | 327 | retval.WantDoMask = Convert.ToUInt32(reader["profileWantDoMask"].ToString()); |
328 | 328 | ||
329 | retval.ProfileAboutText = (string)reader["profileAboutText"]; | 329 | retval.AboutText = (string)reader["profileAboutText"]; |
330 | retval.ProfileFirstText = (string)reader["profileFirstText"]; | 330 | retval.FirstLifeAboutText = (string)reader["profileFirstText"]; |
331 | 331 | ||
332 | retval.ProfileImage = new LLUUID((string)reader["profileImage"]); | 332 | retval.Image = new LLUUID((string)reader["profileImage"]); |
333 | retval.ProfileFirstImage = new LLUUID((string)reader["profileFirstImage"]); | 333 | retval.FirstLifeImage = new LLUUID((string)reader["profileFirstImage"]); |
334 | retval.WebLoginKey = new LLUUID((string)reader["webLoginKey"]); | 334 | retval.WebLoginKey = new LLUUID((string)reader["webLoginKey"]); |
335 | } | 335 | } |
336 | else | 336 | else |
diff --git a/OpenSim/Data/MSSQL/MSSQLUserData.cs b/OpenSim/Data/MSSQL/MSSQLUserData.cs index aae0095..3d4cabf 100644 --- a/OpenSim/Data/MSSQL/MSSQLUserData.cs +++ b/OpenSim/Data/MSSQL/MSSQLUserData.cs | |||
@@ -453,7 +453,7 @@ namespace OpenSim.Data.MSSQL | |||
453 | override public UserAgentData GetAgentByName(string user, string last) | 453 | override public UserAgentData GetAgentByName(string user, string last) |
454 | { | 454 | { |
455 | UserProfileData profile = GetUserByName(user, last); | 455 | UserProfileData profile = GetUserByName(user, last); |
456 | return GetAgentByUUID(profile.Id); | 456 | return GetAgentByUUID(profile.ID); |
457 | } | 457 | } |
458 | 458 | ||
459 | /// <summary> | 459 | /// <summary> |
@@ -505,14 +505,14 @@ namespace OpenSim.Data.MSSQL | |||
505 | { | 505 | { |
506 | lock (database) | 506 | lock (database) |
507 | { | 507 | { |
508 | InsertUserRow(user.Id, user.FirstName, user.SurName, user.PasswordHash, user.PasswordSalt, | 508 | InsertUserRow(user.ID, user.FirstName, user.SurName, user.PasswordHash, user.PasswordSalt, |
509 | user.HomeRegion, user.HomeLocation.X, user.HomeLocation.Y, | 509 | user.HomeRegion, user.HomeLocation.X, user.HomeLocation.Y, |
510 | user.HomeLocation.Z, | 510 | user.HomeLocation.Z, |
511 | user.HomeLookAt.X, user.HomeLookAt.Y, user.HomeLookAt.Z, user.Created, | 511 | user.HomeLookAt.X, user.HomeLookAt.Y, user.HomeLookAt.Z, user.Created, |
512 | user.LastLogin, user.UserInventoryURI, user.UserAssetURI, | 512 | user.LastLogin, user.UserInventoryURI, user.UserAssetURI, |
513 | user.ProfileCanDoMask, user.ProfileWantDoMask, | 513 | user.CanDoMask, user.WantDoMask, |
514 | user.ProfileAboutText, user.ProfileFirstText, user.ProfileImage, | 514 | user.AboutText, user.FirstLifeAboutText, user.Image, |
515 | user.ProfileFirstImage, user.WebLoginKey); | 515 | user.FirstLifeImage, user.WebLoginKey); |
516 | } | 516 | } |
517 | } | 517 | } |
518 | catch (Exception e) | 518 | catch (Exception e) |
@@ -651,7 +651,7 @@ namespace OpenSim.Data.MSSQL | |||
651 | "profileFirstImage = @profileFirstImage, " + | 651 | "profileFirstImage = @profileFirstImage, " + |
652 | "webLoginKey = @webLoginKey where " + | 652 | "webLoginKey = @webLoginKey where " + |
653 | "UUID = @keyUUUID;", database.getConnection()); | 653 | "UUID = @keyUUUID;", database.getConnection()); |
654 | SqlParameter param1 = new SqlParameter("@uuid", user.Id.ToString()); | 654 | SqlParameter param1 = new SqlParameter("@uuid", user.ID.ToString()); |
655 | SqlParameter param2 = new SqlParameter("@username", user.FirstName); | 655 | SqlParameter param2 = new SqlParameter("@username", user.FirstName); |
656 | SqlParameter param3 = new SqlParameter("@lastname", user.SurName); | 656 | SqlParameter param3 = new SqlParameter("@lastname", user.SurName); |
657 | SqlParameter param4 = new SqlParameter("@passwordHash", user.PasswordHash); | 657 | SqlParameter param4 = new SqlParameter("@passwordHash", user.PasswordHash); |
@@ -667,13 +667,13 @@ namespace OpenSim.Data.MSSQL | |||
667 | SqlParameter param14 = new SqlParameter("@lastLogin", Convert.ToInt32(user.LastLogin)); | 667 | SqlParameter param14 = new SqlParameter("@lastLogin", Convert.ToInt32(user.LastLogin)); |
668 | SqlParameter param15 = new SqlParameter("@userInventoryURI", user.UserInventoryURI); | 668 | SqlParameter param15 = new SqlParameter("@userInventoryURI", user.UserInventoryURI); |
669 | SqlParameter param16 = new SqlParameter("@userAssetURI", user.UserAssetURI); | 669 | SqlParameter param16 = new SqlParameter("@userAssetURI", user.UserAssetURI); |
670 | SqlParameter param17 = new SqlParameter("@profileCanDoMask", Convert.ToInt32(user.ProfileCanDoMask)); | 670 | SqlParameter param17 = new SqlParameter("@profileCanDoMask", Convert.ToInt32(user.CanDoMask)); |
671 | SqlParameter param18 = new SqlParameter("@profileWantDoMask", Convert.ToInt32(user.ProfileWantDoMask)); | 671 | SqlParameter param18 = new SqlParameter("@profileWantDoMask", Convert.ToInt32(user.WantDoMask)); |
672 | SqlParameter param19 = new SqlParameter("@profileAboutText", user.ProfileAboutText); | 672 | SqlParameter param19 = new SqlParameter("@profileAboutText", user.AboutText); |
673 | SqlParameter param20 = new SqlParameter("@profileFirstText", user.ProfileFirstText); | 673 | SqlParameter param20 = new SqlParameter("@profileFirstText", user.FirstLifeAboutText); |
674 | SqlParameter param21 = new SqlParameter("@profileImage", user.ProfileImage.ToString()); | 674 | SqlParameter param21 = new SqlParameter("@profileImage", user.Image.ToString()); |
675 | SqlParameter param22 = new SqlParameter("@profileFirstImage", user.ProfileFirstImage.ToString()); | 675 | SqlParameter param22 = new SqlParameter("@profileFirstImage", user.FirstLifeImage.ToString()); |
676 | SqlParameter param23 = new SqlParameter("@keyUUUID", user.Id.ToString()); | 676 | SqlParameter param23 = new SqlParameter("@keyUUUID", user.ID.ToString()); |
677 | SqlParameter param24 = new SqlParameter("@webLoginKey", user.WebLoginKey.UUID.ToString()); | 677 | SqlParameter param24 = new SqlParameter("@webLoginKey", user.WebLoginKey.UUID.ToString()); |
678 | command.Parameters.Add(param1); | 678 | command.Parameters.Add(param1); |
679 | command.Parameters.Add(param2); | 679 | command.Parameters.Add(param2); |