version 0.2.4

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

diff --git a/src/http/pages/boardspage.cpp b/src/http/pages/boardspage.cpp
index af3baad..ed8d469 100644 (file)
--- a/src/http/pages/boardspage.cpp
+++ b/src/http/pages/boardspage.cpp
@@ -61,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);");\r
+               }\r
                if((*queryvars.find("formaction")).second=="update")\r
                {\r
                        int boardid;\r
@@ -173,6 +177,12 @@ const std::string BoardsPage::GeneratePage(const std::string &method, const std:
        content+="</tr>";\r
 \r
        content+="<tr>";\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