1 files changed, 30 insertions, 19 deletions

diff --git a/OpenSim/Region/Application/HGCommands.cs b/OpenSim/Data/MSSQL/MSSQLAvatarData.cs
index 7ae161d..4992183 100644
--- a/OpenSim/Region/Application/HGCommands.cs
+++ b/OpenSim/Data/MSSQL/MSSQLAvatarData.cs
@@ -27,34 +27,45 @@
 
 using System;
 using System.Collections.Generic;
+using System.Data;
 using System.Reflection;
-using System.Xml;
+using System.Threading;
 using log4net;
-using Nini.Config;
+using OpenMetaverse;
 using OpenSim.Framework;
-using OpenSim.Framework.Communications;
-using OpenSim.Framework.Console;
-using OpenSim.Region.Framework;
-using OpenSim.Region.Framework.Scenes;
-using OpenSim.Region.Framework.Scenes.Hypergrid;
+using System.Data.SqlClient;
 
-namespace OpenSim
+namespace OpenSim.Data.MSSQL
 {
-    public class HGCommands
+    /// <summary>
+    /// A MSSQL Interface for Avatar Storage
+    /// </summary>
+    public class MSSQLAvatarData : MSSQLGenericTableHandler<AvatarBaseData>,
+            IAvatarData
     {
-//        private static readonly ILog m_log = LogManager.GetLogger(MethodBase.GetCurrentMethod().DeclaringType);
+        private static readonly ILog m_log = LogManager.GetLogger(MethodBase.GetCurrentMethod().DeclaringType);
+        
+        public MSSQLAvatarData(string connectionString, string realm) :
+                base(connectionString, realm, "Avatar")
+        {            
+        }
 
-        public static Scene CreateScene(RegionInfo regionInfo, AgentCircuitManager circuitManager, CommunicationsManager m_commsManager,
-            StorageManager storageManager, ModuleLoader m_moduleLoader, ConfigSettings m_configSettings, OpenSimConfigSource m_config, string m_version)
+        public bool Delete(UUID principalID, string name)
         {
-            HGSceneCommunicationService sceneGridService = new HGSceneCommunicationService(m_commsManager);
+            using (SqlConnection conn = new SqlConnection(m_ConnectionString))
+            using (SqlCommand cmd = new SqlCommand())
+            {
 
-            return
-                new HGScene(
-                    regionInfo, circuitManager, m_commsManager, sceneGridService, storageManager,
-                    m_moduleLoader, false, m_configSettings.PhysicalPrim,
-                    m_configSettings.See_into_region_from_neighbor, m_config.Source, m_version);
-        }
+                cmd.CommandText = String.Format("DELETE FROM {0} where [PrincipalID] = @PrincipalID and [Name] = @Name", m_Realm);
+                cmd.Parameters.Add(m_database.CreateParameter("@PrincipalID", principalID.ToString()));
+                cmd.Parameters.Add(m_database.CreateParameter("@Name", name));
+                cmd.Connection = conn;
+                conn.Open();
+                if (cmd.ExecuteNonQuery() > 0)
+                    return true;
 
+                return false;
+            }
+        }
     }
 }