version 0.1.14

[fms.git] / src / boardlist.cpp

diff --git a/src/boardlist.cpp b/src/boardlist.cpp
index 71c5e46..cd6e071 100644 (file)
--- a/src/boardlist.cpp
+++ b/src/boardlist.cpp
@@ -8,14 +8,40 @@ void BoardList::Load()
 {\r
        clear();\r
        \r
-       int tempint;\r
-       SQLite3DB::Statement st=m_db->Prepare("SELECT BoardID FROM tblBoard ORDER BY BoardName;");\r
+       int boardid=0;\r
+       std::string boardname="";\r
+       std::string boarddescription="";\r
+       std::string dateadded="";\r
+       std::string savereceivedstr="";\r
+       bool savereceived=false;\r
+       int highmessageid=0;\r
+       int lowmessageid=0;\r
+       int messagecount=0;\r
+\r
+       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
        st.Step();\r
        \r
        while(st.RowReturned())\r
        {\r
-               st.ResultInt(0,tempint);\r
-               push_back(Board(tempint));\r
+               st.ResultInt(0,boardid);\r
+               st.ResultText(1,boardname);\r
+               st.ResultText(2,boarddescription);\r
+               st.ResultText(3,dateadded);\r
+               st.ResultInt(4,highmessageid);\r
+               st.ResultInt(5,lowmessageid);\r
+               st.ResultInt(6,messagecount);\r
+               st.ResultText(7,savereceivedstr);\r
+\r
+               if(savereceivedstr=="true")\r
+               {\r
+                       savereceived=true;\r
+               }               \r
+               else\r
+               {\r
+                       savereceived=false;\r
+               }\r
+\r
+               push_back(Board(boardid,boardname,boarddescription,dateadded,lowmessageid,highmessageid,messagecount,savereceived));\r
                st.Step();\r
        }\r
 }\r