diff options
| author | Melanie | 2011-03-12 13:06:13 +0100 |
|---|---|---|
| committer | Melanie | 2011-03-12 13:06:13 +0100 |
| commit | 4a5560a86eb4c3afa07820f9bdfbfb9708439900 (patch) | |
| tree | 0d9381e434ccd51fd5d7633c641f4b762145e363 /OpenSim/Data/MySQL | |
| parent | Merge branch 'master' into careminster-presence-refactor (diff) | |
| download | opensim-SC_OLD-4a5560a86eb4c3afa07820f9bdfbfb9708439900.zip opensim-SC_OLD-4a5560a86eb4c3afa07820f9bdfbfb9708439900.tar.gz opensim-SC_OLD-4a5560a86eb4c3afa07820f9bdfbfb9708439900.tar.bz2 opensim-SC_OLD-4a5560a86eb4c3afa07820f9bdfbfb9708439900.tar.xz | |
Change avatar picker search to work properly when two name parts are used
Diffstat (limited to 'OpenSim/Data/MySQL')
| -rw-r--r-- | OpenSim/Data/MySQL/MySQLUserAccountData.cs | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/OpenSim/Data/MySQL/MySQLUserAccountData.cs b/OpenSim/Data/MySQL/MySQLUserAccountData.cs index 3b35222..92afa75 100644 --- a/OpenSim/Data/MySQL/MySQLUserAccountData.cs +++ b/OpenSim/Data/MySQL/MySQLUserAccountData.cs | |||
| @@ -72,7 +72,7 @@ namespace OpenSim.Data.MySQL | |||
| 72 | } | 72 | } |
| 73 | else | 73 | else |
| 74 | { | 74 | { |
| 75 | cmd.CommandText = String.Format("select * from {0} where (ScopeID=?ScopeID or ScopeID='00000000-0000-0000-0000-000000000000') and (FirstName like ?searchFirst or LastName like ?searchLast)", m_Realm); | 75 | cmd.CommandText = String.Format("select * from {0} where (ScopeID=?ScopeID or ScopeID='00000000-0000-0000-0000-000000000000') and (FirstName like ?searchFirst and LastName like ?searchLast)", m_Realm); |
| 76 | cmd.Parameters.AddWithValue("?searchFirst", "%" + words[0] + "%"); | 76 | cmd.Parameters.AddWithValue("?searchFirst", "%" + words[0] + "%"); |
| 77 | cmd.Parameters.AddWithValue("?searchLast", "%" + words[1] + "%"); | 77 | cmd.Parameters.AddWithValue("?searchLast", "%" + words[1] + "%"); |
| 78 | cmd.Parameters.AddWithValue("?ScopeID", scopeID.ToString()); | 78 | cmd.Parameters.AddWithValue("?ScopeID", scopeID.ToString()); |