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