4 files changed, 111 insertions, 141 deletions
diff --git a/OpenSim/Framework/Communications/LoginService.cs b/OpenSim/Framework/Communications/LoginService.cs
index 5547c24..bb8cad5 100644
--- a/OpenSim/Framework/Communications/LoginService.cs
+++ b/OpenSim/Framework/Communications/LoginService.cs
@@ -114,7 +114,6 @@ namespace OpenSim.Framework.UserManagement
                        string clientversion = (string)requestData["version"];
                        m_log.Info("[LOGIN]: Client Version " + clientversion + " for " + firstname + " " + lastname);
                    }
-                    
                    userProfile = GetTheUser(firstname, lastname);
                    if (userProfile == null)
@@ -398,7 +397,6 @@ namespace OpenSim.Framework.UserManagement
        public Hashtable ProcessHTMLLogin(Hashtable keysvals)
        {
            // Matches all unspecified characters
            // Currently specified,; lowercase letters, upper case letters, numbers, underline
            //    period, space, parens, and dash.
@@ -422,44 +420,42 @@ namespace OpenSim.Framework.UserManagement
            // the client requires the HTML form field be named 'username'
            // however, the data it sends when it loads the first time is 'firstname'
            // another one of those little nuances.
            
            if (keysvals.Contains("firstname"))
-                firstname = wfcut.Replace((string)keysvals["firstname"],String.Empty,99999);
+                firstname = wfcut.Replace((string)keysvals["firstname"], String.Empty, 99999);
            if (keysvals.Contains("username"))
-                firstname = wfcut.Replace((string)keysvals["username"],String.Empty,99999);
+                firstname = wfcut.Replace((string)keysvals["username"], String.Empty, 99999);
            if (keysvals.Contains("lastname"))
-                lastname = wfcut.Replace((string)keysvals["lastname"],String.Empty,99999);
+                lastname = wfcut.Replace((string)keysvals["lastname"], String.Empty, 99999);
            if (keysvals.Contains("location"))
-                location = wfcut.Replace((string)keysvals["location"],String.Empty,99999);
+                location = wfcut.Replace((string)keysvals["location"], String.Empty, 99999);
            if (keysvals.Contains("region"))
-                region = wfcut.Replace((string)keysvals["region"],String.Empty,99999);
+                region = wfcut.Replace((string)keysvals["region"], String.Empty, 99999);
            if (keysvals.Contains("grid"))
-                grid = wfcut.Replace((string)keysvals["grid"],String.Empty,99999);
+                grid = wfcut.Replace((string)keysvals["grid"], String.Empty, 99999);
            if (keysvals.Contains("channel"))
-                channel = wfcut.Replace((string)keysvals["channel"],String.Empty,99999);
+                channel = wfcut.Replace((string)keysvals["channel"], String.Empty, 99999);
            if (keysvals.Contains("version"))
-                version = wfcut.Replace((string)keysvals["version"],String.Empty,99999);
+                version = wfcut.Replace((string)keysvals["version"], String.Empty, 99999);
            if (keysvals.Contains("lang"))
-                lang = wfcut.Replace((string)keysvals["lang"],String.Empty,99999);
+                lang = wfcut.Replace((string)keysvals["lang"], String.Empty, 99999);
           
            if (keysvals.Contains("password"))
-                password = wfcut.Replace((string)keysvals["password"], String.Empty, 99999);
+                password = wfcut.Replace((string)keysvals["password"],  String.Empty, 99999);
-            
            // load our login form.
-            string loginform = GetLoginForm(firstname,lastname,location,region,grid,channel,version,lang,password,errormessages);
+            string loginform = GetLoginForm(firstname, lastname, location, region, grid, channel, version, lang, password, errormessages);
            if (keysvals.ContainsKey("show_login_form"))
            {
-                
                UserProfileData user = GetTheUser(firstname, lastname);
                bool goodweblogin = false;
@@ -472,9 +468,10 @@ namespace OpenSim.Framework.UserManagement
                    m_userManager.StoreWebLoginKey(user.UUID, webloginkey);
                    statuscode = 301;
-                    string redirectURL = "about:blank?redirect-http-hack=" + System.Web.HttpUtility.UrlEncode("secondlife:///app/login?first_name=" + firstname + "&last_name=" +
+                    string redirectURL = "about:blank?redirect-http-hack=" +
-                                                lastname +
+                        System.Web.HttpUtility.UrlEncode("secondlife:///app/login?first_name=" + firstname + "&last_name=" +
-                                                "&location=" + location + "&grid=Other&web_login_key=" + webloginkey.ToString());
+                                                         lastname +
+                                                         "&location=" + location + "&grid=Other&web_login_key=" + webloginkey.ToString());
                    //m_log.Info("[WEB]: R:" + redirectURL);
                    returnactions["int_response_code"] = statuscode;
                    returnactions["str_redirect_location"] = redirectURL;
@@ -487,11 +484,7 @@ namespace OpenSim.Framework.UserManagement
                    loginform = GetLoginForm(firstname, lastname, location, region, grid, channel, version, lang, password, errormessages);
                    returnactions["int_response_code"] = statuscode;
                    returnactions["str_response_string"] = loginform;
                }
-                
            }
            else
            {
@@ -499,7 +492,6 @@ namespace OpenSim.Framework.UserManagement
                returnactions["str_response_string"] = loginform;
            }
            return returnactions;
