version 0.1.10
[fms.git] / src / http / pages / peertrustpage.cpp
index b353243..38bddbf 100644 (file)
@@ -15,6 +15,8 @@ const std::string PeerTrustPage::GeneratePage(const std::string &method, const s
        std::string rowsperpagestr;\r
        int startrow=0;\r
        std::string startrowstr="0";\r
+       std::string namesearch="";\r
+       std::string sql;\r
 \r
        StringFunctions::Convert(rowsperpage,rowsperpagestr);\r
 \r
@@ -68,20 +70,53 @@ const std::string PeerTrustPage::GeneratePage(const std::string &method, const s
                StringFunctions::Convert(startrow,startrowstr);\r
        }\r
 \r
+       // if we are searching by name\r
+       if(queryvars.find("namesearch")!=queryvars.end())\r
+       {\r
+               namesearch=(*queryvars.find("namesearch")).second;\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+="<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=\"submit\" value=\"Search\">";\r
+       content+="</form>";\r
+       content+="</div>";\r
        content+="<form name=\"frmtrust\" method=\"POST\">";\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
        \r
-       SQLite3DB::Statement st=m_db->Prepare("SELECT COUNT(*) FROM tblIdentity;");\r
+       // get count of identities we are showing\r
+       sql="SELECT COUNT(*) FROM tblIdentity";\r
+       if(namesearch!="")\r
+       {\r
+               sql+=" WHERE Name LIKE '%' || ? || '%'";\r
+       }\r
+       sql+=";";\r
+       SQLite3DB::Statement st=m_db->Prepare(sql);\r
+       if(namesearch!="")\r
+       {\r
+               st.Bind(0,namesearch);\r
+       }\r
        st.Step();\r
        st.ResultInt(0,identitycount);\r
        st.Finalize();\r
 \r
-       st=m_db->Prepare("SELECT IdentityID,Name,LocalMessageTrust,PeerMessageTrust,LocalTrustListTrust,PeerTrustListTrust,PublicKey FROM tblIdentity ORDER BY Name COLLATE NOCASE LIMIT "+startrowstr+","+rowsperpagestr+";");\r
+       sql="SELECT IdentityID,Name,LocalMessageTrust,PeerMessageTrust,LocalTrustListTrust,PeerTrustListTrust,PublicKey FROM tblIdentity";\r
+       if(namesearch!="")\r
+       {\r
+               sql+=" WHERE Name LIKE  '%' || ? || '%'";\r
+       }\r
+       sql+=" ORDER BY Name COLLATE NOCASE LIMIT "+startrowstr+","+rowsperpagestr+";";\r
+       st=m_db->Prepare(sql);\r
+       if(namesearch!="")\r
+       {\r
+               st.Bind(0,namesearch);\r
+       }\r
        st.Step();\r
 \r
        while(st.RowReturned())\r
@@ -113,6 +148,7 @@ const std::string PeerTrustPage::GeneratePage(const std::string &method, const s
                content+="<tr>";\r
                content+="<td title=\""+publickey+"\">";\r
                content+="<input type=\"hidden\" name=\"identityid["+countstr+"]\" value=\""+identityid+"\">";\r
+               content+="<a href=\"peerdetails.htm?identityid="+identityid+"\">";\r
                if(name!="")\r
                {\r
                        content+=SanitizeOutput(name+keypart)+"...";\r
@@ -121,6 +157,7 @@ const std::string PeerTrustPage::GeneratePage(const std::string &method, const s
                {\r
                        content+="[Unknown Name]";\r
                }\r
+               content+="</a>";\r
                content+="</td>";\r
                content+="<td "+GetClassString(localmessagetrust)+">";\r
                content+="<input type=\"hidden\" name=\"oldlocalmessagetrust["+countstr+"]\" value=\""+localmessagetrust+"\">";\r
@@ -146,7 +183,7 @@ const std::string PeerTrustPage::GeneratePage(const std::string &method, const s
                if(startrow>0)\r
                {\r
                        StringFunctions::Convert(startrow-rowsperpage,tempstr);\r
-                       content+="<td colspan=\"2\" align=\"left\"><a href=\"peertrust.htm?startrow="+tempstr+"\"><-- Previous Page</a></td>";\r
+                       content+="<td colspan=\"2\" align=\"left\"><a href=\"peertrust.htm?startrow="+tempstr+"&namesearch="+namesearch+"\"><-- Previous Page</a></td>";\r
                        cols+=2;\r
                }\r
                if(startrow+rowsperpage<identitycount)\r
@@ -157,7 +194,7 @@ const std::string PeerTrustPage::GeneratePage(const std::string &method, const s
                                content+="<td></td>";\r
                                cols++;\r
                        }\r
-                       content+="<td colspan=\"2\" align=\"right\"><a href=\"peertrust.htm?startrow="+tempstr+"\">Next Page --></a></td>";\r
+                       content+="<td colspan=\"2\" align=\"right\"><a href=\"peertrust.htm?startrow="+tempstr+"&namesearch="+namesearch+"\">Next Page --></a></td>";\r
                }\r
                content+="</tr>";\r
        }\r