1 #include "../../../include/http/pages/peerdetailspage.h"
\r
2 #include "../../../include/stringfunctions.h"
\r
3 #include "../../../include/option.h"
\r
4 #include "../../../include/global.h"
\r
10 const std::string PeerDetailsPage::GeneratePage(const std::string &method, const std::map<std::string,std::string> &queryvars)
\r
12 std::string content="";
\r
14 std::string identityidstr="";
\r
16 std::string publickey;
\r
17 std::string messagetrust;
\r
18 std::string trustlisttrust;
\r
19 std::string lastseen="";
\r
20 std::string dateadded="";
\r
21 std::string addedmethod="";
\r
23 std::string fcphost="";
\r
24 std::string hidden="";
\r
25 int freesiteedition=-1;
\r
27 std::string fproxyport="8888";
\r
28 Option::Instance()->Get("FProxyPort",fproxyport);
\r
30 if(queryvars.find("identityid")!=queryvars.end() && (*queryvars.find("identityid")).second!="")
\r
32 identityidstr=(*queryvars.find("identityid")).second;
\r
33 StringFunctions::Convert((*queryvars.find("identityid")).second,identityid);
\r
36 if(identityid!=0 && queryvars.find("formaction")!=queryvars.end() && (*queryvars.find("formaction")).second=="deletemessages")
\r
38 SQLite3DB::Statement del=m_db->Prepare("DELETE FROM tblMessage WHERE IdentityID=?;");
\r
39 del.Bind(0,identityid);
\r
43 if(identityid!=0 && queryvars.find("formaction")!=queryvars.end() && (*queryvars.find("formaction")).second=="hide")
\r
45 SQLite3DB::Statement del=m_db->Prepare("UPDATE tblIdentity SET Hidden='true' WHERE IdentityID=?;");
\r
46 del.Bind(0,identityid);
\r
50 if(identityid!=0 && queryvars.find("formaction")!=queryvars.end() && (*queryvars.find("formaction")).second=="show")
\r
52 SQLite3DB::Statement del=m_db->Prepare("UPDATE tblIdentity SET Hidden='false' WHERE IdentityID=?;");
\r
53 del.Bind(0,identityid);
\r
57 Option::Instance()->Get("FCPHost",fcphost);
\r
59 SQLite3DB::Statement st=m_db->Prepare("SELECT Name,PublicKey,DateAdded,LastSeen,AddedMethod,Hidden,FreesiteEdition FROM tblIdentity WHERE IdentityID=?;");
\r
60 st.Bind(0,identityid);
\r
64 if(st.RowReturned())
\r
66 st.ResultText(0,name);
\r
67 st.ResultText(1,publickey);
\r
68 st.ResultText(2,dateadded);
\r
69 st.ResultText(3,lastseen);
\r
70 st.ResultText(4,addedmethod);
\r
71 st.ResultText(5,hidden);
\r
72 if(st.ResultNull(6)==false)
\r
74 st.ResultInt(6,freesiteedition);
\r
78 if(freesiteedition>=0 && usk.find("SSK@")==0)
\r
80 std::string messagebase="";
\r
81 std::string editionstr="";
\r
82 Option::Instance()->Get("MessageBase",messagebase);
\r
84 StringFunctions::Convert(freesiteedition,editionstr);
\r
85 usk="USK"+usk+messagebase+"/"+editionstr+"/";
\r
92 content+="<tr><td>Name</td><td>"+SanitizeOutput(name)+"</td></tr>";
\r
93 content+="<tr><td>Public Key</td><td class=\"smaller\">"+SanitizeOutput(publickey)+"</td></tr>";
\r
96 content+="<tr><td>Freesite</td><td class=\"smaller\"><a href=\"http://"+fcphost+":"+fproxyport+"/"+SanitizeOutput(usk)+"\">"+SanitizeOutput(usk)+"</a></td></tr>";
\r
98 content+="<tr><td>Date Added</td><td>"+dateadded+"</td></tr>";
\r
99 content+="<tr><td>Last Seen</td><td>"+lastseen+"</td></tr>";
\r
100 content+="<tr><td>Added Method</td><td class=\"smaller\">"+SanitizeOutput(addedmethod)+"</td></tr>";
\r
101 content+="<tr><td>Hidden in Main Peer Trust Page</td>";
\r
102 content+="<td>"+hidden;
\r
103 content+=" <form name=\"frmhidden\" method=\"POST\">";
\r
104 content+="<input type=\"hidden\" name=\"identityid\" value=\""+identityidstr+"\">";
\r
105 if(hidden=="false")
\r
107 content+="<input type=\"hidden\" name=\"formaction\" value=\"hide\">";
\r
108 content+="<input type=\"submit\" value=\"Hide\">";
\r
112 content+="<input type=\"hidden\" name=\"formaction\" value=\"show\">";
\r
113 content+="<input type=\"submit\" value=\"Show\">";
\r
115 content+="</form>";
\r
116 content+="</td></tr>";
\r
119 // get message count posted by this identity
\r
120 st=m_db->Prepare("SELECT COUNT(MessageID) FROM tblMessage WHERE IdentityID=?;");
\r
121 st.Bind(0,identityid);
\r
124 if(st.RowReturned())
\r
126 std::string messagecountstr="0";
\r
127 st.ResultText(0,messagecountstr);
\r
129 content+="<td>Message Count</td>";
\r
130 content+="<td>"+messagecountstr;
\r
131 content+=" <form name=\"frmdeletemessages\" method=\"POST\">";
\r
132 content+="<input type=\"hidden\" name=\"identityid\" value=\""+identityidstr+"\">";
\r
133 content+="<input type=\"hidden\" name=\"formaction\" value=\"deletemessages\">";
\r
134 content+="<input type=\"submit\" value=\"Delete Messages\">";
\r
135 content+="</form>";
\r
140 content+="</table>";
\r
143 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;");
\r
144 st.Bind(0,identityid);
\r
147 content+="<table>";
\r
148 content+="<tr><th colspan=\"5\">";
\r
149 content+="Trust List of this identity";
\r
150 content+="</th></tr>";
\r
151 content+="<tr><td></td><th>Message Trust</th><th>Message Comment</th><th>Trust List Trust</th><th>Trust Comment</th></tr>";
\r
152 while(st.RowReturned())
\r
154 std::string thisid="";
\r
155 std::string messagetrustcomment="";
\r
156 std::string trustlisttrustcomment="";
\r
158 st.ResultText(0,name);
\r
159 st.ResultText(1,publickey);
\r
160 st.ResultText(2,messagetrust);
\r
161 st.ResultText(3,trustlisttrust);
\r
162 st.ResultText(4,thisid);
\r
163 st.ResultText(5,messagetrustcomment);
\r
164 st.ResultText(6,trustlisttrustcomment);
\r
167 content+="<td><a href=\"peerdetails.htm?identityid="+thisid+"\">"+SanitizeOutput(CreateShortIdentityName(name,publickey))+"</a></td>";
\r
168 content+="<td "+GetClassString(messagetrust)+">"+messagetrust+"</td>";
\r
169 content+="<td>"+SanitizeOutput(messagetrustcomment)+"</td>";
\r
170 content+="<td "+GetClassString(trustlisttrust)+">"+trustlisttrust+"</td>";
\r
171 content+="<td>"+SanitizeOutput(trustlisttrustcomment)+"</td>";
\r
172 content+="</tr>\r\n";
\r
177 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;");
\r
178 st.Bind(0,identityid);
\r
181 content+="<tr><th colspan=\"5\"><hr></th></tr>";
\r
182 content+="<tr><th colspan=\"5\">";
\r
183 content+="Trust of this identity from other identities";
\r
184 content+="</th></tr>";
\r
185 content+="<tr><td></td><th>Message Trust</th><th>Message Comment</th><th>Trust List Trust</th><th>Trust Comment</th></tr>";
\r
186 while(st.RowReturned())
\r
188 std::string thisid="";
\r
189 std::string messagetrustcomment="";
\r
190 std::string trustlisttrustcomment="";
\r
192 st.ResultText(0,name);
\r
193 st.ResultText(1,publickey);
\r
194 st.ResultText(2,messagetrust);
\r
195 st.ResultText(3,trustlisttrust);
\r
196 st.ResultText(4,thisid);
\r
197 st.ResultText(5,messagetrustcomment);
\r
198 st.ResultText(6,trustlisttrustcomment);
\r
201 content+="<td><a href=\"peerdetails.htm?identityid="+thisid+"\">"+SanitizeOutput(CreateShortIdentityName(name,publickey))+"</a></td>";
\r
202 content+="<td "+GetClassString(messagetrust)+">"+messagetrust+"</td>";
\r
203 content+="<td>"+SanitizeOutput(messagetrustcomment)+"</td>";
\r
204 content+="<td "+GetClassString(trustlisttrust)+">"+trustlisttrust+"</td>";
\r
205 content+="<td>"+SanitizeOutput(trustlisttrustcomment)+"</td>";
\r
210 content+="</table>";
\r
212 return "HTTP/1.1 200 OK\r\nContent-Type: text/html\r\n\r\n"+StringFunctions::Replace(m_template,"[CONTENT]",content);
\r
215 const std::string PeerDetailsPage::GetClassString(const std::string &trustlevel)
\r
218 std::string tempstr;
\r
220 StringFunctions::Convert(trustlevel,tempint);
\r
222 StringFunctions::Convert(tempint,tempstr);
\r
226 return "class=\"trust"+tempstr+"\"";
\r
234 const bool PeerDetailsPage::WillHandleURI(const std::string &uri)
\r
236 if(uri.find("peerdetails.")!=std::string::npos)
\r