-             
        }
        public string GetLoginForm(string firstname, string lastname, string location, string region, 
@@ -537,67 +529,66 @@ namespace OpenSim.Framework.UserManagement
        public string GetDefaultLoginForm()
        {
            string responseString =
-           "<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">";
+                "<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">";
-                responseString = responseString + "<html xmlns=\"http://www.w3.org/1999/xhtml\">";
+            responseString += "<html xmlns=\"http://www.w3.org/1999/xhtml\">";
-                responseString = responseString + "<head>";
+            responseString += "<head>";
-                responseString = responseString +
+            responseString += "<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\" />";
-                                 "<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\" />";
+            responseString += "<meta http-equiv=\"cache-control\" content=\"no-cache\">";
-                responseString = responseString + "<meta http-equiv=\"cache-control\" content=\"no-cache\">";
+            responseString += "<meta http-equiv=\"Pragma\" content=\"no-cache\">";
-                responseString = responseString + "<meta http-equiv=\"Pragma\" content=\"no-cache\">";
+            responseString += "<title>OpenSim Login</title>";
-                responseString = responseString + "<title>OpenSim Login</title>";
+            responseString += "<body><br />";
-                responseString = responseString + "<body><br />";
+            responseString += "<div id=\"login_box\">";
-                responseString = responseString + "<div id=\"login_box\">";
                
-                responseString = responseString + "<form action=\"/go.cgi\" method=\"GET\" id=\"login-form\">";
+            responseString += "<form action=\"/go.cgi\" method=\"GET\" id=\"login-form\">";
-                responseString = responseString + "<div id=\"message\">[$errors]</div>";
+            responseString += "<div id=\"message\">[$errors]</div>";
-                responseString = responseString + "<fieldset id=\"firstname\">";
+            responseString += "<fieldset id=\"firstname\">";
-                responseString = responseString + "<legend>First Name:</legend>";
+            responseString += "<legend>First Name:</legend>";
-                responseString = responseString + "<input type=\"text\" id=\"firstname_input\" size=\"15\" maxlength=\"100\" name=\"username\" value=\"[$firstname]\" />";
+            responseString += "<input type=\"text\" id=\"firstname_input\" size=\"15\" maxlength=\"100\" name=\"username\" value=\"[$firstname]\" />";
-                responseString = responseString + "</fieldset>";
+            responseString += "</fieldset>";
-                responseString = responseString + "<fieldset id=\"lastname\">";
+            responseString += "<fieldset id=\"lastname\">";
-                responseString = responseString + "<legend>Last Name:</legend>";
+            responseString += "<legend>Last Name:</legend>";
-                responseString = responseString + "<input type=\"text\" size=\"15\" maxlength=\"100\" name=\"lastname\" value=\"[$lastname]\" />";
+            responseString += "<input type=\"text\" size=\"15\" maxlength=\"100\" name=\"lastname\" value=\"[$lastname]\" />";
-                responseString = responseString + "</fieldset>";
+            responseString += "</fieldset>";
-                responseString = responseString + "<fieldset id=\"password\">";
+            responseString += "<fieldset id=\"password\">";
-                responseString = responseString + "<legend>Password:</legend>";
+            responseString += "<legend>Password:</legend>";
-                responseString = responseString + "<table cellspacing=\"0\" cellpadding=\"0\" border=\"0\">";
+            responseString += "<table cellspacing=\"0\" cellpadding=\"0\" border=\"0\">";
-                responseString = responseString + "<tr>";
+            responseString += "<tr>";
-                responseString = responseString + "<td colspan=\"2\"><input type=\"password\" size=\"15\" maxlength=\"100\" name=\"password\" value=\"[$password]\" /></td>";
+            responseString += "<td colspan=\"2\"><input type=\"password\" size=\"15\" maxlength=\"100\" name=\"password\" value=\"[$password]\" /></td>";
-                responseString = responseString + "</tr>";
+            responseString += "</tr>";
-                responseString = responseString + "<tr>";
+            responseString += "<tr>";
-                responseString = responseString + "<td valign=\"middle\"><input type=\"checkbox\" name=\"remember_password\" id=\"remember_password\" [$remember_password] style=\"margin-left:0px;\"/></td>";
+            responseString += "<td valign=\"middle\"><input type=\"checkbox\" name=\"remember_password\" id=\"remember_password\" [$remember_password] style=\"margin-left:0px;\"/></td>";
-                responseString = responseString + "<td><label for=\"remember_password\">Remember password</label></td>";
+            responseString += "<td><label for=\"remember_password\">Remember password</label></td>";
-                responseString = responseString + "</tr>";
+            responseString += "</tr>";
-                responseString = responseString + "</table>";
+            responseString += "</table>";
-                responseString = responseString + "</fieldset>";
+            responseString += "</fieldset>";
-                responseString = responseString + "<input type=\"hidden\" name=\"show_login_form\" value=\"FALSE\" />";
+            responseString += "<input type=\"hidden\" name=\"show_login_form\" value=\"FALSE\" />";
-                responseString = responseString + "<input type=\"hidden\" name=\"method\" value=\"login\" />";
+            responseString += "<input type=\"hidden\" name=\"method\" value=\"login\" />";
-                responseString = responseString + "<input type=\"hidden\" id=\"grid\" name=\"grid\" value=\"[$grid]\" />";
+            responseString += "<input type=\"hidden\" id=\"grid\" name=\"grid\" value=\"[$grid]\" />";
-                responseString = responseString + "<input type=\"hidden\" id=\"region\" name=\"region\" value=\"[$region]\" />";
+            responseString += "<input type=\"hidden\" id=\"region\" name=\"region\" value=\"[$region]\" />";
-                responseString = responseString + "<input type=\"hidden\" id=\"location\" name=\"location\" value=\"[$location]\" />";
+            responseString += "<input type=\"hidden\" id=\"location\" name=\"location\" value=\"[$location]\" />";
-                responseString = responseString + "<input type=\"hidden\" id=\"channel\" name=\"channel\" value=\"[$channel]\" />";
+            responseString += "<input type=\"hidden\" id=\"channel\" name=\"channel\" value=\"[$channel]\" />";
-                responseString = responseString + "<input type=\"hidden\" id=\"version\" name=\"version\" value=\"[$version]\" />";
+            responseString += "<input type=\"hidden\" id=\"version\" name=\"version\" value=\"[$version]\" />";
-                responseString = responseString + "<input type=\"hidden\" id=\"lang\" name=\"lang\" value=\"[$lang]\" />";
+            responseString += "<input type=\"hidden\" id=\"lang\" name=\"lang\" value=\"[$lang]\" />";
-                responseString = responseString + "<div id=\"submitbtn\">";
+            responseString += "<div id=\"submitbtn\">";
-                responseString = responseString + "<input class=\"input_over\" type=\"submit\" value=\"Connect\" />";
+            responseString += "<input class=\"input_over\" type=\"submit\" value=\"Connect\" />";
-                responseString = responseString + "</div>";
+            responseString += "</div>";
-                responseString = responseString + "<div id=\"connecting\" style=\"visibility:hidden\"> Connecting...</div>";
+            responseString += "<div id=\"connecting\" style=\"visibility:hidden\"> Connecting...</div>";
-                responseString = responseString + "<div id=\"helplinks\">";
+            responseString += "<div id=\"helplinks\">";
-                responseString = responseString + "<a href=\"#join now link\" target=\"_blank\"></a> | ";
+            responseString += "<a href=\"#join now link\" target=\"_blank\"></a> | ";
-                responseString = responseString + "<a href=\"#forgot password link\" target=\"_blank\"></a>";
+            responseString += "<a href=\"#forgot password link\" target=\"_blank\"></a>";
-                responseString = responseString + "</div>";
+            responseString += "</div>";
-                responseString = responseString + "<div id=\"channelinfo\"> [$channel] | [$version]=[$lang]</div>";
+            responseString += "<div id=\"channelinfo\"> [$channel] | [$version]=[$lang]</div>";
-                responseString = responseString + "</form>";
+            responseString += "</form>";
-                responseString = responseString + "<script language=\"JavaScript\">";
+            responseString += "<script language=\"JavaScript\">";
-                responseString = responseString + "document.getElementById('firstname_input').focus();";
+            responseString += "document.getElementById('firstname_input').focus();";
-                responseString = responseString + "</script>";
+            responseString += "</script>";
-                responseString = responseString + "</div>";
+            responseString += "</div>";
-                responseString = responseString + "</div>";
+            responseString += "</div>";
-                responseString = responseString + "</body>";
+            responseString += "</body>";
-                responseString = responseString + "</html>";
+            responseString += "</html>";
            return responseString;
        }
@@ -611,7 +602,6 @@ namespace OpenSim.Framework.UserManagement
            return m_userManager.CommitAgent(ref profile);
        }
        /// <summary>
        /// Checks a user against it's password hash
        /// </summary>
