Confirm spam updates to db

I find myself querying the SQL db for the subject of
messages in
maia_mail to see where some known FN's or FP's are located
and then
looking them up online to confirm. Sometimes, this is
impossible due to
the amount of mail in ones cache and the inability to locate
the
message.

Can someone tell me which fields get updated and to what
when ham or
spam is confirmed to that I could do a manual UPDATE SQL
statement to
marked them all confirmed. For instance, I run a query that
finds all
the messages marked non-spam by maia with a certain subject
and/or
sender. Once I find the messages I want to confirm, what
updates would I
then need to make to the db to mark them spam so they are
learned as
such when the process script runs later.

-- 
Robert

_______________________________________________
Maia-users mailing list
Maia-usersrenaissoft.com
http://www.renaissoft.com/mailman/listinfo/maia-users

Robert Fitzpatrick wrote:
> I find myself querying the SQL db for the subject of
messages in
> maia_mail to see where some known FN's or FP's are
located and then
> looking them up online to confirm. Sometimes, this is
impossible due to
> the amount of mail in ones cache and the inability to
locate the
> message.
>
> Can someone tell me which fields get updated and to
what when ham or
> spam is confirmed to that I could do a manual UPDATE
SQL statement to
> marked them all confirmed. For instance, I run a query
that finds all
> the messages marked non-spam by maia with a certain
subject and/or
> sender. Once I find the messages I want to confirm,
what updates would I
> then need to make to the db to mark them spam so they
are learned as
> such when the process script runs later.
>
>   
I once had trouble with a customer having too many items in
quarantine 
to be able to show it, and did some manual updates.

UPDATE maia_mail_recipients SET type = 'C' WHERE
maia_mail.id = 
maia_mail_recipients.mail_id AND
maia_mail_recipients.recipient_id = 
'111' AND maia_mail.score > 40 AND
maia_mail_recipients.type = 'S'

This would mark all items in spam quarantine with a score
over 40 as 
Confirmed spam for the user with id 111. You could probably
modify it to 
check for from or envelope_to addresses.


-- 
Erik Weber
_______________________________________________
Maia-users mailing list
Maia-usersrenaissoft.com
http://www.renaissoft.com/mailman/listinfo/maia-users