Stuart,

> I would like add to the amavisd-new SQL-storage in order to record the
> spam tests that a message hit.  This would be so that I can track how
> often certain rules are hitting.  Has anyone done this and would like to
> share their implementation?

Modify updating of msgs table in sub save_info_final:

    # update message record with additional information
    $conn_h->execute($sql_cl_r->{'upd_msg'},
             $content_type, $quar_type, $q_to, $dsn_sent,
             untaint($spam_level), untaint($m_id), untaint($from),
             untaint($subj), $mail_id);

and the 'upd_msg' clause in %sql_clause, adding another field
to table msgs. The information you want to store is
kept in $msginfo->spam_status

  Mark


_______________________________________________
AMaViS-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/amavis-user
AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/howto/

Reply via email to