#! /bin/bash
# Afrihost - quick block based on wordfence
cat  /usr/local/afri*/configs/wordfense_tables | xargs -i  find  /var/lib/mysql/  -name \*{}\* | while read pwffile ;  do echo $pwffile |  awk -F "/"  '{print $5,$NF}' | sed 's/.MYI//' | while read pdb ptable ; do echo "mysql -e \"use $pdb ; select * from $ptable\"" ; done  ; done   | bash  | grep `date +"%Y"-"%m"-"%d"`|ipgrep | sort | uniq |ipprocheck | /usr/local/afribin/trustedSPs  | awk '{print $1}' | grep .  | geoip | grep "^[A-Z][A-Z]\ " | egrep -v 'ZA|127.0.0|AU|ZW|BW|MZ|LS|ID|NA|ZM|CM|SZ|KE|IN|AO|IN|NA' | ipgrep | xargs -i ipset add wordfence_threats_local   {}