From 3af29bcb4e0bbc50d690f470ca71bfd68fc4d613 Mon Sep 17 00:00:00 2001
From: Roger Kirkman <zadarkportal@gmail.com>
Date: Sat, 26 Oct 2019 18:06:04 +0100
Subject: [PATCH] SQLite missing GetUsersWhere functionality

---
 OpenSim/Data/SQLite/SQLiteUserAccountData.cs | 13 ++++++++++++-
 1 file changed, 12 insertions(+), 1 deletion(-)

diff --git a/OpenSim/Data/SQLite/SQLiteUserAccountData.cs b/OpenSim/Data/SQLite/SQLiteUserAccountData.cs
index 1b79185953..bc695b80e7 100644
--- a/OpenSim/Data/SQLite/SQLiteUserAccountData.cs
+++ b/OpenSim/Data/SQLite/SQLiteUserAccountData.cs
@@ -85,7 +85,18 @@ namespace OpenSim.Data.SQLite
 
         public UserAccountData[] GetUsersWhere(UUID scopeID, string where)
         {
-            return null;
+            using (SqliteCommand cmd = new SqliteCommand())
+            {
+                if (scopeID != UUID.Zero)
+                {
+                    where = "(ScopeID=?ScopeID or ScopeID='00000000-0000-0000-0000-000000000000') and (" + where + ")";
+                    cmd.Parameters.AddWithValue("?ScopeID", scopeID.ToString());
+                }
+
+                cmd.CommandText = String.Format("select * from {0} where " + where, m_Realm);
+
+                return DoQuery(cmd);
+            }
         }
     }
 }
-- 
2.12.0.windows.1