// get identities who posted messages to boards in the past 20 days\r
SQLite3DB::Statement st=m_db->Prepare("SELECT tblLocalIdentity.LocalIdentityID FROM tblLocalIdentity INNER JOIN tblMessageInserts ON tblLocalIdentity.LocalIdentityID=tblMessageInserts.LocalIdentityID WHERE tblLocalIdentity.PublishBoardList='true' AND (tblLocalIdentity.LastInsertedBoardList<? OR tblLocalIdentity.LastInsertedBoardList IS NULL) AND tblMessageInserts.Day>=? GROUP BY tblLocalIdentity.LocalIdentityID;");\r
\r
// get identities who posted messages to boards in the past 20 days\r
SQLite3DB::Statement st=m_db->Prepare("SELECT tblLocalIdentity.LocalIdentityID FROM tblLocalIdentity INNER JOIN tblMessageInserts ON tblLocalIdentity.LocalIdentityID=tblMessageInserts.LocalIdentityID WHERE tblLocalIdentity.PublishBoardList='true' AND (tblLocalIdentity.LastInsertedBoardList<? OR tblLocalIdentity.LastInsertedBoardList IS NULL) AND tblMessageInserts.Day>=? GROUP BY tblLocalIdentity.LocalIdentityID;");\r
-void BoardListInserter::StartInsert(const long &localidentityid)\r
+const bool BoardListInserter::StartInsert(const long &localidentityid)\r
{\r
{\r
- DateTime daysback;\r
- DateTime now;\r
+ Poco::DateTime daysback;\r
+ Poco::DateTime now;\r
BoardListXML xml;\r
FCPMessage message;\r
std::string data;\r
BoardListXML xml;\r
FCPMessage message;\r
std::string data;\r
@@ -116,14+116,13 @@ void BoardListInserter::StartInsert(const long &localidentityid)
std::string indexstr="";\r
std::string localidentityidstr;\r
\r
std::string indexstr="";\r
std::string localidentityidstr;\r
\r
- now.SetToGMTime();\r
- daysback.SetToGMTime();\r
- daysback.Add(0,0,0,-20);\r
+ // 20 days back\r
+ daysback-=Poco::Timespan(20,0,0,0,0);\r
\r
// get boards\r
SQLite3DB::Statement st=m_db->Prepare("SELECT BoardName,BoardDescription FROM tblBoard INNER JOIN tblMessageBoard ON tblBoard.BoardID=tblMessageBoard.BoardID INNER JOIN tblMessage ON tblMessageBoard.MessageID=tblMessage.MessageID INNER JOIN tblMessageInserts ON tblMessage.MessageUUID=tblMessageInserts.MessageUUID WHERE tblMessageInserts.LocalIdentityID=? AND tblMessageInserts.Day>=? GROUP BY tblBoard.BoardID;");\r
st.Bind(0,localidentityid);\r
\r
// get boards\r
SQLite3DB::Statement st=m_db->Prepare("SELECT BoardName,BoardDescription FROM tblBoard INNER JOIN tblMessageBoard ON tblBoard.BoardID=tblMessageBoard.BoardID INNER JOIN tblMessage ON tblMessageBoard.MessageID=tblMessage.MessageID INNER JOIN tblMessageInserts ON tblMessage.MessageUUID=tblMessageInserts.MessageUUID WHERE tblMessageInserts.LocalIdentityID=? AND tblMessageInserts.Day>=? GROUP BY tblBoard.BoardID;");\r