const std::string ForumTemplateViewThreadPage::GenerateContent(const std::string &method, const std::map<std::string,QueryVar> &queryvars)
{
int postcount=0;
std::string fproxyprotocol("");
std::string fproxyhost("");
std::string fproxyport("");
std::string maincontent("");
std::string result("");
std::map<std::string,std::string> vars;
std::vector<std::pair<std::string,std::string> > breadcrumblinks;
std::string threadidstr("");
std::string boardidstr("");
std::string pagestr("");
std::string boardname("");
std::string firstunreadidstr("");
std::string threadpostrowodd("");
std::string threadpostroweven("");
std::string postrows("");
std::string threadpostattachment("");
std::string postattachments("");
std::string trusttable("");
bool showsignatures=false;
bool showavatars=false;
SQLite3DB::Transaction trans(m_db);
Option opt(m_db);
std::vector<std::string> skipspace;
SQLite3DB::Statement fileattachmentst=m_db->Prepare("SELECT Key, Size FROM tblMessageFileAttachment WHERE MessageID=?;");
SQLite3DB::Statement truststpeeronly=m_db->Prepare("SELECT PeerMessageTrust, PeerTrustListTrust FROM tblIdentity WHERE IdentityID=?;");
SQLite3DB::Statement truststboth=m_db->Prepare("SELECT tblIdentityTrust.LocalMessageTrust, tblIdentity.PeerMessageTrust, tblIdentityTrust.LocalTrustListTrust, tblIdentity.PeerTrustListTrust FROM tblIdentity LEFT JOIN tblIdentityTrust ON tblIdentity.IdentityID=tblIdentityTrust.IdentityID WHERE tblIdentity.IdentityID=? AND tblIdentityTrust.LocalIdentityID=?;");
opt.GetBool("ForumShowSignatures",showsignatures);
opt.GetBool("ForumShowAvatars",showavatars);
opt.Get("FProxyProtocol",fproxyprotocol);
opt.Get("FProxyHost",fproxyhost);
opt.Get("FProxyPort",fproxyport);
skipspace.push_back(" ");
if(queryvars.find("messageuuid")!=queryvars.end())
{
SQLite3DB::Statement st=m_db->Prepare("SELECT tblMessage.MessageID, tblThreadPost.ThreadID, tblThread.BoardID FROM tblMessage LEFT JOIN tblThreadPost ON tblMessage.MessageID=tblThreadPost.MessageID LEFT JOIN tblThread ON tblThreadPost.ThreadID=tblThread.ThreadID WHERE MessageUUID=?;");
st.Bind(0,(*queryvars.find("messageuuid")).second.GetData());
st.Step();
if(st.RowReturned())
{
int messageid=0;
int threadid=0;
int boardid=0;
st.ResultInt(2,boardid);
m_viewstate.SetBoardID(boardid);
if(st.ResultNull(1)==false)
{
st.ResultInt(1,threadid);
m_viewstate.SetThreadID(threadid);
}
else
{
m_viewstate.SetThreadID(0);
}
}
st.Finalize();
}
if(queryvars.find("threadid")!=queryvars.end())
{
int temp=0;
threadidstr=(*queryvars.find("threadid")).second.GetData();
StringFunctions::Convert(threadidstr,temp);
m_viewstate.SetThreadID(temp);
}
else
{
int temp=0;
temp=m_viewstate.GetThreadID();
StringFunctions::Convert(temp,threadidstr);
}
if(queryvars.find("page")!=queryvars.end())
{
pagestr=(*queryvars.find("page")).second.GetData();
int temp=0;
if(StringFunctions::Convert(pagestr,temp)==true)
{
m_viewstate.SetPage(temp);
}
}
else
{
int temp=0;
temp=m_viewstate.GetPage();
StringFunctions::Convert(temp,pagestr);
}
if(queryvars.find("boardid")!=queryvars.end())
{
boardidstr=(*queryvars.find("boardid")).second.GetData();
int temp=0;
if(StringFunctions::Convert(boardidstr,temp)==true)
{
m_viewstate.SetBoardID(temp);
}
}
else
{
int temp=0;
temp=m_viewstate.GetBoardID();
StringFunctions::Convert(temp,boardidstr);
}
// first unread select must come before marking read messages
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;");
firstunreadst.Bind(0,threadidstr);
firstunreadst.Step();
if(firstunreadst.RowReturned())
{
firstunreadst.ResultText(0,firstunreadidstr);
}
firstunreadst.Finalize();
trans.Begin(SQLite3DB::Transaction::TRANS_IMMEDIATE);
if(queryvars.find("formaction")!=queryvars.end() && (*queryvars.find("formaction")).second=="markunread")
{
SQLite3DB::Statement updateread=m_db->Prepare("UPDATE tblMessage SET Read=0 WHERE tblMessage.MessageID IN (SELECT MessageID FROM tblThreadPost WHERE ThreadID=?);");
updateread.Bind(0,threadidstr);
trans.Step(updateread);
}
else
{
SQLite3DB::Statement updateread=m_db->Prepare("UPDATE tblMessage SET Read=1 WHERE tblMessage.MessageID IN (SELECT MessageID FROM tblThreadPost WHERE ThreadID=?);");
updateread.Bind(0,threadidstr);
trans.Step(updateread);
}
trans.Commit();
if(trans.IsSuccessful()==false)
{
m_log->error("ForumTemplateViewThreadPage::GenerateContent transaction failed SQL="+trans.GetErrorSQL()+" Error="+trans.GetLastErrorStr());
}
// add/remove trust
if(queryvars.find("formaction")!=queryvars.end() && (*queryvars.find("formaction")).second.GetData().find("trust")!=std::string::npos && queryvars.find("identityid")!=queryvars.end() && ValidateFormPassword(queryvars))
{
trans.Begin(SQLite3DB::Transaction::TRANS_IMMEDIATE);
SQLite3DB::Statement currenttrustst=m_db->Prepare("SELECT IFNULL(LocalMessageTrust,-1), IFNULL(LocalTrustListTrust,-1) FROM tblIdentityTrust WHERE IdentityID=? AND LocalIdentityID=?;");
SQLite3DB::Statement updatetrustst=m_db->Prepare("UPDATE tblIdentityTrust SET LocalMessageTrust=?, LocalTrustListTrust=? WHERE IdentityID=? AND LocalIdentityID=?;");
currenttrustst.Bind(0,(*queryvars.find("identityid")).second.GetData());
currenttrustst.Bind(1,m_viewstate.GetLocalIdentityID());
trans.Step(currenttrustst);
if(currenttrustst.RowReturned())
{
int localmessagetrust=-1;
int localtrustlisttrust=-1;
currenttrustst.ResultInt(0,localmessagetrust);
currenttrustst.ResultInt(1,localtrustlisttrust);
if((*queryvars.find("formaction")).second=="addmessagetrust")
{
if(localmessagetrust==-1)
{
localmessagetrust=50;
}
localmessagetrust=(std::min)(localmessagetrust+10,100);
}
else if((*queryvars.find("formaction")).second=="removemessagetrust")
{
if(localmessagetrust==-1)
{
localmessagetrust=50;
}
localmessagetrust=(std::max)(localmessagetrust-10,0);
}
else if((*queryvars.find("formaction")).second=="addtrustlisttrust")
{
if(localtrustlisttrust==-1)
{
localtrustlisttrust=50;
}
localtrustlisttrust=(std::min)(localtrustlisttrust+10,100);
}
else if((*queryvars.find("formaction")).second=="removetrustlisttrust")
{
if(localtrustlisttrust==-1)
{
localtrustlisttrust=50;
}
localtrustlisttrust=(std::max)(localtrustlisttrust-10,0);
}
if(localmessagetrust!=-1)
{
updatetrustst.Bind(0,localmessagetrust);
}
else
{
updatetrustst.Bind(0);
}
if(localtrustlisttrust!=-1)
{
updatetrustst.Bind(1,localtrustlisttrust);
}
else
{
updatetrustst.Bind(1);
}
updatetrustst.Bind(2,(*queryvars.find("identityid")).second.GetData());
updatetrustst.Bind(3,m_viewstate.GetLocalIdentityID());
trans.Step(updatetrustst);
}
trans.Finalize(currenttrustst);
trans.Finalize(updatetrustst);
trans.Commit();
if(trans.IsSuccessful()==false)
{
m_log->error("ForumTemplateViewThreadPage::GenerateContent transaction failed SQL="+trans.GetErrorSQL()+" Error="+trans.GetLastErrorStr());
}
}
SQLite3DB::Statement boardnamest=m_db->Prepare("SELECT tblBoard.BoardName FROM tblBoard INNER JOIN tblThread ON tblBoard.BoardID=tblThread.BoardID WHERE tblThread.ThreadID=?;");
boardnamest.Bind(0,threadidstr);
boardnamest.Step();
if(boardnamest.RowReturned())
{
boardnamest.ResultText(0,boardname);
}
boardnamest.Finalize();
breadcrumblinks.push_back(std::pair<std::string,std::string>("forummain.htm?viewstate="+m_viewstate.GetViewStateID(),SanitizeOutput(m_trans->Get("web.navlink.browseforums"))));
breadcrumblinks.push_back(std::pair<std::string,std::string>("forumthreads.htm?viewstate="+m_viewstate.GetViewStateID()+"&boardid="+boardidstr+"&page="+pagestr,SanitizeOutput(boardname)));
if(firstunreadidstr!="")
{
vars["FIRSTUNREADPOSTLINK"]="<a href=\"#"+firstunreadidstr+"\"><img src=\"images/mail_get.png\" border=\"0\" style=\"vertical-align:bottom;\">"+m_trans->Get("web.page.forumviewthread.firstunread")+"</a>";
}
else
{
vars["FIRSTUNREADPOSTLINK"]="";
}
m_templatehandler.GetSection("THREADPOSTATTACHMENT",threadpostattachment);
m_templatehandler.GetSection("TRUSTTABLE",trusttable);
vars["MARKUNREADLINK"]="<a href=\""+m_pagename+"?viewstate="+m_viewstate.GetViewStateID()+"&formaction=markunread&threadid="+threadidstr+"&boardid="+boardidstr+"&page="+pagestr+"\"><img src=\"images/mail_generic.png\" border=\"0\" style=\"vertical-align:bottom;\">"+m_trans->Get("web.page.forumviewthread.markunread")+"</a>";
// thread posts
std::vector<std::string> ignoredsig;
ignoredsig.push_back("THREADPOSTSIGNATUREDIV"); // don't replace this div when we get the section, we'll replace it later
m_templatehandler.GetSection("THREADPOSTROWODD",threadpostrowodd,ignoredsig);
m_templatehandler.GetSection("THREADPOSTROWEVEN",threadpostroweven,ignoredsig);
trans.ClearError();
// only selects, deferred OK
trans.Begin();
SQLite3DB::Statement st=m_db->Prepare("SELECT tblMessage.MessageID, tblMessage.IdentityID, tblMessage.FromName, tblMessage.Subject, tblMessage.MessageDate || ' ' || tblMessage.MessageTime, tblMessage.Body, tblIdentity.PublicKey || (SELECT OptionValue FROM tblOption WHERE Option='MessageBase') || '|' || tblMessage.InsertDate || '|Message-' || tblMessage.MessageIndex, tblMessage.MessageUUID, tblIdentity.Signature, tblIdentity.ShowSignature, tblIdentity.ShowAvatar, tblIdentity.FMSAvatar, tblIdentity.SoneAvatar FROM tblMessage INNER JOIN tblThreadPost ON tblMessage.MessageID=tblThreadPost.MessageID LEFT JOIN tblIdentity ON tblMessage.IdentityID=tblIdentity.IdentityID WHERE tblThreadPost.ThreadID=? ORDER BY tblThreadPost.PostOrder;");
st.Bind(0,threadidstr);
trans.Step(st);
while(st.RowReturned())
{
std::map<std::string,std::string> postvars;
std::string postrow("");
int messageid(0);
std::string messageidstr="";
std::string identityidstr="";
std::string fromname="";
std::string subject="";
std::string datetime="";
std::string body="";
std::string postlink="";
std::string messageuuid="";
std::string signature="";
std::string showidsignature="0";
bool allowreply=true;
bool showidavatar=false;
std::string fmsavatar("");
std::string soneavatar("");
st.ResultInt(0,messageid);
st.ResultText(0,messageidstr);
st.ResultText(1,identityidstr);
st.ResultText(2,fromname);
st.ResultText(3,subject);
st.ResultText(4,datetime);
st.ResultText(5,body);
st.ResultText(6,postlink);
st.ResultText(7,messageuuid);
st.ResultText(8,signature);
st.ResultText(9,showidsignature);
st.ResultBool(10,showidavatar);
st.ResultText(11,fmsavatar);
st.ResultText(12,soneavatar);
if(postcount==0)
{
if(subject!="")
{
m_pagetitle+=" - "+SanitizeOutput(boardname,skipspace)+" - "+SanitizeOutput(subject,skipspace);
}
breadcrumblinks.push_back(std::pair<std::string,std::string>(m_pagename+"?viewstate="+m_viewstate.GetViewStateID()+"&threadid="+threadidstr+"&boardid="+boardidstr+"&page="+pagestr,SanitizeOutput(subject,skipspace)));
}
postvars["THREADPOSTANCHOR"]="<a name=\""+messageidstr+"\"></a><a name=\""+FixUUIDAnchor(messageuuid)+"\"></a>";
if(identityidstr=="")
{
postvars["CONDITIONALTRUSTTABLE"]="";
}
else
{
int lmt=0;
int pmt=0;
std::string localmessagetrust("");
std::string localtrustlisttrust("");
std::string peermessagetrust("");
std::string peertrustlisttrust("");
if(m_viewstate.GetLocalIdentityID()==0)
{
truststpeeronly.Bind(0,identityidstr);
truststpeeronly.Step();
if(truststpeeronly.RowReturned())
{
truststpeeronly.ResultText(0,peermessagetrust);
truststpeeronly.ResultText(1,peertrustlisttrust);
truststpeeronly.ResultInt(0,pmt);
if(peermessagetrust!="" && pmt<m_minpeermessagetrust)
{
allowreply=false;
}
}
truststpeeronly.Reset();
}
else
{
truststboth.Bind(0,identityidstr);
truststboth.Bind(1,m_viewstate.GetLocalIdentityID());
truststboth.Step();
if(truststboth.RowReturned())
{
truststboth.ResultText(0,localmessagetrust);
truststboth.ResultText(1,peermessagetrust);
truststboth.ResultText(2,localtrustlisttrust);
truststboth.ResultText(3,peertrustlisttrust);
truststboth.ResultInt(0,lmt);
truststboth.ResultInt(1,pmt);
if(localmessagetrust=="")
{
lmt=100;
}
if(peermessagetrust=="")
{
pmt=100;
}
if(((m_localtrustoverrides==false || localmessagetrust=="") && (pmt<m_minpeermessagetrust || lmt<m_minlocalmessagetrust)) || (m_localtrustoverrides==true && (lmt<m_minlocalmessagetrust)))
{
allowreply=false;
}
}
truststboth.Reset();
}
postvars["CONDITIONALTRUSTTABLE"]=trusttable;
postvars["LOCALMESSAGETRUST"]=localmessagetrust;
postvars["PEERMESSAGETRUST"]=peermessagetrust;
postvars["LOCALTRUSTLISTTRUST"]=localtrustlisttrust;
postvars["PEERTRUSTLISTTRUST"]=peertrustlisttrust;
if(m_viewstate.GetLocalIdentityID()!=0)
{
postvars["LOCALMESSAGETRUST"]+="<a href=\""+m_pagename+"?viewstate="+m_viewstate.GetViewStateID()+"&"+CreateLinkFormPassword()+"&threadid="+threadidstr+"&boardid="+boardidstr+"&page="+pagestr+"&formaction=addmessagetrust&identityid="+identityidstr+"#"+messageidstr+"\"><img src=\"images/circleplus.png\" border=\"0\" style=\"vertical-align:bottom;\"></a>";
postvars["LOCALMESSAGETRUST"]+="<a href=\""+m_pagename+"?viewstate="+m_viewstate.GetViewStateID()+"&"+CreateLinkFormPassword()+"&threadid="+threadidstr+"&boardid="+boardidstr+"&page="+pagestr+"&formaction=removemessagetrust&identityid="+identityidstr+"#"+messageidstr+"\"><img src=\"images/circleminus.png\" border=\"0\" style=\"vertical-align:bottom;\"></a>";
postvars["LOCALTRUSTLISTTRUST"]+="<a href=\""+m_pagename+"?viewstate="+m_viewstate.GetViewStateID()+"&"+CreateLinkFormPassword()+"&threadid="+threadidstr+"&boardid="+boardidstr+"&page="+pagestr+"&formaction=addtrustlisttrust&identityid="+identityidstr+"#"+messageidstr+"\"><img src=\"images/circleplus.png\" border=\"0\" style=\"vertical-align:bottom;\"></a>";
postvars["LOCALTRUSTLISTTRUST"]+="<a href=\""+m_pagename+"?viewstate="+m_viewstate.GetViewStateID()+"&"+CreateLinkFormPassword()+"&threadid="+threadidstr+"&boardid="+boardidstr+"&page="+pagestr+"&formaction=removetrustlisttrust&identityid="+identityidstr+"#"+messageidstr+"\"><img src=\"images/circleminus.png\" border=\"0\" style=\"vertical-align:bottom;\"></a>";
}
}
postvars["THREADPOSTBODY"]=FixBody(body);
postattachments="";
fileattachmentst.Bind(0,messageid);
fileattachmentst.Step();
while(fileattachmentst.RowReturned())
{
std::string thisattachment("");
std::map<std::string,std::string> attachmentvars;
std::string key("");
int size=0;
std::string sizestr("");
std::string keyname("");
std::string::size_type slashpos=std::string::npos;
fileattachmentst.ResultText(0,key);
fileattachmentst.ResultInt(0,size);
fileattachmentst.ResultText(1,sizestr);
if(size<0)
{
sizestr="?";
}
keyname=key;
slashpos=keyname.find('/');
if(slashpos!=std::string::npos && slashpos<keyname.size())
{
keyname=keyname.substr(slashpos+1);
}
attachmentvars["THREADPOSTATTACHMENTLINK"]="<a href=\"[FPROXYPROTOCOL]://[FPROXYHOST]:[FPROXYPORT]/"+StringFunctions::UriEncode(key)+"\"><img src=\"images/attach.png\" border=\"0\" style=\"vertical-align:baseline;\"> "+SanitizeOutput(keyname)+"</a>";
attachmentvars["THREADPOSTATTACHMENTSIZE"]=sizestr+" bytes";
m_templatehandler.PerformReplacements(threadpostattachment,attachmentvars,thisattachment);
postattachments+=thisattachment;
fileattachmentst.Step();
}
fileattachmentst.Reset();
if(postattachments!="")
{
postattachments="<div class=\"postattachments\">"+postattachments+"</div>";
}
postvars["THREADPOSTATTACHMENTS"]=postattachments;
if(identityidstr!="")
{
postvars["THREADPOSTAUTHORNAME"]="<a href=\"peerdetails.htm?identityid="+identityidstr+"\">"+FixAuthorName(fromname)+"</a>";
if(showsignatures==true && showidsignature=="1" && signature!="")
{
std::vector<std::string> skipspace(1," ");
std::string lf(1,10);
postvars["THREADPOSTSIGNATURE"]=StringFunctions::Replace(m_htmlrenderer.Render(signature),lf,"<br />");
}
else
{
postvars["THREADPOSTSIGNATUREDIV"]="";
}
if(showavatars==true && showidavatar==true)
{ /*
std::vector<std::string> parts;
StringFunctions::SplitMultiple(postlink,"@,",parts);
if(parts.size()>1)
{
postvars["THREADPOSTAUTHORAVATAR"]="<img src=\"showavatar.htm?idpart="+StringFunctions::UriEncode(parts[1])+"\">";
}
else
{
postvars["THREADPOSTAUTHORAVATAR"]="";
}
*/
if(fmsavatar!="")
{
postvars["THREADPOSTAUTHORAVATAR"]="<img src=\""+fproxyprotocol+"://"+fproxyhost+":"+fproxyport+"/"+StringFunctions::UriEncode(fmsavatar)+"\" style=\"max-width:150px;max-height:150px;\">";
}
else if(soneavatar!="")
{
postvars["THREADPOSTAUTHORAVATAR"]="<img src=\""+fproxyprotocol+"://"+fproxyhost+":"+fproxyport+"/"+StringFunctions::UriEncode(soneavatar)+"\" style=\"max-width:150px;max-height:150px;\">";
}
else
{
postvars["THREADPOSTAUTHORAVATAR"]="";
}
}
else
{
postvars["THREADPOSTAUTHORAVATAR"]="";
}
}
else
{
postvars["THREADPOSTAUTHORNAME"]=FixAuthorName(fromname);
postvars["THREADPOSTSIGNATUREDIV"]="";
postvars["THREADPOSTAUTHORAVATAR"]="";
}
postvars["THREADPOSTTITLE"]=SanitizeOutput(subject,skipspace);
if(identityidstr!="" && postlink!="")
{
postvars["THREADPOSTLINK"]="<a href=\"[FPROXYPROTOCOL]://[FPROXYHOST]:[FPROXYPORT]/"+StringFunctions::UriEncode(postlink)+"?type=text/plain\"><img src=\"images/link.png\" border=\"0\" title=\""+m_trans->Get("web.page.forumviewthread.permalink")+"\"></a>";
}
else
{
postvars["THREADPOSTLINK"]="";
}
postvars["THREADPOSTLINK"]+=" <a href=\""+m_pagename+"?messageuuid="+FixUUIDAnchor(messageuuid)+"#"+FixUUIDAnchor(messageuuid)+"\"><img src=\"images/link.png\" border=\"0\" title=\""+m_trans->Get("web.page.forumviewthread.shareablelink")+"\"></a>";
postvars["THREADPOSTDATE"]=datetime;
if(allowreply==true)
{
postvars["THREADPOSTREPLYLINK"]="<a href=\"forumcreatepost.htm?viewstate="+m_viewstate.GetViewStateID()+"&replytomessageid="+messageidstr+"&threadid="+threadidstr+"&boardid="+boardidstr+"&page="+pagestr+"\"><img src=\"images/mail_reply.png\" border=\"0\" style=\"vertical-align:bottom;\">"+m_trans->Get("web.page.forumviewthread.reply")+"</a>";
}
else
{
postvars["THREADPOSTREPLYLINK"]="";
}
postcount++;
if(postcount%2==1)
{
m_templatehandler.PerformReplacements(threadpostrowodd,postvars,postrow);
}
else
{
m_templatehandler.PerformReplacements(threadpostroweven,postvars,postrow);
}
postrows+=postrow;
trans.Step(st);
}
trans.Finalize(st);
trans.Commit();
vars["THREADPOSTROWS"]=postrows;
CreateBreadcrumbLinks(breadcrumblinks,result);
vars["LOCATIONBREADCRUMBS"]=result;
m_templatehandler.GetSection("FORUMVIEWTHREADCONTENT",maincontent);
m_templatehandler.PerformReplacements(maincontent,vars,result);
return result;
}
void FixBody(dBodyID body)
{
FixBody(body,fix_ext_param,fix_mass_param);
}
