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
20 std::string addedmethod="";
\r
22 SQLite3DB::Statement st=m_db->Prepare("SELECT tblBoard.BoardID, BoardName, BoardDescription, DateAdded, HighMessageID, LowMessageID, MessageCount, SaveReceivedMessages, AddedMethod FROM tblBoard LEFT JOIN vwBoardStats ON tblBoard.BoardID=vwBoardStats.BoardID ORDER BY BoardName COLLATE NOCASE;");
\r
25 while(st.RowReturned())
\r
27 st.ResultInt(0,boardid);
\r
28 st.ResultText(1,boardname);
\r
29 st.ResultText(2,boarddescription);
\r
30 st.ResultText(3,dateadded);
\r
31 st.ResultInt(4,highmessageid);
\r
32 st.ResultInt(5,lowmessageid);
\r
33 st.ResultInt(6,messagecount);
\r
34 st.ResultText(7,savereceivedstr);
\r
35 st.ResultText(8,addedmethod);
\r
37 if(savereceivedstr=="true")
\r
46 push_back(Board(m_db,boardid,boardname,boarddescription,dateadded,lowmessageid,highmessageid,messagecount,savereceived,addedmethod));
\r
51 void BoardList::LoadNew(const std::string &date)
\r
56 SQLite3DB::Statement st=m_db->Prepare("SELECT BoardID FROM tblBoard WHERE DateAdded>? ORDER BY BoardName;");
\r
60 while(st.RowReturned())
\r
62 st.ResultInt(0,tempint);
\r
63 push_back(Board(m_db,tempint));
\r