#!/bin/bash
### skyway1.sh
###
### List ip addresses count
###
### Get hits
###
echo "Enter log file: "
read logname
echo " <html> " > /var/www/usage2.html
echo " <head> " >> /var/www/usage2.html
echo " <META content=text/css http-equiv=Content-Style-Type>" >> /var/www/usage2.html
echo " <LINK href=\"white.css\" rel=\"stylesheet\" type=\"text/css\">" >> /var/www/usage2.html
echo " <title>Skyway Radio Usage Statistics</title>" >> /var/www/usage2.html
echo " </head> " >> /var/www/usage2.html
echo " <body> " >> /var/www/usage2.html
echo " <blockquote><blockquote><font class=grey2> " >> /var/www/usage2.html
echo " <p> </p> " >> /var/www/usage2.html
echo " <h2>Skyway Radio Usage Statistics</h2>" >> /var/www/usage2.html
echo " <p> </p> " >> /var/www/usage2.html
echo " " >> /var/www/usage2.html
echo " <p> </p> " >> /var/www/usage2.html
echo " <h3>Hits</h3>" >> /var/www/usage2.html
echo "<table cellpadding=10 border=1> " >> /var/www/usage2.html
echo "<tr> " >> /var/www/usage2.html
echo " <th align=left>Date" >> /var/www/usage2.html
echo " <th align=left>Total Hits" >> /var/www/usage2.html
echo " <th align=left>Distinct Users" >> /var/www/usage2.html
for i in `cut -d" " -f4 /etc/httpd/logs/$logname | cut -d: -f1 | sed "s/\[//g" | sort | uniq`
do
echo " " >> /var/www/usage2.html
x=`grep $i /etc/httpd/logs/$logname | grep -v 204.221.210.195 | grep -v 208.42.95.123 | grep -v 192.168.0 | grep -v \/wendy | grep -v \/calendar | cut -d" " -f1 | sort | uniq | wc -l`
y=`grep $i /etc/httpd/logs/$logname | grep -v 204.221.210.195 | grep -v 208.42.95.123 | grep -v 192.168.0 | grep -v \/wendy | grep -v \/calendar | cut -d" " -f1 | wc -l`
echo "<tr> " >> /var/www/usage2.html
echo " <td>$i " >> /var/www/usage2.html
echo " <td align=right>$y " >> /var/www/usage2.html
echo " <td align=right>$x " >> /var/www/usage2.html
echo " " >> /var/www/usage2.html
done
echo "</table>" >> /var/www/usage2.html
###
### Get visitors
###
echo " <p> </p> " >> /var/www/usage2.html
echo " <h3>Visitors</h3>" >> /var/www/usage2.html
echo " " >> /var/www/usage2.html
echo "<table cellpadding=10 border=1> " >> /var/www/usage2.html
echo "<tr> " >> /var/www/usage2.html
echo " <th align=left>Visitor" >> /var/www/usage2.html
echo " <th align=left>Hits" >> /var/www/usage2.html
for x in `grep -v 192.168.0 /etc/httpd/logs/$logname | grep -v 204.221.210.195 | grep -v 208.42.95.123 | grep -v \/wendy | grep -v \/calendar | cut -d" " -f1 | sort | uniq`
do
a=""
a=`host $x | grep -v "not found" | grep -v "connection timed out" | grep -v "is an alias" | cut -d" " -f5 | cut -d. -f2-100 | sed "s/\.$//"`
b=`grep $x /etc/httpd/logs/$logname | wc -l`
echo "<tr> " >> /var/www/usage2.html
if [ "$a" = "" ]
then
echo "<td>$x " >> /var/www/usage2.html
echo "<td align=right> $b" >> /var/www/usage2.html
else
echo "<td><a href=\"http://www.${a}\">$a</a>" >> /var/www/usage2.html
echo "<td align=right> $b" >> /var/www/usage2.html
fi
done
echo " </table>" >> /var/www/usage2.html
echo "</body>" >> /var/www/usage2.html
echo "</html>" >> /var/www/usage2.html
echo "Output written to: /var/www/usage2.html"