#!/bin/sh while read IPADDR; do AUTHORIZED=`/usr/local/bin/sqlite3 /var/db/squid/authIP.db "SELECT COUNT(ip) from users where ip=\"$IPADDR\""` if [ $AUTHORIZED -gt 0 ]; then echo "OK" else echo "ERR" fi done