1 #include "../../../include/http/pages/forumviewthreadpage.h"
\r
2 #include "../../../include/stringfunctions.h"
\r
3 #include "../../../include/unicode/unicodeformatter.h"
\r
9 const std::string ForumViewThreadPage::FixBody(const std::string &body)
\r
11 std::string output=body;
\r
13 output=StringFunctions::Replace(output,"\r\n","\n");
\r
15 UnicodeFormatter::LineWrap(output,80,"",output);
\r
17 output=StringFunctions::Replace(output,"<","<");
\r
18 output=StringFunctions::Replace(output,">",">");
\r
19 output=StringFunctions::Replace(output,"\n","<br />");
\r
23 const std::string ForumViewThreadPage::GeneratePage(const std::string &method, const std::map<std::string,std::string> &queryvars)
\r
25 std::string content="";
\r
26 std::string threadidstr="";
\r
27 std::string boardidstr="";
\r
28 std::string currentpagestr="";
\r
29 std::string boardname="";
\r
30 std::string firstunreadidstr="";
\r
32 if(queryvars.find("threadid")!=queryvars.end())
\r
34 threadidstr=(*queryvars.find("threadid")).second;
\r
36 if(queryvars.find("currentpage")!=queryvars.end())
\r
38 currentpagestr=(*queryvars.find("currentpage")).second;
\r
40 if(queryvars.find("boardid")!=queryvars.end())
\r
42 boardidstr=(*queryvars.find("boardid")).second;
\r
45 content+=CreateForumHeader();
\r
47 SQLite3DB::Statement firstunreadst=m_db->Prepare("SELECT tblMessage.MessageID FROM tblThreadPost INNER JOIN tblMessage ON tblThreadPost.MessageID=tblMessage.MessageID WHERE ThreadID=? AND tblMessage.Read=0;");
\r
48 firstunreadst.Bind(0,threadidstr);
\r
49 firstunreadst.Step();
\r
50 if(firstunreadst.RowReturned())
\r
52 firstunreadst.ResultText(0,firstunreadidstr);
\r
55 if(queryvars.find("formaction")!=queryvars.end() && (*queryvars.find("formaction")).second=="markunread")
\r
57 SQLite3DB::Statement updateread=m_db->Prepare("UPDATE tblMessage SET Read=0 WHERE tblMessage.MessageID IN (SELECT MessageID FROM tblThreadPost WHERE ThreadID=?);");
\r
58 updateread.Bind(0,threadidstr);
\r
63 SQLite3DB::Statement updateread=m_db->Prepare("UPDATE tblMessage SET Read=1 WHERE tblMessage.MessageID IN (SELECT MessageID FROM tblThreadPost WHERE ThreadID=?);");
\r
64 updateread.Bind(0,threadidstr);
\r
68 SQLite3DB::Statement trustst=m_db->Prepare("SELECT LocalMessageTrust, LocalTrustListTrust, PeerMessageTrust, PeerTrustListTrust, Name FROM tblIdentity WHERE IdentityID=?;");
\r
70 SQLite3DB::Statement boardnamest=m_db->Prepare("SELECT tblBoard.BoardName FROM tblBoard INNER JOIN tblThread ON tblBoard.BoardID=tblThread.BoardID WHERE tblThread.ThreadID=?;");
\r
71 boardnamest.Bind(0,threadidstr);
\r
74 if(boardnamest.RowReturned())
\r
76 boardnamest.ResultText(0,boardname);
\r
79 content+="<table class=\"forumheader\">";
\r
81 content+="<td> Forum : <a href=\"forumthreads.htm?boardid="+boardidstr+"¤tpage="+currentpagestr+"\">"+SanitizeOutput(boardname)+"</a></td>";
\r
82 if(firstunreadidstr!="")
\r
85 content+="<a href=\"#"+firstunreadidstr+"\">First Unread Message</a>";
\r
89 content+="<a href=\""+m_pagename+"?formaction=markunread&threadid="+threadidstr+"&boardid="+boardidstr+"¤tpage="+currentpagestr+"\">Mark Unread</a>";
\r
92 content+="</table>\r\n";
\r
94 SQLite3DB::Statement st=m_db->Prepare("SELECT tblMessage.MessageID, tblMessage.IdentityID, tblMessage.FromName, tblMessage.Subject, tblMessage.MessageDate || ' ' || tblMessage.MessageTime, tblMessage.Body FROM tblMessage INNER JOIN tblThreadPost ON tblMessage.MessageID=tblThreadPost.MessageID WHERE tblThreadPost.ThreadID=? ORDER BY tblThreadPost.PostOrder;");
\r
95 st.Bind(0,threadidstr);
\r
97 content+="<table class=\"thread\">";
\r
99 while(st.RowReturned())
\r
101 std::string messageidstr="";
\r
102 std::string identityidstr="";
\r
103 std::string fromname="";
\r
104 std::string subject="";
\r
105 std::string datetime="";
\r
106 std::string body="";
\r
108 st.ResultText(0,messageidstr);
\r
109 st.ResultText(1,identityidstr);
\r
110 st.ResultText(2,fromname);
\r
111 st.ResultText(3,subject);
\r
112 st.ResultText(4,datetime);
\r
113 st.ResultText(5,body);
\r
116 content+="<td rowspan=\"2\" class=\"from\">";
\r
117 content+="<a name=\""+messageidstr+"\"></a>";
\r
118 content+="<a href=\"peerdetails.htm?identityid="+identityidstr+"\">"+FixFromName(fromname)+"</a><br />";
\r
120 trustst.Bind(0,identityidstr);
\r
122 if(trustst.RowReturned())
\r
124 std::string localmessagetrust="";
\r
125 std::string localtrustlisttrust="";
\r
126 std::string peermessagetrust="";
\r
127 std::string peertrustlisttrust="";
\r
128 std::string name="";
\r
130 trustst.ResultText(0,localmessagetrust);
\r
131 trustst.ResultText(1,localtrustlisttrust);
\r
132 trustst.ResultText(2,peermessagetrust);
\r
133 trustst.ResultText(3,peertrustlisttrust);
\r
134 trustst.ResultText(4,name);
\r
136 content+="<table class=\"trust\">";
\r
138 content+="<td colspan=\"3\" style=\"text-align:center;\"><a href=\"peertrust.htm?namesearch="+StringFunctions::UriEncode(name)+"\">Trust</a></td>";
\r
141 content+="<td></td><td>Local</td><td>Peer</td>";
\r
144 content+="<td>Message</td><td>"+localmessagetrust+"</td><td>"+peermessagetrust+"</td>";
\r
147 content+="<td>Trust List</td><td>"+localtrustlisttrust+"</td><td>"+peertrustlisttrust+"</td>";
\r
149 content+="</table>";
\r
153 content+="<td class=\"subject\">";
\r
154 content+=SanitizeOutput(subject)+" on "+datetime;
\r
156 content+="<td><a href=\"forumcreatepost.htm?replytomessageid="+messageidstr+"&threadid="+threadidstr+"&boardid="+boardidstr+"¤tpage="+currentpagestr+"\">Reply</a></td>";
\r
157 content+="</tr>\r\n";
\r
159 content+="<td class=\"body\" colspan=\"2\">";
\r
160 content+=FixBody(body);
\r
167 content+="</table>";
\r
169 return StringFunctions::Replace(m_template,"[CONTENT]",content);
\r