@@ -638,7 +628,7 @@ namespace OpenSim.Framework.UserManagement
            //m_log.Info("[LOGIN]: userprofile:" + profile.passwordHash + " SubCT:" + password);
            passwordSuccess = (profile.passwordHash.Equals(s.ToString(), StringComparison.InvariantCultureIgnoreCase) 
-                            || profile.passwordHash.Equals(password,StringComparison.InvariantCultureIgnoreCase));
+                            || profile.passwordHash.Equals(password, StringComparison.InvariantCultureIgnoreCase));
            return passwordSuccess;
        }
@@ -699,7 +689,6 @@ namespace OpenSim.Framework.UserManagement
                buddyitem.BuddyRightsHave = (int)fl.FriendListOwnerPerms;
                buddyitem.BuddyRightsGiven = (int) fl.FriendPerms;
                buddylistreturn.AddNewBuddy(buddyitem);
            }
            return buddylistreturn;
        }
diff --git a/OpenSim/Framework/Communications/UserManagerBase.cs b/OpenSim/Framework/Communications/UserManagerBase.cs
index b8e3114..48807c2 100644
--- a/OpenSim/Framework/Communications/UserManagerBase.cs
+++ b/OpenSim/Framework/Communications/UserManagerBase.cs
@@ -194,7 +194,6 @@ namespace OpenSim.Framework.UserManagement
        /// <returns>A List of FriendListItems that contains info about the user's friends</returns>
        public List<FriendListItem> GetUserFriendList(LLUUID ownerID)
        {
            foreach (KeyValuePair<string, IUserData> plugin in _plugins)
            {
                try
@@ -208,12 +207,10 @@ namespace OpenSim.Framework.UserManagement
            }
            return null;
        }
        public void StoreWebLoginKey(LLUUID agentID, LLUUID webLoginKey)
        {
            foreach (KeyValuePair<string, IUserData> plugin in _plugins)
            {
                try
@@ -240,10 +237,8 @@ namespace OpenSim.Framework.UserManagement
                    m_log.Info("[USERSTORAGE]: Unable to AddNewUserFriend via " + plugin.Key + "(" + e.ToString() + ")");
                }
            }
        }
        public void RemoveUserFriend(LLUUID friendlistowner, LLUUID friend)
        {
            foreach (KeyValuePair<string, IUserData> plugin in _plugins)
@@ -273,6 +268,7 @@ namespace OpenSim.Framework.UserManagement
                }
            }
        }
        /// <summary>
        /// Loads a user agent by name (not called directly)
        /// </summary>
