version 0.2.8
[fms.git] / src / http / pages / peerdetailspage.cpp
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
5 \r
6 #ifdef XMEM\r
7         #include <xmem.h>\r
8 #endif\r
9 \r
10 const std::string PeerDetailsPage::GeneratePage(const std::string &method, const std::map<std::string,std::string> &queryvars)\r
11 {\r
12         std::string content="";\r
13         int identityid=0;\r
14         std::string identityidstr="";\r
15         std::string name;\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
22         std::string usk="";\r
23         std::string fcphost="";\r
24         std::string hidden="";\r
25 \r
26         if(queryvars.find("identityid")!=queryvars.end() && (*queryvars.find("identityid")).second!="")\r
27         {\r
28                 identityidstr=(*queryvars.find("identityid")).second;\r
29                 StringFunctions::Convert((*queryvars.find("identityid")).second,identityid);\r
30         }\r
31 \r
32         if(identityid!=0 && queryvars.find("formaction")!=queryvars.end() && (*queryvars.find("formaction")).second=="deletemessages")\r
33         {\r
34                 SQLite3DB::Statement del=m_db->Prepare("DELETE FROM tblMessage WHERE IdentityID=?;");\r
35                 del.Bind(0,identityid);\r
36                 del.Step();\r
37         }\r
38 \r
39         if(identityid!=0 && queryvars.find("formaction")!=queryvars.end() && (*queryvars.find("formaction")).second=="hide")\r
40         {\r
41                 SQLite3DB::Statement del=m_db->Prepare("UPDATE tblIdentity SET Hidden='true' WHERE IdentityID=?;");\r
42                 del.Bind(0,identityid);\r
43                 del.Step();\r
44         }\r
45         \r
46         if(identityid!=0 && queryvars.find("formaction")!=queryvars.end() && (*queryvars.find("formaction")).second=="show")\r
47         {\r
48                 SQLite3DB::Statement del=m_db->Prepare("UPDATE tblIdentity SET Hidden='false' WHERE IdentityID=?;");\r
49                 del.Bind(0,identityid);\r
50                 del.Step();\r
51         }\r
52 \r
53         Option::Instance()->Get("FCPHost",fcphost);\r
54 \r
55         SQLite3DB::Statement st=m_db->Prepare("SELECT Name,PublicKey,DateAdded,LastSeen,AddedMethod,Hidden FROM tblIdentity WHERE IdentityID=?;");\r
56         st.Bind(0,identityid);\r
57         st.Step();\r
58 \r
59         content+="<table>";\r
60         if(st.RowReturned())\r
61         {\r
62                 st.ResultText(0,name);\r
63                 st.ResultText(1,publickey);\r
64                 st.ResultText(2,dateadded);\r
65                 st.ResultText(3,lastseen);\r
66                 st.ResultText(4,addedmethod);\r
67                 st.ResultText(5,hidden);\r
68 \r
69                 usk=publickey;\r
70                 if(usk.find("SSK@")==0)\r
71                 {\r
72                         std::string messagebase="";\r
73                         Option::Instance()->Get("MessageBase",messagebase);\r
74                         usk.erase(0,3);\r
75                         usk="USK"+usk+messagebase+"/0/";\r
76                 }\r
77 \r
78                 content+="<tr><td>Name</td><td>"+SanitizeOutput(name)+"</td></tr>";\r
79                 content+="<tr><td>Public Key</td><td class=\"smaller\">"+SanitizeOutput(publickey)+"</td></tr>";\r
80                 content+="<tr><td>Freesite</td><td class=\"smaller\"><a href=\"http://"+fcphost+":8888/"+SanitizeOutput(usk)+"\">"+SanitizeOutput(usk)+"</a></td></tr>";\r
81                 content+="<tr><td>Date Added</td><td>"+dateadded+"</td></tr>";\r
82                 content+="<tr><td>Last Seen</td><td>"+lastseen+"</td></tr>";\r
83                 content+="<tr><td>Added Method</td><td class=\"smaller\">"+SanitizeOutput(addedmethod)+"</td></tr>";\r
84                 content+="<tr><td>Hidden in Main Peer Trust Page</td>";\r
85                 content+="<td>"+hidden;\r
86                 content+="&nbsp;<form name=\"frmhidden\" method=\"POST\">";\r
87                 content+="<input type=\"hidden\" name=\"identityid\" value=\""+identityidstr+"\">";\r
88                 if(hidden=="false")\r
89                 {\r
90                         content+="<input type=\"hidden\" name=\"formaction\" value=\"hide\">";\r
91                         content+="<input type=\"submit\" value=\"Hide\">";\r
92                 }\r
93                 else\r
94                 {\r
95                         content+="<input type=\"hidden\" name=\"formaction\" value=\"show\">";\r
96                         content+="<input type=\"submit\" value=\"Show\">";\r
97                 }\r
98                 content+="</form>";\r
99                 content+="</td></tr>";\r
100         }\r
101 \r
102         // get message count posted by this identity\r
103         st=m_db->Prepare("SELECT COUNT(MessageID) FROM tblMessage WHERE IdentityID=?;");\r
104         st.Bind(0,identityid);\r
105         st.Step();\r
106 \r
107         if(st.RowReturned())\r
108         {\r
109                 std::string messagecountstr="0";\r
110                 st.ResultText(0,messagecountstr);\r
111                 content+="<tr>";\r
112                 content+="<td>Message Count</td>";\r
113                 content+="<td>"+messagecountstr;\r
114                 content+="&nbsp;&nbsp;<form name=\"frmdeletemessages\" method=\"POST\">";\r
115                 content+="<input type=\"hidden\" name=\"identityid\" value=\""+identityidstr+"\">";\r
116                 content+="<input type=\"hidden\" name=\"formaction\" value=\"deletemessages\">";\r
117                 content+="<input type=\"submit\" value=\"Delete Messages\">";\r
118                 content+="</form>";\r
119                 content+="</td>";\r
120                 content+="</tr>";\r
121         }\r
122 \r
123         content+="</table>";\r
124 \r
125 \r
126         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
127         st.Bind(0,identityid);\r
128         st.Step();\r
129 \r
130         content+="<table>";\r
131         content+="<tr><th colspan=\"5\">";\r
132         content+="Trust List of this identity";\r
133         content+="</th></tr>";\r
134         content+="<tr><td></td><th>Message Trust</th><th>Message Comment</th><th>Trust List Trust</th><th>Trust Comment</th></tr>";\r
135         while(st.RowReturned())\r
136         {\r
137                 std::string thisid="";\r
138                 std::string messagetrustcomment="";\r
139                 std::string trustlisttrustcomment="";\r
140 \r
141                 st.ResultText(0,name);\r
142                 st.ResultText(1,publickey);\r
143                 st.ResultText(2,messagetrust);\r
144                 st.ResultText(3,trustlisttrust);\r
145                 st.ResultText(4,thisid);\r
146                 st.ResultText(5,messagetrustcomment);\r
147                 st.ResultText(6,trustlisttrustcomment);\r
148 \r
149                 content+="<tr>";\r
150                 content+="<td><a href=\"peerdetails.htm?identityid="+thisid+"\">"+SanitizeOutput(CreateShortIdentityName(name,publickey))+"</a></td>";\r
151                 content+="<td "+GetClassString(messagetrust)+">"+messagetrust+"</td>";\r
152                 content+="<td>"+SanitizeOutput(messagetrustcomment)+"</td>";\r
153                 content+="<td "+GetClassString(trustlisttrust)+">"+trustlisttrust+"</td>";\r
154                 content+="<td>"+SanitizeOutput(trustlisttrustcomment)+"</td>";\r
155                 content+="</tr>\r\n";\r
156 \r
157                 st.Step();\r
158         }\r
159 \r
160         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
161         st.Bind(0,identityid);\r
162         st.Step();\r
163 \r
164         content+="<tr><th colspan=\"5\"><hr></th></tr>";\r
165         content+="<tr><th colspan=\"5\">";\r
166         content+="Trust of this identity from other identities";\r
167         content+="</th></tr>";\r
168         content+="<tr><td></td><th>Message Trust</th><th>Message Comment</th><th>Trust List Trust</th><th>Trust Comment</th></tr>";\r
169         while(st.RowReturned())\r
170         {\r
171                 std::string thisid="";\r
172                 std::string messagetrustcomment="";\r
173                 std::string trustlisttrustcomment="";\r
174 \r
175                 st.ResultText(0,name);\r
176                 st.ResultText(1,publickey);\r
177                 st.ResultText(2,messagetrust);\r
178                 st.ResultText(3,trustlisttrust);\r
179                 st.ResultText(4,thisid);\r
180                 st.ResultText(5,messagetrustcomment);\r
181                 st.ResultText(6,trustlisttrustcomment);\r
182 \r
183                 content+="<tr>";\r
184                 content+="<td><a href=\"peerdetails.htm?identityid="+thisid+"\">"+SanitizeOutput(CreateShortIdentityName(name,publickey))+"</a></td>";\r
185                 content+="<td "+GetClassString(messagetrust)+">"+messagetrust+"</td>";\r
186                 content+="<td>"+SanitizeOutput(messagetrustcomment)+"</td>";\r
187                 content+="<td "+GetClassString(trustlisttrust)+">"+trustlisttrust+"</td>";\r
188                 content+="<td>"+SanitizeOutput(trustlisttrustcomment)+"</td>";\r
189                 content+="</tr>";\r
190 \r
191                 st.Step();\r
192         }\r
193         content+="</table>";\r
194 \r
195         return "HTTP/1.1 200 OK\r\nContent-Type: text/html\r\n\r\n"+StringFunctions::Replace(m_template,"[CONTENT]",content);\r
196 }\r
197 \r
198 const std::string PeerDetailsPage::GetClassString(const std::string &trustlevel)\r
199 {\r
200         int tempint=0;\r
201         std::string tempstr;\r
202 \r
203         StringFunctions::Convert(trustlevel,tempint);\r
204         tempint/=10;\r
205         StringFunctions::Convert(tempint,tempstr);\r
206 \r
207         if(trustlevel!="")\r
208         {\r
209                 return "class=\"trust"+tempstr+"\"";\r
210         }\r
211         else\r
212         {\r
213                 return "";\r
214         }\r
215 }\r
216 \r
217 const bool PeerDetailsPage::WillHandleURI(const std::string &uri)\r
218 {\r
219         if(uri.find("peerdetails.")!=std::string::npos)\r
220         {\r
221                 return true;\r
222         }\r
223         else\r
224         {\r
225                 return false;\r
226         }\r
227 }\r