X-Git-Url: https://git.pterodactylus.net/?a=blobdiff_plain;f=src%2Ffreenet%2Fmessagerequester.cpp;h=13cc1f2179ede3165665a7408fd5a14f6f9144ef;hb=3dc3ac3cfe10b7196a7977e9c041c29fa141c35e;hp=ac56c5c388808074ec6c5293d14189950093ffbd;hpb=ee580d19b7920904587e18d72a3465d52eab6204;p=fms.git

diff --git a/src/freenet/messagerequester.cpp b/src/freenet/messagerequester.cpp
index ac56c5c..13cc1f2 100644
--- a/src/freenet/messagerequester.cpp
+++ b/src/freenet/messagerequester.cpp
@@ -19,8 +19,10 @@ MessageRequester::MessageRequester(FCPv2 *fcp):IIndexRequester<std::string>(fcp)
 
 const long MessageRequester::GetBoardID(const std::string &boardname)
 {
+	std::string lowerboard=boardname;
+	StringFunctions::LowerCase(lowerboard,lowerboard);
 	SQLite3DB::Statement st=m_db->Prepare("SELECT BoardID FROM tblBoard WHERE BoardName=?;");
-	st.Bind(0,boardname);
+	st.Bind(0,lowerboard);
 	st.Step();
 
 	if(st.RowReturned())
@@ -127,11 +129,15 @@ const bool MessageRequester::HandleAllData(FCPMessage &message)
 		if(boards.size()<=0)
 		{
 			m_log->WriteLog(LogFile::LOGLEVEL_ERROR,"MessageRequester::HandleAllData Message XML did not contain any boards! "+message["Identifier"]);
+			// remove this identityid from request list
+			RemoveFromRequestList(idparts[1]);			
 			return true;
 		}
 		if(xml.GetReplyBoard()=="")
 		{
 			m_log->WriteLog(LogFile::LOGLEVEL_ERROR,"MessageRequester::HandleAllData Message XML did not contain a reply board! "+message["Identifier"]);
+			// remove this identityid from request list
+			RemoveFromRequestList(idparts[1]);			
 			return true;
 		}
 
@@ -191,7 +197,7 @@ const bool MessageRequester::HandleAllData(FCPMessage &message)
 
 		if(validmessage && savetoboardcount>0)
 		{
-			st=m_db->Prepare("INSERT INTO tblMessage(IdentityID,FromName,MessageDate,MessageTime,Subject,MessageUUID,ReplyBoardID,Body) VALUES(?,?,?,?,?,?,?,?);");
+			st=m_db->Prepare("INSERT INTO tblMessage(IdentityID,FromName,MessageDate,MessageTime,Subject,MessageUUID,ReplyBoardID,Body,MessageIndex) VALUES(?,?,?,?,?,?,?,?,?);");
 			st.Bind(0,identityid);
 			st.Bind(1,GetIdentityName(identityid));
 			st.Bind(2,xml.GetDate());
@@ -200,6 +206,7 @@ const bool MessageRequester::HandleAllData(FCPMessage &message)
 			st.Bind(5,xml.GetMessageID());
 			st.Bind(6,GetBoardID(xml.GetReplyBoard()));
 			st.Bind(7,xml.GetBody());
+			st.Bind(8,index);
 			inserted=st.Step(true);
 			int messageid=st.GetLastInsertRowID();