#!/bin/bash

mysql -u root --password=PrisneTajneHeslo --database dbispconfig --execute 'select email,quota from mail_user' > /root/docasna
tail -n +2 /root/docasna > /root/docasna1

while read radek; do
  jmeno=`echo $radek |awk '{print $1}'`
  quota=`echo $radek |awk '{print $2}'`
  cesta=`echo $radek |awk -F '@' '{print $1}'`

  if [ -f /var/vmail/ceska-trebova.cz/$cesta/.quotausage ]; then
      zabrano=`cat "/var/vmail/ceska-trebova.cz/"$cesta"/.quotausage" |tail -n +2 |head -n 1`
      echo 'Uzivatel' $jmeno 'ma v mailu zabrano: ' `expr $zabrano / 1048576` " z " `expr $quota / 1048576` "MB." > /root/mailik
      echo "Toto je pouze informativni mail generovany mail-serverem MU Ceska Trebova." >> /root/mailik
      echo "" >> /root/mailik
      echo "Zdenek Doubrava" >> /root/mailik
      mail -s "Statistika zabraneho mista v mailu." $jmeno < /root/mailik
  fi

done < docasna1

rm /root/docasna
rm /root/docasna1
rm /root/mailik