@@ -295,7 +291,10 @@ namespace OpenSim.Framework.UserManagement
            return null;
        }
-        // TODO: document
+        /// <summary>
+        /// Resets the currentAgent in the user profile
+        /// </summary>
+        /// <param name="agentID">The agent's ID</param>
        public void clearUserAgent(LLUUID agentID)
        {
            UserProfileData profile = GetUserProfile(agentID);
@@ -459,7 +458,6 @@ namespace OpenSim.Framework.UserManagement
                    // If currentagent is null, we can't reference it here or the UserServer crashes!
                    m_log.Info("[LOGOUT]: didn't save logout position: " + userid.ToString());
                }
-                
            }
            else
            {
diff --git a/OpenSim/Framework/Data.MySQL/MySQLManager.cs b/OpenSim/Framework/Data.MySQL/MySQLManager.cs
index 46fd1bc..d422687 100644
--- a/OpenSim/Framework/Data.MySQL/MySQLManager.cs
+++ b/OpenSim/Framework/Data.MySQL/MySQLManager.cs
@@ -138,13 +138,11 @@ namespace OpenSim.Framework.Data.MySQL
            string dllName = module.Assembly.ManifestModule.Name;
            Version dllVersion = module.Assembly.GetName().Version;
            return
                string.Format("{0}.{1}.{2}.{3}", dllVersion.Major, dllVersion.Minor, dllVersion.Build,
                              dllVersion.Revision);
        }
        /// <summary>
        /// Extract a named string resource from the embedded resources
        /// </summary>
