From 12e0d8b3165cefc252cacdbbaaa76d1c19ed735a Mon Sep 17 00:00:00 2001
From: lbsa71
Date: Wed, 13 Feb 2008 21:35:54 +0000
Subject: * Fixed another bug in avatarpicker ('surname'/'lastname' mixup)
 [Provided by openlifegrid.com]

---
 OpenSim/Framework/Data.MSSQL/MSSQLUserData.cs | 8 ++++----
 1 file changed, 4 insertions(+), 4 deletions(-)

(limited to 'OpenSim')

diff --git a/OpenSim/Framework/Data.MSSQL/MSSQLUserData.cs b/OpenSim/Framework/Data.MSSQL/MSSQLUserData.cs
index ac45aaa..4792487 100644
--- a/OpenSim/Framework/Data.MSSQL/MSSQLUserData.cs
+++ b/OpenSim/Framework/Data.MSSQL/MSSQLUserData.cs
@@ -342,7 +342,7 @@ namespace OpenSim.Framework.Data.MSSQL
 
                         IDbCommand result =
                             database.Query(
-                                "SELECT UUID,username,surname FROM " + m_usersTableName + " WHERE username = @first AND lastname = @second",
+                                "SELECT UUID,username,lastname FROM " + m_usersTableName + " WHERE username = @first AND lastname = @second",
                                 param);
                         IDataReader reader = result.ExecuteReader();
 
@@ -352,7 +352,7 @@ namespace OpenSim.Framework.Data.MSSQL
                             Framework.AvatarPickerAvatar user = new Framework.AvatarPickerAvatar();
                             user.AvatarID = new LLUUID((string)reader["UUID"]);
                             user.firstName = (string)reader["username"];
-                            user.lastName = (string)reader["surname"];
+                            user.lastName = (string)reader["lastname"];
                             returnlist.Add(user);
                         }
                         reader.Close();
@@ -377,7 +377,7 @@ namespace OpenSim.Framework.Data.MSSQL
 
                         IDbCommand result =
                             database.Query(
-                                "SELECT UUID,username,surname FROM " + m_usersTableName + " WHERE username = @first OR lastname = @first",
+                                "SELECT UUID,username,lastname FROM " + m_usersTableName + " WHERE username = @first OR lastname = @first",
                                 param);
                         IDataReader reader = result.ExecuteReader();
 
@@ -387,7 +387,7 @@ namespace OpenSim.Framework.Data.MSSQL
                             Framework.AvatarPickerAvatar user = new Framework.AvatarPickerAvatar();
                             user.AvatarID = new LLUUID((string)reader["UUID"]);
                             user.firstName = (string)reader["username"];
-                            user.lastName = (string)reader["surname"];
+                            user.lastName = (string)reader["lastname"];
                             returnlist.Add(user);
                         }
                         reader.Close();
-- 
cgit v1.1