diff options
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 | { |