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

diff --git a/src/http/pages/boardspage.cpp b/src/http/pages/boardspage.cpp
index f143d32..dce33b8 100644
--- 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="";
 
 			boardname=(*queryvars.find("boardname")).second;
+			StringFunctions::LowerCase(boardname,boardname);
 			boarddescription=(*queryvars.find("boarddescription")).second;
 
 			SQLite3DB::Statement addst=m_db->Prepare("INSERT INTO tblBoard(BoardName,BoardDescription,DateAdded) VALUES(?,?,?);");
@@ -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"));
 			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;
@@ -172,7 +177,13 @@ const std::string BoardsPage::GeneratePage(const std::string &method, const std:
 	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\"></td><td><input type=\"submit\" value=\"Add Board\"></form></td>";
+	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>";
 
 	content+="<tr><td colspan=\"3\"><hr><form name=\"frmboards\" method=\"POST\"><input type=\"hidden\" name=\"formaction\" value=\"update\"></td></tr>";
@@ -198,7 +209,7 @@ const std::string BoardsPage::GeneratePage(const std::string &method, const std:
 		content+="<td>"+SanitizeOutput(boardname)+"</td>";
 		content+="<td><input type=\"hidden\" name=\"boardid["+rownumstr+"]\" value=\""+boardidstr+"\">";
 		content+="<input type=\"hidden\" name=\"oldboarddescription["+rownumstr+"]\" value=\""+StringFunctions::Replace(SanitizeOutput(boarddescription),"&nbsp;"," ")+"\">";
-		content+="<input type=\"text\" name=\"boarddescription["+rownumstr+"]\" value=\""+SanitizeOutput(boarddescription)+"\" size=\"40\"></td>";
+		content+="<input type=\"text\" name=\"boarddescription["+rownumstr+"]\" value=\""+SanitizeOutput(boarddescription)+"\" size=\"40\" maxlength=\"50\"></td>";
 		content+="<td>";
 		content+="<input type=\"hidden\" name=\"oldsavereceivedmessages["+rownumstr+"]\" value=\""+savereceivedmessages+"\">";
 		content+="<input type=\"checkbox\" name=\"savereceivedmessages["+rownumstr+"]\" value=\"true\"";