diff options
Diffstat (limited to 'OpenGridServices/OpenGrid.Framework.Data.MySQL/MySQLManager.cs')
-rw-r--r-- | OpenGridServices/OpenGrid.Framework.Data.MySQL/MySQLManager.cs | 32 |
1 files changed, 29 insertions, 3 deletions
diff --git a/OpenGridServices/OpenGrid.Framework.Data.MySQL/MySQLManager.cs b/OpenGridServices/OpenGrid.Framework.Data.MySQL/MySQLManager.cs index 2eaa158..ef2e02e 100644 --- a/OpenGridServices/OpenGrid.Framework.Data.MySQL/MySQLManager.cs +++ b/OpenGridServices/OpenGrid.Framework.Data.MySQL/MySQLManager.cs | |||
@@ -137,7 +137,7 @@ namespace OpenGrid.Framework.Data.MySQL | |||
137 | } | 137 | } |
138 | } | 138 | } |
139 | 139 | ||
140 | public SimProfileData getSimRow(IDataReader reader) | 140 | public SimProfileData readSimRow(IDataReader reader) |
141 | { | 141 | { |
142 | SimProfileData retval = new SimProfileData(); | 142 | SimProfileData retval = new SimProfileData(); |
143 | 143 | ||
@@ -199,7 +199,7 @@ namespace OpenGrid.Framework.Data.MySQL | |||
199 | return retval; | 199 | return retval; |
200 | } | 200 | } |
201 | 201 | ||
202 | public UserAgentData getAgentRow(IDataReader reader) | 202 | public UserAgentData readAgentRow(IDataReader reader) |
203 | { | 203 | { |
204 | UserAgentData retval = new UserAgentData(); | 204 | UserAgentData retval = new UserAgentData(); |
205 | 205 | ||
@@ -231,7 +231,7 @@ namespace OpenGrid.Framework.Data.MySQL | |||
231 | return retval; | 231 | return retval; |
232 | } | 232 | } |
233 | 233 | ||
234 | public UserProfileData getUserRow(IDataReader reader) | 234 | public UserProfileData readUserRow(IDataReader reader) |
235 | { | 235 | { |
236 | UserProfileData retval = new UserProfileData(); | 236 | UserProfileData retval = new UserProfileData(); |
237 | 237 | ||
@@ -277,6 +277,32 @@ namespace OpenGrid.Framework.Data.MySQL | |||
277 | return retval; | 277 | return retval; |
278 | } | 278 | } |
279 | 279 | ||
280 | public List<InventoryFolderBase> readInventoryInFolder(IDataReader reader) | ||
281 | { | ||
282 | List<InventoryFolderBase> rows = new List<InventoryFolderBase>(); | ||
283 | |||
284 | while(reader.Read()) | ||
285 | { | ||
286 | try | ||
287 | { | ||
288 | InventoryFolderBase retval = new InventoryFolderBase(); | ||
289 | |||
290 | retval.agentID = new libsecondlife.LLUUID((string)reader["agentID"]); | ||
291 | retval.parentID = new libsecondlife.LLUUID((string)reader["parentFolderID"]); | ||
292 | retval.folderID = new libsecondlife.LLUUID((string)reader["folderID"]); | ||
293 | retval.name = (string)reader["folderName"]; | ||
294 | |||
295 | rows.Add(retval); | ||
296 | } | ||
297 | catch (Exception e) | ||
298 | { | ||
299 | Console.WriteLine(e.ToString()); | ||
300 | } | ||
301 | } | ||
302 | |||
303 | return rows; | ||
304 | } | ||
305 | |||
280 | public bool insertLogRow(string serverDaemon, string target, string methodCall, string arguments, int priority, string logMessage) | 306 | public bool insertLogRow(string serverDaemon, string target, string methodCall, string arguments, int priority, string logMessage) |
281 | { | 307 | { |
282 | string sql = "INSERT INTO logs (`target`, `server`, `method`, `arguments`, `priority`, `message`) VALUES "; | 308 | string sql = "INSERT INTO logs (`target`, `server`, `method`, `arguments`, `priority`, `message`) VALUES "; |