src/http/pages/peertrustpage.cpp

   1 #include "../../../include/http/pages/peertrustpage.h"\r
   2 #include "../../../include/stringfunctions.h"\r
   3 #include "../../../include/global.h"\r
   4 \r
   5 #ifdef XMEM\r
   6         #include <xmem.h>\r
   7 #endif\r
   8 \r
   9 const std::string PeerTrustPage::BuildQueryString(const long startrow, const std::string &namesearch, const std::string &sortby, const std::string &sortorder, const int localidentityid)\r
  10 {\r
  11         std::string returnval="";\r
  12         std::string tempval="";\r
  13         \r
  14         if(startrow>=0)\r
  15         {\r
  16                 StringFunctions::Convert(startrow,tempval);\r
  17                 returnval+="startrow="+tempval;\r
  18         }\r
  19 \r
  20         if(namesearch!="")\r
  21         {\r
  22                 if(returnval!="")\r
  23                 {\r
  24                         returnval+="&";\r
  25                 }\r
  26                 returnval+="namesearch="+namesearch;\r
  27         }\r
  28 \r
  29         if(sortby!="")\r
  30         {\r
  31                 if(returnval!="")\r
  32                 {\r
  33                         returnval+="&";\r
  34                 }\r
  35                 returnval+="sortby="+sortby;\r
  36         }\r
  37 \r
  38         if(sortorder!="")\r
  39         {\r
  40                 if(returnval!="")\r
  41                 {\r
  42                         returnval+="&";\r
  43                 }\r
  44                 returnval+="sortorder="+sortorder;\r
  45         }\r
  46 \r
  47         if(localidentityid>=0)\r
  48         {\r
  49                 std::string localidentityidstr="";\r
  50                 StringFunctions::Convert(localidentityid,localidentityidstr);\r
  51                 if(returnval!="")\r
  52                 {\r
  53                         returnval+="&";\r
  54                 }\r
  55                 returnval+="localidentityid="+localidentityidstr;\r
  56         }\r
  57 \r
  58         return returnval;\r
  59 \r
  60 }\r
  61 \r
  62 const std::string PeerTrustPage::CreateLocalIdentityDropDown(const std::string &name, const int selectedlocalidentityid)\r
  63 {\r
  64         std::string result="";\r
  65         \r
  66         result+="<select name=\""+name+"\">";\r
  67         \r
  68         SQLite3DB::Statement st=m_db->Prepare("SELECT LocalIdentityID,Name,PublicKey FROM tblLocalIdentity WHERE PublicKey IS NOT NULL ORDER BY Name COLLATE NOCASE;");\r
  69         st.Step();\r
  70 \r
  71         while(st.RowReturned())\r
  72         {\r
  73                 int localidentityid=-1;\r
  74                 std::string localidentityidstr="";\r
  75                 std::string name="";\r
  76                 std::string publickey="";\r
  77 \r
  78                 st.ResultInt(0,localidentityid);\r
  79                 st.ResultText(1,name);\r
  80                 st.ResultText(2,publickey);\r
  81 \r
  82                 StringFunctions::Convert(localidentityid,localidentityidstr);\r
  83 \r
  84                 result+="<option value=\""+localidentityidstr+"\"";\r
  85                 if(localidentityid==selectedlocalidentityid)\r
  86                 {\r
  87                         result+=" SELECTED";\r
  88                 }\r
  89                 result+=">"+SanitizeOutput(CreateShortIdentityName(name,publickey))+"</option>";\r
  90                 st.Step();\r
  91         }\r
  92 \r
  93         result+="</select>";\r
  94 \r
  95         return result;\r
  96 }\r
  97 \r
  98 const std::string PeerTrustPage::GeneratePage(const std::string &method, const std::map<std::string,std::string> &queryvars)\r
  99 {\r
 100         int count=0;\r
 101         std::string countstr;\r
 102         std::string content="";\r
 103         int identitycount=0;            // total number of ids we know\r
 104         int rowsperpage=25;                     // how many ids to show per page\r
 105         std::string rowsperpagestr;\r
 106         int startrow=0;\r
 107         std::string startrowstr="0";\r
 108         std::string namesearch="";\r
 109         std::string sql;\r
 110         std::string sortby="";\r
 111         std::string sortorder="";\r
 112         std::string localidentityidstr="";\r
 113         int localidentityid=-1;\r
 114 \r
 115         StringFunctions::Convert(rowsperpage,rowsperpagestr);\r
 116 \r
 117         // get localidentityid from querystring or load one from the database\r
 118         if(queryvars.find("localidentityid")!=queryvars.end())\r
 119         {\r
 120                 localidentityidstr=(*queryvars.find("localidentityid")).second;\r
 121                 StringFunctions::Convert(localidentityidstr,localidentityid);\r
 122         }\r
 123         else\r
 124         {\r
 125                 SQLite3DB::Statement st=m_db->Prepare("SELECT LocalIdentityID FROM tblLocalIdentity;");\r
 126                 st.Step();\r
 127                 if(st.RowReturned())\r
 128                 {\r
 129                         st.ResultInt(0,localidentityid);\r
 130                         StringFunctions::Convert(localidentityid,localidentityidstr);\r
 131                 }\r
 132         }\r
 133 \r
 134         if(localidentityid!=-1 && queryvars.find("formaction")!=queryvars.end() && (*queryvars.find("formaction")).second=="update")\r
 135         {\r
 136                 std::vector<std::string> identityids;\r
 137                 std::vector<std::string> oldlmt;\r
 138                 std::vector<std::string> lmt;\r
 139                 std::vector<std::string> oldltlt;\r
 140                 std::vector<std::string> ltlt;\r
 141                 std::vector<std::string> oldmtc;\r
 142                 std::vector<std::string> mtc;\r
 143                 std::vector<std::string> oldtltc;\r
 144                 std::vector<std::string> tltc;\r
 145                 int localmessagetrust=0;\r
 146                 int localtrustlisttrust=0;\r
 147                 int identityid=-1;\r
 148 \r
 149                 CreateArgArray(queryvars,"identityid",identityids);\r
 150                 CreateArgArray(queryvars,"oldlocalmessagetrust",oldlmt);\r
 151                 CreateArgArray(queryvars,"localmessagetrust",lmt);\r
 152                 CreateArgArray(queryvars,"oldlocaltrustlisttrust",oldltlt);\r
 153                 CreateArgArray(queryvars,"localtrustlisttrust",ltlt);\r
 154                 CreateArgArray(queryvars,"oldmessagetrustcomment",oldmtc);\r
 155                 CreateArgArray(queryvars,"messagetrustcomment",mtc);\r
 156                 CreateArgArray(queryvars,"oldtrustlisttrustcomment",oldtltc);\r
 157                 CreateArgArray(queryvars,"trustlisttrustcomment",tltc);\r
 158 \r
 159                 SQLite3DB::Statement ins=m_db->Prepare("INSERT INTO tblIdentityTrust(LocalIdentityID,IdentityID) VALUES(?,?);");\r
 160                 SQLite3DB::Statement update=m_db->Prepare("UPDATE tblIdentityTrust SET LocalMessageTrust=?, LocalTrustListTrust=?, MessageTrustComment=?, TrustListTrustComment=? WHERE LocalIdentityID=? AND IdentityID=?;");\r
 161 \r
 162                 for(int i=0; i<identityids.size(); i++)\r
 163                 {\r
 164                         if(oldlmt[i]!=lmt[i] || oldltlt[i]!=ltlt[i] || oldmtc[i]!=mtc[i] || oldtltc[i]!=tltc[i])\r
 165                         {\r
 166                                 StringFunctions::Convert(lmt[i],localmessagetrust);\r
 167                                 StringFunctions::Convert(ltlt[i],localtrustlisttrust);\r
 168                                 StringFunctions::Convert(identityids[i],identityid);\r
 169 \r
 170                                 ins.Bind(0,localidentityid);\r
 171                                 ins.Bind(1,identityid);\r
 172                                 ins.Step();\r
 173                                 ins.Reset();\r
 174 \r
 175                                 if(lmt[i]!="")\r
 176                                 {\r
 177                                         update.Bind(0,localmessagetrust);\r
 178                                 }\r
 179                                 else\r
 180                                 {\r
 181                                         update.Bind(0);\r
 182                                 }\r
 183                                 if(ltlt[i]!="")\r
 184                                 {\r
 185                                         update.Bind(1,localtrustlisttrust);\r
 186                                 }\r
 187                                 else\r
 188                                 {\r
 189                                         update.Bind(1);\r
 190                                 }\r
 191                                 update.Bind(2,mtc[i]);\r
 192                                 update.Bind(3,tltc[i]);\r
 193                                 update.Bind(4,localidentityid);\r
 194                                 update.Bind(5,identityid);\r
 195                                 update.Step();\r
 196                                 update.Reset();\r
 197                         }\r
 198                 }\r
 199 \r
 200         }\r
 201 \r
 202         // if startrow is specified\r
 203         if(queryvars.find("startrow")!=queryvars.end())\r
 204         {\r
 205                 startrowstr=(*queryvars.find("startrow")).second;\r
 206                 // convert back and forth, just in case a number wasn't passed in startrow\r
 207                 StringFunctions::Convert(startrowstr,startrow);\r
 208                 if(startrow<0)\r
 209                 {\r
 210                         startrow=0;\r
 211                 }\r
 212                 StringFunctions::Convert(startrow,startrowstr);\r
 213         }\r
 214 \r
 215         // sort by\r
 216         if(queryvars.find("sortby")!=queryvars.end())\r
 217         {\r
 218                 sortby=(*queryvars.find("sortby")).second;\r
 219         }\r
 220         else\r
 221         {\r
 222                 sortby="Name";\r
 223         }\r
 224 \r
 225         // sort order\r
 226         if(queryvars.find("sortorder")!=queryvars.end())\r
 227         {\r
 228                 sortorder=(*queryvars.find("sortorder")).second;\r
 229         }\r
 230         else\r
 231         {\r
 232                 sortorder="ASC";\r
 233         }\r
 234 \r
 235         // if we are searching by name\r
 236         if(queryvars.find("namesearch")!=queryvars.end())\r
 237         {\r
 238                 namesearch=(*queryvars.find("namesearch")).second;\r
 239         }\r
 240 \r
 241         content+="<h2>Peer Trust</h2>";\r
 242         content+="Message Trust is how much you trust the identity to post good messages. Trust List Trust is how much weight you want the trust list of that identity to have when calculating the total. The local trust levels are set by you, and the peer trust levels are calculated by a weighted average using other identities' trust lists.  Trust is recalculated once an hour from received trust lists.  You must have at least 1 identity created and have received the SSK keypair for it from Freenet before setting trust.";\r
 243         \r
 244         // search drop down\r
 245         content+="<div style=\"text-align:center;margin-bottom:5px;\">";\r
 246         content+="<form name=\"frmsearch\" method=\"POST\" action=\"peertrust.htm?"+BuildQueryString(0,"","","",localidentityid)+"\">";\r
 247         content+="<input type=\"text\" name=\"namesearch\" value=\""+SanitizeOutput(namesearch)+"\">";\r
 248         content+="<input type=\"submit\" value=\"Search\">";\r
 249         content+="</form>";\r
 250         content+="</div>";\r
 251 \r
 252         content+="<div style=\"text-align:center;\">";\r
 253         content+="<form name=\"frmlocalidentity\" method=\"POST\" action=\"peertrust.htm?"+BuildQueryString(startrow,namesearch,sortby,sortorder,-1)+"\">";\r
 254         content+="Load Trust List of ";\r
 255         content+=CreateLocalIdentityDropDown("localidentityid",localidentityid);\r
 256         content+="<input type=\"submit\" value=\"Load List\">";\r
 257         content+="</form>";\r
 258         content+="</div>";\r
 259 \r
 260         content+="<form name=\"frmtrust\" method=\"POST\">";\r
 261         content+="<input type=\"hidden\" name=\"formaction\" value=\"update\">";\r
 262         content+="<input type=\"hidden\" name=\"localidentityid\" value=\""+localidentityidstr+"\">";\r
 263         content+="<input type=\"hidden\" name=\"startrow\" value=\""+startrowstr+"\">";\r
 264         if(namesearch!="")\r
 265         {\r
 266                 content+="<input type=\"hidden\" name=\"namesearch\" value=\""+SanitizeOutput(namesearch)+"\">";\r
 267         }\r
 268         content+="<table class=\"small90\">";\r
 269         content+="<tr><th><a href=\"peertrust.htm?"+BuildQueryString(startrow,namesearch,"Name",ReverseSort("Name",sortby,sortorder),localidentityid)+"\">Name</a></th>";\r
 270         content+="<th><a href=\"peertrust.htm?"+BuildQueryString(startrow,namesearch,"tblIdentityTrust.LocalMessageTrust",ReverseSort("tblIdentityTrust.LocalMessageTrust",sortby,sortorder),localidentityid)+"\">Local Message Trust</a></th>";\r
 271         content+="<th>Message Comment</th>";\r
 272         content+="<th><a href=\"peertrust.htm?"+BuildQueryString(startrow,namesearch,"PeerMessageTrust",ReverseSort("PeerMessageTrust",sortby,sortorder),localidentityid)+"\">Peer Message Trust</a></th>";\r
 273         content+="<th><a href=\"peertrust.htm?"+BuildQueryString(startrow,namesearch,"tblIdentityTrust.LocalTrustListTrust",ReverseSort("tblIdentityTrust.LocalTrustListTrust",sortby,sortorder),localidentityid)+"\">Local Trust List Trust</a></th>";\r
 274         content+="<th>Trust Comment</th>";\r
 275         content+="<th><a href=\"peertrust.htm?"+BuildQueryString(startrow,namesearch,"PeerTrustListTrust",ReverseSort("PeerTrustListTrust",sortby,sortorder),localidentityid)+"\">Peer Trust List Trust</a></th>";\r
 276         content+="<th><a href=\"peertrust.htm?"+BuildQueryString(startrow,namesearch,"MessageCount",ReverseSort("MessageCount",sortby,sortorder),localidentityid)+"\">Message Count</a></th>";\r
 277         content+="</tr>\r\n";\r
 278         \r
 279 //TODO - modify this query\r
 280         // get count of identities we are showing\r
 281         sql="SELECT COUNT(*) FROM tblIdentity LEFT JOIN (SELECT IdentityID FROM tblIdentityTrust WHERE LocalIdentityID=?) AS 'tblIdentityTrust' ON tblIdentity.IdentityID=tblIdentityTrust.IdentityID ";\r
 282         sql+="WHERE tblIdentity.Hidden='false'";\r
 283         if(namesearch!="")\r
 284         {\r
 285                 sql+=" AND (Name LIKE '%' || ? || '%' OR PublicKey LIKE '%' || ? || '%')";\r
 286         }\r
 287         sql+=";";\r
 288         SQLite3DB::Statement st=m_db->Prepare(sql);\r
 289         st.Bind(0,localidentityid);\r
 290         if(namesearch!="")\r
 291         {\r
 292                 st.Bind(1,namesearch);\r
 293                 st.Bind(2,namesearch);\r
 294         }\r
 295         st.Step();\r
 296         st.ResultInt(0,identitycount);\r
 297         st.Finalize();\r
 298 \r
 299         sql="SELECT tblIdentity.IdentityID,Name,tblIdentityTrust.LocalMessageTrust,PeerMessageTrust,tblIdentityTrust.LocalTrustListTrust,PeerTrustListTrust,PublicKey,tblIdentityTrust.MessageTrustComment,tblIdentityTrust.TrustListTrustComment,COUNT(MessageID) AS 'MessageCount' ";\r
 300         sql+="FROM tblIdentity LEFT JOIN (SELECT LocalIdentityID,IdentityID,LocalMessageTrust,LocalTrustListTrust,MessageTrustComment,TrustListTrustComment FROM tblIdentityTrust WHERE LocalIdentityID=?) AS tblIdentityTrust ON tblIdentity.IdentityID=tblIdentityTrust.IdentityID LEFT JOIN tblMessage ON tblIdentity.IdentityID=tblMessage.IdentityID ";\r
 301         sql+="WHERE tblIdentity.Hidden='false'";\r
 302         if(namesearch!="")\r
 303         {\r
 304                 sql+=" AND (Name LIKE  '%' || ? || '%' OR PublicKey LIKE '%' || ? || '%')";\r
 305         }\r
 306         sql+=" GROUP BY tblIdentity.IdentityID";\r
 307         sql+=" ORDER BY";\r
 308         if(sortby=="Name")\r
 309         {\r
 310                 sql+=" Name COLLATE NOCASE";\r
 311         }\r
 312         else\r
 313         {\r
 314                 sql+=" "+sortby;\r
 315         }\r
 316         if(sortorder!="")\r
 317         {\r
 318                 sql+=" "+sortorder;\r
 319         }\r
 320         sql+=" LIMIT "+startrowstr+","+rowsperpagestr+";";\r
 321         st=m_db->Prepare(sql);\r
 322         st.Bind(0,localidentityid);\r
 323         if(namesearch!="")\r
 324         {\r
 325                 st.Bind(1,namesearch);\r
 326                 st.Bind(2,namesearch);\r
 327         }\r
 328         st.Step();\r
 329 \r
 330         while(st.RowReturned())\r
 331         {\r
 332                 std::string identityid;\r
 333                 std::string name;\r
 334                 std::string localmessagetrust;\r
 335                 std::string peermessagetrust;\r
 336                 std::string localtrustlisttrust;\r
 337                 std::string peertrustlisttrust;\r
 338                 std::string publickey;\r
 339                 std::string messagetrustcomment="";\r
 340                 std::string trustlisttrustcomment="";\r
 341                 std::string messagecountstr="";\r
 342 \r
 343                 StringFunctions::Convert(count,countstr);\r
 344 \r
 345                 st.ResultText(0,identityid);\r
 346                 st.ResultText(1,name);\r
 347                 st.ResultText(2,localmessagetrust);\r
 348                 st.ResultText(3,peermessagetrust);\r
 349                 st.ResultText(4,localtrustlisttrust);\r
 350                 st.ResultText(5,peertrustlisttrust);\r
 351                 st.ResultText(6,publickey);\r
 352                 st.ResultText(7,messagetrustcomment);\r
 353                 st.ResultText(8,trustlisttrustcomment);\r
 354                 st.ResultText(9,messagecountstr);\r
 355 \r
 356                 content+="<tr>";\r
 357                 content+="<td title=\""+publickey+"\">";\r
 358                 content+="<input type=\"hidden\" name=\"identityid["+countstr+"]\" value=\""+identityid+"\">";\r
 359                 content+="<a href=\"peerdetails.htm?identityid="+identityid+"\">";\r
 360                 if(name!="")\r
 361                 {\r
 362                         content+=SanitizeOutput(CreateShortIdentityName(name,publickey));\r
 363                 }\r
 364                 else\r
 365                 {\r
 366                         content+="[Unknown Name]";\r
 367                 }\r
 368                 content+="</a>";\r
 369                 content+="</td>";\r
 370                 content+="<td "+GetClassString(localmessagetrust)+">";\r
 371                 content+="<input type=\"hidden\" name=\"oldlocalmessagetrust["+countstr+"]\" value=\""+localmessagetrust+"\">";\r
 372                 content+="<input type=\"text\" name=\"localmessagetrust["+countstr+"]\" value=\""+localmessagetrust+"\" size=\"2\" maxlength=\"3\" class=\"small90\"></td>";\r
 373                 content+="<td "+GetClassString(localmessagetrust)+">";\r
 374                 content+="<input type=\"hidden\" name=\"oldmessagetrustcomment["+countstr+"]\" value=\""+SanitizeOutput(messagetrustcomment)+"\">";\r
 375                 content+="<input type=\"text\" name=\"messagetrustcomment["+countstr+"]\" value=\""+SanitizeOutput(messagetrustcomment)+"\" maxlength=\"50\" class=\"small90\">";\r
 376                 content+="</td>";               \r
 377                 content+="<td "+GetClassString(peermessagetrust)+">";\r
 378                 content+=peermessagetrust+"</td>";\r
 379                 content+="<td "+GetClassString(localtrustlisttrust)+">";\r
 380                 content+="<input type=\"hidden\" name=\"oldlocaltrustlisttrust["+countstr+"]\" value=\""+localtrustlisttrust+"\">";\r
 381                 content+="<input type=\"text\" name=\"localtrustlisttrust["+countstr+"]\" value=\""+localtrustlisttrust+"\" size=\"2\" maxlength=\"3\" class=\"small90\"></td>";\r
 382                 content+="<td "+GetClassString(localtrustlisttrust)+">";\r
 383                 content+="<input type=\"hidden\" name=\"oldtrustlisttrustcomment["+countstr+"]\" value=\""+SanitizeOutput(trustlisttrustcomment)+"\">";\r
 384                 content+="<input type=\"text\" name=\"trustlisttrustcomment["+countstr+"]\" value=\""+SanitizeOutput(trustlisttrustcomment)+"\" maxlength=\"50\" class=\"small90\">";\r
 385                 content+="</td>";\r
 386                 content+="<td "+GetClassString(peertrustlisttrust)+">";\r
 387                 content+=peertrustlisttrust+"</td>";\r
 388                 content+="<td>"+messagecountstr+"</td>";\r
 389                 content+="</tr>\r\n";\r
 390                 st.Step();\r
 391                 count++;\r
 392         }\r
 393         \r
 394         if(startrow>0 || startrow+rowsperpage<identitycount)\r
 395         {\r
 396                 std::string tempstr;\r
 397                 int cols=0;\r
 398 \r
 399                 content+="<tr>";\r
 400                 if(startrow>0)\r
 401                 {\r
 402                         StringFunctions::Convert(startrow-rowsperpage,tempstr);\r
 403                         content+="<td colspan=\"3\" align=\"left\"><a href=\"peertrust.htm?"+BuildQueryString(startrow-rowsperpage,namesearch,sortby,sortorder,localidentityid)+"\"><-- Previous Page</a></td>";\r
 404                         cols+=3;\r
 405                 }\r
 406                 if(startrow+rowsperpage<identitycount)\r
 407                 {\r
 408                         while(cols<5)\r
 409                         {\r
 410                                 content+="<td></td>";\r
 411                                 cols++;\r
 412                         }\r
 413                         content+="<td colspan=\"3\" align=\"right\"><a href=\"peertrust.htm?"+BuildQueryString(startrow+rowsperpage,namesearch,sortby,sortorder,localidentityid)+"\">Next Page --></a></td>";\r
 414                 }\r
 415                 content+="</tr>";\r
 416         }\r
 417 \r
 418         content+="<tr><td colspan=\"8\"><center><input type=\"submit\" value=\"Update Trust\"></center></td></tr>";\r
 419         content+="</table>";\r
 420         content+="</form>";\r
 421 \r
 422         return "HTTP/1.1 200 OK\r\nContent-Type: text/html\r\n\r\n"+StringFunctions::Replace(m_template,"[CONTENT]",content);\r
 423 }\r
 424 \r
 425 const std::string PeerTrustPage::GetClassString(const std::string &trustlevel)\r
 426 {\r
 427         int tempint=0;\r
 428         std::string tempstr;\r
 429 \r
 430         StringFunctions::Convert(trustlevel,tempint);\r
 431         tempint/=10;\r
 432         StringFunctions::Convert(tempint,tempstr);\r
 433 \r
 434         if(trustlevel!="")\r
 435         {\r
 436                 return "class=\"trust"+tempstr+"\"";\r
 437         }\r
 438         else\r
 439         {\r
 440                 return "";\r
 441         }\r
 442 }\r
 443 \r
 444 const std::string PeerTrustPage::ReverseSort(const std::string &sortname, const std::string &currentsortby, const std::string &currentsortorder)\r
 445 {\r
 446         if(sortname==currentsortby)\r
 447         {\r
 448                 if(currentsortorder=="ASC")\r
 449                 {\r
 450                         return "DESC";\r
 451                 }\r
 452                 else\r
 453                 {\r
 454                         return "ASC";\r
 455                 }\r
 456         }\r
 457         else\r
 458         {\r
 459                 return currentsortorder;\r
 460         }\r
 461 }\r
 462 \r
 463 const bool PeerTrustPage::WillHandleURI(const std::string &uri)\r
 464 {\r
 465         if(uri.find("peertrust.")!=std::string::npos)\r
 466         {\r
 467                 return true;\r
 468         }\r
 469         else\r
 470         {\r
 471                 return false;\r
 472         }\r
 473 }\r