X-Git-Url: https://git.pterodactylus.net/?a=blobdiff_plain;f=src%2Ffreenet%2Ftrustlistinserter.cpp;h=6cd8843349023dc959bff8153d1c05f3e73b336c;hb=964f55fd550fc711c0320ce6a24ad713040695d0;hp=ca689eef53a4ed68d90fc72e779f90a1a69e3a79;hpb=8adfd604a97d385869b0ce763b35d014d7aa2cca;p=fms.git

diff --git a/src/freenet/trustlistinserter.cpp b/src/freenet/trustlistinserter.cpp
index ca689ee..6cd8843 100644
--- a/src/freenet/trustlistinserter.cpp
+++ b/src/freenet/trustlistinserter.cpp
@@ -126,15 +126,18 @@ void TrustListInserter::StartInsert(const long localidentityid, const std::strin
 	std::string publickey;
 	int messagetrust;
 	int trustlisttrust;
-	DateTime now;
+	DateTime now,date;
 	int index;
 	std::string indexstr;
 	std::string localidentityidstr;
 
 	now.SetToGMTime();
-	
-	// build the xml file
-	SQLite3DB::Statement st=m_db->Prepare("SELECT PublicKey, LocalMessageTrust, LocalTrustListTrust FROM tblIdentity WHERE PublicKey IS NOT NULL AND PublicKey<>'';");
+	date.SetToGMTime();
+
+	// build the xml file - we only want to add identities that we recently saw, otherwise we could be inserting a ton of identities
+	date.Add(0,0,0,-20);	// identities seen in last 20 days
+	SQLite3DB::Statement st=m_db->Prepare("SELECT PublicKey, LocalMessageTrust, LocalTrustListTrust FROM tblIdentity WHERE PublicKey IS NOT NULL AND PublicKey<>'' AND LastSeen>=?;");
+	st.Bind(0,date.Format("%Y-%m-%d"));
 	st.Step();
 	while(st.RowReturned())
 	{
@@ -174,4 +177,4 @@ void TrustListInserter::StartInsert(const long localidentityid, const std::strin
 
 	m_db->Execute("UPDATE tblLocalIdentity SET InsertingTrustList='true' WHERE LocalIdentityID="+localidentityidstr+";");
 
-}
\ No newline at end of file
+}