From afddecb2830f6afa73f869e120002d12803b3266 Mon Sep 17 00:00:00 2001
From: onefang
Date: Wed, 7 Aug 2019 22:12:46 +1000
Subject: More account manager.

Select with more parameters.

Tables, with member accounts.

Print the query values.
---
 OpenSim/Data/MySQL/MySQLRaw.cs | 8 ++++++--
 1 file changed, 6 insertions(+), 2 deletions(-)

(limited to 'OpenSim/Data/MySQL/MySQLRaw.cs')

diff --git a/OpenSim/Data/MySQL/MySQLRaw.cs b/OpenSim/Data/MySQL/MySQLRaw.cs
index 4be6d90..e8f80aa 100644
--- a/OpenSim/Data/MySQL/MySQLRaw.cs
+++ b/OpenSim/Data/MySQL/MySQLRaw.cs
@@ -40,11 +40,15 @@ namespace OpenSim.Data.MySQL
 	    return result;
 	}
 
-	public List< Hashtable > Select(string table, string wher)
+	public List< Hashtable > Select(string table, string select, string wher, string order)
 	{
-	    string query = "SELECT * FROM " + table;
+	    if ("" == select)
+		select = "*";
+	    string query = "SELECT " + select + " FROM " + table;
 	    if ("" != wher)
 		query = query + " WHERE " + wher;
+	    if ("" != order)
+		query = query + " ORDER BY " + order;
 
             using (MySqlConnection dbcon = new MySqlConnection(m_connectString))
             {
-- 
cgit v1.1