* This is the modus mailing list * Can you do a spam counter on a web site if you aren't running extended sql database, and just using the default store?
If so HOW, if anyone is doing it. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lapo Nustrini Sent: Wednesday, November 12, 2003 4:12 PM To: [EMAIL PROTECTED] Subject: [Modus] Spam counter on a website? * This is the modus mailing list * Ok. Sorry for all the messages. I finally figured out how to edit the value manually to >0 (using Enterprise Manager rather than Query analyzer) Thanks for all the quick responses. Lapo On Wednesday, November 12, 2003, at 12:51 PM, John Fix 3rd wrote: > * This is the modus mailing list * > > Don't remove the null option...just set a value of 1 in the Spamcount > field. > > John > >> -----Original Message----- >> From: [EMAIL PROTECTED] >> [mailto:[EMAIL PROTECTED] On Behalf Of Lapo Nustrini >> Sent: Wednesday, November 12, 2003 3:48 PM >> To: [EMAIL PROTECTED] >> Subject: [Modus] Spam counter on a website? >> >> * This is the modus mailing list * >> >> >> The funny thing is that I originally tried: >> Update tblCounter >> set SpamCount = 100 >> >> And I still got a "(0 row(s) affected)" response... >> I even went into the table and edited the field, removing the >> NULL option. >> >> Still no go... >> >> >> Lapo >> >> >> On Wednesday, November 12, 2003, at 12:36 PM, ISOC Network Operations >> wrote: >> >>> * This is the modus mailing list * >>> >>> Hmm that is odd, only thing I can think of is if the field >> Spamcount >>> is empty it might act like that but not sure. >>> >>> Try editing the value for spamcount to 1 then see if you can do the >>> update in QA and get it to update it to 2, if so then I would think >>> the trigger will start working. >>> >>> John >>> >>> -----Original Message----- >>> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On >>> Behalf Of Lapo Nustrini >>> Sent: Wednesday, November 12, 2003 3:33 PM >>> To: [EMAIL PROTECTED] >>> Subject: [Modus] Spam counter on a website? >>> >>> * This is the modus mailing list * >>> >>> Hello John, >>> >>> thanks for the instructions. I just tried implementing them, but I >>> can't get it to work. >>> >>> I setup the new table (tblCounter) >>> Created a new Field (SpamCount, int, Null) And created the >> Trigger on >>> tblMsgCatalog. (If I try to edit the trigger in Query >> Analyzer, I get >>> the following text to edit: >>> >>> ALTER TRIGGER [SpamCounter] ON [dbo].[tblMsgCatalog] >>> FOR INSERT >>> AS >>> Update tblCounter >>> set SpamCount = SpamCount + 1 >>> >>> This appears correct to me, however, nothing is happening. >>> I think there may be something wrong with the table itself, as if I >>> simply run: >>> >>> Update tblCounter >>> set SpamCount = SpamCount + 1 >>> >>> I get a "(0 row(s) affected)" response. >>> >>> Do you have any idea what I may have done wrong? >>> >>> Thanks, >>> >>> Lapo >>> >>> >>> On Wednesday, November 12, 2003, at 11:44 AM, ISOC Network >> Operations >>> wrote: >>> >>>> * This is the modus mailing list * >>>> >>>> Yup, read my other post, that is exactly what I am doing. >>>> >>>> John >>>> >>>> -----Original Message----- >>>> From: [EMAIL PROTECTED] >> [mailto:[EMAIL PROTECTED] On >>>> Behalf Of Lapo Nustrini >>>> Sent: Wednesday, November 12, 2003 2:32 PM >>>> To: [EMAIL PROTECTED] >>>> Subject: [Modus] Spam counter on a website? >>>> >>>> * This is the modus mailing list * >>>> >>>> My initial thought was that it would be simplest to setup >> the counter >>>> in the SQL database itself, and increment it each time a >> message is >>>> quarantined. >>>> A simple query could then be run to check the counter, without >>> actually >>>> counting the number of records. >>>> >>>> This would also show the total number of messages caught, >> rather than >>>> what is currently in the quarantine. >>>> >>>> However, I really don't know much about MS SQL, so there may be a >>>> better idea. >>>> (I also don't know how to accomplish this. Probably >> something to do >>>> with triggers...) >>>> >>>> Thanks, >>>> Lapo >>>> >>>> >>>> On Wednesday, November 12, 2003, at 11:15 AM, Darryl Dunkin wrote: >>>> >>>>> * 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. >>>>> >>>> >>>> >>>> ** >>>> 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. >>> >>> >>> ** >>> 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. > ** 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.
