#!/bin/sh

if [ "$SENDER" = "<>" ]
then
    exit 0
fi

vmail_sql_user='vmailprovider'
vmail_sql_pass=`grep SQL= /etc/.vmailpass | sed "s/SQL=//g"`

SIGNATUREFILE="/var/tmp/.signature.$$"

mysql -u $vmail_sql_user -p${vmail_sql_pass} -D vmaildata --skip-column-names --batch --raw -e "select signature from users where email like '$SENDER';" > $SIGNATUREFILE 

if [ -s "$SIGNATUREFILE" ]
then 
    if ! grep -q -e '^-- ' $EMAIL 2>/dev/null
    then
        /usr/local/postfix/altermime --input=$EMAIL \
           --disclaimer=$SIGNATUREFILE \
           --disclaimer-html=$SIGNATUREFILE \
           --remove=".*\.vcf" 
    fi 
fi

rm -f $SIGNATUREFILE  

exit 0