diff options
| author | UbitUmarov | 2019-10-13 18:52:33 +0100 |
|---|---|---|
| committer | UbitUmarov | 2019-10-13 18:52:33 +0100 |
| commit | 5bbaea50e46bda3524f5df929d974883a06dbeaa (patch) | |
| tree | ba4d8b3c3252aade2473d59a123aa750fc8f1425 /OpenSim/Data/PGSQL | |
| parent | mantis 8598: filter dead groups from group search. honor querystart request. ... (diff) | |
| download | opensim-SC-5bbaea50e46bda3524f5df929d974883a06dbeaa.zip opensim-SC-5bbaea50e46bda3524f5df929d974883a06dbeaa.tar.gz opensim-SC-5bbaea50e46bda3524f5df929d974883a06dbeaa.tar.bz2 opensim-SC-5bbaea50e46bda3524f5df929d974883a06dbeaa.tar.xz | |
groups v2: remove wrong filters on DB search
Diffstat (limited to '')
| -rwxr-xr-x | OpenSim/Data/PGSQL/PGSQLGroupsData.cs | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/OpenSim/Data/PGSQL/PGSQLGroupsData.cs b/OpenSim/Data/PGSQL/PGSQLGroupsData.cs index f398256..04e2f69 100755 --- a/OpenSim/Data/PGSQL/PGSQLGroupsData.cs +++ b/OpenSim/Data/PGSQL/PGSQLGroupsData.cs | |||
| @@ -86,13 +86,13 @@ namespace OpenSim.Data.PGSQL | |||
| 86 | 86 | ||
| 87 | if (string.IsNullOrEmpty(pattern)) // True for where clause | 87 | if (string.IsNullOrEmpty(pattern)) // True for where clause |
| 88 | { | 88 | { |
| 89 | pattern = " 1 ORDER BY lower(\"Name\") LIMIT 100"; | 89 | pattern = "1"; |
| 90 | 90 | ||
| 91 | return m_Groups.Get(pattern); | 91 | return m_Groups.Get(pattern); |
| 92 | } | 92 | } |
| 93 | else | 93 | else |
| 94 | { | 94 | { |
| 95 | pattern = " \"ShowInList\" = 1 AND lower(\"Name\") LIKE lower('%" + pattern + "%') ORDER BY lower(\"Name\") LIMIT 100"; | 95 | pattern = " \"ShowInList\" = 1 AND lower(\"Name\") LIKE lower('%" + pattern + "%')"; |
| 96 | 96 | ||
| 97 | return m_Groups.Get(pattern, new NpgsqlParameter("pattern", pattern)); | 97 | return m_Groups.Get(pattern, new NpgsqlParameter("pattern", pattern)); |
| 98 | } | 98 | } |