diff options
| author | UbitUmarov | 2015-09-03 18:39:08 +0100 |
|---|---|---|
| committer | UbitUmarov | 2015-09-03 18:39:08 +0100 |
| commit | cdaed113872f0615a0d2864cc54064a4432054c6 (patch) | |
| tree | 246e62dfeffac632cdcd9738a77faebd30b3bd6c /OpenSim/Data/MySQL/MySQLUserAccountData.cs | |
| parent | seems to compile ( tests comented out) (diff) | |
| download | opensim-SC-cdaed113872f0615a0d2864cc54064a4432054c6.zip opensim-SC-cdaed113872f0615a0d2864cc54064a4432054c6.tar.gz opensim-SC-cdaed113872f0615a0d2864cc54064a4432054c6.tar.bz2 opensim-SC-cdaed113872f0615a0d2864cc54064a4432054c6.tar.xz | |
at last we can login and see objects ( friends is dead and disable in
scenepresence)
Diffstat (limited to '')
| -rw-r--r-- | OpenSim/Data/MySQL/MySQLUserAccountData.cs | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/OpenSim/Data/MySQL/MySQLUserAccountData.cs b/OpenSim/Data/MySQL/MySQLUserAccountData.cs index 4ff3175..59cfe70 100644 --- a/OpenSim/Data/MySQL/MySQLUserAccountData.cs +++ b/OpenSim/Data/MySQL/MySQLUserAccountData.cs | |||
| @@ -71,14 +71,14 @@ namespace OpenSim.Data.MySQL | |||
| 71 | if (words.Length == 1) | 71 | if (words.Length == 1) |
| 72 | { | 72 | { |
| 73 | cmd.CommandText = String.Format("select * from {0} where (ScopeID=?ScopeID or ScopeID='00000000-0000-0000-0000-000000000000') and (FirstName like ?search or LastName like ?search) and active=1", m_Realm); | 73 | cmd.CommandText = String.Format("select * from {0} where (ScopeID=?ScopeID or ScopeID='00000000-0000-0000-0000-000000000000') and (FirstName like ?search or LastName like ?search) and active=1", m_Realm); |
| 74 | cmd.Parameters.AddWithValue("?search", words[0] + "%"); | 74 | cmd.Parameters.AddWithValue("?search", "%" + words[0] + "%"); |
| 75 | cmd.Parameters.AddWithValue("?ScopeID", scopeID.ToString()); | 75 | cmd.Parameters.AddWithValue("?ScopeID", scopeID.ToString()); |
| 76 | } | 76 | } |
| 77 | else | 77 | else |
| 78 | { | 78 | { |
| 79 | 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) and active=1", m_Realm); | 79 | 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) and active=1", m_Realm); |
| 80 | cmd.Parameters.AddWithValue("?searchFirst", words[0] + "%"); | 80 | cmd.Parameters.AddWithValue("?searchFirst", "%" + words[0] + "%"); |
| 81 | cmd.Parameters.AddWithValue("?searchLast", words[1] + "%"); | 81 | cmd.Parameters.AddWithValue("?searchLast", "%" + words[1] + "%"); |
| 82 | cmd.Parameters.AddWithValue("?ScopeID", scopeID.ToString()); | 82 | cmd.Parameters.AddWithValue("?ScopeID", scopeID.ToString()); |
| 83 | } | 83 | } |
| 84 | 84 | ||