#!/bin/bash

numnetworks=6

vals=(`/sbin/ifconfig -s | tr -s ' ' | cut -d' ' -f1,5,9 | grep -v RX `)


for (( i=0 ; i < $numnetworks ; i++ )) 
do 
   query="SELECT fRXErrors, fTXErrors FROM NetworkErrors WHERE fEth="$i" ORDER BY fTime DESC LIMIT 0,1;" 
   errors=( `/usr/bin/mysql -u systemstatus --host=fact01 SystemStatus -s -e "$query"`)
   if [ ${errors[0]} -lt ${vals[$i*3+1]} ]
   then 
      echo "RX errors increased to "${errors[0]} 
   fi
   if [ ${errors[1]} -lt ${vals[$i*3+2]} ]
   then
      echo "TX errors increased to "${errors[0]}
   fi
   query="INSERT NetworkErrors SET fEth="$i", fRXErrors="${vals[$i*3+1]}", fTXErrors="${vals[$i*3+2]}", fTime=Now()"
   /usr/bin/mysql -u systemstatus --host=fact01 SystemStatus -e "$query"
done