[Mimedefang] mysql mimedefang

[B. Tolka]

This code checks mysql and checks whether a user account has filtering
enabled or disabled.




sub should_check_for_spam ($)
{

    my($recip) = @_;
    $recip = lc($recip);
    $recip =~ tr/<>//d;
    $dbh= DBI->connect("DBI:mysql:spamassassin:10.9.2.76","get","get");
    $sth = $dbh->prepare("SELECT checkspam FROM userpref WHERE username
= '$recip' && preference= 'rewrite_subject'");
    $sth->execute;
    $sth->bind_columns(\$checkspam);
    $sth->fetchrow_arrayref;
    if ($checkspam eq 0)
    {
    return 0;
    }
    return 1;
    $sth->finish;
    $dbh->disconnect;

}


Bryan Tolka
Network Engineer
---------------------------------------
Robert C. Byrd Health Sciences Center
Morgantown, WV
304-293-4683
btolka at hsc.wvu.edu