diff options
| author | Diva Canto | 2013-07-14 15:47:54 -0700 |
|---|---|---|
| committer | Diva Canto | 2013-07-14 15:47:54 -0700 |
| commit | b0140383da21de03cb655160a2912d04c5b470e6 (patch) | |
| tree | 091f9a16f9f8da857820938e093c20ac7aafad97 /OpenSim/Data/MySQL/MySQLHGTravelData.cs | |
| parent | HG UAS: Moved hg-session data from memory to DB storage. This makes it so tha... (diff) | |
| download | opensim-SC_OLD-b0140383da21de03cb655160a2912d04c5b470e6.zip opensim-SC_OLD-b0140383da21de03cb655160a2912d04c5b470e6.tar.gz opensim-SC_OLD-b0140383da21de03cb655160a2912d04c5b470e6.tar.bz2 opensim-SC_OLD-b0140383da21de03cb655160a2912d04c5b470e6.tar.xz | |
Cleanup old hg sessions (older than 2 days)
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 |