X-Git-Url: https://git.pterodactylus.net/?p=fms.git;a=blobdiff_plain;f=src%2Fhttp%2Fpages%2Fboardspage.cpp;h=ed8d46965d390ebd3e6d3e552c41dc852da9b40e;hp=af3baad0f5c5194a12c95a70b4098b92c5732603;hb=8a0a83a78390f22f99d4487cda2569909dfbc28e;hpb=a007770a843aa759763b98288c9432c3906ce5c6 diff --git a/src/http/pages/boardspage.cpp b/src/http/pages/boardspage.cpp index af3baad..ed8d469 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);"); + } if((*queryvars.find("formaction")).second=="update") { int boardid; @@ -173,6 +177,12 @@ const std::string BoardsPage::GeneratePage(const std::string &method, const std: content+=""; content+=""; + content+="
"; + content+="
Remove boards with 0 messages
"; + content+="
"; + content+=""; + + content+=""; content+="
"; content+="";