aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data
diff options
context:
space:
mode:
authoronefang2019-08-07 22:12:46 +1000
committeronefang2019-08-07 22:12:46 +1000
commitafddecb2830f6afa73f869e120002d12803b3266 (patch)
tree3c3e1a11089fe9ef581a824dc9cc30907ae2a949 /OpenSim/Data
parentTesting MySQLRaw's SELECT. (diff)
downloadopensim-SC_OLD-afddecb2830f6afa73f869e120002d12803b3266.zip
opensim-SC_OLD-afddecb2830f6afa73f869e120002d12803b3266.tar.gz
opensim-SC_OLD-afddecb2830f6afa73f869e120002d12803b3266.tar.bz2
opensim-SC_OLD-afddecb2830f6afa73f869e120002d12803b3266.tar.xz
More account manager.
Select with more parameters. Tables, with member accounts. Print the query values.
Diffstat (limited to 'OpenSim/Data')
-rw-r--r--OpenSim/Data/MySQL/MySQLRaw.cs8
1 files changed, 6 insertions, 2 deletions
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
40 return result; 40 return result;
41 } 41 }
42 42
43 public List< Hashtable > Select(string table, string wher) 43 public List< Hashtable > Select(string table, string select, string wher, string order)
44 { 44 {
45 string query = "SELECT * FROM " + table; 45 if ("" == select)
46 select = "*";
47 string query = "SELECT " + select + " FROM " + table;
46 if ("" != wher) 48 if ("" != wher)
47 query = query + " WHERE " + wher; 49 query = query + " WHERE " + wher;
50 if ("" != order)
51 query = query + " ORDER BY " + order;
48 52
49 using (MySqlConnection dbcon = new MySqlConnection(m_connectString)) 53 using (MySqlConnection dbcon = new MySqlConnection(m_connectString))
50 { 54 {