X-Git-Url: https://git.pterodactylus.net/?p=fms.git;a=blobdiff_plain;f=src%2Fboard.cpp;h=aee9339f4054bf6f4f20fdf2925e8247aac0b60c;hp=e256dcbb608823bd63266e6964a1e6c4c43b4dc6;hb=4430e7762844c66428b6f822288beb71b7f82b95;hpb=ee580d19b7920904587e18d72a3465d52eab6204

diff --git a/src/board.cpp b/src/board.cpp
index e256dcb..aee9339 100644
--- a/src/board.cpp
+++ b/src/board.cpp
@@ -14,6 +14,7 @@ Board::Board()
 	m_lowmessageid=0;
 	m_highmessageid=0;
 	m_messagecount=0;
+	m_savereceivedmessages=true;
 }
 
 Board::Board(const long boardid)
@@ -26,6 +27,21 @@ Board::Board(const std::string &boardname)
 	Load(boardname);
 }
 
+Board::Board(const long boardid, const std::string &boardname, const std::string &boarddescription, const std::string datecreated, const long lowmessageid, const long highmessageid, const long messagecount, const bool savereceivedmessages)
+{
+	m_boardid=boardid;
+	m_boardname=boardname;
+	m_boarddescription=boarddescription;
+	m_lowmessageid=lowmessageid;
+	m_highmessageid=highmessageid;
+	m_messagecount=messagecount;
+	m_savereceivedmessages=savereceivedmessages;
+
+	SetDateFromString(datecreated);
+
+}
+
+
 const bool Board::Load(const long boardid)
 {
 	// clear current values
@@ -37,7 +53,7 @@ const bool Board::Load(const long boardid)
 	m_highmessageid=0;
 	m_messagecount=0;
 
-	SQLite3DB::Statement st=m_db->Prepare("SELECT BoardName, BoardDescription, DateAdded FROM tblBoard WHERE BoardID=?;");
+	SQLite3DB::Statement st=m_db->Prepare("SELECT BoardName, BoardDescription, DateAdded, HighMessageID, LowMessageID, MessageCount, SaveReceivedMessages FROM tblBoard LEFT JOIN vwBoardStats ON tblBoard.BoardID=vwBoardStats.BoardID WHERE tblBoard.BoardID=?;");
 	st.Bind(0,boardid);
 	st.Step();
 
@@ -52,53 +68,25 @@ const bool Board::Load(const long boardid)
 		st.ResultText(1,m_boarddescription);
 		st.ResultText(2,tempstr);
 
-		// break out date created  - date should be in format yyyy-mm-dd HH:MM:SS, so we split on "-", " " (space), and ":"
-		StringFunctions::SplitMultiple(tempstr,"- :",dateparts);
-		if(dateparts.size()>0)
-		{
-			StringFunctions::Convert(dateparts[0],tempint);
-			m_datecreated.SetYear(tempint);
-		}
-		if(dateparts.size()>1)
-		{
-			StringFunctions::Convert(dateparts[1],tempint);
-			m_datecreated.SetMonth(tempint);
-		}
-		if(dateparts.size()>2)
-		{
-			StringFunctions::Convert(dateparts[2],tempint);
-			m_datecreated.SetDay(tempint);
-		}
-		if(dateparts.size()>3)
-		{
-			StringFunctions::Convert(dateparts[3],tempint);
-			m_datecreated.SetHour(tempint);
-		}
-		if(dateparts.size()>4)
-		{
-			StringFunctions::Convert(dateparts[4],tempint);
-			m_datecreated.SetMinute(tempint);
-		}
-		if(dateparts.size()>5)
+		SetDateFromString(tempstr);
+
+		tempint=0;
+		st.ResultInt(3,tempint);
+		m_highmessageid=tempint;
+		tempint=0;
+		st.ResultInt(4,tempint);
+		m_lowmessageid=tempint;
+		tempint=0;
+		st.ResultInt(5,tempint);
+		m_messagecount=tempint;
+		st.ResultText(6,tempstr);
+		if(tempstr=="true")
 		{
-			StringFunctions::Convert(dateparts[5],tempint);
-			m_datecreated.SetSecond(tempint);
+			m_savereceivedmessages=true;
 		}
-
-		// get max and min ids and message count in this board
-		SQLite3DB::Statement bounds=m_db->Prepare("SELECT HighMessageID, LowMessageID, MessageCount FROM vwBoardStats WHERE BoardID=?;");
-		bounds.Bind(0,boardid);
-		bounds.Step();
-
-		if(bounds.RowReturned())
+		else
 		{
-			int tempint;
-			bounds.ResultInt(0,tempint);
-			m_highmessageid=tempint;
-			bounds.ResultInt(1,tempint);
-			m_lowmessageid=tempint;
-			bounds.ResultInt(2,tempint);
-			m_messagecount=tempint;
+			m_savereceivedmessages=false;
 		}
 
 		return true;
@@ -125,3 +113,41 @@ const bool Board::Load(const std::string &boardname)
 		return false;
 	}
 }
+
+void Board::SetDateFromString(const std::string &datestring)
+{
+	// break out date created  - date should be in format yyyy-mm-dd HH:MM:SS, so we split on "-", " " (space), and ":"
+	int tempint=0;
+	std::vector<std::string> dateparts;
+	StringFunctions::SplitMultiple(datestring,"- :",dateparts);
+	if(dateparts.size()>0)
+	{
+		StringFunctions::Convert(dateparts[0],tempint);
+		m_datecreated.SetYear(tempint);
+	}
+	if(dateparts.size()>1)
+	{
+		StringFunctions::Convert(dateparts[1],tempint);
+		m_datecreated.SetMonth(tempint);
+	}
+	if(dateparts.size()>2)
+	{
+		StringFunctions::Convert(dateparts[2],tempint);
+		m_datecreated.SetDay(tempint);
+	}
+	if(dateparts.size()>3)
+	{
+		StringFunctions::Convert(dateparts[3],tempint);
+		m_datecreated.SetHour(tempint);
+	}
+	if(dateparts.size()>4)
+	{
+		StringFunctions::Convert(dateparts[4],tempint);
+		m_datecreated.SetMinute(tempint);
+	}
+	if(dateparts.size()>5)
+	{
+		StringFunctions::Convert(dateparts[5],tempint);
+		m_datecreated.SetSecond(tempint);
+	}
+}