- st=m_db->Prepare("SELECT Name,PublicKey,MessageTrust,TrustListTrust,tblIdentity.IdentityID FROM tblPeerTrust INNER JOIN tblIdentity ON tblPeerTrust.TargetIdentityID=tblIdentity.IdentityID WHERE tblPeerTrust.IdentityID=? ORDER BY Name COLLATE NOCASE;");\r
+ // get message count posted by this identity\r
+ st=m_db->Prepare("SELECT COUNT(MessageID) FROM tblMessage WHERE IdentityID=?;");\r
+ st.Bind(0,identityid);\r
+ st.Step();\r
+\r
+ if(st.RowReturned())\r
+ {\r
+ std::string messagecountstr="0";\r
+ st.ResultText(0,messagecountstr);\r
+ content+="<tr>";\r
+ content+="<td>Message Count</td>";\r
+ content+="<td>"+messagecountstr;\r
+ content+=" <form name=\"frmdeletemessages\" method=\"POST\">";\r
+ content+="<input type=\"hidden\" name=\"identityid\" value=\""+identityidstr+"\">";\r
+ content+="<input type=\"hidden\" name=\"formaction\" value=\"deletemessages\">";\r
+ content+="<input type=\"submit\" value=\"Delete Messages\">";\r
+ content+="</form>";\r
+ content+="</td>";\r
+ content+="</tr>";\r
+ }\r
+\r
+ content+="</table>";\r
+\r
+\r
+ 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