X-Git-Url: https://git.pterodactylus.net/?p=fms.git;a=blobdiff_plain;f=src%2Fhttp%2Fpages%2Fpeertrustpage.cpp;h=b90a1060c0c6fb754b9e62e9d0b3642a4f510447;hp=4a451ed2dd37bf469fafe7ac05bfab8b1c88615c;hb=HEAD;hpb=37a8d59548287dcad78ef00e7b18058721eb9935

diff --git a/src/http/pages/peertrustpage.cpp b/src/http/pages/peertrustpage.cpp
index 4a451ed..b90a106 100644
--- a/src/http/pages/peertrustpage.cpp
+++ b/src/http/pages/peertrustpage.cpp
@@ -1,10 +1,100 @@
 #include "../../../include/http/pages/peertrustpage.h"
 #include "../../../include/stringfunctions.h"
+#include "../../../include/global.h"
 
 #ifdef XMEM
 	#include <xmem.h>
 #endif
 
+const std::string PeerTrustPage::BuildQueryString(const long startrow, const std::string &namesearch, const std::string &sortby, const std::string &sortorder, const int localidentityid)
+{
+	std::string returnval="";
+	std::string tempval="";
+	
+	if(startrow>=0)
+	{
+		StringFunctions::Convert(startrow,tempval);
+		returnval+="startrow="+tempval;
+	}
+
+	if(namesearch!="")
+	{
+		if(returnval!="")
+		{
+			returnval+="&";
+		}
+		returnval+="namesearch="+StringFunctions::UriEncode(namesearch);
+	}
+
+	if(sortby!="")
+	{
+		if(returnval!="")
+		{
+			returnval+="&";
+		}
+		returnval+="sortby="+sortby;
+	}
+
+	if(sortorder!="")
+	{
+		if(returnval!="")
+		{
+			returnval+="&";
+		}
+		returnval+="sortorder="+sortorder;
+	}
+
+	if(localidentityid>=0)
+	{
+		std::string localidentityidstr="";
+		StringFunctions::Convert(localidentityid,localidentityidstr);
+		if(returnval!="")
+		{
+			returnval+="&";
+		}
+		returnval+="localidentityid="+localidentityidstr;
+	}
+
+	return returnval;
+
+}
+
+const std::string PeerTrustPage::CreateLocalIdentityDropDown(const std::string &name, const int selectedlocalidentityid)
+{
+	std::string result="";
+	
+	result+="<select name=\""+name+"\">";
+	
+	SQLite3DB::Statement st=m_db->Prepare("SELECT LocalIdentityID,Name,PublicKey FROM tblLocalIdentity WHERE PublicKey IS NOT NULL ORDER BY Name COLLATE NOCASE;");
+	st.Step();
+
+	while(st.RowReturned())
+	{
+		int localidentityid=-1;
+		std::string localidentityidstr="";
+		std::string name="";
+		std::string publickey="";
+
+		st.ResultInt(0,localidentityid);
+		st.ResultText(1,name);
+		st.ResultText(2,publickey);
+
+		StringFunctions::Convert(localidentityid,localidentityidstr);
+
+		result+="<option value=\""+localidentityidstr+"\"";
+		if(localidentityid==selectedlocalidentityid)
+		{
+			result+=" SELECTED";
+		}
+		result+=">"+SanitizeOutput(CreateShortIdentityName(name,publickey))+"</option>";
+		st.Step();
+	}
+
+	result+="</select>";
+
+	return result;
+}
+
 const std::string PeerTrustPage::GeneratePage(const std::string &method, const std::map<std::string,std::string> &queryvars)
 {
 	int count=0;
@@ -15,39 +105,110 @@ const std::string PeerTrustPage::GeneratePage(const std::string &method, const s
 	std::string rowsperpagestr;
 	int startrow=0;
 	std::string startrowstr="0";
+	std::string namesearch="";
+	std::string sql;
+	std::string sortby="";
+	std::string sortorder="";
+	std::string localidentityidstr="";
+	int localidentityid=-1;
 
 	StringFunctions::Convert(rowsperpage,rowsperpagestr);
 
-	if(queryvars.find("formaction")!=queryvars.end() && (*queryvars.find("formaction")).second=="update")
+	// get localidentityid from querystring or load one from the database
+	if(queryvars.find("localidentityid")!=queryvars.end())
+	{
+		localidentityidstr=(*queryvars.find("localidentityid")).second;
+		StringFunctions::Convert(localidentityidstr,localidentityid);
+		// insert the ID into the temporary table so we remember the identity if we load the page later
+		m_db->Execute("DELETE FROM tmpLocalIdentityPeerTrustPage;");
+		SQLite3DB::Statement st=m_db->Prepare("INSERT INTO tmpLocalIdentityPeerTrustPage(LocalIdentityID) VALUES(?);");
+		st.Bind(0,localidentityid);
+		st.Step();
+	}
+	else
+	{
+		// try to get the localidentityid if it exists in the temp table, otherwise load the first identity in the database
+		SQLite3DB::Statement st=m_db->Prepare("SELECT LocalIdentityID FROM tmpLocalIdentityPeerTrustPage;");
+		st.Step();
+		if(st.RowReturned())
+		{
+			st.ResultInt(0,localidentityid);
+			StringFunctions::Convert(localidentityid,localidentityidstr);
+		}
+		else
+		{
+			st=m_db->Prepare("SELECT LocalIdentityID FROM tblLocalIdentity;");
+			st.Step();
+			if(st.RowReturned())
+			{
+				st.ResultInt(0,localidentityid);
+				StringFunctions::Convert(localidentityid,localidentityidstr);
+			}
+			st.Finalize();
+		}
+	}
+
+	if(localidentityid!=-1 && queryvars.find("formaction")!=queryvars.end() && (*queryvars.find("formaction")).second=="update" && ValidateFormPassword(queryvars))
 	{
 		std::vector<std::string> identityids;
 		std::vector<std::string> oldlmt;
 		std::vector<std::string> lmt;
 		std::vector<std::string> oldltlt;
 		std::vector<std::string> ltlt;
+		std::vector<std::string> oldmtc;
+		std::vector<std::string> mtc;
+		std::vector<std::string> oldtltc;
+		std::vector<std::string> tltc;
 		int localmessagetrust=0;
 		int localtrustlisttrust=0;
-		int identityid;
+		int identityid=-1;
 
 		CreateArgArray(queryvars,"identityid",identityids);
 		CreateArgArray(queryvars,"oldlocalmessagetrust",oldlmt);
 		CreateArgArray(queryvars,"localmessagetrust",lmt);
 		CreateArgArray(queryvars,"oldlocaltrustlisttrust",oldltlt);
 		CreateArgArray(queryvars,"localtrustlisttrust",ltlt);
-		
-		SQLite3DB::Statement update=m_db->Prepare("UPDATE tblIdentity SET LocalMessageTrust=?, LocalTrustListTrust=? WHERE IdentityID=?;");
+		CreateArgArray(queryvars,"oldmessagetrustcomment",oldmtc);
+		CreateArgArray(queryvars,"messagetrustcomment",mtc);
+		CreateArgArray(queryvars,"oldtrustlisttrustcomment",oldtltc);
+		CreateArgArray(queryvars,"trustlisttrustcomment",tltc);
+
+		SQLite3DB::Statement ins=m_db->Prepare("INSERT INTO tblIdentityTrust(LocalIdentityID,IdentityID) VALUES(?,?);");
+		SQLite3DB::Statement update=m_db->Prepare("UPDATE tblIdentityTrust SET LocalMessageTrust=?, LocalTrustListTrust=?, MessageTrustComment=?, TrustListTrustComment=? WHERE LocalIdentityID=? AND IdentityID=?;");
 
 		for(int i=0; i<identityids.size(); i++)
 		{
-			if(oldlmt[i]!=lmt[i] || oldltlt[i]!=ltlt[i])
+			if(oldlmt[i]!=lmt[i] || oldltlt[i]!=ltlt[i] || oldmtc[i]!=mtc[i] || oldtltc[i]!=tltc[i])
 			{
 				StringFunctions::Convert(lmt[i],localmessagetrust);
 				StringFunctions::Convert(ltlt[i],localtrustlisttrust);
 				StringFunctions::Convert(identityids[i],identityid);
 
-				update.Bind(0,localmessagetrust);
-				update.Bind(1,localtrustlisttrust);
-				update.Bind(2,identityid);
+				ins.Bind(0,localidentityid);
+				ins.Bind(1,identityid);
+				ins.Step();
+				ins.Reset();
+
+				if(lmt[i]!="")
+				{
+					update.Bind(0,localmessagetrust);
+				}
+				else
+				{
+					update.Bind(0);
+				}
+				if(ltlt[i]!="")
+				{
+					update.Bind(1,localtrustlisttrust);
+				}
+				else
+				{
+					update.Bind(1);
+				}
+				update.Bind(2,mtc[i]);
+				update.Bind(3,tltc[i]);
+				update.Bind(4,localidentityid);
+				update.Bind(5,identityid);
 				update.Step();
 				update.Reset();
 			}
@@ -68,20 +229,128 @@ const std::string PeerTrustPage::GeneratePage(const std::string &method, const s
 		StringFunctions::Convert(startrow,startrowstr);
 	}
 
+	// sort by
+	if(queryvars.find("sortby")!=queryvars.end())
+	{
+		sortby=(*queryvars.find("sortby")).second;
+		if(sortby!="Name" && sortby!="tblIdentityTrust.LocalMessageTrust" && sortby!="PeerMessageTrust" && sortby!="tblIdentityTrust.LocalTrustListTrust" && sortby!="PeerTrustListTrust" && sortby!="MessageCount")
+		{
+			sortby="Name";
+		}
+	}
+	else
+	{
+		sortby="Name";
+	}
+
+	// sort order
+	if(queryvars.find("sortorder")!=queryvars.end())
+	{
+		sortorder=(*queryvars.find("sortorder")).second;
+		if(sortorder!="ASC" && sortorder!="DESC")
+		{
+			sortorder="ASC";
+		}
+	}
+	else
+	{
+		sortorder="ASC";
+	}
+
+	// if we are searching by name
+	if(queryvars.find("namesearch")!=queryvars.end())
+	{
+		namesearch=(*queryvars.find("namesearch")).second;
+	}
+
 	content+="<h2>Peer Trust</h2>";
-	content+="Message Trust is how much you trust the identity to post good messages. Trust List Trust is how much weight you want the trust list of that identity to have when calculating the total. The local trust levels are set by you, and the peer trust levels are calculated by a weighted average using other identities trust lists.";
+	content+="Message Trust is how much you trust the identity to post good messages. Trust List Trust is how much weight you want the trust list of that identity to have when calculating the total. The local trust levels are set by you, and the peer trust levels are calculated by a weighted average using other identities' trust lists.  Trust is recalculated once an hour from received trust lists.  You must have at least 1 identity created and have received the SSK keypair for it from Freenet before setting trust.<br>";
+	content+="* - This identity is not publishing a trust list<br>";
+
+	// search drop down
+	content+="<div style=\"text-align:center;margin-bottom:5px;\">";
+	content+="<form name=\"frmsearch\" method=\"POST\" action=\""+m_pagename+"?"+BuildQueryString(0,"","","",localidentityid)+"\">";
+	content+="<input type=\"text\" name=\"namesearch\" value=\""+SanitizeOutput(namesearch)+"\">";
+	content+="<input type=\"submit\" value=\"Search\">";
+	content+="</form>";
+	content+="</div>";
+
+	content+="<div style=\"text-align:center;\">";
+	content+="<form name=\"frmlocalidentity\" method=\"POST\" action=\""+m_pagename+"?"+BuildQueryString(startrow,namesearch,sortby,sortorder,-1)+"\">";
+	content+="Load Trust List of ";
+	content+=CreateLocalIdentityDropDown("localidentityid",localidentityid);
+	content+="<input type=\"submit\" value=\"Load List\">";
+	content+="</form>";
+	content+="</div>";
+
 	content+="<form name=\"frmtrust\" method=\"POST\">";
+	content+=CreateFormPassword();
 	content+="<input type=\"hidden\" name=\"formaction\" value=\"update\">";
+	content+="<input type=\"hidden\" name=\"localidentityid\" value=\""+localidentityidstr+"\">";
 	content+="<input type=\"hidden\" name=\"startrow\" value=\""+startrowstr+"\">";
-	content+="<table>";
-	content+="<tr><th>Name</th><th>Local Message Trust</th><th>Peer Message Trust</th><th>Local Trust List Trust</th><th>Peer Trust List Trust</th></tr>";
+	if(namesearch!="")
+	{
+		content+="<input type=\"hidden\" name=\"namesearch\" value=\""+SanitizeOutput(namesearch)+"\">";
+	}
+	content+="<table class=\"small90\">";
+	content+="<tr><th><a href=\""+m_pagename+"?"+BuildQueryString(startrow,namesearch,"Name",ReverseSort("Name",sortby,sortorder),localidentityid)+"\">Name</a></th>";
+	content+="<th><a href=\""+m_pagename+"?"+BuildQueryString(startrow,namesearch,"tblIdentityTrust.LocalMessageTrust",ReverseSort("tblIdentityTrust.LocalMessageTrust",sortby,sortorder),localidentityid)+"\">Local Message Trust</a></th>";
+	content+="<th>Message Comment</th>";
+	content+="<th><a href=\""+m_pagename+"?"+BuildQueryString(startrow,namesearch,"PeerMessageTrust",ReverseSort("PeerMessageTrust",sortby,sortorder),localidentityid)+"\">Peer Message Trust</a></th>";
+	content+="<th><a href=\""+m_pagename+"?"+BuildQueryString(startrow,namesearch,"tblIdentityTrust.LocalTrustListTrust",ReverseSort("tblIdentityTrust.LocalTrustListTrust",sortby,sortorder),localidentityid)+"\">Local Trust List Trust</a></th>";
+	content+="<th>Trust Comment</th>";
+	content+="<th><a href=\""+m_pagename+"?"+BuildQueryString(startrow,namesearch,"PeerTrustListTrust",ReverseSort("PeerTrustListTrust",sortby,sortorder),localidentityid)+"\">Peer Trust List Trust</a></th>";
+	content+="<th><a href=\""+m_pagename+"?"+BuildQueryString(startrow,namesearch,"MessageCount",ReverseSort("MessageCount",sortby,sortorder),localidentityid)+"\">Message Count</a></th>";
+	content+="</tr>\r\n";
 	
-	SQLite3DB::Statement st=m_db->Prepare("SELECT COUNT(*) FROM tblIdentity;");
+	// get count of identities we are showing
+	sql="SELECT COUNT(*) FROM tblIdentity LEFT JOIN tblIdentityTrust ON tblIdentity.IdentityID=tblIdentityTrust.IdentityID ";
+	sql+="WHERE tblIdentityTrust.LocalIdentityID=? AND tblIdentity.Hidden='false'";
+	if(namesearch!="")
+	{
+		sql+=" AND (Name LIKE '%' || ? || '%' OR PublicKey LIKE '%' || ? || '%')";
+	}
+	sql+=";";
+	SQLite3DB::Statement st=m_db->Prepare(sql);
+	st.Bind(0,localidentityid);
+	if(namesearch!="")
+	{
+		st.Bind(1,namesearch);
+		st.Bind(2,namesearch);
+	}
 	st.Step();
 	st.ResultInt(0,identitycount);
 	st.Finalize();
 
-	st=m_db->Prepare("SELECT IdentityID,Name,LocalMessageTrust,PeerMessageTrust,LocalTrustListTrust,PeerTrustListTrust,PublicKey FROM tblIdentity ORDER BY Name COLLATE NOCASE LIMIT "+startrowstr+","+rowsperpagestr+";");
+	sql="SELECT tblIdentity.IdentityID,Name,tblIdentityTrust.LocalMessageTrust,PeerMessageTrust,tblIdentityTrust.LocalTrustListTrust,PeerTrustListTrust,PublicKey,tblIdentityTrust.MessageTrustComment,tblIdentityTrust.TrustListTrustComment,COUNT(MessageID) AS 'MessageCount',tblIdentity.PublishTrustList ";
+	sql+="FROM tblIdentity LEFT JOIN tblIdentityTrust ON tblIdentity.IdentityID=tblIdentityTrust.IdentityID LEFT JOIN tblMessage ON tblIdentity.IdentityID=tblMessage.IdentityID ";
+	sql+="WHERE tblIdentityTrust.LocalIdentityID=? AND tblIdentity.Hidden='false'";
+	if(namesearch!="")
+	{
+		sql+=" AND (Name LIKE  '%' || ? || '%' OR PublicKey LIKE '%' || ? || '%')";
+	}
+	sql+=" GROUP BY tblIdentity.IdentityID";
+	sql+=" ORDER BY";
+	if(sortby=="Name")
+	{
+		sql+=" Name COLLATE NOCASE";
+	}
+	else
+	{
+		sql+=" "+sortby;
+	}
+	if(sortorder!="")
+	{
+		sql+=" "+sortorder;
+	}
+	sql+=" LIMIT "+startrowstr+","+rowsperpagestr+";";
+	st=m_db->Prepare(sql);
+	st.Bind(0,localidentityid);
+	if(namesearch!="")
+	{
+		st.Bind(1,namesearch);
+		st.Bind(2,namesearch);
+	}
 	st.Step();
 
 	while(st.RowReturned())
@@ -93,6 +362,10 @@ const std::string PeerTrustPage::GeneratePage(const std::string &method, const s
 		std::string localtrustlisttrust;
 		std::string peertrustlisttrust;
 		std::string publickey;
+		std::string messagetrustcomment="";
+		std::string trustlisttrustcomment="";
+		std::string messagecountstr="";
+		std::string publishtrustlist="";
 
 		StringFunctions::Convert(count,countstr);
 
@@ -103,37 +376,56 @@ const std::string PeerTrustPage::GeneratePage(const std::string &method, const s
 		st.ResultText(4,localtrustlisttrust);
 		st.ResultText(5,peertrustlisttrust);
 		st.ResultText(6,publickey);
+		st.ResultText(7,messagetrustcomment);
+		st.ResultText(8,trustlisttrustcomment);
+		st.ResultText(9,messagecountstr);
+		st.ResultText(10,publishtrustlist);
 
 		content+="<tr>";
 		content+="<td title=\""+publickey+"\">";
 		content+="<input type=\"hidden\" name=\"identityid["+countstr+"]\" value=\""+identityid+"\">";
+		content+="<a href=\"peerdetails.htm?identityid="+identityid+"\">";
 		if(name!="")
 		{
-			content+=name;
+			content+=SanitizeOutput(CreateShortIdentityName(name,publickey));
 		}
 		else
 		{
 			content+="[Unknown Name]";
 		}
+		content+="</a>";
 		content+="</td>";
 		content+="<td "+GetClassString(localmessagetrust)+">";
 		content+="<input type=\"hidden\" name=\"oldlocalmessagetrust["+countstr+"]\" value=\""+localmessagetrust+"\">";
-		content+="<input type=\"text\" name=\"localmessagetrust["+countstr+"]\" value=\""+localmessagetrust+"\" size=\"2\" maxlength=\"3\"></td>";
+		content+="<input type=\"text\" name=\"localmessagetrust["+countstr+"]\" value=\""+localmessagetrust+"\" size=\"2\" maxlength=\"3\" class=\"small90\"></td>";
+		content+="<td "+GetClassString(localmessagetrust)+">";
+		content+="<input type=\"hidden\" name=\"oldmessagetrustcomment["+countstr+"]\" value=\""+SanitizeOutput(messagetrustcomment)+"\">";
+		content+="<input type=\"text\" name=\"messagetrustcomment["+countstr+"]\" value=\""+SanitizeOutput(messagetrustcomment)+"\" maxlength=\"50\" class=\"small90\">";
+		content+="</td>";		
 		content+="<td "+GetClassString(peermessagetrust)+">";
 		content+=peermessagetrust+"</td>";
 		content+="<td "+GetClassString(localtrustlisttrust)+">";
 		content+="<input type=\"hidden\" name=\"oldlocaltrustlisttrust["+countstr+"]\" value=\""+localtrustlisttrust+"\">";
-		content+="<input type=\"text\" name=\"localtrustlisttrust["+countstr+"]\" value=\""+localtrustlisttrust+"\" size=\"2\" maxlength=\"3\"></td>";
+		content+="<input type=\"text\" name=\"localtrustlisttrust["+countstr+"]\" value=\""+localtrustlisttrust+"\" size=\"2\" maxlength=\"3\" class=\"small90\">";
+		if(publishtrustlist=="false")
+		{
+			content+="*";
+		}
+		content+="</td>";
+		content+="<td "+GetClassString(localtrustlisttrust)+">";
+		content+="<input type=\"hidden\" name=\"oldtrustlisttrustcomment["+countstr+"]\" value=\""+SanitizeOutput(trustlisttrustcomment)+"\">";
+		content+="<input type=\"text\" name=\"trustlisttrustcomment["+countstr+"]\" value=\""+SanitizeOutput(trustlisttrustcomment)+"\" maxlength=\"50\" class=\"small90\">";
+		content+="</td>";
 		content+="<td "+GetClassString(peertrustlisttrust)+">";
 		content+=peertrustlisttrust+"</td>";
-		content+="</tr>";
+		content+="<td>"+messagecountstr+"</td>";
+		content+="</tr>\r\n";
 		st.Step();
 		count++;
 	}
 	
 	if(startrow>0 || startrow+rowsperpage<identitycount)
 	{
-		int tempint;
 		std::string tempstr;
 		int cols=0;
 
@@ -141,27 +433,26 @@ const std::string PeerTrustPage::GeneratePage(const std::string &method, const s
 		if(startrow>0)
 		{
 			StringFunctions::Convert(startrow-rowsperpage,tempstr);
-			content+="<td colspan=\"2\" align=\"left\"><a href=\"peertrust.htm?startrow="+tempstr+"\"><-- Previous Page</a></td>";
-			cols+=2;
+			content+="<td colspan=\"3\" align=\"left\"><a href=\""+m_pagename+"?"+BuildQueryString(startrow-rowsperpage,namesearch,sortby,sortorder,localidentityid)+"\"><-- Previous Page</a></td>";
+			cols+=3;
 		}
 		if(startrow+rowsperpage<identitycount)
 		{
-			StringFunctions::Convert(startrow+rowsperpage,tempstr);
-			while(cols<3)
+			while(cols<5)
 			{
 				content+="<td></td>";
 				cols++;
 			}
-			content+="<td colspan=\"2\" align=\"right\"><a href=\"peertrust.htm?startrow="+tempstr+"\">Next Page --></a></td>";
+			content+="<td colspan=\"3\" align=\"right\"><a href=\""+m_pagename+"?"+BuildQueryString(startrow+rowsperpage,namesearch,sortby,sortorder,localidentityid)+"\">Next Page --></a></td>";
 		}
 		content+="</tr>";
 	}
 
-	content+="<tr><td colspan=\"5\"><input type=\"submit\" value=\"Update Trust\"></td></tr>";
+	content+="<tr><td colspan=\"8\"><center><input type=\"submit\" value=\"Update Trust\"></center></td></tr>";
 	content+="</table>";
 	content+="</form>";
 
-	return "HTTP/1.1 200 OK\r\nContent-Type: text/html\r\n\r\n"+StringFunctions::Replace(m_template,"[CONTENT]",content);
+	return StringFunctions::Replace(m_template,"[CONTENT]",content);
 }
 
 const std::string PeerTrustPage::GetClassString(const std::string &trustlevel)
@@ -183,14 +474,21 @@ const std::string PeerTrustPage::GetClassString(const std::string &trustlevel)
 	}
 }
 
-const bool PeerTrustPage::WillHandleURI(const std::string &uri)
+const std::string PeerTrustPage::ReverseSort(const std::string &sortname, const std::string &currentsortby, const std::string &currentsortorder)
 {
-	if(uri.find("peertrust.")!=std::string::npos)
+	if(sortname==currentsortby)
 	{
-		return true;
+		if(currentsortorder=="ASC")
+		{
+			return "DESC";
+		}
+		else
+		{
+			return "ASC";
+		}
 	}
 	else
 	{
-		return false;
+		return currentsortorder;
 	}
 }