From b0140383da21de03cb655160a2912d04c5b470e6 Mon Sep 17 00:00:00 2001
From: Diva Canto
Date: Sun, 14 Jul 2013 15:47:54 -0700
Subject: Cleanup old hg sessions (older than 2 days)

---
 OpenSim/Data/MySQL/MySQLHGTravelData.cs | 10 ++++++++++
 1 file changed, 10 insertions(+)

(limited to 'OpenSim/Data/MySQL/MySQLHGTravelData.cs')

diff --git a/OpenSim/Data/MySQL/MySQLHGTravelData.cs b/OpenSim/Data/MySQL/MySQLHGTravelData.cs
index 1efbfc3..e81b880 100644
--- a/OpenSim/Data/MySQL/MySQLHGTravelData.cs
+++ b/OpenSim/Data/MySQL/MySQLHGTravelData.cs
@@ -66,5 +66,15 @@ namespace OpenSim.Data.MySQL
             return Delete("SessionID", sessionID.ToString());
         }
 
+        public void DeleteOld()
+        {
+            using (MySqlCommand cmd = new MySqlCommand())
+            {
+                cmd.CommandText = String.Format("delete from {0} where TMStamp < NOW() - INTERVAL 2 DAY", m_Realm);
+
+                ExecuteNonQuery(cmd);
+            }
+
+        }
     }
 }
\ No newline at end of file
-- 
cgit v1.1