X-Git-Url: https://git.pterodactylus.net/?a=blobdiff_plain;f=src%2Fhttp%2Fpages%2Fboardspage.cpp;h=dce33b81d19ac6cf99945b7bf9b9d8c2cee161ff;hb=5c0453c8697cfaa843dd7f799e5404733ee56e13;hp=8d10aa64586b9887e71f96d62d1af6d9259e4973;hpb=ee580d19b7920904587e18d72a3465d52eab6204;p=fms.git diff --git a/src/http/pages/boardspage.cpp b/src/http/pages/boardspage.cpp index 8d10aa6..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,12 +177,18 @@ const std::string BoardsPage::GeneratePage(const std::string &method, const std: content+=""; content+=""; - content+="
"; + content+="
"; + content+="
Remove boards with 0 messages
"; + content+="
"; + content+=""; + + content+=""; + content+="
"; content+=""; content+="
"; content+=""; - content+="NameDescriptionSave Received Messages"; + content+="NameDescriptionSave Received Messages *"; content+=""; while(st.RowReturned() && rownum"; content+=""; content+=""; - content+=""; + content+=""; content+=""; content+=""; content+="
"; content+=""; content+=""; + content+="

"; + content+="* If you uncheck this box, any new messages you download that are posted to this board will be discarded."; + content+="

"; return "HTTP/1.1 200 OK\r\nContent-Type: text/html\r\n\r\n"+StringFunctions::Replace(m_template,"[CONTENT]",content); }