1 files changed, 33 insertions, 2 deletions

diff --git a/OpenSim/Data/MySQL/MySQLGenericTableHandler.cs b/OpenSim/Data/MySQL/MySQLGenericTableHandler.cs
index 2f5937d..4dfc324 100644
--- a/OpenSim/Data/MySQL/MySQLGenericTableHandler.cs
+++ b/OpenSim/Data/MySQL/MySQLGenericTableHandler.cs
@@ -37,7 +37,7 @@ using OpenSim.Region.Framework.Interfaces;
 
 namespace OpenSim.Data.MySQL
 {
-    public class MySQLGenericTableHandler<T> : MySqlFramework where T: struct
+    public class MySQLGenericTableHandler<T> : MySqlFramework where T: class, new()
     {
         private static readonly ILog m_log =
             LogManager.GetLogger(MethodBase.GetCurrentMethod().DeclaringType);
@@ -63,7 +63,7 @@ namespace OpenSim.Data.MySQL
             }
 
             Type t = typeof(T);
-            FieldInfo[] fields = t.GetFields(BindingFlags.NonPublic |
+            FieldInfo[] fields = t.GetFields(BindingFlags.Public |
                                              BindingFlags.Instance |
                                              BindingFlags.DeclaredOnly);
 
@@ -165,7 +165,11 @@ namespace OpenSim.Data.MySQL
                             new Dictionary<string, string>();
 
                     foreach (string col in m_ColumnNames)
+                    {
                         data[col] = reader[col].ToString();
+                        if (data[col] == null)
+                            data[col] = String.Empty;
+                    }
 
                     m_DataField.SetValue(row, data);
                 }
@@ -195,6 +199,33 @@ namespace OpenSim.Data.MySQL
             MySqlCommand cmd = new MySqlCommand();
 
             string query = "";
+            List<String> names = new List<String>();
+            List<String> values = new List<String>();
+
+            foreach (FieldInfo fi in m_Fields.Values)
+            {
+                names.Add(fi.Name);
+                values.Add(fi.GetValue(row).ToString());
+            }
+
+            if (m_DataField != null)
+            {
+                Dictionary<string, string> data =
+                        (Dictionary<string, string>)m_DataField.GetValue(row);
+
+                foreach (KeyValuePair<string, string> kvp in data)
+                {
+                    names.Add(kvp.Key);
+                    values.Add(kvp.Value);
+                }
+            }
+
+            query = String.Format("replace into {0} (`", m_Realm) + String.Join("`,`", names.ToArray()) + "`) values ('" + String.Join("','", values.ToArray()) + "')";
+
+            cmd.CommandText = query;
+
+            if (ExecuteNonQuery(cmd) > 0)
+                return true;
 
             return false;
         }