std::vector<std::string> lmt;\r
std::vector<std::string> oldltlt;\r
std::vector<std::string> ltlt;\r
+ std::vector<std::string> oldmtc;\r
+ std::vector<std::string> mtc;\r
+ std::vector<std::string> oldtltc;\r
+ std::vector<std::string> tltc;\r
int localmessagetrust=0;\r
int localtrustlisttrust=0;\r
int identityid;\r
CreateArgArray(queryvars,"localmessagetrust",lmt);\r
CreateArgArray(queryvars,"oldlocaltrustlisttrust",oldltlt);\r
CreateArgArray(queryvars,"localtrustlisttrust",ltlt);\r
+ CreateArgArray(queryvars,"oldmessagetrustcomment",oldmtc);\r
+ CreateArgArray(queryvars,"messagetrustcomment",mtc);\r
+ CreateArgArray(queryvars,"oldtrustlisttrustcomment",oldtltc);\r
+ CreateArgArray(queryvars,"trustlisttrustcomment",tltc);\r
\r
- SQLite3DB::Statement update=m_db->Prepare("UPDATE tblIdentity SET LocalMessageTrust=?, LocalTrustListTrust=? WHERE IdentityID=?;");\r
+ SQLite3DB::Statement update=m_db->Prepare("UPDATE tblIdentity SET LocalMessageTrust=?, LocalTrustListTrust=?, MessageTrustComment=?, TrustListTrustComment=? WHERE IdentityID=?;");\r
\r
for(int i=0; i<identityids.size(); i++)\r
{\r
- if(oldlmt[i]!=lmt[i] || oldltlt[i]!=ltlt[i])\r
+ if(oldlmt[i]!=lmt[i] || oldltlt[i]!=ltlt[i] || oldmtc[i]!=mtc[i] || oldtltc[i]!=tltc[i])\r
{\r
StringFunctions::Convert(lmt[i],localmessagetrust);\r
StringFunctions::Convert(ltlt[i],localtrustlisttrust);\r
{\r
update.Bind(1);\r
}\r
- update.Bind(2,identityid);\r
+ update.Bind(2,mtc[i]);\r
+ update.Bind(3,tltc[i]);\r
+ update.Bind(4,identityid);\r
update.Step();\r
update.Reset();\r
}\r
content+="<table>";\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>Message Comment</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>Trust Comment</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
st.ResultInt(0,identitycount);\r
st.Finalize();\r
\r
- sql="SELECT IdentityID,Name,LocalMessageTrust,PeerMessageTrust,LocalTrustListTrust,PeerTrustListTrust,PublicKey FROM tblIdentity";\r
+ sql="SELECT IdentityID,Name,LocalMessageTrust,PeerMessageTrust,LocalTrustListTrust,PeerTrustListTrust,PublicKey,MessageTrustComment,TrustListTrustComment FROM tblIdentity";\r
if(namesearch!="")\r
{\r
sql+=" WHERE Name LIKE '%' || ? || '%'";\r
std::string peertrustlisttrust;\r
std::string publickey;\r
std::string keypart="";\r
+ std::string messagetrustcomment="";\r
+ std::string trustlisttrustcomment="";\r
\r
StringFunctions::Convert(count,countstr);\r
\r
st.ResultText(4,localtrustlisttrust);\r
st.ResultText(5,peertrustlisttrust);\r
st.ResultText(6,publickey);\r
+ st.ResultText(7,messagetrustcomment);\r
+ st.ResultText(8,trustlisttrustcomment);\r
\r
if(publickey.size()>8)\r
{\r
content+="<td "+GetClassString(localmessagetrust)+">";\r
content+="<input type=\"hidden\" name=\"oldlocalmessagetrust["+countstr+"]\" value=\""+localmessagetrust+"\">";\r
content+="<input type=\"text\" name=\"localmessagetrust["+countstr+"]\" value=\""+localmessagetrust+"\" size=\"2\" maxlength=\"3\"></td>";\r
+ content+="<td "+GetClassString(localmessagetrust)+">";\r
+ content+="<input type=\"hidden\" name=\"oldmessagetrustcomment["+countstr+"]\" value=\""+SanitizeOutput(messagetrustcomment)+"\">";\r
+ content+="<input type=\"text\" name=\"messagetrustcomment["+countstr+"]\" value=\""+SanitizeOutput(messagetrustcomment)+"\" maxlength=\"50\">";\r
+ content+="</td>"; \r
content+="<td "+GetClassString(peermessagetrust)+">";\r
content+=peermessagetrust+"</td>";\r
content+="<td "+GetClassString(localtrustlisttrust)+">";\r
content+="<input type=\"hidden\" name=\"oldlocaltrustlisttrust["+countstr+"]\" value=\""+localtrustlisttrust+"\">";\r
content+="<input type=\"text\" name=\"localtrustlisttrust["+countstr+"]\" value=\""+localtrustlisttrust+"\" size=\"2\" maxlength=\"3\"></td>";\r
+ content+="<td "+GetClassString(localtrustlisttrust)+">";\r
+ content+="<input type=\"hidden\" name=\"oldtrustlisttrustcomment["+countstr+"]\" value=\""+SanitizeOutput(trustlisttrustcomment)+"\">";\r
+ content+="<input type=\"text\" name=\"trustlisttrustcomment["+countstr+"]\" value=\""+SanitizeOutput(trustlisttrustcomment)+"\" maxlength=\"50\">";\r
+ content+="</td>";\r
content+="<td "+GetClassString(peertrustlisttrust)+">";\r
content+=peertrustlisttrust+"</td>";\r
content+="</tr>";\r
if(startrow>0)\r
{\r
StringFunctions::Convert(startrow-rowsperpage,tempstr);\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
+ content+="<td colspan=\"3\" align=\"left\"><a href=\"peertrust.htm?"+BuildQueryString(startrow-rowsperpage,namesearch,sortby,sortorder)+"\"><-- Previous Page</a></td>";\r
+ cols+=3;\r
}\r
if(startrow+rowsperpage<identitycount)\r
{\r
- while(cols<3)\r
+ while(cols<4)\r
{\r
content+="<td></td>";\r
cols++;\r
}\r
- content+="<td colspan=\"2\" align=\"right\"><a href=\"peertrust.htm?"+BuildQueryString(startrow+rowsperpage,namesearch,sortby,sortorder)+"\">Next Page --></a></td>";\r
+ content+="<td colspan=\"3\" align=\"right\"><a href=\"peertrust.htm?"+BuildQueryString(startrow+rowsperpage,namesearch,sortby,sortorder)+"\">Next Page --></a></td>";\r
}\r
content+="</tr>";\r
}\r