[Modus] Spam counter on a website?

Lapo Nustrini Wed, 12 Nov 2003 14:16:08 -0800

* 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.

[Modus] Spam counter on a website?

Reply via email to