skyway2.sh

 

### skyway1.sh
###
### List ip addresses count
###
### Get hits
###

echo " <html> " > /var/www/usage3.html
echo " <head> " >> /var/www/usage3.html
echo " <META content=text/css http-equiv=Content-Style-Type>" >> /var/www/usage3.html
echo " <LINK href=\"white.css\" rel=\"stylesheet\" type=\"text/css\">" >> /var/www/usage3.html
echo " <title>Skyway Radio Usage Statistics</title>" >> /var/www/usage3.html
echo " </head> " >> /var/www/usage3.html
echo " <body> " >> /var/www/usage3.html
echo " <blockquote><blockquote><font class=grey2> " >> /var/www/usage3.html
echo " <p>&nbsp;</p> " >> /var/www/usage3.html
echo " <h2>Skyway Radio Usage Statistics</h2>" >> /var/www/usage3.html

echo " <p>&nbsp;</p> " >> /var/www/usage3.html
echo "  " >> /var/www/usage3.html

echo " <p>&nbsp;</p> " >> /var/www/usage3.html
echo " <h3>Hits</h3>" >> /var/www/usage3.html

echo "<table cellpadding=10 border=1>  " >> /var/www/usage3.html
echo "<tr> " >> /var/www/usage3.html
   echo "    <th align=left>Date" >> /var/www/usage3.html
   echo "    <th align=left>Total Hits" >> /var/www/usage3.html
   echo "    <th align=left>Distinct Users" >> /var/www/usage3.html

for i in `cut -d" " -f4 /etc/httpd/logs/access_log | cut -d: -f1 | sed "s/\[//g"  | sort | uniq`
do
   echo " " >> /var/www/usage3.html
   x=`grep $i /etc/httpd/logs/access_log | 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/access_log | 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/usage3.html
   echo "    <td>$i " >> /var/www/usage3.html
   echo "    <td align=right>$y " >> /var/www/usage3.html
   echo "    <td align=right>$x " >> /var/www/usage3.html
   echo " " >> /var/www/usage3.html
done
echo "</table>" >> /var/www/usage3.html



###
### Get visitors
###

echo " <p>&nbsp;</p> " 				>> /var/www/usage3.html
echo " <h3>Visitors</h3>" 			>> /var/www/usage3.html
echo " " 					>> /var/www/usage3.html
echo "<table cellpadding=10 border=1>  " 	>> /var/www/usage3.html
echo "<tr> " 					>> /var/www/usage3.html
echo "    <th align=left>Visitor" 		>> /var/www/usage3.html
echo "    <th align=left>Hits" 			>> /var/www/usage3.html


cat /dev/null > /tmp/host3.tmp

for x in `grep -v 192.168.0  /etc/httpd/logs/access_log | grep -v 204.221.210.195  | grep -v 208.42.95.123  | grep -v \/wendy | grep -v \/calendar | cut -d" " -f1 | sort | uniq` 
do


   hst=`host $x  | sed "s/for //g" | grep -v "not found" | cut -d" " -f5 | cut -d. -f2-100 | sed "s/\.$//"` 
   cnt=`grep $x /etc/httpd/logs/access_log | wc -l`
   
   if [ "$hst" = "" ]
   then
       echo "$x+$x $cnt" >> /tmp/host3.tmp
   else
       echo "$hst+$hst $cnt" >> /tmp/host3.tmp
   fi
 

done


sort +1n /tmp/host3.tmp | \
sed "s: :</a><td align=right>:" | \
sed "s:^:<tr><td><a href=\"http\://www.:" | \
sed "s/+/\">/" >> /var/www/usage3.html
   

echo " </table>" >> /var/www/usage3.html

echo "</body>" >> /var/www/usage3.html
echo "</html>" >> /var/www/usage3.html