version 0.3.12

[fms.git] / src / freenet / trustlistrequester.cpp

diff --git a/src/freenet/trustlistrequester.cpp b/src/freenet/trustlistrequester.cpp
index d7dc27b..9ef9b61 100644 (file)
--- a/src/freenet/trustlistrequester.cpp
+++ b/src/freenet/trustlistrequester.cpp
@@ -4,6 +4,7 @@
 #include "../../include/freenet/trustlistxml.h"\r
 \r
 #include <Poco/DateTimeFormatter.h>\r
+#include <Poco/Timespan.h>\r
 \r
 #ifdef XMEM\r
        #include <xmem.h>\r
@@ -56,6 +57,7 @@ const bool TrustListRequester::HandleAllData(FCPMessage &message)
 \r
        // get count of identities added in last 24 hours\r
        st=m_db->Prepare("SELECT COUNT(*) FROM tblIdentity WHERE DateAdded>=?;");\r
+       now-=Poco::Timespan(1,0,0,0,0);\r
        st.Bind(0,Poco::DateTimeFormatter::format(now,"%Y-%m-%d %H:%M:%S"));\r
        st.Step();\r
        if(st.RowReturned())\r
@@ -69,6 +71,7 @@ const bool TrustListRequester::HandleAllData(FCPMessage &message)
        {\r
                m_log->error("TrustListRequester::HandleAllData couldn't get count of identities added in last 24 hours");\r
        }\r
+       now=Poco::DateTime();\r
 \r
        // parse file into xml and update the database\r
        if(xml.ParseXML(std::string(data.begin(),data.end()))==true)\r
@@ -106,7 +109,7 @@ const bool TrustListRequester::HandleAllData(FCPMessage &message)
                // loop through all trust entries in xml and add to database if we don't already know them\r
                for(long i=0; i<xml.TrustCount(); i++)\r
                {\r
-                       int id;\r
+                       int id=-1;\r
                        std::string identity;\r
                        std::string messagetrustcomment="";\r
                        std::string trustlisttrustcomment="";\r
@@ -135,41 +138,44 @@ const bool TrustListRequester::HandleAllData(FCPMessage &message)
                        st.Reset();\r
 \r
                        //insert trust for this identity\r
-                       trustst.Bind(0,identityid);\r
-                       trustst.Bind(1,id);\r
-                       if(xml.GetMessageTrust(i)==-1)\r
+                       if(id!=-1)\r
                        {\r
-                               trustst.Bind(2);\r
-                       }\r
-                       else\r
-                       {\r
-                               trustst.Bind(2,xml.GetMessageTrust(i));\r
-                       }\r
-                       if(xml.GetTrustListTrust(i)==-1)\r
-                       {\r
-                               trustst.Bind(3);\r
-                       }\r
-                       else\r
-                       {\r
-                               trustst.Bind(3,xml.GetTrustListTrust(i));\r
-                       }\r
-                       messagetrustcomment=xml.GetMessageTrustComment(i);\r
-                       trustlisttrustcomment=xml.GetTrustListTrustComment(i);\r
-                       // limit comments to 50 characters each\r
-                       if(messagetrustcomment.size()>50)\r
-                       {\r
-                               messagetrustcomment.erase(50);\r
-                       }\r
-                       if(trustlisttrustcomment.size()>50)\r
-                       {\r
-                               trustlisttrustcomment.erase(50);\r
+                               trustst.Bind(0,identityid);\r
+                               trustst.Bind(1,id);\r
+                               if(xml.GetMessageTrust(i)==-1)\r
+                               {\r
+                                       trustst.Bind(2);\r
+                               }\r
+                               else\r
+                               {\r
+                                       trustst.Bind(2,xml.GetMessageTrust(i));\r
+                               }\r
+                               if(xml.GetTrustListTrust(i)==-1)\r
+                               {\r
+                                       trustst.Bind(3);\r
+                               }\r
+                               else\r
+                               {\r
+                                       trustst.Bind(3,xml.GetTrustListTrust(i));\r
+                               }\r
+                               messagetrustcomment=xml.GetMessageTrustComment(i);\r
+                               trustlisttrustcomment=xml.GetTrustListTrustComment(i);\r
+                               // limit comments to 50 characters each\r
+                               if(messagetrustcomment.size()>50)\r
+                               {\r
+                                       messagetrustcomment.erase(50);\r
+                               }\r
+                               if(trustlisttrustcomment.size()>50)\r
+                               {\r
+                                       trustlisttrustcomment.erase(50);\r
+                               }\r
+                               trustst.Bind(4,messagetrustcomment);\r
+                               trustst.Bind(5,trustlisttrustcomment);\r
+                               trustst.Step();\r
+                               trustst.Reset();\r
                        }\r
-                       trustst.Bind(4,messagetrustcomment);\r
-                       trustst.Bind(5,trustlisttrustcomment);\r
-                       trustst.Step();\r
-                       trustst.Reset();\r
-\r
                }\r
+\r
                trustst.Finalize();\r
                st.Finalize();\r
 \r