[Howto] Fix wrong data in the proftpd accounting

Code:
#!/bin/sh

#Shell script to dump the queries needed to update the quotatallies table

# to the proper values

#We are expecting diskuse to be in the same path as we are

#The output can be redirected to a file using the > filename syntax and then

# injected into mysql in the form "mysql -u root -p ispcp < filename



DIR=`dirname $0`



if ! [ -e  $DIR/diskuse ] ; then

        echo "The diskuse script cannot be found, you can get it at:"

        echo " http://www.castaglia.org/proftpd/contrib/diskuse"

        exit 1

fi



#TODO, we should count the space the root of the folder but excluding some dirs

#  (logs,  phptmp,  statistics ..)

#TODO, the queries to delete orphaned entries could be created too, altough

# ispcp should take care of those

#Loop through the domains

for i in `ls -1 /var/www/virtual/` ; do

        GROUP=`ls -l /var/www/virtual/ | grep "\b$i\$" | tr -s ' ' | cut -d' ' -f3`

        DISK=`perl $DIR/diskuse --group $GROUP /var/www/virtual/$i/htdocs/  | cut -d' ' -f2`

        case $DISK in

                ''|*[!0-9]*)

                        echo "#Calculation error for $i";;

                *)

                        echo "REPLACE INTO ispcp.quotatallies (name,quota_type,bytes_in_used) VALUES ('$i','group',$DISK);";;

        esac

done