mysqlexim

#!/bin/bash

connectmysql ()
{
    mysql -h 192.168.0.143 -u eximstats eximstats -e "$@"
}

tail -F /var/share/eximlog/*.trade.su | sed 's/ \*\* / \#\# /g' | while read string; do
case $(echo $string | awk '{print $8}') in
    "<=" )
        date=$(date -d "$(echo $string | awk '{print $1" "$2" "$3}')" +%s)
        id=$(echo $string | awk '{print $7}')
        theme=$(echo $string | sed -r 's/(^.*T=\"|\" from.*$)//g')
        from=$(echo $string | awk '{print $(NF-2)}')
        for=$(echo $string | awk '{print $NF}')
        host=$(echo $string | awk '{print $4}')
        domain=$(echo $for | awk -F "@" '{print $2}')
        connectmysql "INSERT INTO eximstats (id, host, domain, tsent, sender, recipient, theme, status) VALUES ('$id', '$host', '$domain', '$date', '$from', '$for', '$theme','sent')"
        echo "$date $id $theme $from $for"
    ;;

    "=>" )
        date=$(date -d "$(echo $string | awk '{print $1" "$2" "$3}')" +%s)
        id=$(echo $string | awk '{print $7}')
        connectmysql "UPDATE eximstats SET status='recieved', tansw='$date' WHERE id='$id'"
        echo "$date $id"
        ;;

    "##" )
        date=$(date -d "$(echo $string | awk '{print $1" "$2" "$3}')" +%s)
        id=$(echo $string | awk '{print $7}')
        spam=$(echo $string | awk -F "##" '{print $2}' | sed 's/^.*T=//g')
        connectmysql "UPDATE eximstats SET tansw='$date', status='error', spam='$spam' WHERE id='$id'"
        echo "$date $id $spam"
    ;;
    esac
done