Mantis #2099

Thank you, cmickeyb, for a patch that corrects the database connection
handling in the multithreaded user server.

1 files changed, 13 insertions, 0 deletions

diff --git a/OpenSim/Data/MySQL/MySQLManager.cs b/OpenSim/Data/MySQL/MySQLManager.cs
index 15bdf44..e863216 100644
--- a/OpenSim/Data/MySQL/MySQLManager.cs
+++ b/OpenSim/Data/MySQL/MySQLManager.cs
@@ -280,6 +280,19 @@ namespace OpenSim.Data.MySQL
             cmd.ExecuteNonQuery();
         }
 
+        public void ExecuteParameterizedSql(string sql, Dictionary<string, string> parameters)
+        {
+            CheckConnection();
+
+            MySqlCommand cmd = (MySqlCommand)dbcon.CreateCommand();
+            cmd.CommandText = sql;
+            foreach (KeyValuePair<string, string> param in parameters)
+            {
+                cmd.Parameters.AddWithValue(param.Key, param.Value);
+            }
+            cmd.ExecuteNonQuery();
+        }
+
         /// <summary>
         /// Given a list of tables, return the version of the tables, as seen in the database
         /// </summary>