diff options
author | onefang | 2019-08-07 22:12:46 +1000 |
---|---|---|
committer | onefang | 2019-08-07 22:12:46 +1000 |
commit | afddecb2830f6afa73f869e120002d12803b3266 (patch) | |
tree | 3c3e1a11089fe9ef581a824dc9cc30907ae2a949 /OpenSim/Data/MySQL | |
parent | Testing MySQLRaw's SELECT. (diff) | |
download | opensim-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/MySQL')
-rw-r--r-- | OpenSim/Data/MySQL/MySQLRaw.cs | 8 |
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 | { |