version 0.1.9

[fms.git] / src / message.cpp

diff --git a/src/message.cpp b/src/message.cpp
index 2cfb588..5861ef0 100644 (file)
--- a/src/message.cpp
+++ b/src/message.cpp
@@ -20,6 +20,27 @@ Message::Message(const long messageid)
        Load(messageid);\r
 }\r
 \r
+const bool Message::CheckForAdministrationBoard(const std::vector<std::string> &boards)\r
+{\r
+       std::string name;\r
+       SQLite3DB::Statement st=m_db->Prepare("SELECT BoardName FROM tblBoard INNER JOIN tblAdministrationBoard ON tblBoard.BoardID=tblAdministrationBoard.BoardID;");\r
+       st.Step();\r
+       \r
+       while(st.RowReturned())\r
+       {\r
+               st.ResultText(0,name);\r
+\r
+               if(std::find(boards.begin(),boards.end(),name)!=boards.end())\r
+               {\r
+                       return true;\r
+               }\r
+               \r
+               st.Step();\r
+       }\r
+\r
+       return false;\r
+}\r
+\r
 const std::string Message::GetNNTPArticleID() const\r
 {\r
        return "<"+m_messageuuid+"@freenetproject.org>";\r
@@ -69,6 +90,108 @@ const std::string Message::GetNNTPHeaders() const
        return rval;\r
 }\r
 \r
+void Message::HandleAdministrationMessage()\r
+{\r
+       // only continue if this message was actually a reply to another message\r
+       if(m_inreplyto.size()>0)\r
+       {\r
+               int boardid=0;\r
+               std::string boardname="";\r
+               std::string identityname="";\r
+               int identityid;\r
+               int changemessagetrust=0;\r
+               int changetrustlisttrust=0;\r
+               int origmessagetrust=0;\r
+               int origtrustlisttrust=0;\r
+               SQLite3DB::Statement st=m_db->Prepare("SELECT tblBoard.BoardID,BoardName,ModifyLocalMessageTrust,ModifyLocalTrustListTrust FROM tblBoard INNER JOIN tblAdministrationBoard ON tblBoard.BoardID=tblAdministrationBoard.BoardID;");\r
+               st.Step();\r
+\r
+               while(st.RowReturned())\r
+               {\r
+                       st.ResultInt(0,boardid);\r
+                       st.ResultText(1,boardname);\r
+                       st.ResultInt(2,changemessagetrust);\r
+                       st.ResultInt(3,changetrustlisttrust);\r
+\r
+                       if(std::find(m_boards.begin(),m_boards.end(),boardname)!=m_boards.end())\r
+                       {\r
+                               SQLite3DB::Statement origmess=m_db->Prepare("SELECT tblIdentity.IdentityID,tblIdentity.Name,tblIdentity.LocalMessageTrust,tblIdentity.LocalTrustListTrust FROM tblIdentity INNER JOIN tblMessage ON tblIdentity.IdentityID=tblMessage.IdentityID WHERE tblMessage.MessageUUID=?;");\r
+                               origmess.Bind(0,m_inreplyto[0]);\r
+                               origmess.Step();\r
+\r
+                               if(origmess.RowReturned())\r
+                               {\r
+                                       origmess.ResultInt(0,identityid);\r
+                                       origmess.ResultText(1,identityname);\r
+                                       origmess.ResultInt(2,origmessagetrust);\r
+                                       origmess.ResultInt(3,origtrustlisttrust);\r
+\r
+                                       origmessagetrust+=changemessagetrust;\r
+                                       origtrustlisttrust+=changetrustlisttrust;\r
+\r
+                                       if(origmessagetrust<0)\r
+                                       {\r
+                                               origmessagetrust=0;\r
+                                       }\r
+                                       if(origmessagetrust>100)\r
+                                       {\r
+                                               origmessagetrust=100;\r
+                                       }\r
+                                       if(origtrustlisttrust<0)\r
+                                       {\r
+                                               origtrustlisttrust=0;\r
+                                       }\r
+                                       if(origtrustlisttrust>100)\r
+                                       {\r
+                                               origtrustlisttrust=100;\r
+                                       }\r
+\r
+                                       // update new trust levels\r
+                                       SQLite3DB::Statement update=m_db->Prepare("UPDATE tblIdentity SET LocalMessageTrust=?, LocalTrustListTrust=? WHERE IdentityID=?;");\r
+                                       update.Bind(0,origmessagetrust);\r
+                                       update.Bind(1,origtrustlisttrust);\r
+                                       update.Bind(2,identityid);\r
+                                       update.Step();\r
+\r
+                                       // insert message to show what id was changed and what current levels are\r
+                                       int lastid=0;\r
+                                       std::string messagebody;\r
+                                       std::string messagetruststr="";\r
+                                       std::string trustlisttruststr="";\r
+                                       UUIDGenerator uuid;\r
+                                       DateTime now;\r
+                                       now.SetToGMTime();\r
+                                       StringFunctions::Convert(origmessagetrust,messagetruststr);\r
+                                       StringFunctions::Convert(origtrustlisttrust,trustlisttruststr);\r
+                                       messagebody="Trust Changed for "+identityname+"\r\n";\r
+                                       messagebody+="Local Message Trust : "+messagetruststr+"\r\n";\r
+                                       messagebody+="Local Trust List Trust : "+trustlisttruststr+"\r\n";\r
+                                       SQLite3DB::Statement insert=m_db->Prepare("INSERT INTO tblMessage(FromName,MessageDate,MessageTime,Subject,MessageUUID,ReplyBoardID,Body) VALUES('FMS',?,?,?,?,?,?);");\r
+                                       insert.Bind(0,now.Format("%Y-%m-%d"));\r
+                                       insert.Bind(1,now.Format("%H:%M:%S"));\r
+                                       insert.Bind(2,identityname+" Trust Changed");\r
+                                       insert.Bind(3,uuid.Generate());\r
+                                       insert.Bind(4,boardid);\r
+                                       insert.Bind(5,messagebody);\r
+                                       insert.Step(true);\r
+                                       lastid=insert.GetLastInsertRowID();\r
+\r
+                                       insert=m_db->Prepare("INSERT INTO tblMessageBoard(MessageID,BoardID) VALUES(?,?);");\r
+                                       insert.Bind(0,lastid);\r
+                                       insert.Bind(1,boardid);\r
+                                       insert.Step();\r
+\r
+                                       m_log->WriteLog(LogFile::LOGLEVEL_DEBUG,"Message::HandleAdministrationMessage updated "+identityname+" to "+messagetruststr+" , "+trustlisttruststr);\r
+\r
+                               }\r
+                       }\r
+\r
+                       st.Step();\r
+               }\r
+       }\r
+\r
+}\r
+\r
 void Message::Initialize()\r
 {\r
        m_messageid=-1;\r
@@ -386,6 +509,7 @@ const bool Message::ParseNNTPMessage(const std::string &nntpmessage)
 \r
 void Message::StartFreenetInsert()\r
 {\r
+       //TODO if message was posted to one of the special administration boards - don't really insert it, but perform the action\r
        MessageXML xml;\r
        int localidentityid=-1;\r
 \r