1 files changed, 22 insertions, 32 deletions

diff --git a/OpenSim/ApplicationPlugins/Rest/RestXmlWriter.cs b/OpenSim/Data/MySQL/MySQLOfflineIMData.cs
index 283fa2e..252f358 100644
--- a/OpenSim/ApplicationPlugins/Rest/RestXmlWriter.cs
+++ b/OpenSim/Data/MySQL/MySQLOfflineIMData.cs
@@ -25,48 +25,38 @@
  * SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
  */
 
-using System.IO;
-using System.Text;
-using System.Xml;
+using System;
+using System.Collections;
+using System.Collections.Generic;
+using System.Reflection;
 
-namespace OpenSim.ApplicationPlugins.Rest
-{
-    public class RestXmlWriter: XmlTextWriter
-    {
-        private StringWriter m_sw = null;
-
-        public RestXmlWriter(StringWriter sw) : base(sw)
-        {
-            m_sw = sw;
-            Formatting = Formatting.Indented;
-        }
+using OpenSim.Framework;
+using OpenSim.Data.MySQL;
 
-        public RestXmlWriter(TextWriter textWriter) : base(textWriter)
-        {
-        }
+using OpenMetaverse;
+using MySql.Data.MySqlClient;
 
-        public RestXmlWriter(Stream stream)
-            : this(stream, Encoding.UTF8)
+namespace OpenSim.Data.MySQL
+{
+    public class MySQLOfflineIMData : MySQLGenericTableHandler<OfflineIMData>, IOfflineIMData
+    {
+        public MySQLOfflineIMData(string connectionString, string realm)
+            : base(connectionString, realm, "IM_Store")
         {
         }
 
-        public RestXmlWriter(Stream stream, Encoding enc) : base(stream, enc)
+        public void DeleteOld()
         {
-        }
+            uint now = (uint)Util.UnixTimeSinceEpoch();
 
-        public override void WriteStartDocument()
-        {
-        }
+            using (MySqlCommand cmd = new MySqlCommand())
+            {
+                cmd.CommandText = String.Format("delete from {0} where TMStamp < ?tstamp", m_Realm);
+                cmd.Parameters.AddWithValue("?tstamp", now - 14 * 24 * 60 * 60); // > 2 weeks old
 
-        public override void WriteStartDocument(bool standalone)
-        {
-        }
+                ExecuteNonQuery(cmd);
+            }
 
-        public override string ToString()
-        {
-            Flush();
-            Close();
-            return m_sw.ToString();
         }
     }
 }