#!/bin/bash

numnetworks=6
numnetworks=8

vals=(`/sbin/ifconfig -s | tr -s ' ' | cut -d' ' -f1,5,9 | grep -v RX `)
#echo ${vals[@]}
#echo ${#vals[@]}

numvals=`echo " $numnetworks * 3 + 3" | bc -l`
#echo $numvals
if [ ${#vals[@]} -ne $numvals ]
then 
   echo "ERROR Not "$numnetworks" networks available, but "`echo " ${#vals[@]} / 3 - 1 " | bc `"."
   exit
fi

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