X-Git-Url: https://git.pterodactylus.net/?a=blobdiff_plain;ds=sidebyside;f=src%2Fmessage.cpp;h=123d370e5752c2ee443c3470f7b3a1e69ac7f963;hb=f60495a029c54358f82956482fe203fe2b7b5b23;hp=dee644d919b6f6e6f9963f1751c249877e610aa7;hpb=f208e33c29132aacaec448e74341edea1b925a2a;p=fms.git

diff --git a/src/message.cpp b/src/message.cpp
index dee644d..123d370 100644
--- a/src/message.cpp
+++ b/src/message.cpp
@@ -20,6 +20,27 @@ Message::Message(const long messageid)
 	Load(messageid);
 }
 
+const bool Message::CheckForAdministrationBoard(const std::vector<std::string> &boards)
+{
+	std::string name;
+	SQLite3DB::Statement st=m_db->Prepare("SELECT BoardName FROM tblBoard INNER JOIN tblAdministrationBoard ON tblBoard.BoardID=tblAdministrationBoard.BoardID;");
+	st.Step();
+	
+	while(st.RowReturned())
+	{
+		st.ResultText(0,name);
+
+		if(std::find(boards.begin(),boards.end(),name)!=boards.end())
+		{
+			return true;
+		}
+		
+		st.Step();
+	}
+
+	return false;
+}
+
 const std::string Message::GetNNTPArticleID() const
 {
 	return "<"+m_messageuuid+"@freenetproject.org>";
@@ -69,6 +90,108 @@ const std::string Message::GetNNTPHeaders() const
 	return rval;
 }
 
