aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MSSQL
diff options
context:
space:
mode:
authorSean Dague2008-04-10 13:53:06 +0000
committerSean Dague2008-04-10 13:53:06 +0000
commitc176caeb05c2264654b764e4d010561da60c24fc (patch)
tree87e0cab128ecaac57c5995df4cf5048185fe383f /OpenSim/Data/MSSQL
parent* Brings back map tile generation based on the terrain. The algorithm produc... (diff)
downloadopensim-SC_OLD-c176caeb05c2264654b764e4d010561da60c24fc.zip
opensim-SC_OLD-c176caeb05c2264654b764e4d010561da60c24fc.tar.gz
opensim-SC_OLD-c176caeb05c2264654b764e4d010561da60c24fc.tar.bz2
opensim-SC_OLD-c176caeb05c2264654b764e4d010561da60c24fc.tar.xz
moved fields to properties for UserDataProfile, which was
actually a little more work than I expected given the copious use of out params.
Diffstat (limited to 'OpenSim/Data/MSSQL')
-rw-r--r--OpenSim/Data/MSSQL/MSSQLManager.cs38
-rw-r--r--OpenSim/Data/MSSQL/MSSQLUserData.cs68
2 files changed, 53 insertions, 53 deletions
diff --git a/OpenSim/Data/MSSQL/MSSQLManager.cs b/OpenSim/Data/MSSQL/MSSQLManager.cs
index 5154092..e33468a 100644
--- a/OpenSim/Data/MSSQL/MSSQLManager.cs
+++ b/OpenSim/Data/MSSQL/MSSQLManager.cs
@@ -300,38 +300,38 @@ namespace OpenSim.Data.MSSQL
300 300
301 if (reader.Read()) 301 if (reader.Read())
302 { 302 {
303 retval.UUID = new LLUUID((string)reader["UUID"]); 303 retval.Id = new LLUUID((string)reader["UUID"]);
304 retval.username = (string)reader["username"]; 304 retval.FirstName = (string)reader["username"];
305 retval.surname = (string)reader["lastname"]; 305 retval.SurName = (string)reader["lastname"];
306 306
307 retval.passwordHash = (string)reader["passwordHash"]; 307 retval.PasswordHash = (string)reader["passwordHash"];
308 retval.passwordSalt = (string)reader["passwordSalt"]; 308 retval.PasswordSalt = (string)reader["passwordSalt"];
309 309
310 retval.homeRegion = Convert.ToUInt64(reader["homeRegion"].ToString()); 310 retval.HomeRegion = Convert.ToUInt64(reader["homeRegion"].ToString());
311 retval.homeLocation = new LLVector3( 311 retval.HomeLocation = new LLVector3(
312 Convert.ToSingle(reader["homeLocationX"].ToString()), 312 Convert.ToSingle(reader["homeLocationX"].ToString()),
313 Convert.ToSingle(reader["homeLocationY"].ToString()), 313 Convert.ToSingle(reader["homeLocationY"].ToString()),
314 Convert.ToSingle(reader["homeLocationZ"].ToString())); 314 Convert.ToSingle(reader["homeLocationZ"].ToString()));
315 retval.homeLookAt = new LLVector3( 315 retval.HomeLookAt = new LLVector3(
316 Convert.ToSingle(reader["homeLookAtX"].ToString()), 316 Convert.ToSingle(reader["homeLookAtX"].ToString()),
317 Convert.ToSingle(reader["homeLookAtY"].ToString()), 317 Convert.ToSingle(reader["homeLookAtY"].ToString()),
318 Convert.ToSingle(reader["homeLookAtZ"].ToString())); 318 Convert.ToSingle(reader["homeLookAtZ"].ToString()));
319 319
320 retval.created = Convert.ToInt32(reader["created"].ToString()); 320 retval.Created = Convert.ToInt32(reader["created"].ToString());
321 retval.lastLogin = Convert.ToInt32(reader["lastLogin"].ToString()); 321 retval.LastLogin = Convert.ToInt32(reader["lastLogin"].ToString());
322 322
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.ProfileCanDoMask = Convert.ToUInt32(reader["profileCanDoMask"].ToString());
327 retval.profileWantDoMask = Convert.ToUInt32(reader["profileWantDoMask"].ToString()); 327 retval.ProfileWantDoMask = Convert.ToUInt32(reader["profileWantDoMask"].ToString());
328 328
329 retval.profileAboutText = (string)reader["profileAboutText"]; 329 retval.ProfileAboutText = (string)reader["profileAboutText"];
330 retval.profileFirstText = (string)reader["profileFirstText"]; 330 retval.ProfileFirstText = (string)reader["profileFirstText"];
331 331
332 retval.profileImage = new LLUUID((string)reader["profileImage"]); 332 retval.ProfileImage = new LLUUID((string)reader["profileImage"]);
333 retval.profileFirstImage = new LLUUID((string)reader["profileFirstImage"]); 333 retval.ProfileFirstImage = 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
337 { 337 {
diff --git a/OpenSim/Data/MSSQL/MSSQLUserData.cs b/OpenSim/Data/MSSQL/MSSQLUserData.cs
index c045084..aae0095 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.UUID); 456 return GetAgentByUUID(profile.Id);
457 } 457 }
458 458
459 /// <summary> 459 /// <summary>
@@ -491,7 +491,7 @@ namespace OpenSim.Data.MSSQL
491 override public void StoreWebLoginKey(LLUUID AgentID, LLUUID WebLoginKey) 491 override public void StoreWebLoginKey(LLUUID AgentID, LLUUID WebLoginKey)
492 { 492 {
493 UserProfileData user = GetUserByUUID(AgentID); 493 UserProfileData user = GetUserByUUID(AgentID);
494 user.webLoginKey = WebLoginKey; 494 user.WebLoginKey = WebLoginKey;
495 UpdateUserProfile(user); 495 UpdateUserProfile(user);
496 496
497 } 497 }
@@ -505,14 +505,14 @@ namespace OpenSim.Data.MSSQL
505 { 505 {
506 lock (database) 506 lock (database)
507 { 507 {
508 InsertUserRow(user.UUID, user.username, 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.ProfileCanDoMask, user.ProfileWantDoMask,
514 user.profileAboutText, user.profileFirstText, user.profileImage, 514 user.ProfileAboutText, user.ProfileFirstText, user.ProfileImage,
515 user.profileFirstImage, user.webLoginKey); 515 user.ProfileFirstImage, user.WebLoginKey);
516 } 516 }
517 } 517 }
518 catch (Exception e) 518 catch (Exception e)
@@ -651,30 +651,30 @@ 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.UUID.ToString()); 654 SqlParameter param1 = new SqlParameter("@uuid", user.Id.ToString());
655 SqlParameter param2 = new SqlParameter("@username", user.username); 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);
658 SqlParameter param5 = new SqlParameter("@passwordSalt", user.passwordSalt); 658 SqlParameter param5 = new SqlParameter("@passwordSalt", user.PasswordSalt);
659 SqlParameter param6 = new SqlParameter("@homeRegion", Convert.ToInt64(user.homeRegion)); 659 SqlParameter param6 = new SqlParameter("@homeRegion", Convert.ToInt64(user.HomeRegion));
660 SqlParameter param7 = new SqlParameter("@homeLocationX", user.homeLocation.X); 660 SqlParameter param7 = new SqlParameter("@homeLocationX", user.HomeLocation.X);
661 SqlParameter param8 = new SqlParameter("@homeLocationY", user.homeLocation.Y); 661 SqlParameter param8 = new SqlParameter("@homeLocationY", user.HomeLocation.Y);
662 SqlParameter param9 = new SqlParameter("@homeLocationZ", user.homeLocation.Y); 662 SqlParameter param9 = new SqlParameter("@homeLocationZ", user.HomeLocation.Y);
663 SqlParameter param10 = new SqlParameter("@homeLookAtX", user.homeLookAt.X); 663 SqlParameter param10 = new SqlParameter("@homeLookAtX", user.HomeLookAt.X);
664 SqlParameter param11 = new SqlParameter("@homeLookAtY", user.homeLookAt.Y); 664 SqlParameter param11 = new SqlParameter("@homeLookAtY", user.HomeLookAt.Y);
665 SqlParameter param12 = new SqlParameter("@homeLookAtZ", user.homeLookAt.Z); 665 SqlParameter param12 = new SqlParameter("@homeLookAtZ", user.HomeLookAt.Z);
666 SqlParameter param13 = new SqlParameter("@created", Convert.ToInt32(user.created)); 666 SqlParameter param13 = new SqlParameter("@created", Convert.ToInt32(user.Created));
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.ProfileCanDoMask));
671 SqlParameter param18 = new SqlParameter("@profileWantDoMask", Convert.ToInt32(user.profileWantDoMask)); 671 SqlParameter param18 = new SqlParameter("@profileWantDoMask", Convert.ToInt32(user.ProfileWantDoMask));
672 SqlParameter param19 = new SqlParameter("@profileAboutText", user.profileAboutText); 672 SqlParameter param19 = new SqlParameter("@profileAboutText", user.ProfileAboutText);
673 SqlParameter param20 = new SqlParameter("@profileFirstText", user.profileFirstText); 673 SqlParameter param20 = new SqlParameter("@profileFirstText", user.ProfileFirstText);
674 SqlParameter param21 = new SqlParameter("@profileImage", user.profileImage.ToString()); 674 SqlParameter param21 = new SqlParameter("@profileImage", user.ProfileImage.ToString());
675 SqlParameter param22 = new SqlParameter("@profileFirstImage", user.profileFirstImage.ToString()); 675 SqlParameter param22 = new SqlParameter("@profileFirstImage", user.ProfileFirstImage.ToString());
676 SqlParameter param23 = new SqlParameter("@keyUUUID", user.UUID.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);
680 command.Parameters.Add(param3); 680 command.Parameters.Add(param3);