#include <xmem.h>\r
#endif\r
\r
+const std::string PeerTrustPage::BuildQueryString(const long startrow, const std::string &namesearch, const std::string &sortby, const std::string &sortorder)\r
+{\r
+ std::string returnval="";\r
+ std::string tempval="";\r
+ \r
+ if(startrow>=0)\r
+ {\r
+ StringFunctions::Convert(startrow,tempval);\r
+ returnval+="startrow="+tempval;\r
+ }\r
+\r
+ if(namesearch!="")\r
+ {\r
+ if(returnval!="")\r
+ {\r
+ returnval+="&";\r
+ }\r
+ returnval+="namesearch="+namesearch;\r
+ }\r
+\r
+ if(sortby!="")\r
+ {\r
+ if(returnval!="")\r
+ {\r
+ returnval+="&";\r
+ }\r
+ returnval+="sortby="+sortby;\r
+ }\r
+\r
+ if(sortorder!="")\r
+ {\r
+ if(returnval!="")\r
+ {\r
+ returnval+="&";\r
+ }\r
+ returnval+="sortorder="+sortorder;\r
+ }\r
+\r
+ return returnval;\r
+\r
+}\r
+\r
const std::string PeerTrustPage::GeneratePage(const std::string &method, const std::map<std::string,std::string> &queryvars)\r
{\r
int count=0;\r
std::string startrowstr="0";\r
std::string namesearch="";\r
std::string sql;\r
+ std::string sortby="";\r
+ std::string sortorder="";\r
\r
StringFunctions::Convert(rowsperpage,rowsperpagestr);\r
\r
StringFunctions::Convert(startrow,startrowstr);\r
}\r
\r
+ // sort by\r
+ if(queryvars.find("sortby")!=queryvars.end())\r
+ {\r
+ sortby=(*queryvars.find("sortby")).second;\r
+ }\r
+ else\r
+ {\r
+ sortby="Name";\r
+ }\r
+\r
+ // sort order\r
+ if(queryvars.find("sortorder")!=queryvars.end())\r
+ {\r
+ sortorder=(*queryvars.find("sortorder")).second;\r
+ }\r
+ else\r
+ {\r
+ sortorder="ASC";\r
+ }\r
+\r
// if we are searching by name\r
if(queryvars.find("namesearch")!=queryvars.end())\r
{\r
}\r
\r
content+="<h2>Peer Trust</h2>";\r
- 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.";\r
+ 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.";\r
content+="<div style=\"text-align:center;\">";\r
content+="<form name=\"frmsearch\" method=\"POST\" action=\"peertrust.htm\">";\r
content+="<input type=\"text\" name=\"namesearch\">";\r
content+="<input type=\"hidden\" name=\"formaction\" value=\"update\">";\r
content+="<input type=\"hidden\" name=\"startrow\" value=\""+startrowstr+"\">";\r
content+="<table>";\r
- content+="<tr><th>Name</th><th>Local Message Trust</th><th>Peer Message Trust</th><th>Local Trust List Trust</th><th>Peer Trust List Trust</th></tr>";\r
+ content+="<tr><th><a href=\"peertrust.htm?"+BuildQueryString(startrow,namesearch,"Name",ReverseSort("Name",sortby,sortorder))+"\">Name</a></th>";\r
+ content+="<th><a href=\"peertrust.htm?"+BuildQueryString(startrow,namesearch,"LocalMessageTrust",ReverseSort("LocalMessageTrust",sortby,sortorder))+"\">Local Message Trust</a></th>";\r
+ content+="<th><a href=\"peertrust.htm?"+BuildQueryString(startrow,namesearch,"PeerMessageTrust",ReverseSort("PeerMessageTrust",sortby,sortorder))+"\">Peer Message Trust</a></th>";\r
+ content+="<th><a href=\"peertrust.htm?"+BuildQueryString(startrow,namesearch,"LocalTrustListTrust",ReverseSort("LocalTrustListTrust",sortby,sortorder))+"\">Local Trust List Trust</a></th>";\r
+ content+="<th><a href=\"peertrust.htm?"+BuildQueryString(startrow,namesearch,"PeerTrustListTrust",ReverseSort("PeerTrustListTrust",sortby,sortorder))+"\">Peer Trust List Trust</a></th></tr>";\r
\r
// get count of identities we are showing\r
sql="SELECT COUNT(*) FROM tblIdentity";\r
{\r
sql+=" WHERE Name LIKE '%' || ? || '%'";\r
}\r
- sql+=" ORDER BY Name COLLATE NOCASE LIMIT "+startrowstr+","+rowsperpagestr+";";\r
+ sql+=" ORDER BY";\r
+ if(sortby=="Name")\r
+ {\r
+ sql+=" Name COLLATE NOCASE";\r
+ }\r
+ else\r
+ {\r
+ sql+=" "+sortby;\r
+ }\r
+ if(sortorder!="")\r
+ {\r
+ sql+=" "+sortorder;\r
+ }\r
+ sql+=" LIMIT "+startrowstr+","+rowsperpagestr+";";\r
st=m_db->Prepare(sql);\r
if(namesearch!="")\r
{\r
if(startrow>0)\r
{\r
StringFunctions::Convert(startrow-rowsperpage,tempstr);\r
- content+="<td colspan=\"2\" align=\"left\"><a href=\"peertrust.htm?startrow="+tempstr+"&namesearch="+namesearch+"\"><-- Previous Page</a></td>";\r
+ content+="<td colspan=\"2\" align=\"left\"><a href=\"peertrust.htm?"+BuildQueryString(startrow-rowsperpage,namesearch,sortby,sortorder)+"\"><-- Previous Page</a></td>";\r
cols+=2;\r
}\r
if(startrow+rowsperpage<identitycount)\r
{\r
- StringFunctions::Convert(startrow+rowsperpage,tempstr);\r
while(cols<3)\r
{\r
content+="<td></td>";\r
cols++;\r
}\r
- content+="<td colspan=\"2\" align=\"right\"><a href=\"peertrust.htm?startrow="+tempstr+"&namesearch="+namesearch+"\">Next Page --></a></td>";\r
+ content+="<td colspan=\"2\" align=\"right\"><a href=\"peertrust.htm?"+BuildQueryString(startrow+rowsperpage,namesearch,sortby,sortorder)+"\">Next Page --></a></td>";\r
}\r
content+="</tr>";\r
}\r
}\r
}\r
\r
+const std::string PeerTrustPage::ReverseSort(const std::string &sortname, const std::string ¤tsortby, const std::string ¤tsortorder)\r
+{\r
+ if(sortname==currentsortby)\r
+ {\r
+ if(currentsortorder=="ASC")\r
+ {\r
+ return "DESC";\r
+ }\r
+ else\r
+ {\r
+ return "ASC";\r
+ }\r
+ }\r
+ else\r
+ {\r
+ return currentsortorder;\r
+ }\r
+}\r
+\r
const bool PeerTrustPage::WillHandleURI(const std::string &uri)\r
{\r
if(uri.find("peertrust.")!=std::string::npos)\r