#!/bin/bash
# Simple purge script for dspam and the mysql driver
# by Oden Eriksson 2003

CONFIG_FILE="/etc/mail/dspam/mysql.data"

[ -s ${CONFIG_FILE} ] || exit 0

if [ `cat ${CONFIG_FILE}|/usr/bin/head -1` = "_UNCONFIGURED_" ]; then exit 0; fi

# This is not failsafe...
MYSQL_HOSTNAME=`/usr/bin/head -1 ${CONFIG_FILE}`
MYSQL_PORT=`/usr/bin/head -2 ${CONFIG_FILE}|/usr/bin/tail -1`
MYSQL_USERNAME=`/usr/bin/head -3 ${CONFIG_FILE}|/usr/bin/tail -1`
MYSQL_PASSWORD=`/usr/bin/head -4 ${CONFIG_FILE}|/usr/bin/tail -1`
MYSQL_DATABASE=`/usr/bin/tail -1 ${CONFIG_FILE}`

/usr/bin/mysql \
    --user=${MYSQL_USERNAME} \
    --password=${MYSQL_PASSWORD} \
    --host=${MYSQL_HOSTNAME} \
    --port=${MYSQL_PORT} \
    ${MYSQL_DATABASE} << EOF
delete from dspam_token_data 
  where (innocent_hits*2) + spam_hits < 5
  and current_date()-last_hit > 60;

delete from dspam_token_data
  where innocent_hits = 1
  and current_date()-last_hit > 30;
EOF
