#!/bin/sh

. /etc/alternc/local.sh
if [ -z "$MYSQL_HOST" ]
then
    MYSQL_HOST="localhost"
fi

function rawstats {
    read FOLD DOM
    while [ "$DOM" ]
    do
	grep " $DOM$" /var/log/apache/access.log.1 >>"$FOLD/$DOM.log"
	read FOLD DOM
    done
}

mysql -h"$MYSQL_HOST" -p"$MYSQL_PASS" -u"$MYSQL_USER" "$MYSQL_DATABASE" -B -e "SELECT folder,hostname FROM stats2" |grep -v "^folder" | rawstats