X-Git-Url: https://git.pterodactylus.net/?p=fms.git;a=blobdiff_plain;f=src%2Fmessage.cpp;h=f4a6ea6eaba0dbb1c4f1253b1f3aefa64b4f0ab8;hp=d8adc87c64c1f334f87ea0f7c2ac76c225b2c645;hb=4430e7762844c66428b6f822288beb71b7f82b95;hpb=ee580d19b7920904587e18d72a3465d52eab6204 diff --git a/src/message.cpp b/src/message.cpp index d8adc87..f4a6ea6 100644 --- a/src/message.cpp +++ b/src/message.cpp @@ -630,6 +630,7 @@ const bool Message::StartFreenetInsert() xml.SetDate(m_datetime.Format("%Y-%m-%d")); xml.SetTime(m_datetime.Format("%H:%M:%S")); + StripAdministrationBoards(); for(std::vector::iterator i=m_boards.begin(); i!=m_boards.end(); i++) { xml.AddBoard((*i)); @@ -678,3 +679,22 @@ const bool Message::StartFreenetInsert() return true; } + +void Message::StripAdministrationBoards() +{ + SQLite3DB::Statement st=m_db->Prepare("SELECT tblBoard.BoardID FROM tblBoard INNER JOIN tblAdministrationBoard ON tblBoard.BoardID=tblAdministrationBoard.BoardID WHERE BoardName=?;"); + for(std::vector::iterator i=m_boards.begin(); i!=m_boards.end(); ) + { + st.Bind(0,(*i)); + st.Step(); + if(st.RowReturned()) + { + i=m_boards.erase(i); + } + else + { + i++; + } + st.Reset(); + } +}