diff options
Diffstat (limited to 'OpenSim/Data/MySQL/MySQLHGTravelData.cs')
-rw-r--r-- | OpenSim/Data/MySQL/MySQLHGTravelData.cs | 10 |
1 files changed, 10 insertions, 0 deletions
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 | |||
66 | return Delete("SessionID", sessionID.ToString()); | 66 | return Delete("SessionID", sessionID.ToString()); |
67 | } | 67 | } |
68 | 68 | ||
69 | public void DeleteOld() | ||
70 | { | ||
71 | using (MySqlCommand cmd = new MySqlCommand()) | ||
72 | { | ||
73 | cmd.CommandText = String.Format("delete from {0} where TMStamp < NOW() - INTERVAL 2 DAY", m_Realm); | ||
74 | |||
75 | ExecuteNonQuery(cmd); | ||
76 | } | ||
77 | |||
78 | } | ||
69 | } | 79 | } |
70 | } \ No newline at end of file | 80 | } \ No newline at end of file |