const std::string CreateIdentityPage::GenerateContent(const std::string &method, const std::map<std::string,QueryVar> &queryvars)
{
std::string content="";
if(queryvars.find("formaction")!=queryvars.end() && (*queryvars.find("formaction")).second=="create" && ValidateFormPassword(queryvars))
{
SQLite3DB::Statement st=m_db->Prepare("INSERT INTO tblLocalIdentity(Name,PublishTrustList,DateCreated) VALUES(?,'false',?);");
std::string name="";
Poco::DateTime date;
if(queryvars.find("name")!=queryvars.end())
{
name=(*queryvars.find("name")).second.GetData();
name=StringFunctions::RemoveControlChars(name);
}
st.Bind(0,name);
st.Bind(1,Poco::DateTimeFormatter::format(date,"%Y-%m-%d %H:%M:%S"));
st.Step();
// insert all identities not in trust list already
m_db->Execute("INSERT OR IGNORE INTO tblIdentityTrust(LocalIdentityID,IdentityID) SELECT LocalIdentityID,IdentityID FROM tblLocalIdentity,tblIdentity;");
content+="<h2>"+m_trans->Get("web.page.createidentity.createdidentity")+"</h2>";
content+=m_trans->Get("web.page.createidentity.aftercreateinstructions");
}
else
{
content+="<h2>"+m_trans->Get("web.page.createidentity.title")+"</h2>";
content+="<form name=\"frmcreateidentity\" method=\"POST\">";
content+=CreateFormPassword();
content+="<input type=\"hidden\" name=\"formaction\" value=\"create\">";
content+="Name : <input type=\"text\" name=\"name\" maxlength=\""MAX_IDENTITY_NAME_LENGTH_STR"\">";
content+=" <input type=\"submit\" value=\""+m_trans->Get("web.page.createidentity.create")+"\">";
content+="</form>";
}
return content;
}
const std::string OptionsPage::GenerateContent(const std::string &method, const std::map<std::string,QueryVar> &queryvars)
{
std::string content("");
std::string sql("");
if(queryvars.find("formaction")!=queryvars.end() && (*queryvars.find("formaction")).second=="save" && ValidateFormPassword(queryvars))
{
Option option(m_db);
option.ClearCache();
std::vector<std::string> options;
std::vector<std::string> oldvalues;
std::vector<std::string> newvalues;
CreateArgArray(queryvars,"option",options);
CreateArgArray(queryvars,"oldvalue",oldvalues);
CreateArgArray(queryvars,"value",newvalues);
for(int i=0; i<options.size(); i++)
{
if(oldvalues[i]!=newvalues[i])
{
option.Set(options[i],newvalues[i]);
// load new language immediately
if(options[i]=="Language")
{
Poco::Path tdir;
tdir.pushDirectory(global::basepath+"translations");
tdir=tdir.makeAbsolute();
tdir.setFileName(newvalues[i]);
m_trans->LoadLocalizedTranslation(tdir.toString());
}
if(options[i]=="MessageDownloadMaxDaysBackward")
{
m_db->Execute("INSERT OR IGNORE\
INTO tblMessageRequests (IdentityID, Day, RequestIndex, Found)\
SELECT M.IdentityID, M.InsertDate, M.MessageIndex, 'true'\
FROM tblMessage M\
LEFT JOIN tblMessageRequests R\
ON M.IdentityID=R.IdentityID\
AND M.MessageIndex=R.RequestIndex\
AND M.InsertDate=R.Day\
WHERE R.IdentityID IS NULL\
AND M.IdentityID IS NOT NULL\
AND M.InsertDate >= date('now',(SELECT -MAX(OptionValue,0) FROM tblOption \
WHERE Option='MessageDownloadMaxDaysBackward')||' days');");
}
}
const std::string PeerMaintenancePage::GenerateContent(const std::string &method, const std::map<std::string,QueryVar> &queryvars)
{
std::string content("");
std::string sql("");
SQLite3DB::Statement st;
std::string tempval;
Poco::DateTime date;
bool m_localtrustoverrides=false;
Option opt(m_db);
opt.GetBool("LocalTrustOverridesPeerTrust",m_localtrustoverrides);
if(queryvars.find("formaction")!=queryvars.end() && ValidateFormPassword(queryvars))
{
if((*queryvars.find("formaction")).second=="removenotseen")
{
m_db->Execute("DELETE FROM tblIdentity WHERE LastSeen IS NULL AND WOTLastSeen IS NULL;");
}
else if((*queryvars.find("formaction")).second=="removelastseen20")
{
date=Poco::Timestamp();
date-=Poco::Timespan(20,0,0,0,0);
st=m_db->Prepare("DELETE FROM tblIdentity WHERE IFNULL(LastSeen<?,1) AND IFNULL(WOTLastSeen<?,1);");
st.Bind(0,Poco::DateTimeFormatter::format(date,"%Y-%m-%d %H:%M:%S"));
st.Bind(1,Poco::DateTimeFormatter::format(date,"%Y-%m-%d %H:%M:%S"));
st.Step();
}
else if((*queryvars.find("formaction")).second=="removeneversent")
{
m_db->Execute("DELETE FROM tblIdentity WHERE IdentityID NOT IN (SELECT IdentityID FROM tblMessage WHERE IdentityID IS NOT NULL GROUP BY IdentityID);");
}
else if((*queryvars.find("formaction")).second=="removelastseenneversent20")
{
date=Poco::Timestamp();
date-=Poco::Timespan(20,0,0,0,0);
st=m_db->Prepare("DELETE FROM tblIdentity WHERE IdentityID NOT IN (SELECT IdentityID FROM tblMessage WHERE IdentityID IS NOT NULL GROUP BY IdentityID) AND IFNULL(LastSeen<?,1) AND IFNULL(WOTLastSeen<?,1);");
st.Bind(0,Poco::DateTimeFormatter::format(date,"%Y-%m-%d %H:%M:%S"));
st.Bind(1,Poco::DateTimeFormatter::format(date,"%Y-%m-%d %H:%M:%S"));
st.Step();
}
else if((*queryvars.find("formaction")).second=="removedaysago" && queryvars.find("daysago")!=queryvars.end() && (*queryvars.find("daysago")).second!="")
{
int tempint=10000;
StringFunctions::Convert((*queryvars.find("daysago")).second.GetData(),tempint);
date=Poco::Timestamp();
date-=Poco::Timespan(tempint,0,0,0,0);
st=m_db->Prepare("DELETE FROM tblIdentity WHERE IFNULL(LastSeen<?,1) AND IFNULL(WOTLastSeen<?,1);");
st.Bind(0,Poco::DateTimeFormatter::format(date,"%Y-%m-%d %H:%M:%S"));
st.Bind(1,Poco::DateTimeFormatter::format(date,"%Y-%m-%d %H:%M:%S"));
st.Step();
}
else if((*queryvars.find("formaction")).second=="removenulldaysago" && queryvars.find("daysago")!=queryvars.end() && (*queryvars.find("daysago")).second!="")
{
int tempint=10000;
StringFunctions::Convert((*queryvars.find("daysago")).second.GetData(),tempint);
date=Poco::Timestamp();
date-=Poco::Timespan(tempint,0,0,0,0);
st=m_db->Prepare("DELETE FROM tblIdentity WHERE IFNULL(LastSeen<?,1) AND IFNULL(WOTLastSeen<?,1) AND LocalMessageTrust IS NULL AND LocalTrustListTrust IS NULL;");
st.Bind(0,Poco::DateTimeFormatter::format(date,"%Y-%m-%d %H:%M:%S"));
st.Bind(1,Poco::DateTimeFormatter::format(date,"%Y-%m-%d %H:%M:%S"));
st.Step();
}
else if((*queryvars.find("formaction")).second=="removeposted30daysago")
{
date=Poco::Timestamp();
date-=Poco::Timespan(30,0,0,0,0);
st=m_db->Prepare("DELETE FROM tblIdentity WHERE IdentityID IN (SELECT tblIdentity.IdentityID FROM tblIdentity INNER JOIN tblMessage ON tblIdentity.IdentityID=tblMessage.IdentityID WHERE (SELECT MAX(MessageDate) FROM tblMessage WHERE tblMessage.IdentityID=tblIdentity.IdentityID)<=? GROUP BY tblIdentity.IdentityID);");
st.Bind(0,Poco::DateTimeFormatter::format(date,"%Y-%m-%d"));
st.Step();
}
else if((*queryvars.find("formaction")).second=="removeadded20daysneversent")
{
date=Poco::Timestamp();
date-=Poco::Timespan(20,0,0,0,0);
st=m_db->Prepare("DELETE FROM tblIdentity WHERE IdentityID IN (SELECT tblIdentity.IdentityID FROM tblIdentity LEFT JOIN tblMessage ON tblIdentity.IdentityID=tblMessage.IdentityID WHERE tblMessage.IdentityID IS NULL AND tblIdentity.DateAdded<?);");
st.Bind(0,Poco::DateTimeFormatter::format(date,"%Y-%m-%d %H:%M:%S"));
st.Step();
}
}
content+="<h2>"+m_trans->Get("web.page.peermaintenance.title")+"</h2>";
content+="<p class=\"paragraph\">"+m_trans->Get("web.page.peermaintenance.instructions")+"</p>";
content+="<p>";
content+="<a href=\"recentlyadded.htm\">"+m_trans->Get("web.page.peermaintenance.recentlyadded")+"</a>";
content+="</p>";
content+="<table>";
content+="<tr><th colspan=\"3\">"+m_trans->Get("web.page.peermaintenance.stats")+"</th></tr>";
content+="<tr>";
st=m_db->Prepare("SELECT COUNT(*) FROM tblIdentity;");
st.Step();
st.ResultText(0,tempval);
content+="<td>"+tempval+"</td>";
content+="<td>"+m_trans->Get("web.page.peermaintenance.knownpeers")+"</td>";
content+="</tr>";
content+="<tr>";
st=m_db->Prepare("SELECT COUNT(*) FROM tblIdentity WHERE IsFMS=1;");
st.Step();
st.ResultText(0,tempval);
content+="<td>"+tempval+"</td>";
content+="<td>"+m_trans->Get("web.page.peermaintenance.fmspeers")+"</td>";
content+="</tr>";
content+="<tr>";
st=m_db->Prepare("SELECT COUNT(*) FROM tblIdentity WHERE IsWOT=1;");
st.Step();
st.ResultText(0,tempval);
content+="<td>"+tempval+"</td>";
content+="<td>"+m_trans->Get("web.page.peermaintenance.wotpeers")+"</td>";
content+="</tr>";
content+="<tr>";
sql="SELECT COUNT(*) FROM tblIdentity WHERE ";
if(m_localtrustoverrides==true)
{
sql+="(tblIdentity.LocalMessageTrust>=(SELECT OptionValue FROM tblOption WHERE Option='MinLocalMessageTrust') OR (tblIdentity.LocalMessageTrust IS NULL AND (tblIdentity.PeerMessageTrust IS NULL OR tblIdentity.PeerMessageTrust>=(SELECT OptionValue FROM tblOption WHERE Option='MinPeerMessageTrust'))))";
}
else
{
sql+="(tblIdentity.LocalMessageTrust IS NULL OR tblIdentity.LocalMessageTrust>=(SELECT OptionValue FROM tblOption WHERE Option='MinLocalMessageTrust'))";
sql+="AND (tblIdentity.PeerMessageTrust IS NULL OR tblIdentity.PeerMessageTrust>=(SELECT OptionValue FROM tblOption WHERE Option='MinPeerMessageTrust'))";
}
st=m_db->Prepare(sql);
st.Step();
st.ResultText(0,tempval);
content+="<td>"+tempval+"</td>";
content+="<td>"+m_trans->Get("web.page.peermaintenance.trustedcount")+"</td>";
content+="</tr>";
content+="<tr>";
st=m_db->Prepare("SELECT COUNT(*) FROM tblIdentity WHERE LastSeen IS NULL AND WOTLastSeen IS NULL;");
st.Step();
st.ResultText(0,tempval);
content+="<td>"+tempval+"</td>";
content+="<td>"+m_trans->Get("web.page.peermaintenance.neverseen")+"</td>";
content+="<td>";
content+="<form name=\"frmremove\" method=\"POST\">";
content+=CreateFormPassword();
content+="<input type=\"hidden\" name=\"formaction\" value=\"removenotseen\">";
content+="<input type=\"submit\" value=\""+m_trans->Get("web.page.peermaintenance.remove")+"\">";
content+="</form>";
content+="</td>";
content+="</tr>";
date=Poco::Timestamp();
date-=Poco::Timespan(20,0,0,0,0);
st=m_db->Prepare("SELECT COUNT(*) FROM tblIdentity WHERE IFNULL(LastSeen<?,1) AND IFNULL(WOTLastSeen<?,1);");
st.Bind(0,Poco::DateTimeFormatter::format(date,"%Y-%m-%d %H:%M:%S"));
st.Step();
st.ResultText(0,tempval);
content+="<tr>";
content+="<td>"+tempval+"</td>";
content+="<td>"+m_trans->Get("web.page.peermaintenance.lastseen20days")+"</td>";
content+="<td>";
content+="<form name=\"frmremove\" method=\"POST\">";
content+=CreateFormPassword();
content+="<input type=\"hidden\" name=\"formaction\" value=\"removelastseen20\">";
content+="<input type=\"submit\" value=\""+m_trans->Get("web.page.peermaintenance.remove")+"\">";
content+="</form>";
content+="</td>";
content+="</tr>";
date=Poco::Timestamp();
date-=Poco::Timespan(30,0,0,0,0);
st=m_db->Prepare("SELECT COUNT(*) FROM (SELECT tblIdentity.IdentityID FROM tblIdentity INNER JOIN tblMessage ON tblIdentity.IdentityID=tblMessage.IdentityID WHERE (SELECT MAX(MessageDate) FROM tblMessage WHERE tblMessage.IdentityID=tblIdentity.IdentityID)<=? GROUP BY tblIdentity.IdentityID);");
st.Bind(0,Poco::DateTimeFormatter::format(date,"%Y-%m-%d"));
st.Step();
st.ResultText(0,tempval);
content+="<tr>";
content+="<td>"+tempval+"</td>";
content+="<td>"+m_trans->Get("web.page.peermaintenance.lastsent30days")+"</td>";
content+="<td>";
content+="<form name=\"frmremove\" method=\"POST\">";
content+=CreateFormPassword();
content+="<input type=\"hidden\" name=\"formaction\" value=\"removeposted30daysago\">";
content+="<input type=\"submit\" value=\""+m_trans->Get("web.page.peermaintenance.remove")+"\">";
content+="</form>";
content+="</td>";
content+="</tr>";
st=m_db->Prepare("SELECT COUNT(*) FROM tblIdentity LEFT JOIN tblMessage ON tblIdentity.IdentityID=tblMessage.IdentityID WHERE tblMessage.IdentityID IS NULL;");
st.Step();
st.ResultText(0,tempval);
content+="<tr>";
content+="<td>"+tempval+"</td>";
content+="<td>"+m_trans->Get("web.page.peermaintenance.neversent")+"</td>";
content+="<td>";
content+="<form name=\"frmremove\" method=\"POST\">";
content+=CreateFormPassword();
content+="<input type=\"hidden\" name=\"formaction\" value=\"removeneversent\">";
content+="<input type=\"submit\" value=\""+m_trans->Get("web.page.peermaintenance.remove")+"\">";
content+="</form>";
content+="</td>";
content+="</tr>";
date=Poco::Timestamp();
date-=Poco::Timespan(20,0,0,0,0);
st=m_db->Prepare("SELECT COUNT(*) FROM tblIdentity LEFT JOIN tblMessage ON tblIdentity.IdentityID=tblMessage.IdentityID WHERE tblMessage.IdentityID IS NULL AND tblIdentity.DateAdded<?;");
st.Bind(0,Poco::DateTimeFormatter::format(date,"%Y-%m-%d %H:%M:%S"));
st.Step();
st.ResultText(0,tempval);
content+="<tr>";
content+="<td>"+tempval+"</td>";
content+="<td>"+m_trans->Get("web.page.peermaintenance.added20daysneversent")+"</td>";
content+="<td>";
content+="<form name=\"frmremove\" method=\"POST\">";
content+=CreateFormPassword();
content+="<input type=\"hidden\" name=\"formaction\" value=\"removeadded20daysneversent\">";
content+="<input type=\"submit\" value=\""+m_trans->Get("web.page.peermaintenance.remove")+"\">";
content+="</form>";
content+="</td>";
content+="</tr>";
date=Poco::Timestamp();
date-=Poco::Timespan(20,0,0,0,0);
st=m_db->Prepare("SELECT COUNT(*) FROM tblIdentity LEFT JOIN tblMessage ON tblIdentity.IdentityID=tblMessage.IdentityID WHERE tblMessage.IdentityID IS NULL AND IFNULL(tblIdentity.LastSeen<?,1) AND IFNULL(tblIdentity.WOTLastSeen<?,1);");
st.Bind(0,Poco::DateTimeFormatter::format(date,"%Y-%m-%d %H:%M:%S"));
st.Bind(1,Poco::DateTimeFormatter::format(date,"%Y-%m-%d %H:%M:%S"));
st.Step();
st.ResultText(0,tempval);
content+="<tr>";
content+="<td>"+tempval+"</td>";
content+="<td>"+m_trans->Get("web.page.peermaintenance.lastseen20daysneversent")+"</td>";
content+="<td>";
content+="<form name=\"frmremove\" method=\"POST\">";
content+=CreateFormPassword();
content+="<input type=\"hidden\" name=\"formaction\" value=\"removelastseenneversent20\">";
content+="<input type=\"submit\" value=\""+m_trans->Get("web.page.peermaintenance.remove")+"\">";
content+="</form>";
content+="</td>";
content+="</tr>";
content+="<tr>";
content+="<td><form name=\"frmdelete\" method=\"POST\">";
content+=CreateFormPassword();
content+="<input type=\"hidden\" name=\"formaction\" value=\"removedaysago\"></td>";
content+="<td>"+m_trans->Get("web.page.peermaintenance.lastseen")+" <input type=\"text\" name=\"daysago\" size=\"2\"> "+m_trans->Get("web.page.peermaintenance.daysago")+"</td>";
content+="<td><input type=\"submit\" value=\""+m_trans->Get("web.page.peermaintenance.remove")+"\"></form></td>";
content+="</tr>";
content+="<tr>";
content+="<td><form name=\"frmdelete\" method=\"POST\">";
content+=CreateFormPassword();
content+="<input type=\"hidden\" name=\"formaction\" value=\"removenulldaysago\"></td>";
content+="<td>"+m_trans->Get("web.page.peermaintenance.lastseen")+" <input type=\"text\" name=\"daysago\" size=\"2\"> "+m_trans->Get("web.page.peermaintenance.daysagonulltrust")+"</td>";
content+="<td><input type=\"submit\" value=\""+m_trans->Get("web.page.peermaintenance.remove")+"\"></form></td>";
content+="</tr>";
content+="</table>";
return content;
}
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;
}
const std::string RecentlyAddedPage::GenerateContent(const std::string &method, const std::map<std::string,QueryVar> &queryvars)
{
std::string content="";
Poco::DateTime date;
int count=0;
std::string countstr="0";
if(queryvars.find("formaction")!=queryvars.end() && (*queryvars.find("formaction")).second=="delete" && ValidateFormPassword(queryvars))
{
std::vector<std::string> identityids;
CreateArgArray(queryvars,"chkdel",identityids);
SQLite3DB::Statement del=m_db->Prepare("DELETE FROM tblIdentity WHERE IdentityID=?;");
for(std::vector<std::string>::iterator i=identityids.begin(); i!=identityids.end(); i++)
{
if((*i)!="")
{
del.Bind(0,(*i));
del.Step();
del.Reset();
}
}
}
content="<h2>"+m_trans->Get("web.page.recentlyadded.title")+"</h2>";
SQLite3DB::Statement st=m_db->Prepare("SELECT IdentityID, PublicKey, Name, DateAdded, AddedMethod FROM tblIdentity WHERE DateAdded>=? ORDER BY DateAdded DESC;");
date-=Poco::Timespan(5,0,0,0,0);
st.Bind(0,Poco::DateTimeFormatter::format(date,"%Y-%m-%d %H:%M:%S"));
st.Step();
content+="<form name=\"frmdel\" method=\"post\">";
content+=CreateFormPassword();
content+="<input type=\"hidden\" name=\"formaction\" value=\"delete\">";
content+="<table class=\"small90\">";
content+="<tr><th>"+m_trans->Get("web.page.recentlyadded.name")+"</th><th>"+m_trans->Get("web.page.recentlyadded.dateadded")+"</th><th>"+m_trans->Get("web.page.recentlyadded.addedmethod")+"</th></tr>";
while(st.RowReturned())
{
std::string identityidstr="";
std::string publickey="";
std::string name="";
std::string dateadded="";
std::string addedmethod="";
st.ResultText(0,identityidstr);
st.ResultText(1,publickey);
st.ResultText(2,name);
st.ResultText(3,dateadded);
st.ResultText(4,addedmethod);
StringFunctions::Convert(count,countstr);
content+="<tr>";
content+="<td title=\""+publickey+"\">";
content+="<a href=\"peerdetails.htm?identityid="+identityidstr+"\">";
content+=SanitizeOutput(CreateShortIdentityName(name,publickey));
content+="</a>";
content+="</td>";
content+="<td>"+dateadded+"</td>";
content+="<td>"+SanitizeOutput(addedmethod)+"</td>";
content+="<td><input type=\"checkbox\" name=\"chkdel["+countstr+"]\" value=\""+identityidstr+"\"></td>";
content+="</tr>";
count++;
st.Step();
}
content+="<tr><td colspan=\"4\"><center><input type=\"submit\" value=\""+m_trans->Get("web.page.recentlyadded.deleteselected")+"\"></center></td></tr>";
content+="</table>";
return content;
}
const std::string AddPeerPage::GenerateContent(const std::string &method, const std::map<std::string,QueryVar> &queryvars)
{
std::string content="";
if(queryvars.find("formaction")!=queryvars.end() && (*queryvars.find("formaction")).second=="add" && ValidateFormPassword(queryvars))
{
Poco::DateTime date;
std::string publickey="";
if(queryvars.find("publickey")!=queryvars.end())
{
publickey=(*queryvars.find("publickey")).second.GetData();
}
if(publickey!="" && publickey.find("SSK@")==0 && publickey[publickey.size()-1]=='/')
{
SQLite3DB::Statement st=m_db->Prepare("INSERT INTO tblIdentity(PublicKey,DateAdded,AddedMethod,IsFMS) VALUES(?,?,?,1);");
st.Bind(0,publickey);
st.Bind(1,Poco::DateTimeFormatter::format(date,"%Y-%m-%d %H:%M:%S"));
st.Bind(2,"manually");
st.Step();
st.Reset();
}
}
content+="<h2>"+m_trans->Get("web.page.addpeer.title")+"</h2>";
content+="<form name=\"frmaddpeer\" method=\"POST\">";
content+=CreateFormPassword();
content+="<input type=\"hidden\" name=\"formaction\" value=\"add\">";
content+=m_trans->Get("web.page.addpeer.publickey")+" ";
content+="<input type=\"text\" name=\"publickey\" size=\"100\">";
content+="<br>";
content+=m_trans->Get("web.page.addpeer.validpubkey");
content+="<br>";
content+="<input type=\"submit\" value=\""+m_trans->Get("web.page.addpeer.add")+"\">";
content+="</form>";
return content;
}
const std::string ShowPendingMessagePage::GenerateContent(const std::string &method, const std::map<std::string,QueryVar> &queryvars)
{
if(queryvars.find("formaction")!=queryvars.end() && (*queryvars.find("formaction")).second=="delete" && ValidateFormPassword(queryvars))
{
m_log->information("User requested to delete message "+(*queryvars.find("uuid")).second.GetData());
SQLite3DB::Statement st=m_db->Prepare("DELETE FROM tblMessageInserts WHERE MessageUUID=?");
st.Bind(0, (*queryvars.find("uuid")).second.GetData());
st.Step();
}
SQLite3DB::Statement st=m_db->Prepare("SELECT LocalIdentityID, MessageXML, SendDate, MessageUUID FROM tblMessageInserts WHERE Inserted='false';");
st.Step();
int msgcount=0;
std::string tblcontent="";
std::string content="";
tblcontent+="<table><tr><td>"+m_trans->Get("web.page.pendingmessages.identity")+"</td><td>"+m_trans->Get("web.page.pendingmessages.boards")+"</td><td>"+m_trans->Get("web.page.pendingmessages.subject")+"</td><td>"+m_trans->Get("web.page.pendingmessages.time")+"</td></tr>";
while (st.RowReturned())
{
int identityid=0;
std::string time("");
std::string uuid("");
std::string subject("");
st.ResultInt(0,identityid);
st.ResultText(2,time);
st.ResultText(3, uuid);
LocalIdentity ident(m_db); //found a canned way, thanks SomeDude!
ident.Load(identityid);
tblcontent+="<tr><td>";
tblcontent+=SanitizeOutput(ident.GetName())+"</td><td>";
//yes, the next bit sucks but there's no better way to do it (that I could find)
//we will look at the message XML to find the board(s) posted to....
std::string xml="";
st.ResultText(1,xml);
MessageXML mxml;
mxml.ParseXML(xml);
std::vector<std::string> boards=mxml.GetBoards();
std::vector<std::string>::iterator iter;
for (iter=boards.begin(); iter!=boards.end(); ++iter) tblcontent+=*iter+", ";
tblcontent.erase(tblcontent.length()-2); //strip final ", "
tblcontent+="</td><td>";
subject=mxml.GetSubject();
tblcontent+=SanitizeOutput(subject);
tblcontent+="</td><td>";
tblcontent+=time+"</td><td>";
//button
tblcontent+="<form name=\"frmdelete\" method=\"POST\">";
tblcontent+=CreateFormPassword();
tblcontent+="<input type=\"hidden\" name=\"formaction\" value=\"delete\">";
tblcontent+="<input type=\"hidden\" name=\"uuid\" value=\""+uuid+"\">";
tblcontent+="<input type=\"submit\" value=\""+m_trans->Get("web.page.pendingmessages.deletemessage")+"\">";
tblcontent+="</form>";
tblcontent+="</td></tr>";
st.Step();
msgcount++;
}
tblcontent+="</table>";
std::string msgcountstr("");
StringFunctions::Convert(msgcount,msgcountstr);
content="<h2>"+msgcountstr+" "+m_trans->Get("web.page.pendingmessages.messageswaiting")+"</h2>";
content+=tblcontent;
return content;
}
const std::string HomePage::GenerateContent(const std::string &method, const std::map<std::string,QueryVar> &queryvars)
{
Option option(m_db);
std::string messagecountstr="";
std::string filecountstr="";
std::string fproxyhost="127.0.0.1";
std::string fproxyport="8888";
std::string fproxyprotocol="http";
option.Get("FProxyHost",fproxyhost);
option.Get("FProxyPort",fproxyport);
option.Get("FProxyProtocol",fproxyprotocol);
if(queryvars.find("formaction")!=queryvars.end() && (*queryvars.find("formaction")).second=="shutdown" && ValidateFormPassword(queryvars))
{
m_log->trace("HomePage::GeneratePage requested shutdown");
((FMSApp *)&FMSApp::instance())->Terminate();
global::shutdown=true;
}
std::string content="<h2>"+m_trans->Get("web.page.home.title")+"</h2>";
content+="<p class=\"paragraph\">";
content+="<strong>"+m_trans->Get("web.page.home.fmsversion")+" ";
content+=FMS_VERSION;
content+="</strong><br>";
bool showgenericupdate=true;
SQLite3DB::Statement st=m_db->Prepare("SELECT Major, Minor, Release, PageKey FROM tblFMSVersion ORDER BY Major DESC, Minor DESC, Release DESC LIMIT 1;");
st.Step();
if(st.RowReturned())
{
int major=0;
int minor=0;
int release=0;
int currentmajor=0;
int currentminor=0;
int currentrelease=0;
std::string freesite="";
std::string majorstr="";
std::string minorstr="";
std::string releasestr="";
StringFunctions::Convert(VERSION_MAJOR,currentmajor);
StringFunctions::Convert(VERSION_MINOR,currentminor);
StringFunctions::Convert(VERSION_RELEASE,currentrelease);
st.ResultInt(0,major);
st.ResultInt(1,minor);
st.ResultInt(2,release);
st.ResultText(3,freesite);
StringFunctions::Convert(major,majorstr);
StringFunctions::Convert(minor,minorstr);
StringFunctions::Convert(release,releasestr);
if(currentmajor<major || (currentmajor==major && currentminor<minor) || (currentmajor==major && currentminor==minor && currentrelease<release))
{
content+="<strong>"+m_trans->Get("web.page.home.oldversion")+" <a href=\""+fproxyprotocol+"://"+fproxyhost+":"+fproxyport+"/"+freesite+"\">FMS "+majorstr+"."+minorstr+"."+releasestr+"</a></strong><br>";
content+=m_trans->Get("web.page.home.releaseinfo")+" <a href=\"versioninfo.htm?Major="+majorstr+"&Minor="+minorstr+"&Release="+releasestr+"\">"+m_trans->Get("web.page.home.releaseinfohere")+"</a><br>";
showgenericupdate=false;
}
else
{
content+="<a href=\"versioninfo.htm\">"+m_trans->Get("web.page.home.releaseinfo")+"</a><br>";
}
}
if(showgenericupdate)
{
content+=m_trans->Get("web.page.home.checknewreleases")+" <a href=\""+fproxyprotocol+"://"+fproxyhost+":"+fproxyport+"/"+FMS_FREESITE_USK+"\">"+m_trans->Get("web.page.home.fmsfreesite")+"</a><br>";
}
content+=m_trans->Get("web.page.home.admininstructions");
content+="</p>";
st=m_db->Prepare("SELECT COUNT(*) FROM tblMessageInserts WHERE Inserted='false';");
st.Step();
if(st.RowReturned())
{
st.ResultText(0,messagecountstr);
}
content+=m_trans->Get("web.page.home.messageswaiting")+messagecountstr;
if (messagecountstr!="0") //show link to message page
{
content+=" (<a href=\"showpendingmessage.htm\">"+m_trans->Get("web.page.home.showmessageswaiting")+"</a>)";
}
content+="<br>";
st=m_db->Prepare("SELECT COUNT(*) FROM tblFileInserts WHERE Key IS NULL;");
st.Step();
if(st.RowReturned())
{
st.ResultText(0,filecountstr);
}
content+=m_trans->Get("web.page.home.fileswaiting")+filecountstr+"<br>";
st=m_db->Prepare("SELECT COUNT(*) FROM tblMessageInserts WHERE Inserted='true';");
st.Step();
if(st.RowReturned())
{
st.ResultText(0,messagecountstr);
}
/*
st=m_db->Prepare("SELECT COUNT(*) FROM tblMessageInserts WHERE MessageUUID IN (SELECT MessageUUID FROM tblMessage);");
st.Step();
if(st.RowReturned())
{
st.ResultText(0,filecountstr);
}
*/
content+=m_trans->Get("web.page.home.msgsinserted")+" "+messagecountstr;//+" / "+filecountstr;
if (messagecountstr!="0") //show link to message page
{
content+=" (<a href=\"showinsertedmessage.htm\">"+m_trans->Get("web.page.home.show")+"</a>)";
}
content+="<br>";
st=m_db->Prepare("SELECT COUNT(*) FROM tblMessage;");
st.Step();
if(st.RowReturned())
{
st.ResultText(0,filecountstr);
}
content+=m_trans->Get("web.page.home.msgsreceived")+" "+filecountstr+" (<a href=\"showreceivedmessage.htm\">"+m_trans->Get("web.page.home.show")+"</a>)<br>";
content+="<p class=\"paragraph\">";
content+="<form name=\"frmshutdown\" method=\"POST\">";
content+=CreateFormPassword();
content+="<input type=\"hidden\" name=\"formaction\" value=\"shutdown\">";
content+="<input type=\"submit\" value=\""+m_trans->Get("web.page.home.shutdownfms")+"\">";
content+="</form>";
content+="</p>";
return content;
}
