diff options
-rw-r--r-- | OpenSim/Data/MySQL/MySQLGroupsData.cs | 3 |
1 files changed, 1 insertions, 2 deletions
diff --git a/OpenSim/Data/MySQL/MySQLGroupsData.cs b/OpenSim/Data/MySQL/MySQLGroupsData.cs index afa499e..5734d19 100644 --- a/OpenSim/Data/MySQL/MySQLGroupsData.cs +++ b/OpenSim/Data/MySQL/MySQLGroupsData.cs | |||
@@ -431,8 +431,7 @@ namespace OpenSim.Data.MySQL | |||
431 | 431 | ||
432 | using (MySqlCommand cmd = new MySqlCommand()) | 432 | using (MySqlCommand cmd = new MySqlCommand()) |
433 | { | 433 | { |
434 | cmd.CommandText = String.Format("delete from {0} where TMStamp < ?tstamp", m_Realm); | 434 | cmd.CommandText = String.Format("delete from {0} where TMStamp < NOW() - INTERVAL 2 WEEK", m_Realm); |
435 | cmd.Parameters.AddWithValue("?tstamp", now - 14 * 24 * 60 * 60); // > 2 weeks old | ||
436 | 435 | ||
437 | ExecuteNonQuery(cmd); | 436 | ExecuteNonQuery(cmd); |
438 | } | 437 | } |