@@ -156,7 +154,9 @@ namespace OpenSim.Framework.Data.MySQL
            string[] names = assem.GetManifestResourceNames();
            foreach (string s in names)
+            {
                if (s.EndsWith(name))
+                {
                    using (Stream resource = assem.GetManifestResourceStream(s))
                    {
                        using (StreamReader resourceReader = new StreamReader(resource))
@@ -165,6 +165,8 @@ namespace OpenSim.Framework.Data.MySQL
                            return resourceString;
                        }
                    }
+                }
+            }
            throw new Exception(string.Format("Resource '{0}' was not found", name));
        }
@@ -214,8 +216,7 @@ namespace OpenSim.Framework.Data.MySQL
            }
        }
+        // TODO: at some time this code should be cleaned up
-        // at some time this code should be cleaned up
        /// <summary>
        /// Runs a query with protection against SQL Injection by using parameterised input.
@@ -249,7 +250,7 @@ namespace OpenSim.Framework.Data.MySQL
                    {
                    }
-                    // Try reopen it
+                    // Try to reopen it
                    try
                    {
                        dbcon = new MySqlConnection(connectionString);
@@ -368,7 +369,7 @@ namespace OpenSim.Framework.Data.MySQL
                retval.reservationMinY = Convert.ToInt32(reader["resYMin"].ToString());
                retval.reservationName = (string) reader["resName"];
                retval.status = Convert.ToInt32(reader["status"].ToString()) == 1;
-               LLUUID.TryParse((string) reader["userUUID"], out retval.userUUID);
+                LLUUID.TryParse((string) reader["userUUID"], out retval.userUUID);
            }
            else
            {
@@ -458,22 +459,22 @@ namespace OpenSim.Framework.Data.MySQL
                else 
                    retval.profileAboutText = (string) reader["profileAboutText"];
-                if (reader.IsDBNull( reader.GetOrdinal( "profileFirstText" ) ) )
+                if (reader.IsDBNull(reader.GetOrdinal("profileFirstText")))
                    retval.profileFirstText = "";
                else
                    retval.profileFirstText = (string)reader["profileFirstText"];
-                if (reader.IsDBNull( reader.GetOrdinal( "profileImage" ) ) )
+                if (reader.IsDBNull(reader.GetOrdinal("profileImage")))
                    retval.profileImage = LLUUID.Zero;
                else 
                    LLUUID.TryParse((string)reader["profileImage"], out retval.profileImage);
-                if (reader.IsDBNull( reader.GetOrdinal( "profileFirstImage" ) ) )
+                if (reader.IsDBNull(reader.GetOrdinal("profileFirstImage")))
                    retval.profileFirstImage = LLUUID.Zero;
                else 
                    LLUUID.TryParse((string)reader["profileFirstImage"], out retval.profileFirstImage);
                
-                if( reader.IsDBNull( reader.GetOrdinal( "webLoginKey" ) ) )
+                if(reader.IsDBNull(reader.GetOrdinal("webLoginKey")))
                {
                    retval.webLoginKey = LLUUID.Zero;
                }
@@ -489,7 +490,6 @@ namespace OpenSim.Framework.Data.MySQL
            return retval;
        }
        /// <summary>
        /// Inserts a new row into the log database
        /// </summary>
@@ -534,7 +534,6 @@ namespace OpenSim.Framework.Data.MySQL
            return returnval;
        }
        /// <summary>
        /// Creates a new user and inserts it into the database
        /// </summary>
