#!/bin/bash
if [ "$1" == 'debug' ]; then set -x; shift; fi
#-------------------------
REALPATH=`realpath $0`
WHERE=`dirname $REALPATH`
ME=`basename $REALPATH`
cd $WHERE
. ../../system.conf
. ../../common.conf
. ../../common.bashlib
#-------------------------
. WatchWB.conf

#
# Strip junk from database ...
#
del_IP() {
	echo "Deleting IP: $1 from $DB"
	$SQL "delete from $TABLE where IP='$1';"
}

echo "Cleaning-up database $WHERE/$DB ... please wait ..."

#
# Remove junk IP addresses that break the load process badly
#
BANDITS=`$SQL "select IP from $TABLE;"`

for b in `echo $BANDITS`
do
	validate_IP $b
	if [ $? -ne 0 ]
	then 
		echo "Junk IP: $b "
		del_IP "$b"
	fi
done