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