X-Git-Url: https://git.pterodactylus.net/?a=blobdiff_plain;f=src%2Fdbmaintenancethread.cpp;h=bfee4fb4dbc1c6210ff3b33872f895347ce4eaa4;hb=4855de56590e2f27d39036922339992c96bce9d1;hp=0309414215886de440d32fdb0902e658848a5467;hpb=dec33c63afafabf83c3039e916725cac6faef9b3;p=fms.git

diff --git a/src/dbmaintenancethread.cpp b/src/dbmaintenancethread.cpp
index 0309414..bfee4fb 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);
@@ -95,6 +96,9 @@ void DBMaintenanceThread::Do1HourMaintenance()
 		st.Step();
 	}
 
+	// insert all identities not in trust list already
+	m_db->Execute("INSERT INTO tblIdentityTrust(LocalIdentityID,IdentityID) SELECT LocalIdentityID,IdentityID FROM tblLocalIdentity,tblIdentity WHERE LocalIdentityID || '_' || IdentityID NOT IN (SELECT LocalIdentityID || '_' || IdentityID FROM tblIdentityTrust);");
+
 	m_log->debug("PeriodicDBMaintenance::Do1HourMaintenance");
 }
 
@@ -249,6 +253,7 @@ 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();