diff options
Diffstat (limited to 'OpenSim/Framework/Data.MSSQL/MSSQLManager.cs')
-rw-r--r-- | OpenSim/Framework/Data.MSSQL/MSSQLManager.cs | 96 |
1 files changed, 1 insertions, 95 deletions
diff --git a/OpenSim/Framework/Data.MSSQL/MSSQLManager.cs b/OpenSim/Framework/Data.MSSQL/MSSQLManager.cs index 26e8eb9..085cf57 100644 --- a/OpenSim/Framework/Data.MSSQL/MSSQLManager.cs +++ b/OpenSim/Framework/Data.MSSQL/MSSQLManager.cs | |||
@@ -439,101 +439,7 @@ namespace OpenSim.Framework.Data.MSSQL | |||
439 | 439 | ||
440 | return returnval; | 440 | return returnval; |
441 | } | 441 | } |
442 | 442 | ||
443 | |||
444 | /// <summary> | ||
445 | /// Creates a new user and inserts it into the database | ||
446 | /// </summary> | ||
447 | /// <param name="uuid">User ID</param> | ||
448 | /// <param name="username">First part of the login</param> | ||
449 | /// <param name="lastname">Second part of the login</param> | ||
450 | /// <param name="passwordHash">A salted hash of the users password</param> | ||
451 | /// <param name="passwordSalt">The salt used for the password hash</param> | ||
452 | /// <param name="homeRegion">A regionHandle of the users home region</param> | ||
453 | /// <param name="homeLocX">Home region position vector</param> | ||
454 | /// <param name="homeLocY">Home region position vector</param> | ||
455 | /// <param name="homeLocZ">Home region position vector</param> | ||
456 | /// <param name="homeLookAtX">Home region 'look at' vector</param> | ||
457 | /// <param name="homeLookAtY">Home region 'look at' vector</param> | ||
458 | /// <param name="homeLookAtZ">Home region 'look at' vector</param> | ||
459 | /// <param name="created">Account created (unix timestamp)</param> | ||
460 | /// <param name="lastlogin">Last login (unix timestamp)</param> | ||
461 | /// <param name="inventoryURI">Users inventory URI</param> | ||
462 | /// <param name="assetURI">Users asset URI</param> | ||
463 | /// <param name="canDoMask">I can do mask</param> | ||
464 | /// <param name="wantDoMask">I want to do mask</param> | ||
465 | /// <param name="aboutText">Profile text</param> | ||
466 | /// <param name="firstText">Firstlife text</param> | ||
467 | /// <param name="profileImage">UUID for profile image</param> | ||
468 | /// <param name="firstImage">UUID for firstlife image</param> | ||
469 | /// <returns>Success?</returns> | ||
470 | public bool insertUserRow(LLUUID uuid, string username, string lastname, string passwordHash, | ||
471 | string passwordSalt, UInt64 homeRegion, float homeLocX, float homeLocY, float homeLocZ, | ||
472 | float homeLookAtX, float homeLookAtY, float homeLookAtZ, int created, int lastlogin, | ||
473 | string inventoryURI, string assetURI, uint canDoMask, uint wantDoMask, | ||
474 | string aboutText, string firstText, | ||
475 | LLUUID profileImage, LLUUID firstImage, LLUUID webLoginKey) | ||
476 | { | ||
477 | string sql = "INSERT INTO users "; | ||
478 | sql += "([UUID], [username], [lastname], [passwordHash], [passwordSalt], [homeRegion], "; | ||
479 | sql += | ||
480 | "[homeLocationX], [homeLocationY], [homeLocationZ], [homeLookAtX], [homeLookAtY], [homeLookAtZ], [created], "; | ||
481 | sql += | ||
482 | "[lastLogin], [userInventoryURI], [userAssetURI], [profileCanDoMask], [profileWantDoMask], [profileAboutText], "; | ||
483 | sql += "[profileFirstText], [profileImage], [profileFirstImage], [webLoginKey]) VALUES "; | ||
484 | |||
485 | sql += "(@UUID, @username, @lastname, @passwordHash, @passwordSalt, @homeRegion, "; | ||
486 | sql += | ||
487 | "@homeLocationX, @homeLocationY, @homeLocationZ, @homeLookAtX, @homeLookAtY, @homeLookAtZ, @created, "; | ||
488 | sql += | ||
489 | "@lastLogin, @userInventoryURI, @userAssetURI, @profileCanDoMask, @profileWantDoMask, @profileAboutText, "; | ||
490 | sql += "@profileFirstText, @profileImage, @profileFirstImage, @webLoginKey);"; | ||
491 | |||
492 | Dictionary<string, string> parameters = new Dictionary<string, string>(); | ||
493 | parameters["UUID"] = uuid.ToString(); | ||
494 | parameters["username"] = username.ToString(); | ||
495 | parameters["lastname"] = lastname.ToString(); | ||
496 | parameters["passwordHash"] = passwordHash.ToString(); | ||
497 | parameters["passwordSalt"] = passwordSalt.ToString(); | ||
498 | parameters["homeRegion"] = homeRegion.ToString(); | ||
499 | parameters["homeLocationX"] = homeLocX.ToString(); | ||
500 | parameters["homeLocationY"] = homeLocY.ToString(); | ||
501 | parameters["homeLocationZ"] = homeLocZ.ToString(); | ||
502 | parameters["homeLookAtX"] = homeLookAtX.ToString(); | ||
503 | parameters["homeLookAtY"] = homeLookAtY.ToString(); | ||
504 | parameters["homeLookAtZ"] = homeLookAtZ.ToString(); | ||
505 | parameters["created"] = created.ToString(); | ||
506 | parameters["lastLogin"] = lastlogin.ToString(); | ||
507 | parameters["userInventoryURI"] = String.Empty; | ||
508 | parameters["userAssetURI"] = String.Empty; | ||
509 | parameters["profileCanDoMask"] = "0"; | ||
510 | parameters["profileWantDoMask"] = "0"; | ||
511 | parameters["profileAboutText"] = String.Empty; | ||
512 | parameters["profileFirstText"] = String.Empty; | ||
513 | parameters["profileImage"] = LLUUID.Zero.ToString(); | ||
514 | parameters["profileFirstImage"] = LLUUID.Zero.ToString(); | ||
515 | parameters["webLoginKey"] = LLUUID.Random().ToString(); | ||
516 | |||
517 | bool returnval = false; | ||
518 | |||
519 | try | ||
520 | { | ||
521 | IDbCommand result = Query(sql, parameters); | ||
522 | |||
523 | if (result.ExecuteNonQuery() == 1) | ||
524 | returnval = true; | ||
525 | |||
526 | result.Dispose(); | ||
527 | } | ||
528 | catch (Exception e) | ||
529 | { | ||
530 | m_log.Error(e.ToString()); | ||
531 | return false; | ||
532 | } | ||
533 | |||
534 | return returnval; | ||
535 | } | ||
536 | |||
537 | /// <summary> | 443 | /// <summary> |
538 | /// Execute a SQL statement stored in a resource, as a string | 444 | /// Execute a SQL statement stored in a resource, as a string |
539 | /// </summary> | 445 | /// </summary> |