1 #include "../include/boardlist.h"
\r
7 void BoardList::Load()
\r
12 std::string boardname="";
\r
13 std::string boarddescription="";
\r
14 std::string dateadded="";
\r
15 std::string savereceivedstr="";
\r
16 bool savereceived=false;
\r
17 int highmessageid=0;
\r
21 SQLite3DB::Statement st=m_db->Prepare("SELECT tblBoard.BoardID, BoardName, BoardDescription, DateAdded, HighMessageID, LowMessageID, MessageCount, SaveReceivedMessages FROM tblBoard LEFT JOIN vwBoardStats ON tblBoard.BoardID=vwBoardStats.BoardID ORDER BY BoardName COLLATE NOCASE;");
\r
24 while(st.RowReturned())
\r
26 st.ResultInt(0,boardid);
\r
27 st.ResultText(1,boardname);
\r
28 st.ResultText(2,boarddescription);
\r
29 st.ResultText(3,dateadded);
\r
30 st.ResultInt(4,highmessageid);
\r
31 st.ResultInt(5,lowmessageid);
\r
32 st.ResultInt(6,messagecount);
\r
33 st.ResultText(7,savereceivedstr);
\r
35 if(savereceivedstr=="true")
\r
44 push_back(Board(boardid,boardname,boarddescription,dateadded,lowmessageid,highmessageid,messagecount,savereceived));
\r
49 void BoardList::LoadNew(const std::string &date)
\r
54 SQLite3DB::Statement st=m_db->Prepare("SELECT BoardID FROM tblBoard WHERE DateAdded>? ORDER BY BoardName;");
\r
58 while(st.RowReturned())
\r
60 st.ResultInt(0,tempint);
\r
61 push_back(Board(tempint));
\r