X-Git-Url: https://git.pterodactylus.net/?a=blobdiff_plain;f=src%2Ffreenet%2Ftrustlistrequester.cpp;h=77b03b19c0bc7274d21361c36a74ed20ec6b397e;hb=4430e7762844c66428b6f822288beb71b7f82b95;hp=4eeaf7948d9626b9d8372508002a5e730e8a13be;hpb=f208e33c29132aacaec448e74341edea1b925a2a;p=fms.git

diff --git a/src/freenet/trustlistrequester.cpp b/src/freenet/trustlistrequester.cpp
index 4eeaf79..77b03b1 100644
--- a/src/freenet/trustlistrequester.cpp
+++ b/src/freenet/trustlistrequester.cpp
@@ -96,8 +96,22 @@ const bool TrustListRequester::HandleAllData(FCPMessage &message)
 			//insert trust for this identity
 			trustst.Bind(0,identityid);
 			trustst.Bind(1,id);
-			trustst.Bind(2,xml.GetMessageTrust(i));
-			trustst.Bind(3,xml.GetTrustListTrust(i));
+			if(xml.GetMessageTrust(i)==-1)
+			{
+				trustst.Bind(2);
+			}
+			else
+			{
+				trustst.Bind(2,xml.GetMessageTrust(i));
+			}
+			if(xml.GetTrustListTrust(i)==-1)
+			{
+				trustst.Bind(3);
+			}
+			else
+			{
+				trustst.Bind(3,xml.GetTrustListTrust(i));
+			}
 			trustst.Step();
 			trustst.Reset();
 
@@ -231,7 +245,7 @@ void TrustListRequester::PopulateIDList()
 	// select identities we want to query (we've seen them today and they are publishing trust list) - sort by their trust level (descending) with secondary sort on how long ago we saw them (ascending)
 	sql="SELECT IdentityID FROM tblIdentity ";
 	sql+="WHERE Name IS NOT NULL AND Name <> '' AND PublicKey IS NOT NULL AND PublicKey <> '' AND LastSeen>='"+date.Format("%Y-%m-%d")+"' AND PublishTrustList='true' AND LocalTrustListTrust>=(SELECT OptionValue FROM tblOption WHERE Option='MinLocalTrustListTrust') AND ( PeerTrustListTrust IS NULL OR PeerTrustListTrust>=(SELECT OptionValue FROM tblOption WHERE Option='MinPeerTrustListTrust') )";
-	sql+="ORDER BY LocalMessageTrust+LocalTrustListTrust DESC, LastSeen;";
+	sql+="ORDER BY LocalTrustListTrust DESC, LastSeen;";
 
 	SQLite3DB::Statement st=m_db->Prepare(sql);
 	st.Step();