@@ -630,7 +629,7 @@ namespace OpenSim.Framework.Data.MySQL
            return returnval;
        }
-                /// <summary>
+        /// <summary>
        /// Creates a new user and inserts it into the database
        /// </summary>
        /// <param name="uuid">User ID</param>
@@ -823,6 +822,7 @@ namespace OpenSim.Framework.Data.MySQL
            return returnval;
        }
        /// <summary>
        /// Delete a region from the database
        /// </summary>
@@ -833,14 +833,13 @@ namespace OpenSim.Framework.Data.MySQL
        {
            bool returnval = false;
-            string sql =
+            string sql = "DELETE FROM regions WHERE uuid = ?uuid;";
-                "DELETE FROM regions WHERE uuid = ?uuid;";
            Dictionary<string, string> parameters = new Dictionary<string, string>();
            try
            {
-                    parameters["?uuid"] = uuid;
+                parameters["?uuid"] = uuid;
                IDbCommand result = Query(sql, parameters);
diff --git a/OpenSim/Framework/Data.MySQL/MySQLUserData.cs b/OpenSim/Framework/Data.MySQL/MySQLUserData.cs
index 4c76461..1370b1b 100644
--- a/OpenSim/Framework/Data.MySQL/MySQLUserData.cs
+++ b/OpenSim/Framework/Data.MySQL/MySQLUserData.cs
@@ -108,7 +108,6 @@ namespace OpenSim.Framework.Data.MySQL
            UpgradeAgentsTable(tableList[m_agentsTableName]);
            UpgradeUsersTable(tableList[m_usersTableName]);
            UpgradeFriendsTable(tableList[m_userFriendsTableName]);
        }
        /// <summary>
@@ -227,7 +226,6 @@ namespace OpenSim.Framework.Data.MySQL
                        "(?friendID,?ownerID,?friendPerms,?datetimestamp)",
                            param);
                    adder.ExecuteNonQuery();
                }
            }
            catch (Exception e)
@@ -244,23 +242,21 @@ namespace OpenSim.Framework.Data.MySQL
            param["?ownerID"] = friendlistowner.UUID.ToString();
            param["?friendID"] = friend.UUID.ToString();
            try
            {
                lock (database)
                {
                    IDbCommand updater =
                        database.Query(
-                        "delete from " + m_userFriendsTableName + " where ownerID = ?ownerID and friendID = ?friendID",
+                            "delete from " + m_userFriendsTableName + " where ownerID = ?ownerID and friendID = ?friendID",
                            param);
                    updater.ExecuteNonQuery();
                    updater =
                        database.Query(
-                        "delete from " + m_userFriendsTableName + " where ownerID = ?friendID and friendID = ?ownerID",
+                            "delete from " + m_userFriendsTableName + " where ownerID = ?friendID and friendID = ?ownerID",
                            param);
                    updater.ExecuteNonQuery();
                }
            }
            catch (Exception e)
