{\r
std::string lowerboard=boardname;\r
StringFunctions::LowerCase(lowerboard,lowerboard);\r
{\r
std::string lowerboard=boardname;\r
StringFunctions::LowerCase(lowerboard,lowerboard);\r
- st=m_db->Prepare("INSERT INTO tblBoard(BoardName,DateAdded) VALUES(?,?);");\r
+ st=m_db->Prepare("INSERT INTO tblBoard(BoardName,DateAdded,SaveReceivedMessages,AddedMethod) VALUES(?,?,?,?);");\r
st.Bind(3,xml.GetTime());\r
st.Bind(4,xml.GetSubject());\r
st.Bind(5,xml.GetMessageID());\r
st.Bind(3,xml.GetTime());\r
st.Bind(4,xml.GetSubject());\r
st.Bind(5,xml.GetMessageID());\r
st.Bind(7,xml.GetBody());\r
st.Bind(8,index);\r
inserted=st.Step(true);\r
st.Bind(7,xml.GetBody());\r
st.Bind(8,index);\r
inserted=st.Step(true);\r
sql+="WHERE (tblIdentity.LocalMessageTrust IS NULL OR tblIdentity.LocalMessageTrust>=(SELECT OptionValue FROM tblOption WHERE Option='MinLocalMessageTrust')) ";\r
sql+="AND FromMessageList='true' AND Found='false' AND Day>='"+date.Format("%Y-%m-%d")+"' ";\r
sql+="AND (tblIdentity.PeerMessageTrust IS NULL OR tblIdentity.PeerMessageTrust>=(SELECT OptionValue FROM tblOption WHERE Option='MinPeerMessageTrust')) ";\r
sql+="WHERE (tblIdentity.LocalMessageTrust IS NULL OR tblIdentity.LocalMessageTrust>=(SELECT OptionValue FROM tblOption WHERE Option='MinLocalMessageTrust')) ";\r
sql+="AND FromMessageList='true' AND Found='false' AND Day>='"+date.Format("%Y-%m-%d")+"' ";\r
sql+="AND (tblIdentity.PeerMessageTrust IS NULL OR tblIdentity.PeerMessageTrust>=(SELECT OptionValue FROM tblOption WHERE Option='MinPeerMessageTrust')) ";\r