+void Message::HandleAdministrationMessage()
+{
+	// only continue if this message was actually a reply to another message
+	if(m_inreplyto.size()>0)
+	{
+		int boardid=0;
+		std::string boardname="";
+		std::string identityname="";
+		int identityid;
+		int changemessagetrust=0;
+		int changetrustlisttrust=0;
+		int origmessagetrust=0;
+		int origtrustlisttrust=0;
+		SQLite3DB::Statement st=m_db->Prepare("SELECT tblBoard.BoardID,BoardName,ModifyLocalMessageTrust,ModifyLocalTrustListTrust FROM tblBoard INNER JOIN tblAdministrationBoard ON tblBoard.BoardID=tblAdministrationBoard.BoardID;");
+		st.Step();
+
+		while(st.RowReturned())
+		{
+			st.ResultInt(0,boardid);
+			st.ResultText(1,boardname);
+			st.ResultInt(2,changemessagetrust);
+			st.ResultInt(3,changetrustlisttrust);
+
+			if(std::find(m_boards.begin(),m_boards.end(),boardname)!=m_boards.end())
+			{
+				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=?;");
+				origmess.Bind(0,m_inreplyto[0]);
+				origmess.Step();
+
+				if(origmess.RowReturned())
+				{
+					origmess.ResultInt(0,identityid);
+					origmess.ResultText(1,identityname);
+					origmess.ResultInt(2,origmessagetrust);
+					origmess.ResultInt(3,origtrustlisttrust);
+
+					origmessagetrust+=changemessagetrust;
+					origtrustlisttrust+=changetrustlisttrust;
+
+					if(origmessagetrust<0)
+					{
+						origmessagetrust=0;
+					}
+					if(origmessagetrust>100)
+					{
+						origmessagetrust=100;
+					}
+					if(origtrustlisttrust<0)
+					{
+						origtrustlisttrust=0;
+					}
+					if(origtrustlisttrust>100)
+					{
+						origtrustlisttrust=100;
+					}
+
+					// update new trust levels
+					SQLite3DB::Statement update=m_db->Prepare("UPDATE tblIdentity SET LocalMessageTrust=?, LocalTrustListTrust=? WHERE IdentityID=?;");
+					update.Bind(0,origmessagetrust);
+					update.Bind(1,origtrustlisttrust);
+					update.Bind(2,identityid);
+					update.Step();
+
+					// insert message to show what id was changed and what current levels are
+					int lastid=0;
+					std::string messagebody;
+					std::string messagetruststr="";
+					std::string trustlisttruststr="";
+					UUIDGenerator uuid;
+					DateTime now;
+					now.SetToGMTime();
+					StringFunctions::Convert(origmessagetrust,messagetruststr);
+					StringFunctions::Convert(origtrustlisttrust,trustlisttruststr);
+					messagebody="Trust Changed for "+identityname+"\r\n";
+					messagebody+="Local Message Trust : "+messagetruststr+"\r\n";
+					messagebody+="Local Trust List Trust : "+trustlisttruststr+"\r\n";
+					SQLite3DB::Statement insert=m_db->Prepare("INSERT INTO tblMessage(FromName,MessageDate,MessageTime,Subject,MessageUUID,ReplyBoardID,Body) VALUES('FMS',?,?,?,?,?,?);");
+					insert.Bind(0,now.Format("%Y-%m-%d"));
+					insert.Bind(1,now.Format("%H:%M:%S"));
+					insert.Bind(2,identityname+" Trust Changed");
+					insert.Bind(3,uuid.Generate());
+					insert.Bind(4,boardid);
+					insert.Bind(5,messagebody);
+					insert.Step(true);
+					lastid=insert.GetLastInsertRowID();
+
+					insert=m_db->Prepare("INSERT INTO tblMessageBoard(MessageID,BoardID) VALUES(?,?);");
+					insert.Bind(0,lastid);
+					insert.Bind(1,boardid);
+					insert.Step();
+
+					m_log->WriteLog(LogFile::LOGLEVEL_DEBUG,"Message::HandleAdministrationMessage updated "+identityname+" to "+messagetruststr+" , "+trustlisttruststr);
+
+				}
+			}
+
+			st.Step();
+		}
+	}
+
+}
+
 void Message::Initialize()
 {
 	m_messageid=-1;
@@ -121,6 +244,9 @@ const bool Message::Load(const long messageid, const long boardid)
 		st.ResultText(7,m_fromname);
 		st.Finalize();
 
+		// strip off any \r\n in subject
+		m_subject=StringFunctions::Replace(m_subject,"\r\n","");
+
 		// get board list
 		st=m_db->Prepare("SELECT tblBoard.BoardName FROM tblBoard INNER JOIN tblMessageBoard ON tblBoard.BoardID=tblMessageBoard.BoardID WHERE tblMessageBoard.MessageID=?;");
 		st.Bind(0,messageid);
@@ -255,6 +381,8 @@ const bool Message::ParseNNTPMessage(const std::string &nntpmessage)
 	if(mime.GetFieldValue("From"))
 	{
 		m_fromname=mime.GetFieldValue("From");
+		// remove any path folding
+		m_fromname=StringFunctions::Replace(m_fromname,"\r\n","");
 		// strip off everything between () and <> and any whitespace
 		std::string::size_type startpos=m_fromname.find("(");
 		std::string::size_type endpos;
@@ -297,6 +425,8 @@ const bool Message::ParseNNTPMessage(const std::string &nntpmessage)
 	if(mime.GetFieldValue("Newsgroups"))
 	{
 		std::string temp=mime.GetFieldValue("Newsgroups");
+		// remove any path folding
+		temp=StringFunctions::Replace(temp,"\r\n","");
 		std::vector<std::string> parts;
 		StringFunctions::SplitMultiple(temp,", \t",parts);
 		for(std::vector<std::string>::iterator i=parts.begin(); i!=parts.end(); i++)
@@ -314,6 +444,8 @@ const bool Message::ParseNNTPMessage(const std::string &nntpmessage)
 	if(mime.GetFieldValue("Followup-To"))
 	{
 		m_replyboardname=mime.GetFieldValue("Followup-To");
+		// remove any path folding
+		m_replyboardname=StringFunctions::Replace(m_replyboardname,"\r\n","");
 	}
 	else
 	{
@@ -326,6 +458,8 @@ const bool Message::ParseNNTPMessage(const std::string &nntpmessage)
 	if(mime.GetFieldValue("Subject"))
 	{
 		m_subject=mime.GetFieldValue("Subject");
+		// remove any path folding
+		m_subject=StringFunctions::Replace(m_subject,"\r\n","");
 	}
 	else
 	{
@@ -335,6 +469,8 @@ const bool Message::ParseNNTPMessage(const std::string &nntpmessage)
 	if(mime.GetFieldValue("References"))
 	{
 		std::string temp=mime.GetFieldValue("References");
+		// remove any path folding
+		temp=StringFunctions::Replace(temp,"\r\n","");
 		std::vector<std::string> parts;
 		int count=0;
 		StringFunctions::SplitMultiple(temp,", \t",parts);
@@ -373,6 +509,7 @@ const bool Message::ParseNNTPMessage(const std::string &nntpmessage)
 
 void Message::StartFreenetInsert()
 {
+
 	MessageXML xml;
 	int localidentityid=-1;