X-Git-Url: https://git.pterodactylus.net/?a=blobdiff_plain;f=src%2Fhttp%2Fpages%2Fpeerdetailspage.cpp;h=9a8fd1bf7a9c9496b2c70c7362312a36c502636d;hb=8a0a83a78390f22f99d4487cda2569909dfbc28e;hp=7f06fd2eb51142d72224cad67eb87a084adcf4b7;hpb=4430e7762844c66428b6f822288beb71b7f82b95;p=fms.git

diff --git a/src/http/pages/peerdetailspage.cpp b/src/http/pages/peerdetailspage.cpp
index 7f06fd2..9a8fd1b 100644
--- a/src/http/pages/peerdetailspage.cpp
+++ b/src/http/pages/peerdetailspage.cpp
@@ -17,6 +17,7 @@ const std::string PeerDetailsPage::GeneratePage(const std::string &method, const
 	std::string keypart="";
 	std::string lastseen="";
 	std::string dateadded="";
+	std::string addedmethod="";
 
 	if(queryvars.find("identityid")!=queryvars.end() && (*queryvars.find("identityid")).second!="")
 	{
@@ -31,7 +32,7 @@ const std::string PeerDetailsPage::GeneratePage(const std::string &method, const
 		del.Step();
 	}
 
-	SQLite3DB::Statement st=m_db->Prepare("SELECT Name,PublicKey,DateAdded,LastSeen FROM tblIdentity WHERE IdentityID=?;");
+	SQLite3DB::Statement st=m_db->Prepare("SELECT Name,PublicKey,DateAdded,LastSeen,AddedMethod FROM tblIdentity WHERE IdentityID=?;");
 	st.Bind(0,identityid);
 	st.Step();
 
@@ -42,11 +43,13 @@ const std::string PeerDetailsPage::GeneratePage(const std::string &method, const
 		st.ResultText(1,publickey);
 		st.ResultText(2,dateadded);
 		st.ResultText(3,lastseen);
+		st.ResultText(4,addedmethod);
 
 		content+="<tr><td>Name</td><td>"+SanitizeOutput(name)+"</td></tr>";
 		content+="<tr><td>Public Key</td><td class=\"smaller\">"+SanitizeOutput(publickey)+"</td></tr>";
 		content+="<tr><td>Date Added</td><td>"+dateadded+"</td></tr>";
 		content+="<tr><td>Last Seen</td><td>"+lastseen+"</td></tr>";
+		content+="<tr><td>Added Method</td><td class=\"smaller\">"+SanitizeOutput(addedmethod)+"</td></tr>";
 	}
 
 	// get message count posted by this identity
@@ -73,24 +76,28 @@ const std::string PeerDetailsPage::GeneratePage(const std::string &method, const
 	content+="</table>";
 
 
-	st=m_db->Prepare("SELECT Name,PublicKey,MessageTrust,TrustListTrust,tblIdentity.IdentityID FROM tblPeerTrust INNER JOIN tblIdentity ON tblPeerTrust.TargetIdentityID=tblIdentity.IdentityID WHERE tblPeerTrust.IdentityID=? ORDER BY Name COLLATE NOCASE;");
+	st=m_db->Prepare("SELECT Name,PublicKey,MessageTrust,TrustListTrust,tblIdentity.IdentityID,tblPeerTrust.MessageTrustComment,tblPeerTrust.TrustListTrustComment FROM tblPeerTrust INNER JOIN tblIdentity ON tblPeerTrust.TargetIdentityID=tblIdentity.IdentityID WHERE tblPeerTrust.IdentityID=? ORDER BY Name COLLATE NOCASE;");
 	st.Bind(0,identityid);
 	st.Step();
 
 	content+="<table>";
-	content+="<tr><th colspan=\"3\">";
+	content+="<tr><th colspan=\"5\">";
 	content+="Trust List of this identity";
 	content+="</th></tr>";
-	content+="<tr><td></td><th>Message Trust</th><th>Trust List Trust</th></tr>";
+	content+="<tr><td></td><th>Message Trust</th><th>Message Comment</th><th>Trust List Trust</th><th>Trust Comment</th></tr>";
 	while(st.RowReturned())
 	{
 		std::string thisid="";
+		std::string messagetrustcomment="";
+		std::string trustlisttrustcomment="";
 
 		st.ResultText(0,name);
 		st.ResultText(1,publickey);
 		st.ResultText(2,messagetrust);
 		st.ResultText(3,trustlisttrust);
 		st.ResultText(4,thisid);
+		st.ResultText(5,messagetrustcomment);
+		st.ResultText(6,trustlisttrustcomment);
 
 		if(publickey.size()>8)
 		{
@@ -100,29 +107,35 @@ const std::string PeerDetailsPage::GeneratePage(const std::string &method, const
 		content+="<tr>";
 		content+="<td><a href=\"peerdetails.htm?identityid="+thisid+"\">"+SanitizeOutput(name+keypart)+"...</a></td>";
 		content+="<td "+GetClassString(messagetrust)+">"+messagetrust+"</td>";
+		content+="<td>"+SanitizeOutput(messagetrustcomment)+"</td>";
 		content+="<td "+GetClassString(trustlisttrust)+">"+trustlisttrust+"</td>";
+		content+="<td>"+SanitizeOutput(trustlisttrustcomment)+"</td>";
 		content+="</tr>\r\n";
 
 		st.Step();
 	}
 
-	st=m_db->Prepare("SELECT Name,PublicKey,MessageTrust,TrustListTrust,tblIdentity.IdentityID FROM tblPeerTrust INNER JOIN tblIdentity ON tblPeerTrust.IdentityID=tblIdentity.IdentityID WHERE tblPeerTrust.TargetIdentityID=? ORDER BY Name COLLATE NOCASE;");
+	st=m_db->Prepare("SELECT Name,PublicKey,MessageTrust,TrustListTrust,tblIdentity.IdentityID,tblPeerTrust.MessageTrustComment,tblPeerTrust.TrustListTrustComment FROM tblPeerTrust INNER JOIN tblIdentity ON tblPeerTrust.IdentityID=tblIdentity.IdentityID WHERE tblPeerTrust.TargetIdentityID=? ORDER BY Name COLLATE NOCASE;");
 	st.Bind(0,identityid);
 	st.Step();
 
-	content+="<tr><th colspan=\"3\">";
+	content+="<tr><th colspan=\"5\">";
 	content+="Trust of this identity from other identities";
 	content+="</th></tr>";
-	content+="<tr><td></td><th>Message Trust</th><th>Trust List Trust</th></tr>";
+	content+="<tr><td></td><th>Message Trust</th><th>Message Comment</th><th>Trust List Trust</th><th>Trust Comment</th></tr>";
 	while(st.RowReturned())
 	{
 		std::string thisid="";
+		std::string messagetrustcomment="";
+		std::string trustlisttrustcomment="";
 
 		st.ResultText(0,name);
 		st.ResultText(1,publickey);
 		st.ResultText(2,messagetrust);
 		st.ResultText(3,trustlisttrust);
 		st.ResultText(4,thisid);
+		st.ResultText(5,messagetrustcomment);
+		st.ResultText(6,trustlisttrustcomment);
 		
 		if(publickey.size()>8)
 		{
@@ -132,7 +145,9 @@ const std::string PeerDetailsPage::GeneratePage(const std::string &method, const
 		content+="<tr>";
 		content+="<td><a href=\"peerdetails.htm?identityid="+thisid+"\">"+SanitizeOutput(name+keypart)+"...</a></td>";
 		content+="<td "+GetClassString(messagetrust)+">"+messagetrust+"</td>";
+		content+="<td>"+SanitizeOutput(messagetrustcomment)+"</td>";
 		content+="<td "+GetClassString(trustlisttrust)+">"+trustlisttrust+"</td>";
+		content+="<td>"+SanitizeOutput(trustlisttrustcomment)+"</td>";
 		content+="</tr>";
 
 		st.Step();