* This is the modus mailing list * I've considered doing this also, but have not had an accurate way to do it. The SQLDB only stores the quarantine, so a simple count of your current spam quarantine is:
select count(*) from tblMsgCatalog where msgtype = 2 This counter doesn't change much depending on your expiry, as I keep 7 days worth, I keep around 100k messages. This should match up with what you see in the console. It may be more reasonable to parse out the stats logfile over a period of time instead, although I have not looked into it yet. I am not sure how rebooting or restarting the services effects these numbers. -----Original Message----- From: Lapo Nustrini [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 11:08 To: [EMAIL PROTECTED] Subject: [Modus] Spam counter on a website? * This is the modus mailing list * I'd like to setup a (live) counter on our website, showing how much spam has been stopped. However, I'm not sure what the best way to get the data from the SQL quarantine is. Any suggestions or examples? Thanks, Lapo Nustrini Seanet Corporation 701 Fifth Ave, Suite 6801 Seattle 98104 WA (206) 343 7828 http://www.seanet.com ** To unsubscribe, send an Email to: [EMAIL PROTECTED] with the word "UNSUBSCRIBE" in the body or subject line. ** To unsubscribe, send an Email to: [EMAIL PROTECTED] with the word "UNSUBSCRIBE" in the body or subject line.
