version 0.2.6

[fms.git] / src / http / pages / boardspage.cpp

diff --git a/src/http/pages/boardspage.cpp b/src/http/pages/boardspage.cpp
index dce33b8..4adab89 100644 (file)
--- a/src/http/pages/boardspage.cpp
+++ b/src/http/pages/boardspage.cpp
@@ -55,10 +55,11 @@ const std::string BoardsPage::GeneratePage(const std::string &method, const std:
                        StringFunctions::LowerCase(boardname,boardname);\r
                        boarddescription=(*queryvars.find("boarddescription")).second;\r
 \r
-                       SQLite3DB::Statement addst=m_db->Prepare("INSERT INTO tblBoard(BoardName,BoardDescription,DateAdded) VALUES(?,?,?);");\r
+                       SQLite3DB::Statement addst=m_db->Prepare("INSERT INTO tblBoard(BoardName,BoardDescription,DateAdded,AddedMethod) VALUES(?,?,?,?);");\r
                        addst.Bind(0,boardname);\r
                        addst.Bind(1,boarddescription);\r
                        addst.Bind(2,now.Format("%Y-%m-%d %H:%M:%S"));\r
+                       addst.Bind(3,"Added manually");\r
                        addst.Step();\r
                }\r
                if((*queryvars.find("formaction")).second=="remove0messages")\r
@@ -152,7 +153,7 @@ const std::string BoardsPage::GeneratePage(const std::string &method, const std:
        st.Finalize();\r
 \r
 \r
-       sql="SELECT BoardID,BoardName,BoardDescription,SaveReceivedMessages FROM tblBoard WHERE BoardID NOT IN (SELECT BoardID FROM tblAdministrationBoard)";\r
+       sql="SELECT BoardID,BoardName,BoardDescription,SaveReceivedMessages,AddedMethod FROM tblBoard WHERE BoardID NOT IN (SELECT BoardID FROM tblAdministrationBoard)";\r
        if(boardsearch!="")\r
        {\r
                sql+=" AND (BoardName LIKE '%' || ? || '%' OR BoardDescription LIKE '%' || ? || '%')";\r
@@ -186,9 +187,9 @@ const std::string BoardsPage::GeneratePage(const std::string &method, const std:
        content+="<td><form name=\"frmaddboard\" method=\"POST\"><input type=\"hidden\" name=\"formaction\" value=\"addboard\"><input type=\"text\" name=\"boardname\"></td><td><input type=\"text\" name=\"boarddescription\" size=\"40\" maxlength=\"50\"></td><td><input type=\"submit\" value=\"Add Board\"></form></td>";\r
        content+="</tr>";\r
 \r
-       content+="<tr><td colspan=\"3\"><hr><form name=\"frmboards\" method=\"POST\"><input type=\"hidden\" name=\"formaction\" value=\"update\"></td></tr>";\r
+       content+="<tr><td colspan=\"4\"><hr><form name=\"frmboards\" method=\"POST\"><input type=\"hidden\" name=\"formaction\" value=\"update\"></td></tr>";\r
        content+="<tr>";\r
-       content+="<th>Name</th><th>Description</th><th>Save Received Messages *</th>";\r
+       content+="<th>Name</th><th>Description</th><th>Save Received Messages *</th><th>Added Method</th>";\r
        content+="</tr>";       \r
        while(st.RowReturned() && rownum<rowsperpage)\r
        {\r
@@ -197,11 +198,13 @@ const std::string BoardsPage::GeneratePage(const std::string &method, const std:
                std::string boardname="";\r
                std::string boarddescription="";\r
                std::string savereceivedmessages="";\r
+               std::string addedmethod="";\r
 \r
                st.ResultText(0,boardidstr);\r
                st.ResultText(1,boardname);\r
                st.ResultText(2,boarddescription);\r
                st.ResultText(3,savereceivedmessages);\r
+               st.ResultText(4,addedmethod);\r
 \r
                StringFunctions::Convert(rownum,rownumstr);\r
 \r
@@ -219,6 +222,7 @@ const std::string BoardsPage::GeneratePage(const std::string &method, const std:
                }\r
                content+=">";\r
                content+="</td>";\r
+               content+="<td class=\"smaller\">"+SanitizeOutput(addedmethod)+"</td>";\r
                content+="</tr>\r\n";\r
                st.Step();\r
                rownum++;\r
@@ -238,7 +242,7 @@ const std::string BoardsPage::GeneratePage(const std::string &method, const std:
                }\r
                if(startrow+rowsperpage<boardcount)\r
                {\r
-                       while(cols<2)\r
+                       while(cols<3)\r
                        {\r
                                content+="<td></td>";\r
                                cols++;\r
@@ -249,7 +253,7 @@ const std::string BoardsPage::GeneratePage(const std::string &method, const std:
        }\r
 \r
        content+="<tr>";\r
-       content+="<td colspan=\"3\"><center><input type=\"submit\" value=\"Update\"></center></form></td>";\r
+       content+="<td colspan=\"4\"><center><input type=\"submit\" value=\"Update\"></center></form></td>";\r
        content+="</tr>";\r
        content+="</table>";\r
        content+="<p class=\"paragraph\">";\r