1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859 |
- using System;
- using System.Collections;
- using System.Collections.Generic;
- using System.Reflection;
- using OpenSim.Framework;
- using OpenSim.Data.MySQL;
- using OpenMetaverse;
- using MySql.Data.MySqlClient;
- namespace OpenSim.Data.MySQL
- {
- public class MySQLOfflineIMData : MySQLGenericTableHandler<OfflineIMData>, IOfflineIMData
- {
- public MySQLOfflineIMData(string connectionString, string realm)
- : base(connectionString, realm, "IM_Store")
- {
- }
- public void DeleteOld()
- {
- using (MySqlCommand cmd = new MySqlCommand())
- {
- cmd.CommandText = String.Format("delete from {0} where TMStamp < NOW() - INTERVAL 2 WEEK", m_Realm);
-
- ExecuteNonQuery(cmd);
- }
- }
- }
- }
|