* This is the modus mailing list * Easy:
Create a new table in the database (tblCounter) with a field called SpamCount type (int). This will contain the NUMBER of spams quarantined. Then create a Trigger on the tblMsgCatalog table as follows CREATE TRIGGER [SpamCounter] ON [dbo].[tblMsgCatalog] FOR INSERT AS Update tblCounter set SpamCount = SpamCount + 1 what this does is simple, everytime a new spam is inserted into the quarantine, the value of spamcount in the tblCounter is updated by one. This gives you a RealTime count of all the spam you have stopped. Just query the spamcount value from your web page. My spam count value is 43266923 since the beginning of Modus. John -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gene DuCharme Sent: Wednesday, November 12, 2003 2:11 PM To: [EMAIL PROTECTED] Subject: [Modus] Spam counter on a website? * This is the modus mailing list * cool idea, me too. Thanks --------------------------------------------------- Gene DuCharme SysAdmin Inland Northwest Internet (inwi.net) 509-935-8923 USA Online Central (usaoc.com) 877-GO-USAOC 401 S. Park St. Chewelah, Wa. 99109 *****E-mail Certified Virus Free by ModusMail****** ************* http://www.vircom.com ************* --------------------------------------------------- -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Lapo Nustrini Sent: Wednesday, November 12, 2003 11:08 AM 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. ** To unsubscribe, send an Email to: [EMAIL PROTECTED] with the word "UNSUBSCRIBE" in the body or subject line.