@@ -270,13 +266,13 @@ namespace OpenSim.Framework.Data.MySQL
                return;
            }
        }
        public void UpdateUserFriendPerms(LLUUID friendlistowner, LLUUID friend, uint perms)
        {
            Dictionary<string, string> param = new Dictionary<string, string>();
            param["?ownerID"] = friendlistowner.UUID.ToString();
            param["?friendID"] = friend.UUID.ToString();
            param["?friendPerms"] = perms.ToString();
-            
            try
            {
@@ -284,12 +280,11 @@ namespace OpenSim.Framework.Data.MySQL
                {
                    IDbCommand updater =
                        database.Query(
-                        "update " + m_userFriendsTableName +
+                            "update " + m_userFriendsTableName +
-                        " SET friendPerms = ?friendPerms " +
+                            " SET friendPerms = ?friendPerms " +
-                        "where ownerID = ?ownerID and friendID = ?friendID",
+                            "where ownerID = ?ownerID and friendID = ?friendID",
                            param);
                    updater.ExecuteNonQuery();
                }
            }
            catch (Exception e)
@@ -300,7 +295,6 @@ namespace OpenSim.Framework.Data.MySQL
            }
        }
        public List<FriendListItem> GetUserFriendList(LLUUID friendlistowner)
        {
            List<FriendListItem> Lfli = new List<FriendListItem>();
@@ -315,12 +309,11 @@ namespace OpenSim.Framework.Data.MySQL
                    //Left Join userfriends to itself
                    IDbCommand result =
                        database.Query(
-                        "select a.ownerID,a.friendID,a.friendPerms,b.friendPerms as ownerperms from " + m_userFriendsTableName + " as a, " + m_userFriendsTableName + " as b" +
+                            "select a.ownerID,a.friendID,a.friendPerms,b.friendPerms as ownerperms from " + m_userFriendsTableName + " as a, " + m_userFriendsTableName + " as b" +
-                        " where a.ownerID = ?ownerID and b.ownerID = a.friendID and b.friendID = a.ownerID",
+                            " where a.ownerID = ?ownerID and b.ownerID = a.friendID and b.friendID = a.ownerID",
                            param);
                    IDataReader reader = result.ExecuteReader();
                    while (reader.Read())
                    {
                        FriendListItem fli = new FriendListItem();
@@ -354,7 +347,6 @@ namespace OpenSim.Framework.Data.MySQL
            m_log.Info("[USER]: Stub UpdateUserCUrrentRegion called");
        }
        public List<Framework.AvatarPickerAvatar> GeneratePickerResults(LLUUID queryID, string query)
        {
            List<Framework.AvatarPickerAvatar> returnlist = new List<Framework.AvatarPickerAvatar>();
@@ -378,7 +370,6 @@ namespace OpenSim.Framework.Data.MySQL
                                param);
                        IDataReader reader = result.ExecuteReader();
                        while (reader.Read())
                        {
                            Framework.AvatarPickerAvatar user = new Framework.AvatarPickerAvatar();
@@ -413,7 +404,6 @@ namespace OpenSim.Framework.Data.MySQL
                                param);
                        IDataReader reader = result.ExecuteReader();
                        while (reader.Read())
                        {
                            Framework.AvatarPickerAvatar user = new Framework.AvatarPickerAvatar();
@@ -489,7 +479,6 @@ namespace OpenSim.Framework.Data.MySQL
        public void StoreWebLoginKey(LLUUID AgentID, LLUUID WebLoginKey)
        {
-            
            Dictionary<string, string> param = new Dictionary<string, string>();
            param["?UUID"] = AgentID.UUID.ToString();
            param["?webLoginKey"] = WebLoginKey.UUID.ToString();
@@ -500,11 +489,10 @@ namespace OpenSim.Framework.Data.MySQL
                {
                    IDbCommand updater =
                        database.Query(
-                        "update " + m_usersTableName + " SET webLoginKey = ?webLoginKey " +
+                            "update " + m_usersTableName + " SET webLoginKey = ?webLoginKey " +
-                        "where UUID = ?UUID",
+                            "where UUID = ?UUID",
                            param);
                    updater.ExecuteNonQuery();
                }
            }
            catch (Exception e)
@@ -513,10 +501,6 @@ namespace OpenSim.Framework.Data.MySQL
                m_log.Error(e.ToString());
                return;
            }
-                
-            
        }
        /// <summary>
@@ -605,11 +589,11 @@ namespace OpenSim.Framework.Data.MySQL
        /// <param name="user">The profile data to use to update the DB</param>
        public bool UpdateUserProfile(UserProfileData user)
        {
-            database.updateUserRow(user.UUID, user.username, user.surname, user.passwordHash, user.passwordSalt
+            database.updateUserRow(user.UUID, user.username, user.surname, user.passwordHash, user.passwordSalt,
-            , user.homeRegion, user.homeLocation.X, user.homeLocation.Y, user.homeLocation.Z, user.homeLookAt.X
+                                   user.homeRegion, user.homeLocation.X, user.homeLocation.Y, user.homeLocation.Z, user.homeLookAt.X,
-            , user.homeLookAt.Y, user.homeLookAt.Z, user.created, user.lastLogin, user.userInventoryURI
+                                   user.homeLookAt.Y, user.homeLookAt.Z, user.created, user.lastLogin, user.userInventoryURI,
-            , user.userAssetURI, user.profileCanDoMask, user.profileWantDoMask, user.profileAboutText
+                                   user.userAssetURI, user.profileCanDoMask, user.profileWantDoMask, user.profileAboutText,
-            , user.profileFirstText, user.profileImage, user.profileFirstImage, user.webLoginKey);
+                                   user.profileFirstText, user.profileImage, user.profileFirstImage, user.webLoginKey);
            return true;
        }