X-Git-Url: https://git.pterodactylus.net/?a=blobdiff_plain;f=src%2Fhttp%2Fpages%2Fboardspage.cpp;h=397aefac09470b2af4bd2598d9aec268e48e50fb;hb=221236a4d3aac4144529d418ce368db5c98facb0;hp=8d10aa64586b9887e71f96d62d1af6d9259e4973;hpb=ee580d19b7920904587e18d72a3465d52eab6204;p=fms.git

diff --git a/src/http/pages/boardspage.cpp b/src/http/pages/boardspage.cpp
index 8d10aa6..397aefa 100644
--- a/src/http/pages/boardspage.cpp
+++ b/src/http/pages/boardspage.cpp
@@ -1,6 +1,8 @@
 #include "../../../include/http/pages/boardspage.h"
 #include "../../../include/stringfunctions.h"
-#include "../../../include/datetime.h"
+
+#include <Poco/DateTime.h>
+#include <Poco/DateTimeFormatter.h>
 
 #ifdef XMEM
 	#include <xmem.h>
@@ -41,26 +43,31 @@ const std::string BoardsPage::GeneratePage(const std::string &method, const std:
 	std::string startrowstr="0";
 	std::string boardsearch="";
 	std::string sql="";
-	DateTime now;
-	now.SetToGMTime();
+	Poco::DateTime now;
 
 	if(queryvars.find("formaction")!=queryvars.end())
 	{
-		if((*queryvars.find("formaction")).second=="addboard" && queryvars.find("boardname")!=queryvars.end() && queryvars.find("boarddescription")!=queryvars.end())
+		if((*queryvars.find("formaction")).second=="addboard" && queryvars.find("boardname")!=queryvars.end() && queryvars.find("boarddescription")!=queryvars.end() && ValidateFormPassword(queryvars))
 		{
 			std::string boardname="";
 			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(?,?,?);");
+			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(2,Poco::DateTimeFormatter::format(now,"%Y-%m-%d %H:%M:%S"));
+			addst.Bind(3,"Added manually");
 			addst.Step();
 		}
-		if((*queryvars.find("formaction")).second=="update")
+		if((*queryvars.find("formaction")).second=="remove0messages" && ValidateFormPassword(queryvars))
+		{
+			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" && ValidateFormPassword(queryvars))
 		{
 			int boardid;
 			std::vector<std::string> boardids;
@@ -68,23 +75,29 @@ const std::string BoardsPage::GeneratePage(const std::string &method, const std:
 			std::vector<std::string> descriptions;
 			std::vector<std::string> oldsavemessages;
 			std::vector<std::string> savemessages;
+			std::vector<std::string> oldforums;
+			std::vector<std::string> forums;
 
 			CreateArgArray(queryvars,"boardid",boardids);
 			CreateArgArray(queryvars,"oldboarddescription",olddescriptions);
 			CreateArgArray(queryvars,"boarddescription",descriptions);
 			CreateArgArray(queryvars,"oldsavereceivedmessages",oldsavemessages);
 			CreateArgArray(queryvars,"savereceivedmessages",savemessages);
+			CreateArgArray(queryvars,"oldforum",oldforums);
+			CreateArgArray(queryvars,"forum",forums);
 
 			olddescriptions.resize(boardids.size(),"");
 			descriptions.resize(boardids.size(),"");
 			oldsavemessages.resize(boardids.size(),"");
 			savemessages.resize(boardids.size(),"");
+			oldforums.resize(boardids.size(),"");
+			forums.resize(boardids.size(),"");
 
-			SQLite3DB::Statement updatest=m_db->Prepare("UPDATE tblBoard SET BoardDescription=?, SaveReceivedMessages=? WHERE BoardID=?;");
+			SQLite3DB::Statement updatest=m_db->Prepare("UPDATE tblBoard SET BoardDescription=?, SaveReceivedMessages=?, Forum=? WHERE BoardID=?;");
 			
 			for(int i=0; i<boardids.size(); i++)
 			{
-				if(olddescriptions[i]!=descriptions[i] || oldsavemessages[i]!=savemessages[i])
+				if(olddescriptions[i]!=descriptions[i] || oldsavemessages[i]!=savemessages[i] || oldforums[i]!=forums[i])
 				{
 					updatest.Bind(0,descriptions[i]);
 					if(savemessages[i]!="true")
@@ -95,9 +108,17 @@ const std::string BoardsPage::GeneratePage(const std::string &method, const std:
 					{
 						updatest.Bind(1,"true");
 					}
+					if(forums[i]!="true")
+					{
+						updatest.Bind(2,"false");
+					}
+					else
+					{
+						updatest.Bind(2,"true");
+					}
 					boardid=0;
 					StringFunctions::Convert(boardids[i],boardid);
-					updatest.Bind(2,boardid);
+					updatest.Bind(3,boardid);
 					updatest.Step();
 					updatest.Reset();
 				}
@@ -147,7 +168,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,Forum FROM tblBoard WHERE BoardID NOT IN (SELECT BoardID FROM tblAdministrationBoard)";
 	if(boardsearch!="")
 	{
 		sql+=" AND (BoardName LIKE '%' || ? || '%' OR BoardDescription LIKE '%' || ? || '%')";
@@ -163,21 +184,27 @@ const std::string BoardsPage::GeneratePage(const std::string &method, const std:
 	}
 	st.Step();
 
-	content+="<table>";
+	content+="<table class=\"small90\">";
 
 	content+="<tr>";
 	content+="<td colspan=\"3\"><center>";
-	content+="<form name=\"frmboardsearch\" action=\"boards.htm\" method=\"POST\"><input type=\"text\" name=\"boardsearch\" value=\""+SanitizeOutput(boardsearch)+"\"><input type=\"submit\" value=\"Search\"></form>";
+	content+="<form name=\"frmboardsearch\" action=\"boards.htm\" method=\"POST\"><input type=\"text\" name=\"boardsearch\" value=\""+SanitizeOutput(boardsearch)+"\">"+CreateFormPassword()+"<input type=\"submit\" value=\"Search\"></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\"></td><td><input type=\"submit\" value=\"Add Board\"></form></td>";
+	content+="<td colspan=\"3\"><center>";
+	content+="<form name=\"frmremoveboard\" action=\"boards.htm\" method=\"POST\">"+CreateFormPassword()+"<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><td colspan=\"3\"><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+="<td><form name=\"frmaddboard\" method=\"POST\">"+CreateFormPassword()+"<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=\"4\"><hr><form name=\"frmboards\" method=\"POST\"><input type=\"hidden\" name=\"formaction\" value=\"update\">"+CreateFormPassword()+"</td></tr>";
+	content+="<tr>";
+	content+="<th>Name</th><th>Description</th><th>Save Received Messages *</th><th>Forum</th><th>Added Method</th>";
 	content+="</tr>";	
 	while(st.RowReturned() && rownum<rowsperpage)
 	{
@@ -186,11 +213,15 @@ const std::string BoardsPage::GeneratePage(const std::string &method, const std:
 		std::string boardname="";
 		std::string boarddescription="";
 		std::string savereceivedmessages="";
+		std::string addedmethod="";
+		std::string forum="";
 
 		st.ResultText(0,boardidstr);
 		st.ResultText(1,boardname);
 		st.ResultText(2,boarddescription);
 		st.ResultText(3,savereceivedmessages);
+		st.ResultText(4,addedmethod);
+		st.ResultText(5,forum);
 
 		StringFunctions::Convert(rownum,rownumstr);
 
@@ -198,7 +229,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\"";
@@ -208,6 +239,16 @@ const std::string BoardsPage::GeneratePage(const std::string &method, const std:
 		}
 		content+=">";
 		content+="</td>";
+		content+="<td>";
+		content+="<input type=\"hidden\" name=\"oldforum["+rownumstr+"]\" value=\""+forum+"\">";
+		content+="<input type=\"checkbox\" name=\"forum["+rownumstr+"]\" value=\"true\"";
+		if(forum=="true")
+		{
+			content+=" CHECKED";
+		}
+		content+=">";
+		content+="</td>";
+		content+="<td>"+SanitizeOutput(addedmethod)+"</td>";
 		content+="</tr>\r\n";
 		st.Step();
 		rownum++;
@@ -222,27 +263,30 @@ const std::string BoardsPage::GeneratePage(const std::string &method, const std:
 		if(startrow>0)
 		{
 			StringFunctions::Convert(startrow-rowsperpage,tempstr);
-			content+="<td colspan=\"1\" align=\"left\"><a href=\"boards.htm?"+BuildQueryString(startrow-rowsperpage,boardsearch)+"\"><-- Previous Page</a></td>";
-			cols+=1;
+			content+="<td colspan=\"2\" style=\"text-align:left;\"><a href=\"boards.htm?"+BuildQueryString(startrow-rowsperpage,boardsearch)+"\"><-- Previous Page</a></td>";
+			cols+=2;
 		}
 		if(startrow+rowsperpage<boardcount)
 		{
-			while(cols<2)
+			while(cols<4)
 			{
 				content+="<td></td>";
 				cols++;
 			}
-			content+="<td colspan=\"1\" align=\"right\"><a href=\"boards.htm?"+BuildQueryString(startrow+rowsperpage,boardsearch)+"\">Next Page --></a></td>";
+			content+="<td colspan=\"1\" style=\"text-align:left;\"><a href=\"boards.htm?"+BuildQueryString(startrow+rowsperpage,boardsearch)+"\">Next Page --></a></td>";
 		}
 		content+="</tr>";
 	}
 
 	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\">";
+	content+="* If you uncheck this box, any new messages you download that are posted to this board will be discarded.  When multiple local identities are used, it is best not to discard messages from any boards, as identifying which identities are the same person is much easier when their message lists are missing messages from the same boards.";
+	content+="</p>";
 
-	return "HTTP/1.1 200 OK\r\nContent-Type: text/html\r\n\r\n"+StringFunctions::Replace(m_template,"[CONTENT]",content);
+	return StringFunctions::Replace(m_template,"[CONTENT]",content);
 }
 
 const bool BoardsPage::WillHandleURI(const std::string &uri)