X-Git-Url: https://git.pterodactylus.net/?a=blobdiff_plain;f=src%2Fhttp%2Fpages%2Fboardspage.cpp;h=dce33b81d19ac6cf99945b7bf9b9d8c2cee161ff;hb=5c0453c8697cfaa843dd7f799e5404733ee56e13;hp=af3baad0f5c5194a12c95a70b4098b92c5732603;hpb=befd91205eff729a182f66de15374a577a8718f7;p=fms.git

diff --git a/src/http/pages/boardspage.cpp b/src/http/pages/boardspage.cpp
index af3baad..dce33b8 100644
--- 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"));
 			addst.Step();
 		}
+		if((*queryvars.find("formaction")).second=="remove0messages")
+		{
+			m_db->Execute("DELETE FROM tblBoard WHERE BoardID IN (SELECT BoardID FROM vwBoardStats WHERE MessageCount=0 AND BoardID NOT IN (SELECT BoardID FROM tblAdministrationBoard));");
+		}
 		if((*queryvars.find("formaction")).second=="update")
 		{
 			int boardid;
@@ -173,6 +177,12 @@ const std::string BoardsPage::GeneratePage(const std::string &method, const std:
 	content+="</tr>";
 
 	content+="<tr>";
+	content+="<td colspan=\"3\"><center>";
+	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>";
+	content+="</center></td>";
+	content+="</tr>";
+
+	content+="<tr>";
 	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>";
 	content+="</tr>";