aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/PGSQL/PGSQLGroupsData.cs
diff options
context:
space:
mode:
Diffstat (limited to 'OpenSim/Data/PGSQL/PGSQLGroupsData.cs')
-rw-r--r--OpenSim/Data/PGSQL/PGSQLGroupsData.cs10
1 files changed, 7 insertions, 3 deletions
diff --git a/OpenSim/Data/PGSQL/PGSQLGroupsData.cs b/OpenSim/Data/PGSQL/PGSQLGroupsData.cs
index ed75b63..669e3c8 100644
--- a/OpenSim/Data/PGSQL/PGSQLGroupsData.cs
+++ b/OpenSim/Data/PGSQL/PGSQLGroupsData.cs
@@ -83,11 +83,15 @@ namespace OpenSim.Data.PGSQL
83 public GroupData[] RetrieveGroups(string pattern) 83 public GroupData[] RetrieveGroups(string pattern)
84 { 84 {
85 if (string.IsNullOrEmpty(pattern)) // True for where clause 85 if (string.IsNullOrEmpty(pattern)) // True for where clause
86 {
86 pattern = " true ORDER BY lower(\"Name\") LIMIT 100"; 87 pattern = " true ORDER BY lower(\"Name\") LIMIT 100";
88 return m_Groups.Get(pattern);
89 }
87 else 90 else
88 pattern = string.Format(" lower(\"Name\") LIKE lower('%{0}%') ORDER BY lower(\"Name\") LIMIT 100", pattern); 91 {
89 92 pattern = " lower(\"Name\") LIKE lower('%:pattern%') ORDER BY lower(\"Name\") LIMIT 100";
90 return m_Groups.Get(pattern); 93 return m_Groups.Get(pattern, new NpgsqlParameter("pattern", pattern));
94 }
91 } 95 }
92 96
93 public bool DeleteGroup(UUID groupID) 97 public bool DeleteGroup(UUID groupID)