X-Git-Url: https://git.pterodactylus.net/?a=blobdiff_plain;f=src%2Fdbmaintenancethread.cpp;h=59bc01016c3d2dbed1c412a19459f8bcf82da81e;hb=b88f50bfec6dbcd169bb8285e7c42b93baf52b6b;hp=b6137150e09204be68442bced6d37910b90adbbb;hpb=76805933f794915a72b7f0a21b12af6654759f4f;p=fms.git

diff --git a/src/dbmaintenancethread.cpp b/src/dbmaintenancethread.cpp
index b613715..59bc010 100644
--- a/src/dbmaintenancethread.cpp
+++ b/src/dbmaintenancethread.cpp
@@ -20,6 +20,7 @@ DBMaintenanceThread::DBMaintenanceThread()
 	m_last1day=Poco::Timestamp();
 	m_last1day-=Poco::Timespan(0,23,51,0,0);
 
+	m_deletemessagesolderthan=180;
 	std::string tempval="180";
 	Option::Instance()->Get("DeleteMessagesOlderThan",tempval);
 	StringFunctions::Convert(tempval,m_deletemessagesolderthan);
@@ -252,10 +253,18 @@ void DBMaintenanceThread::Do1DayMaintenance()
 	// delete old messages
 	date=Poco::Timestamp();
 	date-=Poco::Timespan(m_deletemessagesolderthan,0,0,0,0);
+	m_log->trace("PeriodicDBMaintenance::Do1DayMaintenance deleting messages prior to "+Poco::DateTimeFormatter::format(date,"%Y-%m-%d"));
 	st=m_db->Prepare("DELETE FROM tblMessage WHERE MessageDate<?;");
 	st.Bind(0,Poco::DateTimeFormatter::format(date,"%Y-%m-%d"));
 	st.Step();
 
+	// delete old message requests
+	date=Poco::Timestamp();
+	date-=Poco::Timespan(90,0,0,0,0);
+	st=m_db->Prepare("DELETE FROM tblMessageRequests WHERE Day<?;");
+	st.Bind(0,Poco::DateTimeFormatter::format(date,"%Y-%m-%d"));
+	st.Step();
+
 	// delete tblIdentityTrust for local identities and identities that have been deleted
 	m_db->Execute("DELETE FROM tblIdentityTrust WHERE LocalIdentityID NOT IN (SELECT LocalIdentityID FROM tblLocalIdentity);");
 	m_db->Execute("DELETE FROM tblIdentityTrust WHERE IdentityID NOT IN (SELECT IdentityID FROM tblIdentity);");