1 #include "../../include/freenet/messagelistrequester.h"
\r
2 #include "../../include/freenet/messagelistxml.h"
\r
4 #include <Poco/DateTime.h>
\r
5 #include <Poco/DateTimeFormatter.h>
\r
6 #include <Poco/Timestamp.h>
\r
12 MessageListRequester::MessageListRequester()
\r
17 MessageListRequester::MessageListRequester(FCPv2 *fcp):IIndexRequester<long>(fcp)
\r
22 void MessageListRequester::GetBoardList(std::map<std::string,bool> &boards)
\r
24 SQLite3DB::Statement st=m_db->Prepare("SELECT BoardName, SaveReceivedMessages FROM tblBoard;");
\r
26 while(st.RowReturned())
\r
28 std::string boardname="";
\r
29 std::string tempval="";
\r
30 st.ResultText(0,boardname);
\r
31 st.ResultText(1,tempval);
\r
35 boards[boardname]=true;
\r
39 boards[boardname]=false;
\r
46 const bool MessageListRequester::HandleAllData(FCPMessage &message)
\r
48 SQLite3DB::Statement st;
\r
49 SQLite3DB::Statement trustst;
\r
50 std::vector<std::string> idparts;
\r
52 std::vector<char> data;
\r
56 std::map<std::string,bool> boards; // list of boards and if we will save messages for that board or not
\r
57 bool addmessage=false;
\r
58 std::string boardsstr="";
\r
60 GetBoardList(boards);
\r
62 StringFunctions::Split(message["Identifier"],"|",idparts);
\r
63 StringFunctions::Convert(message["DataLength"],datalength);
\r
64 StringFunctions::Convert(idparts[1],identityid);
\r
65 StringFunctions::Convert(idparts[2],index);
\r
67 // wait for all data to be received from connection
\r
68 while(m_fcp->Connected() && m_fcp->ReceiveBufferSize()<datalength)
\r
73 // if we got disconnected- return immediately
\r
74 if(m_fcp->Connected()==false)
\r
80 data.resize(datalength);
\r
81 m_fcp->ReceiveRaw(&data[0],datalength);
\r
83 // parse file into xml and update the database
\r
84 if(xml.ParseXML(std::string(data.begin(),data.end()))==true)
\r
87 SQLite3DB::Statement st=m_db->Prepare("SELECT IdentityID FROM tblMessageRequests WHERE IdentityID=? AND Day=? AND RequestIndex=?;");
\r
88 SQLite3DB::Statement spk=m_db->Prepare("SELECT IdentityID FROM tblIdentity WHERE PublicKey=?;");
\r
89 SQLite3DB::Statement mst=m_db->Prepare("INSERT INTO tblMessageRequests(IdentityID,Day,RequestIndex,FromMessageList) VALUES(?,?,?,'true');");
\r
90 for(long i=0; i<xml.MessageCount(); i++)
\r
93 // go through each board the message was posted to and see if we are saving messages to that board
\r
94 // if the board isn't found, see if we are saving messages to new boards
\r
97 std::vector<std::string> messageboards=xml.GetBoards(i);
\r
98 for(std::vector<std::string>::iterator j=messageboards.begin(); j!=messageboards.end(); j++)
\r
100 if(boards.find((*j))!=boards.end())
\r
102 if(boards[(*j)]==true)
\r
107 else if(m_savetonewboards==true)
\r
111 if(j!=messageboards.begin())
\r
118 if(addmessage==true)
\r
120 st.Bind(0,identityid);
\r
121 st.Bind(1,xml.GetDate(i));
\r
122 st.Bind(2,xml.GetIndex(i));
\r
124 if(st.RowReturned()==false)
\r
126 mst.Bind(0,identityid);
\r
127 mst.Bind(1,xml.GetDate(i));
\r
128 mst.Bind(2,xml.GetIndex(i));
\r
136 m_log->trace("MessageListRequester::HandleAllData will not download message posted to "+boardsstr);
\r
140 // insert external message indexes
\r
141 for(long i=0; i<xml.ExternalMessageCount(); i++)
\r
143 if(xml.GetExternalType(i)=="Keyed")
\r
145 // go through each board the message was posted to and see if we are saving messages to that board
\r
146 // if the board isn't found, see if we are saving messages to new boards
\r
149 std::vector<std::string> messageboards=xml.GetExternalBoards(i);
\r
150 for(std::vector<std::string>::iterator j=messageboards.begin(); j!=messageboards.end(); j++)
\r
152 if(boards.find((*j))!=boards.end())
\r
154 if(boards[(*j)]==true)
\r
159 else if(m_savetonewboards==true)
\r
163 if(j!=messageboards.begin())
\r
170 if(addmessage==true)
\r
172 spk.Bind(0,xml.GetExternalIdentity(i));
\r
174 if(spk.RowReturned())
\r
176 int thisidentityid=0;
\r
177 spk.ResultInt(0,thisidentityid);
\r
178 mst.Bind(0,thisidentityid);
\r
179 mst.Bind(1,xml.GetExternalDate(i));
\r
180 mst.Bind(2,xml.GetExternalIndex(i));
\r
188 m_log->trace("MessageListRequester::HandleAllData will not download external message posted to "+boardsstr+" from " + xml.GetExternalIdentity(i));
\r
193 st=m_db->Prepare("INSERT INTO tblMessageListRequests(IdentityID,Day,RequestIndex,Found) VALUES(?,?,?,'true');");
\r
194 st.Bind(0,identityid);
\r
195 st.Bind(1,idparts[4]);
\r
200 m_log->debug("MessageListRequester::HandleAllData parsed MessageList XML file : "+message["Identifier"]);
\r
204 // bad data - mark index
\r
205 st=m_db->Prepare("INSERT INTO tblMessageListRequests(IdentityID,Day,RequestIndex,Found) VALUES(?,?,?,'false');");
\r
206 st.Bind(0,identityid);
\r
207 st.Bind(1,idparts[4]);
\r
212 m_log->error("MessageListRequester::HandleAllData error parsing MessageList XML file : "+message["Identifier"]);
\r
215 // remove this identityid from request list
\r
216 RemoveFromRequestList(identityid);
\r
222 const bool MessageListRequester::HandleGetFailed(FCPMessage &message)
\r
224 SQLite3DB::Statement st;
\r
225 std::vector<std::string> idparts;
\r
229 StringFunctions::Split(message["Identifier"],"|",idparts);
\r
230 StringFunctions::Convert(idparts[1],identityid);
\r
231 StringFunctions::Convert(idparts[2],index);
\r
233 // code 27 - permanent redirect
\r
234 if(message["Code"]=="27")
\r
236 StartRedirectRequest(message);
\r
240 // if this is a fatal error - insert index into database so we won't try to download this index again
\r
241 if(message["Fatal"]=="true")
\r
243 st=m_db->Prepare("INSERT INTO tblMessageListRequests(IdentityID,Day,RequestIndex,Found) VALUES(?,?,?,'false');");
\r
244 st.Bind(0,identityid);
\r
245 st.Bind(1,idparts[4]);
\r
250 m_log->error("MessageListRequester::HandleGetFailed fatal error code="+message["Code"]+" requesting "+message["Identifier"]);
\r
253 // remove this identityid from request list
\r
254 RemoveFromRequestList(identityid);
\r
259 void MessageListRequester::Initialize()
\r
261 m_fcpuniquename="MessageListRequester";
\r
262 std::string tempval;
\r
263 Option::Instance()->Get("MaxMessageListRequests",tempval);
\r
264 StringFunctions::Convert(tempval,m_maxrequests);
\r
265 if(m_maxrequests<1)
\r
268 m_log->error("Option MaxMessageListRequests is currently set at "+tempval+". It must be 1 or greater.");
\r
270 if(m_maxrequests>100)
\r
272 m_log->warning("Option MaxMessageListRequests is currently set at "+tempval+". This value might be incorrectly configured.");
\r
276 Option::Instance()->Get("LocalTrustOverridesPeerTrust",tempval);
\r
277 if(tempval=="true")
\r
279 m_localtrustoverrides=true;
\r
283 m_localtrustoverrides=false;
\r
287 Option::Instance()->Get("SaveMessagesFromNewBoards",tempval);
\r
288 if(tempval=="true")
\r
290 m_savetonewboards=true;
\r
294 m_savetonewboards=false;
\r
299 void MessageListRequester::PopulateIDList()
\r
301 Poco::DateTime date;
\r
304 SQLite3DB::Statement st;
\r
306 // select identities we want to query (we've seen them today) - sort by their trust level (descending) with secondary sort on how long ago we saw them (ascending)
\r
307 if(m_localtrustoverrides==false)
\r
309 st=m_db->Prepare("SELECT IdentityID FROM tblIdentity WHERE PublicKey IS NOT NULL AND PublicKey <> '' AND LastSeen>='"+Poco::DateTimeFormatter::format(date,"%Y-%m-%d")+"' AND (LocalMessageTrust IS NULL OR LocalMessageTrust>=(SELECT OptionValue FROM tblOption WHERE Option='MinLocalMessageTrust')) AND (PeerMessageTrust IS NULL OR PeerMessageTrust>=(SELECT OptionValue FROM tblOption WHERE Option='MinPeerMessageTrust')) ORDER BY LocalMessageTrust+LocalTrustListTrust DESC, LastSeen;");
\r
313 st=m_db->Prepare("SELECT IdentityID FROM tblIdentity WHERE PublicKey IS NOT NULL AND PublicKey <> '' AND LastSeen>='"+Poco::DateTimeFormatter::format(date,"%Y-%m-%d")+"' AND (LocalMessageTrust>=(SELECT OptionValue FROM tblOption WHERE Option='MinLocalMessageTrust') OR (LocalMessageTrust IS NULL AND (PeerMessageTrust IS NULL OR PeerMessageTrust>=(SELECT OptionValue FROM tblOption WHERE Option='MinPeerMessageTrust')))) ORDER BY LocalMessageTrust+LocalTrustListTrust DESC, LastSeen;");
\r
319 while(st.RowReturned())
\r
321 st.ResultInt(0,id);
\r
327 void MessageListRequester::StartRedirectRequest(FCPMessage &message)
\r
329 std::vector<std::string> parts;
\r
330 std::string indexstr="";
\r
331 std::string identityidstr="";
\r
332 std::string datestr="";
\r
333 FCPMessage newmessage;
\r
335 // get the new edition #
\r
336 StringFunctions::Split(message["RedirectURI"],"/",parts);
\r
337 //edition # is 2nd to last part
\r
340 indexstr=parts[parts.size()-2];
\r
345 StringFunctions::Split(message["Identifier"],"|",parts);
\r
348 identityidstr=parts[1];
\r
355 newmessage.SetName("ClientGet");
\r
356 newmessage["URI"]=StringFunctions::UriDecode(message["RedirectURI"]);
\r
357 newmessage["Identifier"]=m_fcpuniquename+"|"+identityidstr+"|"+indexstr+"|_|"+datestr+"|"+newmessage["URI"];
\r
358 newmessage["ReturnType"]="direct";
\r
359 newmessage["MaxSize"]="1000000";
\r
361 m_fcp->SendMessage(newmessage);
\r
365 void MessageListRequester::StartRequest(const long &id)
\r
367 Poco::DateTime now;
\r
368 FCPMessage message;
\r
369 std::string publickey;
\r
371 std::string indexstr;
\r
372 std::string identityidstr;
\r
374 SQLite3DB::Statement st=m_db->Prepare("SELECT PublicKey FROM tblIdentity WHERE IdentityID=?;");
\r
378 if(st.RowReturned())
\r
380 st.ResultText(0,publickey);
\r
382 now=Poco::Timestamp();
\r
384 SQLite3DB::Statement st2=m_db->Prepare("SELECT MAX(RequestIndex) FROM tblMessageListRequests WHERE Day=? AND IdentityID=?;");
\r
385 st2.Bind(0,Poco::DateTimeFormatter::format(now,"%Y-%m-%d"));
\r
390 if(st2.RowReturned())
\r
392 if(st2.ResultNull(0)==false)
\r
394 st2.ResultInt(0,index);
\r
395 // don't increment index here - the node will let us know if there is a new edition
\r
396 // 2008-05-31 - well actually the node isn't reliably retreiving the latest edition for USKs, so we DO need to increment the index
\r
402 StringFunctions::Convert(index,indexstr);
\r
403 StringFunctions::Convert(id,identityidstr);
\r
405 message.SetName("ClientGet");
\r
406 message["URI"]="USK"+publickey.substr(3)+m_messagebase+"|"+Poco::DateTimeFormatter::format(now,"%Y.%m.%d")+"|MessageList/"+indexstr+"/MessageList.xml";
\r
407 message["Identifier"]=m_fcpuniquename+"|"+identityidstr+"|"+indexstr+"|_|"+Poco::DateTimeFormatter::format(now,"%Y-%m-%d")+"|"+message["URI"];
\r
408 message["ReturnType"]="direct";
\r
409 message["MaxSize"]="1000000";
\r
411 m_fcp->SendMessage(message);
\r
413 m_requesting.push_back(id);
\r