diff options
Diffstat (limited to 'OpenSim/Data/MySQL')
-rw-r--r-- | OpenSim/Data/MySQL/MySQLRegionData.cs | 39 |
1 files changed, 0 insertions, 39 deletions
diff --git a/OpenSim/Data/MySQL/MySQLRegionData.cs b/OpenSim/Data/MySQL/MySQLRegionData.cs index 5c86570..903f022 100644 --- a/OpenSim/Data/MySQL/MySQLRegionData.cs +++ b/OpenSim/Data/MySQL/MySQLRegionData.cs | |||
@@ -254,45 +254,6 @@ namespace OpenSim.Data.MySQL | |||
254 | } | 254 | } |
255 | 255 | ||
256 | /// <summary> | 256 | /// <summary> |
257 | /// Given a list of tables, return the version of the tables, as seen in the database | ||
258 | /// </summary> | ||
259 | /// <param name="tableList">The list of table</param> | ||
260 | /// <param name="dbcon">The database connection handler</param> | ||
261 | public void GetTableVersion(Dictionary<string, string> tableList, MySqlConnection dbcon) | ||
262 | { | ||
263 | lock (dbcon) | ||
264 | { | ||
265 | MySqlCommand tablesCmd = | ||
266 | new MySqlCommand( | ||
267 | "SELECT TABLE_NAME, TABLE_COMMENT FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA=?dbname", | ||
268 | dbcon); | ||
269 | tablesCmd.Parameters.AddWithValue("?dbname", dbcon.Database); | ||
270 | |||
271 | CheckConnection(); | ||
272 | using (MySqlDataReader tables = tablesCmd.ExecuteReader()) | ||
273 | { | ||
274 | while (tables.Read()) | ||
275 | { | ||
276 | try | ||
277 | { | ||
278 | string tableName = (string)tables["TABLE_NAME"]; | ||
279 | string comment = (string)tables["TABLE_COMMENT"]; | ||
280 | if (tableList.ContainsKey(tableName)) | ||
281 | { | ||
282 | tableList[tableName] = comment; | ||
283 | } | ||
284 | } | ||
285 | catch (Exception e) | ||
286 | { | ||
287 | m_log.Error(e.ToString()); | ||
288 | } | ||
289 | } | ||
290 | tables.Close(); | ||
291 | } | ||
292 | } | ||
293 | } | ||
294 | |||
295 | /// <summary> | ||
296 | /// Execute a SQL statement stored in a resource, as a string | 257 | /// Execute a SQL statement stored in a resource, as a string |
297 | /// </summary> | 258 | /// </summary> |
298 | /// <param name="name">the ressource name</param> | 259 | /// <param name="name">the ressource name</param> |