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