version 0.2.5

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

diff --git a/src/http/pages/boardspage.cpp b/src/http/pages/boardspage.cpp
index 8d10aa6..dce33b8 100644 (file)
--- a/src/http/pages/boardspage.cpp
+++ b/src/http/pages/boardspage.cpp
@@ -52,6 +52,7 @@ const std::string BoardsPage::GeneratePage(const std::string &method, const std:
                        std::string boarddescription="";\r
 \r
                        boardname=(*queryvars.find("boardname")).second;\r
+                       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
@@ -60,6 +61,10 @@ const std::string BoardsPage::GeneratePage(const std::string &method, const std:
                        addst.Bind(2,now.Format("%Y-%m-%d %H:%M:%S"));\r
                        addst.Step();\r
                }\r
+               if((*queryvars.find("formaction")).second=="remove0messages")\r
+               {\r
+                       m_db->Execute("DELETE FROM tblBoard WHERE BoardID IN (SELECT BoardID FROM vwBoardStats WHERE MessageCount=0 AND BoardID NOT IN (SELECT BoardID FROM tblAdministrationBoard));");\r
+               }\r
                if((*queryvars.find("formaction")).second=="update")\r
                {\r
                        int boardid;\r
@@ -172,12 +177,18 @@ const std::string BoardsPage::GeneratePage(const std::string &method, const std:
        content+="</tr>";\r
 \r
        content+="<tr>";\r
-       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\"></td><td><input type=\"submit\" value=\"Add Board\"></form></td>";\r
+       content+="<td colspan=\"3\"><center>";\r
+       content+="<form name=\"frmremoveboard\" action=\"boards.htm\" method=\"POST\"><input type=\"hidden\" name=\"formaction\" value=\"remove0messages\">Remove boards with 0 messages<input type=\"submit\" value=\"Remove\"></form>";\r
+       content+="</center></td>";\r
+       content+="</tr>";\r
+\r
+       content+="<tr>";\r
+       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>";\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>";\r
        content+="</tr>";       \r
        while(st.RowReturned() && rownum<rowsperpage)\r
        {\r
@@ -198,7 +209,7 @@ const std::string BoardsPage::GeneratePage(const std::string &method, const std:
                content+="<td>"+SanitizeOutput(boardname)+"</td>";\r
                content+="<td><input type=\"hidden\" name=\"boardid["+rownumstr+"]\" value=\""+boardidstr+"\">";\r
                content+="<input type=\"hidden\" name=\"oldboarddescription["+rownumstr+"]\" value=\""+StringFunctions::Replace(SanitizeOutput(boarddescription),"&nbsp;"," ")+"\">";\r
-               content+="<input type=\"text\" name=\"boarddescription["+rownumstr+"]\" value=\""+SanitizeOutput(boarddescription)+"\" size=\"40\"></td>";\r
+               content+="<input type=\"text\" name=\"boarddescription["+rownumstr+"]\" value=\""+SanitizeOutput(boarddescription)+"\" size=\"40\" maxlength=\"50\"></td>";\r
                content+="<td>";\r
                content+="<input type=\"hidden\" name=\"oldsavereceivedmessages["+rownumstr+"]\" value=\""+savereceivedmessages+"\">";\r
                content+="<input type=\"checkbox\" name=\"savereceivedmessages["+rownumstr+"]\" value=\"true\"";\r
@@ -241,6 +252,9 @@ const std::string BoardsPage::GeneratePage(const std::string &method, const std:
        content+="<td colspan=\"3\"><center><input type=\"submit\" value=\"Update\"></center></form></td>";\r
        content+="</tr>";\r
        content+="</table>";\r
+       content+="<p class=\"paragraph\">";\r
+       content+="* If you uncheck this box, any new messages you download that are posted to this board will be discarded.";\r
+       content+="</p>";\r
 \r
        return "HTTP/1.1 200 OK\r\nContent-Type: text/html\r\n\r\n"+StringFunctions::Replace(m_template,"[CONTENT]",content);\r
 }\r