X-Git-Url: https://git.pterodactylus.net/?a=blobdiff_plain;f=src%2Fhttp%2Fpages%2Fboardspage.cpp;h=4adab89bd6fe0f3f4f14e1b8bbd005188aeeda94;hb=0236076defe60bcd4b3a25c23efa53c21993a48e;hp=ed8d46965d390ebd3e6d3e552c41dc852da9b40e;hpb=8a0a83a78390f22f99d4487cda2569909dfbc28e;p=fms.git

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