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

#
# Strip database ...
#
del_IP() {
	echo "Deleting IP: $1"
	$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 "Removing junk IP: $b "
		del_IP "$b"
	fi
done