#awk '/HELO/ {print $6}' $SPAM_MAIL_DIR/* | sed 's/[^0-9.]//g' | sort -u >> $FILE_PATH/$SPAM_FILE

#awk '/HELO/ {print $6}' $SPAM_MAIL_DIR/* | tr -s '([])' ':' | awk -F: '{print $2}' | sort -u >> $FILE_PATH/$SPAM_FILE

#awk '/HELO/ {gsub(/\(|\)|\[|\]/,""); print $6}' $SPAM_MAIL_DIR/* | sort -u >> $FILE_PATH/$SPAM_FILE

#!/bin/sh
# mailuser_stat.sh v 0.2 Kreny 05/19/2004 17:39

DOMAIN='@yourdomain'
SENDER_FILE='/home/user/public_html/log/log/mail_sender.txt'
RECEIVER_FILE='/home/user/public_html/log/log/mail_receiver.txt'
VIRUSE_FILE='/home/user/public_html/log/log/mail_viruse.txt'
LOG_FILE='/var/spool/qmailscan/qmail-queue.log'
QUARANTINE_FILE='/var/spool/qmailscan/quarantine.log'
TODAY=`date`

printf "Statistics for mail sender\n"
awk 'NR==1 {print "Statistic since "$1,$2,$3,$4,$5}' $LOG_FILE > $SENDER_FILE
echo "" >> $SENDER_FILE
awk '/return-path/&&$10~/'$DOMAIN'/ {print gensub(/\"(.*)@.*\",/,"\\1",1,$10)}' $LOG_FILE | sort | uniq -c | sort -nr >> $SENDER_FILE
printf "\n Last Update: $TODAY" >> $SENDER_FILE
printf "Done! \n"

printf "Statistics for mail receiver\n"
awk 'NR==1 {print "Statistic since "$1,$2,$3,$4,$5}' $LOG_FILE > $RECEIVER_FILE
echo "" >> $RECEIVER_FILE
awk '/return-path/&&$13~/'$DOMAIN'/ {print gensub(/\"(.*)'$DOMAIN'\"/,"\\1",1,$13)}' $LOG_FILE | sort | uniq -c | sort -nr >> $RECEIVER_FILE
printf "\n Last Update: $TODAY" >> $RECEIVER_FILE
printf "Done! \n"

# Counting the viruse mail receiver
printf "Statistics for viruse mail receiver\n"
awk 'NR==1 {print "Statistic since "$1,$2,$3,$4,$5,$6}' $QUARANTINE_FILE > $VIRUSE_FILE
echo "" >> $VIRUSE_FILE
awk '{print gensub(/(.*)'$DOMAIN'/,"\\1",1,$8)}' $QUARANTINE_FILE | sort | uniq -c | sort -nr >> $VIRUSE_FILE
printf "\n Last Update: $TODAY" >> $VIRUSE_FILE
printf "Done! \n"

## Send to Non-dalouis user.(Daliy Statistics)

printf "\nSend to Non-$DOMAIN user.(Daliy Statistics)\n" >> $FILE_PATH/$SENDER_FILE
awk '/return-path/&&$10~/'$DOMAIN'/&&$13!~/'$DOMAIN'/ {print ":"$4,$3,$2,$1,":"gensub(/\"(.*)@.*\",/,"\\1",1,$10)}' /var/spool/qmailscan/qmail-queue.log | sort | uniq -c | awk -F: '{print $2":"$1":"$3}' | sort +0r -1 +1rM -2 +2rn -3 +5rn | awk -F: '{array_a[$1 $3]+=$2}END{for(i in array_a){split(i,array_b,"");printf"%s,\t%d\n",i,array_a[i]}}' |sort +0rn -1 +1rM -2 +2rn -3 +5rn |awk -F, '{if($1==date){printf("\t%d\t%s\n",$3,$2)}else{printf("%s\n\t%d\t%s\n",$1,$3,$2);date=$1;array_b=$0}}'>> $FILE_PATH/$SENDER_FILE

# (Monthly Statistics)Send to Non-dalouis user.
printf "\nSend to Non-dalouis user.(Monthly Statistics)\n\n" >> $FILE_PATH/$SENDER_FILE
awk '/return-path/&&$10~/'$DOMAIN'/&&$13!~/'$DOMAIN'/ {print ":"$4,$3,":"gensub(/\"(.*)@.*\",/,"\\1",1,$10)}' /var/spool/qmailscan/qmail-queue.log | sort | uniq -c | awk -F: '{print $2":"$1":"$3}' | sort +0r -1 +1rM -2 +3rn | awk -F: '{array_a[$1", "$3]+=$2}END{for(i in array_a){split(i,array_b,"");printf"%s\t,\t%d\n",i,array_a[i]}}' |sort +0rn -1 +1rM -2 +5rn |awk -F, '{if($1==month){printf("\t%d\t%s\n",$3,$2)}else{printf("%s\n\t%d\t%s\n",$1,$3,$2);month=$1;array_b=$0}}' >> $FILE_PATH/$SENDER_FILE
printf "Done! \n"

# ::::::::::::::
# vpopmail-alias2recipients
# ::::::::::::::
#!/bin/sh
QMAIL=/var/qmail
VPOPMAIL=/home/vpopmail/domains
for i in `ls -l $VPOPMAIL | grep ^d | awk '{print $9}'`
do
cd $VPOPMAIL/$i
ls -l .qmail-*| grep -v .qmail-default | tr -s " " | awk '{print $9}' | awk -F- '{print $2"@localhost"}' | sed -e 's/localhost/'$i'/' | sort -u >> $QMAIL/users/recipients
done
# ::::::::::::::
# vpopmail-users2recipients
# ::::::::::::::
#!/bin/sh
LANG=C
QMAIL=/var/qmail
VPOPMAIL=/home/vpopmail/domains
for i in `ls -l $VPOPMAIL | grep ^d | awk '{print $9}'`
do
cd $VPOPMAIL/$i
ls -l | grep ^d | awk '{print $9"@localhost"}' | sed -e 's/localhost/'$i'/' | sort -u >> $QMAIL/users/recipients
done